MultipleMeasuresDomains 1.1

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	Domain	table_name/ object_name	column/property/element	column_description	PII Level (NIST)	Obfuscate	Encrypt	type	column length	Allow Null?	Default Value	Constraints	MDM (1/0/?)	Matching Domains For Submitted_App fields	MDM Property Name	SPS Field (Y/N)	Unique Key	Natural Key	Content Type (content, id, administrative)	Entity (e.g., program, course, user, student, teacher, organization)

2	Placement	mmps_placement	placementStatus	Used to quickly differentiate between the status of the placement: Note: The placementStatus field is not currently part of ERP. It's solely defined within Conductor and provided as input to College Adaptor.	Low			Character varying	20	not null	COMPLETE_PLACEMENT PARTIAL_PLACEMENT (only grade point average available so unable to give high level math placements and transcript data will be incomplete or unavailable) NO_PLACEMENT (student was not found in ERP database)
3	Application	mmps_placement	cccid	cccid of student completing CCCApply application	Medium			Character varying	20	not null									id	student
4	Student	mmps_placement	ssid	ssid of student completing CCCApply application	High			Character varying	10	may be null									id	student
5	College	mmps_placement	collegeMISCode	College miscode of college student completed application.	Low			Character varying	20	not null									id	organization
6	Placement	mmps_placement	datasource	Source Of Placement Data 1 = California College Guidance Initiative (CCGI) 2 = Cal-PASS Plus (CPP) 3 = CCC Apply	Low			integer($int32)		not null	Values 1-3								content	organization
7	Placement	mmps_placement	english	English Support Recommendation 1 = Support Not Recommended 2 = Support Recommended 3 = Support Strongly Recommended	Low			integer($int32)		not null	Maximum: 3 Minimum: 1								content	placement
8	Placement	mmps_placement	slam	SLAM Support Recommendation 1 = Support Not Recommended 2 = Support Recommended 3 = Support Strongly Recommended	Low			integer($int32)		may be null	Maximum: 3 Minimum: 1								content	placement
9	Placement	mmps_placement	stem	STEM Support Recommendation 1 = Support Not Recommended 2 = Support Recommended 3 = Support Strongly Recommended	Low			integer		may be null	Maximum: 3 Minimum: 1								content	placement
10	Placement	mmps_placement	isAlg1	Successfully Completed Algebra I	Low			boolean		may be null									content	student
11	Placement	mmps_placement	isAlgII	Successfully Completed Algebra II	Low			boolean		may be null									content	student
12	Placement	mmps_placement	trigonometry	Trigonometry Recommendation True = Recommended False = Not Recommended	Low			boolean		may be null									content	placement
13	Placement	mmps_placement	preCalculus	PreCalculus Recommendation True = Recommended False = Not Recommended				boolean		may be null									content	placement
14	Placement	mmps_placement	calculus	Calculus Recommendation True = Recommended False = Not Recommended				boolean		may be null									content	placement
15	Placement	mmps_placement	acbc	A 1-3 numeric rating to indicate if a student is recommended for Applied Calculus/Business Calculus: 1 = Support Not Recommended 2 = Support Recommended 3 = Support Strongly Recommended				integer($int32)	1	may be null
16	Placement	mmps_placement	completedEleventhGrade	Completed Eleventh Grade	Low			boolean		may be null									content	student
17	Placement	mmps_placement	cumulativeGradePointAverage	Cumulative Grade Point Average	Low			number($double)		may be null	pattern: ^[0-3]\.\d{2}$\|^4.00$								content	student
18	Placement	mmps_placement	englishCompletedCourseId	Highest English Course Completed	Low			integer		may be null	1 = 12th grade Advanced Placement (AP) English Composition or Literature 2 = 12th grade Honors English Composition or Literature 3 = 12th grade English Composition or Literature 4 = 11th grade Advanced Placement (AP) English Composition or Literature 5 = 11th grade Honors English Composition or Literature 6 = 11th grade English Composition or Literature 7 = 10th grade (orlower) English Composition or Literature								content	student
19	Placement	mmps_placement	englishCompletedCourseGrade	Grade of Highest English Course Completed	Low			string		may be null	A A- B+ B B- C+ C C- D F P NP ON = Other Non-passing Grade X = None of the Above / Don’t Know								content	student
20	Placement	mmps_placement	mathematicsCompletedCourseId	Highest Mathematics Course Completed	Low			integer($int32)		may be null	1 ⎯ Pre-algebra or lower 2 ⎯ Algebra 1 3 ⎯ Integrated Math 1 4 ⎯ Integrated Math 2 5⎯ Geometry 6 ⎯ Algebra 2 7 ⎯ Integrated Math 3 8⎯ Statistics 9 ⎯ Integrated Math 4 10 ⎯ Trigonometry 13 – Math Analysis 11 ⎯ Pre-calculus 12 ⎯ Calculus or higher 0 - None of the Above / Don't Know								content	student
21	Placement	mmps_placement	mathematicsCompletedCourseGrade	Grade of Highest Mathematics Course Completed	Low			string		may be null	A A- B+ B B- C+ C C- D F P NP ON = Other Non-passing Grade X = None of the Above / Don’t Know								content	student
22	Placement	mmps_placement	mathematicsPassedCourseId	Highest Mathematics Passed	Low			integer($int32)		may be null	1 ⎯ Pre-algebra or lower 2 ⎯ Algebra 1 3 ⎯ Integrated Math 1 4 ⎯ Integrated Math 2 5⎯ Geometry 6 ⎯ Algebra 2 7 ⎯ Integrated Math 3 8⎯ Statistics 9 ⎯ Integrated Math 4 10 ⎯ Trigonometry 13 – Math Analysis 11 ⎯ Pre-calculus 12 ⎯ Calculus or higher 0 - None of the Above / Don't Know								content	student
23	Placement	mmps_placement	mathematicsPassedCourseGrade	Grade of Highest Mathematics Course Passed	Low			string		may be null	A A- B+ B B- C+ C C- D F P NP ON = Other Non-passing Grade X = None of the Above / Don’t Know								content	student
24	Application	mmps_placement	tstmpERPTransmit	Time stamp when placement was received from ERP timestamp	Low
25	Application	mmps_placement	appId	Application Id generated by Apply, used for tracking placement back to student application	Low			long		yes (but only up until CCGI)	Application Id								id	student
26	Placement	mmps_placement	highestGradeCompleted	Highest grade completed in high school at the time the CCCApply application is being submitted; replaces completedEleventhGrade and serves as the new trigger to display the MMPS questions (GPA, highest English and highest Math questions in CCCAppy)	Low			character varying	2	yes	CE (currently enrolled in 9th grade or lower), 09, 10, 11, 12, or null. This field value defaults to null for students who are not presented the "What was the highest grade you completed in high school" question (based on their CCCApply "High School Education" response).								content	student
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100