worked on load management command. backed in some checks and create lookup tables after load.