Data Change Requests for Ver 2015

There is no predicted release date for these changes at this time.

Attendance –

  • Create tables for Student Historical Absence.
  • Create a Roll Change Log file.
  • Create a table for attendance Codes  ATT_CODE
    • REASON_TEXT   Asc  100
    • REASON_CODE  Asc  2
    • AUDIT_CODE  Asc  2
    • TRUANCY_CODE  Asc  2
    • CALC_HALFDAY   Asc  2
    • HIDE_FROM_SPIDER  Asc  1
  • Create ROLL_LOG
    • Roll#   integer
    • Status  Asc  1
    • Teacher#  (userID)
    • Date
    • Time  Hr.Min
  • Add to Roll Table
    • field for Duration and Marked Status to indicate if marked or not.
    • field for duration
  • Add to TimePdHd filed for Period_ID
  • Absent Record Add field  Time as  hh.min

POS – Add a comment text field to the Stock master file. Requested by Cathedral Grammar


  • Add field to FamEnq checkbox  Inactive
  • EnqStud add checkbox for Enrolled

MEDICAL – Add a tick box to Medical Incident for Email Sent  –  Moama

LEDGER – Add Budget capacity to KPI’s

PAYROLL – Add Payroll Employee Comment table similar to Debtor Comments enabling dated, categorized comment entry (encrypted)  Padua College

SSOBJCTS – Add a field for Category (related to module used) – Add a sub table for specific controls where this object is used


Crdmast – Add Country to each address as well as City

– Add checkbox  Preferred Supplier to limit creditors displayed to Order entry to preferred supplieres only

UserDefi – UserDef – Add field for eForm ID# to enable data to be tied to an eForm

Identity – Add Title  (same length as in Family) Salutation  (Formal – already Salutation), Informal),  Address Silent  Phone Silent  Add Religion. Add field for personal Email  as well as work email

Student Add field for personal Email  as well as work email

Enquiry  Add Religion

Debtors  Add Tagset to DeBatchC to enable tagset check to be carried through to Macro.  Add Tagset to MacroBod Y/N


  • Add Invoice Number to specific invoices to enable invoices to be printed, as well as statement
  • Add table to store multiple discounts structure + Table to store discount categories associated with a student.

WORKAREA  add field to show SNAPSHOT Original Workarea Database and Date Created

Libsys – Add fields for Enable Copies to have different Item Types & Enable copies to have different Call numbers (replace fields currently used in Preferences.ini)

Teacher  Add field for Working with Children Card number  +  Expiry Date

Subject  – Add a field for Print Order

Alumrel  Add fields to bring in line with Freedom Model

REPORT  Create Table REPSEC to store securible groups associated with the report



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s