Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Advancement Reporting View Reports

Banner Operational Data Store
Reporting View Target: CAMPAIGN_COMMENT

Description Contains all comments about this campaign.
Key & Frequency Multiple occurrences per campaign.
Recommended Search Columns CAMPAIGN_TYPE
CAMPAIGN, COMMENT_SEQUENCE

Target Column Business Name Business Definition Database Data Type Business Data Type Domain Value Source Name Source Column Local Source Local Target
CAMPAIGN Campaign Campaign that the constituent has responded to with a gift or pledge payment. VARCHAR2(63)    

AFRCOMT

AFRCOMT_CAMPAIGN

NO

NO
CAMPAIGN_NAME Campaign Name Campaign name. VARCHAR2(255)    

AFBCAMP

AFBCAMP_NAME

NO

NO
CAMPAIGN_TYPE Campaign Type Type of campaign recorded. VARCHAR2(63)    

AFBCAMP

AFBCAMP_CMTP_CODE

NO

NO
CAMPAIGN_TYPE_DESC Campaign Type Description Campaign type description. VARCHAR2(255)    

ATVCMTP

ATVCMTP_DESC

NO

NO
COMMENT_SEQUENCE Comment Sequence Internal sequence number for campaign comments. NUMBER    

AFRCOMT

AFRCOMT_SEQ_NO

NO

NO
CAMPAIGN_COMMENT Campaign Comment Free-form campaign comments. VARCHAR2(255)    

AFRCOMT

AFRCOMT_COMMENT

NO

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

AFRCOMT

AFRCOMT_ACTIVITY_DATE

NO

NO
MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)    

NA

NA

NO

NO
MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)    

NA

NA

NO

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

NA

NA

NO

NO
ADMINISTRATIVE_GROUP Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)    

NA

NA

NO

NO


Ver: 9.2