The Synergetic development team have developed views from the Synergetic database tables to make querying the Synergetic database an easier process.
...
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)
See Previous versions.
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 |
...
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 |
...