Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
AGENCY_ADDRESS		Address type associated with this agency.	VARCHAR2(2)		FRBGRNT	FRBGRNT_AGENCY_ADDR_CODE
AGENCY_ADDRESS_SEQUENCE_NUMBER		Sequence number associated with this address type to uniquely identify the address.	NUMBER(2)		FRBGRNT	FRBGRNT_AGENCY_ADDR_SEQ_NUM
AGENCY_COMMITMENT_AMOUNT	Agency Commitment Amount	Maximum amount of money the agency commits to the grant. Informational only.	NUMBER(17,2)		FRBGRNT	FRBGRNT_MAX_FUNDING_AMT
AGENCY_CONTACT		Name of the person to contact at the agency.	VARCHAR2(35)		FRBGRNT	FRBGRNT_AGENCY_CONTACT
AGENCY_EMAIL	Agency Email	Email address for the agency contact.	VARCHAR2(128)		FRBGRNT	FRBGRNT_AGENCY_EMAIL
AGENCY_PHONE_TYPE		Phone type associated with this agency.	VARCHAR2(4)		FRBGRNT	FRBGRNT_AGENCY_PHONE_TYPE
AGENCY_TELEPHONE_SEQ_NUMBER		Sequence number associated with this phone type to uniquely identify the phone number.	NUMBER(3)		FRBGRNT	FRBGRNT_AGENCY_TELE_SEQNO
AGENCY_UID		System generated unique internal identification number assigned to this organization entity.	NUMBER(8)		FRBGRNT	FRBGRNT_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
ALTERNATE_STATUS_DESC		Alternate status description.	VARCHAR2(35)		FRBGRNT	FRBGRNT_ALTERNATE_STATUS_DESC
CATEGORY		Identifies sponsored programs category. Examples, federal, non-federal.	VARCHAR2(1)		FRBGRNT	FRBGRNT_CATEGORY
CATEGORY_DESC		Grant category description.	VARCHAR2(35)		FUNCTION	FOKODSF.F_GET_SDAT_TITLE
CHART_OF_ACCOUNTS		Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(1)		FRBGRNT	FRBGRNT_COAS_CODE
CHART_OF_ACCOUNTS_COST		Primary identification code for any chart of accounts which uniquely identifies that chart from any other in a multi-chart environment specifically pertaining to Indirect cost and cost share codes.	VARCHAR2(1)		FRBGRNT	FRBGRNT_COAS_CODE_IC_CS
CHART_OF_ACCOUNTS_COST_DESC		Chart of accounts extracted description or title.	VARCHAR2(35)		FTVCOAS	FTVCOAS_TITLE
CHART_OF_ACCOUNTS_DESC		Chart of accounts code description or title.	VARCHAR2(35)		FUNCTION	F_GET_FINANCE_DESC
COST_SHARE_BASE		Code defines the base information for cost share calculations.	VARCHAR2(6)		FRBGRNT	FRBGRNT_BASI_CODE_CS
COST_SHARE_BASE_DESC		Cost share base description.	VARCHAR2(35)		FRVBASI	FRVBASI_DESC
COST_SHARE_CHARGE		Code defines account's and percentage of the charge.	VARCHAR2(6)		FRBGRNT	FRBGRNT_CSTA_CODE_CHARGE
COST_SHARE_CHARGE_DESC		Cost share charge description.	VARCHAR2(35)		FRVCSTA	FRVCSTA_DESC
COST_SHARE_DISTRIBUTION		Code defines the account distribution for indirect cost.	VARCHAR2(6)		FRBGRNT	FRBGRNT_CSTD_CODE_DISTR
COST_SHARE_DISTRIBUTION_DESC		Cost share distribution description.	VARCHAR2(35)		FRVCSTD	FRVCSTD_DESC
COST_SHARE_RATE		Cost share rate for this grant.	VARCHAR2(6)		FRBGRNT	FRBGRNT_CSTR_CODE_RATE
COST_SHARE_RATE_DESC		Cost share rate description.	VARCHAR2(35)		FRVCSTR	FRVCSTR_DESC
CUMULATIVE_AMOUNT	Cumulative Amount	Cumulative funding amount of the grant, received from the agency to date. Informational only.	NUMBER(17,2)		FRBGRNT	FRBGRNT_CUM_FUNDING_AMT
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
CURRENT_YEAR_AMOUNT	Current Year Amount	Current year funding amount of the grant, committed by the agency. Informational only.	NUMBER(17,2)		FRBGRNT	FRBGRNT_CURRENT_FUNDING_AMT
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
EFFORT_CERTIFICATION_REQ_IND	Effort Certification Requirements Indicator		VARCHAR2(1)
EXPENDITURE_END_DATE		Ending period date for expenditure activity.	DATE		FRBGRNT	FRBGRNT_EXPEND_END_DATE
FEDERAL_AGENCY_NAME	Federal Agency Name		VARCHAR2(70)
FEDERAL_IDENTIFICATION		This is the CFDA code.	VARCHAR2(12)		FRBGRNT	FRBGRNT_CFDA_INTERNAL_ID_NO
FEDERAL_IDENTIFICATION_DESC		Description of the CFDA code.			FRVCFDA	FRVCFDA_TITLE
FEDERAL_IDENTIFICATION_STATUS	Federal ID Status		VARCHAR2(2)
FEDERAL_IDENTIFICATION_UID		Identifies the CFDA number.			FRBGRNT	FRBGRNT_CFDA_INTERNAL_ID_NO
FIELD_OF_SCIENCE		Field of science.	VARCHAR2(0)		NA	NA
FISCAL_REPORTING_DATE		Fiscal reporting date of the grant.	DATE		NA	NA
GRANT_ACTIVITY_DATE	Grant Activity Date		DATE
GRANT_ID		Unique user defined or system generated one-up number for this grant.	VARCHAR2(9)		FRBGRNT	FRBGRNT_CODE
GRANT_TYPE		Grant type code to reflect if this is a grant, contract, cooperative agreement, etc.	VARCHAR2(2)		FRBGRNT	FRBGRNT_GRANT_TYPE
GRANT_TYPE_DESC		Retrieved description for grant type.	VARCHAR2(35)		FUNCTION	FOKODSF.F_GET_SDAT_TITLE
GRANT_USER_ID	Grant User ID		VARCHAR2(30)
INDIRECT_COST_BASE		Code used to define indirect cost calculations.	VARCHAR2(6)		FRBGRNT	FRBGRNT_BASI_CODE_IC
INDIRECT_COST_BASE_DESC		Indirect cost base code description.	VARCHAR2(35)		FRVBASI	FRVBASI_DESC
INDIRECT_COST_CHARGE		Code identifies the account's and the percentage of the charge.	VARCHAR2(6)		FRBGRNT	FRBGRNT_INDA_CODE_CHARGE
INDIRECT_COST_CHARGE_DESC		Indirect cost charge description.	VARCHAR2(35)		FRVINDA	FRVINDA_DESC
INDIRECT_COST_DISTRIBUTION		Code identifies the accounting distribution for indirect cost.	VARCHAR2(6)		FRBGRNT	FRBGRNT_INDD_CODE_DISTR
INDIRECT_COST_DISTRIB_DESC		Indirect cost distribution description.	VARCHAR2(35)		FRVINDD	FRVINDD_DESC
INDIRECT_COST_RATE		Indirect cost rate percentage for this grant.	VARCHAR2(6)		FRBGRNT	FRBGRNT_INDR_CODE_RATE
INDIRECT_COST_RATE_DESC		Indirect cost rate code description.	VARCHAR2(35)		FRVINDR	FRVINDR_DESC
LETTER_OF_CREDIT_NUMBER		Actual letter of credit number associated to the payment management system code.	VARCHAR2(15)		FRVPMSC	FRVPMSC_LOC_NO
LOCATION		Identification accounting code of the physical location the grant has been assigned to.	VARCHAR2(6)		FRRGLOC	FRRGLOC_LOCN_CODE
LOCATION_DESC		Extracted description or title of the associated location.	VARCHAR2(35)		FUNCTION	F_GET_FINANCE_DESC
LONG_TITLE		Grant description or title.	VARCHAR2(256)		FRBGRNT	FRBGRNT_LONG_TITLE
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)		FRRGLOC	FRRGLOC_LOCN_RESEARCH_IND
PAYMENT_MANAGEMENT_SYS_CODE		Unique identifier assigned as a payment management system code within grants, containing the letter of credit number and a amount limit that can be drawn on a letter of credit.	VARCHAR2(16)		FRBGBIL	FRBGBIL_PMSC_CODE
PAYMENT_MANAGEMENT_SYS_DESC		Payment management system description.	VARCHAR2(35)		FRVPMSC	FRVPMSC_DESC
PRINCIPAL_INVESTIGATOR_TITLE		Official position/title that belongs to the principal investigator.	VARCHAR2(35)		FRRGRPI	FRRGRPI_TITLE
PRINCIPAL_INVESTIGATOR_UID		System internally generated id to uniquely identify the principal investigator for this grant.	NUMBER(8)		FRBGRNT	FRBGRNT_PI_PIDM
PRIN_INVESTIGATOR_EMAIL_ADDR	Prin Investigator Email Address		VARCHAR2(128)
PROJECT_END_DATE		End date is the last day of the grant period.	DATE		FRBGRNT	FRBGRNT_PROJECT_END_DATE
PROJECT_START_DATE		Date the agency awarded the grant.	DATE		FRBGRNT	FRBGRNT_PROJECT_START_DATE
PROPOSAL		Proposal submitted to the agency that has now been awarded this grant.	VARCHAR2(9)		FRBGRNT	FRBGRNT_PROP_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
RELATED_GRANT		Grant code of a prior defined grant used to copy data from into this grant.	VARCHAR2(9)		FRBGRNT	FRBGRNT_GRNT_CODE_RELATED
RENEWAL_REPORT_DATE		Renewal reporting date of the grant.	DATE		NA	NA
REPORTING_DATE		Reporting date of the grant.	DATE		NA	NA
REPORTING_QUARTER1		Reporting for quarter 1 amount.	NUMBER		NA	NA
REPORTING_QUARTER2		Reporting for quarter 2 amount.	NUMBER		NA	NA
REPORTING_QUARTER3		Reporting for quarter 3 amount.	NUMBER		NA	NA
REPORTING_QUARTER4		Reporting for quarter 4 amount.	NUMBER		NA	NA
RESEARCH_PURPOSE		Purpose of the research.	VARCHAR2(0)		NA	NA
RESPONSIBLE_ORGANIZATION_CODE		Organization code of the responsible administrative office for this grant.	VARCHAR2(6)		FRBGRNT	FRBGRNT_ORGN_CODE_RESP_OFFICE
RESPONSIBLE_ORGANIZATION_DESC		Retrieved description or title of the associated organization.	VARCHAR2(35)		FUNCTION	F_GET_FINANCE_DESC
RESPONSIBLE_ORGN_STATUS		Current status of the associated organization.	VARCHAR2(1)		FUNCTION	F_GET_FINANCE_STATUS
SHORT_TITLE		Grant description or title.	VARCHAR2(35)		FRBGRNT	FRBGRNT_TITLE
SPONSOR_NUMBER		Sponsor agency's reference number.	VARCHAR2(30)		FRBGRNT	FRBGRNT_SPONSOR_ID
STATUS		Status code of the grant.	VARCHAR2(2)		FRBGRNT	FRBGRNT_STATUS_CODE
STATUS_DATE		Last date a status change occurred for this grant.	DATE		FRBGRNT	FRBGRNT_STATUS_DATE
STATUS_DESC		Retrieved description for grant status.	VARCHAR2(35)		FUNCTION	FOKODSF.F_GET_SDAT_TITLE
STATUS_FISCAL_PERIOD		Extracted fiscal period in which the last status date occurred.	VARCHAR2(2)		FUNCTION	F_GET_FISCAL_PERIOD
STATUS_FISCAL_YEAR		Calculated using the status date.	VARCHAR2(4)		FUNCTION	FOFYCNV
SUBCATEGORY		Sub category code for grant and proposal classification such as corporation, foundation, state, etc.	VARCHAR2(4)		FRBGRNT	FRBGRNT_SUB_CATEGORY
SUBCATEGORY_DESC		Retrieved description for grant or proposal sub category.	VARCHAR2(35)		FUNCTION	FOKODSF.F_GET_SDAT_TITLE
TERMINATION_DATE		Date when this grant is no longer in effect. The time between the project end date and termination date defines the trail out period.	DATE		FRBGRNT	FRBGRNT_TERM_DATE
TOTAL_RECIPIENT_SHARE_AMOUNT	Total Recipient Share Amount		NUMBER
TYPE_OF_RESEARCH		Type of research.	VARCHAR2(0)		NA	NA
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: