FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
TED-COMPANY Element: Company Hr	Numeric 4
TED-EMPLOYEE Element: Employee	Numeric 9 Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.
TED-PLAN-NAME Element: Plan Name	Alpha 10 This field contains the plan name.
TED-TR-DATE Element: Tr Date	Numeric 8 (yyyymmdd)
TED-TIME-SEQ Element: Time Seq	Numeric 12
TED-OS-TIME-SEQ Element: Os Time Seq	Numeric 12
TED-ATTEND-CODE Element: Attend Code	Alpha 2 A user-defined alphanumeric code that represents a reason for an employee's absence or hours worked. Examples of attendance codes are, sick, vacation, overtime, on the job injury, snow day, tardy, left early, and so on. Validated in the Attendance Code file.
TED-PCD-SEQ-NBR Element: Pcd Seq Nbr	Numeric 4
TED-HOURS Element: Hours	Signed 7.2 Contains the hours.
TED-CALC-STATUS Element: Calc Status	Alpha 1 1 = Ready for Calculation 2 = Calculation Completed 3 = Transferred to Time Records 4 = Ready for Deletion 5 = Deletion Completed
TED-AMOUNT Element: Amount	Currency 15.2 This is the amounts by period for the specified record.
TED-XFER-DATE Element: Xfer Date	Numeric 8 (yyyymmdd)
TED-XFER-AMOUNT Element: Xfer Amount	Signed 7.2
TED-OS-AMOUNT Element: Os Amount	Signed 7.2
TED-XFER-OS-AMOUNT Element: Xfer Os Amount	Signed 7.2
TED-HRS-TYPE Element: Hrs Type	Alpha 1 H = Hours D = Days W = Weeks M = Months
TED-EXCL-CODE Element: Excl Code	Alpha 2
TED-PAY-CODE Element: Pay Code	Alpha 4 Contains the pay code. A pay code is a user-defined code that identifies a kind of pay.
TED-XFER-PAY-CODE Element: Xfer Pay Code	Alpha 4
TED-RATE-OS-RULE Element: Rate Os Rule	Alpha 1
TED-RATE-OS-PCD Element: Rate Os Pcd	Alpha 4
TED-XFER-RT-OS-PCD Element: Xfer Rt Os Pcd	Alpha 4
TED-DAY-IND Element: Day Ind	Alpha 1 1 = Wait 2 = Excluded 3 = SSP Day 4 = Non Qualifying Day 5 = Maternity Day 6 = Percentage 7 = No Pay 8 = Fixed X = Other
TED-DELETION-DATE Element: Deletion Date	Numeric 8 (yyyymmdd)
TED-TRD-DELETED Element: Trd Deleted	Numeric 1	BN150 EXI2.1 EXI4.1 LP130 PR128 PR130 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 PR37.1 PR45.1 PR521 PR529 PR530 PR560 PR582 PR80.1 PR80.4 PR82.1 TA147 UK102 UK560 ZP530
TED-ATTEND-CLASS Element: Attend Class	Alpha 10 A user-defined alphanumeric code that represents a group of attendance codes used for reporting and inquiring. Validated in the ATCLASS file.

TMEMPLVDTL FILE INDEX

TMEMPLVDTL FILE RELATIONS

ONE TO ONE RELATIONS

TMEMPLVDTL FILE RELATIONS

ONE TO MANY RELATIONS

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