| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
|
ACADEMIC_PERIOD
|
Academic Period
|
Academic period or time frame this advisor is assigned to this student.
|
VARCHAR2(63)
|
|
SGRADVR
|
SGRADVR_TERM_CODE_EFF
|
|
ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
Academic period description.
|
VARCHAR2(63)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ACADEMIC_PERIOD_START1
|
Academic Period Start 1
|
Academic period this advisor was first assigned to this student.
|
VARCHAR2(63)
|
|
SGRADVR
|
SGRADVR_TERM_CODE_EFF
|
|
ACADEMIC_PERIOD_START2
|
Academic Period Start 2
|
Academic period this advisor was first assigned to this student.
|
VARCHAR2(63)
|
|
SGRADVR
|
SGRADVR_TERM_CODE_EFF
|
|
ACADEMIC_PERIOD_START_DESC1
|
Academic Period Start Description 1
|
Academic period description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ACADEMIC_PERIOD_START_DESC2
|
Academic Period Start Description 2
|
Academic period description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
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
|
|
ADVISOR_FIRST_NAME1
|
Advisor First Name 1
|
Advisor's current first name.
|
VARCHAR2(63)
|
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
ADVISOR_FIRST_NAME2
|
Advisor First Name 2
|
Advisor's current first name.
|
VARCHAR2(63)
|
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
ADVISOR_LAST_NAME1
|
Advisor Last Name 1
|
Advisor's current last name.
|
VARCHAR2(63)
|
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
ADVISOR_LAST_NAME2
|
Advisor Last Name 2
|
Advisor's current last name.
|
VARCHAR2(63)
|
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
ADVISOR_TYPE1
|
Advisor Type 1
|
Type of advisor assignment. Advisor is for academic, tutorial, thesis specific assignments.
|
VARCHAR2(63)
|
|
SGRADVR
|
SGRADVR_ADVR_CODE
|
|
ADVISOR_TYPE2
|
Advisor Type 2
|
Type of advisor assignment. Advisor is for academic, tutorial, thesis specific assignments.
|
VARCHAR2(63)
|
|
SGRADVR
|
SGRADVR_ADVR_CODE
|
|
ADVISOR_TYPE_DESC1
|
Advisor Type Description 1
|
Advisor type description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ADVISOR_TYPE_DESC2
|
Advisor Type Description 2
|
Advisor type description.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
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
|
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
|
SGRADVR
|
SGRADVR_PIDM
|
|
PRIMARY_ADVISOR_IND1
|
Primary Advisor Indicator 1
|
Indicates whether this is the primary advisor.
|
VARCHAR2(1)
|
|
SGRADVR
|
SGRADVR_PRIM_IND
|
|
PRIMARY_ADVISOR_IND2
|
Primary Advisor Indicator 2
|
Indicates whether this is the primary advisor.
|
VARCHAR2(1)
|
|
SGRADVR
|
SGRADVR_PRIM_IND
|
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA
|
NA
|