ADP_RUN_PYGP_VW

(SQL View)
 Index Back

Run Pygrp View for ADP Connect

Payroll Interface Run Paygroup View for ADP Connection

SELECT PI_RUN_NUM ,COMPANY ,PAYGROUP ,PAY_END_DT ,PAY_BEGIN_DT ,PI_PYGRP_STATUS ,STATUS_DTTM ,COMPARE_DTTM ,PI_CONFIG_ID ,CHECK_DT ,COUNTRY ,CURRENCY_CD ,PAY_FREQUENCY FROM PS_PI_RUN_PYGRP

  • 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 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    13 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