Integrating Setup Data
This topic discusses how to:
Understand setup data integration.
Configure web services for setup data.
Understand the setup data loading sequence.
Use delivered EIPs.
Note: Documentation relevant to Campus Solutions and Human Capital Management integration is available on My Oracle Support (ID 2091799.2).
In all integration configurations, some setup data underlies all person transactions. This setup data needs to be synchronized between the HCM instance and CS. The following list is of the data integrated in one direction, from HCM to CS:
Address Types
National ID Types
Ethnic Groups
HCM Business Units
Currency Codes
Company Codes
Major Subject Codes
Country Codes
State Codes
Departments
Holiday Date Schedules
Job Codes
Locations
Schools
Majors
Name Titles
Name Types
Name Prefixes
Name Royal Prefixes
Name Royal Suffixes
Name Suffixes
Name Formats
POI Types
Regulatory Regions
Regional Transactions
SetIDs
TableSet Controls
U.S. Standard Occupational Codes
Visa Permit Types
Visa Permit Documents
Oracle delivers several EIPs to automate the process of synchronizing setup data between CS and HCM; this ensures that the setup data underlying the transactional data remains in sync. Other delivered EIPs enable your institution to integrate data in support of External Search/Match and core business processes.
Note that person data EIPs are designated sync or fullsync. Fullsync EIPs republish all the data in their source records at once. Incremental sync EIPs send real-time sync messages; as soon as you make a change in the database of record, the system triggers the sync and sends only the changed information to the other database. This section discusses how to configure FullSync Service Operations.
See Configuring Web Services for Person Data
Configuring Full Sync Service Operations
The following steps for setting up and activating each FullSync service operation in Integration Broker must be performed on the source and target databases.
Source Database Configuration Tasks
Note: These source database configuration instructions are for an HCM 9.1/9.2 database on PeopleTools 8.54.
Update security by adding the Service Operation(s) to your primary permission list:
Navigate to
Select the relevant permission list from the search dialog box.
Select the Web Services tab.
Enter the corresponding Service(s) for the Service Operation(s) you wish to use.
Click the Edit link. On the Web Service Permissions secondary page, add access to the relevant Service Operation(s) listed by selecting the Full Access option for the Access column.
This example illustrates the fields and controls on the Web Services page-Permission List.
This example illustrates the fields and controls on the Web Services Permissions page for HCM.
Activate Service Operations and create Routings.
Navigate to
Select the relevant Service Operation(s) from the search dialog box.
Check the Active check box on the General tab.
Make note of the Queue Name field, as you need to verify later that the Queue status is Running.
Select the Routings tab and add a new routing for the Service Operation by entering a value in the Routing Name field and clicking the Add button.
This example illustrates the fields and controls on the General page for the COUNTRY_FULLSYNC service operation.
This example illustrates the fields and controls on the Routings page for the COUNTRY_FULLSYNC service operation.
Enter a Sender Node and a Receiver Node on the Routings Definition page of the Routings component.
Verify that the Active check box is checked.
Save the routing.
Click the Return button at the bottom of the Routings Definition page to return to the Service Operation setup component.
Click Save at the bottom of any page in the Service Operations component to save the Service Operation.
This example illustrates the fields and controls on the Routing Definitions page for the COUNTRY_FULLSYNC service operation.
Activate Message Queue.
Navigate to
Scroll down the page to find the relevant Queue Name (from the Service Operation setup page noted earlier).
Review the queue Status and activate the queue by clicking the Run button if needed. Before leaving this page, ensure that queue status is set to Running.
Target Database Configuration Tasks
Note: These target database configuration instructions are for a CS 9.2 database on PeopleTools 8.54.
Update security by adding the service operation to the required user’s permission list.
Navigate to
Select the relevant permission list from the search dialog box (primary permission list for the user).
Select the Web Services tab.
Enter the corresponding Service(s) for the Service Operation(s) you wish to leverage.
Click the Edit link and add access to the relevant Service Operation(s) listed on the Web Service Permissions secondary page.
Click OK to return to the Web Services page.
Click Save to save the updated Permission List.
This example illustrates the fields and security controls on the Web Services page.
This example illustrates the fields and security controls on the Web Service Permissions page in Campus Solutions.
Activate Service Operation and Create Routing.
Navigate to
.Select the relevant Service Operation(s) from the search dialog box.
Select the Active check box on the General tab.
Make note of the Queue Name field, as you need to verify later that the Queue status is Running.
This example illustrates the fields and controls on the General page for the COUNTRY_FULLSYNC service operation.
Select the Routings tab and add a new routing for the Service Operation.
Enter a Sender Node and a Receiver Node on the Routings Definition page of the Routings component.
Verify that the Active check box is checked.
Click Save at the bottom of the Routings Definition page to save the routing.
Click the Return at the bottom of the Routings Definition page to return to the Service Operation setup component.
Click Save at the bottom of any page in the Service Operations component to save the Service Operation.
This example illustrates the fields and controls on the Routings page for the COUNTRY_FULLSYNC service operation.
This example illustrates the fields and controls on the Routing Definitions page for the COUNTRY_FULLSYNC service operation.
Activate or create the required Service Operations OnNotify handler.
Click the Handlers tab of the Service Operations component and set up the following:
This example illustrates the fields and controls on the Handlers page for the COUNTRY_FULLSYNC service operation.
Field or Control
Description
Name
Enter a Handler Name if one does not exist. For example, BusUnitHRFullSync.
See the Full Sync Service Operations table (Application Package Name/ Class/ Method column) for the required value for this field.
Type
OnNotify
Implementation
Application Class
Status
Active
Click the Details link and set up the following:
This example illustrates the fields and controls on the Handler Details page.
Field or Control
Description
Package Name
For example, GEN_UPG_HANDLER_12332. See the FullSync Service Operations table (Application Package Name/ Class/ Method column) for the required value for this field.
Path
:
Class ID
For example, CountryFullSync. See the FullSync Service Operations table (Application Package Name/ Class/ Method column) for the required value for this field.
Method
OnNotify
Click OK to return to the Handlers setup page.
Click Save at the bottom of the Handlers page to save your changes.
Activate Message Queue.
Navigate to
Scroll down the page to find the relevant Queue Name (from the Service Operation setup page noted earlier).
Review the queue Status and activate the queue by clicking Run if needed.
Executing the Full Data Publish Utility
Run the Full Data Publish process to synchronize data between your HCM and CS systems.
Define Full Data Publish Rules.
Navigate to
and set up the following:This example illustrates the fields and controls on the Full Table Publish Rules page for the COUNTRY_FULLSYNC service operation.
Field or Control
Description
Message Name
Name of the Service Operation.
Publish Rule ID
Enter a publish rule ID.
Description
Enter a description of the Publish Rule.
Status
Set to Active.
Check the Create Message Header and Create Message Trailer check boxes.
Save the page.
Execute the Full Data Publish Process.
Navigate to
and set up the following:This example illustrates the fields and controls on the Full Data Publish page.
Field or Control
Description
Run Control ID
Create a new Run Control ID.
Request ID
Enter a Request ID.
Process Frequency
Select Always.
Parameters
Select the existing Service Operation, for example, COUNTRY_FULLSYNC.
Save the page and click Run.
Select the Full Table Data Publish process from the Process Scheduler Request page and verify that the process runs successfully.
This example illustrates the fields and controls on the Process Scheduler Request page where the Full Table Data Publish process is selected.
Navigate to
to review the status of the Full Sync messages created by the Full Data Publish process.This example illustrates the fields and controls on the Operation Instances page to monitor asynchronous service operations.
Minimum setup information must be available and loaded from your HCM system to your CS system for implementation. This should be completed before performing any transactional data syncs. The values defined in these setup tables are key to person bio-demo data integrity. Oracle recommends that your HCM instance be the system of record for your setup table data.
The table below lists the available service operations and applicable tables. These should load in the order specified.
Integration Description |
Integration Name |
Table (s) |
---|---|---|
Country Codes |
COUNTRY_FULLSYNC |
COUNTRY_TBL |
Currency Codes |
CURRENCY_FULLSYNC |
CURRENCY_CD_TBL |
State/Province Codes |
STATE_FULLSYNC |
STATE_TBL |
SetIDs |
SETID_INITIALIZE |
SETID_TBL |
Tableset Controls |
TBLSET_CONTROL_INITIALIZE |
SET_CNTRL_TBL SET_CNTRL_GROUP SET_CNTRL_REC |
Regulatory Regions |
REGULATORY_REGION_FULLSYNC |
REG_REGION_TBL HR |
Business Units |
BUS_UNIT_HR_FULLSYNC |
BUS_UNIT_TBL_HR |
Company Codes |
COMPANY_FULLSYNC |
COMPANY_TBL |
Location Codes |
LOCATION_FULLSYNC |
LOCATION_TBL |
Department Codes |
DEPT_FULLSYNC |
DEPT_TBL |
Job Codes |
JOBCODE_FULLSYNC |
JOBCODE_TBL |
Holiday Date Schedules |
HOLIDAY_DATE_FULLSYNC |
HOLIDAY_TBL HOLIDAY_DATE |
National ID Types |
NID_TYPE_FULLSYNC |
NID_TYPE_TBL |
Name Types |
NAME_TYPE_FULLSYNC |
NAME_TYPE_TBL |
Name Prefixes |
NAME_PREFIX_SUFFIX_FULLSYNC1 |
NAME_PREFIX_TBL |
Name Suffixes |
NAME_PREFIX_SUFFIX_FULLSYNC2 |
NAME_SUFFIX_TBL |
Name Royal Prefixes |
NAME_PREFIX_SUFFIX_FULLSYNC3 |
NM_ROYPREF_TBL |
Name Royal Suffixes |
NAME_PREFIX_SUFFIX_FULLSYNC4 |
NM_ROYSUFF_TBL |
Name Titles |
TITLE_FULLSYNC |
TITLE_TBL |
Address Types |
ADDRESS_TYPE_FULLSYNC |
ADDRESS_TYP_TBL |
Person of Interest Types |
POI_TYPE_TBL_FULLSYNC |
POI_TYPE_TBL |
Ethnic Group Codes |
ETHNIC_GRP_FULLSYNC |
ETHNIC_GROUP_TBL |
US Standard Occupational Codes (USA) |
US_SOC_FULLSYNC |
US_SOC_TBL |
Supporting Documents (Visa/Permits) |
SUPPORT_DOC_FULLSYNC |
SUPPORT_DOC_TBL |
Visa Permit Types |
VISA_PERMIT_FULLSYNC |
VISA_PERMIT_TBL |
VISA_PERMIT_SUP |
Major Codes COMPETENCY_FULLSYNC3 |
MAJOR_TBL |
Service Operations and Handlers
The following table identifies the FullSync and Sync Service Operations, and subscription handlers that you should use to configure your CS–HCM setup data integrations. Activate and configure all integrations that you have identified according to your business requirements and implementation plans.
Service Operation |
Description |
Queue |
Subscription Handler App Package |
---|---|---|---|
ADDRESS_TYPE_FULLSYNC |
Address Type Table |
PERSON_SETUP |
AddressTypeFullSync (ADDRESS_TYPE_FULLSYNC/AddressTypeFullSync/OnNotify) |
ADDRESS_TYPE_SYNC |
Address Type Table |
PERSON_SETUP |
AddressTypeSync (ADDRESS_TYPE_SYNC/AddressTypeSync/OnNotify) |
BUS_UNIT_HR_FULLSYNC |
HR Business Unit Table |
HR_SETUP |
BusUnitHRFullSync (BUS_UNIT_HR_FULLSYNC/BusUnitHRFullSync/OnNotify) |
BUS_UNIT_HR_SYNC |
Business Unit Table |
HR_SETUP |
BusUnitHRSync (BUS_UNIT_HR_SYNC/BusUnitHRSync/OnNotify) |
COMPANY_FULLSYNC |
Company Codes |
PERSON_SETUP |
CompanyFullSync (COMPANY_FULLSYNC/CompanyFullSync/OnNotify) |
COMPANY_SYNC |
Company Codes |
PERSON_SETUP |
CompanySync (COMPANY_SYNC/CompanySync/OnNotify) |
COMPETENCY_FULLSYNC3 |
College Major Subject Codes |
COMPETENCY |
CompetencyFullSync3 (COMPETENCY_FULLSYNC3/CompetencyFullSync3/OnNotify) |
COMPETENCY_SYNC3 |
College Major Subject Codes |
COMPETENCY |
CompetencySync3 (COMPETENCY_SYNC3/CompetencySync3/OnNotify) |
COUNTRY_FULLSYNC |
Countries |
ENTERPRISE_SETUP |
GEN_UPG_HANDLER_12332 (COUNTRY_FULLSYNC/CountryFullSync/OnNotify) |
COUNTRY_SYNC |
Countries |
ENTERPRISE_SETUP |
GEN_UPG_HANDLER_18170 (COUNTRY_SYNC/CountrySync/OnNotify) |
CURRENCY_FULLSYNC |
Currency Codes |
ENTERPRISE_SETUP |
CurrencyFullSync CURRENCY_FULLSYNC/CurrencyFullSync/OnNotify |
CURRENCY_SYNC |
Currency Codes |
ENTERPRISE_SETUP |
CurrencySync CURRENCY_SYNC/CurrencySync/OnNotify |
DEPT_FULLSYNC |
Departments |
ENTERPRISE_SETUP |
DeptFullSync (DEPT_FULLSYNC/DeptFullSyncNoCI/OnNotify) |
DEPT_SYNC |
Departments |
ENTERPRISE_SETUP |
DeptSync (DEPT_FULLSYNC/DeptSyncNoCI/OnNotify) |
ETHNIC_GRP_FULLSYNC |
Ethnic Group Table |
TAM_INTEGRATION |
EthnicGrpFullSync ETHNIC_GRP_FULLSYNC/EthnicGrpFullSync/OnNotify |
ETHNIC_GRP_SYNC |
Ethnic Group Table |
TAM_INTEGRATION |
EthnicGrpSync ETHNIC_GRP_SYNC/EthnicGrpSync/OnNotify |
HOLIDAY_DATE_FULLSYNC |
Holiday Date Schedules |
PERSON_SETUP |
HolidayDateFullSync HOLIDAY_DATE_FULLSYNC/HolidayDateFullSync/OnNotify |
HOLIDAY_DATE_SYNC |
Holiday Date Schedules |
PERSON_SETUP |
HolidayDateSync HOLIDAY_DATE_SYNC/HolidayDateSync/OnNotify |
JOBCODE_FULLSYNC |
Job Codes |
PERSON_SETUP |
JobcodeFullSyncJOBCODE_FULLSYNC/JobcodeFullSyncNoCI/OnNotify |
JOBCODE_SYNC |
Job Codes |
PERSON_SETUP |
JobcodeSync JOBCODE_SYNC/JobcodeSyncNoCI/OnNotify |
LOCATION_FULLSYNC |
Company Site Locations |
ENTERPRISE_SETUP |
LocationFullSync (LOCATION_FULLSYNC/LocationFullSyncNoCI/OnNotify) |
LOCATION_SYNC |
Company Site Locations |
ENTERPRISE_SETUP |
LocationSync (LOCATION_SYNC/LocationSyncNoCI/OnNotify) |
NAME_PREFIX_SUFFIX_FULLSYNC1 |
Name |
Prefixes |
NAME_PREFIX_SUFFIX_TABLES NamePrefixSuffixFullSync1 NAME_PREFIX_SUFFIX_FULLSYNC1/NamePrefixSuffixFullSync1/OnNotify |
NAME_PREFIX_SUFFIX_FULLSYNC2 |
Name |
SuffixTable |
NAME_PREFIX_SUFFIX_TABLES NamePrefixSuffixFullSync2 NAME_PREFIX_SUFFIX_FULLSYNC2/NamePrefixSuffixFullSync2/OnNotify |
NAME_PREFIX_SUFFIX_FULLSYNC3 |
Name Royal Pref Table |
NAME_PREFIX_SUFFIX_TABLES |
NamePrefixSuffixFullSync3 NAME_PREFIX_SUFFIX_FULLSYNC3/NamePrefixSuffixFullSync3/OnNotify |
NAME_PREFIX_SUFFIX_FULLSYNC4 |
Name Royal Suff Table |
NAME_PREFIX_SUFFIX_TABLES |
NamePrefixSuffixFullSync4 NAME_PREFIX_SUFFIX_FULLSYNC4/NamePrefixSuffixFullSync4/OnNotify |
NAME_PREFIX_SUFFIX_SYNC1 |
Name Prefixes |
NAME_PREFIX_SUFFIX_TABLES |
NamePrefixSuffixSync1 NAME_PREFIX_SUFFIX_SYNC1/NamePrefixSuffixSync1/OnNotify |
NAME_PREFIX_SUFFIX_SYNC2 |
Name SuffixTable |
NAME_PREFIX_SUFFIX_TABLES |
NamePrefixSuffixSync2 NAME_PREFIX_SUFFIX_SYNC2/NamePrefixSuffixSync2/OnNotify |
NAME_PREFIX_SUFFIX_SYNC3 |
Name Royal Pref Table |
NAME_PREFIX_SUFFIX_TABLES |
NamePrefixSuffixSync3 NAME_PREFIX_SUFFIX_SYNC3/NamePrefixSuffixSync3/OnNotify |
NAME_PREFIX_SUFFIX_SYNC4 |
Name Royal Suff Table |
NAME_PREFIX_SUFFIX_TABLES |
NamePrefixSuffixSync4 NAME_PREFIX_SUFFIX_SYNC4/NamePrefixSuffixSync4/OnNotify |
NAME_TYPE_FULLSYNC |
Name Type Table |
PERSON_SETUP |
NameTypeFullSync NAME_TYPE_FULLSYNC/NameTypeFullSync/OnNotify |
NAME_TYPE_SYNC |
Name Type Table |
PERSON_SETUP |
NameTypeSync NAME_TYPE_SYNC/NameTypeSync/OnNotify |
NID_TYPE_FULLSYNC |
National ID Type table |
PERSON_SETUP |
NidTypeFullSync NID_TYPE_FULLSYNC/NidTypeFullSync/OnNotify |
NID_TYPE_SYNC |
National ID Type table |
PERSON_SETUP |
NidTypeSync NID_TYPE_SYNC/NidTypeSync/OnNotify |
OPR_DEF_FULLSYNC |
Operator Defaults Table - HR |
TAM_INTEGRATION |
OprDefFullSync OPR_DEF_FULLSYNC/OprDefFullSync/OnNotify |
OPR_DEF_SYNC |
Operator Defaults Table - HR |
TAM_INTEGRATION |
OprDefSync OPR_DEF_SYNC/OprDefSync/OnNotify |
POI_TYPE_TBL_FULLSYNC POI |
Type Table |
PERSON_SETUP |
POITypeTBLFullSync POI_TYPE_TBL_FULLSYNC/POITypeTblFullSync/OnNotify |
POI_TYPE_TBL_SYNC POI |
Type Table |
PERSON_SETUP |
POITypeTBLSync POI_TYPE_TBL_SYNC/POITypeTblSync/OnNotify |
REGULATORY_REGION_FULLSYNC |
Regulatory Region |
PERSON_SETUP |
RegRegionFullSync REG_REGION_FULLSYNC/RegRegionFullSync/OnNotify |
REGULATORY_REGION_SYNC |
Regulatory Region |
PERSON_SETUP |
RegRegionSync REG_REGION_SYNC/RegRegionSync/OnNotify |
SETID_INITIALIZE |
SetIDs |
TBLSET_CONTROL |
SetidInitialize (SETID_INITIALIZE/SetidInitialize/OnNotify) |
STATE_FULLSYNC |
State Codes |
ENTERPRISE_SETUP |
StateFullSync STATE_FULLSYNC/StateFullSync/OnNotify |
STATE_SYNC |
State Codes |
ENTERPRISE_SETUP |
StateSync STATE_SYNC/StateSync/OnNotify |
SUPPORT_DOC_FULLSYNC |
Visa Supporting Documents |
TAM_INTEGRATION |
SupportDocFullSync SUPPORT_DOC_FULLSYNC/SupportDocFullSync/OnNotify |
SUPPORT_DOC_SYNC |
Visa Supporting Documents |
TAM_INTEGRATION |
SupportDocSync SUPPORT_DOC_SYNC/SupportDocSync/OnNotify |
TBLSET_CONTROL_INITIALIZE |
TableSet Control Records |
TBLSET_CONTROL |
TblsetControlInitialize TBLSET_CONTROL_INITIALIZE/TblsetControlInitiatlize/OnNotify |
TITLE_FULLSYNC |
Title Table |
PERSON_SETUP |
TitleFullSync TITLE_FULLSYNC/TitleFullSync/OnNotify |
TITLE_SYNC |
Title Table |
PERSON_SETUP |
TitleSync TITLE_SYNC/TitleSync/OnNotify |
US_SOC_FULLSYNC |
US Standard Occupational Codes |
PERSON_SETUP |
USSocFullSync US_SOC_FULLSYNC/USSocFullSync/OnNotify |
US_SOC_SYNC US |
Standard Occupational Codes |
PERSON_SETUP |
USSocSync US_SOC_SYNC/USSocSync/OnNotify |
VISA_PERMIT_FULLSYNC |
Visa Permit Types |
VISA_PERMIT |
VisaPermitFullSync VISA_PERMIT_FULLSYNC/VisaPermitFullSync/OnNotify |
VISA_PERMIT_SYNC |
Visa Permit Types |
VISA_PERMIT |
VisaPermitSync VISA_PERMIT_SYNC/VisaPermitSync/OnNotify |
See also:
PeopleTools: Integration Broker Testing Utilities and Tools
The following table lists delivered EIPs that support CS-to-HCM integration.
EIP Name |
Description |
---|---|
ADDRESS_TYPE_FULLSYNC |
Address Type Table |
ADDRESS_TYPE_SYNC |
Address Type Table |
BUS_UNIT_HR_FULLSYNC |
HR Business Unit Table |
BUS_UNIT_HR_SYNC |
HR Business Unit Table |
COMPANY_FULLSYNC |
Company Codes |
COMPANY_SYNC |
Company Codes |
COMPETENCY_FULLSYNC3 |
College Major Subject Codes |
COMPETENCY_SYNC3 |
College Major Subject Codes |
COUNTRY_FULLSYNC |
Countries |
COUNTRY_SYNC |
Countries |
CURRENCY_FULLSYNC |
Currency Codes |
CURRENCY_SYNC |
Currency Codes |
DEPT_FULLSYNC |
Departments |
DEPT_SYNC |
Departments |
ETHNIC_GRP_FULLSYNC |
Ethnic Group Table |
ETHNIC_GRP_SYNC |
Ethnic Group Table |
HOLIDAY_DATE_FULLSYNC |
Holiday Date Schedules |
HOLIDAY_DATE_SYNC |
Holiday Date Schedules |
JOBCODE_FULLSYNC |
Job Codes |
JOBCODE_SYNC |
Job Codes |
LOCATION_FULLSYNC |
Company Site Locations |
LOCATION_SYNC |
Company Site Locations |
NAME_PREFIX_SUFFIX_FULLSYNC1 |
Name Prefixes |
NAME_PREFIX_SUFFIX_FULLSYNC2 |
Name Suffix Table |
NAME_PREFIX_SUFFIX_FULLSYNC3 |
Name Royal Pref Table |
NAME_PREFIX_SUFFIX_FULLSYNC4 |
Name Royal Suff Table |
NAME_PREFIX_SUFFIX_SYNC1 |
Name Prefixes |
NAME_PREFIX_SUFFIX_SYNC2 |
Name Suffix Table |
NAME_PREFIX_SUFFIX_SYNC3 |
Name Royal Pref Table |
NAME_PREFIX_SUFFIX_SYNC4 |
Name Royal Suff Table |
NAME_TYPE_FULLSYNC |
Name Type Table |
NAME_TYPE_SYNC |
Name Type Table |
NID_TYPE_FULLSYNC |
National ID Type Table |
NID_TYPE_SYNC |
National ID Type Table |
OPR_DEF_FULLSYNC |
Operator Defaults Table - HR |
OPR_DEF_SYNC |
Operator Defaults Table - HR |
PERS_POI_FULLSYNC |
Dflt Transaction Tbl for POIs |
PERS_POI_SYNC |
Dflt Transaction Tbl for POIs |
PERSON_BASIC_FULLSYNC |
Person |
PERSON_BASIC_SYNC |
Person |
PERSON_DISABILITY_FULLSYNC |
Disability |
PERSON_DISABILITY_SYNC |
Disability |
PERSON_DIVERSITY_FULLSYNC |
Diversity Data |
PERSON_DIVERSITY_SYNC |
Diversity Data |
PERS_EMERGNCY_CONTACT_SYNC |
Emergency Contacts |
PERS_EMERGNCY_CONTACT_FULLSYNC |
Emergency Contacts |
PERSON_VISA_CITIZEN_FULLSYNC1 |
EE/Dependent Citizenship |
PERSON_VISA_CITIZEN_FULLSYNC2 |
EE/Depndnt Visa Support Docs |
PERSON_VISA_CITIZEN_SYNC |
EE/Dependent Citizenship |
POI_TYPE_TBL_FULLSYNC |
POI Type Table |
POI_TYPE_TBL_SYNC |
POI Type Table |
REGULATORY_REGION_FULLSYNC |
Regulatory Region |
REGULATORY_REGION_SYNC |
Regulatory Region |
SETID_INITIALIZE |
SetIDs |
STATE_FULLSYNC |
State Codes/Names w/in Country |
STATE_SYNC |
State Codes/Names w/in Country |
SUPPORT_DOC_FULLSYNC |
Visa Supporting Documents |
SUPPORT_DOC_SYNC |
Visa Supporting Documents |
TBLSET_CONTROL_INITIALIZE |
TableSet Control Records |
TITLE_FULLSYNC |
Title Table |
TITLE_SYNC |
Title Table |
US_SOC_FULLSYNC |
U.S. Standard Occupational Codes |
US_SOC_SYNC |
U.S. Standard Occupational Codes |
USER_PROFILE |
User Profiles |
VISA_PERMIT_FULLSYNC |
Visa Supporting Docs Needed |
VISA_PERMIT_SYNC |
Visa Supporting Docs Needed |
WORKFORCE_FULLSYNC |
Job and Person Org Assignments |
WORKFORCE_SYNC |
Job and Person Org Assignments |