UPG_COD_DSB_AET

(SQL Table)
Index Back

COD Disbursement Information

Contains Student Award Disbursement Information.

  • Parent record: SFA_COD_AWARD
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    2 SFA_CR_DOCUMENT_ID Character(34) VARCHAR2(34) NOT NULL Document ID
    3 SFA_CR_RPT_SCHL_ID Character(8) VARCHAR2(8) NOT NULL Reporting School ID
    4 SFA_CR_ATT_SCHL_ID Character(8) VARCHAR2(8) NOT NULL Attended School ID
    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    6 SFA_CR_AWARD_NAME Character(30) VARCHAR2(30) NOT NULL Award Name
    7 SFA_CR_AWARD_YEAR Character(4) VARCHAR2(4) NOT NULL Award Year
    8 SFA_CR_AWARD_NBR Number(2,0) SMALLINT NOT NULL Award Number
    9 SFA_CR_DISB_NBR Number(4,0) SMALLINT NOT NULL Disbursement Number
    10 SFA_CR_DISB_AMT Character(12) VARCHAR2(12) NOT NULL Disbursement Amount
    11 SFA_CR_DISB_DT Character(10) VARCHAR2(10) NOT NULL Disbursement Date
    12 SFA_CR_DSB_RELEASE Character(5) VARCHAR2(5) NOT NULL Disbursement Release
    13 SFA_CR_DSB_SEQ_NBR Character(2) VARCHAR2(2) NOT NULL Disbursement Sequence
    14 SFA_CR_NOTE_MSG Character(20) VARCHAR2(20) NOT NULL Note Message
    15 SFA_CR_FIRST_DISB Character(5) VARCHAR2(5) NOT NULL First Disbursement
    16 SFA_CR_DSB_NET_AMT Character(12) VARCHAR2(12) NOT NULL Disbursement Net Amount
    17 SFA_CR_DSB_FEE_AMT Character(12) VARCHAR2(12) NOT NULL Disbursement Fee Amount
    18 SFA_CR_DSB_REB_AMT Character(12) VARCHAR2(12) NOT NULL Disbursement Rebate Amount
    19 SFA_CR_DSB_CONFIRM Character(5) VARCHAR2(5) NOT NULL Disbursement Confirmation
    20 SFA_CR_PMT_PER_DT Character(10) VARCHAR2(10) NOT NULL Payment Period Start Date
    21 SFA_CR_RESPONSE_CD Character(15) VARCHAR2(15) NOT NULL Response Code
    22 SFA_CR_PRV_SEQ_NBR Character(2) VARCHAR2(2) NOT NULL Previous Disbursement Seq Nbr