Unusual Action Code
Data Dictionary
Updated: 07.10.2009
The Student Management System (SMS) is a server based application used to facilitate the data
collection of students and classes in the community and technical colleges in the state of
Washington. Each quarter the colleges run their data through a program which translates the data
into the Student Management Information System (SMIS).
The SMIS data is then sent as a quarterly extract by each of the community and technical colleges to
the State Board for Community and Technical Colleges (SBCTC) during finals as per the MIS
Reporting calendar. SBCTC then engineers the data to add reporting indicators. This information is
subsequently made available to the community and technical colleges.
The Unusual Action Code table is used for tracking students activity such as participation in the
Hospital Employees Education and Training program. Each student may have one or more unusual
action codes.
This data dictionary is meant to assist users in identifying field: format, definition, and values of the
SMIS system.
Unusual Action Code 1 of 2 Last Revised: 7.10.2009
Unusual Action Code
Data Dictionary
Unusual_Action_Code
This table contains one record per SID, College, UACode and YRQ.
The Unusual Action Code table is updated quarterly by data provided by the colleges through process SR1281J.
This MIS job extracts all students with Unusual Action codes containing the characters “*”,”!”,”+” or UACode “F$”.
SID (PK) Data Type: Text Size: 9 Allow Null: No
Definition: A nine-character field used to uniquely identify a student. This identifier is assigned by the
college SMS system.
UACODE (PK) Data Type: Text Size: 2 Allow Null: No
Definition: The student’s Unusual Action Codes
YRQ (PK) Data Type: Text Size: 4 Allow Null: Yes
Definition: Concatenation of the year and quarter of the record. The first three characters are the
year, and the last character is the quarter.
Examples of Valid Values:
Academic Year
1989-90 1990-91 1999-00 2000-01 2009-10 2010-11
Quarter (890) (901) (990) (A01) (A90) (B01)
Summer 8901 9011 9901 A011 A901 B011
Fall 8902 9012 9902 A012 A902 B012
Winter 8903 9013 9903 A013 A903 B013
Spring 8904 9014 9904 A014 A904 B014
COLLEGE Data Type: Text Size: 3 Allow Null: No
(PK) Definition: Identifies each community or technical college in the state of Washington. College codes
begin with the two-digit district code.
DW_KEY Data Type: Text Size: 10 Allow Null: No
Definition: A unique identifier assigned to each student upon first contact with the community and
technical college system. The identifier is retained by the person throughout their association with the
system and is uniform across all student related tables in the SBCTC Data Warehouse. DW_KEY is
based on social security number. If the social security number is not present, then DW_KEY is based on
SID.
Unusual Action Code 2 of 2 Last Revised: 7.10.2009