PeopleSoft Human Resources Management
To synchronize data with PeopleSoft Human Resources Management (HRMS), PeopleSoft Grants subscribes to application messages. Application messaging is based on the publish-and-subscribe model, which enables PeopleSoft applications to integrate with each other and with third-party applications.
On one end, a message is created and published; on the other end, the message is delivered to any number of subscribers. PeopleSoft Grants subscribes to the following application messages:
For more information, see
PeopleTools: Integration Broker Administration
Action/Reason
These application messages synchronize changes to person data resulting from business activities such as promotions, transfers, terminations, salary increases, and leaves of absence as well as the reasons for taking the actions.
| Message Name | Table |
|---|---|
|
ACTION_REASON_SYNC ACTION_REASON_FULLSYNC |
PS_ACTN_REASON_TBL PS_ACTN_RSN_LANG |
Business Unit Table HR
These application messages determine whether a business unit exists in the business unit table. If so, the business unit populates the description work fields. If the business unit does not exist, it is added to the business unit table. Call functions populate the TableSet controls.
| Message Name | Table |
|---|---|
|
BUS_UNIT_HR_SYNC BUS_UNIT_HR_FULLSYNC |
PS_BUS_UNIT_TBL_HR PS_BUS_UNIT_HR_LNG |
Job Code Table
These application messages synchronize job code information, such as job code, effective dates, and salary grade.
| Message Name | Table |
|---|---|
|
JOBCODE_SYNC JOBCODE_FULLSYNC |
PS_JOBCODE_TBL PS_JOBCODE_LANG |
Name Prefix and Suffix Tables
These application messages synchronize all of the name prefixes or titles.
| Message Name | Tables |
|---|---|
|
NAME_PREFIX_SUFFIX_SYNC NAME_PREFIX_SUFFIX_FULLSYNC1 NAME_PREFIX_SUFFIX_FULLSYNC2 NAME_PREFIX_SUFFIX_FULLSYNC3 NAME_PREFIX_SUFFIX_FULLSYNC4 |
PS_NAME_PREFIX_TBL PS_NAME_SUFFIX_TBL PS_NAME_PREFIX_LNG PS_NAME_SUFFIX_LNG PS_NM_ROYSUFF_TBL PS_NM_ROYPREF_TBL PS_NM_ROYPREF_LNG PS_NM_ROYSUFF_LNG |
Person Accomplishments
These application messages synchronize a person's accomplishment information, such as accomplishments, majors, and date issued.
| Message Name | Table |
|---|---|
|
PERSON_ACCOMP_SYNC PERSON_ACCOMP_FULLSYNC |
PS_ACCOMPLISHMENTS PS_ACCOMP_TBL_LANG PS_ACCOMPLISH_LANG |
Person Competency
These application messages synchronize a person's competency information, such as college major and accomplishments.
| Message Name | Tables |
|---|---|
|
COMPETENCY_SYNC COMPETENCY_FULLSYNC |
PS_MAJOR_TBL PS_ACCOMP_TBL PS_MAJOR_TBL_LANG |
Person Diversity
These application messages synchronize data relating to an employee's nationality and nationality-based work eligibility.
| Message Name | Table |
|---|---|
|
PERSON_DIVERSITY_SYNC PERSON_DIVERSITY_FULLSYNC |
PS_DIVERSITY |
Person Prior Work Experience
These application messages synchronize details of an employee's previous employers and jobs.
| Message Name | Table |
|---|---|
|
PERSON_PRIOR_WORK_SYNC PERSON_PRIOR_WORK_FULLSYNC |
PS_PRIORWORK_EXPER PS_PRIORWRK_EX_LNG. |
Personal Data
These application messages synchronize an employee or applicant's basic information, such as name, address, and email address.
| Message Name | Tables |
|---|---|
|
PERSON_BASIC_SYNC PERSON_BASIC_FULLSYNC |
PS_EMAIL_ADDRESSES PS_PERS_DATA_EFFDT PS_PERS_NID PS_PERSONAL_DATA PS_PERSONAL_PHONE PS_NAMES PS_PERSONL_DTA_LNG PS_PERS_DTAEFF_LNG |
Position Data
These application messages synchronize position data, such as position status, status date, effective date, and reason code.
| Message Name | Table |
|---|---|
|
POSITION_SYNC POSITION_FULLSYNC |
PS_POSITION_DATA PS_POSN_DATA_LANG |
School Table
These application messages synchronize school code, description, state, and school type information with an external system.
| Message Name | Table |
|---|---|
|
SCHOOL_SYNC SCHOOL_FULLSYNC |
PS_SCHOOL_TBL PS_SCHOOL_TBL_LANG |
State Table
These application messages synchronize state name, description, and abbreviation information.
| Message Names | Table |
|---|---|
|
STATE_SYNC STATE_FULLSYNC |
PS_STATE_NAMES_TBL PS_STATE_NAMES_LNG |
Workforce Data
These application messages synchronize workforce information, such as employee job history data (including actions taken, department, job code, location, and salary history), based on the records in the JOB_DATA panel group.
| Message Name | Table |
|---|---|
|
WORKFORCE_SYNC WORKFORCE_FULLSNYC |
PS_JOB PS_EMPLOYMENT PS_EMPLOYMENT_LNG |