Enumerators

public enum SQL_IMPORTAPIWARNINGLEVEL

   {

       enSQLDoNothing = -1,

       enSQLAddToWarningTable = 0,

       enSQLFatal = 1,

       enSQLUseColumnC0 = 2

   }

They are currently set in the Database maintenance part of the profile.

These values tell the Schema Engine AND the API how to treat importing HL7 messages. You will also note that Truncation and Unknown Segment have different choices. With Truncation you have the option to Place in the C0 Column while with Unknown Segment you do not.

If you've looked at our segment data tables you can see that every HL7 field has a C0 column which will be a VarChar(Max), this is even if the actual HL7 field is 1 Component 1 character long. If the Schema Engine detects any HL7 field that REPEATS OR any component of a field which contains SUBCOMPONENTS it will automatically place the RAW value of that entire field in the C0 column while also populating what it can in the C1, C2, C3 columns etc. This is AUTOMATIC, but you can also add to this behavior by telling the Schema Engine to also put truncated data in the C0 column as well.

With UNKNOWN segments the C0 column isn't an option. Since there's no segment tables, there's no field columns, and thus no C0 column so you only have the options of:

       enSQLDoNothing = -1,

       enSQLAddToWarningTable = 0,

       enSQLFatal = 1,

Digression, because this is important. Consider a HL7 field that repeats but contains NO data in the first repeat. Example data: |~254-549-0825^me@mywork.com|. This could be a perfectly valid repeating example of a contacts type of field with HOME and WORK values in the same field. There's no HOME contact (he's homeless) only work contacts. In this example let's say it's the ZXZ segment field number 3 which has 2 components Phone and Email. In the database values would look like this:

ZXZ_F3_C0 = ~254-549-0825^me@mywork.com

ZXZ_F3_C1 = NULL

ZXZ_F3_C2 = NULL

  Public Enum HL7DateTimePrecision

       enDay = 0

       enMinute = 1

       enSeconds = 2

       enMilliseconds = 3

  End Enum

  Public Enum DBBaseDataTypeEnum

       BDT_String = 0

       BDT_Date = 1

       BDT_Numeric = 2

       BDT_BlobText = 3

       BDT_Other = 4

  End Enum    

Used by the HL7FileAnalyzer class.

  Public Enum EHFA_ErrorType

       EHFA_NoError = 0

       EHFA_SystemError = 1

       EHFA_FileIsBlank = 2

       EHFA_FileHasNoMessages = 3

       EHFA_FileDoesNotExist = 4

       EHFA_InvalidPropertyValues = 5

       EHFA_NoFileIsOpen = 6

       EHFA_MessageNotFound = 7

       EHFA_FileAccessError = 8

       EHFA_AnalysisCancelled = 9

       EHFA_InvalidObjectState = 10

  End Enum