Tx Database Data Dictionary - TransactionItems Table

COLUMN_NAME

DATA_TYPE

LENGTH

NULL

ABLE

DESCRIPTION

Id

bigint

NO

Unique ID for the record

Sequence

tinyint

NO

Not Used.

Compounds will share the same TransactionId as the collating value.

PriceSource

tinyint

YES

Price Source used to determine the Ingredient Cost for the Buy Side Pricing

See Price Source Values list at end of document.

NDC

nvarchar

11

NO

NDC Number

GPI

nvarchar

14

YES

GPI Number

MSC

nvarchar

1

YES

MONY Code for the individual item as defined by Medispan at the time of Processing.

See field MONY for the MONY code the item processed under.

DrugName

nvarchar

50

YES

Name of the Drug

MaintenanceCode

nvarchar

2

YES

0 = Non Maintenance

1 = Maintenance

UnitPrice

decimal

NO

The Unit Price of the ingredient after contractual related adjustments

AWP

decimal

YES

AWP Price at time of transaction.

AWPDiscount

decimal

YES

Not Used

MacDiscount

decimal

YES

Not Used

Mac

decimal

YES

MAC Price at time of transaction.

MACSource

nvarchar

8

YES

Location where the MAC was assigned to the claim, such as Network, Select, MAC1, MAC2, MAC3.

WacDiscount

decimal

YES

Not Used

Wac

decimal

YES

WAC Price at time of the transaction

UnitCost

decimal

YES

Not used. Value is a duplicate of UnitPrice.

TransactionId

bigint

NO

Transaction ID related to the TransactionItems record.

MacListId

int

YES

ID of the MAC List used during processing

FormularyId

int

YES

ID of the Formulary used on the transaction

FormularyName

nvarchar

MAX

YES

Related Formulary Name

AgeRuleId

int

YES

ID of Age Rule used during processing

AgeRuleName

nvarchar

128

YES

Name of Age Rule used during processing

AgeRuleRuleSource

tinyint

NO

Location where the Age Rule was found.

• Not Applicable = 0
• Plan = 1
• ProcessRule = 2

AgeRuleProcessRuleId

int

YES

Process Rule that assigned the Age Rule, if applicable.

DispenseLimitRuleId

int

YES

ID of Dispense Limit Rule used during processing

DispenseLimitName

nvarchar

128

YES

Name of Dispense Limit Rule used during processing

DispenseLimitRuleSource

tinyint

NO

Location where the Dispense Limit Rule was found.

• Not Applicable = 0
• Plan = 1
• ProcessRule = 2

DispenseLimitProcessRuleId

int

YES

Process Rule that assigned the Dispense Limit Rule, if applicable.

RefillRuleId

int

YES

ID of Refill Rule used during processing

RefillRuleName

nvarchar

128

YES

Name of Refill Rule used during processing

RefillRuleSource

tinyint

NO

Location where the Refill Rule was found.

• Not Applicable = 0
• Plan = 1
• ProcessRule = 2

RefillProcessRuleId

int

YES

Process Rule that assigned the Refill Rule, if applicable.

FillRestrictionRuleId

int

YES

ID of Restriction Rule used during processing

FillRestrictionRuleName

nvarchar

128

YES

Name of Restriction Rule used during processing

FillRestrictionRuleSource

tinyint

NO

Location where the Restriction Rule was found.

• Not Applicable = 0
• Plan = 1
• ProcessRule = 2

FillRestrictionProcessRuleId

int

YES

Process Rule that assigned the Restriction Rule, if applicable.

CostCalculatorRuleId

int

YES

ID of Cost Calculator Rule used during processing

CostCalculatorRuleName

nvarchar

128

YES

Name of Cost Calculator Rule used during processing

CostCalculatorRuleSource

tinyint

NO

Location where the Cost Calculator Rule was found.

• Not Applicable = 0
• Plan = 1
• ProcessRule = 2

CostCalculatorProcessRuleId

int

YES

Process Rule that assigned the Cost Calculator Rule, if applicable.

BillCostCalculatorRuleId

int

YES

ID of Bill Cost Calculator Rule used during processing

BillCostCalculatorRuleName

