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

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 Definition Database Data Type Source Name Source Column Local Source Local Target
ASK_AMOUNT Ask amount for the contact/project. NUMBER

AMRCONT

AMRCONT_ASK_AMT

NO

NO
COMPLETE_DATE_FISCAL_YEAR Unique identifier or code for the fiscal year. VARCHAR2(4)

ATVFISC

ATVFISC_CODE

NO

NO
COMPLETE_DATE_FISCAL_YEAR_DESC Fiscal year description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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 entity. NUMBER

AMRCONT

AMRPLAN

AMRCONT_PIDM

AMRPLAN_PIDM

NO

NO

NO
ITEM_REF_NUMBER Internal generated number for each contact. NUMBER

AMRCONT

AMRCONT_ITEM_REFNO

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

NO

NO

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

AMRCONT

AMRCONT_CONTACT_DATE

NO

NO
MOVE_DESC Move code description. VARCHAR2(30)

ATVMOVE

ATVMOVE_DESC

NO

NO
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
PERSON_COMPLETED_CONTACT_IDEN Identification code assigned to contact. VARCHAR2(5)

AMRCONT

AMRCONT_IDEN_CODE

NO

NO
PERSON_COMPLETED_CONTACT_NAME Name of the individual completing the contact. VARCHAR2(60)

GURIDEN

GURIDEN_DESC

NO

NO
PERSON_COMPLETED_CONTACT_UID System generated unique internal identification number assigned to this person. NUMBER

GOBEACC

GOBEACC_PIDM

NO

NO
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

NO

NO

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

GURIDEN

GURIDEN_DESC

NO

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

GOBEACC

GOBEACC_PIDM

NO

NO
PLANNED_MOVE_COMPLETE_IND 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
PLANNED_MOVE_DATE Date of the planned move. DATE

AMRPLAN

AMRPLAN_PLAN_DATE

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(6)

AMRPLAN

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

NO

NO
PLANNED_MOVE_FISCAL_YEAR Unique identifier or code for the fiscal year. VARCHAR2(4)

ATVFISC

ATVFISC_CODE

NO

NO
PLANNED_MOVE_FISCAL_YEAR_DESC Fiscal year description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
PLANNED_MOVE_IND 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. VARCHAR2(14)

CONSTANT

CONSTANT

PLANNED MOVE

UNPLANNED MOVE

NO

NO

NO
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

NO

NO
PLAN_MANAGER_IDEN_NAME Moves manager name. VARCHAR2(60)

GURIDEN

GURIDEN_DESC

NO

NO
PLAN_MANAGER_UID System generated unique internal identification number assigned to this person. NUMBER       NO
PRIMARY_PROJECT_IND 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)       NO
PRIMARY_STAFF_IDEN_CODE Staff identification code. VARCHAR2(5)

ARMSTAF

AMRSTAF_IDEN_CODE

NO

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

GURIDEN

GURIDEN_DESC

NO

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

SPRIDEN

SPRIDEN_PIDM

NO

NO
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

NO

NO

NO

NO

NO

NO
PROJECT_DESC Project/interest description. VARCHAR2(30)

ATVPROJ

ATVPROJ_DESC

NO

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

AMRCONT

AMRCONT_PROP_CODE

NO

NO
PROPOSAL_SEQUENCE_NUMBER Proposal code sequence number. NUMBER

AMRCONT

AMRCONT_PROP_SEQ_NO

NO

NO
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
START_DATE_FISCAL_YEAR Unique identifier or code for the fiscal year. VARCHAR2(4)

ATVFISC

ATVFISC_CODE

NO

NO
START_DATE_FISCAL_YEAR_DESC Fiscal year description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

NO

NO
STRATEGY_PLAN Strategy plan. VARCHAR2(15)

AMRCONT

AMRPLAN

AMRCONT_STGY_PLAN

AMRPLAN_STGY_PLAN

NO

NO

NO
STRATEGY_PLAN_END_DATE   DATE       NO
STRATEGY_PLAN_SEQUENCE_NUMBER   NUMBER       NO
STRATEGY_PLAN_START_DATE Strategy plan start date. DATE

AMBPLAN

AMBPLAN_START_DATE

NO

NO
STRATEGY_PLAN_STATUS_IND   VARCHAR2(1)       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: