SSR_AC_REG_HDR

(SQL Table)
 Index Back

Activity Registry Header

Activity Registry Content Header Record (Activity Registry).

  • Related Language Record: SSR_AC_RHDR_LNG

  • Parent Record Of SSR_ACINCL_OVRD SSR_ACMGROVTEMP SSR_ACMGRSTOVRD SSR_ACMGRSTOVVW SSR_AC_REG_SCTY

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSR_AC_CONTENT_ID Character(13) VARCHAR2(13) NOT NULL Activity Registry ID
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 END_EFFDT Date(10) DATE End Effdt
    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 SSR_AC_CONTX_TYPE Character(4) VARCHAR2(4) NOT NULL Academic Content Context Type
    CRSE=Coursework

    Default Value: CRSE

    7 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    8 SSR_AC_ITEM_PREFIX Character(4) VARCHAR2(4) NOT NULL Content Item Prefix

    Default Value: INSTALLATION_SA.SSR_AC_ITEM_PREFIX

    9 SSR_AC_ITEM_STEP Number(4,0) SMALLINT NOT NULL Content Item Step

    Default Value: INSTALLATION_SA.SSR_AC_ITEM_STEP

    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