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    

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