HWR_INCENTIVE

Details

Schema: FUSION
Object owner: HWR
Object type: VIEW

Columns

Name
REWARD_STATUS_ID STATUS DUE_DATE CREATION_DATE COMMENT_TEXT REWARD_ID REWARD_NAME REWARD_DESCRIPTION VALUE UNIT MAX_NO_RECIPIENTS PROGRAM_TYPE PROGRAM_ID PROGRAM_NAME PROGRAM_DESCRIPTION PARTICIPANT_TYPE PARTICIPANT_ID PARTICIPANT_NAME PARTICIPANT_USER_ID

Name

REWARD_STATUS_ID

STATUS

DUE_DATE

CREATION_DATE

COMMENT_TEXT

REWARD_ID

REWARD_NAME

REWARD_DESCRIPTION

VALUE

UNIT

MAX_NO_RECIPIENTS

PROGRAM_TYPE

PROGRAM_ID

PROGRAM_NAME

PROGRAM_DESCRIPTION

PARTICIPANT_TYPE

PARTICIPANT_ID

PARTICIPANT_NAME

PARTICIPANT_USER_ID

Query

SQL_Statement
SELECT RS.REWARD_STATUS_ID, RS.STATUS, RS.DUE_DATE, RS.CREATION_DATE, RS.COMMENT_TEXT, R.REWARD_ID, R.NAME AS REWARD_NAME, R.DESCRIPTION AS REWARD_DESCRIPTION, R.VALUE, R.UNIT, R.MAX_NO_RECIPIENTS, 'CONTEST' AS PROGRAM_TYPE, C.CONTEST_ID AS PROGRAM_ID, C.NAME AS PROGRAM_NAME, C.DESCRIPTION AS PROGRAM_DESCRIPTION, 'INDIVIDUAL' AS PARTICIPANT_TYPE, I.CONTEST_PARTICIPANT_ID AS PARTICIPANT_ID, I.NAME AS PARTICIPANT_NAME, I.USER_ID AS PARTICIPANT_USER_ID FROM HWR_REWARD_STATUS RS, HWR_CNST_CNST_PAR_XREF X, HWR_CNST_B C, HWR_CNST_PAR_IND_B I, HWR_CNST_REWARD_B R WHERE RS.REWARD_STATUS_ID = X.REWARD_STATUS_ID AND X.CONTEST_PARTICIPANT_ID = I.CONTEST_PARTICIPANT_ID AND X.CONTEST_ID = C.CONTEST_ID AND RS.REWARD_ID = R.REWARD_ID UNION SELECT RS.REWARD_STATUS_ID, RS.STATUS, RS.DUE_DATE, RS.CREATION_DATE, RS.COMMENT_TEXT, R.REWARD_ID, R.NAME AS REWARD_NAME, R.DESCRIPTION AS REWARD_DESCRIPTION, R.VALUE, R.UNIT, R.MAX_NO_RECIPIENTS, 'GOAL' AS PROGRAM_TYPE, G.GOAL_ID AS PROGRAM_ID, G.GOAL_NAME AS PROGRAM_NAME, '' AS PROGRAM_DESCRIPTION, 'INDIVIDUAL' AS PARTICIPANT_TYPE, I.CONTEST_PARTICIPANT_ID AS PARTICIPANT_ID, I.NAME AS PARTICIPANT_NAME, I.USER_ID AS PARTICIPANT_USER_ID FROM HWR_REWARD_STATUS RS, HWR_GOAL_USER_XREF X, HWR_GOAL_F G, HWR_CNST_REWARD_B R, HWR_CNST_PAR_IND_B I WHERE RS.REWARD_STATUS_ID = X.REWARD_STATUS_ID AND X.GOAL_ID = G.GOAL_ID AND RS.REWARD_ID = R.REWARD_ID AND X.USER_ID = I.USER_ID UNION SELECT RS.REWARD_STATUS_ID, RS.STATUS, RS.DUE_DATE, RS.CREATION_DATE, RS.COMMENT_TEXT, R.REWARD_ID, R.NAME AS REWARD_NAME, R.DESCRIPTION AS REWARD_DESCRIPTION, R.VALUE, R.UNIT, R.MAX_NO_RECIPIENTS, 'TASK' AS PROGRAM_TYPE, G.TASK_ID AS PROGRAM_ID, G.TITLE AS PROGRAM_NAME, '' AS PROGRAM_DESCRIPTION, 'INDIVIDUAL' AS PARTICIPANT_TYPE, I.CONTEST_PARTICIPANT_ID AS PARTICIPANT_ID, I.NAME AS PARTICIPANT_NAME, I.USER_ID AS PARTICIPANT_USER_ID FROM HWR_REWARD_STATUS RS, HWR_WLNS_TASKS_XREF X, HWR_WLNS_TASKS_VL G, HWR_CNST_REWARD_B R, HWR_CNST_PAR_IND_B I WHERE RS.REWARD_STATUS_ID = X.REWARD_STATUS_ID AND X.TASK_ID = G.TASK_ID AND RS.REWARD_ID = R.REWARD_ID AND X.USER_ID = I.USER_ID ORDER BY CREATION_DATE DESC

