FA_OSAP_SUSP_VW

(SQL View)
 Index Back

View of FA_OSAP_SUSP

This is an exact view of FA_OSAP_SUSP table. The view adds masking for SIN and BIRTHDATE.

SELECT B.OPRCLASS ,A.FA_STUDENT_ID ,A.INSTITUTION ,A.AID_YEAR ,A.OSAP_LAST_TRANS_DT ,A.APP_ACCT_NUM ,A.LAST_NAME ,A.FIRST_NAME ,A.FA_MI ,A.DATE_SSB ,A.SIN ,CASE WHEN B.MASK_CFG_NID='1' THEN '*********' WHEN B.MASK_CFG_NID='2' THEN '*****' %Concat SUBSTR(A.SIN , 6 ,4) ELSE A.SIN END ,A.TOT_ENT_AWARD ,A.TOT_ENT_CSL ,A.TOT_ENT_OSL ,A.TOT_CSL_ISS ,A.TOT_OSL_ISS ,A.NE_CODE ,A.MULTIPLE_APPS ,A.FA_STATUS_CODE_1 ,A.FA_STATUS_CODE_2 ,A.FA_STATUS_CODE_3 ,A.FA_STATUS_CODE_4 ,A.FA_STATUS_CODE_5 ,A.FA_STATUS_CODE_6 ,A.FA_STATUS_CODE_7 ,A.FA_STATUS_CODE_8 ,A.FA_STATUS_CODE_9 ,A.FA_STATUS_CODE_10 ,A.FA_STATUS_CODE_11 ,A.FA_STATUS_CODE_12 ,A.FA_STATUS_CODE_13 ,A.FA_STATUS_CODE_14 ,A.FA_STATUS_CODE_15 ,A.PREPRINT_IND ,A.BIRTHDATE ,CASE WHEN B.MASK_CFG_DOB='1' THEN '**/**/****' WHEN B.MASK_CFG_DOB='2' THEN TO_CHAR(A.BIRTHDATE , 'MM/DD') ELSE TO_CHAR(A.BIRTHDATE , 'MM/DD/YYYY') END ,A.HIGHEST_PCT_CRSLD ,A.TOT_NEED_FLAG ,A.FA_TOTAL_NEED ,A.CURRENT_COST_CD ,A.YEAR_ENTERING ,A.GRANT_ENTITLEMENT ,A.GRANT_ISSUED ,A.INST_CODE ,A.ACAD_YEAR ,A.EMPLID ,A.ADMIT_LVL ,A.OSAP_SUSP_REASON ,A.OSAP_PROCESS_ACTN FROM PS_FA_OSAP_SUSP A , PS_PERS_MSK_CFG B

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

Prompt Table: INSTITUTION_TBL

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

Prompt Table: AID_YEAR_TBL

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

Prompt Table: PEOPLE_SRCH

48 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
49 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
50 OSAP_PROCESS_ACTN Character(1) VARCHAR2(1) NOT NULL Processing Action
A=Add to Results
D=Delete from Suspense
P=Pending