VIEW: CS.CS_COVERAGES#

Source

View Text - Preformatted

select COVERAGE_ID COVERAGE_ID, 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, NAME NAME, DESCRIPTION DESCRIPTION, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, COVERAGE_LEVEL COVERAGE_LEVEL, TIME_BILLABLE_PERCENT TIME_BILLABLE_PERCENT, MAX_TIME_BILLABLE_AMOUNT MAX_TIME_BILLABLE_AMOUNT, MATERIAL_BILLABLE_PERCENT MATERIAL_BILLABLE_PERCENT, MAX_MATERIAL_BILLABLE_AMOUNT MAX_MATERIAL_BILLABLE_AMOUNT, EXPENSE_BILLABLE_PERCENT EXPENSE_BILLABLE_PERCENT, MAX_EXPENSE_BILLABLE_AMOUNT MAX_EXPENSE_BILLABLE_AMOUNT, RESPONSE_TIME_PERIOD_CODE RESPONSE_TIME_PERIOD_CODE, RESPONSE_TIME_VALUE RESPONSE_TIME_VALUE, SUNDAY_START_TIME SUNDAY_START_TIME, SUNDAY_END_TIME SUNDAY_END_TIME, MONDAY_START_TIME MONDAY_START_TIME, MONDAY_END_TIME MONDAY_END_TIME, TUESDAY_START_TIME TUESDAY_START_TIME, TUESDAY_END_TIME TUESDAY_END_TIME, WEDNESDAY_START_TIME WEDNESDAY_START_TIME, WEDNESDAY_END_TIME WEDNESDAY_END_TIME, THURSDAY_START_TIME THURSDAY_START_TIME, THURSDAY_END_TIME THURSDAY_END_TIME, FRIDAY_START_TIME FRIDAY_START_TIME, FRIDAY_END_TIME FRIDAY_END_TIME, SATURDAY_START_TIME SATURDAY_START_TIME, SATURDAY_END_TIME SATURDAY_END_TIME, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, CONTEXT CONTEXT, RENEWAL_TERMS RENEWAL_TERMS, TERMINATION_TERMS TERMINATION_TERMS, EXCEPTION_COVERAGE_ID EXCEPTION_COVERAGE_ID, COVERAGE_TEMPLATE_ID COVERAGE_TEMPLATE_ID, TEMPLATE_FLAG TEMPLATE_FLAG, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, MAX_COVERAGE_AMOUNT MAX_COVERAGE_AMOUNT, MAX_SUPPORT_COVERAGE_AMT MAX_SUPPORT_COVERAGE_AMT from "CS"."CS_COVERAGES"

View Text - HTML Formatted

SELECT COVERAGE_ID COVERAGE_ID
, 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
, NAME NAME
, DESCRIPTION DESCRIPTION
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, COVERAGE_LEVEL COVERAGE_LEVEL
, TIME_BILLABLE_PERCENT TIME_BILLABLE_PERCENT
, MAX_TIME_BILLABLE_AMOUNT MAX_TIME_BILLABLE_AMOUNT
, MATERIAL_BILLABLE_PERCENT MATERIAL_BILLABLE_PERCENT
, MAX_MATERIAL_BILLABLE_AMOUNT MAX_MATERIAL_BILLABLE_AMOUNT
, EXPENSE_BILLABLE_PERCENT EXPENSE_BILLABLE_PERCENT
, MAX_EXPENSE_BILLABLE_AMOUNT MAX_EXPENSE_BILLABLE_AMOUNT
, RESPONSE_TIME_PERIOD_CODE RESPONSE_TIME_PERIOD_CODE
, RESPONSE_TIME_VALUE RESPONSE_TIME_VALUE
, SUNDAY_START_TIME SUNDAY_START_TIME
, SUNDAY_END_TIME SUNDAY_END_TIME
, MONDAY_START_TIME MONDAY_START_TIME
, MONDAY_END_TIME MONDAY_END_TIME
, TUESDAY_START_TIME TUESDAY_START_TIME
, TUESDAY_END_TIME TUESDAY_END_TIME
, WEDNESDAY_START_TIME WEDNESDAY_START_TIME
, WEDNESDAY_END_TIME WEDNESDAY_END_TIME
, THURSDAY_START_TIME THURSDAY_START_TIME
, THURSDAY_END_TIME THURSDAY_END_TIME
, FRIDAY_START_TIME FRIDAY_START_TIME
, FRIDAY_END_TIME FRIDAY_END_TIME
, SATURDAY_START_TIME SATURDAY_START_TIME
, SATURDAY_END_TIME SATURDAY_END_TIME
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, CONTEXT CONTEXT
, RENEWAL_TERMS RENEWAL_TERMS
, TERMINATION_TERMS TERMINATION_TERMS
, EXCEPTION_COVERAGE_ID EXCEPTION_COVERAGE_ID
, COVERAGE_TEMPLATE_ID COVERAGE_TEMPLATE_ID
, TEMPLATE_FLAG TEMPLATE_FLAG
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, MAX_COVERAGE_AMOUNT MAX_COVERAGE_AMOUNT
, MAX_SUPPORT_COVERAGE_AMT MAX_SUPPORT_COVERAGE_AMT
FROM "CS"."CS_COVERAGES"