CMEMPSCHD

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CES-COMPANY
Element: Company Hr
Numeric 4
CES-EMPLOYEE
Element: Employee
Numeric 9
CES-CONTRACT-NBR
Element: Seq Number
Numeric 6
CES-WORK-SCHED
Element: Code
Alpha 10
CES-DATE
Element: Cw Date
Numeric 8 (yyyymmdd)
CES-DAY-CODE
Element: Day Code
Alpha 10
CES-PAY-CODE
Element: Pay Code
Alpha 4
CES-NEW-DAY-CODE
Element: Day Code
Alpha 10
CES-STATUS
Element: Status Cd
Alpha 1

C = Current
P = Pending
D = Deleted
CES-CREATE-DATE
Element: Date Stamp
Numeric 8 (yyyymmdd)
CES-CREATE-TIME
Element: Time Stamp
Numeric 6 (hhmmss)
CES-CREATE-USER-ID
Element: User
Alpha 10 (Lower Case)
CES-DATE-STAMP
Element: Date Stamp
Numeric 8 (yyyymmdd)
CES-TIME-STAMP
Element: Time Stamp
Numeric 6 (hhmmss)
CES-USER-ID
Element: User
Alpha 10 (Lower Case)


CMEMPSCHD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CESSET1 COMPANY
EMPLOYEE
CONTRACT-NBR
WORK-SCHED
DATE
CESSET2 COMPANY
EMPLOYEE
CONTRACT-NBR
WORK-SCHED
DATE
Subset
WhereSTATUS !="C"


File created: Thu Jun 09 11:12:09 2016

Home
Contact Us



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