Tables affected by user renumbering |
The following tables and columns are affected when renumbering user IDs:
MWO_NOTES.USR_userid
USR_PROFILE.USR_userid
SHIFTLOG_NOTES.USR_userid
WAR_MAIN.X_userid_insert,
WAR_MAIN.X_userid_update
EMPTST_MAIN.X_userid_insert
EMPTST_MAIN.X_userid_update,
EQLINK_MAIN.X_userid_insert
EQLINK_MAIN.X_userid_update
FREIGHT_MAIN.X_userid_insert,
FREIGHT_MAIN.X_userid_update
INC_MAIN.X_userid_insert
INC_MAIN.X_userid_update,
SCHED_MAIN.X_userid_insert
SCHED_MAIN.X_userid_update
SCHEDULED_REPORTS table
SHIFT_LOG.X_userid_insert,
SHIFT_LOG.X_userid_update
TRIP_MAIN_OPS.X_userid_insert
TRIP_MAIN_OPS.X_userid_update