datamap.py

incidents_columns = [
    "Actions",
    "AddlReqs",
    "AdminSummary",
    "Category",
    "CategoryID",
    "Context",
    "CreateBy",
    "CreateFirst",
    "CreateLast",
    "CreateTS_date",
    "FamilyMeetingNotes",
    "GradeLevelShort",
    "HomeroomName",
    "IncidentID",
    "Infraction",
    "InfractionTypeID",
    "IsActive",
    "IsReferral",
    "IssueTS_date",
    "Location",
    "LocationID",
    "Penalties",
    "ReportedDetails",
    "SchoolID",
    "SendAlert",
    "Status",
    "StatusID",
    "StudentID",
    "StudentSchoolID",
]

comms_columns = [
    "DLSchoolID",
    "SchoolName",
    "DLCallLogID",
    "DLStudentID",
    "StudentSchoolID",
    "SecondaryStudentID",
    "DLUserID",
    "UserSchoolID",
    "UserFirstName",
    "UserLastName",
    "CommWith",
    "CallType",
    "CallStatus",
    "Reason",
    "PersonContacted",
    "Relationship",
    "PhoneNumber",
    "MailingAddress",
    "ThirdParty",
    "Email",
    "CallDateTime",
    "CallTopic",
    "Response",
    "FollowupID",
    "FollowupBy",
    "FollowupInitTS",
    "FollowupRequest",
    "FollowupCloseTS",
    "FollowupOutstanding",
    "FollowupResponse",
    "IsActive",
    "SourceType",
    "SourceID",
    "DL_LASTUPDATE",
]

behaviors_columns = [
    "DLOrganizationID",
    "DLSchoolID",
    "SchoolName",
    "DLStudentID",
    "StudentSchoolID",
    "SecondaryStudentID",
    "StudentFirstName",
    "StudentMiddleName",
    "StudentLastName",
    "DLSAID",
    "BehaviorDate",
    "Behavior",
    "BehaviorID",
    "BehaviorCategory",
    "PointValue",
    "DLUserID",
    "StaffSchoolID",
    "StaffTitle",
    "StaffFirstName",
    "StaffMiddleName",
    "StaffLastName",
    "Roster",
    "RosterID",
    "SourceType",
    "SourceID",
    "SourceProcedure",
    "Notes",
    "DL_LASTUPDATE",
]