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

Banner Operational Data Store
Reporting View Target: 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.
Recommended Search Columns ENTITY_UID

Target Column Business Name Business Definition Database Data Type Business Data Type Domain Value Source Name Source Column Local Source Local Target
ENTITY_UID Entity UID System generated, unique, internal identification number assigned to this person or entity. NUMBER    

AMRCONT

AMRPLAN

AMRCONT_PIDM

AMRPLAN_PIDM

NO

NO

NO
STRATEGY_PLAN Strategy Plan Strategy plan. VARCHAR2(63)    

AMRCONT

AMRPLAN

AMRCONT_STGY_PLAN

AMRPLAN_STGY_PLAN

NO

NO

NO
STRATEGY_PLAN_START_DATE Strategy Plan Start Date Strategy plan start date. DATE    

AMBPLAN

AMBPLAN_START_DATE

NO

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

ATVFISC

ATVFISC_CODE

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

AMBPLAN

AMBPLAN_IDEN_CODE

NO

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

GURIDEN

GURIDEN_DESC

NO

NO
PLAN_MANAGER_UID Plan Manager UID System generated unique internal identification number assigned to this person. NUMBER    

GOBEACC

GOBEACC_PIDM

NO

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

AMRCONT

AMRPLAN

AMRCONT_MOVE_CODE

AMRPLAN_MOVE_CODE

NO

NO

NO
MOVE_DESC Move Description Move code description. VARCHAR2(255)    

ATVMOVE

ATVMOVE_DESC

NO

NO
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

NO

NO

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

CONSTANT

CONSTANT

PLANNED MOVE

UNPLANNED MOVE

NO

NO

NO
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

NO

NO
PLANNED_MOVE_DATE Planned Move Date Date of the planned move. DATE    

AMRPLAN

AMRPLAN_PLAN_DATE

NO

NO
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'

NO

NO

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

AMRCONT

AMRCONT_CONTACT_DATE

NO

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

TO BE FILLED IN BY DEVELOPER

ATVFISC_CODE

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

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

AMRCONT

AMRCONT_IDEN_CODE

NO

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

GURIDEN

GURIDEN_DESC

NO

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

GOBEACC

GOBEACC_PIDM

NO

NO
ITEM_REF_NUMBER Item Reference Number Internal generated number for each contact. NUMBER    

AMRCONT

AMRCONT_ITEM_REFNO

NO

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

AMRCONT

AMRCONT_PROP_CODE

NO

NO
PROPOSAL_SEQUENCE_NUMBER Proposal Sequence Number Proposal code sequence number. NUMBER    

AMRCONT

AMRCONT_PROP_SEQ_NO

NO

NO
PROJECT Project Project/interest code. VARCHAR2(63)    

AMRCONT

AMRPLAN

AMRPLAN

AMRPLAN

AMRPLAN

AMRCONT_PROJ_CODE

AMRCONT_PROJ_CODE_2

AMRCONT_PROJ_CODE_3

AMRCONT_PROJ_CODE_4

AMRPLAN_PROJ_CODE

NO

NO

NO

NO

NO

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

ATVPROJ

ATVPROJ_DESC

NO

NO
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)    

CALCULATION

DECODE(AMRPLAN_PROJ_CODE, AMRCONT_PROJ_CODE)

NO

NO
ASK_AMOUNT Ask Amount Ask amount for the contact/project. NUMBER    

AMRCONT

AMRCONT_ASK_AMT

NO

NO
PRIMARY_STAFF_IDEN_CODE Primary Staff ID Code Staff identification code. VARCHAR2(63)    

ARMSTAF

AMRSTAF_IDEN_CODE

NO

NO
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(255)    

GURIDEN

GURIDEN_DESC

NO

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

GOBEACC

GOBEACC_PIDM

NO

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

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
PLANNED_MOVE_FISCAL_YEAR Planned Move Fiscal Year Unique identifier or code for the fiscal year. VARCHAR2(63)    

ATVFISC

ATVFISC_CODE

NO

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

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
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

NO

NO
PLANNED_MOVE_DATE_SOURCE_DESC   Planned moved date source description. VARCHAR2(255)    

AMRCONT

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

NO

NO
PERSON_RESPONSIBLE_IDEN Person Responsible IDEN Staff identification code of the person primarily responsible for completing the strategic plan or responsible for the contact. VARCHAR2(63)    

AMRCONT

GOBEACC

AMRCONT_IDEN_CODE

GOBEACC_PIDM

NO

NO

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

GURIDEN

GURIDEN_DESC

NO

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

GOBEACC

GOBEACC_PIDM

NO

NO
STRATEGY_PLAN_END_DATE Strategy Plan End Date Strategy plan end date. DATE    

CALCULATION

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

NO

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

AMBPLAN

AMBPLAN_ACTIVE_IND

NO

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

AMBPLAN

AMBPLAN_STATUS_IND

NO

NO
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

NO

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

AMBPLAN

AMBPLAN_PLAN_SEQ_NO

NO

NO


Ver: 9.2