|
|
TALOSHRS FILE
REFERENCED BY
LP140 LP145 LP198 LP231
UPDATED BY
LP188 LP331 LP88.1 HR11.1 HR511 LP100
LP101 LP180 LP197 LP31.1 LP80.1 PA100
PA52.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TLH-COMPANY Numeric 4 LP188 LP88.1
Element: Company Hr
TLH-EMPLOYEE Numeric 9 LP188 LP88.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.
TLH-PLAN Alpha 10 LP188 LP88.1
Element: Ta Plan
TLH-EMPLOYEE-GROUP Alpha 10 LP188 LP88.1
Element: Group Name
TLH-POSITION Alpha 12 LP188 LP88.1
Element: Position Contains the user-defined code that
represents a position in the company.
TLH-PLAN-RULE Numeric 2 LP188 LP88.1
Element: Ta Type Contains the units of measure for the
summarized totals.
01 = Accrual
02 = Allotment
03 = Ongoing Balance Limit
04 = Annual Accrual Limit
05 = Carryover Limit
06 = GL Liability
TLH-ACCRUAL-TYPE Numeric 2 LP188 LP88.1
Element: Accrual Type
TLH-YEAR Numeric 4 LP188 LP88.1
Element: Payroll Year Contains the payroll year in which the
allocation was taken.
TLH-HOURS Signed 7.2 LP188 LP88.1
Element: Hours Contains the hours.
TLH-HM-PROC-LEVEL Alpha 5 LP188 LP88.1
Element: Process Lev Hr
TLH-DATE-STAMP Numeric 8 (yyyymmdd) LP188 LP88.1
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
TLH-TIME-STAMP Numeric 6 (hhmmss) LP188 LP88.1
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
TLH-USER-ID Alpha 10 (Lower Case) LP188 LP88.1
Element: User
TALOSHRS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TLHSET1 COMPANY HR11.1 HR511
EMPLOYEE LP100 LP101
PLAN LP140 LP145
EMPLOYEE-GROUP LP180 LP188
POSITION LP197 LP198
PLAN-RULE LP31.1 LP331
ACCRUAL-TYPE LP80.1 PA100
YEAR PA52.4
TLHSET2 COMPANY LP231 LP88.1
EMPLOYEE LP88.2
PLAN
EMPLOYEE-GROUP
POSITION
PLAN-RULE
ACCRUAL-TYPE
YEAR*
TLHSET3 COMPANY
HM-PROC-LEVEL
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
PLAN-RULE
ACCRUAL-TYPE
YEAR
TALOSHRS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TLH-COMPANY -> PRS-COMPANY (PRSSET1)
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
TLH-COMPANY -> EMP-COMPANY
TLH-EMPLOYEE -> EMP-EMPLOYEE
Group Name PERSGROUP Required
TLH-COMPANY -> PRG-COMPANY
TLH-EMPLOYEE-GROUP -> PRG-GROUP-NAME
Hm Proc Level PRSYSTEM Required
When TLH-HM-PROC-LEVEL != Spaces
TLH-COMPANY -> PRS-COMPANY
TLH-HM-PROC-LEVEL -> PRS-PROCESS-LEVEL
Paemployee PAEMPLOYEE Required
TLH-COMPANY -> PEM-COMPANY
TLH-EMPLOYEE -> PEM-EMPLOYEE
Plan TAPLAN Required
TLH-COMPANY -> TAP-COMPANY
TLH-PLAN -> TAP-PLAN
Taeemaster TAEEMASTER Required
TLH-COMPANY -> TEM-COMPANY
TLH-EMPLOYEE -> TEM-EMPLOYEE
TLH-PLAN -> TEM-PLAN
TLH-EMPLOYEE-GROUP -> TEM-EMPLOYEE-GROUP
TLH-POSITION -> TEM-POSITION
TALOSHRS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Position PAPOSITION
Valid When TLH-POSITION != Spaces
TLH-COMPANY -> POS-COMPANY
TLH-POSITION -> POS-POSITION
POS-EFFECT-DATE
Tastructur TASTRUCTUR
TLH-COMPANY -> TST-COMPANY
TLH-EMPLOYEE-GROUP -> TST-EMPLOYEE-GROUP
TLH-PLAN -> TST-PLAN
TST-BEGIN-DATE
|
