DR_BUS_EVNT_VW1 (SQL View)	Index Back
Draft Doc Type Events (Bank) Lists draft business events that specify document type defaults by bank.

DR_BUS_EVNT_VW1

(SQL View)

Draft Doc Type Events (Bank)

Lists draft business events that specify document type defaults by bank.

SELECT DRAFT_BUSN_EVENT ,DESCR60 ,DRAFT_DESCR20 FROM PS_DR_BUS_EVNT_TBL WHERE EXISTS ( SELECT 'X' FROM PS_DR_BUS_EVNT_PST WHERE DRAFT_BUSN_EVENT = PS_DR_BUS_EVNT_TBL.DRAFT_BUSN_EVENT AND DRAFT_DOC_TYPE_OPT = 'C')

Related Language Record: DR_BUS_EVT_LVW1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DRAFT_BUSN_EVENT Character(2) VARCHAR2(2) NOT NULL Defines the Draft life cycle event. It represents one of the actions that the PeopleSoft system has provided for Draft processing. Examples are: Approving a Draft Remitting a Draft to the Bank Voiding the Draft.

2 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

3 DRAFT_DESCR20 Character(20) VARCHAR2(20) NOT NULL Description 20 characters, mixed case

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DRAFT_BUSN_EVENT	Character(2)	VARCHAR2(2) NOT NULL	Defines the Draft life cycle event. It represents one of the actions that the PeopleSoft system has provided for Draft processing. Examples are: Approving a Draft Remitting a Draft to the Bank Voiding the Draft.
2	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
3	DRAFT_DESCR20	Character(20)	VARCHAR2(20) NOT NULL	Description 20 characters, mixed case