schema
title: Data Dictionary
This is a map of the tables, fields, and relationships in Civitas Learning's Data Warehouse, along with a data dictionary.
dim_aid_type
Dimension used to describe financial aid types from the SIS.
Given any specific source of financial aid, this table describes attributes of that aid package.
dim_aid_type_id
character varying
Primary key for the table.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_aid_type_id
character varying
Key value from the source system identifying aid sources.
raw_aid_type_desc
character varying
Descriptive label matched with raw_aid_type_id.
civ_aid_type_id
character varying
A Civitas-mapped fund identifier for the financial aid type/fund.
| Values | |
|---|---|
| GRFED | |
| GRINS | |
| GRPEL | |
| LOFED | |
| Not Applicable | |
| SCINS | |
| unmapped |
civ_aid_type_desc
character varying
Descriptive label matched with civ_aid_type_id.
| Values | |
|---|---|
| Federal Pell Grant | |
| Not Applicable | |
| Other Federal Grants | |
| Other Federal Loans | |
| Other Institutional Grant | |
| Other Institutional Scholarship | |
| all unmapped values |
raw_source_id
character varying
Source system key indicating the source of aid.
raw_source_desc
character varying
Descriptive label associated with raw_source_id.
raw_aid_type_group_id
character varying
Key value from the source system indicating a category or grouping of aid.
raw_aid_type_group_desc
character varying
Descriptive label matched with raw_aid_type_group_id.
raw_fed_fund_id
character varying
Key value from the source system further categorizing federal funds sources.
raw_fed_fund_desc
character varying
Descriptive label matched with raw_fed_fund_id.
civ_aid_category
character varying
High-level categorization of financial aid.
| Values | |
|---|---|
| Grant | |
| Loan | |
| Not Applicable | |
| Pell Grant | |
| Scholarship | |
| unmapped |
is_need_based
integer
Flag indicating that the source of aid is need-based.
is_loan
integer
Flag indicating that the source of aid is a loan.
is_merit_based
integer
Flag indicating that the source of aid is a merit-based award.
is_gi_bill
integer
Flag indicating that the source of aid is the federal government via the GI Bill.
is_pell_grant
integer
Flag indicating that the source of aid is the federal government via a Pell Grant.
is_work_study
integer
Flag indicating that the source of aid is the federal government via a Work-Study program.
is_corporate
integer
Flag indicating that the source of aid is corporate-sponsored.
raw_eff_ts
timestamp without time zone
Slowly changing dimension effective date for this row.
raw_eff_ts_end
timestamp without time zone
Slowly changing dimension ending date for this row.
dim_assignment
Dimension used to describe assignments from the LMS.
dim_assignment_id
character varying
Primary key for the table.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_eff_ts
timestamp without time zone
Slowly changing dimension effective date for this row.
raw_eff_ts_end
timestamp without time zone
Slowly changing dimension ending date for this row.
raw_assignment_id
character varying
Key value for an assignment from the source system.
raw_assignment_name
character varying
Descriptive name of the assignment from the source system.
raw_assignment_type
character varying
Key value from the source system used to categorize assignments.
raw_points_possible
character varying
If populated, the number of points from the source LMS possible for the assignment.
raw_scale
real
A raw scale factor for the assignment.
raw_weight
real
If populated, the weight given to the assignment from the source LMS.
raw_aggregation_model_id
character varying
A raw identifier for the aggregation model. An aggregation model identifies how various attempts on the same assignment attempt should be aggregated for a final grade.
raw_due_dt
timestamp without time zone
Source system assignment due date.
raw_creation_ts
timestamp without time zone
Source system assignment creation.
civ_aggregation_model_id
character varying
| Values | |
|---|---|
| Not Applicable | |
| average |
dim_award
Lookup table describing awardable credentials.
dim_award_id
character varying
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_eff_ts
timestamp without time zone
Slowly changing dimension effective date for this row.
raw_eff_ts_end
timestamp without time zone
Slowly changing dimension ending date for this row.
raw_award_id
character varying
raw_award_type_id
character varying
civ_award_type_id
character varying
raw_award_desc
character varying
dim_career_term
Dimension table describing academic terms.
dim_career_term_id
character varying
Primary key of the table.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_eff_ts
timestamp without time zone
Slowly changing dimension effective date for this row.
raw_eff_ts_end
timestamp without time zone
Slowly changing dimension ending date for this row.
raw_term_id
character varying
Key from the source system for the term.
raw_desc
character varying
Descriptive label matched with raw_term_id.
raw_acad_year
character varying
Source system academic year for the term.
civ_career_term_id
integer
A Civitas-mapped, unique career-term identifier.
raw_career_id
character varying
Source system category indicating the type of academic career.
civ_career_id
character varying
A Civitas-mapped value for the academic career associated with this section.
| Values | |
|---|---|
| B | MBA |
| CE | Continuing Education |
| CR | Correspondence |
| D | Doctorate |
| G | Graduate |
| H | High School |
| L | Law |
| M | Medical School |
| PB | Post Baccalaureate |
| P | Pharmacy |
| U | Undergraduate |
| X | Unknown |
civ_term_id
character varying
A Civitas-defined term identifier for the term in which the prediction is produced.
civ_career_term_start_dt
date
The start date of the Civitas-defined term.
civ_career_term_end_dt
date
The end date of the Civitas-defined term.
is_train
smallint
Flag used for model training. Used to indicate the training set.
is_test
smallint
Flag used for model training. Used to indicate the test set.
is_score
smallint
Flag used for model training. Used for scoring.
dim_completion_window
Dimension table describing completion windows.
dim_completion_window_id
character varying
Primary key of the table.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_eff_ts
timestamp without time zone
Slowly changing dimension effective date for this row.
raw_eff_ts_end
timestamp without time zone
Slowly changing dimension ending date for this row.
civ_career
character varying
A Civitas-mapped value for the academic career associated with the completion window.
civ_start_term_sequence_no
integer
A numeric Civitas-defined term identifier for the start term of the completion window.
civ_start_term_id
character varying
A Civitas-defined term identifier for the start term of the completion window.
civ_start_term_start_dt
date
The start date of the start term of the completion window.
civ_end_term_sequence_no
integer
A numeric Civitas-defined term identifier for the end term of the completion window.
civ_end_term_id
character varying
A Civitas-defined term identifier for the end term of the completion window.
civ_end_term_end_dt
date
The end date of the end term of the completion window.
window_length
smallint
The length of the window in number of years.
is_active
smallint
Flag indicating that the completion window is currently used.
dim_continuation_feature
Dimension that describes each feature of the persistence/continuation model.
dim_continuation_feature_id
character varying
Primary key for the table.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_eff_ts
timestamp without time zone
Slowly changing dimension effective date for this row.
raw_eff_ts_end
timestamp without time zone
Slowly changing dimension ending date for this row.
civ_continuation_feature_id
character varying
A Civitas-created unique identifier for the continuation feature.
civ_continuation_feature_name
character varying
Short name for a feature.
civ_continuation_feature_category
character varying
High-level grouping of features.
| Values | |
|---|---|
| Census | |
| Demographic | |
| Enrollment | |
| Enrollment Course | |
| Financial Aid | |
| LMS data features | |
| Not Applicable | |
| Student Campus | |
| Student Plan | |
| Student Type |
civ_continuation_feature_description
character varying
Longer description of how the feature is computed.
dim_course
Dimension describing courses.
dim_course_id
character varying
Primary key for the table.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_course_id
character varying
Source system key, associated with raw_course_nbr.
raw_eff_ts
timestamp without time zone
Slowly changing dimension effective date for this row.
raw_eff_ts_end
timestamp without time zone
Slowly changing dimension ending date for this row.
raw_course_nbr
character varying
Source system course number.
raw_subject
character varying
Subject code from the source system.
raw_catalog_nbr
character varying
Catalog number from the source system.
raw_title
character varying
Full title of the course from the source system.
raw_min_credits
real
Minimum credits from the source system.
raw_cip_code
character varying
A raw value for the CIP code associated with this course.
raw_department_id
character varying
Source system department identifier.
raw_course_level
character varying
Source system course level.
civ_is_deved
smallint
Flag indicting that the course is considered a developmental education course.
civ_course_id
character varying
A Civitas-mapped course identifier.
raw_department_name
character varying
Description associated with raw_department_id.
dim_date
Inmon-style date breakout dimension, which turns individual dates into component parts.
dim_date_id
character varying
dt
date
year
character varying
month_name
character varying
month_nbr_of_year
character varying
week_nbr_of_month
character varying
week_nbr_of_year
character varying
day_name
character varying
day_nbr_of_year
character varying
day_nbr_of_month
character varying
day_nbr_of_week
character varying
institution_id
character varying
Your institution identifier. You may have multiple institutions.
dim_enrollment
Describes enrollment of an individual person in a course/section.
dim_enrollment_id
character varying
Key for the table.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_eff_ts
timestamp without time zone
Slowly changing dimension effective date for this row.
raw_eff_ts_end
timestamp without time zone
Slowly changing dimension ending date for this row.
raw_enrollment_id
character varying
Source system key that defines an enrollment record.
raw_person_id
character varying
Source system identifier for the person who is enrolled in the course.
raw_section_id
character varying
Source system identifier for the section enrolled.
raw_role_id
character varying
A raw unique identifier for the person's role in this section, such as instructor or student.
raw_career_id
character varying
Source system category indicating the type of academic career.
raw_enrollment_status_id
character varying
Source system key that indicates course status, such as dropped or enrolled.
raw_add_dt
timestamp without time zone
Source system date that the enrollment was added.
raw_drop_dt
timestamp without time zone
Source system date that the enrollment was dropped.
raw_credits
double precision
Source system credits for the enrollment.
civ_is_enrolled
smallint
Flag indicating that the person involved is a student who is enrolled.
civ_is_waitlisted
smallint
Flag indicating that the person involved was waitlisted.
civ_is_not_in_course
smallint
Flag indicating that the person is not in the course.
civ_career_id
character varying
A Civitas-mapped value for the academic career associated with this section.
| Values | |
|---|---|
| B | MBA |
| CE | Continuing Education |
| CR | Correspondence |
| D | Doctorate |
| G | Graduate |
| H | High School |
| L | Law |
| M | Medical School |
| PB | Post Baccalaureate |
| P | Pharmacy |
| U | Undergraduate |
| X | Unknown |
civ_is_student
smallint
Flag indicating that the person involved is a student.
civ_is_instructor
smallint
Flag indicating that the person involved is the instructor.
dim_event
dim_person_event_id
character varying
dim_person_id
character varying
Used to join to dimension dim_person.
civ_term_id
character varying
A Civitas-defined term identifier for the term in which the prediction is produced.
civ_event_id
character varying
Do not use.
event_dt
timestamp without time zone
raw_event_value
character varying
institution_id
character varying
Your institution identifier. You may have multiple institutions.
dim_external_institution
Describes external institutions, such as high schools and colleges.
dim_external_institution_id
character varying
Primary key for the table.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_eff_ts
timestamp without time zone
Slowly changing dimension effective date for this row.
raw_eff_ts_end
timestamp without time zone
Slowly changing dimension ending date for this row.
raw_external_institution_id
character varying
Source system key for the institution.
raw_institution_name
character varying
Name of the institution.
raw_institution_type_id
character varying
Source system institution category, related to civ_institution_type_id.
raw_fice_code
character varying
Source system higher ed identifier code.
raw_atp_code
character varying
The College Entrance Examination Board (CEEB) code numbers are needed to register for any ACT or SAT program tests and to send your score reports to colleges and scholarship programs. CEEB code is also known as ATP code.
raw_desc
character varying
Source system description for the institution type. This is not the name of the institution, but a category.
civ_institution_type_id
character varying
A Civitas-mapped value for the type of instituion.
| Values | |
|---|---|
| C | College |
| H | High School |
| O | Other |
dim_outreach_campaign
Describes outreach and nudge campaigns.
dim_outreach_campaign_id
character varying
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_eff_ts
timestamp without time zone
Slowly changing dimension effective date for this row.
raw_eff_ts_end
timestamp without time zone
Slowly changing dimension ending date for this row.
raw_outreach_campaign_id
character varying
Optional Campaign ID, if the Outreach is part of a larger Outreach Campaign.
raw_descr
character varying
raw_start_dt
date
Start Date of the outreach campaign.
raw_end_dt
date
End Date of the outreach campaign.
raw_outreach_campaign_type_id
character varying
Type of outreach campaign, such as Recruiting or Freshman orientation.
raw_outreach_campaign_type_descr
character varying
Descriptive string associated with raw_outreach_campaign_type_id.
dim_outreach_reason
Describes the reason for an outreach.
dim_outreach_reason_id
character varying
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_eff_ts
timestamp without time zone
Slowly changing dimension effective date for this row.
raw_eff_ts_end
timestamp without time zone
Slowly changing dimension ending date for this row.
raw_outreach_reason_id
character varying
Reason for initiating outreach, such as low engagement or failing grades.
raw_descr
character varying
Description associated with raw_outreach_reason_id.
dim_outreach_recommendation
dim_outreach_recommendation_id
character varying
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_eff_ts
timestamp without time zone
Slowly changing dimension effective date for this row.
raw_eff_ts_end
timestamp without time zone
Slowly changing dimension ending date for this row.
raw_outreach_recommendation_id
character varying
raw_outreach_recommendation_descr
character varying
dim_outreach_type
Describes the communication modality of outreach.
dim_outreach_type_id
character varying
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_eff_ts
timestamp without time zone
Slowly changing dimension effective date for this row.
raw_eff_ts_end
timestamp without time zone
Slowly changing dimension ending date for this row.
raw_outreach_type_id
character varying
Type of outreach, such as Tutoring Session, Advising Session, Inspire for Advisors outreach, Inspire for Faculty outreach.
raw_descr
character varying
Description associated with raw_outreach_type_id.
raw_plural_descr
character varying
Plural form of raw_descr.
dim_person
Dimension table describing an individual person.
This is a slowly changing dimension, and it will have more than one record per person over time. By grouping institution_person_id and raw_person_id , you can determine if multiple records refer to the same individual.
This is like a fact in that describes a wide array of attributes about each named person.
If the civ_is flag values are blank or null, they are not mapped for your system.
dim_person_id
character varying
Primary key of the table.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_person_id
character varying
Source system person identifier. This is not a key, because the table is a slowly changing dimension; however, the same value refers to the same person in time.
raw_eff_ts
timestamp without time zone
Slowly changing dimension effective date for this row.
raw_eff_ts_end
timestamp without time zone
Slowly changing dimension ending date for this row.
raw_birth_dt
timestamp without time zone
Source system birth date.
raw_death_dt
timestamp without time zone
Source system death date.
raw_gender
character varying
Gender coding from the source system.
raw_primary_language
character varying
Source system indicator for the person's primary language.
raw_country_of_origin
character varying
Source system country of origin.
institution_person_id
character varying
Source system person identifier.
This is not a key, and it may have duplicates as information on a person is updated.
You can determine duplicates by looking at raw_eff_ts and raw_eff_ts_end.
is_hispanic
smallint
Flag indicating race.
is_american_indian
smallint
Flag indicating race.
is_asian
smallint
Flag indicating race.
is_white
smallint
Flag indicating race.
is_pacific_islander
smallint
Flag indicating race.
is_black
smallint
Flag indicating race.
raw_highschool_institution_name
character varying
A raw value for the name of the high school that the person graduated from.
raw_highschool_fice_code
character varying
A raw value for the FICE code of the high school the person graduated from. The FICE code is the Federal institution identifier.
raw_highschool_atp_code
character varying
A raw value for the ATP code of the high school the person graduated from.
raw_highschool_graduation_dt
timestamp without time zone
A raw value for the date that the person graduated high school.
raw_highschool_gpa
real
A raw value for the person's graduating high school GPA.
raw_highschool_class_rank
integer
A raw value for the person's rank in their graduating high school class.
raw_highschool_class_size
integer
A raw value for the size of the person's graduating high school class.
raw_highschool_class_percentile
real
A raw value for the person's percentile in their graduating high school class.
civ_is_veteran
smallint
Flag indicating the person is a veteran.
raw_country_of_deployment
character varying
A raw value for the country of deployment for military personnel.
raw_military_duty_status
character varying
A raw value for the duty status for military personnel.
raw_military_branch
character varying
A raw value for the military branch that the person is associated with.
raw_military_status
character varying
A raw value for the person's military status.
raw_military_rank
character varying
A raw value for the person's military rank.
raw_veteran_status_id
character varying
A raw value for the person's veteran status.
raw_veteran_status_desc
character varying
A raw description for the person's veteran status.
raw_military_service_start_dt
timestamp without time zone
A raw value for the start date of the person's military service.
raw_militray_return_eligibility_dt
timestamp without time zone
A raw value for the person's date of eligible return to the military.
raw_military_separation_dt
timestamp without time zone
A raw value for the date the person was separated from the military.
civ_is_good_standing
smallint
civ_is_deans_list
smallint
Flag indicating the person is on the Dean's List.
civ_is_warning
smallint
Flag indicating the person has been issued a warning.
civ_is_probation
smallint
civ_is_dismissal
smallint
civ_is_prevent_registration
smallint
Flag indicating they are prevented from further registration.
primary_address_line_1
character varying
Primary address.
primary_address_line_2
character varying
Optional primary address extended line.
primary_city
character varying
Primary address city.
primary_state
character varying
Primary contact state.
primary_zip
character varying
Primary contact zip code.
secondary_address_line_1
character varying
Secondary contact address.
secondary_address_line_2
character varying
Optional secondary contact address.
secondary_city
character varying
Secondary contact city.
secondary_state
character varying
Secondary contact state.
secondary_zip
character varying
Secondary contact zip.
primary_email
character varying
Primary contact email.
secondary_email
character varying
Secondary contact email.
civ_is_on_campus
smallint
primary_phone
character varying
Primary contact phone.
secondary_phone
character varying
Secondary contact phone.
civ_is_convicted_felony
smallint
Flag indicating that the person is a convicted felon.
civ_is_received_ged
smallint
civ_is_disciplinary_probation
smallint
Flag indicating the person is subject to a disciplinary probation.
civ_is_disciplinary_suspension
smallint
Flag indicating the person is subject to a disciplinary suspension.
civ_is_academic_probation
smallint
Flag indicating that the person is on academic probation.
civ_is_academic_suspension
smallint
Flag indicating that the person is under academic suspension.
civ_is_employed
smallint
civ_first_to_attend_college
smallint
Flag indicating that the person is the first in their family to attend college, according to their application.
civ_first_college
smallint
Flag indicating that this is the person's first college experience, according to their application.
civ_federal_financial_aid
smallint
Flag indicating the person is receiving federal financial aid.
civ_pri_lang_eng
smallint
Flag indicating the person's primary language is English.
civ_applied_online
smallint
Flag indicating the person applied online.
civ_is_us_citizen
smallint
Flag indicating the person is a U.S. citizen.
civ_dual_student
smallint
Flag indicating that the student is currently enrolled in another higher education institution, according to their application.
civ_va_benefits
smallint
Flag indicating the student is a recipient of VA benefits.
civ_father_college
smallint
Flag indicating that the person's father attended college.
civ_mother_college
smallint
Flag indicating the person's mother attended college.
civ_is_prevent_disbursement
smallint
Flag indicating the person has a hold that is preventing financial aid disbursement.
civ_prevents_registration
smallint
Flag indicating the person has a hold preventing registration.
civ_prevents_graduation
smallint
Flag indicating the person has a hold that prevents graduation.
first_name
character varying
First name of the person.
last_name
character varying
Last name of the person.
dim_person_no_pii
A subset of the dim_person table with personally identifying information removed.
See dim_person for field descriptions.
dim_person_id
character varying
Used to join to dimension dim_person.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_eff_ts
timestamp without time zone
Slowly changing dimension effective date for this row.
raw_eff_ts_end
timestamp without time zone
Slowly changing dimension ending date for this row.
raw_gender
character varying
raw_primary_language
character varying
Source system indicator for the person's primary language.
raw_country_of_origin
character varying
is_hispanic
smallint
is_american_indian
smallint
is_asian
smallint
is_white
smallint
is_pacific_islander
smallint
is_black
smallint
raw_highschool_institution_name
character varying
raw_highschool_fice_code
character varying
raw_highschool_atp_code
character varying
raw_highschool_graduation_dt
timestamp without time zone
raw_highschool_gpa
real
raw_highschool_class_rank
integer
raw_highschool_class_size
integer
raw_highschool_class_percentile
real
civ_is_veteran
smallint
raw_country_of_deployment
character varying
raw_military_duty_status
character varying
raw_military_branch
character varying
raw_military_status
character varying
raw_military_rank
character varying
raw_veteran_status_id
character varying
raw_veteran_status_desc
character varying
raw_military_service_start_dt
timestamp without time zone
raw_militray_return_eligibility_dt
timestamp without time zone
raw_military_separation_dt
timestamp without time zone
civ_is_good_standing
smallint
civ_is_deans_list
smallint
civ_is_warning
smallint
civ_is_probation
smallint
civ_is_dismissal
smallint
civ_is_prevent_registration
smallint
primary_city
character varying
primary_state
character varying
secondary_city
character varying
secondary_state
character varying
civ_is_on_campus
smallint
civ_is_convicted_felony
smallint
civ_is_received_ged
smallint
civ_is_disciplinary_probation
smallint
civ_is_disciplinary_suspension
smallint
civ_is_academic_probation
smallint
civ_is_academic_suspension
smallint
civ_is_employed
smallint
civ_first_to_attend_college
smallint
civ_first_college
smallint
civ_federal_financial_aid
smallint
civ_pri_lang_eng
smallint
civ_applied_online
smallint
civ_is_us_citizen
smallint
civ_dual_student
smallint
civ_va_benefits
smallint
civ_father_college
smallint
civ_mother_college
smallint
civ_is_prevent_disbursement
smallint
civ_prevents_registration
smallint
civ_prevents_graduation
smallint
dim_person_pii
A subset of the dim_person table, containing only the personally identifying information.
dim_person_pii_id
character varying
raw_person_id
character varying
raw_eff_ts
timestamp without time zone
Slowly changing dimension effective date for this row.
raw_eff_ts_end
timestamp without time zone
Slowly changing dimension ending date for this row.
raw_birth_dt
timestamp without time zone
raw_death_dt
timestamp without time zone
institution_person_id
character varying
primary_address_line_1
character varying
primary_address_line_2
character varying
primary_zip
character varying
secondary_address_line_1
character varying
secondary_address_line_2
character varying
secondary_zip
character varying
primary_email
character varying
secondary_email
character varying
primary_phone
character varying
secondary_phone
character varying
dim_plan
Describes academic plans.
This is a slowly changing dimension, with raw_plan_id representing the same plan in time from the source system, and dim_plan_id representing a unique point in time.
This is not an individual student academic plan.
dim_plan_id
character varying
Primary key for the table.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_eff_ts
timestamp without time zone
Slowly changing dimension effective date for this row.
raw_eff_ts_end
timestamp without time zone
Slowly changing dimension ending date for this row.
raw_plan_id
character varying
Source system plan ID. This is not a key.
raw_plan_desc
character varying
Description for the academic plan.
raw_cip_code
character varying
A raw value for the CIP code associated with this course.
raw_department_id
character varying
Source system department key.
raw_college_id
character varying
Source system college identifier.
raw_award_id
character varying
Source system identifier for the degree or certification awarded.
raw_plan_type_desc
character varying
Descriptive string associated with civ_plan_type_id.
civ_plan_type_id
character varying
A Civitas-mapped value for the plan type.
| Values | |
|---|---|
| Not Applicable | |
| major | |
| minor | |
| unmapped |
raw_department_name
character varying
Description associated with the raw_department_id.
raw_college_name
character varying
Description associated with the raw_college_id.
raw_award_type_id
character varying
Source system code for the category of award.
civ_award_type_id
character varying
A Civitas-mapped value for the award type, denormalized from the award table.
| Values | |
|---|---|
| BO | |
| BS | |
| Certificate | |
| MA | |
| MO | |
| MS | |
| ND | |
| Not Applicable | |
| Not Available | |
| OD | |
| unmapped |
raw_award_desc
character varying
Descriptive label associated with raw_award_id.
dim_program
Dimension that lists academic programs.
dim_program_id
character varying
Primary key for the table.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_eff_ts
timestamp without time zone
Slowly changing dimension effective date for this row.
raw_eff_ts_end
timestamp without time zone
Slowly changing dimension ending date for this row.
raw_program_id
character varying
Source system identifier for the program.
This is not a key unless combined with institution_id.
raw_desc
character varying
Readable description for the program associated with raw_program_id.
dim_section
Dimension that describes a section of a course in time.
dim_section_id
character varying
Primary key for the table.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_section_id
character varying
Source system section identifier.
raw_eff_ts
timestamp without time zone
Slowly changing dimension effective date for this row.
raw_eff_ts_end
timestamp without time zone
Slowly changing dimension ending date for this row.
raw_term_id
character varying
Source system term identifier.
raw_term_session_id
character varying
Source system term / session identifier. Sessions occur within a term.
raw_credit_hours
double precision
A raw value for the number of credit hours earned in the transfer course.
raw_instruction_mode_id
character varying
Source system identifier of the instructional modality.
raw_instructor_method_id
character varying
Source system identifier of the instructional method.
raw_location_id
character varying
Source system location code, typically a campus.
raw_campus_id
character varying
Source system campus identifier. May duplicate raw_location_id.
raw_institution_id
character varying
Source system institution identifier. Not related to institution_id.
raw_course_id
character varying
Source system course identifier associated with the section.
raw_primary_instructor_id
character varying
Source system identifier of the section's primary instructor.
raw_start_dt
timestamp without time zone
Source system start date of the section.
Note that this is not related to raw_eff_ts.
raw_end_dt
timestamp without time zone
Source system end date of the section.
Note that this is not related to raw_eff_ts_end.
raw_census_dt
date
Source system census date for the course.
civ_instruction_mode
character varying
Normalized instruction mode of the course.
| Values | |
|---|---|
| Blended | |
| Not Applicable | |
| Offline | |
| Online |
civ_session_id
character varying
Normalized session identifier associated with the section.
civ_term_id
character varying
A Civitas-defined term identifier for the term in which the prediction is produced.
civ_section_type
character varying
Normalized type categorization of the section.
| Values | |
|---|---|
| Not Applicable | |
| Not Available |
civ_census_dt
date
Normalized census date for the section.
civ_display_section_id
character varying
Do not use.
| Values | |
|---|---|
| Not Applicable | |
| Not Available |
civ_term_start_dt
date
Normalized term start date associated with the section.
civ_term_end_dt
date
Normalized end date for the term associated with the section.
civ_season
character varying
Normalized term-season associated with the section. Used for seasonal comparison of sections across terms.
| Values | |
|---|---|
| Fall | |
| Fall A | |
| Fall B | |
| Not Applicable | |
| Spring | |
| Spring A | |
| Spring B | |
| Summer | |
| Summer A | |
| Summer B | |
| Winter |
civ_year
integer
Normalized calendar year of the section.
civ_acad_year
character varying
Normalized academic year.
civ_display_term
character varying
Normalized description for the term associated with the section.
raw_course_nbr
character varying
Source system identifier for the course associated with the section.
raw_subject
character varying
Source system subject code.
raw_catalog_nbr
character varying
Source system catalog number for the course associated with the section.
raw_title
character varying
Source system description of the course title associated with the section.
raw_min_credits
real
Source system minimum number of credits for the section.
raw_cip_code
character varying
A raw value for the CIP code associated with this course.
raw_department_id
character varying
Source system idenfitier for the academic department.
raw_course_level
character varying
Source system course level code.
civ_is_deved
smallint
Flag indicating that the course is considered a developmental education course.
civ_course_id
character varying
Normalized course description.
raw_campus_desc
character varying
Associated description of a campus associated with raw_campus_id.
raw_department_name
character varying
Source system academic department name associated with raw_department_id.
dim_student_career_term_prediction_shift
Do not use.
dim_prediction_shift_id
character varying
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_person_id
character varying
civ_career_id
character varying
A Civitas-mapped value for the academic career associated with this section.
| Values | |
|---|---|
| B | MBA |
| CE | Continuing Education |
| CR | Correspondence |
| D | Doctorate |
| G | Graduate |
| H | High School |
| L | Law |
| M | Medical School |
| PB | Post Baccalaureate |
| P | Pharmacy |
| U | Undergraduate |
| X | Unknown |
civ_term_id
character varying
A Civitas-defined term identifier for the term in which the prediction is produced.
current_persistence_bucket_name
character varying
previous_persistence_bucket_name
character varying
change_dt
timestamp without time zone
dim_student_engagement_feature
Feature table for the student engagement prediction score.
This table is one of a set not included in standard warehouse deployments. Ask Support about adding them.
dim_student_engagement_feature_id
character varying
Key for the table.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_eff_ts
timestamp without time zone
Slowly changing dimension effective date for this row.
raw_eff_ts_end
timestamp without time zone
Slowly changing dimension ending date for this row.
civ_student_engagement_feature_id
character varying
Identifier of the feature. This may be repeated for multiple institutions.
civ_student_engagement_feature_name
character varying
Description of the associated feature.
civ_student_engagement_feature_category
character varying
Grouping of the features into high-level categories.
| Values | |
|---|---|
| LMS data features | |
| Not Applicable | |
| Not Available |
civ_student_engagement_feature_description
character varying
Long description of the feature.
fact_aid
Represents financial aid for a specific person at a point in time.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
dim_career_term_id
character varying
Used to join to dimension dim_career_term.
dim_aid_type_id
character varying
Used to join to dimension dim_aid_type.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_disbursed_amount
real
The amount of aid.
fact_application
Represents a person applying to a specific program at a point in time.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_person_id
character varying
Used to join to dimension dim_person.
dim_career_term_id
character varying
Used to join to dimension dim_career_term.
dim_program_id
character varying
Used to join to dimension dim_program.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
dim_date_id
character varying
Used to join to dimension dim_date.
fact_assignment_attempt
Represents a single attempt at a course assignment in a given section. This is typically derived from LMS source data.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
dim_section_id
character varying
Used to join to dimension dim_section.
dim_enrollment_id
character varying
Used to join to dimension dim_enrollment.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
dim_assignment_id
character varying
Used to join to dimension dim_assignment.
fact_assignment_grade
Represents a grade given to a person for a specific assignment.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
dim_section_id
character varying
Used to join to dimension dim_section.
dim_enrollment_id
character varying
Used to join to dimension dim_enrollment.
dim_assignment_id
character varying
Used to join to dimension dim_assignment.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_grade
character varying
Source system raw grade.
civ_assignment_grade
double precision
Normalized grade for the assignment.
raw_student_points_possible
double precision
Source system total points possible for the assignment.
fact_assignment_grade_final
Represents a grade given to a person for a specific assignment.
This is the final grade. It may be revised from fact_assignment_grade.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
dim_section_id
character varying
Used to join to dimension dim_section.
dim_enrollment_id
character varying
Used to join to dimension dim_enrollment.
dim_assignment_id
character varying
Used to join to dimension dim_assignment.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
civ_assignment_grade
double precision
A Civitas-mapped numerical value for the final grade of this assignment.
raw_student_points_possible
double precision
fact_completion_scores
Represents completion prediction for students whose completion window hasn't ended as well as students who are currently enrolled. The table retains historical completion scores on a weekly cadence from the day of data warehouse deployment.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
dim_completion_window_id
character varying
Used to join to dimension dim_completion_window.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
civ_career
character varying
A Civitas-mapped value for the academic career associated with the student in the term.
civ_term_sequence_no
integer
A numeric Civitas-defined term identifier for the term in which the prediction is produced.
iteration_ts
timestamp without time zone
prediction
double precision
Specific prediction probability of a student being awarded a degree within the completion window.
civ_term_id
character varying
A Civitas-defined term identifier for the term in which the prediction is produced.
civ_start_term_id
character varying
A Civitas-defined term identifier for the student's start term.
civ_start_term_sequence_no
integer
A numeric Civitas-defined term identifier for the student's start term.
window_length
integer
The length of completion window in number of years.
fact_completion_scores_latest
Represents the latest completion prediction for students whose completion window hasn't ended as well as students who are currently enrolled.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
dim_completion_window_id
character varying
Used to join to dimension dim_completion_window.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
civ_career
character varying
A Civitas-mapped value for the academic career associated with the student in the term.
civ_term_sequence_no
integer
A numeric Civitas-defined term identifier for the term in which the prediction is produced.
iteration_ts
timestamp without time zone
prediction
double precision
Specific prediction probability of a student being awarded a degree within the completion window.
civ_term_id
character varying
A Civitas-defined term identifier for the term in which the prediction is produced.
civ_start_term_id
character varying
A Civitas-defined term identifier for the student's start term.
civ_start_term_sequence_no
integer
A numeric Civitas-defined term identifier for the student's start term.
window_length
integer
The length of completion window in number of years.
fact_continuation
Represents the fact of an individual continuing (or not), term to term.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
next_continuation_event
timestamp without time zone
The timestamp for the day of the person's next continuation event within an academic career.
civ_career
character varying
Civitas value describing the academic career.
| Values | |
|---|---|
| G | |
| U |
civ_term_sequence_no
integer
Monotonically increasing sequence number for terms, used to establish continuation ordering.
continued
smallint
Flag indicating that the student continued to the next term.
fact_continuation_feature
Represents a single feature value for a person in time, used to predict continuation.
This will contain historical values.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
dim_continuation_feature_id
character varying
Used to join to dimension dim_continuation_feature.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
text_value
character varying
If a text feature, this string is the value.
int_value
integer
If a numeric feature, and limited to whole numbers, the feature value.
float_value
real
If a numeric feature, the value of the feature.
bool_value
smallint
If a boolean feature, 0 or 1 indicating the feature.
fact_continuation_feature_latest
The most recent set of continuation features for a given person. See fact_continuation_feature.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
dim_continuation_feature_id
character varying
Used to join to dimension dim_continuation_feature.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
text_value
character varying
int_value
integer
float_value
real
bool_value
smallint
fact_continuation_ifr
Represents the various weight and power of individual features to making a continuation prediction.
Individual feature ranked (IFR) functionality is not included with standard warehouse deployments. If you would like to incorporate IFR, please inquire with Sales.
dim_person_id
character varying
Used to join to dimension dim_person.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_continuation_feature_id
character varying
Used to join to dimension dim_continuation_feature.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
feature_rank
integer
Rank ordered contribution of the feature to a given mode. 1 is the most powerful feature.
feature_contrib
real
Relative numeric representation of the feature contribution to the model.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
civ_career
character varying
| Values | |
|---|---|
| G | |
| U |
civ_term_sequence_no
integer
civ_term_id
character varying
A Civitas-defined term identifier for the term in which the prediction is produced.
fact_continuation_scores
Represents a continuation prediction at a point in time.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
civ_career
character varying
| Values | |
|---|---|
| G | |
| U |
civ_term_sequence_no
integer
iteration_ts
timestamp without time zone
seg_id
integer
N/A
clust_id
integer
N/A
prediction
double precision
Specific prediction probability of continuation for the next term.
model
character varying
Name of the institution-specific model used to compute the score.
civ_term_id
character varying
A Civitas-defined term identifier for the term in which the prediction is produced.
fact_drop
Represents a person dropping a section of a course.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
dim_section_id
character varying
Used to join to dimension dim_section.
dim_enrollment_id
character varying
Used to join to dimension dim_enrollment.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
civ_is_withdraw
smallint
Flag indicating that the drop event should be treated as a withdrawal.
fact_enroll
Represents a person enrolling in a section.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
dim_section_id
character varying
Used to join to dimension dim_section.
dim_enrollment_id
character varying
Used to join to dimension dim_enrollment.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
fact_enrollment_opinion_score
Do not use.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
dim_section_id
character varying
Used to join to dimension dim_section.
dim_enrollment_id
character varying
Used to join to dimension dim_enrollment.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_student_opinion_score
integer
fact_financial_standing
Represents externalities preventing disbursement of financial aid to a person.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_financial_standing_id
character varying
Financial standing identifier from the source system, associated with civ_is_prevent_disbursement.
civ_is_prevent_disbursement
smallint
Normalized Y or N indicating if aid is impacted and preventing disbursement.
fact_forum_post
Represents an individual person posting in shared LMS forums.
dim_person_id
character varying
Used to join to dimension dim_person.
dim_enrollment_id
character varying
Used to join to dimension dim_enrollment.
dim_section_id
character varying
Used to join to dimension dim_section.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
raw_post_id
character varying
raw_post_thread_id
character varying
raw_forum_id
character varying
dim_date_id
character varying
Used to join to dimension dim_date.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
fact_grade
Represents a single grade for a person in a section.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
dim_section_id
character varying
Used to join to dimension dim_section.
dim_enrollment_id
character varying
Used to join to dimension dim_enrollment.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
civ_is_attempt
smallint
Flag indicating a course/section attempt.
civ_is_pending
smallint
N/A
civ_is_withdraw
smallint
Flag indicating withdrawal from the section.
civ_is_administrative_withdraw
smallint
Flag indicating withdrawal from the section.
civ_is_favorable
smallint
Flag indicating that the student's outcome in this course is considered favorable by the institution.
civ_is_earned
smallint
Flag indicating the grade points were earned.
civ_gpa_points
real
A Civitas-mapped numeric value for the GPA points earned in this course.
civ_display_grade
character varying
A Civitas-mapped display value for the grade.
civ_gpa_at
character varying
A Civitas-mapped cumulative GPA. This is the student's new calculated cumulative GPA, as a result of receiving this grade.
fact_graduation
Represents a person graduating from a specific academic career.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
dim_career_term_id
character varying
Used to join to dimension dim_career_term.
dim_plan_id
character varying
Used to join to dimension dim_plan.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
civ_is_award_conferred
integer
Flag indicating the graduation award is conferred.
fact_plan_enrollment
Represents a person enrolled in a specific degree plan.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_person_id
character varying
Used to join to dimension dim_person.
dim_plan_id
character varying
Used to join to dimension dim_plan.
dim_date_id
character varying
Used to join to dimension dim_date.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
fact_program_declaration
Represents a person declaring for a specific program.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_person_id
character varying
Used to join to dimension dim_person.
dim_career_term_id
character varying
Used to join to dimension dim_career_term.
dim_program_id
character varying
Used to join to dimension dim_program.
dim_date_id
character varying
Used to join to dimension dim_date.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
fact_provided_gpa
Represents the GPA of a given person across time.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
civ_career_id
character varying
A Civitas-mapped value for the academic career associated with this section.
| Values | |
|---|---|
| B | MBA |
| CE | Continuing Education |
| CR | Correspondence |
| D | Doctorate |
| G | Graduate |
| H | High School |
| L | Law |
| M | Medical School |
| PB | Post Baccalaureate |
| P | Pharmacy |
| U | Undergraduate |
| X | Unknown |
raw_gpa
double precision
Source system raw computed GPA.
raw_hours_attempted
double precision
Source system total hours attempted.
raw_hours_earned
double precision
Source system hours earned.
raw_quality_points
double precision
Source system total grade points * course hours.
raw_hours_affecting_gpa
double precision
Source system course hours used to compute the GPA.
fact_standing
Represents point-in-time academic standing for a person.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
raw_standing_id
character varying
Source system code for the standing used to compute the civ_* flags.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
civ_is_good_standing
smallint
Flag indicating in good standing.
civ_is_deans_list
smallint
Flag indicating being on the Dean's List.
civ_is_warning
smallint
Flag indicating a warning issued.
civ_is_probation
smallint
Flag indicating on probation.
civ_is_dismissal
smallint
Flag indicating dismissed.
civ_is_prevent_registration
smallint
Flag indicating prevented from further registration.
fact_student_engagement_scores
Represents a person's engagment score at a point in time.
This table is one of a set not included in standard warehouse deployments. Ask Support about adding them.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
dim_section_id
character varying
Used to join to dimension dim_section.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
iteration_ts
timestamp without time zone
seg_id
integer
N/A
clust_id
integer
N/A
engagement_score
double precision
The numerical value for the engagement score.
model
character varying
The model used to compute the student engagement.
fact_student_engagement_top_features
Represents the features contributing most heavily to the student's engagement score.
This table is one of a set not included in standard warehouse deployments. Ask Support about adding them.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
dim_section_id
character varying
Used to join to dimension dim_section.
dim_student_engagement_feature_id
character varying
Used to join to dimension dim_student_engagement_feature.
feature_rank
integer
Rank ordering of the feature's contribution.
feature_contrib
double precision
Weighted feature contribution to the engagement score.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
fact_student_start_term
Represents students' start term.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
civ_career
character varying
A Civitas-mapped value for the academic career associated with the student in the term.
civ_start_term_sequence_no
integer
A numeric Civitas-defined term identifier for the student's start term.
civ_start_term_id
character varying
A Civitas-defined term identifier for the student's start term.
fact_test_score
Represents a standardized single test score for a person.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_test_id
character varying
Source system test identifier.
civ_test_id
character varying
A Civitas-mapped unique identifier for the test.
raw_score
character varying
Source system score.
civ_score
double precision
A Civitas-mapped score for the test.
fact_transfer_course
Represents a single course section transferred, along with the credit.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_course_id
character varying
Used to join to dimension dim_course.
dim_person_id
character varying
Used to join to dimension dim_person.
dim_career_term_id
character varying
Used to join to dimension dim_career_term.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_grade_id
character varying
Source system grade.
raw_credit_hours
real
Source system credit hours for the course.
fact_web_activity
Represents a person's activity with online resources.
event_ts
timestamp without time zone
Time stamp an event took place. This is used for facts to know when.
dim_date_id
character varying
Used to join to dimension dim_date.
dim_person_id
character varying
Used to join to dimension dim_person.
dim_enrollment_id
character varying
Used to join to dimension dim_enrollment.
dim_section_id
character varying
Used to join to dimension dim_section.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
raw_activity_type_id
character varying
Source system activity identifier.
civ_activity_type_id
character varying
A Civitas-mapped identifier for the type of activity.
| Values | |
|---|---|
| assignment | |
| exam | |
| gradebook | |
| message | |
| post |
data_freshness
Append-only history of successful full Data Warehouse loads.
Each nightly build that finishes loading all configured Data Warehouse tables appends one row.
Use MAX(data_freshness_dt) to find the latest time the full warehouse was loaded and ready to query.
data_freshness_id
bigint
Auto-incrementing primary key for each successful full Data Warehouse load.
data_freshness_dt
timestamp without time zone
Timestamp when the full Data Warehouse load completed successfully and the data was ready for customer queries. This is a load-complete marker, not a warehouse build-start marker.
table_data_freshness
Current freshness snapshot for each delivered Data Warehouse table.
One row per table (for example data_mart.dim_person).
The timestamp is rewritten after that table finishes loading.
table_name
character varying
Fully qualified delivered table name, such as data_mart.dim_person.
institution_id
character varying
Your institution identifier. You may have multiple institutions.
table_freshness_dt
timestamp without time zone
Timestamp when this specific delivered table finished loading and its freshness row was refreshed.