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

SGHE Banner Operational Data Store
Composite View Target: AA_CON_CONF_COMMENT_SUBJ

Description Contains subject tag indexing for prospect confidential comments. This is to be used with PROSPECT_CONFIDENTIAL_COMMENT to aid in filtering comments by keyword.
Key & Frequency One occurrence per entity uid per comment group sequence number per staff iden per comment subject.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
COMMENT_GROUP_SEQUENCE One-up system assigned number used to sequence comments for the constitutent.    

APRSUBJ

APRSUBJ_GRP_SEQ_NO

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

APRSUBJ

APRSUBJ_SUBJ_CODE

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

APRSUBJ

APRSUBJ_ACTIVITY_DATE

 
COMMENT_SUBJECT_DESC Subject index code (keyword) description.    

GTVSUBJ

GTVSUBJ_DESC

 
COMMENT_SUBJECT_USER_ID Unique identification code of the user who entered or last updated the constituent comment subject index.    

APRSUBJ

APRSUBJ_USER

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

NA

NA

 
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity.    

APRSUBJ

APRSUBJ_PIDM

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

NA

NA

 
MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
STAFF_IDEN Abbreviation that uniquely identifies the user.    

APRSUBJ

APRSUBJ_IDEN_CODE

 
STAFF_IDEN_NAME Name of the person who made the comment.    

GURIDEN

GURIDEN_IDEN_DESC

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

NA

NA

 


Ver: 8.3