TALOSHRS

REFERENCED BY
LP140 LP145 LP198


UPDATED BY
LP188 LP331 LP88.1 LP88.2 HR11.1 HR511
LP100 LP101 LP102 LP103 LP131 LP180
LP197 LP31.1 LP80.1 PA100 PA52.4 LP231

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TLH-COMPANY
Element: Company Hr		Numeric 4
LP188 LP88.1
TLH-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.
LP188 LP88.1
TLH-PLAN
Element: Ta Plan		Alpha 10
LP188 LP88.1
TLH-EMPLOYEE-GROUP
Element: Group Name		Alpha 10
LP188 LP88.1
TLH-POSITION
Element: Position		Alpha 12
Contains the user-defined code that represents a position in the company.
LP188 LP88.1
TLH-PLAN-RULE
Element: Ta Type		Numeric 2
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
LP188 LP88.1
TLH-ACCRUAL-TYPE
Element: Accrual Type		Numeric 2
LP188 LP88.1
TLH-YEAR
Element: Payroll Year		Numeric 4
Contains the payroll year in which the allocation was taken.
LP188 LP88.1
TLH-HOURS
Element: Hours		Signed 7.2
Contains the hours.
LP188 LP88.1
TLH-HM-PROC-LEVEL
Element: Process Lev Hr		Alpha 5
LP188 LP88.1
TLH-DATE-STAMP
Element: Date Stamp		Numeric 8 (yyyymmdd)
This field contains the server date (month, date, and year) of the last change to this record.
LP188 LP88.1
TLH-TIME-STAMP
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
LP188 LP88.1
TLH-USER-ID
Element: User		Alpha 10 (Lower Case)
LP188 LP88.1


TALOSHRS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TLHSET1 COMPANY
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
PLAN-RULE
ACCRUAL-TYPE
YEAR
HR11.1 HR511
LP100 LP101
LP102 LP103
LP131 LP140
LP145 LP180
LP188 LP197
LP198 LP31.1
LP331 LP80.1
PA100 PA52.4
TLHSET2 COMPANY
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
PLAN-RULE
ACCRUAL-TYPE
YEAR*
LP231 LP88.1
LP88.2
TLHSET3 COMPANY
HM-PROC-LEVEL
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
PLAN-RULE
ACCRUAL-TYPE
YEAR


TALOSHRS FILE RELATIONS


ONE TO ONE RELATIONS

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

File created: Wed Jun 08 20:50:01 2016

Home
Contact Us



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