/
Import E-List Data Utility

NoHo CARE Online User Guide

Import E-List Data Utility

Owned by NoHo Software (Unlicensed)
Oct 01, 2018


The Import E-List Data Utility allows users to import family and child data from an E-List export file. 




To use the Import E-List Data Utility:

  1. Open the E-List Data Utility by going to Main Menu > Case Management > Import E-List Data.

  2. Select the Division.

  3. Click the Choose File button to browse for the file that was exported from E-List.
    When selecting a file to import, the file path used last will now be retained so that users can more easily import multiple records without having to navigate through the file system to find the files each time. The file path will only be retained as long as the Import E-List Data Utility is open.  The file path will not be saved once the form is closed.

  4. Select the format.
    Select “NoHo” to import a Family/Child record that was exported from NoHo E-List.

  5. Click the Import button.

  6. After the family and child data is successfully imported, you will get a confirmation message with the Family and Child ID. 


Field Mapping Details


Notes:

  • To export the family and child data, use the Export button on the Family Form in E-List

  • The export uses setup codes for Relationship, Native Language, Ethnicity, Special Needs, Income Source, Eligibility, and Need Status. Administrators should compare the setup codes for these fields in CARE and E-List to be sure that the same codes are being used in both databases.  Please use caution when changing setup codes because there are some standard setup codes that are required for system functionality in CARE and E-List.  If you have any questions, please contact our support team before changing your setup codes.

Family Data

Data Field

From (NoHo E-List)

To (NoHo CARE)

Field 1- Record Type (F=Family)

n/a

n/a

Field 2- Family ID

Family Form

This field is not imported into CARE.  It is included in the Export for reference purposes only.

Field 3- Case Number

Family Form/Misc. Info section

Family Form

Field 4- Primary First Name

Family Form/Primary Parent tab

Family Form

Field 5- Primary Last Name

Family Form/Primary Parent tab

Family Form

Field 6- Primary Relationship Code *

Family Form/Primary Parent tab

Family Form

Field 7- Primary Birth Date

Family Form/Primary Parent tab

Family Form

Field 8- Primary SSN

Family Form/Primary Parent tab

Family Form

Field 9- Primary Native Language Code *

Family Form/Primary Parent tab

Family Form

Field 10- Primary Home Phone

Family Form/Primary Parent tab

Family Form

Field 11- Primary Work Phone

Family Form/Primary Parent tab

Family Form/Employment tab

Field 12- Secondary First Name

Family Form/Secondary Parent tab

Family Form

Field 13- Secondary Last Name

Family Form/Secondary Parent tab

Family Form

Field 14- Secondary Relationship Code *

Family Form/Secondary Parent tab

Family Form

Field 15- Secondary Birth Date

Family Form/Secondary Parent tab

Family Form

Field 16- Secondary SSN

Family Form/Secondary Parent tab

Family Form

Field 17- Secondary Native Language Code *

Family Form/Secondary Parent tab

Family Form

Field 18- Secondary Home Phone

Family Form/Secondary Parent tab

Family Form

Field 19- Secondary Work Phone

Family Form/Secondary Parent tab

Family Form/Employment tab

Field 20- Main Address1

Family Form/Address tab

Family Form

Field 21- Main Address2

Family Form/Address tab

Family Form

Field 22- Main City

Family Form/Address tab

Family Form

Field 23- Main State

Family Form/Address tab

Family Form

Field 24- Main Zip Code

Family Form/Address tab

Family Form

Field 25- FIPS County Code

The FIPS code is not displayed on the screen, however it is stored in the database and is associated with the county that is selected on the Family Form/Address tab

The FIPS code is not displayed on the screen, however it is stored in the database and is associated with the county that is selected on the Family Form.

Field 26- Single Parent (Y/N) (Y=1, N=0)

Family Form

Family Form

Field 27- SSN Consent

Family Form/Keep SSN Info Private check box


(Note, if this checkbox is checked in CEL, then it indicates that the parent has chosen to keep their SSN private).

Family Form/ SSN Consent check box


(Note, if the “Keep SSN Private” checkbox is checked in CEL, then the “SSN Consent” checkbox will not be checked in CARE).

Field 28- Term.from Cash Aid (Y/N)    (Y=1, N=0)

If a date is entered in the Cash Aid Term field on the Family Form/Primary Parent tab, then a “1” will be exported.  (1 = Yes).  If the field is null (blank), then a “0” will be exported.  (0 = No)

Currently, this field is not imported into CARE, however we are considering including this field in a future version of the import utility.

Field 29- Cash Aid Term Date

Family Form/Primary Parent tab

Currently this field is not imported into CARE, however we are considering including this field in a future version of the import utility.

Field 30- Diversion (Y/N)
(Y=1, N=0)  (Primary or Secondary Parent)

Family Form/Primary and Secondary Parent tabs

Currently this field is not imported into CARE, however we are considering including this field in a future version of the import utility.

Field 31- Diversion Date

Family Form

Currently this field is not imported into CARE, however we are considering including this field in a future version of the import utility. 

Field 32- CPS (Y/N) (Y=1, N=0)

Family Form

Currently this field is not imported into CARE, however we are considering including this field in a future version of the import utility.

Field 33- CPS Date

Family Form

Currently this field is not imported into CARE, however we are considering including this field in a future version of the import utility.

