ODS_PRODUCTION_LOG table details

[adarsha_kssp4z121a3506]

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

[stuarta1]

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