Entity Blood Product Order Detail

DescriptionAn order for blood or a derivative product of blood usually placed by a healthcare practitioner for the purpose of transfusion.

Attributes
Accession NumAccession Num
Advanced Beneficiary Notice Code SkAdvanced Beneficiary Notice Code Sk
Advanced Beneficiary Notice Override Reason Code SkAdvanced Beneficiary Notice Override Reason Code Sk
Blood Product Amt QtyBlood Product Amt Qty
Blood Product Order SkBlood Product Order Sk
Blood Product QtyBlood Product Qty
Blood Product UOM Code SkBlood Product UOM Code Sk
Confidentiality Code SkConfidentiality Code Sk
Effective From DtEffective From Dt
Effective To DtEffective To Dt
Enterer Authorization Mode Code SkEnterer Authorization Mode Code Sk
Enterer Organization Code SkEnterer Organization Code Sk
Entering Device Code SkEntering Device Code Sk
Filler Order NumFiller Order Num
Fillers Expected Availability TsFillers Expected Availability Ts
Informed Consent IndInformed Consent Ind
Intended Use TsIntended Use Ts
Load Info SkLoad Info Sk
Order Action Reason Code SkOrder Action Reason Code Sk
Order Action Status Code SkOrder Action Status Code Sk
Order Discontinue TsOrder Discontinue Ts
Order Status Code SkOrder Status Code Sk
Order Status Modifier Code SkOrder Status Modifier Code Sk
Order TsOrder Ts
Parent Order NumParent Order Num
Placer Group NumPlacer Group Num
Placer Order NumPlacer Order Num
Requested Dispense TsRequested Dispense Ts
Response Code SkResponse Code Sk
Source Code SkSource Code Sk
Tenant SkTenant Sk
Universal Service Code SkUniversal Service Code Sk
Valid From TsValid From Ts
Valid To TsValid To Ts

Relationship
Blood Product Order Detail_Blood Product Order_FKBlood Product Order Detail_Blood Product Order_FK

Primary Key
Blood Product Order Detail PKBlood Product Order Detail PK

Dependencies
 

Reverse Dependencies
 

Attribute Details

 Accession Num
DescriptionA workflow-management generated number that identifies the filler order (diagnostic service) for an imaging order. This identifier corresponds one-to-one to the order filler number but is used in internal tracking of the work within a diagnostic imaging service department.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Advanced Beneficiary Notice Code Sk
DescriptionIndicates the status of the patient's or the patient's representative's consent for responsibility to pay for potentially uninsured services. This element is introduced to satisfy CMS Medical Necessity requirements for outpatient services. This element indicates (a) whether the associated diagnosis codes for the service are subject to medical necessity procedures (b) whether, for this type of service, the patient has been informed that they may be responsible for payment for the service, and (c) whether the patient agrees to be billed for this service.

For Example:
Service is subject to medical necessity procedures
Patient has been informed of responsibility, and agrees to pay for service
Patient has been informed of responsibility, and asks that the payer be billed
Advanced Beneficiary Notice has not been signed
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Advanced Beneficiary Notice Override Reason Code Sk
DescriptionIndicates the reason why the patient did not sign an Advanced Beneficiary Notice. The reason may be coded or it may be a free text entry.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Blood Product Amt Qty
DescriptionIndicates the volume of blood product ordered, dispensed, or transfused.
Data TypeStandards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Blood Product Order Sk
DescriptionAnchor surrogate key for the Blood Product Order data.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Blood Product Qty
DescriptionThe number of blood products ordered, dispensed, or used in the transfusion.

For Example:
3 Units
Data TypeStandards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Blood Product UOM Code Sk
DescriptionThe units of measure in which the ordered, dispensed, or transfused blood product amount is expressed.

For example:
Milliliters
International Units
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Confidentiality Code Sk
DescriptionThe level of security and/or sensitivity surrounding the order.

