Attached are several custom views we use at the University of St. Francis within our portlets as well as within many other reporting applications. They help us more easily get data without worrying so much with performing outer joins and helps to centralize some of the SQL logic and complexity:
- Person and organization information such as name, date of birth, age, ssn, etc (usfv_general_person.sql)
- Email address information (usfv_preferred_email_address.sql and function F_USF_GET_GOREMAL.fnc)
- Mailing Address Information (usfv_addr_rowid.sql and USFV_ADDR_DETAIL.sql)
- Telephone Number Information (USFV_TELE_ROWID.sql and USFV_TELE_DETAIL.sql)