SSR_HM_LOAN_LTX

(SQL View)
 Index Back

Last Loan transaction

Last successful transactions of Student SA_HELP or OS-HELP Loans

SELECT LN.EMPLID , LN.SSR_HLP_DBT_INC_DT , LN.SSF_AUS_LOAN_TYPE , MAX(LN.SSR_TRANS_ID) FROM %Table(SSR_HM_LOAN) LN , %Table(SSR_HM_UID_MAP) UM WHERE LN.EMPLID = UM.EMPLID AND LN.SSR_HLP_DBT_INC_DT = UM.SSR_HLP_DBT_INC_DT AND LN.SSF_AUS_LOAN_TYPE = UM.SSF_AUS_LOAN_TYPE AND LN.SSR_MAP_ID <> 0 AND LN.IB_RESTMETHOD NOT LIKE 'DELETE' AND UM.DELETE_FLAG = 'N' AND UM.EFF_STATUS = 'A' AND UM.RECNAME = 'SSR_HM_LOAN' AND LN.SSF_AUS_LOAN_TYPE IN ('S', 'O', 'A', 'L') GROUP BY LN.EMPLID, LN.SSR_HLP_DBT_INC_DT, LN.SSF_AUS_LOAN_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 SSR_HLP_DBT_INC_DT Date(10) DATE HELP Debt Incurral Date Key Field
3 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
4 SSR_TRANS_ID Number(31,0) DECIMAL(31) NOT NULL HEIMS Transaction ID