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 13 added 118 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__".
\\
\\
||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|
At line 132 added 2 lines
2. Add/update constant values for desire DIFD fields.
3. Set up Preference "DFLT PAYRULE" in IMST
At line 15 removed 19 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 DIFD
fields.
3.      
Set up Preference "DFLT PAYRULE" in
IMST
At line 137 added 5 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
At line 38 removed 3 lines
Directory
Name                Name of the complete
path and directory
At line 44 removed 3 lines
XML File Name
                Name of XML file to be
extracted
At line 49 removed 23 lines
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
This page (revision-16) was last changed on 27-Apr-2022 10:34 by Lilia UrtanTop