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. |