SQL-004: Create operation¶
This document records the SQL used by Criteria in SAIF.Business.Claim.Bill.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-004 |
| Operation type | Create |
| Execution method | Inline |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | Criteria |
| Criteria property | InsertSQL |
| Lifecycle method | BeforeInsert |
Parameters¶
| Parameter | Direction | Type | Max length | Description |
|---|---|---|---|---|
:BillID |
Input | Number | N/A | Binds BillID from active calling code or Oracle signature. |
:AuditedServiceID |
Input | Number | N/A | Binds AuditedServiceID from active calling code or Oracle signature. |
:OriginalBillID |
Input | Number | N/A | Binds OriginalBillID from active calling code or Oracle signature. |
:OriginalAuditServiceID |
Input | Number | N/A | Binds OriginalAuditServiceID from active calling code or Oracle signature. |
:ServiceModifierCode1 |
Input | String | N/A | Binds ServiceModifierCode1 from active calling code or Oracle signature. |
:ServiceModifierCode2 |
Input | String | N/A | Binds ServiceModifierCode2 from active calling code or Oracle signature. |
:ServiceModifierCode3 |
Input | String | N/A | Binds ServiceModifierCode3 from active calling code or Oracle signature. |
:ServiceModifierCode4 |
Input | String | N/A | Binds ServiceModifierCode4 from active calling code or Oracle signature. |
:McoPlanID |
Input | Number | N/A | Binds McoPlanID from active calling code or Oracle signature. |
:McoGsaLocationID |
Input | Number | N/A | Binds McoGsaLocationID from active calling code or Oracle signature. |
:ServiceProviderLoactionID |
Input | Number | N/A | Binds ServiceProviderLoactionID from active calling code or Oracle signature. |
:PrescribingProviderLocatioNID |
Input | Number | N/A | Binds PrescribingProviderLocatioNID from active calling code or Oracle signature. |
:ServiceLocationCode |
Input | String | N/A | Binds ServiceLocationCode from active calling code or Oracle signature. |
:ChargeAmount |
Input | Number | N/A | Binds ChargeAmount from active calling code or Oracle signature. |
:ServiceQuantity |
Input | String | N/A | Binds ServiceQuantity from active calling code or Oracle signature. |
:AllowedAmount |
Input | Number | N/A | Binds AllowedAmount from active calling code or Oracle signature. |
:McoAdminFeeAmount |
Input | Number | N/A | Binds McoAdminFeeAmount from active calling code or Oracle signature. |
:MsrpInvoiceAmount |
Input | Number | N/A | Binds MsrpInvoiceAmount from active calling code or Oracle signature. |
:MsrpInvoiceCode |
Input | String | N/A | Binds MsrpInvoiceCode from active calling code or Oracle signature. |
:TotalAdjustmentAmount |
Input | Number | N/A | Binds TotalAdjustmentAmount from active calling code or Oracle signature. |
:ReauditCode |
Input | String | N/A | Binds ReauditCode from active calling code or Oracle signature. |
:OriginalBillCode |
Input | String | N/A | Binds OriginalBillCode from active calling code or Oracle signature. |
:BillPaymentCategoryCode |
Input | String | N/A | Binds BillPaymentCategoryCode from active calling code or Oracle signature. |
:McoEligibilityStatusCode |
Input | String | N/A | Binds McoEligibilityStatusCode from active calling code or Oracle signature. |
:ServiceDate |
Input | Date | N/A | Binds ServiceDate from active calling code or Oracle signature. |
:ServiceEndDate |
Input | Date | N/A | Binds ServiceEndDate from active calling code or Oracle signature. |
:BillServiceCode |
Input | String | N/A | Binds BillServiceCode from active calling code or Oracle signature. |
:BillServiceTypeCode |
Input | String | N/A | Binds BillServiceTypeCode from active calling code or Oracle signature. |
:BillServDescrEffDate |
Input | Date | N/A | Binds BillServDescrEffDate from active calling code or Oracle signature. |
:NationalDrugCode |
Input | String | N/A | Binds NationalDrugCode from active calling code or Oracle signature. |
:UpdateUser |
Input | Date | N/A | Binds UpdateUser from active calling code or Oracle signature. |
:UpdateNumber |
Input | Date | N/A | Binds UpdateNumber from active calling code or Oracle signature. |
:UpdateDate |
Input | Date | N/A | Binds UpdateDate from active calling code or Oracle signature. |
:FeeScheduleAmount |
Input | Number | N/A | Binds FeeScheduleAmount from active calling code or Oracle signature. |
:McoDiscountPlanID |
Input | Number | N/A | Binds McoDiscountPlanID from active calling code or Oracle signature. |
:McoAdminFeeRate |
Input | String | N/A | Binds McoAdminFeeRate from active calling code or Oracle signature. |
:SecondaryServiceCode |
Input | String | N/A | Binds SecondaryServiceCode from active calling code or Oracle signature. |
:DispenseASWrittenCode |
Input | String | N/A | Binds DispenseASWrittenCode from active calling code or Oracle signature. |
:DiagnosisPointerCode1 |
Input | String | N/A | Binds DiagnosisPointerCode1 from active calling code or Oracle signature. |
:DiagnosisPointerCode2 |
Input | String | N/A | Binds DiagnosisPointerCode2 from active calling code or Oracle signature. |
:DiagnosisPointerCode3 |
Input | String | N/A | Binds DiagnosisPointerCode3 from active calling code or Oracle signature. |
:DiagnosisPointerCode4 |
Input | String | N/A | Binds DiagnosisPointerCode4 from active calling code or Oracle signature. |
:SecondaryServiceTypeCode |
Input | String | N/A | Binds SecondaryServiceTypeCode from active calling code or Oracle signature. |
:PrescribingProviderID |
Input | Number | N/A | Binds PrescribingProviderID from active calling code or Oracle signature. |
:PrescribingProviderCode |
Input | Number | N/A | Binds PrescribingProviderCode from active calling code or Oracle signature. |
:PrescriberLastName |
Input | String | N/A | Binds PrescriberLastName from active calling code or Oracle signature. |
:PrescriberFirstName |
Input | String | N/A | Binds PrescriberFirstName from active calling code or Oracle signature. |
:PrescriptionWrittenDate |
Input | Date | N/A | Binds PrescriptionWrittenDate from active calling code or Oracle signature. |
:CompoundDrugFlag |
Input | String | N/A | Binds CompoundDrugFlag from active calling code or Oracle signature. |
:TaxChargedAmount |
Input | Number | N/A | Binds TaxChargedAmount from active calling code or Oracle signature. |
Tables¶
| Table | Access | Columns used |
|---|---|---|
| CBP_AUDITED_SERVICE | CREATE | A, ALLOWED_AMT, ASW, AUDIT_LINE_NUM, AUDIT_SEQ_NUM, B, BILL_ID, BILL_ORIG_CODE, BILL_PAYMENT_CATEGORY_CODE, BILL_SERVICE_CODE, BILL_SERVICE_TYPE_CODE, BILL_SERV_DESCR_EFF_DATE |
Sample SQL¶
Insert into CBP_AUDITED_SERVICE ( BILL_ID, AUDIT_SEQ_NUM, AUDIT_LINE_NUM, ORIG_BILL_ID, ORIG_AUDIT_SEQ_NUM, SERVICE_MODIFIER_CODE1, SERVICE_MODIFIER_CODE2, SERVICE_MODIFIER_CODE3, SERVICE_MODIFIER_CODE4, MCO_PLAN_ID, MCO_GSA_LOCATION_ID, SERV_PROVIDER_LOC_SEQ_NUM, PRESC_PROVIDER_LOC_SEQ_NUM, SERVICE_LOCATION_CODE, CHARGE_AMT, SERVICE_QUANTITY, ALLOWED_AMT, MCO_ADMIN_FEE_AMT, MSRP_INVOICE_AMT, MSRP_INVOICE_CODE, TOTAL_ADJUSTMENT_AMT, REAUDIT_CODE, BILL_ORIG_CODE, BILL_PAYMENT_CATEGORY_CODE, MCO_ELIGIBILITY_STATUS_CODE, SERVICE_DATE, SERVICE_END_DATE, BILL_SERVICE_CODE, BILL_SERVICE_TYPE_CODE, BILL_SERV_DESCR_EFF_DATE, NATIONAL_DRUG_CODE, UPDATE_USER, UPDATE_NUM, UPDATE_DATE, FEE_SCHEDULE_AMT, MCO_DISCOUNT_PLAN_ID, MCO_ADMIN_FEE_RATE, SECONDARY_CBP_SERVICE_CODE, DISPENSE_AS_WRITTEN_CODE, DIAGNOSIS_POINTER_CODE1, DIAGNOSIS_POINTER_CODE2, DIAGNOSIS_POINTER_CODE3, DIAGNOSIS_POINTER_CODE4, SECONDARY_SERVICE_TYPE_CODE, PRESCRIBING_PROVIDER_ID, PRESCRIBING_PROVIDER_CODE, PRESCRIBER_LAST_NAME, PRESCRIBER_FIRST_NAME, PRESCRIPTION_WRITTEN_DATE, COMPOUND_DRUG_FLAG, TAX_CHARGED_AMT )
VALUES ( :BillID, :AuditedServiceID, NULL, :OriginalBillID, :OriginalAuditServiceID, :ServiceModifierCode1, :ServiceModifierCode2, :ServiceModifierCode3, :ServiceModifierCode4, :McoPlanID, :McoGsaLocationID, :ServiceProviderLoactionID, :PrescribingProviderLocatioNID, :ServiceLocationCode, :ChargeAmount, :ServiceQuantity, :AllowedAmount, :McoAdminFeeAmount, :MsrpInvoiceAmount, :MsrpInvoiceCode, :TotalAdjustmentAmount, :ReauditCode, :OriginalBillCode, :BillPaymentCategoryCode, :McoEligibilityStatusCode, :ServiceDate, :ServiceEndDate, :BillServiceCode, :BillServiceTypeCode, :BillServDescrEffDate, :NationalDrugCode, :UpdateUser, :UpdateNumber, :UpdateDate, :FeeScheduleAmount, :McoDiscountPlanID, :McoAdminFeeRate, :SecondaryServiceCode, :DispenseASWrittenCode, :DiagnosisPointerCode1, :DiagnosisPointerCode2, :DiagnosisPointerCode3, :DiagnosisPointerCode4, :SecondaryServiceTypeCode, :PrescribingProviderID, :PrescribingProviderCode, :PrescriberLastName, :PrescriberFirstName, :PrescriptionWrittenDate, :CompoundDrugFlag, :TaxChargedAmount)
Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.
Sources¶
Business\SAIF.Business.Claim.Bill\Core\clsAuditedService.vb