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

TABLE: HRI.HRI_MB_ACTLS_CT

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


This table stores the data related to the budgets and actuals


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HRI_MB_ACTLS_CT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnHRI_MB_ACTLS_CT_ID
HRI_MB_ACTLS_CT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_ID
ColumnEFFECTIVE_DATE
ColumnELEMENT_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
HRI_MB_ACTLS_CT_ID NUMBER (15) Yes HRI_MB_ACTLS_CT_ID
EFFECTIVE_DATE DATE
Yes EFFECTIVE_DATE
DATE_EARNED DATE

DATE_EARNED
ASSIGNMENT_ID NUMBER (15)
ASSIGNMENT_ID
ORGANIZATION_ID NUMBER (15)
ORGANIZATION_ID
JOB_ID NUMBER (15)
JOB_ID
POSITION_ID NUMBER (15)
POSITION_ID
GRADE_ID NUMBER (15)
GRADE_ID
ELEMENT_TYPE_ID NUMBER (15)
ELEMENT_TYPE_ID
INPUT_VALUE_ID NUMBER (15)
INPUT_VALUE_ID
COST_ALLOCATION_KEYFLEX_ID NUMBER (15)
COST_ALLOCATION_KEYFLEX_ID
ACTUAL_VALUE NUMBER

ACTUAL_VALUE
CURRENCY_CODE VARCHAR2 (30)
CURRENCY_CODE
CREATED_BY NUMBER (15) Yes CREATED_BY
CREATION_DATE DATE
Yes CREATION_DATE
LAST_UPDATE_DATE DATE

LAST_UPDATE_DATE
LAST_UPDATED_BY NUMBER (15)
LAST_UPDATED_BY
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_LOGIN
Query Text

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


SELECT HRI_MB_ACTLS_CT_ID
,      EFFECTIVE_DATE
,      DATE_EARNED
,      ASSIGNMENT_ID
,      ORGANIZATION_ID
,      JOB_ID
,      POSITION_ID
,      GRADE_ID
,      ELEMENT_TYPE_ID
,      INPUT_VALUE_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      ACTUAL_VALUE
,      CURRENCY_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM HRI.HRI_MB_ACTLS_CT;

Dependencies

[top of page]

HRI.HRI_MB_ACTLS_CT does not reference any database object

HRI.HRI_MB_ACTLS_CT is referenced by following:

SchemaHRI
ViewHRI_MB_ACTLS_CT#