DW_AWARD_INSTITUTION_D (Preview)

This table requires activation of Grants Management functional area. This table contains information of Award Institutions.

Details

Module: Grants Management

Key Columns

INSTITUTION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
INSTITUTION_ID NUMBER 38 0 True Primary key for instituion
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. System
DUNS_NUMBER VARCHAR2 128 D-U-N-S Number
UEI_NUMBER VARCHAR2 128 Unique Entity Identifier
NIH_IPF VARCHAR2 128 NIH IPF Number
DHHS_ENTITY_NUMBER VARCHAR2 128 DHHS Entity Number
PARENT_INSTITUTION NUMBER 38 0 Parent Institution
CREATION_DATE TIMESTAMP InstitutionPEOCreationDate
LAST_UPDATE_DATE TIMESTAMP InstitutionPEOLastUpdateDate