This table requires activation of Grants Management functional area. This table contains information of Award Institutions.
Module: Grants Management
INSTITUTION_ID
| 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.