Certificate Type Code Database Maintenance

The key to using the Certificate Type Codes sub system is the use of certificate type and certificate class codes. These codes allow you to enter a wide variety of certificates through one standard screen. Teaching certificates, first aid certificates, diplomas, degrees, masters and doctorates can be entered into the same screen yet extracted individually by like types through proper use of certificate type and class codes.

Certificate type codes are used to broadly group like certificates together. Possible certificate type codes could include personal training and certificates. Certificate class codes are used to more specifically group like certificates together. Certificate class codes could include diploma, degree, masters and doctorate. The final level of definition is the certificate code itself. Each certificate code ties back to its corresponding class and type code. When entering certificates, the only one of these three codes that you have to worry about is the certificate code. The other two codes are known from the certificate code definition.

Once these three database items are defined, you can extract information from the certificate file in a way that will produce extremely useful reports. Below is a table showing some possible relationships between certificate types, classes and codes.

Based on the above relationships you could extract employees having a certificate class code equal to Teaching Certificate to find all certified teachers. You could extract all employees having a certificate class code equal to First Aid Certificate or be even more specific in your query by specifying a certificate code of Industrial 1. You could be very general in your query by listing all employees with a certificate type code equal to Post Sec Training to find all employees who have had any level of post secondary training. You could be a little more specific in your query by specifying a certificate class code of Degree. You could be even more specific by specifying a certificate code of BSC.

By specifying any of these 3 levels of classification (type, class, and code), you can be as general or as specific in your report queries as you wish. 

Certificate Type

Enter up to 10 alphanumeric character certificate type code. 

Description

Enter up to 30 characters of text describing this certificate type code.