ECTRANSIDDefault Value: DSAS01OP
ECQUEUEINSTANCEECTRANSINOUTSWI=Inbound
O=Outbound
Default Value: I
LN_HEADER_NBRDL_DTL_SEQ_NBR_0Default Value: T
DL_CSHSUM_01_EC(SQL Table) |
Index Back |
|---|---|
DL Cash Sum Stg Tbl 2000-01 |
| # | 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: DSAS01OP |
| 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_REC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Statement Record Type
Default Value: T |
| 7 | DL_BATCH_ID_00 | Character(23) | VARCHAR2(23) NOT NULL | DL Batch ID |
| 8 | CPS_SCHOOL_CODE | Character(6) | VARCHAR2(6) NOT NULL | CPS School Code. Also known as Title IV School Code |
| 9 | DL_END_DATE_0 | Date(10) | DATE | DL End Date |
| 10 | DL_FILLER_2 | Character(2) | VARCHAR2(2) NOT NULL | DL Filler 2 |
| 11 | DL_PROCESS_DATE_0 | Date(10) | DATE | DL Process Date |
| 12 | DL_CSH_BAL_START_0 | Number(11,0) | DECIMAL(11) NOT NULL | Beginning Cash Balance |
| 13 | DL_CASH_RECEIPTS_0 | Number(11,0) | DECIMAL(11) NOT NULL | Cash Receipts |
| 14 | DL_EXCESS_CASH_0 | Number(11,0) | DECIMAL(11) NOT NULL | Excess Cash |
| 15 | DL_TOT_CSH_RECPT_0 | Number(11,0) | DECIMAL(11) NOT NULL | Total Net Cash Receipts |
| 16 | DL_NET_B00K_DISB_0 | Number(11,0) | DECIMAL(11) NOT NULL | Net Booked Disbursement |
| 17 | DL_NET_BOOK_ADJ_0 | Number(11,0) | DECIMAL(11) NOT NULL | Net Booked Adjustments |
| 18 | DL_TOT_BK_LN_DTL_0 | Number(11,0) | DECIMAL(11) NOT NULL | Total Booked Loan Detail |
| 19 | DL_CASH_BAL_END_0 | Number(11,0) | DECIMAL(11) NOT NULL | Ending Cash Balance |
| 20 | DL_NET_UNBK_ACT_0 | Number(11,0) | DECIMAL(11) NOT NULL | Net Unbooked Disbt Actual |
| 21 | DL_NET_UNBK_ADJ_0 | Number(11,0) | DECIMAL(11) NOT NULL | Net Unbooked Adjustments |
| 22 | DL_TOT_UNBKLNDTL_0 | Number(11,0) | DECIMAL(11) NOT NULL | Total Unbooked Loan Detail |
| 23 | DL_ADJ_CSHENDBAL_0 | Number(11,0) | DECIMAL(11) NOT NULL | Adjusted Ending Cash Balance |
| 24 | DL_FILLER_34 | Character(34) | VARCHAR2(34) NOT NULL | DL Filler 34 |
| 25 | DL_REC_CNTSEQ_NBR0 | Number(6,0) | INTEGER NOT NULL | Record Count Sequence # |