Receive Employee Service

importEmployee imports data into the production table using Oracle Applications HRMS APIs. It also uses the execEmployeeProg, execEmpAssignCreateProg, and execEmpAssignUpdateProg services to execute the required internal HRMS APIs. Since a single database transaction spans over multiple service calls for the inbound Employee transaction, set the AutoCommit setting to OFF to control the entire transaction through the webMethods service. If execution is successful, it commits the entire transaction for Employee Header information and Employee Assignments information to the database. If the status of the execution is FAILED due to exceptions thrown by HRMS APIs or due to data error, it rolls back the entire transaction. When the execution status is FAILED, the HRMS returns the business error messages returned by the HRMS APIs captures them in the empImportResults document, which can then be sent to the trading partners.

Field Name	Description
ACTION	Required. Add or change employee information.
ACTION_SUBTYPE	Required when ACTION indicates a change to employee information. Values are Update or Correct.
EMPLOYEE NUMBER	Number assigned to existing employees. If the employee number generation is automatic in the applications for new employees, this field should be null.
EFFECTIVE_START_DATE	Required.
EFFECTIVE_END_DATE
BUSINESS_GROUP_NAME	Required. Name of the business group to which the employee belongs.
PERSON_TYPE_CODE	Required. Example values are Employee, Consultant, or Temporary.
LAST_NAME	Required. Employee’s last name.
FIRST_NAME	Employee’s first name.
START_DATE	Required. Start date of hire for the employee.
APPLICANT_NUMBER	Number assigned to an applicant.
COMMENT
DATE_EMPLOYEE_DATA_VERIFIED	Date when the employee last verified the data.
DATE_OF_BIRTH	Required.
DATE_OF_DEATH
EMAIL_ADDRESS
EXPENSE_CHECK_SEND_TO_ADDRESS	Mailing address.
FULL_NAME	Employee’s full name.
KNOWN_AS	Preferred name, if different from first name.
PRIMARY_ADDRESS_FLAG	Required.
ADDRESS_STYLE	Required. Address style for specific region.
ADDRESS_TYPE	Required. Address type such as H for home or M for mailing.
ADDRESS_LINE1	Required. Corresponding address of the employee.
ADDRESS_LINE2
ADDRESS_LINE3
CITY	Required.
STATE	Required.
POSTAL_CODE	Required.
COUNTY	Required.
COUNTRY	Required.
PHONE_TYPE	Required. Customized field value for type of phone such as H1 for home or M for mobile.
TELEPHONE_NUMBER	Required. Phone number.
MARITAL_STATUS	Marital status of employee.
MIDDLE_NAME	Middle name of employee.
NATIONALITY	Nationality of employee.
NATIONAL_IDENTIFIER	Required. Number by which employee is identified in a given legislation.
PREVIOUS_PERSON_LAST_NAME	Previous last name of person.
REGISTERED_DISABLED_FLAG	Indicates if the person is classified as disabled.
SEX	Required. Gender.
TITLE	Title such as Mr., Mrs., or Dr.
SUFFIX	Suffix after the surname such as Sr., Jr., or III.
WORK_SCHEDULE
CORRESPONDENCE_LANGUAGE	Correspondence language for the employee.
STUDENT_STATUS
FULL_TIME_EMPLOYMENT_CAPACITY	Employment capacity of the person.
ON_MILITARY_SERVICE_FLAG	Indicates whether the employee is away for military service.
SECOND_PASSPORT_EXISTS_FLAG	Indicates whether a second passport exists for the person.
BACKGROUND_CHECK_STATUS	Indicates whether background has been checked.
BACKGROUND_CHECK_DATE	The background check date.
BLOOD_TYPE
LAST_MEDICAL_TEST_DATE	Date when last medical test was conducted.
LAST_MEDICAL_TEST_BY	Name of the doctor who conducted the medical test.
REHIRE_RECOMMENDATION	Recommendation for a rehired employee.
REHIRE_REASON	Reason for rehiring a person.
RESUME_EXISTS_FLAG	Indicates if résumé exists for the employee.
RESUME_LAST_UPDATED_DATE	Date when résumé of the person was last updated.
OFFICE_NUMBER
INTERNAL_LOCATION
MAILSTOP	Internal mail location.
HONORS
PRE_NAME_ADJUNCT	Name prefix of the person.
COORD_BEN_MED_PLN_NO	Coordination of benefits medical group plan number.
COORD_BEN_NO_CVG_FLAG	Indicates if employee has other coverage for coordination of benefits.
DEPENDENT_ADOPTION_DATE
DEPENDENT_VLNTRY_SERVICE_FLAG	Indicates if dependent works as a volunteer.
RECEIPT_OF_DEATH_CERTIFICATE_DATE
USES_TOBACCO_FLAG
BENEFIT_GROUP	Benefit group name.
ORIGINAL_DATE_OF_HIRE	Date when the employee was originally hired.
ADJUSTED_SVC_DATE	Previous date of hire for the employee.
TOWN_OF_BIRTH
REGION_OF_BIRTH
COUNTRY_OF_BIRTH

