ECTRANSIDECQUEUEINSTANCEECTRANSINOUTSWI=Inbound
O=Outbound
Default Value: O
LN_APPL_IDDL_DISB_01_NBRDL_DISB_04_VW(SQL View) |
Index Back |
|---|---|
DL Disb Stgn Table '03Direct Loan Origination Disbursement Outbound 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_SRVCR_TOT_NET , DL_DISB_ACK_DT , DL_DSB_AFFIRM_FLAG , LNTRANS_PROC_DTTM FROM PS_DL_DISB_04_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: O |
| 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_SRVCR_TOT_NET | Character(5) | VARCHAR2(5) NOT NULL | Srvc Total Booked Net |
| 26 | DL_DISB_ACK_DT | Character(8) | VARCHAR2(8) NOT NULL | Acknowledgement Date |
| 27 | DL_DSB_AFFIRM_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Affirmation Flag |
| 28 | LNTRANS_PROC_DTTM | DateTime(26) | TIMESTAMP | Loan Proc Dt/Tm |