PROPOSAL - Report
| Data Element |
Business Definition |
Data Type |
Source Name |
Source Data Element |
Form Name |
| PROPOSAL_CODE |
INSTITUTIONAL DEFINED OR SYSTEM ASSIGNED PROPOSAL IDENTIFICATION CODE. |
|
FRBPROP |
FRBPROP_CODE |
UNKNOWN |
| PROPOSAL_LONG_TITLE |
LONG TITLE. |
|
FRBPROP |
FRBPROP_LONG_TITLE |
UNKNOWN |
| PROPOSAL_SHORT_TITLE |
SHORT TITLE. |
|
FRBPROP |
FRBPROP_TITLE |
UNKNOWN |
| GRANT_ID |
GRANT CODE. |
|
FRBPROP |
FRBPROP_GRNT_CODE |
UNKNOWN |
| GRANT_TITLE |
GRANT NAME. |
|
FRBGRNT |
FRBGRNT_TITLE |
UNKNOWN |
| GRANT_AWARD_AMOUNT |
GRANT AWARD AMOUNT. |
|
FRBGRNT |
FRBGRNT_CURRENT_FUNDING_AMT |
UNKNOWN |
| PRINCIPAL_INVESTIGATOR_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
FRBPROP |
FRBPROP_PI_PIDM |
UNKNOWN |
| PRINCIPAL_INVESTIGATOR_IND |
PRINCIPAL INVESTIGATOR INDICATOR. |
|
FRRPRPI |
FRRPRPI_ID_IND |
UNKNOWN |
| PRINCIPAL_INVESTIGATOR_ID |
ID OF THE PRINCIPAL INVESTIGATOR. |
|
FUNCTION |
F_GET_SPRIDEN_ID |
UNKNOWN |
| PRINCIPAL_INVESTIGATOR_FNAME |
PERSON'S FIRST OR GIVEN NAME. |
|
FUNCTION |
F_GET_SPRIDEN_FIRST_NAME |
UNKNOWN |
| PRINCIPAL_INVESTIGATOR_MNAME |
PERSON'S MIDDLE NAME |
|
FUNCTION |
F_GET_SPRIDEN_MI |
UNKNOWN |
| PRINCIPAL_INVESTIGATOR_LNAME |
PERSON'S LAST NAME OR SURNAME. |
|
FUNCTION |
F_GET_SPRIDEN_LAST_NAME |
UNKNOWN |
| FEDERAL_IDENTIFICATION |
CFDA NUMBER. |
|
FRBPROP |
FRBPROP_CFDA_INTERNAL_ID_NO |
UNKNOWN |
| SPONSOR_NUMBER |
AN INFORMATIONAL FIELD USED FOR AD HOC REPORTING. |
|
FRBPROP |
FRBPROP_SPONSOR_ID |
UNKNOWN |
| AGENCY_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
FRBPROP |
FRBPROP_AGENCY_PIDM |
UNKNOWN |
| AGENCY_NUMBER |
PERSON'S ID NUMBER USED TO ACCESS THE RECORDS. |
|
FUNCTION |
F_GET_SPRIDEN_ID |
UNKNOWN |
| AGENCY_NAME |
NAME OF THE AGENCY SPONSORING THE GRANT. |
|
FUNCTION |
F_GET_SPRIDEN_LAST_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 |
| REQUESTED_AMOUNT |
AMOUNT . |
|
FRBPROP |
FRBPROP_REQUESTED_AMT |
UNKNOWN |
| CHART_OF_ACCOUNTS |
INSTITUTIONAL DEFINED VALUE FOR THE CHART OF ACCOUNTS. |
|
FRBPROP |
FRBPROP_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. |
|
FRBPROP |
FRBPROP_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 |
| CURRENT_STATUS |
CURRENT STATUS. |
|
FRBPROP |
FRBPROP_STATUS_CODE |
UNKNOWN |
| CURRENT_STATUS_DATE |
CURRENT STATUS DATE. |
|
FRBPROP |
FRBPROP_STATUS_DATE |
UNKNOWN |
| PROPOSAL_TYPE |
PROPOSAL TYPE. |
|
FRBPROP |
FRBPROP_PROPOSAL_TYPE |
UNKNOWN |
| CATEGORY |
CATEGORY FOR MEETING TIME. |
|
FRBPROP |
FRBPROP_CATEGORY |
UNKNOWN |
| SUBCATEGORY |
A SUB CATEGORY CODE FOR THE GRANT CLASSIFICATION SUCH AS CORPORATION |
|
FRBPROP |
FRBPROP_SUB_CATEGORY |
UNKNOWN |
| LOCATION |
PHYSICAL LOCATION OF THE INSTALLMENT'S FINANCIAL MANAGER. |
|
FRRPLOC |
FRRPLOC_LOCN_CODE |
UNKNOWN |
| LOCATION_DESC |
HIERARCHY DESCRIPTION OR TITLE APPROPRIATE FOR THIS LEVEL. |
|
FTVLOCN |
FTVLOCN_TITLE |
UNKNOWN |
| ON_OFF_CAMPUS |
ON/OFF CAMPUS INDICATOR. |
|
FRRPLOC |
FRRPLOC_RESEARCH_IND |
UNKNOWN |
| ORIGINATION_DATE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| ORIGINATION_FISCAL_YEAR |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| ORIGINATION_FISCAL_PERIOD |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| SUBMISSION_DATE |
DATE THE LOAN APPLICATION WAS SUBMITTED. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
| SUBMISSION_FISCAL_YEAR |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| SUBMISSION_FISCAL_PERIOD |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| AWARD_DATE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| AWARD_FISCAL_YEAR |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| AWARD_FISCAL_PERIOD |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| DECLINE_DATE |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| DECLINE_FISCAL_YEAR |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |
| DECLINE_FISCAL_PERIOD |
|
|
NA |
NOT AVAILABLE |
UNKNOWN |