PGMRCA_SETUP_AC

(SQL View)
 Index Back

Root Cause Area Setup View

Root Cause Area Setup for Change request, This view shows all active entries

SELECT SETID ,ROOT_CAUSE_AREA ,DESCR FROM PS_PGM_RCA_SETUP WHERE STATUS = 'A'

  • Related Language Record: PGMRCA_SETUP_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 ROOT_CAUSE_AREA Character(5) VARCHAR2(5) NOT NULL ROOT_CAUSE_AREA
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description