PER_PS_ANA_PROP_ASG_END_V

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name
PERSON_ID ASSIGNMENT_ID TEXT_TITLE TEXT_METRIC TEXT_META BADGE_TEXT BADGE_STATUS PERIOD_CHN_IND_VAL PERIOD_CHN_IND_CMP CHART_TYPE CHART_COLOR CHART_DATA LINK_TEXT

Query

SQL_Statement

SELECT /* ORA_PER_PS_ANA_PROP_ASG_END */ asg.person_id person_id, asg.assignment_id assignment_id, '{"strKey":"HdrSProposedassignmentend"}' text_title, hrl_df_util.date_to_char(asg.projected_assignment_end) text_metric, decode(trunc(asg.projected_assignment_end - trunc(sysdate)), 0, '{"strKey":"PgHIEndstoday"}', 1, '{"strKey":"PgHIEndstomorrow"}', '{"strKey":"PgHIEndinginDAYSNUMdays", "tokens":{"DAYS_NUM":"' ||(trunc(asg.projected_assignment_end - trunc(sysdate))) || '"}}') text_meta, decode(sign((asg.projected_assignment_end - trunc(sysdate)) - 8), - 1, 'Info', NULL) badge_text, decode(sign((asg.projected_assignment_end - trunc(sysdate)) - 8), - 1, 'info', NULL) badge_status, NULL period_chn_ind_val, NULL period_chn_ind_cmp, NULL chart_type, NULL chart_color, NULL chart_data, '?pAssignmentId=' || asg.assignment_id link_text FROM per_all_assignments_m asg WHERE asg.assignment_type IN ( 'E', 'C', 'N', 'P' ) AND trunc(sysdate) BETWEEN asg.effective_start_date AND asg.effective_end_date AND asg.projected_assignment_end >= trunc(sysdate) AND asg.effective_latest_change = 'Y' AND trunc(asg.projected_assignment_end - trunc(sysdate)) BETWEEN 0 AND 30