{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions and CSV Generation","Participant Details"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":17,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions and CSV Generation","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,1,12,3],[10,1,10,3],[6,1,6,3],[4,1,4,3],[8,1,8,3]]}
[]
[null,null,"Fusion Applications"]
[null,null,"Incentive Compensation Participant Details Interface"]
["Overview"]
[null,"Use either the Run All Participant Processes or the Import and Update Participant Details process to import the source file data from the Oracle WebCenter Content repository, into the staging table and then to the destination tables.\nUsing this template, you can prepare the source file in the required format to:\n •  Update participant level information\n •  Update existing detail level information\n •  Create a new detail level record\n •  Correct the participant type\n •  Delete participants created by mistake\n\nNote:  The participant must exist (participants must be imported first) before you can import new details or update existing details. \n\n"]
["Preparing the Data"]
[null,"Prepare the data for import using the corresponding Participant Details worksheet in this template. (See the section Excel Template Format for details about this template.) \n • Required Attributes: The business unit name and participant name attributes are required. Either the start date or the end date is required. If the hold payment value is Y, then the hold payment reason is required. If creating a new participant detail record, the currency code and country code are required.\n • Recommended Attributes: It is recommended that you also provide at least one of the following to uniquely identify the participant: e-mail address, party identifier, party number, person number.  You can obtain values for these alternate identifiers using the Participant Snapshot work area, Select Participant page search results or the Manage Participant Details page.\n • Detail Record Start and End Dates: Your import start and end date data (or start and end dates derived by the import process) should comply with the following:\n       * be within the participant start and end date range and before or equal to the compensation end date\n       * not cause an assigned compensation plan date range to be greater than the participant detail effective date ranges\n       * not cause a change in currency within the date range of an assigned compensation plan when the processing currency is set to use the participant home currency\n   The import process evaluates the existing detail effective dates, changes in currency, and assigned compensation plans to determine if the existing detail record will be updated or end-dated and a new detail record created. \n • Ignore or Remove Existing Values:  If a value is not provided for an attribute, the import process will ignore the attribute. For example, you are importing updates to an existing detail record. You have defined two participant detail flexfields (Certification Level and Job Code) and want to update just the participants job code value. Enter a row for the participant in this template and provide a value in the flexfield column that corresponds to the job code.  The import process will update the job code value and ignore the existing certification level value. To remove a value for a text data type attribute, enter the value #NULL.  For example, if you want to remove the existing certification level for a participant, enter a row for the participant in this template and provide the value #NULL in the flexfield column that corresponds to the certification level. The import process will remove the existing certification level value for the participant.\n • Correct the Participant Type: To correct the participant type from an analyst to a participant or a participant to an analyst, enter the required information listed above along with the correcting value in the Participant Type column.\n • Delete Participants Created by Mistake: To delete participants created by mistake, enter the required information listed above along with the value DELETE_PARTICIPANT entered in the Delete Participant column. Do not mix both updates and deletions in the same file.\n"]
["Excel Template Format"]
[null,"The Participant Details worksheet within this template represents the interface table and provides key information for your data.\n • The worksheet contains column headers that represent the interface table columns. The columns are in the order that the control file expects them to be in the data file. \n    Do not change the order of the columns. Changing the order of the columns will cause the load process to fail.\n    Do not delete columns. You can hide columns that you do not intend to use, but you cannot delete columns. Deleting columns will cause the load process to fail.\n • Each column header comments provide helpful information such as a description, data type, and length.\n • You must enter data that conforms to the associated database column.\n   - Date fields must be entered in YYYY/MM/DD format\n   - Columns have been formatted, where applicable, to match the expected data type."]
["Loading the Data"]
[null,"1. After you finish preparing the data in the worksheet, click the Generate CSV File button. The process generates the CSV file and a ZIP file.  \n\n\n\n\n\n2. Sign in to the application and navigate to the Tools, File Import and Export work area to upload the zipped file to the content repository.   (To access the File Import and Export work area and Incentive Compensation upload accounts, you must be assigned the Incentive Compensation Integration Specialist security job role)\n         • Click the upload icon or select Upload from the actions menu\n         • Browse and select the zipped file\n         •  Select the ic/incentiveCompensationParticipant/import account\n         • Save and Close\n3. Navigate to the Incentive Compensation, Participant Assignments work area. \n         • Submit either the Run All Participant Processes or the Import and Update Participant Details\n4. Monitor the import process using the View Processes task."]
["Correct Load Errors"]
[null,"The Import and Update Participant Details process creates two additional processes. The first process (Import Participant Details to Staging) loads the data from your source file to the staging table. The second process (Collect Participant Detail from Staging) imports the data from the staging table to the destination tables. If either of these two processes has a status of error or warning, view the process attachment, listed under the Log and Output heading, to assist you in troubleshooting the issue.  If the process fails, all rows that were loaded from the source file are deleted (even those rows that loaded successfully) allowing you to edit the problematic data, upload the revised file to the content repository, and resubmit the process."]

