Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Where to find Risk Code Description in DB — Cloud Customer Connect
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

Where to find Risk Code Description in DB

Accepted answer
32
Views
7
Comments

Summary:

Need to find the Risk Code (or Workers Compensation Code) description in the database.

Content (required):

I am creating a report pulling data out of hcm cloud that is needing to include the "Risk Code" description (Also known as Workers Comp Code). This is attribute2 in the per_jobs_f table. What I see in attribute2 is 8810, but I need to find the description somehow, which for that code should be "Professional." I could make the mapping in the query, but I'd rather not hardcode anything, and I don't even know what all the mappings should be so I'd probably miss something. I don't see anything in the per_jobs_f table, or the per_jobs_f_tl

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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