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

AMRCONT

AMRCONT_ASK_AMT

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

ATVFISC

ATVFISC_CODE

COMPLETE_DATE_FISCAL_YEAR_DESC Fiscal year description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

SYSDATE

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

NA

NA

ENTITY_UID System generated, unique, internal identification number assigned to this person or entity. NUMBER

AMRCONT

AMRPLAN

AMRCONT_PIDM

AMRPLAN_PIDM

ITEM_REF_NUMBER Internal generated number for each contact. NUMBER

AMRCONT

AMRCONT_ITEM_REFNO

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

NA

NA

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

NA

NA

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 Date the planned or unplanned move was completed. DATE

AMRCONT

AMRCONT_CONTACT_DATE

MOVE_DESC Move code description. VARCHAR2(30)

ATVMOVE

ATVMOVE_DESC

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

AMRCONT

AMRCONT_IDEN_CODE

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

GURIDEN

GURIDEN_DESC

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

GOBEACC

GOBEACC_PIDM

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 Name of the individual responsible for completing the strategy plan or reponsible for the contact. VARCHAR2(60)

GURIDEN

GURIDEN_DESC

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

GOBEACC

GOBEACC_PIDM

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

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

ATVFISC

ATVFISC_CODE

PLANNED_MOVE_FISCAL_YEAR_DESC Fiscal year description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

PLANNED_MOVE_IND_DESC Planned move indicator description. VARCHAR2(14)

CONSTANT

CONSTANT

PLANNED MOVE

UNPLANNED MOVE

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 Moves manager name. VARCHAR2(60)

GURIDEN

GURIDEN_DESC

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

ARMSTAF

AMRSTAF_IDEN_CODE

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

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

SPRIDEN

SPRIDEN_PIDM

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/interest description. VARCHAR2(30)

ATVPROJ

ATVPROJ_DESC

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

AMRCONT

AMRCONT_PROP_CODE

PROPOSAL_SEQUENCE_NUMBER Proposal code sequence number. NUMBER

AMRCONT

AMRCONT_PROP_SEQ_NO

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

ATVFISC

ATVFISC_CODE

START_DATE_FISCAL_YEAR_DESC Fiscal year description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

STRATEGY_PLAN Strategy plan. VARCHAR2(15)

AMRCONT

AMRPLAN

AMRCONT_STGY_PLAN

AMRPLAN_STGY_PLAN

STRATEGY_PLAN_END_DATE   DATE    
STRATEGY_PLAN_SEQUENCE_NUMBER   NUMBER    
STRATEGY_PLAN_START_DATE Strategy plan start date. DATE

AMBPLAN

AMBPLAN_START_DATE

STRATEGY_PLAN_STATUS_IND   VARCHAR2(1)    
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

NA

NA



Ver: