COMPANYGPBR_CAT_TYP201=Initial
02=Reopened
03=Death Communication
04=All
EMPLIDGPBR_EMP_CI3_VW(SQL View) |
Index Back |
|---|---|
Search Employees ViewSearch Employees View |
| SELECT DISTINCT DRV.COMPANY , CASE WHEN XRF.CAT_TYPE_BRA = '1' THEN '01' WHEN XRF.CAT_TYPE_BRA = '2' THEN '02' WHEN XRF.CAT_TYPE_BRA = '3' THEN '03' END , XRF.EMPLID , NAM.NAME FROM PS_GPBR_DRVCAT_XRF XRF , PS_GPBR_DRIVER_DAT DRV , PS_NAMES NAM WHERE XRF.EMPLID = NAM.EMPLID AND NAME_TYPE = 'PRI' AND NAM.EFFDT = ( SELECT MAX(NAM2.EFFDT) FROM PS_NAMES NAM2 WHERE NAM2.EMPLID = NAM.EMPLID AND NAM2.NAME_TYPE = NAM.NAME_TYPE AND NAM2.EFFDT <= DRV.GPBR_ES_PS) AND DRV.GPBR_DRIVER_SEQ = XRF.GPBR_DRIVER_SEQ AND XRF.GPBR_EVENT_CD = 'S-2210' UNION SELECT DISTINCT DRV.COMPANY , '04' , XRF.EMPLID , NAM.NAME FROM PS_GPBR_DRVCAT_XRF XRF , PS_GPBR_DRIVER_DAT DRV , PS_NAMES NAM WHERE XRF.EMPLID = NAM.EMPLID AND NAME_TYPE = 'PRI' AND NAM.EFFDT = ( SELECT MAX(NAM2.EFFDT) FROM PS_NAMES NAM2 WHERE NAM2.EMPLID = NAM.EMPLID AND NAM2.NAME_TYPE = NAM.NAME_TYPE AND NAM2.EFFDT <= DRV.GPBR_ES_PS) AND DRV.GPBR_DRIVER_SEQ = XRF.GPBR_DRIVER_SEQ AND XRF.GPBR_EVENT_CD = 'S-2210' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | GPBR_CAT_TYP2 |
Character(2) | VARCHAR2(2) NOT NULL |
CAT Type Form
01=Initial 02=Reopened 03=Death Communication 04=All |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |