Lawson Insight Technical Documentation |
|
TMEMPLVDTL
TMEMPLVDTL FILE
REFERENCED BY
UK260
UPDATED BY
AC541 AC542 BN150 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 PR36.1 PR45.1 PR529
PR530 PR560 PR80.1 PR82.1 UK102 UK560
TA147 UK120 UK300 UK60.1 UK70.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TED-COMPANY Numeric 4 UK120 UK60.1
Element: Company The company number represents an
established company and is entered on
all function codes.
TED-EMPLOYEE Numeric 9 UK120 UK60.1
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 UK120 UK60.1
Element: From Plan NameThis field contains the plan name.
TED-TR-DATE Numeric 8 (yyyymmdd) UK120 UK60.1
Element: Time Record Date
TED-TIME-SEQ Numeric 12 UK120 UK60.1
Element: Sequence Number
TED-OS-TIME-SEQ Numeric 12
Element: Os Time Seq
TED-ATTEND-CODE Alpha 2 UK120 UK60.1
Element: Attendance CodA user-defined alphanumeric code that UK70.1
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 UK120 UK60.1
Element: Pcd Seq Nbr UK70.1
TED-HOURS Signed 7.2 UK120 UK60.1
Element: Hours Contains the hours. UK70.1
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 AC541 AC542
Element: Trd Deleted BN150 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 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
TA147 UK102
UK120 UK560
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 UK120 UK260
EMPLOYEE UK70.1
PLAN-NAME
TR-DATE
ATTEND-CODE
TEDSET2 COMPANY KeyChange UK120 UK260
PLAN-NAME UK300 UK60.1
EMPLOYEE UK60.2
TR-DATE*
ATTEND-CODE
TEDSET3 COMPANY KeyChange AC541 AC542
EMPLOYEE BN150 PR128
TR-DATE PR130 PR131
ATTEND-CODE PR132 PR134
PLAN-NAME PR136 PR189
PR29.1 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR45.1 PR529
PR530 PR560
PR80.1 PR82.1
UK102 UK560
...
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
|