COUNTRY OF ORIGIN Table
XXX
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
COUNTRY |
XXX |
VARCHAR2 |
100 |
COUNTRY_CODE |
The 3 digit code which identifies a country (Example: USA United States of America). |
VARCHAR2 |
20 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
LAST_ACTIVITY_DATE |
Date when information in the record was last updated. |
DATE |
|
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
NOTE |
For the LIBRARY FINANCIAL DETAIL and LIBRARY ALLOCATION DETAIL tables, the NOTE field contains detailed explanation of the budget transaction. May be system assigned e.g. INVOICE, ORDER ENCUMBRANCE (Z601-NOTE). For the CIP table, this field contains additional information regarding the CIP program. |
VARCHAR2 |
200 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |