Home > Guides > Administrator Guide > Drop-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
|