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 | 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 |