Trinity Warehouse Production Business Glossary Documentation

Glossary for the Trinity Warehouse Production Business Glossary

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Business term	Analysis area	Comments
a
1823_High	dim_Adm_Scholarship
1823_Low	dim_Adm_Scholarship
acad career	dim_ACAD_Program
	dim_Student_AcadPlan_curr
	fact_ACAD_StudentClassEnrollment_snap
	fact_Adm_Applications	Academic Program: UGRD - traditional and IDP undergraduates; GRAD - graduates
Acad Career of the Class Section	dim_ACAD_Class_snap
	fact_ACAD_StudentClassEnrollment_snap
Acad Group	dim_ACAD_Class_snap
	fact_ACAD_StudentClassEnrollment_snap
acad plan	dim_Gen_Edu_Reqs
acad prog	dim_ACAD_Program
	fact_ACAD_StudentClassEnrollment_snap
acad program	fact_Adm_Applications	Academic Program: UGRD - traditional undergraduates; IDP - IDP; GRAD - degree-seeking graduates
Academic Career	dim_ACAD_Student_Career_Term_snap
Academic Dept of the Subject	dim_ACAD_Class_snap	The academic department or program (academic organization) that offers courses in this subject area.
Academic Group of Advisor	dim_ACAD_Student_Career_Term_snap
academic interest 1	dim_Adm_Person
academic interest 1 name	dim_Adm_Person
academic interest 2	dim_Adm_Person
academic interest 2 name	dim_Adm_Person
academic interest 3	dim_Adm_Person
academic interest 3 name	dim_Adm_Person
Academic Level - Projected	dim_ACAD_Student_Career_Term_snap
Academic Level - Term End	dim_ACAD_Student_Career_Term_snap
Academic Level - Term Start	dim_ACAD_Student_Career_Term_snap
Academic Load	dim_ACAD_Student_Career_Term_snap	Default Value = 'N'
Academic Load Change Date	dim_ACAD_Student_Career_Term_snap
Academic Org Code of the Class	dim_ACAD_Class_snap	The Academic Organization (department or program) that offers this class.
Academic Org Manager- Class	dim_ACAD_Class_snap
Academic Organization -Class	dim_ACAD_Class_snap	The Academic Organization (department or program) that offers this class.
Academic Organization of the Class	fact_ACAD_StudentClassEnrollment_snap	The Academic Organization (department or program) that offers this class.
Academic Year	dim_ACAD_Student_Career_Term_snap	Default Value from TERM_TBL.ACAD_YEAR
act composite	dim_adm_Superscores_Verified	Best ACT Composite score; score range: 1 to 36
act english	dim_adm_Superscores_Verified	Best ACT English score; score range: 1 to 36
ACT English Language Arts	dim_adm_Superscores_Verified
ACT English Writing	dim_adm_Superscores_Verified
act high score date	dim_adm_Superscores_Verified	Date of the ACT test with the highest composite score
act math	dim_adm_Superscores_Verified	Best ACT Math score; score range: 1 to 36
act most recent date	dim_adm_Superscores_Verified	Most recent verified ACT test
act reading	dim_adm_Superscores_Verified	Best ACT Reading score; score range: 1 to 36
act science reasoning	dim_adm_Superscores_Verified	Best ACT Science Reasoning score; score range: 1 to 36
ACT STEM	dim_adm_Superscores_Verified
ACT Writing	dim_adm_Superscores_Verified
ACT Writing Pre-9/2016	dim_adm_Superscores_Verified
ACT Writing: Development and Support	dim_adm_Superscores_Verified
ACT Writing: Ideas and Analysis	dim_adm_Superscores_Verified
ACT Writing: Language Use and Conventions	dim_adm_Superscores_Verified
ACT Writing: Organization	dim_adm_Superscores_Verified
addr field1	dim_ACAD_Person
addr field1 other	dim_ACAD_Person
addr field2	dim_ACAD_Person
addr field2 other	dim_ACAD_Person
addr field3	dim_ACAD_Person
addr field3 other	dim_ACAD_Person
address created date	dim_Adm_Addresses_Consolidated
address effective date	dim_Adm_Addresses_Consolidated	If the address is temporary/seasonal, then this is when the address takes effect.
address expiration date	dim_Adm_Addresses_Consolidated	If the address is temporary/seasonal, then this is when the address expires.
Address Guid	dim_Adm_Addresses_Consolidated
address notes	dim_Adm_Addresses_Consolidated	This field stores custom notes that Admissions users can enter through the interface.
address priority	dim_Adm_Addresses_Consolidated	Priority helps determine the address rank. See rank description for more information.
address quality	dim_Adm_Addresses_Consolidated	This column determines the quality of an address. When addresses are added during a batch process, the quality is set to 2 by default, indicating that the address is awaiting standardization. Every evening, or upon demand when initiated by an administrator, there is an attempt to standardize addresses with a rating of 2. If they can be successfully standardized, this column is updated to 0. If not, this column is updated to 1. When an address is added individually there is a real-time attempt to standardize it. If the standardization is successful, this column's value will be set to 0. If the user skips the validation process this column's value will be set to 1.
address rank	dim_Adm_Addresses_Consolidated	Address type determines address rank. A record can have both a rank 1 mailing and a rank 1 permanent address. The ranking order is as follows: 1. Priority (high, then normal, then low) 2. Street has a value (value exists, then no value exists) 3. Updated Date (Most recent to least recent) 4. Created Date (Most recent to least recent) 5. ID (ascending order) Note: Addresses recorded via an application submission are stored with a high priority. Exclusions Addresses with an inactive priority are not ranked. Addresses with an effective date ('Valid From Date') in the future are not ranked. Addresses with an expires date ('Valid Until Date') in the past are not ranked.
address rank overall	dim_Adm_Addresses_Consolidated	Rank overall, also known as Active Address, determines the overall address rank, regardless of the address type. A record can have only one address assigned a rank overall of 1. The ranking order is as follows: 1. Highest priority (High, Normal, or Low) 2. If addresses have the same priority, then whichever has a street address value is ranked higher 3. If addresses have the same priority and have a street address value, the address that is a mailing address will be ranked higher. 4. If addresses have the same priority and have a street address value and both are mailing addresses or both are not mailing addresses, then the most recently updated address is ranked higher 5. If addresses have the same priority, have a street address value and are both mailing addresses or both are not mailing addresses and have the same updated date/time then the most recently created address will be ranked higher 6. If all of these items are the same, then the Active Address will rank by the address ID number (whichever is first alphabetically) Exclusions Addresses with an inactive priority are not ranked. Addresses with an effective date ('Valid From Date') in the future are not ranked. Addresses with an expires date ('Valid Until Date') in the past are not ranked.
address type	dim_Adm_Addresses_Consolidated	Slate allows Permanent and Mailing for people. For organizations, a third type called Location is available.
address validated	dim_Adm_Addresses_Consolidated	If the address has been validated by USPS this value will be 'Validated' otherwise it will be null.
address1	dim_ACAD_Person
address1 ac	dim_ACAD_Person
address1 other	dim_ACAD_Person
address2	dim_ACAD_Person
address2 ac	dim_ACAD_Person
address2 other	dim_ACAD_Person
address3	dim_ACAD_Person
address3 ac	dim_ACAD_Person
address3 other	dim_ACAD_Person
address4	dim_ACAD_Person
address4 other	dim_ACAD_Person
Adjusted Units	fact_ACAD_StudentClassEnrollment_snap	Logic copied from IRP table build
Admit Confirmed Date	dim_Adm_Decisions
Admit Letter	dim_Adm_Decisions
Admit Reason	dim_Adm_Decisions
Admit Received Date	dim_Adm_Decisions
Admit Released Date	dim_Adm_Decisions
Admit/Decline Confirmed Date	dim_Adm_Decisions
Admit/Decline Letter	dim_Adm_Decisions
Admit/Decline Reason	dim_Adm_Decisions
Admit/Decline Received Date	dim_Adm_Decisions
Admit/Decline Released Date	dim_Adm_Decisions
Admit/Matric Confirmed Date	dim_Adm_Decisions
Admit/Matric Letter	dim_Adm_Decisions
Admit/Matric Reason	dim_Adm_Decisions
Admit/Matric Received Date	dim_Adm_Decisions
Admit/Matric Released Date	dim_Adm_Decisions
alias other last names used	dim_Adm_Person
Allow Different MtgPttnInstr	dim_CombinedSection_curr	Y/N Flag to allow a different meeting pattern/location/instructor for each section of a group of combined sections.
alter emplid	dim_ACAD_Person
American Indian/Alaskan Native	dim_ACAD_Person
app reference id external	fact_Adm_Applications
app reference id internal	fact_Adm_Applications
app reference id override	fact_Adm_Applications
applicant date	dim_Adm_Person
application certified date	fact_Adm_Applications
application created date	fact_Adm_Applications
application deadline extended date	fact_Adm_Applications
application guid	dim_Adm_Application_Details	The alphanumeric representation of the database key (data type of uniqueidentifier).
	dim_Adm_Scholarship
	fact_Adm_Applications
application identity	fact_Adm_Applications
application priority	fact_Adm_Applications	Found hard coded in WH Applications query in Slate: when '1' then 'High Priority' when '0' then 'Normal Priority' when '-1' then 'Low Priority' when '-2' then 'Inactive'
application priority code	fact_Adm_Applications
application rank	fact_Adm_Applications
application rank submitted	fact_Adm_Applications
application response date	fact_Adm_Applications
application slate id	dim_Adm_Application_Details	A numeric, unique identifier for each application generated by Slate. Also known as application reference ID or 'ref'.
	dim_Adm_Decisions
	dim_Adm_Scholarship
	fact_Adm_Applications
application status	fact_Adm_Applications
application submitted date	fact_Adm_Applications
Application Tags	fact_Adm_Applications	All application scoped tags.
Approved Academic Load	dim_ACAD_Student_Career_Term_snap	Defualt Value = 'F'
arms id	dim_Adm_Person
Asian	dim_ACAD_Person	The race 'Asian' has been recorded for this person. Other races and/or ethnicity could also be indicated for this person.
associated class	fact_ACAD_StudentClassEnrollment_snap
	fact_ACAD_StudentClassEnrollment_snap	Associated Class group number. By using associated class numbers, class sections that constitute a single course offering can be linked during registration. For instance, a certain number of lecture, lab, and discussion sections are combined into one associated class number to indicate that the three components are related to one another. When you schedule the first section of a course offering and use the prompt box, the system only displays this default value. You can use a prompt value, or you can manually enter any new one- to four-digit number into the field. Upon saving the page, the system extracts the necessary course data from the course catalog, creates a row in the Class Associations component for this class association number, and populates the row with the appropriate course catalog data. When a student enrolls in a class, the system verifies that the student has enrolled in a section with all required components of the course from within the same associated class number. If you add a new class associations value to a scheduled class, and you want to make changes to the class association data that the system extracts from the course catalog, you must make your changes on the Class Associations component. A special associated class number, 9999, enables you to associate a section with any other section. However, you can only use this associated class number for nongraded components.
Associated Class Nbr	dim_ACAD_Class_snap	Associated Class group number. By using associated class numbers, class sections that constitute a single course offering can be linked during registration. For instance, a certain number of lecture, lab, and discussion sections are combined into one associated class number to indicate that the three components are related to one another. When you schedule the first section of a course offering and use the prompt box, the system only displays this default value. You can use a prompt value, or you can manually enter any new one- to four-digit number into the field. Upon saving the page, the system extracts the necessary course data from the course catalog, creates a row in the Class Associations component for this class association number, and populates the row with the appropriate course catalog data. When a student enrolls in a class, the system verifies that the student has enrolled in a section with all required components of the course from within the same associated class number. If you add a new class associations value to a scheduled class, and you want to make changes to the class association data that the system extracts from the course catalog, you must make your changes on the Class Associations component. A special associated class number, 9999, enables you to associate a section with any other section. However, you can only use this associated class number for nongraded components.
association 99	fact_ACAD_StudentClassEnrollment_snap
at stdnt option	dim_Gen_Edu_Reqs
attend sync reqd	dim_ACAD_Class_snap
	fact_ACAD_StudentClassEnrollment_snap
attended from date	dim_Adm_School_Attendance	The beginning date the student attended the institution.
attended to date	dim_Adm_School_Attendance	The end date the student attended the institution.
audit grade basis	fact_ACAD_StudentClassEnrollment_snap
Audit Grading Basis	dim_Course_Enrl_Codes_curr
Auto Enroll from Waitlist	dim_ACAD_Class_snap	Indicates whether the wait list process in PS moves students from the wait list to enrolled status when a space opens up in the section. Spaces become available through enrollment drops or an enrollment capacity increase. Generally, when spaces become available in a section, the class status opens, allowing students to enroll. However, selecting this check box keeps the status closed so that you have time to move students from the wait list into the class by running the wait list process (before other students enroll). If you do not select the Auto Enroll from Wait List check box and you have students on the wait list for the class, when the class status changes to open you cannot use the wait list process to move students from the wait list into the class. You have to move wait listed students into the class manually, and students that are not on the wait list can enroll in the class.
	fact_ACAD_StudentClassEnrollment_snap	Indicates whether the wait list process in PS moves students from the wait list to enrolled status when a space opens up in the section. Spaces become available through enrollment drops or an enrollment capacity increase. Generally, when spaces become available in a section, the class status opens, allowing students to enroll. However, selecting this check box keeps the status closed so that you have time to move students from the wait list into the class by running the wait list process (before other students enroll). If you do not select the Auto Enroll from Wait List check box and you have students on the wait list for the class, when the class status changes to open you cannot use the wait list process to move students from the wait list into the class. You have to move wait listed students into the class manually, and students that are not on the wait list can enroll in the class.
auto enroll sect 1	dim_ACAD_Class_snap
	fact_ACAD_StudentClassEnrollment_snap
auto enroll sect 2	dim_ACAD_Class_snap
	fact_ACAD_StudentClassEnrollment_snap
avp interview status	dim_Adm_Person
b
barg unit	dim_ACAD_Person
bilingualism code	dim_ACAD_Person
Billing Career	dim_ACAD_Student_Career_Term_snap	Default Value from STDNT_CAR_TERM.ACAD_CAREER
birth country	dim_Adm_Person
birthcountry	dim_ACAD_Person
birthdate	dim_ACAD_Person
	dim_Adm_Person
birthplace	dim_ACAD_Person
birthstate	dim_ACAD_Person
Black	dim_ACAD_Person	The race 'Black' has been recorded for this person. Other races and/or ethnicity could also be indicated for this person.
Bristol_Tim_Walsh	dim_Adm_Scholarship
Building	dim_PriClassMeetingPattern_curr
Building Code	dim_PriClassMeetingPattern_curr
Building -sdescr	dim_PriClassMeetingPattern_curr
c
campus event nbr	dim_ACAD_Class_snap
	fact_ACAD_StudentClassEnrollment_snap
campus id	dim_ACAD_Person
Campus of the Class Section	dim_ACAD_Class_snap	Campus at which the class section is taught
	fact_ACAD_StudentClassEnrollment_snap	Campus at which the class section is taught
Cancel Even If Student Enrolled	dim_ACAD_Class_snap	Select for the system to process a request for a canceled class section regardless of whether students have already enrolled in the section. If you do not select this check box and you attempt to cancel a section in which students have enrolled, the system prevents you from posting the change, keeping the class status active. Thus, by leaving the box cleared you prevent inadvertently canceling a section in which students are enrolled.
	fact_ACAD_StudentClassEnrollment_snap	Select for the system to process a request for a canceled class section regardless of whether students have already enrolled in the section. If you do not select this check box and you attempt to cancel a section in which students have enrolled, the system prevents you from posting the change, keeping the class status active. Thus, by leaving the box cleared you prevent inadvertently canceling a section in which students are enrolled.
Catalog Code	dim_ACAD_Class_snap	The abbreviated Subject-Catalog Nbr-Section Number
	fact_ACAD_StudentClassEnrollment_snap	The abbreviated Subject-Catalog Nbr-Section Number
Catalog Level	dim_ACAD_Class_snap	The hundred level of a class- e.g., 100-level, 200, etc.
	fact_ACAD_StudentClassEnrollment_snap	The hundred level of a class- e.g., 100-level, 200, etc.
Catalog Nbr	dim_ACAD_Class_snap
	fact_ACAD_StudentClassEnrollment_snap
catalog print	dim_Gen_Edu_Reqs
CEEB Any School Type	dim_Adm_Person	The CEEB code for the most recently attended school of any type (high school, college, etc.)
CEEB High School	dim_Adm_Person	The CEEB code for the most recently attended high school (Slate rank 1 school of type: high school)
Census Cohort	dim_ACAD_Program	The cohort term a person has been assigned to. Historical data or manual overrides can be backfilled by adding data to TC_SOURCES.source.census_cohort_override.
Census Division	dim_Adm_Addresses_Consolidated	The nine US Census geographic divisions, plus the US Territories. Miscellaneous are coded as 'Other US'
Census Region	dim_Adm_Addresses_Consolidated	The four Census Regions, plus the US Territories. Miscellaneous are coded as 'Other US'
CIP Code for Subject	dim_ACAD_Class_snap	CIP code for this subject area.
citizen proof1	dim_ACAD_Person
citizen proof2	dim_ACAD_Person
citizenship primary	dim_Adm_Person
citizenship secondary	dim_Adm_Person
citizenship status	dim_Adm_Person	Derived within Slate. US = US Citizen; PR = Permanent Resident; FN = Foreign National
citizenship us refugee asylee	dim_Adm_Person
city	dim_ACAD_Person
	dim_Adm_Addresses_Consolidated
	dim_Adm_segment_analysis_curr	The city of the student's home address.
