SLR Incomplete Checklist Items

  Report Title Report Name or Query Name Report Type Data
Source
Business Process Reporting Area
SLR Incomplete Checklist Items UCCS_R_SLR_CHKLST_OUTSTANDING PS Query   Maintaining Student Residency Maintaining Student Residency
 

Query Name: UCCS_R_SLR_CHKLST_OUTSTANDING
Report Title: SLR Incomplete Checklist Items
Purpose: Reporting on incomplete checklist items for SLR-related checklists.
Description:

Rows: One row per student, per SLR checklist, per outstanding checklist item. SLR checklists restricted to those with codes starting with 'RR'.

Columns: Student ID, Student Name, Checklist Code, Checklist Descr, Item Sequence, Item Code, Item Descr, Item Status, Item Status Date

Required Prompts: None Optional Prompts: Checklist Code, Student ID

Records used: PERSON_CHECKLIST, PERSON_CHK_ITEM,SCC_CKLSITM_TBL,SCC_PRI_NAME_VW, CS_CHKLST_TBL

Report Inventory ID: UCCS_R_1193

User Access Group: Role Not Defined
Process: Maintaining Student Residency
Usage Notes:  Query is restricted to checklists with codes starting with 'RR'. If any other type of checklist code is entered at the prompt, no results will be returned.
Report Elements: For description of elements visit the Custom Fields Table