Eclipse BIRT Designer Version 2.3.0.v20080606 Build <2.3.0.v20080618-0630> in ApplicationResources Plateau.Plateau_stylesheet /templates/blank_report.gif auto layout Plateau.rptlibrary Plateau contentBidiFormatStr ILYNN metadataBidiFormatStr ILYNN oracle.jdbc.OracleDriver jdbc:oracle:thin:@192.168.126.162:1521:TMS62 PLATEAU UExBVEVBVQ== USER_ID USER_ID CURRICULUM_ID CURRICULUM_ID CPNT_TYP_ID CPNT_TYP_ID ITEM_ID ITEM_ID EXP_DTE EXP_DTE COMPL_DTE COMPL_DTE COMPLETED COMPLETED 1 USER_ID string 2 CURRICULUM_ID string 3 CPNT_TYP_ID string 4 ITEM_ID string 5 EXP_DTE date-time 6 COMPL_DTE date-time 7 COMPLETED string PlateauDataSource 1 USER_ID USER_ID string 12 2 CURRICULUM_ID CURRICULUM_ID string 12 3 CPNT_TYP_ID CPNT_TYP_ID string 12 4 ITEM_ID ITEM_ID string 12 5 EXP_DTE EXP_DTE date-time 93 6 COMPL_DTE COMPL_DTE date-time 93 7 COMPLETED COMPLETED string 12 SELECT T.* from (SELECT DISTINCT stud.stud_id as user_id, qual_cmpnt.qual_id as curriculum_id, qual_cmpnt.cpnt_typ_id, qual_cmpnt.cpnt_id as item_id, qual_cmpnt.exp_dte, qual_cmpnt.compl_dte, pkg_student.get_stud_qual_status(qual_cmpnt.stud_id,qual_cmpnt.qual_id,qual_cmpnt.qual_id) AS completed FROM pa_stud_qual_cpnt qual_cmpnt, pa_student stud WHERE qual_cmpnt.stud_id = stud.stud_id /** and qual_cmpnt.stud_id in [UserSearch] */ /** and qual_cmpnt.qual_id in [CurriculumSearch] */ /** and [security:pa_student stud] */ ) T ORDER BY T.curriculum_id, T.user_id, T.completed desc 1.0 AP_ID 1 12 150 0 NotNullable AP_ID AP_ID 150 DMN_DESC 2 12 300 0 Nullable DMN_DESC DMN_DESC 300 AP_DESC 3 12 300 0 Nullable AP_DESC AP_DESC 300 QUAL_TITLE 4 12 150 0 Nullable QUAL_TITLE QUAL_TITLE 150 QUAL_DESC 5 12 2000 0 Nullable QUAL_DESC QUAL_DESC 2000 ]]> 100% ReportTitle params["ReportTitle"].value string ReportTitle right ReportHeader params["ReportHeader"].value string ReportHeader 100% "Arial Unicode MS" 9pt html new Date()]]> "Arial Unicode MS" 9pt right ReportFooter params["ReportFooter"].value string ReportFooter 100% CurriculumStatus USER_ID dataSetRow["USER_ID"] string CURRICULUM_ID dataSetRow["CURRICULUM_ID"] string CPNT_TYP_ID dataSetRow["CPNT_TYP_ID"] string ITEM_ID dataSetRow["ITEM_ID"] string EXP_DTE dataSetRow["EXP_DTE"] date-time COMPL_DTE dataSetRow["COMPL_DTE"] date-time COMPLETED dataSetRow["COMPLETED"] string "Arial Unicode MS"10ptleft100%CurriculumStatus USER_ID USER_ID dataSetRow["USER_ID"] string CURRICULUM_ID CURRICULUM_ID dataSetRow["CURRICULUM_ID"] string CPNT_TYP_ID CPNT_TYP_ID dataSetRow["CPNT_TYP_ID"] string ITEM_ID ITEM_ID dataSetRow["ITEM_ID"] string EXP_DTE EXP_DTE dataSetRow["EXP_DTE"] date-time COMPL_DTE COMPL_DTE dataSetRow["COMPL_DTE"] date-time COMPLETED COMPLETED dataSetRow["COMPLETED"] string

USER_ID CURRICULUM_ID CPNT_TYP_ID ITEM_ID EXP_DTE COMPL_DTE COMPLETED

"Arial Unicode MS" 10pt USER_ID "Arial Unicode MS" 10pt CURRICULUM_ID "Arial Unicode MS" 10pt CPNT_TYP_ID "Arial Unicode MS" 10pt ITEM_ID "Arial Unicode MS" 10pt EXP_DTE "Arial Unicode MS" 10pt COMPL_DTE "Arial Unicode MS" 10pt COMPLETED 100%CurriculumStatus USER_ID dataSetRow["USER_ID"] string CURRICULUM_ID dataSetRow["CURRICULUM_ID"] string CPNT_TYP_ID dataSetRow["CPNT_TYP_ID"] string ITEM_ID dataSetRow["ITEM_ID"] string EXP_DTE dataSetRow["EXP_DTE"] date-time COMPL_DTE dataSetRow["COMPL_DTE"] date-time COMPLETED dataSetRow["COMPLETED"] string