EOPM_SUPD_TBL (SQL Table)	Index Back
PUM Scrty Automation Tool main PUM Security Automation - Main project table

EOPM_SUPD_TBL

(SQL Table)

PUM Scrty Automation Tool main

PUM Security Automation - Main project table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number

2 PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).

3 EOPM_STATUS Character(1) VARCHAR2(1) NOT NULL set status of PUM security project
1=New
2=Imported
3=Changed
4=Processing
5=Applied
6=Error
7=Tested
Default Value: 1

4 EOPM_STATUS_DT Date(10) DATE status date of PUM security project
Default Value: %date

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PTIASPRPTNO	Number(10,0)	DECIMAL(10) NOT NULL	BUG Number
2	PROJECTNAME	Character(30)	VARCHAR2(30) NOT NULL	Project Name (see PSPROJECTDEFN).
3	EOPM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	set status of PUM security project 1=New 2=Imported 3=Changed 4=Processing 5=Applied 6=Error 7=Tested Default Value: 1
4	EOPM_STATUS_DT	Date(10)	DATE	status date of PUM security project Default Value: %date
5	OBJECTOWNERID	Character(4)	VARCHAR2(4) NOT NULL	Object owner identifier