[Home] [Help] [Dependency Information]
Object Name: | EDW_HR_GRD_GRADES_LTC |
---|---|
Object Type: | TABLE |
Owner: | HRI |
FND Design Data: | HRI.EDW_HR_GRD_GRADES_LTC |
Subobject Name: | |
Status: | VALID |
This is the level table for the Grade level of the Grade dimension. Grades allow you to group people with similar pay and conditions of work.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_HR_GRD_GRADES_LTC_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY | GRADE_PK_KEY |
EDW_HR_GRD_GRADES_LTC_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
GRADE_PK
GRADE_PK_KEY |
EDW_HR_GRD_GRADES_LTC_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | ALL_FK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP | VARCHAR2 | (240) | Name of the Business Group | |
GRADE_PK | VARCHAR2 | (400) | Textual Unique Identifier for the Grade Level | |
INSTANCE | VARCHAR2 | (40) | Identity of Data Source | |
NAME | VARCHAR2 | (240) | Grade name for the Grade level | |
GRADE_DP | VARCHAR2 | (240) | Reserved for future use | |
ALL_FK | VARCHAR2 | (30) | Textual Foreign Key to the All Grades Level | |
GRADE_DATE_FROM | DATE | The Start Date of the Grade | ||
GRADE_DATE_TO | DATE | The End Date of the Grade | ||
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 | |
GRADE_PK_KEY | NUMBER | Unique Warehouse Identifier for the Grade Level | ||
ALL_FK_KEY | NUMBER | Warehouse Foreign Key to the All Grades Level | ||
GRADE_ID | NUMBER | Hidden Identifier for the Grade from the data source | ||
GRADE_SEQUENCE | NUMBER | Level of the Grade in a sequence, used for ordering a list of Grades | ||
BUSINESS_GROUP_ID | NUMBER | Hidden Identifier for the Grade from the data source | ||
GRADE_DEFINITION_ID | NUMBER | Hidden Identifier for the Grade Definition from the data source |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP
, GRADE_PK
, INSTANCE
, NAME
, GRADE_DP
, ALL_FK
, GRADE_DATE_FROM
, GRADE_DATE_TO
, LAST_UPDATE_DATE
, CREATION_DATE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, GRADE_PK_KEY
, ALL_FK_KEY
, GRADE_ID
, GRADE_SEQUENCE
, BUSINESS_GROUP_ID
, GRADE_DEFINITION_ID
FROM HRI.EDW_HR_GRD_GRADES_LTC;
HRI.EDW_HR_GRD_GRADES_LTC does not reference any database object
HRI.EDW_HR_GRD_GRADES_LTC is referenced by following:
|
|
|