 |
Lawson Insight Technical Documentation |
|
PR1099RHST FILE
UPDATED BY
PR195 PR197 PR560 PR82.1 PR85.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PHR-COMPANY Numeric 4 PR195 PR197
Company The company number represents an PR560 PR82.1
established company and is entered on PR85.1
all function codes.
PHR-EMPLOYEE Numeric 9 PR195 PR197
Employee Contains the employee number. Each PR560 PR82.1
person employed by the company is PR85.1
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 PR195 PR197
Current Payroll Year Contains the payroll year in which the PR560 PR82.1
allocation was taken. PR85.1
PHR-QUARTER Numeric 1 PR195 PR197
Quarter Contains the fiscal quarter for the PR560 PR82.1
data stored in this record. PR85.1
PHR-REPORT-ENTITY Alpha 5 PR195 PR197
Report Entity PR560 PR82.1
PR85.1
PHR-PROCESS-LEVEL Alpha 5 PR195 PR197
Process Level This field contains the process level, PR560 PR82.1
which is the reporting hierarchy below PR85.1
company.
PHR-CHECK-ID Numeric 12 PR195 PR197
Internal Check ID Contains the payment identification PR560 PR82.1
Number number (unique payment identifier used PR85.1
in tracking payment information).
PHR-PENS-DIST-CODE Alpha 1 PR195 PR197
Pens Dist Code PR560 PR82.1
PR85.1
PHR-PENS-DST-CODE2 Alpha 1 PR195 PR197
Pens Dst Code2 PR560 PR82.1
PR85.1
PHR-PENS-SEQ-NBR Numeric 4 PR195 PR197
Pens Seq Nbr PR560 PR82.1
PR85.1
PHR-PENS-DIST-TYPE Numeric 2 PR195 PR197
Pens Dist Type PR560 PR82.1
PR85.1
PHR-GROSS-DIST Signed 15.2 PR82.1 PR85.1
Gross Dist
PHR-TAXABLE-AMT Signed 15.2 PR195 PR197
Taxable Amount The taxable amount. PR560 PR82.1
PR85.1
PHR-ORD-INCOME Signed 15.2 PR195 PR197
Ord Income PR560 PR82.1
PR85.1
PHR-CAPITAL-GAIN Signed 15.2 PR195 PR197
Capital Gain PR560 PR82.1
PR85.1
PHR-FED-INC-TAX Signed 15.2 PR195 PR197
Fed Inc Tax PR560 PR82.1
PR85.1
PHR-EMP-CONTRIBUT Signed 15.2 PR195 PR197
Emp Contribut PR560 PR82.1
PR85.1
PHR-NET-UNR-GAIN Signed 15.2 PR195 PR197
Net Unr Gain PR560 PR82.1
PR85.1
PHR-PCT-TOTAL-DIST Numeric 3 PR195 PR197
Pct Total Dist PR560 PR82.1
PR85.1
PHR-LAST-RUN-DATE Numeric 8 (yyyymmdd) PR560
Last Run Date
PHR-OTHER Signed 15.2 PR195 PR197
Other PR82.1 PR85.1
PR1099RHST FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PHRSET1 COMPANY PR560
EMPLOYEE
PAYROLL-YEAR
QUARTER
REPORT-ENTITY
PROCESS-LEVEL
PENS-DIST-CODE
PENS-DST-CODE2
CHECK-ID
PENS-SEQ-NBR
PHRSET2 COMPANY
PAYROLL-YEAR
REPORT-ENTITY
PROCESS-LEVEL
EMPLOYEE
PENS-DIST-CODE
PENS-DST-CODE2
CHECK-ID
PENS-SEQ-NBR
PHRSET3 COMPANY
PAYROLL-YEAR
EMPLOYEE
REPORT-ENTITY
PROCESS-LEVEL
PENS-DIST-CODE
PENS-DST-CODE2
CHECK-ID
PENS-SEQ-NBR
PHRSET4 COMPANY PR85.1
EMPLOYEE
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
|