BENEFIT_PLANEFFDTDefault Value: %date
Prompt Table: PA_DT_ALIAS_VW
Prompt Table: PA_DT_ALIAS_VW
Prompt Table: PA_DT_ALIAS_VW
Prompt Table: PA_EACCT_FUN_VW
Prompt Table: PA_CLC_SVC_DURV
Prompt Table: PA_CUSTOM9_VW
Prompt Table: PA_ACT_JOBLIST
PA_PLAN_ALIASES(SQL Table) |
Index Back |
|---|---|
Plan AliasesThis is a setup table containing the alias names associate with important plan dates. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | NRD_ALIAS_NAME | Character(10) | VARCHAR2(10) NOT NULL |
NRD Alias Name
Prompt Table: PA_DT_ALIAS_VW |
| 4 | ERD_ALIAS_NAME | Character(10) | VARCHAR2(10) NOT NULL |
ERD Alias Name
Prompt Table: PA_DT_ALIAS_VW |
| 5 | VST_ALIAS_NAME | Character(10) | VARCHAR2(10) NOT NULL |
Vesting date alias name
Prompt Table: PA_DT_ALIAS_VW |
| 6 | CONTRIB_NAME | Character(10) | VARCHAR2(10) NOT NULL |
Contrib History Name
Prompt Table: PA_EACCT_FUN_VW |
| 7 | DATE_OPTION | Character(10) | VARCHAR2(10) NOT NULL |
Duration Option
Prompt Table: PA_CLC_SVC_DURV |
| 8 | PA_SS_AUTOBEN_ELIG | Character(10) | VARCHAR2(10) NOT NULL |
Surviving Spouse Eligibility
Prompt Table: PA_CUSTOM9_VW |
| 9 | ACTIVE_DEFINITION | Character(10) | VARCHAR2(10) NOT NULL |
Active/Inactive job definition
Prompt Table: PA_ACT_JOBLIST |