HR EDU INSTITUTION Table
Master data tabe containing the names and addresses of Institutions where employees have received their degrees.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
HR_EDU_INSTITUTION_ADDRESS |
Street address of educational institution. |
VARCHAR2 |
80 |
HR_EDU_INSTITUTION_CITY |
City where educational institution is located. |
VARCHAR2 |
35 |
HR_EDU_INSTITUTION_COUNTRY |
Country where educational institution is located. |
VARCHAR2 |
3 |
HR_EDU_INSTITUTION_ID |
Code assigned to the educational institution where the degree was awarded. |
VARCHAR2 |
6 |
HR_EDU_INSTITUTION_KEY |
XXX |
VARCHAR2 |
6 |
HR_EDU_INSTITUTION_NAME |
Name of educational institution where degree was earned. |
VARCHAR2 |
50 |
HR_EDU_INSTITUTION_STATE |
State where educational institution is located. |
VARCHAR2 |
3 |
HR_EDU_INSTITUTION_ZIP |
Zip code of educational institution. |
VARCHAR2 |
10 |
HR_EDU_INSTITUTN_COUNTRY_NAME |
XXX |
VARCHAR2 |
100 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |