LM_ENR_CHRT1_VW

(SQL View)
 Index Back

Pie chart data

Pie chart data for My Learning Fluid

SELECT A.LM_PERSON_ID , B.XLATLONGNAME , SUM(A.COUNT1) , ' ' FROM PS_LM_ENR_CHART_VW A , PSXLATITEM B WHERE A.LM_STTS = B.FIELDVALUE AND B.FIELDNAME = 'LM_STTS' AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PSXLATITEM C WHERE B.FIELDNAME = C.FIELDNAME AND B.FIELDVALUE = C.FIELDVALUE AND C.EFFDT <= %CurrentDateIn) GROUP BY A.LM_PERSON_ID , B.XLATLONGNAME

  • Related Language Record: LM_ENR_CHRT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_PERSON_ID Number(15,0) DECIMAL(15) NOT NULL ELM Person ID
    2 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    3 COUNT1 Number(10,0) DECIMAL(10) NOT NULL Counter
    4 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description