Logical Mapping Tables

What Are Logical Mapping Tables?

Logical mapping tables and their columns are ones that are logically grouped together but actually map to a different table or column in the J1 database. Often the columns in a logical mapping table actually represent columns from multiple tables. When data from a logical mapping table is processed, the J1 Desktop application will properly save the data to the appropriate database table.

(By contrast, physical mapping tables and their columns are ones that map directly to the corresponding table and column in the J1 database.)

List of Logical Mapping Tables and Their Corresponding Physical Tables

You can map data into the HIGH_SCHOOL, LAST_ORG_ATTEND, and GRAD_YR_LAST_ORG columns on the CANDIDATE table.
 
However, you should be very cautious about using these mapping columns if you are also mapping data to the columns of the ORG_TRACKING mapping table. There is a tie in theJ1 code between the data stored in the CANDIDATE table and the AD_ORG_TRACKING table in the database.  
 
For example, if a change is made in one window (the Candidate tab of the Maintain Candidacy window) for the last high school or the last organization, then the corresponding columns in the other window (the Organizations tab of the Maintain Candidacy window) are updated to ensure that the two tables stay in sync.
 
Additionally, the Graduation Year column on the Candidate tab of the Maintain Candidacy window may be updated from the submitted organization data depending upon the value of the Candidate Grad Year configuration (set through the Configure Function window).
 
Therefore, if data from a form is mapped to both sets of mapping columns, it is possible that the data may become out of sync or that one value may overwrite the other. Jenzabar recommends that you consistently use the mapping columns for one of the tables rather than using both mapping tables in the same form.

Logical Mapping Table

Corresponding Physical Tables

AD_ACTIVITIES_AND_PERIODS

AD_ACTIVITY

AD_ACTIVITY_PERIOD

ADDRESS_MASTER

NameAddressMaster

AddressMaster

AD_SCHOLARSHIP

AD_SCHOLARSHIP

ALTERNATE_IDENTIFIER

ALTERNATE_IDENTIFIER

BIOGRAPH_ETHNIC_RACE

ETHNIC_RACE_REPORT

ETHNIC_REPORT_DTL

RACE_REPORT_DTL

CANDIDACY_ATTACHMENT

ATTACHMENT

CANDIDACY_ATTACHMENT

FERPA_PERMISSION

FERPA_PERMISSION

FERPA_PERMISSION_DETAIL

FORM_NOTE

ITEMS

NAME_MASTER

NameMaster

ORG_TRACKING

AD_ORG_TRACKING

ORG_TRACKING

RELATED_PERSON

AddressMaster

BIOGRAPH_MASTER

NameMaster

RELATION_TABLE

TEST_SCORES

TEST_SCORES

TEST_SCORES_DETAIL