PBTIMEREC FILE
Pay to Bill Time Record
UPDATED BY
BN150 PR128 PR131 PR132 PR134 PR136
PR137 PR140 PR150 PR195 PR199 PR32.1
PR32.2 PR33.1 PR33.2 PR33.3 PR35.1 PR35.2
PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR36.1
PR37.1 PR45.1 PR530 PR80.1 PR82.1 PR85.1
UK102 UK330 UK120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TPB-COMPANY Numeric 4 BN150 PR128
Company The company number represents an PR131 PR132
established company and is entered on PR134 PR136
all function codes. PR137 PR140
PR150 PR195
PR199 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TPB-EMPLOYEE Numeric 9 BN150 PR128
Employee Contains the employee number. Each PR131 PR132
person employed by the company is PR134 PR136
assigned a unique number. The system PR137 PR140
uses the employee number to correlate PR150 PR195
all of the information related to that PR199 PR32.1
person. PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TPB-CHECK-ID Numeric 12
Internal Check ID Contains the payment identification
Number number (unique payment identifier used
in tracking payment information).
TPB-PAY-SUM-GRP Alpha 3
Payment Summary
Group
TPB-TIME-SEQ Numeric 12 BN150 PR128
Sequence Number PR131 PR132
PR134 PR136
PR137 PR140
PR150 PR195
PR199 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TPB-DED-GRP-AMT Signed 15.2
Ded Grp Amt
TPB-DED-GRP-AMT-WC Signed 15.2
Ded Grp Amt Wc
TPB-DED-GRP-AMT-SU Signed 15.2
Ded Grp Amt Su
TPB-PCT-RATE-1 Signed 8.5 BN150 PR128
Pct Rate 1 PR131 PR132
PR134 PR136
PR137 PR140
PR150 PR195
PR199 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TPB-PCT-RATE-2 Signed 8.5 BN150 PR128
Pct Rate 2 PR131 PR132
PR134 PR136
PR137 PR140
PR150 PR195
PR199 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TPB-AMT-RATE-1 Signed 6.2 BN150 PR128
Amt Rate 1 PR131 PR132
PR134 PR136
PR137 PR140
PR150 PR195
PR199 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TPB-AMT-RATE-2 Signed 6.2 BN150 PR128
Amt Rate 2 PR131 PR132
PR134 PR136
PR137 PR140
PR150 PR195
PR199 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TPB-GROSS-AMT-1 Signed 15.2 BN150 PR128
Gross Amt 1 PR131 PR132
PR134 PR136
PR137 PR140
PR150 PR195
PR199 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TPB-GROSS-AMT-2 Signed 15.2 BN150 PR128
Gross Amt 2 PR131 PR132
PR134 PR136
PR137 PR140
PR150 PR195
PR199 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TPB-CLIENT-JOBID Alpha 20 BN150 PR128
Client Jobid PR131 PR132
PR134 PR136
PR137 PR140
PR150 PR195
PR199 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TPB-TIME-USER-FLD Alpha 20 BN150 PR128
Time User Fld PR131 PR132
PR134 PR136
PR137 PR140
PR150 PR195
PR199 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TPB-UNITS-AMOUNT Signed 15.2 BN150 PR128
Units Amount This is the units amount included in PR131 PR132
the file. PR134 PR136
PR137 PR140
PR150 PR195
PR199 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TPB-UNIT-MEASURE Alpha 12 BN150 PR128
Unit Measure PR131 PR132
PR134 PR136
PR137 PR140
PR150 PR195
PR199 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TPB-RATE Signed 13.4 BN150 PR128
Rate Contains the percentage rate. PR131 PR132
PR134 PR136
PR137 PR140
PR150 PR195
PR199 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
UK102 UK120
UK330
TPB-GROSS-CALC-AMT Signed 15.2
Gross Calc Amt
TPB-CHECK-TYPE Alpha 1
Payment Type Contains the payment type.
S = System
M = Manual
J = Adjustment
PBTIMEREC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TPBSET1 COMPANY BN150 PR128
EMPLOYEE PR131 PR132
TIME-SEQ PR134 PR136
PR137 PR140
PR150 PR195
PR199 PR32.1
PR32.2 PR33.1
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR36.1
PR37.1 PR45.1
PR530 PR80.1
PR82.1 PR85.1
...
TPBSET2 COMPANY
EMPLOYEE
CHECK-ID
PAY-SUM-GRP
TIME-SEQ
PBTIMEREC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Timerecord TIMERECORD Required
TPB-COMPANY -> TRD-COMPANY (TRDSET1)
TPB-EMPLOYEE -> TRD-EMPLOYEE
TPB-TIME-SEQ -> TRD-TIME-SEQ
|