CMDISTRIB

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


CMDISTRIB FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CDBSET1 COMPANY
EMPLOYEE
CONTRACT-NBR*
SEGMENT-NBR
PAY-CODE
GL-EFFECT-DATE*
GL-SEQ-NBR*
CDBSET2 COMPANY
EMPLOYEE
CONTRACT-NBR
SEGMENT-NBR
PAY-CODE
GL-EFFECT-DATE
GL-SEQ-NBR


CMDISTRIB FILE RELATIONS


ONE TO ONE RELATIONS

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


CMDISTRIB FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Pay Code PRPAYCODE Required
CDB-COMPANY->PCD-COMPANY
CDB-PAY-CODE->PCD-PAY-CODE
  PCD-PROCESS-LEVEL
  PCD-JOB-CODE

File created: Wed Jun 08 20:48:30 2016

Home
Contact Us



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