SSR_ACMGRSTOVVW

(SQL View)
 Index Back

Activity Manager Override

Override Activity Manager Structural Updates (from Activity Definition)

SELECT A.SSR_AC_CONTENT_ID ,A.INSTITUTION ,A.EFFDT ,B.SSR_AC_CONTENT_TP ,'N' ,'N' ,'N' ,'N' ,'N' ,'N' ,'N' ,'N' ,'N' ,'N' ,'N' ,'N' ,'N' ,'N' ,'N' ,'N' ,'N' ,'N' ,'N' ,'N' ,'N' ,'N' ,'N' ,'N' ,'N' ,'N' ,'PS' ,%CurrentDateTimeIn ,'PS' ,%CurrentDateTimeIn FROM PS_SSR_AC_REG_HDR A , PS_SSR_AC_ITEMTYPE B WHERE A.SSR_AC_CONTX_TYPE = B.SSR_AC_CONTX_TYPE AND B.SSR_CONTEXT_ACTIVE = 'Y'

  • Parent record: SSR_AC_REG_HDR

    • # 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
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 SSR_AC_CONTENT_TP Character(20) VARCHAR2(20) NOT NULL Academic Content Type
    5 SSR_AC_STRUCT_UPD Character(1) VARCHAR2(1) NOT NULL Allow Structural Updates

    Y/N Table Edit

    Default Value: N

    6 SSR_AC_OVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Content Definition

    Y/N Table Edit

    Default Value: N

    7 SSR_AC_ST_UPD_FAC Character(1) VARCHAR2(1) NOT NULL Allow Structural Updates

    Y/N Table Edit

    8 SSR_AC_OVERRIDE_FC Character(1) VARCHAR2(1) NOT NULL Override Content Definition

    Y/N Table Edit

    9 SSR_AC_MISC_FAC Character(1) VARCHAR2(1) NOT NULL General Options

    Y/N Table Edit

    Default Value: N

    10 SSR_AC_MISC_FOV Character(1) VARCHAR2(1) NOT NULL General Override

    Y/N Table Edit

    11 SSR_AC_LATE_FAC Character(1) VARCHAR2(1) NOT NULL Late Content Penalty Options

    Y/N Table Edit

    Default Value: N

    12 SSR_AC_LATE_FOV Character(1) VARCHAR2(1) NOT NULL Late Content Override

    Y/N Table Edit

    13 SSR_AC_RESIT_FAC Character(1) VARCHAR2(1) NOT NULL Resit Options

    Y/N Table Edit

    Default Value: N

    14 SSR_AC_RESIT_FOV Character(1) VARCHAR2(1) NOT NULL Resit Override

    Y/N Table Edit

    15 SSR_AC_DATES_FAC Character(1) VARCHAR2(1) NOT NULL Dates and Durations

    Y/N Table Edit

    Default Value: N

    16 SSR_AC_DATES_FOV Character(1) VARCHAR2(1) NOT NULL Dates Override

    Y/N Table Edit

    17 SSR_AC_CAPS_FAC Character(1) VARCHAR2(1) NOT NULL Content Capping Options

    Y/N Table Edit

    Default Value: N

    18 SSR_AC_CAPS_FOV Character(1) VARCHAR2(1) NOT NULL Content Capping Override

    Y/N Table Edit

    19 SSR_AC_SCHED_FAC Character(1) VARCHAR2(1) NOT NULL Scheduling Options

    Y/N Table Edit

    Default Value: N

    20 SSR_AC_SCHED_FOV Character(1) VARCHAR2(1) NOT NULL Scheduling Override

    Y/N Table Edit

    21 SSR_AC_STAFF_FAC Character(1) VARCHAR2(1) NOT NULL Staffing Requirements

    Y/N Table Edit

    Default Value: N

    22 SSR_AC_STAFF_FOV Character(1) VARCHAR2(1) NOT NULL Staffing Override

    Y/N Table Edit

    23 SSR_AC_ID_FAC Character(1) VARCHAR2(1) NOT NULL Forms of Identification

    Y/N Table Edit

    Default Value: N

    24 SSR_AC_ID_FOV Character(1) VARCHAR2(1) NOT NULL Form of ID Override

    Y/N Table Edit

    25 SSR_AC_DEVS_FAC Character(1) VARCHAR2(1) NOT NULL Content Devices

    Y/N Table Edit

    Default Value: N

    26 SSR_AC_DEVS_FOV Character(1) VARCHAR2(1) NOT NULL Devices Override

    Y/N Table Edit

    27 SSR_AC_INSF_FAC Character(1) VARCHAR2(1) NOT NULL Insufficient Mark Options

    Y/N Table Edit

    Default Value: N

    28 SSR_AC_INSF_FOV Character(1) VARCHAR2(1) NOT NULL Insufficient Mark Override

    Y/N Table Edit

    29 SSR_AC_ATT_FAC Character(1) VARCHAR2(1) NOT NULL Attendance Tracking Options

    Y/N Table Edit

    Default Value: N

    30 SSR_AC_ATT_FOV Character(1) VARCHAR2(1) NOT NULL Attendance Override

    Y/N Table Edit

    31 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    32 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    33 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    34 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time