VIEW: PJI.PJI_RM_RES_F#

Source

View Text - Preformatted

select CAPACITY_HRS CAPACITY_HRS, TOTAL_HRS_A TOTAL_HRS_A, MISSING_HRS_A MISSING_HRS_A, TOTAL_WTD_ORG_HRS_A TOTAL_WTD_ORG_HRS_A, TOTAL_WTD_RES_HRS_A TOTAL_WTD_RES_HRS_A, BILL_HRS_A BILL_HRS_A, BILL_WTD_ORG_HRS_A BILL_WTD_ORG_HRS_A, BILL_WTD_RES_HRS_A BILL_WTD_RES_HRS_A, TRAINING_HRS_A TRAINING_HRS_A, UNASSIGNED_HRS_A UNASSIGNED_HRS_A, REDUCE_CAPACITY_HRS_A REDUCE_CAPACITY_HRS_A, CONF_HRS_S CONF_HRS_S, CONF_WTD_ORG_HRS_S CONF_WTD_ORG_HRS_S, CONF_WTD_RES_HRS_S CONF_WTD_RES_HRS_S, CONF_BILL_HRS_S CONF_BILL_HRS_S, CONF_BILL_WTD_ORG_HRS_S CONF_BILL_WTD_ORG_HRS_S, CONF_BILL_WTD_RES_HRS_S CONF_BILL_WTD_RES_HRS_S, PROV_HRS_S PROV_HRS_S, PROV_WTD_ORG_HRS_S PROV_WTD_ORG_HRS_S, PROV_WTD_RES_HRS_S PROV_WTD_RES_HRS_S, PROV_BILL_HRS_S PROV_BILL_HRS_S, PROV_BILL_WTD_ORG_HRS_S PROV_BILL_WTD_ORG_HRS_S, PROV_BILL_WTD_RES_HRS_S PROV_BILL_WTD_RES_HRS_S, TRAINING_HRS_S TRAINING_HRS_S, UNASSIGNED_HRS_S UNASSIGNED_HRS_S, REDUCE_CAPACITY_HRS_S REDUCE_CAPACITY_HRS_S, CONF_OVERCOM_HRS_S CONF_OVERCOM_HRS_S, PROV_OVERCOM_HRS_S PROV_OVERCOM_HRS_S, AVAILABLE_HRS_BKT1_S AVAILABLE_HRS_BKT1_S, AVAILABLE_HRS_BKT2_S AVAILABLE_HRS_BKT2_S, AVAILABLE_HRS_BKT3_S AVAILABLE_HRS_BKT3_S, AVAILABLE_HRS_BKT4_S AVAILABLE_HRS_BKT4_S, AVAILABLE_HRS_BKT5_S AVAILABLE_HRS_BKT5_S, AVAILABLE_RES_COUNT_BKT1_S AVAILABLE_RES_COUNT_BKT1_S, AVAILABLE_RES_COUNT_BKT2_S AVAILABLE_RES_COUNT_BKT2_S, AVAILABLE_RES_COUNT_BKT3_S AVAILABLE_RES_COUNT_BKT3_S, AVAILABLE_RES_COUNT_BKT4_S AVAILABLE_RES_COUNT_BKT4_S, AVAILABLE_RES_COUNT_BKT5_S AVAILABLE_RES_COUNT_BKT5_S, TOTAL_RES_COUNT TOTAL_RES_COUNT, PERIOD_TYPE_ID PERIOD_TYPE_ID, CALENDAR_TYPE CALENDAR_TYPE, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID, TIME_ID TIME_ID, PERSON_ID PERSON_ID, JOB_ID JOB_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REDUCIBLE_CAPACITY_HRS_A REDUCIBLE_CAPACITY_HRS_A, REDUCIBLE_CAPACITY_HRS_S REDUCIBLE_CAPACITY_HRS_S from "PJI"."PJI_RM_RES_F"

View Text - HTML Formatted

