[Home] [Help] [Dependency Information]
Object Name: | EDW_HR_PSTN_POSITION_LSTG |
---|---|
Object Type: | TABLE |
Owner: | HRI |
FND Design Data: | HRI.EDW_HR_PSTN_POSITION_LSTG |
Subobject Name: | |
Status: | VALID |
This is the staging table for the Position level table. Data from multiple transactional systems is staged here for verification and cleansing, before it is loaded into the Position dimension level table.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_HR_PSTN_POSITION_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | POSITION_PK |
EDW_HR_PSTN_POSITION_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
POSITION_DEFINITION_ID | NUMBER | Hidden identifier for the Position Definition from the data source | ||
POSITION_ID | NUMBER | Hidden identifier for the Position from the data source | ||
POSITION_FROM_DATE | DATE | Start date of the Position | ||
POSITION_TO_DATE | DATE | End date of the Position | ||
PROBATION_PERIOD | NUMBER | Length of the probation period | ||
REPLACEMENT_REQUIRED | VARCHAR2 | (80) | Whether a replacement is required when the person assigned to the position is absent | |
TIME_NORMAL_START | VARCHAR2 | (5) | Normal start time for Position | |
TIME_NORMAL_FINISH | VARCHAR2 | (5) | Normal end time for Position | |
WORKING_HOURS | NUMBER | Number of normal working hours for the position | ||
WORKING_HOUR_FREQ | VARCHAR2 | (80) | Frequency of working hours | |
LAST_UPDATE_DATE | DATE | Standard who column | ||
CREATION_DATE | DATE | Standard who column | ||
USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Defined Attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Defined Attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Defined Attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Defined Attribute | |
USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Defined Attribute | |
ALL_FK | VARCHAR2 | (40) | Textual Foreign Key to the All Positions Level | |
ROW_ID | ROWID | (10) | Row identifier | |
REQUEST_ID | NUMBER | Identifier used by collection program | ||
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages | |
POSITION_PK | VARCHAR2 | (400) | Textual Unique Identifier for the Position Level | |
INSTANCE | VARCHAR2 | (40) | Identity of Data Source | |
POSITION_DP | VARCHAR2 | (530) | Reserved for future use | |
NAME | VARCHAR2 | (530) | Position Name for the Position Level | |
ORGANIZATION_ID | NUMBER | Hidden identifier for the Organization from the data source | ||
JOB_ID | NUMBER | Hidden identifier for the Job from the data source | ||
OPERATION_CODE | VARCHAR2 | (30) | Code used by the loader program to determine whether to insert/update/delete this record | |
COLLECTION_STATUS | VARCHAR2 | (30) | Loading status code for the record | |
ALL_FK_KEY | NUMBER | Warehouse Foreign Key to the All Positions Level | ||
BUSINESS_GROUP | VARCHAR2 | (240) | Business Group the Position is created in | |
BUSINESS_GROUP_ID | NUMBER | Hidden identifier for the Business Group from the data source |
Cut, paste (and edit) the following text to query this object:
SELECT POSITION_DEFINITION_ID
, POSITION_ID
, POSITION_FROM_DATE
, POSITION_TO_DATE
, PROBATION_PERIOD
, REPLACEMENT_REQUIRED
, TIME_NORMAL_START
, TIME_NORMAL_FINISH
, WORKING_HOURS
, WORKING_HOUR_FREQ
, LAST_UPDATE_DATE
, CREATION_DATE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, ALL_FK
, ROW_ID
, REQUEST_ID
, ERROR_CODE
, POSITION_PK
, INSTANCE
, POSITION_DP
, NAME
, ORGANIZATION_ID
, JOB_ID
, OPERATION_CODE
, COLLECTION_STATUS
, ALL_FK_KEY
, BUSINESS_GROUP
, BUSINESS_GROUP_ID
FROM HRI.EDW_HR_PSTN_POSITION_LSTG;
HRI.EDW_HR_PSTN_POSITION_LSTG does not reference any database object
HRI.EDW_HR_PSTN_POSITION_LSTG is referenced by following:
|
|
|