!!!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 will automatically be created on the database server in a the default OUTPUT folder.\\
All data on the file will be distinct and effective as of the current system date
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
|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
|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
|As of Date		|Optional, Date - Extract the records that are effective as of this date
|Department Status|Lexicon - This will filter the records in the extract according to the selected status.\\ If no value selected on the parameter, the process will extract records that have the status null.
|Division Status|Lexicon - This will filter the records in the extract according to the selected status.\\ If no value selected on the parameter, the process will extract records that have the status null.
|Class Spec Status|Lexicon - This will filter the records in the extract according to the selected status.\\ If no value selected on the parameter, the process will extract records that have the status null.
|Position Status|Lexicon - This will filter the records in the extract according to the selected status.\\ If no value selected on the parameter, the process will extract records that have the status null.
|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			|DepartmentCode		|From [IDDP]
|ddd.department_name			|DepartmentName		|From the detail record of [IDDP]
|dln.address_line_1			|Address1		|Based on the [DLN_ID] associated to the the [IDDP]
|dln.address_line_2			|Address2		|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'
\\
!DIVISIONS
||Personality Field			||NEOGOV Mapping	||Notes
|ddv.division_code			|DivisionCode		|From [IDDV]
|ddv.division_name			|DivisionName		|From [IDDV]
|ddp.department_code			|Department		|From [IDDP]
|ddv.division_status			|Status			|From [IDDV]. Value of lexicon [X_STANDING].  Saved value of "Active" will be return '1', all other values will return '2'
\\
\\
!CLASS SPECIFICATIONS
||Personality Field			||NEOGOV Mapping	||Notes
|djb.job_code				|ClassCode		|From IDJB
|djd.effective				|EstablishedDate	|Latest date effective record found on IDJB
|djd.job_title				|ClassTitle		|From the recruiting tab found on the detail record of IDJB
|djd.class_concept			|ClassConcept		|From the recruiting tab found on the detail record of IDJB
|djd.example_of_duties			|ExampleOfDuties	|From the recruiting tab found on the detail record of IDJB
|djd.minimum_qualifications		|MinimumQualifications	|From the recruiting tab found on the detail record of IDJB
|djd.supplemental_info			|SupplementalInfo	|From the recruiting tab found on the detail record of IDJB
|djd.other_requirements			|OtherRequirements	|From the recruiting tab found on the detail record of IDJB
|djd.other_title_1			|OtherTitle1		|From the recruiting tab found on the detail record of IDJB
|djd.ngv_salary_min			|SalaryMin		|From the recruiting tab found on the detail record of IDJB
|djd.ngv_salary_max			|SalaryMax		|From the recruiting tab found on the detail record of IDJB
|djd.billable_hours			|BillableHours		|Lexicon X_BILLABLE_HOURS From the Recruiting Tab found on the detail record of IDJB
|djd.rate_basis				|SalaryPaidCode		|Lexicon X_RATE_BASIS\\*'HR' = 'Hour'\\*'MO' = 'Month'\\*'YR' = 'Year'\\*'BW' = 'BiWeekly'\\*'WK' = 'Week'\\*'SM' = 'Semi-month'\\*'DY' = 'Day'
|djd.show_salary_hourly			|SalaryBreakdownHourly	|Toggle found on IDJB
|djd.show_salary_daily			|SalaryBreakdownDaily	|Toggle found on IDJB
|djd.show_salary_weekly			|SalaryBreakdownWeekly	|Toggle found on IDJB
|djd.show_salary_biweekly		|SalaryBreakdownBiweeky	|Toggle found on IDJB
|djd.show_salary_semimonthly	        |SalaryBreakdownSemiMonthly	|Toggle found on IDJB
|djd.show_salary_monthly		|SalaryBreakdownMonthly	|Toggle found on IDJB
|djd.show_salary_annually		|SalaryBreakdownAnnually|Toggle found on IDJB
|dun.unit_code				|BargainingUnitCode	|Unit Code found on the IDJB
|'N/A'					|PhysicalClassCode	|There is currently no corresponding column
|rnb.benefits_code			|BenefitCode		|From the recruiting tab found on the detail record of IDJB. Set up on the [IRNB] Maintain NGV Benefits form
|doc.occupation_code			|OccupationalGroupCode	|From the recruiting tab found on the detail record of IDJB. Set up on the [IDOC] Define Occupation Code form
|djd.ngv_flsa				|FLSA			|Lexicon X_NGV_FLSA "Exempt" or "Non-Exempt"                               
|djd.eeo_category			|EEO			|Lexicon X_EEO_CATEOGRY found on the detail record of IDJB
|djd.job_interest_cards			|AcceptJobInterestCards	|From the recruiting tab found on the detail record of IDJB. Toggle	
|djd.notes				|Notes                  |From the recruiting tab found on the detail record of IDJB.
\\
\\
!OCCUPATIONAL GROUPS
||Personality Field			||NEOGOV Mapping			||Notes
|doc.Occupation_code			|OccupationCode				|
|doc.occupation_group			|OccupationalGroup			|Lexicon X_OCCUPATION_GROUP 
|doc.description			|Description				|
|No DB VALUE				|1					|Defaults to value of '1'. No DB VALUES

----
![Notes|Edit:Internal.XDCE] 	
[{InsertPage page='Internal.XDCE' default='Click to create a new notes page'}]