Go To View:  RETURN TO BANNER ODS META DATA 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.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACADEMIC_PERIOD Academic period or time frame associated with the comment.    

SHRTTCM

SHRTTCM_TERM_CODE

 
ACADEMIC_PERIOD_DESC Academic period description.    

STVTERM

STVTERM_DESC

 
ACTIVITY_DATE Date record was inserted or updated    

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.    

NA

NA

 
COMMENT_SEQ_NUMBER Sequence number of the transcript comment.    

SHRTMCM

SHRTTCM

SHRTMCM_COMMENT_SEQ_NO

SHRTTCM_COMMENT_SEQ_NO

 
COMMENT_TYPE Type of comment being displayed.    

CONSTANT

CONSTANT

L

T

 
COMMENT_TYPE_DESC Comment type description.    

CONSTANT

CONSTANT

LEVEL

TERM

 
EFFECTIVE_DATE Date this comment is effective.    

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.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
ORIGINATOR Office/department that originated the comment.    

SHRTMCM

SHRTTCM

SHRTMCM_ORIG_CODE

SHRTTCM_ORIG_CODE

 
ORIGINATOR_DESC Originator description.    

STVORIG

STVORIG_DESC

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

SHRTMCM

SHRTTCM

SHRTMCM_PIDM

SHRTTCM_PIDM

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

NA

NA

 
STUDENT_LEVEL Student level associated with this comment. Examples include undergraduate and graduate, etc.    

SHRTMCM

SHRTTCM

SHRTMCM_LEVL_CODE

SHRTTCM_LEVL_CODE

 
STUDENT_LEVEL_DESC Student level description.    

STVLEVL

STVLEVL_DESC

 
TRANSCRIPT_COMMENT Free form comment pertaining to this transcript.    

SHRTMCM

SHRTTCM

SHRTMCM_COMMENT

SHRTTCM_COMMENT

 


Ver: 8.3