REFERRAL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Referral
Definition: Stores all the information related to a referral.
Table Type: ACTIVITY





Column Detail - REFERRAL


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.
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 Contains the date and time the row was created in 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.
EXT_RECEIVED_DT_TM DATETIME Y The date and time the referral was received by an external 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_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


Child Column in REFERRAL(FK) Parent Table Name Parent Column Name
Parents: OUTBOUND_ENCNTR_ID ENCOUNTER ENCNTR_ID
REFER_FROM_LOC_CD LOCATION LOCATION_CD
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




Parent Column in REFERRAL (PK) Child Table Name Child Column Name
Children: REFERRAL_ID AUTH_REFERRAL_RELTN REFERRAL_ID
AUTH_REFERRAL_RELTN_HIST REFERRAL_ID
ESI_LOG REFERRAL_ID
REFERRAL_ACTION REFERRAL_ID
REFERRAL_ALIAS REFERRAL_ID
REFERRAL_CONTACT REFERRAL_ID
REFERRAL_CUSTOM REFERRAL_ID
REFERRAL_CUSTOM_HIST REFERRAL_ID
REFERRAL_DOCUMENT REFERRAL_ID
REFERRAL_ENTITY_RELTN REFERRAL_ID
REFERRAL_HIST REFERRAL_ID
REFERRAL_MONIKER REFERRAL_ID
REFERRAL_P_PLAN_RELTN REFERRAL_ID
TASK_SUBACTIVITY REFERRAL_ID


REFERRAL_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Referral Action
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_ACTION


Column Name Type Null? Definition
ACTION_DT_TM DATETIME Y Date and time the referral was affected by the referral action. It can be defined by the user performing the action.
ACTION_PRSNL_ID DOUBLE N Contains the Personnel ID of the user that performs the action.
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.
REASON_CD DOUBLE N The reason for which the referral action was performed.
REFERRAL_ACTION_ID DOUBLE N Unique generated number that identifies a single row on the REFERRAL_ACTION table.
REFERRAL_ACTION_TYPE_CD DOUBLE N The type of action that was performed on the referral.
REFERRAL_ID DOUBLE N Uniquely identifies the related referral.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
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.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
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.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - REFERRAL_ACTION


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




Parent Column in REFERRAL_ACTION (PK) Child Table Name Child Column Name
Children: REFERRAL_ACTION_ID REFERRAL_CONTACT REFERRAL_ACTION_ID


REFERRAL_ALIAS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Referral Alias
Definition: Contains information about referral alias data.
Table Type: ACTIVITY





Column Detail - REFERRAL_ALIAS


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.
ALIAS VARCHAR(200) N Contains the alias for the referral.
ALIAS_POOL_CD DOUBLE N Referral alias pool code identifies a unique set or list of referral identifiers (i.e., numbers). The referral alias pool code also determines the accept/display format for the unique set of identifiers.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
REFERRAL_ALIAS_ID DOUBLE N Unique generated number that identifies a single row on the REFFERAL_ALIAS table.
REFERRAL_ALIAS_TYPE_CD DOUBLE N Identifies the type of the referral alias.
REFERRAL_ID DOUBLE N 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_ALIAS


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


REFERRAL_CONTACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Referral Contact
Definition: Records contacts made to the patient for a given referral.
Table Type: ACTIVITY





Column Detail - REFERRAL_CONTACT


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.
COMMENT_TEXT_ID DOUBLE N FK to the long_text table. A free text field is provided to the user to capture the outcome of the contact.
CONTACT_DT_TM DATETIME Y The date and time the row was created.
CONTACT_PRSNL_ID DOUBLE N Personnel Identifier of the person who made or attempted to make the contact.
CREATE_DT_TM DATETIME Y This is the date and time that the row was created.
PHONE_ID DOUBLE N The identifier of the phone used for the contact attempt.
REFERRAL_ACTION_ID DOUBLE N Uniquely identifies the related row from Referral_Action.
REFERRAL_CONTACT_ID DOUBLE N Uniquely identifies a related Referral Contact.
REFERRAL_ID DOUBLE N Uniquely identifies the related record on the REFERRAL table.
RESULT_CD DOUBLE N The outcome of the contact.
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_CONTACT


Child Column in REFERRAL_CONTACT(FK) Parent Table Name Parent Column Name
Parents: COMMENT_TEXT_ID LONG_TEXT LONG_TEXT_ID
PHONE_ID PHONE PHONE_ID
CONTACT_PRSNL_ID PRSNL PERSON_ID
REFERRAL_ID REFERRAL REFERRAL_ID
REFERRAL_ACTION_ID REFERRAL_ACTION REFERRAL_ACTION_ID


REFERRAL_CUSTOM



Column Section Relationship Section Top of Page


Table-level Detail

Description: REFERRAL_CUSTOM
Definition: Stores all custom fields attributed to specific referrals
Table Type: ACTIVITY





Column Detail - REFERRAL_CUSTOM


Column Name Type Null? Definition
CREATE_DT_TM DATETIME N Dzte and time the referral was created
REFERRAL_CUSTOM_FIELD_KEY VARCHAR(255) N Identifies a unique custom field name for the specific referral.
REFERRAL_CUSTOM_ID DOUBLE N PRIMARY KEY
REFERRAL_CUSTOM_VALUE_BOOLEAN DOUBLE N Contains the boolean value associated to the custom field defined in referral_custom_field_key.
REFERRAL_CUSTOM_VALUE_DOUBLE DOUBLE N 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) N 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 N 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


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




Parent Column in REFERRAL_CUSTOM (PK) Child Table Name Child Column Name
Children: REFERRAL_CUSTOM_ID REFERRAL_CUSTOM_HIST REFERRAL_CUSTOM_ID