HDL to Update Assignment Status Type ID — 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

HDL to Update Assignment Status Type ID

Summary:

Update Assignment Status from "Inactive - Payroll Eligible" to "Inactive - No Payroll" where Job = "CONVERSION"

From per_all_assignments_m need to update ASSIGNMENT_STATUS_TYPE_ID = 4:

ASSIGNMENT_ID

PERSON_ID

ASSIGNMENT_TYPE

ASSIGNMENT_NUMBER

ASSIGNMENT_STATUS_TYPE_ID

ACTION_CODE

ASSIGNMENT_NAME

ASSIGNMENT_STATUS_TYPE

PERSON_TYPE_ID

SYSTEM_PERSON_TYPE

PERIOD_OF_SERVICE_ID

ACTION_OCCURRENCE_ID

EFFECTIVE_START_DATE

EFFECTIVE_END_DATE

300000009461075

1000000058XXXXX

C

C141424

2

HIRE

Conversion

ACTIVE

300000009184746

CWK

100000005847844

300000009461053

2021/08/30

2022/01/22

300000009461075

1000000058XXXXX

C

C141424

3

BHC_CW_TERM

Conversion

INACTIVE

300000009184746

CWK

100000005847844

300000023907686

2022/01/23

4712/12/31

300000009461061

1000000058XXXXX

CT

CT141424

2

HIRE

CT141424

ACTIVE

300000009184746

CWK

100000005847844

300000009461053

2021/08/30

2022/01/22

300000009461061

1000000058XXXXX

CT

CT141424

3

BHC_CW_TERM

CT141424

INACTIVE

300000009184746

CWK

100000005847844

300000023907686

2022/01/23

4712/12/31

I've tried various versions of the following HDL without success.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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