Forgot Password 



 Application Support
 MIS Data Submission


    

Office of Information Technology & Data Resources





Use this section to look up valid codes to use in Banner. If the code you are looking for does not exist, email the helpdesk to request a new code: datacenter@tcsg.edu.

 

CIP Codes 2010 for Credit Programs

  Banner table STVCIPC

Codes for Classification of Instructional Programs (CIP) are established by the National Center for Education Statistics (NCES). The 2010 codes are available on the NCES website. The 2010 CIP codes have been assigned to the TCSG semester programs: view the TCSG list of semester programs and 2010 CIP codes

 

CIP Codes 2010 for NON-Credit Programs

  Banner table STVCIPC

View Non-Credit CIP codes Adult Basic Education, Other Non-Credit, and Special Services codes.

 

City, State, and Zip

 

There is not a validation table in Banner; addresses are checked against a US Postal Service database when submitted to the TCSG system office. The county is also displayed in the search results.
Search for city, state, and zip codes

 

Colleges

Banner table STVSBGI
 

Search for a college code

 

View College Codes in Excel

 

Degree Types

Banner table STVDEGC

View degree type codes

 

Detail Codes

Banner table TBBDETC

View Standard Detail Codes

 

Faculty Majors

Banner table STVMAJR

Faculty major codes are all numeric, to distinguish from student major codes which are alpha-numeric. Both faculty and student major codes are stored in the same table.
View faculty major codes

 

Fund Codes

Banner table RFRBASE

Standard Financial Aid Fund Codes in Excel

 

High Schools

Banner table STVSBGI

Search for high school codes.

If there is not a High School Code on the search page, contact the helpdesk for a new code (datacenter@tcsg.edu) or use one of the following codes, if appropriate:

119995 Non Coded In State High School
119996 Out of Country
119997 Out of State
119998 High School Equivalency
969999 Home School
119999 Non-Existing

ISO Nation Codes

Nation Codes