PC_DEL_BUS_OPNS (SQL Table)	Index Back
Project Delete BU Options This record stores the Business Unit level control over the Project Delete process.

PC_DEL_BUS_OPNS

(SQL Table)

Project Delete BU Options

This record stores the Business Unit level control over the Project Delete process.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PC_DEL_TREE_FLG Character(1) VARCHAR2(1) NOT NULL This is a flag to indicate whether deletion of project tree nodes are allowed or not during the Project Delete process.
N=Proj Tree Delete Not Allowed
Y=Allow Project Tree Delete
Default Value: N

3 PC_DEL_SEC_LST_FLG Character(1) VARCHAR2(1) NOT NULL This is a flag to indicate whether rows should be deleted from the security project list tables during the Project Delete process.
N=Sec Proj List Del Not Allowed
Y=Allow Sec Proj List Delete
Default Value: N

4 PC_DEL_RES_FLG Character(1) VARCHAR2(1) NOT NULL This flag will indicate whether it is allowable to delete a Project or Activities if there are resource rows associated with the object(s) being deleted? If set, deleting a Project or Activity will also delete the associated resource rows. If not set, the delete request will not be allowed until the resources have been deleted.
N=No PRJ/ACT delete w/Resources
Y=Allow PRJ/ACT delete w/Resrces

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PC_DEL_TREE_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is a flag to indicate whether deletion of project tree nodes are allowed or not during the Project Delete process. N=Proj Tree Delete Not Allowed Y=Allow Project Tree Delete Default Value: N
3	PC_DEL_SEC_LST_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is a flag to indicate whether rows should be deleted from the security project list tables during the Project Delete process. N=Sec Proj List Del Not Allowed Y=Allow Sec Proj List Delete Default Value: N
4	PC_DEL_RES_FLG	Character(1)	VARCHAR2(1) NOT NULL	This flag will indicate whether it is allowable to delete a Project or Activities if there are resource rows associated with the object(s) being deleted? If set, deleting a Project or Activity will also delete the associated resource rows. If not set, the delete request will not be allowed until the resources have been deleted. N=No PRJ/ACT delete w/Resources Y=Allow PRJ/ACT delete w/Resrces