PA_RT_EMP_SETUP(SQL Table) |
Index Back |
|---|---|
Pension Payee SetupThis is an employee table for Retiree Admin. |
| # | 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 | EMPLID_PAYEE |
Character(11) | VARCHAR2(11) NOT NULL |
Payee EmplID
Prompt Table: PERSON_NAME |
| 4 | EMPL_RCD_PAYEE |
Number(3,0) | SMALLINT NOT NULL | Employment Rcd Nbr for Payee |
| 5 | BENEFIT_PLAN | Character(6) | VARCHAR2(6) NOT NULL |
Benefit Plan
Prompt Table: PA_PEN_PLAN_VW |
| 6 | DEPENDENT_BENEF | Character(2) | VARCHAR2(2) NOT NULL |
Dependent Benefit
01=default Prompt Table: DEPENDENT_VW |
| 7 | PA_PERS_DATA_SW | Character(1) | VARCHAR2(1) NOT NULL |
Personal Data
N=Outstanding Y=Completed Default Value: N |
| 8 | PA_JOB_SW | Character(1) | VARCHAR2(1) NOT NULL |
Job Record Saved
N=Outstanding Y=Completed Default Value: N |
| 9 | PA_PAYEE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Payee Type
B=Beneficiary Q=QDRO Alternate Payee R=Retiree T=Terminated Deferred Vested |
| 10 | COMMENTS | Long Character | CLOB | Comment |