Legacy_To_HUB_Approx - UB Academic Planning and Budget

Document Sample
Legacy_To_HUB_Approx - UB Academic Planning and Budget Powered By Docstoc
					SCHEMA      TABLE_NAME
AP_CREDIT   LOK_AP_EXAM
AP_CREDIT   LOK_PROCESSING_STATUS
AP_CREDIT   STUDENT_AP_CREDIT
LOK         ATHLETE_TYPE
LOK         SPORT
STU         ATHLETE
STU         ATHLETE_SPORT
STU         ATH_ACAD_YEAR
CRS         CLASSROOM
CRS         COURSE
CRS         COURSE_AUDIT
CRS         CRS_CONTROL

CRS         CRS_SECTION
CRS         EXAM
CRS         INSTRUCTOR
CRS         MEETING
CRS         SUM_CRS_CTL
S25         ROOM_PROFILE
S25         ROOM_PROFILE_ACTIVE
S25         ROOM_PROFILE_HIST
TTL         COURSE_TITLE
TTL         DEGREE_TITLE
DAR         NON_UB_CREDIT_TGT
DAR         ARTICULATION_MASTER
DAR         ARTICULATION_RULE
DAR         DEG_PROGRAM
DAR         MASTER_REF
DAR         MASTER_REF_GRADE
DAR         MASTREF_ADDRESS
DAR         NON_UB_CREDIT
DAR         PROGRAM_REQMNT
DAR         REQUIREMENTS
LOK         ADM_DEPT_ACC_ENT
LOK         ADM_DEPT_ACC_HIER
LOK         DARS_GENED_MAJ
LOK         XFER_DEC_GPA
STU         DARS_CATALOG
DAR         SUCCESS_PATH_ANALYSIS_SUM_V
DAR         SUCCESS_PATH_SUMMARY_HIST_V
DAR         TCA_MASTER
DAR         TCA_RULE
DAR         TCA_SOURCE
DAR         TCA_TARGET
DAR         ANALYSIS
DAR         ANALYSIS_COURSES
DAR         ANALYSIS_REQ
NUB         GRE_GENERAL_SCORE
NUB         GRE_OPT_SCR
NUB         GRE_SUBJECT_SCORE
NUB         TOEFL_APPLICANT_ACTIVE
NUB   TOEFL_APPLICATION
NUB   TOEFL_TEST_SCORE
LOK   IMMUNIZATION
PER   PERSON_IMMUNIZATION
PER   PERSON_IMZ
STU   LIB_SKILLS
LOK   FAIL_REASON
PAU   PERSON_AUDIT
PAU   SST_PERSON_AUDIT
PER   CAMPUS_ADRS
PER   EMERGENCY
PER   FORMER_NAME

PER   PERSON
PER   PERSON_ADRS
PER   PERSON_ADRS_FORMATTED
PER   PERSON_IMMUNIZATION
PER   PERSON_VISA
PER   VETERAN
STS   STUDENT_INFO
CRS   ACTIVE
CRS   CATALOG
CRS   HISTORY
ENT   UB_CONC_PGM
ISI   COHORT_OFFICIAL_ACTIVE
ISI   COHORT_OFFICIAL_HIST
ISI   COURSE_OFFICIAL_ACTIVE
ISI   COURSE_OFFICIAL_HIST
ISI   DEGREE_OFFICIAL
ISI   HIERARCHY_OFFICIAL
ISI   STUDENT_OFFICIAL_ACTIVE
ISI   STUDENT_OFFICIAL_HIST
LOK   ADVISOR
LOK   BUILDING
LOK   CAMPUS_PREF
LOK   CHKSTP_OVRD
LOK   COUNTRY
LOK   COUNTY
LOK   COURSE_TYPE
LOK   CREDIT_SOURCE
LOK   DEGREE
LOK   DEGREE_STATUS
LOK   DEPT_HONOR
LOK   DIVISION
LOK   ENROLMENT_STS
LOK   ETHNICITY
LOK   GENERAL_ED
LOK   INTNL_PROGRAM
LOK   LATIN_HONOR
LOK   NON_BILLABLE_CRS
LOK   QPA_CREDIT_INDR
LOK   SECTION_STS
LOK      STATE
LOK      STUDENT_LEVEL
LOK      SUPP_SCH_STATUS
LOK      TRANSCRIPT_STS
LOK      VISA
PER      ADDRESS_LOCAL
PER      ADDRESS_PARENT
PER      ADDRESS_PERMANENT
PER      NAME_FORMATTED
PS_RPT   CLASSSCHEDULE_V


STU      CLASSLIST

STU      CUMULATIVE_HOURS

STU      DEMOGRAPHICS
STU      REGISTRATION_ACTIVE
STU      REGISTRATION_HIST
STU      SCHEDULE
STU      SEMESTER
STU      SEMESTER_HOURS
TPT      CREDIT
TPT      DEGREE
LOK      CHKSTP_OVRD
STU      ACAD_SKILLS
STU      GRAD_REG_REQ
STU      LEAVE_OF_ABS
STU      REGISTRATION
STU      SKILLS_EXCPTN
STU      STUDENT
STU      STUDENT_HOURS
STU      STUDENT_SEM
STU      STU_MNRTY_PGM
ENT      UB_PROGRAM
LOK      DEGREE
LOK      DEGREE_STATUS
LOK      DEPT_HONOR
LOK      LATIN_HONOR
LOK      TPT_COMMENT

PER      PERSON
PER      PERSON_ADRS
STU      STUDENT_CTL
STU      STUDENT_SEM
TPT      DENT_REQUEST
TPT      PROF_REQUEST
TPT      TPT_COMMENT
TPT      TPT_RANKING
TPT      TPT_UB_CREDIT
TPT      UB_CREDIT_STU_SEM
TPT      UB_CREDIT_STU_SEM1
TPT   UB_DEGREE_MAJOR_MINOR
TTL   DEGREE_TITLE
ENT   UB_PROGRAM
LOK   DEGREE
LOK   DEGREE_STATUS
LOK   DEPT_HONOR
LOK   LATIN_HONOR
LOK   TPT_COMMENT

PER   PERSON
PER   PERSON_ADRS
STU   STUDENT_CTL
STU   STUDENT_SEM
TPT   LAW_REQUEST
TPT   PROF_REQUEST
TPT   TPT_COMMENT
TPT   TPT_UB_CREDIT
TPT   UB_CREDIT_STU_SEM
TPT   UB_CREDIT_STU_SEM1
TPT   UB_DEGREE_MAJOR_MINOR
TTL   DEGREE_TITLE
TPT   TPT_COMMENT
TPT   TPT_REQUEST
TPT   TPT_UB_CREDIT
TPT   UB_CREDIT_STU_SEM
TPT   UB_CREDIT_STU_SEM1
TPT   UB_DEGREE
EQUIVALENT PS / iSTRATEGY Table(s)
No current equivalent
No current equivalent
No current equivalent




                      Athletics Specific
No current equivalent
PS_RPT.COURSETRANSFORM_V
No current equivalent
No current equivalent
PS_RPT.CLASSSCHEDULE_V
PS_RPT.PS_CLASS_CAPACITY_V
PS_RPT.CLASSEXAMSCHEDULE_V
PS_RPT.CLASSSCHEDULE_V
PS_RPT.CLASSSCHEDULE_V
No current equivalent
No current equivalent
No current equivalent
No current equivalent
PS_RPT.COURSETRANSFORM_V
PS_RPT.LOK_ACAD_PLAN




                DARS Related Tables
PS_RPT.APPLICATIONS_V
PS_RPT.APPLICATIONS_V
PS_RPT.APPLICATIONS_V
PS_RPT.APPLICATIONS_V
PS_RPT.APPLICATIONS_V
PS_RPT.APPLICATIONS_V
No current equivalent
No current equivalent
No current equivalent
No current equivalent
No current equivalent
No current equivalent
No current equivalent
PS_RPT.VIEWHELPERADDRESSLOOKUP_V
PS_RPT.PS_EMERGENCY_CNTCT_V
No current equivalent
PS_RPT.PERSON_NAME
PS_RPT.BIODEMODATALOOKUP_V
PS_RPT.VIEWHELPERADDRESSLOOKUP_V
PS_RPT.VIEWHELPERADDRESSLOOKUP_V
No current equivalent
PS_RPT.BIODEMODATALOOKUP_V
No current equivalent
PS_RPT_STUDENTTERM_V / PS_RPT_STUDENTPLAN_V
PS_RPT_CLASSSCHEDULE_V
PS_RPT_CLASSSCHEDULE_V
PS_RPT_CLASSSCHEDULE_V
PS_RPT_LOK_ACAD_PLAN_V




                      ISI / SUNYIR Tables
No current equivalent
No current equivalent
No current equivalent
No current equivalent
No current equivalent
No current equivalent
No current equivalent
No current equivalent
PS_RPT.LOK_DEGREE_V
No current equivalent
No current equivalent
No current equivalent
No current equivalent
No current equivalent
No current equivalent
No current equivalent
No current equivalent
No current equivalent
No current equivalent
No current equivalent
No current equivalent
No current equivalent
No current equivalent
No current equivalent
No current equivalent
PS_RPT.VIEWHELPERADDRESSLOOKUP_V
PS_RPT.VIEWHELPERADDRESSLOOKUP_V
PS_RPT.VIEWHELPERADDRESSLOOKUP_V
PS_RPT.PERSON_NAME
PS_RPT.CLASSSCHEDULE_V

PS_RPT.CLASSSCHEDULE_V
PS_RPT.REGISTRATION_V
PS_RPT.STUDENTPLAN_V
PS_RPT.STUDENTTERM_V
PS_RPT.STUDENTPLAN_V
PS_RPT.STUDENTTERM_V
PS_RPT.REGISTRATION_V
PS_RPT.REGISTRATION_V
PS_RPT.REGISTRATION_V
PS_RPT.STUDENTTERM_V
PS_RPT.STUDENTTERM_V
PS_RPT.REGISTRATION_V
PS_RPT.DEGREEAWARDS_V
No current equivalent
No current equivalent
No current equivalent
No current equivalent
PS_RPT.REGISTRATION_V
No current equivalent
PS_RPT_STUDENTTERM_V / PS_RPT_STUDENTPLAN_V
PS_RPT_STUDENTTERM_V / PS_RPT_STUDENTPLAN_V
PS_RPT_STUDENTTERM_V / PS_RPT_STUDENTPLAN_V
PS_RPT_STUDENTTERM_V / PS_RPT_STUDENTPLAN_V
PS_RPT.LOK_PLAN_ENTITY_V
PS_RPT.LOK_DEGREE_V
No current equivalent
No current equivalent
No current equivalent
No current equivalent
PS_RPT.PERSON_NAME
PS_RPT.BIODEMODATALOOKUP_V
PS_RPT.VIEWHELPERADDRESSLOOKUP_V
No current equivalent
PS_RPT_STUDENTTERM_V / PS_RPT_STUDENTPLAN_V
No current equivalent
No current equivalent
No current equivalent
No current equivalent
PS_RPT.REGISTRATION_V
PS_RPT.REGISTRATION_V
PS_RPT.REGISTRATION_V
No current equivalent
No current equivalent
PS_RPT.LOK_PLAN_ENTITY_V
No current equivalent
No current equivalent
No current equivalent
No current equivalent
No current equivalent
PS_RPT.PERSON_NAME
PS_RPT.BIODEMODATALOOKUP_V
PS_RPT.VIEWHELPERADDRESSLOOKUP_V
No current equivalent
PS_RPT_STUDENTTERM_V / PS_RPT_STUDENTPLAN_V
No current equivalent
No current equivalent
No current equivalent
PS_RPT.REGISTRATION_V
PS_RPT.REGISTRATION_V
PS_RPT.REGISTRATION_V
No current equivalent
No current equivalent
No current equivalent
No current equivalent
PS_RPT.REGISTRATION_V
PS_RPT.REGISTRATION_V
PS_RPT.REGISTRATION_V
PS_RPT.DEGREEAWARDS_V
View                               Description
                                   General student gender, ethnicity, citizenship
PS_RPT.BIODEMODATALOOKUP_V         and address information.
PS_RPT.CLASSINSTRUCTION_V          Additional course section information
                                   Primary course section table (approximates
PS_RPT.CLASSSCHEDULE_V             legacy CRS.ACTIVE)

PS_RPT.COURSEATTRIBUTES_V          Permission of instructor and related course
PS_RPT.COURSETRANSFORM_V           Basic course information
                                   Primary award table (approximates legacy
PS_RPT.DEGREEAWARDS_V              TPT.UB_DEGREE)
PS_RPT.LATESTVISASTATUS_V
PS_RPT.LOK_ACAD_GROUP_V
PS_RPT.LOK_ACAD_ORG_V
PS_RPT.LOK_ACAD_PLAN_V
PS_RPT.LOK_ACAD_PROG_V
PS_RPT.LOK_ACAD_SUBJECT_V
PS_RPT.LOK_DEGREE_V
PS_RPT.LOK_ORG_LOCATION_V
PS_RPT.LOK_PLAN_ENTITY_V
PS_RPT.LOK_TERM_V
PS_RPT.PERSON_NAME
PS_RPT.PS_CLASS_NOTES_V            Additional class notes information
                                   Primary student course enrollment
PS_RPT.REGISTRATION_V              (approximates legacy STU.REGISTRATION)
PS_RPT.PS_SERVICEINDICATORS_V
PS_RPT.STUDENTGROUPS_V             Student group information
PS_RPT.STUDENTPLAN_V               Student plan information
                                   Primary enrollment table (approximates legacy
PS_RPT.STUDENTTERM_V               STU.SMESTER)
PS_RPT.VIEWHELPERADDRESSLOOKUP_V   Additional student address information
PS_RPT.PS_EMERGENCY_CNTCT_V
PS_RPT.LOK_PEOPLE_RELATION_V
PS_RPT.LOK_RELATIONSHIP_V
PS_COURSE_CATALOG_V
CLASSEXAMSCHEDULE_V
PS_CLASS_CAPACITY_V
PS_CLASS_NOTES_TBL_V
Module

Campus Community
Schedule of Classes

Schedule of Classes

Schedule of Classes
Schedule of Classes

Student Records
Campus Community
Academic Structure
Academic Structure
Academic Structure
Academic Structure
Academic Structure
Academic Structure

Academic Structure
Academic Structure
Campus Community
Schedule of Classes

Student Records
Campus Community
Student Records
Student Records

Student Records
Campus Community
VIEW_NAME         COLUMN_NAME             DESCRIPTION
CLASSSCHEDULE_V   ACADEMICGROUP
CLASSSCHEDULE_V   ACADEMICGROUPSOURCEKEY
CLASSSCHEDULE_V   ACADEMICORG
CLASSSCHEDULE_V   ACADEMICORGSOURCEKEY
CLASSSCHEDULE_V   ASSOCIATECLASS
CLASSSCHEDULE_V   BILLINGFACTOR
CLASSSCHEDULE_V   CAMPUS
CLASSSCHEDULE_V   CAMPUSSOURCEKEY
CLASSSCHEDULE_V   CATALOGNUMBERSOURCEKEY
CLASSSCHEDULE_V   CLASSENDTIME
CLASSSCHEDULE_V   CLASSMEETINGPATTERN
CLASSSCHEDULE_V   CLASSMEETINGPATTERNSOURCEKEY
CLASSSCHEDULE_V   CLASSNUMBER
CLASSSCHEDULE_V   CLASSNUMBERSECTION
CLASSSCHEDULE_V   CLASSSECTION
CLASSSCHEDULE_V   CLASSSECTIONSOURCEKEY
CLASSSCHEDULE_V   CLASSSTARTTIME
CLASSSCHEDULE_V   COMBINEDSECTION
CLASSSCHEDULE_V   COMBINEDSECTIONDESCR
CLASSSCHEDULE_V   COURSE
CLASSSCHEDULE_V   COURSECAREER
CLASSSCHEDULE_V   COURSECAREERSOURCEKEY
CLASSSCHEDULE_V   COURSEDESCRIPTION
CLASSSCHEDULE_V   COURSEID
CLASSSCHEDULE_V   COURSEOFFERNUMBER
CLASSSCHEDULE_V   COURSESOURCEKEY
CLASSSCHEDULE_V   COURSETYPE
CLASSSCHEDULE_V   COURSETYPESOURCEKEY
CLASSSCHEDULE_V   CRSTOPICDESCR
CLASSSCHEDULE_V   CRSTOPICID
CLASSSCHEDULE_V   ENDDATE
CLASSSCHEDULE_V   ENROLLMENTSECTSTATUS
CLASSSCHEDULE_V   ENROLLMENTSECTSTATUSSOURCEKEY
CLASSSCHEDULE_V   ENROLLTOTAL
CLASSSCHEDULE_V   EXAMSEATSPACING
CLASSSCHEDULE_V   FACULTY
CLASSSCHEDULE_V   FACULTYSOURCEKEY
CLASSSCHEDULE_V   FINALEXAM
CLASSSCHEDULE_V   INSTITUTION
CLASSSCHEDULE_V   INSTITUTIONSOURCEKEY
CLASSSCHEDULE_V   INSTRUCTORROLE
CLASSSCHEDULE_V   INSTRUCTORROLESOURCEKEY
CLASSSCHEDULE_V   LOCATION
CLASSSCHEDULE_V   LOCATIONSOURCEKEY
CLASSSCHEDULE_V   PRIMARYINSTRUCTORSECTION
CLASSSCHEDULE_V   REGISTRATIONCONSENT
CLASSSCHEDULE_V   REGISTRATIONCONSENTSOURCEKEY
CLASSSCHEDULE_V   ROOM
CLASSSCHEDULE_V   ROOMCAPACITY
CLASSSCHEDULE_V   ROOMCAPACITYREQUEST
CLASSSCHEDULE_V   ROOMSOURCEKEY
CLASSSCHEDULE_V   SCHEDULEPRINT
CLASSSCHEDULE_V   SECTIONCAPACITY
CLASSSCHEDULE_V   SECTIONCOUNT
CLASSSCHEDULE_V   SECTIONSTATUS
CLASSSCHEDULE_V   SECTIONSTATUSSOURCEKEY
CLASSSCHEDULE_V   SESSIONCODE
CLASSSCHEDULE_V   SESSIONORACLE
CLASSSCHEDULE_V   SESSIONSOURCEKEY
CLASSSCHEDULE_V   STARTDATE
CLASSSCHEDULE_V   SUBJECTDESCRIPTION
CLASSSCHEDULE_V   SUBJECTDESCRIPTIONSOURCEKEY
CLASSSCHEDULE_V   SUBJECTSOURCEKEY
CLASSSCHEDULE_V   TERM
CLASSSCHEDULE_V   TERMCODE
CLASSSCHEDULE_V   TERMSOURCEKEY
CLASSSCHEDULE_V   TIMEOFDAYBAND
CLASSSCHEDULE_V   UNITSMINIMUM
CLASSSCHEDULE_V   UNITSMXIMUM
CLASSSCHEDULE_V   VERSION
CLASSSCHEDULE_V   WAITLISTCAPACITY
CLASSSCHEDULE_V   WAITLISTTOTAL
LENGTH   DATA_TYPE   TRUSTEE LEGACY_EQUIVALENT
50       char        Student
5        char        Student
50       char        Student
10       char        Student
38       num         Student
5, 3     num         Student
50       char        Student
5        char        Student
10       char        Student COURSE_NUMBER + SECTION_ID
20       char        Student END_TIME
50       char        Student
5        char        Student DAYS_OFFERED
10       num         Student REG_NUMBER
4000     char        Student
4        char        Student
4        char        Student
20       char        Student BEGIN_TIME
1        char        Student
                     Student HOURS_MINIMUM
