UEINH – Import Employee Hires#
Processing Information#
The UEINH function is used to 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.
Supported Business Areas#
Set Up#
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" in IMST
4. Launch the UEINH with "Set Up IDIF" set to Yes.
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 |
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.
Report Parameters & Filters#
| 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. |
The column 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.
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.
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 | 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 | 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 | 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 |