Field Name	Description
ACTION	Required. Add or change an employee’s assignment.
ACTION_SUBTYPE	Required when ACTION indicates a change to employee information. Values are Update or Correct.
ASSIGNMENT_NUMBER	Required, if modifying employee assignment number.
EFFECTIVE_START_DATE	Required.
EFFECTIVE_END_DATE	Required.
BUSINESS_GROUP_NAME	Required. Name of the business group to which the employee belongs.
RECRUITER_NAME	Name of the recruiter.
GRADE	Grade of the employee.
POSITION	Position of the employee.
JOB	Job name of the employee.
USER_ASSIGNMENT_STATUS	Required. Assignment status of the employee.
PAYROLL_NAME	Payroll name of the employee.
LOCATION_ADDRESS_LINE_1	Location address for the employee assignment.
LOCATION_ADDRESS_LINE_2
LOCATION_ADDRESS_LINE_3
LOCATION_CITY
LOCATION_COUNTY
LOCATION_STATE
LOCATION_POSTAL_CODE
LOCATION_COUNTRY
PERSON_REFERRED_BY	Person who has referred the employee.
SUPERVISOR_NAME	Employee supervisor’s name.
PROGRESSION_POINT_NAME_NUMBER	Number indicating the progression of the pay scale and their incremental order number
RECRUITMENT_ACTIVITY_NAME	Recruitment activity name for the employee.
SOURCE_ORGANIZATION_NAME	Name of the source organization such as a Division or Business Unit.
ORGANIZATION_NAME	Required.
GROUP_NAME	Name of the group to which the employee belongs.
VACANCY_NAME	Name of the vacancy position.
PAY_BASIS	Basis of payment such as Annual, Hourly, or Monthly.
SALARY_APPROVED_FLAG	Indicates the payment approval.
RATE_BASIS
SALARY_UOM	Unit of measure of the salary.
PROPOSED_SALARY
ASSIGNMENT_TYPE	Required.
ASSIGNMENT_PRIMARY_FLAG	Indicates if the assignment is primary. Required when importing an assignment that contains no address details.
CURRENT_EMPLOYER	Name of the current employer.
ASSIGNMENT_CHANGE_REASON	Reason of changing the current assignment.
COMMENT
DATE_PROBATION_END	The ending probation date for the employee.
GL_ACCOUNT_NUMBER	General ledger account number.
EMPLOYMENT_CATEGORY	Category of the employment such as Full time or Intern.
NORMAL_WORKING_FREQUENCY	Normal frequency at which the employee works such as Day, Hour, Month, Week, or Year.
INTERNAL_ADDRESS_LINE	Internal address detail such as floor.
MANAGER_FLAG	Indicates if the employee for the assignment is a manager.
NORMAL_HOURS	Normal hours of work.
PERFORMANCE_REVIEW_PERIOD
PERF_REVIEW_PERIOD_FREQUENCY	Frequency units. Use with PERF_REVIEW_PERIOD to define time between reviews.
TERMINATION_ACCEPTED_PERSON	Person accepting the termination of the employee.
ACCEPTED_TERMINATION_DATE	Date when termination of employment was accepted.
ACTUAL_TERMINATION_DATE	Actual date of termination of employment.
FINAL_PAYROLL_PROCESSED_DATE	Date when the final payroll for the employee is processed.
LAST_STANDARD_PROCESS_DATE	Last date for including the employee in any standard payroll processing.
LEAVING_REASON	Reason for termination of assignment.
NOTIFIED_TERMINATION_DATE	Date when termination of employment was noted.
PROJECTED_TERMINATION_DATE	Projected employment termination date.
PROBATION_PERIOD	Probation period for the employee.
PROBATION_UNIT	Unit of measure for the probation period.
SALARY_REVIEW_PERIOD	Period by which the salary is reviewed.
SALARY_REVIEW_PERIOD_FREQUENCY	Frequency by which the salary period is reviewed.
SET_OF_BOOKS_NAME	General ledger set of books name.
ASSIGNMENT_SOURCE_TYPE	Employment source name such as Advertisement, Agency, Walk-in, or Career fair.
WORK_TIME_NORMAL_FINISH	Normal time when the work is finished.
WORK_TIME_NORMAL_START	Normal time when the work starts.
BARGAINING_UNIT_CODE	Unit code for bargaining for payment decision such as United Auto Workers or International Steel Workers.
LABOUR_UNION_MEMBER_FLAG	Indicates employee is a labor union member.
HOURLY_SALARIED_CODE	Code indicating the payment type for the assignment, such as Hourly or Salary.
CONTRACT_TYPE
COLLECTIVE_AGREEMENT_NAME
ESTABLISHMENT_NAME
ASSIGNMENT_TITLE

Database Script	Description
wm_install_into_employee.sql	Runs all the scripts listed below, except the uninstall script.
wm_into_employee_pkg.sql	Installs following components which calls the concurrent process to submit the employee information. WM_EMP_IMP_HANDLER_PKG. WM_HANDLE_EMP WM_EMPLOYEE_ASG_IMPORT_PKG. WM_EMP_CREATE_ASG WM_EMPLOYEE_ASG_IMPORT_PKG. WM_EMP_UPDATE_ASG
wm_drop_into_employee.sql	Uninstalls all components created by wm_install_into_employee.sql.