SFA_PF_STU_DEL

(SQL Table)
Index Back

Record used for PROFILE Delete

Record used for PROFILE Delete process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

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

Default Value: OPR_DEF_TBL_CS.AID_YEAR

Prompt Table: AID_YEAR_TBL

3 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

Default Value: 8

4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: SFA_PF_EMPID_VW

5 CSS_ID Character(7) VARCHAR2(7) NOT NULL CSS ID Number
6 SFA_PF_ADD_TYPE Character(1) VARCHAR2(1) NOT NULL Add Type
L=PROFILE LOAD
M=MANUAL
7 SFA_APPL_TYPE Character(1) VARCHAR2(1) NOT NULL Application Type
1=Domestic PROFILE
2=Noncustodial PROFILE
3=Registration Only Record
4=International PROFILE
8 SFA_PF_QUEUE_INST Number(9,0) DECIMAL(9) NOT NULL Load Instance