PROF_SRCH_03 (SQL View)	Index Back
People on Profile Susp Tables

PROF_SRCH_03

(SQL View)

People on Profile Susp Tables

SELECT DISTINCT b.oprclass ,a.css_id ,A.INSTITUTION ,A.AID_YEAR ,a.app_source_code ,b.ssn ,b.ssn_msk ,a.css_school_code ,a.suspend_reason ,B.LAST_NAME_SRCH ,B.FIRST_NAME_SRCH FROM PS_SUSP_PROF_CNTRL A , PS_SUSP_PRF_COM_VW B WHERE A.INSTITUTION=B.INSTITUTION AND a.css_id=b.css_id AND a.aid_year=b.aid_year AND a.app_source_code=b.app_source_code AND a.app_source_code='8' AND a.aid_year='2003'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class

2 CSS_ID Character(7) VARCHAR2(7) NOT NULL CSS ID Number

3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL

4 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
Default Value: 2003
Prompt Table: AID_YEAR_TBL

5 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

6 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #

7 SSN_MSK Character(9) VARCHAR2(9) NOT NULL Social Security #

8 CSS_SCHOOL_CODE Character(4) VARCHAR2(4) NOT NULL CSS School Code

9 SUSPEND_REASON Character(1) VARCHAR2(1) NOT NULL Suspend Reason
1=1 - Student ID not Found
2=2 - Student not at Load Level
3=3 - Final Review Flag Set
4=4 - No SAI Calculation
5=5 - Invalid School Code
6=6 - Student Id already Exists
7=ISIR Tran Nbr out of Sequence
8=8 - Registration Only Record
9=9 -Non-Unique Student ID Found
A=A - Student not at Admit Level
E=SAI Mismatch
F=10 - FA Term Not Built
H=13 - HHB Add Person Suspend
L=Load Update Profile Set To No
M=11 - Manually Set to Suspended
P=12- Packaging Completed
T=Prof Tran Nbr out of Sequence

10 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

11 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRCLASS	Character(30)	VARCHAR2(30) NOT NULL	Operator Class
2	CSS_ID	Character(7)	VARCHAR2(7) NOT NULL	CSS ID Number
3	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL
4	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year Default Value: 2003 Prompt Table: AID_YEAR_TBL
5	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
6	SSN	Character(9)	VARCHAR2(9) NOT NULL	Social Security #
7	SSN_MSK	Character(9)	VARCHAR2(9) NOT NULL	Social Security #
8	CSS_SCHOOL_CODE	Character(4)	VARCHAR2(4) NOT NULL	CSS School Code
9	SUSPEND_REASON	Character(1)	VARCHAR2(1) NOT NULL	Suspend Reason 1=1 - Student ID not Found 2=2 - Student not at Load Level 3=3 - Final Review Flag Set 4=4 - No SAI Calculation 5=5 - Invalid School Code 6=6 - Student Id already Exists 7=ISIR Tran Nbr out of Sequence 8=8 - Registration Only Record 9=9 -Non-Unique Student ID Found A=A - Student not at Admit Level E=SAI Mismatch F=10 - FA Term Not Built H=13 - HHB Add Person Suspend L=Load Update Profile Set To No M=11 - Manually Set to Suspended P=12- Packaging Completed T=Prof Tran Nbr out of Sequence
10	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
11	FIRST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	First Name