SSR_AC_ITEMTYPE

#	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 Default Value: CRSE
2	SSR_AC_CONTENT_TP	Character(20)	VARCHAR2(20) NOT NULL	Academic Content Type
3	SSR_CONTEXT_ACTIVE	Character(1)	VARCHAR2(1) NOT NULL	Content Active Flag Y/N Table Edit Default Value: Y
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCR20	Character(20)	VARCHAR2(20) NOT NULL	Description
6	SSR_AC_ROOT	Character(1)	VARCHAR2(1) NOT NULL	Content Root Y/N Table Edit Default Value: N
7	SSR_ITEM_LVL	Number(4,0)	SMALLINT NOT NULL	Item Order
8	SYSTEM_DATA_FLG	Character(1)	VARCHAR2(1) NOT NULL	This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA. Y/N Table Edit Default Value: N
9	SSR_HAS_ITEMS	Character(1)	VARCHAR2(1) NOT NULL	Child Academic Items Y/N Table Edit Default Value: Y
10	SSR_HAS_ITEMS_SAME	Character(1)	VARCHAR2(1) NOT NULL	Self-Reference Allowed Y/N Table Edit Default Value: N
11	SSR_AC_RESTRICTED	Character(1)	VARCHAR2(1) NOT NULL	Restricted Child Y/N Table Edit Default Value: N
12	SSR_AC_VALIDREG	Character(1)	VARCHAR2(1) NOT NULL	Valid for Registry Y/N Table Edit Default Value: Y
13	SSR_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Extension Record
14	SSR_AC_VALIDMGR	Character(1)	VARCHAR2(1) NOT NULL	Valid for Manager Y/N Table Edit Default Value: Y
15	SSR_ACM_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Extension Record
16	SSR_AC_STRUCT_UPD	Character(1)	VARCHAR2(1) NOT NULL	Allow Structural Updates Y/N Table Edit Default Value: Y
17	SSR_AC_ST_UPD_FAC	Character(1)	VARCHAR2(1) NOT NULL	Allow Structural Updates Y/N Table Edit Default Value: N
18	SSR_IAM_ACTYACTN	Character(1)	VARCHAR2(1) NOT NULL	Activity Actions Y/N Table Edit Default Value: N
19	SSR_AC_VALIDIAM	Character(1)	VARCHAR2(1) NOT NULL	Valid for Individual Manager Y/N Table Edit Default Value: Y
20	SSR_IAM_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Extension Record
21	SSR_AC_MISC_OK	Character(1)	VARCHAR2(1) NOT NULL	General Content OK Y/N Table Edit Default Value: Y
22	SSR_AC_MISC_INC	Character(1)	VARCHAR2(1) NOT NULL	General Options Y/N Table Edit Default Value: N
23	SSR_AC_MISC_FAC	Character(1)	VARCHAR2(1) NOT NULL	General Options Y/N Table Edit Default Value: Y
24	SSR_AC_LATE_OK	Character(1)	VARCHAR2(1) NOT NULL	Late Content Penalty OK Y/N Table Edit Default Value: Y
25	SSR_AC_LATE_INC	Character(1)	VARCHAR2(1) NOT NULL	Late Content Penalty Options Y/N Table Edit Default Value: N
26	SSR_AC_LATE_FAC	Character(1)	VARCHAR2(1) NOT NULL	Late Content Penalty Options Y/N Table Edit Default Value: Y
27	SSR_AC_RESIT_OK	Character(1)	VARCHAR2(1) NOT NULL	Resit Content OK Y/N Table Edit Default Value: Y
28	SSR_AC_RESIT_INC	Character(1)	VARCHAR2(1) NOT NULL	Resit Options Y/N Table Edit Default Value: N
29	SSR_AC_RESIT_FAC	Character(1)	VARCHAR2(1) NOT NULL	Resit Options Y/N Table Edit Default Value: Y
30	SSR_AC_ENROLL_OK	Character(1)	VARCHAR2(1) NOT NULL	Enrollment Content OK Y/N Table Edit Default Value: Y
31	SSR_AC_ENROLL_INC	Character(1)	VARCHAR2(1) NOT NULL	Enrollment Related Options Y/N Table Edit Default Value: N
32	SSR_AC_DATES_OK	Character(1)	VARCHAR2(1) NOT NULL	Date Content OK Y/N Table Edit Default Value: Y
33	SSR_AC_DATES_INC	Character(1)	VARCHAR2(1) NOT NULL	Dates and Durations Y/N Table Edit Default Value: N
34	SSR_AC_DATES_FAC	Character(1)	VARCHAR2(1) NOT NULL	Dates and Durations Y/N Table Edit Default Value: Y
35	SSR_AC_CAPS_OK	Character(1)	VARCHAR2(1) NOT NULL	Mark Capping OK Y/N Table Edit Default Value: Y
36	SSR_AC_CAPS_INC	Character(1)	VARCHAR2(1) NOT NULL	Content Capping Options Y/N Table Edit Default Value: N
37	SSR_AC_CAPS_FAC	Character(1)	VARCHAR2(1) NOT NULL	Content Capping Options Y/N Table Edit Default Value: Y
38	SSR_AC_SCHED_OK	Character(1)	VARCHAR2(1) NOT NULL	Scheduling Content OK Y/N Table Edit Default Value: Y
39	SSR_AC_SCHED_INC	Character(1)	VARCHAR2(1) NOT NULL	Scheduling Options Y/N Table Edit Default Value: N
40	SSR_AC_SCHED_FAC	Character(1)	VARCHAR2(1) NOT NULL	Scheduling Options Y/N Table Edit Default Value: Y
41	SSR_AC_STAFF_OK	Character(1)	VARCHAR2(1) NOT NULL	Staffing Content OK Y/N Table Edit Default Value: Y
42	SSR_AC_STAFF_INC	Character(1)	VARCHAR2(1) NOT NULL	Staffing Requirements Y/N Table Edit Default Value: N
43	SSR_AC_STAFF_FAC	Character(1)	VARCHAR2(1) NOT NULL	Staffing Requirements Y/N Table Edit Default Value: Y
44	SSR_AC_ID_OK	Character(1)	VARCHAR2(1) NOT NULL	Acceptable ID Content OK Y/N Table Edit Default Value: Y
45	SSR_AC_ID_INC	Character(1)	VARCHAR2(1) NOT NULL	Forms of Identification Y/N Table Edit Default Value: N
46	SSR_AC_ID_FAC	Character(1)	VARCHAR2(1) NOT NULL	Forms of Identification Y/N Table Edit Default Value: Y
47	SSR_AC_DEVS_OK	Character(1)	VARCHAR2(1) NOT NULL	Allowable Devices Content OK Y/N Table Edit Default Value: Y
48	SSR_AC_DEVS_INC	Character(1)	VARCHAR2(1) NOT NULL	Content Devices Y/N Table Edit Default Value: N
49	SSR_AC_DEVS_FAC	Character(1)	VARCHAR2(1) NOT NULL	Content Devices Y/N Table Edit Default Value: Y
50	SSR_AC_INSF_OK	Character(1)	VARCHAR2(1) NOT NULL	Insufficient Mark Content OK Y/N Table Edit Default Value: Y
51	SSR_AC_INSF_INC	Character(1)	VARCHAR2(1) NOT NULL	Insufficient Mark Options Y/N Table Edit Default Value: N
52	SSR_AC_INSF_FAC	Character(1)	VARCHAR2(1) NOT NULL	Insufficient Mark Options Y/N Table Edit Default Value: Y
53	SSR_AC_ATT_OK	Character(1)	VARCHAR2(1) NOT NULL	Attendance Content OK Y/N Table Edit Default Value: Y
54	SSR_AC_ATT_INC	Character(1)	VARCHAR2(1) NOT NULL	Attendance Tracking Options Y/N Table Edit Default Value: N
55	SSR_AC_ATT_FAC	Character(1)	VARCHAR2(1) NOT NULL	Attendance Tracking Options Y/N Table Edit Default Value: Y
56	SSR_ACM_LINK	Character(1)	VARCHAR2(1) NOT NULL	Activity Link Y/N Table Edit Default Value: N
57	SSR_AC_ENTITY_ID	Character(40)	VARCHAR2(40) NOT NULL	Entitiy ID Prompt Table: SCC_ENTITY_PT
58	SSR_ACM_ENTITY_ID	Character(40)	VARCHAR2(40) NOT NULL	Entitiy ID Prompt Table: SCC_ENTITY_PT
59	SSR_IAM_ENTITY_ID	Character(40)	VARCHAR2(40) NOT NULL	Entitiy ID Prompt Table: SCC_ENTITY_PT
60	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
61	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
62	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
63	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time