PI_PROCESS_VW

(SQL View)
 Index Back

Distinct view pi_process_tbl

Selective view of PI_PROCESS_TBL to show a distinct list of the available Process IDs by type (Record or Field)

select DISTINCT PRCS_TYPE, PI_PROCESS_ID, DESCRSHORT, USER_DEFINED_IND from PS_PI_PROCESS_TBL

  • Related Language Record: PI_PROC_LANG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PRCS_TYPE Character(1) VARCHAR2(1) NOT NULL Process Type
    F=Field Level
    R=Record Level
    2 PI_PROCESS_ID Character(6) VARCHAR2(6) NOT NULL PI Process ID
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 USER_DEFINED_IND Character(1) VARCHAR2(1) NOT NULL User Defined Process