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