ID #/Add ID

If you want to search by ID #, you can enter search criteria (ID #, SSN, Last Name, or First Name) in the ID # column and press Enter or Tab to launch the search (Name Search or Quick Name Search). You can use the Advanced Search functionality by right-clicking in the ID # column and selecting Advanced Search. The right-click option also allows you to access a Previous Name. Search results are from the Name Master table. If multiple choices are available, a drop-down list displays those possible choices. You must click the Add ID button to add the name retrieved in the ID # column to the Query Results data window. The tabs are populated with information associated with the ID #.

Query

If you want to search for and retrieve a specific group of students, you can select an InfoMaker query from the drop-down list, which displays the available query reports. You can either customize or run the query. The query default name is d_finaid_inq_student_query. Click the Customize button to open InfoMaker and display all available queries. Click the Retrieve button to execute the query and display the names associated with the selected ID Numbers in alphabetical order in the query results data window. Click the Clear List button to clear the query results data window and allow you to search for a new ID # or execute a new query.

The PowerFAIDS* Info for displays the student's name associated with the ID # (in Search By) if the SSN in the J1 Biograph Master table matches the STUDENT_SSN in the PowerFAIDS STUDENT table. If the SSN does not exist in PowerFAIDS, the student name will not display.

The Alt ID is the number optionally assigned to the student in PowerFAIDS. J1 Desktop sends the ID_NUM to this field when you run Create Student Update or Match Records.

If the Student Name exists in PowerFAIDS, the Address field displays PRIMARY_STREET1, PRIMARY_STREET2, PRIMARY_CITY, PRIMARY_STATE, PRIMARY_ZIPCODE, and PRIMARY_COUNTRY from the PowerFAIDS STUDENT table.

All award years for this student (applicant) in PowerFAIDS are displayed in descending order with the most recent award year for the student listed first. The Award Year can be changed, but it impacts PowerFAIDS data displayed across all tabs.

This data window is populated in one of two ways:

§      By clicking the Add ID button to add the retrieved ID #

§      By running the selected InfoMaker query

The names are listed alphabetically. You must select a name in the data window to populate the tabs. The tabs are populated with information from J1 tables, and the PowerFAIDS data fields are populated if that data is available in PowerFAIDS.

The names in this data window can be cleared by clicking the Clear List button.

Biographical Information
J1 Data	PF Data
SSN	SSN
Date of Birth	Date of Birth
Gender	Gender
Marital Status	Marital Status
Ethnic Group
Religion
Disability
Citizen of	Citizen of
Veteran	Veteran
Status
PF Tracking Status
Financial Aid Request
Current Class	Prior Degree
Student Master Holds
Contact Information
Phone (Mobile)
Status (Mobile)
Private (Mobile)
Address Code
Address Line 1
Address Line 2
Address Line 3
City, ST ZIP Code
Phone

 

Biographical Information		PowerFAIDS
J1 Data from BIOGRAPH_MASTER table		PF Data (except SSN) from FM table say_fm_stu
SSN	SSN	student.student.ssn
Date of Birth	BIRTH_DTE	date_of_birth
Gender	GENDER	are_you_male
Marital Status	MARITAL_STATUS	marital_status
Ethnic	ETHNIC_GROUP
Religion	RELIGION
Disability Status	DISABILITY_STS
Citizenship of	CITIZEN_OF
Veteran	VETERAN

 

Status		Contact Information
J1 Data from STUDENT_MASTER table unless specified		J1 Data from AddressMaster unless specified
PF Tracking Status	stu_award_year.tracking_status Changes depending upon Award Year selected	Mobile Phone	NamePhoneMaster.MOBILE_PHONE
Financial Aid Request	BIOGRAPH_MASTER.FIN_AID_REQUEST	Status	NamePhoneMaster.MOBILE_PHONE_STS
Current Class	CURREN_CLASS_CDE include class description CLASS_DEFINITION.CLASS_DESC	Private	PHONE_STS and PHONE_PRIVATE on NamePhoneMaster where PhoneTypeDefAppID = [the appid for the ???Mobile??? phone type] and in PhoneMaster.PHONE for the phone record tied to the NamePhoneMaster record where the PhoneTypeDefAppID = [the appid for the ???Mobile??? phone type]
		Email	alternatecontactmethod.alternatecontact
