Administrative Services Information Services home
Main Navigation

    [Home | Announcements | Access | Installation | User Notes | Data Dictionary | Mailing List | Contact]

    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.
Search Box