50       char        Student CRS_TITLE_NAME
50       char        Student
5        char        Student DIVISION
50       char        Student
6        char        Student
10       num         Student
6        char        Student
50       char        Student
5        char        Student COURSE_TYPE
30       char        Student
38       num         Student
7        date        Student END_DATE
50       char        Student
5        char        Student
10       num         Student ENROLLMENT
38       num         Student
50       char        Student INSTRUCTOR
11       char        Student INSTRUCTOR_PER_NUM
2        char        Student
50       char        Student
5        char        Student
50       char        Student
5        char        Student
50       char        Student
10       char        Student
4        char        Student
50       char        Student
5      char   Student
50     char   Student ROOM
10     num    Student
38     num    Student
10     char   Student
24     char   Student
10     num    Student
10     num    Student
50     char   Student
5      char   Student
3      char   Student
150    char   Student
5      char   Student
7      date   Student BEGIN_DATE
50     char   Student
8      char   Student
8      char   Student UB_ENT_ABBR
50     char   Student
4      char   Student
5      char   Student SEMESTER
50     char   Student
              Student HOURS_MAXIMUM
5, 2   num    Student
50     char   Student
10     num    Student
10     num    Student
+ SECTION_ID
VIEW_NAME            COLUMN_NAME                     DESCRIPTION LENGTH
CLASSINSTRUCTION_V   CLASSINSTRUCTIONKEY                         10
CLASSINSTRUCTION_V   ACADEMICGROUP                               50
CLASSINSTRUCTION_V   ACADEMICGROUPSOURCEKEY                      5
CLASSINSTRUCTION_V   ACADEMICORG                                 50
CLASSINSTRUCTION_V   ACADEMICORGSOURCEKEY                        10
CLASSINSTRUCTION_V   CAMPUS                                      50
CLASSINSTRUCTION_V   CAMPUSSOURCEKEY                             5
CLASSINSTRUCTION_V   CLASSMEETINGPATTERN                         50
CLASSINSTRUCTION_V   CLASSMEETINGPATTERNSOURCEKEY                5
CLASSINSTRUCTION_V   CLASSNUMBERSECTION                          4000
CLASSINSTRUCTION_V   CLASSNUMCLASSSECTIONSOURCEKEY               4
CLASSINSTRUCTION_V   CLASSNUMSUBJECTSOURCEKEY                    8
CLASSINSTRUCTION_V   CLASSNUMCATALOGNUMSOURCEKEY                 10
CLASSINSTRUCTION_V   COURSECAREER                                50
CLASSINSTRUCTION_V   COURSECAREERSOURCEKEY                       5
CLASSINSTRUCTION_V   COURSE                                      50
CLASSINSTRUCTION_V   COURSESOURCEKEY                             6
CLASSINSTRUCTION_V   COURSETYPE                                  50
CLASSINSTRUCTION_V   COURSETYPESOURCEKEY                         5
CLASSINSTRUCTION_V   ENROLLMENTSECTIONSTATUS                     50
CLASSINSTRUCTION_V   ENROLLMENTSECTSTATUSSOURCEKEY               5
CLASSINSTRUCTION_V   FACULTY                                     50
CLASSINSTRUCTION_V   FACULTYSOURCEKEY                            11
CLASSINSTRUCTION_V   INSTITUTION                                 50
CLASSINSTRUCTION_V   INSTITUTIONSOURCEKEY                        5
CLASSINSTRUCTION_V   INSTRUCTORROLE                              50
CLASSINSTRUCTION_V   INSTRUCTORROLESOURCEKEY                     5
CLASSINSTRUCTION_V   LOCATION                                    50
CLASSINSTRUCTION_V   LOCATIONSOURCEKEY                           10
CLASSINSTRUCTION_V   REGISTRATIONCONSENT                         50
CLASSINSTRUCTION_V   REGISTRATIONCONSENTSOURCEKEY                5
CLASSINSTRUCTION_V   ROOM                                        50
CLASSINSTRUCTION_V   ROOMSOURCEKEY                               10
CLASSINSTRUCTION_V   SECTIONSTATUS                               50
CLASSINSTRUCTION_V   SECTIONSTATUSSOURCEKEY                      5
CLASSINSTRUCTION_V   CLASSSESSION                                150
CLASSINSTRUCTION_V   SESSIONSOURCEKEY                            5
CLASSINSTRUCTION_V   SUBJECT                                     50
CLASSINSTRUCTION_V   SUBJECTSOURCEKEY                            8
CLASSINSTRUCTION_V   TERM                                        50
CLASSINSTRUCTION_V   TERMSOURCEKEY                               5
CLASSINSTRUCTION_V   TIMEOFDAYBAND                               50
CLASSINSTRUCTION_V   VERSION                                     50
CLASSINSTRUCTION_V   CLASSINSTRUCTIONCOUNT                       10
CLASSINSTRUCTION_V   CONTACTMINUTES                              10
CLASSINSTRUCTION_V   INSTRUCTORLOADFACTOR                        10, 4
CLASSINSTRUCTION_V   WEEKLYWORKLOADHOURS                         5, 2
CLASSINSTRUCTION_V   ASSIGNMENTPERCENTAGE                        5, 2
CLASSINSTRUCTION_V   COURSEID                                    6
CLASSINSTRUCTION_V   COURSEOFFERNUMBER                           10
CLASSINSTRUCTION_V   TERMCODE                                    4
CLASSINSTRUCTION_V   SESSIONCODE                3
CLASSINSTRUCTION_V   CLASSSECTION               4
CLASSINSTRUCTION_V   CLASSMEETINGNUMBER         10
CLASSINSTRUCTION_V   INSTRUCTORASSIGNSEQUENCE   10
CLASSINSTRUCTION_V   EMPLOYEERECORDNUMBER       10
CLASSINSTRUCTION_V   ASSIGNTYPE                 3
DATA_TYPE   TRUSTEE LEGACY_EQUIVALENT
num         Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
char        Student
num         Student
num         Student
num         Student
num         Student
num         Student
char        Student
num         Student
char        Student
char   Student
char   Student
num    Student
num    Student
num    Student
char   Student
VIEW_NAME            COLUMN_NAME                     DESCRIPTION
COURSEATTRIBUTES_V   COURSEATTRIBUTESKEY             NULL
COURSEATTRIBUTES_V   COURSE                          NULL
COURSEATTRIBUTES_V   DIMCOURSESOURCEKEY              NULL
COURSEATTRIBUTES_V   COURSEATTRIBUTE                 NULL
COURSEATTRIBUTES_V   DIMCOURSEATTRIBUTESOURCEKEY     NULL
COURSEATTRIBUTES_V   COURSEATTRIBUTEVALUE            NULL
COURSEATTRIBUTES_V   DIMCOURSEATTRIBVALUESOURCEKEY   NULL
COURSEATTRIBUTES_V   TERM                            NULL
COURSEATTRIBUTES_V   DIMTERMSOURCEKEY                NULL
COURSEATTRIBUTES_V   VERSION                         NULL
COURSEATTRIBUTES_V   COURSEATTRIBUTECOUNT            NULL
COURSEATTRIBUTES_V   COURSEID                        NULL
COURSEATTRIBUTES_V   TERMSOURCEKEY                   NULL
COURSEATTRIBUTES_V   COURSEATTRIBUTESOURCEKEY        NULL
COURSEATTRIBUTES_V   COURSEATTRIBUTEVALUESOURCEKEY   NULL
LENGTH           T
         DATA_TYPERUSTEE LEGACY_EQUIVALENT
10       num     Student
50       char    Student
6        char    Student
50       char    Student
4        char    Student
50       char    Student
10       char    Student
50       char    Student
5        char    Student
50       char    Student
10       num     Student
6        char    Student
4        char    Student
4        char    Student
10       char    Student
VIEW_NAME           COLUMN_NAME       DESCRIPTION
COURSETRANSFORM_V   ACADEMICGROUP
COURSETRANSFORM_V   ACADEMICGROUPDESCRIPTION
COURSETRANSFORM_V   ACADEMICORGANIZATION
COURSETRANSFORM_V   ACADEMICORGDESCRIPTION
COURSETRANSFORM_V   ACTIVE
COURSETRANSFORM_V   COURSETITLELONG
COURSETRANSFORM_V   DEFAULTGRADINGBASIS
COURSETRANSFORM_V   DEFAULTGRADINGBASISUNIQUEDESCR
COURSETRANSFORM_V   DESCRIPTION
COURSETRANSFORM_V   DESCRIPTIONLONG
COURSETRANSFORM_V   EFFECTIVEDATE
COURSETRANSFORM_V   EFFECTIVESTATUS
COURSETRANSFORM_V   GRADINGBASIS
COURSETRANSFORM_V   PRIMARYCATALOGNUMBER
COURSETRANSFORM_V   PRIMARYCOMPONENT
COURSETRANSFORM_V   PRIMARYCOMPONENTDESCRIPTION
COURSETRANSFORM_V   PRIMARYSUBJECT
COURSETRANSFORM_V   PRIMARYSUBJECTDESCRIPTION
COURSETRANSFORM_V   PRIMARYSUBJECTUNIQUEDESCR
COURSETRANSFORM_V   SOURCEKEY
COURSETRANSFORM_V   UNIQUEDESCRIPTION
COURSETRANSFORM_V   UNITSMAXIMUM
COURSETRANSFORM_V   UNITSMINIMUM
LENGTH   DATA_TYPE   TRUSTEE
5        char        Student
30       char        Student
10       char        Student
30       char        Student
10       num         Student
100      char        Student
3        char        Student
4000     char        Student
30       char        Student
4000     char        Student
7        date        Student
1        char        Student
3        char        Student
10       char        Student
3        char        Student
30       char        Student
8        char        Student
30       char        Student
4000     char        Student
6        char        Student
4000     char        Student
5, 2     num         Student
5, 2     num         Student
VIEW_NAME             COLUMN_NAME               DESCRIPTION
BIODEMODATALOOKUP_V   BIRTHCOUNTRY
BIODEMODATALOOKUP_V   BIRTHDATE
BIODEMODATALOOKUP_V   CITIZENSHIPCOUNTRY
BIODEMODATALOOKUP_V   CITIZENSHIPCOUNTRYDESCR
BIODEMODATALOOKUP_V   DT_OF_DEATH
BIODEMODATALOOKUP_V   EMAIL_ADDR
BIODEMODATALOOKUP_V   EMPLID
BIODEMODATALOOKUP_V   ETHNICITY
BIODEMODATALOOKUP_V   ETHNICITYDESCRIPTION
BIODEMODATALOOKUP_V   EXTENSION
BIODEMODATALOOKUP_V   E_ADDR_TYPE
BIODEMODATALOOKUP_V   FERPA
BIODEMODATALOOKUP_V   FIRST_NAME
BIODEMODATALOOKUP_V   GENDERDESCRIPTION
BIODEMODATALOOKUP_V   HIGHESTEDUCATIONLEVEL
BIODEMODATALOOKUP_V   HIGHESTEDUCATIONLVLDESCRIPTION
BIODEMODATALOOKUP_V   LAST_NAME
BIODEMODATALOOKUP_V   MAR_STATUS
BIODEMODATALOOKUP_V   MAR_STATUS_DESCR
BIODEMODATALOOKUP_V   MIDDLE_NAME
BIODEMODATALOOKUP_V   NAME
BIODEMODATALOOKUP_V   NAME_PREFIX
BIODEMODATALOOKUP_V   NAME_SUFFIX
BIODEMODATALOOKUP_V   PERSONALEMAILADDR
BIODEMODATALOOKUP_V   PHONE
BIODEMODATALOOKUP_V   PHONE_TYPE
BIODEMODATALOOKUP_V   PREF_FIRST_NAME
BIODEMODATALOOKUP_V   SEX
BIODEMODATALOOKUP_V   VISATYPE
LENGTH   DATA_TYPE   TRUSTEE            LEGACY_EQUIVALENT
3        char        Campus Community
7        date        Campus Community   DATE_OF_BIRTH
3        char        Campus Community   CITIZENSHIP
30       char        Campus Community
7        date        Campus Community
70       char        Campus Community   EMAIL_ADDRESS
11       char        Campus Community   PERSON_NUMBER
8        char        Campus Community
50       char        Campus Community   ETHNICITY
6        char        Campus Community
4        char        Campus Community
1        char        Campus Community
30       char        Campus Community
30       char        Campus Community   GENDER
2        char        Campus Community
30       char        Campus Community
30       char        Campus Community
1        char        Campus Community
30       char        Campus Community
30       char        Campus Community
50       char        Campus Community
4        char        Campus Community
15       char        Campus Community
70       char        Campus Community
24       char        Campus Community
4        char        Campus Community
30       char        Campus Community
1        char        Campus Community
3        char        Campus Community
GACY_EQUIVALENT

ATE_OF_BIRTH




MAIL_ADDRESS
 RSON_NUMBER
