Human Resources Messages Design Overview

This topic provides an overview of the message design for many of the sync and full-sync Integration Broker messages generated for Human Resources.

PERSON_BASIC_CV_FULLSYNC_EFF Message Design

For the Person Basic Clairvia FullSync Current Effective dated message (PERSON_BASIC_CV_FULLSYNC_EFF) the system uses the Enterprise Components Full Data Publish Utility. The system uses the mapping views on the Full Publish Rule to override the actual message records with views that extract only current effective dated rows for Clairvia employees.

The standard PERSON_BASIC_FULLSYNC message publishes information for all employees, regardless of their enrollment in Clairvia, as well as all past, present and future dated rows of information that is not relevant to Clairvia. Using the mapping views publishes only the current effective-dated information needed by Clairvia to the PERSON_BASIC_CV_FULLSYNC_EFF message immediately. The Full Data Publish Utility ignores historical data and writes future-dated rows to the EO_EFFDELAY delay record. The Enterprise Components Effective Date Publish utility picks up any records from the delay table that are now current and generates PERSON_BASIC_CV_SYNC_EFF messages.

The full data publish utility publishes a data message with all of the PERSON_DATA information for all Clairvia integrated employees.

WORKFORCE_CV_FULLSYNC Message Design

For the Workforce Clairvia FullSync message (WORKFORCE_CV_FULLSYNC) the system uses the Enterprise Components Full Data Publish Utility. The system uses the mapping views on the Full Publish Rule to override the actual message records with views that extract all historical, current and future dated rows for Clairvia employees.

Using the mapping views publishes only the information needed by Clairvia to the WORKFORCE_CV_FULLSYNC message immediately. This message does not use ‘_EFF’ in the message name, so it does not use current effective dating logic and passes all rows over to the new Clairvia message.

The full data publish utility publishes a data message with the workforce information for all Clairvia integrated employees.

JPM_JP_CV_FULLSYNC_EFF Message Design

For the HR Manage Profiles JP Clairvia FullSync Current Effective dated message (JPM_JP_CV_FULLSYN_EFF), the system uses the Enterprise Components Full Data Publish Utility. The system uses the mapping views on the Full Publish Rule to override the actual message records with views that extract only current effective dated rows for Clairvia employees for the desired HR Manage Profiles content type, using the highest ranking qualifier instance content items.

The standard JPM_JP_FULLSYNC message publishes information for all employees, regardless of their enrollment in Clairvia, as well as all qualifier instances and all past, present and future dated rows of information that is not relevant to Clairvia. Using the mapping views publishes only the current effective-dated information needed by Clairvia to the JPM_JP_CV_FULLSYNC_EFF message immediately. The Full Data Publish Utility ignores historical data and writes future dated rows to the EO_EFFDELAY Delay record. The Enterprise Components Effective Date Publish utility picks up any records from the delay table that are now current and generates JPM_JP_CV_SYNC_EFF messages.

The full data publish utility publishes a data message with all of the Profile information for all Clairvia integrated employees.

PERSON_BASIC_CV_SYNC_EFF Message Design

For the Person Basic Clairvia Sync Current Effective-dated message (PERSON_BASIC_CV_SYNC_EFF), the system makes two passes to place the generic data into a format that Clairvia can use. A handler was added to PERSON_BASIC_SYNC for the first pass and a handler added to PERSON_BASIC_CV_SYNC for the second pass.

In the first pass, the data in the PERSON_BASIC_SYNC message is copied to an interim PERSON_BASIC_CV_SYNC message that contains all data except for the PERS_ORG_REL_WK work record, which is not required by Clairvia.

In the second pass, an Enterprise Components routine reads the PERSON_BASIC_CV_SYNC message and determines if the message contains the current effective-dated row. Current effective-dated rows are copied to the PERSON_BASIC_CV_SYNC_EFF message for publishing. Future-dated rows are copied to the EO_EFFDELAY Delay record. The EC Effective Dating utility compares the future dated row to the date on the utility and if the date is now current, generates the PERSON_BASIC_CV_SYNC_EFF message. Historical rows are ignored and not copied to PERSON_BASIC_CV_SYNC_EFF. The Effective Dating utility creates three messages: a header message where PSCAMA. MSG_SEQ_FLG = H, a data message containing the actual data needed by Clairvia and a trailer message where PSCAMA. MSG_SEQ_FLG = T.

JPM_JP_CV_SYNC_EFF Message Design

For the HR Manage Profiles Profile Clairvia Sync Current Effective-dated message (JPM_JP_CV_SYNC_EFF), the system makes two passes to place the generic data into a format that Clairvia can use. A handler was added to JPM_JP_SYNC for the first pass and a handler added to JPM_JP_CV_SYNC for the second pass.

In the first pass, the data in the JPM_JP_SYNC message is copied to an interim JPM_JP_CV_SYNC message after the system removes any content types that are not one of the Clairvia installation table content types.

In the second pass, an Enterprise Components routine reads the JPM_JP_CV_SYNC message and determines if the message contains the current effective-dated row. Current effective-dated rows are copied to the JPM_JP_CV_SYNC_EFF message for publishing. Future-dated rows are copied to the EO_EFFDELAY Delay record. The Effective Dating utility compares the future dated row to the date on the utility and if the date is now current, generates the JPM_JP_CV_SYNC_EFF messages. Historical rows are ignored and not copied to JPM_JP_CV_SYNC_EFF. The Effective Dating utility creates three messages: a header message where PSCAMA. MSG_SEQ_FLG = H, a data message containing the actual data needed by Clairvia and a trailer message where PSCAMA. MSG_SEQ_FLG = T.

WORKFORCE_CV_SYNC Message Design

For the Workforce Sync Clairvia message (WORKFORCE_CV_SYNC), a handler for the message reads the generic WORKFORCE_SYNC message and copies all rows over to WORKFORCE_CV_SYNC that are for Clairvia Employees. All past, present and future data is copied to the WORKFORCE_CV_SYNC message.