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