|
|
PBHSTDTL FILE
UPDATED BY
PBIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PBH-COMPANY Numeric 4 PBIP.1
Element: Company Hr Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
PBH-PROCESS-LEVEL Alpha 5 PBIP.1
Element: Process Lev HrThis field contains the process level,
which is the reporting hierarchy below
company.
PBH-INVOICE Alpha 22 PBIP.1
Element: Invoice NumberUsed to identify the invoice.
PBH-INVOICE-PREFIX Alpha 2 PBIP.1
Element: Invoice Prefix
PBH-INVOICE-NBR Numeric 8 PBIP.1
Element: Invoice Nbr
PBH-LINE-NBR Numeric 6 PBIP.1
Element: Line Number This field contains the line number.
PBH-RECORD-TYPE Alpha 1 PBIP.1
Element: 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
Element: 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
Element: Deduct Fee Cd
PBH-CODE-TYPE Alpha 1 PBIP.1
Element: Code Type
PBH-PROGRAM Alpha 5 PBIP.1
Element: Program This field designates the program this
record was created by
PBH-DESCRIPTION Alpha 30 (Lower Case) PBIP.1
Element: Description This field displays the description.
PBH-TAX-CATEGORY Numeric 2 PBIP.1
Element: Tax Category
PBH-TAX-AUTH-TYPE Alpha 2 PBIP.1
Element: Tax Auth Type
PBH-ADJUST-PAY Alpha 1 PBIP.1
Element: Adjust Pay
PBH-WC-STATE Alpha 2 PBIP.1
Element: 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
Element: Wc Rate
PBH-REG-HOURS Signed 7.2 PBIP.1
Element: Reg Hours
PBH-OT-HOURS Signed 7.2 PBIP.1
Element: Ot Hours
PBH-OTH-HOURS Signed 7.2 PBIP.1
Element: Oth Hours
PBH-REG-RATE Signed 13.4 PBIP.1
Element: Reg Rate
PBH-OT-RATE Signed 13.4 PBIP.1
Element: Ot Rate
PBH-OTH-RATE Signed 13.4 PBIP.1
Element: Oth Rate
PBH-REG-PAY Signed 11.2 PBIP.1
Element: Reg Pay
PBH-OT-PAY Signed 11.2 PBIP.1
Element: Ot Pay
PBH-OTH-PAY Signed 11.2 PBIP.1
Element: Oth Pay
PBH-TIPS-PAY Signed 11.2 PBIP.1
Element: Tips Pay
PBH-GROSS-PAY Signed 13.2 PBIP.1
Element: Gross Pay
PBH-EMPLOYEE-CAFE Signed 11.2 PBIP.1
Element: Employee Cafe
PBH-CREDITS Signed 11.2 PBIP.1
Element: Credits
PBH-BILLABLE-AMT Signed 15.2 PBIP.1
Element: Billable Amt
PBH-BILLABLE-UNIT Signed 15.2 PBIP.1
Element: Billable Unit
PBH-TAXABLE-AMT Signed 15.2 PBIP.1
Element: Taxable AmountThis is 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
Element: Department Contains the department.
PBH-JOB-CODE Alpha 9 PBIP.1
Element: Job Code Contains a user-defined code that
represents a type of job.
PBH-POSITION Alpha 12 PBIP.1
Element: Position Contains the user-defined code that
represents a position in the company.
PBH-PCD-SEQ-NBR Numeric 4 PBIP.1
Element: Pcd Seq Nbr
PBH-PRD-REC-TYPE Alpha 1 PBIP.1
Element: Prd Rec Type
PBH-PLAN-TYPE Alpha 2 PBIP.1
Element: Type
PBH-PLAN-CODE Alpha 4 PBIP.1
Element: Plan Contains the user-defined code that
represents a benefit plan.
PBH-REPORT-ENTITY Alpha 5 PBIP.1
Element: Report Entity
PBH-BUS-NBR-GRP Alpha 4 PBIP.1
Element: Bus Nbr Grp
PBH-QC-ENT-NBR-GRP Alpha 4 PBIP.1
Element: Qc Ent Nbr Grp
PBH-CURRENCY-CODE Alpha 5 PBIP.1
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PBH-CURR-ND Numeric 1 PBIP.1
Account Currency Represents the number of decimals
Code defined for the currency of the object.
PBH-CALC-TYPE Alpha 1 PBIP.1
Element: Calculation TyThis field contains the calculation
type.
PBH-PAY-SUM-GRP Alpha 3 PBIP.1
Payment Summary
Group
PBH-TR-DATE Numeric 8 (yyyymmdd) PBIP.1
Element: Time Record Date
PBH-TIME-SEQ Numeric 12 PBIP.1
Element: Sequence Number
PBH-CLIENT-JOBID Alpha 20 PBIP.1
Element: Client Jobid
PBH-EDM-SEQ-NBR Numeric 4 PBIP.1
Emp Deduction
Sequence Number
PBH-PAY-END-DATE Numeric 8 (yyyymmdd)
Element: Date
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
PBHSET5 COMPANY
PROCESS-LEVEL
EMPLOYEE
RECORD-TYPE
PAY-END-DATE*
INVOICE
LINE-NBR
PBHSTDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Employee EMPLOYEE Required
PBH-COMPANY -> EMP-COMPANY (EMPSET1)
PBH-EMPLOYEE -> EMP-EMPLOYEE
Paymastr PAYMASTR Required
PBH-COMPANY -> PYM-COMPANY
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
|