city ac	dim_ACAD_Person
city other	dim_ACAD_Person
Class Cancel Date	dim_ACAD_Class_snap	Date that the class section was cancelled.
	fact_ACAD_StudentClassEnrollment_snap	Date that the class section was cancelled.
Class Component	dim_ACAD_Class_snap
	fact_ACAD_StudentClassEnrollment_snap
Class Component - LDescr	dim_ACAD_Class_snap
	fact_ACAD_StudentClassEnrollment_snap
Class Component Code	dim_ACAD_Class_snap	This section's component type (lecture, lab, etc.)
	fact_ACAD_StudentClassEnrollment_snap	This section's component type (lecture, lab, etc.)
Class Description	dim_ACAD_Class_snap
	fact_ACAD_StudentClassEnrollment_snap
Class End Date	dim_ACAD_Class_snap	The end date of the class, defaults from the end date of the session.
	fact_ACAD_StudentClassEnrollment_snap	The end date of the class, defaults from the end date of the session.
Class Enrl Type Code	dim_ACAD_Class_snap	The class type of Enrollment indicates which section is the primary section at enrollment time. The class type of Non-Enrollment is used to indicate that the section choice is the student's secondary enrollment option, or that the section is used in auto-enrollment. Within a class, only one component can possess the class type of Enrollment. For example, at PSUNV Microbiology 240 has Lecture, Laboratory, and Discussion components. There are 5 lecture, 10 laboratory, and 15 discussion sections. We might select the discussion sections as the Enrollment sections, the lecture sections as the Non-Enrollment section using auto-enrollment, and the laboratory sections as Non-Enrollment sections with a student choice of lab section at enrollment time.
	fact_ACAD_StudentClassEnrollment_snap	The class type of Enrollment indicates which section is the primary section at enrollment time. The class type of Non-Enrollment is used to indicate that the section choice is the student's secondary enrollment option, or that the section is used in auto-enrollment. Within a class, only one component can possess the class type of Enrollment. For example, at PSUNV Microbiology 240 has Lecture, Laboratory, and Discussion components. There are 5 lecture, 10 laboratory, and 15 discussion sections. We might select the discussion sections as the Enrollment sections, the lecture sections as the Non-Enrollment section using auto-enrollment, and the laboratory sections as Non-Enrollment sections with a student choice of lab section at enrollment time.
Class Enrollment Status	dim_ACAD_Class_snap
	fact_ACAD_StudentClassEnrollment_snap
Class Enrollment Status Code	dim_ACAD_Class_snap	Either Open or Closed
	fact_ACAD_StudentClassEnrollment_snap	Either Open or Closed
Class Enrollment Type	dim_ACAD_Class_snap
	fact_ACAD_StudentClassEnrollment_snap
Class Experience Type	dim_ACAD_Class_snap
	fact_ACAD_StudentClassEnrollment_snap
Class Experience Type Group	dim_ACAD_Class_snap
	fact_ACAD_StudentClassEnrollment_snap
Class ID -unique	dim_ACAD_Class_snap	Warehouse-generated field to uniquely identify class sections that meet together. Concatenation of term and class nbr or combined section ID
Class Meeting Duration	dim_PriClassMeetingPattern_curr	Duration of this class meeting (derived in the warehouse from Start and End times)
class mtg nbr	dim_PriClassMeetingPattern_curr
class nbr	dim_CombinedSection_curr
	fact_ACAD_StudentClassEnrollment_snap
	dim_ACAD_Class_snap	A unique identifier for a class section within a specific term.
	fact_ACAD_StudentClassEnrollment_snap	A unique identifier for a class section within a specific term.
class prmsn nbr	fact_ACAD_StudentClassEnrollment_snap
Class Rank (FR) as a Percentage	dim_Adm_Application_Details	Standardized class rank (from the Final Report) as a percentage.
Class Rank (MR) as a Percentage	dim_Adm_Application_Details	Standardized class rank (from the Mid-Year Report) as a percentage.
Class Rank (SR) as a Percentage	dim_Adm_Application_Details	Standardized class rank (from the School Report) as a percentage.
Class Rank as a Percentage	dim_Adm_Application_Details	Standardized class rank as a percentage [class rank/graduating class size]. Returns the most recent class rank value from the Final Report, or when unavailable, a valid value from the Mid-Year Report, or when unavailable, a valid value from the School Report. The standardization removes raw class ranks that can't be standardized: ranks of "0" or ranks higher than the graduating class size or when the graduating class size is unavailable and the school's reporting method is "Exact [rank]".
Class Rank data quality assessment	dim_Adm_Application_Details	Class Rank data quality assessment
class rank end dt fr	dim_Adm_Application_Details	End date (month/year) of period used to calculate class rank. (From the Final Report).
class rank end dt mr	dim_Adm_Application_Details	End date (month/year) of period used to calculate class rank. (From the Mid-Year Report).
class rank end dt sr	dim_Adm_Application_Details	End date (month/year) of period used to calculate class rank. (From the School Report).
class rank fr - raw	dim_Adm_Application_Details	Raw class rank (from Final Report). Depending on class_rank_reporting_fr, values are either exact, deciles, quartiles, or quintiles.
Class Rank in Bottom Half (50%) of high school class	dim_Adm_Application_Details	This applicant was ranked in the bottom half of their high school graduating class.
Class Rank in Bottom Quarter (25%) of high school class	dim_Adm_Application_Details	This applicant was ranked in the bottom quarter of their high school graduating class.
Class Rank in Top Half (50%) of high school class	dim_Adm_Application_Details	This applicant was ranked in the top half of their high school graduating class.
Class Rank in Top Quarter (25%) of high school class	dim_Adm_Application_Details	This applicant was ranked in the top quarter of their high school graduating class.
Class Rank in Top Tenth (10%) of high school class	dim_Adm_Application_Details	This applicant was ranked in the top tenth of their high school graduating class.
class rank mr - raw	dim_Adm_Application_Details	Raw class rank (from Mid-Year Report). Depending on class_rank_reporting_mr, values are either exact, deciles, quartiles, or quintiles.
Class Rank Nbr	dim_ACAD_Student_Career_Term_snap
class rank reporting fr	dim_Adm_Application_Details	Class rank (from Final Report) reporting format. Values: Exact, Decile, Quartile, Quintile, None
class rank reporting mr	dim_Adm_Application_Details	Class rank (from Mid-Year Report) reporting format. Values: Exact, Decile, Quartile, Quintile, None
class rank reporting sr	dim_Adm_Application_Details	Class rank (from School Report) reporting format. Values: Exact, Decile, Quartile, Quintile, None
class rank sr - raw	dim_Adm_Application_Details	Raw class rank (from School Report). Depending on class_rank_reporting_sr, values are either exact, deciles, quartiles, or quintiles.
class rank start dt fr	dim_Adm_Application_Details	Start date (month/year) of period used to calculate class rank. (From the Final Report).
class rank start dt mr	dim_Adm_Application_Details	Start date (month/year) of period used to calculate class rank. (From the Mid-Year Report).
class rank start dt sr	dim_Adm_Application_Details	Start date (month/year) of period used to calculate class rank. (From the School Report).
Class Rank Total	dim_ACAD_Student_Career_Term_snap
class rank weighting fr	dim_Adm_Application_Details	Class rank weighting (from Final Report). Values: weighted or unweighted.
class rank weighting mr	dim_Adm_Application_Details	Class rank weighting (from Mid-Year Report). Values: weighted or unweighted.
class rank weighting sr	dim_Adm_Application_Details	Class rank weighting (from School Report). Values: weighted or unweighted.
class section	dim_ACAD_Class_snap
	dim_PriClassMeetingPattern_curr
	fact_ACAD_StudentClassEnrollment_snap
Class Start Date	dim_ACAD_Class_snap	The start date of the class, defaults from the start date of the session.
	fact_ACAD_StudentClassEnrollment_snap	The start date of the class, defaults from the start date of the session.
Class Status	dim_ACAD_Class_snap
	fact_ACAD_StudentClassEnrollment_snap
Class Status Code	dim_ACAD_Class_snap	Class status values of A= Active (default), S= Stop Further Enrollment, T= Tentative Section, and X = Cancelled Section
	fact_ACAD_StudentClassEnrollment_snap	Class status values of A= Active (default), S= Stop Further Enrollment, T= Tentative Section, and X = Cancelled Section
Class Type	dim_ACAD_Class_snap	First level classification to separate TC classes from transfer, consortium and misc placeholders
	fact_ACAD_StudentClassEnrollment_snap	First level classification to separate TC classes from transfer, consortium and misc placeholders
Class Type- Legacy	dim_ACAD_Class_snap	Legacy class type code P. PE and C. NC are incorrect because these use UNITS_MAXIMUM from courses
	fact_ACAD_StudentClassEnrollment_snap	Legacy class type code P. PE and C. NC are incorrect because these use UNITS_MAXIMUM from courses
Class_of_63	dim_Adm_Scholarship
CLI Class flag	dim_ACAD_Class_snap
CLI Class Type	dim_ACAD_Class_snap
CLIC class attribute	dim_ACAD_Class_snap
CMTL class attribute	dim_ACAD_Class_snap
college board student id	dim_Adm_Person
Combined Current GPA	dim_ACAD_Student_Career_Term_snap	Term GPA of Enrollments and Transfer Credits
Combined Section Code	dim_ACAD_Class_snap	C = Combined section; S= Combined section -skip meeting pattern
	fact_ACAD_StudentClassEnrollment_snap	C = Combined section; S= Combined section -skip meeting pattern
Combined Section Combination Type	dim_ACAD_Class_snap
	dim_CombinedSection_curr
Combined Section Combination Type - LDescr	dim_ACAD_Class_snap
	dim_CombinedSection_curr
Combined Section Group Name	dim_ACAD_Class_snap	Name of the group of combined sections
	dim_CombinedSection_curr	Name of the group of combined sections
Combined Section Group Short Name	dim_ACAD_Class_snap	Short name of the group of combined sections
	dim_CombinedSection_curr	Short name of the group of combined sections
Combined Section ID	dim_ACAD_Class_snap
Combined Section Type	dim_ACAD_Class_snap	MAST = master section of the group of combined section SECN = secondary section of the group of combined section
	fact_ACAD_StudentClassEnrollment_snap	MAST = master section of the group of combined section SECN = secondary section of the group of combined section
Common App ID	fact_Adm_Applications	Common Application ID
Common App payment type - raw	dim_Adm_Application_Details	An indication of whether student paid application fee or received a fee waiver. [Not populated prior to 2017 cycle] Regular CommonApp populates values: EPayment, Common App Fee Waiver, Member Fee Waiver, No Fee, Fee waiver granted by college Transfer CommonApp populates Yes/No from question: "Do your financial circumstances qualify you for Fee Waiver?"
CommonApp Tracking Reference	fact_Adm_Applications	CommonApp's tracking of URL referrer.
Component Graded	dim_ACAD_Class_snap
Connecticut	dim_Adm_Scholarship
consent to mobile contact	dim_Adm_Application_Details
continent	dim_Adm_Addresses_Consolidated
country	dim_ACAD_Person
	dim_Adm_Addresses_Consolidated
	dim_ACAD_Student_Career_Term_snap
country code	dim_ACAD_Person
country fips	dim_Adm_Addresses_Consolidated
country full name	dim_Adm_Addresses_Consolidated
country nm format	dim_ACAD_Person
country other	dim_ACAD_Person
country sort name	dim_Adm_Addresses_Consolidated
county	dim_ACAD_Person
	dim_Adm_Addresses_Consolidated
county other	dim_ACAD_Person
Course Administrator	dim_ACAD_Class_snap	The EMPLID of the person in charge of the course (usually the primary instructor). This field is informational only.
	fact_ACAD_StudentClassEnrollment_snap	The EMPLID of the person in charge of the course (usually the primary instructor). This field is informational only.
Course Equivalent	dim_ACAD_Class_snap	The equivalent course group ID number.
	fact_ACAD_StudentClassEnrollment_snap	The equivalent course group ID number.
Course Topic ID	dim_ACAD_Class_snap	The ID number of the topic attached to this class section.
	fact_ACAD_StudentClassEnrollment_snap	The ID number of the topic attached to this class section.
Course Units	fact_ACAD_StudentClassEnrollment_snap	Logic copied from IRP table build
cpamid	dim_ACAD_Person
created date	dim_Adm_Person
credit hours	dim_Adm_School_Attendance	The number of credit hours received from this institution.
Crs Topic Id	dim_PriClassMeetingPattern_curr
crse career	fact_ACAD_StudentClassEnrollment_snap
crse count	fact_ACAD_StudentClassEnrollment_snap
crse grade input	fact_ACAD_StudentClassEnrollment_snap
crse grade off	fact_ACAD_StudentClassEnrollment_snap
crse id	dim_ACAD_Class_snap
	dim_PriClassMeetingPattern_curr
	fact_ACAD_StudentClassEnrollment_snap
crse offer nbr	dim_ACAD_Class_snap
	dim_PriClassMeetingPattern_curr
	fact_ACAD_StudentClassEnrollment_snap
CSS financial aid profile waiver	dim_Adm_Application_Details
Cumulative GPA	dim_ACAD_Student_Career_Term_snap
Cumulative in Residence Terms	dim_ACAD_Student_Career_Term_snap
current bin	fact_Adm_Applications	This column is cleared out after each cycle and should only be populated with bin information from the current cycle.
current bin guid	fact_Adm_Applications	This column is cleared out after each cycle and should only be populated with bin information from the current cycle. This GUID is pulled from the bin.lookup table.
Current GPA	dim_ACAD_Student_Career_Term_snap
Current in Residence Terms	dim_ACAD_Student_Career_Term_snap
Curriculum Category	dim_ACAD_Class_snap
d
Davis_UWC	dim_Adm_Scholarship
death certif nbr	dim_ACAD_Person
deceased	dim_Adm_Person
deceased date	dim_Adm_Person
Decision Confirmed History	fact_Adm_Applications	A concatenation of all decisions taking into account Slate's Decision Confirmed Flag, in reverse chronological order. Here is the format to expect: [Decision_Code; Decision_Reason \| Decision_Code; Decision_Reason] where rank confirmed is not null and rank confirmed is > 0. order is by rank confirmed ascending
Decision History All	fact_Adm_Applications	A concatenation of all decisions in reverse chronological order. Here is the format to expect: [Decision_Code; Decision_Reason \| Decision_Code; Decision_Reason] where rank is not null and rank is > 0. order is by rank ascending
Defer Confirmed Date	dim_Adm_Decisions
Defer from Early Decision	dim_Adm_Application_Details	Indicates decision deferral type between early decision and a future round.
Defer Letter	dim_Adm_Decisions
Defer Reason	dim_Adm_Decisions
Defer Received Date	dim_Adm_Decisions
Defer Released Date	dim_Adm_Decisions
degree	dim_Degrees_curr
degree code	dim_Degrees_curr
degree conferred	dim_Adm_School_Attendance	The type of degree conferred.
degree conferred date	dim_Adm_School_Attendance	The date the degree was confirmed (or expected to be confirmed).
degree formal name	dim_Degrees_curr
degree level	dim_Degrees_curr	Derived field for Bachelor's, Master's, etc.
degree name	dim_Degrees_curr
Deny Confirmed Date	dim_Adm_Decisions
Deny Letter	dim_Adm_Decisions
Deny Reason	dim_Adm_Decisions
Deny Received Date	dim_Adm_Decisions
Deny Released Date	dim_Adm_Decisions
Deposit Pending Confirmed Date	dim_Adm_Decisions
Deposit Pending Letter	dim_Adm_Decisions
Deposit Pending Reason	dim_Adm_Decisions
Deposit Pending Received Date	dim_Adm_Decisions
Deposit Pending Released Date	dim_Adm_Decisions
Deposit Status	fact_Adm_Applications	Indicates whether the student has paid a deposit, has a deposit pending, or received a waiver.
descr	dim_Gen_Edu_Reqs
descrformal	dim_Gen_Edu_Reqs
descrshort	dim_Gen_Edu_Reqs
Design_Fellow	dim_Adm_Scholarship
dim ACAD Person key	fact_ACAD_StudentClassEnrollment_snap	Generated artificial key
dim ACAD Student Caree key	fact_ACAD_StudentClassEnrollment_snap	Generated artificial key
dim Adm Address Perm key	fact_Adm_Applications	Generated artificial key
dim Adm Addresses Acti key	fact_Adm_Applications	Generated artificial key
dim Adm Addresses Cons key	fact_Adm_Applications	Generated artificial key
dim Adm Addresses Mail key	fact_Adm_Applications	Generated artificial key
dim Adm Application De key	fact_Adm_Applications	Generated artificial key - link to Adm Application Details Dimension
dim Adm Decisions key	fact_Adm_Applications	Generated artificial key
dim Adm Person key	fact_Adm_Applications	Generated artificial key - link to Adm Person Dimension
dim Adm Scholarship key	fact_Adm_Applications	Generated artificial key
dim Adm School Attenda key	fact_Adm_Applications	Generated artificial key
dim Adm segment analys key	fact_Adm_Applications	Generated artificial key
dim adm Superscores Ve key	fact_Adm_Applications	Generated artificial key - link to Adm Superscores Dimension
dim CombinedSection cu key	fact_ACAD_StudentClassEnrollment_snap	Generated artificial key
dim Course Enrl Codes key	fact_ACAD_StudentClassEnrollment_snap	Generated artificial key
dim FA StudentAwardYea key	fact_Adm_Applications	Generated artificial key
dim Gen Edu Reqs key	fact_ACAD_StudentClassEnrollment_snap	Generated artificial key
dim snap Class key	fact_ACAD_StudentClassEnrollment_snap	Generated artificial key
dim Student AcadPlan c key	fact_ACAD_StudentClassEnrollment_snap	Generated artificial key
dim TermSession key	fact_ACAD_StudentClassEnrollment_snap	Generated artificial key
disabled	dim_ACAD_Person
disabled vet	dim_ACAD_Person
distance to trin	dim_Adm_Addresses_Consolidated	Distance (in miles) from the address to Trinity. (Direct distance as the crow flies, not driving distance) This is calculated using delivered SQL functions within the Slate address query. Trinity latitude: -72.6924223 and longitude: 41.749967. sql generated by slate as of 1.30.2020 left((ads__JID_.[geo].STDistance(geography::STGeomFromText('point(' + '-72.6924223' + ' ' + '41.749967' + ')', 4326)) / 1609.344), '6')
drop class if enrl	fact_ACAD_StudentClassEnrollment_snap
Drop Consent Required	dim_ACAD_Class_snap	Type of consent required to drop a section. I= instructor, D= department, N= no consent
	fact_ACAD_StudentClassEnrollment_snap	Type of consent required to drop a section. I= instructor, D= department, N= no consent
