Subject Codes
Use the VT Subject Codes page to add, edit, and delete subject codes.
During the ALiS Certification Import process, employee certification information is imported from the file retrieved from the ALiS state system. If the file contains Subject codes not in the Subject Codes reference table, those are added to the Subject Codes reference table.
On the start page, choose Human Resources, then State.
From the Reference Tables menu, select Subject Codes.
Filter records using the filter criteria. To enter filter criteria, select an option from the list, select an operator and a value, then select Add.
To add a record, click Add Record. Refer to Field Descriptions and enter valid information in the required fields. Select Save, then Yes.
To edit a record, select the ellipsis in the Actions column, then select Edit.
To delete a record, select the ellipsis in the Actions column, select Delete, then select Yes.
To download a record, select Download and select Download PDF or Download as an Excel Document.
Field Descriptions
The following table lists the field, database table, column, data type, length, and description for subject codes.
Field | Database Table | Database Column | Data Type | Length | Description |
|---|---|---|---|---|---|
Subject Code | vt_subjectcodes | code | char | 10 | The code for the subject. |
Subject Description | vt_subjectcodes | description | char | 200 | The description of the subject. |
CRDC Specialized Area | vt_subjectcodes | crdc_spec | Char | 4 | The specialized area for Civil Rights Data Collection (CRDC) reporting. Valid values:
|
Date Modified | vt_subjectcodes | change_date | Smalldatetime | Not Applicable | The date when the record was modified. Display-only. |
Time Modified | vt_subjectcodes | change_time | char | 8 | The time when the record was modified. Display-only. |
Modified By | vt_subjectcodes | change_uid | char | 8 | The user who modified the record. Display-only. |