DBA Data[Home] [Help] [Dependency Information]

TABLE: HRI.HRI_MDP_SUP_ABSNC_OCC_CT

Object Details
Object Name: HRI_MDP_SUP_ABSNC_OCC_CT
Object Type: TABLE
Owner: HRI
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HRI_MDP_SUP_ABSNC_OCC_CT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnABSENCE_SK_FK
ColumnSUPERVISOR_PERSON_ID
ColumnEFFECTIVE_DATE
HRI_MDP_SUP_ABSNC_OCC_CT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUPERVISOR_PERSON_ID
ColumnEFFECTIVE_DATE
ColumnABSENCE_CATEGORY_CODE
ColumnABSENCE_REASON_CODE
Columns
Name Datatype Length Mandatory Comments
SUPERVISOR_PERSON_ID NUMBER
Yes
EFFECTIVE_DATE DATE
Yes
ABSENCE_SK_FK NUMBER
Yes
DIRECT_IND NUMBER

ABS_DRTN_DAYS NUMBER

ABS_DRTN_HRS NUMBER

ABS_START_BLNC NUMBER

ABS_NSTART_BLNC NUMBER

ABS_NTFCTN_DAYS_START_BLNC NUMBER

ABS_NTFCTN_DAYS_NSTART_BLNC NUMBER

ABSENCE_CATEGORY_CODE VARCHAR2 (30)
ABSENCE_REASON_CODE VARCHAR2 (30) Yes
ABS_PERSON_ID NUMBER
Yes
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

CREATED_BY NUMBER

CREATION_DATE DATE

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SUPERVISOR_PERSON_ID
,      EFFECTIVE_DATE
,      ABSENCE_SK_FK
,      DIRECT_IND
,      ABS_DRTN_DAYS
,      ABS_DRTN_HRS
,      ABS_START_BLNC
,      ABS_NSTART_BLNC
,      ABS_NTFCTN_DAYS_START_BLNC
,      ABS_NTFCTN_DAYS_NSTART_BLNC
,      ABSENCE_CATEGORY_CODE
,      ABSENCE_REASON_CODE
,      ABS_PERSON_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HRI.HRI_MDP_SUP_ABSNC_OCC_CT;

Dependencies

[top of page]

HRI.HRI_MDP_SUP_ABSNC_OCC_CT does not reference any database object

HRI.HRI_MDP_SUP_ABSNC_OCC_CT is referenced by following:

SchemaAPPS
Materialized ViewHRI_MDP_SUP_ABSNC_CAT_MV
SynonymHRI_MDP_SUP_ABSNC_OCC_CT
TriggerHRI_MDP_SUP_ABSNC_OCC_CT_WHO