EMPLIDEMPL_RCDBENEFIT_PLANPrompt Table: %BEN_PLAN_EDIT
PA_PMT_NBRPrompt Table: PA_RT_EMP_FORM
N=Do not Delete
Y=Mark to Delete
PA_RT_SCHED_VW(SQL View) |
Index Back |
|---|---|
Pension Payment Schedule |
| SELECT DISTINCT emplid , EMPL_RCD , benefit_plan , pa_pmt_nbr , ' ' FROM PS_PA_RT_PAY_SCHED |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table: %BEN_PLAN_EDIT |
| 4 | PA_PMT_NBR |
Number(2,0) | SMALLINT NOT NULL |
Payment Number
Prompt Table: PA_RT_EMP_FORM |
| 5 | DELETE_ON_SAVE | Character(1) | VARCHAR2(1) NOT NULL |
Select for Delete
N=Do not Delete Y=Mark to Delete |