DL_TRL_20_VW (SQL View)	Index Back
DL Trailer In Stgn Tbl Direct Loan Trailer Inbound Stgn Tbl 2015- 2016 Aid Year

DL_TRL_20_VW

(SQL View)

DL Trailer In Stgn Tbl

Direct Loan Trailer Inbound Stgn Tbl 2015- 2016 Aid Year

SELECT A.DL_BATCH_ID_00 , B.ECTRANSID , B.ECQUEUEINSTANCE , B.ECTRANSINOUTSW , B.LN_HEADER_NBR , B.LN_TRAILER_NBR , B.DL_TRAILER_ID , B.DL_REC_LNGTH_O , B.DL_NBR_RECS_O , B.DL_TRLR_NBR_ACPT_O , B.DL_TRLR_NBR_RJCT_O , B.DL_TRLR_NBR_PEND_O FROM PS_DL_HDR_20_EC A , PS_DL_TRL_20_EC B WHERE A.ECTRANSID = B.ECTRANSID AND A.ECQUEUEINSTANCE = B.ECQUEUEINSTANCE AND A.ECTRANSINOUTSW = B.ECTRANSINOUTSW AND A.LN_HEADER_NBR = B.LN_HEADER_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TRNSFR_BATCH Character(23) VARCHAR2(23) NOT NULL Transfer Batch

2 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)

3 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.

4 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

5 LN_HEADER_NBR Number(3,0) SMALLINT NOT NULL Loan Header Nbr

6 LN_TRAILER_NBR Number(3,0) SMALLINT NOT NULL Loan Trailer Nbr

7 DL_TRAILER_ID Character(10) VARCHAR2(10) NOT NULL DL Trailer ID

8 DL_REC_LNGTH_O Number(4,0) SMALLINT NOT NULL Record Length

9 DL_NBR_RECS_O Number(7,0) INTEGER NOT NULL Number of Records

10 DL_TRLR_NBR_ACPT_O Number(5,0) INTEGER NOT NULL Accepted Records

11 DL_TRLR_NBR_RJCT_O Number(5,0) INTEGER NOT NULL Rejected Records

12 DL_TRLR_NBR_PEND_O Number(5,0) INTEGER NOT NULL Pending Records

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TRNSFR_BATCH	Character(23)	VARCHAR2(23) NOT NULL	Transfer Batch
2	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)
3	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.
4	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
5	LN_HEADER_NBR	Number(3,0)	SMALLINT NOT NULL	Loan Header Nbr
6	LN_TRAILER_NBR	Number(3,0)	SMALLINT NOT NULL	Loan Trailer Nbr
7	DL_TRAILER_ID	Character(10)	VARCHAR2(10) NOT NULL	DL Trailer ID
8	DL_REC_LNGTH_O	Number(4,0)	SMALLINT NOT NULL	Record Length
9	DL_NBR_RECS_O	Number(7,0)	INTEGER NOT NULL	Number of Records
10	DL_TRLR_NBR_ACPT_O	Number(5,0)	INTEGER NOT NULL	Accepted Records
11	DL_TRLR_NBR_RJCT_O	Number(5,0)	INTEGER NOT NULL	Rejected Records
12	DL_TRLR_NBR_PEND_O	Number(5,0)	INTEGER NOT NULL	Pending Records