SA_REQUEST_DEL(SQL Table) | 
Index Back | 
|---|---|
Request Delivery Method DetailThis table contains additional attributes of the individual report requests, e.g. delivery method. | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Character(9) | VARCHAR2(9) NOT NULL | 
Report Request Nbr
 Default Value: SA_REQUEST_DTL.REPORT_REQUEST_NBR  | 
|
| 2 | 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 |