Lawson Insight Technical Documentation |
|
TAREASCODE
TAREASCODE FILE
REFERENCED BY
BN150 ET530 ET700 ETI2.1 LP08.2 LP130
LP208 LP209 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 PR80.1 PR82.1 UK102 UK560
TA147
UPDATED BY
LP09.2 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TRE-COMPANY Numeric 4 LP09.2
Element: Company Hr
TRE-REASON-CODE Alpha 4 LP09.2
Element: Ta Reason Cd
TRE-DESCRIPTION Alpha 30 (Lower Case) LP09.2
Element: Ta Description
TRE-REASON-TYPE Numeric 1 LP09.2
Element: Ta Reason Type1 = Absence
2 = Non Absence
TRE-PLAN-BALANCE Numeric 1 LP09.2
Element: Lp Plan Bal 0 = None
1 = Available
2 = Reserve
TRE-SERVICE-CODE Alpha 4 LP09.2
Element: Ta Service Cd
TRE-POINTS Signed 7.2 LP09.2
Element: Points
TRE-STATUS Numeric 1 LP09.2
Element: Ta Status 0 = Active
1 = Inactive
TAREASCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TRESET1 COMPANY BN150 ET530
REASON-CODE ET700 ETI2.1
HR00.1 HR01.1
LP08.2 LP09.2
LP09.3 LP09.4
LP130 LP208
LP209 LP211
LP251 LP260
LP262 LP53.1
LP54.1 LP553
LP554 LP60.2
LP61.1 LP62.1
LP62.2 PR128
PR130 PR131
PR132 PR134
...
TAREASCODE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ta Reason TAREASONS Delete Cascades
TRE-COMPANY -> TRO-COMPANY
TRE-REASON-CODE -> TRO-REASON-CODE
TRO-REASON-CLASS
|