This information is specific to South Dakota state-level users.
PATH: Census > Tools > Import Wizard > Staff Credential Import Type
The Staff Credential Import includes the qualifying credentials earned by a staff member. Files created by the Credentials Extract (South Dakota) can be used for this import.
Image 1: Import Wizard > Staff Credentials
Logic and Validations
The following describes the logic and setup used in the Staff Credentials Import.
- Each line should represent a staff member's education degree or highly qualified status. A staff person with more than one credential record will have a line for each.
- Any employment credential record with an employment credential type of HQ or ED will be imported for staff members who have a Staff State ID and an active district employment record.
- Staff matching logic verifies using the SAUID and the StaffStateID.
Image 2: Staff Credentials Import
Import Layout
The following table lists the data elements included in the layout.
Data Element |
Description |
Format, Type and Length |
Campus Database |
Campus Interface |
|---|---|---|---|---|
SAUID |
The district's state-assigned identification number. An error will generate if the field is not populated or if the entry is not a valid SAUID. |
Numeric, 4 digits |
district.districtID |
System Administration > Resources > District Information > State District Number |
Staff State ID |
Staff member's state-issued identification number. An error will generate if the field is not populated or if the entry is not a valid Staff State ID. |
Numeric, 6 digits |
person.stateStaffID |
Census > People > Demographics > Person Identifiers> State Staff ID |
Credential Type |
Indicates the type of credential the staff member has earned. An error will generate if the field is not populated or if the entry is not a valid Credential Type. Options include:
|
Alpahnumeric, 2 characters |
employmentCredential. employmentCredentialType |
Census > People > Credentials > Type |
Start Date |
Staff member's start date for the credential. An error will generate if the field is not populated or if the entry is not in the correct format. |
Date field, 10 characters |
employmentCredential. startDate |
Census > People > Credential > Start Date |
End Date |
Staff member's end date for the credential. An error will generate if the entry is not in the correct format. |
Date field, 10 characters |
employmentCredential. endDate |
Census > People > Credential > End Date |
Subject Area |
Content teaching assignment used for HQ Status determination. Appears on the Highly Qualified Credential editor. An error will generate if the entry is not a valid Subject Area. Options include:
|
Alphanumeric, 4 characters |
employmentCredential. subjectType |
Census > People > Credential > Highly Qualified > Subject Type |
HQT Method |
Indicates the method used to determine the HQ status. Appears on the Highly Qualified Credential editor. An error will generate if the field is not populated or if the entry is not a valid HQT Method. Options include:
|
Alphanumeric, 2 characters |
employmentCredential. subjectCompetency |
Census > People > Credential > Highly Qualified > Subject Matter Competency |
Housse Date |
Data the High Objective Uniform State Stand of Evaluation rubric was completed. Appears on the Highly Qualified Credential editor. An error will generate if the entry is not in the valid date format. |
Date field, 10 characters |
employmentCredential. housseDate |
Census > People > Credential > Highly Qualified > HOUSSE Completion Date |
Full Certification |
Indicates the staff member is fully certified. Appears on the Licensure Credential editor. This field is required if the Credential Type is LC. |
Alphanumeric, 1 character |
employmentCredential. fullCertification |
Census > People > Credential > Licensure/Certification > Fully Certfied |
LEP Credential |
Indicates the staff person has a Limited English Proficiency credential. Appears on the Licensure Credential editor. |
Alphanumeric, 5 digits |
employmentCredential. lepCredential |
Census > People > Credential > Licensure/Certification > LEP Credential |
Related Services Credential |
Indicates the staff person has a special education services credential. Appears on the Licensure Credential editor. |
Alphanumeric, 11 characters |
employmentCredential. spedRelatedService |
Census > People > Credential > Licensure/Certification > SPED Related Services Credential |
License Number |
Lists the license number assigned to the staff person. Appears on the Licensure Credential editor. |
Alphanumeric, 30 characters |
employmentCredential. licenseNumber |
Census > People > Credential > Licensure/Certification > License Number |
License Type |
Indicates the type of certification received. Appears on the Licensure Credential editor.
|
Alphanumeric, 3 characters |
employmentCredential. licenseType |
Census > People > Credential > Licensure/Certification > License Type |
Education Level |
Level of education the staff member has completed. Appears on the Education Credential editor. |
Alphanumeric, 3 digits |
employmentCredential. degreeType |
Census > People > Credential > Education Level |
Institution Type |
Not applicable. |
Not applicable. |
Not applicable. |
Not applicable. |
Degree School |
Not applicable. |
Not applicable. |
Not applicable. |
Not applicable. |
DegreeState |
Not applicable. |
Not applicable. |
Not applicable. |
Not applicable. |
LEP Credentials Options
Code |
Description |
|---|---|
ESL |
English as a Second Language |
SPKOT |
Teachers of English to Speakers of Other Languages |
ENGLL |
Teachers of English Language Learners |
BILI |
Bilingual Education |
CERT |
Certified in content with ESL/BE PD training |
BOTH |
Both ESL and BE |
ENDS |
Endorsed for ESL, TESOL, TELL, or BE |
SPED Related Services Credential Options
Code |
Description |
|---|---|
AUDIO |
Audiologists |
COUNSELOR |
Counselors and Rehabilitation Counselors |
INTERPRET |
Interpreters |
MEDNURSE |
Medical/Nursing Service Staff |
OCCTHERAP |
Occupational Therapists |
ORIENTMOBIL |
Orientation and Mobility Specialist |
PEANDREC |
Phys Ed, Recreation, Therapeutic Rec Specialists |
PHYSTHERAP |
Physical Therapists |
PSYCH |
Psychologists |
SOCIALWORK |
Social Workers |
SPEECHPATH |
Speech-language Pathologists |
Education Level Options
Code |
Description |
|---|---|
HS |
High School Diploma |
GED |
GED or Equivalent |
A |
Associates |
AA |
Associate of Arts (A.A.) |
AS |
Associate of Science (A.S.) |
AAS |
Associate of Applied Science (A.A.S.) |
B |
Bachelors |
BA |
Bachelor of Arts (B.A.) |
BS |
Bachelor of Science (B.S.) |
BFA |
Bachelor of Fine Arts (B.F.A.) |
BBA |
Bachelor of Business Administration (B.B.A.) |
BED |
Bachelor of Education (B.Ed.) |
FPD |
First Professional Degree |
M |
Masters |
MA |
Master of Arts (M.A.) |
MS |
Master of Science (M.S.) |
MED |
Master of Education (M.Ed.) |
MBA |
Master of Business Administration (M.B.A.) |
CAGS |
Certificate in Advanced Graduate Study |
JD |
Juris Doctor |
EDD |
Educational Doctorate (Ed.D.) |
EDS |
Educational Specialist (Ed.S.) |
PHD |
Doctor of Philosophy (Ph.D.) |
MD |
Doctor of Medicine (MD) |
PSD |
Doctor of Psychology (Psy.D.) |
