TAREASCODE

REFERENCED BY
BN150 PR521 EXI2.1 EXI4.1 LP08.2 LP130
LP199 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
ZP530 TA147 LP10.1 LP201 LP208 LP209
LP211


UPDATED BY
HR00.1 HR01.1 LP09.2

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
LP199 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: Thu Jun 09 11:19:47 2016

Home
Contact Us



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