[Home] [Help] [Dependency Information]
Object Name: | EDW_HR_SRVC_SRV_BAND_LTC |
---|---|
Object Type: | TABLE |
Owner: | HRI |
FND Design Data: | HRI.EDW_HR_SRVC_SRV_BAND_LTC |
Subobject Name: | |
Status: | VALID |
This is the level table for the Period of Work level of the Period of Work dimension. This stores the bands set up to group together people with similar lengths of service.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_HR_SRVC_SRV_BAND_LTC_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | SERVICE_BAND_PK_KEY |
EDW_HR_SRVC_SRV_BAND_LTC_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
SERVICE_BAND_PK
SERVICE_BAND_PK_KEY |
EDW_HR_SRVC_SRV_BAND_LTC_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | ALL_FK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SERVICE_BAND_PK | VARCHAR2 | (400) | Textual Unique Identifier for the Period of Work Band Level | |
ALL_FK | VARCHAR2 | (40) | Textual Foreign Key to the All Period of Work Bands Level | |
NAME | VARCHAR2 | (240) | Period of Work Band Name for the Period of Work Band Level | |
SERVICE_BAND_DP | VARCHAR2 | (240) | Reserved for future use | |
SERVICE_LENGTH_MAX_YEAR | NUMBER | Years component of the maximum value in the period of work band | ||
SERVICE_LENGTH_MAX_MONTH | NUMBER | Months component of the maximum value in the period of work band | ||
SERVICE_LENGTH_MAX_WEEK | NUMBER | Weeks component of the maximum value in the period of work band | ||
SERVICE_LENGTH_MAX_DAY | NUMBER | Days component of the maximum value in the period of work band | ||
SERVICE_LENGTH_MIN_YEAR | NUMBER | Years component of the minimum value in the period of work band | ||
SERVICE_LENGTH_MIN_MONTH | NUMBER | Months component of the minimum value in the period of work band | ||
SERVICE_LENGTH_MIN_WEEK | NUMBER | Weeks component of the minimum value in the period of work band | ||
SERVICE_LENGTH_MIN_DAY | NUMBER | Days component of the minimum value in the period of work band | ||
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 | |
SERVICE_BAND_PK_KEY | NUMBER | Unique Warehouse Identifier for the Period of Work Band Level | ||
ALL_FK_KEY | NUMBER | Warehouse Foreign Key to the All Period of Work Bands Level | ||
INSTANCE | VARCHAR2 | (40) | Identity of Data Source |
Cut, paste (and edit) the following text to query this object:
SELECT SERVICE_BAND_PK
, ALL_FK
, NAME
, SERVICE_BAND_DP
, SERVICE_LENGTH_MAX_YEAR
, SERVICE_LENGTH_MAX_MONTH
, SERVICE_LENGTH_MAX_WEEK
, SERVICE_LENGTH_MAX_DAY
, SERVICE_LENGTH_MIN_YEAR
, SERVICE_LENGTH_MIN_MONTH
, SERVICE_LENGTH_MIN_WEEK
, SERVICE_LENGTH_MIN_DAY
, LAST_UPDATE_DATE
, CREATION_DATE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, SERVICE_BAND_PK_KEY
, ALL_FK_KEY
, INSTANCE
FROM HRI.EDW_HR_SRVC_SRV_BAND_LTC;
HRI.EDW_HR_SRVC_SRV_BAND_LTC does not reference any database object
HRI.EDW_HR_SRVC_SRV_BAND_LTC is referenced by following:
|
|
|