NAME

EXTRACTION FILE NAME

DATABASE
FILE NAME

Estimated time of availability on SBCTC FTP site

CONTENTS

RECOMMENDED INSTRUCTIONS

QUARTERLY

Data Warehouse SMIS tables

DXXXYRQ.EXE

DXXXYRQ.MDB

Approximately 2 weeks after SBCTC runs Finals (see MIS Reporting Calendar for specific dates)

STUDENT, STUCLASS, CLASS and UNUSUAL_ACTION_CODE tables for the quarter

Append to current year STUDENT, STUCLASS and CLASS tables. Replace current year UNUSUAL_ACTION_CODE table.

If Summer quarter, create new academic year tables.

Data Warehouse PMIS tables

PXXXYRQ.EXE

PXXXYRQ.MDB

Approximately 2 weeks after SBCTC runs Finals (see MIS Reporting Calendar for specific dates)

EMPYRQ, PAYROLL and PROGRAM tables for the quarter. Annualized EMPLOYEE table for the current year.

Append to current year EMPYRQ, PAYROLL and PROGRAM tables. Replace current year EMPLOYEE table.

If Summer quarter, create new academic year tables.

Completions

COMPLXXX.EXE

COMPLXXX.MDB

Mid Quarter

Historical Completion table with data up thru previous quarter. Audit Log table, query & report.

Replace previous COMPLETION and AUDIT_LOG tables. Review Audit Log Report.

Transcripts

TRANXXX.EXE

TRANXXX.MDB

Mid Quarter

Historical Transcripts table with data up thru previous quarter. Audit Log table, query & report.

Replace previous TRANSCRIPTS and AUDIT_LOG tables. Review Audit Log Report.

Student Achievement

SA_XXX.EXE

SAREVXXX.EXE

Mid Quarter

Accumulative Student Achievement tables

Replace previous Quarter End files. Archive previous databases if you want to perform comparisons such as fall to fall on your own as SBCTC will not re-distribute past versions

Financial Aid

FAXXXYYY.EXE

FAXXXYYY.MDB

Mid Quarter

Current year Financial Aid tables

Replace previous files from the same academic year. Keep one Financial Aid database per year.

WABERS

WXXXYRQ.EXE

WXXXYRQ.EXE

Mid Quarter

Current year WABERS tables

Replace previous files from the same academic year. Keep one WABERS database per year.

ANNUAL

DLOA

DLOA_YYY.EXE

DLJP_YYY.MDB

DLTR_YYY.MDB

DLWR_YYY.MDB

December

Quick Files (Job Prep, Apprenticeship, Transfer, and Worker Retraining tables)

Maintain and store files separately.

Do not replace or append to previous DLOA files.

Completions

COMPLXXX.EXE

COMPLXXX.MDB

September

Historical Completion table with finalized data for the previous academic year

Replace previous COMPLETION and AUDIT_LOG tables. Review Audit Log Report.

Financial Aid

FAXXXYYY.EXE

FAXXXYYY.MDB

October

Finalized Financial Aid tables for the previous academic year

Replace previous files from the same academic year. Keep one Financial Aid database per year.

Transcripts

TRANXXX.EXE

TRANXXX.MDB

September

Historical Transcripts table with finalized data for the previous academic year

Replace previous TRANSCRIPTS and AUDIT_LOG tables. Review Audit Log Report.

LOOKUP *

CIP

CIP.MDB

CIP.MDB

Mid Quarter

Current CIP tables

Replace previous CIP tables.

PMIS

PMIS_LU.MDB

PMIS_LU.MDB

Mid Quarter

Current PMIS Lookup tables

Replace previous PMIS Lookup tables.

SMIS

SMIS_LU.MDB

SMIS_LU.MDB

Mid Quarter

Current SMIS Lookup tables

Replace previous SMIS Lookup tables.