DBA Data[Home] [Help] [Dependency Information]

TABLE: PSP.PSP_EFF_REPORT_DETAILS

Object Details
Object Name: PSP_EFF_REPORT_DETAILS
Object Type: TABLE
Owner: PSP
FND Design Data: TablePSP.PSP_EFF_REPORT_DETAILS
Subobject Name:
Status: VALID


Contains assorted details by charging account for a given effort report


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PSP_EFF_REPORT_DETAILS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEFFORT_REPORT_DETAIL_ID
PSP_EFF_REPORT_DETAILS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEFFORT_REPORT_ID
Columns
Name Datatype Length Mandatory Comments
EFFORT_REPORT_DETAIL_ID NUMBER (15) Yes Effort report detail identifier
EFFORT_REPORT_ID NUMBER (15) Yes Foreign key for PSP_EFF_REPORTS
OBJECT_VERSION_NUMBER NUMBER (9) Yes Object version number
ASSIGNMENT_ID NUMBER (15)
Assignment id
ASSIGNMENT_NUMBER VARCHAR2 (30)
Assignment Number
GL_SUM_CRITERIA_SEGMENT_NAME VARCHAR2 (2000)
Stores GL Code Combination Value depending on the ER Summarization Criteria
GL_SEGMENT1 VARCHAR2 (25)
DFF Segment
GL_SEGMENT2 VARCHAR2 (25)
DFF Segment
GL_SEGMENT3 VARCHAR2 (25)
DFF Segment
GL_SEGMENT4 VARCHAR2 (25)
DFF Segment
GL_SEGMENT5 VARCHAR2 (25)
DFF Segment
GL_SEGMENT6 VARCHAR2 (25)
DFF Segment
GL_SEGMENT7 VARCHAR2 (25)
DFF Segment
GL_SEGMENT8 VARCHAR2 (25)
DFF Segment
GL_SEGMENT9 VARCHAR2 (25)
DFF Segment
GL_SEGMENT10 VARCHAR2 (25)
DFF Segment
GL_SEGMENT11 VARCHAR2 (25)
DFF Segment
GL_SEGMENT12 VARCHAR2 (25)
DFF Segment
GL_SEGMENT13 VARCHAR2 (25)
DFF Segment
GL_SEGMENT14 VARCHAR2 (25)
DFF Segment
GL_SEGMENT15 VARCHAR2 (25)
DFF Segment
GL_SEGMENT16 VARCHAR2 (25)
DFF Segment
GL_SEGMENT17 VARCHAR2 (25)
DFF Segment
GL_SEGMENT18 VARCHAR2 (25)
DFF Segment
GL_SEGMENT19 VARCHAR2 (25)
DFF Segment
GL_SEGMENT20 VARCHAR2 (25)
DFF Segment
GL_SEGMENT21 VARCHAR2 (25)
DFF Segment
GL_SEGMENT22 VARCHAR2 (25)
DFF Segment
GL_SEGMENT23 VARCHAR2 (25)
DFF Segment
GL_SEGMENT24 VARCHAR2 (25)
DFF Segment
GL_SEGMENT25 VARCHAR2 (25)
DFF Segment
GL_SEGMENT26 VARCHAR2 (25)
DFF Segment
GL_SEGMENT27 VARCHAR2 (25)
DFF Segment
GL_SEGMENT28 VARCHAR2 (25)
DFF Segment
GL_SEGMENT29 VARCHAR2 (25)
DFF Segment
GL_SEGMENT30 VARCHAR2 (25)
DFF Segment
PROJECT_ID NUMBER (15)
Project Id
PROJECT_NUMBER VARCHAR2 (25)
Project Number
PROJECT_NAME VARCHAR2 (30)
Stroes Project Name of respective project
EXPENDITURE_ORGANIZATION_ID NUMBER (15)
Exp Org Identifier
EXP_ORG_NAME VARCHAR2 (240)
Exp Org Name
EXPENDITURE_TYPE VARCHAR2 (30)
Expenditure Type
TASK_ID NUMBER (15)
Task Identifier
TASK_NUMBER VARCHAR2 (25)
Task Number
TASK_NAME VARCHAR2 (30)
Stores Task Name of respective Task
AWARD_ID NUMBER (15)
Award identifier
AWARD_NUMBER VARCHAR2 (240)
Award Number
AWARD_SHORT_NAME VARCHAR2 (30)
Stores Award Short Name of respective Award
ACTUAL_SALARY_AMT NUMBER
Yes Actual Salary Amount
PAYROLL_PERCENT NUMBER
Yes Payroll Percent
PROPOSED_SALARY_AMT NUMBER

Proposed salary amount
PROPOSED_EFFORT_PERCENT NUMBER

Proposed effort percent
COMMITTED_COST_SHARE NUMBER

committed cost share
SCHEDULE_START_DATE DATE

Schedule start date
SCHEDULE_END_DATE DATE

