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