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

SGHE Banner Operational Data Store
Reporting View Target: CONSTITUENT_CONTACT

Description Contains details related to each contact or follow up action with a constituent or prospect.
Key & Frequency One row per entity per contact reference item number.
Recommended Search Columns PERSON_UID

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACTIVE_PROSPECT_STRATEGY_IND Active Prospect Strategy Indicator Indicates whether the strategy plan is active based upon its status and if the system date is between the start and end date of the strategy plan. CHAR(1)  

CALCULATION

CASE WHEN STRATEGY_PLAN_STATUS_IND

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

NA

NA

ASKING_AMOUNT Asking Amount Asking amount for the contact/project. NUMBER  

AMRCONT

AMRCONT_ASK_AMT

ASK_AMOUNT2 Ask Amount 2 Second asking amount for the contact/project. NUMBER  

AMRCONT

AMRCONT_ASK_AMT_2

ASK_AMOUNT3 Ask Amount 3 Third asking amount for the contact/project. NUMBER  

AMRCONT

AMRCONT_ASK_AMT_3

ASK_AMOUNT4 Ask Amount 4 Fourth asking amount for the contact/project. NUMBER  

AMRCONT

AMRCONT_ASK_AMT_4

CALL_REPORT_COMMENT Call Report Comment Call report used to elaborate on the contact explanation. CLOB  

AMRCONT

AMRCONT_CALL_REPORT

CONTACT_COMMENT Contact Comment Comment recorded for the contact made. VARCHAR2(2000)  

AMRCONT

AMRCONT_CONTACT

CONTACT_CREATE_DATE Contact Create Date Date the contact was added. DATE  

AMRCONT

AMRCONT_CREATE_DATE

CONTACT_DATE Contact Date Date the contact was made. DATE  

AMRCONT

AMRCONT_CONTACT_DATE

CONTACT_DATE_FISCAL_YEAR Contact Date Fiscal Year Unique identifier or code for the fiscal year. VARCHAR2(63)  

ATVFISC

ATVFISC_CODE

CONTACT_DATE_FISCAL_YEAR_DESC Contact Date Fiscal Year Description Fiscal year description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

CONTACT_TYPE Contact Type Type of contact between the institution and person. VARCHAR2(63)  

AMRCONT

AMRCONT_SCNT_CODE

CONTACT_TYPE_DESC Contact Type Description Contact type description. VARCHAR2(255)  

ATVSCNT

ATVSCNT_DESC

CREATE_TICKLER_IND Create Tickler Indicator Determines if a follow-up action message is to be created. (Y)es it will be created, (N)o, it does not need to be created. VARCHAR2(1)  

AMRCONT

AMRCONT_CREATE_TICKLER

FOLLOWUP_ASSIGNEE_UID Followup Assignee UID System generated unique internal identification number assigned to this person. NUMBER  

GOBEACC

GOBEACC_PIDM

ITEM_REF_NUMBER Item Ref Number Internal generated number for each contact. NUMBER  

AMRCONT

AMRCONT_ITEM_REFNO

MESSAGES_SENT_COUNT Messages Sent Count Number of messages sent for the contact. NUMBER  

GURTKLR

GURTKLR_PIDM

MOVE Move Move code associated with a plan or associated with a contact that is not plan related. VARCHAR2(63)  

AMRCONT

AMRCONT_MOVE_CODE

MOVE_DESC Move Description Move code description. VARCHAR2(255)  

ATVMOVE

ATVMOVE_DESC

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

NA

NA

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

NA

NA

PERSON_COMPLETED_IDEN Person Completed ID Identification code assigned to contact. VARCHAR2(63)  

AMRCONT

AMRCONT_IDEN_CODE_ASGN

PERSON_COMPLETED_IDEN_NAME Person Completed ID Name Staff member name responsible for the follow-up action. VARCHAR2(255)  

GURIDEN

GURIDEN_DESC

PERSON_RESPONSIBLE_IDEN Person Responsible ID Staff identification code of the person responsible for originating and carrying out the contact. VARCHAR2(63)  

AMRCONT

AMRCONT_IDEN_CODE

PERSON_RESPONSIBLE_IDEN_NAME Person Responsible ID Name Name of the person assigned to make the contact. VARCHAR2(255)  

GURIDEN

GURIDEN_DESC

PERSON_RESPONSIBLE_UID Person Responsible UID System generated unique internal identification number assigned to this person. NUMBER  

SPRIDEN

SPRIDEN_PIDM

PERSON_UID Person UID System generated Banner unique ID which gets assigned to all person and non-person records within Banner. NUMBER  

AMRCONT

AMRCONT_PIDM

PLAN_MOVE_SEQUENCE_NUMBER Plan Move Sequence Number When populated, move sequence number determines that the move is complete because a plan is associated to the move. NUMBER  

AMRCONT

AMRCONT_MOVE_SEQ_NO

PRIMARY_STAFF_IDEN Primary Staff ID Staff identification code of the person with primary responsibility for the prospect. VARCHAR2(63)  

AMRSTAF

AMRSTAF_IDEN_CODE

PRIMARY_STAFF_IDEN_NAME Primary Staff ID Name Name of the person with primary responsibility for this prospect. VARCHAR2(255)  

GURIDEN

GURIDEN_DESC

PRIMARY_STAFF_UID Primary Staff UID System generated unique internal identification number assigned to this person. NUMBER  

