BAT_DB_MAIN
Description:
Stores unique values for the batch that do not change over time.
Primary Key
Column Name
Ordinal Position
BATCH_NUMBER_ID
1
Column Information
Name
Type
Discontinued?
1
BATCH_NUMBER_ID
VARCHAR
No
The unique ID of the batch.
2
BATCH_COMMENT_ID
VARCHAR
No
The unique ID for the comment on the batch.
3
INTENDED_PAT_ID
VARCHAR
No
The patient that the contents of the batch is intended for.