Prior Degree	Retrieves all rows from DEGREE_HISTORY; if one or more rows exist having a value of NULL or 'N' for the CUR_DEGREE column, a check mark is displayed	Address	Display ADDR_CDE = '*LHP' as the top address; follow with all other addresses. ADDR_CDE ADDR_LINE_1 ADDR_LINE_2 ADDR_LINE_3 CITY STATE ZIP PHONE
Registration Holds	HOLD_1_CDE HOLD_2_CDE HOLD_3_CDE HOLD_4_CDE HOLD_5_CDE HOLD_6_CDE
		Window is positioned directly under PowerFAIDS info for window to allow easy address and phone comparison between systems

 

Program Information		PF
Stage		Status
Stage Date		Academic Division
PT/FT		Major Code
Candidacy Type
Counselor		Counselor
Housing		Housing
School Information		PF
Last High School		High School GPA
HS GPA		College GPA
HS Rank
HS Year
Last Organization
GPA
Year
Scores		PF
SATV	New SATW	SAT Verbal		nSAT Writing
SATM	New SATCR	SAT Math		nSAT Reading
SAT Total	New SATM	SAT Total		nSAT Math
ACT Comp	New SAT Total	ACT		nSAT Total

 

The data sources for the data on this tab are detailed in the tables below:

Program Information		PowerFAIDS
J1 Data from CANDIDACY and CANDIDATE tables		PF Data except Housing from stu_award_year
Stage	CANDIDACY.STAGE STAGE_CONFIG.STAGE_DESCRIPTION	Status
Stage Date	CANDIDACY.HISTORY_STAGE_DATE	Acad Division
PT/FT	CANDIDACY.LOAD_P_F
Cand Type	CANDIDACY.CANDIDACY_TYPE CANDIDACY_TYPE_DEF. CANDIDACY_TYPE_DEF	Counselor
Counselor	CANDIDATE.COUNSELOR_INITIALS Last & First Name from NameMaster of Counselor	Housing
Housing	CANDIDATE.HOUSING_CDE TABLE_DETAIL.TABLE_DESC where Column_Name = resid_commuter_sts

 

Program Information		PowerFAIDS
J1 Data from AD_ORG_TRACKING table, unless noted
Last High School	If LAST_HIGH_SCHOOL = Y then AD_ORG_TRACKING.ORG_ID__AD NAME_FORMAT_VIEW.BUSINESS_NAME	High School GPA
Year-GPA-Rank	If LAST_HIGH_SCHOOL = Y then YR_OF_GRADUATION, GPA RANK / SIZE_OF_CLASS	GPA
Last Organization	If LAST_ORG = Y then LAST_HIGH_SCHOOL <> Y and ORG_MASTER.ORG_TYPE = ORG_TYPE from the Configuration table then AD_ORG_ TRACKING.ORG_ID__AD NAME_FORMAT_VIEW. BUSINESS_NAME
GPA	If same logic as for Last Org then GPA

 

Scores		PowerFAIDS
J1 Data is computed		PF Data is from stu_award_year
SATV	TST_CDE = SAT and TST_ELEM=SATV	SATV
SATM	TST_CDE = SAT and TST_ELEM = SATM	SATM
SAT Total	TST_CDE = SAT and total is summed	SAT Total
ACT Comp	TST_CDE = ACT and TST_ELEM = *T/C	ACT Comp
New SATCR	TST_CDE = SAT05 and TST_ELEM = SATCR	New SATCR
New SATM	TST_CDE = SAT05 and TST_ELEM = SATM	New SATM
New SATW	TST_CDE = SAT05 and TST_ELEM = SATW	New SATW
New SAT Total	TST_CDE = SAT05 and total is summed	New SAT Total
If the FA Configuration for Test Scores (PF.CONFIG.WORK_LATEST_OR_HIGHEST) is set to 'Highest', then score is pulled from HIGHEST_TST_SCORE.HIGHEST_TST_SCORE   If FA Configuration for Test Scores (PF.CONFIG.WORK_LATEST_OR_HIGHEST) is set to 'Latest', then score is from TEST_SCORES_DETAIL.TST_SCORE

 

