TMEMPLVDTL

UPDATED BY
BN150 PR521 EXI2.1 EXI4.1 LP130 LP140
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 PR529 PR530 PR560 PR582
PR80.1 PR80.4 PR82.1 UK102 UK560 TA147

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
LP140 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
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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TEDSET1 COMPANY
EMPLOYEE
PLAN-NAME
TR-DATE
ATTEND-CODE
TEDSET2 COMPANY
PLAN-NAME
EMPLOYEE
TR-DATE*
ATTEND-CODE
KeyChange
TEDSET3 COMPANY
EMPLOYEE
TR-DATE
ATTEND-CODE
PLAN-NAME
KeyChange
...
BN150 PR521
EXI2.1 EXI4.1
LP130 LP140
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
TEDSET4 COMPANY
EMPLOYEE
TR-DATE
PLAN-NAME
ATTEND-CODE
Subset
Where(CALC-STATUS ="2")
Or(CALC-STATUS ="4")
TEDSET5 COMPANY
EMPLOYEE
ATTEND-CODE
TR-DATE
PLAN-NAME
TRD-DELETED
KeyChange, Subset
WhereTRD-DELETED !=Zeroes


TMEMPLVDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Wed Jun 08 20:51:43 2016

Home
Contact Us



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