DL_CSHSUM_13_EC

(SQL Table)
Index Back

DL Cash Sum Stg Tbl 2012-13

DL SAS Cash Summary Import StagingTable 2012-13

  • 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: DSLF12OP

    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: T

    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_CASH_SUM_TYPE Character(2) VARCHAR2(2) NOT NULL DL Cash Summary Type
    14 DL_CSH_BAL_START_0 Number(11,0) DECIMAL(11) NOT NULL Beginning Cash Balance
    15 DL_CASH_RECEIPTS_0 Number(11,0) DECIMAL(11) NOT NULL Cash Receipts
    16 DL_EXCESS_CASH_0 Number(11,0) DECIMAL(11) NOT NULL Excess Cash
    17 DL_TOT_CSH_RECPT_0 Number(11,0) DECIMAL(11) NOT NULL Total Net Cash Receipts
    18 DL_NET_B00K_DISB_0 Number(11,0) DECIMAL(11) NOT NULL Net Booked Disbursement
    19 DL_NET_BOOK_ADJ_0 Number(11,0) DECIMAL(11) NOT NULL Net Booked Adjustments
    20 DL_TOT_BK_LN_DTL_0 Number(11,0) DECIMAL(11) NOT NULL Total Booked Loan Detail
    21 DL_CASH_BAL_END_0 Number(11,0) DECIMAL(11) NOT NULL Ending Cash Balance
    22 DL_NET_UNBK_ACT_0 Number(11,0) DECIMAL(11) NOT NULL Net Unbooked Disbt Actual
    23 DL_NET_UNBK_ADJ_0 Number(11,0) DECIMAL(11) NOT NULL Net Unbooked Adjustments
    24 DL_TOT_UNBKLNDTL_0 Number(11,0) DECIMAL(11) NOT NULL Total Unbooked Loan Detail
    25 DL_ADJ_CSHENDBAL_0 Number(11,0) DECIMAL(11) NOT NULL Adjusted Ending Cash Balance
    26 DL_REC_CNTSEQ_NBR0 Number(6,0) INTEGER NOT NULL Record Count Sequence #