BENEFIT_PLANPrompt Table: PA_BEN_PLAN_VW
EMPLIDPrompt Table: PERS_SRCH_GBL
Prompt Table: PA_DFN_SVC_VW
Prompt Table: PA_EACCT_VW
PA_SP_UPGR_VW(SQL View) |
Index Back |
|---|---|
Service Purchase upgrade data |
| SELECT DISTINCT A.BENEFIT_PLAN , A.EMPLID , B.SERVICE_FR_NAME , A.FUNCTN_RESULT_NM , B.PA_SVC_PURCHASED FROM PS_PA_EACCT_ACCUM A , PS_PA_EA_SVC_PRCH B WHERE A.EMPLID = B.EMPLID AND A.BENEFIT_PLAN = B.BENEFIT_PLAN AND A.FUNCTN_RESULT_NM = B.FUNCTN_RESULT_NM AND A.START_DATE = B.START_DATE AND A.END_BALANCE = 0 AND B.PA_SVC_PURCHASED > 0 |
| # | 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
| 3 | SVC_FUNCTN_RESULT | Character(10) | VARCHAR2(10) NOT NULL |
Benefit Service Functn Result
Prompt Table: PA_DFN_SVC_VW |
| 4 | FUNCTN_RESULT_NM | Character(10) | VARCHAR2(10) NOT NULL |
Function Result Name
Prompt Table: PA_EACCT_VW |
| 5 | AMT_TO_PURCH | Number(10,6) | DECIMAL(9,6) NOT NULL | Amount to Purchase |