Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
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(8)		AMBPROP	AMBPROP_PIDM
MIF_DESC		Institution description for the record when the optional multi-institution facility feature has been applied for this table/column.	VARCHAR2(30)		NA	NA
MIF_VALUE		Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
PROPOSAL		Proposal code associated to the prospect.	VARCHAR2(6)		AMBPROP	AMBPROP_PROP_CODE
PROPOSAL_ACTIVE_IND		Indicates whether the proposal is active.	VARCHAR2(1)		AMBPROP	AMBPROP_PRST_CODE
PROPOSAL_ACTIVITY_DATE		Date the record was inserted or last modified.	DATE		AMRPROP	AMRPROP_ACTIVITY_DATE
PROPOSAL_ASK_AMOUNT		Ask amount for the proposal for this prospect.	NUMBER(11, 2)		AMRPROP	AMRPROP_TARGET_ASK_AMOUNT
PROPOSAL_COMMENT		Free format column for entry of proposal comments.	CLOB		AMBPROP	AMBPROP_COMMENT
PROPOSAL_DESC		Proposal code description associated with the prospect.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
PROPOSAL_DUE_DATE		Due date of the proposal.	DATE		AMBPROP	AMBPROP_DUE_DATE
PROPOSAL_PROJECT		Project code associated to the proposal.	VARCHAR2(6)		AMRPROP	AMRPROP_PROJ_CODE
PROPOSAL_PROJECT_DESC		Proposal project code description associated to the prospect project.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
PROPOSAL_PROJ_EFF_FROM_DATE		Begin date that project 1 is effective.	DATE		AMRPROP	AMRPROP_PROJ_EFF_FROM_DATE
PROPOSAL_PROJ_EFF_TO_DATE		End date that project 1 is effective.	DATE		AMRPROP	AMRPROP_PROJ_EFF_TO_DATE
PROPOSAL_PROJ_GIVH		Giving vehicle code for the proposal/project 1.	VARCHAR2(2)		AMRPROP	AMRPROP_GIVH_CODE
PROPOSAL_PROJ_GIVH_DESC		Giving vehicle code description for the proposal/project 1.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
PROPOSAL_SEQUENCE_NUMBER	Proposal Sequence Number	Prospect proposal code sequence number.	NUMBER(3)		AMRPROP	AMRPROP_PROP_SEQ_NO
PROPOSAL_STAFF_ID		Staff identification code.	VARCHAR2(40)
PROPOSAL_STAFF_NAME		Name of the staff member.	VARCHAR2(30)
PROPOSAL_STATUS		Status code of the proposal for the prospect.	VARCHAR2(6)		AMBPROP	AMBPROP_PRST_CODE
PROPOSAL_STATUS_DATE		Date of the proposal status for the prospect.	DATE		AMBPROP	AMBPROP_PRST_DATE
PROPOSAL_STATUS_DESC		Status code description associated with the proposal.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: