Understanding Person and Organization EIPs

Enterprise Learning Management is designed to integrate with other applications to enable the sharing of person and organization data. You can use the EIPs that are delivered with Enterprise Learning Management to import data for internal learners and departments from PeopleSoft HR. PeopleSoft HR remains the system of record for the imported data; this data can be viewed, but not changed, in Enterprise Learning Management.

Note: The delivered EIPs are designed to work with PeopleSoft HR. You can import data from any other XML-compliant HR application; however, modifications to the EIPs are necessary.

Enterprise Learning Management uses full sync and incremental sync EIP messages for importing person and organization data. It is recommended that you:

Run full sync EIPs only during system implementation to import all data for a given message.
Activate incremental EIPs after running full sync EIPs to ensure that additions, modifications, and deletions of data in your HR system are imported into Enterprise Learning Management.
In some cases, data is transferred near-real time.

When you integrate with PeopleSoft HR, Integration Broker technology is used to monitor transactions and synchronize the tables.

When you run an EIP message, the imported data is either loaded directly into the Enterprise Learning Management database or it goes to a staging table for validation before it is loaded. The process depends on the type of data that is being imported. Generally, data that is updated frequently or for which there is a high volume, such as learner and workforce data, goes to a staging table first.

Because of data dependencies, some EIPs must be run in a specific order.

Note: A consultant or system administrator with EIP and Integration Broker experience should be involved in both the initial full sync process and the configuring of incremental sync processes.

Instructions for running scripts are available in the PeopleTools documentation.

See PeopleSoft Integration Broker.

List of Full Sync EIPs for Person and Organization Data

The following table lists the delivered full sync EIP messages for person and organization data, the message subscription PeopleCode, the tables that are populated in Enterprise Learning Management, and an explanation of what happens when a message is initiated.

Message Name / Message Subscription PeopleCode	Staging Table	Destination Record in Enterprise Learning Management	Explanation
BUS_UNIT_HR_FULLSYNC LmBusUnitHRFull		LM_BUS_UNIT_TBL	Deletes all values from the Enterprise Learning Management table and loads all values from HR.
COMPANY_FULLSYNC LM_CompanySync	LM_STG_HR_COMP	PS_LM_HR_COMP_TBL	Loads all values from HR into a staging table for validation. When loading data from the staging table to the final table, data that already exists (key match) is updated; otherwise new data is inserted into the final table.
COUNTRY_FULLSYNC CountryFullSync		COUNTRY_TBL	Deletes all values from the Enterprise Learning Management table and loads all values from HR.
CURRENCY_FULLSYNC CurrencySync		CURRENCY_CD_TBL	Loads all values from HR.
HR_ENROLL_ELM_FULLSYNC LM_TalentpoolLearnerFullSync		LM_PRG_REG	Loads Talent Pool members and associated learning programs from HR.
JOB_CODE_FULLSYNC LmJobCodeFull		LM_JOBCODE_TBL	Loads all values with an LM_JOBCODE_ID, which is different from the HR JobCode ID. The HR JobCode ID and SETID are stored on LM_JOBCODE_TBL.
LM_DEPT_FULLSYNC LmDepartmentFull	LM_STG_DEPT	LM_ORGANIZATION	Loads all values from HR into a staging table for validation. The HR Department ID and Department SETID are stored on LM_ORGANIZATION.
LOCATION_FULLSYNC LmLocationFULLSync	LM_LOCATION_TBL		Loads all values with an LM_LOCATION_ID, which is different from the HR Location ID. The HR Location ID and SETID are stored on LM_LOCATION_TBL.
PERSON_BASIC_FULLSYNC LmPersonSubscription	LM_STG_PRS, LM_STG_PRS_ADDR, LM_STG_PRS_DT, LM_STG_PRS_EML, LM_STG_PRS_NM, LM_STG_PRS_PHN	LM_PERSON LM_PERSON_ADDR LM_PERSON_EMAIL LM_PERSON_NAME LM_PERSON_EFFDT LM_PERSON_PHONE	Loads all values for all active records from HR into the staging tables. Important! Before you run this EIP, you must import user IDs from HR using either the USER_SYNC Application Engine process or the userexport.dms and userimport.dms Datamover scripts.
PERSON_CONTRACT_FULLSYNC LmLearnerContract		LM_LRN_CONTRACT LM_LRN_CONT_TYP	Loads all contract data for learners from HR.
PERS_POI_FULLSYNC LM_PersonPoiSync	LM_STG_PER_POI	LM_PERSON_POI	Loads all person of interest data for learners into a staging table.
POI_TYPE_TBL_FULLSYNC LM_PoiTypeSync	LM_STG_POI_TYP	LM_POI_TYPE_TBL	Loads all person of interest types into a staging table.
POSITION_FULLSYNC LmPositionSyncFull		LM_POSITION	Deletes all values from the Enterprise Learning Management table and loads all values from HR.
SETID_INITIALIZE LmSetID		SETID_TBL	Loads all values. Important! There is no incremental sync EIP for SETID information. You must rerun the full sync table publish process for the SETID_INITIALIZE message on a regular basis to publish any new SETIDs that are created in the HR system to Enterprise Learning Management.
STATE_FULLSYNC StateFullSync		STATE_TBL	Deletes all values from the Enterprise Learning Management table and loads all values from HR.
WORKFORCE_FULLSYNC LmWorkForce	LM_STG_PRS_JOB, LM_STG_PRS_ATT	LM_PERSON_JOB LM_PERSON_ATTRIB	Loads all values from HR into staging tables.

