SA_REQUEST_DEL

(SQL Table)
Index Back

Request Delivery Method Detail

This table contains additional attributes of the individual report requests, e.g. delivery method.

  • Parent record: SA_REQUEST_DTL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REPORT_REQUEST_NBR Character(9) VARCHAR2(9) NOT NULL Report Request Nbr

    Default Value: SA_REQUEST_DTL.REPORT_REQUEST_NBR

    2 REQUEST_SEQ_NBR Number(5,0) INTEGER NOT NULL Request Seq Nbr

    Default Value: SA_REQUEST_DTL.REQUEST_SEQ_NBR

    3 SSR_DELIVER_METHOD Character(4) VARCHAR2(4) NOT NULL Official transcript delivery method

    Prompt Table: SSR_DELIVER_TBL

    4 SSR_TSCRPT_AMOUNT Number(11,2) DECIMAL(10,2) NOT NULL Transcript Flat Amount
    5 SSR_DELIVER_CHARGE Number(11,2) DECIMAL(10,2) NOT NULL Delivery method charge/fee for Request Official Transcript
    6 SSR_TSCRPT_SUB_FEE Signed Number(12,2) DECIMAL(10,2) NOT NULL Subtotal amounts for Request Official Transcript fee summary page; on-the-fly field for on-the-fly grid (may be quantity * fee, or delivery charge, or additional fee, or total fee)
    7 SSR_TSCRPT_ADD_FEE Signed Number(12,2) DECIMAL(10,2) NOT NULL Additional charge/fee for Request Official Transcript
    8 SSR_TSCRPT_TOT_FEE Number(11,2) DECIMAL(10,2) NOT NULL Total delivery method charge/fee for Request Official Transcript (quantity * fee + delivery charge + additional fee)
    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    10 SSR_PAYMENT_STATUS Character(1) VARCHAR2(1) NOT NULL Payment Status flag for Request Official Transcript
    R=Received
    U=Unsuccessful
    11 SSR_PAYMENT_DATE Date(10) DATE Payment Date for Request Official Transcript