PI_RUN_PYGRP

(SQL Table)
 Index Back

Payroll Int. Run Pygrp Table

Payroll Interface Run Paygroup Table

  • Parent record: PI_RUN_TBL

    • # 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 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    3 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
    4 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date
    5 PAY_BEGIN_DT Date(10) DATE NOT NULL Pay Period Begin Date
    6 PI_PYGRP_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Interface Pygrp Status
    C=Compared
    E=Exported
    I=Imported
    L=Initial Load
    P=In Progress
    R=Ready

    Default Value: R

    7 STATUS_DTTM DateTime(26) TIMESTAMP Status Date & Time
    8 COMPARE_DTTM DateTime(26) TIMESTAMP Date and Time of Last Compare
    9 PI_CONFIG_ID Character(6) VARCHAR2(6) NOT NULL PI Configuration ID
    10 CHECK_DT Date(10) DATE Check date.
    11 PI_BALANCE_ID Character(2) VARCHAR2(2) NOT NULL Balance ID
    12 PI_BALANCE_YEAR Number(4,0) SMALLINT NOT NULL PI Balances for Year
    13 PI_BALANCE_QTR Number(3,0) SMALLINT NOT NULL PI Balances for Quarter
    14 PI_BALANCE_PERIOD Number(3,0) SMALLINT NOT NULL PI Balances for Period
    15 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    16 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    17 PAY_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Pay Frequency
    A=Annual
    B=Biweekly
    D=Daily
    M=Monthly
    Q=Quarterly
    S=Semimonthly
    W=Weekly

    Prompt Table: FREQUENCY_TBL

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