 |
|
 |
|
|
|
 |
|
|
|
 |
|
|
|
 |
|
|
|
 |
|
|
|
 |
|
The Data Dictionary assists both Banner and Hyperion Reports users with database field name translations. It is a reference table that assists users in translating the Banner (database) table and field names that appear in some Hyperion reports.
If you see a field name in a report that you are not familiar with, you can look in the Data Dictionary for assistance.
Search for the name in the "Report Field" column and click on the associated values.
| Report Field | Values | Description |
| Accept Amt | Accepted award amount | |
| Actc Code | Actc Codes | Activity Codes |
| Activity Date | Last date of activity in record | |
| Acyr Code | Academic Year Code | |
| Admt Code | Admt Codes | Student' s Admission Type |
| Aidy Code |
Financial Aid Year (last 2 digits of Acad Year) |
|
| Amt | Amount of the budget component | |
| App Mrcd Code | Mrcd Codes | Meal Plan Application Code |
| Approve Amt | Appoved amount for electronic loan application | |
| Approve Date | Approval date for electronic loan application | |
| Aprd Code | Aprd Codes | Aid period code: determines how aid will be scheduled and disbursed throughout the aid year. |
| Artp Desc | Artp Codes | Housing & Meal Application Type Code Description |
| Ascd Code | Ascd Codes | Room Assignment Status Code |
| Ascd Date | Ascd Codes | Room Assignment Date |
| Asg Mrcd Code | Mrcd Codes | Meal Plan Assignment Code |
| Astd Code DL | Astd Codes | Designates who is on the Dean's List |
| Astd Code End of Term | Astd Codes | Academic Standing Code at End of Term |
| Athl Aid Ind | Athletic Aid Indicator | |
| Atyp Code | Atyp Codes | Address Type |
| Aust Code | Aust Codes | Authorization status code for students FWS placement |
| Auth End Date | End date for student employment under the Federal Work Study program (FWS) | |
| Auth Start Date | Start date for student employment under the Federal Work Study program | |
| Awst Code | Awst Codes | Award status code |
| Begin Date | Room Assignment start date | |
| Begin Time | Time Class is Scheduled to Meet | |
| Bgrp Code | Bgrp Codes | Budget group code--determines student cost of attendance |
| Bill Hr | Credit Hours Student is Billed | |
| Bill Hrs | Credit Hours Student is Billed | |
| Birth Date | Date of Birth | |
| Blck Code | Blck Codes | Section Block Codes |
| Blck Desc | Blck Codes | Block Codes |
| Bldg Code | Bldg Codes | Resident Hall building code |
| C 1 Ctrb For Stdt | Student's part of the estimated family contribution | |
| C Depend Status | Student's dependency status as determined by the CPS | |
| C Par 1 Ctrb For Stdt | Parent's part of the estimated family contribution | |
| Cancel Amt | Canceled award amount | |
| Capacity | Building Capacity | |
| Check Amt | Loan check amount for disbursement--could be electronic funds or paper check | |
| Check Date | Date of arrival of loan funds for disbursement | |
| City | City Code | |
| Citz Code | "Y" or "N" | US Citizenship Indicator |
| Citz Ind | Self-reported expected citizenship status of student | |
| Clas Code | Student's Classification Codes | |
| Class Code | Banner Class | |
| Coll Code | Coll Codes | Student's Primary College Code |
| Coll Code 2 | Coll Codes | Student's Secondary College Code |
| Comp Code | Comp Codes | Budget group component code |
| Confid Ind | "Y" or "N" | Indicates Student's Desire to Have Their Information Remain Confidential |
| Connector | "A" or "O" | Denotes "And"/"Or" Prerequisite Courses |
| Course Comment | Additional Comments Related to Course | |
| Credit Hours | Credit Hours | |
| Credit Hr | Credit Hours | |
| Credit Hr High | The Most Credits that can be earned in a Variable Credit Course | |
| Credit Hr Low | The Least Credits that can be earned in a Variable Credit Course | |
| Credit Hrs | Credit Hours Student is Taking | |
| Crn | Course Reference Number | |
| Crse Numb | Course Number | |
| Crse Numb Preq | Prereq Course Number | |
| Crse Title | Course Title | |
| Date Printed | Report Generation Date | |
| Day Number | Number of Times A Class Meets Per Week | |
| Days Code | Days Codes | Days of the Week |
| Decline Amt | Declined award amount | |
| Degc Code | Degc Codes | Degree Code |
| Degc Dlev Code | Degc Codes | Degree Codes |
| Dept Code | Dept. Codes | Deptment Code |
| Desc | Form Description | |
| Detail Code | Billing Detail Code | |
| Driver Lic No | Self-reported student driver license number | |
| Eff Term | Specified Key Block Term | |
| El Status | Status of electronic loan application | |
| Elig Code | Elig Codes | Sport Eligibility Code |
| Email Address | Email Address | |
| Emal Code | "DOE" or "PPE" | Email Type |
| End Date | Room assignment end date | |
| End Time | Time Class is Scheduled to End | |
| Enrl | Enrollment Status | |
| Ests Code | Ests Codes | Student's Eligibility Status |
| Ests Date | Term of Student's Eligibility Status | |
| Ethn Code | Ethn Codes | Ethnicity Codes |
| Exp Enroll Status | Self-reported expected enrollment status of student | |
| Exp Enroll Status | Self-reported expected enrollment status of student | |
| Exp Grad Date | Expected Date of Graduation | |
| Expect Amt | Expected dollar amount of loan application | |
| Fed Coll Choice 1 | Student college choice 1 | |
| Fed Coll Choice 2 | Student college choice 2 | |
| Fed Coll Choice 3 | Student college choice 3 | |
| Fed Coll Choice 4 | Student college choice 4 | |
| Fed Coll Choice 5 | Student college choice 5 | |
| Fed Coll Choice 6 | Student college choice 6 | |
| Feed Ind | Indicates whether or not the loan disbursement has paid to a student's account | |
| Final Grde Seq No | Sequence Number Associated to Each Final Grade | |
| First Name | Student's First Name | |
| Fsrc Code | Fund Source | |
| Ftyp Code | Fund Type | |
| Full Part Ind | "Full" or "Part" | Student's Full/Part Time Indicator |
| Fund Code | Fund Codes | Award fund identifier code |
| Fund Title | Name of Fund | |
| Gmod Code | Gmod Codes | Grading Modes |
| Grad Date | Graduation Date | |
| Gradable Ind | "Y" or "N" | Indicates if Class will be Graded |
| Grde Code Final | Final Grade | |
| Grst Code | Grst Codes | Graduation Status |
| Haps Code | Housing Application Code | |
| Haps Desc | Haps Codes | Housing Application Code Descriptions |
| Hldd Code | Hldd Codes | Hold Code |
| Hold Reason | Reason For Hold | |
| Honr Code | Honr Codes | Graduation Honors |
| Jobt Code | Job title code for student employment under FWS--Job title controls rate of pay | |
| Last Name | Student's Last Name | |
| Levl Code | Levl Codes | Student's Program Identifier |
| Levl Gpa | Student's Level Grade Point Average | |
| Levl Hours Earned | Total Credit Hours Earned in one Level | |
| Majr Cipc Code | CIPC Codes | CIPC Codes |
| Majr Code | Majr Codes | Major Codes |
| Majr Code 1 | Majr Codes | Student's Primary Major Code |
| Majr Code 1 2 | Majr Codes | Student's Secondary Major Code |
| Majr Code 2 | Majr Codes | Student's Second Major in a Dual Degree |
| Majr Code Conc 1 | Student's First Concentration Code | |
| Majr Code Conc 1 2 | Student's Second Concentration Code | |
| Majr Code Conc 1 3 | Student's Third Concentration Code | |
| Majr Code Conc 2 | Student's Second Concentration Code | |
| Majr Code Minr 1 | Student's First Minor Code | |
| Majr Code Minr 1 2 | Student's Second Minor Code | |
| Majr Code Minr 2 | Student's Second Minor for Secondary Major in Dual Degree | |
| Max Enrl | Maximum Number of Students that can Enroll for a Class | |
| Memo Amt | Memoed amount of award | |
| Mrtl Code | Mrtl Codes | Marital Status Code |
| Name | Name to Appear on Student's Diploma | |
| Natn Code Legal | Natn Codes | Country of Citizenship |
| Natn Nation | Natn Codes | Country of Citizenship Description |
| Object | Associated Forms in Class | |
| Offer Amt | Offered amount of award | |
| Orig Comp Date | Date the student's FAFSA was originally completed at the CPS | |
| Orig Offer Amt | Original amount of award that was offered to student | |
| Orig Offer Date | Original date award was offered to student | |
| Oth Va Amt | Self-reported amount of Veteran's Benefits | |
| Oth Va Mth | Self-reported number of months the student expects to receive the veteran's benefits | |
| Paid Amt | Paid award amount | |
| Paid Amt | Paid award amount | |
| Par Us Inc | Self-reported parent's income | |
| Pay End Date | End date for student employment under the Federal Work Study program (FWS) | |
| Pay Rate | Rate of pay for student employment under FWS--tied to job title. | |
| Pay Start Date | Start date for student employment under the Federal Work Study program | |
| Percent Responses | Percentage of Instructor Course Responsibility | |
| Pgrp Code | Pgrp Codes | Packaging group code |
| Phone Area | Telephone Area Code | |
| Phone Ext | Telephone Extension | |
| Phone Number | Telephone Number | |
| Pidm | Banner generated identification number | |
| Place Cde | Placement code (numeric) for possible workplace for federal student employment | |
| Primary Ind | "Y" or "N" | Primary Instructor Indicator |
| Primary Userid | Drexel User Id | |
| Program | Courses Required to Complete a Major | |
| Program 1 | Courses Required to Complete a Major | |
| Rcpt Date | Date the FAFSA was received by the CPS | |
| Reject Code | Banner codes for various types of rejects such as Disbursement Errors | |
| Relg Code | Relg Codes | Religious Preference Code |
| Rgre Code | Rgre Codes | Registration Reason |
| Rjct Code | Rjct Codes | Description for Banner reject code |
| Role | Modify of Query Access | |
| Room Code | Room Class is Scheduled to Meet | |
| Room Number | Assignment Room number | |
| Rrcd Code | Rrcd Codes | Room Rate Code |
| Rsts Code | Rsts Codes | Student's Registration Status |
| Sat Day | Saturday Meet Day | |
| Schd Code | Schd Codes | Type of Class Scheduled |
| Seats Avail | Available Seats in a Class | |
| Seq No | Course Section Number | |
| Seq Numb | Course Section Number | |
| Sess Code | Sess Codes | Session of Courses |
| Sex | "M" or "F" | Gender |
| Site Code | Site Codes | Site Codes |
| Spst Code | Spst Codes | Sport Status |
| Ssn | Social Security Number | |
| Ssts Code | Ssts Codes | Section Status |
| Stat Code | Stat Codes | State Code |
| Stat Code Lic | Self-reported state of student's driver's license | |
| Stat Code Res | Self-reported state of legal residence | |
| Stat Date | Date status of tracking requirement was last updated | |
| Street Line1 | Street Address (line 1) | |
| Street Line2 | Street Address (line 2) | |
| Street Line3 | Street Address (line 3) | |
| Styp Code | Styp Codes | Student's Enrollment Status |
| Subj Code | Subj Codes | Subject Code |
| Tbbrtc Desc | Billing Detail Code Description | |
| Tele Code | Telephone Codes | |
| Term Code | Term Codes | Academic Year and Term |
| Term Code Admit | Term Codes | Academic Year and Term a Student is Admitted to the University |
| Term Code Completed | Term Codes | Mandatory Term to Complete Program By |
| Term Code Ctlg 1 | Term Codes | Academic Year and Term Program Began |
| Term Code Eff | Term Codes | Specified Key Block Term |
| Term Code Grad | Term Codes | Academic Year and Term a Student Graduates |
| Term Gpa | Student's Term Grade Point Average | |
| Term Hours Attempted | Credit Hours Attempted in a chosen term | |
| Term Hours Earned | Credit Hours Earned in a chosen term | |
| Text | Section Information | |
| Tfc | Total family contribution | |
| Tgrp Code | Tgrp Codes | Tracking group code |
| Course Title | Course Title | |
| Tmst Code | Tmst Codes | Time Status Code |
| Tmst Date | Time Status Date | |
| To Date | Date Address is Valid to | |
| To Term | Room Application End Date | |
| Tot Credit Hrs | Total Credit Hours in a Section | |
| Total Days | Total number of days spent in assigned resident hall | |
| Treq Code | Treq Codes | Tracking requirement code |
| Trst Code | Trst Codes | Tracking requirement status code |
| Unmet Need | Amount of unmet need | |
| Us Vet | Self-reported veteran status of student | |
| User | Initial Registration User Audit | |
| Userid | Banner User Id | |
| Vtyp Code Current | Vtyp Codes | Current Visa Code |
| Xlst Group | Cross List Indent | |
| Yr In Coll | Self-reported year in college of student | |
| Zip | Zip Code |
| Last Modified: <% Dim fs, f Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.GetFile(Request.ServerVariables("PATH_TRANSLATED")) DTM= FormatDateTime(f.DateLastModified, vbShortDate) response.write(DTM) %> | Home |  |
Contents | |
Index | |
Drexel Contacts | |
Search | |
Feedback/Corrections |
|