Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Student Reporting View Reports

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.
Recommended Search Columns PERSON_UID, COMMENT_TYPE
ACADEMIC_PERIOD, ORIGINATOR
ORIGINATOR, COMMENT_TYPE
STUDENT_LEVEL, COMMENT_TYPE
COMMENT_TYPE

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. 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)

SHRTTCM

SHRTTCM_TERM_CODE

ACADEMIC_PERIOD_DESC Academic Period Description Academic period description. VARCHAR2(255)

STVTERM

STVTERM_DESC

ACTIVITY_DATE Activity Date Date record was inserted or updated. DATE

SHRTMCM

SHRTTCM

SHRTMCM_ACTIVITY_DATE

SHRTTCM_ACTIVITY_DATE

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_SEQ_NUMBER Comment Sequence Number Sequence number of the transcript comment. NUMBER

SHRTMCM

SHRTTCM

SHRTMCM_COMMENT_SEQ_NO

SHRTTCM_COMMENT_SEQ_NO

COMMENT_TYPE Comment Type Type of comment being displayed. VARCHAR2(1)

CONSTANT

CONSTANT

L

T

COMMENT_TYPE_DESC Comment Type Description Comment type description. VARCHAR2(5)

CONSTANT

CONSTANT

LEVEL

TERM

EFFECTIVE_DATE Effective Date Date this comment is effective. DATE

SHRTMCM

SHRTTCM

SHRTMCM_EFFECTIVE_DATE

SHRTTCM_EFFECTIVE_DATE

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

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

SHRTMCM

SHRTTCM

SHRTMCM_ORIG_CODE

SHRTTCM_ORIG_CODE

ORIGINATOR_DESC Originator Description Originator description. VARCHAR2(255)

STVORIG

STVORIG_DESC

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

SHRTMCM

SHRTTCM

SHRTMCM_PIDM

SHRTTCM_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

STUDENT_LEVEL Student Level Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc. VARCHAR2(63)

SHRTMCM

SHRTTCM

SHRTMCM_LEVL_CODE

SHRTTCM_LEVL_CODE

STUDENT_LEVEL_DESC Student Level Description Student level description. VARCHAR2(255)

STVLEVL

STVLEVL_DESC

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

SHRTMCM

SHRTTCM

SHRTMCM_COMMENT

SHRTTCM_COMMENT



Ver: 9.2