ECTRANSIDDefault Value: DSLF03OP
ECQUEUEINSTANCEECTRANSINOUTSWI=Inbound
O=Outbound
Default Value: I
LN_HEADER_NBRDL_DTL_SEQ_NBR_0Default Value: T
DL_CSHSUM_03_EC(SQL Table) |
Index Back |
|---|---|
DL Cash Sum 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_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_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_CASH_SUM_TYPE | Character(2) | VARCHAR2(2) NOT NULL | DL Cash Summary Type |
| 14 | DL_CSH_BAL_START_0 | Number(11,0) | DECIMAL(11) NOT NULL | Beginning Cash Balance |
| 15 | DL_CASH_RECEIPTS_0 | Number(11,0) | DECIMAL(11) NOT NULL | Cash Receipts |
| 16 | DL_EXCESS_CASH_0 | Number(11,0) | DECIMAL(11) NOT NULL | Excess Cash |
| 17 | DL_TOT_CSH_RECPT_0 | Number(11,0) | DECIMAL(11) NOT NULL | Total Net Cash Receipts |
| 18 | DL_NET_B00K_DISB_0 | Number(11,0) | DECIMAL(11) NOT NULL | Net Booked Disbursement |
| 19 | DL_NET_BOOK_ADJ_0 | Number(11,0) | DECIMAL(11) NOT NULL | Net Booked Adjustments |
| 20 | DL_TOT_BK_LN_DTL_0 | Number(11,0) | DECIMAL(11) NOT NULL | Total Booked Loan Detail |
| 21 | DL_CASH_BAL_END_0 | Number(11,0) | DECIMAL(11) NOT NULL | Ending Cash Balance |
| 22 | DL_NET_UNBK_ACT_0 | Number(11,0) | DECIMAL(11) NOT NULL | Net Unbooked Disbt Actual |
| 23 | DL_NET_UNBK_ADJ_0 | Number(11,0) | DECIMAL(11) NOT NULL | Net Unbooked Adjustments |
| 24 | DL_TOT_UNBKLNDTL_0 | Number(11,0) | DECIMAL(11) NOT NULL | Total Unbooked Loan Detail |
| 25 | DL_ADJ_CSHENDBAL_0 | Number(11,0) | DECIMAL(11) NOT NULL | Adjusted Ending Cash Balance |
| 26 | DL_FILLER_30 | Character(30) | VARCHAR2(30) NOT NULL | DL Filler 30 |
| 27 | DL_REC_CNTSEQ_NBR0 | Number(6,0) | INTEGER NOT NULL | Record Count Sequence # |