Skip to main content
Skip table of contents

_ON_LNPG_CONTACTS_

This view returns all of the contacts that can be selected for a student for association with an enrollment in a literacy and numeracy class - i.e. Mother, Father, Guardian, and all Contacts for which the association = "LNPG".

If the "ON_LNPG_Contacts_Only" preference is present and has the value "1", the view returns only rows from the S_CONTACTS_S table (i.e. Contact_Table_Source = 'S_CONTACTS_S'). If the preference is undefined, or has a value of null, the view returns rows from both the STUDENTS and S_CONTACTS_S tables (i.e. Contact_Table_Source = 'STUDENTS' and 'S_CONTACTS_S').

The view is used by class enrollment data entry pages, the continuing education literacy and numeracy register, and the OnSIS night school and summer school submissions.

The view is defined as follows:

Field

Description

LNPG_Reference

Literacy and Numeracy Parent/Guardian Reference. One of:

  • If source is [Students]Mother
    • set to "M" and [Students]ID
  • If source is [Students]Father
    • set to "F " and [Students]ID
  • If source is [Students]Guardian_LN, Guardian_FN and Guardian_MN
    • set to "G" and [Students]ID
  • If source is [S_Contacts_S]Last_Name, First_Name and Middle_Name
    • set to "C" + [S_Contacts_S]ID

Contact_Name

Contact Name. One of:

  • [Students]Mother when not empty
  • [Students] Father when not empty
  • [Students]Guardian_LN + ", " + Guardian_FN + " " + Guardian_MN when any of the fields is not empty
  • [S_Contacts_S]Last_Name + ", " + First_Name + " " + Middle_Name for contacts associated with the student via a [S_Contact_Relationship_C] record that have [S_Contact_Relationship_C]Association = "LNPG"

Contact_foreignkey

Foreign key reference to the table containing the contact information. One of:

  • [Students]ID
  • [S_Contacts_S]ID

Contact_Table_Source

Name of the table containing the contact information. One of:

  • 'STUDENTS'
  • 'S_CONTACTS_S'

ADE_ParentNumber

OnSIS Parent Number. [Students]State_StudentNumber + LNPG_Reference as defined above

StudentID

Student ID. [Students]ID

SortOrder

Sort Order. One of:

  • If source is [Students]Mother then set to 1
  • If source is [Students]Father then set to 2
  • If source is [Students]Guardian_LN, Guardian_FN and Guardian_MN then set to 3
  • If source is [S_Contacts_S]Last_Name, First_Name and Middle_Name then set to 4 concatenated with [S_Contacts_S]ID
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.