Help & Support Center
Search:  
Contents
:
IndexPrintBookmark

Home > Guides > Administrator Guide > xDrop-Down Values (Codes) > Costpoint

Costpoint

Need Help on this Topic? Email Support


Page Location: Admin > Codes > Costpoint

The process for transferring new hires from Cyber Recruiter to Costpoint involves exporting the information to an ASCII text file and importing that file into the Costpoint Product. To accomplish this step the Costpoint code tables must be up-to-date. All of these code tables are required for transferring new employee data to Costpoint.

Set up these tables as they are in Costpoint prior to completing the "Defaults Tab in the Setup page: Employee Classes, Leave Cycles, Pay Type, Timehseet Cycle, Workers Comp. The rest of the tables should be set up prior to using on a daily basis.

Most of these code tables are independent, however three codes build upon one other so it is recommended to enter them in this order: 1) Workers Comp, 2) Job Titles, 3) GLC.

User View: When the user completes the Costpoint page in the applicant's profile these codes are used.

Codes may be imported using the import keys listed below.

Table Name Import Key
Companies     DTKCOMP
Employee Classes             DTKEECLS
GLC (General Labor Category) DTKGLC
Home Organizations DTKORG
Job Titles DTKJT
Labor Groups DTKLGR
Labor Locations DTKLABLOC    
Leave Cycles DTKLEAVE
Locator DTKLCTR 
Pay Types DTKPAYTYPE
PLC DTKPLC 
Reasons DTKREAS 
Security Org ID's DTKSECORG 
Timesheet Cycles DTKTSCYC 
Visa Types   DTKVISA 
Workers Comp  DTKWKCOMP 

.csv file should contain Code & Description in that order. 
As noted above three codes build upon one another and so the Job Title Code setup has an additional component of the Workers Comp code attached and the GLC Code setup has an additional component of the Job Title attached. These components cannot be in the import file  so this linking will need to be done after each code table is imported with the Code and Description fields only

Creating Costpoint Codes

Important Considerations:  Cyber Recruiter codes cannot contain certain symbols such as commas, quotes, periods, apostrophes or ampersands and the user will get an error message when trying to enter or import codes containing them. There are also certain character combinations that must be avoided because Cyber Recruiter is programmed to strip them (even if they are in the middle of a code or description) as they can be used by others to reference potentially dangerous procedures or scripts that could cause harm to your Cyber Recruiter system. These combinations include: SP_ or sp_ and XP_ or xp_. Also a double dash will be converted to a single dash. There are a few other combinations not listed here that could be stripped, but it is extremely unlikely that they would be used in codes or descriptions.

After clicking "Add new record." enter in the necessary information to create a new code.  

Field Purpose
Code Unique Identifier for the drop-down option. This code is written in the raw data and is referenced to determine the description to show on the screen. If the code is removed from the Admin > Codes section, this value will still be in the Applicant file for reporting purposes unless the file is edited and saved after the code was deleted.
Description This is what is displayed on the screens and on the website for searching.

Most codes have only two components Code & Description, but as noted above three codes build upon one another and so the Job Title Code setup has an additional component of the Workers Comp code attached and the GLC Code setup has an additional component of the Job Title attached.

Inactivating Codes

Costpoint Codes cannot be inactivated.

NOTE: If a code cannot be inactivated, it is not recommended to delete the code as this could cause "holes" in your data. Instead, consider adding a "z" to the beginning of the Description field as this will move the code to the bottom of the list.

 


See also