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_MOVES_MANAGEMENT

Description Contains details related to each scheduled move and each contact or follow up action associated with a prospect plan for a prospect.
Key & Frequency Multiple rows per entity per project.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ASK_AMOUNT Ask Amount Ask amount for the contact/project. NUMBER(11,2)  

AMRCONT

AMRCONT_ASK_AMT

COMPLETE_DATE_FISCAL_YEAR Completion Date Fiscal Year Unique identifier or code for the fiscal year. VARCHAR2(4)  

ATVFISC

ATVFISC_CODE

COMPLETE_DATE_FISCAL_YEAR_DESC Completion Date Fiscal Year Description Fiscal year description. VARCHAR2(30)  

FUNCTION

GOKODSF.F_GET_DESC

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

NA

SYSDATE

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

NA

NA

ENTITY_UID Entity UID System generated, unique, internal identification number assigned to this person or entity. NUMBER(8)  

AMRCONT

AMRPLAN

AMRCONT_PIDM

AMRPLAN_PIDM

ITEM_REF_NUMBER Item Reference Number Internal generated number for each contact. NUMBER(15)  

AMRCONT

AMRCONT_ITEM_REFNO

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

NA

NA

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

NA

NA

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

AMRCONT

AMRPLAN

AMRCONT_MOVE_CODE

AMRPLAN_MOVE_CODE

MOVE_COMPLETION_DATE Move Completion Date Date the planned or unplanned move was completed. DATE  

AMRCONT

AMRCONT_CONTACT_DATE

MOVE_DESC Move Description Move code description. VARCHAR2(30)  

ATVMOVE

ATVMOVE_DESC

MOVE_INTERVAL Move Interval Number of days between the previous move and the current move. For the first move in the strategy plan, this is the number of days that should pass after the day the plan is assigned to the prospect before the move is completed. NUMBER  

AMRPLAN

AMRPLAN_WAIT_DAYS

PERSON_COMPLETED_CONTACT_IDEN Person Completed Contact ID Identification code assigned to contact. VARCHAR2(5)  

AMRCONT

AMRCONT_IDEN_CODE

PERSON_COMPLETED_CONTACT_NAME Person Completed Contact Name Name of the individual completing the contact. VARCHAR2(60)  

GURIDEN

GURIDEN_DESC

PERSON_COMPLETED_CONTACT_UID Person Completed Contact UID System generated unique internal identification number assigned to this person. NUMBER  

GOBEACC

GOBEACC_PIDM

PERSON_RESPONSIBLE_IDEN Person Responsible IDEN Staff identification code of the individual assigned as the moves manager, the person primarily responsible for completing the strategic plan. VARCHAR2(5)  

AMRCONT

AMRPLAN

AMRCONT_IDEN_CODE

AMRPLAN_IDEN_CODE

PERSON_RESPONSIBLE_IDEN_NAME Person Responsible IDEN Name Name of the individual responsible for completing the strategy plan or reponsible for the contact. VARCHAR2(60)  

GURIDEN

GURIDEN_DESC

PERSON_RESPONSIBLE_UID Person Responsible UID System generated unique internal identification number assigned to the responsible staff person. NUMBER  

GOBEACC

GOBEACC_PIDM

PLANNED_MOVE_COMPLETE_IND Planned Move Completion Indicator Determines if the move to the next constituent action was completed. VARCHAR2(1)  

CALCULATION

CONSTANT

DECODE(TO_CHAR(AMRCONT_MOVE_SEQNO),NULL,'N','Y')

N

PLANNED_MOVE_DATE Planned Move Date Date of the planned move. DATE  

AMRPLAN

AMRPLAN_PLAN_DATE

PLANNED_MOVE_DATE_SOURCE   Determines if the planned move date was changed manually by the (U)ser or by the (S)ystem during a re-scheduling function. VARCHAR2(1)  

AMRPLAN

AMRPLAN_SYS_IND

PLANNED_MOVE_DATE_SOURCE_DESC   Planned moved date source description. VARCHAR2(6)  

AMRPLAN

DECODE(AMRPLAN_SYS_IND,'S','SYSTEM','MANUAL')

PLANNED_MOVE_FISCAL_YEAR Planned Move Fiscal Year Unique identifier or code for the fiscal year. VARCHAR2(4)  

ATVFISC

ATVFISC_CODE

PLANNED_MOVE_FISCAL_YEAR_DESC Planned Move Fiscal Year Description Fiscal year description. VARCHAR2(30)  

FUNCTION

GOKODSF.F_GET_DESC

PLANNED_MOVE_IND Planned Move Indicator Determines if the move was associated to a plan (Y)es or not associated to a plan (N)o. VARCHAR2(1)  

CONSTANT

CONSTANT

N

Y

PLANNED_MOVE_IND_DESC Planned Move Indicator Description Planned move indicator description. VARCHAR2(14)  

CONSTANT

CONSTANT

PLANNED MOVE

UNPLANNED MOVE

PLAN_MANAGER_IDEN Plan Manager IDEN Staff identification code of the individual assigned as the moves manager, the person primarily responsible for completing the strategic plan. VARCHAR2(5)  

AMBPLAN

AMBPLAN_IDEN_CODE

PLAN_MANAGER_IDEN_NAME Plan Manager ID Name Moves manager name. VARCHAR2(60)  

GURIDEN

GURIDEN_DESC

PLAN_MANAGER_UID Plan Manager UID System generated unique internal identification number assigned to this person. NUMBER      
PRIMARY_PROJECT_IND Primary Project Indicator Determines if the project from the contact is related directly to the strategic plan. (Y)es the project is directly related to the plan, (N)o the project is not directly related to the plan. VARCHAR2(1)      
PRIMARY_STAFF_IDEN_CODE Primary Staff ID Code Staff identification code. VARCHAR2(5)  

ARMSTAF

AMRSTAF_IDEN_CODE

PRIMARY_STAFF_IDEN_NAME Primary Staff ID Name Name of the person with primary responsibility for this prospect as displayed on the internal person identification page. VARCHAR2(60)  

GURIDEN

GURIDEN_DESC

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

SPRIDEN

SPRIDEN_PIDM

PROJECT Project Project/interest code. VARCHAR2(6)  

AMRCONT

AMRCONT

AMRCONT

AMRCONT

AMRPLAN

AMRCONT_PROJ_CODE

AMRCONT_PROJ_CODE_2

AMRCONT_PROJ_CODE_3

AMRCONT_PROJ_CODE_4

AMRPLAN_PROJ_CODE

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

ATVPROJ

ATVPROJ_DESC

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

AMRCONT

AMRCONT_PROP_CODE

PROPOSAL_SEQUENCE_NUMBER Proposal Sequence Number Proposal code sequence number. NUMBER(3)  

AMRCONT

AMRCONT_PROP_SEQ_NO

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

AMRPLAN

AMRPLAN_ACTIVITY_DATE

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

ATVFISC

ATVFISC_CODE

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

FUNCTION

GOKODSF.F_GET_DESC

STRATEGY_PLAN Strategy Plan Strategy plan. VARCHAR2(15)  

AMRCONT

AMRPLAN

AMRCONT_STGY_PLAN

AMRPLAN_STGY_PLAN

STRATEGY_PLAN_END_DATE Strategy Plan End Date   DATE      
STRATEGY_PLAN_SEQUENCE_NUMBER Strategy Plan Sequence Number   NUMBER      
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   VARCHAR2(1)      
ZONE_VALUE Zone Value Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)  

NA

NA



Ver: