Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
ACADEMIC_PERIOD
|
Academic Period
|
Academic period or time frame associated with this instructional assignment record.
|
VARCHAR2(63)
|
|
SIRASGN
|
SIRASGN_TERM_CODE
|
ACTIVITY_DATE
|
Activity Date
|
Date record was inserted or updated
|
DATE
|
|
NA
|
SYSDATE
|
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_REFERENCE_NUMBER
|
Course Reference Number
|
Computer assigned internal unique number for the schedule offering.
|
VARCHAR2(5)
|
|
SIRASGN
|
SIRASGN_CRN
|
INSTRUCTOR_FIRST_NAME2
|
Instructor First Name 2
|
Instructor's first name.
|
VARCHAR2(63)
|
|
SPRIDEN
|
SPRIDEN_FIRST_NAME
|
INSTRUCTOR_FIRST_NAME3
|
Instructor First Name 3
|
Instructor's first name.
|
VARCHAR2(63)
|
|
SPRIDEN
|
SPRIDEN_FIRST_NAME
|
INSTRUCTOR_ID2
|
Instructor ID 2
|
Instructor's ID number.
|
VARCHAR2(63)
|
|
SPRIDEN
|
SPRIDEN_ID
|
INSTRUCTOR_ID3
|
Instructor ID 3
|
Instructor's ID number.
|
VARCHAR2(63)
|
|
SPRIDEN
|
SPRIDEN_ID
|
INSTRUCTOR_LAST_NAME2
|
Instructor Last Name 2
|
Instructor's current last name.
|
VARCHAR2(63)
|
|
CALCULATION
|
NVL(SPRIDEN_LAST_NAME,'STAFF')
|
INSTRUCTOR_LAST_NAME3
|
Instructor Last Name 3
|
Instructor's current last name.
|
VARCHAR2(63)
|
|
CALCULATION
|
NVL(SPRIDEN_LAST_NAME,'STAFF')
|
INSTRUCTOR_MIDDLE_NAME2
|
Instructor Middle Name 2
|
Instructor's middle name.
|
VARCHAR2(63)
|
|
SPRIDEN
|
SPRIDEN_MI
|
INSTRUCTOR_MIDDLE_NAME3
|
Instructor Middle Name 3
|
Instructor's middle name.
|
VARCHAR2(63)
|
|
SPRIDEN
|
SPRIDEN_MI
|
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
|
PRIMARY_INSTRUCTOR_FIRST_NAME
|
Primary Instructor First Name
|
Instructor's first name.
|
VARCHAR2(63)
|
|
SPRIDEN
|
SPRIDEN_FIRST_NAME
|
PRIMARY_INSTRUCTOR_ID
|
Primary Instructor ID
|
Instructor's ID number.
|
VARCHAR2(63)
|
|
SPRIDEN
|
SPRIDEN_ID
|
PRIMARY_INSTRUCTOR_LAST_NAME
|
Primary Instructor Last Name
|
Instructor's current last name.
|
VARCHAR2(63)
|
|
CALCULATION
|
NVL(SPRIDEN_LAST_NAME,'STAFF')
|
PRIMARY_INSTRUCTOR_MIDDLE_NAME
|
Primary Instructor Middle Name
|
Instructor's middle name.
|
VARCHAR2(63)
|
|
CALCULATION
|
NVL(SPRIDEN_MI,'STAFF')
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA
|
NA
|