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

Ver: