ECTRANSIDECQUEUEINSTANCEECTRANSINOUTSWI=Inbound
O=Outbound
Default Value: I
LN_HEADER_NBRDL_BATCH_ID_00DL_DTL_SEQNBRDL_LNLVL_25_EC(SQL Table) |
Index Back |
|---|---|
DL Loan Detail Stg Tbl 2024-25DL SAS Loan Level Detail Import StagingTable 2024-25 |
| # | 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_ACTL_GRS_SVCR_O | Number(6,0) | INTEGER NOT NULL | DL Actual Servicer Gross |
| 16 | DL_ACTL_FEE_SVCR_O | Number(5,0) | INTEGER NOT NULL | DL Actual Servicer Fee |
| 17 | DL_ACTL_REB_SVCR_O | Number(5,0) | INTEGER NOT NULL | DL Actual Servicer Rebate |
| 18 | DL_ACTL_NET_SVCR_O | Number(6,0) | INTEGER NOT NULL | DL Actual Servicer Net |
| 19 | DL_BORR_FRST_NM_02 | Character(35) | VARCHAR2(35) NOT NULL | Borrower's First Name |
| 20 | DL_BORR_MI | Character(35) | VARCHAR2(35) NOT NULL | Borrower's Middle Initial |
| 21 | DL_BORR_LAST_NAME | Character(35) | VARCHAR2(35) NOT NULL | Borrower's Last Name |
| 22 | DL_BORR_SUFFIX | Character(10) | VARCHAR2(10) NOT NULL | 2425 Student Suffix |
| 23 | DL_STU_FRST_NM_02 | Character(35) | VARCHAR2(35) NOT NULL | Student's First Name |
| 24 | DL_STU_MI | Character(35) | VARCHAR2(35) NOT NULL | Student's Middle Initial |
| 25 | DL_STU_LAST_NAME | Character(35) | VARCHAR2(35) NOT NULL | Student's Last Name |
| 26 | DL_STUDENT_SUFFIX | Character(10) | VARCHAR2(10) NOT NULL | 2425 Student Suffix |
| 27 | DL_REC_CNTSEQ_NBR0 | Number(6,0) | INTEGER NOT NULL | Record Count Sequence # |
| 28 | SFA_DL_SERVICER | Character(30) | VARCHAR2(30) NOT NULL | Servicer Name |