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