ECTRANSIDECQUEUEINSTANCEECTRANSINOUTSWI=Inbound
O=Outbound
Default Value: I
LN_HEADER_NBRDL_BATCH_ID_00DL_DTL_SEQNBRDL_CSHSUM_23_EC(SQL Table) |
Index Back |
|---|---|
DL Cash Sum Stg Tbl 2022-23DL SAS Cash Summary Import StagingTable 2022-23 |
| # | 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_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_REC_CNTSEQ_NBR0 | Number(6,0) | INTEGER NOT NULL | Record Count Sequence # |