ORGAN_TRACK
Description:
Track changes to the organ record that occur as data is added and changed. A table for audit trailing the changes.

Primary Key
Column Name Ordinal Position
ORG_RECORD_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ORG_RECORD_ID NUMERIC No
The unique identifier for the organ 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 TRACK_INST DATETIME (Local) No
Instant that item was changed.
4 TRACK_WHO_ID VARCHAR No
ID of the user who changed the item.
5 TRACK_WHO_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
6 TRACK_ORG_STAT_C_NAME VARCHAR No
Track changes in organ status.
May contain organization-specific values: Yes
Category Entries:
Inactive
Pre-Procurement
Procured
Transplanted
Failed
In Rejection
Partially Functioning
7 TRACK_SOURCE_C_NAME VARCHAR No
Track changes to the organ source.
May contain organization-specific values: Yes
Category Entries:
Living
Donation after Brain Death
Donation after Circulatory Death
Auto
8 TRACK_HLA_MATCH_C_NAME VARCHAR No
Track changes to the human leukocyte antigen (HLA) match type.
May contain organization-specific values: Yes
Category Entries:
Identical
Haplo
Non Match
9 TRACK_DONOR_CRIT_C_NAME VARCHAR No
Track changes to the donation criteria.
May contain organization-specific values: Yes
Category Entries:
Standard Criteria Donor
Expanded Criteria Donor
10 TRACK_AG_MATCHES INTEGER No
Track changes to the antigen matches.
11 TRACK_CDC_YN VARCHAR No
Track changes to whether the donor had risk factors for blood-borne disease transmission.
May contain organization-specific values: No
Category Entries:
No
Yes
12 TRACK_MATCH_RUN VARCHAR No
Track changes to match run ID.
13 TRACK_OPO_RISK_YN VARCHAR No
Track changes to whether the donor is considered high risk by the organ procurement organization.
The category values for this column were already listed for column: TRACK_CDC_YN
14 TRACK_LINK_ORG_ID NUMERIC No
Track changes to the Organ ID to which the current organ is linked.
15 TRACK_DNR_ID_UNOS VARCHAR No
Track changes made to the donor ID from the United Network for Organ Sharing (UNOS).
16 TRACK_DNR_ABO_C_NAME VARCHAR No
Track changes to the donor's blood type.
May contain organization-specific values: No
Category Entries:
A+
A-
AB+
AB-
B+
B-
O+
O-
A
B
AB
O
A1
A1B
A2
A2B
A1+
A1-
A2+
A2-
A1B+
A1B-
A2B+
A2B-