Physical Mapping Tables

What are Physical Mapping Tables?

Physical mapping tables and columns are ones that map directly to the corresponding table and column in the J1 database.

(By contrast, 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.)

List of Physical Mapping 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.

ALUMNI_MASTER

APPL_MASTER

APPL_MASTER_UDF

APPL_REFS

APPL_REFS_UDF

ARCH_STUDENT_INFO

ATTRIBUTE_TRANS

ATTRIBUTE_TRANS_UDF

BIOGRAPH_MASTER

BIOGRAPH_MASTER_UDF

CANDIDACY

CANDIDACY_UDF

CANDIDATE

CANDIDATE_UDF

CM_EMERG_CONTACTS

DEGREE_HISTORY

DEGREE_HISTORY_UDF

DEV_PERSON

DEV_RELATIONS

DONOR_MASTER

EDU_EARN_HIST

EDU_EARN_HIST_UDF

EMPL_PROF_AFFIL

EMPL_PROF_AFFIL_UDF

EX_GIFT_CATEGORY_PATRONS

EX_GIFT_CATEGORY_STAFF

EX_PLANNED_GIFT_MASTER

EX_PLANNED_GIFT_MASTER_UDF

EXTERNAL_EMPLOYMENT_HIST

EXTERNAL_EMPLOYMENT_HIST_UDF

FERPA_PERMISSION_DETAIL

ITEMS

LEAVE_OF_ABSENCE

MAJOR_DONOR

MILITARY_SERVICE_MASTER

MILITARY_SERVICE_MASTER_UDF

NameAddressMaster_UDF

NAMEMASTER_UDF

ORG_MASTER

PersonName

POS_APPL

POS_APPL_UDF

RELATION_TABLE

SALUTATION

STUDENT_DIV_MAST

STUDENT_DIV_MAST_UDF

STUDENT_MASTER

STUDENT_MASTER_UDF

STUDENT_TERM_TABLE

TX_RESIDENCY_APPLICATION