PA_401A17_PARMS

(SQL Table)
Index Back

401(a)17

This is a setup table for 401(a)17 parameters.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 LIMIT_USE_NAME Character(10) VARCHAR2(10) NOT NULL Limit Use Name
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 LIMIT_OPTIONS Character(1) VARCHAR2(1) NOT NULL Earnings are Limited on a
C=12 Consecutive Month Basis
P=Period by Period Basis
R=Rolling Monthly Average
U=User Code
Y=Year to Date Basis

Default Value: P

4 CONSEC_FRACTION Character(1) VARCHAR2(1) NOT NULL To Limit non-Annual Periods
E=Limit Each Period
P=Reduce Proportionately
U=User Code

Default Value: P

5 LIMIT_EFFDT Character(1) VARCHAR2(1) NOT NULL Limits are Aligned by
C=Calendar Year
P=Plan Year

Default Value: C

6 CARRY_BACK Character(1) VARCHAR2(1) NOT NULL Use Carry Back Rules
N=No Carry Back
O=Min OBRA93 Limit ($150,000)
T=Min TRA86 Limit ($200,000)
U=User Code

Default Value: N

7 PROJECT_COLA Character(1) VARCHAR2(1) NOT NULL Project with 401(a)(17) COLA
8 PRORATE_PARTIAL Character(1) VARCHAR2(1) NOT NULL Prorate Over Partial Periods

Y/N Table Edit

Default Value: N

9 PRORATE_SHORT Character(1) VARCHAR2(1) NOT NULL Prorate Over Short Plan Years

Y/N Table Edit

Default Value: N

10 TBL_LOOKUP_NAME Character(10) VARCHAR2(10) NOT NULL Table Lookup Alias Name

Prompt Table: PA_TBL_INT_SRCH

11 LIMIT_START_YEAR Character(4) VARCHAR2(4) NOT NULL Limit Start Year