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 |