DW_AWARD_INSTITUTION_D

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     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    

Copyright © 2019, 2023, Oracle and/or its affiliates.