ECTRANSIDECQUEUEINSTANCEECTRANSINOUTSWI=Inbound
O=Outbound
Default Value: O
LN_APPL_IDDL_DISB_01_NBRDL_DISB_01_VW(SQL View) |
Index Back |
|---|---|
DL Disb Stgn Table '01Direct Loan Origination Disbursement Outbound Stgn Tbl - 2000-2001 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_ADJ , DL_USERID_CREATE , DL_BATCH_ID_00 , DL_SCHOOL_CD , DL_SCHL_CD_STAT , DL_LOAN_ID_STAT , DL_DISB_NBR_STAT , DL_DISB_RJCT_1 , DL_DISB_RJCT_2 , DL_DISB_RJCT_3 , DL_DISB_RJCT_4 , DL_DISB_RJCT_5 , DL_ACTNDT_STAT , DL_DISB_SEQ_STAT , 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_01_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_ADJ | Character(6) | VARCHAR2(6) NOT NULL | Actual Adjust 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_SCHL_CD_STAT | Character(1) | VARCHAR2(1) NOT NULL | School Code Status |
| 17 | DL_LOAN_ID_STAT | Character(1) | VARCHAR2(1) NOT NULL | Loan ID Status |
| 18 | DL_DISB_NBR_STAT | Character(1) | VARCHAR2(1) NOT NULL | Disbursement Nbr Status |
| 19 | DL_DISB_RJCT_1 | Character(2) | VARCHAR2(2) NOT NULL | DL Disb Reject 1 |
| 20 | DL_DISB_RJCT_2 | Character(2) | VARCHAR2(2) NOT NULL | DL Disb Reject 2 |
| 21 | DL_DISB_RJCT_3 | Character(2) | VARCHAR2(2) NOT NULL | DL Disb Reject 3 |
| 22 | DL_DISB_RJCT_4 | Character(2) | VARCHAR2(2) NOT NULL | DL Disb Reject 4 |
| 23 | DL_DISB_RJCT_5 | Character(2) | VARCHAR2(2) NOT NULL | DL Disb Reject 5 |
| 24 | DL_ACTNDT_STAT | Character(1) | VARCHAR2(1) NOT NULL | DL Action Dt Status |
| 25 | DL_DISB_SEQ_STAT | Character(1) | VARCHAR2(1) NOT NULL | Disbursement Seq Status |
| 26 | DL_DISB_GROSS_SVCR | Character(5) | VARCHAR2(5) NOT NULL | Svcr Actual Gross |
| 27 | DL_DISB_FEE_SVCR | Character(5) | VARCHAR2(5) NOT NULL | Svcr Actual Fee |
| 28 | DL_DISB_NET_SVCR | Character(5) | VARCHAR2(5) NOT NULL | Svcr Actual Net |
| 29 | DL_DISB_ADJ_SVCR | Character(6) | VARCHAR2(6) NOT NULL | Svcr Actual Adjustment |
| 30 | DL_SRVCR_TOT_NET | Character(5) | VARCHAR2(5) NOT NULL | Srvc Total Booked Net |
| 31 | DL_DISB_ACK_DT | Character(8) | VARCHAR2(8) NOT NULL | Acknowledgement Date |
| 32 | DL_DSB_AFFIRM_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Affirmation Flag |
| 33 | LNTRANS_PROC_DTTM | DateTime(26) | TIMESTAMP | Loan Proc Dt/Tm |