Target Column	Business Name	Business Definition	Database Data Type	Business Data Type	Domain Value	Source Name	Source Column	Local Source	Local Target
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	NO NO NO	NO
STAFF_TYPE	Staff Type	Staff type code.	VARCHAR2(63)			AMRSTAF	AMRSTAF_STFT_CODE	NO	NO
STAFF_TYPE_DESC	Staff Type Description	Staff type description.	VARCHAR2(255)			FUNCTION	GOKODSF.F_GET_DESC	NO	NO
STAFF_IDEN	Staff ID	Staff identification code.	VARCHAR2(63)			AMBPROP AMRCONT AMRSTAF	AMBPROP_STAFF_IDEN_CODE AMRCONT_IDEN_CODE AMRSTAF_IDEN_CODE	NO NO NO	NO
STAFF_IDEN_NAME	Staff ID Name	Name of the person with primary responsibility for this prospect.	VARCHAR2(255)			GURIDEN	GURIDEN_DESC	NO	NO
SOLICITOR_IND	Solicitor Indicator	Indicates if staff person is a solicitor.	VARCHAR2(1)			AMRSTAF CONSTANT	AMRSTAF_SOLICIT_IND 'N'	NO NO	NO
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'	NO NO	NO
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	NO NO NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
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	NO	NO
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)			NA	NA	NO	NO
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)			NA	NA	NO	NO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)			NA	NA	NO	NO
STAFF_ASSIGNMENT_START_DATE	Staff Assignment Start Date	Staff assignment start date.	DATE			AMRSTAF	AMRSTAF_START_DATE	NO	NO
STAFF_ASSIGNMENT_END_DATE	Staff Assignment End Date	Staff assignment end date.	DATE			CALCULATION	NVL(AMRSTAF_END_DATE,'31-DEC-2099')	NO	NO
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	NO	NO
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	NO	NO
STAFF_ASSIGN_STATUS_IND_DESC	Staff Assignment Status Indicator Description	Staff assignment status description.	VARCHAR2(255)			AMRSTAF	AMRSTAF_STATUS_IND	NO	NO

Ver: 9.2