PR1099RSLH – No description in the Lawson data dictionary
- System
- Payroll (PR)
- Prefix
PSL- Primary key
COMPANY,EMPLOYEE,PAYROLL-YEAR,QUARTER,REPORT-ENTITY,PROCESS-LEVEL,PENS-DIST-CODE,PENS-DST-CODE2,CHECK-ID,PENS-SEQ-NBR,DED-CODE- Fields
- 13
- Updated by
- 7 programs
- Referenced by
- 3 programs
PR1099RSLH is a Lawson Payroll table (prefix PSL); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, PAYROLL-YEAR, QUARTER, REPORT-ENTITY, PROCESS-LEVEL, PENS-DIST-CODE, PENS-DST-CODE2, CHECK-ID, PENS-SEQ-NBR, DED-CODE (PSLSET1). It is related 1:1 to PRSYSTEM, DEDCODE, EMPLOYEE, PAYMASTR, PRCHECK and PRPENHIST and 1:M to PRPENFSRCH. It is updated by PR195, PR197, PR300, PR560, PR582, PR82.1 and PR85.1 and referenced by PR250, PR251 and PR253. The table has 13 fields, 1 index and 8 documented relations.
About PR1099RSLH
No description in the Lawson data dictionary.
Fields (13)
Column = COBOL field name without the PSL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PSL-COMPANY PKCOMPANY | Numeric 4 | — | PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PSL-EMPLOYEE PKEMPLOYEE | 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 |
PSL-PAYROLL-YEAR PKPAYROLL_YEAR | Numeric 4 | Contains the payroll year in which the allocation was taken. | PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PSL-QUARTER PKQUARTER | Numeric 1 | Contains the fiscal quarter for the data stored in this record. | PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PSL-REPORT-ENTITY PKREPORT_ENTITY | Alpha 5 | — | PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PSL-PROCESS-LEVEL PKPROCESS_LEVEL | Alpha 5 | — | PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PSL-CHECK-ID PKCHECK_ID | Numeric 12 | Contains the payment identification number (unique payment identifier used in tracking payment information). | PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PSL-PENS-DIST-CODE PKPENS_DIST_CODE | Alpha 1 | — | PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PSL-PENS-DST-CODE2 PKPENS_DST_CODE2 | Alpha 1 | — | PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PSL-PENS-SEQ-NBR PKPENS_SEQ_NBR | Numeric 4 | — | PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PSL-DED-CODE PKDED_CODE | Alpha 4 | — | PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PSL-TAX-AMTTAX_AMT | Signed 15.2 | — | PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
PSL-TAX-WAGE-AMTTAX_WAGE_AMT | Signed 15.2 | — | PR195, PR197, PR560, PR582, PR82.1, PR85.1 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PSLSET1 | COMPANY, EMPLOYEE, PAYROLL-YEAR, QUARTER, REPORT-ENTITY, PROCESS-LEVEL, PENS-DIST-CODE, PENS-DST-CODE2, CHECK-ID, PENS-SEQ-NBR, DED-CODE | Primary | PR195, PR197, PR250, PR251, PR253, PR300, PR560, PR582 +2 more |
Relations
One to one (7) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Company | PRSYSTEM | Required | PSL-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL | |
| Ded Code | DEDCODE | Required | PSL-COMPANY → DDC-COMPANY, PSL-DED-CODE → DDC-DED-CODE | |
| Employee | EMPLOYEE | Required | PSL-COMPANY → EMP-COMPANY, PSL-EMPLOYEE → EMP-EMPLOYEE | |
| Paymastr | PAYMASTR | Not Required | PSL-COMPANY → PYM-COMPANY, PSL-EMPLOYEE → PYM-EMPLOYEE, PSL-CHECK-ID → PYM-CHECK-ID | |
| Prcheck | PRCHECK | Not Required | PSL-COMPANY → PCH-COMPANY, PSL-EMPLOYEE → PCH-EMPLOYEE, PSL-PENS-SEQ-NBR → PCH-PENS-SEQ-NBR, PSL-CHECK-ID → PCH-CHECK-ID | |
| Process Level | PRSYSTEM | Required | PSL-COMPANY → PRS-COMPANY, PSL-PROCESS-LEVEL → PRS-PROCESS-LEVEL | |
| Prpenhist | PRPENHIST | Not Required | PSL-COMPANY → PNH-COMPANY, PSL-EMPLOYEE → PNH-EMPLOYEE, PSL-CHECK-ID → PNH-CHECK-ID, PSL-PENS-SEQ-NBR → PNH-PENS-SEQ-NBR |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Prpenfsrch | PRPENFSRCH | PSL-COMPANY → PFH-COMPANY, PSL-EMPLOYEE → PFH-EMPLOYEE, PSL-CHECK-ID → PFH-CHECK-ID, PSL-PENS-SEQ-NBR → PFH-PENS-SEQ-NBR, PFH-FUNDING-SOURCE |
Programs
Updated by (7)
- PR195 Accrual Program
- PR197 Payroll Close
- PR300 History Purge
- PR560 Payroll History Load CSV
- PR582 Mass Adjustment Load
- PR82.1 Adjustment
- PR85.1 Bank Account Reconciliation