DOCS_RCVD_TRANSPLANT_INFO
Description:
Cosmos discrete data received on transplants.

Primary Key
Column Name Ordinal Position
DOCUMENT_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 DOCUMENT_ID NUMERIC No
The unique identifier (.1 item) for the document record.
2 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 TRANSPLANT_REFERENCE_IDENT VARCHAR No
This item stores the unique reference id associated with the transplant episode
6 TRANSPLANT_SURGERY_DATE DATETIME No
Transplant surgery date
7 TRANSPLANT_REFERRAL_DATE DATETIME No
Transplant episode referral date
8 TRANSPLANT_EVALUATION_DATE DATETIME No
Transplant Episode evaluation date
9 TRANSPLANT_WAITLIST_DATE DATETIME No
Transplant episode waitlisted date
10 TRANSPLANT_SINGLE_SRC_DXO_ID NUMERIC No
Source organization for transplant info with a single source.
11 TRANSPLANT_SINGLE_SRC_DXO_ID_EXTERNAL_NAME VARCHAR No
Organization's external name used as the display name on forms and user interfaces.