User Tools

Site Tools


humanresources:utilities:importstaffdemoinsurancedata

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
humanresources:utilities:importstaffdemoinsurancedata [2018/10/01 16:16] emorenohumanresources:utilities:importstaffdemoinsurancedata [2020/07/31 17:31] (current) – removed emoreno
Line 1: Line 1:
-======Import Staff Demo Insurance Data - HRS7960====== 
  
-<div #message></div> 
- 
-//**Human Resources > Utilities > Import Staff Demo Insurance Data**// 
- 
-<WRAP round intro>This utility is used to import a comma-delimited text (.txt) file to insert insurance records to the Maintenance > Staff Demo > Insurance tab. 
- 
-You must be logged on to a current year pay frequency to access this utility. 
- 
-**Notes**: 
- 
-If **Insert new records from import file.** is selected, one of the following occurs: 
-  
-  * If insurance plan data exists in the database but no coverage data, then new coverage rows are inserted. 
-  * If insurance plan and coverage data exist in the database, then no new coverage rows are inserted and an error message is displayed. 
-  * If the import file contains insurance plan data but no coverage data, an insurance plan record is inserted if it does not already exist. 
-  
-If coverage data is duplicated in the file, the number of rows listed in the file are inserted with a unique sequence number to prevent duplicate rows in the database. 
- 
- 
-[[https://txeis.net/page/Partners|File layout]] 
-</WRAP> 
- 
- 
-====Insert new records:==== 
- 
-Under **Import Option**, select one of the following options: 
- 
-  * **Insert new records from import file.** 
-  * **Delete all existing records and insert all records from import file.**   
-  
-Under **Employees Identifier**, select one of the following options to include as the first identifying column in the record layout:   
-  
-  * **Employee Number** 
-  * **Staff ID/SSN** 
- 
-^ Field                                        ^ Description    /*Table with two rows*/ 
-^Insurance Company Code/Name|Type the insurance company code or name. A list of matching codes is displayed in the drop down. Select the desired code, or click {{:images:smallpicklist.gif|Ellipsis Icon}} to perform a search in the Insurance Company Codes directory. Only insurance company code/names that exist on the Tables > Insurance Company Codes page are displayed.\\  \\  If an insurance company code is selected, the selected code overwrites the code in the file. However, if the field is left blank, the insurance company code from the file is used.|   
-^Import Path|Click **Choose File**. The File Upload dialog box is displayed.\\  \\  Select the desired file to upload, and click **Open**. The file name is displayed.\\  \\  Click **Cancel** to close the dialog box without selecting a file.| 
-  
-Click **Execute** to start the import. 
- 
-If any [[general:importstaffdemoinsurancedata_errors|errors]] are encountered during the import process, the Import Staff Demo Insurance Data Error Report is displayed. 
-++++Review the report.|{{page>general:printreport&inline}}++++ 
- 
-Click **Cancel** to return to the Import Staff Demo Insurance Data page. 
-  
-Click **Process**.  
-++++Create a backup.|{{page>general:backup&inline}}++++ 
-  
-A message is displayed indicating that the process was successful. 
- 
- 
- 
- 
-{{indexmenu_n>135}} 
humanresources/utilities/importstaffdemoinsurancedata.1538410566.txt.gz · Last modified: 2018/10/01 11:16 (external edit)