PA20 and Complete Date

EDU is the EDUSER table.

Forgot to tell you, it's under the ED system code. EDI table.

Cannot find the COM-DATE field on this table, though.

Doesn't make sense for it to be using that table for PA20.

Don't believe everything Ctrl-Shift-O tells you. All it "knows" is that EDU-COM-DATE is the COBOL field name on the PA20 form. While that *usually* corresponds to the correct table, in this case it doesn't. To find the *real* answer, you have to delve into the COBOL. It's actually stored in the EMPCODES table (EPC is the prefix). EPC-COMPANY = employee's company, EPC-TYPE = "ED", EPC-EMP-APP = 0, EPC-EMPLOYEE = employee number, EPC-CODE = "ED", etc.

Hi Donna, I have a Crystal Report written to this table and would be happy to share the .rpt file if you want. Just contact me with your email or post it here and I'll get it to you.

M. J., Greg and John,

Thank you for your responses. I evidently did not check the box to subscribe to this topic and did not know you answered my inquiry. Sorry it took me so long to acknowledge your kindness.

I am at Driscoll Childrens Hospital in Corpus Christi, TX. I am providing Lawson reporting for all departments but have had some HR requests for information from tables I have not used in the past.

Lawson Guru members have been a true blessing to me for years.

Donna

If you are a report writer I would definitely get familiar with the Lawson utilities dbdoc and dburf specifically with the -w flag. I've used that for years. What it does is it will go through the Lawson programs and tables and create web pages out of them. Linking, and field definitions (when available) are included as well as relationships, indexes... etc.
For the non-core Lawson stuff or non-Lawson databases see https://www.lawsonguru.co...-po-comments-fields/ and specifically my reply on 5/27/2011.

Glad to be of assistance!