Who's On?

	Membership:
	Latest: DaptonConsultancyServices
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5206

	People Online:
	Visitors: 516
	Members: 0
	Total: 516

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

USER FIELDS HR11

3 Replies

0 Subscribed to this topic

28 Subscribed to this forum

Sort:

Author

Messages

TRACY

Veteran Member

Posts: 58

6/6/2013 11:58 AM

Can anyone tell me how to query off the user fields on HR11? Having a duh moment for sure..... thanks.

Greg Moeller

Veteran Member

Posts: 1498

MVP

New Poster

Engaged Reader

Avid Reader

6/6/2013 12:38 PM

Check out the HREMPUSF table..

Kwane McNeal

Veteran Member

Posts: 479

6/6/2013 12:44 PM

You will need to know the field number as a portion of the key.

Tim Cochrane

Veteran Member

Posts: 154

6/12/2013 11:44 AM

In case you don't have the answer yet...

Step 1 - query HRUSERFLDS with a SELECT =
Ex: PROD=&FILE=HRUSERFLDS&FIELD=FIELD-KEY&SELECT=FIELD-NAME=90-SPEC STATUS IND&OUT=CSV&DELIM=~

Step 2 - query HREMPUSF with a SELECT = and and FIELD-KEY =
Ex: PROD=&FILE=HREMPUSF&FIELD=COMPANY;EMPLOYEE;FIELD-KEY;A-FIELD&SELECT=COMPANY=%26EMPLOYEE=%26FIELD-KEY=&OUT=CSV&DELIM=~