ECTRANSIDDefault Value: DSLF03OP
ECQUEUEINSTANCEECTRANSINOUTSWI=Inbound
O=Outbound
Default Value: I
LN_HEADER_NBRDL_DTL_SEQ_NBR_0DL_LN_DTL_SEQ_0Default Value: L
DL_LNLVL_03_EC(SQL Table) |
Index Back |
|---|---|
DL Loan Detail Stg Tbl 2002-03 |
| # | 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)
Default Value: DSLF03OP |
| 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_DTL_SEQ_NBR_0 |
Number(3,0) | SMALLINT NOT NULL | Detail Sequence Number |
| 6 | DL_LN_DTL_SEQ_0 |
Number(6,0) | INTEGER NOT NULL | Loan Detail Sequence |
| 7 | DL_REC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Statement Record Type
Default Value: L |
| 8 | DL_BATCH_ID_00 | Character(23) | VARCHAR2(23) NOT NULL | DL Batch ID |
| 9 | CPS_SCHOOL_CODE | Character(6) | VARCHAR2(6) NOT NULL | CPS School Code. Also known as Title IV School Code |
| 10 | DL_REGION_CD | Character(2) | VARCHAR2(2) NOT NULL | Region Code |
| 11 | DL_STATE_CD | Character(2) | VARCHAR2(2) NOT NULL | State Code |
| 12 | DL_END_DATE_0 | Date(10) | DATE | DL End Date |
| 13 | DL_PROCESS_DATE_0 | Date(10) | DATE | DL Process Date |
| 14 | DL_LOAN_ID | Character(21) | VARCHAR2(21) NOT NULL | DL Loan ID |
| 15 | DL_LOAN_BKDT_SVCRO | Date(10) | DATE | Loan Booked Date at Servicer |
| 16 | DL_FILLER_8 | Character(8) | VARCHAR2(8) NOT NULL | DL Filler 8 |
| 17 | DL_ACTL_GRS_SVCR_O | Number(6,0) | INTEGER NOT NULL | DL Actual Servicer Gross |
| 18 | DL_ACTL_FEE_SVCR_O | Number(5,0) | INTEGER NOT NULL | DL Actual Servicer Fee |
| 19 | DL_ACTL_REB_SVCR_O | Number(5,0) | INTEGER NOT NULL | DL Actual Servicer Rebate |
| 20 | DL_ACTL_NET_SVCR_O | Number(6,0) | INTEGER NOT NULL | DL Actual Servicer Net |
| 21 | DL_FILLER_107 | Character(107) | VARCHAR2(107) NOT NULL | DL Filler 107 |
| 22 | DL_REC_CNTSEQ_NBR0 | Number(6,0) | INTEGER NOT NULL | Record Count Sequence # |