dss dv active flag	dim_ACAD_Class_snap	This flag indicates if the current row can be found in a source system
	dim_ACAD_Student_Career_Term_snap	This flag indicates if the current row can be found in a source system
	dim_Adm_Application_Details	This flag indicates if the current row can be found in a source system
	dim_Adm_Person	This flag indicates if the current row can be found in a source system
	dim_Adm_School_Attendance	This flag indicates if the current row can be found in a source system
	dim_adm_Superscores_Verified	This flag indicates if the current row can be found in a source system
	fact_ACAD_StudentClassEnrollment_snap	This flag indicates if the current row can be found in a source system
	fact_Adm_Applications	This flag indicates if the current row can be found in a source system
dss dv end date	dim_Adm_Application_Details	timestamp when record is ended in the satellite
	dim_Adm_Person	timestamp when record is ended in the satellite
	dim_Adm_School_Attendance	timestamp when record is ended in the satellite
	fact_Adm_Applications	timestamp when record is ended in the satellite
dss dv load date	dim_Adm_Addresses_Consolidated	Date and time the row was loaded in the data vault
	dim_Adm_Application_Details	Date and time the row was loaded in the data vault
	dim_Adm_School_Attendance	Date and time the row was loaded in the data vault
	fact_Adm_Applications	Date and time the row was loaded in the data vault
dss dv start date	dim_Adm_Application_Details	Date and time the row was inserted into the data vault
	dim_Adm_Person	Date and time the row was inserted into the data vault
	dim_Adm_School_Attendance	Date and time the row was inserted into the data vault
	fact_Adm_Applications	Date and time the row was inserted into the data vault
dss dv version	dim_Adm_Application_Details	Version number of a business key in the data vault
	dim_Adm_Person	Version number of a business key in the data vault
	dim_Adm_School_Attendance	Version number of a business key in the data vault
	dim_adm_Superscores_Verified	Version number of a business key in the data vault
	fact_Adm_Applications	Version number of a business key in the data vault
dss end date	dim_ACAD_Class_snap	timestamp when record is ended in the satellite
	dim_Adm_Decisions
	fact_ACAD_StudentClassEnrollment_snap	timestamp when record is ended in the satellite
dss load date	dim_ACAD_Class_snap	Date and time the row was loaded in the data vault
	dim_ACAD_Student_Career_Term_snap	Date and time the row was loaded in the data vault
	dim_Adm_Person	Date and time the row was loaded in the data vault
	fact_ACAD_StudentClassEnrollment_snap	Date and time the row was loaded in the data vault
dss record source	dim_ACAD_Class_snap	Record source
dss start date	dim_ACAD_Class_snap	Date and time the row was inserted into the data vault
	dim_Adm_Decisions
	fact_ACAD_StudentClassEnrollment_snap	Date and time the row was inserted into the data vault
dss version	fact_ACAD_StudentClassEnrollment_snap	Version number of a business key in the data vault
dt of death	dim_ACAD_Person
dyn class nbr	fact_ACAD_StudentClassEnrollment_snap
dyn dt include	dim_ACAD_Class_snap	Include in dynamic date calculations
	fact_ACAD_StudentClassEnrollment_snap	Include in dynamic date calculations
Dynamic Date Calc Required	dim_ACAD_Class_snap
	fact_ACAD_StudentClassEnrollment_snap
e
earn credit	fact_ACAD_StudentClassEnrollment_snap
education level	dim_Degrees_curr
Educational Neighborhood Cluster	dim_Adm_segment_analysis_curr	Code which is used to generally describe the geodemographic status of the neighborhood in which the student lives.
eff status	dim_DegreeHonors_curr
	dim_Degrees_curr
	dim_Gen_Edu_Reqs
effdt	dim_DegreeHonors_curr
	dim_Degrees_curr
	dim_Gen_Edu_Reqs
	dim_Student_AcadPlan_curr
effdt_end	dim_Student_AcadPlan_curr
Eligible to Enroll	dim_ACAD_Student_Career_Term_snap	Default Value = 'Y'
email	dim_Adm_Person
emplid	dim_ACAD_Person
	dim_ACAD_Program
	dim_Adm_Person	A unique identification number for a person created in Peoplesoft.
	dim_Student_AcadPlan_curr
	fact_ACAD_StudentClassEnrollment_snap
	fact_Adm_Applications	A unique identification number for a person created in Peoplesoft.
Employee ID	dim_ACAD_Student_Career_Term_snap
End Date	dim_ACAD_Student_Career_Term_snap
End Dt	dim_PriClassMeetingPattern_curr
enrl action last	fact_ACAD_StudentClassEnrollment_snap
enrl actn prc last	fact_ACAD_StudentClassEnrollment_snap
enrl actn rsn last	fact_ACAD_StudentClassEnrollment_snap
enrl add dt	fact_ACAD_StudentClassEnrollment_snap
enrl drop dt	fact_ACAD_StudentClassEnrollment_snap
enrl req source	fact_ACAD_StudentClassEnrollment_snap
enrl status reason	fact_ACAD_StudentClassEnrollment_snap
Enrl Status Rsn - Long Descr	dim_Course_Enrl_Codes_curr
enrl_dss dv active flag	fact_ACAD_StudentClassEnrollment_snap	This flag indicates if the current row can be found in a source system
enrl_dss end date	fact_ACAD_StudentClassEnrollment_snap	timestamp when record is ended in the satellite
enrl_dss start date	fact_ACAD_StudentClassEnrollment_snap	Date and time the row was inserted into the data vault
Enroll Consent Required	dim_ACAD_Class_snap	Type of consent required to enroll in a section. I= instructor, D= department, N= no consent
	fact_ACAD_StudentClassEnrollment_snap	Type of consent required to enroll in a section. I= instructor, D= department, N= no consent
Enrolled in Gateway Program	dim_Adm_Person	Gateway Program assignment: Cities Program, Interdisciplinary Science Program (ISP), etc.
Enrolled Student Final	dim_ACAD_Class_snap	student status = E
	fact_ACAD_StudentClassEnrollment_snap	student status = E
Enrolled Student Peoplesoft Calculation	dim_ACAD_Class_snap	student status = E,W
	fact_ACAD_StudentClassEnrollment_snap	student status = E, W
Enrolled Undergraduate Student Final	dim_ACAD_Class_snap	student status = E and acad_career = UGRD
	fact_ACAD_StudentClassEnrollment_snap	student status = E and acad_career = UGRD
Enrollment Capacity- Combined Section	dim_ACAD_Class_snap	Enrollment capacity of the combined section group
	dim_CombinedSection_curr	Enrollment capacity of the combined section group
Enrollment Capacity of the Section	dim_ACAD_Class_snap	The maximum number of students allowed to enroll in the class.
	fact_ACAD_StudentClassEnrollment_snap	The maximum number of students allowed to enroll in the class.
Enrollment Cumulative GPA	dim_ACAD_Student_Career_Term_snap	Cumulative Enrollment GPA
Enrollment Grade Points	dim_ACAD_Student_Career_Term_snap	Cumulative Enrollment Grade Points
Enrollment Request Source	dim_Course_Enrl_Codes_curr
Enrollment Status Reason	dim_Course_Enrl_Codes_curr
Enrollment Total- Combined Section	dim_ACAD_Class_snap	Total enrollment of the combined section group
	dim_CombinedSection_curr	Total enrollment of the combined section group
Enrollment Total of the Section	dim_ACAD_Class_snap	The total number of students enrolled for the section.
	fact_ACAD_StudentClassEnrollment_snap	The total number of students enrolled for the section.
entry dt fra	dim_ACAD_Person
entry strm	dim_Adm_Person	This is the Peoplesoft code that represents a particular term. In Slate, this value is hardcoded into the Export field for each entry_term defined.
	fact_Adm_Applications	This is the Peoplesoft code that represents a particular term. In Slate, this value is hardcoded into the Export field for each entry_term defined.
entry term	dim_Adm_Person	Trinity custom field that is Person Scoped. This value changes whenever data comes in from a prospect/inquiry/applicant.
	dim_Adm_segment_analysis_curr	Trinity custom field that is Person Scoped. This value changes whenever data comes in from a prospect/inquiry/applicant.
	fact_Adm_Applications	Trinity custom field that is Person Scoped. This value changes whenever data comes in from a prospect/inquiry/applicant.
Equivalent Course Override	dim_ACAD_Class_snap	Override the Equivalent Course setting
	fact_ACAD_StudentClassEnrollment_snap	Override the Equivalent Course setting
Exam Seat Spacing	dim_ACAD_Class_snap	The number of seats between students during the final exam. For informational purposes only.
	fact_ACAD_StudentClassEnrollment_snap	The number of seats between students during the final exam. For informational purposes only.
expctd military dt	dim_ACAD_Person
ext writeoff	fact_ACAD_StudentClassEnrollment_snap
extension	dim_ACAD_Person
External Org ID	dim_ACAD_Student_Career_Term_snap
f
FA Stats Calc Date Time	dim_ACAD_Student_Career_Term_snap
FA Stats Calculation Required	dim_ACAD_Student_Career_Term_snap	Default Value = 'N'
FA Units Taken Toward GPA	dim_ACAD_Student_Career_Term_snap
Facility ID	dim_PriClassMeetingPattern_curr
Facility Type	dim_PriClassMeetingPattern_curr
Facility Type Code	dim_PriClassMeetingPattern_curr
Facility Type -sdescr	dim_PriClassMeetingPattern_curr
Fees Exist	dim_ACAD_Class_snap	Yes/no flag
	fact_ACAD_StudentClassEnrollment_snap	Yes/no flag
ferpa	dim_ACAD_Person
field of study	dim_Adm_School_Attendance	Field of study a student had in the school.
Field of Study for the Subject	dim_ACAD_Class_snap	Field of Study for this subject area
Fin Aid Progress Units Passed	dim_ACAD_Student_Career_Term_snap
Fin Aid Progress Units Taken	dim_ACAD_Student_Career_Term_snap
final rating recommended decision	fact_Adm_Applications
financial aid	fact_Adm_Applications	Indicates whether student intends to apply for financial aid. Values: Yes, No, Unknown
Financial Aid Grade Points	dim_ACAD_Student_Career_Term_snap
Financial Aid Load	dim_ACAD_Student_Career_Term_snap
Financial_Incentive	dim_Adm_Scholarship
first	dim_Adm_Person
first generation	dim_Adm_Person
First Generation in college	dim_Adm_Application_Details	First-generation status (originates from a submitted Common App) [application-scoped custom field in Slate]
first name	dim_ACAD_Person
first name srch	dim_ACAD_Person
First Term	dim_ACAD_Program	First term with some IR logic applied
First Time in Career	dim_ACAD_Student_Career_Term_snap	Defualt Value = 'Y'
first year or transfer	dim_Adm_Person	Trinity custom field that is Person Scoped. This indicates whether the person is a first year student, transfer student, IDP, or graduate student. This field does not reflect the status per application so practice caution when using this field to count records. Example: student applies in fall 2018 and they are marked as first year. Student applies again in fall 2020 and because this field is person scoped the status is changed from first year to transfer. When looking at applications from both 2018 and 2020, the value in this field will be transfer for both records.
	fact_Adm_Applications	Trinity custom field that is Person Scoped. This indicates whether the person is a first year student, transfer student, IDP, or graduate student. This field does not reflect the status per application so practice caution when using this field to count records. Example: student applies in fall 2018 and they are marked as first year. Student applies again in fall 2020 and because this field is person scoped the status is changed from first year to transfer. When looking at applications from both 2018 and 2020, the value in this field will be transfer for both records.
Form of Study	dim_ACAD_Student_Career_Term_snap	Default Value = 'ENRL'
Forrester	dim_Adm_Scholarship
Fri	dim_PriClassMeetingPattern_curr
ft student	dim_ACAD_Person
Fully Enrolled Date	dim_ACAD_Student_Career_Term_snap
Fully Graded Date	dim_ACAD_Student_Career_Term_snap
g
Gap Defer Confirmed Date	dim_Adm_Decisions
Gap Defer Letter	dim_Adm_Decisions
Gap Defer Reason	dim_Adm_Decisions
Gap Defer Received Date	dim_Adm_Decisions
Gap Defer Released Date	dim_Adm_Decisions
Gap Matric Confirmed Date	dim_Adm_Decisions
Gap Matric Letter	dim_Adm_Decisions
Gap Matric Reason	dim_Adm_Decisions
Gap Matric Received Date	dim_Adm_Decisions
Gap Matric Released Date	dim_Adm_Decisions
gender identity	dim_Adm_Person
Generate Class Attend	dim_ACAD_Class_snap	Indicates that the system always generatse attendance rosters for this class.
	fact_ACAD_StudentClassEnrollment_snap	Indicates that the system always generatse attendance rosters for this class.
geo code	dim_ACAD_Person
geo code other	dim_ACAD_Person
geomarket	dim_Adm_Addresses_Consolidated
geomarket guid	dim_Adm_Addresses_Consolidated
gl interface req	fact_ACAD_StudentClassEnrollment_snap
Global_Scholar	dim_Adm_Scholarship
Global_Symposium	dim_Adm_Scholarship
GPA bin for CDS	dim_Adm_Application_Details	GPA binned values for Common Data Set
GPA cumulative	dim_Adm_Application_Details	Cumulative GPA; populated by the most recent upload of a school report, mid-year report, or final report
GPA data quality assessment	dim_Adm_Application_Details	GPA data quality assessment
GPA indicated on the Final Report	dim_Adm_Application_Details	GPA indicated on the Final Report
GPA indicated on the Mid-Year Report	dim_Adm_Application_Details	GPA indicated on the Mid-Year Report
GPA indicated on the School Report	dim_Adm_Application_Details	GPA indicated on the School Report
GPA scale	dim_Adm_Application_Details	GPA scale; populated by the most recent upload of a school report, mid-year report, or final report
GPA Standardized on a 4.0 scale	dim_Adm_Application_Details	GPA standardized on a 4.0 scale
GPA standardized on a letter grade scale	dim_Adm_Application_Details	GPA standardized on a letter grade scale
GPA Weighting	dim_Adm_Application_Details	Indicates whether GPA is Weighted or Unweighted; populated by the most recent upload of a school report, mid-year report, or final report
grade	dim_ACAD_Person
grade category	fact_ACAD_StudentClassEnrollment_snap
grade dt	fact_ACAD_StudentClassEnrollment_snap
grade points	fact_ACAD_StudentClassEnrollment_snap
	dim_ACAD_Student_Career_Term_snap
