EONC_PROC_VW (SQL View)	Index Back
Business Process View Business Process setup view.

EONC_PROC_VW

(SQL View)

Business Process View

Business Process setup view.

SELECT EONC_PROCESS_NAME , EONC_PROC_DESCR , OBJECTOWNERID , DATA_TYPE_CD , LASTUPDOPRID , LASTUPDDTTM FROM PS_EONC_PROC_TBL

Related Language Record: EONC_PROC_LW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EONC_PROCESS_NAME Character(50) VARCHAR2(50) NOT NULL Business Process Name

2 EONC_PROC_DESCR Character(100) VARCHAR2(100) NOT NULL Business Process Description

3 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier

4 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
N=Customer Data
S=Sample Data
Y=System Data
Default Value: N

5 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

6 LASTUPDDTTM 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	EONC_PROCESS_NAME	Character(50)	VARCHAR2(50) NOT NULL	Business Process Name
2	EONC_PROC_DESCR	Character(100)	VARCHAR2(100) NOT NULL	Business Process Description
3	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier
4	DATA_TYPE_CD	Character(1)	VARCHAR2(1) NOT NULL	Data Type Code N=Customer Data S=Sample Data Y=System Data Default Value: N
5	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
6	LASTUPDDTTM	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.