VIEW_NAME        COLUMN_NAME                    DESCRIPTION   LENGTH   DATA_TYPE
DEGREEAWARDS_V   ADMITTYPE                      NULL          50       char
DEGREEAWARDS_V   ADMITTYPESOURCEKEY             NULL          5        char
DEGREEAWARDS_V   AGEBAND                        NULL          50       char
DEGREEAWARDS_V   CAMPUS                         NULL          50       char
DEGREEAWARDS_V   CAMPUSSOURCEKEY                NULL          5        char
DEGREEAWARDS_V   CAREER                         NULL          50       char
DEGREEAWARDS_V   CAREERSOURCEKEY                NULL          5        char
DEGREEAWARDS_V   CITIZENSHIP                    NULL          50       char
DEGREEAWARDS_V   CITIZENSHIPSOURCEKEY           NULL          5        char
DEGREEAWARDS_V   COHORTTYPE                     NULL          25       char
DEGREEAWARDS_V   COHORTTYPESOURCEKEY            NULL          5        char
DEGREEAWARDS_V   CREDITHOURCUMULATIVEBAND       NULL          25       char
DEGREEAWARDS_V   CUMULATIVECREDITSATTEMPTED     NULL          8, 3     num
DEGREEAWARDS_V   CUMULATIVECREDITSAUDITED       NULL          8, 3     num
DEGREEAWARDS_V   CUMULATIVECREDITSEARNED        NULL          8, 3     num
DEGREEAWARDS_V   CUMULATIVECREDITSTOWARDGPA     NULL          8, 3     num
DEGREEAWARDS_V   CUMULATIVEGPA                  NULL          8, 3     num
DEGREEAWARDS_V   CUMULATIVEGRADEPOINTS          NULL          9, 3     num
DEGREEAWARDS_V   CUMULATIVETESTCREDITS          NULL          8, 3     num
DEGREEAWARDS_V   CUMULATIVETRANSFERCREDITS      NULL          8, 3     num
DEGREEAWARDS_V   DEGREE                         NULL          50       char
DEGREEAWARDS_V   DEGREEAWARDDATE                NULL          7        date
DEGREEAWARDS_V   DEGREECONFERDATE               NULL          7        date
DEGREEAWARDS_V   DEGREECOUNT                    NULL          10       num
DEGREEAWARDS_V   DEGREEGPA                      NULL          8, 3     num
DEGREEAWARDS_V   DEGREEHONORS                   NULL          50       char
DEGREEAWARDS_V   DEGREEHONORSSOURCEKEY          NULL          3        char
DEGREEAWARDS_V   DEGREESOURCEKEY                NULL          8        char
DEGREEAWARDS_V   DEGREESTATUS                   NULL          50       char
DEGREEAWARDS_V   DEGREESTATUSDATE               NULL          7        date
DEGREEAWARDS_V   DEGREESTATUSSOURCEKEY          NULL          5        char
DEGREEAWARDS_V   EMPLOYEEID                     NULL          11       char
DEGREEAWARDS_V   ETHNICITY                      NULL          50       char
DEGREEAWARDS_V   ETHNICITYSOURCEKEY             NULL          8        char
DEGREEAWARDS_V   EXPECTEDGRADTERMSOURCEKEY      NULL          5        char
DEGREEAWARDS_V   EXPECTEDGRADUATIONTERM         NULL          50       char
DEGREEAWARDS_V   GENDER                         NULL          50       char
DEGREEAWARDS_V   GENDERSOURCEKEY                NULL          5        char
DEGREEAWARDS_V   GPACUMULATIVEBAND              NULL          50       char
DEGREEAWARDS_V   HASCUMULATIVEGPA               NULL          10       num
DEGREEAWARDS_V   HASCUMULATIVETESTCREDITS       NULL          10       num
DEGREEAWARDS_V   HASCUMULATIVETRANSFERCREDITS   NULL          10       num
DEGREEAWARDS_V   HASDEGREEGPA                   NULL          10       num
DEGREEAWARDS_V   HIGHSCHOOL                     NULL          50       char
DEGREEAWARDS_V   HIGHSCHOOLSOURCEKEY            NULL          11       char
DEGREEAWARDS_V   INSTITUTION                    NULL          50       char
DEGREEAWARDS_V   INSTITUTIONSOURCEKEY            NULL   5      char
DEGREEAWARDS_V   IPEDSETHNICITY                  NULL   50     char
DEGREEAWARDS_V   IPEDSETHNICITYSOURCEKEY         NULL   8      char
DEGREEAWARDS_V   LASTCOLLEGEATTENDED             NULL   50     char
DEGREEAWARDS_V   LASTCOLLEGEATTENDEDSOURCEKEY    NULL   11     char
DEGREEAWARDS_V   MAJOR                           NULL   50     char
DEGREEAWARDS_V   MAJORSOURCEKEY                  NULL   10     char
DEGREEAWARDS_V   MAJORTRNSCRDESCR                       100    char
DEGREEAWARDS_V   MINOR                           NULL   50     char
DEGREEAWARDS_V   MINORSOURCEKEY                  NULL   10     char
DEGREEAWARDS_V   MINORTRNSCRDESCR                       100    char
DEGREEAWARDS_V   PLAN                            NULL   50     char
DEGREEAWARDS_V   PLANSOURCEKEY                   NULL   10     char
DEGREEAWARDS_V   PROGRAM                         NULL   50     char
DEGREEAWARDS_V   PROGRAMACTION                   NULL   4000   char
DEGREEAWARDS_V   PROGRAMACTIONSOURCEKEY          NULL   5      char
DEGREEAWARDS_V   PROGRAMREASON                   NULL   4000   char
DEGREEAWARDS_V   PROGRAMREASONSOURCEKEY          NULL   5      char
DEGREEAWARDS_V   PROGRAMSOURCEKEY                NULL   5      char
DEGREEAWARDS_V   PROGRAMSTATUS                   NULL   50     char
DEGREEAWARDS_V   PROGRAMSTATUSSOURCEKEY          NULL   5      char
DEGREEAWARDS_V   PSTOTALAUDITED                  NULL   8, 3   num
DEGREEAWARDS_V   PSTOTALCUMULATIVE               NULL   8, 3   num
DEGREEAWARDS_V   PSTOTALGRADEPOINTS              NULL   8, 3   num
DEGREEAWARDS_V   PSTOTALINPROGRESSNOTTOWARDGPA   NULL   8, 3   num
DEGREEAWARDS_V   PSTOTALINPROGRESSTOWARDGPA      NULL   8, 3   num
DEGREEAWARDS_V   PSTOTALOTHER                    NULL   8, 3   num
DEGREEAWARDS_V   PSTOTALPASSEDFORPROGRESS        NULL   8, 3   num
DEGREEAWARDS_V   PSTOTALPASSEDNOTTOWARDGPA       NULL   8, 3   num
DEGREEAWARDS_V   PSTOTALPASSEDTOWARDGPA          NULL   8, 3   num
DEGREEAWARDS_V   PSTOTALTAKENFORPROGRESS         NULL   8, 3   num
DEGREEAWARDS_V   PSTOTALTAKENNOTTOWARDGPA        NULL   8, 3   num
DEGREEAWARDS_V   PSTOTALTAKENTOWARDGPA           NULL   8, 3   num
DEGREEAWARDS_V   PSTOTALTESTCREDIT               NULL   8, 3   num
DEGREEAWARDS_V   PSTOTALTRANSFERRED              NULL   8, 3   num
DEGREEAWARDS_V   RESIDENCEZIPCODE                NULL   4000   char
DEGREEAWARDS_V   RESIDENCEZIPCODESOURCEKEY       NULL   12     char
DEGREEAWARDS_V   STARTTERMFORCAREER              NULL   50     char
DEGREEAWARDS_V   STARTTERMFORCAREERSOURCEKEY     NULL   5      char
DEGREEAWARDS_V   STARTTERMFORGROUP               NULL   50     char
DEGREEAWARDS_V   STARTTERMFORGROUPSOURCEKEY      NULL   5      char
DEGREEAWARDS_V   STARTTERMFORINSTITUTION         NULL   50     char
DEGREEAWARDS_V   STARTTERMFORINSTSOURCEKEY       NULL   5      char
DEGREEAWARDS_V   STARTTERMFORMAJOR               NULL   50     char
DEGREEAWARDS_V   STARTTERMFORMAJORSOURCEKEY      NULL   5      char
DEGREEAWARDS_V   STARTTERMFORMINOR               NULL   50     char
DEGREEAWARDS_V   STARTTERMFORMINORSOURCEKEY      NULL   5      char
DEGREEAWARDS_V   STARTTERMFORPROGRAM            NULL   50     char
DEGREEAWARDS_V   STARTTERMFORPROGRAMSOURCEKEY   NULL   5      char
DEGREEAWARDS_V   STUDENT                        NULL   50     char
DEGREEAWARDS_V   STUDENTDEGREE                  NULL   2      char
DEGREEAWARDS_V   STUDENTSOURCEKEY               NULL   11     char
DEGREEAWARDS_V   TERM                           NULL   50     char
DEGREEAWARDS_V   TERMSOURCEKEY                  NULL   5      char
DEGREEAWARDS_V   VERSION                        NULL   50     char
DEGREEAWARDS_V   VISATYPE                       NULL   50     char
DEGREEAWARDS_V   VISATYPESOURCEKEY              NULL   5      char
DEGREEAWARDS_V   YEARSTOGRADUATE                NULL   10     num
DEGREEAWARDS_V   YEARSTOGRADUATEBAND            NULL   50     char
DEGREEAWARDS_V   ZIPCODE                        NULL   4000   char
DEGREEAWARDS_V   ZIPCODESOURCEKEY               NULL   12     char
TRUSTEE   LEGACY_EQUIVALENT
Student
Student
Student
Student
Student
Student
Student   STU_DIVISION
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student   DEGREE_DATE
Student
Student
Student
Student
Student   LATIN_HONOR
Student
Student
Student
Student   DEGREE_STATUS
Student   PERSON_NUMBER
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student   DEGREE
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
VIEW_NAME        COLUMN_NAME                              LENGTH
                                                  DESCRIPTION      DATA_TYPE
