ECTRANSIDECQUEUEINSTANCEECTRANSINOUTSWI=Inbound
O=Outbound
Default Value: I
LN_HEADER_NBRDL_BATCH_ID_00DL_DTL_SEQNBRDL_LNDAL_17_EC(SQL Table) |
Index Back |
|---|---|
DL Disb ActLvl Stg Tbl 2015-16DL SAS Disbursement Activity Import StagingTable 2015-16 |
| # | 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_BATCH_ID_00 |
Character(23) | VARCHAR2(23) NOT NULL | DL Batch ID |
| 6 | DL_DTL_SEQNBR |
Number(9,0) | DECIMAL(9) NOT NULL | Detail Sequence Number |
| 7 | DL_REC_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Statement Record Type |
| 8 | CPS_SCHOOL_CODE | Character(6) | VARCHAR2(6) NOT NULL | CPS School Code. Also known as Title IV School Code |
| 9 | DL_REGION_CD | Character(2) | VARCHAR2(2) NOT NULL | Region Code |
| 10 | DL_STATE_CD | Character(2) | VARCHAR2(2) NOT NULL | State Code |
| 11 | DL_END_DATE_0 | Date(10) | DATE | DL End Date |
| 12 | DL_PROCESS_DATE_0 | Date(10) | DATE | DL Process Date |
| 13 | DL_LOAN_ID | Character(21) | VARCHAR2(21) NOT NULL | DL Loan ID |
| 14 | DL_LOAN_BKDT_SVCRO | Date(10) | DATE | Loan Booked Date at Servicer |
| 15 | DL_DISB_BKDT_LOC_0 | Date(10) | DATE | Disbursement Book Date at LOC |
| 16 | DL_DISB_GRS_SVCR_O | Number(6,0) | INTEGER NOT NULL | DL Disbt Servicer Actual Gross |
| 17 | DL_DISB_FEE_SVCR_O | Number(5,0) | INTEGER NOT NULL | DL Disbt Servicer Actual Fee |
| 18 | DL_DISB_REB_SVCR_O | Number(5,0) | INTEGER NOT NULL | DL Disbt Servicer Rebate |
| 19 | DL_DISB_NET_SVCR_O | Number(6,0) | INTEGER NOT NULL | DL Disbt Servicer Actual Net |
| 20 | DL_DISB_ADJ_SVCR_O | Number(7,0) | INTEGER NOT NULL | DL Disbt Servicer Actual Adj |
| 21 | DL_DISB_NBR2_0 | Number(2,0) | SMALLINT NOT NULL | Disbursement Number |
| 22 | DL_DISB_SEQ_NBR_O | Number(2,0) | SMALLINT NOT NULL | Disbursement Sequence Number |
| 23 | DL_TRANS_TYPE_DISB | Character(1) | VARCHAR2(1) NOT NULL | Transaction Type-Disbursement |
| 24 | DL_TRANS_DATE_0 | Date(10) | DATE | Transaction Date |
| 25 | DL_TOT_GRS_SVCR_O | Number(6,0) | INTEGER NOT NULL | DL Total Servicer Gross |
| 26 | DL_TOT_FEE_SVCR_O | Number(5,0) | INTEGER NOT NULL | DL Total Servicer Fee |
| 27 | DL_TOT_REB_SVCR_O | Number(5,0) | INTEGER NOT NULL | DL Total Svcr Rebate |
| 28 | DL_TOT_NET_SVCR_O | Number(6,0) | INTEGER NOT NULL | DL Total Servicer Net |
| 29 | DL_REC_CNTSEQ_NBR0 | Number(6,0) | INTEGER NOT NULL | Record Count Sequence # |
| 30 | SFA_DL_SERVICER | Character(30) | VARCHAR2(30) NOT NULL | Servicer Name |
| 31 | DL_START_DATE_O | Date(10) | DATE | Start Date |