| Target Column |
Business Name |
Business Definition |
Database Data Type |
Domain Value |
Source Name |
Source Column |
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA
|
NA
|
|
AGENCY_ADDRESS
|
Agency Address
|
Address type associated with this agency.
|
VARCHAR2(63)
|
|
FRBGRNT
|
FRBGRNT_AGENCY_ADDR_CODE
|
|
AGENCY_ADDRESS_SEQUENCE_NUMBER
|
Agency Address Sequence Number
|
Sequence number associated with this address type to uniquely identify the address.
|
NUMBER
|
|
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
|
|
FRBGRNT
|
FRBGRNT_MAX_FUNDING_AMT
|
|
AGENCY_CONTACT
|
Agency Contact
|
Name of the person to contact at the agency.
|
VARCHAR2(63)
|
|
FRBGRNT
|
FRBGRNT_AGENCY_CONTACT
|
|
AGENCY_EMAIL
|
Agency Email
|
Email address for the agency contact.
|
VARCHAR2(255)
|
|
FRBGRNT
|
FRBGRNT_AGENCY_EMAIL
|
|
AGENCY_ID
|
Agency ID
|
System generated or manually assigned id to uniquely identify an agency.
|
VARCHAR2(63)
|
|
SPRIDEN
|
SPRIDEN_ID
|
|
AGENCY_ID_LEVEL_1
|
Agency ID Level 1
|
Agency's identification number level 1.
|
VARCHAR2(63)
|
|
SPRIDEN
|
SPRIDEN_ID
|
|
AGENCY_ID_LEVEL_2
|
Agency ID Level 2
|
Agency's identification number level 2.
|
VARCHAR2(63)
|
|
SPRIDEN
|
SPRIDEN_ID
|
|
AGENCY_ID_LEVEL_3
|
Agency ID Level 3
|
Agency's identification number level 3.
|
VARCHAR2(63)
|
|
SPRIDEN
|
SPRIDEN_ID
|
|
AGENCY_ID_LEVEL_4
|
Agency ID Level 4
|
Agency's identification number level 4.
|
VARCHAR2(63)
|
|
SPRIDEN
|
SPRIDEN_ID
|
|
AGENCY_NAME
|
Agency Name
|
Name of the agency.
|
VARCHAR2(63)
|
|
SPRIDEN
|
SPRIDEN_LAST_NAME
|
|
AGENCY_NAME_LEVEL_1
|
Agency Name Level 1
|
Agency name level 1.
|
VARCHAR2(63)
|
|
SPRIDEN
|
SPRIDEN_LAST_NAME
|
|
AGENCY_NAME_LEVEL_2
|
Agency Name Level 2
|
Agency name level 2.
|
VARCHAR2(63)
|
|
SPRIDEN
|
SPRIDEN_LAST_NAME
|
|
AGENCY_NAME_LEVEL_3
|
Agency Name Level 3
|
Agency name level 3.
|
VARCHAR2(63)
|
|
SPRIDEN
|
SPRIDEN_LAST_NAME
|
|
AGENCY_NAME_LEVEL_4
|
Agency Name Level 4
|
Agency name level 4.
|
VARCHAR2(63)
|
|
SPRIDEN
|
SPRIDEN_LAST_NAME
|
|
AGENCY_PHONE_TYPE
|
Agency Phone Type
|
Phone type associated with this agency.
|
VARCHAR2(63)
|
|
FRBGRNT
|
FRBGRNT_AGENCY_PHONE_TYPE
|
|
AGENCY_TELEPHONE_SEQ_NUMBER
|
Agency Telephone Sequence Number
|
Sequence number associated with this phone type to uniquely identify the phone number.
|
NUMBER
|
|
FRBGRNT
|
FRBGRNT_AGENCY_TELE_SEQNO
|
|
AGENCY_UID
|
Agency UID
|
System generated unique internal identification number assigned to this organization entity.
|
NUMBER
|
|
FRBGRNT
|
FRBGRNT_AGENCY_PIDM
|
|
AGENCY_UID_LEVEL_1
|
Agency UID Level 1
|
Extracted agency system generated identification number hierarchy level 1.
|
NUMBER
|
|
FUNCTION
|
F_AGCY_HIER
|
|
AGENCY_UID_LEVEL_2
|
Agency UID Level 2
|
Extracted agency system generated identification number hierarchy level 2.
|
NUMBER
|
|
FUNCTION
|
F_AGCY_HIER
|
|
AGENCY_UID_LEVEL_3
|
Agency UID Level 3
|
Extracted agency system generated identification number hierarchy level 3.
|
NUMBER
|
|
FUNCTION
|
F_AGCY_HIER
|
|
AGENCY_UID_LEVEL_4
|
Agency UID Level 4
|
Extracted agency system generated identification number hierarchy level 4.
|
NUMBER
|
|
FUNCTION
|
F_AGCY_HIER
|
|
ALTERNATE_STATUS_DESC
|
Alternate Status Description
|
Alternate status description.
|
VARCHAR2(255)
|
|
FRBGRNT
|
FRBGRNT_ALTERNATE_STATUS_DESC
|
|
CATEGORY
|
Category
|
Identifies sponsored programs category. Examples, federal, non-federal.
|
VARCHAR2(63)
|
|
FRBGRNT
|
FRBGRNT_CATEGORY
|
|
CATEGORY_DESC
|
Category Description
|
Grant category description.
|
VARCHAR2(255)
|
|
FUNCTION
|
FOKODSF.F_GET_SDAT_TITLE
|
|
CHART_OF_ACCOUNTS
|
Chart Of Accounts
|
Identifies the chart from other charts in a multi-chart environment.
|
VARCHAR2(63)
|
|
FRBGRNT
|
FRBGRNT_COAS_CODE
|
|
CHART_OF_ACCOUNTS_COST
|
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
|
|
CHART_OF_ACCOUNTS_COST_DESC
|
Chart Of Accounts Cost Description
|
Chart of accounts extracted description or title.
|
VARCHAR2(255)
|
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
CHART_OF_ACCOUNTS_COST_STATUS
|
Chart Of Accounts Cost Status
|
Status of the chart of accounts cost.
|
VARCHAR2(63)
|
|
FTVCOAS
|
FTVCOAS_STATUS_IND
|
|
CHART_OF_ACCOUNTS_DESC
|
Chart Of Accounts Description
|
Chart of accounts code description or title.
|
VARCHAR2(255)
|
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
CHART_OF_ACCOUNTS_STATUS
|
Chart Of Accounts Status
|
Status of the chart of accounts.
|
VARCHAR2(63)
|
|
FTVCOAS
|
FTVCOAS_STATUS_IND
|
|
COST_SHARE_BASE
|
Cost Share Base
|
Code defines the base information for cost share calculations.
|
VARCHAR2(63)
|
|
FRBGRNT
|
FRBGRNT_BASI_CODE_CS
|
|
COST_SHARE_BASE_DESC
|
Cost Share Base Description
|
Cost share base description.
|
VARCHAR2(255)
|
|
FRVBASI
|
FRVBASI_DESC
|
|
COST_SHARE_CHARGE
|
Cost Share Charge
|
Code defines account's and percentage of the charge.
|
VARCHAR2(63)
|
|
FRBGRNT
|
FRBGRNT_CSTA_CODE_CHARGE
|
|
COST_SHARE_CHARGE_DESC
|
Cost Share Charge Description
|
Cost share charge description.
|
VARCHAR2(255)
|
|
FRVCSTA
|
FRVCSTA_DESC
|
|
COST_SHARE_DISTRIBUTION
|
Cost Share Distribution
|
Code defines the account distribution for indirect cost.
|
VARCHAR2(63)
|
|
FRBGRNT
|
FRBGRNT_CSTD_CODE_DISTR
|
|
COST_SHARE_DISTRIBUTION_DESC
|
Cost Share Distribution Description
|
Cost share distribution description.
|
VARCHAR2(255)
|
|
FRVCSTD
|
FRVCSTD_DESC
|
|
COST_SHARE_RATE
|
Cost Share Rate
|
Cost share rate for this grant.
|
VARCHAR2(63)
|
|
FRBGRNT
|
FRBGRNT_CSTR_CODE_RATE
|
|
COST_SHARE_RATE_DESC
|
Cost Share Rate Description
|
Cost share rate description.
|
VARCHAR2(255)
|
|
FRVCSTR
|
FRVCSTR_DESC
|
|
CUMULATIVE_AMOUNT
|
Cumulative Amount
|
Cumulative funding amount of the grant, received from the agency to date. Informational only.
|
NUMBER
|
|
FRBGRNT
|
FRBGRNT_CUM_FUNDING_AMT
|
|
CURRENT_YEAR_AMOUNT
|
Current Year Amount
|
Current year funding amount of the grant, committed by the agency. Informational only.
|
NUMBER
|
|
FRBGRNT
|
FRBGRNT_CURRENT_FUNDING_AMT
|
|
EFFORT_CERTIFICATION_REQ_IND
|
Effort Certification Requirements Indicator
|
Indicates whether effort certification is required with this grant.
|
VARCHAR2(1)
|
|
FRBGRNT
|
FRBGRNT_EFF_CERT_REQUIRED_IND
|
|
EXPENDITURE_END_DATE
|
Expenditure End Date
|
Ending period date for expenditure activity.
|
DATE
|
|
FRBGRNT
|
FRBGRNT_EXPEND_END_DATE
|
|
FEDERAL_AGENCY_NAME
|
Federal Agency Name
|
Federal agency name associated with the Catalog of Federal Domestic Assistance code.
|
VARCHAR2(255)
|
|
FRVCFDA
|
FRVCFDA_FEDERAL_AGENCY_NAME
|
|
FEDERAL_IDENTIFICATION
|
Federal ID
|
Identifies the Catalog of Federal Domestic Assistance code.
|
VARCHAR2(63)
|
|
FRVCFDA
|
FRVCFDA_CFDA_CODE
|
|
FEDERAL_IDENTIFICATION_DESC
|
Federal ID Description
|
Description of the Catalog of Federal Domestic Assistance.
|
VARCHAR2(255)
|
|
FRVCFDA
|
FRVCFDA_TITLE
|
|
FEDERAL_IDENTIFICATION_STATUS
|
Federal ID Status
|
Catalog of Federal Domestic Assistance status.
|
VARCHAR2(63)
|
|
FRVCFDA
|
FRVCFDA_STATUS
|
|
FEDERAL_IDENTIFICATION_UID
|
Federal ID UID
|
System generated unique internal identification number assigned to the Catalog of Federal Domestic Assistance code.
|
NUMBER
|
|
FRBGRNT
|
FRBGRNT_CFDA_INTERNAL_ID_NO
|
|
FIELD_OF_SCIENCE
|
Field Of Science
|
Field of science.
|
VARCHAR2(63)
|
|
NA
|
NA
|
|
FISCAL_REPORTING_DATE
|
Fiscal Reporting Date
|
Fiscal reporting date of the grant.
|
DATE
|
|
NA
|
NA
|
|
GRANT_ACTIVITY_DATE
|
Grant Activity Date
|
Date record was inserted or updated.
|
DATE
|
|
FRBGRNT
|
FRBGRNT_ACTIVITY_DATE
|
|
GRANT_ID
|
Grant ID
|
Unique user defined or system generated one-up number for this grant.
|
VARCHAR2(63)
|
|
FRBGRNT
|
FRBGRNT_CODE
|
|
GRANT_TYPE
|
Grant Type
|
Grant type code to reflect if this is a grant, contract, cooperative agreement, etc.
|
VARCHAR2(63)
|
|
FRBGRNT
|
FRBGRNT_GRANT_TYPE
|
|
GRANT_TYPE_DESC
|
Grant Type Description
|
Retrieved description for grant type.
|
VARCHAR2(255)
|
|
FUNCTION
|
FOKODSF.F_GET_SDAT_TITLE
|
|
GRANT_USER_ID
|
Grant User ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(63)
|
|
FRBGRNT
|
FRBGRNT_USER_ID
|
|
INDIRECT_COST_BASE
|
Indirect Cost Base
|
Code used to define indirect cost calculations.
|
VARCHAR2(63)
|
|
FRBGRNT
|
FRBGRNT_BASI_CODE_IC
|
|
INDIRECT_COST_BASE_DESC
|
Indirect Cost Base Description
|
Indirect cost base code description.
|
VARCHAR2(255)
|
|
FRVBASI
|
FRVBASI_DESC
|
|
INDIRECT_COST_CHARGE
|
Indirect Cost Charge
|
Code identifies the account's and the percentage of the charge.
|
VARCHAR2(63)
|
|
FRBGRNT
|
FRBGRNT_INDA_CODE_CHARGE
|
|
INDIRECT_COST_CHARGE_DESC
|
Indirect Cost Charge Description
|
Indirect cost charge code description.
|
VARCHAR2(255)
|
|
FRVINDA
|
FRVINDA_DESC
|
|
INDIRECT_COST_DISTRIBUTION
|
Indirect Cost Distribution
|
Code identifies the accounting distribution for indirect cost.
|
VARCHAR2(63)
|
|
FRBGRNT
|
FRBGRNT_INDD_CODE_DISTR
|
|
INDIRECT_COST_DISTRIB_DESC
|
Indirect Cost Distribution Description
|
Indirect cost distribution description.
|
VARCHAR2(255)
|
|
FRVINDD
|
FRVINDD_DESC
|
|
INDIRECT_COST_RATE
|
Indirect Cost Rate
|
Indirect cost rate percentage for this grant.
|
VARCHAR2(63)
|
|
FRBGRNT
|
FRBGRNT_INDR_CODE_RATE
|
|
INDIRECT_COST_RATE_DESC
|
Indirect Cost Rate Description
|
Indirect cost rate code description.
|
VARCHAR2(255)
|
|
FRVINDR
|
FRVINDR_DESC
|
|
LETTER_OF_CREDIT_NUMBER
|
Letter Of Credit Number
|
Actual letter of credit number associated to the payment management system code.
|
VARCHAR2(63)
|
|
FRVPMSC
|
FRVPMSC_LOC_NO
|
|
LOCATION
|
Location
|
Identification accounting code of the physical location the grant has been assigned to.
|
VARCHAR2(63)
|
|
FRRGLOC
|
FRRGLOC_LOCN_CODE
|
|
LOCATION_DESC
|
Location Description
|
Extracted description or title of the associated location.
|
VARCHAR2(255)
|
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
LOCATION_STATUS
|
Location Status
|
Status of the location.
|
VARCHAR2(63)
|
|
FTVLOCN
|
FTVLOCN_STATUS_IND
|
|
LONG_TITLE
|
Long Title
|
Grant long title or description.
|
VARCHAR2(256)
|
|
FRBGRNT
|
FRBGRNT_LONG_TITLE
|
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
|
NA
|
NA
|
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
|
NA
|
NA
|
|
ON_OFF_CAMPUS
|
On Off Campus
|
Where Grant research is being performed. Either On Campus, Off campus or both.
|
VARCHAR2(63)
|
|
FRRGLOC
|
FRRGLOC_LOCN_RESEARCH_IND
|
|
ORGANIZATION_DESC_1
|
Organization Description 1
|
Retrieves description or title level 1 within this organization hierarchy.
|
VARCHAR2(255)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_DESC_2
|
Organization Description 2
|
Retrieves description or title level 2 within this organization hierarchy.
|
VARCHAR2(255)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_DESC_3
|
Organization Description 3
|
Retrieves description or title level 3 within this organization hierarchy.
|
VARCHAR2(255)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_DESC_4
|
Organization Description 4
|
Retrieves description or title level 4 within this organization hierarchy.
|
VARCHAR2(255)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_DESC_5
|
Organization Description 5
|
Retrieves description or title level 5 within this organization hierarchy.
|
VARCHAR2(255)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_DESC_6
|
Organization Description 6
|
Retrieves description or title level 6 within this organization hierarchy.
|
VARCHAR2(255)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_DESC_7
|
Organization Description 7
|
Retrieves description or title level 7 within this organization hierarchy.
|
VARCHAR2(255)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_DESC_8
|
Organization Description 8
|
Retrieves description or title level 8 within this organization hierarchy.
|
VARCHAR2(255)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_LEVEL_1
|
Organization Level 1
|
Retrieves level 1 organization within this organization hierarchy.
|
VARCHAR2(63)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_LEVEL_2
|
Organization Level 2
|
Retrieves level 2 organization within this organization hierarchy.
|
VARCHAR2(63)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_LEVEL_3
|
Organization Level 3
|
Retrieves level 3 organization within this organization hierarchy.
|
VARCHAR2(63)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_LEVEL_4
|
Organization Level 4
|
Retrieves level 4 organization within this organization hierarchy.
|
VARCHAR2(63)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_LEVEL_5
|
Organization Level 5
|
Retrieves level 5 organization within this organization hierarchy.
|
VARCHAR2(63)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_LEVEL_6
|
Organization Level 6
|
Retrieves level 6 organization within this organization hierarchy.
|
VARCHAR2(63)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_LEVEL_7
|
Organization Level 7
|
Retrieves level 7 organization within this organization hierarchy.
|
VARCHAR2(63)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_LEVEL_8
|
Organization Level 8
|
Retrieves level 8 organization within this organization hierarchy.
|
VARCHAR2(63)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_STATUS_1
|
Organization Status 1
|
Retrieves status of level 1 organization within this organization hierarchy.
|
VARCHAR2(63)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_STATUS_2
|
Organization Status 2
|
Retrieves status of level 2 organization within this organization hierarchy.
|
VARCHAR2(63)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_STATUS_3
|
Organization Status 3
|
Retrieves status of level 3 organization within this organization hierarchy.
|
VARCHAR2(63)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_STATUS_4
|
Organization Status 4
|
Retrieves status of level 4 organization within this organization hierarchy.
|
VARCHAR2(63)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_STATUS_5
|
Organization Status 5
|
Retrieves status of level 5 organization within this organization hierarchy.
|
VARCHAR2(63)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_STATUS_6
|
Organization Status 6
|
Retrieves status of level 6 organization within this organization hierarchy.
|
VARCHAR2(63)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_STATUS_7
|
Organization Status 7
|
Retrieves status of level 7 organization within this organization hierarchy.
|
VARCHAR2(63)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGANIZATION_STATUS_8
|
Organization Status 8
|
Retrieves status of level 8 organization within this organization hierarchy.
|
VARCHAR2(63)
|
|
FUNCTION
|
FOKODSF.F_GET_ORGN_HIER
|
|
ORGN_FINANCIAL_MANAGER_ID
|
Organization 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
|
|
ORGN_FINANCIAL_MANAGER_NAME
|
Organization 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
|
|
ORGN_FINANCIAL_MANAGER_UID
|
Organization Financial Manager UID
|
System generated unique internal identification number assigned to the financial manager associated with this organization.
|
NUMBER
|
|
FTVORGN
|
FTVORGN_FMGR_CODE_PIDM
|
|
ORGN_FMGR_CITY
|
Organization Fmgr City
|
City associated with the address.
|
VARCHAR2(63)
|
|
SPRADDR
|
SPRADDR_CITY
|
|
ORGN_FMGR_COUNTY
|
Organization Fmgr County
|
County code associated with the address.
|
VARCHAR2(63)
|
|
SPRADDR
|
SPRADDR_CNTY_CODE
|
|
ORGN_FMGR_COUNTY_DESC
|
Organization Fmgr County Description
|
County address name.
|
VARCHAR2(255)
|
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
ORGN_FMGR_FIRST_NAME
|
Organization Fmgr First Name
|
Financial manager's first or given name.
|
VARCHAR2(63)
|
|
FUNCTION SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_FIRST_NAME
|
|
ORGN_FMGR_LAST_NAME
|
Organization Fmgr Last Name
|
Fund manager's last name or surname.
|
VARCHAR2(63)
|
|
FUNCTION SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME
|
|
ORGN_FMGR_MIDDLE_NAME
|
Organization Fmgr Middle Name
|
Financial manager's middle name.
|
VARCHAR2(63)
|
|
FUNCTION SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_MI
|
|
ORGN_FMGR_NATION
|
Organization Fmgr Nation
|
Nation code associated with the address.
|
VARCHAR2(63)
|
|
SPRADDR
|
SPRADDR_NATN_CODE
|
|
ORGN_FMGR_NATION_DESC
|
Organization Fmgr Nation Description
|
Name of the nation.
|
VARCHAR2(255)
|
|
STVNATN
|
STVNATN_NATION
|
|
ORGN_FMGR_POSTAL_CODE
|
Organization Fmgr Postal Code
|
Address postal code.
|
VARCHAR2(63)
|
|
SPRADDR
|
SPRADDR_ZIP
|
|
ORGN_FMGR_STATE_PROVINCE
|
Organization Fmgr State Province
|
State/Province code for the address.
|
VARCHAR2(63)
|
|
SPRADDR
|
SPRADDR_STAT_CODE
|
|
ORGN_FMGR_STATE_PROVINCE_DESC
|
Organization Fmgr State Province Description
|
State/province name.
|
VARCHAR2(255)
|
|
STVSTAT
|
STVSTAT_DESC
|
|
ORGN_FMGR_STREET_LINE1
|
Organization Fmgr Street Line 1
|
First line of the address.
|
VARCHAR2(255)
|
|
SPRADDR
|
SPRADDR_STREET_LINE1
|
|
ORGN_FMGR_STREET_LINE2
|
Organization Fmgr Street Line 2
|
Second line of the address.
|
VARCHAR2(255)
|
|
SPRADDR
|
SPRADDR_STREET_LINE2
|
|
ORGN_FMGR_STREET_LINE3
|
Organization Fmgr Street Line 3
|
Third line of the address.
|
VARCHAR2(255)
|
|
SPRADDR
|
SPRADDR_STREET_LINE3
|
|
ORGN_FMGR_STREET_LINE4
|
Organization Fmgr Street Line 4
|
Fourth line of the address.
|
VARCHAR2(255)
|
|
SPRADDR
|
SPRADDR_STREET_LINE4
|
|
PAYMENT_MANAGEMENT_SYS_CODE
|
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
|
|
PAYMENT_MANAGEMENT_SYS_DESC
|
Payment Management Sys Description
|
Payment management system description.
|
VARCHAR2(255)
|
|
FRVPMSC
|
FRVPMSC_DESC
|
|
PRINCIPAL_INVESTIGATOR_FNAME
|
Principal Investigator First Name
|
Current first name of the principal investigator.
|
VARCHAR2(63)
|
|
FUNCTION SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_LAST_NAME
|
|
PRINCIPAL_INVESTIGATOR_ID
|
Principal Investigator ID
|
Current identification number of the principal investigator.
|
VARCHAR2(63)
|
|
FUNCTION SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_ID
|
|
PRINCIPAL_INVESTIGATOR_LNAME
|
Principal Investigator Last Name
|
Current last name of the principal investigator.
|
VARCHAR2(63)
|
|
FUNCTION SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_FIRST_NAME
|
|
PRINCIPAL_INVESTIGATOR_MNAME
|
Principal Investigator Middle Name
|
Current middle name of the principal investigator.
|
VARCHAR2(63)
|
|
FUNCTION SPRIDEN
|
MGKFUNC.F_GET_PERSON_INFO SPRIDEN_MI
|
|
PRINCIPAL_INVESTIGATOR_NAME
|
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
|
|
PRINCIPAL_INVESTIGATOR_TITLE
|
Principal Investigator Title
|
Official position/title that belongs to the principal investigator.
|
VARCHAR2(255)
|
|
FRRGRPI
|
FRRGRPI_TITLE
|
|
PRINCIPAL_INVESTIGATOR_UID
|
Principal Investigator UID
|
System internally generated id to uniquely identify the principal investigator for this grant.
|
NUMBER
|
|
FRBGRNT
|
FRBGRNT_PI_PIDM
|
|
PRIN_INVESTIGATOR_EMAIL_ADDR
|
Prin Investigator Email Address
|
Principal investigator's email address.
|
VARCHAR2(255)
|
|
FRRGRPI
|
FRRGRPI_EMAIL
|
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
|
NA
|
NA
|
|
PROJECT_END_DATE
|
Project End Date
|
End date is the last day of the grant period.
|
DATE
|
|
FRBGRNT
|
FRBGRNT_PROJECT_END_DATE
|
|
PROJECT_START_DATE
|
Project Start Date
|
Date the agency awarded the grant.
|
DATE
|
|
FRBGRNT
|
FRBGRNT_PROJECT_START_DATE
|
|
PROPOSAL
|
Proposal
|
Proposal submitted to the agency that has now been awarded this grant.
|
VARCHAR2(63)
|
|
FRBGRNT
|
FRBGRNT_PROP_CODE
|
|
PROPOSAL_LONG_TITLE
|
Proposal Long Title
|
Long description or title of the grant proposal.
|
VARCHAR2(256)
|
|
FRBPROP
|
FRBPROP_LONG_TITLE
|
|
PROPOSAL_SHORT_TITLE
|
Proposal Short Title
|
Short description or title of the grant proposal.
|
VARCHAR2(255)
|
|
FRBPROP
|
FRBPROP_TITLE
|
|
RELATED_GRANT
|
Related Grant
|
Grant code of a prior defined grant used to copy data from into this grant.
|
VARCHAR2(63)
|
|
FRBGRNT
|
FRBGRNT_GRNT_CODE_RELATED
|
|
RENEWAL_REPORT_DATE
|
Renewal Report Date
|
Renewal reporting date of the grant.
|
DATE
|
|
NA
|
NA
|
|
REPORTING_DATE
|
Reporting Date
|
Reporting date of the grant.
|
DATE
|
|
NA
|
NA
|
|
REPORTING_QUARTER1
|
Reporting Quarter 1
|
Reporting for quarter 1 amount.
|
NUMBER
|
|
NA
|
NA
|
|
REPORTING_QUARTER2
|
Reporting Quarter 2
|
Reporting for quarter 2 amount.
|
NUMBER
|
|
NA
|
NA
|
|
REPORTING_QUARTER3
|
Reporting Quarter 3
|
Reporting for quarter 3 amount.
|
NUMBER
|
|
NA
|
NA
|
|
REPORTING_QUARTER4
|
Reporting Quarter 4
|
Reporting for quarter 4 amount.
|
NUMBER
|
|
NA
|
NA
|
|
RESEARCH_PURPOSE
|
Research Purpose
|
Purpose of the research.
|
VARCHAR2(63)
|
|
NA
|
NA
|
|
RESPONSIBLE_ORGANIZATION_CODE
|
Responsible Organization Code
|
Organization code of the responsible administrative office for this grant.
|
VARCHAR2(63)
|
|
FRBGRNT
|
FRBGRNT_ORGN_CODE_RESP_OFFICE
|
|
RESPONSIBLE_ORGANIZATION_DESC
|
Responsible Organization Description
|
Retrieved description or title of the associated organization.
|
VARCHAR2(255)
|
|
FUNCTION
|
F_GET_FINANCE_DESC
|
|
RESPONSIBLE_ORGN_STATUS
|
Responsible Organization Status
|
Current status of the associated organization.
|
VARCHAR2(63)
|
|
FUNCTION
|
F_GET_FINANCE_STATUS
|
|
SHORT_TITLE
|
Short Title
|
Grant short description.
|
VARCHAR2(255)
|
|
FRBGRNT
|
FRBGRNT_TITLE
|
|
SPONSOR_NUMBER
|
Sponsor Number
|
Sponsor agency's reference number.
|
VARCHAR2(63)
|
|
FRBGRNT
|
FRBGRNT_SPONSOR_ID
|
|
STATUS
|
Status
|
Grant status. The most common values are (Inactive or (Active.
|
VARCHAR2(63)
|
|
FRBGRNT
|
FRBGRNT_STATUS_CODE
|
|
STATUS_DATE
|
Status Date
|
Last date a status change occurred for this grant.
|
DATE
|
|
FRBGRNT
|
FRBGRNT_STATUS_DATE
|
|
STATUS_DESC
|
Status Description
|
Retrieved description for grant status.
|
VARCHAR2(255)
|
|
FTVSDAT
|
FTVSDAT_TITLE
|
|
STATUS_FISCAL_PERIOD
|
Status Fiscal Period
|
Extracted fiscal period in which the last status date occurred.
|
VARCHAR2(63)
|
|
FUNCTION
|
F_GET_FISCAL_PERIOD
|
|
STATUS_FISCAL_YEAR
|
Status Fiscal Year
|
Extracted fiscal year in which the last status date occurred.
|
VARCHAR2(63)
|
|
FUNCTION
|
FOFYCNV
|
|
SUBCATEGORY
|
Subcategory
|
Sub category code for grant and proposal classification such as corporation, foundation, state, etc.
|
VARCHAR2(63)
|
|
FRBGRNT
|
FRBGRNT_SUB_CATEGORY
|
|
SUBCATEGORY_DESC
|
Subcategory Description
|
Retrieved description for grant or proposal sub category.
|
VARCHAR2(255)
|
|
FUNCTION
|
FOKODSF.F_GET_SDAT_TITLE
|
|
TERMINATION_DATE
|
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
|
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
|
|
TYPE_OF_RESEARCH
|
Type Of Research
|
Type of research.
|
VARCHAR2(63)
|
|
NA
|
NA
|