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

SGHE Banner Operational Data Store
Reporting View Target: PROSPECT_STAFF_ASSIGNMENT

Description Contains a listing of all staff assigned to a prospect. This may be through direct staff assignment, a proposal assignment, or a prospect management contact.
Key & Frequency One row per entity per staff type per staff identifier or staff UID.
Recommended Search Columns ENTITY_UID, STAFF_TYPE

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACTIVE_STAFF_ASSIGNMENT_IND Active Staff Assignment Indicator Indicates if the staff assignment is active based upon its status and if the system date is between the start and end date of the staff assignment. CHAR(1)  

CALCULATION

CASE WHEN STAFF_ASSIGNMENT_STATUS_IND

ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

CONTACT_STAFF_IND Contact Staff Indicator Determines if the staff person has been responsible for a prospect management related contact with the prospect. (Y)es, the staff person has been responsible for a contact, (N)o, the staff person has not been responsible for a contact. VARCHAR2(1)  

FUNCTION

AOKODSF.F_GET_STAFF_INDICATOR

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

AMBPROP

AMRCONT

AMRSTAF

AMBPROP_PIDM

AMRCONT_PIDM

AMRSTAF_PIDM

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

NA

NA

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

NA

NA

PLAN_MANAGER_IND Plan Manager Indicator Determines if this staff person has ever been assigned a strategy plan for the prospect. (Y)es the staff person has been a plan manager, (N)o the staff person has not been a plan manager. VARCHAR2(1)  

FUNCTION

AOKODSF.F_GET_STAFF_INDICATOR

PRIMARY_IND Primary Indicator Determines if this staff person is the current primary staff assignment to the prospect. (Y)es, this is the current primary staff assigned, (N)o, this is not the current primary staff assigned. VARCHAR2(1)  

AMRSTAF

CONSTANT

AMRSTAF_PRIMARY_IND

'N'

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

NA

NA

PROPOSAL_STAFF_IND Proposal Staff Indicator Determines if this staff person has ever been assigned to a proposal for this prospect. (Y)es the staff person has been assigned to a proposal, (N)o the staff person has never been assigned to a proposal. VARCHAR2(1)  

FUNCTION

AOKODSF.F_GET_STAFF_INDICATOR

PROSPECT_STAFF_IND Prospect Staff Indicator Determines if the staff person exists as a direct assignment to the prospect. (Y)es, the staff person is directly assigned to the prosect, (N)o, the staff person is not directly assigned to the prospect. VARCHAR2(1)  

FUNCTION

AOKODSF.F_GET_STAFF_INDICATOR

SOLICITOR_IND Solicitor Indicator Indicates if staff person is a solicitor. VARCHAR2(1)  

AMRSTAF

CONSTANT

AMRSTAF_SOLICIT_IND

'N'

STAFF_ASSIGNMENT_END_DATE Staff Assignment End Date Staff assignment end date. DATE  

CALCULATION

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

STAFF_ASSIGNMENT_START_DATE Staff Assignment Start Date Staff assignment start date. DATE  

AMRSTAF

AMRSTAF_START_DATE

STAFF_ASSIGNMENT_STATUS_IND Staff Assignment Status Indicator Indicates if the staff assignment is (1) acitve or (0) inactive. VARCHAR2(1)  

AMRSTAF

AMRSTAF_STATUS_IND

STAFF_ASSIGN_STATUS_IND_DESC Staff Assignment Status Indicator Description Staff assignment status description. VARCHAR2(255)  

AMRSTAF

AMRSTAF_STATUS_IND

STAFF_IDEN Staff ID Staff identification code. VARCHAR2(63)  

AMBPROP

AMRCONT

AMRSTAF

AMBPROP_STAFF_IDEN_CODE

AMRCONT_IDEN_CODE

AMRSTAF_IDEN_CODE

STAFF_IDEN_NAME Staff ID Name Name of the person with primary responsibility for this prospect. VARCHAR2(255)  

GURIDEN

GURIDEN_DESC

STAFF_TYPE Staff Type Staff type code. VARCHAR2(63)  

AMRSTAF

AMRSTAF_STFT_CODE

STAFF_TYPE_DESC Staff Type Description Staff type description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

STAFF_UID Staff UID System generated, unique, internal identification number assigned to this person. NUMBER  

AMBPROP

AMRSTAF

GOBEACC

AMBPROP_STAFF_PIDM

AMRSTAF_STAFF_PIDM

GOBEACC_PIDM



Ver: 9.0