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 |