HWR_PER_PROFILE_VL

Details

• Schema: FUSION

• Object owner: HWR

• Object type: VIEW

Columns

Name

PRFL_ID SOURCE_ID FIRST_NAME MIDDLE_NAME LAST_NAME ALIAS GENDER_CODE EMAIL IS_ACTIVE_FLAG RESUME_URL IMAGE_URL ABOUT_ME ASSOCIATIONS CURRENT_STATUS DNA_CHECKSUM GEEKCODE HEADLINE HONORS INDUSTRY INTERESTS LANGUAGES MYERS_BRIGG NICKNAME PERSONAL_URL PLAN SKILLS SPECIALTIES TITLE PROFILE_REPO PROFILE_TYPE URL USER_ID USERNAME USER_GUID USER_DISTINGUISHED_NAME MULTITENANCY_USERNAME CAREER_STATEMENT JOB_NAME COMPANY_NAME STREET_ADDRESS PHONE CREATED_BY CREATION_DATE LAST_UPDATE_LOGIN LAST_UPDATED_BY LAST_UPDATE_DATE

Query

SQL_Statement

SELECT B.PRFL_ID, B.SOURCE_ID, B.FIRST_NAME, B.MIDDLE_NAME, B.LAST_NAME, B.ALIAS, B.GENDER_CODE, B.EMAIL, B.IS_ACTIVE_FLAG, B.RESUME_URL, B.IMAGE_URL, B.ABOUT_ME, B.ASSOCIATIONS, B.CURRENT_STATUS, B.DNA_CHECKSUM, B.GEEKCODE, B.HEADLINE, B.HONORS, B.INDUSTRY, B.INTERESTS, B.LANGUAGES, B.MYERS_BRIGG, B.NICKNAME, B.PERSONAL_URL, B.PLAN, B.SKILLS, B.SPECIALTIES, B.TITLE, B.PROFILE_REPO, B.PROFILE_TYPE, B.URL, B.USER_ID, B.USERNAME, B.USER_GUID, B.USER_DISTINGUISHED_NAME, B.MULTITENANCY_USERNAME, B.CAREER_STATEMENT, B.JOB_NAME, B.COMPANY_NAME, T.STREET_ADDRESS, T.PHONE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATE_LOGIN, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE FROM HWR_PER_PROFILE_B B, HWR_PER_PROFILE_TL T WHERE B.PRFL_ID = T.PRFL_ID AND B.SOURCE_ID = T.SOURCE_ID AND T.LANGUAGE = USERENV('LANG')