PI_PROCESS_TBL

(SQL Table)
 Index Back

PYI Special Code Table

Payroll Interface Special Code Table

  • Related Language Record: PI_PROC_TB_LANG

  • Parent Record Of PI_PROCESS_VAL PI_PROC_VA_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PI_PROCESS_ID Character(6) VARCHAR2(6) NOT NULL PI Process ID
    2 PI_PROCESS_PHASE Character(1) VARCHAR2(1) NOT NULL PI Process Phase
    A=After Field Translation
    B=Before Field Translation
    C=Record Processing
    E=Export File Creation
    I=Import Processing
    3 PRCS_DESCR Long Character CLOB Process Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 PRCS_TYPE Character(1) VARCHAR2(1) NOT NULL Process Type
    F=Field Level
    R=Record Level
    6 USER_DEFINED_IND Character(1) VARCHAR2(1) NOT NULL User Defined Process

    Y/N Table Edit

    Default Value: N

    7 USER_EXIT Character(8) VARCHAR2(8) NOT NULL User Exit Program