| STATIONNUMBER |
PATS does a join between the PATS report_of_contact table
and the std_institution table, to select this field into the rollup table and
the report tables.
|
VISN_ID |
PATS uses this field when building data for the rollup and
for one PATS report provided for the National Program Office. PATS first does
a JOIN between the PATS report_of_contact table and the std_institution table
to select the institution at which a patient complaint was made. It then uses
the results of the first join to do a second join on the std_institution table
to select an entry with an ID matching the visn_id field of the first entry,
in order to get the name of the VISN.
|
VISTANAME |
PATS does a join between the PATS report_of_contact table
and the std_institution table, to select this field into the rollup table and
the report tables.
|
ID |
PATS has several foreign key references to the ID field on
the std_institution table. This field is used both to do joins between the
PATS tables and the std_institution table to build tables used for reporting,
and to screen data so that users see only the data for their own division.
|
