1. Tables and Views for HCM
  2. HWM_RP_TM_PRD_RESOLVED_V

HWM_RP_TM_PRD_RESOLVED_V

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: VIEW

Columns

Name

RESOLVED_TM_PERIOD_ID

OBJECT_VERSION_NUMBER

REPEATING_TM_PERIOD_ID

START_DATE_TIME

END_DATE_TIME

START_DATE_TRUNC

END_DATE_TRUNC

PERIOD_NAME

PERIOD_CLASS

PERIOD_TYPE

PERIOD_START_DATE

MULTIPLE

MONTH_TYPE

ONE_OR_MANY

PERIOD_LENGTH

REFERENCE_DATE

RULE_USAGE

TIME_ENTRY_USAGE

APPROVAL_USAGE

MODULE_ID

ENTERPRISE_ID

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATED_BY

CREATION_DATE

WEEK_TYPE

PERIOD_CD

ACCRUAL_USAGE

BALANCE_USAGE

OVERTIME_USAGE

Query

SQL_Statement

SELECT res.RESOLVED_TM_PERIOD_ID,

res.OBJECT_VERSION_NUMBER,

res.REPEATING_TM_PERIOD_ID,

res.START_DATE START_DATE_TIME ,

res.END_DATE END_DATE_TIME ,

trunc(res.START_DATE) Start_Date_TRUNC ,

trunc(res.END_DATE) End_Date_TRUNC ,

pd.NAME PERIOD_name ,

pd.PERIOD_CLASS,

pd.PERIOD_TYPE,

pd.PERIOD_START_DATE,

pd.MULTIPLE,

pd.MONTH_TYPE,

pd.ONE_OR_MANY,

pd.PERIOD_LENGTH,

pd.REFERENCE_DATE,

pd.RULE_USAGE,

pd.TIME_ENTRY_USAGE,

pd.APPROVAL_USAGE,

pd.MODULE_ID,

pd.ENTERPRISE_ID,

pd.LAST_UPDATE_DATE,

pd.LAST_UPDATED_BY,

pd.LAST_UPDATE_LOGIN,

pd.CREATED_BY,

pd.CREATION_DATE,

pd.WEEK_TYPE,

pd.PERIOD_CD,

pd.ACCRUAL_USAGE,

pd.BALANCE_USAGE,

pd.OVERTIME_USAGE

FROM HWM_RP_TM_RESOLVED res , HWM_RP_TM_periods_vl pd

where res.repeating_tm_period_id = pd.repeating_tm_period_id