Aspen Tables and Fields with CVTE Data

Denise Miller Updated by Denise Miller

Tables

Below are the tables that store CVTE data.

Name

OID

DBName

ClassName

Prefix

Category

Course

tblCourse

COURSE

com.x2dev.sis.model.beans.Course

CRS

Schedule

Person

tblPerson

PERSON

com.x2dev.sis.model.beans.SisPerson

PSN

Core

Schedule Master

tblSchMaster

SCHEDULE_MASTER

com.x2dev.sis.model.beans.MasterSchedule

MST

Schedule

School Course

tblCrsSchool

COURSE_SCHOOL

com.x2dev.sis.model.beans.SchoolCourse

CSK

Schedule

Student

tblStudent

STUDENT

com.x2dev.sis.model.beans.SisStudent

STD

Student

Student Schedule

tblStdSchedule

STUDENT_SCHEDULE

com.x2dev.sis.model.beans.StudentSchedule

SSC

Schedule

Student Transcript

tblStdTrans

STUDENT_TRANSCRIPT

com.x2dev.sis.model.beans.Transcript

TRN

Grades

Fields

Below are the common fields, by table, that store CVTE data and that are used in state and federal reporting. (Name, Alias, OID, Database Feld Name, Field Type, Java field name, Java Field Type)

Course Table Fields

Name

Alias

OID

Name

Type

JavaName

JavaType

Academic level

SIF Instructional Level

crsAcademicLvl

CRS_ACADEMIC_LEVEL

V

academicLevel

java.lang.String

Credit

 

crsCredit

CRS_CREDIT

N

credit

java.math.BigDecimal

CTE Chapter 74

 

crsFieldC001

CRS_FIELDC_001

V

fieldC001

java.lang.String

CTE Non Chapter 74

 

crsFieldC002

CRS_FIELDC_002

V

fieldC002

java.lang.String

Department

 

crsDeptCode

CRS_DEPARTMENT_CODE

V

departmentCode

java.lang.String

Description

 

crsCourseDesc

CRS_COURSE_DESCRIPTION

V

description

java.lang.String

DESE Core (by SCS code)

 

crsFieldA028

CRS_FIELDA_028

V

fieldA028

java.lang.String

DESE Subject Area

 

crsFieldC006

CRS_FIELDC_006

V

fieldC006

java.lang.String

Epims/SCS Code

WA10-MTC

crsFieldA007

CRS_FIELDA_007

V

fieldA007

java.lang.String

Governance

 

crsFieldB006

CRS_FIELDB_006

V

fieldB006

java.lang.String

Grade level

WA09

crsGradeLevel

CRS_GRADE_LEVEL

V

gradeLevel

java.lang.String

Is CTE Program?

 

crsFieldA016

CRS_FIELDA_016

V

fieldA016

java.lang.String

Is PLTW?

 

crsFieldA025

CRS_FIELDA_025

V

fieldA025

java.lang.String

MassCore

 

crsFieldA014

CRS_FIELDA_014

V

fieldA014

java.lang.String

Number

 

crsCourseNum

CRS_COURSE_NUMBER

V

number

java.lang.String

Object identifier

 

crsOID

CRS_OID

C

oid

java.lang.String

Override school code

DOE SCHOOL CRS

crsFieldB010

CRS_FIELDB_010

V

fieldB010

java.lang.String

Pathway

 

crsFieldB014

CRS_FIELDB_014

V

fieldB014

java.lang.String

Pathways Course

SCS14

crsFieldA026

CRS_FIELDA_026

V

fieldA026

java.lang.String

Related year context object identifier

 

crsCtxOID

CRS_CTX_OID

C

districtContextOid

java.lang.String

School level

 

crsSchoolLevel

CRS_SCHOOL_LEVEL

V

schoolLevel

java.lang.String

SIF Credit Type

USE SCHOOL COURSE alias

crsFieldB011

CRS_FIELDB_011

V

fieldB011

java.lang.String

Person Table Fields

Name

Alias

OID

Name

Type

JavaName

JavaType

Date of birth

DOE 06

psnDob

PSN_DOB

D

dob

java.sql.Date

DESE adjusted first name

SIF PSN Adjusted First Name, PSN DOE Adjusted First

psnFieldC001

PSN_FIELDC_001

V

fieldC001

java.lang.String

DESE adjusted last name

SIF PSN Adjusted Last Name, PSN DOE Adjusted Last

