SFA_CNSL_UPD_VW

(SQL View)
Index Back

COD Loan Counseling View

Use to identify loan cousneling records with award status of skip or unprocessed

SELECT A.SFA_CR_DOCUMENT_ID ,A.SFA_CR_RPT_SCHL_ID ,A.SFA_CR_ATT_SCHL_ID ,A.EMPLID ,B.SFA_CR_AWARD_NAME ,B.SFA_CR_AWARD_YEAR ,B.SFA_CR_AWARD_NBR ,A.SFA_CR_ID_SSN ,A.SFA_CR_ID_BIRTH_DT ,A.SFA_CR_ID_LAST_NAM ,A.SFA_CR_FIRST_NAME ,A.SFA_CR_MIDDLE_INIT ,B.SFA_CR_CNSL_SEQNBR ,B.SFA_CR_CNSL_CMP_DT ,B.SFA_CR_AWARD_STAT ,B.SFA_CR_CNSL_STATUS FROM PS_SFA_COD_STUDENT A ,PS_SFA_COD_AWARD B WHERE A.SFA_CR_DOCUMENT_ID = B.SFA_CR_DOCUMENT_ID AND A.SFA_CR_RPT_SCHL_ID = B.SFA_CR_RPT_SCHL_ID AND A.SFA_CR_ATT_SCHL_ID = B.SFA_CR_ATT_SCHL_ID AND A.EMPLID = B.EMPLID AND B.SFA_CR_AWARD_NAME IN ('DLSEntranceCounseling','DLPEntranceCounseling' ,'ExitCounseling')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SFA_CR_DOCUMENT_ID Character(34) VARCHAR2(34) NOT NULL Document ID
2 SFA_CR_RPT_SCHL_ID Character(8) VARCHAR2(8) NOT NULL Reporting School ID
3 SFA_CR_ATT_SCHL_ID Character(8) VARCHAR2(8) NOT NULL Attended School ID
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 SFA_CR_AWARD_NAME Character(30) VARCHAR2(30) NOT NULL Award Name
6 SFA_CR_AWARD_YEAR Character(4) VARCHAR2(4) NOT NULL Award Year
7 SFA_CR_AWARD_NBR Number(2,0) SMALLINT NOT NULL Award Number
8 SFA_CR_ID_SSN Character(9) VARCHAR2(9) NOT NULL SSN Identifier
9 SFA_CR_ID_BIRTH_DT Character(10) VARCHAR2(10) NOT NULL Birthdate Identifier
10 SFA_CR_ID_LAST_NAM Character(35) VARCHAR2(35) NOT NULL Last Name Identifier
11 SFA_CR_FIRST_NAME Character(35) VARCHAR2(35) NOT NULL First Name
12 SFA_CR_MIDDLE_INIT Character(35) VARCHAR2(35) NOT NULL Middle Initial
13 SFA_CR_CNSL_SEQNBR Number(3,0) SMALLINT NOT NULL Counseling Sequence Number
14 SFA_CR_CNSL_CMP_DT Character(10) VARCHAR2(10) NOT NULL Counseling Complete Date
15 SFA_CR_AWARD_STAT Character(4) VARCHAR2(4) NOT NULL Award Status Code
E=Error
P=Processing Complete
S=Skipped Record
U=Unprocessed
16 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