REGISTRATION_V   ACADEMICCAREER                   NULL    4        char
REGISTRATION_V   ACADEMICGROUP                    NULL    50       char
REGISTRATION_V   ACADEMICGROUPSOURCEKEY           NULL    5        char
REGISTRATION_V   ACADEMICLEVEL                    NULL    50       char
REGISTRATION_V   ACADEMICLEVELSOURCEKEY           NULL    5        char
REGISTRATION_V   ACADEMICLOADFINAID               NULL    50       char
REGISTRATION_V   ACADEMICLOADFINAIDSOURCEKEY      NULL    5        char
REGISTRATION_V   ACADEMICLOADTUITION              NULL    50       char
REGISTRATION_V   ACADEMICLOADTUITIONSOURCEKEY     NULL    5        char
REGISTRATION_V   ACADEMICORG                      NULL    50       char
REGISTRATION_V   ACADEMICORGSOURCEKEY             NULL    10       char
REGISTRATION_V   ACADEMICSTANDING                 NULL    50       char
REGISTRATION_V   ACADEMICSTANDINGSOURCEKEY        NULL    5        char
REGISTRATION_V   ADMITTYPE                        NULL    50       char
REGISTRATION_V   ADMITTYPESOURCEKEY               NULL    5        char
REGISTRATION_V   ADVISINGACADEMICGROUP            NULL    50       char
REGISTRATION_V   ADVISINGACADEMICGROUPSOURCEKEY   NULL    5        char
REGISTRATION_V   ADVISOR                          NULL    50       char
REGISTRATION_V   ADVISORSOURCEKEY                 NULL    11       char
REGISTRATION_V   AGEBAND                          NULL    50       char
REGISTRATION_V   AUDITGRADEBASIS                  NULL    1        char
REGISTRATION_V   CAMPUS                           NULL    50       char
REGISTRATION_V   CAMPUSSOURCEKEY                  NULL    5        char
REGISTRATION_V   CAREER                           NULL    50       char
REGISTRATION_V   CAREERSOURCEKEY                  NULL    5        char
REGISTRATION_V   CITIZENSHIP                      NULL    50       char
REGISTRATION_V   CITIZENSHIPSOURCEKEY             NULL    5        char
REGISTRATION_V   CLASSENROLLSTATUS                NULL    50       char
REGISTRATION_V   CLASSENROLLSTATUSSOURCEKEY       NULL    5        char
REGISTRATION_V   CLASSGRADE                       NULL    17, 9    num
REGISTRATION_V   CLASSMEETINGPATTERN              NULL    50       char
REGISTRATION_V   CLASSMEETINGPATTERNSOURCEKEY     NULL    5        char
REGISTRATION_V   CLASSNUMBER                      NULL    10       num
REGISTRATION_V   CLASSNUMBERSECTION               NULL    4000     char
REGISTRATION_V   CLASSNUMBERSECTIONSOURCEKEY      NULL    4        char
REGISTRATION_V   COHORTTYPE                       NULL    25       char
REGISTRATION_V   COHORTTYPESOURCEKEY              NULL    5        char
REGISTRATION_V   COURSE                           NULL    50       char
REGISTRATION_V   COURSECAREER                     NULL    50       char
REGISTRATION_V   COURSECAREERSOURCEKEY            NULL    5        char
REGISTRATION_V   COURSEID                         NULL    6        char
REGISTRATION_V   COURSEOFFERNUMBER                NULL    10       num
REGISTRATION_V   COURSESOURCEKEY                  NULL    6        char
REGISTRATION_V   COURSETYPE                       NULL    50       char
REGISTRATION_V   COURSETYPESOURCEKEY              NULL    5        char
REGISTRATION_V   CREDITHOURCUMULATIVEBAND         NULL    25       char
REGISTRATION_V   CREDITHOURTERMBAND               NULL   50     char
REGISTRATION_V   CREDITSATTEMPTED                 NULL   5, 2   num
REGISTRATION_V   CREDITSEARNED                    NULL   5, 2   num
REGISTRATION_V   DEGREESEEKINDICATOR              NULL   25     char
REGISTRATION_V   DEGREESEEKINDICATORSOURCEKEY     NULL   5      char
REGISTRATION_V   DROPCOUNT                        NULL   10     num
REGISTRATION_V   EARNCREDIT                       NULL   1      char
REGISTRATION_V   EMPLOYEEID                       NULL   11     char
REGISTRATION_V   ENROLLEDCLASSCOUNT               NULL   10     num
REGISTRATION_V   ENROLLEDINDICATOR                NULL   25     char
REGISTRATION_V   ENROLLMENTSECTSTATUS             NULL   50     char
REGISTRATION_V   ENROLLMENTSECTSTATUSSOURCEKEY    NULL   5      char
REGISTRATION_V   ETHNICITY                        NULL   50     char
REGISTRATION_V   ETHNICITYSOURCEKEY               NULL   8      char
REGISTRATION_V   EXPECTEDGRADTERM                 NULL   50     char
REGISTRATION_V   EXPECTEDGRADTERMSOURCEKEY        NULL   5      char
REGISTRATION_V   FACULTY                          NULL   50     char
REGISTRATION_V   FACULTYSOURCEKEY                 NULL   11     char
REGISTRATION_V   FIRSTTERMATINSTINDICATOR         NULL   50     char
REGISTRATION_V   FIRSTTERMINCAREERINDICATOR       NULL   50     char
REGISTRATION_V   FIRSTTERMINGROUPINDICATOR        NULL   50     char
REGISTRATION_V   FIRSTTERMINMAJORINDICATOR        NULL   50     char
REGISTRATION_V   FIRSTTERMINMINORINDICATOR        NULL   50     char
REGISTRATION_V   FIRSTTERMINPROGRAMINDICATOR      NULL   50     char
REGISTRATION_V   GENDER                           NULL   50     char
REGISTRATION_V   GENDERSOURCEKEY                  NULL   5      char
REGISTRATION_V   GPACUMULATIVEBAND                NULL   50     char
REGISTRATION_V   GPATERMBAND                      NULL   50     char
REGISTRATION_V   GRADE                            NULL   50     char
REGISTRATION_V   GRADEDATE                        NULL   7      date
REGISTRATION_V   GRADESOURCEKEY                   NULL   3      char
REGISTRATION_V   GRADUATIONAPPLYSTATUS            NULL   50     char
REGISTRATION_V   GRADUATIONAPPLYSTATUSSOURCEKEY   NULL   5      char
REGISTRATION_V   HASCLASSGRADE                    NULL   10     num
REGISTRATION_V   INCLUDEINGPAINDICATOR            NULL   25     char
REGISTRATION_V   INSTITUTION                      NULL   50     char
REGISTRATION_V   INSTITUTIONSOURCEKEY             NULL   5      char
REGISTRATION_V   IPEDSETHNICITY                   NULL   50     char
REGISTRATION_V   IPEDSETHNICITYSOURCEKEY          NULL   8      char
REGISTRATION_V   LOCATION                         NULL   50     char
REGISTRATION_V   LOCATIONSOURCEKEY                NULL   10     char
REGISTRATION_V   MAJOR                            NULL   50     char
REGISTRATION_V   MAJORSOURCEKEY                   NULL   10     char
REGISTRATION_V   MINOR                            NULL   50     char
REGISTRATION_V   MINORSOURCEKEY                   NULL   10     char
REGISTRATION_V   PLAN                             NULL   50     char
REGISTRATION_V   PLANSOURCEKEY                    NULL   10     char
REGISTRATION_V   PROGRAM                        NULL   50     char
REGISTRATION_V   PROGRAMACTION                  NULL   4000   char
REGISTRATION_V   PROGRAMACTIONSOURCEKEY         NULL   5      char
REGISTRATION_V   PROGRAMREASON                  NULL   4000   char
REGISTRATION_V   PROGRAMREASONSOURCEKEY         NULL   5      char
REGISTRATION_V   PROGRAMSOURCEKEY               NULL   5      char
REGISTRATION_V   PROGRAMSTATUS                  NULL   50     char
REGISTRATION_V   PROGRAMSTATUSSOURCEKEY         NULL   5      char
REGISTRATION_V   PSGRADEPOINTS                  NULL   9, 3   num
REGISTRATION_V   PSUNITSEARNED                  NULL   5, 2   num
REGISTRATION_V   PSUNITSPROGRESS                NULL   5, 2   num
REGISTRATION_V   PSUNITSTAKEN                   NULL   5, 2   num
REGISTRATION_V   REGISTEREDCLASSCOUNT           NULL   10     num
REGISTRATION_V   REGISTRATIONADDDATE            NULL   7      date
REGISTRATION_V   REGISTRATIONADDDAY             NULL   25     char
REGISTRATION_V   REGISTRATIONCONSENT            NULL   50     char
REGISTRATION_V   REGISTRATIONCONSENTSOURCEKEY   NULL   5      char
REGISTRATION_V   REGISTRATIONDROPDATE           NULL   7      date
REGISTRATION_V   REGISTRATIONDROPDAY            NULL   25     char
REGISTRATION_V   REGISTRATIONSTATUSDATE         NULL   7      date
REGISTRATION_V   REPEATCODE                     NULL   50     char
REGISTRATION_V   REPEATCODESOURCEKEY            NULL   5      char
REGISTRATION_V   REPEATDATE                     NULL   7      date
REGISTRATION_V   RESIDENCEZIPCODE               NULL   4000   char
REGISTRATION_V   RESIDENCEZIPCODESOURCEKEY      NULL   12     char
REGISTRATION_V   RESIDENCYADMISSIONS            NULL   50     char
REGISTRATION_V   RESIDENCYADMISSIONSSOURCEKEY   NULL   5      char
REGISTRATION_V   RESIDENCYTUITION               NULL   50     char
REGISTRATION_V   RESIDENCYTUITIONSOURCEKEY      NULL   5      char
REGISTRATION_V   RETURNEDNEXTTERMINDICATOR      NULL   50     char
REGISTRATION_V   RETURNEDNEXTYEARINDICATOR      NULL   50     char
REGISTRATION_V   ROOM                           NULL   50     char
REGISTRATION_V   ROOMSOURCEKEY                  NULL   10     char
REGISTRATION_V   SECTIONSTATUS                  NULL   50     char
REGISTRATION_V   SECTIONSTATUSSOURCEKEY         NULL   5      char
REGISTRATION_V   SESSIONCODE                    NULL   3      char
REGISTRATION_V   SESSIONDESCRIPTION             NULL   150    char
REGISTRATION_V   SESSIONDESCRIPTIONSOURCEKEY    NULL   5      char
REGISTRATION_V   STARTTERMFORCAREER             NULL   50     char
REGISTRATION_V   STARTTERMFORCAREERSOURCEKEY    NULL   5      char
REGISTRATION_V   STARTTERMFORGROUP              NULL   50     char
REGISTRATION_V   STARTTERMFORGROUPSOURCEKEY     NULL   5      char
REGISTRATION_V   STARTTERMFORINST               NULL   50     char
REGISTRATION_V   STARTTERMFORINSTSOURCEKEY      NULL   5      char
REGISTRATION_V   STARTTERMFORMAJOR              NULL   50     char
REGISTRATION_V   STARTTERMFORMAJORSOURCEKEY     NULL   5      char
REGISTRATION_V   STARTTERMFORMINOR              NULL   50     char
REGISTRATION_V   STARTTERMFORMINORSOURCEKEY     NULL   5      char
REGISTRATION_V   STARTTERMFORPROGRAM            NULL   50     char
REGISTRATION_V   STARTTERMFORPROGRAMSOURCEKEY   NULL   5      char
REGISTRATION_V   STUDENT                        NULL   50     char
REGISTRATION_V   STUDENTSOURCEKEY               NULL   11     char
REGISTRATION_V   STUDENTTERMSTATUS              NULL   50     char
REGISTRATION_V   SUBJECT                        NULL   50     char
REGISTRATION_V   SUBJECTSOURCEKEY               NULL   8      char
REGISTRATION_V   TERM                           NULL   50     char
REGISTRATION_V   TERMSOURCE                     NULL   4      char
REGISTRATION_V   TERMSOURCEKEY                  NULL   5      char
REGISTRATION_V   TIMEOFDAYBAND                  NULL   50     char
REGISTRATION_V   TIMESCENARIO                   NULL   25     char
REGISTRATION_V   TUITIONGROUP                   NULL   50     char
REGISTRATION_V   TUITIONGROUPSOURCEKEY          NULL   10     char
REGISTRATION_V   UNITSATTEMPTED                 NULL   1      char
REGISTRATION_V   VERSION                        NULL   50     char
REGISTRATION_V   VISATYPE                       NULL   50     char
REGISTRATION_V   VISATYPESOURCEKEY              NULL   5      char
REGISTRATION_V   WITHDRAWCOUNT                  NULL   10     num
REGISTRATION_V   ZIPCODE                        NULL   4000   char
REGISTRATION_V   ZIPCODESOURCEKEY               NULL   12     char
TRUSTEE   LEGACY_EQUIVALENT
Student   STU_DIVISION
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student   GRADE_NUMERIC
Student
Student
Student   REG_NUMBER
Student   COURSE_NUMBER
Student   SECTION_ID
Student
Student
Student   CRS_TITLE_NAME
Student
Student   CREDIT_LEVEL
Student
Student
Student
Student
Student   COURSE_TYPE
Student
Student
Student   CREDIT_HOURS    Depending if past/current/future term
Student   CREDIT_HOURS    Depending if past/current/future term
Student
Student
Student
Student
Student   PERSON_NUMBER
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student   GRADE
Student
Student   GRADE
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student   CREDIT_HOURS   Depending if past/current/future term
Student
Student   CREDIT_HOURS   Depending if past/current/future term
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student   DEPARTMENT
Student   SEMESTER_FMT
Student   SEMESTER
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
VIEW_NAME             COLUMN_NAME                    DESCRIPTION   LENGTH
SERVICEINDICATORS_V   EMPLID                         NULL          11
SERVICEINDICATORS_V   TERMSOURCEKEY                  NULL          4
SERVICEINDICATORS_V   SERVICEINDICATORSOURCEKEY      NULL          5
SERVICEINDICATORS_V   SERVICEINDICATORREASONSRCKEY   NULL          5
SERVICEINDICATORS_V   TERM                           NULL          50
SERVICEINDICATORS_V   STUDENT                        NULL          50
SERVICEINDICATORS_V   SERVICEINDICATORDESCRIPTION    NULL          50
SERVICEINDICATORS_V   SERVICEINDICATORCOUNT          NULL          10
SERVICEINDICATORS_V   REASONDESCRIPTION              NULL          50
SERVICEINDICATORS_V   COMMENTS                       NULL          2000
SERVICEINDICATORS_V   POSITIVESERVICEINDICATOR       NULL          1
SERVICEINDICATORS_V   SERVICEINDICATORACTIVEDATE     NULL          11
SERVICEINDICATORS_V   SERVICEINDICATORLOGDATE        NULL          11
DATA_TYPE   TRUSTEE            LEGACY_EQUIVALENT
char        Campus Community
char        Campus Community
char        Campus Community
char        Campus Community
char        Campus Community
char        Campus Community
char        Campus Community
num         Campus Community
char        Campus Community
char        Campus Community
char        Campus Community
char        Campus Community
char        Campus Community
VIEW_NAME         COLUMN_NAME                   DESCRIPTION   LENGTH   DATA_TYPE
STUDENTGROUPS_V   EMPLOYEEID                    NULL          11       char
STUDENTGROUPS_V   STUDENTDESCRIPTION            NULL          50       char
STUDENTGROUPS_V   STUDENTDESCRIPTIONSOURCEKEY   NULL          11       char
STUDENTGROUPS_V   STUDENTGROUP                  NULL          50       char
STUDENTGROUPS_V   STUDENTGROUPCOUNT             NULL          10       num
STUDENTGROUPS_V   STUDENTGROUPSKEY              NULL          10       num
STUDENTGROUPS_V   STUDENTGROUPSOURCEKEY         NULL          5        char
STUDENTGROUPS_V   TERM                          NULL          50       char
STUDENTGROUPS_V   TERMSOURCEKEY                 NULL          4        char
STUDENTGROUPS_V   VERSION                       NULL          50       char
TRUSTEE LEGACY_EQUIVALENT
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
VIEW_NAME       COLUMN_NAME                    DESCRIPTION   LENGTH   DATA_TYPE
STUDENTPLAN_V   ACADEMICCAREER                 NULL          4        char
STUDENTPLAN_V   ACADEMICLEVEL                  NULL          50       char
STUDENTPLAN_V   ACADEMICLEVELSOURCEKEY         NULL          5        char
STUDENTPLAN_V   ACADEMICLOADFINAIDSOURCEKEY    NULL          5        char
STUDENTPLAN_V   ACADEMICLOADFINANCIALAID       NULL          50       char
STUDENTPLAN_V   ACADEMICLOADTUITION            NULL          50       char
STUDENTPLAN_V   ACADEMICLOADTUITIONSOURCEKEY   NULL          5        char
STUDENTPLAN_V   ACADEMICPLAN                   NULL          10       char
STUDENTPLAN_V   ACADEMICPROGRAMPRIMARY         NULL          5        char
STUDENTPLAN_V   ACADEMICSTANDING               NULL          50       char
STUDENTPLAN_V   ACADEMICSTANDINGSOURCEKEY      NULL          5        char
STUDENTPLAN_V   ACADEMICSUBPLAN                NULL          10       char
STUDENTPLAN_V   ACTCOMPOSITESCORE              NULL          10       num
STUDENTPLAN_V   ACTENGLISHSCORE                NULL          10       num
STUDENTPLAN_V   ACTMATHSCORE                   NULL          10       num
STUDENTPLAN_V   ACTREADINGSCORE                NULL          10       num
STUDENTPLAN_V   ACTSCIENCESCORE                NULL          10       num
STUDENTPLAN_V   ADMISSIONSAPPLICATIONNUMBER    NULL          8        char
STUDENTPLAN_V   ADMITTYPE                      NULL          50       char
STUDENTPLAN_V   ADMITTYPESOURCEKEY             NULL          5        char
STUDENTPLAN_V   ADVISINGACADEMICGROUP          NULL          50       char
STUDENTPLAN_V   ADVISINGACADGROUPSOURCEKEY     NULL          5        char
STUDENTPLAN_V   ADVISOR                        NULL          50       char
STUDENTPLAN_V   ADVISORSOURCEKEY               NULL          11       char
STUDENTPLAN_V   AGEBAND                        NULL          50       char
STUDENTPLAN_V   APPLICATIONPROGRAMNUMBER       NULL          10       num
STUDENTPLAN_V   AUDITONLYCOUNT                 NULL          10       num
STUDENTPLAN_V   AUDITONLYINDICATOR             NULL          25       char
STUDENTPLAN_V   AUDITONLYINDICATORSOURCEKEY    NULL          5        char
STUDENTPLAN_V   CAMPUS                         NULL          50       char
STUDENTPLAN_V   CAMPUSSOURCEKEY                NULL          5        char
STUDENTPLAN_V   CAREER                         NULL          50       char
STUDENTPLAN_V   CAREERSOURCEKEY                NULL          5        char
STUDENTPLAN_V   CITIZENSHIP                    NULL          50       char
STUDENTPLAN_V   CITIZENSHIPSOURCEKEY           NULL          5        char
STUDENTPLAN_V   COHORTTYPE                     NULL          25       char
STUDENTPLAN_V   COHORTTYPESOURCEKEY            NULL          5        char
STUDENTPLAN_V   CREDITHOURCUMULATIVEBAND       NULL          25       char
STUDENTPLAN_V   CREDITHOURTERMBAND             NULL          50       char
STUDENTPLAN_V   CUMULATIVECREDITSATTEMPTED     NULL          8, 3     num
STUDENTPLAN_V   CUMULATIVECREDITSAUDITED       NULL          8, 3     num
STUDENTPLAN_V   CUMULATIVECREDITSEARNED        NULL          8, 3     num
STUDENTPLAN_V   CUMULATIVECREDITSTOWARDGPA     NULL          8, 3     num
STUDENTPLAN_V   CUMULATIVEGPA                  NULL          8, 3     num
STUDENTPLAN_V   CUMULATIVEGRADEPOINTS          NULL          9, 3     num
STUDENTPLAN_V   CUMULATIVETESTCREDITS          NULL          8, 3     num
STUDENTPLAN_V   CUMULATIVETRANSFERCREDITS        NULL   8, 3   num
STUDENTPLAN_V   DATAFROMADMISSIONSAPPLICATION    NULL   1      char
STUDENTPLAN_V   DECLAREDATE                      NULL   7      date
STUDENTPLAN_V   DEGREESEEKINGINDICATOR           NULL   25     char
STUDENTPLAN_V   DEGREESEEKINGINDSOURCEKEY        NULL   5      char
STUDENTPLAN_V   ELIGIBLETOENROLL                 NULL   1      char
STUDENTPLAN_V   ELIGIBLETOENROLLINDICATOR        NULL   25     char
STUDENTPLAN_V   ELIGIBLETOENROLLINDSOURCEKEY     NULL   5      char
STUDENTPLAN_V   EMPLOYEEID                       NULL   11     char
STUDENTPLAN_V   ENROLLEDCOUNT                    NULL   10     num
STUDENTPLAN_V   ENROLLEDINDICATOR                NULL   25     char
STUDENTPLAN_V   ETHNICITY                        NULL   50     char
STUDENTPLAN_V   ETHNICITYSOURCEKEY               NULL   8      char
STUDENTPLAN_V   EXPECTEDGRADTERMSOURCEKEY        NULL   5      char
STUDENTPLAN_V   EXPECTEDGRADUATIONDATE           NULL   7      date
STUDENTPLAN_V   EXPECTEDGRADUATIONTERM           NULL   50     char
STUDENTPLAN_V   FIRSTTERMATINSTITUTIONCOUNT      NULL   10     num
STUDENTPLAN_V   FIRSTTERMATINSTITUTIONIND        NULL   50     char
STUDENTPLAN_V   FIRSTTERMINCAREERCOUNT           NULL   10     num
STUDENTPLAN_V   FIRSTTERMINCAREERINDICATOR       NULL   50     char
STUDENTPLAN_V   FIRSTTERMINGROUPCOUNT            NULL   10     num
STUDENTPLAN_V   FIRSTTERMINGROUPINDICATOR        NULL   50     char
STUDENTPLAN_V   FIRSTTERMINMAJORCOUNT            NULL   10     num
STUDENTPLAN_V   FIRSTTERMINMAJORINDICATOR        NULL   50     char
STUDENTPLAN_V   FIRSTTERMINMINORCOUNT            NULL   10     num
STUDENTPLAN_V   FIRSTTERMINMINORINDICATOR        NULL   50     char
STUDENTPLAN_V   FIRSTTERMINPROGRAMCOUNT          NULL   10     num
STUDENTPLAN_V   FIRSTTERMINPROGRAMINDICATOR      NULL   50     char
STUDENTPLAN_V   FORMOFSTUDY                      NULL   50     char
STUDENTPLAN_V   FORMOFSTUDYSOURCEKEY             NULL   5      char
STUDENTPLAN_V   FTECOUNT                         NULL   8, 3   num
STUDENTPLAN_V   FULLYENROLLEDDATE                NULL   7      date
STUDENTPLAN_V   FULLYGRADEDDATE                  NULL   7      date
STUDENTPLAN_V   GENDER                           NULL   50     char
STUDENTPLAN_V   GENDERSOURCEKEY                  NULL   5      char
STUDENTPLAN_V   GPACUMULATIVEBAND                NULL   50     char
STUDENTPLAN_V   GPATERMBAND                      NULL   50     char
STUDENTPLAN_V   GRADUATIONAPPLYSTATUS            NULL   50     char
STUDENTPLAN_V   GRADUATIONAPPLYSTATUSSOURCEKEY   NULL   5      char
STUDENTPLAN_V   HASACTCOMPOSITESCORE             NULL   10     num
STUDENTPLAN_V   HASACTENGLISHSCORE               NULL   10     num
STUDENTPLAN_V   HASACTMATHSCORE                  NULL   10     num
STUDENTPLAN_V   HASACTREADINGSCORE               NULL   10     num
STUDENTPLAN_V   HASACTSCIENCESCORE               NULL   10     num
STUDENTPLAN_V   HASCUMULATIVEGPA                 NULL   10     num
STUDENTPLAN_V   HASCUMULATIVETESTCREDITS         NULL   10     num
STUDENTPLAN_V   HASCUMULATIVETRANSFERCREDITS     NULL   10     num
STUDENTPLAN_V   HASSAT1600SCORE                 NULL   10     num
STUDENTPLAN_V   HASSAT2400SCORE                 NULL   10     num
STUDENTPLAN_V   HASSATMATHSCORE                 NULL   10     num
STUDENTPLAN_V   HASSATREADINGSCORE              NULL   10     num
STUDENTPLAN_V   HASSATVERBALSCORE               NULL   10     num
STUDENTPLAN_V   HASSATWRITINGSCORE              NULL   10     num
STUDENTPLAN_V   HASTERMGPA                      NULL   10     num
STUDENTPLAN_V   HASTERMTESTCREDITS              NULL   10     num
STUDENTPLAN_V   HASTERMTRANSFERCREDITS          NULL   10     num
STUDENTPLAN_V   HIGHSCHOOL                      NULL   50     char
STUDENTPLAN_V   HIGHSCHOOLSOURCEKEY             NULL   11     char
STUDENTPLAN_V   INSTITUTION                     NULL   50     char
STUDENTPLAN_V   INSTITUTIONSOURCEKEY            NULL   5      char
STUDENTPLAN_V   IPEDSETHNICITY                  NULL   50     char
STUDENTPLAN_V   IPEDSETHNICITYSOURCEKEY         NULL   8      char
STUDENTPLAN_V   LASTCOLLEGEATTENDED             NULL   50     char
STUDENTPLAN_V   LASTCOLLEGEATTENDEDSOURCEKEY    NULL   11     char
STUDENTPLAN_V   LASTDATEATTENDED                NULL   7      date
STUDENTPLAN_V   MAJOR                           NULL   50     char
STUDENTPLAN_V   MAJORSOURCEKEY                  NULL   10     char
STUDENTPLAN_V   MINOR                           NULL   50     char
STUDENTPLAN_V   MINORSOURCEKEY                  NULL   10     char
STUDENTPLAN_V   PLAN                            NULL   50     char
STUDENTPLAN_V   PLANSEQUENCE                    NULL   10     num
STUDENTPLAN_V   PLANSOURCEKEY                   NULL   10     char
STUDENTPLAN_V   PRIMARYACADEMICGROUP            NULL   50     char
STUDENTPLAN_V   PRIMARYACADEMICGROUPSOURCEKEY   NULL   5      char
STUDENTPLAN_V   PRIORGROUP                      NULL   50     char
STUDENTPLAN_V   PRIORGROUPSOURCEKEY             NULL   5      char
STUDENTPLAN_V   PRIORMAJOR                      NULL   50     char
STUDENTPLAN_V   PRIORMAJORSOURCEKEY             NULL   10     char
STUDENTPLAN_V   PRIORMINOR                      NULL   50     char
STUDENTPLAN_V   PRIORMINORSOURCEKEY             NULL   10     char
STUDENTPLAN_V   PRIORPROGRAM                    NULL   50     char
STUDENTPLAN_V   PRIORPROGRAMSOURCEKEY           NULL   5      char
STUDENTPLAN_V   PROGRAM                         NULL   50     char
STUDENTPLAN_V   PROGRAMACTION                   NULL   4000   char
STUDENTPLAN_V   PROGRAMACTIONSOURCEKEY          NULL   5      char
STUDENTPLAN_V   PROGRAMREASON                   NULL   4000   char
STUDENTPLAN_V   PROGRAMREASONSOURCEKEY          NULL   5      char
STUDENTPLAN_V   PROGRAMSOURCEKEY                NULL   5      char
STUDENTPLAN_V   PROGRAMSTATUS                   NULL   50     char
STUDENTPLAN_V   PROGRAMSTATUSSOURCEKEY          NULL   5      char
STUDENTPLAN_V   PSTERMGRADEPOINTS               NULL   9, 3   num
STUDENTPLAN_V   PSTOTALAUDITED                  NULL   8, 3   num
STUDENTPLAN_V   PSTOTALCUMULATIVE               NULL   8, 3   num
STUDENTPLAN_V   PSTOTALGRADEPOINTS              NULL   8, 3   num
STUDENTPLAN_V   PSTOTALINPROGRESSNOTTOWARDGPA   NULL   8, 3   num
STUDENTPLAN_V   PSTOTALINPROGRESSTOWARDGPA      NULL   8, 3   num
STUDENTPLAN_V   PSTOTALOTHER                    NULL   8, 3   num
STUDENTPLAN_V   PSTOTALPASSEDFORPROGRESS        NULL   8, 3   num
STUDENTPLAN_V   PSTOTALPASSEDNOTTOWARDGPA       NULL   8, 3   num
STUDENTPLAN_V   PSTOTALPASSEDTOWARDGPA          NULL   8, 3   num
STUDENTPLAN_V   PSTOTALTAKENFORPROGRESS         NULL   8, 3   num
STUDENTPLAN_V   PSTOTALTAKENNOTTOWARDGPA        NULL   8, 3   num
STUDENTPLAN_V   PSTOTALTAKENTOWARDGPA           NULL   8, 3   num
STUDENTPLAN_V   PSTOTALTESTCREDIT               NULL   8, 3   num
STUDENTPLAN_V   PSTOTALTRANSFERRED              NULL   8, 3   num
STUDENTPLAN_V   PSUNITSAUDITED                  NULL   8, 3   num
STUDENTPLAN_V   PSUNITSINPROGRESSNOTTOWARDGPA   NULL   8, 3   num
STUDENTPLAN_V   PSUNITSINPROGRESSTOWARDGPA      NULL   8, 3   num
STUDENTPLAN_V   PSUNITSOTHER                    NULL   8, 3   num
STUDENTPLAN_V   PSUNITSPASSEDFORPROGRESS        NULL   8, 3   num
STUDENTPLAN_V   PSUNITSPASSEDNOTTOWARDGPA       NULL   8, 3   num
STUDENTPLAN_V   PSUNITSPASSEDTOWARDGPA          NULL   8, 3   num
STUDENTPLAN_V   PSUNITSTAKENFORPROGRESS         NULL   8, 3   num
STUDENTPLAN_V   PSUNITSTAKENNOTTOWARDGPA        NULL   8, 3   num
STUDENTPLAN_V   PSUNITSTAKENTOWARDGPA           NULL   8, 3   num
STUDENTPLAN_V   PSUNITSTERMTOTAL                NULL   8, 3   num
STUDENTPLAN_V   PSUNITSTESTCREDIT               NULL   8, 3   num
STUDENTPLAN_V   PSUNITSTRANSFERRED              NULL   8, 3   num
STUDENTPLAN_V   RESIDENCEZIPCODE                NULL   4000   char
STUDENTPLAN_V   RESIDENCEZIPCODESOURCEKEY       NULL   12     char
STUDENTPLAN_V   RESIDENCYADMISSIONS             NULL   50     char
STUDENTPLAN_V   RESIDENCYADMISSIONSSOURCEKEY    NULL   5      char
STUDENTPLAN_V   RESIDENCYTUITION                NULL   50     char
STUDENTPLAN_V   RESIDENCYTUITIONSOURCEKEY       NULL   5      char
STUDENTPLAN_V   RETURNEDNEXTTERMINDICATOR       NULL   50     char
STUDENTPLAN_V   RETURNEDNEXTYEARINDICATOR       NULL   50     char
STUDENTPLAN_V   SAT1600SCORE                    NULL   10     num
STUDENTPLAN_V   SAT2400SCORE                    NULL   10     num
STUDENTPLAN_V   SATMATHSCORE                    NULL   10     num
STUDENTPLAN_V   SATREADINGSCORE                 NULL   10     num
STUDENTPLAN_V   SATVERBALSCORE                  NULL   10     num
STUDENTPLAN_V   SATWRITINGSCORE                 NULL   10     num
STUDENTPLAN_V   STARTTERM                       NULL   50     char
STUDENTPLAN_V   STARTTERMFORCAREER              NULL   50     char
STUDENTPLAN_V   STARTTERMFORCAREERSOURCEKEY     NULL   5      char
STUDENTPLAN_V   STARTTERMFORGROUP               NULL   50     char
STUDENTPLAN_V   STARTTERMFORGROUPSOURCEKEY      NULL   5      char
STUDENTPLAN_V   STARTTERMFORINSTITUTION         NULL   50     char
STUDENTPLAN_V   STARTTERMFORINSTSOURCEKEY       NULL   5      char
STUDENTPLAN_V   STARTTERMFORMAJOR               NULL   50     char
STUDENTPLAN_V   STARTTERMFORMAJORSOURCEKEY      NULL   5      char
STUDENTPLAN_V   STARTTERMFORMINOR              NULL   50     char
STUDENTPLAN_V   STARTTERMFORMINORSOURCEKEY     NULL   5      char
STUDENTPLAN_V   STARTTERMFORPROGRAM            NULL   50     char
STUDENTPLAN_V   STARTTERMFORPROGRAMSOURCEKEY   NULL   5      char
STUDENTPLAN_V   STARTTERMSOURCEKEY             NULL   5      char
STUDENTPLAN_V   STUDENT                        NULL   50     char
STUDENTPLAN_V   STUDENTCAREERNUMBER            NULL   10     num
STUDENTPLAN_V   STUDENTSOURCEKEY               NULL   11     char
STUDENTPLAN_V   STUDENTTERMCOUNT               NULL   10     num
STUDENTPLAN_V   STUDENTTERMSTATUS              NULL   50     char
STUDENTPLAN_V   TERM                           NULL   50     char
STUDENTPLAN_V   TERMCREDITSATTEMPTED           NULL   8, 3   num
STUDENTPLAN_V   TERMCREDITSAUDITED             NULL   8, 3   num
STUDENTPLAN_V   TERMCREDITSEARNED              NULL   8, 3   num
STUDENTPLAN_V   TERMCREDITSTOWARDGPA           NULL   8, 3   num
STUDENTPLAN_V   TERMGPA                        NULL   8, 3   num
STUDENTPLAN_V   TERMGRADEPOINTS                NULL   9, 3   num
STUDENTPLAN_V   TERMSOURCEKEY                  NULL   4      char
STUDENTPLAN_V   TERMTESTCREDITS                NULL   8, 3   num
STUDENTPLAN_V   TERMTRANSFERCREDITS            NULL   8, 3   num
STUDENTPLAN_V   TIMESCENARIO                   NULL   25     char
STUDENTPLAN_V   TIMESCENARIOSOURCEKEY          NULL   5      char
STUDENTPLAN_V   TUITIONGROUP                   NULL   50     char
STUDENTPLAN_V   TUITIONGROUPSOURCEKEY          NULL   10     char
STUDENTPLAN_V   VERSION                        NULL   50     char
STUDENTPLAN_V   VISATYPE                       NULL   50     char
STUDENTPLAN_V   VISATYPESOURCEKEY              NULL   5      char
STUDENTPLAN_V   WITHDRAWCOUNT                  NULL   10     num
STUDENTPLAN_V   WITHDRAWDATE                   NULL   7      date
STUDENTPLAN_V   WITHDRAWREASON                 NULL   4      char
STUDENTPLAN_V   ZIPCODE                        NULL   4000   char
STUDENTPLAN_V   ZIPCODESOURCEKEY               NULL   12     char
TRUSTEE LEGACY_EQUIVALENT
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
Student
VIEW_NAME       COLUMN_NAME                    DESCRIPTION   LENGTH   DATA_TYPE
STUDENTTERM_V   ACADEMICCAREER                 NULL          4        char
STUDENTTERM_V   ACADEMICLEVEL                  NULL          50       char
STUDENTTERM_V   ACADEMICLEVELSOURCEKEY         NULL          5        char
STUDENTTERM_V   ACADEMICLOADFINAIDSOURCEKEY    NULL          5        char
STUDENTTERM_V   ACADEMICLOADFINANCIALAID       NULL          50       char
STUDENTTERM_V   ACADEMICLOADTUITION            NULL          50       char
STUDENTTERM_V   ACADEMICLOADTUITIONSOURCEKEY   NULL          5        char
STUDENTTERM_V   ACADEMICPROGRAMPRIMARY         NULL          5        char
STUDENTTERM_V   ACADEMICSTANDING               NULL          50       char
STUDENTTERM_V   ACADEMICSTANDINGSOURCEKEY      NULL          5        char
STUDENTTERM_V   ACTCOMPOSITESCORE              NULL          10       num
STUDENTTERM_V   ACTENGLISHSCORE                NULL          10       num
STUDENTTERM_V   ACTMATHSCORE                   NULL          10       num
STUDENTTERM_V   ACTREADINGSCORE                NULL          10       num
STUDENTTERM_V   ACTSCIENCESCORE                NULL          10       num
STUDENTTERM_V   ADMISSIONSAPPLICATIONNUMBER    NULL          8        char
STUDENTTERM_V   ADMITTERM                                    4        char
STUDENTTERM_V   ADMITTYPE                      NULL          50       char
STUDENTTERM_V   ADMITTYPESOURCEKEY             NULL          5        char
STUDENTTERM_V   ADVISINGACADEMICGROUP          NULL          50       char
STUDENTTERM_V   ADVISINGACADGROUPSOURCEKEY     NULL          5        char
STUDENTTERM_V   ADVISOR                        NULL          50       char
STUDENTTERM_V   ADVISORSOURCEKEY               NULL          11       char
STUDENTTERM_V   AGEBAND                        NULL          50       char
STUDENTTERM_V   APPLICATIONPROGRAMNUMBER       NULL          10       num
STUDENTTERM_V   AUDITONLYCOUNT                 NULL          10       num
STUDENTTERM_V   AUDITONLYINDICATOR             NULL          25       char
STUDENTTERM_V   AUDITONLYINDICATORSOURCEKEY    NULL          5        char
STUDENTTERM_V   CAMPUS                         NULL          50       char
STUDENTTERM_V   CAMPUSSOURCEKEY                NULL          5        char
STUDENTTERM_V   CAREER                         NULL          50       char
STUDENTTERM_V   CAREERSOURCEKEY                NULL          5        char
STUDENTTERM_V   CITIZENSHIP                    NULL          50       char
STUDENTTERM_V   CITIZENSHIPSOURCEKEY           NULL          5        char
STUDENTTERM_V   COHORTTYPE                     NULL          25       char
STUDENTTERM_V   COHORTTYPESOURCEKEY            NULL          5        char
STUDENTTERM_V   CREDITHOURCUMULATIVEBAND       NULL          25       char
STUDENTTERM_V   CREDITHOURTERMBAND             NULL          50       char
STUDENTTERM_V   CUMULATIVECREDITSATTEMPTED     NULL          8, 3     num
STUDENTTERM_V   CUMULATIVECREDITSAUDITED       NULL          8, 3     num
STUDENTTERM_V   CUMULATIVECREDITSEARNED        NULL          8, 3     num
STUDENTTERM_V   CUMULATIVECREDITSTOWARDGPA     NULL          8, 3     num
STUDENTTERM_V   CUMULATIVEGPA                  NULL          8, 3     num
STUDENTTERM_V   CUMULATIVEGRADEPOINTS          NULL          9, 3     num
STUDENTTERM_V   CUMULATIVETESTCREDITS          NULL          8, 3     num
STUDENTTERM_V   CUMULATIVETRANSFERCREDITS      NULL          8, 3     num
STUDENTTERM_V   DATAFROMADMISSIONSAPPLICATION   NULL   1      char
STUDENTTERM_V   DEGREESEEKINGINDICATOR          NULL   25     char
STUDENTTERM_V   DEGREESEEKINGINDSOURCEKEY       NULL   5      char
STUDENTTERM_V   ELIGIBLETOENROLL                NULL   1      char
STUDENTTERM_V   ELIGIBLETOENROLLINDICATOR       NULL   25     char
STUDENTTERM_V   ELIGIBLETOENROLLINDSOURCEKEY    NULL   5      char
STUDENTTERM_V   EMPLOYEEID                      NULL   11     char
STUDENTTERM_V   ENROLLEDCOUNT                   NULL   10     num
STUDENTTERM_V   ENROLLEDINDICATOR               NULL   25     char
STUDENTTERM_V   ETHNICITY                       NULL   50     char
STUDENTTERM_V   ETHNICITYSOURCEKEY              NULL   8      char
STUDENTTERM_V   EXPECTEDGRADTERMSOURCEKEY       NULL   5      char
STUDENTTERM_V   EXPECTEDGRADUATIONTERM          NULL   50     char
STUDENTTERM_V   FIRSTTERMATINSTITUTIONCOUNT     NULL   10     num
STUDENTTERM_V   FIRSTTERMATINSTITUTIONIND       NULL   50     char
STUDENTTERM_V   FIRSTTERMINCAREERCOUNT          NULL   10     num
STUDENTTERM_V   FIRSTTERMINCAREERINDICATOR      NULL   50     char
STUDENTTERM_V   FIRSTTERMINGROUPCOUNT           NULL   10     num
STUDENTTERM_V   FIRSTTERMINGROUPINDICATOR       NULL   50     char
STUDENTTERM_V   FIRSTTERMINMAJORCOUNT           NULL   10     num
STUDENTTERM_V   FIRSTTERMINMAJORINDICATOR       NULL   50     char
STUDENTTERM_V   FIRSTTERMINMINORCOUNT           NULL   10     num
STUDENTTERM_V   FIRSTTERMINMINORINDICATOR       NULL   50     char
STUDENTTERM_V   FIRSTTERMINPROGRAMCOUNT         NULL   10     num
STUDENTTERM_V   FIRSTTERMINPROGRAMINDICATOR     NULL   50     char
STUDENTTERM_V   FORMOFSTUDY                     NULL   50     char
STUDENTTERM_V   FORMOFSTUDYSOURCEKEY            NULL   5      char
STUDENTTERM_V   FTECOUNT                        NULL   8, 3   num
STUDENTTERM_V   FULLYENROLLEDDATE               NULL   7      date
STUDENTTERM_V   FULLYGRADEDDATE                 NULL   7      date
STUDENTTERM_V   GENDER                          NULL   50     char
STUDENTTERM_V   GENDERSOURCEKEY                 NULL   5      char
STUDENTTERM_V   GPACUMULATIVEBAND               NULL   50     char
STUDENTTERM_V   GPATERMBAND                     NULL   50     char
STUDENTTERM_V   GRADUATIONAPPLYSTATSOURCEKEY    NULL   5      char
STUDENTTERM_V   GRADUATIONAPPLYSTATUS           NULL   50     char
STUDENTTERM_V   HASACTCOMPOSITESCORE            NULL   10     num
STUDENTTERM_V   HASACTENGLISHSCORE              NULL   10     num
STUDENTTERM_V   HASACTMATHSCORE                 NULL   10     num
STUDENTTERM_V   HASACTREADINGSCORE              NULL   10     num
STUDENTTERM_V   HASACTSCIENCESCORE              NULL   10     num
STUDENTTERM_V   HASCUMULATIVEGPA                NULL   10     num
STUDENTTERM_V   HASCUMULATIVETESTCREDITS        NULL   10     num
STUDENTTERM_V   HASCUMULATIVETRANSFERCREDITS    NULL   10     num
STUDENTTERM_V   HASSAT1600SCORE                 NULL   10     num
STUDENTTERM_V   HASSAT2400SCORE                 NULL   10     num
STUDENTTERM_V   HASSATMATHSCORE                 NULL   10     num
STUDENTTERM_V   HASSATREADINGSCORE              NULL   10     num
STUDENTTERM_V   HASSATVERBALSCORE               NULL   10     num
STUDENTTERM_V   HASSATWRITINGSCORE              NULL   10     num
STUDENTTERM_V   HASTERMGPA                      NULL   10     num
STUDENTTERM_V   HASTERMTESTCREDITS              NULL   10     num
STUDENTTERM_V   HASTERMTRANSFERCREDITS          NULL   10     num
STUDENTTERM_V   HIGHSCHOOL                      NULL   50     char
STUDENTTERM_V   HIGHSCHOOLSOURCEKEY             NULL   11     char
STUDENTTERM_V   INELIGIBLETORETURNCOUNT         NULL   10     num
STUDENTTERM_V   INSTITUTION                     NULL   50     char
STUDENTTERM_V   INSTITUTIONSOURCEKEY            NULL   5      char
STUDENTTERM_V   IPEDSETHNICITY                  NULL   50     char
STUDENTTERM_V   IPEDSETHNICITYSOURCEKEY         NULL   8      char
STUDENTTERM_V   LASTCOLLEGEATTENDED             NULL   50     char
STUDENTTERM_V   LASTCOLLEGEATTENDEDSOURCEKEY    NULL   11     char
STUDENTTERM_V   LASTDATEATTENDED                NULL   7      date
STUDENTTERM_V   MAJOR                           NULL   50     char
STUDENTTERM_V   MAJORSOURCEKEY                  NULL   10     char
STUDENTTERM_V   MINOR                           NULL   50     char
STUDENTTERM_V   MINORSOURCEKEY                  NULL   10     char
STUDENTTERM_V   PLAN                            NULL   50     char
STUDENTTERM_V   PLANSOURCEKEY                   NULL   10     char
STUDENTTERM_V   PRIMARYACADEMICGROUP            NULL   50     char
STUDENTTERM_V   PRIMARYACADEMICGROUPSOURCEKEY   NULL   5      char
STUDENTTERM_V   PRIORGROUP                      NULL   50     char
STUDENTTERM_V   PRIORGROUPSOURCEKEY             NULL   5      char
STUDENTTERM_V   PRIORMAJOR                      NULL   50     char
STUDENTTERM_V   PRIORMAJORSOURCEKEY             NULL   10     char
STUDENTTERM_V   PRIORMINOR                      NULL   50     char
STUDENTTERM_V   PRIORMINORSOURCEKEY             NULL   10     char
STUDENTTERM_V   PRIORPROGRAM                    NULL   50     char
STUDENTTERM_V   PRIORPROGRAMSOURCEKEY           NULL   5      char
STUDENTTERM_V   PROGRAM                         NULL   50     char
STUDENTTERM_V   PROGRAMACTION                   NULL   4000   char
STUDENTTERM_V   PROGRAMACTIONSOURCEKEY          NULL   5      char
STUDENTTERM_V   PROGRAMREASON                   NULL   4000   char
STUDENTTERM_V   PROGRAMREASONSOURCEKEY          NULL   5      char
STUDENTTERM_V   PROGRAMSOURCEKEY                NULL   5      char
STUDENTTERM_V   PROGRAMSTATUS                   NULL   50     char
STUDENTTERM_V   PROGRAMSTATUSSOURCEKEY          NULL   5      char
STUDENTTERM_V   PSTERMGRADEPOINTS               NULL   9, 3   num
STUDENTTERM_V   PSTOTALAUDITED                  NULL   8, 3   num
STUDENTTERM_V   PSTOTALCUMULATIVE               NULL   8, 3   num
STUDENTTERM_V   PSTOTALGRADEPOINTS              NULL   8, 3   num
STUDENTTERM_V   PSTOTALINPROGRESSNOTTOWARDGPA   NULL   8, 3   num
STUDENTTERM_V   PSTOTALINPROGRESSTOWARDGPA      NULL   8, 3   num
STUDENTTERM_V   PSTOTALOTHER                    NULL   8, 3   num
STUDENTTERM_V   PSTOTALPASSEDFORPROGRESS        NULL   8, 3   num
STUDENTTERM_V   PSTOTALPASSEDNOTTOWARDGPA       NULL   8, 3   num
STUDENTTERM_V   PSTOTALPASSEDTOWARDGPA          NULL   8, 3   num
STUDENTTERM_V   PSTOTALTAKENFORPROGRESS         NULL   8, 3   num
STUDENTTERM_V   PSTOTALTAKENNOTTOWARDGPA        NULL   8, 3   num
STUDENTTERM_V   PSTOTALTAKENTOWARDGPA           NULL   8, 3   num
STUDENTTERM_V   PSTOTALTESTCREDIT               NULL   8, 3   num
STUDENTTERM_V   PSTOTALTRANSFERRED              NULL   8, 3   num
STUDENTTERM_V   PSUNITSAUDITED                  NULL   8, 3   num
STUDENTTERM_V   PSUNITSINPROGRESSNOTTOWARDGPA   NULL   8, 3   num
STUDENTTERM_V   PSUNITSINPROGRESSTOWARDGPA      NULL   8, 3   num
STUDENTTERM_V   PSUNITSOTHER                    NULL   8, 3   num
STUDENTTERM_V   PSUNITSPASSEDFORPROGRESS        NULL   8, 3   num
STUDENTTERM_V   PSUNITSPASSEDNOTTOWARDGPA       NULL   8, 3   num
STUDENTTERM_V   PSUNITSPASSEDTOWARDGPA          NULL   8, 3   num
STUDENTTERM_V   PSUNITSTAKENFORPROGRESS         NULL   8, 3   num
STUDENTTERM_V   PSUNITSTAKENNOTTOWARDGPA        NULL   8, 3   num
STUDENTTERM_V   PSUNITSTAKENTOWARDGPA           NULL   8, 3   num
STUDENTTERM_V   PSUNITSTERMTOTAL                NULL   8, 3   num
STUDENTTERM_V   PSUNITSTESTCREDIT               NULL   8, 3   num
STUDENTTERM_V   PSUNITSTRANSFERRED              NULL   8, 3   num
STUDENTTERM_V   RESIDENCEZIPCODE                NULL   4000   char
STUDENTTERM_V   RESIDENCEZIPCODESOURCEKEY       NULL   12     char
STUDENTTERM_V   RESIDENCYADMISSIONS             NULL   50     char
STUDENTTERM_V   RESIDENCYADMISSIONSSOURCEKEY    NULL   5      char
STUDENTTERM_V   RESIDENCYTUITION                NULL   50     char
STUDENTTERM_V   RESIDENCYTUITIONSOURCEKEY       NULL   5      char
STUDENTTERM_V   RETURNEDNEXTTERMINDICATOR       NULL   50     char
STUDENTTERM_V   RETURNEDNEXTYEARINDICATOR       NULL   50     char
STUDENTTERM_V   SAT1600SCORE                    NULL   10     num
STUDENTTERM_V   SAT2400SCORE                    NULL   10     num
STUDENTTERM_V   SATMATHSCORE                    NULL   10     num
STUDENTTERM_V   SATREADINGSCORE                 NULL   10     num
STUDENTTERM_V   SATVERBALSCORE                  NULL   10     num
STUDENTTERM_V   SATWRITINGSCORE                 NULL   10     num
STUDENTTERM_V   STARTTERM                       NULL   50     char
STUDENTTERM_V   STARTTERMFORCAREER              NULL   50     char
STUDENTTERM_V   STARTTERMFORCAREERSOURCEKEY     NULL   5      char
STUDENTTERM_V   STARTTERMFORGROUP               NULL   50     char
STUDENTTERM_V   STARTTERMFORGROUPSOURCEKEY      NULL   5      char
STUDENTTERM_V   STARTTERMFORINSTITUTION         NULL   50     char
STUDENTTERM_V   STARTTERMFORINSTSOURCEKEY       NULL   5      char
STUDENTTERM_V   STARTTERMFORMAJOR               NULL   50     char
STUDENTTERM_V   STARTTERMFORMAJORSOURCEKEY      NULL   5      char
STUDENTTERM_V   STARTTERMFORMINOR               NULL   50     char
STUDENTTERM_V   STARTTERMFORMINORSOURCEKEY      NULL   5      char
STUDENTTERM_V   STARTTERMFORPROGRAM             NULL   50     char
STUDENTTERM_V   STARTTERMFORPROGRAMSOURCEKEY   NULL   5      char
STUDENTTERM_V   STARTTERMSOURCEKEY             NULL   5      char
STUDENTTERM_V   STUDENT                        NULL   50     char
STUDENTTERM_V   STUDENTCAREERNUMBER            NULL   10     num
STUDENTTERM_V   STUDENTSOURCEKEY               NULL   11     char
STUDENTTERM_V   STUDENTTERMCOUNT               NULL   10     num
STUDENTTERM_V   STUDENTTERMSTATUS              NULL   50     char
STUDENTTERM_V   TERM                           NULL   50     char
STUDENTTERM_V   TERMCREDITSATTEMPTED           NULL   8, 3   num
STUDENTTERM_V   TERMCREDITSAUDITED             NULL   8, 3   num
STUDENTTERM_V   TERMCREDITSEARNED              NULL   8, 3   num
STUDENTTERM_V   TERMCREDITSTOWARDGPA           NULL   8, 3   num
STUDENTTERM_V   TERMGPA                        NULL   8, 3   num
STUDENTTERM_V   TERMGRADEPOINTS                NULL   9, 3   num
STUDENTTERM_V   TERMSOURCEKEY                  NULL   4      char
STUDENTTERM_V   TERMTESTCREDITS                NULL   8, 3   num
STUDENTTERM_V   TERMTRANSFERCREDITS            NULL   8, 3   num
STUDENTTERM_V   TIMESCENARIO                   NULL   25     char
STUDENTTERM_V   TIMESCENARIOSOURCEKEY          NULL   5      char
STUDENTTERM_V   TUITIONGROUP                   NULL   50     char
STUDENTTERM_V   TUITIONGROUPSOURCEKEY          NULL   10     char
STUDENTTERM_V   VERSION                        NULL   50     char
STUDENTTERM_V   VERSIONSOURCEKEY               NULL   10     num
STUDENTTERM_V   VISATYPE                       NULL   50     char
STUDENTTERM_V   VISATYPESOURCEKEY              NULL   5      char
STUDENTTERM_V   WITHDRAWCOUNT                  NULL   10     num
STUDENTTERM_V   WITHDRAWDATE                   NULL   7      date
STUDENTTERM_V   WITHDRAWREASON                 NULL   4      char
STUDENTTERM_V   ZIPCODE                        NULL   4000   char
STUDENTTERM_V   ZIPCODESOURCEKEY               NULL   12     char
TRUSTEE          LEGACY_EQUIVALENT
Student Record
Student Record   STUDENT_LEVEL_ABBREVIATION
Student Record   STUDENT_LEVEL
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record   DIVISION_TRANSLATION
Student Record   DIVISION
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record PERSON_NUMBER
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record APPR_MINOR_1_PLAN
Student Record
Student Record CURRENT_MAJOR_PLAN
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record NY_RESIDENT_IND
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record   SEMESTER_FMT
Student Record   HRS_REGISTERED
Student Record
Student Record   NET_HOURS_REGISTERED
Student Record
Student Record
Student Record
Student Record   SEMESTER
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
Student Record
VIEW_NAME                   COLUMN_NAME DESCRIPTION LENGTH   DATA_TYPE
VIEWHELPERADDRESSLOOKUP_V   ADDRESS1                55       char
VIEWHELPERADDRESSLOOKUP_V   ADDRESS2                55       char
VIEWHELPERADDRESSLOOKUP_V   ADDRESS3                55       char
VIEWHELPERADDRESSLOOKUP_V   ADDRESS4                55       char
VIEWHELPERADDRESSLOOKUP_V   ADDRESS_TYPE            4        char
VIEWHELPERADDRESSLOOKUP_V   CITY                    30       char
VIEWHELPERADDRESSLOOKUP_V   COUNTRY                 3        char
VIEWHELPERADDRESSLOOKUP_V   COUNTRYDESCR            30       char
VIEWHELPERADDRESSLOOKUP_V   COUNTY                  30       char
VIEWHELPERADDRESSLOOKUP_V   EFFDT                   7        date
VIEWHELPERADDRESSLOOKUP_V   EFF_STATUS              1        char
VIEWHELPERADDRESSLOOKUP_V   EMPLID                  11       char
VIEWHELPERADDRESSLOOKUP_V   POSTAL                  12       char
VIEWHELPERADDRESSLOOKUP_V   STATE                   6        char
VIEWHELPERADDRESSLOOKUP_V   STATEDESCR              30       char
TRUSTEE LEGACY_EQUIVALENT
Campus Community
Campus Community
Campus Community
Campus Community
Campus Community
Campus Community
Campus Community
Campus Community
Campus Community
Campus Community
Campus Community
Campus Community
Campus Community
Campus Community
Campus Community
VIEW_NAME          COLUMN_NAME             DESCRIPTION
LOK_ACAD_GROUP_V   ACTIVE
LOK_ACAD_GROUP_V   AUTOENROLLFROMWAITLISTIND
LOK_ACAD_GROUP_V   DESCRIPTION
LOK_ACAD_GROUP_V   EFFECTIVEDATE
LOK_ACAD_GROUP_V   EFFECTIVESTATUS
LOK_ACAD_GROUP_V   INSTITUTION
LOK_ACAD_GROUP_V   SHORTDESCRIPTION
LOK_ACAD_GROUP_V   SOURCEKEY
LOK_ACAD_GROUP_V   SPECIALPERMISSIONREQUIREDIND
LOK_ACAD_GROUP_V   UNIQUEDESCRIPTION
LENGTH   DATA_TYPE   TRUSTEE
10       num         Academic Planning and Budget
1        char        Academic Planning and Budget
30       char        Academic Planning and Budget
7        date        Academic Planning and Budget
1        char        Academic Planning and Budget
5        char        Academic Planning and Budget
10       char        Academic Planning and Budget
5        char        Academic Planning and Budget
1        char        Academic Planning and Budget
4000     char        Academic Planning and Budget
VIEW_NAME        COLUMN_NAME              DESCRIPTION
LOK_ACAD_ORG_V   ACTIVE
LOK_ACAD_ORG_V   CAMPUS
LOK_ACAD_ORG_V   CAMPUSDESCRIPTION
LOK_ACAD_ORG_V   DESCRIPTION
LOK_ACAD_ORG_V   EFFECTIVEDATE
LOK_ACAD_ORG_V   EFFECTIVESTATUS
LOK_ACAD_ORG_V   FORMALDESCRIPTION
LOK_ACAD_ORG_V   INSTITUTION
LOK_ACAD_ORG_V   INSTITUTIONDESCRIPTION
LOK_ACAD_ORG_V   SHORTDESCRIPTION
LOK_ACAD_ORG_V   SOURCEKEY
LOK_ACAD_ORG_V   UNIQUEDESCRIPTION
LENGTH   DATA_TYPE   TRUSTEE
10       num         Academic Planning and Budget
5        char        Academic Planning and Budget
30       char        Academic Planning and Budget
30       char        Academic Planning and Budget
7        date        Academic Planning and Budget
1        char        Academic Planning and Budget
50       char        Academic Planning and Budget
5        char        Academic Planning and Budget
30       char        Academic Planning and Budget
10       char        Academic Planning and Budget
10       char        Academic Planning and Budget
4000     char        Academic Planning and Budget
VIEW_NAME         COLUMN_NAME            DESCRIPTION
LOK_ACAD_PLAN_V   ACTIVE
LOK_ACAD_PLAN_V   CAREERDESCRIPTION
LOK_ACAD_PLAN_V   CAREERSOURCEKEY
LOK_ACAD_PLAN_V   CAREERUNIQUEDESCRIPTION
LOK_ACAD_PLAN_V   CIPCODE
LOK_ACAD_PLAN_V   CIPCODEDESCRIPTION
LOK_ACAD_PLAN_V   CIPCODEUNIQUEDESCRIPTION
LOK_ACAD_PLAN_V   DEGREEDESCRIPTION
LOK_ACAD_PLAN_V   DEGREESOURCEKEY
LOK_ACAD_PLAN_V   DEGREEUNIQUEDESCRIPTION
LOK_ACAD_PLAN_V   GROUPDESCRIPTION
LOK_ACAD_PLAN_V   GROUPSOURCEKEY
LOK_ACAD_PLAN_V   GROUPUNIQUEDESCRIPTION
LOK_ACAD_PLAN_V   HEGISCODE
LOK_ACAD_PLAN_V   HEGISCODEDESCRIPTION
LOK_ACAD_PLAN_V   HEGISCODEUNIQUEDESCRIPTION
LOK_ACAD_PLAN_V   ORGDESCRIPTION
LOK_ACAD_PLAN_V   ORGSOURCEKEY
LOK_ACAD_PLAN_V   ORGUNIQUEDESCRIPTION
LOK_ACAD_PLAN_V   PLANDESCRIPTION
LOK_ACAD_PLAN_V   PLANEFFECTIVEDATE
LOK_ACAD_PLAN_V   PLANEFFECTIVESTATUS
LOK_ACAD_PLAN_V   PLANINSTITUTION
LOK_ACAD_PLAN_V   PLANSHORTDESCRIPTION
LOK_ACAD_PLAN_V   PLANSOURCEKEY
LOK_ACAD_PLAN_V   PLANTYPE
LOK_ACAD_PLAN_V   PLANTYPEDESCRIPTION
LOK_ACAD_PLAN_V   PLANUNIQUEDESCRIPTION
LOK_ACAD_PLAN_V   PROGRAMDESCRIPTION
LOK_ACAD_PLAN_V   PROGRAMSOURCEKEY
LOK_ACAD_PLAN_V   PROGRAMUNIQUEDESCRIPTION
LOK_ACAD_PLAN_V   SUBPLANDESCRIPTION
LOK_ACAD_PLAN_V   SUBPLANEFFECTIVEDATE
LOK_ACAD_PLAN_V   SUBPLANEFFECTIVESTATUS
LOK_ACAD_PLAN_V   SUBPLANINSTITUTION
LOK_ACAD_PLAN_V   SUBPLANSHORTDESCRIPTION
LOK_ACAD_PLAN_V   SUBPLANSOURCEKEY
LOK_ACAD_PLAN_V   SUBPLANTYPE
LOK_ACAD_PLAN_V   SUBPLANTYPEDESCRIPTION
LOK_ACAD_PLAN_V   SUBPLANUNIQUEDESCRIPTION
LOK_ACAD_PLAN_V   TRNSCRDESCR
LENGTH   DATA_TYPE   TRUSTEE
10       num         Academic Planning and Budget
30       char        Academic Planning and Budget
4        char        Academic Planning and Budget
4000     char        Academic Planning and Budget
13       char        Academic Planning and Budget
254      char        Academic Planning and Budget
4000     char        Academic Planning and Budget
30       char        Academic Planning and Budget
8        char        Academic Planning and Budget
4000     char        Academic Planning and Budget
30       char        Academic Planning and Budget
5        char        Academic Planning and Budget
4000     char        Academic Planning and Budget
8        char        Academic Planning and Budget
30       char        Academic Planning and Budget
4000     char        Academic Planning and Budget
30       char        Academic Planning and Budget
10       char        Academic Planning and Budget
4000     char        Academic Planning and Budget
30       char        Academic Planning and Budget
7        date        Academic Planning and Budget
1        char        Academic Planning and Budget
5        char        Academic Planning and Budget
10       char        Academic Planning and Budget
10       char        Academic Planning and Budget
3        char        Academic Planning and Budget
30       char        Academic Planning and Budget
4000     char        Academic Planning and Budget
30       char        Academic Planning and Budget
5        char        Academic Planning and Budget
4000     char        Academic Planning and Budget
50       char        Academic Planning and Budget
7        date        Academic Planning and Budget
1        char        Academic Planning and Budget
5        char        Academic Planning and Budget
10       char        Academic Planning and Budget
10       char        Academic Planning and Budget
3        char        Academic Planning and Budget
50       char        Academic Planning and Budget
4000     char        Academic Planning and Budget
100      char        Academic Planning and Budget
VIEW_NAME                  DESCRIPTION
                  COLUMN_NAME                     T
                                   LENGTH DATA_TYPERUSTEE
