EMPLIDBENEFIT_PLANPrompt Table: PA_PLAN_VW
FUNCTN_RESULT_NMPrompt Table: PA_FR_STRTUP_VW
PA_STRTUP_HISTO(SQL Table) |
Index Back |
|---|---|
Plan Start Up HistoryThis is an employee table for Startup History. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table: PA_PLAN_VW |
| 3 | FUNCTN_RESULT_NM |
Character(10) | VARCHAR2(10) NOT NULL |
Function Result Name
Prompt Table: PA_FR_STRTUP_VW |
| 4 | START_UP_DATE | Date(10) | DATE NOT NULL | Start Up Date. |
| 5 | START_UP_AMOUNT | Number(15,4) | DECIMAL(14,4) NOT NULL | Start Up Amount. |
| 6 | ACCUM_PRE_TAX | Number(14,2) | DECIMAL(13,2) NOT NULL | Pre-Tax Account Balance |
| 7 | ACCUM_POST_TAX | Number(14,2) | DECIMAL(13,2) NOT NULL | Post-Tax Account Balance |
| 8 | ACCUM_POST_TAX_INT | Number(14,2) | DECIMAL(13,2) NOT NULL | Post-Tax Interest Account Balance |
| 9 | ACCUM_PRE_TAX_INT | Number(14,2) | DECIMAL(13,2) NOT NULL | Pre-Tax Interest Account Balance |