SELECT DISTINCT
TO_CHAR(creation_dt,’MM/DD/YYYY’) “Date of Creation”,
first_names “First Name”, surname “Last Name”,
Section_Name “SSO ID”,
(CASE WHEN Authority_id = ‘LEAD1’ THEN ‘Reconciler’
WHEN Authority_id = ‘LEADREV’ THEN ‘Reviewer’
WHEN Authority_id = ‘LEADRR’ THEN ‘Reconciler/Reviewer’
WHEN Authority_id = ‘LEADADMN’ THEN ‘Administrator’
WHEN Authority_id = ‘LEAD1’ THEN ‘Reconciler’
WHEN Authority_id = ‘LEADVIEW’ THEN ‘Browser’
WHEN Authority_id = ‘LEADCRE’ THEN ‘CREAdmin’
WHEN Authority_id = ‘LEADCS’ THEN ‘CSAdmin’ END) “User Role”,
(CASE WHEN user_status = 1 THEN ‘ACTIVE’
WHEN user_status = 2 THEN ‘INACTIVE’END) “Status”, user_id “Hex Id”
FROM usrr
WHERE user_id!=’SETUP’ AND user_id NOT LIKE ‘LEAD%’
