CWASSIGN

REFERENCED BY
BN305 HR11.1 HR11.2 HR11.4 HR28.1 HR511
LT101 LT111 ZH510 PA02.1 PA100 PA102
PA115 PA13.1 PA13.2 PA502 PA513 PA52.1
PA52.3 PA52.4 PA52.5 PR110 PR113 PR12.6
PR120 PR13.1 PR13.5 PR13.6 PR13.8 PR13.9
PR30.2 PR512


UPDATED BY
BN150 PR521 EXI2.1 EXI4.1 LP130 PR128
PR131 PR132 PR134 PR135 PR136 PR137
PR189 PR20.4 PR29.1 PR32.1 PR32.2 PR33.1
PR33.2 PR33.3 PR35.1 PR35.2 PR35.3 PR35.4
PR35.5 PR35.6 PR35.8 PR35.9 PR36.1 PR36.4
PR37.1 PR45.1 PR529 PR530 PR560 PR582
PR80.1 PR80.4 PR82.1 UK102 TA147

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CWA-COMPANY
Element: Company Hr		Numeric 4
CWA-EMPLOYEE
Element: Employee		Numeric 9
CWA-CONTRACT-YEAR
Element: Cw Contract Yr		Numeric 4
CWA-ASG-PAY-CODE
Element: Asg Pay Code		Alpha 4
CWA-ASG-EFFECT-DTE
Element: Effect Date		Numeric 8 (yyyymmdd)
CWA-ASG-END-DATE
Element: End Date		Numeric 8 (yyyymmdd)
CWA-PRORATED-AMT
Element: Cw Prorated Am		Signed 18.6
CWA-PRORATED-UNITS
Element: Cw Prorate Unt		Signed 18.6
CWA-PCD-SEQ-NBR
Element: Pcd Seq Nbr		Numeric 8
CWA-ASG-CALC-TYPE
Element: Cw Asg Calc Tp		Numeric 1

1 = Annual Amount
2 = Pay Period
3 = Percent of Current Earnings
4 = Daily Rate
5 = Hourly
CWA-AMT-PCT
Element: Cw Amt Pct		Signed 18.6
CWA-POSITION
Element: Position		Alpha 12
CWA-CHECK-GRP
Element: Check Grp		Alpha 1
CWA-PROCESS-GRP
Element: Process Grp		Alpha 1
CWA-PAY-CYCLE
Element: Pay Cycle		Alpha 1 Occurs 9 Times

X
CWA-TAX-FREQ-OVER
Element: Tax Freq Over		Numeric 3

001 = Weekly
002 = Biweekly
003 = Semi-monthly
004 = Monthly
005 = Daily
006 = Quarterly
007 = Semi-annually
008 = Annually
009 = 9 Month Accademic Monthly
010 = 10 Month Academic Monthly
CWA-ROLL-OVER-FLAG
Element: Cw Roll Ovr Fl		Numeric 1

1 = No
2 = Yes
CWA-DATE-OVER-FLG
Element: Cw Dte Ovr Flg		Numeric 1

1 = No
2 = Yes
CWA-PAY-PER-AMT
Element: Cw Pay Per Amt		Signed 18.6
CWA-YTD-PAID-WAGES
Element: Ytd Paid Wages		Signed 18.6
CWA-PAID-WAGE-BAL
Element: Paid Wage Bal		Signed 18.6
CWA-USER-ALPHA-1
Element: Cw User Alpha		Alpha 20 (Lower Case)
CWA-USER-ALPHA-2
Element: Cw User Alpha		Alpha 20 (Lower Case)
CWA-USER-ALPHA-3
Element: Cw User Alpha		Alpha 20 (Lower Case)
CWA-USER-ALPHA-4
Element: Cw User Alpha		Alpha 20 (Lower Case)
CWA-USER-ALPHA-5
Element: Cw User Alpha		Alpha 20 (Lower Case)
CWA-USER-ALPHA-6
Element: Cw User Alpha		Alpha 20 (Lower Case)
CWA-USER-ALPHA-7
Element: Cw User Alpha		Alpha 20 (Lower Case)
CWA-USER-ALPHA-8
Element: Cw User Alpha		Alpha 20 (Lower Case)
CWA-USER-ALPHA-9
Element: Cw User Alpha		Alpha 20 (Lower Case)
CWA-USER-ALPHA-10
Element: Cw User Alpha		Alpha 20 (Lower Case)
CWA-USER-ALPHA-11
Element: Cw User Alpha		Alpha 20 (Lower Case)
CWA-USER-ALPHA-12
Element: Cw User Alpha		Alpha 20 (Lower Case)
CWA-USER-NUM-1
Element: Cw Amount		Signed 18.6
CWA-USER-NUM-2
Element: Cw Amount		Signed 18.6
CWA-USER-NUM-3
Element: Cw Amount		Signed 18.6
CWA-USER-NUM-4
Element: Cw Amount		Signed 18.6
CWA-USER-NUM-5
Element: Cw Amount		Signed 18.6
CWA-USER-NUM-6
Element: Cw Amount		Signed 18.6
CWA-USER-NUM-7
Element: Cw Amount		Signed 18.6
CWA-USER-NUM-8
Element: Cw Amount		Signed 18.6
CWA-USER-NUM-9
Element: Cw Amount		Signed 18.6
CWA-USER-NUM-10
Element: Cw Amount		Signed 18.6
CWA-USER-NUM-11
Element: Cw Amount		Signed 18.6
CWA-USER-NUM-12
Element: Cw Amount		Signed 18.6
CWA-USER-DATE-1
Element: Cw Date		Numeric 8 (yyyymmdd)
CWA-USER-DATE-2
Element: Cw Date		Numeric 8 (yyyymmdd)
CWA-USER-DATE-3
Element: Cw Date		Numeric 8 (yyyymmdd)
CWA-USER-DATE-4
Element: Cw Date		Numeric 8 (yyyymmdd)
CWA-USER-DATE-5
Element: Cw Date		Numeric 8 (yyyymmdd)
CWA-USER-DATE-6
Element: Cw Date		Numeric 8 (yyyymmdd)
CWA-USER-DATE-7
Element: Cw Date		Numeric 8 (yyyymmdd)
CWA-USER-DATE-8
Element: Cw Date		Numeric 8 (yyyymmdd)
CWA-USER-DATE-9
Element: Cw Date		Numeric 8 (yyyymmdd)
CWA-USER-DATE-10
Element: Cw Date		Numeric 8 (yyyymmdd)
CWA-USER-DATE-11
Element: Cw Date		Numeric 8 (yyyymmdd)
CWA-USER-DATE-12
Element: Cw Date		Numeric 8 (yyyymmdd)
CWA-CLOSE-DATE
Element: Close Date		Numeric 8 (yyyymmdd)
CWA-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
CWA-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
CWA-USER-ID
Element: User		Alpha 10 (Lower Case)
CWA-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
CWA-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
CWA-CREATE-USER-ID
Element: User		Alpha 10 (Lower Case)
CWA-FULL-AMT
Element: Cw Full Amt		Signed 18.6
CWA-FULL-UNITS
Element: Cw Full Units		Signed 18.6
CWA-PAY-CYCLES
Element: Cw Pay Cycles		Numeric 3
CWA-BEN-ELIG-FLAG
Element: Ben Elig Flag		Numeric 1

