"You need to enter a valid value for the JobLegId attribute." on JobLegislative HDL — 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

"You need to enter a valid value for the JobLegId attribute." on JobLegislative HDL

Hello,

I am attempting an HDL and getting this error message in the upload:

You need to enter a valid value for the JobLegId attribute. The current values are 300000007457959,JobLegislative.

Here is a line from the HDL:

METADATA

JobLegislative

EFF_CATEGORY_CODE

FLEX:PER_JOBS_LEG_EFF

JobId

JobLegId

JobCode

SetCode

EffectiveStartDate

EffectiveEndDate

GUID

standardOccupationalClassifica(PER_JOBS_LEG_EFF=HRX_US_JOBS)

MERGE

JobLegislative

JOB_LEG

HRX_US_JOBS

300000007457959

300000130238991

70371

COMMON

2000/01/01

4712/12/31

2E619A6FD5603FDCE053A427480AAFCD

25-0000

The effective start date matches the date of the topmost row of the jobcode.

My SQL to get the JobLegId is here:

SELECT JOB.JOB_ID,JOB.EFFECTIVE_START_DATE,LEG.JOB_LEG_ID,INT.GUID FROM PER_JOBS_F JOB LEFT JOIN HRC_INTEGRATION_KEY_MAP INT ON INT.SURROGATE_ID = JOB.JOB_ID LEFT JOIN PER_JOB_LEG_F LEG ON LEG.JOB_ID = JOB.JOB_ID WHERE JOB.JOB_CODE = '70371'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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