EMPLIDEMPL_RCDPYMT_DTSEQNOACC=Accumulator
DED=Deductions
EAR=Earnings
GP_ERDD_CAT_VW(SQL View) |
Index Back |
|---|---|
GP Chatbot Earning DeductionGP Chatbot Earning Deduction |
| SELECT C.EMPLID ,C.EMPL_RCD ,C.PYMT_DT ,D.seqno ,C.PRD_BGN_DT ,C.PRD_END_DT ,A.GP_CATGRY_TYPE ,CASE WHEN A.GP_CATGRY_TYPE='EAR' THEN 'Earnings' WHEN A.GP_CATGRY_TYPE='DED' THEN 'Deductions' WHEN A.GP_CATGRY_TYPE='ACM' THEN 'Acumulators' END ,A.GP_CATEGORY_ID ,D.DESCR ,A.COUNTRY ,C.CAL_RUN_ID ,C.GP_PAYGROUP ,C.RUN_TYPE ,SUM(C.CALC_RSLT_VAL) ,E.JOBCODE_DESCR FROM PS_GP_CAT_CODE_TBL A ,PS_GP_MPSLP_STGED C ,PS_GP_CTGYSEL_TBL D ,PS_JOB_CURR_VW1 E WHERE C.PIN_NUM=A.PIN_NUM AND A.GP_CATGRY_TYPE=D.GP_CATGRY_TYPE AND A.GP_CATEGORY_ID=D.GP_CATEGORY_ID AND A.COUNTRY=D.COUNTRY AND C.CALC_RSLT_VAL > 0 AND E.EMPLID=C.EMPLID AND E.EMPL_RCD=C.EMPL_RCD GROUP BY C.EMPLID ,C.EMPL_RCD ,C.PRD_BGN_DT ,C.PRD_END_DT ,C.PYMT_DT ,A.GP_CATGRY_TYPE ,CASE WHEN A.GP_CATGRY_TYPE='EAR' THEN 'Earnings' WHEN A.GP_CATGRY_TYPE='DED' THEN 'Deductions' WHEN A.GP_CATGRY_TYPE='ACM' THEN 'Acumulators' END ,A.GP_CATEGORY_ID ,D.DESCR ,A.COUNTRY ,C.CAL_RUN_ID ,C.GP_PAYGROUP ,C.RUN_TYPE,d.seqno, E.JOBCODE_DESCR |
| # | 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 | PYMT_DT |
Date(10) | DATE | Payment Date |
| 4 | SEQNO |
Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 5 | PRD_BGN_DT | Date(10) | DATE | Period Begin Date |
| 6 | PRD_END_DT | Date(10) | DATE | Pay Period End Date |
| 7 | GP_CATGRY_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Category type for Chatbot category setup
ACC=Accumulator DED=Deductions EAR=Earnings |
| 8 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 9 | GP_CATEGORY_ID | Character(3) | VARCHAR2(3) NOT NULL | Category ID for Chatbot category setup |
| 10 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 11 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 12 | CAL_RUN_ID | Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 13 | GP_PAYGROUP | Character(10) | VARCHAR2(10) NOT NULL | Global Payroll pay group |
| 14 | RUN_TYPE | Character(10) | VARCHAR2(10) NOT NULL | Run Type Name |
| 15 | CALC_RSLT_VAL | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Calculation Numeric Result |
| 16 | JOBTITLE | Character(30) | VARCHAR2(30) NOT NULL | Job Title |