VIEW: CSM.CSF_M_USER_INQ#

Source

View Text - Preformatted

select CLID$$CS CLID$$CS, USER_ID USER_ID, USER_NAME USER_NAME, RESOURCE_ID RESOURCE_ID, CLIENT_NUMBER CLIENT_NUMBER, LANGUAGE#1 LANGUAGE, ORG_ID ORG_ID, LAST_SYNC_DATE_START LAST_SYNC_DATE_START, LAST_SYNC_DATE_END LAST_SYNC_DATE_END, FIRST_NAME FIRST_NAME, LAST_NAME LAST_NAME, FULL_NAME FULL_NAME, RESPONSIBILITY_ID RESPONSIBILITY_ID, MIGRATION_COMPLETED MIGRATION_COMPLETED, MIGRATION_COMPLETED_DATE MIGRATION_COMPLETED_DATE, MIGRATION_COMPLETION_VERSION MIGRATION_COMPLETION_VERSION, PARTY_ID PARTY_ID, DMLTYPE$$ DMLTYPE$$, SEQNO$$ SEQNO$$, TRANID$$ TRANID$$, VERSION$$ VERSION$$, ROLE_NAME ROLE_NAME, ROLE_TYPE ROLE_TYPE, GROUP_ID GROUP_ID, IN_CURRENT_GROUP IN_CURRENT_GROUP, PRIMARY_USER PRIMARY_USER from "CSM"."CSF_M_USER_INQ"

View Text - HTML Formatted

SELECT CLID$$CS CLID$$CS
, USER_ID USER_ID
, USER_NAME USER_NAME
, RESOURCE_ID RESOURCE_ID
, CLIENT_NUMBER CLIENT_NUMBER
, LANGUAGE#1 LANGUAGE
, ORG_ID ORG_ID
, LAST_SYNC_DATE_START LAST_SYNC_DATE_START
, LAST_SYNC_DATE_END LAST_SYNC_DATE_END
, FIRST_NAME FIRST_NAME
, LAST_NAME LAST_NAME
, FULL_NAME FULL_NAME
, RESPONSIBILITY_ID RESPONSIBILITY_ID
, MIGRATION_COMPLETED MIGRATION_COMPLETED
, MIGRATION_COMPLETED_DATE MIGRATION_COMPLETED_DATE
, MIGRATION_COMPLETION_VERSION MIGRATION_COMPLETION_VERSION
, PARTY_ID PARTY_ID
, DMLTYPE$$ DMLTYPE$$
, SEQNO$$ SEQNO$$
, TRANID$$ TRANID$$
, VERSION$$ VERSION$$
, ROLE_NAME ROLE_NAME
, ROLE_TYPE ROLE_TYPE
, GROUP_ID GROUP_ID
, IN_CURRENT_GROUP IN_CURRENT_GROUP
, PRIMARY_USER PRIMARY_USER
FROM "CSM"."CSF_M_USER_INQ"