EMPLIDEMPL_RCDGPGB_CO_ORD_REFGPGB_CB_CO_VW(SQL View) |
Index Back |
|---|---|
GPUK Chatbot Court Order ViewGPUK Chatbot Court Order View |
| SELECT a.emplid ,a.empl_rcd ,a.gpgb_co_ord_ref , x.xlatlongname ,CASE WHEN a.gpgb_co_leg = 'EW' THEN ( SELECT descr FROM ps_gpgb_co_ew_tbl WHERE gpgb_co_order=a.gpgb_co_order) WHEN a.gpgb_co_leg = 'NI' THEN ( SELECT descr FROM ps_gpgb_co_ni_tbl WHERE gpgb_co_order=a.gpgb_co_order) WHEN a.gpgb_co_leg = 'SC' THEN ( SELECT descr FROM ps_gpgb_co_SC_tbl WHERE gpgb_co_order=a.gpgb_co_order) END AS descr,a.start_date, CASE WHEN a.GPGB_CO_AMT_PAYBLE = 0 THEN a.gpgb_co_ndr ELSE a.GPGB_CO_AMT_PAYBLE END ,E1.jobcode_descr FROM ps_gpgb_ee_co_Dtl a,psxlatitem x ,PS_JOB_CURR_VW1 E1 WHERE x.fieldname='GPGB_CO_LEG' AND x.fieldvalue=a.gpgb_co_leg AND active_flag='A' 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 | GPGB_CO_ORD_REF |
Character(25) | VARCHAR2(25) NOT NULL | GPUK Court Order Reference |
| 4 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 7 | GPGB_CO_AMT_PAYBLE | Number(9,2) | DECIMAL(8,2) NOT NULL | GPUK Court Amount Payable |
| 8 | JOBTITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |