INTFC_EDIT (SQL Table)	Index Back
Interface Edit Interface Edit

INTFC_EDIT

(SQL Table)

Interface Edit

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

2 EDIT_VALUE Character(30) VARCHAR2(30) NOT NULL 8/7/00 - Modified Long and Short Name from Edit Value to Selection Value. This is more meaningful as this field is used to select a particular value for a field from PROJ_RESOURCE.

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

4 EDIT_COUNT Number(12,0) DECIMAL(12) NOT NULL Edit Error Count

5 EDIT_VALUE_NEW Character(30) VARCHAR2(30) NOT NULL New Edit Value

6 UPDATE_STATUS_SW Character(1) VARCHAR2(1) NOT NULL Update Status
Y/N Table Edit

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
2	EDIT_VALUE	Character(30)	VARCHAR2(30) NOT NULL	8/7/00 - Modified Long and Short Name from Edit Value to Selection Value. This is more meaningful as this field is used to select a particular value for a field from PROJ_RESOURCE.
3	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
4	EDIT_COUNT	Number(12,0)	DECIMAL(12) NOT NULL	Edit Error Count
5	EDIT_VALUE_NEW	Character(30)	VARCHAR2(30) NOT NULL	New Edit Value
6	UPDATE_STATUS_SW	Character(1)	VARCHAR2(1) NOT NULL	Update Status Y/N Table Edit