SQL_Statement

SELECT RS.REWARD_STATUS_ID,

RS.STATUS,

RS.DUE_DATE,

RS.CREATION_DATE,

RS.COMMENT_TEXT,

R.REWARD_ID,

R.NAME AS REWARD_NAME,

R.DESCRIPTION AS REWARD_DESCRIPTION,

R.VALUE,

R.UNIT,

R.MAX_NO_RECIPIENTS,

'CONTEST' AS PROGRAM_TYPE,

C.CONTEST_ID AS PROGRAM_ID,

C.NAME AS PROGRAM_NAME,

C.DESCRIPTION AS PROGRAM_DESCRIPTION,

'INDIVIDUAL' AS PARTICIPANT_TYPE,

I.CONTEST_PARTICIPANT_ID AS PARTICIPANT_ID,

I.NAME AS PARTICIPANT_NAME,

I.USER_ID AS PARTICIPANT_USER_ID

FROM HWR_REWARD_STATUS RS,

HWR_CNST_CNST_PAR_XREF X,

HWR_CNST_B C,

HWR_CNST_PAR_IND_B I,

HWR_CNST_REWARD_B R

WHERE RS.REWARD_STATUS_ID = X.REWARD_STATUS_ID

AND X.CONTEST_PARTICIPANT_ID = I.CONTEST_PARTICIPANT_ID

AND X.CONTEST_ID = C.CONTEST_ID

AND RS.REWARD_ID = R.REWARD_ID

UNION

SELECT RS.REWARD_STATUS_ID,

RS.STATUS,

RS.DUE_DATE,

RS.CREATION_DATE,

RS.COMMENT_TEXT,

R.REWARD_ID,

R.NAME AS REWARD_NAME,

R.DESCRIPTION AS REWARD_DESCRIPTION,

R.VALUE,

R.UNIT,

R.MAX_NO_RECIPIENTS,

'GOAL' AS PROGRAM_TYPE,

G.GOAL_ID AS PROGRAM_ID,

G.GOAL_NAME AS PROGRAM_NAME,

'' AS PROGRAM_DESCRIPTION,

'INDIVIDUAL' AS PARTICIPANT_TYPE,

I.CONTEST_PARTICIPANT_ID AS PARTICIPANT_ID,

I.NAME AS PARTICIPANT_NAME,

I.USER_ID AS PARTICIPANT_USER_ID

FROM HWR_REWARD_STATUS RS,

HWR_GOAL_USER_XREF X,

HWR_GOAL_F G,

HWR_CNST_REWARD_B R,

HWR_CNST_PAR_IND_B I

WHERE RS.REWARD_STATUS_ID = X.REWARD_STATUS_ID

AND X.GOAL_ID = G.GOAL_ID

AND RS.REWARD_ID = R.REWARD_ID

AND X.USER_ID = I.USER_ID

UNION

SELECT RS.REWARD_STATUS_ID,

RS.STATUS,

RS.DUE_DATE,

RS.CREATION_DATE,

RS.COMMENT_TEXT,

R.REWARD_ID,

R.NAME AS REWARD_NAME,

R.DESCRIPTION AS REWARD_DESCRIPTION,

R.VALUE,

R.UNIT,

R.MAX_NO_RECIPIENTS,

'TASK' AS PROGRAM_TYPE,

G.TASK_ID AS PROGRAM_ID,

G.TITLE AS PROGRAM_NAME,

'' AS PROGRAM_DESCRIPTION,

'INDIVIDUAL' AS PARTICIPANT_TYPE,

I.CONTEST_PARTICIPANT_ID AS PARTICIPANT_ID,

I.NAME AS PARTICIPANT_NAME,

I.USER_ID AS PARTICIPANT_USER_ID

FROM HWR_REWARD_STATUS RS,

HWR_WLNS_TASKS_XREF X,

HWR_WLNS_TASKS_VL G,

HWR_CNST_REWARD_B R,

HWR_CNST_PAR_IND_B I

WHERE RS.REWARD_STATUS_ID = X.REWARD_STATUS_ID

AND X.TASK_ID = G.TASK_ID

AND RS.REWARD_ID = R.REWARD_ID

AND X.USER_ID = I.USER_ID

ORDER BY CREATION_DATE DESC