Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
AGENCY_UID		System generated unique internal identification number assigned to this organization entity.	NUMBER(8)		FRBPROP	FRBPROP_AGENCY_PIDM
AGENCY_UID_LEVEL_1		Extracted agency system generated identification number hierarchy level 1.	NUMBER		FUNCTION	FOKODSF.F_AGCY_HIER
AGENCY_UID_LEVEL_2		Extracted agency system generated identification number hierarchy level 2.	NUMBER		FUNCTION	FOKODSF.F_AGCY_HIER
AGENCY_UID_LEVEL_3		Extracted agency system generated identification number hierarchy level 3.	NUMBER		FUNCTION	FOKODSF.F_AGCY_HIER
AGENCY_UID_LEVEL_4		Extracted agency system generated identification number hierarchy level 4.	NUMBER		FUNCTION	FOKODSF.F_AGCY_HIER
AWARD_DATE		Extracts recorded date proposal was awarded the grant.	DATE		FUNCTION	F_GET_STATUS_DATE
AWARD_FISCAL_PERIOD		Extracts awarded fiscal period.	VARCHAR2(2)		FUNCTION	F_GET_STATUS_INFO
AWARD_FISCAL_YEAR		This is the Award Fiscal Year. In the Datamart this uses function f_get_status_info to get award fiscal year where status is A.	VARCHAR2(4)		FUNCTION	FOFYCNV
CATEGORY		Identifies sponsored programs category. Examples, federal, non-federal.	VARCHAR2(1)		FRBPROP	FRBPROP_CATEGORY
CHART_OF_ACCOUNTS		Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)		FRBPROP	FRBPROP_COAS_CODE
CHART_OF_ACCOUNTS_DESC		Chart of accounts code description or title.	VARCHAR2(35)		FUNCTION	F_GET_FINANCE_DESC
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
CURRENT_STATUS		Current status of the proposal.	VARCHAR2(2)		FRBPROP	FRBPROP_STATUS_CODE
CURRENT_STATUS_DATE		Current status date of the proposal.	DATE		FRBPROP	FRBPROP_STATUS_DATE
DECLINE_DATE		Recorded date that the award for the grant was declined.	DATE		FUNCTION	F_GET_STATUS_DATE
DECLINE_FISCAL_PERIOD		Extracted fiscal period in which the proposal was declined.	VARCHAR2(2)		FUNCTION	F_GET_STATUS_INFO
DECLINE_FISCAL_YEAR		This is the Decline Fiscal Year. In the Datamart this uses function f_get_status_info to get decline date where decline fiscal year is D.	VARCHAR2(4)		FUNCTION	FOFYCNV
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
FEDERAL_IDENTIFICATION		This is the CFDA code.	VARCHAR2(12)		FRBPROP	FRBPROP_CFDA_INTERNAL_ID_NO
FEDERAL_IDENTIFICATION_DESC		Description of the CFDA code.			FRVCFDA	FRVCFDA_TITLE
FEDERAL_IDENTIFICATION_UID		Identifies the CFDA number.			FRBPROP	FRBPROP_CFDA_INTERNAL_ID_NO
GRANT_ID		Unique user defined or system generated one-up number for this grant.	VARCHAR2(9)		FRBPROP	FRBPROP_GRNT_CODE
LOCATION		Identification accounting code of the physical location the proposal has been assigned to.	VARCHAR2(6)		FRRPLOC	FRRPLOC_LOCN_CODE
LOCATION_DESC		Extracted description or title of the associated location.	VARCHAR2(35)		FUNCTION	F_GET_FINANCE_DESC
MIF_DESC		Institution description 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.	VARCHAR2(6)		NA	NA
ON_OFF_CAMPUS		Where Grant research is being performed. Either On Campus, Off campus or both.	VARCHAR2(1)		FRRPLOC	FRRPLOC_LOCN_RESEARCH_IND
ORGANIZATION_CODE		Identification accounting code used for the responsible department.	VARCHAR2(6)		FRBPROP	FRBPROP_ORGN_CODE_RESP_OFFICE
ORGANIZATION_DESC		Extracted description or title associated with the organization code.	VARCHAR2(35)		FUNCTION	F_GET_FINANCE_DESC
ORIGINATION_DATE		Extracted proposal origination date.	DATE		FUNCTION	F_GET_STATUS_DATE
ORIGINATION_FISCAL_PERIOD		Extracted proposal origination fiscal period.	VARCHAR2(2)		FUNCTION	F_GET_STATUS_INFO
ORIGINATION_FISCAL_YEAR		This is the Origination Fiscal Year. In the Datamart this uses function f_get_status_info to get origination fiscal year where status in N.	VARCHAR2(4)		FUNCTION	FOFYCNV
PI_IND		Principal investigator type.	VARCHAR2(3)		FRRPRPI	FRRPRPI_ID_IND
PRINCIPAL_INVESTIGATOR_UID		System internally generated id to uniquely identify the principal investigator for this grant.	NUMBER(8)		FRBPROP	FRBPROP_PI_PIDM
PROPOSAL_CODE		User-defined or system assigned proposal identification code.	VARCHAR2(9)		FRBPROP	FRBPROP_CODE
PROPOSAL_LONG_TITLE		Long description or title of the grant proposal.	VARCHAR2(256)		FRBPROP	FRBPROP_LONG_TITLE
PROPOSAL_SHORT_TITLE		Short description or title of the grant proposal.	VARCHAR2(35)		FRBPROP	FRBPROP_TITLE
PROPOSAL_TYPE		Determines type of proposal like project, grant, contract, cooperative agreement.	VARCHAR2(2)		FRBPROP	FRBPROP_PROPOSAL_TYPE
PROPOSAL_TYPE_DESC		Description of the proposal type.			FUNCTION	FOKODSF.F_GET_SDAT_TITLE
REQUESTED_AMOUNT	Requested Amount	Total proposed amount to the agency including direct and indirect costs.	NUMBER(17,2)		FRBPROP	FRBPROP_REQUESTED_AMT
SPONSOR_NUMBER		Sponsor agency's reference number.	VARCHAR2(30)		FRBPROP	FRBPROP_SPONSOR_ID
SUBCATEGORY		Sub category code for grant and proposal classification such as corporation, foundation, state, etc.	VARCHAR2(4)		FRBPROP	FRBPROP_SUB_CATEGORY
SUBMISSION_DATE		Extracts proposal submission date.	DATE		FUNCTION	F_GET_STATUS_DATE
SUBMISSION_FISCAL_PERIOD		Extracts proposal submission fiscal period.	VARCHAR2(2)		FUNCTION	F_GET_STATUS_INFO
SUBMISSION_FISCAL_YEAR		This is the Submission Fiscal Year. In the Datamart this uses function f_get_status_info to get submission fiscal year where status is S.	VARCHAR2(4)		FUNCTION	FOFYCNV
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: