DL_LNDAL_10_EC

(SQL Table)
Index Back

DL Disb ActLvl Stg Tbl 2009-10

DL SAS Disbursement Activity Import StagingTable 2009-10

  • Parent record: DL_HDR_08_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)

    Default Value: DSLF09OP

    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

    Default Value: D

    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_LOAN_ID Character(21) VARCHAR2(21) NOT NULL DL Loan ID
    14 DL_LOAN_BKDT_SVCRO Date(10) DATE Loan Booked Date at Servicer
    15 DL_DISB_BKDT_LOC_0 Date(10) DATE Disbursement Book Date at LOC
    16 DL_DISB_GRS_SVCR_O Number(6,0) INTEGER NOT NULL DL Disbt Servicer Actual Gross
    17 DL_DISB_FEE_SVCR_O Number(5,0) INTEGER NOT NULL DL Disbt Servicer Actual Fee
    18 DL_DISB_REB_SVCR_O Number(5,0) INTEGER NOT NULL DL Disbt Servicer Rebate
    19 DL_DISB_NET_SVCR_O Number(6,0) INTEGER NOT NULL DL Disbt Servicer Actual Net
    20 DL_DISB_ADJ_SVCR_O Number(7,0) INTEGER NOT NULL DL Disbt Servicer Actual Adj
    21 DL_DISB_NBR2_0 Number(2,0) SMALLINT NOT NULL Disbursement Number
    22 DL_DISB_SEQ_NBR_O Number(2,0) SMALLINT NOT NULL Disbursement Sequence Number
    23 DL_TRANS_TYPE_DISB Character(1) VARCHAR2(1) NOT NULL Transaction Type-Disbursement
    24 DL_TRANS_DATE_0 Date(10) DATE Transaction Date
    25 DL_TOT_GRS_SVCR_O Number(6,0) INTEGER NOT NULL DL Total Servicer Gross
    26 DL_TOT_FEE_SVCR_O Number(5,0) INTEGER NOT NULL DL Total Servicer Fee
    27 DL_TOT_REB_SVCR_O Number(5,0) INTEGER NOT NULL DL Total Svcr Rebate
    28 DL_TOT_NET_SVCR_O Number(6,0) INTEGER NOT NULL DL Total Servicer Net
    29 DL_REC_CNTSEQ_NBR0 Number(6,0) INTEGER NOT NULL Record Count Sequence #