EMPLIDEMPL_RCDGPGB_TAX_BGN_YRPAY_ENTITYGPGB_CB_P60_VW(SQL View) |
Index Back |
|---|---|
GPUK P60 ViewGPUK P60 View |
| SELECT a.emplid ,a.empl_Rcd , gpgb_tax_bgn_yr ,a.pay_entity , gpgb_er_name , hcsc_report_dt ,'Your P60 Details for the Tax Year ' %Concat %NumToChar(gpgb_tax_bgn_yr) ,E1.jobcode_descr FROM ps_gpgb_p60_rpt a , ps_gpgb_pyent b ,PS_JOB_CURR_VW1 E1 WHERE a.pay_entity = b.pay_entity 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_TAX_BGN_YR |
Number(4,0) | SMALLINT NOT NULL | Tax Year Begins In This Calendar Year |
| 4 | PAY_ENTITY |
Character(10) | VARCHAR2(10) NOT NULL | Pay Entity |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | PAYMENT_DT | Date(10) | DATE | Payment Date |
| 7 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 8 | JOBTITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |