Table Detail Report

REFERRAL_CUSTOM_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Referral Custom History
Definition: Stores the history of all the custom field values attributed for a referral
Table Type: ACTIVITY





Column Detail - REFERRAL_CUSTOM_HIST


Column Name Type Null? Definition
CREATE_DT_TM DATETIME Y Dzte and time the referral was created
REFERRAL_CUSTOM_FIELD_KEY VARCHAR(255) Y Identifies a unique custom field name for the specific referral.
REFERRAL_CUSTOM_HIST_ID DOUBLE N A system generated code used to uniquely identify a row on the REFERRAL_CUSTOM_HIST table.
REFERRAL_CUSTOM_ID DOUBLE Y PRIMARY KEY
REFERRAL_CUSTOM_VALUE_BOOLEAN DOUBLE Y Contains the boolean value associated to the custom field defined in referral_custom_field_key.
REFERRAL_CUSTOM_VALUE_DOUBLE DOUBLE Y Contains the double value associated to the custom field defined in referral_custom_field_key.
REFERRAL_CUSTOM_VALUE_DT_TM DATETIME Y Contains the date/time value associated to the custom field defined in referral_custom_field_key.
REFERRAL_CUSTOM_VALUE_STRING VARCHAR(255) Y Contains the string value associated to the custom field defined in referral_custom_field_key.
REFERRAL_CUSTOM_VALUE_TYPE VARCHAR(40) Y Identifies the data type of the value corresponding to the custom key defined in referral_custom_field_key. This will indicate the referral_custom_value_* column that is populated.
REFERRAL_ID DOUBLE Y A foreign key value from the REFERRAL table which Uniquely identifies the related referral.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - REFERRAL_CUSTOM_HIST


Child Column in REFERRAL_CUSTOM_HIST(FK) Parent Table Name Parent Column Name
Parents: REFERRAL_ID REFERRAL REFERRAL_ID
REFERRAL_CUSTOM_ID REFERRAL_CUSTOM REFERRAL_CUSTOM_ID


REFERRAL_DOCUMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Referral Document
Definition: This table links documents to a referral. This includes clinical documents and CAMM documents.
Table Type: ACTIVITY





Column Detail - REFERRAL_DOCUMENT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BLOB_HANDLE VARCHAR(255) Y The handle to the remote blob (CPDI) being referenced.
CATEGORY_CD DOUBLE Y This column defines the category of a document attached to a referral.
CREATE_DT_TM DATETIME N The date and time that a row is created in the referral document table.
DISPLAY_NAME VARCHAR(255) Y A descriptive name for the document that can be displayed to the user.
EVENT_ID DOUBLE N The event identifier of the clinical document being referenced.
MEDIA_OBJECT_IDENTIFIER VARCHAR(64) Y The identifier of the external media object (CAMM) being referenced.
MEDIA_OBJECT_VERSION_NBR DOUBLE N The version number of the external media object (CAMM) being referenced.
REFERRAL_DOCUMENT_ID DOUBLE N Unique generated number that identifies a single row on the referral_document table.
REFERRAL_ID DOUBLE N The identifier of the referral linked to the document.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - REFERRAL_DOCUMENT


Child Column in REFERRAL_DOCUMENT(FK) Parent Table Name Parent Column Name
Parents: REFERRAL_ID REFERRAL REFERRAL_ID


REFERRAL_ENTITY_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Referral Entity Relationship
Definition: Tracks the changes to the status of a referral. Also tracks the personnel and date/times of the modification of the referral.
Table Type: ACTIVITY





Column Detail - REFERRAL_ENTITY_RELTN


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
CREATE_DT_TM DATETIME Y This is the date and time that the row was created.
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the row is related (i.e., episode_id, sch_event_id, encounter, order etc.)
PARENT_ENTITY_NAME VARCHAR(30) N The upper case name of the table to which this row is related (i.e., EPISODE, SCH_EVENT, ENCOUNTER, ORDER, etc.)
REFERRAL_ENTITY_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the REFERRAL_ENTITY_RELTN table.
REFERRAL_ID DOUBLE N Uniquely identifies the related referral record.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - REFERRAL_ENTITY_RELTN


Child Column in REFERRAL_ENTITY_RELTN(FK) Parent Table Name Parent Column Name
Parents: REFERRAL_ID REFERRAL REFERRAL_ID


REFERRAL_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Referral History
Definition: Contains the history of all the modifications of a referral.
Table Type: ACTIVITY





Column Detail - REFERRAL_HIST


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
ADMINISTRATIVE_PROBLEM_CD DOUBLE Y The administrative problem code associated to the referral.
ADMIT_BOOKING_TYPE_CD DOUBLE N Represents how quickly an appointment was booked for the referral.
AUTHORIZATION_CODE_TXT VARCHAR(50) Y A free text alpha numeric code that gets the information for contracts with organisations that will pay for the treatment.
CREATE_DT_TM DATETIME Y This is the date and time that the row was created on the referral table.
CREATE_SYSTEM_CD DOUBLE N An indication of the system that created the referral.
EXTERNAL_SCHEDULED_DT_TM DATETIME Y The date of the scheduled referral if using a non-millennium scheduling system.
HEALTHCARE_GUARANTEE_DT_TM DATETIME Y The guaranteed appointment date calculated for the person for the referral.
INBOUND_ASSIGNED_PRSNL_ID DOUBLE N The identifier of the personnel that is coordinating the inbound referral when manually assigned.
INSTRUCTIONS_TO_STAFF_TEXT_ID DOUBLE N FK to the long_text table. A free text field is provided to communicate special instructions to staff.
INTENDED_BOOKING_TYPE_CD DOUBLE N Represents how quickly an appointment should be booked for the referral based on factors such as urgency and referral type.
LAST_PERFORMED_ACTION_CD DOUBLE N The last performed action on the referral.
LAST_PERFORMED_ACTION_DT_TM DATETIME Y The date and time the last action was performed on the referral.
MEDICAL_SERVICE_CD DOUBLE N The specialized service within which the patient is treated.
ORDER_ID DOUBLE N The identifier of the order that created the outbound referral.
OUTBOUND_ASSIGNED_PRSNL_ID DOUBLE N The identifier of the personnel that is coordinating the outbound referral when manually assigned.
OUTBOUND_ENCNTR_ID DOUBLE N The identifier of the encounter that created the outbound referral
PERSON_ID DOUBLE N The person id of the patient associated to the referral.
REFERRAL_CATEGORY_CD DOUBLE N The venue description of a referral.
REFERRAL_HIST_ID DOUBLE N Unique generated number that identifies a single row on the REFERRAL_HIST table.
REFERRAL_ID DOUBLE N Unique generated number that identifies a single row on the Referral table.
REFERRAL_ORIG_RECEIVED_DT_TM DATETIME Y The date and time the referral was originally received by the referring trust.
REFERRAL_PRIORITY_CD DOUBLE N The urgency of a request for services.
REFERRAL_REASON_TEXT_ID DOUBLE N The reason the referral was created. Foreign Key to the long_text table.
REFERRAL_RECEIVED_DT_TM DATETIME Y The date and time the referral was received by an inbound provider.
REFERRAL_SOURCE_CD DOUBLE N The origin from where the referral request is received.
REFERRAL_STATUS_CD DOUBLE N The status of the referral across the sending or receiving system.
REFERRAL_SUBSTATUS_CD DOUBLE N The substatus of the referral across the sending or receiving system.
REFERRAL_WRITTEN_DT_TM DATETIME Y The date and time when the referral was written by the referring source.
REFER_FROM_LOC_CD DOUBLE N The nursing unit location of the encounter at the time of referral creation
REFER_FROM_ORGANIZATION_ID DOUBLE N The identifier of the organization that is sending the referral.
REFER_FROM_PRACTICE_SITE_ID DOUBLE N The identifier of the practice site sending the referral.
REFER_FROM_PROVIDER_ID DOUBLE N The personnel ID of the provider requesting the referral.
REFER_TO_ORGANIZATION_ID DOUBLE N The organization ID where the referral is being received.
REFER_TO_PRACTICE_SITE_ID DOUBLE N The identifier of the practice site receiving the referral.
REFER_TO_PROVIDER_ID DOUBLE N The personnel ID of the provider who is receiving the referral.
REQUESTED_START_DT_TM DATETIME Y The date that any treatment for the referral is asked to be delayed to.
RESPONSIBLE_PROVIDER_ID DOUBLE N The personnel ID of the inbound provider who is responsible for the care of the patient.
SERVICE_BY_DT_TM DATETIME Y The date the referral must be completed by.
SERVICE_CATEGORY_CD DOUBLE N The specialty within which the consultant is recognized or contracted to the organization.
SERVICE_TYPE_REQUESTED_CD DOUBLE N The type of referral request.
STAND_BY_CD DOUBLE N The state of waiting to secure a place on the basis of earliest availability.
SUSPECTED_CANCER_TYPE_CD DOUBLE N The type of suspected cancer for which an urgent referral is made.
TREATMENT_COMPLETED_DT_TM DATETIME Y The date and time at which the treatment for the referral is deemed completed.
TREATMENT_TO_DATE_TEXT_ID DOUBLE N A free text field is provided to the user to capture notes on any treatment already provided. A foreign key to the long_text table.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
WAITLIST_REMOVAL_DT_TM DATETIME Y The date and time the referral was attended or removed.
WAIT_STATUS_CD DOUBLE N The status representing the patient while waiting to be scheduled.
WAIT_TIME_DAYS DOUBLE Y The wait time in days between accepting a referral and seeing the patient for a referral.



