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.)
![]() |
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 |