Create
a Relationship Row?If the Submission Type is FERPA Permissions (550), this tab is displayed even if no relationship code is submitted. This tab is used to review any existing relationship information as well as view a new relationship row generated from the submitted data that needs to be saved to the RELATION_TABLE. The relationship information is displayed in a grid on this tab.
The following options are available from the Relationships tab:
Advanced Search (only available if you click on or select the ID Number column) |
Previous Name (only available if you click on or select the ID Number column) |
The mapping information will only be used after a parent has been assigned an ID Number on the FERPA Permissions tab through the selection of ID Number via the Duplicate Name Search window or creation of a new ID Number. This allows you to use the submitted information for the parent and the relationship code to generate a new relationship row.
The following table details population of database columns and mapping of submission data for the Relationships tab.
Column Label |
Database Table Name |
Database Column Name |
Available for Mapping? |
Mapping Table Name |
Mapping Column Name |
Relationship |
RELATION_TABLE |
REL_CDE |
Y |
FERPA_PERMISSION |
REL_CDE |
ID Number |
RELATION_TABLE |
REL_ID_NUM |
N |
|
|
) is displayed if
an ID Number is available for the parent and a Relationship Code value
was submitted and if no row exists in the Relation Table for the selected
student ID Number and specified parent ID Number and the submitted
relationship code.