This page (revision-9) was last changed on 25-Feb-2022 13:06 by Lilia Urtan

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
9 25-Feb-2022 13:06 7 KB Lilia Urtan to previous
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 removed one line
\\
At line 26 removed one line
\\
At line 28 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 32 removed one line
|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
At line 34 changed 6 lines
|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)
|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 41 removed one line
\\
At line 43 changed 62 lines
\\
!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
!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'
At line 106 changed 3 lines
----
![Notes|Edit:Internal.XDCE]
[{InsertPage page='Internal.XDCE' default='Click to create a new notes page'}]
!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 |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
This page (revision-9) was last changed on 25-Feb-2022 13:06 by Lilia UrtanTop