Admissions Requirements
	Requirement Description
	Completion Status
	Completion Date
	Hold/Rel
	Min Met?
	Recv'd Req
PowerFAIDS Documents
	Tracking Status
	Dependency
	Financial Aid Counselor
	Document
	Required for
	Status
	Date

 

Admissions Requirements
J1 Data from Requirements table
Requirement Description	Req_Des
Completion Status	Completion_sts If completion_sts = 'I', clear checkbox; if 'C', then select it
Completion Date	Completion_dte_dte
Hold/Rel	Hold_Release If hold_release = 'H', then display 'Held'; if 'R', then display 'Released'
Min Met?	.Min_Met If min_met = 'Y', then select the checkbox; if 'N', then clear the checkbox
Recvd Req	Rcv_Req If rcv_req = 'Y', then select the checkbox; if 'N', then clear the checkbox
This window should provide the same data as the Admissions Requirements tab on the Candidacy tab with the exception of the Requirement Code and Print columns.

 

PowerFAIDS Documents
PF Data except Dependency above Document Grid from stu_award_year
Tracking Status	tracking_status
Dependency	say_fm_fnar_stu.dependency
Financial Aid Counselor	counselor _name
PF Data except Document Name on Doc Grid from student_required_documents
Document	docs.doc_name
Required For	required_for
Status	docs_status
Date	status_effective_dt Candidacy Selection Drop-Down The Candidacy drop-down window allows users to look at any current or historic Candidacy records for the student. On this tab, the Candidacy row controls what documentation set is displayed from J1 Desktop. The Award Year selected controls the display of the PowerFAIDS documentation set. All J1 Data except Current from Candidacy Program Code Year Code Term Code Division Code Location Code Stage Current Candidacy

 

Admissions Awards
Scholarship Type
Amount
Amount Per Year
Awarded
Accepted
Sent to FA
PowerFAIDS Awards
Tracking Status
Fund ID
	Fund Name
	Amount
	Status
	Create Date
	Modified Date
	Disbursed Amount
	Total Award Amount (computed amount)

 

The data sources for the data on this tab are detailed in the tables below:

Candidacy Selection Drop-Down
The Candidacy Drop-Down window allows users to look at any current or historic candidacy records for the student. On this tab, it controls what Admissions Awards are displayed from J1 Desktop. The Award Year selected controls the display of the PowerFAIDS Awards.
All J1 Data except Current from Candidacy
Program Code	prog_cde
Year Code	yr_cde
Term Code	trm_cde
Division Code	div_cde
Location Code	loca_cde
Stage	stage
Current Candidacy	Candidate.cur_candidacy

 

Admissions Awards
J1 Data from AD_SCHOLARSHIP
Scholarship Type	SCHOLARSHIP
Amount	SCHOLARSHIP_AMOUNT
Amount Per Year	AMOUNT_PER_YEAR
Awarded	DATE_SCHOLARSHIP_AWARDED
Accepted	DATE_SCHOLARSHIP_ACCEPTED
Sent to FA	TRANSFERRED_TO_PF

 

PowerFAIDS Awards
PF Data from stu_award except Tracking Status and Fund Short Name
Tracking Status	stu_award_year.tracking_status
Fund ID	fund_ay_token
Fund Name	funds.fund_short_name
Amount	actual_amt
Status	status
Created Date	create_dt
Modified Date	modified_dt
Disbursed Amount	disbursed_amt
Total Award Amount	Sum of all Fund Amounts

 

Student Awards
POE	Fund Code	Amount	Status
PowerFAIDS Awards
Tracking Status	Budget for FM	Budget for IM
	Family Contribution for FM	Family Contribution for IM
	Need for FM	Need for IM
	Unmet Need for FM	Unmet Need for IM
	Need Based Aid	Need Based Aid
Awards
Fund ID	Fund Name	Amount
Status	Create Date	Modified Date	Disbursed Amount (computed amount)

 

Student Awards
J1 Data is from two tables: PF_STDNT_AWARD and PF_STUDENT_LOANS depending on the Fund Payment Type assigned to the Fund Code in PF_FUND_CDE_MSTR
POE/Award Year	If FUND_PAYMENT_TYP = 'G' (Grant), then     PF_STDNT_AWARD.POE_ID     PF_POE_DEF.POE_DESC If FUND_PAYMENT_TYPE = 'L' (Loan), then     PF_STUDENT_LOANS.AWARD_YR
Fund	PF_FUND_CDE_MSTR.FUND_DESC
Amount	If FUND_PAYMENT_TYP = 'G' (Grant), then     PF_STDNT_AWARD.TOTAL_AWARDED     PF_POE_DEF.POE_DESC If FUND_PAYMENT_TYPE = 'L' (Loan), then     PF_STUDENT_LOANS.AWARD_AMT
Status	If FUND_PAYMENT_TYPE = 'G' (Grant) and PF_STDNT_AWARD.RELEASE_STS = 'A'     Display "Preliminary Award" If FUND_PAYMENT_TYPE = 'G' (Grant) and PF_STDNT_AWARD.RELEASE_STS = 'T'     Display "Transferred to account" If FUND_PAYMENT_TYPE = 'L' (Loan)     Display blank

 

The Awards Grid window displays PF Data primarily from the stu_award table.
Fund ID	fund_ay_token
Fund Name	funds.fund_short_name
Amount	actual_amt
Status	status
Created Date	create_dt
Modified Data	modified_dt
Disbursed Amount	disbursed_amt
Tot Award Amt	Calculate Total Award Amount by summing Amount for all rows returned
The Scheduled Disbursements window displays each fund awarded and the scheduled disbursement award and date for the selected POE.
Fund ID	fund_ay_token
Sched Disb Amount	stu_award_transactions.scheduled_amount
Total Sched Disb Amt (no label provided)	Calculate Total Sched Disb Amount by summing Sched Disb Amount for all rows returned

 

Student Division
	Division
	Class Level
	Current Degree Code
Degree Programs
	Major
	Major
	Major
Entry Dates
	Original
	Re-Entry
Exit
	Date
	Reason
Expected Graduation
	Year	Term
Attendance
	Most Recent Year	Term Hours
	Most Recent Term	Term Courses
Hours From Most Recent Academic Update
	Year/Term
	Attempted Transfer Hours	Attempted Local Hours	Attempted Career Hours
	Earned Transfer Hours	Earned Local Hours	Earned Career Hours
	GPA Transfer Hours	GPA Local Hours	GPA Career Hours
Current Update Information
	Honors
	Probation
	Athletic Team Member
	Eligible for Scholarship

 

The data sources for the data on this tab are detailed in the tables below:

Student Division		Attendance
Data from Student Master table		Date from Student Master
Division	CUR_STUD_DIV	Most Recent Year Enrolled	MOST_RECNT_YR_ENR
Class Level	CURRENT_CLASS_CDE	Most Recent Term Enrolled	MOST_RECNT_TRM_ENR

 

Current Degree Programs		Hours from Most Recent Academic Update
Data from Degree History table		Data is primarily from Student Division Master table
Major	MAJOR_1 MAJOR_2 MAJOR_3	Year/Term	LAST_TRM_ACAD_UPD/LAST_YR_ACAD_UPD
		Transfer Local GU Career UG Attempted XFER_HRS_ATTEMPT LOCAL_HRS_ATTEMPT CAREER_HRS_ATTEMPT Earned XFER_HRS_EARNED LOCAL_HRS_EARNED CAREER_HRS_EARNED GPA XFER_GPA LOCAL_GPA CAREER_GPA

 

Entry Dates		Current Update Information
Data from Student Division Master table		Data from Student Master
Original	ENTRY_DTE	Honors	CUR_ACAD_HONORS
Reentry	RE_ENTRY_DTE	Probation	CUR_ACAD_HONORS

 

Exit Dates		checkbox Items
Data from Student Division Master table		Data from Student Master
Exit Date	EXIT_DTE	Eligible for Scholarship	ATH_TEAM_MEMBR
Exit Reason	EXIT_REASON	Athletic Team Member	ELIG_SPECIAL_GPA

 

Expected Graduation Year
Data from Student Division Master table
Year/Term	EXPECT_GRAD_YR/EXPECT_GRAD_TRM

 

Student Aims
Aim	Advising Req Code	Description	Begin Date	End Date	Status
Advisors
Advisor ID	Name	Division	Primary	Type	Seq Num

Student Satisfactory Progress History
Year	Term	Rule
Division	Degree	Enroll Type
Term GPA	Term Hours Attempted	Term Hours Earned
Year GPA	Year Hours Attempted	Year Hours Earned
Cumulative GPA	Cumulative Hours Attempted	Cumulative Hours Earned
Cumulative Percent	Total Hours Attempted	Current Hours
Term Count	Current Progress 1	Previous Progress 1
Final Progress 1	Appeal 1	Progress Override 1
Current Progress 2	Previous Progress 2	Final Progress 2
Appeal 2	Progress Override 2	Current Progress 3
Previous Progress 3	Final Progress 3	Appeal 3
Progress Override 3	Update PF

 

The data sources for the data on this tab are detailed in the tables below:

Student Aims
Data is from Student Aims table
Aim	AIM_LABEL
Advising Req Code	ADV_REQ_CODE
Description	AIM_DESC
Begin Date	BEGIN_DTE
End Date	END_DTE
Status	STUD_REQ_CFG_STS

 

Advisors
Data is from Advisor Student Table except Name
Advisor ID	ADVISOR_ID
Name	COMPUTED COLUMN
Division	DIV_CDE
Primary	ADVISOR_NUM
Type	ADVISOR_TYPE
Seq Number	SEQ_NUM

 

Student Satisfactory Progress History
Data is from PF_SAP_HIST table
ID#	ID_NUM
Year	YR_CDE
Term	TRM_CDE
Division	DIV_CDE
Degree	DEGREE_CDE
Major 1	MAJOR_1
Enroll Type	ENROLL_TYPE
Cumulative GPA	CUM_GPA
Cumulative Hrs Attempted	CUM_HRS_ATTEMPTED
Cumulative Hrs Earned	CUM_HRS_EARNED
Cumulative Percentage	Computed Column
Total Hrs Attempted	TOTAL_HRS_ATTEMPTED
Current Hours in Progress	CURRENT_HOURS_IN_PROGRESS
Current Progress 1	CURRENT_PROGRESS_1
Previous Progress 1	PREVIOUS_PROGRESS_1
Final Progress 1	FINAL_PROGRESS_1
Appeal 1	APPEAL_1
Progress Override 1	PROGRESS_OVERRIDE_1
Upd PF	UPDATE_PF

 

If you are not licensed to use the Student Life module, only the columns marked with #  will display.

#Session (select session from drop-down list)
#Meal Plan	#Campus Box Number
#Resident/Commuter	#Room Phone

Room Assignment
	#Location	#Room	Room Status
	#Building	#Room Type
Student Budget (PowerFAIDS)
	Budget Category	Default Total	Adjustment	Adjusted Total

 

Student Life Housing Information
The Session Master table controls the data viewed in this window
Session	CM_SESSION_MSTR.SESS_CDE CM_SESSION_MSTR.SESS_DES
The general housing information is from the STUD_SESS_ASSIGN table
Meal Plan	MEAL_PLAN
Campus Box Number	CAMPUS_BOX_NUM
Resident/Commuter	RESID_COMMUTER_STS
Room Phone	ROOM_PHONE

 

Student Life Housing Information
The Session Master table controls the data viewed in this window
Session	CM_SESSION_MSTR.SESS_CDE CM_SESSION_MSTR.SESS_DES
The room assignment data is primarily from the ROOM_ASSIGN table
Location	LOCATION_MASTER.LOC_DESC BLDG_LOC_CDE
Building	BUILDING_MASTER.BUILDING_DESC BLDG_CDE
Room	ROOM_MASTER.ROOM_DESC ROOM_CDE
Room Sts	SESS_ROOM_MASTER.ROOM_STS Possible values: A = Assigned U = Unassigned R = Reserved P = Pending H = Held by
Room Type	ROOM_TYPE

 

