SCRTY_GBRUN_VW

(SQL View)
 Index Back

SCRTY GB Prompt for Groups

prompts for permissable groups (as per GB setup by Operator ID and driving component). The component must be defined in GB security setup for the user

SELECT A.GB_GROUP_ID ,B.STATUS , B.DESCR FROM PS_SCRTY_GBREG_TBL A , ps_scrty_gbreg_vw B WHERE A.GB_GROUP_ID = B.GB_GROUP_ID

  • Related Language Record: SCRTY_GBPRMT_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
    2 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description