HWM_RP_TM_PERIODS

Details

Schema: FUSION
Object owner: HXT
Object type: VIEW

Columns

Name
REPEATING_TM_PERIOD_ID OBJECT_VERSION_NUMBER NAME DESCRIPTION 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 ATTENDANCE_TRACKING_USAGE SGUID

Name

REPEATING_TM_PERIOD_ID

OBJECT_VERSION_NUMBER

NAME

DESCRIPTION

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

ATTENDANCE_TRACKING_USAGE

SGUID

Query

SQL_Statement
SELECT HWM_RP_TM_PERIODS_B.REPEATING_TM_PERIOD_ID REPEATING_TM_PERIOD_ID, HWM_RP_TM_PERIODS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, HWM_RP_TM_PERIODS_TL.NAME NAME, HWM_RP_TM_PERIODS_TL.DESCRIPTION DESCRIPTION, HWM_RP_TM_PERIODS_B.PERIOD_CLASS PERIOD_CLASS, HWM_RP_TM_PERIODS_B.PERIOD_TYPE PERIOD_TYPE, HWM_RP_TM_PERIODS_B.PERIOD_START_DATE PERIOD_START_DATE, HWM_RP_TM_PERIODS_B.MULTIPLE MULTIPLE, HWM_RP_TM_PERIODS_B.MONTH_TYPE MONTH_TYPE, HWM_RP_TM_PERIODS_B.ONE_OR_MANY ONE_OR_MANY, HWM_RP_TM_PERIODS_B.PERIOD_LENGTH PERIOD_LENGTH, HWM_RP_TM_PERIODS_B.REFERENCE_DATE REFERENCE_DATE, HWM_RP_TM_PERIODS_B.RULE_USAGE RULE_USAGE, HWM_RP_TM_PERIODS_B.TIME_ENTRY_USAGE TIME_ENTRY_USAGE, HWM_RP_TM_PERIODS_B.APPROVAL_USAGE APPROVAL_USAGE, HWM_RP_TM_PERIODS_B.MODULE_ID MODULE_ID, HWM_RP_TM_PERIODS_B.ENTERPRISE_ID ENTERPRISE_ID, HWM_RP_TM_PERIODS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, HWM_RP_TM_PERIODS_B.LAST_UPDATED_BY LAST_UPDATED_BY, HWM_RP_TM_PERIODS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, HWM_RP_TM_PERIODS_B.CREATED_BY CREATED_BY, HWM_RP_TM_PERIODS_B.CREATION_DATE CREATION_DATE, HWM_RP_TM_PERIODS_B.WEEK_TYPE WEEK_TYPE, HWM_RP_TM_PERIODS_B.PERIOD_CD PERIOD_CD, HWM_RP_TM_PERIODS_B.ACCRUAL_USAGE ACCRUAL_USAGE, HWM_RP_TM_PERIODS_B.BALANCE_USAGE BALANCE_USAGE, HWM_RP_TM_PERIODS_B.OVERTIME_USAGE OVERTIME_USAGE, HWM_RP_TM_PERIODS_B.ATTENDANCE_TRACKING_USAGE ATTENDANCE_TRACKING_USAGE, HWM_RP_TM_PERIODS_B.SGUID SGUID FROM HWM_RP_TM_PERIODS_B, HWM_RP_TM_PERIODS_TL WHERE HWM_RP_TM_PERIODS_B.REPEATING_TM_PERIOD_ID = HWM_RP_TM_PERIODS_TL.REPEATING_TM_PERIOD_ID AND HWM_RP_TM_PERIODS_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

HWM_RP_TM_PERIODS_B.REPEATING_TM_PERIOD_ID REPEATING_TM_PERIOD_ID,

HWM_RP_TM_PERIODS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

HWM_RP_TM_PERIODS_TL.NAME NAME,

HWM_RP_TM_PERIODS_TL.DESCRIPTION DESCRIPTION,

HWM_RP_TM_PERIODS_B.PERIOD_CLASS PERIOD_CLASS,

HWM_RP_TM_PERIODS_B.PERIOD_TYPE PERIOD_TYPE,

HWM_RP_TM_PERIODS_B.PERIOD_START_DATE PERIOD_START_DATE,

HWM_RP_TM_PERIODS_B.MULTIPLE MULTIPLE,

HWM_RP_TM_PERIODS_B.MONTH_TYPE MONTH_TYPE,

HWM_RP_TM_PERIODS_B.ONE_OR_MANY ONE_OR_MANY,

HWM_RP_TM_PERIODS_B.PERIOD_LENGTH PERIOD_LENGTH,

HWM_RP_TM_PERIODS_B.REFERENCE_DATE REFERENCE_DATE,

HWM_RP_TM_PERIODS_B.RULE_USAGE RULE_USAGE,

HWM_RP_TM_PERIODS_B.TIME_ENTRY_USAGE TIME_ENTRY_USAGE,

HWM_RP_TM_PERIODS_B.APPROVAL_USAGE APPROVAL_USAGE,

HWM_RP_TM_PERIODS_B.MODULE_ID MODULE_ID,

HWM_RP_TM_PERIODS_B.ENTERPRISE_ID ENTERPRISE_ID,

HWM_RP_TM_PERIODS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

HWM_RP_TM_PERIODS_B.LAST_UPDATED_BY LAST_UPDATED_BY,

HWM_RP_TM_PERIODS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

HWM_RP_TM_PERIODS_B.CREATED_BY CREATED_BY,

HWM_RP_TM_PERIODS_B.CREATION_DATE CREATION_DATE,

HWM_RP_TM_PERIODS_B.WEEK_TYPE WEEK_TYPE,

HWM_RP_TM_PERIODS_B.PERIOD_CD PERIOD_CD,

HWM_RP_TM_PERIODS_B.ACCRUAL_USAGE ACCRUAL_USAGE,

HWM_RP_TM_PERIODS_B.BALANCE_USAGE BALANCE_USAGE,

HWM_RP_TM_PERIODS_B.OVERTIME_USAGE OVERTIME_USAGE,

HWM_RP_TM_PERIODS_B.ATTENDANCE_TRACKING_USAGE ATTENDANCE_TRACKING_USAGE,

HWM_RP_TM_PERIODS_B.SGUID SGUID

FROM

HWM_RP_TM_PERIODS_B,

HWM_RP_TM_PERIODS_TL

WHERE

HWM_RP_TM_PERIODS_B.REPEATING_TM_PERIOD_ID = HWM_RP_TM_PERIODS_TL.REPEATING_TM_PERIOD_ID AND HWM_RP_TM_PERIODS_TL.LANGUAGE = USERENV('LANG')