Table Detail Report

TRACK_ORD_EVENT_RELTN



Column Section Top of Page


Table-level Detail

Description: TRACK ORD EVENT RELTN
Definition: Uesd to associate order catalog or catalog type code with the track_events
Table Type: REFERENCE





Column Detail - TRACK_ORD_EVENT_RELTN


Column Name Type Null? Definition
ASSOCIATION_TYPE_CD DOUBLE N Defines what type of association from code set 20504
CAT_OR_CATTYPE_CD DOUBLE N catalog code or catalog type code more often used is catalog cd from code set 200 and less often used is catalog type cd from 6000
TRACK_EVENT_ID DOUBLE N Track event id from the track event table.Column
TRACK_GROUP_CD DOUBLE N tracking group codeColumn
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.


TRACK_ORD_TRIGGER



Column Section Top of Page


Table-level Detail

Description: TRACK ORD TRIGGER
Definition: order , event association trigger info
Table Type: REFERENCE





Column Detail - TRACK_ORD_TRIGGER


Column Name Type Null? Definition
CHILD_CD DOUBLE N catalog code or catalogtype code more often used is catalog cd from code set 200 and less often used is catalog type cd from 6000
PARENT_CD DOUBLE N catalog code or catalogtype code more often used is catalog cd from code set 200 and less often used is catalog type cd from 6000
TRACK_GROUP_CD DOUBLE N tracking group codeColumn
TRIGGER_IND DOUBLE N Trigger indicator to know if this order is to be triggered or notColumn
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.


TRACK_PREARRIVAL_FIELD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Track Pre-arrival Field
Definition: Definitions for data fields for tracking pre-arrivals
Table Type: REFERENCE





Column Detail - TRACK_PREARRIVAL_FIELD


Column Name Type Null? Definition
CODE_SET DOUBLE N Code set column
CUSTOM_IND DOUBLE N Custom indicator col
DEFAULT_HEIGHT DOUBLE N Default height col
DEFAULT_LABEL VARCHAR(40) N Default label col
DEFAULT_WIDTH DOUBLE N Default width col
FIELD_MEANING VARCHAR(12) N Field Meaning col
FIELD_NAME VARCHAR(40) N Field Name
FIELD_TYPE_CD DOUBLE N Field type code from code set 20530
PARENT_ENTITY_ID DOUBLE N ID value from the Parent Entity row
PARENT_ENTITY_NAME VARCHAR(30) N Name of the Parent Entity (table) for which this data is related. Initial possible tables are CODE_VALUE and TRACK_REFERENCE.
TRACKING_GROUP_CD DOUBLE N This field indicates that this TRACK_PREARRIVAL_FIELD entry applies only to a specific tracking group.
TRACK_PREARRIVAL_FIELD_ID DOUBLE N Primary Key
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 - TRACK_PREARRIVAL_FIELD




Parent Column in TRACK_PREARRIVAL_FIELD (PK) Child Table Name Child Column Name
Children: TRACK_PREARRIVAL_FIELD_ID TRACKING_PREARRIVAL_USERFIELDS TRACK_PREARRIVAL_FIELD_ID


TRACK_PREFS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Store tracking preferences
Definition: Store tracking preferencs
Table Type: REFERENCE





Column Detail - TRACK_PREFS


Column Name Type Null? Definition
COMP_NAME VARCHAR(50) N Component name
COMP_NAME_UNQ VARCHAR(50) N Unique component nameColumn
COMP_PREF VARCHAR(50) Y Component preference
COMP_TYPE_CD DOUBLE N component type cdColumn
PARENT_PREF_ID DOUBLE N parent pref idColumn
TRACK_PREF_ID DOUBLE N primary keyColumn
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 - TRACK_PREFS




Parent Column in TRACK_PREFS (PK) Child Table Name Child Column Name
Children: TRACK_PREF_ID TRACK_COMP_PREFS TRACK_PREF_ID


TRACK_REFERENCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Tracking Reference Table
Definition: Reference table used to contain reference data for various tracking reference types defined in the 16409 code_set.
Table Type: REFERENCE





Column Detail - TRACK_REFERENCE


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.
ASSOC_CODE_VALUE DOUBLE Y This is the code value item that is associated with a code value element that is used by the PM application. This field will contain code values for various code sets.
COMPLETE_IND DOUBLE Y Complete Indicator used to identify if the registration status is a complete or active status.
CRITICAL_BLINK_IND DOUBLE Y Critical Blink IndicatorColumn
CRITICAL_COLOR VARCHAR(20) Y Critical ColorColumn
CRITICAL_ICON DOUBLE Y Critical IconColumn
CRITICAL_INTERVAL DOUBLE Y Critical IntervalColumn
DEFAULT_IND DOUBLE Y Default Indicator used to identify if this is the default value for the tracking group and tracking reference type code.
DESCRIPTION VARCHAR(100) Y Description of the Tracking Reference Item.
DISPLAY VARCHAR(20) Y Display description
DISPLAY_KEY VARCHAR(50) Y Display Key generated from the Display field (All Uppercase, No Spaces or Special Characters).
OVERDUE_BLINK_IND DOUBLE Y Overdue Blink IndicatorColumn
OVERDUE_COLOR VARCHAR(20) Y Overdue ColorColumn
OVERDUE_ICON DOUBLE Y Overdue IconColumn
OVERDUE_INTERVAL DOUBLE Y Overdue IntervalColumn
REF_COLOR VARCHAR(20) Y Normal Reference Color
REF_ICON DOUBLE Y Normal Reference Icon
TRACKING_GROUP_CD DOUBLE N Tracking Group Code used to identify which tracking group this reference is currently associated with.
TRACKING_REF_ID DOUBLE N Tracking Reference Identifier
TRACKING_REF_TYPE_CD DOUBLE N Tracking Reference Type Code used to identify the type of tracking reference being defined.
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 - TRACK_REFERENCE


Child Column in TRACK_REFERENCE(FK) Parent Table Name Parent Column Name
Parents: TRACKING_GROUP_CD CODE_VALUE CODE_VALUE
TRACKING_REF_TYPE_CD CODE_VALUE CODE_VALUE




Parent Column in TRACK_REFERENCE (PK) Child Table Name Child Column Name
Children: TRACKING_REF_ID FN_OMF_ENCNTR CHECKIN_ACUITY_ID
FN_OMF_ENCNTR CHECKOUT_ACUITY_ID
FN_OMF_ENCNTR SPECIALTY_ID
TRACKING_CHECKIN ACUITY_LEVEL_ID
TRACKING_CHECKIN DEPART_ACUITY_LEVEL_ID
TRACKING_CHECKIN REGISTRATION_STATUS_ID
TRACKING_CHECKIN SPECIALTY_ID
TRACKING_CHECKIN TEAM_ID
TRACKING_LOCATOR TRACKING_ACUITY_LEVEL_ID
TRACKING_PRSNL TRACKING_PRSNL_TASK_ID
TRACKING_PRSNL_REF TRACKING_REF_ID