EMPLIDEMPL_RCDBENEFIT_PLANPrompt Table: PA_PEN_PLAN_VW
PA_PMT_NBRDefault Value: 1
EFFDTDefault Value: %date
PA_SEQ_NUMDefault Value: 1
PA_CONTR_RLO_VW(SQL View) |
Index Back |
|---|---|
Contribution Withdrawal ViewThis is an employee table for Retiree Admin. |
| SELECT EMPLID , EMPL_RCD , BENEFIT_PLAN , PA_PMT_NBR , EFFDT , PA_SEQ_NUM FROM PS_PA_CONTR_RLOVR |
| # | 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: PA_PEN_PLAN_VW |
| 4 | PA_PMT_NBR |
Number(2,0) | SMALLINT NOT NULL |
Payment Number
Default Value: 1 |
| 5 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | PA_SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL |
Sequence Number
Default Value: 1 |