IO_DEFINITION_ELEMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Element definition
Definition: I&O Total Definition Element
Table Type: REFERENCE





Column Detail - IO_DEFINITION_ELEMENT


Column Name Type Null? Definition
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.
EVENT_CD DOUBLE N Event code to be used for total calculation
IO_DEFINITION_ELEMENT_ID DOUBLE N Identifies the primary key for this specific row.
IV_EVENT_CD DOUBLE N Event Set the event code belongs to.
PREV_IO_DEFINITION_ELEMENT_ID DOUBLE N Identifies the original primary key for this row.
ROUTE_CD DOUBLE N Route code to be used for total calculation.
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 - IO_DEFINITION_ELEMENT




Parent Column in IO_DEFINITION_ELEMENT (PK) Child Table Name Child Column Name
Children: IO_DEFINITION_ELEMENT_ID IO_DEF_ELEMENT_RELTN IO_DEFINITION_ELEMENT_ID


IO_DEF_ELEMENT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: I&O Total Definition and Element Relation
Definition: Relationship between a total definition and elements
Table Type: REFERENCE





Column Detail - IO_DEF_ELEMENT_RELTN


Column Name Type Null? Definition
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.
IO_DEFINITION_ELEMENT_ID DOUBLE N Identifies the IO_definition_element_id.
IO_DEF_ELEMENT_RELTN_ID DOUBLE N Identifies the primary key for this specific row.
IO_TOTAL_GROUP_ID DOUBLE N Group id of the elements the definition is associated with. This is unique for a group of elements.
PREV_IO_DEF_ELEMENT_RELTN_ID DOUBLE N Identifies the original primary key for this row.
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 - IO_DEF_ELEMENT_RELTN


Child Column in IO_DEF_ELEMENT_RELTN(FK) Parent Table Name Parent Column Name
Parents: IO_DEFINITION_ELEMENT_ID IO_DEFINITION_ELEMENT IO_DEFINITION_ELEMENT_ID
PREV_IO_DEF_ELEMENT_RELTN_ID IO_DEF_ELEMENT_RELTN IO_DEF_ELEMENT_RELTN_ID
IO_TOTAL_GROUP_ID IO_TOTAL_GROUP_DEFINITION IO_TOTAL_GROUP_ID




Parent Column in IO_DEF_ELEMENT_RELTN (PK) Child Table Name Child Column Name
Children: IO_DEF_ELEMENT_RELTN_ID IO_DEF_ELEMENT_RELTN PREV_IO_DEF_ELEMENT_RELTN_ID


IO_TOTAL_DEFINITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: I&O Total Definition
Definition: Definition of how a I&O total should be calculated.
Table Type: REFERENCE





Column Detail - IO_TOTAL_DEFINITION


Column Name Type Null? Definition
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.
IO_TOTAL_DEFINITION_ID DOUBLE N Identifies the primary key for this specific definition for an I&O
IO_TOTAL_GROUP_ID DOUBLE N FK FROM IO_TOTAL_GROUP_DEFINITION. This is the grouper for the definitions.
PREV_IO_TOTAL_DEFINITION_ID DOUBLE N Identifies the original primary key for this row.
TASK_ASSAY_CD DOUBLE N Identifies the DTA this definition is associated with.
TOTAL_DEFINITION_NAME VARCHAR(200) N Name of the definition.
TOTAL_DURATION DOUBLE N Total duration in minutes
TOTAL_DURATION_TYPE_CD DOUBLE N Total duration type
TOTAL_OPERATION_TYPE_CD DOUBLE N Operation to use to calculate the total
TOTAL_TYPE_CD DOUBLE N Identifies the type of calculation to perform.
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 - IO_TOTAL_DEFINITION


Child Column in IO_TOTAL_DEFINITION(FK) Parent Table Name Parent Column Name
Parents: TASK_ASSAY_CD DISCRETE_TASK_ASSAY TASK_ASSAY_CD
PREV_IO_TOTAL_DEFINITION_ID IO_TOTAL_DEFINITION IO_TOTAL_DEFINITION_ID
IO_TOTAL_GROUP_ID IO_TOTAL_GROUP_DEFINITION IO_TOTAL_GROUP_ID




Parent Column in IO_TOTAL_DEFINITION (PK) Child Table Name Child Column Name
Children: IO_TOTAL_DEFINITION_ID CE_IO_TOTAL_RESULT IO_TOTAL_DEFINITION_ID
IO_TOTAL_DEFINITION PREV_IO_TOTAL_DEFINITION_ID


IO_TOTAL_GROUP_DEFINITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: IO Total Group Definition
Definition: Contains the Grouper ID for the definitions
Table Type: REFERENCE





Column Detail - IO_TOTAL_GROUP_DEFINITION


Column Name Type Null? Definition
IO_TOTAL_GROUP_ID DOUBLE N ID value for the definition Grouper
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 - IO_TOTAL_GROUP_DEFINITION




Parent Column in IO_TOTAL_GROUP_DEFINITION (PK) Child Table Name Child Column Name
Children: IO_TOTAL_GROUP_ID IO_DEF_ELEMENT_RELTN IO_TOTAL_GROUP_ID
IO_TOTAL_DEFINITION IO_TOTAL_GROUP_ID