PA_401A17_PARMS(SQL Table) |
Index Back |
---|---|
401(a)17This 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 |