SSR_ACMGRSTOVRD(SQL Table) |
Index Back |
---|---|
Activity Manager OverrideOverride Activity Manager Structural Updates (from Activity Definition) |
# | 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 |