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 This column is for Oracle Internal use only. 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