TIME_SCALE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | TIME SCALE |
Definition: | Time scale definition for some Powerchart components. Used in IO2G |
Table Type: | REFERENCE |
Column Detail - TIME_SCALE
Column Name | Type | Null? | Definition |
---|---|---|---|
INTERVAL_LABEL_FLAG | DOUBLE | Y | determines how to label an interval |
INTERVAL_LENGTH | DOUBLE | Y | length of an interval |
INTERVAL_UNITS_CD | DOUBLE | N | time unit for interval |
NBR_OF_INTERVALS | DOUBLE | Y | defines the number of intervals in a day |
TIME_SCALE_ID | DOUBLE | N | primary key to the time scale table |
TIME_SCALE_NAME | VARCHAR(60) | N | Name of the time scale |
TIME_SCALE_NAME_KEY | VARCHAR(60) | N | Uppercase name as index |
TIME_SCALE_START_TM | DATETIME | Y | Start time for time scale |
TIME_SCALE_START_TM_LONG | DOUBLE | Y | Time scale start time stored as a long datatype |
TIME_SCALE_TYPE_FLAG | DOUBLE | N | time scale type |
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 - TIME_SCALE
Child Column in TIME_SCALE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | INTERVAL_UNITS_CD | CODE_VALUE | CODE_VALUE |
TIME_SCALE_OP
Column Section | Top of Page |
Table-level Detail
Description: | TIME SCALE OP |
Definition: | Defines operations on the time scale |
Table Type: | REFERENCE |
Column Detail - TIME_SCALE_OP
Column Name | Type | Null? | Definition |
---|---|---|---|
OPERATION_DISP_NAME | VARCHAR(100) | Y | The name of the operation to be displayed. i.e. Shift 1 Total, Grand total |
OPERATION_END_INTERVAL | DOUBLE | N | The last interval to operate on |
OPERATION_FLAG | DOUBLE | N | Defines what operation to perform on the a range of intervals |
OPERATION_PLACEMENT_FLAG | DOUBLE | Y | Where to place the operation |
OPERATION_START_INTERVAL | DOUBLE | N | The interval to start operating on |
TIME_SCALE_ID | DOUBLE | N | foreign key to time_scale |
TIME_SCALE_OP_IDX | DOUBLE | N | Operation number on the specific time scale. A time scale can have one or more operations |
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. |