LOAN_DISB_VW

(SQL View)
 Index Back

Loan Disbursement Detail View

Loan Origination Loan Disbursement Detail View

SELECT DISTINCT a.emplid , a.institution , a.aid_year , a.loan_type , a.ln_appl_seq , a.item_type , a.disbursement_id , a.ln_action_type , a.ln_action_cd , a.ln_action_dt , a.ln_action_status , a.LN_ACTNSTAT_DT , a.trnsfr_batch , a.RECON_STATUS , a.RECON_STATUS_DT , a.ln_book_stat FROM PS_LOAN_DISB_ACTN a , ps_loan_disbmnt b WHERE a.emplid = b.emplid AND a.institution = b.institution AND a.aid_year = b.aid_year AND a.acad_career = b.acad_career AND a.loan_type = b.loan_type AND a.ln_appl_seq = b.ln_appl_seq AND a.item_type = b.item_type AND a.disbursement_id = b.disbursement_id AND a.ln_disb_seq_nbr = ( SELECT MAX(c.ln_disb_seq_nbr) FROM PS_LOAN_DISB_ACTN c WHERE a.emplid = c.emplid AND a.institution = c.institution AND a.aid_year = c.aid_year AND a.acad_career = c.acad_career AND a.loan_type = c.loan_type AND a.ln_appl_seq = c.ln_appl_seq AND a.item_type = c.item_type AND a.disbursement_id = c.disbursement_id)

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

Prompt Table: PEOPLE_SRCH

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

Default Value: OPR_DEF_TBL_CS.INSTITUTION

Prompt Table: INSTITUTION_TBL

3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

Default Value: OPR_DEF_TBL_CS.AID_YEAR

Prompt Table: AID_YEAR_TBL

4 LOAN_TYPE Character(4) VARCHAR2(4) NOT NULL Loan Type Cd
5 LN_APPL_SEQ Number(2,0) SMALLINT NOT NULL Loan Application Seq Num
6 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

Prompt Table: LN_ITEM_TBL

7 DISBURSEMENT_ID Character(2) VARCHAR2(2) NOT NULL Disbursement ID

Default Value: LOAN_DISBMNT.DISBURSEMENT_ID

8 LN_ACTION_TYPE Character(1) VARCHAR2(1) NOT NULL Loan Action Type

Default Value: D

Prompt Table: LN_ACTNTYPE_TBL

9 LN_ACTION_CD Character(4) VARCHAR2(4) NOT NULL Loan Action Cd

Prompt Table: LN_DISBCD_VW

10 LN_ACTION_DT DateTime(26) TIMESTAMP Loan Action Dttm
11 LN_ACTION_STATUS Character(1) VARCHAR2(1) NOT NULL Loan Action Status
A=Accptd-Not Applied
B=Accepted
F=Failed Rule
I=Invalid
L=Lower Endorser Amount accepted
O=Authorized for Transfer
P=Pending
R=Rejected
T=Transmitted
U=Received
W=Accepted with Corrected Award
12 LN_ACTNSTAT_DT Date(10) DATE Loan Action Status Dt
13 TRNSFR_BATCH Character(23) VARCHAR2(23) NOT NULL Transfer Batch
14 RECON_STATUS Character(1) VARCHAR2(1) NOT NULL Reconciliation Status
15 RECON_STATUS_DT Date(10) DATE Reconciliation Status Date
16 LN_BOOK_STAT Character(1) VARCHAR2(1) NOT NULL Direct Lending Booked Status
A=Booked
R=Unbooked