CREATE_APPLCTX |
DOUBLE |
Y |
Application which created this row |
CREATE_DT_TM |
DATETIME |
Y |
The date/time this entry was created. |
CREATE_ID |
DOUBLE |
N |
ID of user who created this row |
CREATE_TASK |
DOUBLE |
Y |
Task which created this row |
DAY_F_IND |
DOUBLE |
Y |
Indicates whether or not the route should run on Friday. |
DAY_M_IND |
DOUBLE |
Y |
Indicates whether or not the route should run on Monday. |
DAY_R_IND |
DOUBLE |
Y |
Indicates whether or not the route should run on Thursday. |
DAY_SU_IND |
DOUBLE |
Y |
Indicates whether or not the route should run on Sunday. |
DAY_S_IND |
DOUBLE |
Y |
Indicates whether or not the route should run on Saturday. |
DAY_T_IND |
DOUBLE |
Y |
Indicates whether or not the route should run on Tuesday. |
DAY_W_IND |
DOUBLE |
Y |
Indicates whether or not the route should run on Wednesday. |
MONTH_APR_IND |
DOUBLE |
Y |
Indicates whether or not the route should run in April. |
MONTH_AUG_IND |
DOUBLE |
Y |
Indicates whether or not the route should run in August. |
MONTH_DEC_IND |
DOUBLE |
Y |
Indicates whether or not the route should run in December. |
MONTH_FEB_IND |
DOUBLE |
Y |
Indicates whether or not the route should run in February. |
MONTH_JAN_IND |
DOUBLE |
Y |
Indicates whether or not the route should run in January. |
MONTH_JUL_IND |
DOUBLE |
Y |
Indicates whether or not the route should run in July. |
MONTH_JUN_IND |
DOUBLE |
Y |
Indicates whether or not the route should run in June. |
MONTH_MAR_IND |
DOUBLE |
Y |
Indicates whether or not the route should run in March. |
MONTH_MAY_IND |
DOUBLE |
Y |
Indicates whether or not the route should run in May. |
MONTH_NOV_IND |
DOUBLE |
Y |
Indicates whether or not the route should run in November. |
MONTH_OCT_IND |
DOUBLE |
Y |
Indicates whether or not the route should run in October. |
MONTH_SEP_IND |
DOUBLE |
Y |
Indicates whether or not the route should run in September. |
PAR_ROUTE_ID |
DOUBLE |
N |
The unique id of the route this schedule belongs to. |
PAR_SCHEDULE_ID |
DOUBLE |
N |
The unique id of this entry. |
START_TM |
DATETIME |
Y |
The time this schedule is expected to run. |
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. |