1 = No
2 = Yes
CWA-PAY-CHG-IND
Element: Pay Chg Ind		Numeric 1

1 = No
2 = Yes
CWA-WORK-SCHED
Element: Work Sched		Alpha 10
CWA-STOP-DT-OVR
Element: Override Flg		Numeric 1

1 = No
2 = Yes
CWA-PAY-CYC-OVR
Element: Override Flg		Numeric 1

1 = No
2 = Yes
CWA-PAYOUT
Element: Assign Payout		Numeric 1

0 = No
1 = Yes
CWA-FTE
Element: Fte		Signed 11.6
CWA-HOURS
Element: Hours		Signed 7.2
CWA-YTD-HOURS
Element: Ytd Paid Hours		Signed 18.6


CWASSIGN FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CWASET1 COMPANY
EMPLOYEE
CONTRACT-YEAR*
POSITION
ASG-EFFECT-DTE*
PCD-SEQ-NBR
...
BN150 BN305
HR11.1 HR11.2
HR11.4 HR28.1
HR511 LT101
LT111 PR521
ZH510 EXI2.1
EXI4.1 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
CWASET2 COMPANY
EMPLOYEE
CONTRACT-YEAR
POSITION
ASG-EFFECT-DTE
PCD-SEQ-NBR
CWASET3 COMPANY
CONTRACT-YEAR*
EMPLOYEE
POSITION
ASG-EFFECT-DTE*
PCD-SEQ-NBR


CWASSIGN FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
CWA-COMPANY->PRS-COMPANY (PRSSET1)
Spaces->PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
CWA-COMPANY->EMP-COMPANY
CWA-EMPLOYEE->EMP-EMPLOYEE
Paemployee PAEMPLOYEE Required
CWA-COMPANY->PEM-COMPANY
CWA-EMPLOYEE->PEM-EMPLOYEE
Work Schedule HRWRKSCHD Required
CWA-COMPANY->WSC-COMPANY
CWA-WORK-SCHED->WSC-WORK-SCHED
CWA-CONTRACT-YEAR->WSC-CONTRACT-YEAR
Zeroes->WSC-EFFECT-DATE


CWASSIGN FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Emp Contract CWCONTRACT
CWA-COMPANY->CCT-COMPANY
CWA-EMPLOYEE->CCT-EMPLOYEE
CWA-CONTRACT-YEAR->CCT-CONTRACT-YEAR
CWA-POSITION->CCT-POSITION
  CCT-CONT-SEQ-NBR
Emp Position PAEMPPOS
CWA-COMPANY->PEP-COMPANY
CWA-EMPLOYEE->PEP-EMPLOYEE
CWA-POSITION->PEP-POSITION
CWA-ASG-EFFECT-DTE->PEP-EFFECT-DATE
  PEP-POS-LEVEL
Emp Trans CWEMPTRANS Delete Cascades
CWA-COMPANY->CCE-COMPANY
CWA-EMPLOYEE->CCE-EMPLOYEE
CWA-CONTRACT-YEAR->CCE-CONTRACT-YEAR
CWA-POSITION->CCE-POSITION
  CCE-CONT-SEQ-NBR
  CCE-TRANS-SEQ-NBR
Pay Code PRPAYCODE
CWA-COMPANY->PCD-COMPANY
CWA-ASG-PAY-CODE->PCD-PAY-CODE
  PCD-PROCESS-LEVEL
  PCD-JOB-CODE
Position PAPOSITION
CWA-COMPANY->POS-COMPANY
CWA-POSITION->POS-POSITION
  POS-EFFECT-DATE

File created: Thu Jun 09 02:12:40 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.