{"sheet":"Participant Details","index":1,"n_rows":3,"n_cols":112,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,"Participant Attribute Import"]
[null,null,null,null,null,null,null,null,null,null,null,"* Required       ** One is required ",null,null,null,null,null,null,null,null,"Employee Id"]
["*Business Unit","*Participant","Compensation End Date","Analyst","Hold Payment","Hold Payment Reason","Payee Only","E-Mail Address","Party Identifier","Party Number","Person Number","Worker Number","Display Identifier","Source System","Source System ID","**Start Date","**End Date","Cost Center","Country Code","Currency Code","Detail Number Attribute 1","Detail Number Attribute 2","Detail Number Attribute 3","Detail Number Attribute 4","Detail Number Attribute 5","Detail Number Attribute 6","Detail Number Attribute 7","Detail Number Attribute 8","Detail Number Attribute 9","Detail Number Attribute 10","Detail Number Attribute 11","Detail Number Attribute 12","Detail Number Attribute 13","Detail Number Attribute 14","Detail Number Attribute 15","Detail Number Attribute 16","Detail Number Attribute 17","Detail Number Attribute 18","Detail Number Attribute 19","Detail Number Attribute 20","Detail Character Attribute 1","Detail Character Attribute 2","Detail Character Attribute 3","Detail Character Attribute 4","Detail Character Attribute 5","Detail Character Attribute 6","Detail Character Attribute 7","Detail Character Attribute 8","Detail Character Attribute 9","Detail Character Attribute 10","Detail Character Attribute 11","Detail Character Attribute 12","Detail Character Attribute 13","Detail Character Attribute 14","Detail Character Attribute 15","Detail Character Attribute 16","Detail Character Attribute 17","Detail Character Attribute 18","Detail Character Attribute 19","Detail Character Attribute 20","Detail Date Attribute 1","Detail Date Attribute 2","Detail Date Attribute 3","Detail Date Attribute 4","Detail Date Attribute 5","Detail Date Attribute 6","Detail Date Attribute 7","Detail Date Attribute 8","Detail Date Attribute 9","Detail Date Attribute 10","Attribute Category","Participant Character Attribute 1","Participant Character Attribute 2","Participant Character Attribute 3","Participant Character Attribute 4","Participant Character Attribute 5","Participant Character Attribute 6","Participant Character Attribute 7","Participant Character Attribute 8","Participant Character Attribute 9","Participant Character Attribute 10","Participant Character Attribute 11","Participant Character Attribute 12","Participant Character Attribute 13","Participant Character Attribute 14","Participant Character Attribute 15","Participant Number Attribute 1","Participant Number Attribute 2","Participant Number Attribute 3","Participant Number Attribute 4","Participant Number Attribute 5","Participant Number Attribute 6","Participant Number Attribute 7","Participant Number Attribute 8","Participant Number Attribute 9","Participant Number Attribute 10","Participant Date Attribute 1","Participant Date Attribute 2","Participant Date Attribute 3","Participant Date Attribute 4","Participant Date Attribute 5","Participant Date Attribute 6","Participant Date Attribute 7","Participant Date Attribute 8","Participant Date Attribute 9","Participant Date Attribute 10","Classification Batch Group Number","Crediting Batch Group Number","Rollup Batch Group Number","Calculation Batch Group Number","Participant Type","Delete Participant"]