SQL Table scripts |
Top Previous Next |
|
Below are the scripts for Microsoft SQL Server. If you have a different database, you will have to slighty alter the scripts.
Both tables have an 'ID' column that is self incrementing. The field 'HeaderID' in the child table is the foreign key and points to the ID in the header table. CREATE TABLE [edi_AuthorizerHeader]( [Id] [bigint] IDENTITY(1,1) NOT NULL, [TradingPartnerID] [char](15) NULL, [TradingPartnerIDQual] [char](2) NULL, [FileDate] [date] NULL, [FileTime] [char](10) NULL, [FileName] [varchar](100) NULL, [ProcessDate] [date] NULL, [ProcessTime] [char](10) NULL, [Status] [tinyint] NULL, [Version] [char](12) NULL, [TransactionID] [varchar](30) NULL, [Purpose] [char](2) NULL, [UMOName] [varchar](35) NULL, [UMOIDQual] [char](2) NULL, [UMOID] [varchar](30) NULL, [UMOContact] [varchar](60) NULL, [UMOPhone] [varchar](20) NULL, [UMOExtension] [varchar](10) NULL, [UMOFax] [varchar](20) NULL, [UMOEmail] [varchar](60) NULL, [UMOURL] [varchar](100) NULL, [UMO_RequestValid1] [char](1) NULL, [UMO_RejectReason1] [char](2) NULL, [UMO_FollowUpCode1] [char](1) NULL, [UMO_RequestValid2] [char](1) NULL, [UMO_RejectReason2] [char](2) NULL, [UMO_FollowUpCode2] [char](1) NULL, --[UMO_RequestValid3] [char](1) NULL, --[UMO_RejectReason3] [char](2) NULL, --[UMO_FollowUpCode3] [char](1) NULL, --[UMO_RequestValid4] [char](1) NULL, --[UMO_RejectReason4] [char](2) NULL, --[UMO_FollowUpCode4] [char](1) NULL, --[UMO_RequestValid5] [char](1) NULL, --[UMO_RejectReason5] [char](2) NULL, --[UMO_FollowUpCode5] [char](1) NULL, --[UMO_RequestValid6] [char](1) NULL, --[UMO_RejectReason6] [char](2) NULL, --[UMO_FollowUpCode6] [char](1) NULL, --[UMO_RequestValid7] [char](1) NULL, --[UMO_RejectReason7] [char](2) NULL, --[UMO_FollowUpCode7] [char](1) NULL, --[UMO_RequestValid8] [char](1) NULL, --[UMO_RejectReason8] [char](2) NULL, --[UMO_FollowUpCode8] [char](1) NULL, --[UMO_RequestValid9] [char](1) NULL, --[UMO_RejectReason9] [char](2) NULL, --[UMO_FollowUpCode9] [char](1) NULL, [UMOName_RejectReason1] [char](2) NULL, [UMOName_FollowUpCode1] [char](1) NULL, [UMOName_RejectReason2] [char](2) NULL, [UMOName_FollowUpCode2] [char](1) NULL, --[UMOName_RejectReason3] [char](2) NULL, --[UMOName_FollowUpCode3] [char](1) NULL, --[UMOName_RejectReason4] [char](2) NULL, --[UMOName_FollowUpCode4] [char](1) NULL, --[UMOName_RejectReason5] [char](2) NULL, --[UMOName_FollowUpCode5] [char](1) NULL, --[UMOName_RejectReason6] [char](2) NULL, --[UMOName_FollowUpCode6] [char](1) NULL, --[UMOName_RejectReason7] [char](2) NULL, --[UMOName_FollowUpCode7] [char](1) NULL, --[UMOName_RejectReason8] [char](2) NULL, --[UMOName_FollowUpCode8] [char](1) NULL, --[UMOName_RejectReason9] [char](2) NULL, --[UMOName_FollowUpCode9] [char](1) NULL, [RequestorEntityID] [char](2) NULL, [RequestorName] [varchar](35) NULL, [RequestorFirstName] [varchar](25) NULL, [RequestorMiddleName] [varchar](10) NULL, [RequestorSuffix] [varchar](10) NULL, [RequestorIDQual] [char](2) NULL, [RequestorID] [varchar](30) NULL, [RequestorOtherIDQual1] [varchar](3) NULL, [RequestorOtherID1] [varchar](30) NULL, [RequestorOtherIDQual2] [varchar](3) NULL, [RequestorOtherID2] [varchar](30) NULL, [RequestorOtherIDQual3] [varchar](3) NULL, [RequestorOtherID3] [varchar](30) NULL, [RequestorAddress1] [varchar](55) NULL, [RequestorAddress2] [varchar](55) NULL, [RequestorCity] [varchar](30) NULL, [RequestorState] [char](2) NULL, [RequestorZip] [varchar](15) NULL, [RequestorCountry] [varchar](3) NULL, [RequestorSubdivision] [varchar](3) NULL, [RecieverContact] [varchar](60) NULL, [RequestorTelefone] [varchar](20) NULL, [RequestorExtension] [varchar](10) NULL, [RequestorFax] [varchar](20) NULL, [RequestorEmail] [varchar](60) NULL, [RequestorURL] [varchar](100) NULL, [RequestorProviderCode] [char](2) NULL, [RequestorProviderTaxonomy] [varchar](30) NULL, [Requester_RejectReason1] [char](2) NULL, [Requester_FollowUpCode1] [char](1) NULL, [Requester_RejectReason2] [char](2) NULL, [Requester_FollowUpCode2] [char](1) NULL, --[Requester_RejectReason3] [char](2) NULL, --[Requester_FollowUpCode3] [char](1) NULL, --[Requester_RejectReason4] [char](2) NULL, --[Requester_FollowUpCode4] [char](1) NULL, --[Requester_RejectReason5] [char](2) NULL, --[Requester_FollowUpCode5] [char](1) NULL, --[Requester_RejectReason6] [char](2) NULL, --[Requester_FollowUpCode6] [char](1) NULL, --[Requester_RejectReason7] [char](2) NULL, --[Requester_FollowUpCode7] [char](1) NULL, --[Requester_RejectReason8] [char](2) NULL, --[Requester_FollowUpCode8] [char](1) NULL, --[Requester_RejectReason9] [char](2) NULL, --[Requester_FollowUpCode9] [char](1) NULL, [SubscriberName] [varchar](35) NULL, [SubscriberFirstName] [varchar](25) NULL, [SubscriberMiddleName] [varchar](10) NULL, [SubscriberSuffix] [varchar](10) NULL, [SubscriberIDQual] [char](2) NULL, [SubscriberID] [varchar](30) NULL, [SubscriberOtherIDQual1] [varchar](3) NULL, [SubscriberOtherID1] [varchar](30) NULL, [SubscriberOtherIDQual2] [varchar](3) NULL, [SubscriberOtherID2] [varchar](30) NULL, [SubscriberOtherIDQual3] [varchar](3) NULL, [SubscriberOtherID3] [varchar](30) NULL, [SubscriberAddress1] [varchar](55) NULL, [SubscriberAddress2] [varchar](55) NULL, [SubscriberCity] [varchar](30) NULL, [SubscriberState] [char](2) NULL, [SubscriberZip] [varchar](15) NULL, [SubscriberCountry] [varchar](3) NULL, [SubscriberSubdivision] [varchar](3) NULL, [SubscriberSex] [char](2) NULL, [SubscriberBirthDate] [date] NULL, [SubscriberRelationship] [char](2) NULL, [SubscriberEmploymentStatus] [char](2) NULL, [Subscriber_RejectReason1] [char](2) NULL, [Subscriber_FollowUpCode1] [char](1) NULL, [Subscriber_RejectReason2] [char](2) NULL, [Subscriber_FollowUpCode2] [char](1) NULL, --[Subscriber_RejectReason3] [char](2) NULL, --[Subscriber_FollowUpCode3] [char](1) NULL, --[Subscriber_RejectReason4] [char](2) NULL, --[Subscriber_FollowUpCode4] [char](1) NULL, --[Subscriber_RejectReason5] [char](2) NULL, --[Subscriber_FollowUpCode5] [char](1) NULL, --[Subscriber_RejectReason6] [char](2) NULL, --[Subscriber_FollowUpCode6] [char](1) NULL, --[Subscriber_RejectReason7] [char](2) NULL, --[Subscriber_FollowUpCode7] [char](1) NULL, --[Subscriber_RejectReason8] [char](2) NULL, --[Subscriber_FollowUpCode8] [char](1) NULL, --[Subscriber_RejectReason9] [char](2) NULL, --[Subscriber_FollowUpCode9] [char](1) NULL, [DependentRelationship] [char](2) NULL, [DependentBirthOrder] [int] NULL, [DependentName] [varchar](35) NULL, [DependentFirstName] [varchar](25) NULL, [DependentMiddleName] [varchar](10) NULL, [DependentSuffix] [varchar](10) NULL, [DependentIDQual] [char](2) NULL, [DependentID] [varchar](30) NULL, [DependentOtherIDQual1] [varchar](3) NULL, [DependentOtherID1] [varchar](30) NULL, [DependentOtherIDQual2] [varchar](3) NULL, [DependentOtherID2] [varchar](30) NULL, [DependentOtherIDQual3] [varchar](3) NULL, [DependentOtherID3] [varchar](30) NULL, [DependentAddress1] [varchar](55) NULL, [DependentAddress2] [varchar](55) NULL, [DependentCity] [varchar](30) NULL, [DependentState] [char](2) NULL, [DependentZip] [varchar](15) NULL, [DependentCountry] [varchar](3) NULL, [DependentSubdivision] [varchar](3) NULL, [DependentSex] [char](2) NULL, [DependentBirthDate] [date] NULL, [Dependent_RejectReason1] [char](2) NULL, [Dependent_FollowUpCode1] [char](1) NULL, [Dependent_RejectReason2] [char](2) NULL, [Dependent_FollowUpCode2] [char](1) NULL, --[Dependent_RejectReason3] [char](2) NULL, --[Dependent_FollowUpCode3] [char](1) NULL, --[Dependent_RejectReason4] [char](2) NULL, --[Dependent_FollowUpCode4] [char](1) NULL, --[Dependent_RejectReason5] [char](2) NULL, --[Dependent_FollowUpCode5] [char](1) NULL, --[Dependent_RejectReason6] [char](2) NULL, --[Dependent_FollowUpCode6] [char](1) NULL, --[Dependent_RejectReason7] [char](2) NULL, --[Dependent_FollowUpCode7] [char](1) NULL, --[Dependent_RejectReason8] [char](2) NULL, --[Dependent_FollowUpCode8] [char](1) NULL, --[Dependent_RejectReason9] [char](2) NULL, --[Dependent_FollowUpCode9] [char](1) NULL, /*TRN*/ [TraceOriginator] [varchar](30) NULL, [TraceID] [varchar](30) NULL, [TraceReference] [varchar](30) NULL, /****RESPONSE****/ [ResponseType] [char](2) NULL, [CertificationAction] [char](2) NULL, [CertificationNumber] [varchar](50) NULL, [DecisionReason] [varchar](30) NULL, [SecondSurgicalOpinion] [char](1) NULL, [IssueDate] [date] NULL, [ExpirationDate] [date] NULL, [EffectiveDate] [date] NULL, [EffectiveEndDate] [date] NULL, [ReferenceNumber] [varchar](50) NULL, [Patient_RejectReason1] [char](2) NULL, [Patient_FollowUpCode1] [char](1) NULL, [Patient_RejectReason2] [char](2) NULL, [Patient_FollowUpCode2] [char](1) NULL, --[Patient_RejectReason3] [char](2) NULL, --[Patient_FollowUpCode3] [char](1) NULL, --[Patient_RejectReason4] [char](2) NULL, --[Patient_FollowUpCode4] [char](1) NULL, --[Patient_RejectReason5] [char](2) NULL, --[Patient_FollowUpCode5] [char](1) NULL, --[Patient_RejectReason6] [char](2) NULL, --[Patient_FollowUpCode6] [char](1) NULL, --[Patient_RejectReason7] [char](2) NULL, --[Patient_FollowUpCode7] [char](1) NULL, --[Patient_RejectReason8] [char](2) NULL, --[Patient_FollowUpCode8] [char](1) NULL, --[Patient_RejectReason9] [char](2) NULL, --[Patient_FollowUpCode9] [char](1) NULL, [LOINC_Code1] [varchar](10) NULL, [LOINC_Code2] [varchar](10) NULL, [LOINC_Code3] [varchar](10) NULL, [LOINC_Code4] [varchar](10) NULL, [LOINC_Code5] [varchar](10) NULL, [LOINC_Code6] [varchar](10) NULL, [LOINC_Code7] [varchar](10) NULL, [LOINC_Code8] [varchar](10) NULL, [LOINC_Code9] [varchar](10) NULL, [LOINC_Code10] [varchar](10) NULL, [LOINC_Code11] [varchar](10) NULL, [LOINC_Code12] [varchar](10) NULL, [ResponseFileName] [varchar](100) NULL, [ResponseUser] [varchar](40) NULL, [ResponseFileDate] [date] NULL, [ResponseFileTime] [char](10) NULL, /*UM*/ [RequestCategory] [char](2) NULL, [CertificationType] [char](1) NULL, [ServiceType] [varchar](2) NULL, [FacilityType] [varchar](2) NULL, [FacilityCode] [varchar](2) NULL, [RelatedCause1] [varchar](3) NULL, [RelatedCause2] [varchar](3) NULL, [RelatedCause3] [varchar](3) NULL, [AccidentState] [char](2) NULL, [AccidentCountry] [varchar](3) NULL, [ServiceLevel] [varchar](3) NULL, [ConditionCode] [char](1) NULL, [PrognosisCode] [char](1) NULL, [ReleaseOfInformationCode] [char](1) NULL, [DelayReasonCode] [varchar](2) NULL, /*REF*/ [PreviousCertification] [varchar](30) NULL, [PreviousAdminCertification] [varchar](30) NULL, /*DTP*/ [AccidentDate] [date] NULL, [LastMenstrualDate] [date] NULL, [EstimatedDateofBirth] [date] NULL, [OnsetDate] [date] NULL, [EventDate] [date] NULL, [AdmissionDate] [date] NULL, [DischargeDate] [date] NULL, /*HI Diagnosis*/ [AdmitDiagnosisCodeType] [char](3) NULL, [AdmitDiagnosisCode] [varchar](35) NULL, [AdmitDiagnosisDate] [date] NULL, [PrincipalDiagnosisCodeType] [char](3) NULL, [PrincipalDiagnosisCode] [varchar](35) NULL, [PrincipalDiagnosisDate] [date] NULL, [ReasonForVisitCodeType] [char](3) NULL, [ReasonForVisitCode] [varchar](35) NULL, [ReasonForVisitDate] [date] NULL, [DRGCodeType] [char](3) NULL, [DRGCode] [varchar](35) NULL, [DRGDate] [date] NULL, [DiagnosisCodeType1] [char](3) NULL, [DiagnosisCode1] [varchar](35) NULL, [DiagnosisDate1] [date] NULL, [DiagnosisCodeType2] [char](3) NULL, [DiagnosisCode2] [varchar](35) NULL, [DiagnosisDate2] [date] NULL, [DiagnosisCodeType3] [char](3) NULL, [DiagnosisCode3] [varchar](35) NULL, [DiagnosisDate3] [date] NULL, [DiagnosisCodeType4] [char](3) NULL, [DiagnosisCode4] [varchar](35) NULL, [DiagnosisDate4] [date] NULL, [DiagnosisCodeType5] [char](3) NULL, [DiagnosisCode5] [varchar](35) NULL, [DiagnosisDate5] [date] NULL, [DiagnosisCodeType6] [char](3) NULL, [DiagnosisCode6] [varchar](35) NULL, [DiagnosisDate6] [date] NULL, [DiagnosisCodeType7] [char](3) NULL, [DiagnosisCode7] [varchar](35) NULL, [DiagnosisDate7] [date] NULL, [DiagnosisCodeType8] [char](3) NULL, [DiagnosisCode8] [varchar](35) NULL, [DiagnosisDate8] [date] NULL, [DiagnosisCodeType9] [char](3) NULL, [DiagnosisCode9] [varchar](35) NULL, [DiagnosisDate9] [date] NULL, /*HSD*/ [HSDQuantityQualifier] [char](2) NULL, [HSDQuantity] [bigint] NULL, [HSDUnitCode] [char](2) NULL, [HSDSampleModulus] [varchar](6) NULL, [HSDTimePeriodQualifier] [varchar](2) NULL, [HSDPeriodCount] [int] NULL, [HSDServicePatternCode] [varchar](2) NULL, [HSDTimePatternCode] [char](1) NULL, /*CRC*/ [ConditionCodeCategory1] [char](2) NULL, [ConditionCodeIndicator1] [char](1) NULL, [ConditionCode1_1] [char](2) NULL, [ConditionCode1_2] [char](2) NULL, [ConditionCode1_3] [char](2) NULL, [ConditionCode1_4] [char](2) NULL, [ConditionCode1_5] [char](2) NULL, [ConditionCodeCategory2] [char](2) NULL, [ConditionCodeIndicator2] [char](1) NULL, [ConditionCode2_1] [char](2) NULL, [ConditionCode2_2] [char](2) NULL, [ConditionCode2_3] [char](2) NULL, [ConditionCode2_4] [char](2) NULL, [ConditionCode2_5] [char](2) NULL, /*CL1*/ [AdmissionTypeCode] [char](1) NULL, [AdmissionSourceCode] [char](1) NULL, [PatientStatus] [varchar](2) NULL, [NursingHomeStatus] [char](1) NULL, /*CR1 Ambulance Certification*/ [WeightUnit] [char](2) NULL, [PatientWeight] [numeric](18, 2) NULL, [AmbulanceTransport] [char](1) NULL, [AmbulanceReason] [char](1) NULL, [DistanceUnit] [char](2) NULL, [TransportDistance] [numeric](18, 2) NULL, [TransportFrom] [varchar](55) NULL, [TransportTo] [varchar](55) NULL, [TripPurposeDescription] [varchar](80) NULL, [StretcherPurposeDescription] [varchar](80) NULL, /*CR2 Chiropractic Care*/ [TreatmentSeries] [varchar](9) NULL, [TreatmentCount] [bigint] NULL, [SubluxationCode1] [varchar](3) NULL, [SubluxationCode2] [varchar](3) NULL, [TreatmentPeriodUnit] [char](2) NULL, [TreatmentPeriodCount] [bigint] NULL, [TreatmentMonthlyCount] [bigint] NULL, [TreatmentCondition] [char](1) NULL, [TreatmentComplication] [char](1) NULL, [TreatmentDescription] [varchar](80) NULL, [TreatmentDescription2] [varchar](80) NULL, [TreatmentXRayAvailable] [char](1) NULL, /*CR5 Home Oxygen*/ [OxygenEquipment1] [char](1) NULL, [OxygenEquipment2] [char](1) NULL, [EqipmentReason] [varchar](80) NULL, [OxygenFlowRate] [bigint] NULL, [DailyUseCount] [bigint] NULL, [HourlyUseCount] [bigint] NULL, [RespiratoryTherapistOrder] [varchar](80) NULL, [ArterialBloodGasQty] [bigint] NULL, [OxygenSaturationQty] [bigint] NULL, [OxygenTestCondition] [char](1) NULL, [OxygenTestFindings1] [char](1) NULL, [OxygenTestFindings2] [char](1) NULL, [OxygenTestFindings3] [char](1) NULL, [PortableOxygenFlowRate] [bigint] NULL, [OxygenDeliverySystem] [char](1) NULL, [OxygenEqipmentType] [char](1) NULL, /*CR6 Home Health*/ [PrognosisCode1] [char](1) NULL, [HomeHealthStartDate] [date] NULL, [HomeHealthCertificationFrom] [date] NULL, [HomeHealthCertificationTo] [date] NULL, [SkilledNursingIndication] [char](1) NULL, [MedicareCoverageIndicator] [char](1) NULL, [HomeHealthCertificationType] [char](1) NULL, [HomeHealthRelatedSurgeryDate] [date] NULL, [HomeHealthRelatedSurgeryQual] [char](2) NULL, [HomeHealthRelatedSurgeryCode] [varchar](15) NULL, [HomeHealthPhysicianOrderDate] [date] NULL, [HomeHealthLastVisitDate] [date] NULL, [HomeHealthPhysicianContactDate] [date] NULL, [HomeHealthLastAdmissionFrom] [date] NULL, [HomeHealthLastAdmissionTo] [date] NULL, [HomeHealthFacilityType] [char](1) NULL, /*PWK*/ [ReportType1] [varchar](2) NULL, [ReportTransmCode1] [varchar](2) NULL, [ReportID1] [varchar](80) NULL, [ReportDescription1] [varchar](80) NULL, [ReportType2] [varchar](2) NULL, [ReportTransmCode2] [varchar](2) NULL, [ReportID2] [varchar](80) NULL, [ReportDescription2] [varchar](80) NULL, [ReportType3] [varchar](2) NULL, [ReportTransmCode3] [varchar](2) NULL, [ReportID3] [varchar](80) NULL, [ReportDescription3] [varchar](80) NULL, [ResponseReportType1] [varchar](2) NULL, [ResponseReportTransmCode1] [varchar](2) NULL, [ResponseReportID1] [varchar](80) NULL, [ResponseReportDescription1] [varchar](80) NULL, [ResponseReportType2] [varchar](2) NULL, [ResponseReportTransmCode2] [varchar](2) NULL, [ResponseReportID2] [varchar](80) NULL, [ResponseReportDescription2] [varchar](80) NULL, [ResponseReportType3] [varchar](2) NULL, [ResponseReportTransmCode3] [varchar](2) NULL, [ResponseReportID3] [varchar](80) NULL, [ResponseReportDescription3] [varchar](80) NULL, /*MSG*/ [Message] [varchar](264) NULL, /*Provider 1*/ [Provider1EntityID] [char](2) NULL, [Provider1Name] [varchar](60) NULL, [Provider1FirstName] [varchar](35) NULL, [Provider1MiddleName] [varchar](25) NULL, [Provider1Suffix] [varchar](10) NULL, [Provider1IDQual] [char](2) NULL, [Provider1ID] [varchar](30) NULL, [Provider1OtherIDQual1] [varchar](3) NULL, [Provider1OtherID1] [varchar](30) NULL, [Provider1OtherIDDesc1] [varchar](80) NULL, [Provider1OtherIDQual2] [varchar](3) NULL, [Provider1OtherID2] [varchar](30) NULL, [Provider1OtherIDDesc2] [varchar](80) NULL, [Provider1OtherIDQual3] [varchar](3) NULL, [Provider1OtherID3] [varchar](30) NULL, [Provider1OtherIDDesc3] [varchar](80) NULL, [Provider1Address1] [varchar](55) NULL, [Provider1Address2] [varchar](55) NULL, [Provider1City] [varchar](25) NULL, [Provider1State] [char](2) NULL, [Provider1Zip] [varchar](10) NULL, [Provider1Contact] [varchar](60) NULL, [Provider1Telefone] [varchar](20) NULL, [Provider1Extension] [varchar](10) NULL, [Provider1Fax] [varchar](20) NULL, [Provider1Email] [varchar](60) NULL, [Provider1URL] [varchar](100) NULL, [Provider1TypeCode] [char](2) NULL, [Provider1Taxonomy] [varchar](30) NULL, [Provider1_RejectReason1] [char](2) NULL, [Provider1_FollowUpCode1] [char](1) NULL, [Provider1_RejectReason2] [char](2) NULL, [Provider1_FollowUpCode2] [char](1) NULL, --[Provider1_RejectReason3] [char](2) NULL, --[Provider1_FollowUpCode3] [char](1) NULL, --[Provider1_RejectReason4] [char](2) NULL, --[Provider1_FollowUpCode4] [char](1) NULL, --[Provider1_RejectReason5] [char](2) NULL, --[Provider1_FollowUpCode5] [char](1) NULL, --[Provider1_RejectReason6] [char](2) NULL, --[Provider1_FollowUpCode6] [char](1) NULL, --[Provider1_RejectReason7] [char](2) NULL, --[Provider1_FollowUpCode7] [char](1) NULL, --[Provider1_RejectReason8] [char](2) NULL, --[Provider1_FollowUpCode8] [char](1) NULL, --[Provider1_RejectReason9] [char](2) NULL, --[Provider1_FollowUpCode9] [char](1) NULL, /*Provider 2*/ [Provider2EntityID] [char](2) NULL, [Provider2Name] [varchar](60) NULL, [Provider2FirstName] [varchar](35) NULL, [Provider2MiddleName] [varchar](25) NULL, [Provider2Suffix] [varchar](10) NULL, [Provider2IDQual] [char](2) NULL, [Provider2ID] [varchar](30) NULL, [Provider2OtherIDQual1] [varchar](3) NULL, [Provider2OtherID1] [varchar](30) NULL, [Provider2OtherIDDesc1] [varchar](80) NULL, [Provider2OtherIDQual2] [varchar](3) NULL, [Provider2OtherID2] [varchar](30) NULL, [Provider2OtherIDDesc2] [varchar](80) NULL, [Provider2OtherIDQual3] [varchar](3) NULL, [Provider2OtherID3] [varchar](30) NULL, [Provider2OtherIDDesc3] [varchar](80) NULL, [Provider2Address1] [varchar](55) NULL, [Provider2Address2] [varchar](55) NULL, [Provider2City] [varchar](25) NULL, [Provider2State] [char](2) NULL, [Provider2Zip] [varchar](10) NULL, [Provider2Contact] [varchar](60) NULL, [Provider2Telefone] [varchar](20) NULL, [Provider2Extension] [varchar](10) NULL, [Provider2Fax] [varchar](20) NULL, [Provider2Email] [varchar](60) NULL, [Provider2URL] [varchar](100) NULL, [Provider2TypeCode] [char](2) NULL, [Provider2Taxonomy] [varchar](30) NULL, [Provider2_RejectReason1] [char](2) NULL, [Provider2_FollowUpCode1] [char](1) NULL, [Provider2_RejectReason2] [char](2) NULL, [Provider2_FollowUpCode2] [char](1) NULL, --[Provider2_RejectReason3] [char](2) NULL, --[Provider2_FollowUpCode3] [char](1) NULL, --[Provider2_RejectReason4] [char](2) NULL, --[Provider2_FollowUpCode4] [char](1) NULL, --[Provider2_RejectReason5] [char](2) NULL, --[Provider2_FollowUpCode5] [char](1) NULL, --[Provider2_RejectReason6] [char](2) NULL, --[Provider2_FollowUpCode6] [char](1) NULL, --[Provider2_RejectReason7] [char](2) NULL, --[Provider2_FollowUpCode7] [char](1) NULL, --[Provider2_RejectReason8] [char](2) NULL, --[Provider2_FollowUpCode8] [char](1) NULL, --[Provider2_RejectReason9] [char](2) NULL, --[Provider2_FollowUpCode9] [char](1) NULL, /*Provider 3*/ [Provider3EntityID] [char](2) NULL, [Provider3Name] [varchar](60) NULL, [Provider3FirstName] [varchar](35) NULL, [Provider3MiddleName] [varchar](25) NULL, [Provider3Suffix] [varchar](10) NULL, [Provider3IDQual] [char](2) NULL, [Provider3ID] [varchar](30) NULL, [Provider3OtherIDQual1] [varchar](3) NULL, [Provider3OtherID1] [varchar](30) NULL, [Provider3OtherIDDesc1] [varchar](80) NULL, [Provider3OtherIDQual2] [varchar](3) NULL, [Provider3OtherID2] [varchar](30) NULL, [Provider3OtherIDDesc2] [varchar](80) NULL, [Provider3OtherIDQual3] [varchar](3) NULL, [Provider3OtherID3] [varchar](30) NULL, [Provider3OtherIDDesc3] [varchar](80) NULL, [Provider3Address1] [varchar](55) NULL, [Provider3Address2] [varchar](55) NULL, [Provider3City] [varchar](25) NULL, [Provider3State] [char](2) NULL, [Provider3Zip] [varchar](10) NULL, [Provider3Contact] [varchar](60) NULL, [Provider3Telefone] [varchar](20) NULL, [Provider3Extension] [varchar](10) NULL, [Provider3Fax] [varchar](20) NULL, [Provider3Email] [varchar](60) NULL, [Provider3URL] [varchar](100) NULL, [Provider3TypeCode] [char](2) NULL, [Provider3Taxonomy] [varchar](30) NULL, [Provider3_RejectReason1] [char](2) NULL, [Provider3_FollowUpCode1] [char](1) NULL, [Provider3_RejectReason2] [char](2) NULL, [Provider3_FollowUpCode2] [char](1) NULL, --[Provider3_RejectReason3] [char](2) NULL, --[Provider3_FollowUpCode3] [char](1) NULL, --[Provider3_RejectReason4] [char](2) NULL, --[Provider3_FollowUpCode4] [char](1) NULL, --[Provider3_RejectReason5] [char](2) NULL, --[Provider3_FollowUpCode5] [char](1) NULL, --[Provider3_RejectReason6] [char](2) NULL, --[Provider3_FollowUpCode6] [char](1) NULL, --[Provider3_RejectReason7] [char](2) NULL, --[Provider3_FollowUpCode7] [char](1) NULL, --[Provider3_RejectReason8] [char](2) NULL, --[Provider3_FollowUpCode8] [char](1) NULL, --[Provider3_RejectReason9] [char](2) NULL, --[Provider3_FollowUpCode9] [char](1) NULL, /*Other UMO 1*/ [OtherUMO1EntityID] [char](2) NULL, [OtherUMO1Name] [varchar](35) NULL, [OtherUMO1DenialReason] [varchar](50) NULL, [OtherUMO1AddDenialReason1] [varchar](50) NULL, [OtherUMO1AddDenialReason2] [varchar](50) NULL, [OtherUMO1AddDenialReason3] [varchar](50) NULL, [OtherUMO1DenialDate] [date] NULL, /*Other UMO 2*/ [OtherUMO2EntityID] [char](2) NULL, [OtherUMO2Name] [varchar](35) NULL, [OtherUMO2DenialReason] [varchar](50) NULL, [OtherUMO2AddDenialReason1] [varchar](50) NULL, [OtherUMO2AddDenialReason2] [varchar](50) NULL, [OtherUMO2AddDenialReason3] [varchar](50) NULL, [OtherUMO2DenialDate] [date] NULL, /*Other UMO 3*/ [OtherUMO3EntityID] [char](2) NULL, [OtherUMO3Name] [varchar](35) NULL, [OtherUMO3DenialReason] [varchar](50) NULL, [OtherUMO3AddDenialReason1] [varchar](50) NULL, [OtherUMO3AddDenialReason2] [varchar](50) NULL, [OtherUMO3AddDenialReason3] [varchar](50) NULL, [OtherUMO3DenialDate] [date] NULL, /*Additional Patient Info Contact*/ [ContactName] [varchar](60) NULL, [ContactFirstName] [varchar](35) NULL, [ContactMiddleName] [varchar](25) NULL, [ContactSuffix] [varchar](10) NULL, [ContactIDQual] [char](2) NULL, [ContactID] [varchar](30) NULL, [ContactAddress1] [varchar](55) NULL, [ContactAddress2] [varchar](55) NULL, [ContactCity] [varchar](25) NULL, [ContactState] [char](2) NULL, [ContactZip] [varchar](10) NULL, [Contact] [varchar](60) NULL, [ContactPhone] [varchar](20) NULL, [ContactExtension] [varchar](10) NULL, [ContactFax] [varchar](20) NULL, [ContactEmail] [varchar](60) NULL, CONSTRAINT [PK_edi_AuthorizerHeader] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]
CREATE TABLE [edi_AuthorizerDetails]( [DetailId] [bigint] IDENTITY(1,1) NOT NULL, [HeaderId] [bigint] NULL, /*TRN*/ [TraceOriginator] [varchar](30) NULL, [TraceID] [varchar](30) NULL, [TraceReference] [varchar](30) NULL, /*UM*/ [RequestCategory] [char](2) NULL, [CertificationType] [char](1) NULL, [ServiceType] [varchar](2) NULL, [FacilityType] [varchar](2) NULL, [BillType] [char](1) NULL, /*REF*/ [PreviousCertification] [varchar](30) NULL, [PreviousAdminCertification] [varchar](30) NULL, /*DTP*/ [ServiceDate] [date] NULL, [ServiceEndDate] [date] NULL, /****RESPONSE****/ [CertificationAction] [char](2) NULL, [CertificationNumber] [varchar](50) NULL, [DecisionReason] [varchar](30) NULL, [SecondSurgicalOpinion] [char](1) NULL, [IssueDate] [date] NULL, [ExpirationDate] [date] NULL, [EffectiveDate] [date] NULL, [EffectiveEndDate] [date] NULL, [ReferenceNumber] [varchar](50) NULL, [RejectReason1] [char](2) NULL, [FollowUpCode1] [char](1) NULL, [RejectReason2] [char](2) NULL, [FollowUpCode2] [char](1) NULL, --[RejectReason3] [char](2) NULL, --[FollowUpCode3] [char](1) NULL, --[RejectReason4] [char](2) NULL, --[FollowUpCode4] [char](1) NULL, --[RejectReason5] [char](2) NULL, --[FollowUpCode5] [char](1) NULL, --[RejectReason6] [char](2) NULL, --[FollowUpCode6] [char](1) NULL, --[RejectReason7] [char](2) NULL, --[FollowUpCode7] [char](1) NULL, --[RejectReason8] [char](2) NULL, --[FollowUpCode8] [char](1) NULL, --[RejectReason9] [char](2) NULL, --[FollowUpCode9] [char](1) NULL, [LOINC_Code1] [varchar](10) NULL, [LOINC_Code2] [varchar](10) NULL, [LOINC_Code3] [varchar](10) NULL, [LOINC_Code4] [varchar](10) NULL, [LOINC_Code5] [varchar](10) NULL, [LOINC_Code6] [varchar](10) NULL, [LOINC_Code7] [varchar](10) NULL, [LOINC_Code8] [varchar](10) NULL, [LOINC_Code9] [varchar](10) NULL, [LOINC_Code10] [varchar](10) NULL, [LOINC_Code11] [varchar](10) NULL, [LOINC_Code12] [varchar](10) NULL, /*SVx*/ [ClaimType] [char](1) NULL, [RevenueCode] [varchar](15) NULL, [ProcedureCodeType] [varchar](2) NULL, [ProcedureCode] [varchar](15) NULL, [Modifier1] [char](3) NULL, [Modifier2] [char](3) NULL, [Modifier3] [char](3) NULL, [Modifier4] [char](3) NULL, [ProcedureDescription] [varchar](80) NULL, [Amount] [decimal](8,2) NULL, [Unit] [char](2) NULL, [Quantity] [varchar](15) NULL, [UnitRate] [varchar](10) NULL, [DiagPointer1] [char](2) NULL, [DiagPointer2] [char](2) NULL, [DiagPointer3] [char](2) NULL, [DiagPointer4] [char](2) NULL, [OralCavityDesignation1] [char](1) NULL, [OralCavityDesignation2] [char](1) NULL, [OralCavityDesignation3] [char](1) NULL, [OralCavityDesignation4] [char](1) NULL, [OralCavityDesignation5] [char](1) NULL, [PCI_Code] [char](1) NULL, [ReasonForPlacement] [varchar](80) NULL, [ToothNumber] [varchar](96) NULL, [Surface] [varchar](512) NULL, [EPSDT] [char](1) NULL, [NursingHomeStatus] [char](1) NULL, [CareLevel] [char](2) NULL, /*HSD*/ [HSDQuantityQualifier] [char](2) NULL, [HSDQuantity] [bigint] NULL, [HSDUnitCode] [char](2) NULL, [HSDSampleModulus] [varchar](6) NULL, [HSDTimePeriodQualifier] [varchar](2) NULL, [HSDPeriodCount] [int] NULL, [HSDServicePatternCode] [varchar](2) NULL, [HSDTimePatternCode] [char](1) NULL, /*PWK*/ [ReportType1] [varchar](2) NULL, [ReportTransmCode1] [varchar](2) NULL, [ReportID1] [varchar](80) NULL, [ReportDescription1] [varchar](80) NULL, [ReportType2] [varchar](2) NULL, [ReportTransmCode2] [varchar](2) NULL, [ReportID2] [varchar](80) NULL, [ReportDescription2] [varchar](80) NULL, [ReportType3] [varchar](2) NULL, [ReportTransmCode3] [varchar](2) NULL, [ReportID3] [varchar](80) NULL, [ReportDescription3] [varchar](80) NULL, [ResponseReportType1] [varchar](2) NULL, [ResponseReportTransmCode1] [varchar](2) NULL, [ResponseReportID1] [varchar](80) NULL, [ResponseReportDescription1] [varchar](80) NULL, [ResponseReportType2] [varchar](2) NULL, [ResponseReportTransmCode2] [varchar](2) NULL, [ResponseReportID2] [varchar](80) NULL, [ResponseReportDescription2] [varchar](80) NULL, [ResponseReportType3] [varchar](2) NULL, [ResponseReportTransmCode3] [varchar](2) NULL, [ResponseReportID3] [varchar](80) NULL, [ResponseReportDescription3] [varchar](80) NULL, /*MSG*/ [Message] [varchar](264) NULL, /*Provider 1*/ [Provider1EntityID] [char](2) NULL, [Provider1Name] [varchar](35) NULL, [Provider1FirstName] [varchar](25) NULL, [Provider1MiddleName] [varchar](10) NULL, [Provider1Suffix] [varchar](10) NULL, [Provider1IDQual] [char](2) NULL, [Provider1ID] [varchar](30) NULL, [Provider1OtherIDQual1] [varchar](3) NULL, [Provider1OtherID1] [varchar](30) NULL, [Provider1OtherIDDesc1] [varchar](80) NULL, [Provider1OtherIDQual2] [varchar](3) NULL, [Provider1OtherID2] [varchar](30) NULL, [Provider1OtherIDDesc2] [varchar](80) NULL, [Provider1OtherIDQual3] [varchar](3) NULL, [Provider1OtherID3] [varchar](30) NULL, [Provider1OtherIDDesc3] [varchar](80) NULL, [Provider1Address1] [varchar](30) NULL, [Provider1Address2] [varchar](30) NULL, [Provider1City] [varchar](25) NULL, [Provider1State] [char](2) NULL, [Provider1Zip] [varchar](10) NULL, [Provider1Contact] [varchar](60) NULL, [Provider1Telefone] [varchar](20) NULL, [Provider1Extension] [varchar](10) NULL, [Provider1Fax] [varchar](20) NULL, [Provider1Email] [varchar](60) NULL, [Provider1URL] [varchar](100) NULL, [Provider1TypeCode] [char](2) NULL, [Provider1Taxonomy] [varchar](30) NULL, [Provider1_RejectReason1] [char](2) NULL, [Provider1_FollowUpCode1] [char](1) NULL, [Provider1_RejectReason2] [char](2) NULL, [Provider1_FollowUpCode2] [char](1) NULL, --[Provider1_RejectReason3] [char](2) NULL, --[Provider1_FollowUpCode3] [char](1) NULL, --[Provider1_RejectReason4] [char](2) NULL, --[Provider1_FollowUpCode4] [char](1) NULL, --[Provider1_RejectReason5] [char](2) NULL, --[Provider1_FollowUpCode5] [char](1) NULL, --[Provider1_RejectReason6] [char](2) NULL, --[Provider1_FollowUpCode6] [char](1) NULL, --[Provider1_RejectReason7] [char](2) NULL, --[Provider1_FollowUpCode7] [char](1) NULL, --[Provider1_RejectReason8] [char](2) NULL, --[Provider1_FollowUpCode8] [char](1) NULL, --[Provider1_RejectReason9] [char](2) NULL, --[Provider1_FollowUpCode9] [char](1) NULL, /*Provider 2*/ [Provider2EntityID] [char](2) NULL, [Provider2Name] [varchar](35) NULL, [Provider2FirstName] [varchar](25) NULL, [Provider2MiddleName] [varchar](10) NULL, [Provider2Suffix] [varchar](10) NULL, [Provider2IDQual] [char](2) NULL, [Provider2ID] [varchar](30) NULL, [Provider2OtherIDQual1] [varchar](3) NULL, [Provider2OtherID1] [varchar](30) NULL, [Provider2OtherIDDesc1] [varchar](80) NULL, [Provider2OtherIDQual2] [varchar](3) NULL, [Provider2OtherID2] [varchar](30) NULL, [Provider2OtherIDDesc2] [varchar](80) NULL, [Provider2OtherIDQual3] [varchar](3) NULL, [Provider2OtherID3] [varchar](30) NULL, [Provider2OtherIDDesc3] [varchar](80) NULL, [Provider2Address1] [varchar](30) NULL, [Provider2Address2] [varchar](30) NULL, [Provider2City] [varchar](25) NULL, [Provider2State] [char](2) NULL, [Provider2Zip] [varchar](10) NULL, [Provider2Contact] [varchar](60) NULL, [Provider2Telefone] [varchar](20) NULL, [Provider2Extension] [varchar](10) NULL, [Provider2Fax] [varchar](20) NULL, [Provider2Email] [varchar](60) NULL, [Provider2URL] [varchar](100) NULL, [Provider2TypeCode] [char](2) NULL, [Provider2Taxonomy] [varchar](30) NULL, [Provider2_RejectReason1] [char](2) NULL, [Provider2_FollowUpCode1] [char](1) NULL, [Provider2_RejectReason2] [char](2) NULL, [Provider2_FollowUpCode2] [char](1) NULL, --[Provider2_RejectReason3] [char](2) NULL, --[Provider2_FollowUpCode3] [char](1) NULL, --[Provider2_RejectReason4] [char](2) NULL, --[Provider2_FollowUpCode4] [char](1) NULL, --[Provider2_RejectReason5] [char](2) NULL, --[Provider2_FollowUpCode5] [char](1) NULL, --[Provider2_RejectReason6] [char](2) NULL, --[Provider2_FollowUpCode6] [char](1) NULL, --[Provider2_RejectReason7] [char](2) NULL, --[Provider2_FollowUpCode7] [char](1) NULL, --[Provider2_RejectReason8] [char](2) NULL, --[Provider2_FollowUpCode8] [char](1) NULL, --[Provider2_RejectReason9] [char](2) NULL, --[Provider2_FollowUpCode9] [char](1) NULL, /*Provider 3*/ [Provider3EntityID] [char](2) NULL, [Provider3Name] [varchar](35) NULL, [Provider3FirstName] [varchar](25) NULL, [Provider3MiddleName] [varchar](10) NULL, [Provider3Suffix] [varchar](10) NULL, [Provider3IDQual] [char](2) NULL, [Provider3ID] [varchar](30) NULL, [Provider3OtherIDQual1] [varchar](3) NULL, [Provider3OtherID1] [varchar](30) NULL, [Provider3OtherIDDesc1] [varchar](80) NULL, [Provider3OtherIDQual2] [varchar](3) NULL, [Provider3OtherID2] [varchar](30) NULL, [Provider3OtherIDDesc2] [varchar](80) NULL, [Provider3OtherIDQual3] [varchar](3) NULL, [Provider3OtherID3] [varchar](30) NULL, [Provider3OtherIDDesc3] [varchar](80) NULL, [Provider3Address1] [varchar](30) NULL, [Provider3Address2] [varchar](30) NULL, [Provider3City] [varchar](25) NULL, [Provider3State] [char](2) NULL, [Provider3Zip] [varchar](10) NULL, [Provider3Contact] [varchar](60) NULL, [Provider3Telefone] [varchar](20) NULL, [Provider3Extension] [varchar](10) NULL, [Provider3Fax] [varchar](20) NULL, [Provider3Email] [varchar](60) NULL, [Provider3URL] [varchar](100) NULL, [Provider3TypeCode] [char](2) NULL, [Provider3Taxonomy] [varchar](30) NULL, [Provider3_RejectReason1] [char](2) NULL, [Provider3_FollowUpCode1] [char](1) NULL, [Provider3_RejectReason2] [char](2) NULL, [Provider3_FollowUpCode2] [char](1) NULL, --[Provider3_RejectReason3] [char](2) NULL, --[Provider3_FollowUpCode3] [char](1) NULL, --[Provider3_RejectReason4] [char](2) NULL, --[Provider3_FollowUpCode4] [char](1) NULL, --[Provider3_RejectReason5] [char](2) NULL, --[Provider3_FollowUpCode5] [char](1) NULL, --[Provider3_RejectReason6] [char](2) NULL, --[Provider3_FollowUpCode6] [char](1) NULL, --[Provider3_RejectReason7] [char](2) NULL, --[Provider3_FollowUpCode7] [char](1) NULL, --[Provider3_RejectReason8] [char](2) NULL, --[Provider3_FollowUpCode8] [char](1) NULL, --[Provider3_RejectReason9] [char](2) NULL, --[Provider3_FollowUpCode9] [char](1) NULL, /*Additional Patient Info Contact*/ [ContactName] [varchar](60) NULL, [ContactFirstName] [varchar](35) NULL, [ContactMiddleName] [varchar](25) NULL, [ContactSuffix] [varchar](10) NULL, [ContactIDQual] [char](2) NULL, [ContactID] [varchar](30) NULL, [ContactAddress1] [varchar](55) NULL, [ContactAddress2] [varchar](55) NULL, [ContactCity] [varchar](25) NULL, [ContactState] [char](2) NULL, [ContactZip] [varchar](10) NULL, [Contact] [varchar](60) NULL, [ContactPhone] [varchar](20) NULL, [ContactExtension] [varchar](10) NULL, [ContactFax] [varchar](20) NULL, [ContactEmail] [varchar](60) NULL, CONSTRAINT [PK_edi_AuthorizerDetails] PRIMARY KEY CLUSTERED ( [DetailId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]
|