1. Tables and Views for HCM
  2. HRY_EVENT_CATEGORIES_VL

HRY_EVENT_CATEGORIES_VL

Details

  • Schema: FUSION

  • Object owner: HRY

  • Object type: VIEW

Columns

Name

EVENT_CATEGORY_ID

BASE_CATEGORY_NAME

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

PRIORITY

RETENTION_DAYS

LEGISLATION_CODE

LEGISLATIVE_DATA_GROUP_ID

MODULE_ID

ENTERPRISE_ID

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

SGUID

SEED_DATA_SOURCE

ORA_SEED_SET1

ORA_SEED_SET2

CATEGORY_NAME

DESCRIPTION

Query

SQL_Statement

SELECT

hry_event_categories.EVENT_CATEGORY_ID EVENT_CATEGORY_ID,

hry_event_categories.BASE_CATEGORY_NAME BASE_CATEGORY_NAME,

hry_event_categories.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

hry_event_categories.ATTRIBUTE1 ATTRIBUTE1,

hry_event_categories.ATTRIBUTE2 ATTRIBUTE2,

hry_event_categories.ATTRIBUTE3 ATTRIBUTE3,

hry_event_categories.ATTRIBUTE4 ATTRIBUTE4,

hry_event_categories.ATTRIBUTE5 ATTRIBUTE5,

hry_event_categories.ATTRIBUTE6 ATTRIBUTE6,

hry_event_categories.ATTRIBUTE7 ATTRIBUTE7,

hry_event_categories.ATTRIBUTE8 ATTRIBUTE8,

hry_event_categories.ATTRIBUTE9 ATTRIBUTE9,

hry_event_categories.ATTRIBUTE10 ATTRIBUTE10,

hry_event_categories.PRIORITY PRIORITY,

hry_event_categories.RETENTION_DAYS RETENTION_DAYS,

hry_event_categories.LEGISLATION_CODE LEGISLATION_CODE,

hry_event_categories.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID,

hry_event_categories.MODULE_ID MODULE_ID,

hry_event_categories.ENTERPRISE_ID ENTERPRISE_ID,

hry_event_categories.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

hry_event_categories.CREATED_BY CREATED_BY,

hry_event_categories.CREATION_DATE CREATION_DATE,

hry_event_categories.LAST_UPDATED_BY LAST_UPDATED_BY,

hry_event_categories.LAST_UPDATE_DATE LAST_UPDATE_DATE,

hry_event_categories.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

hry_event_categories.SGUID SGUID,

hry_event_categories.SEED_DATA_SOURCE SEED_DATA_SOURCE,

hry_event_categories.ORA_SEED_SET1 ORA_SEED_SET1,

hry_event_categories.ORA_SEED_SET2 ORA_SEED_SET2,

hry_event_categories_tl.CATEGORY_NAME CATEGORY_NAME,

hry_event_categories_tl.DESCRIPTION DESCRIPTION

FROM

hry_event_categories,

hry_event_categories_tl

WHERE

hry_event_categories.EVENT_CATEGORY_ID = hry_event_categories_tl.EVENT_CATEGORY_ID AND hry_event_categories_tl.LANGUAGE = USERENV('LANG')