Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Dimensions. 

cube_namedimension_unique_namehierarchy_name
Cube NameDimension Unique NameDescription
SAM Plans
[Assessments]
Assessment CodeAssessment
Code
review code
SAM Plans
[Assessments]
Assessment Code CategoryAssessment code category. Categories include Not Reviewed, Missing Element, Needs Work and Compliant.
SAM Plans
[Assessments]
Assessment Code DescriptionDescription of the assessment code.
SAM Plans
[Assessments]
CampusCampus name
SAM Plans
[Assessments]CampusCollegeMajorHierarchy
CampusCollegeMajorHierarchyHierarchy showing the organizational structure of the individual plans starting at Campus level with drill downs to College and Major
SAM Plans
[Assessments]
CIP CodeProgram CIP
Code
code
SAM Plans
[Assessments]
College DivisionCollege name / Division name
SAM Plans
[Assessments]
Cycle YearCycle Year
SAM Plans
[Assessments]
Degree TypeDegree
Type
(BA, BS, MA, etc)
SAM Plans
[Assessments]
DurationDuration of assessment (1 year or 3 year)
SAM Plans
[Assessments]
Duration YearCurrent year of assessment. Year 1,2 or 3
SAM Plans
[Assessments]
Flag Assessment ActiveFlag indicating if the objective assessment code is currently active.
SAM Plans
[Assessments]
Flag Review ActiveFlag indicating if the overall review code is active.
SAM Plans
[Assessments]
Flag Review ApprovedFlag indicating if the review code idicates an assessment approval.
SAM Plans
[Assessments]Level Type
Level TypeLevel or type of the program or unit.  Values include Undergraduate, Graduate, Centers and Institues and Administrative.
SAM Plans
[Assessments]
Major UnitAcademic major or administrative unit.
SAM Plans
[Assessments]
Mission StatementMission
Statement
statement of the program.
SAM Plans
[Assessments]
Mission Statement AssessmentAssessment review of the missions statement.
SAM Plans
[Assessments]Plan Status
Plan StatusPlan status code. 0 = Not started, 1 = Edited, 2 = Submitted, 4 = Reviewed, 5 = Reopened
SAM Plans
[Assessments]
Plan Type NameName of the plan type. (ex. Academic, Administrative)
SAM Plans
[Assessments]Review StatusSAM Plans[Assessments]Review TitleSAM Plans[Measures]Measures
Review StatusReview status code. 0 = Plan not reviewed, 1 = Plan not approved, 2 = Plan approved, 3 = Report not reviewed, 4 = Report not approved, 5 = Report approved, 6 = In review
SAM PlansReview TitleReview title or description. (Developed, Non-compliant, etc.)


FACTS/MEASURES.

cube_nameMeasureGroup_
Cube Name
measure_
Measure Name
measure_description
Measure DescriptionEXPRESSION
SAM Plans
FACTSAM
Count AssessmentsCount AssessmentsCount
Assessments
of assessments (Plans).
SAM Plans
FACTSAM Assessments
No Of GoalsNo Of Goals

...

Count of goals in an assessment.