PROG_CASH_SEQ

(SQL Table)
Index Back

Loan Cash Detail

Maintains the Cash Detail information, by Reconciliation Period, used to reconcile Direct Loan with the Servicer.

  • Parent record: LOAN_CASH_SUM
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: AID_YEAR_TBL

    3 PROGRAM Character(1) VARCHAR2(1) NOT NULL Program
    C=CALG
    D=Ford DL
    F=FFELP
    H=HP
    L=Pell Grant
    P=Perkins
    S=SEOG
    W=FWS
    4 RECON_PER Character(10) VARCHAR2(10) NOT NULL Recon Per
    5 RECON_PER_SEQ Number(5,0) INTEGER NOT NULL Recon Period Sequence Number
    6 NBR_RECORDS Number(8,0) INTEGER NOT NULL Total Nbr of Records in Period
    7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    8 RECON_BATCH_ID Character(23) VARCHAR2(23) NOT NULL Recon Batch ID
    9 RECON_BATCH_DT Date(10) DATE Recon Batch Date
    10 RECON_CNFRM_CD Character(12) VARCHAR2(12) NOT NULL Recon Confirmation Code
    11 RECON_TXN_DT Date(10) DATE Recon Transaction Date
    12 RECON_TXN_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Recon Transaction Amount
    13 RECON_REQUEST_DT Date(10) DATE Request Date
    14 RECON_CASH Signed Number(13,2) DECIMAL(11,2) NOT NULL Recon Cash on Hand
    15 RECON_ANT_DISB Signed Number(13,2) DECIMAL(11,2) NOT NULL Recon Anticipated Disbursement
    16 RECON_REQUEST_AMT Signed Number(13,2) DECIMAL(11,2) NOT NULL Recon Requested Amount