[Home] [Help] [Dependency Information]
Object Name: | IRC_APL_PROFILE_SNAPSHOTS |
---|---|
Object Type: | TABLE |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Table to store the profile snapshots of applicants in iRecruitment for Applicant Tracking functionality. It captures the snapshot of an applicant each time, the profile is updated. If the profile is updated multiple times in a day, only the latest spanshot is saved for that day.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000445673C00003$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
IRC_APL_PROFILE_SNAPSHOTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PERSON_ID |
IRC_APL_PROFILE_SNAPSHOTS_PK | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PROFILE_SNAPSHOT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROFILE_SNAPSHOT_ID | NUMBER | (15) | Yes | Primary key |
PERSON_ID | NUMBER | (15) | Person Id of the applicant | |
PROFILE_INFO | CLOB | (4000) | Profile Snapshot in an XML format | |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | System-generated version of row. Increments by one with each update |
Cut, paste (and edit) the following text to query this object:
SELECT PROFILE_SNAPSHOT_ID
, PERSON_ID
, PROFILE_INFO
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM HR.IRC_APL_PROFILE_SNAPSHOTS;
HR.IRC_APL_PROFILE_SNAPSHOTS does not reference any database object
HR.IRC_APL_PROFILE_SNAPSHOTS is referenced by following:
|
|
|