[Home] [Help] [Dependency Information]
Object Name: | PSP_REP_SCH_EMP_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PSP.PSP_REP_SCH_EMP_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERSON_ID | NUMBER | (9) | Yes | Person identifier for current schedule line |
ASSIGNMENT_ID | NUMBER | (9) | Yes | Assignment identifier for current schedule line |
FTE | NUMBER | Full-time equivalent | ||
ELEMENT_TYPE_ID | NUMBER | (9) | Earnings element identifier for current schedule line | |
ELEMENT_GROUP_ID | NUMBER | (9) | Stores the element group identifier at its scheduling level | |
SCHEDULING_TYPES_CODE | VARCHAR2 | (30) | ||
PROJECT_ID | NUMBER | (15) | Project identifier | |
TASK_ID | NUMBER | (15) | Task identifier | |
AWARD_ID | NUMBER | (15) | Award identifier | |
EXPENDITURE_ORGANIZATION_ID | NUMBER | (15) | Unique identifier for the expenditure organization to which the line is charged | |
EXPENDITURE_TYPE | VARCHAR2 | (30) | Unique identifier for the expenditure type to which the line is charged | |
GL_CODE_COMBINATION_ID | NUMBER | (15) | Account identifier | |
SCHEDULE_PERCENT | NUMBER | (5) | Percentage scheduled for current schedule line | |
SCHEDULE_BEGIN_DATE | DATE | Begin date for current schedule line | ||
SCHEDULE_END_DATE | DATE | End date for current schedule line | ||
ORGANIZATION_ID | NUMBER | (15) | Yes | Organization of person identified by PERSON_ID |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of Books identifier |
Cut, paste (and edit) the following text to query this object:
SELECT PERSON_ID
, ASSIGNMENT_ID
, FTE
, ELEMENT_TYPE_ID
, ELEMENT_GROUP_ID
, SCHEDULING_TYPES_CODE
, PROJECT_ID
, TASK_ID
, AWARD_ID
, EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_TYPE
, GL_CODE_COMBINATION_ID
, SCHEDULE_PERCENT
, SCHEDULE_BEGIN_DATE
, SCHEDULE_END_DATE
, ORGANIZATION_ID
, BUSINESS_GROUP_ID
, SET_OF_BOOKS_ID
FROM APPS.PSP_REP_SCH_EMP_V;
|
|
|