SQL-001: clsNationalDrug¶

This statement supports clsNationalDrug by executing a Create operation through inline.

Classification¶

Field	Value
SQL ID	SQL-001
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsNationalDrug`
Criteria property	`InsertSQL`
Lifecycle method	`BeforeInsert`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:NationalDrugCode`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:EffDate`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:ExpDate`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:ActivityCode`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:PharmacyRouteCode`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:TherapyClassCode`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:GenericCode`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:BrandNameCode`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:IntExtCode`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:UnitDoseCode`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:LastChangeDate`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:ProductName`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:GenericNdcCode`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:GenericName`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:ManufacturerName`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:GppcCode`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:MetricStrengthAmt`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:MetricStrengthUnit`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:DoseFormCode`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:PackageSizeAmt`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:PackageUnitCode`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:PackageQuantity`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:TotalPackageAmount`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:DesiCode`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:PackageDescrCode`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:DisallowRecordCode`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:UpdateUser`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:UpdateNum`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.
`:UpdateDate`	Input	Unknown	—	Passed from clsNationalDrug via BeforeInsert.

Tables¶

Table	Access	Columns used
CBP_NATIONAL_DRUG	Create	Not enumerated directly in the stage findings.**

Sample SQL¶

Insert into CBP_NATIONAL_DRUG (
    NATIONAL_DRUG_CODE,
    EFF_DATE,
    EXP_DATE,
    ACTIVITY_CODE,
    PHARMACY_ROUTE_CODE,
    THERAPY_CLASS_CODE,
    GENERIC_CODE,
    BRAND_NAME_CODE,
    INT_EXT_CODE,
    UNIT_DOSE_CODE,
    LAST_CHANGE_DATE,
    PRODUCT_NAME,
    GENERIC_NDC_CODE,
    GENERIC_NAME,
    MANUFACTURER_NAME,
    GPPC_CODE,
    METRIC_STRENGTH_AMT,
    METRIC_STRENGTH_UNIT,
    DOSE_FORM_CODE,
    PACKAGE_SIZE_AMT,
    PACKAGE_UNIT_CODE,
    PACKAGE_QUANTITY,
    TOTAL_PACKAGE_AMOUNT,
    DESI_CODE,
    PACKAGE_DESCR_CODE,
    UPDATE_USER,
    UPDATE_NUM,
    UPDATE_DATE,
    DISALLOW_RECORD_CODE
) VALUES (
    :NationalDrugCode,
    :EffDate,
    :ExpDate,
    :ActivityCode,
    :PharmacyRouteCode,
    :TherapyClassCode,
    :GenericCode,
    :BrandNameCode,
    :IntExtCode,
    :UnitDoseCode,
    :LastChangeDate,
    :ProductName,
    :GenericNdcCode,
    :GenericName,
    :ManufacturerName,
    :GppcCode,
    :MetricStrengthAmt,
    :MetricStrengthUnit,
    :DoseFormCode,
    :PackageSizeAmt,
    :PackageUnitCode,
    :PackageQuantity,
    :TotalPackageAmount,
    :DesiCode,
    :PackageDescrCode,
    :UpdateUser,
    :UpdateNum,
    :UpdateDate,
    :DisallowRecordCode
)

Operations and processes¶

clsNationalDrug BeforeInsert

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.MedicalBill/clsNationalDrug.vb