DL_TRL_02_VW

(SQL View)
 Index Back

DL Trailer In Stgn Tbl

Direct Loan Trailer Inbound Stgn Tbl - 1997 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_02_EC A, PS_DL_TRL_02_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

  • Parent record: DL_HEADR_IN_EC

    • # 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