VIEW: PSP.PSP_EFF_REPORT_DETAILS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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