SAVINGS_403B_EE(SQL Table) |
Index Back |
|---|---|
EE Svgs 403b (Obsolete)OBSOLETE! This table is obsolete as of Release 8.8. It contains "frozen" data that was not upgraded. It is retained for historical queries only and should not be edited. This table is no longer maintained by PeopleSoft and will be dropped during a subsequent release. -------------------------------------------------- This table stores employees 403(b) Balances and Projections information. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
| 2 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 3 | CALENDAR_YEAR |
Number(4,0) | SMALLINT NOT NULL | Calendar Year |
| 4 | SAVINGS_PLAN_TYPE |
Character(4) | VARCHAR2(4) NOT NULL |
Identifies the type of savings plan, such as 403(b), 457, 401(k).
403B=403b Plans 457=457 Plans Default Value: 403B |
| 5 | LTD_SERVICE_YEARS | Number(8,5) | DECIMAL(7,5) NOT NULL | Service Years LTD |
| 6 | YTD_SERVICE_YEARS | Number(8,5) | DECIMAL(7,5) NOT NULL | Service Years YTD |
| 7 | GRS_YTD | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Gross Earnings YTD |
| 8 | GRS_YTD_ADJ | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | Gross Earnings YTD Adjusted |
| 9 | DED_YTD | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Deduction Balance YTD |
| 10 | DED_YTD_NON_ELECT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Ded YTD Non-Elect |
| 11 | DED_YTD_ER | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Ded YTD Employer |
| 12 | DED_LTD | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Deduction Balance LTD |
| 13 | DED_LTD_NON_ELECT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Ded LTD Non Elect |
| 14 | DED_LTD_ER | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Ded LTD Employer |
| 15 | DED_ADJ | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Deduction Adjustment Balance field. |
| 16 | DED_ADJ_NON_ELECT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Deduction Balance Non-Elect |
| 17 | DED_ADJ_ER | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Deduction Balance Employer |
| 18 | DED_ADJ_PA | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Deduction Adj from PA |
| 19 | ELECTION_DT | Date(10) | DATE | Election Date |
| 20 | ALT_ELECTION | Character(1) | VARCHAR2(1) NOT NULL |
415 Alternative Election
A=Last Year of Service B=Any Year Rule C=Overall Limit N=No Alternative Election Default Value: N |
| 21 | SERVICE_YRS_OVRD | Character(1) | VARCHAR2(1) NOT NULL |
Override Service Years Calc
Y/N Table Edit Default Value: N |
| 22 | PROJ_402G_CAP_EXT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Elective Deferrals Limit |
| 23 | YTD_402G_CAP_USED | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | 402(g) Cap Extension Used YTD |
| 24 | LTD_402G_CAP_USED | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | 402(g) Cap Extension Used LTD |
| 25 | YTD_402G_DED | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | 402(g) Deduction Year to Date |
| 26 | LTD_402G_DED | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | 402(g) Deductions LTD |
| 27 | YTD_415_DED | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | 415 Deductions YTD |
| 28 | PROJ_DED | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Exclusion Allowance |
| 29 | PROJ_DED_ER_LMT | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Employer Contribution Limit |
| 30 | PROJ_DED_ALTA | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Proj Year of Sep Excl Limit |
| 31 | PROJ_DED_ALTB | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Any Year Excl Limit |
| 32 | PROJ_DED_ALTC | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Overall Excl Limit |
| 33 | LIMIT_REDUCTN_402G | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | Limit Reduction Amount |
| 34 | HARDSHIP_WTHD_DT | Date(10) | DATE | Hardship Withdrawal Date |
| 35 | ALT_402G_ELECTION | Character(1) | VARCHAR2(1) NOT NULL |
Elect 402(g) Cap Expansion
N=No X=Automatic Election Y=Yes Default Value: N |
| 36 | TERMINATION_DT | Date(10) | DATE | Termination Date |
| 37 | ELECT_457_CATCH_UP | Character(1) | VARCHAR2(1) NOT NULL |
457 plan election for "Catch Up" limit processing.
Y/N Table Edit Default Value: N |
| 38 | UNDERUTIL_457_LMTS | Signed Number(12,2) | DECIMAL(10,2) NOT NULL | The amount that the 457 plan limit has been underutilized for all eligible years of participation. |
| 39 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 40 | LAST_UPDATE_DATE | Date(10) | DATE | Date of last update |