SSF_STD_LNO_SRC

(SQL View)
 Index Back

OS HELP Student Loan

OS HELP Student Loan Search Record

SELECT A.EMPLID , B.NAME , A.ACAD_CAREER , A.INSTITUTION ,C.ACAD_PROG ,A.STRM , A.STDNT_CAR_NBR ,A.SSF_OS_STUDY_PD ,A.SSR_HECS_XMPT_STAT ,A.SSF_LOAN_STATUS ,A.SSF_OS_INCUR_DT ,A.SSF_LOAN_AMOUNT ,(( SELECT D.DESCR FROM PS_SSR_CNTRY2_AUS D WHERE D.SSR_COUNTRY_DEST=A.SSF_OSHELP_CNTRY_P AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_SSR_CNTRY2_AUS D1 WHERE D.SSR_COUNTRY_DEST=D1.SSR_COUNTRY_DEST AND D1.EFFDT <= T.TERM_BEGIN_DT AND D1.EFF_STATUS='A'))),(( SELECT D.DESCR FROM PS_SSR_CNTRY2_AUS D WHERE D.SSR_COUNTRY_DEST=A.SSF_OSHELP_CNTRY_S AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_SSR_CNTRY2_AUS D1 WHERE D.SSR_COUNTRY_DEST=D1.SSR_COUNTRY_DEST AND D1.EFFDT <= T.TERM_BEGIN_DT AND D1.EFF_STATUS='A'))) ,(( SELECT D.DESCR FROM PS_SSR_LANG2_DEST D WHERE D.SSR_LANG_CD_DEST=A.SSR_E582_AUS AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_SSR_LANG2_DEST D1 WHERE D.SSR_LANG_CD_DEST=D1.SSR_LANG_CD_DEST AND D1.EFFDT <= T.TERM_BEGIN_DT AND D1.EFF_STATUS='A'))) ,A.SSR_E583_AUS FROM PS_SSF_STDNT_LN_OS A , PS_SCC_PRI_NAME_VW B ,PS_SSF_PROG_ANZ_VW C , PS_TERM_TBL T WHERE A.EMPLID = B.EMPLID AND A.EMPLID=C.EMPLID AND A.ACAD_CAREER=C.ACAD_CAREER AND A.INSTITUTION=C.INSTITUTION AND A.STRM=C.STRM AND A.STDNT_CAR_NBR=C.STDNT_CAR_NBR AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_SCC_PRI_NAME_VW B1 WHERE B1.EMPLID = B.EMPLID AND B1.EFFDT <= %CurrentDateIn) AND T.INSTITUTION=A.INSTITUTION AND T.ACAD_CAREER=A.ACAD_CAREER AND T.STRM=A.STRM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: SCC_PERS_SA_VW

2 NAME Character(50) VARCHAR2(50) NOT NULL Name
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

Prompt Table: SSF_OS_CAR_VW

4 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

5 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
6 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: STDNT_TERM_SRCH

7 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr

Prompt Table: SSF_PROG_ANZ_VW

8 SSF_OS_STUDY_PD Date(10) DATE Australia DEST processing
9 SSR_HECS_XMPT_STAT Character(3) VARCHAR2(3) NOT NULL Liability Status
10 SSF_LOAN_STATUS Character(1) VARCHAR2(1) NOT NULL Loan Status
A=Approved
D=Denied
H=Hold
I=Ignore
P=Pending
11 SSF_OS_INCUR_DT Date(10) DATE Revised Incurral Date
12 SSF_LOAN_AMOUNT Signed Number(18,2) DECIMAL(16,2) NOT NULL Loan Amount
13 SSF_OS_CTRY_P_DESC Character(30) VARCHAR2(30) NOT NULL Primary Study Country
14 SSF_OS_CTRY_S_DESC Character(30) VARCHAR2(30) NOT NULL Secondary Study Country
15 SSR_E582_AUS_DESC Character(30) VARCHAR2(30) NOT NULL Language
16 SSR_E583_AUS Date(10) DATE OS?HELP Language study commencement date