ANC_PER_ABS_ENTRIES_V

Details

  • Schema: FUSION

  • Object owner: ANC

  • Object type: VIEW

Columns

Name

PER_ABSENCE_ENTRY_ID

PERSON_ID

START_DATE

START_DATETIME

END_DATETIME

END_DATE

START_TIME

END_TIME

APPROVAL_STATUS_CD

DURATION

UOM

Query

SQL_Statement

SELECT

abs.PER_ABSENCE_ENTRY_ID,

abs.PERSON_ID,

abs.START_DATE ,

abs.START_DATETIME,

abs.END_DATETIME,

abs.END_DATE,

abs.START_TIME,

abs.END_TIME,

abs.APPROVAL_STATUS_CD,

abs.DURATION,

abs.UOM

FROM

ANC_PER_ABS_ENTRIES abs