HRR_DASHBOARD_TMPLS_VL

Details

• Schema: FUSION

• Object owner: HRR

• Object type: VIEW

Columns

Name

DASHBOARD_TMPL_ID BUSINESS_GROUP_ID SET_ID NAME TMPL_STATUS_CODE OWNER_ID DISPLAY_RISK_OF_LOSS DISPLAY_IMPACT_OF_LOSS DISPLAY_MOBILITY DISPLAY_GENDER DISPLAY_AGE USE_NOTES_FLAG DISPLAY_ETHNICITY DISPLAY_RELIGIOUS_AFFLTN DISPLAY_COMMENTS INCLUDE_SUCCESSION_PLANS INCLUDE_TALENT_POOLS INCLUDE_MATRIX_MGMT FILTER_SUCCESSION_PLAN FILTER_TALENT_POOL FILTER_JOBROLE_ASSGN FILTER_LOCATION FILTER_JOBGRADE FILTER_ORG_HIERARCHY FILTER_REVWR_PARTCPNT FILTER_LEVEL FILTER_COMPETENCY FILTER_PROFICIENCY FILTER_BUSINESSUNIT FILTER_JOB_FUNCTION FILTER_JOB_FAMILY FILTER_MGMT_LEVEL COLOR_JOBROLE_ASSGN COLOR_LOCATION COLOR_ORG_HIERARCHY USE_TASKS_FLAG USE_COMPARE_FLAG USE_ORGCHART_FLAG USE_POT_ASSESS_FLAG CREATE_GOALS_FLAG USE_HOLDING_AREA_FLAG MAX_MARKERS_ALLOWED MODULE_ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30 OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER11 ATTRIBUTE_NUMBER12 ATTRIBUTE_NUMBER13 ATTRIBUTE_NUMBER14 ATTRIBUTE_NUMBER15 ATTRIBUTE_NUMBER16 ATTRIBUTE_NUMBER17 ATTRIBUTE_NUMBER18 ATTRIBUTE_NUMBER19 ATTRIBUTE_NUMBER20 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 ATTRIBUTE_DATE11 ATTRIBUTE_DATE12 ATTRIBUTE_DATE13 ATTRIBUTE_DATE14 ATTRIBUTE_DATE15 POPULATION_SIZE_FOR_ESS ROL_DSPLY_OPTN_PREF IOL_DSPLY_OPTN_PREF MOBILITY_DSPLY_OPTN_PREF FILTER_DEPARTMENT QUESTIONNAIRE_ID

Query

SQL_Statement

