Skip to content

Instantly share code, notes, and snippets.

@accasey

accasey/update_comp_rate.sql

Created February 16, 2018 14:51
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save accasey/4232a1fc6bae397d243ddbc1e4fe9ae8 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save accasey/4232a1fc6bae397d243ddbc1e4fe9ae8 to your computer and use it in GitHub Desktop.
Download ZIP
Update compensation
Raw
update_comp_rate.sql
UPDATE PS_COMPENSATION SET COMPRATE = 1000.00, CONVERT_COMPRT = 1000, CHANGE_AMT = 100
/
UPDATE PS_JOB SET COMPRATE = 1000, CHANGE_AMT = 1, CHANGE_PCT =1 , ANNUAL_RT = 1000, MONTHLY_RT = 100, DAILY_RT = 10, HOURLY_RT = 1
/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment