PRED_GRAPH
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PRED GRAPH |
Definition: | Stores the information about the graph like graph name, graph type etc. |
Table Type: | REFERENCE |
Column Detail - PRED_GRAPH
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. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
GRAPH_TYPE_CD | DOUBLE | N | Type of graph. |
OWNER_IDENTIFIER | DOUBLE | Y | Owner Identifier |
PRED_GRAPH_ID | DOUBLE | N | Unique identifier for a graph. |
PRED_GRAPH_INST_ID | DOUBLE | N | Unique iidentifier for the graph sequence. |
PRED_GRAPH_NAME | VARCHAR(255) | N | Name of the predefined graph. |
SYSTEM_IND | DOUBLE | N | System Indicator |
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 - PRED_GRAPH
Parent Column in PRED_GRAPH (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PRED_GRAPH_INST_ID | PRED_GRAPH_ITEM | PRED_GRAPH_INST_ID |
PRED_GRAPH_RELTN | PRED_GRAPH_INST_ID |
PRED_GRAPH_ITEM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PRED GRAPH ITEM |
Definition: | Stores which event sets are linked to that given graph. |
Table Type: | REFERENCE |
Column Detail - PRED_GRAPH_ITEM
Column Name | Type | Null? | Definition |
---|---|---|---|
EVENT_CD | DOUBLE | N | Identifies the event code to be included in the graph. |
EVENT_SET_NAME | VARCHAR(40) | Y | Name of the event set. |
PRED_GRAPH_INST_ID | DOUBLE | N | Unique identifier for the graph sequence. |
PRED_GRAPH_ITEM_ID | DOUBLE | N | Unique identifier for the pred Graph item. |
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 - PRED_GRAPH_ITEM
Child Column in PRED_GRAPH_ITEM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PRED_GRAPH_INST_ID | PRED_GRAPH | PRED_GRAPH_INST_ID |
Parent Column in PRED_GRAPH_ITEM (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PRED_GRAPH_ITEM_ID | PRED_GRAPH_ITEM_PROP | PRED_GRAPH_ITEM_ID |
PRED_GRAPH_ITEM_PROP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Pred Graph Item Prop |
Definition: | Stores the additional attributes about the event set which is the part of the given graph. For example whether that event set values will be plotted as line or not. Whether it will have secondary axis.. |
Table Type: | REFERENCE |
Column Detail - PRED_GRAPH_ITEM_PROP
Column Name | Type | Null? | Definition |
---|---|---|---|
PRED_GRAPH_ITEM_ID | DOUBLE | N | Unique identifier for the pred Graph item. |
PRED_GRAPH_ITEM_PROP_ID | DOUBLE | N | Specifies the entities that a graph can be linked to. |
PROP_NAME | VARCHAR(100) | N | Specifies the entity associated with a graph. |
PROP_VALUE | VARCHAR(255) | N | Specifies the unique identifier of the entity associated with a graph. |
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 - PRED_GRAPH_ITEM_PROP
Child Column in PRED_GRAPH_ITEM_PROP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PRED_GRAPH_ITEM_ID | PRED_GRAPH_ITEM | PRED_GRAPH_ITEM_ID |
PRED_GRAPH_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Pred Graph Relation |
Definition: | Stores the information about the user who created the graph |
Table Type: | REFERENCE |
Column Detail - PRED_GRAPH_RELTN
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. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
PARENT_ENTITY_ID | DOUBLE | N | Parent Entity Identifier |
PARENT_ENTITY_NAME | VARCHAR(30) | N | Name of entity specified in PARENT_ENTITY_ID. |
PRED_GRAPH_INST_ID | DOUBLE | N | Unique identifier for the graph sequence. |
PRED_GRAPH_RELTN_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 - PRED_GRAPH_RELTN
Child Column in PRED_GRAPH_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PRED_GRAPH_INST_ID | PRED_GRAPH | PRED_GRAPH_INST_ID |