ETTIMELINE FILE
REFERENCED BY
ET540
UPDATED BY
ET530
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TMD-TL-ID Numeric 10 ET530
Element: Numeric 1
TMD-TL-TC-ID Numeric 10
Element: Numeric 1
TMD-TL-DATE Numeric 8 (yyyymmdd)
Element: Date
TMD-TL-RES-ID Numeric 10
Element: Numeric 1
TMD-TL-PAYCODE Alpha 10
Element: Alpha 10
TMD-TL-ACTIVITY-ID Numeric 12
Element: Orig Obj Id
TMD-TL-ACCT-CAT Alpha 10 ET540
Element: Alpha 10
TMD-TL-HOURS Signed 7.2
Element: Hours
TMD-TL-BILLABLE Numeric 5
Element: Numeric
TMD-TL-BILL-STATUS Numeric 5
Element: Numeric
TMD-TL-PAY-STATUS Numeric 5
Element: Numeric
TMD-TL-SUBMIT-DATE Numeric 8 (yyyymmdd)
Element: Date
TMD-TL-JOB-CODE Alpha 10
Element: Alpha 10
TMD-TL-POSITION Alpha 12
Element: Position
TMD-TL-DEPARTMENT Alpha 12
Element: Alpha 12
TMD-TL-PROC-LEVEL Alpha 12
Element: Alpha 12
TMD-TL-RATE-CODE Alpha 10
Element: Code
TMD-TL-SHIFT Numeric 10
Element: Numeric 1
TMD-TL-SCHEDULE Alpha 10
Element: Alpha 10
TMD-TL-GRADE Alpha 3
Element: Pay Grade
TMD-TL-STEP Numeric 2
Element: Pay Step
TMD-TL-PAY-SENT Numeric 5 ET530
Element: Numeric
TMD-TL-PAY-SENT-DT Numeric 8 (yyyymmdd)
Element: Date
TMD-TL-BILL-SENT Numeric 5 ET530
Element: Numeric
TMD-TL-BILL-SNT-DT Numeric 8 (yyyymmdd)
Element: Date
TMD-TL-COMMENT-IND Numeric 5
Element: Numeric
TMD-TL-CREATOR-ID Numeric 10
Element: Numeric 1
TMD-TL-CREATE-DATE Numeric 8 (yyyymmdd)
Element: Date
TMD-TL-SUBMIT Numeric 5
Element: Numeric
TMD-TL-DAYS Signed 7.2
Element: Hours
TMD-TL-REL-TL-ID Numeric 10 ET530
Element: Numeric 1
TMD-TL-PAYRTESTEP Numeric 10
Element: Numeric 1
TMD-TL-PAYRTERESID Numeric 10
Element: Numeric 1
TMD-TL-BILRTESTEP Numeric 10
Element: Numeric 1
TMD-TL-BILRTERESID Numeric 10
Element: Numeric 1
TMD-TL-BASECURR Numeric 10
Element: Numeric 1
TMD-TL-ATN-OBJ-ID Numeric 12 ET530
Element: Obj Id
TMD-TL-RTE-ID Numeric 10
Element: Numeric 1
TMD-TL-LOCATION Alpha 10
Element: Alpha 10
TMD-TL-BILLCAT Numeric 10
Element: Numeric 1
TMD-TL-ERRFLAG Numeric 10
Element: Numeric 1
TMD-TL-TYPE Numeric 10 ET530
Element: Numeric 1
TMD-TL-PAYRTELDATE Numeric 8 (yyyymmdd)
Element: Date
TMD-TL-BILRTELDATE Numeric 8 (yyyymmdd)
Element: Date
TMD-TL-MOD-ID Numeric 10
Element: Numeric 1
TMD-TL-MOD-DATE Numeric 8 (yyyymmdd)
Element: Date
TMD-TL-ASGN-ID Numeric 10
Element: Numeric 1
TMD-TL-BILLCATGRP Alpha 30
Element: Alpha 30
TMD-TL-ADJUSTABLE Numeric 10
Element: Numeric 1
TMD-TL-INVC-STS Numeric 10
Element: Numeric 1
TMD-TL-INTERR Numeric 10
Element: Numeric 1
TMD-TL-MWEBRES-ID Numeric 10
Element: Numeric 1
TMD-TL-MINUTES Signed 10.0
Element: Minutes
TMD-TL-HOUR-IN Numeric 10
Element: Numeric 1
TMD-TL-MINUTE-IN Numeric 10
Element: Numeric 1
TMD-TL-HOUR-OUT Numeric 10
Element: Numeric 1
TMD-TL-MINUTE-OUT Numeric 10
Element: Numeric 1
TMD-TL-BO-ADJUST Numeric 10 ET530
Element: Numeric 1
TMD-TL-PRD-ID Numeric 10
Element: Numeric 1
TMD-TL-COSTCENTER Numeric 10
Element: Numeric 1
TMD-TL-GLCOMPANY Numeric 4
Element: Company
TMD-TL-ACCT-UNIT Alpha 15
Element: Acct Unit
ETTIMELINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TMDSET1 TL-ID ET530
TMDSET2 TL-PAY-SENT KeyChange ET530
TL-ID
TMDSET3 TL-BILL-SENT KeyChange ET540
TL-ID
TMDSET4 TL-TC-ID ET530
TL-PAY-SENT
TL-ID
TMDSET5 TL-REL-TL-ID ET530
TL-PAY-SENT
TL-ID
|
