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

TABLE: HRI.HRI_MD_CMNTS_ACTLS_CT

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


This table holds the data related to the budget and the actuals.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
EFFECTIVE_START_DATE DATE
Yes Effective Start Date
EFFECTIVE_END_DATE DATE
Yes Effective End Date
ASSIGNMENT_ID NUMBER (15)
Assignment Id of the person
ORGANIZATION_ID NUMBER (15)
Organization Id
JOB_ID NUMBER (15)
Job id of the person
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 Key FlexField
COMMITMENT_VALUE NUMBER

Commitment Value
ACTUAL_VALUE NUMBER

Actual Value obtained
CURRENCY_CODE VARCHAR2 (30)
Currency code
CREATED_BY NUMBER (15) Yes Person information who created the table
CREATION_DATE DATE
Yes Date information on which the table is created
LAST_UPDATE_DATE DATE

Date the table date is last updated
LAST_UPDATED_BY NUMBER (15)
Person information who last updated the data
LAST_UPDATE_LOGIN NUMBER (15)
Login information of the person who last updated
Query Text

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


SELECT EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      ASSIGNMENT_ID
,      ORGANIZATION_ID
,      JOB_ID
,      POSITION_ID
,      GRADE_ID
,      ELEMENT_TYPE_ID
,      INPUT_VALUE_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      COMMITMENT_VALUE
,      ACTUAL_VALUE
,      CURRENCY_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM HRI.HRI_MD_CMNTS_ACTLS_CT;

Dependencies

[top of page]

HRI.HRI_MD_CMNTS_ACTLS_CT does not reference any database object

HRI.HRI_MD_CMNTS_ACTLS_CT is referenced by following:

SchemaHRI
ViewHRI_MD_CMNTS_ACTLS_CT#