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