Agrupamento

CASE WHEN QC1_DMT_DIM_CLASSIFICATION.QC1_JOB_GROUP_003='1A' THEN 'PEAGE perception'
WHEN QC1_DMT_DIM_CLASSIFICATION.QC1_JOB_GROUP_003='1B' THEN 'PEAGE enc.technique'
WHEN QC1_DMT_DIM_CLASSIFICATION.QC1_JOB_GROUP_003='1C' THEN 'PEAGE commercial'
WHEN QC1_DMT_DIM_CLASSIFICATION.QC1_JOB_GROUP_003 in ('2A','2B') THEN 'VIABILITE/SECURITE'
WHEN QC1_DMT_DIM_CLASSIFICATION.QC1_JOB_GROUP_003 in ('3A','3B') THEN 'MAINTENANCE & ATELIER'
WHEN QC1_DMT_DIM_CLASSIFICATION.QC1_JOB_GROUP_003='4A' THEN
CASE WHEN QC1_DMT_DIM_ORGANISATION.QC1_LEV_03_CODE='1' THEN 'STRUCTURE EXPLOITATION'
ELSE 'STRUCTURE HORS EXPLOITATION'
END
ELSE ''
END