SFA_EXITCNSL_VW

(SQL View)
 Index Back

Loan Exit Counseling View

Loan Exit Counseling View

SELECT B.OPRCLASS ,A.DL_PROCESS_DATE_0 ,A.DL_SEQ_NBR ,A.DL_DTL_SEQNBR ,A.DL_STU_SSN ,CASE WHEN B.MASK_CFG_NID='1' THEN '*********' WHEN B.MASK_CFG_NID='2' THEN CONCAT('*****' , SUBSTR(A.DL_STU_SSN , 6 ,4)) ELSE A.DL_STU_SSN END ,A.DL_STU_DOB ,A.DL_STDNT_LAST_NAME ,A.DL_STDNT_FIRST_NAM ,A.DL_STDNT_MI ,A.DL_COMPLETION_DATE ,A.SFA_CR_CNSL_STATUS ,A.EMPLID FROM PS_DL_EXIT_DTL_EC A ,PS_PERS_MSK_CFG B WHERE A.DL_PROCESS_STATUS = 'S' AND A.SFA_CR_CNSL_STATUS IN ('1','2','3','4','5','6','7','8')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
2 DL_PROCESS_DATE_0 Date(10) DATE DL Process Date
3 DL_SEQ_NBR Number(9,0) DECIMAL(9) NOT NULL Sequence Number
4 DL_DTL_SEQNBR Number(9,0) DECIMAL(9) NOT NULL Detail Sequence Number
5 DL_STU_SSN Character(9) VARCHAR2(9) NOT NULL Student's SSN
6 SSN_MSK Character(9) VARCHAR2(9) NOT NULL Social Security #
7 DL_STU_DOB Character(8) VARCHAR2(8) NOT NULL Student's Date of Birth
8 DL_STDNT_LAST_NAME Character(35) VARCHAR2(35) NOT NULL Last Name
9 DL_STDNT_FIRST_NAM Character(35) VARCHAR2(35) NOT NULL First Name
10 DL_STDNT_MI Character(35) VARCHAR2(35) NOT NULL Middle Initial
11 DL_COMPLETION_DATE Character(8) VARCHAR2(8) NOT NULL Completion Date
12 SFA_CR_CNSL_STATUS Character(2) VARCHAR2(2) NOT NULL Counseling Processing Status
1=Student Not Found
2=Multiple Student Matches
3=SearchMatch option set to Skip
4=No Setup
5=No Grad PLUS record found
6=No Stafford record found
7=No Aid Year
8=Cannot Insert/Update data
13 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID