Table Detail Report

MM_PAR_SCHEDULE



Column Section Top of Page


Table-level Detail

Description: MM PAR SCHEDULE
Definition: Information about a route's schedule.
Table Type: REFERENCE





Column Detail - MM_PAR_SCHEDULE


Column Name Type Null? Definition
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.