"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'