Synergetic views

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:

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. 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.
0 = False.

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:

  • printouts
  • using in Microsoft Excel.

4/303 Burwood Hwy, Burwood East, Vic, 3151

AddressFull

A carriage return/line feed-delimited address useful for:

  • mail merges
  • labels.

4/303 Burwood Hwy
Burwood East Vic 3151