General Subtab (Candidate Tab on the Review Internet Submission Window)

If available, this sub-tab is used to review any general information that is included in a submission that needs to be saved to the CANDIDATE table in the J1 database. This sub-tab is available if the Submission Type is Admissions Inquiry - New (320) or Admissions Application - New (330).

If there are differences between the J1 database and submission information, a sunburst icon (

) is displayed next to the "General" label on the sub-tab. These sunburst icons are also displayed to the left of each column on the sub-tab where there is a difference between the J1 database and the submission information. When these differences exist, the Compare Data button is available.

If you make a manual change to a column on a sub-tab that has been included in the submission and the changed value is different from the database value, the sunburst icon displays for the column and beside the "General" sub-tab label and is included as a "changed" column on the Compare Data window since the value differs from the value in the J1 database. If the manual change is same as the J1 database value, it is not considered a "changed" column.

Any source that is submitted as the CANDIDATE.SOURCE column mapping is put in the first available Source column, and the corresponding date/time is put in the current Date column. If all 10 Source columns are already filled with a database value, then the SOURCE_1 column is overwritten with the submitted source. If a particular SOURCE mapping column is specified (i.e., SOURCE_3), the submitted data will be inserted into the specified column and its corresponding date column will be updated with the current date/time.

Buttons

The Compare Data button is available for use on this sub-tab if there are differences between the submitted values and database values.

Options

· Anticipated Aid Report (Financial Aid option)
If this ID Number has no award or if the award has already been disbursed to the Business Office, the Financial Aid option is not available.

Mappings

Click here to view a table that details population of database columns and mapping of submission data.

Column Label	Database Table Name	Database Column Name	Available for Mapping?	Mapping Table Name	Mapping Column Name
Counselor Responsible	CANDIDATE	COUNSELOR_INITIALS	Y	CANDIDATE	COUNSELOR_INITIALS
Graduation Year	CANDIDATE	GRAD_YR_LAST_ORG	Y	CANDIDATE	GRAD_YR_LAST_ORG
Housing Code	CANDIDATE	HOUSING_CDE	Y	CANDIDATE	HOUSING_CDE
High School	CANDIDATE	HIGH_SCHOOL	Y	CANDIDATE	HIGH_SCHOOL
Last Organization Attended	CANDIDATE	LAST_ORG_ATTENDED	Y	CANDIDATE	LAST_ORG_ATTEND
Source Type Filter 1:
Source 1	CANDIDATE	SOURCE_1	N	CANDIDATE	*SOURCE, SOURCE_1
Date	CANDIDATE	SOURCE_DTE_1	N
Source Type Filter 2:
Source 2	CANDIDATE	SOURCE_2	N	CANDIDATE	*SOURCE, SOURCE_2
Date	CANDIDATE	SOURCE_DTE_2	N
Source Type Filter 3:
Source 3	CANDIDATE	SOURCE_3	N	CANDIDATE	*SOURCE, SOURCE_3
Date	CANDIDATE	SOURCE_DTE_3	N
Source Type Filter 4:
Source 4	CANDIDATE	SOURCE_4	N	CANDIDATE	*SOURCE, SOURCE_4
Date	CANDIDATE	SOURCE_DTE_4	N
Source Type Filter 5:
Source 5	CANDIDATE	SOURCE_5	N	CANDIDATE	*SOURCE, SOURCE_5
Date	CANDIDATE	SOURCE_DTE_5	N
Source Type Filter 6:
Source 6	CANDIDATE	SOURCE_6	N	CANDIDATE	*SOURCE, SOURCE_6
Date	CANDIDATE	SOURCE_DTE_6	N
Source Type Filter 7:
Source 7	CANDIDATE	SOURCE_7	N	CANDIDATE	*SOURCE, SOURCE_7
Date	CANDIDATE	SOURCE_DTE_7	N
Source Type Filter 8:
Source 8	CANDIDATE	SOURCE_8	N	CANDIDATE	*SOURCE, SOURCE_8
Date	CANDIDATE	SOURCE_DTE_8	N
Source Type Filter 9:
Source 9	CANDIDATE	SOURCE_9	N	CANDIDATE	*SOURCE, SOURCE_9
Date	CANDIDATE	SOURCE_DTE_9	N
Source Type Filter 10:
Source 10	CANDIDATE	SOURCE_10	N	CANDIDATE	*SOURCE, SOURCE_10
Date	CANDIDATE	SOURCE_DTE_10	N
Year	CANDIDATE	cur_yr	N
Term	CANDIDATE	cur_trm	N
Program	CANDIDATE	cur_prog	N
Division	CANDIDATE	cur_div	N
Location	CANDIDATE	cur_loc	N
Department	CANDIDATE	cur_dept	N
Stage	CANDIDATE	cur_stage	N
	CANDIDATE	cur_stage_lvl	N

*The data from the SOURCE mapped columns will go into the first open SOURCE column in the CANDIDATE table. Source columns 6-10 are not displayed by default but are available through ELITE PAINT.