Micros 3700 RES shift_emp_ttl data

[raphael75]

Does the data in micros.shift_emp_ttl come from a stored procedure? If so, which stored procedure is it?

Thanks!

 

[pmegan]

Employee shift data is pulled from all over the transaction & detail tables and consolidated into with micros.shift_emp_ttl by the micros.sp_post_emp_cum stored procedure.

 

[raphael75]

Thanks for your reply. I checked out that stored procedure but it is empty. Is it created on-demand?

I'm just trying to figure out how it calculates Net Sales. Do you know the formula(s) it uses or a place I can find them?

Thank you!

 

[pmegan]

No, it's a permanent sp. If it's empty there's something wrong with your database.

I'm not sure how net sales are calculated. My guess is that depending on how the RVC's are set up the procedure gets either the trans_emp_seq or chk_emp_seq from trans_dtl and consolidates the net_sls_ttl from sale_dtl. Like I said, that's just my guess. The sp_post_emp_cum procedure is pretty crazy, 2036 lines, and I haven't really looked at it in a while.

 

[raphael75]

Strange, I wasn't able to view the sp_post_emp_cum procedure in RazorSQL but I could see it in Interactive SQL.

Man, you were right, that procedure is huge. This version is 2151 lines. I'll start trying to decode it.

Thanks so much for your help!