This page (revision-16) was last changed on 27-Apr-2022 10:34 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
16 27-Apr-2022 10:34 12 KB Lilia Urtan to previous
15 26-Nov-2021 10:22 12 KB Kevin Higgs to previous | to last
14 26-Nov-2021 10:22 12 KB Karen Parrott to previous | to last
13 26-Nov-2021 10:22 12 KB Kevin Higgs to previous | to last
12 26-Nov-2021 10:22 12 KB Kevin Higgs to previous | to last
11 26-Nov-2021 10:22 12 KB Kevin Higgs to previous | to last
10 26-Nov-2021 10:22 12 KB Kevin Higgs to previous | to last
9 26-Nov-2021 10:22 12 KB Kevin Higgs to previous | to last
8 26-Nov-2021 10:22 11 KB Kevin Higgs to previous | to last X_NEOGOV_TAX_PARMX ==> X_NEOGOV_TAX_PARM
7 26-Nov-2021 10:22 11 KB Kevin Higgs to previous | to last
6 26-Nov-2021 10:22 11 KB Kevin Higgs to previous | to last
5 26-Nov-2021 10:22 10 KB Karen Parrott to previous | to last
4 26-Nov-2021 10:22 10 KB Karen Parrott to previous | to last
3 26-Nov-2021 10:22 10 KB Kevin Higgs to previous | to last
2 26-Nov-2021 10:22 1 KB Kevin Higgs to previous | to last
1 26-Nov-2021 10:22 1 KB Kevin Higgs to last

Page References

Incoming links Outgoing links
UEINH
UEINH

Version management

Difference between version and

At line 1 removed 20 lines
At line 23 removed 2 lines
At line 27 removed 2 lines
At line 30 changed 5 lines
import Employee Hire from NEOGOV Insight/Onboard into Personality. It will use
an IDIF interface format to extract employee hire data from the xml file exported
by Insight/Onboard. Extracted data will be loaded into HL conversion tables and
validated with HL standard conversion logic. Validated data will be stored into
the actual database tables to create employee hires.
import Employee Hire from NEOGOV Insight/Onboard into Personality. It will use an IDIF interface format to extract employee hire data from the xml file exported by Insight/Onboard. Extracted data will be loaded into HL conversion tables and validated with HL standard conversion logic. Validated data will be stored into the actual database tables to create employee hires.
At line 8 added 6 lines
!! Supported Business Areas
*REQUIRED
**Identitiy ([IEID])
**Personals ([IEPI])
**Employement ([IEEI])
**Work Assignment ([IEAS])
At line 15 added 4 lines
* OPTIONAL
**US Pay Rules / W4 ([IPRLUS])
**Payment Method ([IPPM])
**Contacts ([IECT])
At line 21 added 7 lines
1. After loading the seeddata, make a deep copy of IDIF "HL$NGV-HL-CV-EMP-XML", such as "__ABC$NGV-HL-CV-EMP-XML__".\\
\\
2. Add/update constant values for desire IDIF fields. The value in the constant field will be the value loaded when UEINH is launched.\\
\\
3. Set up Preference "[DFLT PAYRULE|DFLT PAYRULE]" in IMST \\
\\
4. Launch the UEINH with "Set Up IDIF" set to Yes.
At line 29 added 8 lines
!!Additional Set Up Notes
Some values found in NEOGOV do not match those used in Personality. A series of lexicons have been created for mapping these differences. These are preloaded values, users should not need to update these lexicons
||Inbound Mapping||Corresponding Lexicon||
|[X_NEOGOV_ETHNIC]|[X_ETHNIC]
|[X_NEOGOV_MARITAL_STATUS]|[X_MARITAL_STATUS]
|[X_NEOGOV_TAX_PARM]|X_TAX_PARMX
|[X_NEOGOV_UFED_FILING_STATUS]|[X_UFED_FILING_STATUS]
|[X_NEOGOV_UST_FILING_STATUS]|[X_UST_FILING_STATUS]
At line 38 added 2 lines
The value in the MEANING field on the lexicon will be the value being imported from NEOGOV
The value in the Displayed field will be the mapped value as it is stored in the Personality system.
At line 42 removed 3 lines
1.      
After loading the seeddata, make a deep copy of
IDIF "HL$NGV-HL-CV-EMP-XML", such as "ABC$NGV-HL-CV-EMP-XML".
At line 46 removed 14 lines
2.      
Add/update constant values for desire DIFD
fields.
3.      
Set up Preference "DFLT PAYRULE" in
IMST
At line 44 added 6 lines
|Directory Name|Name of the complete path and directory|
|XML File Name|Name of XML file to be extracted|
|Interface Code|Interface format for extracting data|
|Exception Level|Exception only, User Trace, Legislation, UserCalc Trace, Program Trace or Utility Trace
|Clear CV Tables|Purge data from conversion tables
|Set Up IDIF| This should be set to "Yes" when running the interface for the first time. All other instances this should be set to "No" or Null.
At line 51 added 6 lines
%%info
The column [Reference ID||REFERENCE_ID] on each interface definition (IDIF) is specific to each database which reference the id on IMCD column details tab. This field must be populated in order for the UEINH to function.\\
\\
The default [IDIF] will initially have this value set as null.To populate this field, the first time UEINH is run in each environment, the user must answer Yes to the prompt "Set Up IDIF".\\
\\
If this program is set up and tested in a TEST environment and then moved to Production be sure to run with Set Up IDIF = Yes for the first run in Production.   If this prompt is Yes for each run of UEINH, it will not cause issues but it will add processing time.%%
At line 64 removed 3 lines
Directory
Name                Name of the complete
path and directory
At line 68 changed 30 lines
XML File Name
                 Name of XML file to be