GOBEACC

GOBEACC_PIDM

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

NA

NA

PROJECT Project Project/interest code. VARCHAR2(63)  

AMRCONT

AMRCONT_PROJ_CODE

PROJECT2 Project 2 Second project or interest area. VARCHAR2(63)  

AMRCONT

AMRCONT_PROJ_CODE_2

PROJECT3 Project 3 Third project or interest area. VARCHAR2(63)  

AMRCONT

AMRCONT_PROJ_CODE_3

PROJECT4 Project 4 Fourth project or interest area. VARCHAR2(63)  

AMRCONT

AMRCONT_PROJ_CODE_3

PROJECT_DESC Project Description Project/interest description. VARCHAR2(255)  

ATVPROJ

ATVPROJ_DESC

PROJECT_DESC2 Project Description 2 Second project or interest area description. VARCHAR2(255)  

ATVPROJ

ATVPROJ_DESC

PROJECT_DESC3 Project Description 3 Third project or interest area description. VARCHAR2(255)  

ATVPROJ

ATVPROJ_DESC

PROJECT_DESC4 Project Description 4 Fourth project or interest area description. VARCHAR2(255)  

ATVPROJ

ATVPROJ_DESC

PROPOSAL Proposal Proposal code associated to the prospect. VARCHAR2(63)  

AMRCONT

AMRCONT_PROP_CODE

PROPOSAL_SEQUENCE_NUMBER Proposal Sequence Number Proposal code sequence number. NUMBER  

AMRCONT

AMRCONT_PROP_SEQ_NO

PROSPECT_CONTACT_ACTIVITY_DATE Prospect Contact Activity Date Date that information for this record in the table was entered or last updated. DATE  

AMRCONT

AMRCONT_ACTIVITY_DATE

PROSPECT_CONTACT_IND Prospect Contact Indicator Identifies the constituent for the contact as a prospect (Y)es or a general constituent contact (N)o. VARCHAR2(1)  

CALCULATION

CASE(AMRCONT_GEN_CONTACT_IND)

PROSPECT_CONTACT_USER_ID Prospect Contact User ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)  

AMRCONT

AMRCONT_USER_ID

RECENT_TICKLER_STATUS Recent Tickler Status Determines the most recent follow-up action tickler status. Follow-up action is (C)omplete, Follow-up action has not yet occurred, (P)ending, Follow-up action is no longer pending, although it is still planned and on (H)old. VARCHAR2(63)  

AMRCONT

AMRCONT_TICK_STATUS

RECENT_TICKLER_STATUS_DESC Recent Tickler Status Description Recent tickler status description. VARCHAR2(255)  

MGT_VALIDATION

SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'TICKLER_STATUS' AND VALUE = RECENT_TICKLER_STATUS

STAFF_ASSIGNED_COUNT Staff Assigned Count Count of staff assigned. NUMBER  

FUNCTION

MAKFUNC.F_COUNT_STAFF_ASSIGNMENT

START_DATE_FISCAL_YEAR Start Date Fiscal Year Unique identifier or code for the fiscal year. VARCHAR2(63)  

ATVFISC

ATVFISC_CODE

START_DATE_FISCAL_YEAR_DESC Start Date Fiscal Year Description Fiscal year description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

STRATEGY_PLAN Strategy Plan Strategy plan name. VARCHAR2(63)  

AMRCONT

AMRCONT_STGY_PLAN

STRATEGY_PLAN_END_DATE Strategy Plan End Date Strategy plan end date. DATE  

CALCULATION

NVL(AMBPLAN_END_DATE,'31-DEC-2099')

STRATEGY_PLAN_SEQUENCE_NUMBER Strategy Plan Sequence Number Internal sequence number allowing multiple strategies for the strategy plan. NUMBER  

AMBPLAN

AMBPLAN_PLAN_SEQ_NO

STRATEGY_PLAN_START_DATE Strategy Plan Start Date Strategy plan start date. DATE  

AMBPLAN

AMBPLAN_START_DATE

STRATEGY_PLAN_STATUS_IND Strategy Plan Status Indicator Indicates whether the strategy plan is (1) active or (0) inactive. VARCHAR2(1)  

AMBPLAN

AMBPLAN_ACTIVE_IND

STRATEGY_PLAN_STATUS_IND_DESC Strategy Plan Status Indicator Description Strategy plan status description. VARCHAR2(255)  

AMBPLAN

AMBPLAN_STATUS_IND

TICKLER_CONFIDENTIAL_IND Tickler Confidential Indicator Determines if the follow-up message is to remain confidential. (Y)es confidential, (N)ot confidential. VARCHAR2(1)  

CALCULATION

NVL(AMRCONT_CONFID_IND)

TICKLER_DATE Tickler Date Tickler message date. DATE  

AMRCONT

AMRCONT_TICK_DATE

TICKLER_MESSAGE Tickler Message Tickler message. VARCHAR2(255)  

AMRCONT

AMRCONT_TICKLER

TOTAL_EXPENSE Total Expense Total of all expenses for the contact. NUMBER  

FUNCTION

SUM(NVL(AMRPEXP_EXPN_AMT, 0))

TOTAL_STAFF_COUNT Total Staff Count Total number of staff attending the contact visit. NUMBER  

CALCULATION

COUNT(AMRATTN_PIDM)



Ver: 9.0