DW_AWARD_INSTITUTION_LOCATION_D (Preview)

This table requires activation of Grants Management functional area. This table maintains location informaiton of an Institution.

Details

Module: Grants Management

Key Columns

INSTITUTION_LOCATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
INSTITUTION_LOCATION_ID NUMBER 38 0 True ID Primary Key    
SOURCE_RECORD_ID VARCHAR2 256     System    
INSTITUTION_ID NUMBER 38 0   Institution identifier    
LOCATION_ID NUMBER 38 0   location Identifier    
AWARD_LOCATION VARCHAR2 16     Institution Award Location Indicator    
BILLING_LOCATION VARCHAR2 16     Institution Billing Location Indicator    
PRIMARY_FLAG VARCHAR2 16     Primary Institution Location Indicator    
CREATION_DATE TIMESTAMP       InstitutionPEOCreationDate    
LAST_UPDATE_DATE TIMESTAMP       InstitutionPEOLastUpdateDate    

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