[Home] [Help] [Dependency Information]
Object Name: | HZ_WORK_CLASS |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_WORK_CLASS |
Subobject Name: | |
Status: | VALID |
The HZ_WORK_CLASS table stores custom-defined classification information about a person's job title and work experience. For example, one system may use classifications such as "Electrician" and "Master" while another may use job codes and seniority indicators such as "EM3" and "over 20" to indicate a class 3 Master Electrician with over 20 years of experience. Note that there may be multiple records in the HZ_WORK_CLASS table for each record in the HZ_EMPLOYMENT_HISTORY table.
.
The primary key for this table is WORK_CLASS_ID.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_WORK_CLASS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | WORK_CLASS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORK_CLASS_ID | NUMBER | (15) | Yes | Unique identifier for this class of work |
LEVEL_OF_EXPERIENCE | VARCHAR2 | (60) | User-defined rating for the level of experience in this class of work. For example, journeyman, trainee, or exposure | |
WORK_CLASS_NAME | VARCHAR2 | (240) | Yes | User-determined classification for work. For example, bricklayer, doctor, lawer, programmer, or minister of health. |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
EMPLOYMENT_HISTORY_ID | NUMBER | (15) | Yes | Foreign key to the HZ_EMPLOYMENT_HISTORY table |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
WH_UPDATE_DATE | DATE | Date when the record was entered or changed in a data warehouse | ||
STATUS | VARCHAR2 | (1) | Record status flag | |
OBJECT_VERSION_NUMBER | NUMBER | Version number for locking purposes | ||
APPLICATION_ID | NUMBER | (15) | Unique identifier for the application that created this record | |
CREATED_BY_MODULE | VARCHAR2 | (150) | Identifier for the source application module that created this record |
Cut, paste (and edit) the following text to query this object:
SELECT WORK_CLASS_ID
, LEVEL_OF_EXPERIENCE
, WORK_CLASS_NAME
, CREATED_BY
, EMPLOYMENT_HISTORY_ID
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, WH_UPDATE_DATE
, STATUS
, OBJECT_VERSION_NUMBER
, APPLICATION_ID
, CREATED_BY_MODULE
FROM AR.HZ_WORK_CLASS;
AR.HZ_WORK_CLASS does not reference any database object
AR.HZ_WORK_CLASS is referenced by following:
|
|
|