LOK_ACAD_PROG_V   ACTIVE           10      num    Academic Planning and Budget
LOK_ACAD_PROG_V   CAMPUS           5       char   Academic Planning and Budget
LOK_ACAD_PROG_V                    3
                  CAMPUSDESCRIPTION0       char   Academic Planning and Budget
LOK_ACAD_PROG_V                    3
                  CAREERDESCRIPTION0       char   Academic Planning and Budget
LOK_ACAD_PROG_V   CAREERSOURCEKEY4         char   Academic Planning and Budget
LOK_ACAD_PROG_V                    4000
                  CAREERUNIQUEDESCRIPTION char    Academic Planning and Budget
LOK_ACAD_PROG_V   DESCRIPTION      30      char   Academic Planning and Budget
LOK_ACAD_PROG_V   EFFECTIVEDATE    7       date   Academic Planning and Budget
LOK_ACAD_PROG_V   EFFECTIVESTATUS 1        char   Academic Planning and Budget
LOK_ACAD_PROG_V   FIRSTTERMVALID   4       char   Academic Planning and Budget
LOK_ACAD_PROG_V   GROUPDESCRIPTION30       char   Academic Planning and Budget
LOK_ACAD_PROG_V   GROUPSOURCEKEY 5         char   Academic Planning and Budget
LOK_ACAD_PROG_V                    4000
                  GROUPUNIQUEDESCRIPTION char     Academic Planning and Budget