SELECT DT.DASHBOARD_TMPL_ID DASHBOARD_TMPL_ID, DT.BUSINESS_GROUP_ID BUSINESS_GROUP_ID, DT.SET_ID SET_ID, DTTL.NAME NAME, DT.TMPL_STATUS_CODE TMPL_STATUS_CODE, DT.OWNER_ID OWNER_ID, DT.DISPLAY_RISK_OF_LOSS DISPLAY_RISK_OF_LOSS, DT.DISPLAY_IMPACT_OF_LOSS DISPLAY_IMPACT_OF_LOSS, DT.DISPLAY_MOBILITY DISPLAY_MOBILITY, DT.DISPLAY_GENDER DISPLAY_GENDER, DT.DISPLAY_AGE DISPLAY_AGE, DT.USE_NOTES_FLAG USE_NOTES_FLAG, DT.DISPLAY_ETHNICITY DISPLAY_ETHNICITY, DT.DISPLAY_RELIGIOUS_AFFLTN DISPLAY_RELIGIOUS_AFFLTN, DT.DISPLAY_COMMENTS DISPLAY_COMMENTS, DT.INCLUDE_SUCCESSION_PLANS INCLUDE_SUCCESSION_PLANS, DT.INCLUDE_TALENT_POOLS INCLUDE_TALENT_POOLS, DT.INCLUDE_MATRIX_MGMT INCLUDE_MATRIX_MGMT, DT.FILTER_SUCCESSION_PLAN FILTER_SUCCESSION_PLAN, DT.FILTER_TALENT_POOL FILTER_TALENT_POOL, DT.FILTER_JOBROLE_ASSGN FILTER_JOBROLE_ASSGN, DT.FILTER_LOCATION FILTER_LOCATION, DT.FILTER_JOBGRADE FILTER_JOBGRADE, DT.FILTER_ORG_HIERARCHY FILTER_ORG_HIERARCHY, DT.FILTER_REVWR_PARTCPNT FILTER_REVWR_PARTCPNT, DT.FILTER_LEVEL FILTER_LEVEL, DT.FILTER_COMPETENCY FILTER_COMPETENCY, DT.FILTER_PROFICIENCY FILTER_PROFICIENCY, DT.FILTER_BUSINESSUNIT FILTER_BUSINESSUNIT, DT.FILTER_JOB_FUNCTION FILTER_JOB_FUNCTION, DT.FILTER_JOB_FAMILY FILTER_JOB_FAMILY, DT.FILTER_MGMT_LEVEL FILTER_MGMT_LEVEL, DT.COLOR_JOBROLE_ASSGN COLOR_JOBROLE_ASSGN, DT.COLOR_LOCATION COLOR_LOCATION, DT.COLOR_ORG_HIERARCHY COLOR_ORG_HIERARCHY, DT.USE_TASKS_FLAG USE_TASKS_FLAG, DT.USE_COMPARE_FLAG USE_COMPARE_FLAG, DT.USE_ORGCHART_FLAG USE_ORGCHART_FLAG, DT.USE_POT_ASSESS_FLAG USE_POT_ASSESS_FLAG, DT.CREATE_GOALS_FLAG CREATE_GOALS_FLAG, DT.USE_HOLDING_AREA_FLAG USE_HOLDING_AREA_FLAG, DT.MAX_MARKERS_ALLOWED MAX_MARKERS_ALLOWED, DT.MODULE_ID MODULE_ID, DT.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, DT.ATTRIBUTE1 ATTRIBUTE1, DT.ATTRIBUTE2 ATTRIBUTE2, DT.ATTRIBUTE3 ATTRIBUTE3, DT.ATTRIBUTE4 ATTRIBUTE4, DT.ATTRIBUTE5 ATTRIBUTE5, DT.ATTRIBUTE6 ATTRIBUTE6, DT.ATTRIBUTE7 ATTRIBUTE7, DT.ATTRIBUTE8 ATTRIBUTE8, DT.ATTRIBUTE9 ATTRIBUTE9, DT.ATTRIBUTE10 ATTRIBUTE10, DT.ATTRIBUTE11 ATTRIBUTE11, DT.ATTRIBUTE12 ATTRIBUTE12, DT.ATTRIBUTE13 ATTRIBUTE13, DT.ATTRIBUTE14 ATTRIBUTE14, DT.ATTRIBUTE15 ATTRIBUTE15, DT.ATTRIBUTE16 ATTRIBUTE16, DT.ATTRIBUTE17 ATTRIBUTE17, DT.ATTRIBUTE18 ATTRIBUTE18, DT.ATTRIBUTE19 ATTRIBUTE19, DT.ATTRIBUTE20 ATTRIBUTE20, DT.ATTRIBUTE21 ATTRIBUTE21, DT.ATTRIBUTE22 ATTRIBUTE22, DT.ATTRIBUTE23 ATTRIBUTE23, DT.ATTRIBUTE24 ATTRIBUTE24, DT.ATTRIBUTE25 ATTRIBUTE25, DT.ATTRIBUTE26 ATTRIBUTE26, DT.ATTRIBUTE27 ATTRIBUTE27, DT.ATTRIBUTE28 ATTRIBUTE28, DT.ATTRIBUTE29 ATTRIBUTE29, DT.ATTRIBUTE30 ATTRIBUTE30, DT.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, DT.CREATED_BY CREATED_BY, DT.CREATION_DATE CREATION_DATE, DT.LAST_UPDATED_BY LAST_UPDATED_BY, DT.LAST_UPDATE_DATE LAST_UPDATE_DATE, DT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DT.ATTRIBUTE_NUMBER1, DT.ATTRIBUTE_NUMBER2, DT.ATTRIBUTE_NUMBER3, DT.ATTRIBUTE_NUMBER4, DT.ATTRIBUTE_NUMBER5, DT.ATTRIBUTE_NUMBER6, DT.ATTRIBUTE_NUMBER7, DT.ATTRIBUTE_NUMBER8, DT.ATTRIBUTE_NUMBER9, DT.ATTRIBUTE_NUMBER10, DT.ATTRIBUTE_NUMBER11, DT.ATTRIBUTE_NUMBER12, DT.ATTRIBUTE_NUMBER13, DT.ATTRIBUTE_NUMBER14, DT.ATTRIBUTE_NUMBER15, DT.ATTRIBUTE_NUMBER16, DT.ATTRIBUTE_NUMBER17, DT.ATTRIBUTE_NUMBER18, DT.ATTRIBUTE_NUMBER19, DT.ATTRIBUTE_NUMBER20, DT.ATTRIBUTE_DATE1, DT.ATTRIBUTE_DATE2, DT.ATTRIBUTE_DATE3, DT.ATTRIBUTE_DATE4, DT.ATTRIBUTE_DATE5, DT.ATTRIBUTE_DATE6, DT.ATTRIBUTE_DATE7, DT.ATTRIBUTE_DATE8, DT.ATTRIBUTE_DATE9, DT.ATTRIBUTE_DATE10, DT.ATTRIBUTE_DATE11, DT.ATTRIBUTE_DATE12, DT.ATTRIBUTE_DATE13, DT.ATTRIBUTE_DATE14, DT.ATTRIBUTE_DATE15, DT.POPULATION_SIZE_FOR_ESS POPULATION_SIZE_FOR_ESS, DT.ROL_DSPLY_OPTN_PREF, DT.IOL_DSPLY_OPTN_PREF, DT.MOBILITY_DSPLY_OPTN_PREF, DT.FILTER_DEPARTMENT FILTER_DEPARTMENT, DT.QUESTIONNAIRE_ID QUESTIONNAIRE_ID FROM HRR_DASHBOARD_TMPLS_B DT, HRR_DASHBOARD_TMPLS_TL DTTL WHERE DT.DASHBOARD_TMPL_ID = DTTL.DASHBOARD_TMPL_ID AND DT.BUSINESS_GROUP_ID = DTTL.BUSINESS_GROUP_ID AND DTTL.LANGUAGE = USERENV('LANG')