Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ACADEMIC_PERIOD
|
Academic Period
|
Represents an academic period or a portion of the academic year for which faculty feedback is being requested. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.
|
VARCHAR2(63)
|
SFBFFSC
|
SFBFFSC_TERM_CODE
|
ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
ACADEMIC_YEAR
|
Academic Year
|
Academic year associated with the academic period on this record.
|
VARCHAR2(63)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
ACADEMIC_YEAR_DESC
|
Academic Year Description
|
Academic year description.
|
VARCHAR2(255)
|
STVACYR
|
STVACYR_DESC
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
COMMENT_GRADE_ACTIVITY_DATE
|
Comment Grade Activity Date
|
System maintained date this record was created or last updated.
|
DATE
|
SFRFFST
|
SFRFFST_ACTIVITY_DATE
|
COMMENT_GRADE_ORIGIN
|
Comment Grade Origin
|
This system maintained field specifies the origin of the data.
|
VARCHAR2(63)
|
SFRFFST
|
SFRFFST_DATA_ORIGIN
|
COMMENT_GRADE_VERSION
|
Comment Grade Version
|
Optimistic lock token for SFRFFST.
|
NUMBER
|
SFRFFST
|
SFRFFST_VERSION
|
COMMENT_GRADE__USER
|
Comment Grade
|
Oracle User who created or updated the record.
|
VARCHAR2(63)
|
SFRFFST
|
SFRFFST_USER_ID
|
COURSE_IDENTIFICATION
|
Course ID
|
Course subject and course number combined.
|
VARCHAR2(63)
|
CALCULATION
|
SFRSTCR_SUBJ_CODE||SFRSTCR_CRSE_NUMB
|
COURSE_NUMBER
|
Course Number
|
Course number associated with the subject for the course.
|
VARCHAR2(63)
|
SSBSECT
|
SSBSECT_CRSE_NUMB
|
COURSE_REFERENCE_NUMBER
|
Course Reference Number
|
The course number of the course the student has been registered.
|
VARCHAR2(63)
|
SFRFFST
|
SFRFFST_CRN
|
COURSE_SECTION_NUMBER
|
Course Section Number
|
Sequence number used to associate the information about the unique course for the student.
|
VARCHAR2(63)
|
SSBSECT
|
SSBSECT_SEQ_NUMB
|
FEEDBACK_ADD_COMMENT_IND
|
Feedback Additional Comment Indicator
|
Indicates a faculty member may enter free-form comment in addition to recording issues and recommendations. When set to Yes, the entry of text is permitted for the feedback session.
|
VARCHAR2(1)
|
SFBFFSC
|
SFBFFSC_ADD_COMMENTS_FLAG
|
FEEDBACK_ADD_RECOMMENDS_IND
|
Feedback Additional Recommends Indicator
|
Indicates faculty member may provide recommendations to mitigate issues or concerns entered. When set to Yes for the feedback session, feedback types defined as recommendations are permitted. When set to No for the feedback session only feedback types identified as issues may be entered.
|
VARCHAR2(1)
|
SFBFFSC
|
SFBFFSC_ADD_RECOMMENDS_FLAG
|
FEEDBACK_COMMENT
|
Feedback Comment
|
Faculty member free-form text overall comment entered for this feedback session for this course reference number in this academic period.
|
VARCHAR2(4000)
|
SFRFFST
|
SFRFFST_COMMENTS
|
FEEDBACK_DETAIL_EXISTS_IND
|
Feedback Detail Exists Indicator
|
Indicates the student has faculty feedback for this feedback session, academic period and course reference number.
|
VARCHAR2(1)
|
FUNCTION
|
DECODE((SELECT COUNT (*) FROM MST_FACULTY_FEEDBACK_DETAIL FD WHERE FD.PERSON_UID = F.PERSON_UID AND FD.ACADEMIC_PERIOD = F.ACADEMIC_PERIOD AND FD.COURSE_REFERENCE_NUMBER = F.COURSE_REFERENCE_NUMBER),0, 'N','Y')
|
FEEDBACK_ESTIMATED_GRADE
|
Feedback Estimated Grade
|
Faculty member's estimated grade for the student in this feedback session for this course reference number in this academic period.
|
VARCHAR2(63)
|
SFRFFST
|
SFRFFST_GRDE_CODE
|
FEEDBACK_SESSION_ACTIVITY_DATE
|
Feedback Session Activity Date
|
System maintained field specifies the date this record was created or last updated.
|
DATE
|
SFBFFSC
|
SFBFFSC_ACTIVITY_DATE
|
FEEDBACK_SESSION_DESC
|
Feedback Session Description
|
Feedback session short description
|
VARCHAR2(255)
|
SFBFFSC
|
SFBFFSC_DESCRIPTION
|
FEEDBACK_SESSION_END_DATE
|
Feedback Session End Date
|
The date after which no more feedback can be provided.
|
DATE
|
SFBFFSC
|
SFBFFSC_END_DATE
|
FEEDBACK_SESSION_KEY
|
Feedback Session KEY
|
System generated, unique, internal identification number assigned to this feedback session that may be assigned to course reference numbers within the academic period.
|
NUMBER
|
SFBFFSC
|
SFBFFSC_SURROGATE_ID
|
FEEDBACK_SESSION_ORIGIN
|
Feedback Session Origin
|
This system maintained field specifies the origin of the data.
|
VARCHAR2(63)
|
SFBFFSC
|
SFBFFSC_DATA_ORIGIN
|
FEEDBACK_SESSION_START_DATE
|
Feedback Session Start Date
|
The date within a term from which faculty can start providing feedback
|
DATE
|
SFBFFSC
|
SFBFFSC_START_DATE
|
FEEDBACK_SESSION_SUSPEND_IND
|
Feedback Session Suspend Indicator
|
Indicates this feedback session has been suspended and no faculty feedback is permitted. When this is set to Yes the faculty may not enter any additional feedback types, comments nor estimated grades for the feedback session.
|
VARCHAR2(1)
|
SFBFFSC
|
SFBFFSC_SUSPEND_FEEDBACK_IND
|
FEEDBACK_SESSION_USER
|
Feedback Session User
|
Oracle User who created or updated the record.
|
VARCHAR2(63)
|
SFBFFSC
|
SFBFFSC_USER_ID
|
FEEDBACK_SESSION_VERSION
|
Feedback Session Version
|
Optimistic lock token for SFBFFSC.
|
NUMBER
|
SFBFFSC
|
SFBFFSC_VERSION
|
FEEDBACK_STATUS
|
Feedback Status
|
Feedback status that identifies the feedback is require or monitored = 'M', optional = 'O', completed = 'C'. Completed is used when feedback is recorded for the faculty member and course reference number for this student in the academic period and feedback session.
|
VARCHAR2(63)
|
SFRFFST
|
SFRFFST_STATUS_CDE
|
FEEDBACK_STATUS_DESC
|
Feedback Status Description
|
Feedback status short description or code
|
VARCHAR2(255)
|
CALCULATION
|
CASE SFRFFST_STATUS_CDE WHEN
|
ID
|
ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_ID
|
INSTRUCTOR_ID
|
Instructor ID
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
VARCHAR2(63)
|
SPRIDEN
|
SPRIDEN_ID
|
INSTRUCTOR_NAME
|
Instructor Name
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
F_FORMAT_NAME
|
INSTUCTOR_UID
|
Instuctor UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
SFRFFST
|
SFRFFST_FACULTY_PIDM
|
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
|
F_FORMAT_NAME
|
PERSON_GRADE_COMMENT_KEY
|
Person Grade Comment KEY
|
System generated, unique, internal identification number assigned to the estimated grade and or comment entered by the faculty member for the student in this academic period and course reference number combination.
|
NUMBER
|
SFRFFST
|
SFRFFST_SURROGATE_ID
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
SFRFFST
|
SFRFFST_STUDENT_PIDM
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
SUBJECT
|
Subject
|
Main instructional subject area for this course.
|
VARCHAR2(63)
|
SSBSECT
|
SSBSECT_SUBJ_CODE
|
SUBJECT_DESC
|
Subject Description
|
Subject code description.
|
VARCHAR2(255)
|
STVSUBJ
|
STVSUBJ_DESC
|
SUB_ACADEMIC_PERIOD
|
Sub Academic Period
|
A session, portion or part of the academic period.
|
VARCHAR2(63)
|
SFRSTCR
|
SFRSTCR_PTRM_CODE
|
SUB_ACADEMIC_PERIOD_DESC
|
Sub Academic Period Description
|
Sub academic period description.
|
VARCHAR2(255)
|
STVPTRM
|
STVPTRM_DESC
|