For Example:
Very restricted
Restricted
Usual control
Employee
Unwed mother
Very important person or celebrity
Psychiatric patient
AIDS patient
HIV(+) patient
Alcohol/drug treatment patient
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Effective From Dt
DescriptionEstablishes a period where a set of attributes are true according to the business.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Effective To Dt
DescriptionEnds a period of effectivity.
Data TypeStandards - Data Domains.ddm/Data Domains/Date [DATE]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Enterer Authorization Mode Code Sk
DescriptionIndicates the form of authorization a recorder had from the responsible practitioner to create or change an order.

For Example:
Electronic
E-mail
Fax
In Person
Mail
Paper
Phone
Reflexive (Automated system)
Video-conference
Voice
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Enterer Organization Code Sk
DescriptionIndicates the organization that the enterer belonged to at the time he/she enters/maintains the order, such as medical group or department.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Entering Device Code Sk
DescriptionIdentifies the physical device (terminal, PC) used to enter the order.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Filler Order Num
DescriptionThe identifying number associated with the filling application.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Fillers Expected Availability Ts
DescriptionThe date and time the filler expects the services to be available. For Example, When a prescription is ready for pickup or when a supply will be sent or picked up, or for when a laboratory result is expected to be available.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Informed Consent Ind
DescriptionIndicates whether consent for the transfusion has been obtained.
Data TypeStandards - Data Domains.ddm/Data Domains/Boolean Indicator [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Intended Use Ts
DescriptionThe date and time the practitioner intends to use the blood product that is being ordered.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Order Action Reason Code Sk
DescriptionIndicates the reason for the order action event.

For Example:
Patient refused
Patient discharged
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Action Status Code Sk
DescriptionIndicates the action associated with an order.

For Example:
Cancel
On Hold
Pending
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Discontinue Ts
DescriptionThe date and time an order was stopped or discontinued.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Status Code Sk
DescriptionIndicates the current status of an order.

For Example:
Some, but not all, results available
Order was cancelled
Order is completed
Order was discontinued
Error, order not found
Order is on hold
In process, unspecified
Order has been replaced
In process, scheduled
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Status Modifier Code Sk
DescriptionIndicates the modifier who refined the order status. May be used to provide additional levels of specificity or additional information for the defined order status codes.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Order Ts
DescriptionA date and time that specifies the start of the Order Status.

For example:
A pharmacy order becomes 'on hold' and the accompanying status timestamp is YYYY/DD/MM 00:00
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Parent Order Num
DescriptionA number which uniquely represents an order in the operational system. The identifier code for the parent order which caused this observation/test/battery to be performed.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Placer Group Num
DescriptionA number used to identify a group of orders.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Placer Order Num
DescriptionThe placer application's order number for the service/material being ordered.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Requested Dispense Ts
DescriptionThe date and time that the requested blood products must be ready for dispense. This date/time may be different from the intended use date and time.

For example:
The patient may be scheduled to come in for a transfusion at a specified appointment time. However, the placer would request that the blood product be ready for dispense prior to the appointment time in order to have the blood product ready for transfusion at the appointment time.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Response Code Sk
DescriptionIndicates the amount of information to be returned from the filler. Sometimes the requested level of response may not be possible immediately, but when it is possible, the filler (receiving) application must send the information.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Source Code Sk
DescriptionThe origin of the data identifying the actual load source, vendor, manual key entry, or context of the data in a specific row in the database.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Tenant Sk
DescriptionThe surrogate key of the entry identifying the legal owner of the data.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Universal Service Code Sk
DescriptionThe identifier code for the requested blood product. This can be based on local and/or universal codes.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Valid From Ts
DescriptionEstablishes a period where a set of attributes are true in the source system. This would be populated with the transaction timestamp and would be used for the snapshot date.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Valid To Ts
DescriptionEnds a period of validity.
Data TypeStandards - Data Domains.ddm/Data Domains/Timestamp [TIMESTAMP]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 Blood Product Order Detail_Blood Product Order_FK
Is Identifying Relationshiptrue
Child TableBlood Product Order Detail
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableBlood Product Order
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE

Primary Key Details

 Blood Product Order Detail PK
Key AttributeBlood Product Order Sk
Key AttributeValid From Ts