1. Tables and Views for HCM
  2. PER_INTG_TALEO_EXPORT_M

PER_INTG_TALEO_EXPORT_M

This table holds information about the person records that needs to be exported as part of integration.

Details

  • Schema: FUSION

  • Object owner: PER

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

PER_INTEG_TALEO_EXPORT_M_PK

TALEO_EXPORT_ID, EFFECTIVE_LATEST_CHANGE, EFFECTIVE_SEQUENCE, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

Columns

Name Datatype Length Precision Not-null Comments
TALEO_EXPORT_ID NUMBER 18 Yes This is a system generated primary key. Surrogate key.
PERSON_ID NUMBER 18 System generated unique identifier for a person.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
BUSINESS_GROUP_ID NUMBER 18 Identifier of Enterprise, used for multi-tenancy partitioning.
DATE_OF_BIRTH DATE Date of birth of the person for export.
PERSON_NUMBER VARCHAR2 30 Number assigned to the person, to identify the person uniquely in any context, not dependent on being an employee, contingent worker, etc.
PERSON_ID1 NUMBER 18 System generated unique identifier for a person.
EFFECTIVE_START_DATE DATE Yes Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE DATE Yes Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
FIRST_NAME VARCHAR2 150 First name of the person. This value is copied from per_person_names_f.
PERSON_NAME_ID NUMBER 18 System generated identifier for person name.
EFFECTIVE_START_DATE1 DATE Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE1 DATE Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
NAME_VERSION_NUMBER NUMBER 9 Object version number from person name.
MIDDLE_NAMES VARCHAR2 80 Middle names of the person. This value is copied from per_person_names_f table.
LAST_NAME VARCHAR2 150 Last name of the person. This value is copied from per_person_names_f table.
EMAIL_ADDRESS VARCHAR2 240 Email address of the person. This value is copied from per_email_addresses table.
EMAIL_ADDRESS_ID NUMBER 18 Email address identifier of the person.
EMAIL_VERSION_NUMBER NUMBER 9 Object version number from email address.
DISPLAY_PHONE_NUMBER VARCHAR2 4000 Display phone number of the person.
PHONE_ID NUMBER 18 Phone identifier of the person.
EXTENSION VARCHAR2 60 Extension phone number of the person.
NATIONAL_IDENTIFIER_NUMBER VARCHAR2 30 National identifier number of the person.
NATIONAL_IDENTIFIER_ID NUMBER 18 National identifier of the person.
NID_VERSION_NUMBER NUMBER 9 Object version number of national identifier.
USERNAME VARCHAR2 100 The latest principal username of the user
USER_ID NUMBER 18 System generated unique identifier for the user record of a person.
USER_VERSION_NUMBER NUMBER 9 Object version number from per_users table for the person.
USER_ACCOUNT_ACTIVE_FLAG VARCHAR2 2 Indicates if the person has an active user account.
NAME VARCHAR2 240 Denotes the translated name for the Organization Unit.
ORGANIZATION_ID NUMBER 18 System generated unique identifier for an organization.
EFFECTIVE_START_DATE4 DATE Effective start date of the organization.
EFFECTIVE_END_DATE4 DATE Effective end date of the organization.
DEPT_VERSION_NUMBER NUMBER 9 Object version number of the organization.
ORGANIZATION_CODE VARCHAR2 500 Code of the organization. This value will be unique for an organization.
ORGANIZATION_ID1 NUMBER 18 System generated identifier for the organization.
EFFECTIVE_START_DATE5 DATE Effective start date of the organization.
EFFECTIVE_END_DATE5 DATE Effective end date of the organization.
CLASSIFICATION_CODE VARCHAR2 40 Classification code of the organization.
ORG_VERSION_NUMBER NUMBER 9 Object version number of the organization.
NAME1 VARCHAR2 240 Translated name of the job according to session langauge.
JOB_ID NUMBER 18 System generated identifier of the job.
EFFECTIVE_START_DATE6 DATE Effective start date of the job.
EFFECTIVE_END_DATE6 DATE Effective end date of the job of the person for export.
JOB_VERSION_NUMBER NUMBER 9 Object version number of the job.
USERNAME1 VARCHAR2 100 The latest principal username of the manager.
USER_ID1 NUMBER 18 System generated user identifier for the manager.
MGR_VERSION_NUMBER NUMBER 9 Object version number of the user record of manager.
ADDRESS_LINE11 VARCHAR2 240 Address Line 1 of the person's home address.
ADDRESS_LINE21 VARCHAR2 240 Address Line 2 of the person's home address.
ADDRESS_LINE31 VARCHAR2 240 Address Line 3 of the person's home address.
ADDRESS_LINE41 VARCHAR2 240 Address Line 4 of the person's home address.
POSTAL_CODE1 VARCHAR2 30 Postal code of the person's home address.
REGION_11 VARCHAR2 120 Region 1 of the person's home address.
TIMEZONE_CODE1 VARCHAR2 50 Timezone code of the person's home address
COUNTRY1 VARCHAR2 60 Country of the person's home address.
ADDRESS_ID NUMBER 18 System generated identifier of the person's home address.
EFFECTIVE_START_DATE3 DATE Effective start date of the person's home address.
EFFECTIVE_END_DATE3 DATE Effective end date of the person's home address.
CORRESPONDENCE_LANGUAGE VARCHAR2 60 Lookup identifies language to use for this communication.
ADDRESS_LINE_1 VARCHAR2 240 Address line 1 of the location.
ADDRESS_LINE_2 VARCHAR2 240 Address line 2 of the location.
ADDRESS_LINE_3 VARCHAR2 240 Address line 3 of the location.
ADDRESS_LINE_4 VARCHAR2 240 Address line 4 of the location.
COUNTRY VARCHAR2 60 Country of the location of the person for export.
LOCATION_CODE VARCHAR2 60 Code of the location of the person for export.
LOCATION_NAME VARCHAR2 240 Name of the location of the person for export.
POSTAL_CODE VARCHAR2 30 Postal code of the location's address.
REGION_1 VARCHAR2 120 Primary region in which the address is located.
TIMEZONE_CODE VARCHAR2 50 Specifies the standard timezone boundary under which the address falls.
TOWN_OR_CITY VARCHAR2 60 Name of town or city of the location.
LOCATION_ID NUMBER 18 System generated identifier of the location.
EFFECTIVE_START_DATE2 DATE Effective start date of the location.
EFFECTIVE_END_DATE2 DATE Effective end date of the location.
USER_TYPE_COLLECTION VARCHAR2 10 User type collection value for the export process.
USER_TYPE_1 VARCHAR2 240 User type for the export process.
JOB_ROLE_CODE VARCHAR2 20 Job role code for the export process.
CONFIRM_PROFILE VARCHAR2 20 Confirm profile value for the export process.
INTERNAL_CANDIDATE VARCHAR2 20 Indicates if the candidate is internal.
CANDIDATE_PROFILE_LANGUAGE VARCHAR2 10 Profile language of the candidate.
EMPLOYEE_STATUS VARCHAR2 20 Status of the employee. Indicates if the employee is active.
CONFIGURATION_PROFILE_CODE VARCHAR2 20 Configuration profile code value for the export process.
MANAGER_LEVEL NUMBER 10 Manager level of the person.Indicates the manager hierarchy level of the person.
APPLICANT_NUMBER VARCHAR2 30 Unique number for people who are applicants. This is in addition to PERSON_NUMBER. Allows global tracking of applicants..
BUSINESS_UNIT_ID NUMBER 18 Determinant for set enabled tables and those using business unit as a partitioning key.
VACANCY_ID NUMBER 18 Vacancy identifier for the job or position for which person is a candidate.
ASSIGNMENT_ID NUMBER 18 Yes System generated unique identifier for the assignment of a person.
EFFECTIVE_START_DATE7 DATE Effective start date of assignment.
EFFECTIVE_END_DATE7 DATE Effective end date of assignment.
EFFECTIVE_SEQUENCE NUMBER 4 Yes Date Effective Entity: indicates the order of different changes made during a day. The lowest value represents the earliest change in the day.
EFFECTIVE_LATEST_CHANGE VARCHAR2 30 Yes Date Effective Entity: 'Y' indicates that this row represents the latest change in the day.
ASG_VERSION_NUMBER NUMBER 9 Object version number of assignment.
HOMEADDRESSTOWNORCITY VARCHAR2 60 Name of the town or city of the person's home address.
ACTION_LAST_UPDATE_DATE TIMESTAMP Last update date of action for the export process.
ACTION_ACTION_DATE TIMESTAMP Indicates the first start date for the export process.
NAME_LAST_UPDATE_DATE TIMESTAMP Last update date of person name for the export process.
PERPPF_LAST_UPDATE_DATE TIMESTAMP Last update date of person's workrelationship for the export process.
USER_LAST_UPDATE_DATE TIMESTAMP Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server).
PERSON_LAST_UPDATE_DATE TIMESTAMP Last update date of person for the export process.
EMAIL_LAST_UPDATE_DATE TIMESTAMP Last update date of person's email for the export process.
NID_LAST_UPDATE_DATE TIMESTAMP Last update date of person's national identifier for the export process.
ADDRESS_LAST_UPDATE_DATE TIMESTAMP Last update date of person's address for the export process.
ROLE_LAST_UPDATE_DATE TIMESTAMP Last update date of role for the export process.
PHONE_LAST_UPDATE_DATE TIMESTAMP Last update date of person's phone for the export process.
ASSIGNMENT_STATUS_TYPE VARCHAR2 30 Assignment status type of person.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index Uniqueness Tablespace Columns
PER_INTG_TALEO_EXPORT_M_PK Unique Default TALEO_EXPORT_ID, EFFECTIVE_LATEST_CHANGE, EFFECTIVE_SEQUENCE, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE