SSR_RQST_DETDEL (SQL View)	Index Back
Request Delivery Method Detail This table contains additional attributes of the individual report requests, e.g. delivery method.

SSR_RQST_DETDEL

(SQL View)

Request Delivery Method Detail

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

SELECT B.REPORT_REQUEST_NBR , B.REQUEST_SEQ_NBR , A.EMPLID , B.SSR_DELIVER_METHOD , A.NUMBER_OF_COPIES , B.SSR_TSCRPT_AMOUNT , B.SSR_DELIVER_CHARGE , B.SSR_TSCRPT_SUB_FEE , B.SSR_TSCRPT_ADD_FEE , B.SSR_TSCRPT_TOT_FEE , B.CURRENCY_CD FROM %Table(SA_REQUEST_DTL) A , %Table(SA_REQUEST_DEL) B WHERE A.REPORT_REQUEST_NBR = B.REPORT_REQUEST_NBR AND A.REQUEST_SEQ_NBR = B.REQUEST_SEQ_NBR

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

4 SSR_DELIVER_METHOD Character(4) VARCHAR2(4) NOT NULL Official transcript delivery method
Prompt Table: SSR_DELIVER_TBL

5 NUMBER_OF_COPIES Number(2,0) SMALLINT NOT NULL Number of Copies

6 SSR_TSCRPT_AMOUNT Number(11,2) DECIMAL(10,2) NOT NULL Transcript Flat Amount

7 SSR_DELIVER_CHARGE Number(11,2) DECIMAL(10,2) NOT NULL Delivery method charge/fee for Request Official Transcript

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

9 SSR_TSCRPT_ADD_FEE Signed Number(12,2) DECIMAL(10,2) NOT NULL Additional charge/fee for Request Official Transcript

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

11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	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	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	SSR_DELIVER_METHOD	Character(4)	VARCHAR2(4) NOT NULL	Official transcript delivery method Prompt Table: SSR_DELIVER_TBL
5	NUMBER_OF_COPIES	Number(2,0)	SMALLINT NOT NULL	Number of Copies
6	SSR_TSCRPT_AMOUNT	Number(11,2)	DECIMAL(10,2) NOT NULL	Transcript Flat Amount
7	SSR_DELIVER_CHARGE	Number(11,2)	DECIMAL(10,2) NOT NULL	Delivery method charge/fee for Request Official Transcript
8	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)
9	SSR_TSCRPT_ADD_FEE	Signed Number(12,2)	DECIMAL(10,2) NOT NULL	Additional charge/fee for Request Official Transcript
10	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)
11	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code