Relationships Tab (Review Submitted FERPA Permissions Window)

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.

Options

The following options are available from the Relationships tab:

ELITE PAINT

Add Row

Insert Row

Delete Row

Restore Row

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)

Mappings

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

 

 

How To

Create a Relationship Row?

Related Topics

Review Submitted FERPA Submissions Window

Relationships Window

Common Functionality for Grid Windows