DL_DISB_ACK_EC(SQL Table) |
Index Back |
|---|---|
DL Disb Ack Stgn TblDirect Loan Disbursement Acknowledgment Outbound Stgn Tbl - 1997 Aid Year |
| # | 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_HEADER_NBR |
Number(3,0) | SMALLINT NOT NULL | Loan Header Nbr |
| 5 | DL_LOAN_ID |
Character(21) | VARCHAR2(21) NOT NULL | DL Loan ID |
| 6 | DL_DISB_NBR | Character(1) | VARCHAR2(1) NOT NULL | Disbursement Number |
| 7 | DL_DISB_ACTION | Character(1) | VARCHAR2(1) NOT NULL | Disbursement Action |
| 8 | DL_DISB_ACTN_DT_O | Date(10) | DATE | Disbursement Action Dt |
| 9 | DL_DISB_SEQ_NBR_O | Number(2,0) | SMALLINT NOT NULL | Disbursement Sequence Number |
| 10 | DL_DISB_ACT_GROS_O | Number(5,0) | INTEGER NOT NULL | Disb Actual Gross Amt |
| 11 | DL_DISB_ACT_FEE_O | Number(5,0) | INTEGER NOT NULL | Disb Actual Fee Amt |
| 12 | DL_DISB_ACT_NET_O | Number(5,0) | INTEGER NOT NULL | Disb Actual Net Amt |
| 13 | DL_DISB_ACT_ADJ_O | Number(6,0) | INTEGER NOT NULL | Disb Actual Adjust Amt |
| 14 | DL_USERID_CREATE | Character(8) | VARCHAR2(8) NOT NULL | User ID Create |
| 15 | DL_BATCH_ID | Character(2) | VARCHAR2(2) NOT NULL |
DL Batch ID
Default Value: #H |
| 16 | DL_BATCH_NBR | Character(15) | VARCHAR2(15) NOT NULL | DL Batch Nbr |
| 17 | DL_BATCH | Character(17) | VARCHAR2(17) NOT NULL | Direct Lending Batch |
| 18 | DL_SCHOOL_CD | Character(6) | VARCHAR2(6) NOT NULL | School Code |
| 19 | DL_SCHL_CD_STAT | Character(1) | VARCHAR2(1) NOT NULL |
School Code Status
Default Value: B |
| 20 | DL_LOAN_ID_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Loan ID Status
Default Value: B |
| 21 | DL_DISB_NBR_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Disbursement Nbr Status
Default Value: B |
| 22 | DL_DISB_ACTNSTAT | Character(1) | VARCHAR2(1) NOT NULL |
DL Disb Action Status
Default Value: B |
| 23 | DL_DISB_MSG1 | Character(1) | VARCHAR2(1) NOT NULL | DL Disb Msg 1 |
| 24 | DL_DISB_MSG2 | Character(1) | VARCHAR2(1) NOT NULL | DL Disb Msg 2 |
| 25 | DL_DISB_MSG3 | Character(1) | VARCHAR2(1) NOT NULL | DL Disb Msg 3 |
| 26 | DL_DISB_MSG4 | Character(1) | VARCHAR2(1) NOT NULL | DL Disb Msg 4 |
| 27 | DL_DISB_MSG5 | Character(1) | VARCHAR2(1) NOT NULL | DL Disb Msg 5 |
| 28 | DL_DISB_MSG6 | Character(1) | VARCHAR2(1) NOT NULL | DL Disb Msg 6 |
| 29 | DL_DISB_MSG7 | Character(1) | VARCHAR2(1) NOT NULL | DL Disb Msg 7 |
| 30 | DL_DISB_MSG8 | Character(1) | VARCHAR2(1) NOT NULL | DL Disb Msg 8 |
| 31 | DL_DISB_MSG9 | Character(1) | VARCHAR2(1) NOT NULL | DL Disb Msg 9 |
| 32 | DL_DISB_MSG10 | Character(1) | VARCHAR2(1) NOT NULL | DL Disb Msg 10 |
| 33 | DL_ACTNDT_STAT | Character(1) | VARCHAR2(1) NOT NULL |
DL Action Dt Status
Default Value: B |
| 34 | DL_DISB_SEQ_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Disbursement Seq Status
Default Value: B |
| 35 | DL_DISB_GRS_SVCR_O | Number(6,0) | INTEGER NOT NULL | DL Disbt Servicer Actual Gross |
| 36 | DL_DISB_FEE_SVCR_O | Number(5,0) | INTEGER NOT NULL | DL Disbt Servicer Actual Fee |
| 37 | DL_DISB_NET_SVCR_O | Number(6,0) | INTEGER NOT NULL | DL Disbt Servicer Actual Net |
| 38 | DL_DISB_ADJ_SVCR_O | Number(7,0) | INTEGER NOT NULL | DL Disbt Servicer Actual Adj |
| 39 | DL_RECON_STAT | Character(1) | VARCHAR2(1) NOT NULL | Reconciliation Status |
| 40 | DL_RECON_RJCT_1 | Character(2) | VARCHAR2(2) NOT NULL | Reconciliation Reject 1 |
| 41 | DL_RECON_RJCT_2 | Character(2) | VARCHAR2(2) NOT NULL | Reconciliation Reject 2 |
| 42 | DL_RECON_RJCT_3 | Character(2) | VARCHAR2(2) NOT NULL | Reconciliation Reject 3 |
| 43 | DL_RECON_RJCT_4 | Character(2) | VARCHAR2(2) NOT NULL | Reconciliation Reject 4 |
| 44 | DL_RECON_RJCT_5 | Character(2) | VARCHAR2(2) NOT NULL | Reconciliation Reject 5 |
| 45 | DL_SRVCR_TOT_NET_O | Number(5,0) | INTEGER NOT NULL | DL SvcrCtr Tot Net Amt |
| 46 | DL_RECORD_SEQ | Number(5,0) | INTEGER NOT NULL | DL Record Sequence Nbr |
| 47 | 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 |