This page (revision-15) was last changed on 17-Apr-2024 16:29 by Kevin Higgs

This page was created on 26-Nov-2021 10:22 by Kevin Higgs

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
15 17-Apr-2024 16:29 10 KB Kevin Higgs to previous
14 23-Feb-2024 16:02 9 KB Kevin Higgs to previous | to last
13 23-Feb-2024 15:58 9 KB Kevin Higgs to previous | to last
12 23-Feb-2024 13:32 9 KB Kevin Higgs to previous | to last
11 23-Feb-2024 13:30 9 KB Kevin Higgs to previous | to last
10 23-Feb-2024 13:24 9 KB Kevin Higgs to previous | to last
9 31-Aug-2022 17:24 7 KB Karen Parrott to previous | to last
8 26-Nov-2021 10:22 6 KB Karen Parrott to previous | to last
7 26-Nov-2021 10:22 6 KB Karen Parrott to previous | to last
6 26-Nov-2021 10:22 6 KB Karen Parrott to previous | to last
5 26-Nov-2021 10:22 6 KB Kevin Higgs to previous | to last
4 26-Nov-2021 10:22 6 KB Kevin Higgs to previous | to last
3 26-Nov-2021 10:22 5 KB Kevin Higgs to previous | to last
2 26-Nov-2021 10:22 3 KB Kevin Higgs to previous | to last
1 26-Nov-2021 10:22 2 KB Kevin Higgs to last

Page References

Incoming links Outgoing links
XDCE...nobody
XDCE

Version management

Difference between version and

At line 3 changed one line
!!!PURPOSE
!!Purpose
At line 24 added one line
\\
At line 26 added one line
\\
At line 26 changed 3 lines
||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
||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
At line 31 changed 3 lines
|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)
|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)
\\
\\
At line 35 changed 2 lines
!Departments
||Personality Field ||NEOGOV Mapping ||Notes
\\
!DEPARTMENTS
\\
||Personality Field ||NEOGOV Mapping ||Notes
At line 39 changed 18 lines
|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 |
|ddv.division_name |DivisionName |
|ddp.department_code |Department |
|ddv.division_status |Status |Standing of Active will be return '1', all other values will return '2'
!Class Specifications
|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 |
|ddv.division_name |DivisionName |
|ddp.department_code |Department |
|ddv.division_status |Status |Standing 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 | |
|djd.notes |Notes |
\\
\\
!OCCUPATIONAL GROUPS
At line 58 changed 28 lines
|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 |SalaryBreakdownBiweekly |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 |
djd.notes |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
This page (revision-15) was last changed on 17-Apr-2024 16:29 by Kevin HiggsTop