PY_PAY011_VW

(SQL View)
 Index Back

Payroll Error Message View

This view shows the list of payroll error messages generated from PAY011 process.

SELECT A.COMPANY , A.PAYGROUP , A.PAY_END_DT , A.OFF_CYCLE , A.PAGE_NUM , A.LINE_NUM , A.ADDL_NBR , A.SEPCHK , A.MSGDATA1 , A.MSGDATA2 , A.MSGDATA3 , A.AUDIT_SEQNUM , A.EMPLID , A.EMPL_RCD , A.EMPL_NAME , A.DEPTID , A.BUSINESS_UNIT , A.RUN_ID , A.OPRID , A.LASTUPDDTTM , A.COUNTRY_CD , A.INDUSTRY_SECTOR , B.DESCRLONG FROM PS_PY_AUDITS A , PS_PAY_MESSAGE_TBL B WHERE A.PROGRAM_SRC = 'PAY011' AND A.MESSAGE_ID = B.MSGID

  • Related Language Record: PY_PAY011_VWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
    3 PAY_END_DT Date(10) DATE Pay Period End Date
    4 OFF_CYCLE Character(1) VARCHAR2(1) NOT NULL Off Cycle ?
    5 PAGE_NUM Number(5,0) INTEGER NOT NULL Page Nbr
    6 LINE_NUM Number(3,0) SMALLINT NOT NULL Line Nbr
    7 ADDL_NBR Number(3,0) SMALLINT NOT NULL Additional Pay Line Nbr
    8 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    9 MSGDATA1 Character(30) VARCHAR2(30) NOT NULL Message Data
    10 MSGDATA2 Character(30) VARCHAR2(30) NOT NULL Message Data
    11 MSGDATA3 Character(30) VARCHAR2(30) NOT NULL Message Data
    12 AUDIT_SEQNUM Number(5,0) INTEGER NOT NULL WorkCenter audit report sequence number.
    13 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    14 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    15 EMPL_NAME Character(50) VARCHAR2(50) NOT NULL Employee Name
    16 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    17 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    18 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID
    19 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    20 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    21 COUNTRY_CD Character(3) VARCHAR2(3) NOT NULL Country Code
    22 INDUSTRY_SECTOR Character(4) VARCHAR2(4) NOT NULL Industry Sector
    CORE=Core
    PBSC=Public Sector
    USFG=US Federal Government
    23 MESSAGE_TEXT_LONG Long Character CLOB Message Text This field refers to the Text for a particular Message Number in the Message Catalog.