Skip to Content

ODS_PRODUCTION_LOG table details

Hello Team,


Can any one tell me how colum "pass1_elapsed_queue_time'  on the ODS_PRODUCTION_LOG table in ODS DB is calculated? The value it is showing in our DB does not appear to be correct.


-Adarsha.K.S


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 26, 2016 at 06:38 PM

    Adarsha


    It's not so much a calculation as a direct mapping from the WIP production_log table, elapsed_queue_time column:


    production_log.elapsed_queue_time, where production_log.times_processed=1


    So for


    pass2_elapsed_queue_time, this is where times_processed=2


    and pass2plus_elapsed_queue_time is where times_processed>2


    Stuart

    Add comment
    10|10000 characters needed characters exceeded