PGM_APPLAREA_AC

(SQL View)
 Index Back

Active Application Areas

This is the prompt view for selecting all active Application Areas.

SELECT A.SETID , A.APPLICATION_AREA , A.DESCR FROM PS_PGM_APPLAREA A WHERE A.EFF_STATUS = 'A'

  • Related Language Record: PGM_APPLAREA_LG

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

    Prompt Table: SP_SETID_NONVW

    2 APPLICATION_AREA Character(10) VARCHAR2(10) NOT NULL The general area in which an application belongs. Examples: "Financials", "Human Resources", etc.
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description