Extract Core Entities from High Line to Neogov (XDCE)#
PURPOSE#
The XDCE program creates an extract in the form of a .csv from Personality in a predefined layout for importing to the NEOGOV system.
Extracts can include Department, Divsions, Occupational Groups and Positions.
A separate file will be created for each extract selected.
The predefined naming convention for the file will used - SITE_CODE_filetype_YYYYMMDD.csv;
- Site Code as seen on IMST in the SITE_CODE field
- The type of file to be created;
- Department = Dept
- Divisions = Div
- Class Specifications = cs
- Occupational Groups = oc
- Positions = pos
- The system date in the format YYYYMMDD
- the extenstion - .csv
The file requirements and how your data is set up should be reviewed with the NEOGOV integration team.
Report Parameters#
| Report Parameters | Description |
|---|---|
| Departments | Mandatory, Lexicon (Yes or No) - Select Yes if you wish for a Department extract file to be created. The filename will be SITE_CODE_dept_YYYYMMDD.csv |
| Divisions | Mandatory, Lexicon (Yes or No) - Select Yes if you wish for a Division extract file to be created. The filename will be SITE_CODE_div_YYYYMMDD.csv |
| Class Specifications | Mandatory, Lexicon (Yes or No) - Select Yes if you wish for a Class Specification extract file to be created. The filename will be SITE_CODE_cs_YYYYMMDD.csv |
| Occupational Groups | Mandatory, Lexicon (Yes or No) - Select Yes if you wish for a Occupation Groups extract file to be created. The filename will be SITE_CODE_oc_YYYYMMDD.csv |
| Positions | Mandatory, Lexicon (Yes or No) - Select Yes if you wish for a Position extract file to be created. The filename will be SITE_CODE_pos_YYYYMMDD.csv |
| Exception Level | Values of ‘0’ to ‘9’ (more exception messages are displayed when a higher level number is used) |
File Layout#
Departments#
| Personality Field | NEOGOV Mapping | Notes |
|---|---|---|
| ddp.department_code | Department Code | From IDDP |
| ddd.department_name | Department Name | From the detail record of IDDP |
| dln.address_line_1 | Address 1 | Based on the DLN_ID associated to the the IDDP |
| dln.address_line_2 | Address 2 | Based on the DLN_ID associated to the the IDDP |
| dln.locality | City | Based on the DLN_ID associated to the the IDDP |
| dsp.state_province_code | State | Based on the DSP_ID found on the DLN_ID associated to the the Department |
| dln.zip_postal | ZipCode | Based on the DLN_ID associated to the the IDDP |
| dln.phone_number | Phone1 | Based on the DLN_ID associated to the the IDDP |
| dln.alt_phone_number | Phone2 | Based on the DLN_ID associated to the the IDDP |
| Not Used in Personality | WebSiteURL | There is currently no corresponding column |
| ddp.standing | Status | Standing of Active will be return '1', all other values will return '2' |
