Who's On?

	Membership:
	Latest: Brady
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5274

	People Online:
	Visitors: 535
	Members: 0
	Total: 535

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

Query on PR69.1

1 Replies

0 Subscribed to this topic

68 Subscribed to this forum

Sort:

Author

Messages

Jill

Posts: 5

3/20/2014 1:11 PM

We have a field in PR69.1 that shows the PA-PSD-CODE and I'm trying to find a way to query on that field? I have tried HR65 Report Writer but I cannot seem to find anything that would show that field. I found the Field Nbr (14) and can query in the Application query source but what about in the Database query source in Add-ins? Or Report Writer? Is this a custom field that was added for my company or does anyone else use this field as well?

John Henley

Posts: 3351

3/20/2014 1:48 PM

Table is PRREGPARM. Use COUNTRY-CODE = 'US' AND RECORD-TYPE = 'T' AND TOPIC='S1'