SUSP_STDNT_AID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CSS_ID	Character(7)	VARCHAR2(7) NOT NULL	CSS ID Number
2	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: FA_INSTITUTN_VW.INSTITUTION Prompt Table: INSTITUTION_TBL
3	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: AID_YEAR_TBL
4	APP_SOURCE_CODE	Character(1)	VARCHAR2(1) NOT NULL	Application Source Code 0=Need Access 0=Need Access 1=Electronic Initial Application 2=Electronic Renewal Aplication 3=Electronic Correction 4=FAFSA Express 5=ACT 6=I-NET 7=NCS 8=Profile 9=Institutional Application O=FT Canada Student Loan P=PT Canada Student Loan
5	TABLE_ID	Character(1)	VARCHAR2(1) NOT NULL	Child Table Key Default Value: 1
6	PROCESSING_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Aid Package Processing Status 0=No Electronic Application 1=Applied 2=Ready For Counselor Review 3=Ready for Packaging 4=Repackage 9=Packaging Completed Default Value: 0
7	VERIFICATON_STATUS	Character(1)	VARCHAR2(1) NOT NULL	ED Verification Status C=ED Verification Complete N=Not Required P=Verification Pending R=Required to be Performed Default Value: N
8	SFA_REVIEW_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Review Status C=Review Complete I=Incomplete Default Value: I
9	SCHOLARSHIP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Scholarship Status E=Evaluated N=Not Evaluated Default Value: N
10	PACKAGING_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Aid Packaging Method 0=Not Packaged 5=Auto Packaged 9=Counselor Packaged Default Value: 0
11	PACKAGING_PLAN	Character(2)	VARCHAR2(2) NOT NULL	Aid Packaging Plan 00=No Formula Used 01=Grant Eligible Dependent 02=Grant Eligible Independent 03=No Need Undergraduate 04=No Need Graduate Default Value: 00
12	SAT_ACADEMIC_PRG	Character(1)	VARCHAR2(1) NOT NULL	Used on Packaging Status Summary to note current Satisfactory Academic Progress status. A=Academic Plan N=Not Meeting Satis Acad Prgrs P=Probation U=SAP Undetermined W=Warning Y=Meeting Satis Acad Progress Default Value: U
13	DISBURSEMENT_HOLD	Character(1)	VARCHAR2(1) NOT NULL	Disbursement Hold F=Hold Federal Aid I=Hold Institutional Aid L=Hold All Loans
14	COUNSELOR	Character(11)	VARCHAR2(11) NOT NULL	Counselor Prompt Table: PEOPLE_SRCH
15	COMMUNITY_SERVICE	Character(1)	VARCHAR2(1) NOT NULL	Community Service Indicator 1=Community Service Placement 2=Not Community Service Default Value: 2
16	QA_VERF_SELECT	Character(1)	VARCHAR2(1) NOT NULL	Inst Verification Status 1=Non Select 2=Selected for Verification 3=Document Select Default Value: 1
17	QA_SELECTED	Character(1)	VARCHAR2(1) NOT NULL	QA Sample 1=Not Selected as QA Sample 2=Selected as QA Sample Default Value: 1
18	AID_APP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Aid Application Status A=Application Active for All Aid C=Application Canceled R=Apply for Restricted Aid Only Default Value: A
19	VERIF_STATUS_CODE	Character(1)	VARCHAR2(1) NOT NULL	ED Verification Status Cd A=Accurate Data B=Blank C=Calculated N=Not Selected R=Reprocessed S=Selected, Not Verified T=Tolerance V=Verified W=Without Documentation Default Value: N
20	PELL_PROCESS_FIELD	Character(1)	VARCHAR2(1) NOT NULL	Pell Processing Status A=Accepted By ED G=Repackaged L=Selected N=Not Sent P=Pending R=Reported to ED S=Ready to Send V=Review
21	ED_RECORD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	ED Record Status A=Accepted w/ Assumptions D=Duplicate E=Error I=Accepted R=Rejected
22	ED_LEVEL_SAT	Character(1)	VARCHAR2(1) NOT NULL	SAT Education Level
23	PELL_EFFDT	Date(10)	DATE	Effective Date
24	PELL_EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
25	PELL_TRANS_NBR	Number(2,0)	SMALLINT NOT NULL	Transaction Num Prompt Table: PELL_INFO_VW
26	USE_SECONDARY_EFC	Character(1)	VARCHAR2(1) NOT NULL	Use Secondary EFC Y/N Table Edit Default Value: N