PY_KB_CN_EXC

(SQL Table)
 Index Back

Payroll INS CAN Exceptions

Payroll Insights Canada Exceptions

  • Related Language Record: PY_KB_CN_EXC_LN

    • # 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 PY_ER_TYPE Character(1) VARCHAR2(1) NOT NULL Category Type
    1=Payroll
    4=Presheet
    5=Precalc
    6=Preconfirm
    A=Active Employees w/o Payline
    I=Inactive Employees w/Payline
    L=Local Data Missing
    M=Multiple Provinces on Cheque
    O=OK to Pay Turned Off
    P=Payline Employee
    Q=Unconfirmed Cheques Prior Run
    S=State Tax Data Missing
    U=Unconfirmed Checks Prior Run
    9 PY_MESSAGE_ID Character(30) VARCHAR2(30) NOT NULL Message ID
    10 AUDIT_SEQNUM Number(5,0) INTEGER NOT NULL WorkCenter audit report sequence number.
    11 PY_EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    12 PY_EMPL_RCD Number(3,0) SMALLINT NOT NULL Employee Record
    13 PY_RUN_ID Character(10) VARCHAR2(10) NOT NULL Run ID
    14 PAY_BEGIN_DT Date(10) DATE Pay Period Begin Date
    15 PY_ER_CAT Character(1) VARCHAR2(1) NOT NULL Payroll Error Category
    E=Error
    I=Informational
    N=Not Applicable
    W=Warning
    16 PY_MSGTEXTLONG Long Character CLOB Message Text This field refers to the Text for a particular Message Number in the Message Catalog.
    17 PY_COMPANY_DESCR Character(100) VARCHAR2(100) NOT NULL Company description
    18 PY_PAYGROUP_DESCR Character(100) VARCHAR2(100) NOT NULL Paygroup Description
    19 PY_RUNID_DESCR Character(100) VARCHAR2(100) NOT NULL Pay Run ID description