What's new in Customer Journeys?

Connect and learn more! ×
How to inactivate the Other Classifications for a Department using 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

How to inactivate the Other Classifications for a Department using HDL

Received Response
77
Views
13
Comments

Summary:

How to inactivate the Other Classifications for a Department using HDL

Content (required):

I tried using the HDL to make the other classification as inactive but it's loading successfully but still display the same in the UI.


HDL:

METADATA|OrgUnitClassification|OrganizationId|OrgUnitClassificationId|EffectiveStartDate|EffectiveEndDate|Status

MERGE|OrgUnitClassification|300000006651769|300000007346934|2023/04/01||I

MERGE|OrgUnitClassification|300000006651769|300000007346931|2023/04/01||I



Code used to fetch the Organization Id and Organization Unit Classification ID.


select

hrorg.ORGANIZATION_ID orgid,

hrorgtl.NAME orgname,

houc.ORG_UNIT_CLASSIFICATION_ID orgunitclass,

hoctl.classification_name Orgunitclassificationname,

hoctl.CLASSIFICATION_CODE orgunitclasscode

from

hr_all_organization_units_f hrorg,

   hr_organization_units_f_tl hrorgtl,

   hr_org_unit_classifications_f houc,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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