EDExpress ISIR Export Layout 2010 - 2011

This document shows you how to create an export file format in EDExpress and export to ASCII format.

Follow these steps to create this layout:

Select Tools from the main menu.
Select File Format from the menu.
Select App Express and then press the OK button.
Press the Add button and create a new file format.

Format Code: “SR”
Description: “CAMS ISIR Import”

Select the fields from the list in the order of the list below.
Save the layout.

CAMS SEQ	EDE SEQ	Description
1	292	Student’s Current SSN
2	123	Last Name
3	95	First Name
4	126	Middle Initial
5	7	Application Receipt Date
6	45	Born Before 1/1/1987
7	301	Student’s Marital Status
8	329	Veteran of US Armed Forces
9	285	Student’s Adjusted Gross Income
10	169	Parents’ Number of Family Members
11	147	Parents’ Adjusted Gross Income
12	67	EFC
13	260	Secondary EFC
14	319	TI: Total Income
15	43	ATI: Allowances Against Total Income
16	318	STX: State Tax Allowance
17	66	EA: Employment Allowance
18	120	IPA: Income Protection Allowance
19	4	AI: Available Income
20	60	DNW: Discretionary Net Worth
21	229	SEC APA: Secondary Asset Protection Allowance
22	182	PCA: Parents’ Contributions From Assets
23	1	AAI: Adjusted Available Income
24	320	TPC: Total Parent Contribution
25	181	PC: Parents’ Contribution
26	265	SIC: Dependents Student Income Contribution
27	225	SCA: Student’s Contribution From Assets
28	306	Student’s Number of Family Members
29	325	TSC: Total Student Contribution
30	262	Selected For Verification
31	57	Dependency Status
32	44	Automatic Zero EFC Indicator
33	94	First Bachelor’s Degree by 7/1/2010
34	96	FTI: Fisap Total Income
35	330	Working on a Masters or Doctorate Program?
36	322	Transaction Number
37	183	Pell Grant Eligibility Flag
38	192	Primary Alternate Month 1
39	193	Primary Alternate Month 10
40	194	Primary Alternate Month 11
41	195	Primary Alternate Month 12
42	196	Primary Alternate Month 2
43	197	Primary Alternate Month 3
44	198	Primary Alternate Month 4
45	199	Primary Alternate Month 5
46	200	Primary Alternate Month 6
47	201	Primary Alternate Month 7
48	202	Primary Alternate Month 8
49	83	Federal School Code 1
50	84	Federal School Code 10
51	85	Federal School Code 2
52	86	Federal School Code 3
53	87	Federal School Code 4
54	88	Federal School Code 5
55	89	Federal School Code 6
56	90	Federal School Code 7
57	91	Federal School Code 8
58	92	Federal School Code 9
59	103	Housing Plans 1
60	104	Housing Plans 10
61	106	Housing Plans 2
62	107	Housing Plans 3
63	108	Housing Plans 4
64	109	Housing Plans 5
65	110	Housing Plans 6
66	111	Housing Plans 7
67	112	Housing Plans 8
68	113	Housing Plans 9

Follow these steps to export ISIR from EDExpress:

Select File from the main menu.
Select Export from the next menu.
Select the APP Express tab.
Select the Export Type External ISIR.
Define the path and name of the export file.

“Drive:\CAMSEnterprise\Import\EISIRIMP.txt”

Select the Format Code “SR”.
Select the Selection Criteria button to set criteria on your export.
Press the OK button to start the export.