Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Advancement Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AA_DESIGNATION_COMMENT_SUBJ

Description Source composite view provides reporting on comment tags associated with a designation comment.
Key & Frequency One occurrence per designation per comment group sequence number per staff iden per comment tag.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
COMMENT_GROUP_SEQUENCE Comment Group Sequence One-up system assigned number used to sequence comments for the designation. NUMBER(15)  

ADRSUBJ

ADRSUBJ_GRP_SEQ_NO

COMMENT_SUBJECT   Subject index code (keyword) associated with the comment. VARCHAR2(6)  

ADRSUBJ

ADRSUBJ_SUBJ_CODE

COMMENT_SUBJECT_ACTIVITY_DATE Activity Date Date information for this record in the table was entered or last updated. DATE  

ADRSUBJ

ADRSUBJ_ACTIVITY_DATE

COMMENT_SUBJECT_DESC   Subject index code (keyword) description. VARCHAR2(30)      
COMMENT_SUBJECT_USER_ID   Unique identification code of the user who entered or last updated the designation comment tag. VARCHAR2(30)  

ADRSUBJ

ADRSUBJ_USER

CURRENT_DATE Current Date System current date (sysdate) or date the data was extracted. DATE  

NA

SYSDATE

DESIGNATION Designation User defined code for a designation. VARCHAR2(10)  

ADRSUBJ

ADRSUBJ_DESG

DOMAIN_VALUE Domain Value Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)  

NA

NA

MIF_DESC MIF Description Institution description for the record when the optional multi-institution facility feature has been applied. VARCHAR2(30)  

NA

NA

MIF_VALUE MIF Value Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)  

NA

NA

STAFF_IDEN Staff ID Abbreviation that uniquely identifies the user. VARCHAR2(5)  

ADRSUBJ

ADRSUBJ_IDEN_CODE

ZONE_VALUE Zone Value Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)  

NA

NA



Ver: