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.
| 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:
- At the DataExpress Main Menu, select option 1 (Display procedure catalog)
- At the prompt Catalog directory, type ../../PLIB/INFORM
- 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.
- At the prompt Display Selected Entries (Y/n)?, press the return key (to accept the default Yes response).
- 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).
In IT Support
- ctcLink Support
- Data Services
- Data Staging
- K-20 Education Network
- Legacy Applications
- LegacyLink
- Legacy Transcript
- Mailman eLists (listservs)
- Customer Support (for Legacy colleges)
- Software & Hardware Contracts
Page Manager:
slnelson@sbctc.edu
Last Modified: 7/7/23, 2:59 PM
