|
|
PR1099RHST FILE
UPDATED BY
PR197 PR250 PR251 PR253 PR560 PR82.1
PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PHR-COMPANY Numeric 4 PR197 PR560
Element: Company Hr Identifies the AP company if the PR82.1 PR85.1
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
PHR-EMPLOYEE Numeric 9 PR197 PR560
Element: Employee Contains the employee number. Each PR82.1 PR85.1
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.
PHR-PAYROLL-YEAR Numeric 4 PR197 PR560
Element: Current PayrolContains the payroll year in which the PR82.1 PR85.1
allocation was taken.
PHR-QUARTER Numeric 1 PR197 PR560
Element: Quarter Contains the fiscal quarter for the PR82.1 PR85.1
data stored in this record.
PHR-REPORT-ENTITY Alpha 5 PR197 PR560
Element: Report Entity PR82.1 PR85.1
PHR-PROCESS-LEVEL Alpha 5 PR197 PR560
Element: Process Lev HrThis field contains the process level, PR82.1 PR85.1
which is the reporting hierarchy below
company.
PHR-CHECK-ID Numeric 12 PR197 PR560
Internal Check ID Contains the payment identification PR82.1 PR85.1
Number number (unique payment identifier used
in tracking payment information).
PHR-PENS-DIST-CODE Alpha 1 PR197 PR560
Element: Pens Dist Code PR82.1 PR85.1
PHR-PENS-DST-CODE2 Alpha 1 PR197 PR560
Element: Pens Dst Code2 PR82.1 PR85.1
PHR-PENS-SEQ-NBR Numeric 4 PR197 PR560
Element: Pens Seq Nbr PR82.1 PR85.1
PHR-PENS-DIST-TYPE Numeric 2 PR197 PR560
Element: Pens Dist Type PR82.1 PR85.1
PHR-GROSS-DIST Signed 15.2 PR82.1 PR85.1
Element: Gross Dist
PHR-TAXABLE-AMT Signed 15.2 PR197 PR560
Element: Taxable AmountThis is the taxable amount. PR82.1 PR85.1
PHR-ORD-INCOME Signed 15.2 PR197 PR560
Element: Ord Income PR82.1 PR85.1
PHR-CAPITAL-GAIN Signed 15.2 PR197 PR560
Element: Capital Gain PR82.1 PR85.1
PHR-FED-INC-TAX Signed 15.2 PR197 PR560
Element: Fed Inc Tax PR82.1 PR85.1
PHR-EMP-CONTRIBUT Signed 15.2 PR197 PR560
Element: Emp Contribut PR82.1 PR85.1
PHR-NET-UNR-GAIN Signed 15.2 PR197 PR560
Element: Net Unr Gain PR82.1 PR85.1
PHR-PCT-TOTAL-DIST Numeric 3 PR197 PR560
Element: Pct Total Dist PR82.1 PR85.1
PHR-LAST-RUN-DATE Numeric 8 (yyyymmdd) PR250 PR251
Element: Last Run Date PR253 PR560
PHR-OTHER Signed 15.2 PR197 PR560
Element: Other PR82.1 PR85.1
PR1099RHST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PHRSET1 COMPANY PR250 PR251
EMPLOYEE PR253 PR560
PAYROLL-YEAR
QUARTER
REPORT-ENTITY
PROCESS-LEVEL
PENS-DIST-CODE
PENS-DST-CODE2
CHECK-ID
PENS-SEQ-NBR
PHRSET2 COMPANY PR250 PR251
PAYROLL-YEAR PR253
REPORT-ENTITY
PROCESS-LEVEL
EMPLOYEE
PENS-DIST-CODE
PENS-DST-CODE2
CHECK-ID
PENS-SEQ-NBR
PHRSET3 COMPANY PR250 PR251
PAYROLL-YEAR PR253
EMPLOYEE
REPORT-ENTITY
PROCESS-LEVEL
PENS-DIST-CODE
PENS-DST-CODE2
CHECK-ID
PENS-SEQ-NBR
PHRSET4 COMPANY PR197 PR560
EMPLOYEE PR82.1 PR85.1
CHECK-ID
PENS-SEQ-NBR
PR1099RHST FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PHR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
PHR-COMPANY -> EMP-COMPANY
PHR-EMPLOYEE -> EMP-EMPLOYEE
Paymastr PAYMASTR Not Required
PHR-COMPANY -> PYM-COMPANY
PHR-EMPLOYEE -> PYM-EMPLOYEE
PHR-CHECK-ID -> PYM-CHECK-ID
Prcheck PRCHECK Not Required
PHR-COMPANY -> PCH-COMPANY
PHR-EMPLOYEE -> PCH-EMPLOYEE
PHR-PENS-SEQ-NBR -> PCH-PENS-SEQ-NBR
PHR-CHECK-ID -> PCH-CHECK-ID
Process Level PRSYSTEM Required
PHR-COMPANY -> PRS-COMPANY
PHR-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
Prpenhist PRPENHIST Not Required
PHR-COMPANY -> PNH-COMPANY
PHR-EMPLOYEE -> PNH-EMPLOYEE
PHR-CHECK-ID -> PNH-CHECK-ID
PHR-PENS-SEQ-NBR -> PNH-PENS-SEQ-NBR
PR1099RHST FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Prpenfsrch PRPENFSRCH
PHR-COMPANY -> PFH-COMPANY
PHR-EMPLOYEE -> PFH-EMPLOYEE
PHR-CHECK-ID -> PFH-CHECK-ID
PHR-PENS-SEQ-NBR -> PFH-PENS-SEQ-NBR
PFH-FUNDING-SOURCE
|
