PRCSDEFN_MC_VW (SQL View)	Index Back
Process Defn View for Mass Chg View of the prcsdefn. The key and listbox characteristics allow mass change prompting to occur - despite the double key characteristics of the prcsdefnl.

PRCSDEFN_MC_VW

(SQL View)

Process Defn View for Mass Chg

View of the prcsdefn. The key and listbox characteristics allow mass change prompting to occur - despite the double key characteristics of the prcsdefnl.

select prcsname, descr, prcstype from ps_prcsdefn

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PRCSNAME Character(12) VARCHAR2(12) NOT NULL Process Name

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 PRCSTYPE Character(30) VARCHAR2(30) NOT NULL Process Type

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PRCSNAME	Character(12)	VARCHAR2(12) NOT NULL	Process Name
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	PRCSTYPE	Character(30)	VARCHAR2(30) NOT NULL	Process Type