PBHSTDTL FILE
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PBH-COMPANY Numeric 4
Company The company number represents an
established company and is entered on
all function codes.
PBH-PROCESS-LEVEL Alpha 5
Process Level This field contains the process level,
which is the reporting hierarchy below
company.
PBH-INVOICE Alpha 22
Invoice Number Used to identify the invoice.
PBH-INVOICE-PREFIX Alpha 2
Invoice Prefix
PBH-INVOICE-NBR Numeric 8
Invoice Nbr
PBH-LINE-NBR Numeric 6
Line Number This field contains the line number.
PBH-RECORD-TYPE Alpha 1
Record Type This field identifies the type of
record defined.
Valid values are:
S = Summary
D = Detail
F = Fee Info
T = Time Record Info
O = AR Offset Transaction
J = Job Code Fee
B
PBH-EMPLOYEE Numeric 9
Employee Contains the employee number. Each
person employed by the company is
assigned a unique number. The system
uses the employee number to correlate
all of the information related to that
person.
PBH-DEDUCT-FEE-CD Alpha 4
Deduct Fee Cd
PBH-CODE-TYPE Alpha 1
Code Type
PBH-PROGRAM Alpha 5
Program This field designates the program this
record was created by
PBH-DESCRIPTION Alpha 30 (Lower Case)
Description This field displays the description.
PBH-TAX-CATEGORY Numeric 2
Tax Category
PBH-TAX-AUTH-TYPE Alpha 2
Tax Auth Type
PBH-ADJUST-PAY Alpha 1
Adjust Pay
PBH-WC-STATE Alpha 2
Wc State
PBH-WC-CODE Alpha 10
Workers Comp Policy Contains the workers' compensation code.
Code
PBH-WC-CLASS Alpha 4
Workers Comp Contains the workers' compensation
Classification class.
PBH-WC-RATE Signed 13.4
Wc Rate
PBH-REG-HOURS Signed 7.2
Reg Hours
PBH-OT-HOURS Signed 7.2
Ot Hours
PBH-OTH-HOURS Signed 7.2
Oth Hours
PBH-REG-RATE Signed 13.4
Reg Rate
PBH-OT-RATE Signed 13.4
Ot Rate
PBH-OTH-RATE Signed 13.4
Oth Rate
PBH-REG-PAY Signed 11.2
Reg Pay
PBH-OT-PAY Signed 11.2
Ot Pay
PBH-OTH-PAY Signed 11.2
Oth Pay
PBH-TIPS-PAY Signed 11.2
Tips Pay
PBH-GROSS-PAY Signed 13.2
Gross Pay
PBH-EMPLOYEE-CAFE Signed 11.2
Employee Cafe
PBH-CREDITS Signed 11.2
Credits
PBH-BILLABLE-AMT Signed 15.2
Billable Amt
PBH-BILLABLE-UNIT Signed 15.2
Billable Unit
PBH-TAXABLE-AMT Signed 15.2
Taxable Amount The taxable amount.
PBH-CHECK-ID Numeric 12
Internal Check ID Contains the payment identification
Number number (unique payment identifier used
in tracking payment information).
PBH-DEPARTMENT Alpha 5
Department Contains the department.
PBH-JOB-CODE Alpha 9
Job Code Contains a user-defined code that
represents a type of job.
PBH-POSITION Alpha 12
Position Contains the user-defined code that
represents a position in the company.
PBH-PCD-SEQ-NBR Numeric 4
Pcd Seq Nbr
PBH-PRD-REC-TYPE Alpha 1
Prd Rec Type
PBH-PLAN-TYPE Alpha 2
Type
PBH-PLAN-CODE Alpha 4
Plan Contains the user-defined code that
represents a benefit plan.
PBH-REPORT-ENTITY Alpha 5
Report Entity
PBH-BUS-NBR-GRP Alpha 4
Bus Nbr Grp
PBH-QC-ENT-NBR-GRP Alpha 4
Qc Ent Nbr Grp
PBH-CURRENCY-CODE Alpha 5
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PBH-CURR-ND Numeric 1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
PBH-CALC-TYPE Alpha 1
Calculation Type This field contains the calculation
type.
PBH-PAY-SUM-GRP Alpha 3
Payment Summary
Group
PBH-TR-DATE Numeric 8 (yyyymmdd)
Time Record Date
PBH-TIME-SEQ Numeric 12
Sequence Number
PBH-CLIENT-JOBID Alpha 20
Client Jobid
PBH-EDM-SEQ-NBR Numeric 4
Emp Deduction
Sequence Number
PBHSTDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PBHSET1 COMPANY
PROCESS-LEVEL
INVOICE
LINE-NBR
PBHSET2 COMPANY
EMPLOYEE
CHECK-ID
PROCESS-LEVEL
INVOICE
LINE-NBR
PBHSET3 COMPANY
PROCESS-LEVEL
INVOICE
EMPLOYEE
LINE-NBR
PBHSET4 COMPANY
PROCESS-LEVEL
WC-CODE
WC-STATE
INVOICE
LINE-NBR
PBHSTDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Paymastr PAYMASTR Required
PBH-COMPANY -> PYM-COMPANY (PYMSET1)
PBH-EMPLOYEE -> PYM-EMPLOYEE
PBH-CHECK-ID -> PYM-CHECK-ID
Pbhsthdr PBHSTHDR Required
PBH-COMPANY -> PBK-COMPANY
PBH-PROCESS-LEVEL -> PBK-PROCESS-LEVEL
PBH-INVOICE -> PBK-INVOICE
|
