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