[Home] [Help] [Dependency Information]
Object Name: | IRC_ASSIGNMENT_STATUSES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PER.IRC_ASSIGNMENT_STATUSES |
Subobject Name: | |
Status: | VALID |
This table stores information about changes to applicant assignment changes. It can store multiple status changes per day, and keeps track of the date and time that the change was made.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IRC_ASSIGNMENT_STATUSES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | ASSIGNMENT_STATUS_ID |
IRC_ASSIGNMENT_STATUSES_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ASSIGNMENT_ID |
IRC_ASSIGNMENT_STATUSES_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ASSIGNMENT_STATUS_TYPE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSIGNMENT_STATUS_ID | NUMBER | (15) | Yes | Primary Key. |
ASSIGNMENT_ID | NUMBER | (15) | Yes | The assignment that these statuses are for. |
ASSIGNMENT_STATUS_TYPE_ID | NUMBER | (15) | Yes | The assignment status. |
STATUS_CHANGE_DATE | DATE | Yes | The date and time of the status change | |
STATUS_CHANGE_REASON | VARCHAR2 | (240) | Description of why the status was updated. | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column. |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column. | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO column. |
CREATION_DATE | DATE | Yes | Standard WHO column. | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | System-generated version of row. Increments by one with each update. |
Cut, paste (and edit) the following text to query this object:
SELECT ASSIGNMENT_STATUS_ID
, ASSIGNMENT_ID
, ASSIGNMENT_STATUS_TYPE_ID
, STATUS_CHANGE_DATE
, STATUS_CHANGE_REASON
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM HR.IRC_ASSIGNMENT_STATUSES;
HR.IRC_ASSIGNMENT_STATUSES does not reference any database object
HR.IRC_ASSIGNMENT_STATUSES is referenced by following:
|
|
|