LOK_ACAD_PROG_V   INSTITUTION      5       char   Academic Planning and Budget
LOK_ACAD_PROG_V                    10
                  ISDEGREESEEKINGPROGRAM num      Academic Planning and Budget
LOK_ACAD_PROG_V   LEVELLOADRULE    5       char   Academic Planning and Budget
LOK_ACAD_PROG_V                    30
                  LEVELLOADRULEDESCRIPTION char   Academic Planning and Budget
LOK_ACAD_PROG_V   ORGDESCRIPTION 30        char   Academic Planning and Budget
LOK_ACAD_PROG_V   ORGSOURCEKEY     10      char   Academic Planning and Budget
LOK_ACAD_PROG_V                    4000
                  ORGUNIQUEDESCRIPTION     char   Academic Planning and Budget
LOK_ACAD_PROG_V   SHORTDESCRIPTION10       char   Academic Planning and Budget
LOK_ACAD_PROG_V   SOURCEKEY        5       char   Academic Planning and Budget
LOK_ACAD_PROG_V   UNIQUEDESCRIPTION4000    char   Academic Planning and Budget
VIEW_NAME            COLUMN_NAME          DESCRIPTION
LOK_ACAD_SUBJECT_V   ACADEMICORGDESCRIPTION
LOK_ACAD_SUBJECT_V   ACADEMICORGSOURCEKEY
LOK_ACAD_SUBJECT_V   ACADEMICORGUNIQUEDESCRIPTION
LOK_ACAD_SUBJECT_V   ACTIVE
LOK_ACAD_SUBJECT_V   CIPCODE
LOK_ACAD_SUBJECT_V   DESCRIPTION
LOK_ACAD_SUBJECT_V   EFFECTIVEDATE
LOK_ACAD_SUBJECT_V   EFFECTIVESTATUS
LOK_ACAD_SUBJECT_V   FORMALDESCRIPTION
LOK_ACAD_SUBJECT_V   HEGISCODE
LOK_ACAD_SUBJECT_V   INSTITUTION
LOK_ACAD_SUBJECT_V   SHORTDESCRIPTION
LOK_ACAD_SUBJECT_V   SOURCEKEY
LOK_ACAD_SUBJECT_V   SPLITOWNERINDICATOR
LOK_ACAD_SUBJECT_V   UNIQUEDESCRIPTION
LENGTH   DATA_TYPE   TRUSTEE
30       char        Academic Planning and Budget
10       char        Academic Planning and Budget
4000     char        Academic Planning and Budget
10       num         Academic Planning and Budget
13       char        Academic Planning and Budget
30       char        Academic Planning and Budget
7        date        Academic Planning and Budget
1        char        Academic Planning and Budget
50       char        Academic Planning and Budget
8        char        Academic Planning and Budget
5        char        Academic Planning and Budget
10       char        Academic Planning and Budget
8        char        Academic Planning and Budget
1        char        Academic Planning and Budget
4000     char        Academic Planning and Budget
g and Budget
g and Budget
g and Budget
g and Budget
g and Budget
g and Budget
g and Budget
g and Budget
g and Budget
g and Budget
g and Budget
g and Budget
g and Budget
g and Budget
g and Budget
VIEW_NAME      COLUMN_NAME         DESCRIPTION
LOK_DEGREE_V   ACTIVE
LOK_DEGREE_V   DESCRIPTION
LOK_DEGREE_V   EDUCATIONLEVEL
LOK_DEGREE_V   EFFECTIVEDATE
LOK_DEGREE_V   EFFECTIVESTATUS
LOK_DEGREE_V   FORMALDESCRIPTION
LOK_DEGREE_V   INTERNALDEGREE
LOK_DEGREE_V   SHORTDESCRIPTION
LOK_DEGREE_V   SOURCEKEY
LOK_DEGREE_V   UNIQUEDESCRIPTION
LOK_DEGREE_V   YEARSOFEDUCATION
LENGTH   DATA_TYPE   TRUSTEE
10       num         Academic Planning and Budget
30       char        Academic Planning and Budget
30       char        Academic Planning and Budget
7        date        Academic Planning and Budget
1        char        Academic Planning and Budget
50       char        Academic Planning and Budget
1        char        Academic Planning and Budget
10       char        Academic Planning and Budget
8        char        Academic Planning and Budget
4000     char        Academic Planning and Budget
5        num         Academic Planning and Budget
g and Budget
g and Budget
g and Budget
g and Budget
g and Budget
g and Budget
g and Budget
g and Budget
g and Budget
g and Budget
g and Budget
VIEW_NAME                      DESCRIPTION
                     COLUMN_NAME       LENGTH           T
                                                DATA_TYPERUSTEE