List of Incremental Sync EIPs for Person and Organization Data

The following table lists the delivered incremental sync EIP messages for person and organization data, the message subscription PeopleCode, the tables that are populated in Enterprise Learning Management, and an explanation of what happens when a message is initiated.

Note: The same staging tables are used for both full sync and incremental sync EIP messages.

Message Name and Message Subscription PeopleCode	Destination Record in Enterprise Learning Management	Explanation
BUS_UNIT_HR_SYNC LmBusUnitHR	LM_BUS_UNIT_TBL	Values are added, updated, or deleted to reflect and changes that have been made in PeopleSoft HR.
COMPANY_SYNC LM_CompanySync	PS_LM_HR_COMP_TBL	Loads all changes from HR into a staging table.
COUNTRY_SYNC CountrySync	COUNTRY_TBL	Values are loaded from HR.
CURRENCY_SYNC CurrencySync	CURRENCY_CD_TBL	Values are loaded from HR.
DEPT_SYNC Lm_DepartmentSync	LM_ORGANIZATION	Value is initially loaded into the staging table, LM_STG_DEPT with an LM_ORGANIZATION_ID, which is different from the HR Department ID. The HR Department ID and Department SETID are stored on LM_ORGANIZATION. Learning environment appears by default from the Installation table, if this is an add (the department is new).
HR_ENROLL_ELM_SYNC LM_TalentpoolLearnerSync	LM_PR_REG	Loads any changes from HR to Talent Pool members and associated learning programs since the HR_PRG_ENROLL_FULLSYNC message was run. This includes additions and deletions.
JOBCODE_SYNC LmJobCodeSync	LM_JOBCODE_TBL	Value is loaded with an LM_JOBCODE_ID, which is different from the HR JobCode ID. The HR JobCode ID and SETID are stored in LM_JOBCODE_TBL.
LOCATION_SYNC LmLocationSync	LM_LOCATION_TBL	Loads all values with an LM_LOCATION_ID, which is different from the HR Location ID. The HR Location ID and SETID are stored on LM_LOCATION_TBL.
PERSON_BASIC_SYNC LmPersonSubscription	LM_PERSON LM_PERSON_EFFDT LM_PERSON_PHONE LM_PERSON_NAME LM_PERSON_ADDR LM_PERSON_EMAIL LM_PERSON_OPRID	Person changes are loaded from PeopleSoft HCM. EMPLID is converted to LM_PERSON_ID. Only contact method types that exist in Enterprise Learning Management are loaded (address, phone, email). Only name types that exist in Enterprise Learning Management are loaded.
PERSON_CONTRACT_SYNC LmLearnerContract	LM_LRN_CONTRACT LM_LRN_CONT_TYP	Values are added, updated, or deleted to reflect and changes that have been made in PeopleSoft HR.
POSITION_SYNC LmPositionSync	LM_POSITION	Values are loaded from PeopleSoft HCM.
SETID_INITIALIZE LmSetIDInitialize	SETID_TBL	All values are loaded. Important! PeopleSoft does not deliver an incremental sync EIP for SETID information. You must rerun the full sync table publish process for the SETID_INITIALIZE message on a regular basis to publish any new SETIDs that are created in the HR system to Enterprise Learning Management.
STATE_SYNC StateSync	STATE_TBL	Values are loaded from HR.
USER_PROFILE LM_PersonOprid	PSOPRDEFN PSOPRALIAS PSUSEREMAIL	Values are loaded from HR
WORKFORCE_SYNC LmWorkForce	LM_PERSON_JOB LM_PERSON_ATTRB	Workforce changes are loaded from PeopleSoft HCM. Data is only loaded if person already exists on LM_PERSON. DeptID is converted to LM_ORGANIZATIONID. ChartFields appear by default from learning environment if this is a hire.
PERS_POI_SYNC LM_PersonPoiSync	LM_PERSON_POI	Person of Interest changes are loaded from PeopleSoft HCM. Only new records are loaded. Existing records are not updated.
POI_TYPE_TBL_SYNC LM_PoiTypeSync	LM_POI_TYPE_TBL	Person of Interest types are loaded from PeopleSoft HCM. New values are added and existing values are updated.

Understanding Person and Organization EIPs

Full Sync and Incremental Sync EIPs

List of Full Sync EIPs for Person and Organization Data

List of Incremental Sync EIPs for Person and Organization Data