|
|
TMEMPLVDTL FILE
UPDATED BY
BN150 PR128 PR130 PR131 PR132 PR134
PR136 PR29.1 PR32.2 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR35.9 PR36.1 PR45.1 PR529 PR530 PR560
PR82.1 UK102 TA147 TP135
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TED-COMPANY Numeric 4
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
TED-EMPLOYEE Numeric 9
Element: Employee 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 Alpha 10
Element: From Plan NameThis field contains the plan name.
TED-TR-DATE Numeric 8 (yyyymmdd)
Element: Time Record Date
TED-TIME-SEQ Numeric 12
Element: Sequence Number
TED-OS-TIME-SEQ Numeric 12
Element: Os Time Seq
TED-ATTEND-CODE Alpha 2
Element: Attendance CodA 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 Numeric 4
Element: Pcd Seq Nbr
TED-HOURS Signed 7.2
Element: Hours Contains the hours.
TED-CALC-STATUS Alpha 1
Element: Calc Status 1 = Ready for Calculation
2 = Calculation Completed
3 = Transferred to Time Records
4 = Ready for Deletion
5 = Deletion Completed
TED-AMOUNT Currency 15.2
Element: Amount This is the amounts by period for the
specified record.
TED-XFER-DATE Numeric 8 (yyyymmdd)
Element: Xfer Date
TED-XFER-AMOUNT Signed 7.2
Element: Xfer Amount
TED-OS-AMOUNT Signed 7.2
Over/Short
Transaction Amount
TED-XFER-OS-AMOUNT Signed 7.2
Element: Xfer Os Amount
TED-HRS-TYPE Alpha 1
Element: Hrs Type H = Hours
D = Days
W = Weeks
M = Months
TED-EXCL-CODE Alpha 2
Element: Excl Code
TED-PAY-CODE Alpha 4
Element: Payment Code Contains the pay code. A pay code is a
user-defined code that identifies a kind
of pay.
TED-XFER-PAY-CODE Alpha 4
Element: Xfer Pay Code
TED-RATE-OS-RULE Alpha 1
Element: Rate Os Rule
TED-RATE-OS-PCD Alpha 4
Element: Rate Os Pcd
TED-XFER-RT-OS-PCD Alpha 4
Element: Xfer Rt Os Pcd
TED-DAY-IND Alpha 1
Element: Day Ind 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 Numeric 8 (yyyymmdd)
Element: Deletion Date
TED-TRD-DELETED Numeric 1 BN150 PR128
Element: Trd Deleted PR130 PR131
PR132 PR134
PR136 PR29.1
PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 TA147
TP135 UK102
TED-ATTEND-CLASS Alpha 10
Element: Attendance ClaA user-defined alphanumeric code that
represents a group of attendance codes
used for reporting and inquiring.
Validated in the ATCLASS file.
TMEMPLVDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TEDSET1 COMPANY
EMPLOYEE
PLAN-NAME
TR-DATE
ATTEND-CODE
TEDSET2 COMPANY KeyChange
PLAN-NAME
EMPLOYEE
TR-DATE*
ATTEND-CODE
TEDSET3 COMPANY KeyChange BN150 PR128
EMPLOYEE PR130 PR131
TR-DATE PR132 PR134
ATTEND-CODE PR136 PR29.1
PLAN-NAME PR32.2 PR33.2
PR33.3 PR35.1
PR35.2 PR35.3
PR35.4 PR35.5
PR35.6 PR35.8
PR35.9 PR36.1
PR45.1 PR529
PR530 PR560
PR82.1 UK102
TA147 TP135
TEDSET4 COMPANY Subset
EMPLOYEE Where (CALC-STATUS = "2" )
TR-DATE Or (CALC-STATUS = "4" )
PLAN-NAME
ATTEND-CODE
TEDSET5 COMPANY KeyChange, Subset
EMPLOYEE Where TRD-DELETED != Zeroes
ATTEND-CODE
TR-DATE
PLAN-NAME
TRD-DELETED
TMEMPLVDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Attend Code ATTENDCODE Required
TED-COMPANY -> ATC-COMPANY (ATCSET1)
TED-ATTEND-CODE -> ATC-ATTEND-CODE
Company PRSYSTEM Required
TED-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
TED-COMPANY -> EMP-COMPANY
TED-EMPLOYEE -> EMP-EMPLOYEE
Prpaycode PRPAYCODE Required
TED-COMPANY -> PCD-COMPANY
TED-PCD-SEQ-NBR -> PCD-SEQ-NBR
Tmleave TMLEAVE Required
TED-COMPANY -> TLV-COMPANY
TED-PLAN-NAME -> TLV-PLAN-NAME
TED-TR-DATE -> TLV-EFFECT-DATE
Tmtime TMTIME Required
TED-COMPANY -> TMT-COMPANY
TED-EMPLOYEE -> TMT-EMPLOYEE
TED-TIME-SEQ -> TMT-TIME-SEQ
TMEMPLVDTL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Tmempleave TMEMPLEAVE Required
TED-COMPANY -> TEL-COMPANY
TED-EMPLOYEE -> TEL-EMPLOYEE
TED-PLAN-NAME -> TEL-PLAN-NAME
TEL-PL-ENTRY-DATE
|
