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