EMPLIDEMPL_RCDAVC1=AVC1
FIXA=Fixed Scheme A
PCTB=Percentage Scheme B
GPGB_CB_PEN_VW(SQL View) |
Index Back |
|---|---|
GPUK Pension ViewGPUK Pension View |
| SELECT a.emplid ,a.empl_Rcd , a.start_date ,a.gpgb_ee_pctg_cont ,e.gpgb_pen_a_status ,s1.descr ,s2.gpgb_pen_scheme ,E1.jobcode_descr FROM ps_gpgb_ee_pension a ,ps_gpgb_pen_events e ,ps_GPGB_PNSCL0_TBL s1 ,ps_GPGB_PNSCL1_TBL s2 ,PS_JOB_CURR_VW1 E1 WHERE a.start_date =( SELECT MAX(start_date) FROM ps_gpgb_ee_pension WHERE emplid=a.emplid AND empl_Rcd=a.empl_rcd) AND a.emplid=e.emplid AND a.empl_rcd=e.empl_Rcd AND e.gpgb_prcrn_date =( SELECT MAX(gpgb_prcrn_Date) FROM ps_gpgb_pen_events WHERE emplid=e.emplid AND empl_rcd=e.empl_Rcd) AND s1.gpgb_qpen_scheme=a.gpgb_pen_Scheme AND s2.gpgb_qpen_scheme=s1.gpgb_qpen_Scheme AND s2.effdt=( SELECT MAX(effdt) FROM ps_gpgb_pnscl1_tbl WHERE gpgb_qpen_Scheme=s2.gpgb_qpen_Scheme) AND E1.emplid=a.emplid AND E1.empl_Rcd = a.empl_Rcd |
| # | 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 Record |
| 3 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 4 | GPGB_EE_PCTG_CONT | Number(6,2) | DECIMAL(5,2) NOT NULL | Employee's Percentage Contribution |
| 5 | GPGB_PEN_A_STATUS | Character(50) | VARCHAR2(50) NOT NULL | Pension Applicant Status GBR |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | GPGB_PEN_SCHEME | Character(4) | VARCHAR2(4) NOT NULL |
Pension Scheme Code
AVC1=AVC1 FIXA=Fixed Scheme A PCTB=Percentage Scheme B |
| 8 | JOBTITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |