Candidacy Tab (Review Internet Submission Window)

If the Submission Type is Admissions Inquiry - New (320), or Admissions Application - New (330), this tab may be displayed even if no data is submitted for the CANDIDATE and CANDIDACY mapping tables. If available, this tab is used to review any information that is included in a submission that needs to be saved to the CANDIDATE table in the J1 database.

Grids

The Submitted Candidacy grid displays the Submitted Candidacy row, which includes the Submitted Program, Submitted Year, Submitted Term, Submitted Division, Submitted Location, Submitted Stage, and Submitted Current (Candidacy). It is displayed above the Multiple Candidacy grid that displays existing Candidacy rows including the existing Current Candidacy row.

The Multiple Candidacy grid allows you to view all Candidacy rows to determine if the information submitted is an update to an existing Candidacy or if the submission is a new Candidacy. You can associate the submitted data with an existing Candidacy row, compare the data and then save the data to that row, or you can create a new Candidacy row. Any Candidacy-related information submitted (including user-defined information) will be saved to the selected or new Candidacy row. Depending on the data submitted, some of the columns in the Submitted Candidacy row may be empty; if no Candidacy information was submitted, the entire Submitted Candidacy row will be empty.

By default, the Submitted Candidacy row is selected. If you click on this row, any submitted data is displayed in the 6 subtabs at the bottom of the window. If you click on an existing Candidacy row in the Multiple Candidacy grid, its data is displayed in the 6 subtabs at the bottom of the window.

Subtabs

Columns and Mappings

Requirements (displays current database information from the Requirements table)

Submitted fee information can be viewed by selecting the submitted data row in the top grid on the Candidacy tab and then selecting the Fees subtab. Submitted fee information will automatically be associated with the selected Candidacy row (i.e., existing or new).

Columns and Mappings

History (displays current database information from the Stage History Transaction table)

If there are submitted values mapped to columns on the table currently being used on the User Defined subtab but there is no column available on the InfoMaker form that corresponds to the mapped column, the following message is displayed: "There are submitted values for the user-defined columns on this table, but they are not currently displayed on this InfoMaker form. Please see the Submissions Report for this submission to see these values."

Columns

Submitted scholarship information can be viewed by selecting the submitted data row in the top grid on the Candidacy tab and then selecting the Scholarships subtab. Submitted scholarship information will automatically be associated with the selected Candidacy row (i.e., existing or new).

Columns and Mappings

This subtab is used to review any attachment information that is included in a submission. The Attachments subtab is available if there is attachment data available for the current submission.

Candidacy Documents

General Notes

Stage Processing

When a Candidacy row is saved to the CANDIDACY table per mapping values detailed on the General and User Defined subtabs, stage processing may also take place.

If the Stage column for an existing Candidacy row has been modified or a new Candidacy row has been created and you choose to do the Stage Change processing when prompted, the Stage Date is set to the current date and time. Also, appropriate Action Lists are attached to the candidate's Notepad (or Action Lists stopped), and appropriate Requirement Lists are attached to the Candidacy.

Additionally, if the Stage for any one of the candidate's candidacies are in a campus portal (JICS) creation stage (i.e., the Candidate campus portal (JICS) Account Create radio button is selected on the Edit Stage Configuration window for that stage), a campus portal (JICS) Account is created if it does not already exist. The Candidacy and the Candidate role are also created in campus portal (JICS) for this ID Number. If all the Stages of the existing Candidacy rows are in a campus portal (JICS) Delete stage (i.e., the Candidate campus portal (JICS) Account Delete radio button is selected on the Edit Stage Configuration window), the campus portal (JICS) Candidate role is deleted.

Column Label	Database Table Name	Database Column Name	Available for Mapping?	Mapping Table Name	Mapping Column Name
Program	CANDIDACY	PROG_CDE	Y	CANDIDACY	PROG_CDE
Year	CANDIDACY	YR_CDE	Y	CANDIDACY	YR_CDE
Term	CANDIDACY	TRM_CDE	Y	CANDIDACY	TRM_CDE
Division	CANDIDACY	DIV_CODE	Y	CANDIDACY	DIV_CODE
Location	CANDIDACY	LOCA_CDE	Y	CANDIDACY	LOCA_CDE
Part/Full Time	CANDIDACY	LOAD_P_F	Y	CANDIDACY	LOAD_P_F
Cand Type	CANDIDACY	CANDIDACY_TYPE	Y	CANDIDACY	CANDIDACY_TYPE
Department	CANDIDACY	DEPT_CDE	Y	CANDIDACY	DEPT_CDE
Degree	CANDIDACY	DEGREE_CDE	y	CANDIDACY	DEGREE_CDE
Minor Program	CANDIDACY	INTENDED_MINOR_PROG	Y	CANDIDACY	INTENDED_MINOR_PROG
2nd Prog of Interest	CANDIDACY	SECOND_PROGRAM_OF_INTEREST	Y	CANDIDACY	SECOND_PROGRAM_OF_INTEREST
3rd Prog of Interest	CANDIDACY	THIRD_PROGRAM_OF_INTEREST	Y	CANDIDACY	THIRD_PROGRAM OF INTEREST
Stage	CANDIDACY	STAGE	Y	CANDIDACY	STAGE
Current	CANDIDACY	CUR_CANDIDACY	Y	CANDIDACY	CUR_CANDIDACY
Stage Date	CANDIDACY	HIST_STAGE_DTE	N
Sent to RE	CANDIDACY	TRANSF_TO_RE_DTE	N
Stop Transfer to RE	CANDIDACY	STOP_RE_TRANSFER	N
Minimum Met (Req.)	CANDIDACY	REQ_MIN_MET	N
Completed (Req.)	CANDIDACY	REQ_COMPLETE	N
Released (Req.)	CANDIDACY	REQ_RELEASED	N
	CANDIDACY	ACT_LIST_COMP_1	N
	CANDIDACY	ACT_LIST_COMP_2	N
	CANDIDACY	ACT_LIST_COMP_3	N
	CANDIDACY	WAITLIST_DTE_DTE	N
	CANDIDACY	WAITLIST_TIM	N
	CANDIDACY	DEFER_TO_FRM_FLG	N
	CANDIDACY	DEFER_TO_YR	N
	CANDIDACY	DEFER_TO_TRM	N
	CANDIDACY	DEFER_TO_PROG	N
	CANDIDACY	DEFER_TO_DIV	N
	CANDIDACY	DEFER_TO_LOC	N
	CANDIDACY	DEFER_TO_STAGE	N
	CANDIDACY	DEFER_FRM_YR	N
	CANDIDACY	DEFER_FRM_TRM	N
	CANDIDACY	DEFER_FRM_PROG	N
	CANDIDACY	DEFER_FRM_DIV	N
	CANDIDACY	DEFER_FRM_LOC	N
	CANDIDACY	DEFER_FRM_STAGE	N
	CANDIDACY	QUICKKEY	N

Column Label	Database Table Name	Database Column Name	Available for Mapping?	Mapping Table Name	Mapping Column Name
Fee Type	CANDIDACY	APP_FEE_TYPE	Y	CANDIDACY	APP_FEE_TYPE
Fee Date	CANDIDACY	APP_FEE_DATE	Y	CANDIDACY	APP_FEE_DATE
Fee Amount	CANDIDACY	APP_FEE_AMT	Y	CANDIDACY	APP_FEE_AMT
Fee Type	CANDIDACY	ENROLL_FEE_TYPE	Y	CANDIDACY	ENROLL_FEE_TYPE
Deposit Date	CANDIDACY	ENROLL_DEP_DTE	Y	CANDIDACY	ENROLL_DEP_DTE
Deposit Amount	CANDIDACY	ENROLL_DEP_AMT	Y	CANDIDACY	ENROLL_DEP_AMT
Admission Release	CANDIDACY	AD_RELEASE	Y	CANDIDACY	AD_RELEASE

Column Label	Database Table Name	Database Column Name	Available for Mapping?	Mapping Table Name	Mapping Column Name
	AD_SCHOLARSHIPS	YR_CDE	N
	AD_SCHOLARSHIPS	TRM_CDE	N
	AD_SCHOLARSHIPS	PROG_CDE	N
	AD_SCHOLARSHIPS	DIV_CODE	N
	AD_SCHOLARSHIPS	LOCA_CDE	N
	AD_SCHOLARSHIPS	SCHOLARSHIP_ID	N
Scholarship Type	AD_SCHOLARSHIPS	SCHOLARSHIP_TYPE	Y	AD_SCHOLARSHIPS	SCHOLARSHIP_TYPE
Date Awarded	AD_SCHOLARSHIPS	DATE_SCHOLARSHIP_AWARDED	Y	AD_SCHOLARSHIPS	DATE_SCHOLARSHIP_AWARDED
Amount	AD_SCHOLARSHIPS	SCHOLARSHIP_AMOUNT	Y	AD_SCHOLARSHIPS	SCHOLARSHIP_AMOUNT
Date Accepted	AD_SCHOLARSHIPS	DATE_SCHOLARSHIP_ACCEPTED	Y	AD_SCHOLARSHIPS	DATE_SCHOLARSHIP_ACCEPTED
Nominator ID Number	AD_SCHOLARSHIPS	NOMINATOR_ID_NUM	N
Nominator Name			N
Date Reviewed	AD_SCHOLARSHIPS	DATE_SCHOLARSHIP_REVIEWED	Y	AD_SCHOLARSHIPS	DATE_SCHOLARSHIP_REVIEWED
Transferred to FA	AD_SCHOLARSHIPS	TRANSFER_TO_PF	Y	AD_SCHOLARSHIPS	TRANSFERRED_TO_PF
Amount Per Semester	AD_SCHOLARSHIPS	AMOUNT_PER_SEMESTER	Y	AD_SCHOLARSHIPS	AMOUNT_PER_SEMESTER
Amount Per Year	AD_SCHOLARSHIPS	AMOUNT_PER_YEAR	Y	AD_SCHOLARSHIPS	AMOUNT_PER_YEAR

Column Label	Database Table Name	Database Column Name	Available for Mapping?	Mapping Table Name	Mapping Column Name
	ATTACHMENT	ATTACHMENT_ID	N
Attachment Number	CANDIDACY_ATTACHMENT	CANDIDACY_ATTACH_SEQ_NUM	N
Submission Date	ATTACHMENT	CREATION_DTE	N
Submission Type	CANDIDACY_ATTACHMENT	SUBMISSION_TYPE	N
Attachment Description	ATTACHMENT	ATTACHMENT_TYPE_CDE	Y	CANDIDACY_ATTACHMENT	ATTACHMENT_TYPE
Attachment Format	ATTACHMENT	FORMAT_CDE	N
	ATTACHMENT	ATTACHMENT	Y	CANDIDACY_ATTACHMENT	ATTACHMENT_TEXT

Column Label	Database Table Name	Database Column Name	Available for Mapping?	Mapping Table Name	Mapping Column Name
General Note Text	ATTACHMENT	ATTACHMENT	Y	FORM_NOTE	NOTE