CMPAYCYC

UPDATED BY
BN150 PR521 EXI2.1 EXI4.1 LP130 PR128
PR131 PR132 PR134 PR135 PR136 PR137
PR189 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
CYC-COMPANY
Element: Hr Company		Numeric 4
CYC-CONTRACT-YEAR
Element: Cw Contract Yr		Numeric 4
CYC-WORK-SCHED
Element: Code		Alpha 10
CYC-PAY-START-DATE
Element: Pay Start Date		Numeric 8 (yyyymmdd)
CYC-PAY-END-DATE
Element: Pay End Date		Numeric 8 (yyyymmdd)
CYC-PAY-CYCLES
Element: Cw Pay Cycles		Numeric 3
CYC-CREATE-DATE
Element: Date Stamp		Numeric 8 (yyyymmdd)
CYC-CREATE-TIME
Element: Time Stamp		Numeric 6 (hhmmss)
CYC-CREATE-USER-ID
Element: User		Alpha 10 (Lower Case)
CYC-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
CYC-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
CYC-USER-ID
Element: User		Alpha 10 (Lower Case)


CMPAYCYC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CYCSET1 COMPANY
CONTRACT-YEAR
WORK-SCHED
PAY-START-DATE
...
BN150 PR521
EXI2.1 EXI4.1
LP130 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 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
CYCSET2 COMPANY
CONTRACT-YEAR*
WORK-SCHED
PAY-START-DATE*


CMPAYCYC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
CYC-COMPANY->PRS-COMPANY (PRSSET1)
Spaces->PRS-PROCESS-LEVEL


CMPAYCYC FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Cmcontrule CMCONTRULE
CYC-COMPANY->CRU-COMPANY
Spaces->CRU-CONTRACT-GROUP
  CRU-EFFECT-DATE
Hrwrkschd HRWRKSCHD
CYC-COMPANY->WSC-COMPANY
CYC-WORK-SCHED->WSC-WORK-SCHED
CYC-CONTRACT-YEAR->WSC-CONTRACT-YEAR
  WSC-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.