extracted
Interface
Code                  Interface format for
extracting data
Exception
Level                 Exception only, User
Trace, Legislation, UserCalc Trace, Program Trace or Utility Trace
Clear CV
Tables                 Purge data from
conversion tables
!!Sample IDIF Layout
||Record#||Field#||Start||End||Name||Field Type||Record||Format Mask||Record Identifier||XML Tag||Constant Value||Derivation
|1|1|1|1|FILE_HEADER|Char|Not Specified| | |Person| |
|1|10|1|1|PERSONALS_GRP|Char|Header Record| |IVEPS|Personal| | 
|1|12|1|60|Employee #|Char|Detail Record| |IVEPS.PERSON_CODE|Person_Code| |
|1|14|1|16|S.S.N.|Char|Detail Record| |IVEPS.GOVERNMENT_CODE|Government_Code| |
|1|16|1|50|First Name|Char|Detail Record| |IVEPS.FIRST_NAME|First_Name| |
|1|18|1|50|Last Name|Char|Detail Record| |IVEPS.LAST_NAME|Last_Name| | |
|1|20|1|1|Date of Birth|Date|Detail Record|YYYY-MM-DD|IVEPS.BIRTH_DATE|Birth_Date| |
|1|22|1|30|Gender|Char|Detail Record| |IVEPS.GENDER|Gender| |
|1|24|1|30|Language|Char|Detail Record| |IVEPS.LANGUAGE_CODE| |ENG|
|1|26|1|30|Ethnic|Char|Detail Record| |IVEPS.ETHNIC|Ethnic| |
|1|28|1|50|Middle Name|Char|Detail Record| |IVEPS.MIDDLE_NAME|Middle_Name| |
|1|30|1|50|Photo Location|Char|Detail Record| |IVEPS.PHOTO_LOCATION| |person_code.jpg|
|1|32|1|30|Govt Code Origin|Char|Detail Record| |IVEPS.GOVT_CODE_ORIGIN| |US|
|1|34|1|1|Effective as of|Date|Detail Record| |IVEPS.EFFECTIVE| | |IVEEM.HIRE_DATE
|1|36|1|60|Change Reason|Char|Detail Record| |IVEPS.CHANGE_CODE| |INITIAL RECORD| | |
|1|38|1|50|Address 1|Char|Detail Record| |IVEPS.ADDRESS_LINE_1|Address_Line_1| |
|1|40|1|50|Address 2|Char|Detail Record| |IVEPS.ADDRESS_LINE_2|Address_Line_2| |
|1|42|1|50|City/Town|Char|Detail Record| |IVEPS.LOCALITY|City| |
|1|44|1|60|State|Char|Detail Record| |IVEPS.STATE_PROVINCE_CODE|State_Code| |
|1|46|1|60|Country|Char|Detail Record| |IVEPS.COUNTRY_CODE| |USA|
|1|48|1|16|Zip Code|Char|Detail Record| |IVEPS.ZIP_POSTAL|Zip| |
|1|50|1|20|Phone #|Char|Detail Record| |IVEPS.PHONE_NUMBER|Phone_Number| |
|1|52|1|20|Cellular #|Char|Detail Record| |IVEPS.CELLULAR_NUMBER|Cellular_Number| |
|1|54|1|50|E-mail|Char|Detail Record| |IVEPS.EMAIL_ADDRESS|Email_Address| |
|1|56|1|30|Marital Status|Char|Detail Record| |IVEPS.MARITAL_STATUS|Marital_Status| |
|1|100|1|1|EMPLOYMENTS_GRP|Char|Header Record| |IVEEM|Employment| |
|1|102|1|60|Entity|Char|Detail Record| |IVEEM.ENTITY_CODE| | |
|1|104|1|30|Employment Type|Char|Detail Record| |IVEEM.EMPLOYMENT_TYPE| |01|
|1|106|1|1|Date of Hire|Date|Detail Record|YYYY-MM-DD|IVEEM.HIRE_DATE|Hire_Date| |
|1|108|1|1|Original Hire Date|Date|Detail Record|YYYY-MM-DD|IVEEM.ORIGINAL_HIRE_DATE|Original_Hire_Date| |IVEEM.HIRE_DATE
|1|110|1|1|Seniority Date|Date|Detail Record|YYYY-MM-DD|IVEEM.SENIORITY_DATE|Seniority_Date| |IVEEM.HIRE_DATE
|1|200|1|1|ASSIGNMENTS_GRP|Char|Header Record| |IVEAS|Assignment| |
|1|202|1|60|Entity|Char|Detail Record| |IVEAS.ENTITY_CODE| | |
|1|204|1|30|Employment Type|Char|Detail Record| |IVEAS.EMPLOYMENT_TYPE| |01|
|1|206|1|1|Date of Hire|Date|Detail Record| |IVEAS.HIRE_DATE| | |IVEEM.HIRE_DATE
|1|208|1|60|Assignment|Char|Detail Record| |IVEAS.ASSIGNMENT_CODE| |PRIME|
|1|210|1|30|Type|Char|Detail Record| |IVEAS.ASSIGNMENT_TYPE| |00|
|1|212|1|30|Status|Char|Detail Record| |IVEAS.ASSIGNMENT_STATUS| |01|
|1|214|1|1|Start Date|Date|Detail Record| |IVEAS.ASSIGNMENT_START_DATE| | |IVEEM.HIRE_DATE
|1|216|1|4|Prime Assignment|Char|Detail Record| |IVEAS.PRIME_ASSIGNMENT| |1|
|1|218|1|1|Effective as of|Date|Detail Record| |IVEAS.EFFECTIVE| | |IVEEM.HIRE_DATE
|1|220|1|1|Expires on|Date|Detail Record| |IVEAS.EXPIRY| |31-Dec-3999|
|1|222|1|60|Change Reason|Char|Detail Record| |IVEAS.CHANGE_CODE| |INITIAL RECORD|
|1|224|1|60|Employment Status|Char|Detail Record| |IVEAS.STATUS_CODE| |PENDING|
|1|226|1|60|Position|Char|Detail Record| |IVEAS.POSITION_CODE|Position_Code| |
|1|228|1|60|Employee #|Char|Detail Record| |IVEAS.PERSON_CODE_SUPERVISED_BY|Supervisory| |
|1|230|1|60|Wage Scale|Char|Detail Record| |IVEAS.SCALE_CODE| | |
|1|232|1|60|Step|Char|Detail Record| |IVEAS.STEP_CODE|Step_Code| |
|1|234|1|9|FTE|Number|Detail Record| |IVEAS.FTE|FTE| |
|1|236|1|18|Wage Rate|Number|Detail Record| |IVEAS.WAGE_RATE|Wage_Rate| |
|1|238|1|30|Basis|Char|Detail Record| |IVEAS.RATE_BASIS|Rate_Basis| |
|1|240|1|1|Job Seniority Date|Date|Detail Record| |IVEAS.JOB_SENIORITY_DATE| | |IVEEM.HIRE_DATE
|1|242|1|50|E-mail|Char|Detail Record| |IVEAS.EMAIL_ADDRESS|Email_Address| |
|1|244|1|4|Web Pay Stub Only|Char|Detail Record| |IVEAS.WEB_PAY_STUB_ONLY| | |
|1|300|1|1|EASD_UDF_GRP|Char|Header Record| |EASD|Assignment| |
|1|302|1|1|EASD UDF Place Holder|Char|Detail Record| |EASD.UDF_USER_FIELD_01| | |
|1|400|1|1|PAYMENTRULES_GRP|Char|Header Record| |IVPPYD|Payment_Rule| |
|1|402|1|60|Entity|Char|Detail Record| |IVPPYD.ENTITY_CODE| | |
|1|404|1|30|Employment Type|Char|Detail Record| |IVPPYD.EMPLOYMENT_TYPE| |01|
|1|406|1|1|Effective as of|Date|Detail Record| |IVPPYD.EFFECTIVE| | |IVEEM.HIRE_DATE
|1|408|1|1|Expires on|Date|Detail Record| |IVPPYD.EXPIRY| |31-Dec-3999|
|1|410|1|60|Change Reason|Char|Detail Record| |IVPPYD.CHANGE_CODE| |INITIAL RECORD|
|1|412|1|30|Type|Char|Detail Record| |IVPPYD.PAYMENT_RULE_TYPE| | |
|1|414|1|60|Country|Char|Detail Record| |IVPPYD.COUNTRY_CODE| | |IVEPS.COUNTRY_CODE
|1|416|1|60|Bank Transit Code|Char|Detail Record| |IVPPYD.BANK_TRANSIT_CODE|Bank_Transit_Code| |
|1|418|1|30|Bank Account|Char|Detail Record| |IVPPYD.BANK_ACCOUNT|Bank_Account| |
|1|420|1|30|Bank Account Type|Char|Detail Record| |IVPPYD.BANK_ACCOUNT_TYPE|Bank_Account_Type| |
|1|422|1|5|Split Sequence|Number|Detail Record| |IVPPYD.SPLIT_SEQUENCE|Sequence| |
|1|424|1|18|Amount $|Number|Detail Record| |IVPPYD.AMOUNT|Amount| |
|1|426|1|4|Pay Remaining|Char|Detail Record| |IVPPYD.PAY_REMAINING|Pay_Remaining| |
|1|428|1|4|Prime Deposit|Char|Detail Record| |IVPPYD.PRIME_DEPOSIT|Prime_Deposit| |
|1|500|1|1|USPAYRULES_GRP|Char|Header Record| |IVPPRU|US_Pay_Rule| |
|1|502|1|60|Entity|Char|Detail Record| |IVPPRU.ENTITY_CODE| | |
|1|504|1|30|Employment Type|Char|Detail Record| |IVPPRU.EMPLOYMENT_TYPE| |01|
|1|506|1|1|Date of Hire|Date|Detail Record| |IVPPRU.HIRE_DATE| | |IVEEM.HIRE_DATE
|1|508|1|50|Description|Char|Detail Record| |IVPPRU.DESCRIPTION| |Default|
|1|510|1|1|Effective as of|Date|Detail Record| |IVPPRU.EFFECTIVE| | |IVEEM.HIRE_DATE
|1|512|1|1|Expires on|Date|Detail Record| |IVPPRU.EXPIRY| |31-Dec-3999|
|1|514|1|60|Change Reason|Char|Detail Record| |IVPPRU.CHANGE_CODE| |INITIAL RECORD|
|1|516|1|30|FED Filing Status|Char|Detail Record| |IVPPRU.UFED_FILING_STATUS|Ufed_Filing_Status| |
|1|518|1|5|FED Number of Exemptions|Number|Detail Record| |IVPPRU.UFED_NUM_EXEMPTIONS|Ufed_Num_Exemptions| |
|1|520|1|18|FED Add'l Tax Per Period|Number|Detail Record| |IVPPRU.UFED_ADD_TAX_PER_PERIOD|Ufed_Add_Tax_Per_Period| |
|1|522|1|30|FED Tax Method|Char|Detail Record| |IVPPRU.UFED_TAX_METHOD| | |
|1|524|1|30|FED Suppl Tax Method|Char|Detail Record| |IVPPRU.UFED_SUPPL_TAX_METHOD| | |
|1|526|1|30|FED FICA Method|Char|Detail Record| |IVPPRU.UFED_FICA_METHOD| | |
|1|528|1|30|FED Medicare Method|Char|Detail Record| |IVPPRU.UFED_MEDICARE_METHOD| | |
|1|530|1|30|STATE Filing Status|Char|Detail Record| |IVPPRU.UST_FILING_STATUS|Ust_Filing_Status| |
|1|532|1|5|STATE Number of Exemption 1|Number|Detai Record| |IVPPRU.UST_NUM_EXEMPTION_1|Ust_Num_Exemption_1| |
|1|534|1|18|STATE Add'l Tax Per Period|Number|Detail Record| |IVPPRU.UST_ADD_TAX_PER_PERIOD|Ust_Add_Tax_Per_Period| |
|1|536|1|30|STATE Tax Method|Char|Detail Record| |IVPPRU.UST_TAX_METHOD| | |
|1|538|1|30|STATE Suppl Tax Method|Char|Detail Record| |IVPPRU.UST_SUPPL_TAX_METHOD| | |
|1|540|1|30|STATE Reciprocity Agreement|Char|Detail Record| |IVPPRU.UST_RECIPROCATION| |
|1|600|1|1|MISC_PARAMETERS_GRP|Char|Header Record| |PPRM|Misc_Parameters| |
|1|602|1|4000|Field Variable|Char|Detail Record| |PPRM.FIELD_VARIABLE|Tax_Parm_1| |
|1|604|1|60|Tax Rate Code|Char|Detail Record| |PPRM.PTM_ID| |FILINGSTATUS|
|1|606|1|4000|Field Variable 2|Char|Detail Record| |PPRM.FIELD_VARIABLE|Tax_Parm_2| |
|1|608|1|60|Tax Rate Code 2|Char|Detail Record| |PPRM.PTM_ID| |TOTALALLOWANCES|
|1|610|1|4000|Field Variable 3|Char|Detail Record| |PPRM.FIELD_VARIABLE|Tax_Parm_3| |
|1|612|1|60|Tax Rate Code 3|Char|Detail Record| |PPRM.PTM_ID| |2020_W4|
|1|614|1|4000|Field Variable 4|Char|Detail Record| |PPRM.FIELD_VARIABLE|Tax_Parm_4| |
|1|616|1|60|Tax Rate Code 4|Char|Detail Record| |PPRM.PTM_ID| |TWO_JOBS|
|1|618|1|4000|Field Variable 5|Char|Detail Record| |PPRM.FIELD_VARIABLE|Tax_Parm_5| |
|1|620|1|60|Tax Rate Code 5|Char|Detail Record| |PPRM.PTM_ID| |DEPENDENTS_AMT|
|1|622|1|4000|Field Variable 6|Char|Detail Record| |PPRM.FIELD_VARIABLE|Tax_Parm_6| |
|1|624|1|60|Tax Rate Code 6|Char|Detail Record| |PPRM.PTM_ID| |OTHER_INCOME|
|1|626|1|4000|Field Variable 7|Char|Detai Record| |PPRM.FIELD_VARIABLE|Tax_Parm_7| |
|1|628|1|60|Tax Rate Code 7|Char|Detail Record| |PPRM.PTM_ID| |DEDUCTIONS|
|1|700|1|1|CONTACTS_GRP|Char|Header Record| |IVECT|Contact| |
|1|702|1|50|First Name|Char|Detail Record| |IVECT.FIRST_NAME|First_Name| |
|1|704|1|50|Last Name|Char|Detail Record| |IVECT.LAST_NAME|Last_Name| |
|1|706|1|30|Relation|Char|Detail Record| |IVECT.RELATION|Relation| |
|1|708|1|20|Phone #|Char|Detail Record| |IVECT.PHONE_NUMBER|Phone_Number| |
|1|710|1|20|Cellular #|Char|Detail Record| |IVECT.CELLULAR_NUMBER|Cellular_Number| |
|1|712|1|30|Contact Type|Char|Detail Record| |IVECT.CONTACT_TYPE|Contact_Type| |Spouse
|1|714|1|30|Contact Status|Char|Detail Record| |IVECT.CONTACT_STATUS| |01|
----
![Notes|Edit:Internal.UEINH]
[{InsertPage page='Internal.UEINH' default='Click to create a new notes page'}]
This page (revision-16) was last changed on 27-Apr-2022 10:34 by Lilia UrtanTop