[Home] [Help] [Dependency Information]
Object Name: | EDW_HR_GRD_GRADES_LSTG |
---|---|
Object Type: | TABLE |
Owner: | HRI |
FND Design Data: | HRI.EDW_HR_GRD_GRADES_LSTG |
Subobject Name: | |
Status: | VALID |
This is the staging table for the Grade level table. Data from multiple transactional systems is staged here for verification and cleansing, before it is loaded into the Grade dimension level table.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_HR_GRD_GRADES_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | GRADE_PK |
EDW_HR_GRD_GRADES_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ALL_FK_KEY | NUMBER | Warehouse Foreign Key to the All Grades 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 | |
BUSINESS_GROUP | VARCHAR2 | (240) | Name of the Business Group | |
BUSINESS_GROUP_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 | ||
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 | (40) | 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 | |
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 | |
GRADE_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 ALL_FK_KEY
, ROW_ID
, REQUEST_ID
, ERROR_CODE
, BUSINESS_GROUP
, BUSINESS_GROUP_ID
, GRADE_SEQUENCE
, 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
, OPERATION_CODE
, COLLECTION_STATUS
, GRADE_ID
, GRADE_DEFINITION_ID
FROM HRI.EDW_HR_GRD_GRADES_LSTG;
HRI.EDW_HR_GRD_GRADES_LSTG does not reference any database object
HRI.EDW_HR_GRD_GRADES_LSTG is referenced by following:
|
|
|