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

SGHE Banner Operational Data Store
Composite View Target: AA_PROSPECT_CONF_COMMENT

Description Source composite view provides reporting on confidential comments associated with a prospect.
Key & Frequency One occurrence per prospect per comment group sequence number per staff iden.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
COMMENT_ACTIVITY_DATE Date information for this record in the table was entered or last updated.    

AMRCONF

AMRCONF_ACTIVITY_DATE

 
COMMENT_CONFIDENTIALITY_IND Indicates whether the person has requested the institution keep their comment confidential.    

CALCULATION

NVL(AMRCONF_CONFID_IND)

 
COMMENT_ENTRY_DATE Date the comment was made.    

AMRCONF

AMRCONF_ENTRY_DATE

 
COMMENT_GROUP_SEQUENCE One-up system assigned number used to sequence comments for the prospect.    

AMRCONF

AMRCONF_GRP_SEQ_NO

 
COMMENT_USER_ID Unique identification code of the user who entered or last updated the prospect comment.    

AMRCONF

AMRCONF_USER

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

NA

SYSDATE

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

NA

NA

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

AMRCONF

AMRCONF_PIDM

 
MIF_DESC Institution description for the record 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

 
PROSPECT_COMMENT Free-form comment regarding the prospect.    

FUNCTION

GOKODSF.F_TRIM_LONGS

 
STAFF_IDEN Abbreviation that uniquely identifies the user.    

AMRCONF

AMRCONF_IDEN_CODE

 
STAFF_IDEN_NAME Name of the person who made the comment.    

GURIDEN

GURIDEN_DESC

 
STAFF_IDEN_USER_ID Unique identification code belonging to the person who made the comment.    

AMRCONF

AMRCONF_USER_ID

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

NA

NA

 


Ver: 8.3