Create Custom Flat File Layout Screen

The purpose of the Create Custom Flat File Layout screen is to allow a provider to specify its own flat file format for loading patient, immunization, comment, or event files into the ALERT IIS. Training and experience with Data Exchange is required to use this feature.

Required Fields
Field Name	Description
Custom Flat File Template Name	Template Name of the custom template.
Define Patient File Information File Length	Length of the Patient File that will be imported.
Record Identifier	Starting position of the Record Identifier, used to link a Patient to Immunization records in the Patient file.
First Name	Starting position of the First Name of the Patient in the file.
Last Name	Starting position of the Last Name of the Patient in the file.
Birth Date	Starting position of the Birth Date of the Patient in the file.
Define Immunization File Information File Length	Length of the Immunization File that will be imported.
Record Identifier	Starting position of the Record Identifier, used to link a Patient to Immunization records in the Immunization File.
NDC Code	Starting position of the NDC Code of the Immunization File, either NDC Code, Trade Name, CPT Code, CVX Code or Vaccine Group need to be entered.
Trade Name	Starting position of the Trade Name of the Immunization File, either NDC Code, Trade Name, CPT Code, CVX Code or Vaccine Group need to be entered.
CPT Code	Starting position of the CPT Code of the Immunization File, either NDC Code, Trade Name, CPT Code, CVX Code or Vaccine Group need to be entered.
CVX Code	Starting position of the CVX Code of the Immunization File, either NDC Code, Trade Name, CPT Code, CVX Code or Vaccine Group need to be entered.
Vaccine Group	Starting position of the Vaccine Group of the Immunization File, either NDC Code, Trade Name, CPT Code, CVX Code or Vaccine Group need to be entered.
Vaccination Date	Starting position of the Vaccination Date of the Immunization File.
Define Comment File Information File Length	Length of the Comment File that will be imported.
Record Identifier	Starting position of the Record Identifier, used to link a Patient to Immunization and Comment records in the Comment File.
Comment Code	Starting position of the Comment code of the Comment File.
Record Identifier	Starting position of the Record Identifier of the Event File.
Event Code	Starting position of the Event code of the Event File.
Priority Group	Starting position of the Priority Group of the Event File.

Other Fields
Field Name	Description
Patient Status	Starting position of the Patient Status of the Patient in the file.
Middle Name	Starting position of the Middle Name of the Patient in the file.
Name Suffix	Starting position of the Name Suffix of the Patient in the file.
Death Date	Starting position of the Death Date of the Patient in the file.
Mothers First Name	Starting position of the Mothers First Name of the Patient in the file.
Mothers Maiden Last Name	Starting position of the Mothers Maiden Last Name of the Patient in the file.
Mothers HBsAg Status	Starting position of the Mothers HBsAg Status of the Patient in the file.
Sex Gender	Starting position of the Sex Gender of the Patient in the file.
American Indian or Alaskan Native	Starting position of the American Indian or Alaskan Native Race of the Patient in the file.
Asian	Starting position of the Asian Race of the Patient in the file.
Native Hawaiian or Other Pacific Islander	Starting position of the Native Hawaiian or Other Pacific Islander Race of the Patient in the file.
Black or African-American	Starting position of the Black or African-American Race of the Patient in the file.
White	Starting position of the White Race of the Patient in the file.
Other Race	Starting position of the Other Race of the Patient in the file.
Ethnicity Code	Starting position of the Ethnicity Code of the Patient in the file.
Social Security Number	Starting position of the Social Security Number of the Patient in the file.
Contact Allowed	Starting position of the Contact Allowed of the Patient in the file.
Patient ID	Starting position of the Patient ID of the Patient in the file.
Medicaid ID	Starting position of the Medicaid ID of the Patient in the file.
Responsible Party First Name	Starting position of the Responsible Party First Name of the Patient in the file.
Responsible Party Middle Name	Starting position of the Responsible Party Middle Name of the Patient in the file.
Responsible Party Last Name	Starting position of the Responsible Party Last Name of the Patient in the file.
Responsible Party Relationship	Starting position of the Responsible Party Relationship of the Patient in the file.
Street Address	Starting position of the Street Address of the Patient in the file.
Other Address Line	Starting position of the Other Address Line of the Patient in the file.
PO Box Route Line	Starting position of the PO Box Route Line of the Patient in the file.
City	Starting position of the City of the Patient in the file.
State	Starting position of the State of the Patient in the file.
Zip	Starting position of the Zip of the Patient in the file.
County	Starting position of the County of the Patient in the file.
Phone	Starting position of the Phone of the Patient in the file.
Sending Organization	Starting position of the Sending Organization in the file.
Administration Route Code	Starting position of the Administration Route Code in the Immunization file.
Body Site Code	Starting position of the Body Site Code in the Immunization file.
Reaction Code	Starting position of the Reaction Code in the Immunization file.
Manufacturer Code	Starting position of the Manufacturer Code in the Immunization file.
Immunization Information Source	Starting position of the Immunization Information Source in the Immunization file.
Lot Number	Starting position of the Lot Number in the Immunization file.
Provider Name	Starting position of the Provider Name in the Immunization file.
Administered By Name	Starting position of the Administered By Name in the Immunization file.
Sending Organization	Starting position of the Sending Organization in the Immunization file.
Vaccine Eligibility	Starting position of the Vaccine Eligibility in the Immunization file.
Begin Date	Starting position of the Begin Date in the Comment file.
End Date	Starting position of the End Date in the Comment file.

The following table describes the buttons available on the Create Custom Flat File Layout screen.

Command Button	Description
	When clicking on the View button, the system displays the detailed field lengths and starting positions for all the fields in the custom layout chosen from the pick list.
	When clicking the Edit button, the system displays the Edit Layout page.
	When clicking the Create new layout button, the system displays the Create New Layout page.
	When clicking the Save button, the system validates all fields are entered correctly and saves the New Layout that was developed.
	When clicking the Update button, the system validates all fields are entered correctly and saves the edited layout that was developed.
	When clicking the Cancel button, the system returns to the previous screen.