Skip to content

DataExpress Cataloged Procedures

Links to instructions to run DataExpress procedures are below.

This is a partial list of the cataloged procedures available on the HP3000 in the INFORM group, PLIB account. For a complete list of available procedures, see Running the Procedure Catalog below.

Expand All
Document - Description Last Updated
(mm/dd/yyyy)
SM9001R - Screen 1 Student Master Data 04/10/2002
SM9003R - Mailing label information based on TRACK-DTL and STD-AWD-DTL 02/17/2009 
SM9004R - Mailing label information based on TRACK-DTL and STD-AWD-DTL. Formatted for printing. Includes SSN and YR-SES. 02/17/2009
SM9101R - Complete Withdrawals after 10th Day (Part 1: Extract) 04/10/2002
SM9102R - Complete Withdrawals after 10th Day (Part 2: Report) 04/10/2002
SM9103R - Complete Drops Before 10th Day (Part 1: Extract) 11/07/2003 
SM9104R - Complete Drops Before 10th Day (Part 2: Report) 11/07/2003
SM9116R - Create File of SSNs for WSAC Cruncher (Col Bound) 03/03/2020
SM9400R - Customer Accounts Sponsorships with Financial Aid Awards 02/09/1998
SM9701R - Students without NEED01 Record to Exclude From FISAP 08/30/2002
SM9805R - Academic Progress 02/09/1998
SM9806R - Calculated and Awarded State Need Grant  02/09/1998
SM9807R - Identify Students by Student Budget Code and Award Code 09/01/2010
SM9809R - SNG Ineligible Independent Students Enrolled Less than Halftime with Worksheet B Income  10/19/2007 
SM9813R - Student Financial Details Listing   02/09/1998
SM9814R - Financial Aid Expenditure Summary (Year-to-Date) 01/29/1991
SM9815R - Financial Aid Expenditure Detail (Not Year-to-Date)  01/29/1991
SM9816R - File Labels From Tracking Selection   02/09/1998 
SM9820R - WSOS Extract 03/03/2020
SM9824R - General Extract - Student Award Detail  
SM9825R - Award Detail and Unduplicated Count 07/28/2010 
SM9830R - WCG/Tuition Compare (Part 1)  02/04/2021
SM9831R - WCG/Tuition Compare (Part 2) 02/04/2021
SM9845R - Session Enrollment Codes and Actual Enrollments 02/09/1998
SM9846R - Annual Enrollment Code and Actual Enrollment 02/09/1998
SM9881R - Accepted FISAP Awards and Did Not Attend 02/17/1998
SM9882R - Attempted Hours and Student Intent 08/08/2003
SM9887R - Session Enrollment Codes and Actual Enrollments 02/09/1998
SM9888R - Credit Completion and Program Intent by Award Code 02/25/1998
SM9890R - General Extract - Tracking Detail 03/17/1998
SM9895R - Students With Dependents for SNG DCA Funds 06/30/1998
SM9897R - WCG Archival Create File 03/03/2020
SM9898R - State Need Grant Archival Check Report 02/16/2011 
SM9899R - Attendance   02/09/1998
Document - Description  Last Updated
(mm/dd/yyyy)
BM1747R - Students Receiving IRS Tuition Statement  
BM1745RE - Payment vs. Qualification Details for IRS Tuition Statement  
BM1745RI - Ineligible IRS Tuition Statement Students  
FM0001 - GL Download to FA  
FM0002 - FinAid Download to Append to GL 12/07/1998 
FM0003 - FM0001 and FM0002 to FM0002S  12/07/1998
FM0004 - GL/FA Exception Report  12/14/1998
Document - Description Last Updated
(mm/dd/yyyy) 
PS0205X - DataExpress Extract File for Use with Job PS0205J (On-Request Personnel Action Forms) 08/10/2009
PS0210X - DataExpress Extract File for Use with PS0210J (On-Request Benefits Coverage Letters)  01/03/2012
PS0510X - DataExpress Extract File for Use with PS0510J (Employee History Report - Partial)  08/10/2009
PS2101R - Leave Activity History Report 06/15/2009
PS7117R - Age and Years of Service Report  06/15/2009 
PS7999R - Extract Employees with Assigned SIDs (Identifies employees who have new SIDs) 04/01/2002
PS8101X - DataExpress Extract File for Use with PS8101J (Mailing Labels)  
PS8102D - Merge with PS8102J for PTF Job Activation 10/16/2012
PS8103X - DataExpress Extract File for Use with PS8103J (Campus Mailing Labels)   
Document - Description  Last Updated
(mm/dd/yyyy)
SM2001R - Previous Name Log
Produces a report that lists name changes that were made in SMS
04/09/2003
SM5003S - Student Unusual Action Log (File Description) 01/26/2009 
SM5003SR - Student Unusual Action Log (DataExpress Notification) 01/26/2009
SM5115X1 - Duplicate Student Comparison Extract File from Student Biographic  
SM5115X2 - Duplicate Student Comparison Extract File from Student Enrollment  
SM5115X3 - Duplicate Student Comparison Extract File from Student Transcript  
SM6004 (Pick-A-Prof Extract – for Letter Grades) 02/23/2009
SM6005 (Pick-A-Prof Extract – for Decimal Grades)  02/23/2009
SM6100R - Grade Transaction Log
Produces a report of all grade transactions that have occurred since grade logging was activated. 
 
SM7001BR - WAOL Transactions  
SM7034R - Waitlist Count by YRQ and Item Number 03/17/2003
SR1001A - Worker Retraining Report - Part 1 of 2  
SR1001BR - Worker Retraining Report - Part 2 of 2  
SR1002A - Workfirst Report - Part 1 of 2  
SR1002BR - Workfirst Report - Part 2 of 2  
ZX0018R - Cataloged DataExpress Procedure for SMS—SID/SSN Modification 04/01/2002

For a complete list of all procedures in the INFORM group, PLIB account, use the following steps:

  1. At the DataExpress Main Menu, select option 1 (Display procedure catalog)
  2. At the prompt Catalog directory, type ../../PLIB/INFORM
  3. To see the entire PLIB/INFORM catalog, at the Procedure Name Selection prompt press the return key. The total number of catalog entries will be displayed.
  4. At the prompt Display Selected Entries (Y/n)?, press the return key (to accept the default Yes response).
  5. The Procedure Catalog Report is displayed. To move back and forth between the displayed pages, select Forward A Page (F1) or Back A Page (F2).

Page Manager: slnelson@sbctc.edu
Last Modified: 7/7/23, 2:59 PM

starburst graphic