Created by Corina C Larsen, last modified on Apr 11, 2019

No key fields.

KeyRecord.FieldnameFormatXLATHeading Text
 ACAD_CAREER - Academic CareerChar4NCareer
 ADM_APPL_NBR - Application NbrChar8 Appl Nbr
 APPL_EVAL_NBR - Evaluation NbrNum3.0 Eval Nbr
 EMPLID - Empl IDChar11 ID
 EVALUATION_CODE - Evaluation CodeChar10 Eval Code
 EVALUATION_FLAG - Successfully EvaluatedChar1 Evaluated
 UM_ACAD - ACAD COMPONENT RATINGNum3.4 ACAD
 UM_COCRD - COCRD COMPONENET RATINGNum3.4 COCRD
 UM_COGPA - COGPA COMPONENT RATINGNum3.4 COPGA
 UM_EXTRA - EXTRA COMPONENT RATINGNum3.4 EXTRA
 UM_HSGPA - HSGPA COMPOCNENT RATINGNum3.4 HSGPA
 UM_RATE - RATE COMPONENT RATINGNum3.4 RATE
 UM_RAW - RAW COMPONENT RATINGNum3.4 RAW
 UM_RCGPA - RCGPA COMPONENT RATINGNum3.4 RCGPA
 UM_STCUR - STCUR COMPONENT RATINGNum3.4 STCUR
 UM_TGPAC - TGPAC COMPONENT RATINGNum3.4 TGPAC
 UM_TRHRS - TRHRS COMPONENT RATINGNum3.4 TRHRS
SQL Code for UM_FLAT_CMPT_VW
SELECT
  * 
FROM (SELECT 
          RATING_CMP,
          EMPLID, 
          ACAD_CAREER, 
          ADM_APPL_NBR, 
          APPL_EVAL_NBR, 
          EVALUATION_CODE, 
          EVALUATION_FLAG, 
          RATING_CMP_VALUE 
        FROM SYSADM.PS_ADM_APPL_CMP)
PIVOT (SUM(RATING_CMP_VALUE) FOR RATING_CMP IN ('ACAD', 'COCRD', 'COGPA', 'EXTRA', 'HSGPA', 'RATE', 'RAW', 'RCGPA', 'STCUR', 'TGPAC', 'TRHRS') )
ORDER BY EMPLID