User-Defined Tables and Columns

Do NOT create a column in the UDF table that has the same name as an existing udef column in its parent table.

If you name a column in the CANDIDACY_UDF table the same as a udef column in the CANDIDACY table, you will receive an error because J1 Desktop does not know from which table to get the data.

The following user-defined tables allow you to add unlimited user-defined columns. Request your IT Administrator to create in the database any additional columns you may need.

All user-defined tables end in _UDF and include defined primary keys of the parent table.

User-Defined Tables	Defined Primary Keys
NameAddressMaster_UDF	ID_NUM
	ADDR_CDE
ATTRIBUTE_TRANS_UDF	ID_NUM
	ATTRIB_SEQ
BIOGRAPH_MASTER_UDF	ID_NUM
CANDIDACY_UDF	ID_NUM
	YR_CDE
	TRM_CDE
	PROG_CDE
	DIV_CDE
	LOCA_CDE
CANDIDATE_UDF	ID_NUM
CATALOG_MSTR_UDF	ORG_CDE
	CRS_CDE
EX_PLANNED_GIFT_MASTER_UDF	PLANNED_GIFT_NUM
FACULTY_LOAD_UDF	YR_CDE
	TRM_CDE
	CRS_CDE
	INSTRCTR_ID_NUM
FACULTY_MSTR_UDF	ID_NUM
FIXED_ASSETS_UDF	ITEM_NUMBER
LOCATION_MASTER_UDF	LOC_CDE
NAME_MASTER_UDF	ID_NUM
ORG_TRACKING_UDF	ID_NUM
SECTION_MSTR_UDF	YR_CDE
	TRM_CDE
	CRS_CDE
SPORTS_TRACKING_UDF	ID_NUM
	YR_CDE
	TRM_CDE
	SPORTS_CDE
SOURCE_DEFINITION_UDF	SOURCE_CDE