CSO_USER_INFORMATION_RO_V

Details

• Schema: FUSION

• Object owner: CSO

• Object type: VIEW

Columns

Name
RECORD_ID FIRST_NAME LAST_NAME EMAIL ACTIVE STATUS PER_USERS_ACTIVE_FLAG PER_USERS_SUSPENDED LOGIN ADMIN_USER EXTERNAL_TYPE IS_DEFAULT_ADMINISTRATOR OWNER_SITE_ID TYPE_LOOKUP_CODE_ID ALIAS CREATED_BY DATE_ADDED DATE_MODIFIED DEFAULT_SUB_SITE_ID EXTERNAL_ID LAST_UPDATED_BY LOCALE_ID LOOKUP_CODE_ID PDIT_CHALLENGE RECEIVE_ASSIGNED RECEIVE_PERFORM REPUTATION_POINTS SUBSCRIPTION_SCHEDULE USER_LEVEL

Query

SQL_Statement

SELECT fau.RECORD_ID as RECORD_ID, fau.FIRST_NAME as FIRST_NAME, fau.LAST_NAME as LAST_NAME, fau.EMAIL as EMAIL, fau.ACTIVE, fau.STATUS AS STATUS, fau.PER_USERS_ACTIVE_FLAG, fau.PER_USERS_SUSPENDED, fau.LOGIN AS LOGIN, fau.ADMIN_USER, fau.EXTERNAL_TYPE, fau.IS_DEFAULT_ADMINISTRATOR, fau.OWNER_SITE_ID, fau.TYPE_LOOKUP_CODE_ID, ui.ALIAS, ui.CREATED_BY, ui.DATE_ADDED, ui.DATE_MODIFIED, ui.DEFAULT_SUB_SITE_ID, ui.EXTERNAL_ID, ui.LAST_UPDATED_BY, ui.LOCALE_ID, ui.LOOKUP_CODE_ID, ui.PDIT_CHALLENGE, ui.RECEIVE_ASSIGNED, ui.RECEIVE_PERFORM, ui.REPUTATION_POINTS, ui.SUBSCRIPTION_SCHEDULE, ui.USER_LEVEL FROM CSO_FA_USER_RO_V fau LEFT OUTER JOIN CSO_USER_ATTRIBUTES_V ui ON fau.RECORD_ID = ui.RECORD_ID