DL_HDR_08_EC

(SQL Table)
 Index Back

DL Header In Stgn Tbl

Direct Loan Header Inbound Stgn Tbl - 2007 - 08 Aid Year

  • Parent Record Of DL_CSHDTL_08_EC DL_CSHDTL_09_EC DL_CSHDTL_10_EC DL_CSHDTL_11_EC DL_CSHDTL_12_EC DL_CSHDTL_13_EC DL_CSHDTL_14_EC DL_CSHDTL_15_EC DL_CSHDTL_16_EC DL_CSHDTL_17_EC DL_CSHDTL_18_EC DL_CSHDTL_19_EC DL_CSHDTL_20_EC DL_CSHDTL_21_EC DL_CSHDTL_22_EC DL_CSHSUM_08_EC DL_CSHSUM_08_VW DL_CSHSUM_09_EC DL_CSHSUM_09_VW DL_CSHSUM_10_EC DL_CSHSUM_10_VW DL_CSHSUM_11_EC DL_CSHSUM_11_VW DL_CSHSUM_12_EC DL_CSHSUM_12_VW DL_CSHSUM_13_EC DL_CSHSUM_13_VW DL_CSHSUM_14_EC DL_CSHSUM_14_VW DL_CSHSUM_15_EC DL_CSHSUM_15_VW DL_CSHSUM_16_EC DL_CSHSUM_16_VW DL_CSHSUM_17_EC DL_CSHSUM_18_EC DL_CSHSUM_19_EC DL_CSHSUM_20_EC DL_CSHSUM_21_EC DL_CSHSUM_22_EC DL_DISSUM_08_EC DL_DISSUM_09_EC DL_DISSUM_10_EC DL_DISSUM_11_EC DL_DISSUM_12_EC DL_DISSUM_13_EC DL_DISSUM_14_EC DL_DISSUM_15_EC DL_DISSUM_16_EC DL_DISSUM_17_EC DL_DISSUM_18_EC DL_DISSUM_19_EC DL_DISSUM_20_EC DL_DISSUM_21_EC DL_DISSUM_22_EC DL_LNDAL_08_EC DL_LNDAL_09_EC DL_LNDAL_10_EC DL_LNDAL_11_EC DL_LNDAL_12_EC DL_LNDAL_13_EC DL_LNDAL_14_EC DL_LNDAL_15_EC DL_LNDAL_16_EC DL_LNDAL_17_EC DL_LNDAL_18_EC DL_LNDAL_19_EC DL_LNDAL_20_EC DL_LNDAL_21_EC DL_LNDAL_22_EC DL_LNLVL_08_EC DL_LNLVL_09_EC DL_LNLVL_10_EC DL_LNLVL_11_EC DL_LNLVL_12_EC DL_LNLVL_13_EC DL_LNLVL_14_EC DL_LNLVL_15_EC DL_LNLVL_16_EC DL_LNLVL_17_EC DL_LNLVL_18_EC DL_LNLVL_19_EC DL_LNLVL_20_EC DL_LNLVL_21_EC DL_LNLVL_22_EC

    • # 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_HEADER_ID Character(10) VARCHAR2(10) NOT NULL DL Header ID

    Default Value: DL HEADER

    6 DL_REC_LNGTH_O Number(4,0) SMALLINT NOT NULL Record Length
    7 DL_MSG_CLASS Character(8) VARCHAR2(8) NOT NULL DL Message Class
    8 DL_BATCH_ID_00 Character(23) VARCHAR2(23) NOT NULL DL Batch ID
    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).
    18 DL_RECORD_LENGTH Character(4) VARCHAR2(4) NOT NULL Loan Record Length