SELECT CAPACITY_HRS CAPACITY_HRS
, TOTAL_HRS_A TOTAL_HRS_A
, MISSING_HRS_A MISSING_HRS_A
, TOTAL_WTD_ORG_HRS_A TOTAL_WTD_ORG_HRS_A
, TOTAL_WTD_RES_HRS_A TOTAL_WTD_RES_HRS_A
, BILL_HRS_A BILL_HRS_A
, BILL_WTD_ORG_HRS_A BILL_WTD_ORG_HRS_A
, BILL_WTD_RES_HRS_A BILL_WTD_RES_HRS_A
, TRAINING_HRS_A TRAINING_HRS_A
, UNASSIGNED_HRS_A UNASSIGNED_HRS_A
, REDUCE_CAPACITY_HRS_A REDUCE_CAPACITY_HRS_A
, CONF_HRS_S CONF_HRS_S
, CONF_WTD_ORG_HRS_S CONF_WTD_ORG_HRS_S
, CONF_WTD_RES_HRS_S CONF_WTD_RES_HRS_S
, CONF_BILL_HRS_S CONF_BILL_HRS_S
, CONF_BILL_WTD_ORG_HRS_S CONF_BILL_WTD_ORG_HRS_S
, CONF_BILL_WTD_RES_HRS_S CONF_BILL_WTD_RES_HRS_S
, PROV_HRS_S PROV_HRS_S
, PROV_WTD_ORG_HRS_S PROV_WTD_ORG_HRS_S
, PROV_WTD_RES_HRS_S PROV_WTD_RES_HRS_S
, PROV_BILL_HRS_S PROV_BILL_HRS_S
, PROV_BILL_WTD_ORG_HRS_S PROV_BILL_WTD_ORG_HRS_S
, PROV_BILL_WTD_RES_HRS_S PROV_BILL_WTD_RES_HRS_S
, TRAINING_HRS_S TRAINING_HRS_S
, UNASSIGNED_HRS_S UNASSIGNED_HRS_S
, REDUCE_CAPACITY_HRS_S REDUCE_CAPACITY_HRS_S
, CONF_OVERCOM_HRS_S CONF_OVERCOM_HRS_S
, PROV_OVERCOM_HRS_S PROV_OVERCOM_HRS_S
, AVAILABLE_HRS_BKT1_S AVAILABLE_HRS_BKT1_S
, AVAILABLE_HRS_BKT2_S AVAILABLE_HRS_BKT2_S
, AVAILABLE_HRS_BKT3_S AVAILABLE_HRS_BKT3_S
, AVAILABLE_HRS_BKT4_S AVAILABLE_HRS_BKT4_S
, AVAILABLE_HRS_BKT5_S AVAILABLE_HRS_BKT5_S
, AVAILABLE_RES_COUNT_BKT1_S AVAILABLE_RES_COUNT_BKT1_S
, AVAILABLE_RES_COUNT_BKT2_S AVAILABLE_RES_COUNT_BKT2_S
, AVAILABLE_RES_COUNT_BKT3_S AVAILABLE_RES_COUNT_BKT3_S
, AVAILABLE_RES_COUNT_BKT4_S AVAILABLE_RES_COUNT_BKT4_S
, AVAILABLE_RES_COUNT_BKT5_S AVAILABLE_RES_COUNT_BKT5_S
, TOTAL_RES_COUNT TOTAL_RES_COUNT
, PERIOD_TYPE_ID PERIOD_TYPE_ID
, CALENDAR_TYPE CALENDAR_TYPE
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID
, TIME_ID TIME_ID
, PERSON_ID PERSON_ID
, JOB_ID JOB_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REDUCIBLE_CAPACITY_HRS_A REDUCIBLE_CAPACITY_HRS_A
, REDUCIBLE_CAPACITY_HRS_S REDUCIBLE_CAPACITY_HRS_S
FROM "PJI"."PJI_RM_RES_F"