PC_DEL_UTIL_EXC (SQL Table)	Index Back
Proj Delete Exception Record This record will store all exception records from the PC_DEL_UTIL app engine.

PC_DEL_UTIL_EXC

(SQL Table)

Proj Delete Exception Record

This record will store all exception records from the PC_DEL_UTIL app engine.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

4 DTTM_STAMP 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.

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

6 PC_DEL_EXC_OBJ Character(3) VARCHAR2(3) NOT NULL Used in the PC_DEL_UTIL exception record. Used to determine the object causing the exception: Project or Activity.
ACT=Activity
PRJ=Project

7 PC_DEL_EXC_NAME Character(15) VARCHAR2(15) NOT NULL Used in the PC_DEL_UTIL exception record. Used to identify the name of the object causing the exception.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
3	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
4	DTTM_STAMP	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.
5	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
6	PC_DEL_EXC_OBJ	Character(3)	VARCHAR2(3) NOT NULL	Used in the PC_DEL_UTIL exception record. Used to determine the object causing the exception: Project or Activity. ACT=Activity PRJ=Project
7	PC_DEL_EXC_NAME	Character(15)	VARCHAR2(15) NOT NULL	Used in the PC_DEL_UTIL exception record. Used to identify the name of the object causing the exception.