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