EMPLIDBENEFIT_PLANPrompt Table: PA_PEN_PLAN_VW
EFFDTDefault Value: %date
Prompt Table: PA_CLC_EMP_EDIT
PA_RT_EMP_CMNT(SQL Table) |
Index Back |
|---|---|
Pension Payee CommentsThis is an employee table for Retiree Admin. |
| # | 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_PEN_PLAN_VW |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | CALC_NAME | Character(20) | VARCHAR2(20) NOT NULL |
Calculation Name
Prompt Table: PA_CLC_EMP_EDIT |
| 5 | COMMENTS | Long Character | CLOB | Comment |