SCRTY_TBL_STGP

(SQL Table)
Index Back

Operator Stdnt Groups

This table contains the Student Groups which the operator is allowed to view and / or update.

  • Parent record: SCRTY_TBL_INST
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: OPR_DEF_TBL_CS.OPRID

    Prompt Table: PSOPRDEFN

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: SCRTY_TBL_INST

    3 STDNT_GROUP Character(4) VARCHAR2(4) NOT NULL Student Group

    Prompt Table: STDNT_GROUP_TBL

    4 INQUIRY_USE_IND Character(1) VARCHAR2(1) NOT NULL Inquiry Indicator

    Y/N Table Edit

    Default Value: N

    5 ENTRY_USE_IND Character(1) VARCHAR2(1) NOT NULL Update Indicator

    Y/N Table Edit

    Default Value: N