At the top of each worksheet (cell D6), the name of the Special Information Type is stored. This field is mandatory and is used when validating, uploading and downloading special information.
The worksheet columns are divided into three sections: Status, Employee and Special Information. You can see the section headings in Row 8.
The first section ‘Status’ is used to track the progress of the records as they interface into Oracle Human Resources and report back any error or warning messages. For a description of each status refer to section: Status and Message Columns
The Employee section must contain the Employee Number or Contingent Worker Number, and Person Id columns for the API interface. The remaining columns in this section (e.g. Last Name) are for your reference only and are used to quickly identify employees. Note - Changing employee reference information in the worksheet will not change it within Oracle Human Resources.
The Special Information section contains the various columns needed to load special information including: Update Mode, Person Analysis Id, Start Date, End Date and each of the Special Information Segments/fields.
How to use these fields is described in the sections that follow.
Multiple Special Information Records for an Employee
Each row within the worksheet holds one Special Information record. If an employee has multiple Special Information records on a worksheet then the Employee information needs to only show on the first Special Information record for that employee.
EXAMPLE: Two employees: The first employee has three Special Information records, and the second employee has one Special Information record.