grade points fa	fact_ACAD_StudentClassEnrollment_snap
Grading Basis	dim_Course_Enrl_Codes_curr
Grading Basis Code	dim_Course_Enrl_Codes_curr
grading basis dt	fact_ACAD_StudentClassEnrollment_snap
grading basis enrl	fact_ACAD_StudentClassEnrollment_snap
Grading Basis of the class	dim_ACAD_Class_snap
grading scheme enr	fact_ACAD_StudentClassEnrollment_snap
graduating class size	dim_Adm_Application_Details	Size of the graduating class (from the counselor's description of the school profile in their Common App recommendation)
grd pts per unit	fact_ACAD_StudentClassEnrollment_snap
GS_Symposium	dim_Adm_Scholarship
gvt change flag	dim_ACAD_Person
gvt cred mil svce	dim_ACAD_Person
gvt curr agcy empl	dim_ACAD_Person
gvt curr fed empl	dim_ACAD_Person
gvt disability cd	dim_ACAD_Person
gvt draft status	dim_ACAD_Person
gvt high grade	dim_ACAD_Person
gvt high pay plan	dim_ACAD_Person
gvt mil grade	dim_ACAD_Person
gvt mil resrve cat	dim_ACAD_Person
gvt mil sep ret	dim_ACAD_Person
gvt mil svce end	dim_ACAD_Person
gvt mil svce start	dim_ACAD_Person
gvt mil verify	dim_ACAD_Person
gvt military comp	dim_ACAD_Person
gvt par nbr last	dim_ACAD_Person
gvt pay plan	dim_ACAD_Person
gvt prev agcy empl	dim_ACAD_Person
gvt prev fed empl	dim_ACAD_Person
gvt sep incent dt	dim_ACAD_Person
gvt sep incentive	dim_ACAD_Person
gvt tenure	dim_ACAD_Person
gvt unif svc ctr	dim_ACAD_Person
gvt vet pref appt	dim_ACAD_Person
gvt vet pref rif	dim_ACAD_Person
gvt yr attained	dim_ACAD_Person
h
has ACT	dim_adm_Superscores_Verified	Student record includes a verified ACT test
has Application Fee Waiver	dim_Adm_Application_Details	Application fee was waived.
has Class Rank	dim_Adm_Application_Details	This applicant has a valid class rank provided by their high school (as standardized by the logic in the class_rank_percentage column).
has CSS Profile Application Fee Waiver	dim_Adm_Application_Details	The CSS Profile application fee was waived.
has Enrollment Deposit Waiver	dim_Adm_Application_Details	The enrollment deposit was waived.
has GPA	dim_Adm_Application_Details	This applicant has a GPA provided by their high school.
has Legacy tag	dim_Adm_Person	The Legacy tag is set on the person record in Slate
has SAT-I	dim_adm_Superscores_Verified	Student record includes a verified SAT-I test
has SAT-II	dim_adm_Superscores_Verified	Student record includes a verified SAT II subject test
has SAT-R	dim_adm_Superscores_Verified	Student record includes a verified SAT-R test
health care nbr	dim_ACAD_Person
health care state	dim_ACAD_Person
High School % Applying Out of State	dim_Adm_segment_analysis_curr	Percent of students in a high school that applied to an out of state college.
High School % Below Poverty Line	dim_Adm_segment_analysis_curr	ACS based percent of students at the high school who are below the poverty line.
High School % Black	dim_Adm_segment_analysis_curr	ACS based percent of students at a high school who are black.
High School % Catholic	dim_Adm_segment_analysis_curr	Percent of students in a high school that are Catholic.
High School % Christian(non-Catholic)	dim_Adm_segment_analysis_curr	Percent of students in a high school that are Christian.
High School % English Only	dim_Adm_segment_analysis_curr	Percent of student in high school who report that they only speak English.
High School % Female	dim_Adm_segment_analysis_curr	Percent of students in a high school that are female.
High School % Hispanic	dim_Adm_segment_analysis_curr	ACS based percent of students at a high school who are Hispanic.
High School % in Private High School	dim_Adm_segment_analysis_curr	Percent of students reporting they are attending a private high school
High School % in Religious High School	dim_Adm_segment_analysis_curr	Percent of student reporting they are attending a religiously affiliated high school
High School % Interested in Religious College	dim_Adm_segment_analysis_curr	Percent of students in a high school who are interested in attending a religiously affiliated college.
High School % Moving in Past 2 Years	dim_Adm_segment_analysis_curr	ACS based percent of students at the high school that have moved in the past 2 years.
High School % Needing Financial Aid	dim_Adm_segment_analysis_curr	Percent of students in a high school that require financial aid for college.
High School % of Colleges Receiving Scores that are 4 Year	dim_Adm_segment_analysis_curr	Percent of colleges receiving score sends from students at a high school that are 4 year colleges.
High School % White	dim_Adm_segment_analysis_curr	ACS based percent of students at a high schools who are white.
High School % with Parent Education of < High School	dim_Adm_segment_analysis_curr	Percent of students in a high school who reported that no parent had education beyond high school.
High School Academic 2	dim_Adm_segment_analysis_curr	High school D+ factor score for student grades. Values: -9.999 - +9.999
High School Academic 3	dim_Adm_segment_analysis_curr	High school D+ factor score for academic ability. Values: -9.999 - +9.999
High School Academic 4	dim_Adm_segment_analysis_curr	High school D+ factor score for content area strengths/weaknesses. Values: -9.999 - +9.999
High School American Community Survey 1	dim_Adm_segment_analysis_curr	High school D+ factor score for community work category. (Professional vs Working Class) Values: -9.999 - +9.999
High School American Community Survey 2	dim_Adm_segment_analysis_curr	High school D+ factor score for community income category. (Blue Collar vs low income) Values: -9.999 - +9.999
High School American Community Survey 3	dim_Adm_segment_analysis_curr	High school D+ factor score for community category. (white suburban or black inner city) Values: -9.999 - +9.999
High School American Community Survey 4	dim_Adm_segment_analysis_curr	High school D+ factor score for family category (large family or older retired). Values: -9.999 - +9.999
High School American Community Survey 5	dim_Adm_segment_analysis_curr	High school D+ factor scores for residential stability (rural stability or highly mobile) Values: -9.999 - +9.999
High School Average # of AP Tests	dim_Adm_segment_analysis_curr	Average # of AP tests taken by students in a high school.
High School Average # of Honors Courses	dim_Adm_segment_analysis_curr	Average # of Honors courses taken by students in a high school.
High School Average # of SAT Score Sends	dim_Adm_segment_analysis_curr	Average number of scores sends for students in a high school
High School Average Admit Rate of Colleges Receiving Scores	dim_Adm_segment_analysis_curr	Average rate of admissions for colleges receiving score sends from students at a high school.
High School Average Cost of Colleges Receiving Scores	dim_Adm_segment_analysis_curr	Average cost for colleges receiving score sends from students at a high school.
High School Average Enrolled Test Score of Colleges Receiving Scores	dim_Adm_segment_analysis_curr	Average SAT score of students enrolled in a college receiving scores sends from students at the high school.
High School Average Retention Rate of Colleges Receiving Scores	dim_Adm_segment_analysis_curr	Retention rate of colleges receiving scores sends from students at the high school.
High School Cluster	dim_Adm_School_Attendance	Code which is used to generally describe the geodemographic status of the high school that the student attends.
	dim_Adm_segment_analysis_curr	Code which is used to generally describe the geodemographic status of the high school that the student attends.
High School Code	dim_Adm_segment_analysis_curr	This is the high school code that was provided to college board.
High School College Application 1	dim_Adm_segment_analysis_curr	High school D+ factor score for college application focus of public/private. Values: -9.999 - +9.999
High School College Application 2	dim_Adm_segment_analysis_curr	High school D+ factor score for college application financial constraints. Values: -9.999 - +9.999
High School College Application 3	dim_Adm_segment_analysis_curr	High school D+ factor score for college application focus of sectarian/non-sectarian. Values: -9.999 - +9.999
High School College Application 4	dim_Adm_segment_analysis_curr	High school D+ factor score for college application focus of focused/early decision/multiple applications. Values: -9.999 - +9.999
High School College Interest 1	dim_Adm_segment_analysis_curr	High school D+ factor score for national selective vs local technical college interest. Values: -9.999 - +9.999
High School College Interest 2	dim_Adm_segment_analysis_curr	High school D+ factor score for public/private college interest. Values: -9.999 - +9.999
High School College Interest 3	dim_Adm_segment_analysis_curr	High school D+ factor score for sectarian college interest. Values: -9.999 - +9.999
High School College Interest 4	dim_Adm_segment_analysis_curr	High school D+ factor score for coed/single gender college interest. Values: -9.999 - +9.999
High School Demographic 1	dim_Adm_segment_analysis_curr	High school D+ factor score Christian culture. Values: -9.999 - +9.999
High School Demographic 2	dim_Adm_segment_analysis_curr	High school D+ factor score for Catholic culture. Values: -9.999 - +9.999
High School Demographic 3	dim_Adm_segment_analysis_curr	High school D+ factor score for Jewish culture. Values: -9.999 - +9.999
High School Demographic 4	dim_Adm_segment_analysis_curr	High school D+ factor score for gender. Values: -9.999 - +9.999
High School Demographic 5	dim_Adm_segment_analysis_curr	High school D+ factor score for college prep culture. Values: -9.999 - +9.999
High School Diversity 1	dim_Adm_segment_analysis_curr	High school D+ factor score for high school Asian population. Values: -9.999 - +9.999
High School Diversity 2	dim_Adm_segment_analysis_curr	High school D+ factor score for high school African-American population. Values: -9.999 - +9.999
High School Diversity 3	dim_Adm_segment_analysis_curr	High school D+ factor score for high school Hispanic population. Values: -9.999 - +9.999
High School Diversity 4	dim_Adm_segment_analysis_curr	High school D+ factor score for high school Mexican population. Values: -9.999 - +9.999
High School Diversity 5	dim_Adm_segment_analysis_curr	High school D+ factor score for high school Puerto Rican/Caribbean ESL population. Values: -9.999 - +9.999
High School Median Adjusted Housing Value	dim_Adm_segment_analysis_curr	ACS based median house values as a percentage of average state value of students at the high school
High School Median Family Income	dim_Adm_segment_analysis_curr	ACS based median family income of students at the high school.
High School Opportunity 1	dim_Adm_segment_analysis_curr	High school D+ factor score for strength of academic curriculum. Values: -9.999 - +9.999
High School Opportunity 2	dim_Adm_segment_analysis_curr	High school D+ factor score AP/Honors curriculum. Values: -9.999 - +9.999
High School Opportunity 3	dim_Adm_segment_analysis_curr	High school D+ factor score for religious curriculum. Values: -9.999 - +9.999
High School Opportunity 4	dim_Adm_segment_analysis_curr	High school D+ factor score for college prep curriculum. Values: -9.999 - +9.999
High School Opportunity 5	dim_Adm_segment_analysis_curr	High school D+ factor score for breadth of curriculum. Values: -9.999 - +9.999
High School Per Capita Income	dim_Adm_segment_analysis_curr	ACS based average per capita income of students at the high school.
High School SAT CR Score	dim_Adm_segment_analysis_curr	Average score on the CR section of the SAT for all students in a high school.
High School SAT Math Score	dim_Adm_segment_analysis_curr	Average score on the math section of the SAT for all students in a high school.
High School SAT Writing Score	dim_Adm_segment_analysis_curr	Average score on the writing section of the SAT for all students in a high school.
High School Self Reported Parent Income	dim_Adm_segment_analysis_curr	Average income of parents of students in a high school.
High School SES 1	dim_Adm_segment_analysis_curr	High school D+ factor school for level of education. Values: -9.999 - +9.999
High School SES 2	dim_Adm_segment_analysis_curr	High school D+ factor score for socioeconomic class. Values: -9.999 - +9.999
High School Student Achievement 1	dim_Adm_segment_analysis_curr	High school D+ factor score for student community achievement. Values: -9.999 - +9.999
High School Student Achievement 2	dim_Adm_segment_analysis_curr	High school D+ factor score for leadership achievement. Values: -9.999 - +9.999
High School Student Achievement 3	dim_Adm_segment_analysis_curr	High school D+ factor score for art achievement. Values: -9.999 - +9.999
High School Student Achievement 4	dim_Adm_segment_analysis_curr	High school D+ factor score for athletic achievement. Values: -9.999 - +9.999
High School Student Achievement 5	dim_Adm_segment_analysis_curr	High school D+ factor score for religious achievement. Values: -9.999 - +9.999
High School Student Achievement 6	dim_Adm_segment_analysis_curr	High school D+ factor score for ethnic achievement. Values: -9.999 - +9.999
highest educ lvl	dim_ACAD_Person
Hillel	dim_Adm_Scholarship
hispanic	dim_Adm_Person
	dim_ACAD_Person	The ethnicity 'Hispanic or Latino' has been recorded for this person. Other races and/or ethnicity could also be recorded for this person.
Holiday Schedule	dim_ACAD_Class_snap	Defaults to the holiday schedule from the session.
	fact_ACAD_StudentClassEnrollment_snap	Defaults to the holiday schedule from the session.
honors code	dim_DegreeHonors_curr
honors type	dim_DegreeHonors_curr
honors_formal_name	dim_DegreeHonors_curr
honors_sdescr	dim_DegreeHonors_curr
honors_title	dim_DegreeHonors_curr
honseki jpn	dim_ACAD_Person
house type	dim_ACAD_Person
house type other	dim_ACAD_Person
housing interest	fact_Adm_Applications	Indicates whether student intends to live on- or off-campus.
How learned about Trinity 1	dim_Adm_Application_Details	Referral source. The first value specified by student on the Common App.
hr responsible id	dim_ACAD_Person
hs acad1	dim_Adm_segment_analysis_curr
i
ielts listening	dim_adm_Superscores_Verified	Best verified IELTS Listening score; score range: 0 to 9
ielts overall band score	dim_adm_Superscores_Verified	Best verified IELTS overall score; score range: 1 to 9
ielts reading	dim_adm_Superscores_Verified	Best verified IELTS Reading score; score range: 0 to 9
ielts speaking	dim_adm_Superscores_Verified	Best verified IELTS Speaking score; score range: 0 to 9
ielts writing	dim_adm_Superscores_Verified	Best verified IELTS Writing score; score range: 0 to 9
in city limit	dim_ACAD_Person
in city lmt other	dim_ACAD_Person
include in gpa	fact_ACAD_StudentClassEnrollment_snap
inq relatives name relationship year	dim_Adm_Person	A list of relatives who attended Trinity. Populated via an open text box on Slate inquiry forms.
inquiry date	dim_Adm_Person
institution	dim_ACAD_Class_snap
	dim_CombinedSection_curr
	dim_DegreeHonors_curr
	dim_Gen_Edu_Reqs
	fact_ACAD_StudentClassEnrollment_snap
	dim_ACAD_Student_Career_Term_snap	Default Value from OPR_DEF_TBL_CS.INSTITUTION
Instruction Mode	dim_ACAD_Class_snap	The instruction mode indicates whether the class is taught In Person (P) or using Interactive TV, World Wide Web, Correspondence, and so on. Important! You can generate attendance rosters for only those classes with an instruction mode value of P.
	fact_ACAD_StudentClassEnrollment_snap	The instruction mode indicates whether the class is taught In Person (P) or using Interactive TV, World Wide Web, Correspondence, and so on. Important! You can generate attendance rosters for only those classes with an instruction mode value of P.
instructor id	fact_ACAD_StudentClassEnrollment_snap
internal degree	dim_Degrees_curr
IPEDS ethnicity	dim_ACAD_Person	calculated field to determine ipeds ethnicity
is Admit	fact_Adm_Applications	This record has a decision of Admit in the history of confirmed decisions. Values: Yes, No, Unknown
is Admit Bin Based	fact_Adm_Applications	Values: Yes, No, Unknown
is American Indian/Alaskan Native	dim_Adm_Person
is App	fact_Adm_Applications	This is an application. Yes, No, Unknown
is Applicant	dim_Adm_Person	Indicates whether this person has an application on record (per Slate-defined logic).
is Arts Major	dim_Student_AcadPlan_curr	A value of '1' means the student has at least 1 Arts major.
is Asian	dim_Adm_Person
is Black or African American	dim_Adm_Person
is Completed App	fact_Adm_Applications	Yes, No, Unknown
is Declared	dim_Student_AcadPlan_curr	A value of '1' means the student has declared a major.
is Defer from ED to RD	dim_Adm_Application_Details	Application was deferred from an early decision round to the regular decision round.
is Defer from ED1 to RD	dim_Adm_Application_Details	Application was deferred from early decision round #1 (ED1) to the regular decision round.
is Defer from ED2 to RD	dim_Adm_Application_Details	Application was deferred from early decision round #2 (ED2) to the regular decision round.
is Deny	fact_Adm_Applications	This record has a decision of Deny in the history of confirmed decisions. Values: Yes, No, Unknown
is Deposit	fact_Adm_Applications	Student has paid the deposit or recieved a waiver.
is Double Major	dim_Student_AcadPlan_curr	A value of '1' means the student has been assigned two majors.
is Enroll	fact_Adm_Applications	Applicant has confirmed intention to enroll (deposit may or may not have been paid). Students deferring to a future term are excluded, but those deferring from a prior term are included. Values: Yes, No, Unknown
is Enrolled Final	fact_ACAD_StudentClassEnrollment_snap	Student is enrolled and not withdrawn.
	dim_Course_Enrl_Codes_curr	Student is enrolled and not withdrawn.
is Gap	fact_Adm_Applications	Yes, No, Unknown
is Gap Attend	fact_Adm_Applications	Yes, No, Unknown
is Hispanic or Latinx	dim_Adm_Person
is Humanities Major	dim_Student_AcadPlan_curr	A value of '1' means the student has at least 1 Humanities major.
is International	dim_Adm_Person
Is Lab	dim_ACAD_Class_snap
	fact_ACAD_StudentClassEnrollment_snap
Is Lecture	dim_ACAD_Class_snap
	fact_ACAD_StudentClassEnrollment_snap
is Legacy	dim_Adm_Person
is Legacy including Siblings	dim_Adm_Person	Student has the Legacy flag set and/or has specified that sibling(s) have attended Trinity on the Common App. Siblings = Sister, brother, step-sister, step-brother
is Melt	fact_Adm_Applications	Applicant cancelled enrollment. Values: Yes, No, Unknown
is Multiple Races	dim_ACAD_Person	Multi_Legacy = 1 OR 2 or more non-hispanic non-notspecified
is Native Hawaiian or Other Pacific Islander	dim_Adm_Person
is No Decision	fact_Adm_Applications	No (confirmed) decisions have been recorded for this application. Values: Yes, No, Unknown
is Recruited Athlete	dim_Adm_Person
is Registered	fact_ACAD_StudentClassEnrollment_snap	Student Enroll Status = E
	dim_Course_Enrl_Codes_curr	Student enrollment status = 'E'
is related to Trinity employee	dim_Adm_Application_Details	Applicant indicated that they are related to a Trinity employee
is Rescind Offer	fact_Adm_Applications	Yes, No, Unknown
is Social Science Major	dim_Student_AcadPlan_curr	A value of '1' means the student has at least 1 Social Sciences major.
is STEM	dim_ACAD_Class_snap
	fact_ACAD_StudentClassEnrollment_snap
is Stem Major	dim_Student_AcadPlan_curr	A value of '1' means the student has at least 1 STEM major.
is Test Optional	dim_adm_Superscores_Verified	Student has either the OOT flag set or has no verified SAT-I/SAT-R/ACT test
is Triple Major	dim_Student_AcadPlan_curr	A value of '1' means the student has been assigned three majors.
is Two or more race	dim_Adm_Person
is Undeclared	dim_Student_AcadPlan_curr	A value of 'Y' means the student has not declared a major.
is Unknown Race and Ethnicity	dim_Adm_Person
is US Citizen	dim_Adm_Person
is Veteran	dim_Adm_Application_Details
is Waitlist Decline	fact_Adm_Applications	Applicant was waitlisted and declined to hold their place. Values: Yes, No, Unknown
is Waitlist Hold	fact_Adm_Applications	Applicant was waitlisted and wants to hold their place. Values: Yes, No, Unknown
is Waitlist Offer	fact_Adm_Applications	Applicant was offered a place on the waitlist. Values: Yes, No, Unknown
is White	dim_Adm_Person
is Withdrawn	fact_Adm_Applications	Application is withdrawn. Values: Yes, No, Unknown
is Withdrawn After Admission Decision	fact_Adm_Applications	Application was withdrawn after admissions made a decision of admit, deny, or wait list. Values: Yes, No, Unknown.
is Withdrawn Before Admission Decision	fact_Adm_Applications	Application was withdrawn before admissions made a decision of admit, deny, or wait list. Values: Yes, No, Unknown.
is withdrawn by admissions	fact_Adm_Applications	Application is withdrawn by admissions. (incomplete and admit-no response) Values: Yes, No, Unknown
is Withdrawn By Applicant	fact_Adm_Applications	Application has been withdrawn due to student action. Values: Yes, No, Unknown
j
k
Kelter	dim_Adm_Scholarship
l
lang cd	dim_ACAD_Person
language 1	dim_Adm_Application_Details	The first of up to five languages in which the student is proficient, as listed on the Common App.
language 1 proficiency	dim_Adm_Application_Details	The proficiency level of the first language listed on the Common App. Multiple values allowed, including First Language, Speak, Read, Write, Spoken at Home.
language 2	dim_Adm_Application_Details	The second of up to five languages in which the student is proficient, as listed on the Common App.
language 2 proficiency	dim_Adm_Application_Details	The proficiency level of the second language listed on the Common App. Multiple values allowed, including First Language, Speak, Read, Write, Spoken at Home.
last	dim_Adm_Person
Last Date of Attendance	dim_ACAD_Student_Career_Term_snap
last drop dt stmp	fact_ACAD_StudentClassEnrollment_snap
last drop tm stmp	fact_ACAD_StudentClassEnrollment_snap
Last Enrl Action Process - Long Descr	dim_Course_Enrl_Codes_curr
Last Enrl Action Reason	dim_Course_Enrl_Codes_curr
Last Enrl Action Reason Code	dim_Course_Enrl_Codes_curr
Last Enrl Action Reason SDescr	dim_Course_Enrl_Codes_curr
last enrl dt stmp	fact_ACAD_StudentClassEnrollment_snap
Last Enrl Request Source - Long Descr	dim_Course_Enrl_Codes_curr
last enrl tm stmp	fact_ACAD_StudentClassEnrollment_snap
Last Enrollment Action	dim_Course_Enrl_Codes_curr	An enrollment action is the action performed on the enrollment record. The system by default sets the enrollment action for the request to Enroll, but you can override this default value. Add Grd (add grade): Select to add a grade to the student's enrollment record for the corresponding class. Change Grd (change grade): Select to change a grade on the student's enrollment record for the corresponding class. Chg WL Pos (change wait list position): Select to change the student's wait list position for the corresponding class. Drop: Select to drop the student from the corresponding class. Drop to WL (drop to wait list): Select to drop the student from the corresponding class and move the student to the wait list for that class. Enroll: Select to enroll the student into the corresponding class. Norm Maint (normal maintenance): Select to update the student's enrollment record for the corresponding class in normal maintenance mode. Items available for update include grading basis, units, permission, course count, notes, requirement designation, repeat code, and instructor ID. You can use the normal maintenance action to update these items, rather than dropping the class and re-adding it with the new information. Remove Grd (remove grade): Select to remove a grade from the student's enrollment record for the corresponding class. Swap: Select to enable the student to swap the corresponding class in which he or she is enrolled for a different class. The Change To field becomes available for you to enter the new class section in which the student wants to enroll. You can also use this option to swap a student's enrollment from one related class section to another related class section. List the enrollment class section in both the Class Nbr (class number) and Change To fields, select a different related class, then post the enrollment transaction.
Last Enrollment Action Process	dim_Course_Enrl_Codes_curr
Last Enrollment Action Process Code	dim_Course_Enrl_Codes_curr
Last Enrollment Request Source	dim_Course_Enrl_Codes_curr
Last Enrollment Request Source Code	dim_Course_Enrl_Codes_curr
last name	dim_ACAD_Person
last name pref nld	dim_ACAD_Person
last name srch	dim_ACAD_Person
last upd dt stmp	fact_ACAD_StudentClassEnrollment_snap
last upd enreq src	fact_ACAD_StudentClassEnrollment_snap
last upd tm stmp	fact_ACAD_StudentClassEnrollment_snap
lastupddttm	dim_ACAD_Person
latest bin	fact_Adm_Applications	This column holds the latest value from the bin history, regardless of the current cycle.
latest bin guid	fact_Adm_Applications	This column holds the latest value from the bin history, regardless of the current cycle. This bin GUID is pulled from the application.bin table in Slate
latest confirmed decision code	fact_Adm_Applications
latest confirmed decision confirm date	fact_Adm_Applications
latest confirmed decision name	fact_Adm_Applications
latest confirmed decision reason	fact_Adm_Applications
latest decision code	fact_Adm_Applications
latest decision confirmed yn	fact_Adm_Applications	Yes, No, Unknown
latest decision name	fact_Adm_Applications
latest decision reason	fact_Adm_Applications
latest decision status	fact_Adm_Applications	Found hard coded in WH Applications query in Slate: when [rank_confirmed] = 1 then 'Confirmed' when [code] IS NOT NULL then 'Provisional' else 'No decision'
latitude	dim_Adm_Addresses_Consolidated
	dim_PriClassMeetingPattern_curr
Lincoln	dim_Adm_Scholarship
lived outside us years	dim_Adm_Person
Location	dim_PriClassMeetingPattern_curr
Location of the Class Section	dim_ACAD_Class_snap	Location at which the class section is taught (recoded values)
	fact_ACAD_StudentClassEnrollment_snap	Location at which the class section is taught (recoded values)
Location of the Class Section -Original from PS	dim_ACAD_Class_snap	Location at which the class section is taught
	fact_ACAD_StudentClassEnrollment_snap	Location at which the class section is taught
Lock In Amount	dim_ACAD_Student_Career_Term_snap
Lock In Date	dim_ACAD_Student_Career_Term_snap
longitude	dim_Adm_Addresses_Consolidated
	dim_PriClassMeetingPattern_curr
m
major	dim_Adm_School_Attendance	The student's major.
Major 1 Multiple Department Flag	dim_Student_AcadPlan_curr	indicator that shows whether major 1 has multiple departments that 'own' it.
Major 2 Multiple Departments Flag	dim_Student_AcadPlan_curr	indicator that shows whether major 2 has multiple department 'owners'
Major 3 Multiple Department Flag	dim_Student_AcadPlan_curr	indicator that shows whether major 3 has multiple department 'owners'
Major Count	dim_Student_AcadPlan_curr	The number of majors a student has. Undeclared = 0.
mandatory grd bas	fact_ACAD_StudentClassEnrollment_snap
mar status	dim_ACAD_Person
mar status dt	dim_ACAD_Person
Master Class Section	dim_ACAD_Class_snap
	fact_ACAD_StudentClassEnrollment_snap
master guid	fact_Adm_Applications	This points to the original application from which this record was cloned.
Mastercard_Foundation	dim_Adm_Scholarship
Max Audit Units	dim_ACAD_Student_Career_Term_snap
Max No GPA Units	dim_ACAD_Student_Career_Term_snap
Max Total Courses	dim_ACAD_Student_Career_Term_snap
Max Total Units	dim_ACAD_Student_Career_Term_snap
Max Wait List Units	dim_ACAD_Student_Career_Term_snap
medicare entld dt	dim_ACAD_Person
Meeting Time End	dim_PriClassMeetingPattern_curr
Meeting Time Start	dim_PriClassMeetingPattern_curr
meets Arts dist	dim_Gen_Edu_Reqs
meets dist req	dim_Gen_Edu_Reqs
meets FrnLng req	dim_Gen_Edu_Reqs
meets FY req	dim_Gen_Edu_Reqs
meets Global req	dim_Gen_Edu_Reqs
meets Hum dist	dim_Gen_Edu_Reqs
meets NatSci dist	dim_Gen_Edu_Reqs
meets Num dist	dim_Gen_Edu_Reqs
meets SocSci dist	dim_Gen_Edu_Reqs
meets Writing1 req	dim_Gen_Edu_Reqs
meets Writing2 req	dim_Gen_Edu_Reqs
Merit_Aid	dim_Adm_Scholarship
middle	dim_Adm_Person
middle name	dim_ACAD_Person
milit situatn esp	dim_ACAD_Person
milit situatn fra	dim_ACAD_Person
military end ita	dim_ACAD_Person
military rank ita	dim_ACAD_Person
military stat ger	dim_ACAD_Person
military stat ita	dim_ACAD_Person
military status	dim_ACAD_Person
military type ita	dim_ACAD_Person
Min Total Units	dim_ACAD_Student_Career_Term_snap
Min Utlzn Pct	dim_PriClassMeetingPattern_curr	Enter the minimum usage that a facility should experience. This field is for internal record keeping only, and has no programming associated with it.
Minimum Enrollment of the Section	dim_ACAD_Class_snap	The minimum enrollment number in order for the section to be offered.This field is for informational purposes only.
	fact_ACAD_StudentClassEnrollment_snap	The minimum enrollment number in order for the section to be offered.This field is for informational purposes only.
Minor 1 Multiple Department Flag	dim_Student_AcadPlan_curr	indicator that shows whether major 2 has multiple department 'owners'
Minor 2 Multiple Departments Flag	dim_Student_AcadPlan_curr	indicator that shows whether major 2 has multiple department 'owners'
Minor 3 Multiple Department 3	dim_Student_AcadPlan_curr	indicator that shows whether major 2 has multiple department 'owners'
Minor Count	dim_Student_AcadPlan_curr	The number of minors a student has. Undeclared = 0
Mon	dim_PriClassMeetingPattern_curr
n
name	dim_ACAD_Person
	dim_Adm_Person
name ac	dim_ACAD_Person
name display	dim_ACAD_Person
name formal	dim_ACAD_Person
name initials	dim_ACAD_Person
name prefix	dim_ACAD_Person
name royal prefix	dim_ACAD_Person
name royal suffix	dim_ACAD_Person
name suffix	dim_ACAD_Person
name title	dim_ACAD_Person
Native Hawaiian/Other Pacific Island	dim_ACAD_Person	The race 'Native Hawaiian/Other Pacific Island' has been recorded for this person. Other races and/or ethnicity could also be indicated for this person.
Neighborhood % Applying Out of State	dim_Adm_segment_analysis_curr	Percent of students in a neighborhood that applied to an out of state college.
Neighborhood % Below Poverty Line	dim_Adm_segment_analysis_curr	Percent of students in a neighborhood who are below the poverty line.
Neighborhood % Black	dim_Adm_segment_analysis_curr	ACS based percent of students in a neighborhood who are black.
Neighborhood % Catholic	dim_Adm_segment_analysis_curr	Percent of students in a neighborhood that are Catholic.
Neighborhood % Christian (non-Catholic)	dim_Adm_segment_analysis_curr	Percent of students in a neighborhood that are Christian.
Neighborhood % English Only	dim_Adm_segment_analysis_curr	Percent of students in a neighborhood who report that they only speak English.
Neighborhood % Female	dim_Adm_segment_analysis_curr	Percent of students in a neighborhood that are female.
Neighborhood % Hispanic	dim_Adm_segment_analysis_curr	ACS based percent of students in a neighborhood who are Hispanic.
Neighborhood % in Private High School	dim_Adm_segment_analysis_curr	Percent of students in a neighborhood that attend a private high school.
Neighborhood % in Religious High School	dim_Adm_segment_analysis_curr	Percent of students in a neighborhood that attend a religiously affiliated high school.
Neighborhood % Interested in Religious College	dim_Adm_segment_analysis_curr	Percent of students in a neighborhood who are interested in attending a religiously affiliated college.
Neighborhood % Moving in Past 2 Years	dim_Adm_segment_analysis_curr	ACS based percent of students in a neighborhood that have moved in the past 2 years.
Neighborhood % Needing Financial Aid	dim_Adm_segment_analysis_curr	Percent of students in a neighborhood that require financial aid for college.
Neighborhood % of Colleges Receiving Scores that are 4 Year	dim_Adm_segment_analysis_curr	Percent of colleges receiving score sends from students in a neighborhood that are 4 year colleges.
Neighborhood % White	dim_Adm_segment_analysis_curr	ACS based percent of students in a neighborhood who are white.
Neighborhood % with Parent Education of < High School	dim_Adm_segment_analysis_curr	Percent of students in a neighborhood who reported that no parent had education beyond high school.
Neighborhood Academic 1	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for student grades. Values: -9.999 - +9.999
Neighborhood Academic 2	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for student grades. Values: -9.999 - +9.999
Neighborhood Academic 3	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for academic ability. Values: -9.999 - +9.999
Neighborhood Academic 4	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for content area strengths/weaknesses. Values: -9.999 - +9.999
Neighborhood American Community Survey 1	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for community work category. (Professional vs Working Class) Values: -9.999 - +9.999
Neighborhood American Community Survey 2	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for community income category. (Blue Collar vs low income) Values: -9.999 - +9.999
Neighborhood American Community Survey 3	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for community category. (white suburban or black inner city) Values: -9.999 - +9.999
Neighborhood American Community Survey 4	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for family category (large family or older retired) Values: -9.999 - +9.999
Neighborhood American Community Survey 5	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for residential stability (rural stability or highly mobile) Values: -9.999 - +9.999
Neighborhood American Community Survey 6	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for residential density (dense non-rural vs residential) Values: -9.999 - +9.999
Neighborhood Average # of AP Tests	dim_Adm_segment_analysis_curr	Average # of AP tests taken by students in a neighborhood.
Neighborhood Average # of Honors Courses	dim_Adm_segment_analysis_curr	Average # of Honors courses taken by students in a neighborhood.
Neighborhood Average # of SAT Score Sends	dim_Adm_segment_analysis_curr	Average number of scores sends for students in a neighborhood.
Neighborhood Average Admit Rate of Colleges Receiving Scores	dim_Adm_segment_analysis_curr	Average rate of admissions for colleges receiving score sends from students in a neighborhood.
Neighborhood Average Cost of Colleges Receiving Scores	dim_Adm_segment_analysis_curr	Average cost for colleges receiving score sends from students in a neighborhood.
Neighborhood Average Enrolled Test Score of Colleges Receiving Scores	dim_Adm_segment_analysis_curr	Average SAT score of students enrolled in a college receiving scores sends from students in a neighborhood.
Neighborhood Average Retention Rate of Colleges Receiving Scores	dim_Adm_segment_analysis_curr	Retention rate of colleges receiving scores sends from students in a neighborhood.
Neighborhood College Application 1	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for college application focus of public/private. Values: -9.999 - +9.999
Neighborhood College Application 2	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for college application focus of sectarian/non-sectarian. Values: -9.999 - +9.999
Neighborhood College Application 3	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for college application shotgun/focused. Values: -9.999 - +9.999
Neighborhood College Interest 1	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for national selective vs local technical college interest. Values: -9.999 - +9.999
Neighborhood College Interest 2	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for public/private college interest. Values: -9.999 - +9.999
Neighborhood College Interest 3	dim_Adm_segment_analysis_curr	Neighborhood D+ factor for college setting interest. Values: -9.999 - +9.999
Neighborhood College Interest 4	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for coed/single gender college interest. Values: -9.999 - +9.999
Neighborhood Demographic 1	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score Christian culture. Values: -9.999 - +9.999
Neighborhood Demographic 2	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for Catholic culture. Values: -9.999 - +9.999
Neighborhood Demographic 3	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for Jewish culture. Values: -9.999 - +9.999
Neighborhood Demographic 4	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for college prep culture. Values: -9.999 - +9.999
Neighborhood Demographic 5	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for gender. Values: -9.999 - +9.999
Neighborhood Diversity 1	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for high school Hispanic/Mexican population. Values: -9.999 - +9.999
Neighborhood Diversity 2	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for high school African-American population. Values: -9.999 - +9.999
Neighborhood Diversity 3	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for high school Asian population. Values: -9.999 - +9.999
Neighborhood Diversity 4	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for high school Puerto Rican/Caribbean ESL population. Values: -9.999 - +9.999
Neighborhood HS Opportunity 1	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for strength of academic curriculum. Values: -9.999 - +9.999
Neighborhood HS Opportunity 2	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for college prep curriculum. Values: -9.999 - +9.999
Neighborhood HS Opportunity 3	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score AP/Honors curriculum. Values: -9.999 - +9.999
Neighborhood HS Opportunity 4	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for breath of curriculum. Values: -9.999 - +9.999
Neighborhood Median Adjusted Housing Value	dim_Adm_segment_analysis_curr	ACS based median house value as a percentage of average status value of students in a neighborhood.
Neighborhood Median Family Income	dim_Adm_segment_analysis_curr	ACS based median family income of students in a neighborhood.
Neighborhood Per Capita Income	dim_Adm_segment_analysis_curr	ACS based average per capita income of students in a neighborhood.
Neighborhood SAT CR Score	dim_Adm_segment_analysis_curr	Average score on the CR section of the SAT for all students in a neighborhood.
Neighborhood SAT Math Score	dim_Adm_segment_analysis_curr	Average score on the math section of the SAT for all students in a high school.
Neighborhood SAT Writing Score	dim_Adm_segment_analysis_curr	Average score on the writing section of the SAT for all students in a neighborhood.
Neighborhood Self Reported Parent Income	dim_Adm_segment_analysis_curr	Average income of parents of students in a neighborhood.
Neighborhood SES 1	dim_Adm_segment_analysis_curr	Neighborhood D+ factor school for level of education. Values: -9.999 - +9.999
Neighborhood SES 2	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for socioeconomic class. Values: -9.999 - +9.999
Neighborhood Student Achievement 1	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for student academic achievement. Values: -9.999 - +9.999
Neighborhood Student Achievement 2	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for student community achievement. Values: -9.999 - +9.999
Neighborhood Student Achievement 3	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for student work/vocational achievement. Values: -9.999 - +9.999
Neighborhood Student Achievement 4	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for leadership achievement. Values: -9.999 - +9.999
Neighborhood Student Achievement 5	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for athletic achievement. Values: -9.999 - +9.999
Neighborhood Student Achievement 6	dim_Adm_segment_analysis_curr	Neighborhood D+ factor score for art achievement. Values: -9.999 - +9.999
next stdnt positin	dim_ACAD_Class_snap	The next position on the wait list?
	fact_ACAD_StudentClassEnrollment_snap	The next position on the wait list?
non need based finaid	dim_Adm_Application_Details	[Legacy data field from Common App] Possible values include None, Veteran's Administration Benefits, Tuition Exchange.
Normal Class Duration	dim_PriClassMeetingPattern_curr	The number of minutes for each class in this standard meeting pattern.
Not Specified	dim_ACAD_Person
notify stdnt chng	fact_ACAD_StudentClassEnrollment_snap
NSLDS Loan Year	dim_ACAD_Student_Career_Term_snap
num1	dim_ACAD_Person
num1 other	dim_ACAD_Person
num2	dim_ACAD_Person
num2 other	dim_ACAD_Person
Number of Applications	fact_Adm_Applications	Use this column for math.
Number of Days Submitted Before Deadline	fact_Adm_Applications	The number of days an application is submitted before the round's deadline. [round_deadline_date] - [application_submitted_date]. Positive numbers are applications that were submitted before the deadline and negative numbers are applications that were submitted after the deadline.
o
Ongoing Combination of Sections	dim_ACAD_Class_snap	If this flag is set to Yes, then PeopleSoft carries forward this combined section when a new term is created. If this flag is set to No, the system assumes that the combination is a temporary arrangement for the current term.
	dim_CombinedSection_curr	If this flag is set to Yes, then PeopleSoft carries forward this combined section when a new term is created. If this flag is set to No, the system assumes that the combination is a temporary arrangement for the current term.
oot tag	dim_adm_Superscores_Verified	Opt out of Testing indicator
oprid	fact_ACAD_StudentClassEnrollment_snap
Opt Out of Marketing	dim_Adm_Person
optional essay prompt	fact_Adm_Applications	Essay prompt as it appears on the Common App.
order no	dim_Adm_segment_analysis_curr	From College Board documentation: The number assigned to the order by the system to uniquely identify the order.
Other Citizenship Status	dim_ACAD_Person	Non United States Citizenship statuses delimited by semi-colon.
Other College Attended CEEB Withdrawal	dim_Adm_Application_Details	The CEEB code of the college attended by an applicant who withdrew.
Other College Attended Withdrawal	dim_Adm_Application_Details	The college attended by an applicant who withdrew.
Override All Academic Levels	dim_ACAD_Student_Career_Term_snap	Default Value = 'N'
Override Billing Units	dim_ACAD_Student_Career_Term_snap
Override Initial Add Fees	dim_ACAD_Student_Career_Term_snap	Default Value = 'N'
Override Intiial Enroll Fee	dim_ACAD_Student_Career_Term_snap	Default Value = 'N'
Override Maximum Units	dim_ACAD_Student_Career_Term_snap	Default Value = 'N'
Override Projected Level	dim_ACAD_Student_Career_Term_snap	Default Value = 'N'
Override Tuition Group	dim_ACAD_Student_Career_Term_snap
Override Withdrawal Schedule	dim_ACAD_Student_Career_Term_snap
ovrd grading basis	fact_ACAD_StudentClassEnrollment_snap
p
Parent 1 Education Level	dim_Adm_Application_Details
Parent 2 Education Level	dim_Adm_Application_Details
parent divorce date	dim_Adm_Person
parent marital status	dim_Adm_Person
partner last name	dim_ACAD_Person
partner roy prefix	dim_ACAD_Person
Passport to Trinity event status	dim_Adm_Application_Details	Indicates whether applicant was invited to or declined invitation for the Passport to Trinity overnight program.
Passport to Trinity Recommendation	dim_Adm_Application_Details	Indicates whether student was recommended for the Passport to Trinity event
Period Active Status	fact_Adm_Applications	Shows whether the period is active. Values: Y, N, U. Note: this column is pulling the current status for each period (dss_dv_active_flag = 'Y'). In other words, if you're looking at a status for a prior snapshot date, this column will not show you what was in the warehouse as of that time.
period guid	fact_Adm_Applications	GUID from the period.lookup table in Slate.
period year	fact_Adm_Applications
permanent resident	dim_Adm_Person
person guid	dim_Adm_Person	A Slate field that is used in their database to enforce uniqueness on the person table.
	dim_adm_Superscores_Verified
	fact_Adm_Applications
person record active	dim_Adm_Person
person reference id external	dim_Adm_Person
person reference id internal	dim_Adm_Person
person reference id override	dim_Adm_Person
person slate id	dim_Adm_Application_Details	A numeric, unique identifier for each person generated by Slate. Also known as person reference ID or 'ref'.
	dim_Adm_Person	An identification number unique to each person assigned by Slate. The source column is called 'ref' on the person table.
	dim_Adm_School_Attendance	A Slate generated field used to uniquely identify a person.
	dim_adm_Superscores_Verified
	fact_Adm_Applications
	dim_Adm_segment_analysis_curr	This is the ref number on the person table in Slate. In the warehouse, this column is called Person_Slate_ID.
person start date	dim_ACAD_Person	Date and time the data for this person record started
	dim_ACAD_Person	The date and time this data for a person was inactive
person status	dim_Adm_Person	Person status as determined by Slate logic. Potential values include: Prospect, Inquiry, Applicant, Null. If there are null values, then the slate process to assign person status has not been run.
person tags	dim_Adm_Person	Concatenated list of tags scoped to the person record
personal site link	dim_Adm_Application_Details	URL to a personal website
phone	dim_ACAD_Person
phone daytime	dim_Adm_Person
phone evening	dim_Adm_Person
phone mobile	dim_Adm_Person
place of death	dim_ACAD_Person
plan_Major 1 Code	dim_Student_AcadPlan_curr
plan_Major 1 Department	dim_Student_AcadPlan_curr
plan_Major 1 Description	dim_Student_AcadPlan_curr
plan_Major 1 Short Description	dim_Student_AcadPlan_curr
plan_Major 2 Code	dim_Student_AcadPlan_curr
plan_Major 2 Department	dim_Student_AcadPlan_curr
plan_Major 2 Description	dim_Student_AcadPlan_curr
plan_Major 2 Short Description	dim_Student_AcadPlan_curr
plan_Major 3 Code	dim_Student_AcadPlan_curr
plan_Major 3 Department	dim_Student_AcadPlan_curr
plan_Major 3 Description	dim_Student_AcadPlan_curr
plan_Major 3 Short Description	dim_Student_AcadPlan_curr
plan_Minor 1 Code	dim_Student_AcadPlan_curr
plan_Minor 1 Department	dim_Student_AcadPlan_curr
plan_Minor 1 Description	dim_Student_AcadPlan_curr
plan_Minor 1 Short Description	dim_Student_AcadPlan_curr
plan_Minor 2 Code	dim_Student_AcadPlan_curr
plan_Minor 2 Department	dim_Student_AcadPlan_curr
plan_Minor 2 Description	dim_Student_AcadPlan_curr
plan_Minor 2 Short Description	dim_Student_AcadPlan_curr
plan_Minor 3 Code	dim_Student_AcadPlan_curr
plan_Minor 3 Department	dim_Student_AcadPlan_curr
plan_Minor 3 Description	dim_Student_AcadPlan_curr
plan_Minor 3 Short Description	dim_Student_AcadPlan_curr
plan_Multiple Major Codes	dim_Student_AcadPlan_curr
plan_Multiple Major Description	dim_Student_AcadPlan_curr
plan_Multiple Major Short Description	dim_Student_AcadPlan_curr
plan_Multiple Minor Codes	dim_Student_AcadPlan_curr
plan_Multiple Minor Description	dim_Student_AcadPlan_curr
plan_Multiple Minor Short Description	dim_Student_AcadPlan_curr
plan_Multiple Program Codes	dim_Student_AcadPlan_curr
plan_Multiple Program Description	dim_Student_AcadPlan_curr
plan_Multiple Program Short Description	dim_Student_AcadPlan_curr
plan_Program 1 Code	dim_Student_AcadPlan_curr
plan_Program 1 Department	dim_Student_AcadPlan_curr
plan_Program 1 Description	dim_Student_AcadPlan_curr
plan_Program 1 Short Description	dim_Student_AcadPlan_curr
plan_Program 2 Code	dim_Student_AcadPlan_curr
plan_Program 2 Department	dim_Student_AcadPlan_curr
plan_Program 2 Description	dim_Student_AcadPlan_curr
plan_Program 2 Short Description	dim_Student_AcadPlan_curr
Populations	fact_Adm_Applications	Populations assigned to this application
portfolio intent to submit	dim_Adm_Application_Details	Applicant indicated on Common App that they intend to submit a portfolio.
Posse	dim_Adm_Scholarship
postal	dim_ACAD_Person
	dim_Adm_Addresses_Consolidated
postal other	dim_ACAD_Person
pref first name	dim_ACAD_Person
preferred	dim_Adm_Person
prefix	dim_Adm_Person
Presidential	dim_Adm_Scholarship
Primary Academic Program	dim_ACAD_Student_Career_Term_snap
Primary Instructional Section	dim_ACAD_Class_snap	The primary instructional section number. This field is specifically used for distance learning classes. You can use this field to indicate in which section the instructor resides. This field is for informational purposes only.
	fact_ACAD_StudentClassEnrollment_snap	The primary instructional section number. This field is specifically used for distance learning classes. You can use this field to indicate in which section the instructor resides. This field is for informational purposes only.
Print honors on diploma	dim_DegreeHonors_curr
Print honors on transcript	dim_DegreeHonors_curr
Print Topic in Schedule	dim_ACAD_Class_snap
	fact_ACAD_StudentClassEnrollment_snap
Print Topic on Transcript	dim_PriClassMeetingPattern_curr
Program 1 Multiple Departments Flag	dim_Student_AcadPlan_curr	indicator that shows whether major 2 has multiple department 'owners'
Program 2 Multiple Department Flag	dim_Student_AcadPlan_curr	indicator that shows whether major 2 has multiple department 'owners'
Program Eligibility Flag	dim_ACAD_Student_Career_Term_snap	Default Value from ACAD_PROG_TBL.FA_ELIGIBILITY
Projected Bill Units	dim_ACAD_Student_Career_Term_snap
Pro-Rata Eligible	dim_ACAD_Student_Career_Term_snap	Default Value = 'N'
prospect date	dim_Adm_Person
ps strm	fact_Adm_Applications	temporary fix until peoplesoft strm is added to slate rounds in export1 field.
q
questbridge cm prospect id	dim_Adm_Person
questbridge cps id	dim_Adm_Person
Questbridge ID	dim_Adm_Application_Details
questbridge prospect id	dim_Adm_Person
r
race	dim_Adm_Person
Race and Ethnicity Classification per IPEDS	dim_Adm_Person	Outputs the commonly accepted IPEDS value for race and ethnicity.
Raether_HMTCA	dim_Adm_Scholarship
Reader Full Name	fact_Adm_Applications
Reader Username	fact_Adm_Applications	The username a person has in Slate. This could be used to enforce row level security within visualizations.
record guid	dim_Adm_Addresses_Consolidated
	dim_Adm_School_Attendance	A Slate generated identifier for a person, rarely used and only by administrators.
	dim_Adm_School_Attendance	A Slate generated identifier for a school's active address, rarely used and only by administrators.
Redbook Admissions Status	fact_Adm_Applications	COFHE Redbook field to disguinsh the status of an admissions student. Examples: denied, admitted, matriculated, defer
Redbook Admissions Status Description	fact_Adm_Applications	COFHE Redbook field to disguinsh the status of an admissions student. Examples: denied, admitted, matriculated, defer
Redbook Admissions Type	fact_Adm_Applications	COFHE Redbook field to disguinsh the type of admissions student. Examples: gap, early decision, regular, transfers.
Redbook Admissions Type Description	fact_Adm_Applications	COFHE Redbook field to disguinsh the type of admissions student. Examples: gap, early decision, regular, transfers.
Refund Percentage	dim_ACAD_Student_Career_Term_snap
Refund Scheme	dim_ACAD_Student_Career_Term_snap
region	dim_Adm_Addresses_Consolidated
Region State Name	dim_Adm_Addresses_Consolidated
Region Territory	dim_Adm_Addresses_Consolidated
Registered	dim_ACAD_Student_Career_Term_snap
Registration Card Date	dim_ACAD_Student_Career_Term_snap
relate class nbr 1	fact_ACAD_StudentClassEnrollment_snap
relate class nbr 2	fact_ACAD_StudentClassEnrollment_snap
Relative Attended Trinity	dim_Adm_Person	Concatenated list of other relatives (other than parents) from the custom CommonApp question, Have any relatives ever attended Trinity College? Applicants can provide details on up to five relatives Possible values: Aunt, Brother, Cousin, Great Aunt, Grandfather, Grandmother, Great Grandfather, Great Grandmother, Great Uncle, Niece, Nephew, Other Relative, Step-Brother, Sister, Step-Sister, Step-Grandfather, Step-Grandmother, Uncle
religious preference	dim_Adm_Person
religious preference other	dim_Adm_Person
repeat candidate	fact_ACAD_StudentClassEnrollment_snap
repeat code	fact_ACAD_StudentClassEnrollment_snap
	dim_Course_Enrl_Codes_curr
Repeat Code Descr	dim_Course_Enrl_Codes_curr
Repeat Code LDescr	dim_Course_Enrl_Codes_curr
Repeat Code SDescr	dim_Course_Enrl_Codes_curr
repeat dt	fact_ACAD_StudentClassEnrollment_snap
Requested Room Capacity	dim_ACAD_Class_snap	The requested room capacity for the class. Your room capacity can be different than your enrollment capacity. Because the system stores two separate capacity values, this field enables you to manipulate the enrollment capacity without affecting room scheduling. The system populates the Requested Room Capacity field by default from the default section size on the Course Catalog - Components page.
	fact_ACAD_StudentClassEnrollment_snap	The requested room capacity for the class. Your room capacity can be different than your enrollment capacity. Because the system stores two separate capacity values, this field enables you to manipulate the enrollment capacity without affecting room scheduling. The system populates the Requested Room Capacity field by default from the default section size on the Course Catalog - Components page.
Requirement Designation Code	dim_ACAD_Class_snap	A requirement designation can be extra work that has to be done for a course, such as Design Credit, or a requirement designation can specify a special type of a course to use in a course list for the Academic Advisement application. Requirement designation values are defined on the Requirement Designation Table page, and default from the Catalog Data page. Example requirement designation values are Design Credit, Thesis Choice, and so on. Requirement designations feed into the Academic Advisement application.
Resection when full	dim_ACAD_Class_snap	The alternative section in which the system automatically enrolls a student if the primary section is full. The component of the primary section and the resection to section class must be the same. For instance, when Section 1 Lecture is filled, the system enrolls students in Section 3 Lecture.
	fact_ACAD_StudentClassEnrollment_snap	The alternative section in which the system automatically enrolls a student if the primary section is full. The component of the primary section and the resection to section class must be the same. For instance, when Section 1 Lecture is filled, the system enrolls students in Section 3 Lecture.
Reset Cum Stats at Term Start	dim_ACAD_Student_Career_Term_snap	Default Value = 'N'
Revenue from item type	fact_ACAD_StudentClassEnrollment_snap
Room	dim_PriClassMeetingPattern_curr
Room Capacity	dim_PriClassMeetingPattern_curr
Room Capacity Request- Combined Section	dim_ACAD_Class_snap	Room Capacity Request- Combined Section
	dim_CombinedSection_curr	Room Capacity Request- Combined Section
Room Number	dim_PriClassMeetingPattern_curr
Room sdescr	dim_PriClassMeetingPattern_curr
round	fact_Adm_Applications
Round Active Status	fact_Adm_Applications	Shows whether the round is active. Values: Y, N, U. Note: this column is pulling the current status for each round (dss_dv_active_flag = 'Y'). In other words, if you're looking at a status for a prior snapshot date, this column will not show you what was in the warehouse as of that time.
Round Deadline Date	fact_Adm_Applications	The deadline for applications to be submitted in each round.
round guid	fact_Adm_Applications	GUID from round.lookup table in Slate
round key	fact_Adm_Applications
round short name	fact_Adm_Applications
rqmnt designtn	dim_Gen_Edu_Reqs
	fact_ACAD_StudentClassEnrollment_snap
rqmnt designtn grd	fact_ACAD_StudentClassEnrollment_snap
rqmnt designtn opt	fact_ACAD_StudentClassEnrollment_snap
rsrv cap nbr	fact_ACAD_StudentClassEnrollment_snap
s
saa display option	dim_Gen_Edu_Reqs
sal admin plan	dim_ACAD_Person
Sat	dim_PriClassMeetingPattern_curr
SAT I R Superscore	dim_adm_Superscores_Verified	Superscore of the SAT, both old and new, using the SAT I to R concordance method.
SAT I to R Concordance	dim_adm_Superscores_Verified	Superscore of the SAT I converted to the SAT R scoring.
SAT II Subject Test Count	dim_adm_Superscores_Verified	Count of distinct SAT II Subject tests
sati cr m	dim_adm_Superscores_Verified	SAT I verified superscore (Critical Reading + Math); score range: 400 to 1600
sati cr m w	dim_adm_Superscores_Verified	SAT I Critical Reading + Math + Writing verified superscore; score range: 600 to 2400
sati critical reading	dim_adm_Superscores_Verified	Best SAT I Critical Reading score; score range: 200 to 800
sati high score date	dim_adm_Superscores_Verified	Date of the SAT-I test with the highest total score
sati math	dim_adm_Superscores_Verified	Best SAT I Math score; score range: 200 to 800
sati most recent date	dim_adm_Superscores_Verified	Most recent verified SAT-I test
sati writing	dim_adm_Superscores_Verified	Best SAT I Writing score; score range: 200 to 800
SATII best score	dim_adm_Superscores_Verified	The highest score on a SAT II subject test
SATII best score date	dim_adm_Superscores_Verified	The test date of the SAT II subject test with the best score
SATII best score test	dim_adm_Superscores_Verified	The SAT II subject test with the best score
SATII chemistry	dim_adm_Superscores_Verified	Best SAT II Subject Test: Chemistry; score range: 200 to 800
SATII chinese listening	dim_adm_Superscores_Verified	Best SAT II Subject Test: Chemistry; score range: 200 to 800
SATII ecological biology	dim_adm_Superscores_Verified	Best SAT II Subject Test: Ecological Biology; score range: 200 to 800
SATII french	dim_adm_Superscores_Verified	Best SAT II Subject Test: French; score range: 200 to 800
SATII french listening	dim_adm_Superscores_Verified	Best SAT II Subject Test: French with Listening; score range: 200 to 800
SATII german	dim_adm_Superscores_Verified	Best SAT II Subject Test: German; score range: 200 to 800
SATII german listening	dim_adm_Superscores_Verified	Best SAT II Subject Test: German with Listening; score range: 200 to 800
SATII italian	dim_adm_Superscores_Verified	Best SAT II Subject Test: Italian; score range: 200 to 800
SATII japanese listening	dim_adm_Superscores_Verified	Best SAT II Subject Test: Japanese with Listening; score range: 200 to 800
SATII korean listening	dim_adm_Superscores_Verified	Best SAT II Subject Test: Korean with Listening; score range: 200 to 800
SATII latin	dim_adm_Superscores_Verified	Best SAT II Subject Test: Latin; score range: 200 to 800
SATII literature	dim_adm_Superscores_Verified	Best SAT II Subject Test: Literature; score range: 200 to 800
SATII math level i	dim_adm_Superscores_Verified	Best SAT II Subject Test: Math - Level I; score range: 200 to 800
SATII math level ii	dim_adm_Superscores_Verified	Best SAT II Subject Test: Math - Level II; score range: 200 to 800
SATII modern hebrew	dim_adm_Superscores_Verified	Best SAT II Subject Test: Modern Hebrew; score range: 200 to 800
SATII molecular biology	dim_adm_Superscores_Verified	Best SAT II Subject Test: Molecular Biology; score range: 200 to 800
SATII physics	dim_adm_Superscores_Verified	Best SAT II Subject Test: Physics; score range: 200 to 800
SATII spanish	dim_adm_Superscores_Verified	Best SAT II Subject Test: Spanish; score range: 200 to 800
SATII spanish listening	dim_adm_Superscores_Verified	Best SAT II Subject Test: Spanish with Listening; score range: 200 to 800
SATII us history	dim_adm_Superscores_Verified	Best SAT II Subject Test: U.S. History; score range: 200 to 800
SATII world history	dim_adm_Superscores_Verified	Best SAT II Subject Test: World History; score range: 200 to 800
satr command of evidence	dim_adm_Superscores_Verified	SAT Revised - Command of Evidence Subscore (from the Reading Test and the Writing and Language Test); score range: 1 to 15
satr essay analysis	dim_adm_Superscores_Verified	SAT Revised - Essay Score - Analysis; score range: 2 to 8
satr essay reading	dim_adm_Superscores_Verified	SAT Revised - Essay Score - Reading; score range: 2 to 8
satr essay writing	dim_adm_Superscores_Verified	SAT Revised - Essay Score - Writing; score range: 2 to 8
satr expression ideas	dim_adm_Superscores_Verified	SAT Revised - Expression of Ideas Subscore (from the Writing and Language Test); score range: 1 to 15
satr heart of algebra	dim_adm_Superscores_Verified	SAT Revised - Heart of Algebra Subscore (from the Math Test); score range: 1 to 15
satr high score date	dim_adm_Superscores_Verified	Date of the SAT-R test with the highest total score
satr history social studies	dim_adm_Superscores_Verified	SAT Revised - Analysis in History/Social Studies cross-test score; score range: 10 to 40
satr math section	dim_adm_Superscores_Verified	SAT Revised - Math Section score; score range: 200 to 800
satr math test	dim_adm_Superscores_Verified	SAT Revised - Math Test score; score range: 10 to 40
satr most recent test date	dim_adm_Superscores_Verified	Most recent verified SAT-R test
satr passport to advanced math	dim_adm_Superscores_Verified	SAT Revised - Passport to Advanced Math Subscore (from the Math Test); score range: 1 to 15
satr problem solving data analysis	dim_adm_Superscores_Verified	SAT Revised - Problem Solving and Data Analysis Subscore (from the Math Test); score range: 1 to 15
satr r w m	dim_adm_Superscores_Verified	SAT Revised - the sum of the best individual scores of the three tests (Reading, Writing and Language, and Math)
satr reading test	dim_adm_Superscores_Verified	SAT Revised - Reading Test score; score range: 10 to 40
satr reading writing section	dim_adm_Superscores_Verified	SAT Revised - Evidence-based Reading and Writing Section score; score range: 200 to 800
satr science	dim_adm_Superscores_Verified	SAT Revised - Analysis in Science cross-test score; score range: 10 to 40
satr standard english conventions	dim_adm_Superscores_Verified	SAT Revised - Standard English Conventions Subscore (from the Writing and Language Test); score range: 1 to 15
satr total score	dim_adm_Superscores_Verified	SAT Revised Total Superscore - the sum of the best individual scores of the two sections (Evidence-Based Reading and Writing, and Math); score range: 400 to 1600
satr words in context	dim_adm_Superscores_Verified	SAT Revised - Words in Context Subscore (from the Reading Test and the Writing and Language Test); score range: 1 to 15
satr writing language test	dim_adm_Superscores_Verified	SAT Revised - Writing and Language Test score; score range: 10 to 40
Say_Yes_to_Education	dim_Adm_Scholarship
schedule print	dim_Gen_Edu_Reqs
	dim_ACAD_Class_snap	Toggle to display the class in the schedule of classes
	fact_ACAD_StudentClassEnrollment_snap	Toggle to display the class in the schedule of classes
Scholarship Davis Foundation	dim_Adm_Scholarship
Scholarship Global	dim_Adm_Scholarship
school address created date	dim_Adm_School_Attendance
school address guid	dim_Adm_School_Attendance	A Slate generated identifier for a school's address, rarely used and only by administrators.
school address notes	dim_Adm_School_Attendance	This field stores custom notes that Admissions users can enter through the interface.
school address priority	dim_Adm_School_Attendance	Priority helps determine the address rank. See rank description for more information.
school address quality	dim_Adm_School_Attendance	This column determines the quality of an address. When addresses are added during a batch process, the quality is set to 2 by default, indicating that the address is awaiting standardization. Every evening, or upon demand when initiated by an administrator, there is an attempt to standardize addresses with a rating of 2. If they can be successfully standardized, this column is updated to 0. If not, this column is updated to 1. When an address is added individually there is a real-time attempt to standardize it. If the standardization is successful, this column's value will be set to 0. If the user skips the validation process this column's value will be set to 1.
school address type	dim_Adm_School_Attendance	Slate allows Permanent and Mailing for people. For organizations, a third type called Location is available.
school address validated	dim_Adm_School_Attendance	If the address has been validated by USPS this value will be 'Validated' otherwise it will be null.
school attendance guid	dim_Adm_School_Attendance	A Slate generated identifier for a school a particular person has attended, rarely used and only by administrators.
school awards	dim_Adm_School_Attendance	Awards the student received at this particular school.
school ceeb code	dim_Adm_School_Attendance	A unique school identifier.
School Census Division	dim_Adm_School_Attendance	The nine US Census geographic divisions, plus the US Territories. Miscellaneous are coded as 'Other US'
School Census Region	dim_Adm_School_Attendance	The four Census Regions, plus the US Territories. Miscellaneous are coded as 'Other US'
school city	dim_Adm_School_Attendance	The city where the school is located.
school continent	dim_Adm_School_Attendance
school country	dim_Adm_School_Attendance	The full name of the country where the school is located.
school country code	dim_Adm_School_Attendance	The country code of the school.
school country short name	dim_Adm_School_Attendance
school county	dim_Adm_School_Attendance
school created date	dim_Adm_School_Attendance	The date the school was created in Slate.
school distance to trin	dim_Adm_School_Attendance	Distance (in miles) from the address to Trinity. (Direct distance as the crow flies, not driving distance) This is calculated using delivered SQL functions within the Slate address query. Trinity latitude: -72.6924223 and longitude: 41.749967. sql generated by slate as of 1.30.2020 left((ads__JID_.[geo].STDistance(geography::STGeomFromText('point(' + '-72.6924223' + ' ' + '41.749967' + ')', 4326)) / 1609.344), '6')
school geomarket	dim_Adm_School_Attendance
school geomarket guid	dim_Adm_School_Attendance
school hide	dim_Adm_School_Attendance
school identity	dim_Adm_School_Attendance
School Information Source	dim_Adm_School_Attendance	This column identifies the source of data for a particular record. If the ceeb code of a record has a match in the org table, that data will show on the record. If there is no matching ceeb code the school information found in the School Attendance table will show.
school language	dim_Adm_School_Attendance	Indicates if English is the primary language of instruction at this institution.
school latitude	dim_Adm_School_Attendance
school level of study	dim_Adm_School_Attendance	TODO - compare this to organization_category column to find inconsistencies Called Level of Study in Slate, This categorizes the school into three categories (as of 2/2020): Graduate, High School, Undergraduate.
school location	dim_Adm_School_Attendance	Region, State. Pulls from the organization table first and then school attendance.
school longitude	dim_Adm_School_Attendance
school name	dim_Adm_School_Attendance	The full name of the school.
school organization guid	dim_Adm_School_Attendance	A Slate generated identifier for an organization, rarely used and only by administrators.
school phone number	dim_Adm_School_Attendance	Phone number for the school.
school postal	dim_Adm_School_Attendance
school region	dim_Adm_School_Attendance	The region where the school is located.
school Region State Name	dim_Adm_School_Attendance
School Region Territory	dim_Adm_School_Attendance
school street 1	dim_Adm_School_Attendance
school street 2	dim_Adm_School_Attendance
school street 3	dim_Adm_School_Attendance
school street combined	dim_Adm_School_Attendance	Street 1, 2, and 3 concatenated together with a backslash '\' delimiter.
School Type	dim_Adm_School_Attendance	Stored in the custom fields, this column categorizes the type of school. As of 2/2020 the options were Charter, Home School, Independent, Public, Religious.
school username	dim_Adm_School_Attendance
school world region	dim_Adm_School_Attendance
school zip code	dim_Adm_School_Attendance
school zip4 code	dim_Adm_School_Attendance
sctn combined id	dim_CombinedSection_curr
seasonal	dim_Adm_Addresses_Consolidated	A yes/no flag that indicates whether address is temporary/seasonal.
second last name	dim_ACAD_Person
second last srch	dim_ACAD_Person
sel group	fact_ACAD_StudentClassEnrollment_snap
separate crse grd	dim_Gen_Edu_Reqs
seq_Major 1 Code	dim_Student_AcadPlan_curr
seq_Major 1 Department	dim_Student_AcadPlan_curr
seq_Major 1 Description	dim_Student_AcadPlan_curr
seq_Major 1 Short Description	dim_Student_AcadPlan_curr
seq_Major 2 Code	dim_Student_AcadPlan_curr
seq_Major 2 Department	dim_Student_AcadPlan_curr
seq_Major 2 Description	dim_Student_AcadPlan_curr
seq_Major 2 Short Description	dim_Student_AcadPlan_curr
seq_Major 3 Code	dim_Student_AcadPlan_curr
seq_Major 3 Department	dim_Student_AcadPlan_curr
seq_Major 3 Description	dim_Student_AcadPlan_curr
seq_Major 3 Short Description	dim_Student_AcadPlan_curr
seq_Minor 1 Code	dim_Student_AcadPlan_curr
seq_Minor 1 Department	dim_Student_AcadPlan_curr
seq_Minor 1 Description	dim_Student_AcadPlan_curr
seq_Minor 1 Short Description	dim_Student_AcadPlan_curr
seq_Minor 2 Code	dim_Student_AcadPlan_curr
seq_Minor 2 Department	dim_Student_AcadPlan_curr
seq_Minor 2 Description	dim_Student_AcadPlan_curr
seq_Minor 2 Short Description	dim_Student_AcadPlan_curr
seq_Minor 3 Code	dim_Student_AcadPlan_curr
seq_Minor 3 Department	dim_Student_AcadPlan_curr
seq_Minor 3 Description	dim_Student_AcadPlan_curr
seq_Minor 3 Short Description	dim_Student_AcadPlan_curr
seq_Multiple Major Codes	dim_Student_AcadPlan_curr
seq_Multiple Major Description	dim_Student_AcadPlan_curr
seq_Multiple Major Short Description	dim_Student_AcadPlan_curr
seq_Multiple Minor Codes	dim_Student_AcadPlan_curr
seq_Multiple Minor Description	dim_Student_AcadPlan_curr
seq_Multiple Minor Short Description	dim_Student_AcadPlan_curr
seq_Multiple Program Codes	dim_Student_AcadPlan_curr
seq_Multiple Program Description	dim_Student_AcadPlan_curr
seq_Multiple Program Short Description	dim_Student_AcadPlan_curr
seq_Program 1 Code	dim_Student_AcadPlan_curr
seq_Program 1 Department	dim_Student_AcadPlan_curr
seq_Program 1 Description	dim_Student_AcadPlan_curr
seq_Program 1 Short Description	dim_Student_AcadPlan_curr
seq_Program 2 Code	dim_Student_AcadPlan_curr
seq_Program 2 Department	dim_Student_AcadPlan_curr
seq_Program 2 Description	dim_Student_AcadPlan_curr
seq_Program 2 Short Description	dim_Student_AcadPlan_curr
session code	dim_ACAD_Class_snap
	dim_CombinedSection_curr
	dim_PriClassMeetingPattern_curr
	fact_ACAD_StudentClassEnrollment_snap
sessn enrl cntl	fact_ACAD_StudentClassEnrollment_snap
sex	dim_ACAD_Person
	dim_Adm_Person
Show Enrollment on Transcript	dim_ACAD_Student_Career_Term_snap
Show Statistics on Transcript	dim_ACAD_Student_Career_Term_snap
sibling count	dim_Adm_Application_Details	Number of siblings
Slideroom Submission 1 Type	dim_Adm_Application_Details	The type of the first Slideroom submission. Possible values include: Studio Arts, Film, Creative Writing, etc.
Slideroom Submission 2 Type	dim_Adm_Application_Details	The type of the second Slideroom submission. Possible values include: Studio Arts, Film, Creative Writing, etc.
Slideroom Submission 3 Type	dim_Adm_Application_Details	The type of the third Slideroom submission. Possible values include: Studio Arts, Film, Creative Writing, etc.
slideroom url	dim_Adm_Application_Details	URL for Slideroom portfolio
smoker	dim_ACAD_Person
smoker dt	dim_ACAD_Person
Snapshot Classification	dim_ACAD_Class_snap	Differentiates between the 'live' source system data and 'snapshot' data which is data in source system as of a particular date.
	dim_ACAD_Student_Career_Term_snap	Differentiates between the 'live' source system data and 'snapshot' data which is data in source system as of a particular date.
	dim_Adm_Addresses_Consolidated	Differentiates between the 'live' source system data and 'snapshot' data which is data in source system as of a particular date.
	dim_Adm_Scholarship	Differentiates between the 'live' source system data and 'snapshot' data which is data in source system as of a particular date.
	fact_ACAD_StudentClassEnrollment_snap	Differentiates between the 'live' source system data and 'snapshot' data which is data in source system as of a particular date.
	fact_Adm_Applications	Differentiates between the 'live' source system data and 'snapshot' data which is data in source system as of a particular date.
Snapshot Date	dim_ACAD_Class_snap	The specific 'As of date'
	dim_ACAD_Student_Career_Term_snap	The specific 'As of date'
	dim_Adm_Addresses_Consolidated	The specific 'As of date'
	dim_Adm_Scholarship	The specific 'As of date'
	fact_ACAD_StudentClassEnrollment_snap	The specific 'As of date'
	fact_Adm_Applications	The specific 'As of date'
Snapshot Scope	dim_ACAD_Class_snap	This identifies the field used to narrow the snapshot grain in the warehouse code.
	dim_ACAD_Student_Career_Term_snap	This identifies the field used to narrow the snapshot grain in the warehouse code.
	dim_Adm_Addresses_Consolidated	This identifies the field used to narrow the snapshot grain in the warehouse code.
	dim_Adm_Scholarship	This identifies the field used to narrow the snapshot grain in the warehouse code.
	fact_ACAD_StudentClassEnrollment_snap	This identifies the field used to narrow the snapshot grain in the warehouse code.
	fact_Adm_Applications	This identifies the field used to narrow the snapshot grain in the warehouse code.
Snapshot Type	dim_ACAD_Class_snap	A descriptive field that categorizes each snapshot.
	dim_ACAD_Student_Career_Term_snap	A descriptive field that categorizes each snapshot.
	dim_Adm_Addresses_Consolidated	A descriptive field that categorizes each snapshot.
	dim_Adm_Scholarship	A descriptive field that categorizes each snapshot.
	fact_ACAD_StudentClassEnrollment_snap	A descriptive field that categorizes each snapshot.
	fact_Adm_Applications	A descriptive field that categorizes each snapshot.
soc sec aff dt	dim_ACAD_Person
source guid	fact_Adm_Applications	This points to the data import record for this application.
Split Ownership of Subject	dim_ACAD_Class_snap	Y/N flag to indicate multiple academic organizations own this subject area.
sport 1	dim_Adm_Person
sport 1 rating	dim_Adm_Person
sport 2	dim_Adm_Person
sport 2 rating	dim_Adm_Person
sport 3	dim_Adm_Person
sport 3 rating	dim_Adm_Person
ssr show clsrch	dim_Gen_Edu_Reqs
staff assigned	dim_Adm_Person
staff assigned locked	dim_Adm_Person
Standard Meeting Pattern	dim_PriClassMeetingPattern_curr
Standard Meeting Pattern Code	dim_PriClassMeetingPattern_curr
Standard Meeting Pattern -sdescr	dim_PriClassMeetingPattern_curr
Start Date for Gen Standing PO	dim_ACAD_Student_Career_Term_snap
Start Dt	dim_PriClassMeetingPattern_curr
state	dim_ACAD_Person
	dim_Adm_segment_analysis_curr	2 character US Postal Service code which identifies the state of the student's address.
state other	dim_ACAD_Person
status dt	fact_ACAD_StudentClassEnrollment_snap
stdnt car nbr	dim_Student_AcadPlan_curr
stdnt enrl status	fact_ACAD_StudentClassEnrollment_snap
stdnt positin	fact_ACAD_StudentClassEnrollment_snap
street 1	dim_Adm_Addresses_Consolidated
street 2	dim_Adm_Addresses_Consolidated
street 3	dim_Adm_Addresses_Consolidated
street combined	dim_Adm_Addresses_Consolidated	Street 1, 2, and 3 concatenated together with a backslash '\' delimiter.
street1	dim_Adm_segment_analysis_curr	Line 1 of the student's home street address.
street2	dim_Adm_segment_analysis_curr	Line 2 of the student's home street address.
street3	dim_Adm_segment_analysis_curr	Line 3 of the student's home street address.
strm	dim_ACAD_Class_snap
	dim_CombinedSection_curr
	dim_PriClassMeetingPattern_curr
	fact_ACAD_StudentClassEnrollment_snap
Student Career Nbr	dim_ACAD_Student_Career_Term_snap
Student Enrl Status	dim_Course_Enrl_Codes_curr
Student Enrl Status - Long Descr	dim_Course_Enrl_Codes_curr
Student Enrollment Status Code	dim_Course_Enrl_Codes_curr
Student Enrollment Status Reason Code	dim_Course_Enrl_Codes_curr
student status	dim_Adm_segment_analysis_curr
Student-Specific Permissions	dim_ACAD_Class_snap	Student-specific permissions enable instructors or administrators to control section enrollment by granting advance add permission to individual students. Note: This applies only to add permissions. Drop permissions are always student specific, whether or not the check box is selected.
	fact_ACAD_StudentClassEnrollment_snap	Student-specific permissions enable instructors or administrators to control section enrollment by granting advance add permission to individual students. Note: This applies only to add permissions. Drop permissions are always student specific, whether or not the check box is selected.
Study Agreement	dim_ACAD_Student_Career_Term_snap
subject	fact_ACAD_StudentClassEnrollment_snap
Subject Code	dim_ACAD_Class_snap
Subject Name	dim_ACAD_Class_snap
Subject Name-Short	dim_ACAD_Class_snap
suffix	dim_Adm_Person
Sun	dim_PriClassMeetingPattern_curr
t
tc double	dim_Gen_Edu_Reqs
TC employee relatives	dim_Adm_Application_Details	List of relatives who are employed by Trinity, by relationship type. Possible values include: Aunt, Brother, Cousin, Great Aunt, Grandfather, Grandmother, Great Grandfather, Great Grandmother, Great Uncle, Niece, Nephew, Other Relative, Step-Brother, Sister, Step-Sister, Step-Grandfather, Step-Grandmother, Uncle
TC Units Adjustment	dim_ACAD_Student_Career_Term_snap	Transfer Credits Unit Adjustment
Term	dim_ACAD_Student_Career_Term_snap
Term Activation Date	dim_ACAD_Student_Career_Term_snap	Date when the student was term activated.
Term Unit Type	dim_ACAD_Student_Career_Term_snap	Default Value from ACAD_CAR_TBL.TERM_TYPE
Thurs	dim_PriClassMeetingPattern_curr
toefl ibt selfreport	dim_adm_Superscores_Verified	TOEFL iBT total superscore - including self-reported and verified scores; score range: 0 to 120
toefl ibt verified	dim_adm_Superscores_Verified	TOEFL iBT total superscore - verified scores; score range: 0 to 120
toefl pbt selfreport	dim_adm_Superscores_Verified	TOEFL PBT total superscore - including self-reported and verified scores; score range: 0 to 120
toefl pbt verified	dim_adm_Superscores_Verified	TOEFL PBT total superscore - verified scores; score range: 0 to 120
Topic Text	dim_PriClassMeetingPattern_curr
Total Audited	dim_ACAD_Student_Career_Term_snap
Total Cumulative Units	dim_ACAD_Student_Career_Term_snap
Total Fin Aid Grade Points	dim_ACAD_Student_Career_Term_snap
Total Fin Aid Taken Toward GPA	dim_ACAD_Student_Career_Term_snap
Total Fin Aid Units Passed	dim_ACAD_Student_Career_Term_snap
Total Fin Aid Units Taken	dim_ACAD_Student_Career_Term_snap
Total from Other Credit	dim_ACAD_Student_Career_Term_snap
Total From Test Credit	dim_ACAD_Student_Career_Term_snap
Total Grade Points	dim_ACAD_Student_Career_Term_snap	Cumulative Grade Points of Enrollment and Transfer Credits.
Total In Progress - GPA	dim_ACAD_Student_Career_Term_snap
Total In Progress - Not for GPA	dim_ACAD_Student_Career_Term_snap
Total Passed for Progress	dim_ACAD_Student_Career_Term_snap
Total Passed Not Toward GPA	dim_ACAD_Student_Career_Term_snap
Total Passed Toward GPA	dim_ACAD_Student_Career_Term_snap
Total Semesters Taken	dim_ACAD_Program	Total semesters taken within this program.
Total Taken for Progress	dim_ACAD_Student_Career_Term_snap
Total Taken Not Toward GPA	dim_ACAD_Student_Career_Term_snap
Total Taken Toward GPA	dim_ACAD_Student_Career_Term_snap	Cumulative Units for GPA of Enrollments and Transfer Credits.
Total Term Units	dim_ACAD_Student_Career_Term_snap
Total Transferred	dim_ACAD_Student_Career_Term_snap
Tozer_10	dim_Adm_Scholarship
Tozer_25	dim_Adm_Scholarship
Transfer Credit Cumulative GPA	dim_ACAD_Student_Career_Term_snap	Cumulative GPA of Transfer Credits
Transfer Credit Current GPA	dim_ACAD_Student_Career_Term_snap	Term GPA of Transfer Credits
Transfer Credit Grade Points	dim_ACAD_Student_Career_Term_snap	Cumulative Transfer Credits Grade Points
Transfer Grade Points	dim_ACAD_Student_Career_Term_snap	Term Grade Points of Transfer Credits.
Transfer in Residence Terms	dim_ACAD_Student_Career_Term_snap
Transfer Passed for GPA	dim_ACAD_Student_Career_Term_snap
Transfer Passed Not for GPA	dim_ACAD_Student_Career_Term_snap
Transfer Taken for GPA	dim_ACAD_Student_Career_Term_snap	Term Units for GPA of Transfer Credits
Transfer Taken Not for GPA	dim_ACAD_Student_Career_Term_snap
Trinity app fee waiver	dim_Adm_Application_Details	Indication of a Trinity-specific application fee waiver. "Do you intend to use one of these school-specific fee waivers?" Values include: "Waiver Yes" - CommonApp prompt: "I have been pre-authorized for a Trinity College application fee waiver" "First Gen Waiver" - CommonApp prompt: "I am a first generation college student and eligible for a Trinity College application fee waiver." "Waiver No" - CommonApp prompt: "None"
Trinity Essay Type	fact_Adm_Applications	Trinity Supplemental Essay Type
Trinity_Club_Hartford	dim_Adm_Scholarship
tscrpt note exists	fact_ACAD_StudentClassEnrollment_snap
tscrpt note id	fact_ACAD_StudentClassEnrollment_snap
tscrpt print	dim_Gen_Edu_Reqs
Tues	dim_PriClassMeetingPattern_curr
Tuit Calc Date Time	dim_ACAD_Student_Career_Term_snap
Tuition Calc Required	dim_ACAD_Student_Career_Term_snap	Default Value from BUS_UNIT_TBL_SF.TERM_ACT_INIT_SET
Tuition exchange application	dim_Adm_Application_Details
Tuition Group	dim_ACAD_Student_Career_Term_snap
Tuition Residency	dim_ACAD_Student_Career_Term_snap
Tuition_Exchange	dim_Adm_Scholarship
Type of Combined Section Group	dim_ACAD_Class_snap	Sections can be combined "Within Subject", "Cross Subject", or "Both." Values for this field are delivered with your system as translate values. There is no programming associated with this field.
	dim_CombinedSection_curr	Sections can be combined "Within Subject", "Cross Subject", or "Both." Values for this field are delivered with your system as translate values. There is no programming associated with this field.
u
Unit Multiplier	dim_ACAD_Student_Career_Term_snap
Unit Progress Changed Date NSC	dim_ACAD_Student_Career_Term_snap
United States Citizenship Status	dim_ACAD_Person
United States Citizenship Status Description	dim_ACAD_Person
Units Academic Progress	dim_ACAD_Class_snap
units attempted	fact_ACAD_StudentClassEnrollment_snap
Units Audited	dim_ACAD_Student_Career_Term_snap
Units FinAid Progress	dim_ACAD_Class_snap
Units from Other Credit	dim_ACAD_Student_Career_Term_snap
Units from Test Credit	dim_ACAD_Student_Career_Term_snap
Units in Progress - GPA	dim_ACAD_Student_Career_Term_snap
Units in Progress - Not for GPA	dim_ACAD_Student_Career_Term_snap
Units Maximum	dim_ACAD_Class_snap	The maximum number of units at the class level
Units Minimum	dim_ACAD_Class_snap	The minimum number of units at the class level
Units Passed for Progress	dim_ACAD_Student_Career_Term_snap
Units Passed Not Toward GPA	dim_ACAD_Student_Career_Term_snap
Units Passed Toward GPA	dim_ACAD_Student_Career_Term_snap
Units taken	fact_ACAD_StudentClassEnrollment_snap	Logic copied from IRP table build
Units Taken for Progress	dim_ACAD_Student_Career_Term_snap
Units Taken Not toward GPA	dim_ACAD_Student_Career_Term_snap
Units Taken Toward GPA	dim_ACAD_Student_Career_Term_snap
	dim_ACAD_Student_Career_Term_snap	Cumulative Enrollment Units for GPA
	dim_ACAD_Student_Career_Term_snap	Cumulative Transfer Credits Units for GPA
Units Transferred	dim_ACAD_Student_Career_Term_snap
unt billing	fact_ACAD_StudentClassEnrollment_snap
unt earned	fact_ACAD_StudentClassEnrollment_snap
unt prgrss	fact_ACAD_StudentClassEnrollment_snap
unt prgrss fa	fact_ACAD_StudentClassEnrollment_snap
unt taken	fact_ACAD_StudentClassEnrollment_snap
US Armed Forces status	dim_Adm_Application_Details	Status related to US Armed Forces. Values include Currently Serving, Previously Served, Current Dependent.
us visa holder	dim_Adm_Person
us work eligibilty	dim_ACAD_Person
v
va benefit	dim_ACAD_Person
VA benefits inquiry	dim_Adm_Application_Details	Veterans Administratoin benefits
valid attempt	fact_ACAD_StudentClassEnrollment_snap
vericant embed url	dim_Adm_Person
vericant id	dim_Adm_Person
vericant spoken english score	dim_adm_Superscores_Verified	Vericant Spoken English Evaluation (SEE) score; score range: 1 to 6
w
Wait List Capacity- Combined Section	dim_ACAD_Class_snap	Wait list capacity of the combined section group
	dim_CombinedSection_curr	Wait list capacity of the combined section group
Wait List Capacity of the Section	dim_ACAD_Class_snap	The maximum number of students allowed to wait list for the class.
	fact_ACAD_StudentClassEnrollment_snap	The maximum number of students allowed to wait list for the class.
Wait List Total- Combined Section	dim_ACAD_Class_snap	Total students on the wait list of the combined section group
	dim_CombinedSection_curr	Total students on the wait list of the combined section group
Wait List Total of the Section	dim_ACAD_Class_snap	The total number of students on the wait list for the section.
	fact_ACAD_StudentClassEnrollment_snap	The total number of students on the wait list for the section.
Waitlist Confirmed Date	dim_Adm_Decisions
waitlist daemon	dim_ACAD_Class_snap
	fact_ACAD_StudentClassEnrollment_snap
Waitlist Letter	dim_Adm_Decisions
Waitlist Reason	dim_Adm_Decisions
Waitlist Received Date	dim_Adm_Decisions
Waitlist Released Date	dim_Adm_Decisions
Waitlist/Accept Confirmed Date	dim_Adm_Decisions
Waitlist/Accept Letter	dim_Adm_Decisions
Waitlist/Accept Reason	dim_Adm_Decisions
Waitlist/Accept Received Date	dim_Adm_Decisions
Waitlist/Accept Released Date	dim_Adm_Decisions
Waitlist/Decline Confirmed Date	dim_Adm_Decisions
Waitlist/Decline Letter	dim_Adm_Decisions
Waitlist/Decline Reason	dim_Adm_Decisions
Waitlist/Decline Received Date	dim_Adm_Decisions
Waitlist/Decline Released Date	dim_Adm_Decisions
Wed	dim_PriClassMeetingPattern_curr
White	dim_ACAD_Person	The race 'White' has been recorded for this person. Other races and/or ethnicity could also be indicated for this person.
Withdraw Confirmed Date	dim_Adm_Decisions
Withdraw Letter	dim_Adm_Decisions
Withdraw Reason	dim_Adm_Decisions
Withdraw Received Date	dim_Adm_Decisions
Withdraw Released Date	dim_Adm_Decisions
Withdrawal \ Cancel	dim_ACAD_Student_Career_Term_snap	Default Value = 'NWD'
Withdrawal \ Cancel Date	dim_ACAD_Student_Career_Term_snap
Withdrawal \ Cancel Reason	dim_ACAD_Student_Career_Term_snap
world region	dim_Adm_Addresses_Consolidated
x
y
years of education	dim_Degrees_curr
Yellow_Ribbon	dim_Adm_Scholarship
z
zip	dim_Adm_segment_analysis_curr	US Postal Code (including the dash) for US addresses.
zip code	dim_Adm_Addresses_Consolidated
zip4 code	dim_Adm_Addresses_Consolidated

Trinity Warehouse Production Business Glossary Documentation

Glossary for the Trinity Warehouse Production Business Glossary

Business term

Analysis area

Comments

1823_High

1823_Low

acad career

Acad Career of the Class Section

Acad Group

acad plan

acad prog

acad program

Academic Career

Academic Dept of the Subject

Academic Group of Advisor

academic interest 1

academic interest 1 name

academic interest 2

academic interest 2 name

academic interest 3

academic interest 3 name

Academic Level - Projected

Academic Level - Term End

Academic Level - Term Start

Academic Load

Academic Load Change Date

Academic Org Code of the Class

Academic Org Manager- Class

Academic Organization -Class

Academic Organization of the Class

Academic Year

act composite

act english

ACT English Language Arts

ACT English Writing

act high score date

act math

act most recent date

act reading

act science reasoning

ACT STEM

ACT Writing

ACT Writing Pre-9/2016

ACT Writing: Development and Support

ACT Writing: Ideas and Analysis

ACT Writing: Language Use and Conventions

ACT Writing: Organization

addr field1

addr field1 other

addr field2

addr field2 other

addr field3

addr field3 other

address created date

address effective date

address expiration date

Address Guid

address notes

address priority

address quality

address rank

address rank overall

address type

address validated

address1

address1 ac

address1 other

address2

address2 ac

address2 other

address3

address3 ac

address3 other

address4

address4 other

Adjusted Units

Admit Confirmed Date

Admit Letter

Admit Reason