LOK_ORG_LOCATION_V   ADDRESS1          55       char    Academic Planning and Budget
LOK_ORG_LOCATION_V   ADDRESS2          55       char    Academic Planning and Budget
LOK_ORG_LOCATION_V   ADDRESS3          55       char    Academic Planning and Budget
LOK_ORG_LOCATION_V   ADDRESS4          55       char    Academic Planning and Budget
LOK_ORG_LOCATION_V   ADDR_FIELD1       2        char    Academic Planning and Budget
LOK_ORG_LOCATION_V   ADDR_FIELD2       4        char    Academic Planning and Budget
LOK_ORG_LOCATION_V   ADDR_FIELD3       4        char    Academic Planning and Budget
LOK_ORG_LOCATION_V   CITY              30       char    Academic Planning and Budget
LOK_ORG_LOCATION_V   COUNTRY           3        char    Academic Planning and Budget
LOK_ORG_LOCATION_V   COUNTY            30       char    Academic Planning and Budget
LOK_ORG_LOCATION_V   DESCR             30       char    Academic Planning and Budget
LOK_ORG_LOCATION_V   DESCRSHORT        10       char    Academic Planning and Budget
LOK_ORG_LOCATION_V   EDI_ADDRESS       999      char    Academic Planning and Budget
LOK_ORG_LOCATION_V   EFFDT             7        date    Academic Planning and Budget
LOK_ORG_LOCATION_V   EFF_STATUS        1        char    Academic Planning and Budget
LOK_ORG_LOCATION_V   EMAILID           70       char    Academic Planning and Budget
LOK_ORG_LOCATION_V   EXT_ORG_ID        11       char    Academic Planning and Budget
LOK_ORG_LOCATION_V   GEO_CODE          11       char    Academic Planning and Budget
LOK_ORG_LOCATION_V   HOUSE_TYPE        2        char    Academic Planning and Budget
LOK_ORG_LOCATION_V   IN_CITY_LIMIT     1        char    Academic Planning and Budget
LOK_ORG_LOCATION_V   LASTUPDDTTM       7        date    Academic Planning and Budget
LOK_ORG_LOCATION_V   LASTUPDOPRID      30       char    Academic Planning and Budget
LOK_ORG_LOCATION_V   NUM1              6        char    Academic Planning and Budget
LOK_ORG_LOCATION_V   NUM2              6        char    Academic Planning and Budget
LOK_ORG_LOCATION_V   ORG_LOCATION      38       num     Academic Planning and Budget
LOK_ORG_LOCATION_V   POSTAL            12       char    Academic Planning and Budget
LOK_ORG_LOCATION_V   STATE             6        char    Academic Planning and Budget
LOK_ORG_LOCATION_V   URL_ADDRESS       254      char    Academic Planning and Budget
VIEW_NAME                    DESCRIPTION
                    COLUMN_NAME                     T
                                     LENGTH DATA_TYPERUSTEE
LOK_PLAN_ENTITY_V   LEGACY_AWARD     3       char   Academic Planning and Budget
LOK_PLAN_ENTITY_V   LEGACY_AWARD_ABBR10      char   Academic Planning and Budget
LOK_PLAN_ENTITY_V                    2
                    LEGACY_CONCENTRATION_ID char    Academic Planning and Budget
LOK_PLAN_ENTITY_V                    50
                    LEGACY_ENTITY_NAME       char   Academic Planning and Budget
LOK_PLAN_ENTITY_V                    4
                    LEGACY_ENTITY_NUMBER     char   Academic Planning and Budget
LOK_PLAN_ENTITY_V                    1
                    LEGACY_ENTITY_STATUS     char   Academic Planning and Budget
LOK_PLAN_ENTITY_V   LEGACY_MINOR_ID 2        char   Academic Planning and Budget
LOK_PLAN_ENTITY_V                    7
                    STRUCTURE_CREATION_DATE date    Academic Planning and Budget
LOK_PLAN_ENTITY_V                    1
                    STRUCTURE_USE_CODE       char   Academic Planning and Budget
LOK_PLAN_ENTITY_V   TRNSCRDESCR      100     char   Academic Planning and Budget
LOK_PLAN_ENTITY_V   UBSIS_APPRV_INT 1        char   Academic Planning and Budget
LOK_PLAN_ENTITY_V                    30
                    UBSIS_APPRV_INT_DESCR    char   Academic Planning and Budget
LOK_PLAN_ENTITY_V   UBSIS_CAREER     4       char   Academic Planning and Budget
LOK_PLAN_ENTITY_V                    30
                    UBSIS_CAREER_DESCR       char   Academic Planning and Budget
LOK_PLAN_ENTITY_V   UBSIS_FUNDING    1       char   Academic Planning and Budget
LOK_PLAN_ENTITY_V                    30
                    UBSIS_FUNDING_TRAN       char   Academic Planning and Budget
LOK_PLAN_ENTITY_V   UBSIS_PLAN       10      char   Academic Planning and Budget
LOK_PLAN_ENTITY_V   UBSIS_PLAN_DESCR 30      char   Academic Planning and Budget
LOK_PLAN_ENTITY_V                    1
                    UBSIS_PLAN_ENUMERATIVE   char   Academic Planning and Budget
LOK_PLAN_ENTITY_V                    30      char
                    UBSIS_PLAN_ENUMERATIVE_DESCR    Academic Planning and Budget
LOK_PLAN_ENTITY_V   UBSIS_PLAN_TYPE 3        char   Academic Planning and Budget
LOK_PLAN_ENTITY_V                    30
                    UBSIS_PLAN_TYPE_DESCR    char   Academic Planning and Budget
LOK_PLAN_ENTITY_V   UBSIS_PROGRAM    4       char   Academic Planning and Budget
LOK_PLAN_ENTITY_V                    30
                    UBSIS_PROGRAM_DESCR      char   Academic Planning and Budget
LOK_PLAN_ENTITY_V                    1
                    UBSIS_PROGRAM_LEVEL      char   Academic Planning and Budget
LOK_PLAN_ENTITY_V                    30
                    UBSIS_PROGRAM_LEVEL_DESCRchar   Academic Planning and Budget
LOK_PLAN_ENTITY_V                    1
                    UBSIS_PROGRAM_TYPE       char   Academic Planning and Budget
LOK_PLAN_ENTITY_V                    30
                    UBSIS_PROGRAM_TYPE_DESCR char   Academic Planning and Budget
LOK_PLAN_ENTITY_V   UBSIS_SUBPLAN    10      char   Academic Planning and Budget
LOK_PLAN_ENTITY_V                    30
                    UBSIS_SUBPLAN_DESCR      char   Academic Planning and Budget
LOK_PLAN_ENTITY_V                    3
                    UBSIS_SUBPLAN_TYPE       char   Academic Planning and Budget
LOK_PLAN_ENTITY_V                    30
                    UBSIS_SUBPLAN_TYPE_DESCR char   Academic Planning and Budget
VIEW_NAME             DESCRIPTION
             COLUMN_NAME      LENGTH           T
                                       DATA_TYPERUSTEE
LOK_TERM_V   ACADEMICYEAR     4        char    Academic Planning and Budget
LOK_TERM_V   ACTIVE           10       num     Academic Planning and Budget
LOK_TERM_V   DESCRIPTION      30       char    Academic Planning and Budget
LOK_TERM_V   HOLIDAYSCHEDULE 4         char    Academic Planning and Budget
LOK_TERM_V   INSTITUTION      5        char    Academic Planning and Budget
LOK_TERM_V   NEXTTERMSOURCEKEY1        char    Academic Planning and Budget
LOK_TERM_V                    1
             NEXTYEARTERMSOURCEKEY     char    Academic Planning and Budget
LOK_TERM_V                    1
             PRIORTERMSOURCEKEY        char    Academic Planning and Budget
LOK_TERM_V                    1
             PRIORYEARTERMSOURCEKEY    char    Academic Planning and Budget
LOK_TERM_V   SESSIONCODE      3        char    Academic Planning and Budget
LOK_TERM_V   SIXTYPERCENTDATE7         date    Academic Planning and Budget
LOK_TERM_V   SOURCEKEY        4        char    Academic Planning and Budget
LOK_TERM_V   TERMBEGINDATE    7        date    Academic Planning and Budget
LOK_TERM_V   TERMCATEGORY     30       char    Academic Planning and Budget
LOK_TERM_V   TERMENDDATE      7        date    Academic Planning and Budget
LOK_TERM_V   TERMTYPE         30       char    Academic Planning and Budget
LOK_TERM_V   UNIQUEDESCRIPTION4000     char    Academic Planning and Budget
LOK_TERM_V                    10
             WEEKSOFINSTRUCTION        num     Academic Planning and Budget
VIEW_NAME                DESCRIPTION
                 COLUMN_NAME      LENGTH           T
                                           DATA_TYPERUSTEE
                 RELATIONSHIP
LOK_RELATIONSHIP_V                4        char    Academic Planning and Budget
                 RELATIONSHIP_DESCR
LOK_RELATIONSHIP_V                30       char    Academic Planning and Budget
VIEW_NAME               COLUMN_NAME
LOK_PEOPLE_RELATION_V   PEOPLE_RELATION
LOK_PEOPLE_RELATION_V   PEOPLE_RELATION_DESCR
DESCRIPTION   LENGTH
              4
              30
DATA_TYPE   TRUSTEE
char        Academic Planning and Budget
char        Academic Planning and Budget
CONVERSION_RULES
VIEW_NAME              DESCRIPTION
              COLUMN_NAME      LENGTH           T
                                        DATA_TYPERUSTEE
