OPRIDCALC_NAMEEMPLIDPrompt Table: PERS_SRCH_GBL
BENEFIT_PLANPA_CLC_TMP_SRCH(SQL View) |
Index Back |
|---|---|
Calc Results Search Record |
| SELECT DISTINCT c.OPRID ,a.calc_name ,a.emplid ,a.benefit_plan FROM ps_pa_clc_dates a , ps_pa_clc_srch_3 b , PS_PERS_SRCH_GBL C WHERE a.calc_name = b.calc_name AND A.EMPLID = C.EMPLID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | CALC_NAME |
Character(20) | VARCHAR2(20) NOT NULL | Calculation Name |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
| 4 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL | Benefit Plan |