BMT_DONOR_SUITABILITY_AUD
Description:
Audit history information for BMT donor selection, suitability, and availability information.

Primary Key
Column Name Ordinal Position
EPISODE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 EPISODE_ID NUMERIC No
The unique identifier for the episode record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 SUITABILITY_C_NAME VARCHAR No
Donor suitability audit item
May contain organization-specific values: No
Category Entries:
Suitable
Unsuitable
4 AVAILABILITY_C_NAME VARCHAR No
Donor availability audit item
May contain organization-specific values: No
Category Entries:
Available
Unavailable
Temporarily Unavailable
Deleted from Registry
5 SELECTION_C_NAME VARCHAR No
Donor selection audit item
May contain organization-specific values: No
Category Entries:
Selected for Donation
Deferred
6 UPDATE_USER_ID VARCHAR No
Donor suitability and selection audit user
7 UPDATE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
8 START_UTC_DTTM DATETIME (UTC) No
Donor suitability and selection audit instant
9 END_UTC_DTTM DATETIME (UTC) No
The end instant for a given set of donor suitability, availability, and selection values
10 DNR_WRKP_AUD_C_NAME VARCHAR No
Donor workup audit item
May contain organization-specific values: No
Category Entries:
Primary
Backup