Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
AGENCY_ADDRESS	Address type associated with this agency.	VARCHAR2(63)	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(63)	FRBGRNT	FRBGRNT_AGENCY_CONTACT	NO	NO
AGENCY_EMAIL	Email address for the agency contact.	VARCHAR2(255)	FRBGRNT	FRBGRNT_AGENCY_EMAIL	NO	NO
AGENCY_ID	System generated or manually assigned id to uniquely identify an agency.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID	NO	NO
AGENCY_ID_LEVEL_1	Agency's identification number level 1.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID	NO	NO
AGENCY_ID_LEVEL_2	Agency's identification number level 2.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID	NO	NO
AGENCY_ID_LEVEL_3	Agency's identification number level 3.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID	NO	NO
AGENCY_ID_LEVEL_4	Agency's identification number level 4.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID	NO	NO
AGENCY_NAME	Name of the agency.	VARCHAR2(63)	SPRIDEN	SPRIDEN_LAST_NAME	NO	NO
AGENCY_NAME_LEVEL_1	Agency name level 1.	VARCHAR2(63)	SPRIDEN	SPRIDEN_LAST_NAME	NO	NO
AGENCY_NAME_LEVEL_2	Agency name level 2.	VARCHAR2(63)	SPRIDEN	SPRIDEN_LAST_NAME	NO	NO
AGENCY_NAME_LEVEL_3	Agency name level 3.	VARCHAR2(63)	SPRIDEN	SPRIDEN_LAST_NAME	NO	NO
AGENCY_NAME_LEVEL_4	Agency name level 4.	VARCHAR2(63)	SPRIDEN	SPRIDEN_LAST_NAME	NO	NO
AGENCY_PHONE_TYPE	Phone type associated with this agency.	VARCHAR2(63)	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	F_AGCY_HIER	NO	NO
AGENCY_UID_LEVEL_2	Extracted agency system generated identification number hierarchy level 2.	NUMBER	FUNCTION	F_AGCY_HIER	NO	NO
AGENCY_UID_LEVEL_3	Extracted agency system generated identification number hierarchy level 3.	NUMBER	FUNCTION	F_AGCY_HIER	NO	NO
AGENCY_UID_LEVEL_4	Extracted agency system generated identification number hierarchy level 4.	NUMBER	FUNCTION	F_AGCY_HIER	NO	NO
ALTERNATE_STATUS_DESC	Alternate status description.	VARCHAR2(255)	FRBGRNT	FRBGRNT_ALTERNATE_STATUS_DESC	NO	NO
CATEGORY	Identifies sponsored programs category. Examples, federal, non-federal.	VARCHAR2(63)	FRBGRNT	FRBGRNT_CATEGORY	NO	NO
CATEGORY_DESC	Grant category description.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE	NO	NO
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	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(63)	FRBGRNT	FRBGRNT_COAS_CODE_IC_CS	NO	NO
CHART_OF_ACCOUNTS_COST_DESC	Chart of accounts extracted description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
CHART_OF_ACCOUNTS_COST_STATUS	Status of the chart of accounts cost.	VARCHAR2(63)	FTVCOAS	FTVCOAS_STATUS_IND	NO	NO
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
CHART_OF_ACCOUNTS_STATUS	Status of the chart of accounts.	VARCHAR2(63)	FTVCOAS	FTVCOAS_STATUS_IND	NO	NO
COST_SHARE_BASE	Code defines the base information for cost share calculations.	VARCHAR2(63)	FRBGRNT	FRBGRNT_BASI_CODE_CS	NO	NO
COST_SHARE_BASE_DESC	Cost share base description.	VARCHAR2(255)	FRVBASI	FRVBASI_DESC	NO	NO
COST_SHARE_CHARGE	Code defines account's and percentage of the charge.	VARCHAR2(63)	FRBGRNT	FRBGRNT_CSTA_CODE_CHARGE	NO	NO
COST_SHARE_CHARGE_DESC	Cost share charge description.	VARCHAR2(255)	FRVCSTA	FRVCSTA_DESC	NO	NO
COST_SHARE_DISTRIBUTION	Code defines the account distribution for indirect cost.	VARCHAR2(63)	FRBGRNT	FRBGRNT_CSTD_CODE_DISTR	NO	NO
COST_SHARE_DISTRIBUTION_DESC	Cost share distribution description.	VARCHAR2(255)	FRVCSTD	FRVCSTD_DESC	NO	NO
COST_SHARE_RATE	Cost share rate for this grant.	VARCHAR2(63)	FRBGRNT	FRBGRNT_CSTR_CODE_RATE	NO	NO
COST_SHARE_RATE_DESC	Cost share rate description.	VARCHAR2(255)	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_YEAR_AMOUNT	Current year funding amount of the grant, committed by the agency. Informational only.	NUMBER	FRBGRNT	FRBGRNT_CURRENT_FUNDING_AMT	NO	NO
EFFORT_CERTIFICATION_REQ_IND	Indicates whether effort certification is required with this grant.	VARCHAR2(1)	FRBGRNT	FRBGRNT_EFF_CERT_REQUIRED_IND	NO	NO
EXPENDITURE_END_DATE	Ending period date for expenditure activity.	DATE	FRBGRNT	FRBGRNT_EXPEND_END_DATE	NO	NO
FEDERAL_AGENCY_NAME	Federal agency name associated with the Catalog of Federal Domestic Assistance code.	VARCHAR2(255)	FRVCFDA	FRVCFDA_FEDERAL_AGENCY_NAME	NO	NO
FEDERAL_IDENTIFICATION	Identifies the Catalog of Federal Domestic Assistance code.	VARCHAR2(63)	FRVCFDA	FRVCFDA_CFDA_CODE	NO	NO
FEDERAL_IDENTIFICATION_DESC	Description of the Catalog of Federal Domestic Assistance.	VARCHAR2(255)	FRVCFDA	FRVCFDA_TITLE	NO	NO
FEDERAL_IDENTIFICATION_STATUS	Catalog of Federal Domestic Assistance status.	VARCHAR2(63)	FRVCFDA	FRVCFDA_STATUS	NO	NO
FEDERAL_IDENTIFICATION_UID	System generated unique internal identification number assigned to the Catalog of Federal Domestic Assistance code.	NUMBER	FRBGRNT	FRBGRNT_CFDA_INTERNAL_ID_NO	NO	NO
FIELD_OF_SCIENCE	Field of science.	VARCHAR2(63)	NA	NA	NO	NO
FISCAL_REPORTING_DATE	Fiscal reporting date of the grant.	DATE	NA	NA	NO	NO
GRANT_ACTIVITY_DATE	Date record was inserted or updated.	DATE	FRBGRNT	FRBGRNT_ACTIVITY_DATE	NO	NO
GRANT_ID	Unique user defined or system generated one-up number for this grant.	VARCHAR2(63)	FRBGRNT	FRBGRNT_CODE	NO	NO
GRANT_TYPE	Grant type code to reflect if this is a grant, contract, cooperative agreement, etc.	VARCHAR2(63)	FRBGRNT	FRBGRNT_GRANT_TYPE	NO	NO
GRANT_TYPE_DESC	Retrieved description for grant type.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE	NO	NO
GRANT_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	FRBGRNT	FRBGRNT_USER_ID	NO	NO
INDIRECT_COST_BASE	Code used to define indirect cost calculations.	VARCHAR2(63)	FRBGRNT	FRBGRNT_BASI_CODE_IC	NO	NO
INDIRECT_COST_BASE_DESC	Indirect cost base code description.	VARCHAR2(255)	FRVBASI	FRVBASI_DESC	NO	NO
INDIRECT_COST_CHARGE	Code identifies the account's and the percentage of the charge.	VARCHAR2(63)	FRBGRNT	FRBGRNT_INDA_CODE_CHARGE	NO	NO
INDIRECT_COST_CHARGE_DESC	Indirect cost charge code description.	VARCHAR2(255)	FRVINDA	FRVINDA_DESC	NO	NO
INDIRECT_COST_DISTRIBUTION	Code identifies the accounting distribution for indirect cost.	VARCHAR2(63)	FRBGRNT	FRBGRNT_INDD_CODE_DISTR	NO	NO
INDIRECT_COST_DISTRIB_DESC	Indirect cost distribution description.	VARCHAR2(255)	FRVINDD	FRVINDD_DESC	NO	NO
INDIRECT_COST_RATE	Indirect cost rate percentage for this grant.	VARCHAR2(63)	FRBGRNT	FRBGRNT_INDR_CODE_RATE	NO	NO
INDIRECT_COST_RATE_DESC	Indirect cost rate code description.	VARCHAR2(255)	FRVINDR	FRVINDR_DESC	NO	NO
LETTER_OF_CREDIT_NUMBER	Actual letter of credit number associated to the payment management system code.	VARCHAR2(63)	FRVPMSC	FRVPMSC_LOC_NO	NO	NO
LOCATION	Identification accounting code of the physical location the grant has been assigned to.	VARCHAR2(63)	FRRGLOC	FRRGLOC_LOCN_CODE	NO	NO
LOCATION_DESC	Extracted description or title of the associated location.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
LOCATION_STATUS	Status of the location.	VARCHAR2(63)	FTVLOCN	FTVLOCN_STATUS_IND	NO	NO
LONG_TITLE	Grant long title or description.	VARCHAR2(256)	FRBGRNT	FRBGRNT_LONG_TITLE	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
ON_OFF_CAMPUS	Where Grant research is being performed. Either On Campus, Off campus or both.	VARCHAR2(63)	FRRGLOC	FRRGLOC_LOCN_RESEARCH_IND	NO	NO
ORGANIZATION_DESC_1	Retrieves description or title level 1 within this organization hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_DESC_2	Retrieves description or title level 2 within this organization hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_DESC_3	Retrieves description or title level 3 within this organization hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_DESC_4	Retrieves description or title level 4 within this organization hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_DESC_5	Retrieves description or title level 5 within this organization hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_DESC_6	Retrieves description or title level 6 within this organization hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_DESC_7	Retrieves description or title level 7 within this organization hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_DESC_8	Retrieves description or title level 8 within this organization hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_LEVEL_1	Retrieves level 1 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_LEVEL_2	Retrieves level 2 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_LEVEL_3	Retrieves level 3 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_LEVEL_4	Retrieves level 4 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_LEVEL_5	Retrieves level 5 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_LEVEL_6	Retrieves level 6 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_LEVEL_7	Retrieves level 7 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_LEVEL_8	Retrieves level 8 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_STATUS_1	Retrieves status of level 1 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_STATUS_2	Retrieves status of level 2 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_STATUS_3	Retrieves status of level 3 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_STATUS_4	Retrieves status of level 4 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_STATUS_5	Retrieves status of level 5 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_STATUS_6	Retrieves status of level 6 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_STATUS_7	Retrieves status of level 7 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGANIZATION_STATUS_8	Retrieves status of level 8 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER	NO	NO
ORGN_FINANCIAL_MANAGER_ID	System generated or manually assigned ID that uniquely identifies the financial manager.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID	NO NO	NO
ORGN_FINANCIAL_MANAGER_NAME	Combination of the person's last name, first name, and middle initial into one value.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
ORGN_FINANCIAL_MANAGER_UID	System generated unique internal identification number assigned to the financial manager associated with this organization.	NUMBER	FTVORGN	FTVORGN_FMGR_CODE_PIDM	NO	NO
ORGN_FMGR_CITY	City associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_CITY	NO	NO
ORGN_FMGR_COUNTY	County code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_CNTY_CODE	NO	NO
ORGN_FMGR_COUNTY_DESC	County address name.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
ORGN_FMGR_FIRST_NAME	Financial manager's first or given name.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_FIRST_NAME	NO NO	NO
ORGN_FMGR_LAST_NAME	Fund manager's last name or surname.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME	NO NO	NO
ORGN_FMGR_MIDDLE_NAME	Financial manager's middle name.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_MI	NO NO	NO
ORGN_FMGR_NATION	Nation code associated with the address.	VARCHAR2(63)	SPRADDR	SPRADDR_NATN_CODE	NO	NO
ORGN_FMGR_NATION_DESC	Name of the nation.	VARCHAR2(255)	STVNATN	STVNATN_NATION	NO	NO
ORGN_FMGR_POSTAL_CODE	Address postal code.	VARCHAR2(63)	SPRADDR	SPRADDR_ZIP	NO	NO
ORGN_FMGR_STATE_PROVINCE	State/Province code for the address.	VARCHAR2(63)	SPRADDR	SPRADDR_STAT_CODE	NO	NO
ORGN_FMGR_STATE_PROVINCE_DESC	State/province name.	VARCHAR2(255)	STVSTAT	STVSTAT_DESC	NO	NO
ORGN_FMGR_STREET_LINE1	First line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE1	NO	NO
ORGN_FMGR_STREET_LINE2	Second line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE2	NO	NO
ORGN_FMGR_STREET_LINE3	Third line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE3	NO	NO
ORGN_FMGR_STREET_LINE4	Fourth line of the address.	VARCHAR2(255)	SPRADDR	SPRADDR_STREET_LINE4	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(63)	FRBGBIL	FRBGBIL_PMSC_CODE	NO	NO
PAYMENT_MANAGEMENT_SYS_DESC	Payment management system description.	VARCHAR2(255)	FRVPMSC	FRVPMSC_DESC	NO	NO
PRINCIPAL_INVESTIGATOR_FNAME	Current first name of the principal investigator.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME	NO NO	NO
PRINCIPAL_INVESTIGATOR_ID	Current identification number of the principal investigator.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID	NO NO	NO
PRINCIPAL_INVESTIGATOR_LNAME	Current last name of the principal investigator.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_FIRST_NAME	NO NO	NO
PRINCIPAL_INVESTIGATOR_MNAME	Current middle name of the principal investigator.	VARCHAR2(63)	FUNCTION SPRIDEN	MGKFUNC.F_GET_PERSON_INFO SPRIDEN_MI	NO NO	NO
PRINCIPAL_INVESTIGATOR_NAME	Combination of the person's last name, first name, and middle initial into one value.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
PRINCIPAL_INVESTIGATOR_TITLE	Official position/title that belongs to the principal investigator.	VARCHAR2(255)	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	Principal investigator's email address.	VARCHAR2(255)	FRRGRPI	FRRGRPI_EMAIL	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	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(63)	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(255)	FRBPROP	FRBPROP_TITLE	NO	NO
RELATED_GRANT	Grant code of a prior defined grant used to copy data from into this grant.	VARCHAR2(63)	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(63)	NA	NA	NO	NO
RESPONSIBLE_ORGANIZATION_CODE	Organization code of the responsible administrative office for this grant.	VARCHAR2(63)	FRBGRNT	FRBGRNT_ORGN_CODE_RESP_OFFICE	NO	NO
RESPONSIBLE_ORGANIZATION_DESC	Retrieved description or title of the associated organization.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC	NO	NO
RESPONSIBLE_ORGN_STATUS	Current status of the associated organization.	VARCHAR2(63)	FUNCTION	F_GET_FINANCE_STATUS	NO	NO
SHORT_TITLE	Grant short description.	VARCHAR2(255)	FRBGRNT	FRBGRNT_TITLE	NO	NO
SPONSOR_NUMBER	Sponsor agency's reference number.	VARCHAR2(63)	FRBGRNT	FRBGRNT_SPONSOR_ID	NO	NO
STATUS	Grant status. The most common values are (Inactive or (Active.	VARCHAR2(63)	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(255)	FTVSDAT	FTVSDAT_TITLE	NO	NO
STATUS_FISCAL_PERIOD	Extracted fiscal period in which the last status date occurred.	VARCHAR2(63)	FUNCTION	F_GET_FISCAL_PERIOD	NO	NO
STATUS_FISCAL_YEAR	Extracted fiscal year in which the last status date occurred.	VARCHAR2(63)	FUNCTION	FOFYCNV	NO	NO
SUBCATEGORY	Sub category code for grant and proposal classification such as corporation, foundation, state, etc.	VARCHAR2(63)	FRBGRNT	FRBGRNT_SUB_CATEGORY	NO	NO
SUBCATEGORY_DESC	Retrieved description for grant or proposal sub category.	VARCHAR2(255)	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	Total recipient portion includes all matching and cost sharing provided by the recipients and third-party providers to meet the level required by the Federal agency.	NUMBER	FRBGRNT	FRBGRNT_RCPT_SHARE_TOTAL	NO	NO
TYPE_OF_RESEARCH	Type of research.	VARCHAR2(63)	NA	NA	NO	NO

Ver: 9.2