SCRTY_TBL_SR_VW

(SQL View)
 Index Back

OprID Access - Srvc Indicators

SCRTY_TBL_SRVC is used for data security purposes. It identifies who can set and release service indicators. Service indicators control the services that are provided to individuals.

SELECT OPRID ,INSTITUTION ,SRVC_IND_CD ,SRVC_IND_REASON ,HOLD_PLACEMENT ,HOLD_RELEASE FROM PS_SCRTY_TBL_SRVC

  • 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).

    Prompt Table: OPRDEFN2

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: SCRTY_TBL_INST

    3 SRVC_IND_CD Character(3) VARCHAR2(3) NOT NULL Service Indicator Cd

    Prompt Table: SRVC_IND_CD_TBL

    4 SRVC_IND_REASON Character(5) VARCHAR2(5) NOT NULL Service Indicator Reason

    Prompt Table: SRVC_IN_RSN_TBL

    5 HOLD_PLACEMENT Character(1) VARCHAR2(1) NOT NULL Hold Placement Authorization

    Y/N Table Edit

    6 HOLD_RELEASE Character(1) VARCHAR2(1) NOT NULL Hold Release Authorization

    Y/N Table Edit