DL_DSBACK_03_VW

(SQL View)
 Index Back

DL DisbAck Stgn Table '03

Direct Loan Origination Disbursement Acknowledgement Inbound Stgn Tbl - 2002-2003 Aid Year

SELECT ECTRANSID , ECQUEUEINSTANCE , ECTRANSINOUTSW , DL_LOAN_ID , DL_DISB_01_NBR , DL_DISB_ACTION , DL_DISBURS_ACTN_DT , DL_DISB_SEQ_NBR , DL_DISB_ACT_GROSS , DL_DISB_ACT_FEE , DL_DISB_ACT_NET , DL_DISB_ACT_REBATE , DL_USERID_CREATE , DL_BATCH_ID_00 , DL_SCHOOL_CD , DL_RJCT_1 , DL_RJCT_2 , DL_RJCT_3 , DL_RJCT_4 , DL_RJCT_5 , DL_DISB_GROSS_SVCR , DL_DISB_FEE_SVCR , DL_DISB_NET_SVCR , DL_DISB_ADJ_SVCR , DL_FRST_DISB_FLG , DL_DISB_REB_SVCR , DL_SRVCR_TOT_NET , DL_DISB_ACK_DT , DL_DSB_AFFIRM_FLAG , LNTRANS_PROC_DTTM , LN_STG_PROC_STAT , PROCESS_INSTANCE FROM PS_DL_DSBACK_03_EC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ECTRANSID Character(15) VARCHAR2(15) NOT NULL Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
2 ECQUEUEINSTANCE Number(9,0) DECIMAL(9) NOT NULL Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
3 ECTRANSINOUTSW Character(1) VARCHAR2(1) NOT NULL Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
I=Inbound
O=Outbound

Default Value: I

4 LN_APPL_ID Character(21) VARCHAR2(21) NOT NULL Loan Application ID
5 DL_DISB_01_NBR Character(2) VARCHAR2(2) NOT NULL Direct Lending Disbursement Number for for aid year 2000-2001. This field has increased to 2 digits from aid year 1999-2000 (field DL_DISB_NBR)
6 DL_DISB_ACTION Character(1) VARCHAR2(1) NOT NULL Disbursement Action
7 DL_DISBURS_ACTN_DT Character(8) VARCHAR2(8) NOT NULL Disbursement Action Dt
8 DL_DISB_SEQ_NBR Character(2) VARCHAR2(2) NOT NULL Disbursement Seq Nbr
9 DL_DISB_ACT_GROSS Character(5) VARCHAR2(5) NOT NULL Actual Gross Amt
10 DL_DISB_ACT_FEE Character(5) VARCHAR2(5) NOT NULL Actual Fee Amt
11 DL_DISB_ACT_NET Character(5) VARCHAR2(5) NOT NULL Actual Net Amount
12 DL_DISB_ACT_REBATE Character(5) VARCHAR2(5) NOT NULL Actual Rebate Amt
13 DL_USERID_CREATE Character(8) VARCHAR2(8) NOT NULL User ID Create
14 DL_BATCH_ID_00 Character(23) VARCHAR2(23) NOT NULL DL Batch ID
15 DL_SCHOOL_CD Character(6) VARCHAR2(6) NOT NULL School Code
16 DL_RJCT_1 Character(4) VARCHAR2(4) NOT NULL Reject Code 1
17 DL_RJCT_2 Character(4) VARCHAR2(4) NOT NULL Reject Code 2
18 DL_RJCT_3 Character(4) VARCHAR2(4) NOT NULL Reject Code 3
19 DL_RJCT_4 Character(4) VARCHAR2(4) NOT NULL Reject Code 4
20 DL_RJCT_5 Character(4) VARCHAR2(4) NOT NULL Reject Code 5
21 DL_DISB_GROSS_SVCR Character(5) VARCHAR2(5) NOT NULL Svcr Actual Gross
22 DL_DISB_FEE_SVCR Character(5) VARCHAR2(5) NOT NULL Svcr Actual Fee
23 DL_DISB_NET_SVCR Character(5) VARCHAR2(5) NOT NULL Svcr Actual Net
24 DL_DISB_ADJ_SVCR Character(6) VARCHAR2(6) NOT NULL Svcr Actual Adjustment
25 DL_FRST_DISB_FLG Character(1) VARCHAR2(1) NOT NULL First Disb Flag
26 DL_DISB_REB_SVCR Character(5) VARCHAR2(5) NOT NULL Svcr Actual Rebate
27 DL_SRVCR_TOT_NET Character(5) VARCHAR2(5) NOT NULL Srvc Total Booked Net
28 DL_DISB_ACK_DT Character(8) VARCHAR2(8) NOT NULL Acknowledgement Date
29 DL_DSB_AFFIRM_FLAG Character(1) VARCHAR2(1) NOT NULL Affirmation Flag
30 LNTRANS_PROC_DTTM DateTime(26) TIMESTAMP Loan Proc Dt/Tm
31 LN_STG_PROC_STAT Character(1) VARCHAR2(1) NOT NULL Loan Staging Record Proc Stat
E=Error
K=Skipped
L=Loaded
N=Not Processed
S=Skip
U=Unprocessed
X=Suspended
Y=Processed
32 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance