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

Banner Operational Data Store
Composite View Target: AA_PROSPECT_CONF_COMMENT_SUBJ

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

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
COMMENT_GROUP_SEQUENCE One-up system assigned number used to sequence comments for the prospect. NUMBER

AMRSUBJ

AMRSUBJ_GRP_SEQ_NO

NO

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

AMRSUBJ

AMRSUBJ_SUBJ_CODE

NO

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

AMRSUBJ

AMRSUBJ_ACTIVITY_DATE

NO

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

AMRSUBJ

AMRSUBJ_USER

NO

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

NA

SYSDATE

NO

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

NA

NA

NO

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

AMRSUBJ

AMRSUBJ_PIDM

NO

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

NA

NA

NO

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

NA

NA

NO

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

AMRSUBJ

AMRSUBJ_IDEN_CODE

NO

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

NA

NA

NO

NO


Ver: