|
You have the ability to 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 the J1 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 (i.e., the Candidate tab of the Maintain Candidacy window) for the last high school or the last organization, the corresponding column(s) in the other window (i.e., the Organizations tab of the Maintain Candidacy window) is/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. |
Physical mapping tables and columns are ones that map directly to the corresponding table and column in the J1 database.
Table Name |
Column Name |
||
ATTRIBUTE_TRANS |
ATTRIB_BEGIN_DTE |
||
ATTRIBUTE_TRANS |
ATTRIB_DEF |
||
ATTRIBUTE_TRANS |
ATTRIB_END_DATE |
||
ATTRIBUTE_TRANS |
ATTRIBUTE_CDE |
||
BIOGRAPH_MASTER |
ACTIVE_DUTY_ARMED_SVCS_BRANCH |
||
BIOGRAPH_MASTER |
BIRTH_DTE |
||
BIOGRAPH_MASTER |
BLOCK_LOANS_PATRON |
||
BIOGRAPH_MASTER |
CITIZEN_OF |
||
BIOGRAPH_MASTER |
CURRENT_EMPLOY_TYP |
||
BIOGRAPH_MASTER |
DISABILITY_STS |
||
BIOGRAPH_MASTER |
EMPLOYEE_OF_COLLEG |
||
BIOGRAPH_MASTER |
ENTRANCE_CDE |
||
BIOGRAPH_MASTER |
ETHNIC_GROUP |
||
BIOGRAPH_MASTER |
FIN_AID_REQUEST |
||
BIOGRAPH_MASTER |
GENDER |
||
BIOGRAPH_MASTER |
HIGHEST_DEGR_EARN |
||
BIOGRAPH_MASTER |
IS_ACTIVE_DUTY_ARMED_SVCS |
||
BIOGRAPH_MASTER |
LIB_PATRON_GRP |
||
BIOGRAPH_MASTER |
MARITAL_STS |
||
BIOGRAPH_MASTER |
NONRESIDENT_ALIEN |
||
BIOGRAPH_MASTER |
PREV_ENROLL_CEU |
||
BIOGRAPH_MASTER |
PREV_ENROLL_CREDIT |
||
BIOGRAPH_MASTER |
RELIGION |
||
BIOGRAPH_MASTER |
SPOUSE_EMPLOYEE |
||
BIOGRAPH_MASTER |
SSN |
||
BIOGRAPH_MASTER |
SSN_PRIVATE |
||
BIOGRAPH_MASTER |
UDEF_10A_1 |
||
BIOGRAPH_MASTER |
UDEF_11_2N_1 |
||
BIOGRAPH_MASTER |
UDEF_11_2N_2 |
||
BIOGRAPH_MASTER |
UDEF_1A_1 |
||
BIOGRAPH_MASTER |
UDEF_1A_2 |
||
BIOGRAPH_MASTER |
UDEF_1A_3 |
||
BIOGRAPH_MASTER |
UDEF_1A_4 |
||
BIOGRAPH_MASTER |
UDEF_1A_5 |
||
BIOGRAPH_MASTER |
UDEF_1A_6 |
||
BIOGRAPH_MASTER |
UDEF_1A_7 |
||
BIOGRAPH_MASTER |
UDEF_2A_1 |
||
BIOGRAPH_MASTER |
UDEF_2A_2 |
||
BIOGRAPH_MASTER |
UDEF_2A_3 |
||
BIOGRAPH_MASTER |
UDEF_2A_4 |
||
BIOGRAPH_MASTER |
UDEF_3A_1 |
||
BIOGRAPH_MASTER |
UDEF_3A_2 |
||
BIOGRAPH_MASTER |
UDEF_3A_3 |
||
BIOGRAPH_MASTER |
UDEF_5A_1 |
||
BIOGRAPH_MASTER |
UDEF_5A_2 |
||
BIOGRAPH_MASTER |
UDEF_DTE_1 |
||
BIOGRAPH_MASTER |
UDEF_DTE_2 |
||
BIOGRAPH_MASTER |
UDEF_ID_1 |
||
BIOGRAPH_MASTER |
UDEF_ID_2 |
||
BIOGRAPH_MASTER |
VETERAN |
||
BIOGRAPH_MASTER |
VETERAN_OF_ARMED_SVCS_BRANCH |
||
BIOGRAPH_MASTER |
VISA_TYPE |
||
CANDIDACY |
CANDIDACY_TYPE |
||
CANDIDACY |
CUR_CANDIDACY |
||
CANDIDACY |
DEGREE_CDE |
||
CANDIDACY |
DEPT_CDE |
||
CANDIDACY |
DIV_CDE |
||
CANDIDACY |
INTENDED_MINOR_PROG |
||
CANDIDACY |
JRM_APPLICATION_ID |
||
CANDIDACY |
LOAD_P_F |
||
CANDIDACY |
LOCA_CDE |
||
CANDIDACY |
PROG_CDE |
||
CANDIDACY |
SECOND_PROGRAM_OF_INTEREST |
||
CANDIDACY |
STAGE |
||
CANDIDACY |
THIRD_PROGRAM_OF_INTEREST |
||
CANDIDACY |
TRM_CDE |
||
CANDIDACY |
UDEF_11_2N_1 |
||
CANDIDACY |
UDEF_1A_1 |
||
CANDIDACY |
UDEF_3A_1 |
||
CANDIDACY |
UDEF_3A_2 |
||
CANDIDACY |
UDEF_3A_3 |
||
CANDIDACY |
UDEF_5A_1 |
||
CANDIDACY |
UDEF_5A_2 |
||
CANDIDACY |
UDEF_DTE |
||
CANDIDACY |
YR_CDE |
||
CANDIDATE |
ACAD_YR_LAST_ATTENDED |
||
CANDIDATE |
ADDITIONAL_NAMES_ON_TRANSCRIPT |
||
CANDIDATE |
ATHLETIC_PROSPECT |
||
CANDIDATE |
COUNTY_LAST_FILED_TX_RTRN |
||
CANDIDATE |
DEPENDENT_OF_VETERAN |
||
CANDIDATE |
FELONY_EXPLANATION |
||
CANDIDATE |
GED_TEST_CENTER_CITY |
||
CANDIDATE |
GED_TEST_CENTER_NAME |
||
CANDIDATE |
GED_TEST_CENTER_STATE |
||
CANDIDATE |
GED_TEST_CENTER_ZIP |
||
CANDIDATE |
GED_TEST_DTE |
||
CANDIDATE |
HAS_BEEN_CONVICTED_OF_FELONY |
||
CANDIDATE |
HAS_BEEN_ON_PROB_SUSPND_EXPLD |
||
CANDIDATE |
HAS_GED |
||
CANDIDATE |
HIGHLY_DESIRABLE |
||
CANDIDATE |
HOUSING_CDE |
||
CANDIDATE |
IS_EXEMPTION_OTHERS_TAX_RETURN |
||
CANDIDATE |
IS_PARENT_ALUMNUS |
||
CANDIDATE |
IS_PARENT_EMPLOYEE |
||
CANDIDATE |
PREVIOUSLY_APPLIED |
||
CANDIDATE |
PROB_SUSPND_EXPLD_EXPLANATION |
||
CANDIDATE |
RECEIVING_VETERANS_BENEFITS |
||
CANDIDATE |
RESIDENT_OF_STATE |
||
CANDIDATE |
RESIDENT_OF_STATE_SINCE_DTE |
||
CANDIDATE |
SOURCE
|
||
CANDIDATE |
UDEF_10A_1 |
||
CANDIDATE |
UDEF_112_1 |
||
CANDIDATE |
UDEF_112_2 |
||
CANDIDATE |
UDEF_11N_1 |
||
CANDIDATE |
UDEF_11N_2 |
||
CANDIDATE |
UDEF_11N_3 |
||
CANDIDATE |
UDEF_1A_1 |
||
CANDIDATE |
UDEF_1A_10 |
||
CANDIDATE |
UDEF_1A_2 |
||
CANDIDATE |
UDEF_1A_3 |
||
CANDIDATE |
UDEF_1A_4 |
||
CANDIDATE |
UDEF_1A_5 |
||
CANDIDATE |
UDEF_1A_6 |
||
CANDIDATE |
UDEF_1A_7 |
||
CANDIDATE |
UDEF_1A_8 |
||
CANDIDATE |
UDEF_1A_9 |
||
CANDIDATE |
UDEF_2A_1 |
||
CANDIDATE |
UDEF_2A_2 |
||
CANDIDATE |
UDEF_2A_3 |
||
CANDIDATE |
UDEF_2A_4 |
||
CANDIDATE |
UDEF_2A_5 |
||
CANDIDATE |
UDEF_2A_6 |
||
CANDIDATE |
UDEF_3A_1 |
||
CANDIDATE |
UDEF_3A_2 |
||
CANDIDATE |
UDEF_3A_3 |
||
CANDIDATE |
UDEF_3A_4 |
||
CANDIDATE |
UDEF_3A_5 |
||
CANDIDATE |
UDEF_52_1 |
||
CANDIDATE |
UDEF_5A_1 |
||
CANDIDATE |
UDEF_5A_2 |
||
CANDIDATE |
UDEF_5A_3 |
||
CANDIDATE |
UDEF_5A_4 |
||
CANDIDATE |
UDEF_5A_5 |
||
CANDIDATE |
UDEF_5N_1 |
||
CANDIDATE |
UDEF_5N_10 |
||
CANDIDATE |
UDEF_5N_2 |
||
CANDIDATE |
UDEF_5N_3 |
||
CANDIDATE |
UDEF_5N_4 |
||
CANDIDATE |
UDEF_5N_5 |
||
CANDIDATE |
UDEF_5N_6 |
||
CANDIDATE |
UDEF_5N_7 |
||
CANDIDATE |
UDEF_5N_8 |
||
CANDIDATE |
UDEF_5N_9 |
||
CANDIDATE |
UDEF_72_1 |
||
CANDIDATE |
UDEF_DTE_1 |
||
CANDIDATE |
UDEF_DTE_2 |
||
CANDIDATE |
UDEF_DTE_3 |
||
CANDIDATE |
UDEF_DTE_4 |
||
CANDIDATE |
UDEF_DTE_5 |
||
CANDIDATE |
UDEF_DTE_6 |
||
CANDIDATE |
UDEF_ID_1 |
||
CANDIDATE |
UDEF_ID_2 |
||
CANDIDATE |
YEAR_PREVIOUSLY_APPLIED |
||
CANDIDATE |
YR_STATE_TX_RTRN_LST_FILED |
||
NameAddressMaster_UDF |
ADDR_CDE |
