Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Student Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: TRANSCRIPT_COMMENT

Description Transcript Comments by Term
Key & Frequency One row per person uid per level per academic period per comment sequence number.

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period or time frame associated with the comment. VARCHAR2(63)

SHRTTCM

SHRTTCM_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

ACTIVITY_DATE Date record was inserted or updated DATE

SHRTMCM

SHRTTCM

SHRTMCM_ACTIVITY_DATE

SHRTTCM_ACTIVITY_DATE

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

COMMENT_SEQ_NUMBER Sequence number of the transcript comment. NUMBER

SHRTMCM

SHRTTCM

SHRTMCM_COMMENT_SEQ_NO

SHRTTCM_COMMENT_SEQ_NO

COMMENT_TYPE Type of comment being displayed. VARCHAR2(1)

CONSTANT

L

T

COMMENT_TYPE_DESC Comment type description. VARCHAR2(5)

CONSTANT

LEVEL

TERM

EFFECTIVE_DATE Date this comment is effective. DATE

SHRTMCM

SHRTTCM

SHRTMCM_EFFECTIVE_DATE

SHRTTCM_EFFECTIVE_DATE

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

ORIGINATOR Office/department that originated the comment. VARCHAR2(63)

SHRTMCM

SHRTTCM

SHRTMCM_ORIG_CODE

SHRTTCM_ORIG_CODE

ORIGINATOR_DESC Originator description. VARCHAR2(255)

STVORIG

STVORIG_DESC

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

SHRTMCM

SHRTTCM

SHRTMCM_PIDM

SHRTTCM_PIDM

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

STUDENT_LEVEL Student level associated with this comment. Examples include undergraduate and graduate, etc. VARCHAR2(63)

SHRTMCM

SHRTTCM

SHRTMCM_LEVL_CODE

SHRTTCM_LEVL_CODE

STUDENT_LEVEL_DESC Student level description. VARCHAR2(255)

STVLEVL

STVLEVL_DESC

TRANSCRIPT_COMMENT Free form comment pertaining to this transcript. VARCHAR2(50)

SHRTMCM

SHRTTCM

SHRTMCM_COMMENT

SHRTTCM_COMMENT



Ver: 8.0