PY_KB_CN_CAT

(SQL Table)
Index Back

Payroll Insights CN Categories

Payroll Insights Canada Categories

  • Related Language Record: PY_KB_CN_CAT_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 SEPCHK Number(2,0) SMALLINT NOT NULL Separate check number.
    8 PY_CAT_TYPE Character(1) VARCHAR2(1) NOT NULL Category Type
    D=Deductions
    E=Earnings
    O=Other Earnings
    T=Taxes
    V=Overtime
    9 PY_CAT_ID Character(6) VARCHAR2(6) NOT NULL Category ID
    10 CHECK_DT Date(10) DATE Check date.
    11 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    12 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    13 PY_EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    14 PY_EMPL_RCD Number(3,0) SMALLINT NOT NULL Employee Record
    15 PY_EMPL_TYPE Character(1) VARCHAR2(1) NOT NULL Employee Type
    E=Exception Hourly
    H=Hourly
    N=Not Applicable
    S=Salaried
    16 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    17 PROVINCE Character(6) VARCHAR2(6) NOT NULL Province
    18 PY_CAT_TYPE_DESCR Character(30) VARCHAR2(30) NOT NULL Category Type Description
    19 PY_CAT_ID_DESCR Character(30) VARCHAR2(30) NOT NULL Category ID Description
    20 PY_TOT_CAT Signed Number(19,2) DECIMAL(17,2) NOT NULL Total by Category
    21 PY_COMPANY_DESCR Character(100) VARCHAR2(100) NOT NULL Company description
    22 PY_PAYGROUP_DESCR Character(100) VARCHAR2(100) NOT NULL Paygroup Description
    23 PY_BUS_DESCR Character(100) VARCHAR2(100) NOT NULL Business Unit description
    24 PY_DEPT_DESCR Character(100) VARCHAR2(100) NOT NULL Department description
    25 PY_STATE_DESCR Character(30) VARCHAR2(30) NOT NULL State Description