UEINH
Back to current versionRestore this version

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

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 MappingCorresponding Lexicon
X_NEOGOV_ETHNICX_ETHNIC
X_NEOGOV_MARITAL_STATUSX_MARITAL_STATUS
X_NEOGOV_TAX_PARMX_NEOGOVX_TAX_PARMX
X_NEOGOV_UFED_FILING_STATUSX_UFED_FILING_STATUS
X_NEOGOV_UST_FILING_STATUSX_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 NameName of the complete path and directory
XML File NameName of XML file to be extracted
Interface CodeInterface format for extracting data
Exception LevelException only, User Trace, Legislation, UserCalc Trace, Program Trace or Utility Trace
Clear CV TablesPurge 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.

Reference ID on each interface definition column (IDIF) is specific to each database which reference the id on IMCD column details tab.  Without this properly set the UEINH will not function. The standard IDIF is sent out with the reference Id blank. The first time UEINH is run in each environment, the user must answer Yes to the prompt.  For example, 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#StartEndNameField TypeRecordFormat MaskRecord IdentifierXML TagConstant ValueDerivation
1111FILE_HEADERCharNot Specified Person
11011PERSONALS_GRPCharHeader Record IVEPSPersonal  
112160Employee #CharDetail Record IVEPS.PERSON_CODEPerson_Code
114116S.S.N.CharDetail Record IVEPS.GOVERNMENT_CODEGovernment_Code
116150First NameCharDetail Record IVEPS.FIRST_NAMEFirst_Name
118150Last NameCharDetail Record IVEPS.LAST_NAMELast_Name
12011Date of BirthDateDetail RecordYYYY-MM-DDIVEPS.BIRTH_DATEBirth_Date
122130GenderCharDetail Record IVEPS.GENDERGender
124130LanguageCharDetail Record IVEPS.LANGUAGE_CODE ENG
126130EthnicCharDetail Record IVEPS.ETHNICEthnic
128150Middle NameCharDetail Record IVEPS.MIDDLE_NAMEMiddle_Name
130150Photo LocationCharDetail Record IVEPS.PHOTO_LOCATION person_code.jpg
132130Govt Code OriginCharDetail Record IVEPS.GOVT_CODE_ORIGIN US
13411Effective as ofDateDetail Record IVEPS.EFFECTIVE IVEEM.HIRE_DATE
136160Change ReasonCharDetail Record IVEPS.CHANGE_CODE INITIAL RECORD
138150Address 1CharDetail Record IVEPS.ADDRESS_LINE_1Address_Line_1
140150Address 2CharDetail Record IVEPS.ADDRESS_LINE_2Address_Line_2
142150City/TownCharDetail Record IVEPS.LOCALITYCity
144160StateCharDetail Record IVEPS.STATE_PROVINCE_CODEState_Code
146160CountryCharDetail Record IVEPS.COUNTRY_CODE USA
148116Zip CodeCharDetail Record IVEPS.ZIP_POSTALZip
150120Phone #CharDetail Record IVEPS.PHONE_NUMBERPhone_Number
152120Cellular #CharDetail Record IVEPS.CELLULAR_NUMBERCellular_Number
154150E-mailCharDetail Record IVEPS.EMAIL_ADDRESSEmail_Address
156130Marital StatusCharDetail Record IVEPS.MARITAL_STATUSMarital_Status
110011EMPLOYMENTS_GRPCharHeader Record IVEEMEmployment
1102160EntityCharDetail Record IVEEM.ENTITY_CODE
1104130Employment TypeCharDetail Record IVEEM.EMPLOYMENT_TYPE 01
110611Date of HireDateDetail RecordYYYY-MM-DDIVEEM.HIRE_DATEHire_Date
110811Original Hire DateDateDetail RecordYYYY-MM-DDIVEEM.ORIGINAL_HIRE_DATEOriginal_Hire_Date IVEEM.HIRE_DATE
111011Seniority DateDateDetail RecordYYYY-MM-DDIVEEM.SENIORITY_DATESeniority_Date IVEEM.HIRE_DATE
120011ASSIGNMENTS_GRPCharHeader Record IVEASAssignment
1202160EntityCharDetail Record IVEAS.ENTITY_CODE
1204130Employment TypeCharDetail Record IVEAS.EMPLOYMENT_TYPE 01
120611Date of HireDateDetail Record IVEAS.HIRE_DATE IVEEM.HIRE_DATE
1208160AssignmentCharDetail Record IVEAS.ASSIGNMENT_CODE PRIME
1210130TypeCharDetail Record IVEAS.ASSIGNMENT_TYPE 00
1212130StatusCharDetail Record IVEAS.ASSIGNMENT_STATUS 01
121411Start DateDateDetail Record IVEAS.ASSIGNMENT_START_DATE IVEEM.HIRE_DATE
121614Prime AssignmentCharDetail Record IVEAS.PRIME_ASSIGNMENT 1
121811Effective as ofDateDetail Record IVEAS.EFFECTIVE IVEEM.HIRE_DATE
122011Expires onDateDetail Record IVEAS.EXPIRY 31-Dec-3999
1222160Change ReasonCharDetail Record IVEAS.CHANGE_CODE INITIAL RECORD
1224160Employment StatusCharDetail Record IVEAS.STATUS_CODE PENDING
1226160PositionCharDetail Record IVEAS.POSITION_CODEPosition_Code
1228160Employee #CharDetail Record IVEAS.PERSON_CODE_SUPERVISED_BYSupervisory
1230160Wage ScaleCharDetail Record IVEAS.SCALE_CODE
1232160StepCharDetail Record IVEAS.STEP_CODEStep_Code
123419FTENumberDetail Record IVEAS.FTEFTE
1236118Wage RateNumberDetail Record IVEAS.WAGE_RATEWage_Rate
1238130BasisCharDetail Record IVEAS.RATE_BASISRate_Basis
124011Job Seniority DateDateDetail Record IVEAS.JOB_SENIORITY_DATE IVEEM.HIRE_DATE
1242150E-mailCharDetail Record IVEAS.EMAIL_ADDRESSEmail_Address
124414Web Pay Stub OnlyCharDetail Record IVEAS.WEB_PAY_STUB_ONLY
130011EASD_UDF_GRPCharHeader Record EASDAssignment
130211EASD UDF Place HolderCharDetail Record EASD.UDF_USER_FIELD_01
140011PAYMENTRULES_GRPCharHeader Record IVPPYDPayment_Rule
1402160EntityCharDetail Record IVPPYD.ENTITY_CODE
1404130Employment TypeCharDetail Record IVPPYD.EMPLOYMENT_TYPE 01
140611Effective as ofDateDetail Record IVPPYD.EFFECTIVE IVEEM.HIRE_DATE
140811Expires onDateDetail Record IVPPYD.EXPIRY 31-Dec-3999
1410160Change ReasonCharDetail Record IVPPYD.CHANGE_CODE INITIAL RECORD
1412130TypeCharDetail Record IVPPYD.PAYMENT_RULE_TYPE
1414160CountryCharDetail Record IVPPYD.COUNTRY_CODE IVEPS.COUNTRY_CODE
1416160Bank Transit CodeCharDetail Record IVPPYD.BANK_TRANSIT_CODEBank_Transit_Code
1418130Bank AccountCharDetail Record IVPPYD.BANK_ACCOUNTBank_Account
1420130Bank Account TypeCharDetail Record IVPPYD.BANK_ACCOUNT_TYPEBank_Account_Type
142215Split SequenceNumberDetail Record IVPPYD.SPLIT_SEQUENCESequence
1424118Amount $NumberDetail Record IVPPYD.AMOUNTAmount
142614Pay RemainingCharDetail Record IVPPYD.PAY_REMAININGPay_Remaining
142814Prime DepositCharDetail Record IVPPYD.PRIME_DEPOSITPrime_Deposit
150011USPAYRULES_GRPCharHeader Record IVPPRUUS_Pay_Rule
1502160EntityCharDetail Record IVPPRU.ENTITY_CODE
1504130Employment TypeCharDetail Record IVPPRU.EMPLOYMENT_TYPE 01
150611Date of HireDateDetail Record IVPPRU.HIRE_DATE IVEEM.HIRE_DATE
1508150DescriptionCharDetail Record IVPPRU.DESCRIPTION Default
151011Effective as ofDateDetail Record IVPPRU.EFFECTIVE IVEEM.HIRE_DATE
151211Expires onDateDetail Record IVPPRU.EXPIRY 31-Dec-3999
1514160Change ReasonCharDetail Record IVPPRU.CHANGE_CODE INITIAL RECORD
1516130FED Filing StatusCharDetail Record IVPPRU.UFED_FILING_STATUSUfed_Filing_Status
151815FED Number of ExemptionsNumberDetail Record IVPPRU.UFED_NUM_EXEMPTIONSUfed_Num_Exemptions
1520118FED Add'l Tax Per PeriodNumberDetail Record IVPPRU.UFED_ADD_TAX_PER_PERIODUfed_Add_Tax_Per_Period
1522130FED Tax MethodCharDetail Record IVPPRU.UFED_TAX_METHOD
1524130FED Suppl Tax MethodCharDetail Record IVPPRU.UFED_SUPPL_TAX_METHOD
1526130FED FICA MethodCharDetail Record IVPPRU.UFED_FICA_METHOD
1528130FED Medicare MethodCharDetail Record IVPPRU.UFED_MEDICARE_METHOD
1530130STATE Filing StatusCharDetail Record IVPPRU.UST_FILING_STATUSUst_Filing_Status
153215STATE Number of Exemption 1NumberDetai Record IVPPRU.UST_NUM_EXEMPTION_1Ust_Num_Exemption_1
1534118STATE Add'l Tax Per PeriodNumberDetail Record IVPPRU.UST_ADD_TAX_PER_PERIODUst_Add_Tax_Per_Period
1536130STATE Tax MethodCharDetail Record IVPPRU.UST_TAX_METHOD
1538130STATE Suppl Tax MethodCharDetail Record IVPPRU.UST_SUPPL_TAX_METHOD
160011MISC_PARAMETERS_GRPCharHeader Record PPRMMisc_Parameters
160214000Field VariableCharDetail Record PPRM.FIELD_VARIABLETax_Parm_1
1604160Tax Rate CodeCharDetail Record PPRM.PTM_ID FILINGSTATUS
160614000Field Variable 2CharDetail Record PPRM.FIELD_VARIABLETax_Parm_2
1608160Tax Rate Code 2CharDetail Record PPRM.PTM_ID TOTALALLOWANCES
161014000Field Variable 3CharDetail Record PPRM.FIELD_VARIABLETax_Parm_3
1612160Tax Rate Code 3CharDetail Record PPRM.PTM_ID 2020_W4
161414000Field Variable 4CharDetail Record PPRM.FIELD_VARIABLETax_Parm_4
1616160Tax Rate Code 4CharDetail Record PPRM.PTM_ID TWO_JOBS
161814000Field Variable 5CharDetail Record PPRM.FIELD_VARIABLETax_Parm_5
1620160Tax Rate Code 5CharDetail Record PPRM.PTM_ID DEPENDENTS_AMT
162214000Field Variable 6CharDetail Record PPRM.FIELD_VARIABLETax_Parm_6
1624160Tax Rate Code 6CharDetail Record PPRM.PTM_ID OTHER_INCOME
162614000Field Variable 7CharDetai Record PPRM.FIELD_VARIABLETax_Parm_7
1628160Tax Rate Code 7CharDetail Record PPRM.PTM_ID DEDUCTIONS
170011CONTACTS_GRPCharHeader Record IVECTContact
1702150First NameCharDetail Record IVECT.FIRST_NAMEFirst_Name
1704150Last NameCharDetail Record IVECT.LAST_NAMELast_Name
1706130RelationCharDetail Record IVECT.RELATIONRelation
1708120Phone #CharDetail Record IVECT.PHONE_NUMBERPhone_Number
1710120Cellular #CharDetail Record IVECT.CELLULAR_NUMBERCellular_Number
1712130Contact TypeCharDetail Record IVECT.CONTACT_TYPEContact_Type Spouse
1714130Contact StatusCharDetail Record IVECT.CONTACT_STATUS 01

Notes #

Click to create a new notes page