EMPLIDRCDORIG_EMPLIDB=Beneficiary
Q=QDRO Alternate Payee
R=Retiree
T=Terminated Deferred Vested
PA_RT_EMP_VW(SQL View) |
Index Back |
|---|---|
View for Retiree AdminThis is a working view. |
| select c.emplid_payee, c.empl_rcd_payee, c.emplid, c.pa_payee_type from PS_PA_RT_EMP_SETUP c |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | RCD |
Number(3,0) | SMALLINT NOT NULL | Empl |
| 3 | ORIG_EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Originating Emplid |
| 4 | PA_PAYEE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Payee Type
B=Beneficiary Q=QDRO Alternate Payee R=Retiree T=Terminated Deferred Vested |