Listed below are sample codes that could be used in setting up 504 Plans in Aeries. These codes can be added manually by using the Update Code Table form, or the convenient Default Code Management page within Aeries.
Below is a SQL Query that can be run to populate default code values for the 504 Plans in Aeries. This script will not override existing code values and only add new codes. After adding the codes, the codes can be easily deleted from the Update Code Table form. This script includes sample codes for the all of the 504 tables which include FOF, FAP, FDE, FEC, and FSD.
Please note that due to caching, it may take up to 5 minutes to apply these code changes.
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','AD','ACASKL','Academic skills','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','AD','ATTENT','Attention','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','AD','BEHAVE','Behavior','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','AD','COMMU','Communication','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','AD','GENAT','General Attitude','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','AD','GENER','General','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','AD','HWRK','Homework','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','AD','MEMO','Memory','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','AD','MOBIL','Mobility','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','AD','ORGANI','Organization & planning','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','AD','SLFEST','Low self-esteem','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','AD','SOCIAL','Social skills','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','AD','STUDY','Study skills','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','CD','PRESEN','Have teachers provide outlines of presentations','Academic');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','CD','SHORT','Provide a shorter school day','Academic');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','CD','ORALRE','Let student give reports orally rather than in writing','Academic');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','CD','XTRA','Allow extra time between classes','Academic');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','CD','TOLERA','Tolerate (understand the need) excessive movement','Behavior');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','CD','AWARE','Create awareness by staff of potential victimization from other students.','Behavior');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','CD','PRAISE','Provide positive praise and redirection.','Behavior');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','CD','SUICID','Report any suicidal comments to counselor/psychologist immediately.','Behavior');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','CD','PADCHA','Obtain padded chairs','Health');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','CD','EXERCI','Provide more time for massage or exercises','Health');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','CD','ALLERG','Remove allergens (e.g. hair spray, lotions, perfumes, paint, latex)','Health');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','CD','RELAY','Make health care needs known to appropriate staff','Health');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','CD','SUPERV','Provide supervision during transitions, disruptions, field trips','Non-Academic');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','CD','REST','Provide a private area in which to rest','Non-Academic');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','CD','BUDDY','Provide student with a student buddy for participation in sports','Non-Academic');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','CD','CONTAC','Arrange for periodic home-school contacts','Other');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','CD','PEERS','Establish peer support group','Other');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','CD','COUNS','Provide counseling, social skills instruction','Other');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','FN','ALLCLS','Every Class','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','FN','NEED','As Needed','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','FN','LNCH','Every Lunch','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','FN','DAY','Daily','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','FN','WEEK','Weekly','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','FN','MONTH','Monthly','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','FN','ASSES','During Assessments','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','FN','WRITTE','During Written Assessments','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','FN','INSTRU','During instruction','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','FN','VERB','During Verbal Assessments','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','FN','MULT','During Multiple-choice Assessments','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','FN','INCLSS','During in-class assignments','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','RL','NURSE','School Nurse','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','RL','COUNSE','Counselor','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','RL','PE_TCH','Physical Education Teacher','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','RL','EN_TCH','English Teacher','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','RL','SOC_TC','Social Studies Teacher','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','RL','SC_TCH','Science Teacher','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','RL','MT_TCH','Math Teacher','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','RL','AL_TCH','All Teachers','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','RL','DEAN','Dean of Students','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','RL','PRINC','Principal','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','RL','LNCMON','Lunch Monitor','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','RL','HLLMON','Hallway Monitor','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','RL','LIBRA','Librarian','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','RL','LNCSRV','Lunch Server','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','RL','CLRK','Office Clerk','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','RL','RECEP','Receptionist','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','RL','CUSTO','Custodian','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','RL','TEC_TC','Technology Teacher','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','RL','DRVER','Bus Driver','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','RL','COACH','Coach','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FAP','RL','ALL','All Staff Members','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','L','Learning','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','M','Mobility','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','CARE','Caring for oneself','Activity');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','CONCEN','Concentrating','Activity');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','EAT','Eating','Activity');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','HEAR','Hearing','Activity');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','COMM','Communicating','Activity');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','LEARN','Learning','Activity');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','LIFT','Lifting','Activity');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','MANUAL','Performing manual tasks','Activity');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','SEE','Seeing','Activity');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','SLEEP','Sleeping','Activity');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','SPEAK','Speaking','Activity');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','STAND','Standing','Activity');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','THINK','Thinking','Activity');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','WALK','Walking','Activity');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','WORK','Working','Activity');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','OTH_A','Other life activity','Activity');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','READ','Reading','Activity');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','BEND','Bending','Activity');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','BLAD','Bladder','Function');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','BOWEL','Bowel','Function');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','BRAIN','Brain','Function');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','CIRCU','Circulatory','Function');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','DIGEST','Digestive','Function');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','ENDOC','Endocrine','Function');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','IMMUNE','Immune System','Function');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','NEURO','Neurological','Function');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','CELL','Normal cell growth','Function');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','REPRO','Reproductive','Function');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','RESP','Respiratory','Function');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FDE','CD','OTH_F','Other bodily function','Function');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FEC','CD','MEDICA','Prescribed Medication','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FEC','CD','PSYHC','Psychological Evaluation','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FEC','CD','APTTST','Aptitude and Achievement Tests','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FEC','CD','HLTINF','School Health Information','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FEC','CD','WRKSAM','Student Work Samples','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FEC','CD','HLTHPL','Health Plan','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FEC','CD','TEAINP','Teacher Input and Recommendations','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FEC','CD','ATTREP','Attendance Reports','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FEC','CD','STUINP','Student Input','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FEC','CD','PARINP','Parent Input','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FEC','CD','OTHINP','Other Staff Input and Recommendations','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FEC','CD','OTHTST','Other Tests','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FEC','CD','DISREP','Discipline Reports','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FEC','CD','BEHASS','Behavior Assessments','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FEC','CD','INTOUT','Early Intervention Outcomes','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FEC','CD','MEDDIA','Diagnosis from Medical Professional','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FEC','CD','SCREEN','Screening Results','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FEC','CD','SPED','Special Education Record','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FEC','CD','OTHER','Other','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FEC','CD','GRDTRN','Grades and Transcripts','Academic');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FEC','CD','MITMEA','Mitigating Measures','Other');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FOF','MT','INR','Initial Referral','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FOF','MT','ANR','Annual Referral','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FOF','MT','REV','Re-evaluation','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FOF','MT','AMD','Amendment','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FSD','CD','A','ADHD','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FSD','CD','H','Other Health Impairment','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FSD','CD','P','Physical Impairment','');
INSERT INTO COD (TC, FC, CD, DE, CAT)
VALUES ('FSD','CD','M','Mental Impairment','');