HR EDU INSTITUTION Table
Reference table of educational institutions, including identifiers, name, and location attributes used to support HR education reporting and education-history fact tables.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HR_EDU_INSTITUTION_ADDRESS |
Mailing street address for the educational institution. |
VARCHAR2 |
80 |
HR_EDU_INSTITUTION_CITY |
City for the educational institution address. |
VARCHAR2 |
35 |
HR_EDU_INSTITUTION_COUNTRY |
Country code for the educational institution address. |
VARCHAR2 |
3 |
HR_EDU_INSTITUTION_ID |
Source-system identifier for the educational institution. |
VARCHAR2 |
6 |
HR_EDU_INSTITUTION_KEY |
Surrogate key uniquely identifying an educational institution record. |
VARCHAR2 |
6 |
HR_EDU_INSTITUTION_NAME |
Name of the educational institution (e.g., university or college). |
VARCHAR2 |
100 |
HR_EDU_INSTITUTION_STATE |
State or province abbreviation for the educational institution address. |
VARCHAR2 |
3 |
HR_EDU_INSTITUTION_ZIP |
Postal code for the educational institution address. |
VARCHAR2 |
10 |
HR_EDU_INSTITUTN_COUNTRY_NAME |
Country name for the educational institution address. |
VARCHAR2 |
400 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |