TAREASCODE

REFERENCED BY
BN150 PR521 EXI2.1 EXI4.1 LP08.2 LP10.1
LP130 LP140 LP201 LP208 LP211 LP251
LP260 LP262 LP53.1 LP54.1 LP553 LP554
LP60.2 LP61.1 LP62.1 LP62.2 PR128 PR130
PR131 PR132 PR134 PR135 PR136 PR137
PR189 PR29.1 PR30.1 PR32.1 PR32.2 PR33.1
PR33.2 PR33.3 PR35.1 PR35.2 PR35.3 PR35.4
PR35.5 PR35.6 PR35.8 PR35.9 PR36.1 PR37.1
PR45.1 PR529 PR530 PR560 PR582 PR80.1
PR80.4 PR82.1 UK102 UK560 TA147


UPDATED BY
LP09.2 LP09.4 HR00.1 HR01.1 LP209

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRE-COMPANY
Element: Company Hr
Numeric 4
LP09.2
TRE-REASON-CODE
Element: Ta Reason Cd
Alpha 4
LP09.2
TRE-DESCRIPTION
Element: Ta Description
Alpha 30 (Lower Case)
LP09.2
TRE-REASON-TYPE
Element: Ta Reason Type
Numeric 1

1 = Absence
2 = Non Absence
LP09.2
TRE-PLAN-BALANCE
Element: Lp Plan Bal
Numeric 1

0 = None
1 = Available
2 = Reserve
LP09.2
TRE-SERVICE-CODE
Element: Ta Service Cd
Alpha 10
LP09.2
TRE-POINTS
Element: Points
Signed 7.2
LP09.2
TRE-STATUS
Element: Ta Status
Numeric 1

0 = Active
1 = Inactive
LP09.2


TAREASCODE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRESET1 COMPANY
REASON-CODE
...
BN150 HR00.1
HR01.1 PR521
EXI2.1 EXI4.1
LP08.2 LP09.2
LP09.3 LP09.4
LP10.1 LP130
LP140 LP201
LP208 LP209
LP211 LP251
LP260 LP262
LP53.1 LP54.1
LP553 LP554
LP60.2 LP61.1
LP62.1 LP62.2
PR128 PR130


TAREASCODE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TRE-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Service Code TASERVCODE Required
When (TRE-SERVICE-CODE !=Spaces )
TRE-COMPANY->TSC-COMPANY
TRE-SERVICE-CODE->TSC-SERVICE-CODE


TAREASCODE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Ta Reason TAREASONS Delete Cascades
TRE-COMPANY->TRO-COMPANY
TRE-REASON-CODE->TRO-REASON-CODE
  TRO-REASON-CLASS


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

Home
Contact Us



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