ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Payroll >> termination date for crystal report
http://www.istechforum.com/YaBB.pl?num=1228250318

Message started by deburr on 12/02/08 at 13:38:38

Title: termination date for crystal report
Post by deburr on 12/02/08 at 13:38:38

Anybody know what table and field contains the payroll termination date. I can't seem to find it in BKPRMSTR.

Thanks,
Steve

Title: Re: termination date for crystal report
Post by Lenette on 12/02/08 at 13:57:41

In BKPRMSTR it is TERM (BKPR_EMP_TERM)

Title: Re: termination date for crystal report
Post by deburr on 12/03/08 at 10:59:53

That was what I first thought, but BKPR_EMP_TERM is a string type field with the Y or N for the terminated question. The date is somewhere else. Still looking.

Title: Re: termination date for crystal report
Post by kevind on 12/03/08 at 16:43:05

Table: BKPRINFO
Field: BKPR_INFO_DATE_1

Link BKPRMSTR.BKPR_EMP_NUM to BKPRINFO.BKPR_INFO_NUM

Records may not exist in BKPRINFO for all employees.
You may need to use a left outer join in the link type.

Title: Re: termination date for crystal report
Post by deburr on 12/04/08 at 10:17:47

Kevin

Thanks