HDL Assignment Update -- Bullk Update the Hourly Salaried Code

Summary

HDL Assignment Update -- Bullk Update the Hourly Salaried Code

Content

Hi,

I had a requirement where i needed to update the hourly salaried code on assignment.

Please find the sql's for the same.

select 'METADATA|Assignment|AssignmentNumber|WorkTermsAssignmentId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|ActionCode|ReasonCode|PersonNumber|HourlySalariedCode'
from dual
union all
SELECT  ('MERGE|Assignment|'
        || a.assignment_number
        || '|'
        || a.work_terms_assignment_id
        || '|'
        || to_char(A.effective_start_date,'YYYY/MM/DD')
        || '|'
        ||to_char(A.effective_end_date,'YYYY/MM/DD')
        || '|'
        || a.effective_sequence
        || '|'
        || a.effective_latest_change
        || '|'