TEM INSTRUCTOR Table
View exposing TEM instructor reference data including instructor identifiers, names, personnel area and subarea, employee type, employment status, HR organization, office address and phone, and warehouse load date.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
EMPLOYEE_TYPE |
Employee type associated with the record. |
VARCHAR2 |
40 |
EMPLOYMENT_STATUS |
Employment status associated with the record. |
VARCHAR2 |
30 |
FIRST_NAME |
First name associated with the person or organization. |
VARCHAR2 |
40 |
FULL_NAME |
Full name associated with the person or organization. |
VARCHAR2 |
100 |
HR_ORG_UNIT_ID |
Business identifier for the hr org unit. |
VARCHAR2 |
8 |
HR_ORG_UNIT_TITLE |
Hr org unit title associated with the record. |
VARCHAR2 |
75 |
LAST_NAME |
Last name associated with the person or organization. |
VARCHAR2 |
40 |
MIDDLE_NAME |
Middle name associated with the person or organization. |
VARCHAR2 |
40 |
OFFICE_ADDRESS |
Office address associated with the record. |
VARCHAR2 |
40 |
OFFICE_PHONE |
Office phone associated with the record. |
VARCHAR2 |
15 |
PERSONNEL_AREA |
Personnel area associated with the record. |
VARCHAR2 |
40 |
PERSONNEL_AREA_CODE |
Code identifying personnel area. |
VARCHAR2 |
25 |
PERSONNEL_SUBAREA |
Personnel subarea associated with the record. |
VARCHAR2 |
40 |
PERSONNEL_SUBAREA_CODE |
Code identifying personnel subarea. |
VARCHAR2 |
25 |
TEM_INSTRUCTOR_CODE |
Code identifying tem instructor. |
VARCHAR2 |
12 |
TEM_INSTRUCTOR_KEY |
Surrogate key identifying the tem instructor. |
VARCHAR2 |
12 |
TEM_INSTRUCTOR_TYPE_CODE |
Code identifying tem instructor type. |
VARCHAR2 |
2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |