GRANT_VIEW - Report
| Data Element |
Business Definition |
Data Type |
Source Name |
Source Data Element |
Form Name |
| GRANT_ID |
GRANT CODE. |
|
FRBGRNT |
FRBGRNT_CODE |
UNKNOWN |
| LONG_TITLE |
|
|
FRBGRNT |
FRBGRNT_LONG_TITLE |
UNKNOWN |
| SHORT_TITLE |
NAME GIVEN TO IDENTIFY THIS GRANT. |
|
FRBGRNT |
FRBGRNT_TITLE |
UNKNOWN |
| PRINCIPAL_INVESTIGATOR_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
FRBGRNT |
FRBGRNT_PI_PIDM |
UNKNOWN |
| PRINCIPAL_INVESTIGATOR_ID |
ID OF THE PRINCIPAL INVESTIGATOR. |
|
SPRIDEN |
SPRIDEN_ID |
UNKNOWN |
| PRINCIPAL_INVESTIGATOR_FNAME |
PERSON'S FIRST OR GIVEN NAME. |
|
SPRIDEN |
SPRIDEN_FIRST_NAME |
UNKNOWN |
| PRINCIPAL_INVESTIGATOR_MNAME |
PERSON'S MIDDLE NAME |
|
SPRIDEN |
SPRIDEN_MI |
UNKNOWN |
| PRINCIPAL_INVESTIGATOR_LNAME |
PERSON'S LAST NAME OR SURNAME. |
|
SPRIDEN |
SPRIDEN_LAST_NAME |
UNKNOWN |
| FEDERAL_IDENTIFICATION |
CFDA NUMBER. |
|
FRBGRNT |
FRBGRNT_CFDA_INTERNAL_ID_NO |
UNKNOWN |
| SPONSOR_NUMBER |
AN INFORMATIONAL FIELD USED FOR AD HOC REPORTING. |
|
FRBGRNT |
FRBGRNT_SPONSOR_ID |
UNKNOWN |
| AGENCY_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
FRBGRNT |
FRBGRNT_AGENCY_PIDM |
UNKNOWN |
| AGENCY_ID |
PERSON'S ID NUMBER USED TO ACCESS THE RECORDS. |
|
SPRIDEN |
SPRIDEN_PIDM |
UNKNOWN |
| AGENCY_NAME |
NAME OF THE AGENCY SPONSORING THE GRANT. |
|
SPRIDEN |
F_FORMAT_NAME |
UNKNOWN |
| AGENCY_UID_LEVEL_1 |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
SPRIDEN |
SPRIDEN_PIDM |
UNKNOWN |
| AGENCY_ID_LEVEL_1 |
"AGENCY ID LEVEL 1." |
|
SPRIDEN |
SPRIDEN_ID |
UNKNOWN |
| AGENCY_NAME_LEVEL_1 |
"AGENCY NAME LEVEL 1. USES FUNCTION GET THE NAME FOR THE LEVEL UNIQUE IDENTIFIER." |
|
SPRIDEN |
SPRIDEN_LAST_NAME |
UNKNOWN |
| AGENCY_UID_LEVEL_2 |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
SPRIDEN |
SPRIDEN_PIDM |
UNKNOWN |
| AGENCY_ID_LEVEL_2 |
"AGENCY ID LEVEL 2." |
|
SPRIDEN |
SPRIDEN_ID |
UNKNOWN |
| AGENCY_NAME_LEVEL_2 |
"AGENCY NAME LEVEL 2. USES FUNCTION GET THE NAME FOR THE LEVEL UNIQUE IDENTIFIER." |
|
SPRIDEN |
SPRIDEN_LAST_NAME |
UNKNOWN |
| AGENCY_UID_LEVEL_3 |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
SPRIDEN |
SPRIDEN_PIDM |
UNKNOWN |
| AGENCY_ID_LEVEL_3 |
"AGENCY ID LEVEL 3." |
|
SPRIDEN |
SPRIDEN_ID |
UNKNOWN |
| AGENCY_NAME_LEVEL_3 |
"AGENCY NAME LEVEL 3. USES FUNCTION GET THE NAME FOR THE LEVEL UNIQUE IDENTIFIER." |
|
SPRIDEN |
SPRIDEN_LAST_NAME |
UNKNOWN |
| AGENCY_UID_LEVEL_4 |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
SPRIDEN |
SPRIDEN_PIDM |
UNKNOWN |
| AGENCY_ID_LEVEL_4 |
"AGENCY ID LEVEL 4." |
|
SPRIDEN |
SPRIDEN_ID |
UNKNOWN |
| AGENCY_NAME_LEVEL_4 |
"AGENCY NAME LEVEL 4. USES FUNCTION GET THE NAME FOR THE LEVEL UNIQUE IDENTIFIER." |
|
SPRIDEN |
SPRIDEN_LAST_NAME |
UNKNOWN |
| FULL_AMOUNT |
|
|
FRBGRNT |
FRBGRNT_MAX_FUNDING_AMT |
UNKNOWN |
| CURRENT_YEAR_AMOUNT |
|
|
FRBGRNT |
FRBGRNT_CURRENT_FUNDING_AMT |
UNKNOWN |
| CUMULATIVE_AMOUNT |
|
|
FRBGRNT |
FRBGRNT_CUM_FUNDING_AMT |
UNKNOWN |
| CHART_OF_ACCOUNTS |
INSTITUTIONAL DEFINED VALUE FOR THE CHART OF ACCOUNTS. |
|
FRBGRNT |
FRBGRNT_COAS_CODE |
UNKNOWN |
| CHART_OF_ACCOUNTS_DESC |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVCOAS |
FTVCOAS_TITLE |
UNKNOWN |
| ORGANIZATION_CODE |
IDENTIFIES THE INDIVIDUAL ORGANIZATION CODE WHICH APPEARS ON A TRANSACTION. |
|
FRBGRNT |
FRBGRNT_ORGN_CODE_RESP_OFFICE |
UNKNOWN |
| ORGANIZATION_DESC |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVORGN |
FTVORGN_TITLE |
UNKNOWN |
| ORGANIZATION_LEVEL_1 |
PRIMARY ORGANIZATION WITHIN THE ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_ORGN_CODE |
UNKNOWN |
| ORGANIZATION_DESC_1 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVORGN |
FTVORGN_TITLE |
UNKNOWN |
| ORGANIZATION_STATUS_1 |
STATUS OF THE PRIMARY ORGANIZATION WITHIN THE ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_STATUS_IND |
UNKNOWN |
| ORGANIZATION_LEVEL_2 |
LEVEL 2 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_ORGN_CODE |
UNKNOWN |
| ORGANIZATION_DESC_2 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVORGN |
FTVORGN_TITLE |
UNKNOWN |
| ORGANIZATION_STATUS_2 |
STATUS OF THE LEVEL 2 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_STATUS_IND |
UNKNOWN |
| ORGANIZATION_LEVEL_3 |
LEVEL 3 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_ORGN_CODE |
UNKNOWN |
| ORGANIZATION_DESC_3 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVORGN |
FTVORGN_TITLE |
UNKNOWN |
| ORGANIZATION_STATUS_3 |
STATUS OF THE LEVEL 3 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_STATUS_IND |
UNKNOWN |
| ORGANIZATION_LEVEL_4 |
LEVEL 4 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_ORGN_CODE |
UNKNOWN |
| ORGANIZATION_DESC_4 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVORGN |
FTVORGN_TITLE |
UNKNOWN |
| ORGANIZATION_STATUS_4 |
STATUS OF THE LEVEL 4 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_STATUS_IND |
UNKNOWN |
| ORGANIZATION_LEVEL_5 |
LEVEL 5 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_ORGN_CODE |
UNKNOWN |
| ORGANIZATION_DESC_5 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVORGN |
FTVORGN_TITLE |
UNKNOWN |
| ORGANIZATION_STATUS_5 |
STATUS OF THE LEVEL 5 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_STATUS_IND |
UNKNOWN |
| ORGANIZATION_LEVEL_6 |
LEVEL 6 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_ORGN_CODE |
UNKNOWN |
| ORGANIZATION_DESC_6 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVORGN |
FTVORGN_TITLE |
UNKNOWN |
| ORGANIZATION_STATUS_6 |
STATUS OF THE LEVEL 6 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_STATUS_IND |
UNKNOWN |
| ORGANIZATION_LEVEL_7 |
LEVEL 7 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_ORGN_CODE |
UNKNOWN |
| ORGANIZATION_DESC_7 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVORGN |
FTVORGN_TITLE |
UNKNOWN |
| ORGANIZATION_STATUS_7 |
STATUS OF THE LEVEL 7 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_STATUS_IND |
UNKNOWN |
| ORGANIZATION_LEVEL_8 |
LEVEL 8 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_ORGN_CODE |
UNKNOWN |
| ORGANIZATION_DESC_8 |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVORGN |
FTVORGN_TITLE |
UNKNOWN |
| ORGANIZATION_STATUS_8 |
STATUS OF THE LEVEL 8 ORGANIZATION WITHIN THIS ORGANIZATION HIERARCHY. |
|
FTVORGN |
FTVORGN_STATUS_IND |
UNKNOWN |
| GRANT_TYPE |
|
|
FRBGRNT |
FRBGRNT_GRANT_TYPE |
UNKNOWN |
| GRANT_TYPE_DESC |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| CATEGORY |
CATEGORY FOR MEETING TIME. |
|
FRBGRNT |
FRBGRNT_CATEGORY |
UNKNOWN |
| SUBCATEGORY |
A SUB CATEGORY CODE FOR THE GRANT CLASSIFICATION SUCH AS CORPORATION |
|
FRBGRNT |
FRBGRNT_SUB_CATEGORY |
UNKNOWN |
| PROJECT_START_DATE |
|
|
FRBGRNT |
FRBGRNT_PROJECT_START_DATE |
UNKNOWN |
| PROJECT_END_DATE |
|
|
FRBGRNT |
FRBGRNT_PROJECT_END_DATE |
UNKNOWN |
| EXPENDITURE_END_DATE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| PROPOSAL |
|
|
FRBGRNT |
FRBGRNT_PROP_CODE |
UNKNOWN |
| TYPE_OF_RESEARCH |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| RESEARCH_PURPOSE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| FIELD_OF_SCIENCE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| STATUS |
STATUS OF THE ACADEMIC OUTCOME AND IDENTIFIES THOSE OUTCOMES THAT ARE PENDING OR AWARDED. |
|
FRBGRNT |
FRBGRNT_STATUS_CODE |
UNKNOWN |
| STATUS_DESC |
DESCRIPTION FOR THE STATUS CODE . |
|
NA |
NOT AVAILABLE |
UNKNOWN |
| REPORTING_DATE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| FISCAL_REPORTING_DATE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| RENEWAL_REPORT_DATE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| REPORTING_QUARTER1 |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| REPORTING_QUARTER2 |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| REPORTING_QUARTER3 |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| REPORTING_QUARTER4 |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| STATUS_DATE |
DATE THE APPLICANT STATUS WAS ENTERED. |
|
FRBGRNT |
FRBGRNT_STATUS_DATE |
UNKNOWN |
| STATUS_FISCAL_PERIOD |
|
|
FRBGRNT |
CALCULATION. |
UNKNOWN |
| STATUS_FISCAL_YEAR |
|
|
FRBGRNT |
CALCULATION. |
UNKNOWN |
| LETTER_OF_CREDIT_NUMBER |
|
|
FRVPMSC |
FRVPMSC_LOC_NO |
UNKNOWN |
| PAYMENT_MANAGEMENT_SYS_CODE |
|
|
FRBGBIL |
FRBGBIL_PMSC_CODE |
UNKNOWN |
| PAYMENT_MANAGEMENT_SYS_DESC |
|
|
FRVPMSC |
FRVPMSC_DESC |
UNKNOWN |
| LOCATION |
PHYSICAL LOCATION OF THE INSTALLMENT'S FINANCIAL MANAGER. |
|
FRRGLOC |
FRRGLOC_LOCN_CODE |
UNKNOWN |
| LOCATION_TITLE |
|
|
FTVLOCN |
FTVLOCN_TITLE |
UNKNOWN |
| ON_OFF_CAMPUS |
ON/OFF CAMPUS INDICATOR. |
|
FRRGLOC |
FRRGLOC_LOCN_RESEARCH_IND |
UNKNOWN |