Each record describes a Major. All data was copied manually from Oracle to the Data Warehouse. New database (April 2010) will have a job to load this.
Updated: No
Oracle Field/Calc | DW Field | Description or Sample | ||
STVMAJR.STVMAJR_CODE | Major_Code | A unique numeric id for the Major | ||
STVMAJR.STVMAJR_DESC | Major_Desc | Description of the Major | ||
STVMAJR.STVMAJR_CIPC_CODE | CIPC_Code | 6-digit code. See STVCIPC Oracle table. | ||
STVMAJR.STVMAJR_SEVIS_EQUIV | SEVIS_Equiv | |||
STVMAJR.STVMAJR_TOPS_CODE | TOP_Code | Taxonomy of Program Code. 6-digit code. See STVTOPS table in Oracle. | ||
scbcrse.scbcrse_divs_code | DivisionId | Division Code: AG: Agriculture BUS: Business CFS: Consumer/Family Studies ARTF: Fine Arts IT: Industry and Technology LANG: Language Arts and Commun LIBR: Library MATH: Math and Engineering PE: Physical Education SCI: Science SOCS: Social Sciences STSV: Student Services SPLP: Special Programs NURS: Nursing WEXP: Work Experience | Division Code: AG: Agriculture BUS: Business CFS: Consumer/Family Studies ARTF: Fine Arts IT: Industry and Technology LANG: Language Arts and Commun LIBR: Library MATH: Math and Engineering PE: Physical Education SCI: Science SOCS: Social Sciences STSV: Student Services SPLP: Special Programs NURS: Nursing WEXP: Work Experience | |
STVDIVS_DESC | Division | Description of DivisionId code |
Add Comment