Manually enter the record definitions for the source data, which is enrollment data from your trading partner. The enrollment file is produced by your trading partner’s human resources application (HR_ENRL.SEQ) and consists of two record types – one for subscribers (ENRL_SUB) and one for dependents (ENRL_DEP). These formats are displayed below:
HR_ENRL.SEQ REC_TYPE 1 AN SUBSCR_ID 9 AN RELATIONSHIP 1 AN SSN 9 AN NAME_LAST 20 AN NAME_FIRST 20 AN NAME_MI 1 AN ADDR1 35 AN ADDR2 35 AN CITY 20 AN STATE 2 AN ZIP_5 5 AN DT_OF_BRTH 8 DT COVG_START_DT 8 DT COVG_END_DT 8 DT
Manually entering record definitions
ECMap automatically calculates the record length for you as you add fields to the record.
Select Records/Tables on the toolbar or Workspace. The Records/Tables window displays.
Right-click Records on the Records/Tables window and choose New Record from the drop-down menu. The New Record window displays with the Required tab selected.
Enter the following on the New Record window, Required tab:
Record Name – enter ENRL_SUB
Record Description – enter Employee/subscriber record
Record Length – enter 0
End Character – select CRLF from the drop-down list
Select the Optional tab.
In Record Type, select Source (input data to map).
Select OK to display the New Field window. The New Field window has two tabs – Fields and Options.
Navigating through the fields in a record
ECMap automatically fills in the Start Position of the current field. For the first field in a record, ECMap enters “1”. For subsequent fields, ECMap calculates the start position based on the field lengths you entered for the previous fields.
On the Fields tab, ECMap automatically enters the Record Name, ENRL_SUB.
The Field Description is optional; if you leave it blank, ECMap populates it with the Field Name.
You must enter the Field Name, Length, and Type on the Fields tab.
The Web Parameter is required only for HTML or XML data.
If you begin typing “AN” ECMap automatically enters the alphanumeric Field Type for you.
After you enter the information on the Fields tab for each field (except the last), select Next. A blank New Field window displays. After you enter the information for the last field in the record,
Select OK to return to the New Record window.
After you have entered the information for one field, to move to a new field, you can TAB down to Next and press Enter, select Next, or press the “N” key while holding down the ALT key.
Entering information in the fields in a record
Enter the following on the Fields tab, then select Next:
Field Name REC_TYPE Field Length 1 Field Type AN
Enter the following on the Fields tab, then select Next:
Field Name SUBSCR_ID Field Length 9 Field Type AN
Enter the following on the Fields tab, then select Next:
Field Name RELATIONSHIP Field Length 1 Field Type AN
Enter the following on the Fields tab, then select Next:
Field Name SSN Field Length 9 Field Type AN
Enter the following on the Fields tab, then select Next:
Field Name NAME_LAST Field Length 20 Field Type AN
Enter the following on the Fields tab, then select Next:
Field Name NAME_FIRST Field Length 20 Field Type AN
Enter the following on the Fields tab, then select Next:
Field Name NAME_MI Field Length 1 Field Type AN
Enter the following on the Fields tab, then select Next:
Field Name ADDR1 Field Length 35 Field Type AN
Enter the following on the Fields tab, then select Next:
Field Name ADDR2 Field Length 35 Field Type AN
Enter the following on the Fields tab, then select Next:
Field Name CITY Field Length 20 Field Type AN
Enter the following on the Fields tab, then select Next:
Field Name STATE Field Length 2 Field Type AN
Enter the following on the Fields tab, then select Next:
Field Name ZIP_5 Field Length 5 Field Type AN
Enter the following on the Fields tab, then select Next:
Enter on the Fields tab: Field Name DT_OF_BIRTH Field Length 8 Field Type DT
Two text boxes appear. Select from the drop-down list, then select Next:
Date Format YYYYMMDD Century Minimum Type Use global century minimum
If you start typing “YYY..” ECMap
automatically enters the Date Format for you.
If you start typing “Use Glo...”, ECMap enters the Century Minimum Type for you automatically.
Enter on the Fields tab:
Field Name COVG_START_DT Field Length 8 Field Type DT
Two text boxes appear. Select from the drop-down list, then select Next:
Date Format YYYYMMDD Century Minimum Type Use global century minimum
Enter on the Fields tab:
Field Name COVG_END_DT Field Length 8 Field Type DT
Select from the drop-down list:
Date Format YYYYMMDD Century Minimum Type Use global century minimum
Select OK to return to the Records/Tables window. The fields in the record ENRL_SUB are displayed.
If you accidentally select Next instead of OK, you must
select Cancel to exit from the Field Properties window and return
to the New Record window.
Creating a copy of a record and its fields
Right-click ENRL_SUB and choose Template Record from the drop-down menu.
The Template Record window displays with the Required tab selected. Record Description, Record Length, and End Character are automatically populated with information from the ENRL_SUB record.
For the Required tab, enter or change the following:
Name – enter ENRL_DEP.
Description – change the description to Employee dependent record.
Length – do not make any changes.
For End Character – keep CRLF.
Select the Optional tab.
For Record Type, keep Source (input data to map).
Leave Record Tag blank.
Select OK to return to the Records/Tables window.
Adding field attributes to the manually entered
records
On the Records/Tables window, open ENRL_SUB, right-click REC_TYPE under ENRL_SUB, and choose Field Properties from the drop-down menu. The Field Properties window displays.
Select the Options tab to make it active. Select the check box next to Record Type to check it and then select in the Record Type text box.
Type S in the text box and select OK to return to the Records/Tables window. Close the ENRL_SUB record by selecting the minus button next to it.
The “record type” field property associates
an application data record with a layout. In this example, assign “S” as
the record type for a subscriber record and “D” as
the record type for a dependent record. This is an arbitrary choice,
and you may assign any unique value you choose.
Open ENRL_DEP, right-click REC_TYPE under ENRL_DEP, and choose Field Properties from the drop-down menu. The Field Properties window displays.
Select the Options tab to make it active.
Select the check box next to Record Type to check it and then select in the Record Type text box.
Type D in the text box and select OK to return to the Records/Tables window.
From the File menu on the Records/Tables window, choose Close to return to the main ECMap window.
