SSF_HECSXMPT_VW

(SQL View)
Index Back

Liability Status

View to Fetch Liability Status for SA-Help

SELECT A.SSR_HECS_XMPT_STAT ,A.EFF_STATUS ,A.DESCR ,A.SSF_AUS_LOAN_TYPE FROM PS_SSF_HECS_EX_TBL A WHERE A.SSF_AUS_LOAN_TYPE = 'S' AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SSR_HECS_XMPT_STAT Character(3) VARCHAR2(3) NOT NULL Liability Status
2 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 SSF_AUS_LOAN_TYPE Character(1) VARCHAR2(1) NOT NULL AUS Loan Type
A=OS-HELP for study in Asia
E=Exempt
F=FEE-HELP
H=HECS-HELP
L=OS-HELP Language study
O=OS-HELP
S=SA-HELP