nvarchar

128

YES

Name of Bill Cost Calculator Rule used during processing

BillCostCalculatorRuleSource

tinyint

NO

Location where the Bill Cost Calculator Rule was found.

• Not Applicable = 0
• Plan = 1
• ProcessRule = 2

BillCostCalculatorProcessRuleId

int

YES

Process Rule that assigned the Bill Cost Calculator Rule, if applicable.

DrugTier

nvarchar

MAX

YES

Drug Tier value as set by a Process Rule

MONY

nvarchar

1

YES

The MONY code used during processing. This may match the MSC value, but can be altered by MONY overrides during processing.

QuantityDispensed

decimal

NO

Quantity Dispensed of the item.

This will match the value on the Transactions table on non compounds.

ExtendedAWP

decimal

YES

Not Used

MacListName

nvarchar

100

YES

Name of the MAC List used during processing

AgeRuleProcessRuleName

nvarchar

128

YES

Name of the Process Rule that assigned the Age Rule, if applicable

DispenseLimitProcessRuleName

nvarchar

128

YES

Name of the Process Rule that assigned the Dispense Limit Rule, if applicable

FillRestrictionProcessRuleName

nvarchar

128

YES

Name of the Process Rule that assigned the Restriction Rule, if applicable

RefillProcessRuleName

nvarchar

128

YES

Name of the Process Rule that assigned the Refill Rule, if applicable

CostCalculatorProcessRuleName

nvarchar

128

YES

Name of the Process Rule that assigned the Cost Calculator Rule, if applicable

BillCostCalculatorProcessRuleName

nvarchar

128

YES

Name of the Process Rule that assigned the Bill Cost Calculator Rule, if applicable

IsPreferred

bit

YES

Currently not in use

OtcIndicator

nvarchar

1

YES

Medispan OTC Indicator value for the product. Values of:

O: OTC, Single Source

P: OTC, Multi Source

R: Rx Drug, Single Source

S: Rx Drug, Multi Source

BrandNameCode

nvarchar

1

YES

Medispan Brand Name Code for the product. Values of:

B: Branded Generic Name

G: Generic Name

T: Trademarked Name

RejectCode

nvarchar

3

YES

Reject code specific to the product. In a compound scenario, this indicates that the ingredient was not covered but does not mean the transaction as a whole rejected.

SFSCostCalculatorRuleId

int

YES

Cost Calculator used to calculate the State Fee Schedule rate.

SFSIngredientCost

decimal

YES

Ingredient Cost determined by the State Fee Schedule calculation.

SFSPriceSource

tinyint

YES

Price Source used to determine SFS ingredient cost.

See Price Source Values list at end of document.

NADACPrice

decimal

YES

NADAC Price at time of the transaction

DrugDescriptorId

int

YES

Drug Descriptor ID from Medispan at the time of Processing

ACAFulPrice

decimal

YES

Added as of version 1.15.8

ACA FUL price at time of the transaction

SellPriceSource

tinyint

YES

Price Source used to determine the Ingredient Cost for the Sell Side Pricing

See Price Source Values list at end of document.

ProcessRuleIEFormularyId

int

YES

ID of the Formulary found on the first qualifying include/exclude Process Rule.

ProcessRuleIEFormularyName

nvarchar

64

YES

Name of the Formulary found on the first qualifying include/exclude Process Rule.

ProcessRuleIEFormularyAction

nvarchar

1

YES

Include or Exclude status of the first qualifying Process Rule with a formulary.

I = Include

E = Exclude

CompoundIngredientBasisofCostDetermination

varchar

5

YES

Compound Ingredient Basis of Cost Determination as submitted on the Transaction in field 490-UE.

CompoundIngredientDrugCost

decimal

18,6

YES

Compound Ingredient Drug Cost as submitted on Transaction in field 449-EE.

SellSideUnitPrice

decimal

18,6

YES

Unit price for the Compound Ingredient calculated for the Sell Side of the transaction.

SellIngredientCostAdjustment

decimal

18,6

YES

Adjustment amount used from the Sell Ingredient Cost Adjustment by Basis option on a Bill Cost Calculator specific to this NDC for the transactions.