Darton State College
Home » Administration » Data Warehouse » Data Dictionaries » Table: WACADHST
Data Warehouse
Home | Search | Training | Data Dictionaries | Reports | Register | News | Email
WACADHST Student Academic History Table
(MUST BE ACCESSED THROUGH HOUSE)
User Dictionary
Revision Date: April 19, 2000.
NOTE: Data items prefixed by 'WHH' pertain to the student (e.g.
name,major,etc.). Those prefixed by 'WHD' pertain to the student grade
history.
- WHH_LINK (8)
- A data item used to link appropriate data warehouse tables.
- A data item used to link appropriate data warehouse tables.
- WHH_SYSDATE (Date)
- The system date and time the general student information in this
table was created.
- The system date and time the general student information in this
table was created.
- WHH_LAST_NAME (25)
- Student's last name.
- Student's last name.
- WHH_FIRST_NAME (15)
- Student's first name.
- Student's first name.
- WHH_MI (2)
- Student's middle initial.
- Student's middle initial.
- WHH_NAME_LFM (35)
- Student's last name, first name and middle initial.
- Student's last name, first name and middle initial.
- WHH_NAME_FML (35)
- Student's first name, middle initial, and last name.
- Student's first name, middle initial, and last name.
- WHH_STREET_LINE1 (30)
- Street address line 1 (mailing address).
- Street address line 1 (mailing address).
- WHH_STREET_LINE2 (30)
- Street address line 2 (mailing address).
- Street address line 2 (mailing address).
- WHH_STREET_LINE3 (30)
- Street address line 3 (mailing address).
- Street address line 3 (mailing address).
- WHH_CITY (20)
- City name (mailing address).
- City name (mailing address).
- WHH_STAT_CODE (3)
- State code (mailing address).
- See BANNER form STVSTAT for valid codes.
- See BANNER form STVSTAT for valid codes.
- State code (mailing address).
- WHH_ZIP (10)
- Zipcode (mailing address).
- See BANNER form GTVZIPC for valid codes.
- See BANNER form GTVZIPC for valid codes.
- Zipcode (mailing address).
- WHH_COUNTY_CODE (5)
- County code (mailing address).
- See BANNER form STVCNTY for valid codes.
- See BANNER form STVCNTY for valid codes.
- County code (mailing address).
- WHH_COUNTY_DESC (30)
- County description (mailing address).
- County description (mailing address).
- WHH_PHONE_MA (12)
- Phone number [format is: 999-999-9999] (for mailing address).
- Phone number [format is: 999-999-9999] (for mailing address).
- WHH_SS_NUMBER (9)
- Social security number.
- Social security number.
- WHH (Date)
- Birth date.
- Birth date.
- WHH_ETHNIC (2)
- Ethnic code.
- See BANNER form STVETHN for valid codes.
- See BANNER form STVETHN for valid codes.
- Ethnic code.
- WHH_ETHNIC_DESC (30)
- Ethnic description.
- Ethnic description.
- WHH_SEX (1)
- Sex.
- F - Female
- M - Male
- N - Not available
- Sex.
- WHH_CONFID_IND (1)
- Confidentiality indicator identifies whether or not the student
wishes to have personal information, such as address and telephone
number, kept confidential.
- Y - Yes, keep information confidential.
- N - No confidentiality requested.
- Confidentiality indicator identifies whether or not the student
wishes to have personal information, such as address and telephone
number, kept confidential.
- WHH_NATION_CODE (5)
- Nation code.
- blank - USA
- See BANNER form STVNATN for valid codes.
- Nation code.
- WHH_NATION_DESC (28)
- Nation code description.
- blank - USA
- blank - USA
- Nation code description.
- WHH_CITIZENSHIP_CODE (5)
- Citizenship code.
- C - Citizen
- A - Alien, non-resident
- R - Alien, resident
- See BANNER form STVCITZ for valid codes.
- See BANNER form STVCITZ for valid codes.
- Citizenship code.
- WHH_CITIZENSHIP_DESC (28)
- Citizenship description.
- Citizenship description.
- WHH_LEVEL_CODE (2)
- Level code of the student.
- US - Undergraduate Semester
- See BANNER form STVLEVL for valid codes.
- See BANNER form STVLEVL for valid codes.
- US - Undergraduate Semester
- Level code of the student.
- WHH_LEVEL_DESC (30)
- Level code description.
- Level code description.
- WHH_STUDENT_TYPE (1)
- Student type code.
- See BANNER form STVSTYP for valid codes.
- See BANNER form STVSTYP for valid codes.
- Student type code.
- WHH_STUDENT_TYPE_DESC (30)
- Student type description.
- Student type description.
- WHH_COLLEGE (2)
- College code.
- See BANNER form STVCOLL for valid codes.
- See BANNER form STVCOLL for valid codes.
- College code.
- WHH_COLLEGE_DESC (24)
- College description.
- College description.
- WHH_DEPARTMENT (4)
- Department code.
- See BANNER form STVDEPT for valid codes.
- See BANNER form STVDEPT for valid codes.
- Department code.
- WHH_DEPARTMENT_DESC (24)
- Department description.
- Department description.
- WHH_DEGREE (6)
- Code of the degree that student is seeking.
- See BANNER form STVDEGC for valid codes.
- See BANNER form STVDEGC for valid codes.
- Code of the degree that student is seeking.
- WHH_DEGREE_DESC (24)
- Description of degree.
- Description of degree.
- WHH_MAJOR_1 (4)
- Student's first major code.
- See BANNER form STVMAJR for valid codes.
- See BANNER form STVMAJR for valid codes.
- Student's first major code.
- WHH_MAJOR_1_DESC (24)
- Description of student's first major.
- Description of student's first major.
- WHH_MAJOR_2 (4)
- Student's second major code.
- See BANNER form STVMAJR for valid codes.
- See BANNER form STVMAJR for valid codes.
- Student's second major code.
- WHH_MAJOR_2_DESC (24)
- Description of student's second
major.
- Description of student's second
major.
- WHH_EXP_GRAD_DATE (Date)
- Expected graduation date for current major. (Not available at
this time.)
- Expected graduation date for current major. (Not available at
this time.)
-
WHH_ACADEMIC_STANDING * (2)
- Student's Academic standing code as last calculated. This code
would be the same as WHH_ACAD_ORIGINAL_STAND unless it has been
overridden, then it would be the same as WHH_ACAD_STAND_OVERRIDE.
- See BANNER form STVASTD for valid codes.
- See BANNER form STVASTD for valid codes.
- Student's Academic standing code as last calculated. This code
would be the same as WHH_ACAD_ORIGINAL_STAND unless it has been
overridden, then it would be the same as WHH_ACAD_STAND_OVERRIDE.
- WHH_ACAD_STAND_OVERRIDE * (2)
- Student's academic standing override code. This field will be
blank if no override occurred during the current term.
- See BANNER form STVASTD for valid codes.
- See BANNER form STVASTD for valid codes.
- Student's academic standing override code. This field will be
blank if no override occurred during the current term.
- WHH_ACAD_STAND_OVER_TERM * (6-yyyymm)
- The term associated with the academic standing override code.
- The term associated with the academic standing override code.
- WHH_ACAD_ORIGINAL_STAND * (2)
- The student's academic standing code as last calculated.
- See BANNER form STVASTD for valid codes.
- See BANNER form STVASTD for valid codes.
- The student's academic standing code as last calculated.
- WHH_FIRST_TERM (6-yyyymm)
- The first term in which the student registered or, if never
registered, the term in which the student was admitted.
- See BANNER form STVTERM for valid codes.
- See BANNER form STVTERM for valid codes.
- The first term in which the student registered or, if never
registered, the term in which the student was admitted.
- WHH_LAST_TERM (6-yyyymm)
- The last term in which grades were processed for a student,
including withdrawals.
- See BANNER form STVTERM for valid codes.
- See BANNER form STVTERM for valid codes.
- The last term in which grades were processed for a student,
including withdrawals.
- WHH_CLASSIFICATION * (3)
- Classification of student based on hours earned.
- FR - Freshman
- SO - Sophomore
- See BANNER form STVCLAS for valid codes.
- See BANNER form STVCLAS for valid codes.
- Classification of student based on hours earned.
- WHH_CLASSIFICATION_DESC(30)
- WHH_HIGHSCHOOL_AVERAGE (14)
- Student's highschool grade average.
- Student's highschool grade average.
- WHH_HOURS_EARNED_DAR * (999.99)
- Institutional hours earned from Darton. (This data item is
not used in GPA calculations.)
- Institutional hours earned from Darton. (This data item is
not used in GPA calculations.)
- WHH_HOURS_TRANSFERED (999.99)
- Total number of hours transferred from all other
institutions, applicable to the student's level. (See WHH_LEVEL_CODE
data item for level descriptions.)
- Total number of hours transferred from all other
institutions, applicable to the student's level. (See WHH_LEVEL_CODE
data item for level descriptions.)
- WHH_HOURS_TOTAL * (999.99)
- Total hours earned (Darton hours + transferred hours).
- Total hours earned (Darton hours + transferred hours).
- WHH_ADJ_GPA * (9999.999999)
- Students adjusted grade point average (using Darton hours
only). This is the GPA shown on students' grade reports. (See
the Darton catalog for a complete definition of 'adjusted
GPA.')
- Students adjusted grade point average (using Darton hours
only). This is the GPA shown on students' grade reports. (See
the Darton catalog for a complete definition of 'adjusted
GPA.')
- WHH_CUM_GPA * (9999.999999)
- Student's cumulative grade point average. This does not
currently appear in Banner, but is included on student
transcripts.
- Student's cumulative grade point average. This does not
currently appear in Banner, but is included on student
transcripts.
- WHH_GPA_HOURS * (5)
- Student's institutional GPA hours from Darton.
- Student's institutional GPA hours from Darton.
- WHH_GPA_POINTS * (5)
- The institutional GPA points based on GPA hours from Darton.
- The institutional GPA points based on GPA hours from Darton.
- WHH_ESTS_CODE (2)
- Enrollment status code.
- See BANNER form STVESTS for valid codes.
- See BANNER form STVESTS for valid codes.
- Enrollment status code.
- WHH_PREFERRED_NAME (15)
- Student's preferred first
name.
- Student's preferred first
name.
- WHH_MARITAL_STATUS (2)
- Marital status.
- M - Married
- S - Single
- See BANNER form STVMRTL for valid codes.
- See BANNER form STVMRTL for valid codes.
- Marital status.
- WHH_RESIDENCY_CODE (1)
- Residency code.
- See BANNER form STVRESD for valid codes.
- See BANNER form STVRESD for valid codes.
- Residency code.
- WHH_ACTIVITY_GREEK_CODE (8)
- Greek code of sorority/fraternity participation. (Not
available at this time.)
- See BANNER form STVACTC for valid codes.
- See BANNER form STVACTC for valid codes.
- Greek code of sorority/fraternity participation. (Not
available at this time.)
- WHH_APPLIED_FOR_GRAD (1)
- (Not available at this time.)
- (Not available at this time.)
- WHH_APPL_FOR_GRAD_TERM (6-yyyymm)
- (Not available at this time.)
- (Not available at this time.)
- WHH_US_CITIZEN (1)
- Citizen type code.
- C - Citizen
- A - Alien, non-resident
- R - Alien, resident
- See BANNER form STVCITZ for valid codes.
- See BANNER form STVCITZ for valid codes.
- Citizen type code.
- WHH_VISA_TYPE (2)
- Visa type code.
- See BANNER form STVVTYP for valid codes.
- See BANNER form STVVTYP for valid codes.
- Visa type code.
- WHH_VISA_DESC (30)
- Visa description.
- Visa description.
- WHH_REGISTER_FOR_CRSE (1)
- This field indicates whether or not Banner recognizes a
student as being registered for at least one course during the
current term.
- Y - Yes
- N - No
- This field indicates whether or not Banner recognizes a
student as being registered for at least one course during the
current term.
- WHH_CREDIT_HOURS (99.99)
- Total credit hours for which student is currently registered
and attending classes. This data item excludes withdrawn
hours.
- Total credit hours for which student is currently registered
and attending classes. This data item excludes withdrawn
hours.
- WHH_TOTAL_BILLING_HRS (4)
- Total billing hours for which student has registered this
term. This data item includes withdrawn hours.
- Total billing hours for which student has registered this
term. This data item includes withdrawn hours.
- WHH_ADVISOR_PIDM (8)
- Banner's internal identification number for a student's
primary advisor.
- Banner's internal identification number for a student's
primary advisor.
- WHH_ADVISOR_NAME_LFM (35)
- Student's advisor's name (in first, middle, last name
order).
- Student's advisor's name (in first, middle, last name
order).
- WHH_ADVISOR_SS_NUMBER (9)
- Social security number of student's advisor.
- Social security number of student's advisor.
- WHH_ADVISOR_COLLEGE (2)
- College code of advisor.
- See BANNER form STVCOLL for valid codes.
- See BANNER form STVCOLL for valid codes.
- College code of advisor.
- WHH_ADVISOR_DEPARTMENT (4)
- Department code of student's advisor.
- See BANNER form STVDEPT for valid codes.
- See BANNER form STVDEPT for valid codes.
- Department code of student's advisor.
- WHH_DEGREE_COUNT (2)
- Number of degrees awarded from Darton.
- Number of degrees awarded from Darton.
- WHH_LAST_GRADUATION_TERM (6-yyyymm)
- Graduation term of last degree awarded.
- Graduation term of last degree awarded.
- WHH_LAST_DEGREE_CODE (6-yyyymm)
- Degree code of last degree awarded.
- See BANNER form STVDEGC for valid codes.
- See BANNER form STVDEGC for valid codes.
- Degree code of last degree awarded.
- WHH_LAST_DEGREE_COLLEGE (2)
- College code of last degree awarded.
- See BANNER form STVCOLL for valid codes.
- See BANNER form STVCOLL for valid codes.
- College code of last degree awarded.
- WHH_LAST_DEGREE_DEPT (4)
- Department code of last degree awarded.
- See BANNER form STVDEPT for valid codes.
- See BANNER form STVDEPT for valid codes.
- Department code of last degree awarded.
- WHH_LAST_DEGREE_MAJOR_CODE (4)
- Major code of last degree awarded.
- See BANNER form STVMAJR for valid codes.
- See BANNER form STVMAJR for valid codes.
- Major code of last degree awarded.
- WHH_LAST_DEGREE_MAJOR_DESC (24)
- Major description of last degree awarded.
- Major description of last degree awarded.
- WHH_PREV_GRADUATION_TERM (6-yyyymm)
- Graduation term of previous degree awarded.
- Graduation term of previous degree awarded.
- WHH_PREV_DEGREE_CODE (6-yyyymm)
- Degree code of previous degree awarded.
- See BANNER form STVDEGC for valid codes.
- See BANNER form STVDEGC for valid codes.
- Degree code of previous degree awarded.
- WHH_PREV_DEGREE_COLLEGE (2)
- College code of previous degree awarded.
- See BANNER form STVCOLL for valid codes.
- See BANNER form STVCOLL for valid codes.
- College code of previous degree awarded.
- WHH_PREV_DEGREE_DEPT (4)
- Department code of previous degree awarded.
- See BANNER form STVDEPT for valid codes.
- See BANNER form STVDEPT for valid codes.
- Department code of previous degree awarded.
- WHH_PREV_DEGREE_MAJOR_CODE (4)
- Major code of previous degree awarded.
- See BANNER form STVMAJR for valid codes.
- See BANNER form STVMAJR for valid codes.
- Major code of previous degree awarded.
- WHH_PREV_DEGREE_MAJOR_DESC (24)
- Major description of previous degree awarded.
- Major description of previous degree awarded.
[NOTE: The following 51 fields contain the academic non-course requirements status codes and satisfied indicators, (and test dates, scores, and counts where applicable) for the following types of non-course requirements:]
[NOTE: See the first set of status codes and satisfied indicators for code and indicator descriptions.]
- CPCE CPC - English
- CPCF CPC - Foreign Language
- CPCM CPC - Math
- CPCN CPC - Natural Science
- CPCS CPC - Social Science
- CPCT CPC Total (New Admis. Policy)
- CPEE CPE - English Requirement
- CPEM CPE - Math Requirement
- CPER CPE - Reading Requirement
- LCNG Leg. - Constitution - Ga.
- LCNU Leg. - Constitution - U.S.
- LHSG Leg. - History - Ga.
- LHSU Leg. - History - U.S.
- LSUE Learning Support - English
- LSUM Learning Support - Math
- LSUR Learning Support - Reading
- RTPR Regents' Reading Requirement
- RTPW Regents' Writing Requirement
- See BANNER form STVNCRQ for valid codes.
- WHH_CPCE_NCST (2)
- The non-course status code for CPCE (CPC - English).
- See BANNER form STVNCST for valid codes.
- See BANNER form STVNCST for valid codes.
- The non-course status code for CPCE (CPC - English).
- WHH_CPCE_SAT_IND (1)
- The non-course satisfied indicator for CPCE (CPC - English).
- Y - Satisfied
- N - Not satisfied
- The non-course satisfied indicator for CPCE (CPC - English).
- WHH_CPCF_NCST (2)
- The non-course status code for CPCF (CPC - Foreign
Language).
- The non-course status code for CPCF (CPC - Foreign
Language).
- WHH_CPCF_SAT_IND (1)
- The non-course satisfied indicator for CPCF (CPC - Foreign
Language).
- The non-course satisfied indicator for CPCF (CPC - Foreign
Language).
- WHH_CPCM_NCST (2)
- The non-course status code for CPCM (CPC - Math).
- The non-course status code for CPCM (CPC - Math).
- WHH_CPCM_SAT_IND (1)
- The non-course satisfied indicator for CPCM (CPC - Math).
- The non-course satisfied indicator for CPCM (CPC - Math).
- WHH_CPCN_NCST (2)
- The non-course status code for CPCN (CPC -Natural Science).
- The non-course status code for CPCN (CPC -Natural Science).
- WHH_CPCN_SAT_IND (1)
- The non-course satisfied indicator for CPCN (CPC -Natural
Science).
- The non-course satisfied indicator for CPCN (CPC -Natural
Science).
- WHH_CPCS_NCST (2)
- The non-course status code for CPCS (CPC - Social Science).
- The non-course status code for CPCS (CPC - Social Science).
- WHH_CPCS_SAT_IND (1)
- The non-course satisfied indicator for CPCS (CPC - Social
Science).
- The non-course satisfied indicator for CPCS (CPC - Social
Science).
- WHH_CPCT_NCST (2)
- The non-course status code for CPCT (CPC - Total (New Admis.
Policy)).
- The non-course status code for CPCT (CPC - Total (New Admis.
Policy)).
- WHH_CPCT_SAT_IND (1)
- The non-course satisfied indicator for CPCT (CPC - Total
(New Admis. Policy)).
- The non-course satisfied indicator for CPCT (CPC - Total
(New Admis. Policy)).
- WHH_CPEE_NCST (2)
- The non-course status code for CPEE (CPE - English
Requirement).
- The non-course status code for CPEE (CPE - English
Requirement).
- WHH_CPEE_SAT_IND (1)
- The non-course satisfied indicator for CPEE (CPE - English
Requirement).
- The non-course satisfied indicator for CPEE (CPE - English
Requirement).
- WHH_CPEE_COUNT (2)
- The count of the number of times the CPEE English test was
taken.
- The count of the number of times the CPEE English test was
taken.
- WHH_CPEE_TEST_CODE (4)
- The test code associated with the most recent test score.
- CPEE - College Placement Exam English
- COME - Compass Placement Exam English
- The test code associated with the most recent test score.
- WHH_CPEE_TEST_DATE (Date)
- Date of the most recent CPEE/COME English test.
- Date of the most recent CPEE/COME English test.
- WHH_CPEE_TEST_SCORE (5)
- Most recent CPEE/COME English test score.
- Most recent CPEE/COME English test score.
- WHH_CPEM_NCST (2)
- The non-course status code for CPEM (CPE - Math Requirement).
- The non-course status code for CPEM (CPE - Math Requirement).
- WHH_CPEM_SAT_IND (1)
- The non-course satisfied indicator for CPEM (CPE - Math
Requirement).
- The non-course satisfied indicator for CPEM (CPE - Math
Requirement).
- WHH_CPEM_COUNT (2)
- The count of the number of times the CPEM Math test was
taken.
- The count of the number of times the CPEM Math test was
taken.
- WHH_CPEM_TEST_CODE (4)
- The test code associated with the most recent test score.
- CPEM - College Placement Exam Math
- COMM - Compass Placement Exam Math
- The test code associated with the most recent test score.
- WHH_CPEM_TEST_DATE (Date)
- Date of the most recent CPEM/COMM Math test.
- Date of the most recent CPEM/COMM Math test.
- WHH_CPEM_TEST_SCORE (5)
- Most recent CPEM/COMM Math test score.
- Most recent CPEM/COMM Math test score.
- WHH_CPER_NCST (2)
- The non-course status code for CPER (CPE - Reading
Requirement).
- The non-course status code for CPER (CPE - Reading
Requirement).
- WHH_CPER_SAT_IND (1)
- The non-course satisfied indicator for CPER (CPE - Reading
Requirement).
- The non-course satisfied indicator for CPER (CPE - Reading
Requirement).
- WHH_CPER_COUNT (2)
- The count of the number of times the CPER Reading test was
taken.
- The count of the number of times the CPER Reading test was
taken.
-
WHH_CPER_TEST_CODE (4)
- The test code associated with the most recent test score.
- CPER - College Placement Exam Reading
- COMR - Compass Placement Exam Reading
- The test code associated with the most recent test score.
- WHH_CPER_TEST_DATE (Date)
- Date of the most recent CPER/COMR Reading test.
- Date of the most recent CPER/COMR Reading test.
- WHH_CPER_TEST_SCORE (5)
- Most recent CPER/COMR Reading test score.
- Most recent CPER/COMR Reading test score.
- WHH_GEDL_TEST_DATE (Date)
- The most recent date of the GEDL test.
- The most recent date of the GEDL test.
- WHH_GEDL_TEST_SCORE (5)
-
The most recent GEDL test score.
-
- WHH_GEDM_TEST_DATE (Date)
- The most recent date of the GEDM test.
- The most recent date of the GEDM test.
- WHH_GEDM_TEST_SCORE (5)
-
The most recent GEDM test score.
-
- WHH_GEDN_TEST_DATE (Date)
- The most recent date of the GEDN test.
- The most recent date of the GEDN test.
- WHH_GEDN_TEST_SCORE (5)
-
The most recent GEDN test score.
-
- WHH_GEDS_TEST_DATE (Date)
- The most recent date of the GEDS test.
- The most recent date of the GEDS test.
- WHH_GEDS_TEST_SCORE (5)
-
The most recent GEDS test score.
-
- WHH_GEDW_TEST_DATE (Date)
- The most recent date of the GEDW test.
- The most recent date of the GEDW test.
- WHH_GEDW_TEST_SCORE (5)
-
The most recent GEDW test score.
-
- WHH_GEDT_TEST_DATE (Date)
- The most recent date of the GEDT test.
- The most recent date of the GEDT test.
- WHH_GEDT_TEST_SCORE (5)
-
The most recent total standard GED test score.
-
- WHH_LCNG_NCST (2)
- The non-course status code for LCNG (Leg. - Constitution -
Ga.).
- The non-course status code for LCNG (Leg. - Constitution -
Ga.).
- WHH_LCNG_SAT_IND (1)
- The non-course satisfied indicator for LCNT (Leg. -
Constitution - Ga.).
- The non-course satisfied indicator for LCNT (Leg. -
Constitution - Ga.).
- WHH_LCNU_NCST (2)
- The non-course status code for LCNU (Leg. - Constitution -
U.S.).
- The non-course status code for LCNU (Leg. - Constitution -
U.S.).
- WHH_LCNU_SAT_IND (1)
- The non-course satisfied indicator for LCNU (Leg. -
Constitution - U.S.).
- The non-course satisfied indicator for LCNU (Leg. -
Constitution - U.S.).
- WHH_LHSG_NCST (2)
- The non-course status code for LHSG (Leg. - History - Ga.).
- The non-course status code for LHSG (Leg. - History - Ga.).
- WHH_LHSG_SAT_IND (1)
- The non-course
satisfied indicator for LHSG (Leg. - History - Ga.).
- The non-course
satisfied indicator for LHSG (Leg. - History - Ga.).
- WHH_LHSU_NCST (2)
- The non-course status code for LHSU Leg. - History - U.S.).
- The non-course status code for LHSU Leg. - History - U.S.).
- WHH_LHSU_SAT_IND (1)
- The non-course satisfied indicator for LHSU (Leg. - History
- U.S.).
- The non-course satisfied indicator for LHSU (Leg. - History
- U.S.).
- WHH_LSUE_NCST (2)
- The non-course status code for LSUE (Learning Support -
English).
- The non-course status code for LSUE (Learning Support -
English).
- WHH_LSUE_SAT_IND (1)
- The non-course satisfied indicator for LSUE (Learning
Support - English).
- The non-course satisfied indicator for LSUE (Learning
Support - English).
- WHH_LSUM_NCST (2)
- The non-course status code for LSUM (Learning Support -
Math).
- The non-course status code for LSUM (Learning Support -
Math).
- WHH_LSUM_SAT_IND (1)
- The non-course satisfied indicator for LSUM (Learning
Support - Math).
- The non-course satisfied indicator for LSUM (Learning
Support - Math).
- WHH_LSUR_NCST (2)
- The non-course status code for LSUR (Learning Support -
Reading).
- The non-course status code for LSUR (Learning Support -
Reading).
- WHH_LSUR_SAT_IND (1)
- The non-course satisfied indicator for LSUR (Learning
Support - Reading).
- The non-course satisfied indicator for LSUR (Learning
Support - Reading).
- WHH_RPTR_TEST_DATE (Date)
- Date of latest Regent's Reading test.
- Date of latest Regent's Reading test.
- WHH_RPTR_TEST_SCORE (5)
- Score of latest Regent's Reading test.
- Score of latest Regent's Reading test.
- WHH_RPTR_COUNT (2)
- The count of the number of times the Regents Reading test
was taken.
- The count of the number of times the Regents Reading test
was taken.
- WHH_RTPR_NCST (2)
- The non-course status code for RTPR (Regents' Reading
Requirement).
- The non-course status code for RTPR (Regents' Reading
Requirement).
- WHH_RTPR_SAT_IND (1)
- The non-course satisfied indicator for RTPR (Regents' Reading
Requirement).
- The non-course satisfied indicator for RTPR (Regents' Reading
Requirement).
- WHH_RTPW_TEST_DATE (Date)
- Date of latest Regent's Writing test.
- Date of latest Regent's Writing test.
- WHH_RTPW_TEST_SCORE (5)
- Score of latest Regent's Writing test.
- Score of latest Regent's Writing test.
- WHH_RTPW_COUNT (2)
- The count of the number of times the Regents Writing test was
taken.
- The count of the number of times the Regents Writing test was
taken.
- WHH_RTPW_NCST (2)
- The non-course status code for RTPW (Regents' Writing
Requirement).
- The non-course status code for RTPW (Regents' Writing
Requirement).
- WHH_RTPW_SAT_IND (1)
- The non-course satisfied indicator for RTPW (Regents' Writing
Requirement).
- The non-course satisfied indicator for RTPW (Regents' Writing
Requirement).
- WHH_A01_ACT_ENGLISH_DATE (Date)
- Date of the most recent ACT English test.
- Date of the most recent ACT English test.
- WHH_A01_ACT_ENGLISH_SCORE (5)
- Most recent ACT English score.
- Most recent ACT English score.
- WHH_A02_ACT_MATH_DATE (Date)
- Date of the most recent ACT Math test.
- Date of the most recent ACT Math test.
- WHH_A02_ACT_MATH_SCORE (5)
- Most recent ACT Math score.
- Most recent ACT Math score.
- WHH_A03_ACT_Reading_DATE (Date)
- Date of the most recent ACT Reading test
- Date of the most recent ACT Reading test
-
WHH_A03_ACT_Reading_SCORE (5)
- Most recent ACT Reading score.
- Most recent ACT Reading score.
- WHH_A04_ACT_SCIENCE_DATE (Date)
- Date of the most recent ACT Science test.
- Date of the most recent ACT Science test.
- WHH_A04_ACT_SCIENCE_SCORE (5)
- Most recent ACT Science score.
- Most recent ACT Science score.
- WHH_A05_ACT_COMPOSITE_DATE (Date)
- Date of the most recent ACT Composite test.
- Date of the most recent ACT Composite test.
- WHH_A05_ACT_ENGLISH_SCORE (5)
- Most recent ACT Composite score.
- Most recent ACT Composite score.
- WHH_S01_SAT_VERBAL_DATE (Date)
- Date of the most recent SAT Verbal test.
- Date of the most recent SAT Verbal test.
- WHH_S01_SAT_VERBAL_SCORE (5)
- Most recent SAT Verbal test score.
- Most recent SAT Verbal test score.
- WHH_S02_SAT_MATH_DATE (Date)
- Date of the most recent SAT Math test.
- Date of the most recent SAT Math test.
-
WHH_S02_SAT_MATH_SCORE (5)
- Most recent SAT Math test score.
- Most recent SAT Math test score.
- WHH_SATT_SAT_TOTAL_DATE (Date)
- Date of the most recent SAT Total score.
- Date of the most recent SAT Total score.
- WHH_SATT_SAT_TOTAL_SCORE (5)
- Most recent SAT Total test score.
- Most recent SAT Total test score.
- WHH_T01_TOEFL_DATE (Date)
- Date of the most recent TOEFL test score.
- Date of the most recent TOEFL test score.
- WHH_T01_TOEFL_SCORE (5)
- Most recent TOEFL test score.
- Most recent TOEFL test score.
- WHD_LINK (8)
- A data item used to link appropriate data warehouse tables.
- A data item used to link appropriate data warehouse tables.
- WHD_SYSDATE (Date)
- The system date and time the course data in this table was
created.
- The system date and time the course data in this table was
created.
- WHD_SS_NUMBER (9)
- Social security number.
- Social security number.
- WHD_LEVEL_CODE (2)
- Level code of the course.
- See BANNER form STVLEVL for valid codes.
- See BANNER form STVLEVL for valid codes.
- Level code of the course.
- WHD_TERM_CODE (6-YYYYMM)
- Registration term code in which the course was taken in the
format of YYYYMM.
- See BANNER form STVTERM for valid codes.
- See BANNER form STVTERM for valid codes.
- Registration term code in which the course was taken in the
format of YYYYMM.
- WHD_TCKN_SEQ_NO (2)
- Sequence number of the course registration during a term. (These
numbers begin with 1 for the first course registration. For
example, if a student were taking 4 courses during a term, the
courses would each have a different sequence number from 1 to 4.)
- Sequence number of the course registration during a term. (These
numbers begin with 1 for the first course registration. For
example, if a student were taking 4 courses during a term, the
courses would each have a different sequence number from 1 to 4.)
- WHD_CRN (5)
- Course reference number.
- Course reference number.
- WHD_SUBJ_CODE (4)
- Course subject code.
- See BANNER form STVSUBJ for valid codes.
- See BANNER form STVSUBJ for valid codes.
- Course subject code.
- WHD_CRSE_NUMB (5)
- Course number associated with the course subject.
- Course number associated with the course subject.
- WHD_SECTION (4)
- Course section number.
- Course section number.
- WHD_CRSE_TITLE (30)
- Course title.
- Course title.
- WHD_COLL_CODE (2)
- College code in which the course is taught.
- See BANNER form STVCOLL for valid codes.
- See BANNER form STVCOLL for valid codes.
- College code in which the course is taught.
- WHD_DEPT_CODE (4)
- Department code in which the course is taught.
- See BANNER form STVDEPT for valid codes.
- See BANNER form STVDEPT for valid codes.
- Department code in which the course is taught.
- WHD_SESS_CODE (1)
- Session code during which course was taken.
- See BANNER form STVSESS for valid codes.
- See BANNER form STVSESS for valid codes.
- Session code during which course was taken.
- WHD_REPEAT_IND (1)
- Repeat indicator for course.
- A - exclude - Indicates that this course was repeated in a later term and this course grade is excluded in GPA calculations.
- I - include - Indicates that this course is a repeat course and this course grade is included in GPA calculations.
- blank - not a repeated course.
- Repeat indicator for course.
- WHD_GRDE_CODE_FINAL (3)
- Last grade given for this course.
- See BANNER form SHAGRDE for valid codes.
- See BANNER form SHAGRDE for valid codes.
- Last grade given for this course.
- WHD_GMOD_CODE (1)
- Grade mode of course registration.
- See BANNER form STVGMOD for valid codes.
- See BANNER form STVGMOD for valid codes.
- Grade mode of course registration.
- WHD_CREDIT_HOURS (99.99)
- Course credit hours.
- Course credit hours.
- WHD_GCHG_CODE (2)
- Grade change reason code.
- See BANNER form STVGCHG for valid codes.
- See BANNER form STVGCHG for valid codes.
- Grade change reason code.
- WHD_GRDE_CHG_DATE (Date)
- Date that grade was entered.
- Date that grade was entered.
- WHD_GRDE_CHG_USER (10)
- User responsible for entering this grade.
- User responsible for entering this grade.
- WHD_GPA_TYPE_IND (1)
- Type of course (indicates whether grade is used in GPA
calculations).
- I - Institutional - (course taken at Darton College - grade used in GPA calculations)
- T - Transfer - (course transferred from another college -
grade not used in GPA calculations)
- Type of course (indicates whether grade is used in GPA
calculations).
- WHD_GMOD_CODE_DESC (30)
- Description of the grade mode of the course.
- (Not available at this time.)
- Description of the grade mode of the course.
