TEM ATTENDEE Table
View exposing learning and development attendee reference data including attendee identifiers, names, person and employment attributes, personnel area and subarea, HR organization, office address and phone, and warehouse load date.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ATTENDEE_ID |
Business identifier for the attendee. |
VARCHAR2 |
8 |
ATTENDEE_TYPE_CODE |
Code identifying attendee type. |
VARCHAR2 |
2 |
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 |
PERSON_TYPE |
Person type associated with the record. |
VARCHAR2 |
40 |
TEM_ATTENDEE_KEY |
Surrogate key identifying the tem attendee. |
VARCHAR2 |
12 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |