SSR_ACTIVITY

(SQL Table)
 Index Back

Activity Record

Content Management Activity Record

  • Parent Record Of SSRACMCONTITLNG SSRACMCONTM_LNG SSRACMSTAFMSLNG SSR_ACMASGN_EXT SSR_ACMATND_INC SSR_ACMATND_SBR SSR_ACMCAP_INC SSR_ACMCAT_EXT SSR_ACMCOMP_EXT SSR_ACMCONT_ATT SSR_ACMCONT_ITM SSR_ACMCONT_MSG SSR_ACMDATE_INC SSR_ACMDEVS_INC SSR_ACMENRL_INC SSR_ACMERUL_INC SSR_ACMEXAM_EXT SSR_ACMEXAM_VW SSR_ACMEXCO_VW SSR_ACMEXINS2VW SSR_ACMEXMPR_VW SSR_ACMEXSC_VW SSR_ACMEX_INSVW SSR_ACMID_INC SSR_ACMID_SBR SSR_ACMMAIN_INC SSR_ACMMAIN_SBR SSR_ACMREG_SCTY SSR_ACMREQ_EXT SSR_ACMSCHD_INC SSR_ACMSCTN_VW SSR_ACMSTAF_INC SSR_ACMSTAF_MSG SSR_ACMSTFINWK

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSR_ACTIVITY_ID Character(11) VARCHAR2(11) NOT NULL Academic Activity ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    3 SSR_ACTIVTY_ID_PAR Character(11) VARCHAR2(11) NOT NULL Parent Activity ID
    4 SSR_AC_CONTX_TYPE Character(4) VARCHAR2(4) NOT NULL Academic Content Context Type
    CRSE=Coursework
    5 SSR_AC_CONTENT_TP Character(20) VARCHAR2(20) NOT NULL Academic Content Type

    Prompt Table: SSR_ACMITEMTPVW

    6 SSR_AC_CONTENT_ID Character(13) VARCHAR2(13) NOT NULL Activity Registry ID
    7 SSR_AC_ITEM_ID Character(10) VARCHAR2(10) NOT NULL Content Item ID
    8 SSR_ACTIVTY_ID_LNK Character(11) VARCHAR2(11) NOT NULL Linked Activity ID
    9 SSR_ACT_LINK_FLAG Character(1) VARCHAR2(1) NOT NULL Activity Link

    Y/N Table Edit

    Default Value: N

    10 SSR_AC_AGGRGT_CTR Number(5,0) INTEGER NOT NULL Aggregate Counter
    11 SSR_ACM_SORT_ORD Number(4,0) SMALLINT NOT NULL Sort Sequence

    Default Value: 100

    12 SSR_ACTY_GRP_ID Character(11) VARCHAR2(11) NOT NULL Activity Grouping ID
    13 SSR_ACM_MGR_CRTD Character(1) VARCHAR2(1) NOT NULL Manager Created Activity

    Y/N Table Edit

    Default Value: N

    14 SSR_AM_LSTTXN_DTTM DateTime(26) TIMESTAMP Last Change Transaction DTTM
    15 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    16 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    17 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    18 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time