ODS Column	ODS Business Definition	ODS Calculation Formula	ODS Data Type	Banner Source Name	Banner Source Column	Banner Form Name
ACADEMIC_PERIOD	Academic period code to be associated with information in this record.			SGRCOOP	SGRCOOP_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.			FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR	Academic year associated with the academic period.			STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC	Academic year description.			FUNCTION	GOKODSF.F_GET_DESC
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
COURSE_IDENTIFICATION	Combined subject code and course number that identifies the instructional content of this course.			CALCULATION	SCBCRSE_SUBJ_CODE||SCBCRSE_CRSE_NUMB
COURSE_REFERENCE_NUMBER	Course reference number assigned to this section or schedule offering.			SGRCOOP	SGRCOOP_CRN
EMPLOYER_CONTACT_NAME	Name of the employer contact person for this student and work experience.			SGRCOOP	SGRCOOP_EMPL_CONTACT_NAME
EMPLOYER_CONTACT_TITLE	Employer contact person's title/			SGRCOOP	SGRCOOP_EMPL_CONTACT_TITLE
EVALUATION_PREPARE_DATE	Cooperative assignment evaluation prepared date.			SGRCOOP	SGRCOOP_EVAL_PREPARED_DATE
EVALUATION_RECEIVED_DATE	Cooperative assignment evaluation received date.			SGRCOOP	SGRCOOP_EVAL_RECEIVED_DATE
FIELD_OF_INTEREST_IND	indicates if the cooperative education experience is a field of interest to the student. Value is Y or blank only.';			SGRCOOP	SGRCOOP_INTEREST_IND
ID	Person's or organization's current identification number.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.			NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.			NA	NA
NAME	Name of the person (last name, first name, middle initial) or organization.			FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_UID	System generated, unique, internal identification number assigned to this person.			SGRCOOP	SGRCOOP_PIDM
PHONE_AREA	Phone area.			SGRCOOP	SGRCOOP_PHONE_AREA
PHONE_EXT	Phone extension.			SGRCOOP	SGRCOOP_PHONE_EXT
PHONE_NUMBER	Phone number.			SGRCOOP	SGRCOOP_PHONE_NUMBER
PHONE_NUMBER_COMBINED	Combined values of the area code, phone number and phone extensions.			CALCULATION	SGRCOOP_PHONE_AREA||SGRCOOP_PHONE_NUMBER||SGRCOOP_PHONE_EXT
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.			NA	NA
SEQUENCE_NUMBER	Sequence number system assigned to the cooperative education record.			SGRCOOP	SGRCOOP_SEQ_NO
STUDENT_LEVEL	Student level associated with the course work in the academic outcome. For example, undergraduate, graduate, etc.			SGRCOOP	SGRCOOP_LEVL_CODE
STUDENT_LEVEL_DESC	Student level description.			FUNCTION	GOKODSF.F_GET_DESC
SUB_ACADEMIC_PERIOD	A session, portion or part of the academic period.			NA	NA
SUB_ACADEMIC_PERIOD_DESC	Sub academic period description.			NA	NA
WORK_END_DATE	Work experience or cooperative education experience end date.			SGRCOOP	SGRCOOP_END_DATE
WORK_EXPERIENCE_EMPLOYER	Identifies the work experience or cooperative education employer.			SGRCOOP	SGRCOOP_EMPL_CODE
WORK_EXPERIENCE_EMPLOYER_DESC	Work experience or cooperative education employer description.			STVEMPL	STVEMPL_DESC
WORK_EXPERIENCE_OVERRIDE_IND	Indicates there was an override required or given for this work experience.			SGRCOOP	SGRCOOP_OVERRIDE_IND
WORK_EXPERIENCE_TYPE	Identifies the type of cooperative education experience.			SGRCOOP	SGRCOOP_COPC_CODE
WORK_EXPERIENCE_TYPE_DESC	Cooperative education type description.			STVCOPC	STVCOPC_DESC
WORK_START_DATE	Work experience or cooperative education experience begin date.			SGRCOOP	SGRCOOP_BEGIN_DATE

Ver: 8.3