psnFieldC003

PSN_FIELDC_003

V

fieldC003

java.lang.String

DESE adjusted middle name

SIF PSN Adjusted Middle Name, PSN DOE Adjusted Middle

psnFieldC002

PSN_FIELDC_002

V

fieldC002

java.lang.String

DOE Adjusted Postal Code

SIF PSN Adjusted Postal Code

psnFieldB004

PSN_FIELDB_004

V

fieldB004

java.lang.String

DOE EOE Access

DOE EOE Access

psnFieldA004

PSN_FIELDA_004

V

fieldA004

java.lang.String

First name

DOE 03

psnNameFirst

PSN_NAME_FIRST

V

firstName

java.lang.String

Gender

DOE 09

psnGenderCode

PSN_GENDER_CODE

V

genderCode

java.lang.String

Hispanic or Latino

 

psnHispLatInd

PSN_HISPANIC_LATINO_IND

L

hispanicLatinoIndicator

boolean

Last name

DOE 05

psnNameLast

PSN_NAME_LAST

V

lastName

java.lang.String

Middle name

DOE 04

psnNameMiddle

PSN_NAME_MIDDLE

V

middleName

java.lang.String

Object identifier

 

psnOID

PSN_OID

C

oid

java.lang.String

Race

 

psnRaceView

PSN_RACE_VIEW

V

raceView

java.lang.String

Schedule Master Table Fields

Name

Alias

OID

Name

Type

JavaName

JavaType

Course

 

mstCourseView

MST_COURSE_VIEW

V

courseView

java.lang.String

Highly Qualified Teacher Status

 

mstFieldB001

MST_FIELDB_001

V

fieldB001

java.lang.String

MST DOE Grade Level Override

MST DOE Grade Level Override

mstFieldA011

MST_FIELDA_011

V

fieldA011

java.lang.String

Object identifier

 

mstOID

MST_OID

C

oid

java.lang.String

Related classroom object identifier

 

mstRmsOID

MST_RMS_OID_PRIMARY

C

primaryRoomOid

java.lang.String

Related schedule object identifier

 

mstSchOID

MST_SCH_OID

C

scheduleOid

java.lang.String

Related schedule term object identifier

 

mstTrmOID

MST_TRM_OID

C

scheduleTermOid

java.lang.String

Related school course object identifier

 

mstCskOID

MST_CSK_OID

C

schoolCourseOid

java.lang.String

Related staff object identifier

 

mstStfOID

MST_STF_OID_PRIMARY

C

primaryStaffOid

java.lang.String

Schedule

 

mstSchdDisplay

MST_SCHEDULE_DISPLAY

V

scheduleDisplay

java.lang.String

Schedule term

 

mstTermView

MST_TERM_VIEW

V

termView

java.lang.String

SIF MST END DATE

SIF MST END DATE

mstFieldA008

MST_FIELDA_008

V

fieldA008

java.lang.String

SIF MST START DATE

SIF MST START DATE

mstFieldA007

MST_FIELDA_007

V

fieldA007

java.lang.String

School Course Table Fields

Most of the CVTE data in the School Course table is inherited from the Course table. The CTE fields on the School Course table are not being used. All CTE data comes from the Course table.

Name

Alias

OID

Name

Type

JavaName

JavaType

Academic level

 

cskAcademicLvl

CSK_ACADEMIC_LEVEL

V

academicLevel

java.lang.String

CTE

 

cskFieldA003

CSK_FIELDA_003

V

fieldA003

java.lang.String

CTE Chapter 74 Program

 

cskFieldB002

CSK_FIELDB_002

V

fieldB002

java.lang.String

CTE Non-Chapter 74 Program

 

cskFieldB003

CSK_FIELDB_003

V

fieldB003

java.lang.String

Department

 

cskDeptCode

CSK_DEPARTMENT_CODE

V

departmentCode

java.lang.String

Description

 

cskCourseDesc

CSK_COURSE_DESCRIPTION

V

description

java.lang.String

Grade level

 

cskGradeLevel

CSK_GRADE_LEVEL

V

gradeLevel

java.lang.String

Number

 

cskCourseNum

CSK_COURSE_NUMBER

V

number

java.lang.String

Object identifier

 

cskOID

CSK_OID

C

oid

java.lang.String

Related course object identifier

 

cskCrsOID

CSK_CRS_OID

C

courseOid

java.lang.String

