GP_WC_ERROR

(SQL View)
 Index Back

GP WC Payroll Error Message

GP WC Payroll Error Message

SELECT C.EMPLID , C.CAL_ID , D.FIRST_NAME , D.LAST_NAME , C.EMPL_RCD , E.LAST_HIRE_DT , E.TERMINATION_DT , E.COMPANY , E.BUSINESS_UNIT , E.DEPTID , E.ESTABID , F.DESCR , E13X.XLATLONGNAME , E14X.XLATLONGNAME , C.GP_PAYGROUP , E.EMPL_CLASS , E.FTE , REPLACE( REPLACE(REPLACE(REPLACE(REPLACE( B.MESSAGE_TEXT ,'%1' , A.MSGDATA1) ,'%2' , A.MSGDATA2) ,'%3' , A.MSGDATA3) ,'%4' , A.MSGDATA4) ,'%5' , A.MSGDATA5) , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.GP_MSG_SEVERITY , A.CAL_RUN_ID FROM (((PS_GP_MESSAGES A ) LEFT OUTER JOIN PSMSGCATDEFN B ON B.MESSAGE_SET_NBR = A.MESSAGE_SET_NBR AND B.MESSAGE_NBR = A.MESSAGE_NBR ) LEFT OUTER JOIN (PS_GP_PYE_SEG_STAT H ) ON A.CAL_RUN_ID = H.CAL_RUN_ID AND A.EMPLID = H.EMPLID AND A.EMPL_RCD = H.EMPL_RCD AND A.CAL_ID = H.CAL_ID AND A.GP_PAYGROUP = H.GP_PAYGROUP AND H.RSLT_SEG_NUM = A.RSLT_SEG_NUM ) , ((PS_GP_PYE_PRC_STAT C ) LEFT OUTER JOIN PS_PERSON_NAME D ON C.EMPLID = D.EMPLID ) , ((PS_JOB E ) LEFT OUTER JOIN PS_LOCATION_TBL F ON F.LOCATION = E.LOCATION ) LEFT OUTER JOIN ( SELECT * FROM PSXLATITEM TA WHERE TA.FIELDNAME='HR_STATUS' AND TA.EFF_STATUS = 'A' AND TA.EFFDT = ( SELECT MAX(EFFDT) FROM PSXLATITEM TB WHERE TB.FIELDNAME='HR_STATUS' AND TA.FIELDVALUE=TB.FIELDVALUE AND TB.EFF_STATUS = 'A' AND TB.EFFDT <= %CurrentDateIn)) E13X ON E13X.FIELDVALUE = E.HR_STATUS AND E13X.FIELDNAME='HR_STATUS' LEFT OUTER JOIN ( SELECT * FROM PSXLATITEM TA WHERE TA.FIELDNAME='EMPL_STATUS' AND TA.EFF_STATUS = 'A' AND TA.EFFDT = ( SELECT MAX(EFFDT) FROM PSXLATITEM TB WHERE TB.FIELDNAME='EMPL_STATUS' AND TA.FIELDVALUE=TB.FIELDVALUE AND TB.EFF_STATUS = 'A' AND TB.EFFDT <= %CurrentDateIn)) E14X ON E14X.FIELDVALUE = E.EMPL_STATUS AND E14X.FIELDNAME='EMPL_STATUS' WHERE ( ( A.CAL_RUN_ID = C.CAL_RUN_ID AND A.EMPLID = C.EMPLID AND A.EMPL_RCD = C.EMPL_RCD AND A.GP_PAYGROUP = C.GP_PAYGROUP AND C.EMPLID = E.EMPLID AND C.EMPL_RCD = E.EMPL_RCD AND C.GP_PAYGROUP = E.GP_PAYGROUP AND F.EFFDT = ( SELECT MAX(F_ED.EFFDT) FROM PS_LOCATION_TBL F_ED WHERE F.SETID = F_ED.SETID AND F.LOCATION = F_ED.LOCATION AND F_ED.EFFDT <= E.EFFDT) AND EXISTS ( SELECT G.GP_PAYGROUP FROM PS_GP_WC_USR_PYGRP G WHERE ( G.GP_PAYGROUP = C.GP_PAYGROUP )) AND A.GP_MSG_SEVERITY = 'E' AND C.CALC_TYPE = 'P' AND C.PRD_TYPE = 'C' AND E.EFFDT <= CASE WHEN H.SEG_END_DT IS NULL THEN C.PRD_END_DT ELSE H.SEG_END_DT END ))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
3 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
6 LAST_HIRE_DT Date(10) DATE Latest Start Date - The latest time that an Employee or a Contingent Worker has started - based on EMPLID/EMPL_RCD.
7 TERMINATION_DT Date(10) DATE Termination Date
8 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
10 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
11 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
12 DESCR Character(30) VARCHAR2(30) NOT NULL Description
13 HR_STATUS_DESCR Character(30) VARCHAR2(30) NOT NULL HR Status
14 EMPL_STATUS_DESCR Character(30) VARCHAR2(30) NOT NULL Employee Status
15 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
16 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification
17 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
18 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description
19 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
20 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
21 GP_MSG_SEVERITY Character(1) VARCHAR2(1) NOT NULL Message Severity. Shows the severity of a message after a calculation. Stored in GP_MESSAGES
E=Error
W=Warning
22 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id