1. Tables and Views for HCM
  2. HWM_TM_REP_S_HXT_ATRBS_V

HWM_TM_REP_S_HXT_ATRBS_V

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: VIEW

Columns

Name

HXT_TIME_REPOS_ATRB_ID

HXT_ATTRIBUTE_CATEGORY

EXPEDITE

OVERRIDE_PAY_METHOD

OVERRIDE_CHECK_PRINTER

HXT_RESOLVED_PERIOD_ID

HXT_DAY

USAGES_SOURCE_ID

USAGES_SOURCE_VERSION

Query

SQL_Statement

SELECT HxtAtrbs.tm_rep_atrb_id Hxt_Time_Repos_Atrb_Id,

HxtAtrbs.attribute_category Hxt_attribute_category,

HxtAtrbs.attribute_varchar3 EXPEDITE,

HxtAtrbs.attribute_varchar4 OVERRIDE_PAY_METHOD,

HxtAtrbs.attribute_varchar5 OVERRIDE_CHECK_PRINTER,

HxtAtrbs.attribute_number1 Hxt_Resolved_Period_Id,

HxtAtrbs.attribute_varchar2 Hxt_Day,

HxtAtrbsUsg.usages_source_id,

HxtAtrbsUsg.usages_source_version

FROM hwm_tm_rep_atrbs HxtAtrbs, hwm_tm_rep_atrb_usages HxtAtrbsUsg

WHERE HxtAtrbs.tm_rep_atrb_id = HxtAtrbsUsg.tm_rep_atrb_id

and HxtAtrbs.attribute_category = 'HXT'