The
University
of
Vermont

 

BANNER Table Basics (Incl top 10 tables). 

What Is A PIDM?
(From Page 1-7 in the General Object Access manual)

If you’ve worked with Banner2000, you’ve probably heard the term PIDM. The question, what is a PIDM, is often asked.
Since PIDM is a key attribute in many of the Object: Access views, it is important that you understand what one is. The list
below highlights aspects of a PIDM that will help you better understand the concept.

  • PIDM stands for Personal Identification Master
  • A PIDM is an internal identification number which Banner2000 assigns to various entities, such as a person or company
  • It is an internal number that users do not see
  • The PIDM is unique to each entity; therefore two different entities, like people or companies, will not have the same PIDM
  • The PIDM for a particular entity is the same across all products and modules
  • Since a PIDM can be related to a person/ entity and the PIDM is consistent across the Banner2000 system, it is often the only thing that a person/ entity has in common throughout the many tables in the database
  • Because it is unique and because it is often the one piece of information that is the same among tables, a PIDM is used to join tables. (Joining tables is what enables you to access data from many different areas in the Banner2000 database. Table joins an important aspect of the Object: Access architecture.)
Brought to you through the courtesy of Computing and Information Technology, University of Vermont. Copyright © 1996 The University of Vermont and others. All rights reserved.

The University supports both institutional and personal web pages. The views expressed on personal web pages are strictly those of the author, and are not reviewed or approved by the University of Vermont

Send questions and comments to  Keith.Kennedy@uvm.edu

Read the Webmaster's Policies.
Last page update: November 11, 1998