WD_REQ_ID_VW (SQL View)	Index Back
Term Withdraw Request ID View

WD_REQ_ID_VW

(SQL View)

Term Withdraw Request ID View

SELECT A.TERM_WD_REQUEST_ID ,A.TERM_WD_REQ_SOURCE ,A.DTTM_STAMP_SEC ,COUNT(*) FROM PS_TERM_WD_REQ_HDR A ,PS_TERM_WD_REQ_DTL B WHERE A.TERM_WD_REQUEST_ID = B.TERM_WD_REQUEST_ID AND A.TERM_WD_REQ_SOURCE='SF' GROUP BY A.TERM_WD_REQUEST_ID ,A.TERM_WD_REQ_SOURCE ,A.DTTM_STAMP_SEC

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TERM_WD_REQUEST_ID Character(10) VARCHAR2(10) NOT NULL Term Withdrawal/Cancellation

2 TERM_WD_REQ_SOURCE Character(3) VARCHAR2(3) NOT NULL Term WD Request Source
SF=Student Financials Batch
WD=SR Withdrawal Panel

3 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

4 TOTAL_STDNT_IN_REQ Number(5,0) INTEGER NOT NULL Total Student in Request

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TERM_WD_REQUEST_ID	Character(10)	VARCHAR2(10) NOT NULL	Term Withdrawal/Cancellation
2	TERM_WD_REQ_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Term WD Request Source SF=Student Financials Batch WD=SR Withdrawal Panel
3	DTTM_STAMP_SEC	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
4	TOTAL_STDNT_IN_REQ	Number(5,0)	INTEGER NOT NULL	Total Student in Request