0 pts.
 Central person Object – HELP REQUIRED
How do you create a "Central Person" object, which is linked to one or more personnel numbers? Thanks

Software/Hardware used:
ASKED: February 2, 2006  4:56 AM
UPDATED: February 2, 2006  12:12 PM

Answer Wiki:
Please define your environment. Are you working with an Oracle database? Are you referring to one of Oracle's application products? In general terms, a "Central Person" object suggests a table containing various personnel numbers assigned to a person. For example, in the Florida Driver License Information System (developed in-house and using Oracle 8i), we assign each person a unique number for internal use only and store that number along with Driver License Number and other personal identifiers including name. Name, DL #, etc. are used to for reporting and inquiries, but most DL tables contain that internal use only key. We do this because name changes not only affect the name key, but also the DL #, which is partially generated from the name. If that is what you mean by a "Central Person" object, ours is a table as described above. It's primary key is that internal use only number. Other tables have foreign key constraints to that table's primary key. Reports and inquiries use Name, DL # and other "real world" keys and those are "translated" using the "Central Person" table.
Last Wiki Answer Submitted:  February 2, 2006  12:12 pm  by  Stevewaltz   0 pts.
All Answer Wiki Contributors:  Stevewaltz   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _