| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
|
ACADEMIC_PERIOD_NUENROLL
|
Academic_Period_Enrolled
|
Academic term for the course in which a student is enrolled.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
ACADEMIC_PERIOD_NUENROLL_DESC
|
Academic_Period_Enrolled_Desc
|
Description for Academic Period Enrolled
|
VARCHAR2(255 CHAR)
|
|
|
|
|
ACADEMIC_PERIOD_NUFREEZE
|
Academic_Period
|
Academic term when student data was frozen corresponding to an event in the academic calendar (defined by student level).
|
VARCHAR2(63 CHAR)
|
|
|
|
|
ACADEMIC_PERIOD_NUFREEZE_DESC
|
Academic_Period_Desc
|
Description for Academic Period
|
VARCHAR2(255 CHAR)
|
|
|
|
|
ACADEMIC_RANK
|
Instructor_Academic_Rank
|
A code representing faculty designation-rank in a college or university.
|
VARCHAR2 (9 CHAR)
|
|
|
|
|
ACADEMIC_RANK_DESC
|
Instructor_Academic_Rank_Desc
|
Description for Academic Rank
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
ACTUAL_ENROLLMENT
|
Actual_Enrollment
|
Total number of students enrolled in course section. The students counting in the actual enrollment have a course status defined to count as enrolled.
|
NUMBER (5)
|
|
|
|
|
CAMPUS
|
Course_Campus_Code
|
Campus where the course section is offered.
|
VARCHAR2 (63 CHAR)
|
STVCAMP
|
|
|
|
CAMPUS_DESC
|
Course_Campus_Desc
|
Description for campus.
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
COLLEGE
|
Student_College_Code
|
This field identifies the college associated with the primary curriculum for the effective term.
|
VARCHAR2 (63 CHAR)
|
STVCOLL
|
|
|
|
COLLEGE_DESC
|
Student_College_Description
|
Description for College
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
COLLEGE_DESC_FULL
|
COLLEGE_DESC_FULL
|
Description for College, titles have no character limits
|
|
|
|
|
|
CONTINUING_EDUCATION_IND
|
|
Indicates whether or not the class is offered for continuing education credit.
|
VARCHAR2 (1)
|
|
|
|
|
COOPERATIVE_EDUCATION_IND
|
Cooperative_Education_Ind
|
Indicates that the class is a coop placement
|
VARCHAR2 (1)
|
|
|
|
|
CORE_CAPSTONE_IND
|
CORE_CAPSTONE_IND
|
Records if class fulfills Capstone requirement.
|
|
|
|
|
|
COURSE_BILLING_CREDITS
|
Course_Billing_Credits
|
Billing units associated with this section or schedule offering.
|
NUMBER (11, 3)
|
|
|
|
|
COURSE_COLLEGE
|
Course_College_Code
|
College or school to which the course instructional responsibility is associated.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
COURSE_COLLEGE_DESC
|
Course_College_Desc
|
College or school name.
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
COURSE_CREDITS
|
Course_Credits
|
Academic Credits associated with this course, credits which appear on your transcript.
|
NUMBER (11,3)
|
|
|
|
|
COURSE_DEPARTMENT
|
Course_Department_Code
|
Course department responsible for the instructional delivery of this offering.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
COURSE_DEPARTMENT_DESC
|
Course_Department_Desc
|
Description for Course Department
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
COURSE_IDENTIFICATION
|
Course_Identification
|
Combined subject code and course number that identifies the instructional content of this course.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
COURSE_NUMBER
|
Course_Number
|
Course number associated with the subject for the course.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
COURSE_REFERENCE_NUMBER
|
Course_Reference_Number
|
Universally referred to as the 'CRN', this is a computer assigned internal unique 5 digit numeric identifier for the schedule offering for a specific section within a specific term.
Please note: The course reference number for a given class will be different from term to term.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
CURRENT_TIME_STATUS
|
Student_Attendance_Status_Code
|
This field identifies whether the student is taking a full or part-time credit load (which varies by student level) for the given term.
|
VARCHAR2 (63 CHAR)
|
STVTMST
|
|
|
|
CURRENT_TIME_STATUS_DESC
|
Student_Attendance_Status_Desc
|
Description for current time status.
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
DEGREE
|
Student_Degree
|
Degree or award code associated with the student's academic study.
|
VARCHAR2 (63 CHAR)
|
STVDEGC
|
|
|
|
DEGREE_DESC
|
Student_Degree_Desc
|
Degree code description. For example, bachelor of business administration, master of arts, juris doctor, etc.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
DUAL_MAJOR_IND
|
Combined_Major_Ind
|
Flag indicating that the student is pursuing two majors.
|
VARCHAR2 (1 CHAR)
|
|
|
|
|
EMAIL_PREFERRED_ADDRESS
|
Email_Preferred_Address
|
Indicates which email address would like to receive their email.
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
ENROLLED_IND
|
Enrolled_Indicator
|
Indicates whether the student's enrollment status includes them in headcounts.
|
VARCHAR2 (1 CHAR)
|
|
|
|
|
ENROLLMENT_STATUS
|
Enrollment_Status_Code
|
Identifies Student's current enrollment status.
|
VARCHAR2 (63 CHAR)
|
STVESTS
|
|
|
|
ENROLLMENT_STATUS_DESC
|
Enrollment_Status_Desc
|
Description for student Enrollment Status
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
FACULTY_MEMBER_CATEGORY
|
Faculty_Member_Category
|
Category assigned to the faculty or academic staff member. Included categories may be professor, associate professor, auxiliary, etc.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
FACULTY_MEMBER_CATEGORY_DESC
|
Faculty_Member_Category_Desc
|
Description for faculty member category
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
FACULTY_TENURE
|
Faculty_Tenure
|
Tenure is an employee status with respect to permanence of their position.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
FIRST_NAME
|
Student_First_Name
|
The first name given to a person at birth, baptism, another naming ceremony or through legal change.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
FREEZE_DATE
|
Freeze_Date
|
Actual date the data was frozen
|
DATE
|
|
|
|
|
FULL_PART_TIME_IND
|
Instructor_Full_Part_Time_Ind
|
Indicates whether the instructor is full or part time faculty.
|
VARCHAR2 (5 CHAR)
|
|
|
|
|
HONORS_TYPE
|
Honors_Type
|
Indicates whether a course is part of the Honors program, and if so, what type of Honors course it is. There are Honors Department courses which are offered centrally and are unique to the Honors program, and there are Honors Section courses, which carry the same course numbers and departmental prefix as non-honors sections offered through the colleges but have a range of different distinctive profiles relative to other departmental courses, sometimes they have fewer students, they may use different source materials, or cover the subject matter in a modified way. If a course is not one of these two options, it will be designated as Not Honors.
|
VARCHAR2(63)
|
|
|
|
|
ID
|
Student_NUID
|
Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent.
|
VARCHAR2 (10 CHAR)
|
|
|
|
|
INSTRUCTIONAL_METHOD
|
Instructional_Method_Code
|
Delivered view field ODSMGR.MEETING_TIME.INSTRUCTION_DELIVERY_MODE is called instructional method in custom views.
|
VARCHAR2 (5 CHAR)
|
GTVINSM
|
|
|
|
INSTRUCTIONAL_METHOD_DESC
|
Instructional_Method_Desc
|
Delivered view field ODSMGR.MEETING_TIME.INSTRUCTION_DELIVERY_MODE is called instructional method in custom views.
|
VARCHAR2 (255)
|
|
|
|
|
INSTRUCTOR_HR_DEPT
|
|
Currently Under Review
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
INSTRUCTOR_HR_DEPT_DESC
|
|
Department descriptions differ in Fall 2011/Spring 2012 due to PeopleSoft conversion. Use department code rather than description when pulling data during this crossover time.
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
INSTRUCTOR_HR_DIV
|
|
Currently Under Review
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
INSTRUCTOR_HR_DIV_DESC
|
|
Currently Under Review
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
INSTRUCTOR_JOB_GRADE
|
Instructor_Job_Grade
|
The employee identifier which indicates broad job function and hierarchy within that function.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
INSTRUCTOR_ROLE
|
|
Instructor's Role as one of Staff, faculty, SGA
|
VARCHAR2 (9 CHAR)
|
|
|
|
|
LAST_NAME
|
Student_Last_Name
|
The last name by which a person is known.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
MAJOR
|
Primary_Major_Code
|
This field identifies the primary major within the
primary curriculum for the effective term.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
MAJOR_DESC
|
Primary_Major_Desc
|
Description for Major
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
MAXIMUM_ENROLLMENT
|
Maximum_Enrollment
|
Sets the maximum enrollment for a course section.
|
NUMBER (5)
|
|
|
|
|
MEETING_TIME
|
Meeting_Time
|
Indicates the day(s) and time(s) this class meets.
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
MIDDLE_NAME
|
Student_Middle_Name
|
A secondary name given to an individual at birth, baptism, another naming ceremony, or through legal change.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
OFFERING_NUMBER
|
Course_Section_Number
|
Course section number.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
PERSON_UID
|
Student_PIDM
|
System generated Banner unique ID which gets assigned to all person and non-person records within Banner.
|
NUMBER(8)
|
|
|
|
|
POA_CODE
|
Student_POA_Code
|
Latest pattern of attendance over time.
|
VARCHAR2 (8 CHAR)
|
|
|
|
|
POA_DESC
|
Student_POA_Desc
|
POA Code description
|
VARCHAR2 (200 CHAR)
|
|
|
|
|
POSITION_EMPL_CLASS
|
|
Business Definition
Employee class code. Organizes position information consistent with employee groupings. At the employee level, it's used to help determine controls for benefits, leave, payroll and self-service rules.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
POSITION_EMPL_CLASS_DESC
|
|
Business Definition
Employee class description.
|
VARCHAR2(255 CHAR)
|
|
|
|
|
PRIMARY_INSTRUCTOR_FIRST_NAME
|
Primary_Instructor_First_Name
|
This field identifies instructor's first name.
|
VARCHAR2 (60 CHAR)
|
|
|
|
|
PRIMARY_INSTRUCTOR_ID
|
Primary_Instructor_NUID
|
Primary instructor NUID
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
PRIMARY_INSTRUCTOR_LAST_NAME
|
Primary_Instructor_Last_Name
|
This field identifies instructor's last name.
|
VARCHAR2 (60 CHAR)
|
|
|
|
|
PROGRAM
|
Primary_Program_Code
|
Classification of academic breakdown defined as a primary combination of program, student level, course, degree, and level. May also contain majors, minors, and concentrations.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
PROGRAM_DESC
|
Primary_Program_Desc
|
Description for Program
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
REGISTERED_IND
|
Registered_Indicator
|
Business Definition
Indicates whether the student is registered for the current academic period.
Business Logic
If no Registration record exists for the current term
AND
No Academic History record exists for the current term then assign Registered Indicator code N (Not Registered).
If a Registration record exists for the current term
OR
An Academic History record exists for the current term then assign Registered Indicator code Y (Registered).
Valid Values
Y
N
|
VARCHAR2 (1 CHAR)
|
|
|
|
|
REGISTRATION_STATUS
|
Registration_Status_Code
|
Course registration status associated with this section.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
REGISTRATION_STATUS_DATE
|
Registration_Status_Date
|
Date associated with the course registration status of this section.
|
DATE
|
|
|
|
|
REGISTRATION_STATUS_DESC
|
Registration_Status_Desc
|
Description for course registration status.
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
SCHEDULE_ATTRIBUTE1
|
|
Business Definition
Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
SCHEDULE_ATTRIBUTE2
|
|
Business Definition
Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
SCHEDULE_ATTRIBUTE3
|
|
Business Definition
Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
SCHEDULE_ATTRIBUTE4
|
|
Business Definition
Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
SCHEDULE_ATTRIBUTE5
|
|
Business Definition
Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
SCHEDULE_ATTRIBUTE_DESC1
|
|
Business Definition
Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC.
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
SCHEDULE_ATTRIBUTE_DESC2
|
|
Business Definition
Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC.
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
SCHEDULE_ATTRIBUTE_DESC3
|
|
Business Definition
Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC.
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
SCHEDULE_ATTRIBUTE_DESC4
|
|
Business Definition
Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC.
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
SCHEDULE_ATTRIBUTE_DESC5
|
|
Business Definition
Identifies one of many possible Scheduling Attributes to be tracked for detailed information pertaining to course/section for requirements and used for reporting groups of courses for curriculum purposes in a timely correlated with course record . Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for Scheduling 1 and Attribute 2 for Scheduling 2 ETC.
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
SCHEDULE_TYPE
|
Schedule_Type_Code
|
Instructional delivery methods authorized for a course. Each course must be authorized to be offered for at least one schedule type. An unlimited number of schedule types can be authorized for a course (i.e., lecture, lab, internet, correspondence, etc.).
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
SCHEDULE_TYPE_DESC
|
Schedule_Type_Desc
|
Description for Schedule type.
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
STATUS
|
Section_Status_Code
|
Current course section status as one of active or cancelled.
|
VARCHAR2 (63 CHAR)
|
STVSSTS
|
|
|
|
STATUS_DESC
|
Section_Status_Desc
|
Description for Status
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
STUDENT_ATTRIBUTE_CONCAT
|
Student_Attribute_Concat
|
A concatenation of the student attributes. Attribute concatenation begins with 201425 academic term freeze.
|
VARCHAR2(63 CHAR)
|
|
|
|
|
STUDENT_ATTRIBUTE_CONCAT_DESC
|
Student_Attribute_Concat_Desc
|
A concatenation of the student attributes. Attribute concatenation begins with 201425 academic term freeze.
|
VARCHAR2(255 CHAR)
|
|
|
|
|
STUDENT_ATTRIBUTE_DESC_NU1
|
Student_Attribute_Desc_Nu_1
|
Description for Student Attribute Nu1
|
VARCHAR2 (100 CHAR)
|
|
|
|
|
STUDENT_ATTRIBUTE_DESC_NU2
|
Student_Attribute_Desc_Nu_2
|
Description for Student Attribute Nu2
|
VARCHAR2 (100 CHAR)
|
|
|
|
|
STUDENT_ATTRIBUTE_DESC_NU3
|
Student_Attribute_Desc_Nu_3
|
Description for Student Attribute Nu3
|
VARCHAR2 (50 CHAR)
|
|
|
|
|
STUDENT_ATTRIBUTE_DESC_NU4
|
Student_Attribute_Desc_Nu_4
|
Description for Student Attribute Nu4
|
VARCHAR2 (100 CHAR)
|
|
|
|
|
STUDENT_ATTRIBUTE_DESC_NU5
|
Student_Attribute_Desc_Nu_5
|
Description for Student Attribute Nu5
|
VARCHAR2 (100 CHAR)
|
|
|
|
|
STUDENT_ATTRIBUTE_NU1
|
Student_Attribute_Nu_1
|
Identifies one of many possible student attributes to be tracked for the person and used for reporting groups of students timely correlated with student record (some attribute stay with a student forever, while others come and go on a nightly basis). Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for StudentA and Attribute2 for StudentB.
StudentA - Attribute1: HONA
StudentA - Attribute2: TSHP
StudentB - Attribute1: TSHP
StudentB - Attribute2: HONA
|
VARCHAR2 (50 CHAR)
|
|
|
|
|
STUDENT_ATTRIBUTE_NU2
|
Student_Attribute_Nu_2
|
Identifies one of many possible student attributes to be tracked for the person and used for reporting groups of students timely correlated with student record (some attribute stay with a student forever, while others come and go on a nightly basis). Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for StudentA and Attribute2 for StudentB.
StudentA - Attribute1: HONA
StudentA - Attribute2: TSHP
StudentB - Attribute1: TSHP
|
VARCHAR2 (50 CHAR)
|
|
|
|
|
STUDENT_ATTRIBUTE_NU3
|
|
Identifies one of many possible student attributes to be tracked for the person and used for reporting groups of students timely correlated with student record (some attribute stay with a student forever, while others come and go on a nightly basis). Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for StudentA and Attribute2 for StudentB. StudentA - Attribute1: HONA StudentA - Attribute2: TSHP StudentB - Attribute1: TSHP StudentB - Attribute2: HONA
|
VARCHAR2(50 CHAR)
|
|
|
|
|
STUDENT_ATTRIBUTE_NU4
|
Student_Attribute_Nu_4
|
Identifies one of many possible student attributes to be tracked for the person and used for reporting groups of students timely correlated with student record (some attribute stay with a student forever, while others come and go on a nightly basis). Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for StudentA and Attribute2 for StudentB.
StudentA - Attribute1: HONA
StudentA - Attribute2: TSHP
StudentB - Attribute1: TSHP
|
VARCHAR2 (50 CHAR)
|
|
|
|
|
STUDENT_ATTRIBUTE_NU5
|
Student_Attribute_Nu_5
|
Identifies one of many possible student attributes to be tracked for the person and used for reporting groups of students timely correlated with student record (some attribute stay with a student forever, while others come and go on a nightly basis). Please note that attribute fields are not in any sequential order; same data may appear in Attribute1 for StudentA and Attribute2 for StudentB.
StudentA - Attribute1: HONA
StudentA - Attribute2: TSHP
StudentB - Attribute1: TSHP
|
VARCHAR2 (50 CHAR)
|
|
|
|
|
STUDENT_CLASSIFICATION
|
Student_Classification_Code
|
Identifies the student classification (i.e. year in school) after grades have been processed for this academic period. For example, freshman, sophomore, etc.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
STUDENT_CLASSIFICATION_DESC
|
Student_Classification_Desc
|
Description for Student classification
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
STUDENT_DEPARTMENT
|
Student_Department_Code
|
Department responsible for the student's academic study.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
STUDENT_DEPARTMENT_DESC
|
Student_Department_Desc
|
Description for Student Department
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
STUDENT_LEVEL
|
Student_Level_Code
|
This field identifies the level of the student for the effective term as one of CP(Continuing Education CPS), UP(CPS - Undergraduate), GP(CPS - Graduate), UG(Undergraduate Day), GR(Graduate Day), LW(Law), US(Undergraduate Specialty Programs), GS(Graduate Specialty Programs)
|
VARCHAR2 (63 CHAR)
|
STVLEVL
|
|
|
|
STUDENT_LEVEL_DESC
|
Student_Level_Desc
|
Description for Student Level
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
STUDENT_POPULATION
|
Student_Population_Code
|
This field identifies the student type for the effective term.
|
VARCHAR2 (63 CHAR)
|
STVSTYP
|
|
|
|
STUDENT_POPULATION_DESC
|
Student_Population_Desc
|
Description for Student population
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
STUDENT_RESIDENCY
|
Student_Residency_Code
|
Residency of the student as one of full-time, full-time international, part-time, part-time international.
|
VARCHAR2 (63 CHAR)
|
STVRESD
|
|
|
|
STUDENT_RESIDENCY_DESC
|
Student_Residency_Desc
|
Description for Student Residency
Values:
F: full-time
I: full-time international
P: part-time
J: part-time international.
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
SUBJECT
|
Course_Subject_Code
|
Main instructional subject area for this course.
|
VARCHAR2 (63 CHAR)
|
STVSUBJ
|
|
|
|
SUBJECT_DESC
|
Course_Subject_Desc
|
Description for Subject
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
SUB_ACADEMIC_PERIOD
|
SUB_ACADEMIC_PERIOD
|
Code for part of academic term in which the class takes place.
|
|
|
|
|
|
SUB_ACADEMIC_PERIOD_DESC
|
SUB_ACADEMIC_PERIOD_DESC
|
Description for SUB_ACADEMIC_PERIOD.
|
|
|
|
|
|
TITLE_LONG_DESC
|
Course_Title_Long
|
Unabbreviated class title, including some HTML coding so titles appear correctly on website.
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
TITLE_SHORT_DESC
|
Title_Short_Desc
|
Displays the course or section short title
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
WITHDRAWAL_REASON_DESC_NEU
|
Withdrawal_Reason_Desc
|
Description for Withdrawal Reason NEU
|
VARCHAR2 (255 CHAR)
|
|
|
|
|
WITHDRAWAL_REASON_NEU
|
Withdrawal_Reason_Code
|
Student's withdrawal reason, could be either voluntarily or involuntary.
|
VARCHAR2 (63 CHAR)
|
|
|
|
|
YEAR_OF_STUDY
|
Student_POA_Year_of_Study
|
Latest year if study co-related to the POA code
|
NUMBER (2)
|
|
|
|