ECTRANSIDECQUEUEINSTANCEECTRANSINOUTSWI=Inbound
O=Outbound
Default Value: I
DL_BATCH_ID_00DL_HDR_SAS21_VW(SQL View) |
Index Back |
|---|---|
DLSAS 2020-21 Search RecordDLSAS Search Record for 2020-21 inbound files |
| ( SELECT A.ECTRANSID , A.ECQUEUEINSTANCE , A.ECTRANSINOUTSW , A.DL_BATCH_ID_00 , A.LN_HEADER_NBR , A.DL_HEADER_ID , A.DL_REC_LNGTH_O , A.DL_MSG_CLASS , A.DL_HDR_CREATE_DT_O , A.DL_CREATE_TIME , A.DL_BATCH_RJCT , A.DL_REBUILD_TYPE , A.DL_PROVIDER_ID , A.DL_PROVIDER_VER , A.LOAN_TRANS_DTTM , A.PROCESS_INSTANCE , A.OPRID FROM PS_DL_HDR_21_EC A , PS_DL_LNDAL_21_EC B WHERE A.ECTRANSID = B.ECTRANSID AND A.ECQUEUEINSTANCE = B.ECQUEUEINSTANCE AND A.ECTRANSINOUTSW = B.ECTRANSINOUTSW) UNION ( SELECT C.ECTRANSID , C.ECQUEUEINSTANCE , C.ECTRANSINOUTSW , C.DL_BATCH_ID_00 , C.LN_HEADER_NBR , C.DL_HEADER_ID , C.DL_REC_LNGTH_O , C.DL_MSG_CLASS , C.DL_HDR_CREATE_DT_O , C.DL_CREATE_TIME , C.DL_BATCH_RJCT , C.DL_REBUILD_TYPE , C.DL_PROVIDER_ID , C.DL_PROVIDER_VER , C.LOAN_TRANS_DTTM , C.PROCESS_INSTANCE , C.OPRID FROM PS_DL_HDR_21_EC C , PS_DL_CSHSUM_21_EC D WHERE c.ECTRANSID = D.ECTRANSID AND c.ECQUEUEINSTANCE = D.ECQUEUEINSTANCE AND c.ECTRANSINOUTSW = D.ECTRANSINOUTSW) |
| # | 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 | DL_BATCH_ID_00 |
Character(23) | VARCHAR2(23) NOT NULL | DL Batch ID |
| 5 | LN_HEADER_NBR | Number(3,0) | SMALLINT NOT NULL | Loan Header Nbr |
| 6 | DL_HEADER_ID | Character(10) | VARCHAR2(10) NOT NULL | DL Header ID |
| 7 | DL_REC_LNGTH_O | Number(4,0) | SMALLINT NOT NULL | Record Length |
| 8 | DL_MSG_CLASS | Character(8) | VARCHAR2(8) NOT NULL | DL Message Class |
| 9 | DL_HDR_CREATE_DT_O | Date(10) | DATE | DL Create Date |
| 10 | DL_CREATE_TIME | Character(6) | VARCHAR2(6) NOT NULL | DL Create Time |
| 11 | DL_BATCH_RJCT | Character(2) | VARCHAR2(2) NOT NULL | Direct Loan Batch Reject Code |
| 12 | DL_REBUILD_TYPE | Character(2) | VARCHAR2(2) NOT NULL | DL Rebuild File Type |
| 13 | DL_PROVIDER_ID | Character(3) | VARCHAR2(3) NOT NULL | DL Software Provider ID |
| 14 | DL_PROVIDER_VER | Character(6) | VARCHAR2(6) NOT NULL | DL Software Provider Version |
| 15 | LOAN_TRANS_DTTM | DateTime(26) | TIMESTAMP | Loan Trans Date/Time |
| 16 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 17 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |