CMPAYCYC

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
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: Wed Jun 08 20:48:30 2016

Home
Contact Us



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