SSR_AC_CONTEXT

(SQL Table)
 Index Back

Activity Content Definition

Activity Content Definition record used in Activity Management (Activity Definition).

  • Parent Record Of SSRACMITMOLNGVW SSR_ACM_ITMOVVW SSR_AC_ITEMCHLD SSR_AC_ITEMCLVW SSR_AC_ITEMCVW SSR_AC_ITEMPAR SSR_AC_ITEMPLVW SSR_AC_ITEMPVW SSR_AC_ITEMTYPE SSR_AC_UPD_TPVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSR_AC_CONTX_TYPE Character(4) VARCHAR2(4) NOT NULL Academic Content Context Type
    CRSE=Coursework
    2 SSR_RECNAME Character(15) VARCHAR2(15) NOT NULL Extension Record
    3 SSR_SEC_TAG_TYPE1 Character(4) VARCHAR2(4) NOT NULL Security Tag 1 Type
    NONE=No Security Tags
    ORG=Academic Organization
    ROLE=Role Based

    Default Value: NONE

    4 SSR_SEC_TAG_PRMPT1 Character(15) VARCHAR2(15) NOT NULL Security Tag 1 Prompt Record

    Prompt Table: SSR_AC_SECRECVW

    5 SSR_SEC_TAG_TYPE2 Character(4) VARCHAR2(4) NOT NULL Security Tag 2 Type
    NONE=No Security Tags
    ORG=Academic Organization
    ROLE=Role Based

    Default Value: NONE

    6 SSR_SEC_TAG_PRMPT2 Character(15) VARCHAR2(15) NOT NULL Security Tag 2 Prompt Record

    Prompt Table: SSR_AC_SECRECVW

    7 SSR_SEC_TAG_TYPE3 Character(4) VARCHAR2(4) NOT NULL Security Tag 3 Type
    NONE=No Security Tags
    ORG=Academic Organization
    ROLE=Role Based

    Default Value: NONE

    8 SSR_SEC_TAG_PRMPT3 Character(15) VARCHAR2(15) NOT NULL Security Tag 3 Prompt Record

    Prompt Table: SSR_AC_SECRECVW

    9 SSR_AC_SYNC_ACTIVE Character(1) VARCHAR2(1) NOT NULL IAM Sync Active

    Y/N Table Edit

    Default Value: Y

    10 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    11 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    12 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    13 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time