PERSON_NAME   EMPLOYEEID       11       char    Campus Community
PERSON_NAME                    80
              FIRST_MI_LAST_SUFFIX      char    Campus Community
PERSON_NAME                    108
              FIRST_MN_LAST_SUFFIX      char    Campus Community
PERSON_NAME   FIRST_NAME       30       char    Campus Community
PERSON_NAME   FORMAL_GREETING 66        char    Campus Community
PERSON_NAME   INFORMAL_GREETING35       char    Campus Community
PERSON_NAME   LAST_NAME        30       char    Campus Community
PERSON_NAME   MIDDLE_NAME      30       char    Campus Community
PERSON_NAME   NAME_SUFFIX      15       char    Campus Community
PERSON_NAME   PERSON_NAME      50       char    Campus Community
PERSON_NAME   PERSON_NAME_UNFMT50       char    Campus Community
PERSON_NAME   SALUTATION       61       char    Campus Community
PERSON_NAME   SORT_NAME        93       char    Campus Community
PERSON_NAME   TO_THE_PARENTS_OF79       char    Campus Community
VIEW_NAME                   DESCRIPTION
                   COLUMN_NAME      LENGTH           T
                                             DATA_TYPERUSTEE
PS_CLASS_NOTES_V   CLASS_NOTES_SEQ           num     Student
PS_CLASS_NOTES_V   CLASS_NOTE_NBR 4          char    Student
PS_CLASS_NOTES_V   CLASS_SECTION    4        char    Student
PS_CLASS_NOTES_V   CRSE_ID          6        char    Student
PS_CLASS_NOTES_V   CRSE_OFFER_NBR            num     Student
PS_CLASS_NOTES_V   DESCRLONG        4000     clob    Student
PS_CLASS_NOTES_V   PRINT_AT         1        char    Student
PS_CLASS_NOTES_V                    1
                   PRINT_NOTE_W_O_CLS        char    Student
PS_CLASS_NOTES_V   SESSION_CODE     3        char    Student
PS_CLASS_NOTES_V   STRM             4        char    Student
VIEW_NAME                        DESCRIPTION
                       COLUMN_NAME       LENGTH           T
                                                  DATA_TYPERUSTEE
PS_EMERGENCY_CNTCT_V   ADDRESS1          55       char    Campus Community
PS_EMERGENCY_CNTCT_V   ADDRESS2          55       char    Campus Community
PS_EMERGENCY_CNTCT_V   ADDRESS3          55       char    Campus Community
PS_EMERGENCY_CNTCT_V   ADDRESS4          55       char    Campus Community
PS_EMERGENCY_CNTCT_V   ADDRESS_TYPE      4        char    Campus Community
PS_EMERGENCY_CNTCT_V   ADDR_FIELD1       2        char    Campus Community
PS_EMERGENCY_CNTCT_V   ADDR_FIELD2       4        char    Campus Community
PS_EMERGENCY_CNTCT_V   ADDR_FIELD3       4        char    Campus Community
PS_EMERGENCY_CNTCT_V   CITY              30       char    Campus Community
PS_EMERGENCY_CNTCT_V   CONTACT_NAME      50       char    Campus Community
PS_EMERGENCY_CNTCT_V   COUNTRY           3        char    Campus Community
PS_EMERGENCY_CNTCT_V   COUNTRY_CODE      3        char    Campus Community
PS_EMERGENCY_CNTCT_V   COUNTY            30       char    Campus Community
PS_EMERGENCY_CNTCT_V   EMPLID            11       char    Campus Community
PS_EMERGENCY_CNTCT_V   EXTENSION         6        char    Campus Community
PS_EMERGENCY_CNTCT_V   GEO_CODE          11       char    Campus Community
PS_EMERGENCY_CNTCT_V   HOUSE_TYPE        2        char    Campus Community
PS_EMERGENCY_CNTCT_V   IN_CITY_LIMIT     1        char    Campus Community
PS_EMERGENCY_CNTCT_V   NUM1              6        char    Campus Community
PS_EMERGENCY_CNTCT_V   NUM2              6        char    Campus Community
PS_EMERGENCY_CNTCT_V   PHONE             24       char    Campus Community
PS_EMERGENCY_CNTCT_V   PHONE_TYPE        4        char    Campus Community
PS_EMERGENCY_CNTCT_V   POSTAL            12       char    Campus Community
PS_EMERGENCY_CNTCT_V   PRIMARY_CONTACT 1          char    Campus Community
PS_EMERGENCY_CNTCT_V   RELATIONSHIP      2        char    Campus Community
PS_EMERGENCY_CNTCT_V   SAME_ADDRESS_EMPL 1        char    Campus Community
PS_EMERGENCY_CNTCT_V   SAME_PHONE_EMPL 1          char    Campus Community
PS_EMERGENCY_CNTCT_V   STATE             6        char    Campus Community
VIEW_NAME             COLUMN_NAME           DESCRIPTION
PS_COURSE_CATALOG_V   ACADEMICGROUP
PS_COURSE_CATALOG_V   ACADEMICORGANIZATION
PS_COURSE_CATALOG_V   ACTIVE
PS_COURSE_CATALOG_V   COURSETITLELONG
PS_COURSE_CATALOG_V   CRSE_ID
PS_COURSE_CATALOG_V   DEFAULTGRADINGBASIS
PS_COURSE_CATALOG_V   DEFAULTGRADINGBASISUNIQUEDESCR
PS_COURSE_CATALOG_V   DESCRIPTION
PS_COURSE_CATALOG_V   DESCRIPTIONLONG
PS_COURSE_CATALOG_V   EFFECTIVEDATE
PS_COURSE_CATALOG_V   EFFECTIVESTATUS
PS_COURSE_CATALOG_V   GRADINGBASIS
PS_COURSE_CATALOG_V   PRIMARYCATALOGNUMBER
PS_COURSE_CATALOG_V   PRIMARYCOMPONENT
PS_COURSE_CATALOG_V   PRIMARYCOMPONENTDESCRIPTION
PS_COURSE_CATALOG_V   PRIMARYSUBJECT
PS_COURSE_CATALOG_V   PRIMARYSUBJECTDESCRIPTION
PS_COURSE_CATALOG_V   PRIMARYSUBJECTUNIQUEDESCR
PS_COURSE_CATALOG_V   REQUIREMENTGROUP
PS_COURSE_CATALOG_V   RQRMNT_GROUP
PS_COURSE_CATALOG_V   RQRMNT_GROUP_LONG_DESCRIPTION
PS_COURSE_CATALOG_V   UNIQUEDESCRIPTION
PS_COURSE_CATALOG_V   UNITSMAXIMUM
PS_COURSE_CATALOG_V   UNITSMINIMUM
LENGTH   DATA_TYPE   TRUSTEE
5        char        Student
10       char        Student
10       num         Student
100      char        Student
6        char        Student
3        char        Student
4000     char        Student
30       char        Student
4000     char        Student
7        date        Student
1        char        Student
3        char        Student
10       char        Student
3        char        Student
30       char        Student
8        char        Student
30       char        Student
4000     char        Student
6        char        Student
6        char        Student
254      char        Student
4000     char        Student
5, 2     num         Student
5, 2     num         Student
VIEW_NAME             COLUMN_NAME
CLASSEXAMSCHEDULE_V   ACADEMICGROUP
CLASSEXAMSCHEDULE_V   ACADEMICGROUPSOURCEKEY
CLASSEXAMSCHEDULE_V   ACADEMICORG
CLASSEXAMSCHEDULE_V   ACADEMICORGSOURCEKEY
CLASSEXAMSCHEDULE_V   ASSOCIATECLASS
CLASSEXAMSCHEDULE_V   BILLINGFACTOR
CLASSEXAMSCHEDULE_V   BLDGCD
CLASSEXAMSCHEDULE_V   CATALOGNUMBERSOURCEKEY
CLASSEXAMSCHEDULE_V   CLASSEXAMSEQ
CLASSEXAMSCHEDULE_V   CLASSEXAMTYPE
CLASSEXAMSCHEDULE_V   CLASSNUMBER
CLASSEXAMSCHEDULE_V   CLASSNUMBERSECTION
CLASSEXAMSCHEDULE_V   CLASSSECTION
CLASSEXAMSCHEDULE_V   CLASSSECTIONSOURCEKEY
CLASSEXAMSCHEDULE_V   COMBINEDEXAM
CLASSEXAMSCHEDULE_V   COMBINEDSECTION
CLASSEXAMSCHEDULE_V   COMBINEDSECTIONDESCR
CLASSEXAMSCHEDULE_V   COURSE
CLASSEXAMSCHEDULE_V   COURSECAREER
CLASSEXAMSCHEDULE_V   COURSECAREERSOURCEKEY
CLASSEXAMSCHEDULE_V   COURSEDESCRIPTION
CLASSEXAMSCHEDULE_V   COURSEID
CLASSEXAMSCHEDULE_V   COURSEOFFERNUMBER
CLASSEXAMSCHEDULE_V   COURSESOURCEKEY
CLASSEXAMSCHEDULE_V   COURSETYPE
CLASSEXAMSCHEDULE_V   COURSETYPESOURCEKEY
CLASSEXAMSCHEDULE_V   CRSTOPICDESCR
CLASSEXAMSCHEDULE_V   CRSTOPICID
CLASSEXAMSCHEDULE_V   DESCR
CLASSEXAMSCHEDULE_V   DESCRSHORT
CLASSEXAMSCHEDULE_V   ENROLLMENTSECTSTATUS
CLASSEXAMSCHEDULE_V   ENROLLMENTSECTSTATUSSOURCEKEY
CLASSEXAMSCHEDULE_V   ENROLLTOTAL
CLASSEXAMSCHEDULE_V   EXAMDT
CLASSEXAMSCHEDULE_V   EXAMENDTIME
CLASSEXAMSCHEDULE_V   EXAMSEATSPACING
CLASSEXAMSCHEDULE_V   EXAMSTARTTIME
CLASSEXAMSCHEDULE_V   EXAMTIMECODE
CLASSEXAMSCHEDULE_V   FACILITYGROUP
CLASSEXAMSCHEDULE_V   FACILITYID
CLASSEXAMSCHEDULE_V   FACILITYTYPE
CLASSEXAMSCHEDULE_V   FACULTY
CLASSEXAMSCHEDULE_V   FACULTYSOURCEKEY
CLASSEXAMSCHEDULE_V   FINALEXAM
CLASSEXAMSCHEDULE_V   INSTITUTION
CLASSEXAMSCHEDULE_V   INSTITUTIONSOURCEKEY
CLASSEXAMSCHEDULE_V   INSTRUCTORROLE
CLASSEXAMSCHEDULE_V   LOCATION
CLASSEXAMSCHEDULE_V   PRIMARYINSTRUCTORSECTION
CLASSEXAMSCHEDULE_V   REGISTRATIONCONSENT
CLASSEXAMSCHEDULE_V   REGISTRATIONCONSENTSOURCEKEY
CLASSEXAMSCHEDULE_V   ROOM
CLASSEXAMSCHEDULE_V   ROOMCAPACITY
CLASSEXAMSCHEDULE_V   SCHEDULEPRINT
CLASSEXAMSCHEDULE_V   SECTIONCAPACITY
CLASSEXAMSCHEDULE_V   SECTIONCOUNT
CLASSEXAMSCHEDULE_V   SECTIONSTATUS
CLASSEXAMSCHEDULE_V   SECTIONSTATUSSOURCEKEY
CLASSEXAMSCHEDULE_V   SESSIONCODE
CLASSEXAMSCHEDULE_V   SESSIONORACLE
CLASSEXAMSCHEDULE_V   SESSIONSOURCEKEY
CLASSEXAMSCHEDULE_V   SUBJECTDESCRIPTION
CLASSEXAMSCHEDULE_V   SUBJECTDESCRIPTIONSOURCEKEY
CLASSEXAMSCHEDULE_V   SUBJECTSOURCEKEY
CLASSEXAMSCHEDULE_V   TERM
CLASSEXAMSCHEDULE_V   TERMCODE
CLASSEXAMSCHEDULE_V   TERMSOURCEKEY
CLASSEXAMSCHEDULE_V   UNITSMINIMUM
CLASSEXAMSCHEDULE_V   UNITSMXIMUM
CLASSEXAMSCHEDULE_V   VERSION
CLASSEXAMSCHEDULE_V   WAITLISTCAPACITY
CLASSEXAMSCHEDULE_V   WAITLISTTOTAL
        DESCRIPTION   LENGTH
                      50
                      5
                      50
                      10
                      38
                      5, 3
                      10
                      10

                      4
                      10
                      4000
                      4
                      4
                      1
                      1
                      50
                      50
                      50
                      5
                      50
                      6
                      10
                      6
                      50
                      5
                      30
                      38
                      30
                      10
                      50
SOURCEKEY             5
                      10
                      7
                      11
                      38
                      11
                      8
                      1
                      10
                      4
                      50
                      11
                      2
                      50
                      5
50
10
4
50
5
10

24
10
10
50
5
3
150
5
50
8
8
50
4
5
5, 2
5, 2
50
10
10
DATA_TYPE      TRUSTEE
char           Student
char           Student
char           Student
char           Student
num            Student
num            Student
char           Student
char           Student
num            Student
char           Student
num            Student
char           Student
char           Student
char           Student
char           Student
char           Student
char           Student
char           Student
char           Student
char           Student
char           Student
char           Student
num            Student
char           Student
char           Student
char           Student
char           Student
num            Student
char           Student
char           Student
char           Student
char           Student
num            Student
date           Student
timestamp(6)   Student
num            Student
timestamp(6)   Student
char           Student
char           Student
char           Student
char           Student
char           Student
char           Student
char           Student
char           Student
char           Student
char   Student
char   Student
char   Student
char   Student
char   Student
char   Student
num    Student
char   Student
num    Student
num    Student
char   Student
char   Student
char   Student
char   Student
char   Student
char   Student
char   Student
char   Student
char   Student
char   Student
char   Student
num    Student
num    Student
char   Student
num    Student
num    Student
VIEW_NAME             COLUMN_NAME                             LENGTH
                                                      DESCRIPTION
PS_CLASS_CAPACITY_V   ACADEMICORG                             50
PS_CLASS_CAPACITY_V   ACADEMICORGSOURCEKEY                    10
PS_CLASS_CAPACITY_V   CATALOGNUMBER                           10
PS_CLASS_CAPACITY_V   CLASSNUMBER                             10
PS_CLASS_CAPACITY_V   CLASSNUMBERSECTION                      4000
PS_CLASS_CAPACITY_V   CLASS_ENROLL_TOTAL                      10
PS_CLASS_CAPACITY_V   CLASS_SECTION                           4
PS_CLASS_CAPACITY_V   COURSE                                  50
PS_CLASS_CAPACITY_V   COURSECAREER                            50
PS_CLASS_CAPACITY_V   COURSECAREERSOURCEKEY                   5
PS_CLASS_CAPACITY_V   COURSETYPE                              50
PS_CLASS_CAPACITY_V   CRSE_ID                                 6
PS_CLASS_CAPACITY_V   CRSE_OFFER_NBR
PS_CLASS_CAPACITY_V   ENROLLMENT_CAPACITY                    10
PS_CLASS_CAPACITY_V   PRIMARYCOMPONENT                       3
PS_CLASS_CAPACITY_V   PRIMARYSUBJECT                         8
PS_CLASS_CAPACITY_V   RESERVE_CAPACITY
PS_CLASS_CAPACITY_V   RESERVE_CAPACITY_ENROLL_TOTAL
PS_CLASS_CAPACITY_V   ROOM                                   50
PS_CLASS_CAPACITY_V   ROOMCAPACITYREQUEST                    38
PS_CLASS_CAPACITY_V   RQRMNT_GROUP                           6
PS_CLASS_CAPACITY_V   RQRMNT_GROUP_DESCR                     30
PS_CLASS_CAPACITY_V   RQRMNT_GROUP_LONG_DESCR                254
PS_CLASS_CAPACITY_V   RSRV_CAP_NBR
PS_CLASS_CAPACITY_V   SEATSAVAILABLE                         ,
PS_CLASS_CAPACITY_V   SESSION_CODE                           3
PS_CLASS_CAPACITY_V   START_DT                               7
PS_CLASS_CAPACITY_V   STRM                                   4
PS_CLASS_CAPACITY_V   TERM                                   50
        T
DATA_TYPERUSTEE
char    Student
char    Student
char    Student
num     Student
char    Student
num     Student
char    Student
char    Student
char    Student
char    Student
char    Student
char    Student
num     Student
num     Student
char    Student
char    Student
num     Student
num     Student
char    Student
num     Student
char    Student
char    Student
char    Student
num     Student
num     Student
char    Student
date    Student
char    Student
char    Student
VIEW_NAME             DESCRIPTION
             COLUMN_NAME      LENGTH           T
                                       DATA_TYPERUSTEE
             CLASS_NOTE_NBR 4
PS_CLASS_NOTES_TBL_V                   char    Student
             DESCR
PS_CLASS_NOTES_TBL_V          30       char    Student
             DESCRLONG
PS_CLASS_NOTES_TBL_V          4000     char    Student
             EFFDT
PS_CLASS_NOTES_TBL_V          7        date    Student
             EFF_STATUS
PS_CLASS_NOTES_TBL_V          1        char    Student
             INSTITUTION
PS_CLASS_NOTES_TBL_V          5        char    Student

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:5
posted:12/1/2011
language:Swedish
pages:159