Texas A&M University - Infrastructure Services

Schema Change Log

Global Changes

Date Change
02/20/2007 Role-based affiliation information added to directory.
11/12/2007 All tamuEduPersonAffiliation roles scoped (role@location) in tamuEduPersonScopedAffiliation.
02/01-04/2008 Conversion to new mailstore. All entries possessing a TAMU Email account are provisioned with the tamuEduZimbraUser objectclass.
6/2/2009 Discontinue population of ssn, studentID, employeeNumber, and deliverMailbox.

People Branch

  1. General person attributes
    • General person attributes: Identifiers, access-related attributes, general information
    • General person attributes: General personal and organizational identification
      Role-based Affiliations:
      • TAMU Role-Based Affiliations (tamuEduPersonAffiliation)
        Date Change
        02/20/2007 implemented population of attribute
        10/03/2007 added affiliate:12man to permissible values
        10/08/2007 added affiliate:qatar to permissible values
        3/5/2009 collapsed two two-part employee flags assigned to every employee to one three-part employee flag

        Flags being deprecated:
        employee:active
        employee:retired
        employee:loa
        employee:workingretiree
        employee:faculty
        employee:staff
        employee:studentworker
        employee:graduateassistant

        Flags being added:
        employee:faculty:active
        employee:faculty:workingretiree
        employee:faculty:loa
        employee:faculty:retired
        employee:faculty:terminated
        employee:faculty:deceased
        employee:staff:active
        employee:staff:workingretiree
        employee:staff:loa
        employee:staff:retired
        employee:staff:terminated
        employee:staff:deceased
        employee:studentworker:active
        employee:studentworker:terminated
        employee:studentworker:deceased
        employee:graduateassistant:active
        employee:graduateassistant:terminated
        employee:graduateassistant:deceased
        affiliate:administrativestudent
      • Higher Ed Affiliations (eduPersonAffiliation)
        Date Change
        02/20/2007 implemented population of attribute
      • Higher Ed Primary Affiliation (eduPersonPrimaryAffiliation)
        Date Change
        02/20/2007 implemented population of attribute
      Role@Location Affiliations:
      • TAMU Scoped Affiliations (tamuEduPersonScopedAffiliation)
        Date Change
        02/20/2007 implemented population of attribute (tamuEduPersonAffiliation student flags only)
        11/12/2007 began populating scoped tamuEduPersonAffiliation employee, faculty, and affiliate flags
      • Higher Ed Scoped Affiliations (eduPersonScopedAffiliation)
        Date Change
        02/20/2007 implemented population of attribute
      Course-based Affiliations:
      • Course Affiliation URNs (eduCourseOffering)
        Date Change
        01/28/2009 implemented population of attribute
      Role@Course Affiliations:
      • Scoped Course Affiliations (eduCourseMember)
        Date Change
        01/28/2009 implemented population of attribute
    • General person attributes: Resource Authorization
      • Resource Entitlement URNs (eduPersonEntitlement)
        Date Change
        02/01/2008 implemented population of attribute
    • General person attributes: Electronic Mail
      • TAMU Email (Neo) Mail Host (mailHost)
        Date Change
        03/07/2008 implemented population of attribute
      • TAMU Email (Neo) Account Id (tamuEduZimbraId)
        Date Change
        03/07/2008 implemented population of attribute
  2. Entry management attributes (attributes for identity, reconciliation, selection, and directory build)
    • Object Classes Assigned to Entry (objectClass)
      Date Change
      02/20/2007 objectClasses eduPerson, tamuEduPerson assigned to every entry
      All entries associated with a feed or data source are checked and assigned the two objectClasses.
      All new entries will automatically be assigned these two objectClasses.
      Entries not associated with any major data source at the time of the initial assignment will not be allocated these objectClasses. It is expected that these entries will be expired/deleted very shortly.
      02/01/2008 objectClass tamuEduZimbraUser assigned to every entry with a TAMU Email (Neo) account
    • Data Source (tamuEduDataFeed)
      Date Change
      10/03/2007 new data source 12MAN added
      10/08/2007 new data source QATAR added
      09/01/2008 new data source EIS added
    • Account Status (tamuStatus)
      Date Change
      07/15/2007 added ssprLocked to permissible values
      11/19/2007 added passwordForgotten to permissible values (replaces passwordDisabled)
      11/3/2008 added securityLocked to permissible values
      6/2/2009 dropped affiliation:applicant, affilation:admitted, affiliation:enrolled, affiliation:administrativeStudent, affiliation:retired, affiliation:deceased, affiliation:leave-of-absence, ManualAddNonRenewable from permissible values