VIEW: PJI.PJI_RM_AGGR_RES5#

Source

View Text - Preformatted

select WORKER_ID WORKER_ID, CAPACITY_HRS CAPACITY_HRS, TOTAL_HRS_A TOTAL_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, REDUCIBLE_CAPACITY_HRS_A REDUCIBLE_CAPACITY_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, REDUCIBLE_CAPACITY_HRS_S REDUCIBLE_CAPACITY_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, MISSING_HRS_A MISSING_HRS_A, 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, GL_CALENDAR_ID GL_CALENDAR_ID, PA_CALENDAR_ID PA_CALENDAR_ID from "PJI"."PJI_RM_AGGR_RES5"

View Text - HTML Formatted

SELECT WORKER_ID WORKER_ID
, CAPACITY_HRS CAPACITY_HRS
, TOTAL_HRS_A TOTAL_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
, REDUCIBLE_CAPACITY_HRS_A REDUCIBLE_CAPACITY_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
, REDUCIBLE_CAPACITY_HRS_S REDUCIBLE_CAPACITY_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
, MISSING_HRS_A MISSING_HRS_A
, 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
, GL_CALENDAR_ID GL_CALENDAR_ID
, PA_CALENDAR_ID PA_CALENDAR_ID
FROM "PJI"."PJI_RM_AGGR_RES5"