IR INSTITUTION Table
View exposing institution reference records including institution name, alternate name, address, country, category, and related attributes.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALTERNATE_INSTITUTION_NAME |
Alternate institution name associated with the record. |
VARCHAR2 |
100 |
CITY |
City associated with the record. |
VARCHAR2 |
80 |
COUNTRY |
Country associated with the record. |
VARCHAR2 |
100 |
COUNTRY_CODE |
Code identifying country. |
VARCHAR2 |
3 |
INSTITUTION_CATEGORY_LABEL |
Institution category label associated with the record. |
VARCHAR2 |
200 |
INSTITUTION_CATEGORY_VALUE |
Institution category value associated with the record. |
NUMBER |
|
INSTITUTION_ID |
Business identifier for the institution. |
VARCHAR2 |
8 |
INSTITUTION_NAME |
Institution name associated with the record. |
VARCHAR2 |
100 |
INSTITUTION_SORT_ORDER |
Institution sort order associated with the record. |
VARCHAR2 |
6 |
RECORD_CREATED_DATE |
Date associated with record created. |
DATE |
|
STATE |
State associated with the record. |
VARCHAR2 |
3 |
STREET_ADDRESS |
Street address associated with the record. |
VARCHAR2 |
100 |
ZIP |
Zip associated with the record. |
VARCHAR2 |
20 |