Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
ENTITY_UID	Entity UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER		AMRPROP	AMRPROP_PIDM
ID	ID	Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent.	VARCHAR2(63)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
PROJECT_ASSIGNED_PROSPECT_IND	Project Assigned Prospect Indicator	Determines if the project was assigned to the prospect. (Y)es, the project was assigned to the prospect, (N)o, the project was not assigned to the prospect.	VARCHAR2(1)		FUNCTION	AOKODSF.F_GET_PROJ_ASSIGN_PROS_IND(AMRPROP_PIDM, AMRPROP_PROJ_CODE)
PROJECT_GIVING_VEHICLE	Project Giving Vehicle	Giving vehicle for the proposal's project.	VARCHAR2(63)		AMRPROP	AMRPROP_GIVH_CODE
PROJECT_GIVING_VEHICLE_DESC	Project Giving Vehicle Description	Proposal's project giving vehicle code description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
PROJECT_RESULT_EXISTS_IND	Project Result Exists IND	Indicates whether the proposal project has a result recorded.	VARCHAR2(4000)		FUNCTION	MAKFUNC.F_PROPOSAL_RESULT_EXISTS
PROJECT_TARGET_ASK_AMOUNT	Project Target Ask Amount	Targeted ask amount for the proposal's project.	NUMBER		AMRPROP	AMRPROP_TARGET_ASK_AMOUNT
PROJECT_TARGET_ASK_DATE	Project Target Ask Date	Date by which the target ask amount will be solicited for the proposal's project.	DATE		AMRPROP	AMRPROP_TARGET_ASK_DATE
PROJECT_TOTAL_RESULT	Project Total Result	Total of all result values for the proposal project.	NUMBER		FUNCTION	MAKFUNC.F_SUM_PROPOSAL_RESULT
PROPOSAL	Proposal	Proposal code associated with the prospect.	VARCHAR2(63)		AMRPROP	AMRPROP_PROP_CODE
PROPOSAL_ACTIVE_IND	Proposal Active Indicator	Proposal status active indicator. Determines if the status is active (Y)es, or inactive (N)o.	VARCHAR2(1)		ATVPRST	ATVPRST_ACTIVE_IND
PROPOSAL_DESC	Proposal Description	Prospect's proposal code description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
PROPOSAL_PROJECT	Proposal Project	Project code associated with the proposal.	VARCHAR2(63)		AMRPROP	AMRPROP_PROJ_CODE
PROPOSAL_PROJECT_ACTIVE_IND	Proposal Project Active Indicator	Proposal's project status active indicator. Determines if the project status is active (Y)es, or inactive (N)o.	VARCHAR2(1)		ATVPRST	ATVPRST_ACTIVE_IND
PROPOSAL_PROJECT_ACTIVITY_DATE	Proposal Project Activity Date	Date the record was inserted or last modified.	DATE		AMRPROP	AMRPROP_ACTIVITY_DATE
PROPOSAL_PROJECT_COMMENT	Proposal Project Comment	Free-form comment regarding the proposal project.	VARCHAR2(2000)		AMRPROP	AMRPROP_PROJ_TEXT
PROPOSAL_PROJECT_DESC	Proposal Project Description	Proposal project code description.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
PROPOSAL_PROJECT_END_DATE	Proposal Project End Date	Date when the project ends for the proposal.	DATE		AMRPROP	AMRPROP_PROJ_EFF_TO_DATE
PROPOSAL_PROJECT_START_DATE	Proposal Project Start Date	Date when the project starts for the proposal.	DATE		AMRPROP	AMRPROP_PROJ_EFF_FROM_DATE
PROPOSAL_PROJECT_STATUS	Proposal Project Status	Status of the proposal's project for the prospect.	VARCHAR2(63)		AMRPROP	AMRPROP_PRST_CODE
PROPOSAL_PROJECT_STATUS_DATE	Proposal Project Status Date	Date the proposal status was created or last updated.	DATE		AMRPROP	AMRPROP_PRST_DATE
PROPOSAL_PROJECT_STATUS_DESC	Proposal Project Status Description	Status code description associated with the proposal's project.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC
PROPOSAL_PROJECT_USER_ID	Proposal Project User ID	Unique identification code of the user who entered or last updated the proposal project.	VARCHAR2(63)		AMRPROP	AMRPROP_USER
PROPOSAL_SEQUENCE_NUMBER	Proposal Sequence Number	Prospect proposal code sequence number.	NUMBER		AMRPROP	AMRPROP_PROP_SEQ_NO
PROPOSAL_STATUS	Proposal Status	Status of the proposal for the prospect.	VARCHAR2(63)		AMBPROP	AMBPROP_PRST_CODE
PROPOSAL_STATUS_DATE	Proposal Status Date	Date the proposal status was created or last updated.	DATE		AMBPROP	AMBPROP_PRST_DATE
PROPOSAL_STATUS_DESC	Proposal Status Description	Status code description associated with the proposal.	VARCHAR2(255)		FUNCTION	GOKODSF.F_GET_DESC

Ver: 9.0