FA_OSAP_SUSP

(SQL Table)
 Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FA_STUDENT_ID Character(9) VARCHAR2(9) NOT NULL FA Student ID
2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Prompt Table: INSTITUTION_TBL

3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

Prompt Table: AID_YEAR_TBL

4 OSAP_LAST_TRANS_DT Date(10) DATE Last Transaction Date
5 APP_ACCT_NUM Character(9) VARCHAR2(9) NOT NULL App Acct Number
6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
7 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
8 FA_MI Character(1) VARCHAR2(1) NOT NULL Middle Initial
9 DATE_SSB Date(10) DATE Date Received at SSB
10 SIN Character(9) VARCHAR2(9) NOT NULL Social Insurance #
11 TOT_ENT_AWARD Number(5,0) INTEGER NOT NULL Total Entitled Award
12 TOT_ENT_CSL Number(5,0) INTEGER NOT NULL Total Entitled CSL
13 TOT_ENT_OSL Number(5,0) INTEGER NOT NULL Total Entitled OSL
14 TOT_CSL_ISS Number(5,0) INTEGER NOT NULL Total CSL Issued
15 TOT_OSL_ISS Number(5,0) INTEGER NOT NULL Total OSL Issued
16 NE_CODE Character(2) VARCHAR2(2) NOT NULL NE Code
A1=Sept. - Dec. with 1 term
B1=Sept. - Dec. with 2 terms
C1=Sept. - Dec. with 3 terms
D1=Jan. - Apr. with 1 term
E1=Jan. - Apr. with 2 terms
F1=May - Jun. with 1 term
G1=July - Aug. with 2 terms
H1=July - Aug. with 3 terms
J1=July - Aug. with 1 term
17 MULTIPLE_APPS Character(1) VARCHAR2(1) NOT NULL Multiple Apps
18 FA_STATUS_CODE_1 Character(1) VARCHAR2(1) NOT NULL Status Code 1
19 FA_STATUS_CODE_2 Character(1) VARCHAR2(1) NOT NULL Status Code 2
20 FA_STATUS_CODE_3 Character(1) VARCHAR2(1) NOT NULL Status Code 3
21 FA_STATUS_CODE_4 Character(1) VARCHAR2(1) NOT NULL Status Code 4
22 FA_STATUS_CODE_5 Character(1) VARCHAR2(1) NOT NULL Status Code 5
23 FA_STATUS_CODE_6 Character(1) VARCHAR2(1) NOT NULL Status Code 6
24 FA_STATUS_CODE_7 Character(1) VARCHAR2(1) NOT NULL Status Code 7
25 FA_STATUS_CODE_8 Character(1) VARCHAR2(1) NOT NULL Status Code 8
26 FA_STATUS_CODE_9 Character(1) VARCHAR2(1) NOT NULL Status Code 9
27 FA_STATUS_CODE_10 Character(1) VARCHAR2(1) NOT NULL Status Code 10
28 FA_STATUS_CODE_11 Character(1) VARCHAR2(1) NOT NULL Status Code 11
29 FA_STATUS_CODE_12 Character(1) VARCHAR2(1) NOT NULL Status Code 12
30 FA_STATUS_CODE_13 Character(1) VARCHAR2(1) NOT NULL Status Code 13
31 FA_STATUS_CODE_14 Character(1) VARCHAR2(1) NOT NULL Status Code 14
32 FA_STATUS_CODE_15 Character(1) VARCHAR2(1) NOT NULL Status Code 15
33 PREPRINT_IND Character(1) VARCHAR2(1) NOT NULL Preprint Indicator
34 BIRTHDATE Date(10) DATE Date of Birth
35 HIGHEST_PCT_CRSLD Character(3) VARCHAR2(3) NOT NULL Highest Pct Courseload
36 TOT_NEED_FLAG Character(1) VARCHAR2(1) NOT NULL Total Need Flag
37 FA_TOTAL_NEED Number(5,0) INTEGER NOT NULL Total Need
38 CURRENT_COST_CD Character(10) VARCHAR2(10) NOT NULL Current Cost Code
39 YEAR_ENTERING Character(1) VARCHAR2(1) NOT NULL Year Entering
40 GRANT_ENTITLEMENT Number(5,0) INTEGER NOT NULL FA Grant Entitlement
41 GRANT_ISSUED Number(5,0) INTEGER NOT NULL Grant Issued
42 INST_CODE Character(4) VARCHAR2(4) NOT NULL FA Inst Code
43 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year
44 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PEOPLE_SRCH

