PR1099RHST

UPDATED BY
PR195 PR197 PR250 PR251 PR253 PR300
PR560 PR582 PR82.1 PR85.1 UK560

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PHR-COMPANY
Element: Company Hr		Numeric 4
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PHR-EMPLOYEE
Element: Employee		Numeric 9
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.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PHR-PAYROLL-YEAR
Element: Payroll Year		Numeric 4
Contains the payroll year in which the allocation was taken.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PHR-QUARTER
Element: Quarter		Numeric 1
Contains the fiscal quarter for the data stored in this record.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PHR-REPORT-ENTITY
Element: Report Entity		Alpha 5
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PHR-PROCESS-LEVEL
Element: Process Lev Hr		Alpha 5
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PHR-CHECK-ID
Element: Check Id		Numeric 12
Contains the payment identification number (unique payment identifier used in tracking payment information).
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PHR-PENS-DIST-CODE
Element: Pens Dist Code		Alpha 1
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PHR-PENS-DST-CODE2
Element: Pens Dst Code2		Alpha 1
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PHR-PENS-SEQ-NBR
Element: Pens Seq Nbr		Numeric 4
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PHR-PENS-DIST-TYPE
Element: Pens Dist Type		Numeric 2
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PHR-GROSS-DIST
Element: Gross Dist		Signed 15.2
PR82.1 PR85.1
PHR-TAXABLE-AMT
Element: Taxable Amt		Signed 15.2
This is the taxable amount.
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PHR-ORD-INCOME
Element: Ord Income		Signed 15.2
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PHR-CAPITAL-GAIN
Element: Capital Gain		Signed 15.2
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PHR-FED-INC-TAX
Element: Fed Inc Tax		Signed 15.2
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PHR-EMP-CONTRIBUT
Element: Emp Contribut		Signed 15.2
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PHR-NET-UNR-GAIN
Element: Net Unr Gain		Signed 15.2
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PHR-PCT-TOTAL-DIST
Element: Pct Total Dist		Numeric 3
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560
PHR-LAST-RUN-DATE
Element: Last Run Date		Numeric 8 (yyyymmdd)
PR250 PR251
PR253 PR560
UK560
PHR-OTHER
Element: Other		Signed 15.2
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560


PR1099RHST FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PHRSET1 COMPANY
EMPLOYEE
PAYROLL-YEAR
QUARTER
REPORT-ENTITY
PROCESS-LEVEL
PENS-DIST-CODE
PENS-DST-CODE2
CHECK-ID
PENS-SEQ-NBR
PR250 PR251
PR253 PR300
PR560 UK560
PHRSET2 COMPANY
PAYROLL-YEAR
REPORT-ENTITY
PROCESS-LEVEL
EMPLOYEE
PENS-DIST-CODE
PENS-DST-CODE2
CHECK-ID
PENS-SEQ-NBR
PR250 PR251
PR253
PHRSET3 COMPANY
PAYROLL-YEAR
EMPLOYEE
REPORT-ENTITY
PROCESS-LEVEL
PENS-DIST-CODE
PENS-DST-CODE2
CHECK-ID
PENS-SEQ-NBR
PR250 PR251
PR253
PHRSET4 COMPANY
EMPLOYEE
CHECK-ID
PENS-SEQ-NBR
PR195 PR197
PR560 PR582
PR82.1 PR85.1
UK560


PR1099RHST FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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

File created: Thu Jun 09 11:27:09 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.