TASERVICE

Service Class & Code Relations

REFERENCED BY
BN150 PR521 EXI2.1 EXI4.1 LP10.1 LP102
LP130 LP140 LP145 LP188 LP198 LP210
LP260 LP353 LP60.1 LP60.3 PR128 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 PR36.4 PR37.1 PR45.1
PR529 PR530 PR560 PR582 PR80.1 PR80.4
PR82.1 UK102 TA147 LP199


UPDATED BY
LP08.3 LP08.4 LP08.1 LP08.2 HR00.1 HR01.1
LP251

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TSV-COMPANY
Element: Company Hr
Numeric 4
LP08.3 LP08.4
TSV-SERVICE-CLASS
Element: Ta Service Cls
Alpha 3
LP08.3 LP08.4
TSV-SERVICE-CODE
Element: Ta Service Cd
Alpha 10
LP08.3 LP08.4
TSV-HOURS-FLAG
Element: Hours Flag
Alpha 1

1 = Include
2 = Exclude
3 = Subtract
LP08.3 LP08.4
TSV-WAGES-FLAG
Element: Wages Flag
Alpha 1

1 = Include
2 = Exclude
3 = Subtract
LP08.3 LP08.4


TASERVICE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TSVSET1 COMPANY
SERVICE-CLASS
SERVICE-CODE
...
BN150 HR00.1
HR01.1 PR521
EXI2.1 EXI4.1
LP08.1 LP08.3
LP10.1 LP102
LP130 LP140
LP145 LP188
LP198 LP210
LP251 LP260
LP353 LP60.1
LP60.3 PR128
PR131 PR132
PR134 PR135
PR136 PR137
PR189 PR29.1
TSVSET2 COMPANY
SERVICE-CODE
SERVICE-CLASS
...
BN150 PR521
EXI2.1 EXI4.1
LP08.2 LP08.4
LP130 LP199
PR128 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


TASERVICE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 02:22:11 2016

Home
Contact Us



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