_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:
|
Contact_Name | Contact Name. One of:
|
Contact_foreignkey | Foreign key reference to the table containing the contact information. One of:
|
Contact_Table_Source | Name of the table containing the contact information. One of:
|
ADE_ParentNumber | OnSIS Parent Number. [Students]State_StudentNumber + LNPG_Reference as defined above |
StudentID | Student ID. [Students]ID |
SortOrder | Sort Order. One of:
|