PI_RUN_TBL

(SQL Table)
 Index Back

Payroll Interface Run Table

Payroll Interface Run Table

  • Parent Record Of ADP_RUN_PYGP_VW PI_RUN_PYGRP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PI_RUN_NUM Number(4,0) SMALLINT NOT NULL Payroll Interface Run Number
    2 PI_RUN_TYPE Character(1) VARCHAR2(1) NOT NULL Payroll Interface Run Type
    E=Export
    I=Import
    3 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID
    4 PI_RUN_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Interface Run Status
    C=Completed
    I=In Progress
    R=Ready

    Default Value: R

    5 STATUS_DTTM DateTime(26) TIMESTAMP Status Date & Time
    6 EXPORT_CHG_FULL Character(1) VARCHAR2(1) NOT NULL Export Change or Full
    C=Changes Only
    F=Full Set of Records

    Default Value: C

    7 EXCLUDE_DEDCALC Character(1) VARCHAR2(1) NOT NULL Exclude Calculated Deductions

    Y/N Table Edit

    Default Value: N

    8 ACTIVE_EMPL Character(1) VARCHAR2(1) NOT NULL Active Employees

    Y/N Table Edit

    9 PI_SELECT_TYPE Character(1) VARCHAR2(1) NOT NULL Selection Process Type
    A=Manually Select
    C=Smart Select
    D=All Employees in Group

    Default Value: D