Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AGENCY_ID_LEVEL_1	Agency's identification number level 1.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID
AGENCY_ID_LEVEL_2	Agency's identification number level 2.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID
AGENCY_ID_LEVEL_3	Agency's identification number level 3.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID
AGENCY_ID_LEVEL_4	Agency's identification number level 4.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID
AGENCY_NAME	Name of the agency.	VARCHAR2(255)	SPRIDEN	SPRIDEN_LAST_NAME
AGENCY_NAME_LEVEL_1	Agency name level 1.	VARCHAR2(255)	SPRIDEN	SPRIDEN_LAST_NAME
AGENCY_NAME_LEVEL_2	Agency name level 2.	VARCHAR2(255)	SPRIDEN	SPRIDEN_LAST_NAME
AGENCY_NAME_LEVEL_3	Agency name level 3.	VARCHAR2(255)	SPRIDEN	SPRIDEN_LAST_NAME
AGENCY_NAME_LEVEL_4	Agency name level 4.	VARCHAR2(255)	SPRIDEN	SPRIDEN_LAST_NAME
AGENCY_NUMBER	Agency's identification number.	VARCHAR2(63)	SPRIDEN	SPRIDEN_ID
AGENCY_UID	System generated unique internal identification number assigned to this organization entity.	NUMBER	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(63)	FUNCTION	F_GET_STATUS_INFO
AWARD_FISCAL_YEAR	Extracts awarded fiscal year.	VARCHAR2(63)	FUNCTION	FOFYCNV
CATEGORY	Identifies sponsored programs category. Examples, federal, non-federal.	VARCHAR2(63)	FRBPROP	FRBPROP_CATEGORY
CHART_OF_ACCOUNTS	Identifies the chart from other charts in a multi-chart environment.	VARCHAR2(63)	FRBPROP	FRBPROP_COAS_CODE
CHART_OF_ACCOUNTS_DESC	Chart of accounts code description or title.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
CHART_OF_ACCOUNTS_STATUS	Status of the chart of accounts.	VARCHAR2(63)	FTVCOAS	FTVCOAS_STATUS_IND
CURRENT_STATUS	Current status of the proposal.	VARCHAR2(63)	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(63)	FUNCTION	F_GET_STATUS_INFO
DECLINE_FISCAL_YEAR	Extracted fiscal year in which the proposal was declined.	VARCHAR2(63)	FUNCTION	FOFYCNV
FEDERAL_IDENTIFICATION	Identifies the CFDA code.	VARCHAR2(63)	FRBPROP FRVCFDA	FRBPROP_CFDA_INTERNAL_ID_NO FRVCFDA_CFDA_CODE
FEDERAL_IDENTIFICATION_DESC	Description of the CFDA code.	VARCHAR2(255)	FRVCFDA	FRVCFDA_TITLE
FEDERAL_IDENTIFICATION_UID	Identifies the CFDA number.	NUMBER	FRBPROP	FRBPROP_CFDA_INTERNAL_ID_NO
GRANT_AWARD_AMOUNT	Grant award amount.	NUMBER	FRBGRNT	FRBGRNT_CURRENT_FUNDING_AMT
GRANT_ID	Unique user defined or system generated one-up number for this grant.	VARCHAR2(63)	FRBPROP	FRBPROP_GRNT_CODE
GRANT_TITLE	Shortened name or title for the grant.	VARCHAR2(255)	FRBGRNT	FRBGRNT_TITLE
LOCATION	Identification accounting code of the physical location the proposal has been assigned to.	VARCHAR2(63)	FRRPLOC	FRRPLOC_LOCN_CODE
LOCATION_DESC	Extracted description or title of the associated location.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
LOCATION_STATUS	Status of the location.	VARCHAR2(63)	FTVLOCN	FTVLOCN_STATUS_IND
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
ON_OFF_CAMPUS	Where Grant research is being performed. Either On Campus, Off campus or both.	VARCHAR2(63)	FRRPLOC	FRRPLOC_LOCN_RESEARCH_IND
ORGANIZATION_CODE	Identification accounting code used for the responsible department.	VARCHAR2(63)	FRBPROP	FRBPROP_ORGN_CODE_RESP_OFFICE
ORGANIZATION_DESC	Extracted description or title associated with the organization code.	VARCHAR2(255)	FUNCTION	F_GET_FINANCE_DESC
ORGANIZATION_DESC_1	Retrieves description or title level 1 within this organization hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_DESC_2	Retrieves description or title level 2 within this organization hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_DESC_3	Retrieves description or title level 3 within this organization hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_DESC_4	Retrieves description or title level 4 within this organization hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_DESC_5	Retrieves description or title level 5 within this organization hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_DESC_6	Retrieves description or title level 6 within this organization hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_DESC_7	Retrieves description or title level 7 within this organization hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_DESC_8	Retrieves description or title level 8 within this organization hierarchy.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_LEVEL_1	Retrieves level 1 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_LEVEL_2	Retrieves level 2 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_LEVEL_3	Retrieves level 3 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_LEVEL_4	Retrieves level 4 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_LEVEL_5	Retrieves level 5 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_LEVEL_6	Retrieves level 6 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_LEVEL_7	Retrieves level 7 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_LEVEL_8	Retrieves level 8 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_STATUS	Status of the organization.	VARCHAR2(63)	FTVORGN	FTVORGN_STATUS_IND
ORGANIZATION_STATUS_1	Retrieves status of level 1 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_STATUS_2	Retrieves status of level 2 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_STATUS_3	Retrieves status of level 3 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_STATUS_4	Retrieves status of level 4 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_STATUS_5	Retrieves status of level 5 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_STATUS_6	Retrieves status of level 6 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_STATUS_7	Retrieves status of level 7 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORGANIZATION_STATUS_8	Retrieves status of level 8 organization within this organization hierarchy.	VARCHAR2(63)	FUNCTION	FOKODSF.F_GET_ORGN_HIER
ORIGINATION_DATE	Extracted proposal origination date.	DATE	FUNCTION	F_GET_STATUS_DATE
ORIGINATION_FISCAL_PERIOD	Extracted proposal origination fiscal period.	VARCHAR2(63)	FUNCTION	F_GET_STATUS_INFO
ORIGINATION_FISCAL_YEAR	Extracted proposal origination fiscal year.	VARCHAR2(63)	FUNCTION	FOFYCNV
PRINCIPAL_INVESTIGATOR_FNAME	Current first name of the principal investigator.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PRINCIPAL_INVESTIGATOR_ID	Current identification number for the principal investigator.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PRINCIPAL_INVESTIGATOR_IND	Principal investigator type indicator.	VARCHAR2(63)	FRRPRPI	FRRPRPI_ID_IND
PRINCIPAL_INVESTIGATOR_LNAME	Current last name of the principal investigator.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PRINCIPAL_INVESTIGATOR_MNAME	Current middle name of the principal investigator.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PRINCIPAL_INVESTIGATOR_UID	System internally generated id to uniquely identify the principal investigator for this grant.	NUMBER	FRBPROP	FRBPROP_PI_PIDM
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROPOSAL_CODE	User-defined or system assigned proposal identification code.	VARCHAR2(63)	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(255)	FRBPROP	FRBPROP_TITLE
PROPOSAL_TYPE	Determines type of proposal like project, grant, contract, cooperative agreement.	VARCHAR2(63)	FRBPROP	FRBPROP_PROPOSAL_TYPE
PROPOSAL_TYPE_DESC	Description of the proposal type.	VARCHAR2(255)	FUNCTION	FOKODSF.F_GET_SDAT_TITLE
REQUESTED_AMOUNT	Total proposed amount to the agency including direct and indirect costs.	NUMBER	FRBPROP	FRBPROP_REQUESTED_AMT
SPONSOR_NUMBER	Sponsor agency's reference number.	VARCHAR2(63)	FRBPROP	FRBPROP_SPONSOR_ID
SUBCATEGORY	Sub category code for grant and proposal classification such as corporation, foundation, state, etc.	VARCHAR2(63)	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(63)	FUNCTION	F_GET_STATUS_INFO
SUBMISSION_FISCAL_YEAR	Extracts proposal submission fiscal year.	VARCHAR2(63)	FUNCTION	FOFYCNV

Ver: 8.1