IR INSTITUTION Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALTERNATE_INSTITUTION_NAME |
XXX |
VARCHAR2 |
100 |
CITY |
City. |
VARCHAR2 |
80 |
COUNTRY |
XXX |
VARCHAR2 |
100 |
COUNTRY_CODE |
The 3 digit code which identifies a country (Example: USA United States of America). |
VARCHAR2 |
3 |
INSTITUTION_CATEGORY_LABEL |
XXX |
VARCHAR2 |
200 |
INSTITUTION_CATEGORY_VALUE |
XXX |
NUMBER |
|
INSTITUTION_ID |
XXX |
VARCHAR2 |
8 |
INSTITUTION_NAME |
XXX |
VARCHAR2 |
100 |
INSTITUTION_SORT_ORDER |
XXX |
VARCHAR2 |
6 |
RECORD_CREATED_DATE |
The date when the record was created. |
DATE |
|
STATE |
State. |
VARCHAR2 |
3 |
STREET_ADDRESS |
The street address of an MIT building, as distinguished from the mailing address. For example: Walker Memorial, Bldg. 50: Street Address: 142 Memorial Drive; Mailing Address: 77 Massachusetts Avenue. |
VARCHAR2 |
100 |
ZIP |
XXX |
VARCHAR2 |
20 |