Lawson Insight Technical Documentation |
|
TMEMPLVDTL
TMEMPLVDTL FILE
UPDATED BY
BN150 ET530 ETI2.1 LP130 PR128 PR130
PR131 PR132 PR134 PR136 PR189 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 PR80.1 PR82.1
UK102 UK560 TA147
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TED-COMPANY Numeric 4
Element: Company Hr
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: Plan Name This field contains the plan name.
TED-TR-DATE Numeric 8 (yyyymmdd)
Element: Tr Date
TED-TIME-SEQ Numeric 12
Element: Time Seq
TED-OS-TIME-SEQ Numeric 12
Element: Os Time Seq
TED-ATTEND-CODE Alpha 2
Element: Attend Code 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 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
Element: Os 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: Pay 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 ET530
Element: Trd Deleted ETI2.1 LP130
PR128 PR130
PR131 PR132
PR134 PR136
PR189 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
PR80.1 PR82.1
TA147 UK102
UK560
TED-ATTEND-CLASS Alpha 10
Element: Attend Class 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 KeyChange
PLAN-NAME
EMPLOYEE
TR-DATE*
ATTEND-CODE
TEDSET3 COMPANY KeyChange BN150 ET530
EMPLOYEE ETI2.1 LP130
TR-DATE PR128 PR130
ATTEND-CODE PR131 PR132
PLAN-NAME PR134 PR136
PR189 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
PR80.1 PR82.1
...
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
|