Prev
Next
Forums S3 Systems Administration

USER FIELDS HR11

Sort:
You are not authorized to post a reply.
Author
Messages
TRACY
Veteran Member
Posts: 58
Veteran Member
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
    Veteran Member
    6/6/2013 12:38 PM
      Check out the HREMPUSF table..
      Kwane McNeal
      Veteran Member
      Posts: 479
      Veteran Member
      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
        Veteran Member
        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=~
          Tim Cochrane - Principal LM/IPA Consultant
          You are not authorized to post a reply.