TASERVICE FILE
REFERENCED BY
LP140 LP145 LP188 LP198 LP210 LP251
LP260 LP353 LP60.1 LP60.3 BN150 ET530
ETI2.1 LP130 PR128 PR130 PR131 PR132
PR134 PR135 PR136 PR137 PR189 PR29.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
LP08.3 LP08.4 LP08.1 LP08.2 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TSV-COMPANY Numeric 4 LP08.3 LP08.4
Element: Company Hr
TSV-SERVICE-CLASS Alpha 3 LP08.3 LP08.4
Element: Ta Service Cls
TSV-SERVICE-CODE Alpha 4 LP08.3 LP08.4
Element: Ta Service Cd
TSV-HOURS-FLAG Alpha 1 LP08.3 LP08.4
Element: Hours Flag 1 = Include
2 = Exclude
3 = Subtract
TSV-WAGES-FLAG Alpha 1 LP08.3 LP08.4
Element: Wages Flag 1 = Include
2 = Exclude
3 = Subtract
TASERVICE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TSVSET1 COMPANY HR00.1 HR01.1
SERVICE-CLASS LP08.1 LP08.3
SERVICE-CODE LP140 LP145
LP188 LP198
LP210 LP251
LP260 LP353
LP60.1 LP60.3
TSVSET2 COMPANY BN150 ET530
SERVICE-CODE ETI2.1 LP08.2
SERVICE-CLASS LP08.4 LP130
PR128 PR130
PR131 PR132
PR134 PR135
PR136 PR137
PR189 PR29.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
...
TASERVICE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TSV-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Service Class TASERVCLSS Required
TSV-COMPANY -> TSL-COMPANY
TSV-SERVICE-CLASS -> TSL-SERVICE-CLASS
Service Code TASERVCODE Required
TSV-COMPANY -> TSC-COMPANY
TSV-SERVICE-CODE -> TSC-SERVICE-CODE
|