Table Detail Report

TRACK_FILTER_REFINEMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: TRACK FILTER REFINEMENT
Definition: Describes custom tracking fields that are being filtered on.
Table Type: REFERENCE





Column Detail - TRACK_FILTER_REFINEMENT


Column Name Type Null? Definition
PARENT_ENTITY_ID DOUBLE N ID value from the parent table identified in PARENT_ENTITY_NAME
PARENT_ENTITY_NAME VARCHAR(30) N Name of the Parent Entity
REFINEMENT_CONTENT VARCHAR(256) N Refinement value data. Describes a custom field.
REFINEMENT_NAME VARCHAR(64) N Describes the data being held in this refinement
TRACK_FILTER_ID DOUBLE N ID from the TRACK FILTER table for the filter that these refinements are describing
TRACK_FILTER_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_FILTER_REFINEMENT


Child Column in TRACK_FILTER_REFINEMENT(FK) Parent Table Name Parent Column Name
Parents: TRACK_FILTER_ID TRACK_FILTER TRACK_FILTER_ID


TRACK_FILTER_VALUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: TRACK FILTER VALUE
Definition: Describes the data values for a custom tracking field that will be included when filtering.
Table Type: REFERENCE





Column Detail - TRACK_FILTER_VALUE


Column Name Type Null? Definition
OPERATOR_FLAG DOUBLE N Operator to be used when evaluating this filter value.EQUALS = 0, LESS THAN = 1, GREATER THAN = 2, LESS THAN EQUALS = 3, GREATER THAN EQUALS = 4, STARTS WITH = 5, CONTAINS = 6
PARENT_ENTITY_ID DOUBLE N ID value from the parent table identified in PARENT_ENTITY_NAME
PARENT_ENTITY_NAME VARCHAR(30) N Name of the Parent Entity
TRACK_FILTER_ID DOUBLE N Foreign Key ID from the TRACK FILTER table for the filter that these refinements are describing
TRACK_FILTER_VALUE_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.
VALUE_AMT DOUBLE N Double data value to include when filtering
VALUE_DT_TM DATETIME Y Date data value to include when filtering
VALUE_TXT VARCHAR(128) N Text data value to include when filtering



Relationship Detail - TRACK_FILTER_VALUE


Child Column in TRACK_FILTER_VALUE(FK) Parent Table Name Parent Column Name
Parents: TRACK_FILTER_ID TRACK_FILTER TRACK_FILTER_ID


TRACK_FLOORPLAN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Floorplan Tracking View
Definition: Floorplan Tracking View Specification
Table Type: REFERENCE





Column Detail - TRACK_FLOORPLAN


Column Name Type Null? Definition
DESCRIPTION VARCHAR(200) N A place to put a more detailed description of the floorplan view
DISPLAY_NAME VARCHAR(40) N Name of the floorplan
LONG_BLOB_ID DOUBLE N FK From the LONG_BLOB_REFERENCE for the field that contains the floorplay graphic.
OBJECT_SIZE_FLAG DOUBLE N Specifies the size of objects displayed in this view 0 = small, 1 = medium, 2 = large
TRACKING_GROUP_CD DOUBLE N Tracking group code the floorplan view is associated with
TRACK_FLOORPLAN_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_FLOORPLAN


Child Column in TRACK_FLOORPLAN(FK) Parent Table Name Parent Column Name
Parents: LONG_BLOB_ID LONG_BLOB_REFERENCE LONG_BLOB_ID




Parent Column in TRACK_FLOORPLAN (PK) Child Table Name Child Column Name
Children: TRACK_FLOORPLAN_ID TRACK_FLOORPLAN_LOCATION TRACK_FLOORPLAN_ID


TRACK_FLOORPLAN_LOCATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Track Floorplan Location
Definition: Locations associated to a floorplan and their positions in the floorplan
Table Type: REFERENCE





Column Detail - TRACK_FLOORPLAN_LOCATION


Column Name Type Null? Definition
ANCHOR_PT_X DOUBLE N x coordinate, in pixels, relative to the upper left corner of location object
ANCHOR_PT_Y DOUBLE N Y coordinate, in pixels, relative to the upper left corner of location object
HIDDEN_IND DOUBLE N Indicates that the location object should be hidden when vacant
LOCATION_CD DOUBLE N The Location cd
TRACK_FLOORPLAN_ID DOUBLE N Reference to the Parent Floorplan
TRACK_FLOORPLAN_LOCATION_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_FLOORPLAN_LOCATION


Child Column in TRACK_FLOORPLAN_LOCATION(FK) Parent Table Name Parent Column Name
Parents: TRACK_FLOORPLAN_ID TRACK_FLOORPLAN TRACK_FLOORPLAN_ID


TRACK_GROUP



Column Section Top of Page


Table-level Detail

Description: Tracking Group Table
Definition: Table used to store Parent/Child relationships between tracking reference tables and other code value records.
Table Type: REFERENCE





Column Detail - TRACK_GROUP


Column Name Type Null? Definition
CHILD_TABLE VARCHAR(40) Y Child Table
CHILD_VALUE DOUBLE N Child Value
COLLATION_SEQ DOUBLE Y Collation SequenceColumn
PARENT_VALUE DOUBLE N Parent Value
TRACKING_GROUP_CD DOUBLE N Tracking Group CodeColumn
TRACKING_RULE VARCHAR(200) Y Tracking RuleColumn
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.