SSR_ACMMAIN_INC

#	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_CW_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Mandatory Y/N Table Edit Default Value: Y
4	SSR_CW_TOPIC_APP	Character(1)	VARCHAR2(1) NOT NULL	Topic Approval Required Y/N Table Edit Default Value: N
5	SSR_ALLOW_OVERRIDE	Character(1)	VARCHAR2(1) NOT NULL	Allow Override or Substitution Y/N Table Edit
6	SSR_NO_MARK_DEF	Character(1)	VARCHAR2(1) NOT NULL	No Mark Option I=Blank Mark - Include T=Below Threshold - Exclude X=Blank Mark - Exclude Default Value: I
7	SSR_CW_NO_MRK_VAL	Number(8,3)	DECIMAL(7,3) NOT NULL	Minimum points for an assignment.
8	SSR_CW_NO_MRKTHRES	Number(8,3)	DECIMAL(7,3) NOT NULL	Minimum points for an assignment.
9	INCL_IN_MID_TERM	Character(1)	VARCHAR2(1) NOT NULL	Include for Mid Term Grade Y/N Table Edit Default Value: N
10	SSR_RESITS_ALLOWED	Character(1)	VARCHAR2(1) NOT NULL	This field indicates if resits are allowed. Y/N Table Edit
11	SSR_RESIT_RULE	Character(10)	VARCHAR2(10) NOT NULL	Resit Rule ID
12	SSR_SUP_RESIT	Character(1)	VARCHAR2(1) NOT NULL	This field indicates if resits are allowed. Y/N Table Edit Default Value: N
13	SSR_AC_RS_ITEMID	Character(10)	VARCHAR2(10) NOT NULL	Supplemental Resit Item Prompt Table: SSR_AC_SR_ITMVW
14	SSR_CW_TOT_ATMPT	Number(3,0)	SMALLINT NOT NULL	Allowable Number of Attempts Default Value: 0
15	SSR_RESIT_RFSL_OK	Character(1)	VARCHAR2(1) NOT NULL	This field indicates if resits are allowed. Y/N Table Edit Default Value: N
16	SSR_RESIT_CALC_OPT	Character(1)	VARCHAR2(1) NOT NULL	This field indicates if resits are allowed. A=Average All Marks H=Highest Mark L=Most Recent Mark Default Value: A
17	SSR_AC_RST_PRD_OPT	Character(2)	VARCHAR2(2) NOT NULL	Resit Period Option NE=Next Exam Period NP=Next Exam Regular Period NR=Next Exam Resit Period RE=Rules Engine SS=Student Selection
18	SSR_EXAMPRD_REG	Character(1)	VARCHAR2(1) NOT NULL	Regular Exam Y/N Table Edit Default Value: Y
19	SSR_EXAMPRD_RESIT	Character(1)	VARCHAR2(1) NOT NULL	Resit Exam Y/N Table Edit Default Value: N
20	SSR_AC_MAX_PRD_DSP	Number(3,0)	SMALLINT NOT NULL	Maximum Period to Display NE=Next Exam Period NR=Next Exam Resit Period RE=Rules Engine SS=Student Selection
21	SSR_CW_RELDAYS_OPT	Character(1)	VARCHAR2(1) NOT NULL	Relative Days Option C=Class Start Date S=Session Start Date T=Term Start Date Default Value: C
22	SSR_CW_REL_GRADE	Signed Number(4,0)	DECIMAL(3) NOT NULL	Grading Days
23	SSR_CW_REL_DUE	Signed Number(4,0)	DECIMAL(3) NOT NULL	Due Days
24	SSR_CW_REQ_INST	Character(1)	VARCHAR2(1) NOT NULL	Required by Institution Y/N Table Edit
25	SSR_CW_REL_START	Signed Number(4,0)	DECIMAL(3) NOT NULL	Start Days
26	SSR_PENALTY_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Late Penalty Type C=Capped D=Daily Penalty F=Fixed N=No Penalty O=One Time W=Weekly Default Value: N
27	SSR_LATE_PENALTY	Number(8,3)	DECIMAL(7,3) NOT NULL	Late Penalty
28	SSR_PENALTY_MAX	Number(8,3)	DECIMAL(7,3) NOT NULL	Penalty Maximum
29	SSR_PENALTY_MARK	Number(8,3)	DECIMAL(7,3) NOT NULL	Penalty Mark
30	SSR_AC_PNLTY_EXP	Character(1)	VARCHAR2(1) NOT NULL	Late Penalty Type Y/N Table Edit Default Value: N
31	SSR_AC_PNLTY_DAYS	Signed Number(4,0)	DECIMAL(3) NOT NULL	Days
32	SSR_RESIT_DURATION	Number(3,0)	SMALLINT NOT NULL	Resit Attempt Window Expires
33	SSR_CW_RST_EXP_OP	Character(1)	VARCHAR2(1) NOT NULL	Resit Expiration Date Options F=First Due Date L=Most Recent Due Date N=No Expiration S=Session End Date T=Term End Date Default Value: N
34	SSR_CW_YR_ATMPT	Number(3,0)	SMALLINT NOT NULL	Allowable Attempts Per Year
35	SSR_ACTIVITY_ID_RS	Character(11)	VARCHAR2(11) NOT NULL	Supplemental Activity Prompt Table: SSR_ACMCONTITVW
36	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
37	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
38	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
39	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time