TERM_WD_SF_VW (SQL View)	Index Back
Term Withdrawal Request Header The Term Withdrawal Request Header table contains general information pertaining to a Term Withdrawal/Cancellation Request.

TERM_WD_SF_VW

(SQL View)

Term Withdrawal Request Header

The Term Withdrawal Request Header table contains general information pertaining to a Term Withdrawal/Cancellation Request.

select a.term_wd_request_id ,a.oprid ,a.term_wd_proc_st ,a.process_instance ,a.term_wd_req_source ,a.dttm_stamp_sec from PS_TERM_WD_REQ_HDR a where a.term_wd_proc_st='P' and a.term_wd_req_source='SF'

# 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID

3 TERM_WD_PROC_ST Character(1) VARCHAR2(1) NOT NULL Term Withdrawal Req Proc Stat
E=Errors found
P=Pending
S=Success
Default Value: P

4 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

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

#	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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Default Value: OPR_DEF_TBL_CS.OPRID
3	TERM_WD_PROC_ST	Character(1)	VARCHAR2(1) NOT NULL	Term Withdrawal Req Proc Stat E=Errors found P=Pending S=Success Default Value: P
4	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
5	TERM_WD_REQ_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Term WD Request Source SF=Student Financials Batch WD=SR Withdrawal Panel Default Value: WD
6	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.