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.