Schedule end date
AME_TRANSACTION_ID VARCHAR2 (50)
AME Transaction identifier
INVESTIGATOR_NAME VARCHAR2 (240)
Stores the Name of Award Principal Investigator / Project Manager / Task Manager
INVESTIGATOR_PERSON_ID NUMBER (15)
Stores Investigator Person Id
INVESTIGATOR_ORG_NAME VARCHAR2 (240)
Stores Investigator Primary Organization Name
INVESTIGATOR_PRIMARY_ORG_ID NUMBER (15)
Stores Investigator Primary Organization Id
VALUE1 NUMBER

Stores Additional Number Value
VALUE2 NUMBER

Stores Additional Number Value
VALUE3 NUMBER

Stores Additional Number Value
VALUE4 NUMBER

Stores Additional Number Value
VALUE5 NUMBER

Stores Additional Number Value
VALUE6 NUMBER

Stores Additional Number Value
VALUE7 NUMBER

Stores Additional Number Value
VALUE8 NUMBER

Stores Additional Number Value
VALUE9 NUMBER

Stores Additional Number Value
VALUE10 NUMBER

Stores Additional Number Value
ATTRIBUTE1 VARCHAR2 (1000)
Stores Additional Attribute Value
ATTRIBUTE2 VARCHAR2 (1000)
Stores Additional Attribute Value
ATTRIBUTE3 VARCHAR2 (1000)
Stores Additional Attribute Value
ATTRIBUTE4 VARCHAR2 (1000)
Stores Additional Attribute Value
ATTRIBUTE5 VARCHAR2 (1000)
Stores Additional Attribute Value
ATTRIBUTE6 VARCHAR2 (1000)
Stores Additional Attribute Value
ATTRIBUTE7 VARCHAR2 (1000)
Stores Additional Attribute Value
ATTRIBUTE8 VARCHAR2 (1000)
Stores Additional Attribute Value
ATTRIBUTE9 VARCHAR2 (1000)
Stores Additional Attribute Value
ATTRIBUTE10 VARCHAR2 (1000)
Stores Additional Attribute Value
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who Column
GROUPING_CATEGORY VARCHAR2 (30)
Records grouping category
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EFFORT_REPORT_DETAIL_ID
,      EFFORT_REPORT_ID
,      OBJECT_VERSION_NUMBER
,      ASSIGNMENT_ID
,      ASSIGNMENT_NUMBER
,      GL_SUM_CRITERIA_SEGMENT_NAME
,      GL_SEGMENT1
,      GL_SEGMENT2
,      GL_SEGMENT3
,      GL_SEGMENT4
,      GL_SEGMENT5
,      GL_SEGMENT6
,      GL_SEGMENT7
,      GL_SEGMENT8
,      GL_SEGMENT9
,      GL_SEGMENT10
,      GL_SEGMENT11
,      GL_SEGMENT12
,      GL_SEGMENT13
,      GL_SEGMENT14
,      GL_SEGMENT15
,      GL_SEGMENT16
,      GL_SEGMENT17
,      GL_SEGMENT18
,      GL_SEGMENT19
,      GL_SEGMENT20
,      GL_SEGMENT21
,      GL_SEGMENT22
,      GL_SEGMENT23
,      GL_SEGMENT24
,      GL_SEGMENT25
,      GL_SEGMENT26
,      GL_SEGMENT27
,      GL_SEGMENT28
,      GL_SEGMENT29
,      GL_SEGMENT30
,      PROJECT_ID
,      PROJECT_NUMBER
,      PROJECT_NAME
,      EXPENDITURE_ORGANIZATION_ID
,      EXP_ORG_NAME
,      EXPENDITURE_TYPE
,      TASK_ID
,      TASK_NUMBER
,      TASK_NAME
,      AWARD_ID
,      AWARD_NUMBER
,      AWARD_SHORT_NAME
,      ACTUAL_SALARY_AMT
,      PAYROLL_PERCENT
,      PROPOSED_SALARY_AMT
,      PROPOSED_EFFORT_PERCENT
,      COMMITTED_COST_SHARE
,      SCHEDULE_START_DATE
,      SCHEDULE_END_DATE
,      AME_TRANSACTION_ID
,      INVESTIGATOR_NAME
,      INVESTIGATOR_PERSON_ID
,      INVESTIGATOR_ORG_NAME
,      INVESTIGATOR_PRIMARY_ORG_ID
,      VALUE1
,      VALUE2
,      VALUE3
,      VALUE4
,      VALUE5
,      VALUE6
,      VALUE7
,      VALUE8
,      VALUE9
,      VALUE10
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      GROUPING_CATEGORY
FROM PSP.PSP_EFF_REPORT_DETAILS;

Dependencies

[top of page]

PSP.PSP_EFF_REPORT_DETAILS does not reference any database object

PSP.PSP_EFF_REPORT_DETAILS is referenced by following:

SchemaPSP
ViewPSP_EFF_REPORT_DETAILS#