Who's On?

	Membership:
	Latest: Taylor.M
	Past 24 Hours: 2
	Prev. 24 Hours: 0
	Overall: 5204

	People Online:
	Visitors: 163
	Members: 0
	Total: 163

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1369
Roger French	1315
mark.cook	1244

Time/Absence Entry Comments

1 Replies

0 Subscribed to this topic

68 Subscribed to this forum

Sort:

Author

Messages

Matt Gordon

Basic Member

Posts: 12

10/19/2017 1:59 PM

I have an administrator that would like to have a report of approved absence entries including the comments each pay period. Does anyone know where the comment is stored? There is a 'comment' field in PRPENDTIME but no entries that I make show up there. I'm also not seeing your typical cross reference fields to link to another table. Any ideas?

Matt Gordon

Basic Member

Posts: 12

10/26/2017 7:45 PM

I dug around and finally found them. The comments are stored in EMPCOMMENT with a CMT_TYPE of 'TR'. They can be linked by COMPANY, EMPLOYEE, and R_DATE.