Non-Student Life Housing Information
No Session drop-down selection available
The general housing and room assignment information is primarily from the Student Master table
Meal Plan	MEAL_PLAN
Campus Box Number	CAMPUS_BOX_NUM
Resident/Commuter	RESID_COMMUTER_STS
Room Phone	DORM_PHONE_NUM
Location	Display LOCATION_MASTER.LOC_DESC for DORM_LOC_CDE
Building	Display BUILDING_MASTER.BUILDING_DESC for DORM_BLDG_CDE
Room	Display ROOM_MASTER.ROOM_DESC for DORM_ROOM_CDE
Room Type	ROOM_TYPE

 

PowerFAIDS Student Budget
PF Data is primarily from student_budget_items table
Budget Category	budcat_items.budcat_item_desc
Default Total	Displays sum of student_budget_items_dt.base_budget_amt for all student_budget_items_dt rows
Adjustment	Displays sum of student_budget_items_dt.base_budget_adjustment_amt for all student_budget_items_dt rows
Adjusted Total	Add computed Default Total and computed Adjustment Display results as Adjusted Total
This window should mirror the information displayed in the PowerFAIDS Student Budgets View.

 

Subsidiary Period Balance Statement Balance

1098-T Academic Year Posted Balance Balance To Date

1098-T Academic Term Unapplied Financial Aid History Begin Balance

Billing Period

 

The following details are displayed for this Subsidiary and Billing Period/1098-T Academic Year and Term for the student:

Source

Group Num

Billing Period

1098-T Academic Year

1098-T Academic Term

Date

Status

(Transaction) Description

Fund Code

Folio

Debit

Credit

Subsidiary

Account Code

A/R Code

Charge Fee Code

Third Party

1098T Elig

 

The trailer at the bottom of the window displays a summary of the information displayed on the Account tab (see the "Data Sources" section below for more information):

 

The data sources for the data on this tab are detailed in the tables below:

Account Filter Columns
The Filter Columns provide you with the ability to alter the data displayed in the Account Grid. The default data displayed is for all subsidiaries, years and terms.
Subsidiary	SUBSID_MASTER.SUBSID_CDE	TRANS_HIST.SUBSID_CDE
1098-T Academic Year	YEAR_DEF.YR_CDE	TRANS_HIST.CHG_YR_TRAN_HIST
1098-T Academic Term	TRM_DEF.TRM_CDE	TRANS_HIST.CHG_TRM_HIST
Billing Period	BILLING_PERIOD_DEF.ID	TRANS_HIST.BILLING_PERIOD_ID
These data values serve as input variables to extract data from the TRANS_HIST table based on the equivalencies above.

 

Account Balance Information
The Balance columns provide a quick understanding of student's account. Data is from Subsidiary Master [SUBSID_MASTER] table.
Period Balance	SUBSID_MASTER.PERIOD_BEG_BAL
Statement Balance	SUBSID_MASTER.STMT_BEG_BAL
Posted Balance	SUBSID_MASTER.AR_POSTED_BAL
Balance to Date	SUBSID_MASTER.AR_BAL_TO_DTE
Unapplied Financial Aid	SUBSID_MASTER.UNAPPLIED_FIN_AID
These balances are all summaries for the student and the specific subsidiary code selected in the account filter. It reflects all subsidiaries assigned to the student by default.

 

Account Detail Grid
Data is primarily from Transaction History [TRANS_HIST] table
Source	TRANS_HIST.SOURCE_CDE
Group Num	TRANS_HIST.GROUP_NUM
Billing Period	TRANS_HIST.BILLING_PERIOD_ID
Charge Year	TRANS_HIST.CHG_YR_TRAN_HIST
Charge Term	TRANS_HIST.CHG_TRM_TRAN_HIST
Date	TRANS_HIST.TRANS_DTE
Status	TRANS_HIST.SUBSID_TRANS_STS
Description	TRANS_HIST.TRANS_DESC
Fund Cde	PF_FUND_CDE_MSTR.FUND_DESC
Folio	TRANS_HIST.FOLIO
Debit	Display TRANS_HIST.TRANS_AMT when >= 0.
Credit	Display TRANS_HIST.TRANS_AMT when < 0.
Subsidiary	SUBSID_DEF.SUBSID_DESC
Account Code	TRANS_HIST.ACCT_CDE
A/R Code	TRANS_HIST.AR_CDE
Charge Fee Code	TRANS_HIST.CHG_FEE_CDE
Third Party	Display Name from NameMaster for THIRD_PTY_BILL_ID
1098T Elig	TRANS_HIST.ELIG_1098T

 

