Table Detail Report

TRACK_ACTION_REFINEMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Track Action Refinement
Definition: Describes how a tracking action will be launched.
Table Type: REFERENCE





Column Detail - TRACK_ACTION_REFINEMENT


Column Name Type Null? Definition
PARENT_ENTITY_ID DOUBLE N Primary key from the parent table identified in PARENT_ENTITY_NAME - this is replicated from TRACK_ACTION to support RDDS merge delete.
PARENT_ENTITY_NAME VARCHAR(30) N Name of the Parent Entitythis is replicated from TRACK_ACTION to support RDDS merge delete for parent/child tables.
REFINEMENT_CONTENT VARCHAR(256) N Refinement value data. Describes a custom field.
REFINEMENT_ENTITY_ID DOUBLE N Primary Key from a parent table identified in REFINEMENT_ENTITY_NAME. (TRACK_EVENT, TRACK_PREFERENCE, CODE_VALUE, DCP_FORMS_REF)
REFINEMENT_ENTITY_NAME VARCHAR(30) N Name of the parent entity for REFINEMENT_ENTITY_ID(TRACK_EVENT, TRACK_PREFERENCE, CODE_VALUE, DCP_FORMS_REF)
REFINEMENT_NAME VARCHAR(64) N Describes the data being held in this refinement
TRACK_ACTION_ID DOUBLE N FOREIGN KEY ID from the TRACK ACTION table for the action that these refinements are describing
TRACK_ACTION_REFINEMENT_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_ACTION_REFINEMENT


Child Column in TRACK_ACTION_REFINEMENT(FK) Parent Table Name Parent Column Name
Parents: TRACK_ACTION_ID TRACK_ACTION TRACK_ACTION_ID


TRACK_COLLECTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Track_Collection
Definition: This table stores the FirstNet's Track Collection Reference Data.
Table Type: REFERENCE





Column Detail - TRACK_COLLECTION


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.
COLLECTION_TYPE_CD DOUBLE N Code value from code set 20320
COLOR_NUM DOUBLE N Color of the Track Collection
DESCRIPTION VARCHAR(250) N Description or Name of the collectionColumn
DISPLAY VARCHAR(50) N Short Display for the collectionColumn
SEQUENCE_NUM DOUBLE N Sequence number of the track event group for display
TRACKING_GROUP_CD DOUBLE N Tracking Group Code from code set 16370.
TRACK_COLLECTION_ID DOUBLE N Key of the table
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_COLLECTION




Parent Column in TRACK_COLLECTION (PK) Child Table Name Child Column Name
Children: TRACK_COLLECTION_ID TRACK_ACTION_LINK FOLLOWUP_TRACK_COLLECTION_ID
TRACK_ACTION_LINK PRIMARY_TRACK_COLLECTION_ID
TRACK_COLLECTION_ELEMENT TRACK_COLLECTION_ID
TRACK_EVENT DEF_NEXT_EVENT_ID
TRACK_EVENT DEF_PREVIOUS_EVENT_ID


TRACK_COLLECTION_ELEMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Track Collection Element
Definition: This table stores the FirstNet's Track Collection Element Reference Data.
Table Type: REFERENCE





Column Detail - TRACK_COLLECTION_ELEMENT


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.
ELEMENT_STATUS_CD DOUBLE N Could be a code value for event status
ELEMENT_TABLE VARCHAR(30) N Stores the Table Name where the value is from
ELEMENT_VALUE DOUBLE N Mostly Track_event_id or could be code value
SEQUENCE_NUM DOUBLE N Sequence of appearance of each element in the track collection
TRACK_COLLECTION_ELEMENT_ID DOUBLE N Primary Key
TRACK_COLLECTION_ID DOUBLE N Foreign Key from Track Collection table
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_COLLECTION_ELEMENT


Child Column in TRACK_COLLECTION_ELEMENT(FK) Parent Table Name Parent Column Name
Parents: TRACK_COLLECTION_ID TRACK_COLLECTION TRACK_COLLECTION_ID


TRACK_COMPLAINT



Column Section Relationship Section Top of Page


Table-level Detail

Description: List of Complaints (Lynx Problems) that can be assigned to a patient.
Definition: Track Complaint
Table Type: REFERENCE





Column Detail - TRACK_COMPLAINT


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.
COMPLAINT_TITLE VARCHAR(255) Y Textual display describing the Complaint (Lynx Problem)
FOREIGN_COMPLAINT_ID DOUBLE N Lynx Problem ID of the Lynx Problem matching this Complaint (Lynx Problem)
PARENT_COMPLAINT_ID DOUBLE N Track Complaint ID of the parent track complaint record. Used to define a problem hierarchy.
TRACK_COMPLAINT_ID DOUBLE N Primary Key to the table. Sequence from i_tracking.
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_COMPLAINT




Parent Column in TRACK_COMPLAINT (PK) Child Table Name Child Column Name
Children: TRACK_COMPLAINT_ID TRACKING_COMPLAINT TRACK_COMPLAINT_ID


TRACK_COMP_PREFS



Column Section Relationship Section Top of Page


Table-level Detail

Description: TRACK COMP PREFS
Definition: Contains preference components
Table Type: REFERENCE





Column Detail - TRACK_COMP_PREFS


Column Name Type Null? Definition
SUB_COMP_NAME VARCHAR(50) N name of subcomponentColumn
SUB_COMP_PREF VARCHAR(200) Y preference stringColumn
SUB_COMP_TYPE_CD DOUBLE N type of sub componentColumn
TRACK_PREF_COMP_ID DOUBLE N primary idColumn
TRACK_PREF_ID DOUBLE N key to track pref tableColumn
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_COMP_PREFS


Child Column in TRACK_COMP_PREFS(FK) Parent Table Name Parent Column Name
Parents: TRACK_PREF_ID TRACK_PREFS TRACK_PREF_ID