SSF_STDNT_LN_VW

(SQL View)
 Index Back

ANZ Student Loan Header

Student Loan Header for ANZ

SELECT H.EMPLID , H.ACAD_CAREER , H.INSTITUTION , H.STRM , H.STDNT_CAR_NBR , H.ACAD_PROG , H.BUSINESS_UNIT , D.SEQ_NUM , D.SSR_HECS_XMPT_STAT , D.SSF_LOAN_STATUS , D.SSF_NOTICE_STATUS , D.SSF_ELIG_CHARGES , D.SSF_PMTS_MADE , D.SSF_LOAN_AMOUNT , D.SSF_LOAN_FEE_AMT , D.POSTED_FLAG , D.LASTUPDDTTM , D.SSF_OVERRIDE_BAL , D.SCC_FEE_HELP_BAL FROM PS_SSF_STDNT_LNHDR H , PS_SSF_STDNT_LOAN D WHERE H.EMPLID = D.EMPLID AND H.ACAD_CAREER = D.ACAD_CAREER AND H.INSTITUTION = D.INSTITUTION AND H.STRM = D.STRM AND H.STDNT_CAR_NBR = D.STDNT_CAR_NBR

# 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 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: STDNT_CAREER

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

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

4 STRM Character(4) VARCHAR2(4) NOT NULL Term

Prompt Table: STDNT_TERM_SRCH

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

Prompt Table: SSF_PROG_ANZ_VW

6 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
8 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
9 SSR_HECS_XMPT_STAT Character(3) VARCHAR2(3) NOT NULL HECS Exempt Status

Prompt Table: SSF_HECS_EX_TBL

10 SSF_LOAN_STATUS Character(1) VARCHAR2(1) NOT NULL ANZ Loan Status
A=Approved
D=Denied
H=Hold
I=Ignore
P=Pending

Default Value: P

11 SSF_NOTICE_STATUS Character(1) VARCHAR2(1) NOT NULL ANZ Notice Status
D=Reported to DEST
P=Pending
R=Ready
S=Sent
V=Variation Required

Default Value: P

12 SSF_ELIG_CHARGES Signed Number(18,2) DECIMAL(16,2) NOT NULL Eligible Charges
13 SSF_PMTS_MADE Signed Number(18,2) DECIMAL(16,2) NOT NULL Payments Made
14 SSF_LOAN_AMOUNT Signed Number(18,2) DECIMAL(16,2) NOT NULL Loan Amount
15 SSF_LOAN_FEE_AMT Signed Number(18,2) DECIMAL(16,2) NOT NULL Loan Fee Amount
16 POSTED_FLAG Character(1) VARCHAR2(1) NOT NULL Posting Status

Default Value: N

17 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

Default Value: %DateTime

18 SSF_OVERRIDE_BAL Character(1) VARCHAR2(1) NOT NULL Override Balance

Y/N Table Edit

Default Value: N

19 SCC_FEE_HELP_BAL Number(10,2) DECIMAL(9,2) NOT NULL FEE-HELP Balance