!!! 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.

!! 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__".
\\
\\
||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|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| 

2. Add/update constant values for desire DIFD fields.
3. Set up Preference "DFLT PAYRULE" in IMST 

!! 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