PI_PARTIC

(SQL Table)
 Index Back

PYI Participant Output

Payroll Interface Export Participant (Employee) Output

  • Parent Record Of PI_PARTIC_EXPT PI_PARTIC_EXTBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 PI_RUN_NUM Number(4,0) SMALLINT NOT NULL Payroll Interface Run Number

    Prompt Table: PI_RUN_TBL

    4 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    5 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group

    Prompt Table: PAYGROUP_TBL

    6 PAY_END_DT Date(10) DATE NOT NULL Pay Period End Date

    Prompt Table: PAY_CALENDAR

    7 PI_SYSTEM_ID Character(4) VARCHAR2(4) NOT NULL Payroll Interface System ID

    Prompt Table: PI_SYSTEM_TBL

    8 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
    A=Active
    D=Deceased
    L=Leave of Absence
    P=Leave With Pay
    Q=Retired With Pay
    R=Retired
    S=Suspended
    T=Terminated
    U=Terminated With Pay
    V=Terminated Pension Pay Out
    W=Short Work Break
    X=Retired-Pension Administration
    9 PI_CONFIG_ID Character(6) VARCHAR2(6) NOT NULL PI Configuration ID
    10 PI_EMPLID Character(20) VARCHAR2(20) NOT NULL Payroll Interface EMPLID
    11 PI_PARTIC_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Interface Status
    C=Compared
    E=Compare Error
    P=In Progress
    12 PI_CHANGE_IND Character(1) VARCHAR2(1) NOT NULL Payroll Interface Change Ind
    N=No
    P=Process Change
    Y=Yes
    13 PI_CHANGE_TYPE Character(1) VARCHAR2(1) NOT NULL PI Change Type
    D=Data Changes
    N=New Employees
    P=Process Control
    R=Reactive Pay
    T=Terminated Pay
    14 STATUS_DTTM DateTime(26) TIMESTAMP Status Date & Time
    15 LAST_EXPORT_SEQ Number(3,0) SMALLINT NOT NULL Last Export Sequence
    16 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country