Account Totals Columns
Data is summary of data displayed in Account Detail Grid
Rows retrieved	Total Count of TRANS_HIST rows displayed for select Subsidiary Code
Total Debit Amount	Total of all TRANS_HIST.TRANS_AMT from the selected rows WHERE trans_amt >= 0.
Total Credit Amount	Total of all TRANS_HIST.TRANS_AMT from the selected rows WHERE trans_amt < 0.
Balance	(Total Debit Amount )+ (Total Credit Amount)

 

ID Number

Item Date

Item Time

Item Type

Object

Item Description

 

The data sources for the data on this tab are detailed in the table below:

Notepad Grid
Data is from ITEMS table.
Item Date	ITEM_DATE
Item Time	ITEM_TIME
Item Type	ITEM_TYPE
Object	OBJECT_KEY
Item Description	ITEM_DESCRIPTION

 

Customize the following reports by clicking its Customize button, which opens InfoMaker:

Available Reports	Customizable Report
1 General	r_stud_in_geninfo
2 Admissions	r_stud_in_adinfo
3 Registration	r_stud_in_reinfo
4 Financial Aid	r_stud_in_fainfo
5 Business Office	r_stud_in_arinfo
6 Student Life	r_stud_in_sainfo1
7 Advising	r_stud_in_avinfo
8 Notepad	r_stud_in_npinfo

Each report (Registration Report sample) can be viewed to determine complete details.

 

1.    Open the Financial Aid Inquiry window.

2.    To search for and retrieve an individual student, enter or search for the ID #. Click the Add ID button to move it to the query results data window.

3.    To search for and retrieve a specific group of students, select the appropriate query from the drop-down list and customize it if you wish. Click the Retrieve button to populate the query results data window with the student names.

4.    In the query results data window, highlight (select) the student about which you want to view General information.

5.    Click the General Info tab. You may be allowed to edit some columns.

6.    Click the Clear List button if you want to clear names from the query results data window, which allows you to search for and retrieve another student/group of students.

 

1.    Open the Financial Aid Inquiry window.

2.    To search for and retrieve an individual student, enter or search for the ID #. Click the Add ID button to move it to the query results data window.

3.    To search for and retrieve a specific group of students, select the appropriate query from the drop-down list and customize it if you wish. Click the Retrieve button to populate the query results data window with the student names.

4.    In the query results data window, highlight (select) the student about which you want to view Admissions information.

5.    Click the Admissions tab. You may be allowed to edit some columns.

6.    Click the Clear List button if you want to clear names from the query results data window, which allows you to search for and retrieve another student/group of students.

 

1.    Open the Financial Aid Inquiry window.

2.    To search for and retrieve an individual student, enter or search for the ID #. Click the Add ID button to move it to the query results data window.

3.    To search for and retrieve a specific group of students, select the appropriate query from the drop-down list and customize it if you wish.  Click the Retrieve button to populate the query results data window with the student names.

4.    In the query results data window, highlight (select) the student about which you want to view Document information.

5.    Click the Documents tab. You may be allowed to edit some columns.

6.    Click the Clear List button if you want to clear names from the query results data window, which allows you to search for and retrieve another student/group of students.

 

1.    Open the Financial Aid Inquiry window.

2.    To search for and retrieve an individual student, enter or search for the ID #. Click the Add ID button to move it to the query results data window.

3.    To search for and retrieve a specific group of students, select the appropriate query from the drop-down list and customize it if you wish. Click the Retrieve button to populate the query results data window with the student names.

4.    In the query results data window, highlight (select) the student about which you want to view Scholarship information.

5.    Click the Scholarships tab. You may be allowed to edit some columns.

6.    Click the Clear List button if you want to clear names from the query results data window, which allows you to search for and retrieve another student/group of students.

 

