Target Column	Business Definition	Database Data Type	Source Name	Source Column
CONTACT_STAFF_IND	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
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 organization entity.	NUMBER	AMBPROP AMRCONT AMRSTAF	AMBPROP_PIDM AMRCONT_PIDM AMRSTAF_PIDM
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 for this table/column.	VARCHAR2(6)	NA	NA
PLAN_MANAGER_IND	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	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	'N' N
PROPOSAL_STAFF_IND	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	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	Indicates if staff person is a solicitor.	VARCHAR2(1)	AMRSTAF CONSTANT	AMRSTAF_SOLICIT_IND 'N'
STAFF_ASSIGNMENT_END_DATE		DATE
STAFF_ASSIGNMENT_START_DATE		DATE
STAFF_ASSIGNMENT_STATUS_IND		VARCHAR2(1)
STAFF_IDEN	Staff identification code.	VARCHAR2(5)	AMBPROP AMRCONT AMRSTAF	AMBPROP_STAFF_IDEN_CODE AMRCONT_IDEN_CODE AMRSTAF_IDEN_CODE
STAFF_IDEN_NAME	Name of the person with primary responsibility for this prospect.	VARCHAR2(30)	GURIDEN	GURIDEN_DESC
STAFF_TYPE	Staff type code.	VARCHAR2(4)	AMRSTAF	AMRSTAF_STFT_CODE
STAFF_TYPE_DESC	Staff type description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
STAFF_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	AMBPROP AMRSTAF GOBEACC	AMBPROP_STAFF_PIDM AMRSTAF_STAFF_PIDM GOBEACC_PIDM
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: