[Home] [Help] [Dependency Information]
Object Name: | PSP_EFFORT_ERRORS |
---|---|
Object Type: | TABLE |
Owner: | PSP |
FND Design Data: | PSP.PSP_EFFORT_ERRORS |
Subobject Name: | |
Status: | VALID |
PSP_EFFORT_ERRORS contains the details of the Warning Report for the
employees who already have an effort report produced for the requested
time period.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PSP_EFFORT_ERRORS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TEMPLATE_ID
PERSON_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TEMPLATE_ID | NUMBER | (9) | Yes | Primary key of PSP_EFFORT_REPORT_TEMPLATES |
PERSON_ID | NUMBER | (9) | Yes | Person identifier number from Human Resources |
MESSAGE | VARCHAR2 | (255) | Description of error | |
PREV_EFFORT_REPORT_ID | NUMBER | (9) | Effort report identifier of the already existing effort report for the employee | |
PREV_VERSION_NUM | NUMBER | (2) | Version number of the already existing effort report for an employee |
Cut, paste (and edit) the following text to query this object:
SELECT TEMPLATE_ID
, PERSON_ID
, MESSAGE
, PREV_EFFORT_REPORT_ID
, PREV_VERSION_NUM
FROM PSP.PSP_EFFORT_ERRORS;
PSP.PSP_EFFORT_ERRORS does not reference any database object
PSP.PSP_EFFORT_ERRORS is referenced by following:
|
|
|