PRTAXLEVY – Payroll Tax Levy
- System
- Payroll (PR)
- Prefix
TXL- Primary key
TAX-ID-CODE,LEVY-YEAR,LEVY-FILING-ST,LEVY-EXEMPTS- Fields
- 6
- Updated by
- 2 programs
- Referenced by
- 124 programs
PRTAXLEVY is the Payroll Tax Levy table in Lawson Payroll (prefix TXL). It is indexed by TAX-ID-CODE, LEVY-YEAR, LEVY-FILING-ST, LEVY-EXEMPTS (TXLSET1). It is related 1:1 to PRTAXAUTH. It is updated by HR100 and PR10.1 and referenced by BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 and 116 more. The table has 6 fields, 1 index and 1 documented relation.
About PRTAXLEVY
Contains the information that makes up the tax table used for tax levies.
Fields (6)
Column = COBOL field name without the TXL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#TXL-LEVY-YEAR PKLEVY_YEAR | Numeric 4 | Contains the year that identifies the IRS table. | PR10.1 |
#TXL-LEVY-FILING-ST PKLEVY_FILING_ST | Alpha 1 | Contains the levy filing status. | PR10.1 |
#TXL-LEVY-EXEMPTS PKLEVY_EXEMPTS | Numeric 2 | Contains the number of levy exemptions. | PR10.1 |
#TXL-LEVY-EXEMP-AMTLEVY_EXEMP_AMT | Signed 6.2 Occurs 4 Times ×4 | Contains the levy exemption amount. | PR10.1 |
#TXL-TAX-ID-CODE PKTAX_ID_CODE | Alpha 10 | — | PR10.1 |
#TXL-TXL-TYPETXL_TYPE | Alpha 1 | — | — |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
TXLSET1 |
| Primary | BN100, BN101, BN102, BN103, BN104, BN105, BN145, BN150 +22 more (list truncated in source) |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||
|---|---|---|---|---|---|---|---|
| Prtaxauth | PRTAXAUTH | Required |
|
Programs
Updated by (2)
Referenced by (124)
- BN100 Employee Change Benefit Update
- BN101 Mass Benefit Add
- BN102 Plan Employee Update
- BN103 Mass Benefit Termination
- BN104 Frequency Table Update
- BN105 Plan Update
- BN145 Flex Dollars Calculation
- BN150 Life Insurance Reportable Income
- BN245 Benefit Election Form
- BN305 Highly Compensated Employees
- BN31.1 Speed Benefit Entry
- BN31.2 Employee Benefit Entry
- BN32.1 Employee Benefit Changes
- BN32.2 Employee Benefit Detail Changes
- BN32.3 Benefit Add
- BN45.1 Employee Flex Credits
- BN531 Batch Benefit Enrollment
- BN65.1 Election Simulation
- BN66.1 Estimated Pay Calculation
- BN71.1 COBRA Benefit Entry
- BN72.1 Retiree Benefit Entry
- BS10.1 Web Enrollment Current Benefit Inquiry
- BS12.1 Web Enrollment Eligible New Plans
- BS13.1 Web Enrollment Coverage Options
- BS14.1 Web Enrollment Coverage Amounts
- BS15.1 Web Enrollment Contribution Limits
- BS32.1 Web Enrollment Stop Benefits Update
- EXI2.1 Invoke for PRTRDPD
- EXI4.1 Invoke for PRPRBPD
- HR11.1 Employee
- HR11.2 Compensation Analysis
- HR11.4 Employee Assignment Inquiry
- HR28.1 Employee Ethnicity
- HR511 Employee Conversion
- LP130 Absence Plan Payout
- LT101 HRM Receiver Update
- LT111 HRM Receiver Update
- PA02.1 Position
- PA100 Action Update
- PA102 Position Update
- PA115 Employee Purge
- PA13.1 Multiple Positions and Jobs
- PA13.2 Multiple Position and Job History
- PA502 Position Conversion
- PA513 Position and Job Conversion
- PA52.1 Individual Action
- PA52.3 Mass Action
- PA52.4 Hire an Applicant
- PA52.5 Position and Job Action
- PR110 Step And Grade Audit
- PR113 United States Tax Deduction Update
- PR12.6 Employee Automatic Deposit
- PR120 Mass Pay Update
- PR128 Offset Time Record Creation
- PR13.1 Employee United States Taxes
- PR13.2 Employee United States Taxes
- PR13.5 Employee Canada Taxes
- PR13.6 Employee Canada Taxes
- PR13.8 U.S. Tax Deduction Errors
- PR13.9 Employee Additional Tax Details
- PR131 Retroactive Pay Calculation
- PR132 FLSA Overtime Calculation
- PR134 Automatic Time Records
- PR135 Time Record Edit
- PR136 Missing Time Records
- PR137 Batch Time Record Update
- PR139 Arrears Automation
- PR14.1 Employee Deduction
- PR14.2 Tax Withholding Lock-In
- PR140 Earnings and Deductions Calculation
- PR15.1 Deduction Speed Entry
- PR15.2 Employee Deduction Speed Entry
- PR189 Gross Up Calculation
- PR195 Accrual Program
- PR205 Deduction Listing
- PR210 Tax Levy Table Listing
- PR26.1 United States Employee Garnishment
- PR26.2 United States Employee Garnishment Inquiry
- PR29.1 Pension Payment Maintenance
- PR30.2 Employee Automatic Time Record
- PR32.1 Employee Daily Time Entry
- PR32.2 Employee Daily Time Entry
- PR33.1 Speed Entry Setup
- PR33.2 Speed Entry by Number
- PR33.3 Speed Entry by Name
- PR35.1 Time Entry
- PR35.2 Detail Time Entry
- PR35.3 Speed Time Entry
- PR35.4 Step and Grade, Grade Range Time Entry
- PR35.5 Attendance Time Entry
- PR35.6 Activity Time Entry
- PR35.8 Position Time Entry
- PR35.9 Reason Code Time Entry
- PR36.1 Time Record Entry
- PR36.4 Manual Time Record Maintenance
- PR37.1 Batch Time Control
- PR39.1 One Time Deduction
- PR39.2 One Time Deduction Speed
- PR45.1 Error Processing
- PR47.1 Canada Employee Garnishment
- PR47.2 Canada Employee Garnishment Inquiry
- PR512 Employee ACH Distribution Interface
- PR514 Employee Deduction Master Load
- PR521 Nonstandard Pay and Work Period CSV Load
- PR529 Pension Payroll Conversion
- PR530 Time Record Interface CSV
- PR539 One Time Deduction Load
- PR560 Payroll History Load CSV
- PR582 Mass Adjustment Load
- PR80.1 Manual Check
- PR80.3 Manual Payment One Time Deduction
- PR80.4 Manual Payment
- PR82.1 Adjustment
- PR89.1 Payment Modeling
- PRAT.1 Alltax connection test
- TA147 Canada Vacation Audit
- UK102 Bonus Pay Update
- ZB10.1 Coverage Options Calculator
- ZB31.1 Speed Benefit Entry
- ZB31.2 Employee Benefit Entry
- ZB32.1 Employee Benefit Changes
- ZB32.2 Employee Benefit Detail Changes
- ZB32.3 Benefit Add
- ZH510 Update PCP from ZPENDPCP