|
[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
D a t a D i c t i o n a r y
Summary Object
- The Summary object contains cumulative student summary data. This object contains one record per level of coursework ('UG', 'GR', or 'LW') for each student included in the Student Data Warehouse.
- Warehouse ID
- Warehouse identification code. A unique identifying value for all persons in the Student Data Warehouse.
- Data Type: Number
- Example: 123456
- Source: derived
- Summary Course Level
- Course level of a student's work. 'UG' for Undergraduate, 'GR' for Graduate, 'LW' for Law.
- Data Type: 2 Characters
- Example: GR
- Source: shrlgpa_levl_code
- Accum UO Attempt Hours
- UO credit hours attempted for the course level.
- Data Type: 3 Digit number plus 2 decimal places
- Example: 78
- Source: shrlgpa_hours_attempted
- Accum UO Earn Hours
- UO credit hours earned for the course level.
- Data Type: 3 Digit number plus 2 decimal places
- Example: 78
- Source: shrlgpa_hours_earned
- Accum UO GPA Hours
- Credit hours used for Grade Point Average calculation for the course level.
- Data Type: 3 Digit number plus 2 decimal places
- Example: 77
- Source: shrlgpa_gpa_hours
- Accum UO Quality Points
- UO quality points for the course level. It is the sum of credit hours for all UO courses times quality points for each grade at this course level. Used for GPA calculations.
- Data Type: 4 Digit number plus 2 decimal places
- Example: 271
- Source: shrlgpa_quality_points
- Accum UO GPA
- UO Grade Point Average for the course level. It is calculated by dividing GPA hours for the level into Accum UO Quality Points for the course level.
- Data Type: 4 Digit number plus 6 decimal places
- Example: 3.51
- Source: shrlgpa_gpa
- Accum Transfer Attempt Hours
- Cumulative transfer credit hours attempted for the course level.
- Data Type: 3 Digit number plus 2 decimal places
- Example: 0
- Source: shrlgpa_hours_attempted
- Accum Transfer Earn Hours
- Cumulative transfer credit hours earned for the course level.
- Data Type: 3 Digit number plus 2 decimal places
- Example: 0
- Source: shrlgpa_hours_earned
- Accum Transfer GPA Hours
- Cumulative Transfer credit hours used for Grade Point Average calculation for the course level.
- Data Type: 3 Digit number plus 2 decimal places
- Example: 0
- Source: shrlgpa_gpa_hours
- Accum Transfer Quality Points
- Cumulative transfer quality points for the course level. It is calculated by multiplying credit hours of the course by quality points associated with the grade. Used for GPA calculations.
- Data Type: 4 Digit number plus 2 decimal places
- Example: 0
- Source: shrlgpa_quality_points
- Accum Transfer GPA
- Cumulative transfer Grade Point Average for the course level. It is calculated by dividing Accum Transfer GPA hours into Accum Transfer Quality points.
- Data Type: 4 Digit number plus 6 decimal places
- Example: 0
- Source: shrlgpa_gpa
- Accum Overall Attempt Hours
- Cumulative UO and transfer credit hours attempted for the course level.
- Data Type: 3 Digit number plus 2 decimal places
- Example: 78
- Source: shrlgpa_hours_attempted
- Accum Overall Earn Hours
- Cumulative UO and transfer credit hours earned for the course level.
- Data Type: 3 Digit number plus 2 decimal places
- Example: 78
- Source: shrlgpa_hours_earned
- Accum Overall GPA Hours
- Cumulative UO and transfer credit hours used for GPA calculation for the course level.
- Data Type: 3 Digit number plus 2 decimal places
- Example: 77
- Source: shrlgpa_gpa_hours
- Accum Overall Quality Points
- Cumulative UO and transfer quality points for the course level. It is calculated as the sum of credit hours for all UO and transfer courses times quality points for each grade at this course level. Used for GPA calculations.
- Data Type: 4 Digit number plus 2 decimal places
- Example: 271
- Source: shrlgpa_quality_points
- Accum Overall GPA
- Cumulative UO and transfer GPA for the course level. It is calculated by dividing Grade Point Average hours into Quality points.
- Data Type: 4 Digit number plus 6 decimal places
- Example: 3.51
- Source: hrlgpa_gpa
- Excess Transfer Hours Deducted
- Number of transfer credit hours exceeding maximum allowable.(AdmitAp Summary only)
- Data Type: 5 Digit number plus 2 decimal places.
- High School Code
- Most recent high school the student attended, according to UO application information.
- Data Type: 7 Characters
- Example: 481365
- Source: sorhsch_sbgi_code
- Val Table: Educational Institution
- High School Desc
- Text Description of High School Code.
- Data Type: 30 Characters
- Example: Bellarmine
- Source: stvsbgi_desc
- Val Table: Institution
- High School Grad Date
- Graduation date of the most recently attended high school.
- Data Type: Date
- Example: 06/01/88
- Source: sorhsch_graduation_date
- High School GPA
- GPA for the most recently attended high school
- Data Type: 4 Digit number plus 6 decimal places
- Example: 3.9
- Source: sorhsch_gpa
- SAT Verbal Score
- Highest SAT verbal score.
- Data Type: Number
- Example: 700
- Source: sortest_test_score 'SATV'
- SAT Verbal Date
- Date highest SAT verbal score was achieved.
- Data Type: Date
- Example: 06/01/94
- Source: sortest_test_score
- SAT Math Score
- Highest SAT math score.
- Data Type: Number
- Example: 650
- Source: sortest_test_score 'SATM'
- SAT Math Date
- Date highest SAT math score was achieved.
- Data Type: Date
- Example: 06/01/94
- Source: sortest_test_date
- Combined SAT Verbal Score
- SAT verbal score from highest composite SAT score. "Composite" means verbal/math scores from the same test date.
- Data Type: Number
- Example: 700
- Source: sortest_test_score
- Combined SAT Math Score
- SAT math score from highest composite SAT score. "Composite" means verbal/math scores from the same test date.
- Data Type: Number
- Example: 650
- Source: sortest_test_score
- Combined SAT Date
- Date of highest composite SAT score.
- Data Type: Date
- Example: 06/01/94
- Source: sortest_test_score
- ACT English Score
- Highest ACT English score.
- Data Type: Number
- Example: 25
- Source: sortest_test_score 'ACTE'
- ACT English Date
- Date the highest ACT English score was achieved.
- Data Type: Date
- Example: 06/01/95
- Source: sortest_test_date
- ACT Math Date
- Date the highest ACT math score was achieved.
- Data Type: Date
- Example: 06/01/94
- Source: sortest_test_date
- ACT Math Score
- Highest ACT math score.
- Data Type: Number
- Example: 31
- Source: sortest_test_score 'ACTM'
- ACT Composite Score
- Highest ACT composite score. "Composite" means english/math scores from the same test date.
- Data Type: Number
- Example: 31
- Source: sortest_test_score
- ACT Composite Date
- Date the highest ACT composite score was achieved.
- Data Type: Date
- Example: 06/01/94
- Source: sortest_test_date
- TOEFL Score
- Highest TOEFL (Test of English as a Foreign Language) score.
- Data Type: Number
- Example: 833
- Source: sortest_test_score 'TEOF'
- TOEFL Date
- Date of highest TOEFL score.
- Data Type: Date
- Example: 06/01/94
- Source: sortest_test_date
- TSWE Score
- Highest TSWE (Test of Standard Written English) score.
- Data Type: Number
- Example: 550
- Source: sortest_test_score 'TSWE'
- MATH Score
- Highest UO Math placement score.
- Data Type: Number
- Example: 32
- Source: sortest_test_score 'MATH'
- GED Score
- Highest GED score.
- Data Type: Number
- Example: 66
- Source: sortest_test_score 'GED'
- SAT2 Codes
- SAT2 codes, separated by '|' (pipe characters).
- Data Type: 99 Characters
- Example: |ACAH|ACBY|ACCH|
- Source: sortest_tesc_code
- SAT2 Scores
- SAT2 test scores, separated by '|' (pipe characters).
- Data Type: 99 Characters
- Example: |550|580|600|
- Source: sortest_test_score
- SAT2 Dates
- SAT2 test dates, separated by '|' (pipe characters).
- Data Type: 99 Characters
- Example: |01-MAR-95|01-FEB-95|01-MAR-95|
- Source: sortest_test_date
- LGPA Score
- Highest LGPA score. This is the Law School cumulative GPA 'test' normalized GPA provided by Law School Data Service, the cumulative GPA of all previous colleges, used for admission determination for law school.
- Data Type: Number
- Example: 31
- Source: sortest_test_score
- LST1 Score
- Highest LST1 score. This is part of the Law School Admission test.
- Data Type: Number
- Example: 31
- Source: sortest_test_score
- LST2 Score
- Highest LST2 score. This is part of the Law School Admission test.
- Data Type: Number
- Example: 31
- Source: sortest_test_score
- Gender
- Student's gender, M = Malel, F = Female, N = Not designated.
- Data Type: 1 Character
- Example: M
- Source: spbpers_sex
- Birth Date
- Student's birth date.
- Data Type: Date
- Example: 12/28/61
- Source: spbpers_birth_date
- Ethnic Code
- Ethnicity code associated with the student.
- Data Type: 2 Characters
- Example: W
- Source: spbpers_ethn_code
- Val Table: Ethnicity
- Ethnic Desc
- Description of ethnicity code.
- Data Type: 30 Characters
- Example: W
- Source: stvethn_desc
- Val Table: Ethnicity
- Ethnic Type Code
- Ethnic Type Category Code, groups ethnic codes into the U.S. government-defined ethnic categories required for most official reporting. They are: (1) Black, Non-Hispanic; (2) American Indian or Alaskan Native; (3) Asian or Pacific Islander; (4) Hispanic; (5) White Non-Hispanic; (6) Other.
- Data Type: 2 Characters
- Example: 3
- Source: stvethn_ectc_code
- Val Table: Ethnicity
- Ethnic Type Desc
- Description of Ethnic Type Category Code.
- Data Type: 30 Characters
- Example: W
- Source: stvectc_desc
- Val Table: Ethnicity
- Citizenship Nation Code
- Code of the nation of student's citizenship. Populated only for non-U.S. citizens.
- Data Type: 4 Characters
- Example: LUS
- Source: sprintl_natn_code_legal
- Val Table: Nation*
- Citizenship Nation Desc
- Description of nation of student's citizenship.
- Data Type: 30 Characters
- Example: United States
- Source: stvnatn_nation
- Val Table: Nation*
This page was last updated on February 15, 2000.
[Home |
Announcements |
Access |
Installation |
User Notes |
Data Dictionary |
Mailing List |
Contact]
|
|
