EMPLIDEMPL_RCDPA_RUN_IDBENEFIT_PLANPrompt Table: PA_PEN_PLAN_VW
PA_PMT_NBRDefault Value: 1
EFFDTDefault Value: %date
PA_RT_ADJ_VW(SQL View) |
Index Back |
|---|---|
View for Payment AdjustmentsThis is a working view. |
| select distinct emplid, EMPL_RCD, pa_Run_id, benefit_plan, pa_pmt_nbr, effdt from PS_PA_RT_ADJ |
| # | 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 | PA_RUN_ID |
Character(10) | VARCHAR2(10) NOT NULL | Run ID |
| 4 | BENEFIT_PLAN |
Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table: PA_PEN_PLAN_VW |
| 5 | PA_PMT_NBR |
Number(2,0) | SMALLINT NOT NULL |
Payment Number
Default Value: 1 |
| 6 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |