Teacher Service Record | Tech Docs
Contents
Application Details
Developer: Joe Gautreau | Programmer / Web Application Developer | jgautreau@judsonisd.org | (210) 945-5558
Development Platform: ColdFusion MX 7, SQL Server, Model-Glue Framework, CSS Layout
Development Server: Testweb
Development Database: ERCSQL
Production Server: Web1
Production Database: ERCSQL2K5
Launch Date: July 5, 2007
Application Overview
The Teacher Service Record was developed to allow Human Resources an easy way to create a Teacher Service Record on the fly. Before they had to get with Jesse Cortinas and ask for the record, which he would generate through an Access application/db, now using the same data we create the PDF on the fly and the user/requestor can now do this themselves. The application also allows for batch generation through the "Print Multiple Records" button. The user simply enters a comma seperated list of employeeID's and voila, it is done.
To sum it all up, the Teacher Service Record application allows simple on the fly creation of Teacher Service Record requests.
Roles
There is only one role for this application at the moment and that is the user role which can search for and print Teacher Service Records.
Database Schema
Below you will find the Teacher Service Record database schema along with a short description for each table.
ServiceHistory: This table is populated via a nightly stored procedure (SQL) which you can learn more about in the notes section. This table stores all service history data form JISD employees past and present.
RequestHistory: This table is used to store Teacher Service History requests from the judsonisd.org website in the HR section.
State: This table is used to store information about the states. Used as a reference in a relational sense to the RequestHistory table.
Flow
Teacher Service Record Data Flow Document - Click to download the PDF.
CFC's & Functions
ServiceRecord.cfc
init:
- Purpose: When called this function returns an instance of the entire object / cfc with all methods available.
- Arguments: None
- Return Type: CFC
checkServiceRecord:
- Purpose: This function checks for service records for a given search request sent in by the user. Any one of the arguments along with the searchType will produce results. The results are displayed to the user to choose which record they would like to generate a request for. A query result set is returned.
- Arguments: SSN (numeric), EIN (numeric), firstname (string), lastname (string), searchType (numeric)
- Return Type: Query
getServiceRecord:
- Purpose: This function returns a single service record in query form pulled from the employeeID passed in.
- Arguments: EIN (numeric)
- Return Type: Query
getMultipleServiceRecords:
- Purpose: This function returns a query result set of teacher service records based on the comma seperated list that was passed in. This does the same thing as the above function only on a grander scale.
- Arguments: einList (comma seperated string)
- Return Type: Query
Notes
A nightly process run through a SQL stored procedure, runs nightly to grab all previous employee service record data from Finance Plus, and dump it into a table called ServiceHistory in the Teacher Service Record database.
Another process to note is the fact that Teacher Service Requests are also made through JISD's website. A past teacher can login and request a service record via the web, an email is then generated to HR personnel who then fulfills the request. This request data is stored in the RequestHistory table.