EMPLIDPrompt Table: PERSON_NAME
BENEFIT_PLANPrompt Table: PA_SP_CNFG_BP
PA_SP_SRCH_GBL(SQL View) |
Index Back |
|---|---|
Service purchase Serarch VWService purchase Serarch VW, used on service to purchase component. |
| SELECT A.EMPLID , A.BENEFIT_PLAN , C.NAME FROM PS_PA_PELG_HIST A , PS_PA_SP_CNFG_BP B , PS_PERS_SRCH_GBL C WHERE A.benefit_plan = B.Benefit_plan AND C.EMPLID = A.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON_NAME |
| 2 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table: PA_SP_CNFG_BP |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |