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 |