COMM_SPDKEY_VW1

(SQL View)
 Index Back

Operator Comm Speed Key Vw

This view is used to provide 3C group prompting security when setting up the operator communication keys. It is used as the prompt record on the field COMM_KEY from record OPR_COMM_SPDKEY and placed on panel OPR_SPDKEY_FUNC.

SELECT DISTINCT B.OPRID, A.INSTITUTION, A.ADMIN_FUNCTION, A.COMM_KEY, A.DESCR, A.COMM_CATEGORY FROM PS_COMM_SPDKEY_TBL A, PS_OPR_GRP_3C_TBL B, PS_COMM_GRP_3C_TBL C WHERE A.INSTITUTION = B.INSTITUTION AND B.ENTRY_USE_IND = 'Y' AND A.INSTITUTION = C.INSTITUTION AND A.COMM_CATEGORY = C.COMM_CATEGORY AND B.GROUP_3C = C.GROUP_3C

  • Related Language Record: COM_SPDKYVW1_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function

    Prompt Table: ADM_FUNCTN_TBL

    4 COMM_KEY Character(8) VARCHAR2(8) NOT NULL Communication Speed Key

    Prompt Table: COMM_SPDKEY_TBL

    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 COMM_CATEGORY Character(6) VARCHAR2(6) NOT NULL Communication Category

    Prompt Table: COMM_CATG_TBL