You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How can I query the Travel Required attribute of the Requisition Work Requirements in SQL?

I have a requirement to include the 'Travel Required' attribute in a BI Publisher extract for integration. I have tracked it down from the requisition work requirements section to the Job Profile and believe it is stored in the HRT_PROFILE_ITEMS table, but cannot determine which data field as they are generically named (ie item_text30_1). How can I determine what table / field stores this value, so that I can properly extract it? Is there a document or configuration that I can reference?

(Note: We currently have an SR open as the value is disappearing after the field is saved and does not appear to be saving).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!