List Public Enums / Clean This Up
ENUM: SQL_IMPORTAPIWARNINGLEVEL
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
|
