The Synergetic development team have developed views from the Synergetic database tables to make querying the Synergetic database an easier process.
The views contain links between several base tables, that include related information that can be used in similar queries. The information can be from single fields or generated fields.
Links (or joins) can be made between several views and base tables but sometimes the linking process can be difficult. Contact Synergetic Management Systems if you want to request a field to be added to an existing view or you require assistance with joining tables.
Details on the views are provided in two sections, based on where the primary data is sourced:
- Main Synergetic database. See Main Synergetic views.
- Finance database. See Main Finance views.
Note: New views are created and released during each Synergetic update. See What's new to Extracting data.
Tip: Views are listed in alphabetic order in each topic. If you are using Synergetic Online Help you can also find a view by typing its name on the Search tab. In the example below, vCommunityAddresses is found in two topics..gif)
Fields
Fields contain all of the information that is maintained in Synergetic. You can use any field you want in your query but it is recommended that you select the fields from a view.
The following table lists fields useful for filtering data:
Field | Value | Additional information |
|---|---|---|
DeceasedFlag | 0 | Only retrieve records of people not deceased. |
ValidAddressFlag | 1 | 1 = True |
CurrentSemesterOnlyFlag | 1 | 1 = True |
FileYear | 2014 | |
FileSemester | 1, 2, ...n | |
StudentStatus | <> 'LFT' | See luStudentStatus in the System Maintenance manual. |
StudentContactType | 'SC1', 'SC2' or 'SCT' | See luContact in the System Maintenance manual. |
StudentContactNormalMailFlag | 1 | 1 = True |
Generated fields
Generated fields can be one or more fields that have been combined and manipulated together to create another new field.
The following table provides details about useful generated fields:
Generated field | Description | Example |
|---|---|---|
MailSalutation | Combines the title of a person with their surname. | Mr Johnson |
If this person has a spouse and the Address to primary only field on the Contact tab of Student Maintenance is not selected, their title will be joined with the partner's. | Mr and Mrs Johnson | |
MailName | Combines the title, first name and surname. | Mr P Johnson |
AddressComma | A comma-delimited address useful for:
| 4/303 Burwood Hwy, Burwood East, Vic, 3151 |
AddressFull | A carriage return/line feed-delimited address useful for:
| 4/303 Burwood Hwy |