Related school object identifier

 

cskSklOID

CSK_SKL_OID

C

schoolOid

java.lang.String

Related transcript definition object id

 

cskGtdOID

CSK_GTD_OID

C

transcriptDefinitionOid

java.lang.String

SIF Attending School

SIF Attending School

cskFieldA006

CSK_FIELDA_006

V

fieldA006

java.lang.String

SIF Credit Type School

SIF Credit Type

cskFieldB006

CSK_FIELDB_006

V

fieldB006

java.lang.String

Student Table Fields

Name

Alias

OID

Name

Type

JavaName

JavaType

CTE type of program

DOE 35

stdFieldB025

STD_FIELDB_025

V

fieldB025

java.lang.String

CTE special population

DOE 42

stdFieldB030

STD_FIELDB_030

V

fieldB030

java.lang.String

CTE chapter 74

DOE 43

stdFieldB031

STD_FIELDB_031

V

fieldB031

java.lang.String

CTE non-chapter 74

DOE 44

stdFieldB032

STD_FIELDB_032

V

fieldB032

java.lang.String

DOE045 - Career Pathway Program Type

DOE 45

stdFieldC032

STD_FIELDC_032

V

fieldC032

java.lang.String

DOE046 - Career Pathway Program Participation

DOE 46

stdFieldC033

STD_FIELDC_033

V

fieldC033

java.lang.String

DOE047 - Industry Recognized Credentials

DOE 47 IndustryRecognizedCredentials

stdFieldC036

STD_FIELDC_036

V

fieldC036

java.lang.String

DOE048 - Industry Recognized Credentials

DOE 48 IndustryRecognizedCredentials

stdFieldC037

STD_FIELDC_037

V

fieldC037

java.lang.String

DOE049 - Industry Recognized Credentials

DOE 49 IndustryRecognizedCredentials

stdFieldC038

STD_FIELDC_038

V

fieldC038

java.lang.String

Student Schedule Table Fields

Name

Alias

OID

Name

Type

JavaName

JavaType

Related schedule master object identifie

 

sscMstOID

SSC_MST_OID

C

sectionOid

java.lang.String

Related schedule object identifier

 

sscSchOID

SSC_SCH_OID

C

scheduleOid

java.lang.String

Related student object identifier

 

sscStdOID

SSC_STD_OID

C

studentOid

java.lang.String

Schedule term

 

sscTermView

SSC_TERM_VIEW

V

termView

java.lang.String

Section type

 

sscSectionType

SSC_SECTION_TYPE_CODE

V

sectionType

java.lang.String

SIF SSC END DATE

SIF SSC END DATE

sscFieldA004

SSC_FIELDA_004

V

fieldA004

java.lang.String

SIF SSC START DATE

SIF SSC START DATE

sscFieldA003

SSC_FIELDA_003

V

fieldA003

java.lang.String

Student Transcript Table Fields

Name

Alias

OID

Name

Type

JavaName

JavaType

Course Number

 

trnCskCrsNum

TRN_CSK_COURSE_NUMBER

V

courseNumber

java.lang.String

Credit

 

trnTotalCredit

TRN_TOTAL_CREDIT

N

totalCredit

java.math.BigDecimal

Final grade

 

trnFinalGrade

TRN_FINAL_GRADE

V

finalGrade

java.lang.String

Grade level

 

trnGradeLevel

TRN_GRADE_LEVEL

V

gradeLevel

java.lang.String

Object identifier

 

trnOID

TRN_OID

C

oid

java.lang.String

Related master object identifier

 

trnMstOID

TRN_MST_OID

C

masterScheduleOid

java.lang.String

Related school course object identifier

 

trnCskOID

TRN_CSK_OID

C

schoolCourseOid

java.lang.String

Related school object identifier

 

trnSklOID

TRN_SKL_OID

C

schoolOid

java.lang.String

Related staff object identifier

 

trnStfOID

TRN_STF_OID

C

teacherOid

java.lang.String

Related student object identifier

 

trnStdOID

TRN_STD_OID

C

studentOid

java.lang.String

Related transcript definition object id

 

trnGtdOID

TRN_GTD_OID

C

transcriptDefinitionOid

java.lang.String

School Year

 

trnCtxSklYear

TRN_CTX_SCHOOL_YEAR

N

schoolYear

int

How did we do?

How to see schools with CVTE courses

How to see School Course Sections of CVTE Courses

Contact