VIEW: PA.PA_COMPENSATION_DETAILS_ALL#

Source

View Text - Preformatted

select PERSON_ID PERSON_ID, COMPENSATION_RULE_SET COMPENSATION_RULE_SET, START_DATE_ACTIVE START_DATE_ACTIVE, 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, HOURLY_COST_RATE HOURLY_COST_RATE, END_DATE_ACTIVE END_DATE_ACTIVE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ORG_ID ORG_ID, OVERRIDE_TYPE OVERRIDE_TYPE, RATE_SCHEDULE_ID RATE_SCHEDULE_ID, COST_RATE_CURRENCY_CODE COST_RATE_CURRENCY_CODE, ACCT_RATE_DATE_CODE ACCT_RATE_DATE_CODE, ACCT_RATE_TYPE ACCT_RATE_TYPE, ACCT_EXCHANGE_RATE ACCT_EXCHANGE_RATE, BASE_HOURS BASE_HOURS, RBC_ELEMENT_TYPE_ID RBC_ELEMENT_TYPE_ID from "PA"."PA_COMPENSATION_DETAILS_ALL"

View Text - HTML Formatted

SELECT PERSON_ID PERSON_ID
, COMPENSATION_RULE_SET COMPENSATION_RULE_SET
, START_DATE_ACTIVE START_DATE_ACTIVE
, 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
, HOURLY_COST_RATE HOURLY_COST_RATE
, END_DATE_ACTIVE END_DATE_ACTIVE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ORG_ID ORG_ID
, OVERRIDE_TYPE OVERRIDE_TYPE
, RATE_SCHEDULE_ID RATE_SCHEDULE_ID
, COST_RATE_CURRENCY_CODE COST_RATE_CURRENCY_CODE
, ACCT_RATE_DATE_CODE ACCT_RATE_DATE_CODE
, ACCT_RATE_TYPE ACCT_RATE_TYPE
, ACCT_EXCHANGE_RATE ACCT_EXCHANGE_RATE
, BASE_HOURS BASE_HOURS
, RBC_ELEMENT_TYPE_ID RBC_ELEMENT_TYPE_ID
FROM "PA"."PA_COMPENSATION_DETAILS_ALL"