Database Table Schema for Handbook 2020-2021

List of Tables
Abbreviation Title Table Name Actions
AC ACT 61 ACT61 View / Compare
AI ACT 61 Tier II ACT61II View / Compare
AS ALE (Annual Report) ALE View / Compare
AL Aledays - Days in ALE ALEDAYS View / Compare
BU BUS BUS View / Compare
TP BUS - Supplemental Transportation SUPPTRANSP View / Compare
TS BUS - Transportation Personnel TRANSPERSON View / Compare
CA Calendar CALENDAR View / Compare
CL Class CLASS View / Compare
CO Contact Persons CONTACTPERSON View / Compare
DS Discipline DISCIPLN View / Compare
DI District DISTRICT View / Compare
EC Equity Compliance Report EQUITYCOMPREPORT View / Compare
FB Facility - Building FAC_BUILD View / Compare
BC Finance - Bank Reconciliation BANK_RECON View / Compare
EM Finance - Employee EMPLOYEE View / Compare
FE Finance - Expenditure FINANCEEXP View / Compare
AT Finance - ACT 28 ACT28 View / Compare
BL Finance - Building Loss BLDGLOSSES View / Compare
FA Finance - Employee Additional Duties EMPADD_DUTY View / Compare
BS Finance - Employee Base Salary EMPBASESAL View / Compare
CF Finance - Employee Benefits EMPBEN View / Compare
EB Finance - Employee Bonus EMPLOYEEBONUS View / Compare
FN Finance - Employee Fringe Benefits EMPFRINBEN View / Compare
EL Finance - Employee Leave EMP_LEAVE View / Compare
ES Finance - Employee Salary/Benefits EMPLOYEESALARY View / Compare
FG Finance - General Ledger FINANCEGEN View / Compare
PO Finance - Programs on Behalf of Other Agencies PGMOTHAG View / Compare
PV Finance - Property Value PROPERTYVALUES View / Compare
FR Finance - Revenue FINANCEREV View / Compare
CC Finance - Salaries and FTE SALFTE View / Compare
SL Finance - Salary Range SALRANG View / Compare
SA Finance - Salary Schedule SALSCHED View / Compare
SE Finance - Salary Schedule SES_PROVIDER View / Compare
UP Finance - Underpayments UNDERPAYMENTS View / Compare
VE Finance - Vendor VENDOR View / Compare
GR Graduate GRADUATE View / Compare
JA Job Assignment JOBASSGN View / Compare
MB Medical Body Mass Index MEDICAL_BMI View / Compare
MD Medical Dyslexia MEDICAL_DYSLEXIA View / Compare
MH Medical Hearing MEDICAL_HEARING View / Compare
MI Medical Immunization MEDICAL_IMMUN View / Compare
MS Medical Scoliosis MEDICAL_SCOLIOSIS View / Compare
MV Medical Vision MEDICAL_VISION View / Compare
NE Non-employee Contractors NONEMPLOYEE_CONTRACTORS View / Compare
PS Private School PRIVATE_SCHOOL View / Compare
PT Private School Title I PRIVSCH_TITLEI View / Compare
PD Professional Development STAFF_DEV View / Compare
RG Register REGISTER View / Compare
SD Safety Drill SAFETYDRILL View / Compare
SC School SCHOOL View / Compare
SB School Board Training SCHOOLBOARDTRAINING View / Compare
EI Special Education Early Intervening Services 1 (School Age Only) SPCEDERLYINTERV1 View / Compare
ER Special Education Early Intervening Services 2 (School Age Only) SPCEDERLYINTERV2 View / Compare
RF Special Education Referral Tracking SPCEDREFTRAC View / Compare
SY Special Education School Age SPCEDSCHAGE View / Compare
SZ Special Education Early Childhood SPCEDEARLYCHILD View / Compare
SX Special Education Employee SPCEDEMPLOYEE View / Compare
ST Student STUDENT View / Compare
SS Student Attendance STUDENT_ATT View / Compare
SG Student Grades STUDENT_GRADE View / Compare
SI Student ID Change STIDCHG View / Compare
No change New Table Modified Table Deleted Table