Field 34- Primary Extension

Family Form/Primary Parent tab

Family Form/Employment tab

Field 35- Secondary Extension

Family Form/Secondary Parent tab

Family Form/Employment tab

Field 36- Primary Email

Family Form/Primary Parent tab

Family Form

Field 37- Secondary Email

Family Form/Secondary Parent tab

Family Form

Field 38- Primary Gender

Family Form/Primary Parent tab

Family Form

Field 39- Secondary Gender

Family Form/Secondary Parent tab

Family Form

Field 40- Primary Parent Ethnicity*

Family Form/Primary Parent tab

Family Form

Field 41- Secondary Parent Ethnicity*

Family Form/Secondary Parent tab

Family Form

Field 42- Mailing Address1

Family Form/Address tab

Family Form

Field 43- Mailing Address2

Family Form/Address tab

Family Form

Field 44- Mailing City

Family Form/Address tab

Family Form

Field 45- Mailing State

Family Form/Address tab

Family Form

Field 46- Mailing Zip Code

Family Form/Address tab

Family Form

Fields 47-50

Not currently used (reserved for future use)

Not currently used (reserved for future use)

Income Data

Data Field

From (NoHo E-List)

To (NoHo CARE)

Field 1- Record Type (I=Income)

n/a

n/a

Field 2- Family ID

Family Form

This field is not imported into CARE.  It is included in the Export for reference purposes only.

Field 3- Income Effective Date

Not stored in CEL, so the current date (when export is run) will be inserted in this field

Family Form Income/Family Fee tab.

Field 4- Family Size

Family Form

Family Form/Family Income-Fee Form

Field 5- Total Income

Family Info/Income Form

This field is not imported into CARE.  It is included in the Export for reference purposes only.

Field 6- Income Source Code *

Family Info/Income Form

Family Form/Family Income-Fee Form

Field 7- Income Amount

Family Info/Income Form

Family Form/Family Income-Fee Form


Eligibility Data

Data Field

From (NoHo E-List)

To (NoHo CARE)

Field 1- Record Type (E=Eligibility)

n/a

n/a

Field 2- Family ID

Family Form

This field is not imported into CARE.  It is included in the Export for reference purposes only.

Field 3- Eligibility Code *

Family Info/Eligibility Form

Family Form/Eligibility Status tab


Need Status Data

Data Field

From (NoHo E-List)

To (NoHo CARE)

Field 1- Record Type (N=Need)

n/a

n/a

Field 2- Family ID

Family Form

This field is not imported into CARE.  It is included in the Export for reference purposes only.

Field 3- Family Member
(Primary=A, Secondary=B)

Family Form/Need Status Form- Primary or Secondary tab

Family Form/Need Status tab- Family Member combo box

Field 4- Need Status Code *

Family Form/Need Status Form

Family Form/Need Status tab


Child Data

Data Field

From (NoHo E-List)

To (NoHo CARE)

Field 1- Record Type (C=Child)

n/a

n/a

Field 2- Family ID

Family Form

This field is not imported into CARE.  It is included in the Export for reference purposes only.

Field 3- Child ID

Child Form

This field is not imported into CARE.  It is included in the Export for reference purposes only.

Field 4- Child First Name

Child Form

Child Form

Field 5- Child Last Name

Child Form

Child Form

Field 6- Child Birth Date

Child Form

Child Form

Field 7- Special Needs
(Y/N) (Y=1, N=0)

If there is a selection in the Special Needs combo box, then a “1” will be exported.  (1 = Yes).  If there is no selection made, then a “0” will be exported.  (0 = No)

Child Form/Special Needs check box

Field 8- Special Needs Code *

The special needs code is currently being left out of  export file since the special needs options in E-List generally don’t match the special needs options in CARE

(see note on left)

Field 9- Foster Child
(Y/N) (Y=1, N=0)

Child Form

Child Form/Foster Child check box

Field 10- Previously Served 11 or 12 year old

Child Form

Currently this field is not imported into CARE, however we are considering including this field in a future version of the import utility.

Field 11- Limited English Proficient
(Y/N)   (Y=1, N=0)

Child Form

Child Form/Limited English check box

Field 12- Exceptional Needs
(Y/N)   (Y=1, N=0)

Child Form

Child Form/Exceptional Needs check box

Field 13- Child Ethnicity

Child Form

Child Form

Field 14- Child Gender

Child Form

Child Form



Important:

* The export uses setup codes for Relationship, Native Language, Ethnicity, Special Needs, Income Source, Eligibility, and Need Status. Administrators should compare the setup codes for these fields in CARE and E-List to be sure that the same codes are being used in both databases.  Please use caution when changing setup codes because there are some standard setup codes that are required for system functionality in CARE and E-List.  If you have any questions, please contact our support team before changing your setup codes.



Applicable Setup and System Options:

  • For this page, the applicable security rights for a user are based on the user's rights to the "FORM Import E-List Data" security object. Note: Security rights are set by CARE Administrators on the User Security Page.





Related content

Copyright ©1995. David Grant, Inc. All rights reserved. All NoHo software and related products, including the NoHo Care Online User Guide, are the sole property of David Grant, Inc. (”DGI”), and may not be used by, distributed to, or shared with any person(s) or entity(s) that are not currently licensed users.