Relationship Detail - REFERRAL_HIST


Child Column in REFERRAL_HIST(FK) Parent Table Name Parent Column Name
Parents: OUTBOUND_ENCNTR_ID ENCOUNTER ENCNTR_ID
INSTRUCTIONS_TO_STAFF_TEXT_ID LONG_TEXT LONG_TEXT_ID
REFERRAL_REASON_TEXT_ID LONG_TEXT LONG_TEXT_ID
TREATMENT_TO_DATE_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORDER_ID ORDERS ORDER_ID
REFER_FROM_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
REFER_TO_ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
REFER_FROM_PRACTICE_SITE_ID PRACTICE_SITE PRACTICE_SITE_ID
REFER_TO_PRACTICE_SITE_ID PRACTICE_SITE PRACTICE_SITE_ID
INBOUND_ASSIGNED_PRSNL_ID PRSNL PERSON_ID
OUTBOUND_ASSIGNED_PRSNL_ID PRSNL PERSON_ID
REFER_FROM_PROVIDER_ID PRSNL PERSON_ID
REFER_TO_PROVIDER_ID PRSNL PERSON_ID
RESPONSIBLE_PROVIDER_ID PRSNL PERSON_ID
REFERRAL_ID REFERRAL REFERRAL_ID


REFERRAL_MONIKER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Referral Moniker
Definition: Stores all external monikers associated to REFERRAL.
Table Type: ACTIVITY





Column Detail - REFERRAL_MONIKER


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE Y Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE Y The person who caused the active_status_cd to be set or change.
ALIAS_POOL_CD DOUBLE Y The alias pool code identifies a unique set or list of order identifiers.
ALIAS_TYPE_CD DOUBLE Y The alias type code identifies a kind or type of alias.
CONTRIBUTOR_SYSTEM_CD DOUBLE Y Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed.
CREATE_DT_TM DATETIME Y The date and time the entry was created.
REFERRAL_ID DOUBLE Y Identifies the related REFERRAL row.
REFERRAL_MONIKER_ID DOUBLE N Unique generated number that identifies a single row on the REFERRAL_MONIKER table.
REFERRAL_MONIKER_SYSTEM_TXT VARCHAR(255) Y Identifies the system generating moniker.
REFERRAL_MONIKER_TYPE_TXT VARCHAR(255) Y Type of moniker which is created by external systems to referral.
REFERRAL_MONIKER_VALUE_TXT VARCHAR(255) Y Contains the actual monikor value.
UPDT_APPLCTX DOUBLE Y The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE Y Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME Y The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE Y The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE Y The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - REFERRAL_MONIKER


Child Column in REFERRAL_MONIKER(FK) Parent Table Name Parent Column Name
Parents: ALIAS_POOL_CD ALIAS_POOL ALIAS_POOL_CD
REFERRAL_ID REFERRAL REFERRAL_ID