Downloads
To download data from CACTUS, on the Cactus menu bar, click on Tools, and Download CACTUS tables.
Column Description |
Length |
Format |
Person id |
11 |
Numeric |
SSN |
9 |
Character |
Last name |
60 |
Character |
First name |
35 |
Character |
Middle name |
60 |
Character |
Preferred name |
60 |
Character |
Maiden name |
60 |
Character |
AKA (also known as) |
250 |
Character |
Ethnic code |
3 |
Character |
Gender |
1 |
Character |
Date of birth |
|
Datetime |
Citizenship |
1 |
Character |
Ethnic Codes:
A Asian
B Black
C Caucasian
H Hispanic
I American Indian
P Pacific Islander
U Unknown
Gender:
F Female
M Male
U Unknown
Citizenship
Y Yes
N No
U Unknown
Column Description |
Length |
Format |
Person id |
11 |
Numeric |
Social Security Number |
9 |
Character |
Address line 1 |
60 |
Character |
Address line 2 |
60 |
Character |
Apartment number |
15 |
Character |
City |
60 |
Character |
State |
2 |
Character |
Zipcode |
15 |
Character |
Country |
40 |
Character |
100 |
Character |
|
Telephone |
10 |
Character |
Fax |
10 |
Character |
Effective date |
|
Datetime |
If the address information is blank, it is because we have no current address for this educator. The educator’s license and renewal reminders are sent to the home address. If they are returned, we mark the address as unusable and wait to hear from the educator.
Years of Experience for each Educator
Column Description |
Length |
Format |
Person id |
11 |
Numeric |
Social security number |
9 |
Character |
First name |
35 |
Character |
Middle Name |
60 |
Character |
Last name |
60 |
Character |
District |
100 |
Character |
School |
100 |
Character |
Current years |
|
Numeric |
Other class years |
|
Numeric |
Other administrative years |
|
Numeric |
Other instructional years |
|
Numeric |
Current years is the sum of the experience rows where the FTE is .5 or greater, and the educator is not an intern.
Other classroom years comes from the box on the experience history tab and is in addition to the detail years.
Other administrative years comes from the box on the experience history tab and is in addition to the detail years.
Other instruction years comes from the box on the experience history tab and is in addition to the detail years.
Column Description |
Length |
Format |
Decimals |
Person id |
11 |
Numeric |
|
Social Security Number |
9 |
Character |
|
Begin date |
19 |
Datetime |
|
End date |
19 |
Datetime |
|
Contact hours |
4 |
Numeric |
|
Intern flag |
1 |
Character |
|
Lane |
2 |
Character |
|
Step |
2 |
Character |
|
Contract salary |
11 |
Decimal |
4 |
Salary add-on |
11 |
Decimal |
4 |
Contract days |
3 |
Numeric |
|
FTE |
5 |
decimal |
3 |
Column Description |
Length |
Format |
Decimals |
Person id |
11 |
Numeric |
|
Social Security Number |
9 |
Character |
|
Begin date |
19 |
Datetime |
|
core code |
11 |
Character |
|
institution (assigned school) |
100 |
Character |
|
school number |
3 |
Character |
|
assignment percent |
3 |
Decimal |
2 |
assignment status |
1 |
Character |
|
mail pickup |
1 |
Character |
|
qualified flag |
1 |
Character |
|
NCLB qualified flag |
1 |
Character |
|
|
|
|
|
Core code is the 11 digit assignment code which specifies what the educator is doing
Institution is the name of the school where the assignment is performed
School number is the USOE-assigned school number
Assignment percent is the percentage of the educator’s time that was spent on this assignment for the entire school year. The percentages must add to 100% for each educator. If the educator has one assignment first semester and a different assignment second semester, each would be 50%.
Assignment status is A for active; or I for inactive, which is to say, no longer employed.
Mail pickup will be Y for the school where the educator receives mail. If there are multiple assignments, only one can be Y; the rest will be N.
Underqualified flag is actually a Qualified flag, i.e., Y is yes, the educator is USOE qualified; N is no, the educator is not USOE qualified.
NCLB qualified may be A for not applicable (not an NCLB core subject); I for interim, meaning the educator is NCLB highly qualified until his/her license expires; Y for yes, permanently NCLB highly qualified; and N for not NCLB highly qualified.
Column Description |
Length |
Format |
Person id |
11 |
Numeric |
Social Security Number |
9 |
Character |
degree major code |
7 |
Character |
degree major description |
100 |
Character |
degree type |
3 |
Character |
degree description of degree type |
50 |
Character |
granting institution id |
11 |
Number |
granting institution name |
100 |
Character |
degree state |
2 |
Character |
degree minor code |
7 |
Character |
degree minor description |
100 |
Character |
degree date |
19 |
Datetime |
Degree major code refers to the CACTUS license area/endo code definition table where most degrees are defined.
Degree major description comes from the CACTUS license area/endo code definition table.
Granting institution id is the code from the institution table where all CACTUS institutions are defined. This is the Utah college or university that granted the degree.
Granting institution name is the name of the Utah college or university that granted the degree. Out of state schools will be “Others not detailed”.
Degree state is the state in which the degree was earned.
Degree minor code refers to the CACTUS license area/endo code definition table where most degrees are defined.
Degree minor description comes from the CACTUS license area/endo code definition table.
Every educator does not have a minor. Some have more than one minor, in which case, the degree major will be repeated so that more than one minor can be attached to a single major.
Column Description |
Length |
Format |
Person id |
11 |
Numeric |
Social Security Number |
9 |
Character |
issue date |
19 |
Datetime |
expire date |
19 |
Datetime |
status |
1 |
Character |
license level |
1 |
Character |
License status:
N New
R Renewed
T Reinstated
W Incomplete New
D Incomplete Renewed
The incomplete license status indicates that the educator has not completed the background check. In some cases the educator has not submitted anything to USOE; in some cases fingerprints have not come back from BCI and/or FBI; in some cases the fingerprints were of insufficient quality and the educator needs to resubmit; in some cases there was a problem and the educator needs to submit documentation to the Utah Professional Practices Advisory Commission to be cleared.
License level:
1
2
3
P paraprofessional
T temporary (authorized)
Column Description |
Length |
Format |
Person id |
11 |
Numeric |
Social Security Number |
9 |
Character |
license area code |
7 |
Character |
license area description |
100 |
Character |
license area receive date |
19 |
Datetime |
recommending institution id |
11 |
Number |
recommending institution name |
100 |
Character |
license area type |
5 |
Character |
license area status |
1 |
Character |
expire date |
19 |
Datetime |
qualified by |
1 |
Character |
NCLB qualified |
1 |
Character |
License area code is defined in Area_Endo_Degree table on the Code Tables icon in CACTUS.
License area receive date is the date the license area was issued.
Recommending institution is the college or university that recommended a student for licensure or a district that recommended the educator to move from basic to standard.
License area type is basic, standard, temporary (authorized), paraprofessional.
License area status:
N New
R Renewed
E Expired
X Extended
S Suspended
T Reinstated
K Revoked
W Incomplete New
D Incomplete Renewed
Expire date is null or contains a date on which the license area will expire.
Qualified by is the means by which the educator earned the license area. Codes may be found and downloaded from CACTUS, Code Tables icon, Qualified by tab.
NCLB qualified may be Interim, Yes, or No for early childhood and elementary license areas. All others will be not Applicable.
Column Description |
Length |
Format |
Person id |
11 |
Numeric |
Social Security Number |
9 |
Character |
license area code |
7 |
Character |
license area receive date |
19 |
Datetime |
endorsement code |
7 |
Character |
endorsement description |
100 |
Character |
endorsement expire date |
19 |
Datetime |
qualified by |
1 |
Character |
nclb qualified |
1 |
Character |
nclb expires |
19 |
Datetime |
recommending institution id |
11 |
Numeric |
recommending institution name |
100 |
Character |
restricted institution id |
11 |
Numeric |
restricted institution name |
100 |
character |
specialty |
7 |
Character |
License area code is the license area the endorsement is attached to. Each endorsement is attached to one or more license areas, as appropriate. You can look at the rules by going to the code tables on CACTUS and selecting the Endorsements’ License areas tab.
License area receive date is the date the current license area was issued.
Endorsement code and description identify the endorsement.
Endorsement receive date is the date the current endorsement was issued.
Endorsement expire date will be null if it is a permanent endorsement; for an authorization or state-approved endorsement program, there will be an expiration date.
Qualified by is route by which the educator earned the endorsement. The codes are defined in the code tables (the CACTUS icon looks like a green can) on the Qualified by tab. The Qualified by table may be downloaded from the Code Table tab page.
NCLB qualified may be A for not applicable (not an NCLB core subject); I for interim, meaning the educator is NCLB highly qualified until his/her license or endorsement expires; Y for yes, permanently NCLB highly qualified; and N for not NCLB highly qualified.
NCLB expires is the date the interim qualification expires. It will either be the date the license expires, or the date the state-approved endorsement program should be completed.
Recommending institution id and name are the institution that recommended the educator for the endorsement.
Restricted institution id and name is the institution where the educator is qualified to teach with this endorsement. The educator will not be qualified with this endorsement at any other institution.
Specialty is an indication of extra study in science for an elementary license area holder.
Column Description |
Length |
Format |
Person id |
11 |
Numeric |
Social Security Number |
9 |
Character |
test type |
6 |
Character |
|
description |
100 |
Character |
|
date taken |
19 |
datetime |
|
test status |
1 |
Character |
Test status:
Y Passing score
N Failing score
P Pending; passing score has not been set
Revised 6/12/2008