|
PBBLDEDUCT FILE
UPDATED BY
PR197 PR85.1 PR36.1 PR45.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PLD-COMPANY Numeric 4 PR197 PR85.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.
PLD-EMPLOYEE Numeric 9 PR197 PR85.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.
PLD-CHECK-ID Numeric 12 PR197 PR85.1
Internal Check ID Contains the payment identification
Number number (unique payment identifier used
in tracking payment information).
PLD-DED-CODE Alpha 4 PR197 PR85.1
Element: Deduction Code
PLD-EDM-SEQ-NBR Numeric 4 PR197 PR85.1
Emp Deduction
Sequence Number
PLD-PROCESS-LEVEL Alpha 5 PR197 PR85.1
Element: Process Lev HrThis field contains the process level,
which is the reporting hierarchy below
company.
PLD-WORK-STATE Alpha 2 PR197 PR85.1
Element: Work State Identifies the state in which the
workers' compensation plan is affective.
PLD-WC-STATE Alpha 2 PR197 PR85.1
Element: Wc State
PLD-WC-CODE Alpha 10 PR197 PR85.1
Workers Comp Policy Contains the workers' compensation code.
Code
PLD-WC-CLASS Alpha 4 PR197 PR85.1
Workers Comp Contains the workers' compensation
Classification class.
PLD-WC-RATE Signed 13.4 PR197 PR85.1
Element: Wc Rate
PLD-PAYROLL-YEAR Numeric 4 PR197 PR85.1
Element: Current PayrolContains the payroll year in which the
allocation was taken.
PLD-QUARTER Numeric 1 PR197 PR85.1
Element: Quarter Contains the fiscal quarter for the
data stored in this record.
PLD-TAX-CATEGORY Numeric 2 PR197 PR85.1
Element: Tax Category
PLD-TAX-AUTH-TYPE Alpha 2 PR197 PR85.1
Element: Tax Auth Type
PLD-ADJUST-PAY Alpha 1 PR197 PR85.1
Element: Adjust Pay
PLD-DED-AMT Signed 13.2 PR197 PR85.1
Element: Deduction Amount
PLD-TAX-WAGES Signed 13.2 PR197 PR85.1
Element: Taxable Wages
PLD-WAGE-AMOUNT Signed 13.2 PR197 PR85.1
Element: Wage Amount Contains the sum of all wage amounts
from the time records for pay codes tied
to this pay summary group.
PLD-EXCESS Signed 13.2 PR197 PR85.1
Element: Excess
PLD-BILLABLE-AMT Signed 15.2 PR197 PR85.1
Element: Billable Amt
PLD-GARN-OBJ-ID Numeric 12 PR197 PR85.1
Element: Garn Obj Id
PLD-REPORT-ENTITY Alpha 5 PR197 PR85.1
Element: Report Entity
PLD-BUS-NBR-GRP Alpha 4 PR197 PR85.1
Element: Bus Nbr Grp
PLD-QC-ENT-NBR-GRP Alpha 4 PR197 PR85.1
Element: Qc Ent Nbr Grp
PLD-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PLD-CURR-ND Numeric 1
Account Currency Represents the number of decimals
Code defined for the currency of the object.
PLD-BN-DED-CODE Alpha 1
Element: Bn Ded Code
PBBLDEDUCT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PLDSET1 COMPANY PR197 PR36.1
EMPLOYEE PR45.1 PR85.1
CHECK-ID
DED-CODE
EDM-SEQ-NBR
REPORT-ENTITY
BUS-NBR-GRP
QC-ENT-NBR-GRP
PROCESS-LEVEL
WORK-STATE
PLDSET3 COMPANY
EMPLOYEE
DED-CODE
EDM-SEQ-NBR
CHECK-ID
REPORT-ENTITY
BUS-NBR-GRP
QC-ENT-NBR-GRP
PROCESS-LEVEL
WORK-STATE
PBBLDEDUCT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Paydeduct PAYDEDUCTN Required
PLD-COMPANY -> PYD-COMPANY (PYDSET1)
PLD-EMPLOYEE -> PYD-EMPLOYEE
PLD-CHECK-ID -> PYD-CHECK-ID
PLD-DED-CODE -> PYD-DED-CODE
PLD-EDM-SEQ-NBR -> PYD-EDM-SEQ-NBR
Spaces -> PYD-REPORT-ENTITY
Spaces -> PYD-BUS-NBR-GRP
Spaces -> PYD-QC-ENT-NBR-GRP
PLD-PROCESS-LEVEL -> PYD-PROCESS-LEVEL
PLD-WORK-STATE -> PYD-WORK-STATE
|