1.    Open the Financial Aid Inquiry window.

2.    To search for and retrieve an individual student, enter or search for the ID #. Click the Add ID button to move it to the query results data window.

3.    To search for and retrieve a specific group of students, select the appropriate query from the drop-down list and customize it if you wish. Click the Retrieve button to populate the query results data window with the student names.

4.    In the query results data window, highlight (select) the student about which you want to view Financial Aid information.

5.    Click the Financial Aid tab. You may be allowed to edit some columns.

6.    Click the Clear List button if you want to clear names from the query results data window, which allows you to search for and retrieve another student/group of students.

 

1.    Open the Financial Aid Inquiry window.

2.    To search for and retrieve an individual student, enter or search for the ID #. Click the Add ID button to move it to the query results data window.

3.    To search for and retrieve a specific group of students, select the appropriate query from the drop-down list and customize it if you wish. Click the Retrieve button to populate the query results data window with the student names.

4.    In the query results data window, highlight (select) the student about which you want to view Registration information.

5.    Click the Registration tab. You may be allowed to edit some columns.

6.    Click the Clear List button if you want to clear names from the query results data window, which allows you to search for and retrieve another student/group of students.

 

1.    Open the Financial Aid Inquiry window.

2.    To search for and retrieve an individual student, enter or search for the ID #. Click the Add ID button to move it to the query results data window.

3.    To search for and retrieve a specific group of students, select the appropriate query from the drop-down list and customize it if you wish. Click the Retrieve button to populate the query results data window with the student names.

4.    In the query results data window, highlight (select) the student about which you want to view Advising information.

5.    Click the SAP/Advising tab. You may be allowed to edit some columns.

6.    Click the Clear List button if you want to clear names from the query results data window, which allows you to search for and retrieve another student/group of students.

 

1.    Open the Financial Aid Inquiry window.

2.    To search for and retrieve an individual student, enter or search for the ID #. Click the Add ID button to move it to the query results data window.

3.    To search for and retrieve a specific group of students, select the appropriate query from the drop-down list and customize it if you wish. Click the Retrieve button to populate the query results data window with the student names.

4.    In the query results data window, highlight (select) the student about which you want to view Housing/Budget information.

5.    Click the Housing/Bdgt tab. You may be allowed to edit some columns.

6.    Click the Clear List button if you want to clear names from the query results data window, which allows you to search for and retrieve another student/group of students.

 

1.    Open the Financial Aid Inquiry window.

2.    To search for and retrieve an individual student, enter or search for the ID #. Click the Add ID button to move it to the query results data window.

3.    To search for and retrieve a specific group of students, select the appropriate query from the drop-down list and customize it if you wish. Click the Retrieve button to populate the query results data window with the student names.

4.    In the query results data window, highlight (select) the student about which you want to view Account information.

5.    Click the Account tab. You may be allowed to edit some columns.

6.    Click the Clear List button if you want to clear names from the query results data window, which allows you to search for and retrieve another student/group of students.

 

1.    Open the Financial Aid Inquiry window.

2.    To search for and retrieve an individual student, enter or search for the ID #. Click the Add ID button to move it to the query results data window.

3.    To search for and retrieve a specific group of students, select the appropriate query from the drop-down list and customize it if you wish. Click the Retrieve button to populate the query results data window with the student names.

4.    In the query results data window, highlight (select) the student about which you want to view Notepad information.

5.    Click the Notepad tab. You may be allowed to edit some columns.

6.    Click the Clear List button if you want to clear names from the query results data window, which allows you to search for and retrieve another student/group of students.

 

1.    Open the Financial Aid Inquiry window.

2.    To search for and retrieve an individual student, enter or search for the ID #. Click the Add ID button to move it to the query results data window.

3.    To search for and retrieve a specific group of students, select the appropriate query from the drop-down list and customize it if you wish. Click the Retrieve button to populate the query results data window with the student names.

4.    In the query results data window, highlight (select) the student about which you want to view Reports.

5.    Click the Reports tab. You may be allowed to edit some columns.

6.    Click the Clear List button if you want to clear names from the query results data window, which allows you to search for and retrieve another student/group of students.