45 ADMIT_LVL Character(1) VARCHAR2(1) NOT NULL Student's Admit Lvl
0=0 - Student Not Found
1=1 - Has Not Applied
2=2 - Inactive
3=3 - Applied/Pending
4=4 - Admitted
5=5 - Accepted/Continuing
46 OSAP_SUSP_REASON Character(1) VARCHAR2(1) NOT NULL OSAP Suspend Reason
1=EmplID not matched
2=SIN not matched
3=Name not matched
4=EmplID/SIN not matched
5=EmplID/Name not matched
6=SIN/Name not matched
7=EmplID/SIN/Name not matched
8=Student not at Load Level
47 OSAP_PROCESS_ACTN Character(1) VARCHAR2(1) NOT NULL Processing Action
A=Add to Results
D=Delete from Suspense
P=Pending
48 SFA_UNMET_NEED Number(6,0) INTEGER NOT NULL CNAS Unmet Need field.
49 SFA_DISAB_FLG Character(1) VARCHAR2(1) NOT NULL CNAS - Disability Flag.
1=Yes
2=No
50 SFA_OAG_ENT Number(5,0) INTEGER NOT NULL CNAS - OAG Entitled.
51 SFA_OAG_ISSUE Number(5,0) INTEGER NOT NULL CNAS - OAG Issued.
52 SFA_MOAG_ENT Number(5,0) INTEGER NOT NULL CNAS - MOAG Entitled.
53 SFA_MOAG_ISSUE Number(5,0) INTEGER NOT NULL CNAS - MOAG Issued.
54 SFA_CAG_LID_ENT Number(5,0) INTEGER NOT NULL CNAS - CAG LID Entitled.
55 SFA_CAG_LID_ISS Number(5,0) INTEGER NOT NULL CNAS - CAG LID Issued.
56 SFA_CAG_PD_ENT Number(5,0) INTEGER NOT NULL CNAS - CAG PD Entitled.
57 SFA_CAG_PD_ISS Number(5,0) INTEGER NOT NULL CNAS - CAG PD Issued.
58 SFA_MILLEN_ENT Number(5,0) INTEGER NOT NULL CNAS - Millennium Entitled.
59 SFA_MILLEN_ISS Number(5,0) INTEGER NOT NULL CNAS - Millennium Issued.
60 SFA_CUR_ST_INFO Character(1) VARCHAR2(1) NOT NULL CNAS - Current Status Information.
61 SFA_OWN_VECH Character(1) VARCHAR2(1) NOT NULL CNAS - Own Vehicles?
62 SFA_RRSP_NET Number(6,0) INTEGER NOT NULL CNAS - RRSP Net Value.
63 SFA_TOT_OTHER Number(6,0) INTEGER NOT NULL CNAS - Total Other Assets.
64 SFA_PRESTD_INC Number(5,0) INTEGER NOT NULL CNAS - Student Prestudy Income.
65 SFA_STD_PER_EMP Number(5,0) INTEGER NOT NULL CNAS - Study Period Employment.
66 SFA_GOVT_INC Number(5,0) INTEGER NOT NULL CNAS - Government Income During Study.
67 SFA_TYP_GOV_INC Character(1) VARCHAR2(1) NOT NULL CNAS - Type of Gov. Income.
68 SFA_LIV_PARNTS Character(1) VARCHAR2(1) NOT NULL CNAS - Living With Parents During Period?
1=At Home
2=Living Away
69 SFA_CUR_RES_INFO Character(1) VARCHAR2(1) NOT NULL CNAS - Current Residency Information
1=Student is ON Resident
2=Spouse is ON Resident
3=Parent is ON Resident
4=Not ON Resident
5=Resident of Canada
70 SFA_C_OF_E Character(6) VARCHAR2(6) NOT NULL CNAS - C of E Event Status.
71 SFA_CODE_35 Character(1) VARCHAR2(1) NOT NULL CNAS - Code 35
Y=Yes
72 SFA_CODE_65 Character(1) VARCHAR2(1) NOT NULL CNAS - Code 65
Y=Yes
73 SFA_CODE_67 Character(1) VARCHAR2(1) NOT NULL CNAS - Code 67
Y=Yes