LN_CL_HR_OVR_VW

(SQL View)
 Index Back

Prompt view std w/loan awards

Pulls emplids with awards of loan type and accepted status used in Origination 6/13/2000 Added LOAN_TYPE, LN_PERIOD_START, LN_PERIOD_END

SELECT DISTINCT B.INSTITUTION , B.AID_YEAR , B.ACAD_CAREER , B.EMPLID , A.NAME , B.LOAN_TYPE , B.LN_PERIOD_START , B.LN_PERIOD_END FROM PS_SCC_PRI_NAME_VW A , PS_LOAN_ORIGNATN B , PS_LOAN_ORIG_DTL C , PS_LOAN_DISBMNT D WHERE A.EMPLID = B.EMPLID AND A.EMPLID = C.EMPLID AND A.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PS_SCC_PRI_NAME_VW X1 WHERE X1.EMPLID = A.EMPLID) AND B.INSTITUTION = C.INSTITUTION AND B.AID_YEAR = C.AID_YEAR AND B.ACAD_CAREER = C.ACAD_CAREER AND B.LOAN_TYPE = C.LOAN_TYPE AND B.LN_APPL_SEQ = C.LN_APPL_SEQ AND A.EMPLID = D.EMPLID AND B.INSTITUTION = D.INSTITUTION AND B.AID_YEAR = D.AID_YEAR AND B.ACAD_CAREER = D.ACAD_CAREER AND B.LOAN_TYPE = D.LOAN_TYPE AND B.LN_APPL_SEQ = D.LN_APPL_SEQ AND C.ITEM_TYPE = D.ITEM_TYPE AND (B.LN_VERSION = 'CL-VER-04' OR B.LN_VERSION = 'CRC-VER-01') AND C.LOAN_PROC_STAT = 'S' AND C.LN_ORIG_TRANS = 'A' AND (D.LOAN_PAID_IND = 'N' OR D.LOAN_PAID_IND = ' ')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year
3 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
BAC=Bachelor (NLD)
BBL=Vocational Coaching (NLD)
BOL=Vocational Training (NLD)
BUSN=Graduate Business
CNED=Continuing Education
CRED=Semester Credit
EDU=Education (NLD)
EXED=Extended Education
GRAD=Graduate
LAW=Law
MEDS=Medical School
NONA=Non Award
PGRD=Postgraduate
RSCH=Research
TECH=Technical
UENG=Undergraduate Engineering
UGRD=Undergraduate
VAVO=Advanced General Educ. (NLD)
VETM=Veterinary Medicine
4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
5 NAME Character(50) VARCHAR2(50) NOT NULL Name
6 LOAN_TYPE Character(4) VARCHAR2(4) NOT NULL Loan Type Cd
7 LN_PERIOD_START Date(10) DATE Loan Period Start
8 LN_PERIOD_END Date(10) DATE Loan Period End