Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Advancement Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: PROSPECT_INFO

Description Contains summary profile information for each identified prospect including reference information, status, target ask amount and date, primary staff assignment detail and ratings, geo-region and assigned staff counts.
Key & Frequency One row per entity.
Recommended Search Columns ENTITY_UID
ENTITY_UID, ENTITY_IND
ENTITY_IND

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

ADVANCEMENT_RATING_COUNT Count of the recruitment ratings recorded for this person. NUMBER

FUNCTION

MAKFUNC.F_ADVANCEMENT_RATING_COUNT

CONSTITUENT_CONTACT_COUNT Count of the number of counts have been made by the institution and recorded for this constituent. NUMBER

FUNCTION

MAKFUNC.F_COUNT_CONS_CONTACT

ENTITY_IND Indicates whether the entity is a person or an organization. VARCHAR2(1)

CONSTANT

'O'

'P'

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

AMRINFO

AMRINFO_PIDM

ID Person's or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

NA

NA

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

NA

NA

NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PREF_GEOGRAPHIC_REGION_COUNT Count of geographic regions associated with this address. NUMBER

FUNCTION

MGKFUNC.F_COUNT_GEOGRAPHIC_REGIONS

PREF_GEO_REGION_ADDR_TYPE Address type of the address to be used as the preferred geographic region address. VARCHAR2(63)

APBCONS

APBCONS_ATYP_CODE_GEOR

PREF_GEO_REGION_ADDR_TYPE_DESC Preferred geographic region address type. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

PRIMARY_STAFF_ASSIGN_IDEN Primary staff identification code. VARCHAR2(63)

AMRSTAF

AMRSTAF_IDEN_CODE

PRIMARY_STAFF_ASSIGN_IDEN_NAME Name of the primary staff identification code. VARCHAR2(255)

GURIDEN

GURIDEN_DESC

PRIMARY_STAFF_ASSIGN_TYPE Primary staff type code. VARCHAR2(63)

AMRSTAF

AMRSTAF_STFT_CODE

PRIMARY_STAFF_ASSIGN_TYPE_DESC Primary staff type code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

PROSPECT_AMOUNT Manually entered or system calculated prospect amount. NUMBER

AMRINFO

AMRINFO_PROSP_RATE

PROSPECT_STATUS Status. VARCHAR2(63)

AMRINFO

AMRINFO_STATUS

REFERENCE Reference code. VARCHAR2(63)

AMRINFO

AMRINFO_REFR_CODE

REFERENCE_DESC Reference code description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STAFF_ASSIGNMENT_COUNT Count of staff assignments. NUMBER

FUNCTION

MAKFUNC.F_COUNT_STAFF_ASSIGNMENT

TARGET_ASK_DATE Manually entered target asking date. DATE

AMRINFO

AMRINFO_TARGET_ASK_DATE



Ver: 8.0