| INTEGRATED PATIENT FUNDS |
The VPFS package will create the INSTITUTION view that
references the following SDS tables / fields:
1) STD_INSTITUTION Table: Fields: id, name, stationnumber, vistaname,
streetcountry_id, streetaddressline1, streetaddressline2,
streetaddressline3, streetcity, streetpostalcode 2) STD_STATE Table:
Fields: postalname 3) STD_COUNTRY Table: Fields: shortname 4) STD_FACILITYTYPE
Table: Fields: code
This view is used to provide a consolidated view of institution data from the
SDS tables (as detailed above) and the VPFS_INSTITUTION table, which contains
institution-specific data used by VPFS.
The SELECT privilege is granted to the VPFS user for the STD_INSTITUTION,
STD_STATE, STD_COUNTRY, and STD_FACILITYTYPE tables.
|
