TALOSHRS

REFERENCED BY
LP231


UPDATED BY
LP188 LP331 LP88.1 HR11.1 HR511 LT101
LT111 LP100 LP101 LP102 LP103 LP131
LP140 LP145 LP151 LP180 LP197 LP198
LP31.1 LP80.1 PA100 PA52.4

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
LT101 LT111
LP100 LP101
LP102 LP103
LP131 LP140
LP145 LP151
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
KeyChange


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: Thu Jun 09 02:22:10 2016

Home
Contact Us



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