BENEFIT_PLANPrompt Table: PA_BEN_PLAN_VW
FUNCTN_NAMEPrompt Table: PA_FUNCTN
FUNCTN_RESULT_NMSERVICE_FR_NAMEPrompt Table: PA_PLAN_SVC_VW
PA_EA_SV_FR_TBL(SQL Table) |
Index Back |
|---|---|
Function Result AliasThis is a setup table containing Function Result Aliases. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table: PA_BEN_PLAN_VW |
| 2 | FUNCTN_NAME |
Character(10) | VARCHAR2(10) NOT NULL |
Function Name
Prompt Table: PA_FUNCTN |
| 3 | FUNCTN_RESULT_NM |
Character(10) | VARCHAR2(10) NOT NULL | Function Result Name |
| 4 | SERVICE_FR_NAME |
Character(10) | VARCHAR2(10) NOT NULL |
Service Function Result.
Prompt Table: PA_PLAN_SVC_VW |