[Home] [Help] [Dependency Information]
Object Name: | PQH_FR_VALIDATION_PERIODS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PQH.PQH_FR_VALIDATION_PERIODS |
Subobject Name: | |
Status: | VALID |
Table that keeps the period details for a particular validation of an individual
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PQH_FR_VALIDATION_PERIODS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | VALIDATION_PERIOD_ID |
PQH_FR_VALIDATION_PERIODS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | VALIDATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VALIDATION_PERIOD_ID | NUMBER | (15) | Yes | System-generated Primary Key Column |
VALIDATION_ID | NUMBER | (15) | Yes | Reference to the Validation concerned |
START_DATE | DATE | Start Date of the Period | ||
END_DATE | DATE | End Date of the Period | ||
PREVIOUS_EMPLOYER_ID | NUMBER | (15) | Previous Employer Name | |
NORMAL_HOURS | NUMBER | (22) | Working Hours Unit | |
FREQUENCY | VARCHAR2 | (30) | Working Hours Frequency | |
PERIOD_YEARS | NUMBER | (2) | Period in Years | |
PERIOD_MONTHS | NUMBER | (2) | Period in Months | |
PERIOD_DAYS | NUMBER | (3) | Period in Days | |
COMMENTS | VARCHAR2 | (2000) | Comments/ Reasons | |
VALIDATION_STATUS | VARCHAR2 | (30) | Validation Status (Validated / Impossible to validate) | |
ASSIGNMENT_CATEGORY | VARCHAR2 | (30) | Assignment Category, i.e Full time etc | |
LAST_UPDATE_DATE | DATE | Standard WHO Column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
CREATED_BY | NUMBER | (15) | Standard WHO Column | |
CREATION_DATE | DATE | Standard WHO Column | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Object Version Number |
Cut, paste (and edit) the following text to query this object:
SELECT VALIDATION_PERIOD_ID
, VALIDATION_ID
, START_DATE
, END_DATE
, PREVIOUS_EMPLOYER_ID
, NORMAL_HOURS
, FREQUENCY
, PERIOD_YEARS
, PERIOD_MONTHS
, PERIOD_DAYS
, COMMENTS
, VALIDATION_STATUS
, ASSIGNMENT_CATEGORY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM HR.PQH_FR_VALIDATION_PERIODS;
HR.PQH_FR_VALIDATION_PERIODS does not reference any database object
HR.PQH_FR_VALIDATION_PERIODS is referenced by following:
|
|
|