CWDISTRIB

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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CWD-COMPANY
Element: Company Hr		Numeric 4
CWD-EMPLOYEE
Element: Employee		Numeric 9
CWD-CONTRACT-YEAR
Element: Cw Contract Yr		Numeric 4
CWD-POSITION
Element: Position		Alpha 12
CWD-CONT-SEQ-NBR
Element: Cw Cont Seq No		Numeric 12
CWD-PAY-CODE
Element: Pay Code		Alpha 4
CWD-GL-EFFECT-DATE
Element: Cw Effect Date		Numeric 8 (yyyymmdd)
CWD-GL-SEQ-NBR
Element: Cw Gl Seq Nbr		Numeric 4
CWD-PCD-SEQ-NBR
Element: Pcd Seq Nbr		Numeric 8
CWD-DIST-COMPANY
Element: Company		Numeric 4
CWD-DST-ACCT-UNIT
Element: Acct Unit		Alpha 15
CWD-DST-ACCOUNT
Element: Account		Numeric 6
CWD-DST-SUB-ACCT
Element: Sub Acct		Numeric 4
CWD-ACTIVITY
Element: Activity		Alpha 15
CWD-ACCT-CATEGORY
Element: Acct Category		Alpha 5
CWD-PERCENT
Element: Percent		Signed 7.3
CWD-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
CWD-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
CWD-USER-ID
Element: User		Alpha 10 (Lower Case)
CWD-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
CWD-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
CWD-CREATE-USER-ID
Element: User		Alpha 10 (Lower Case)
CWD-FTE
Element: Fte		Signed 11.6


CWDISTRIB FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CWDSET1 COMPANY
EMPLOYEE
CONTRACT-YEAR*
POSITION
CONT-SEQ-NBR*
PAY-CODE
GL-EFFECT-DATE*
GL-SEQ-NBR*
...
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
CWDSET2 COMPANY
EMPLOYEE
CONTRACT-YEAR
POSITION
CONT-SEQ-NBR
PAY-CODE
GL-EFFECT-DATE
GL-SEQ-NBR
CWDSET3 COMPANY
CONTRACT-YEAR*
EMPLOYEE
POSITION
CONT-SEQ-NBR*
PAY-CODE
GL-EFFECT-DATE*
GL-SEQ-NBR*


CWDISTRIB FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Acct Category ACACCTCAT Required
When (CWD-ACCT-CATEGORY !=Spaces )
CWD-ACCT-CATEGORY->AAX-ACCT-CATEGORY
Activity ACACTIVITY Required
When (CWD-ACTIVITY !=Spaces )
CWD-ACTIVITY->ACV-ACTIVITY
Company PRSYSTEM Required
CWD-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Dist Account GLMASTER Required
CWD-COMPANY->GLM-COMPANY
CWD-DST-ACCT-UNIT->GLM-ACCT-UNIT
CWD-DST-ACCOUNT->GLM-ACCOUNT
CWD-DST-SUB-ACCT->GLM-SUB-ACCOUNT
Employee EMPLOYEE Required
CWD-COMPANY->EMP-COMPANY
CWD-EMPLOYEE->EMP-EMPLOYEE
Paemployee PAEMPLOYEE Required
CWD-COMPANY->PEM-COMPANY
CWD-EMPLOYEE->PEM-EMPLOYEE


CWDISTRIB FILE RELATIONS


ONE TO MANY RELATIONS

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

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

Home
Contact Us



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