SCRTY_TBL_INST

(SQL Table)
 Index Back

OprID Access to Institutions

Security table for Academic Institution.

  • Parent Record Of SCRTY_APPL_CTR SCRTY_RECR_CTR SCRTY_TBL_CAR

    • # 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 Institution field to store institution information in campus solution system.

    Prompt Table: INSTITUTION_TBL

    3 ACCESS_CD Character(1) VARCHAR2(1) NOT NULL Access Code
    N=No Access
    R=Read Only Access
    Y=Read/Write Access

    Default Value: Y

    4 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    5 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    6 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    7 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    8 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    9 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time