EODU_CRITERIA (SQL Table)	Index Back
Sample Data Match Criteria Logical conditions to filter sample data

EODU_CRITERIA

(SQL Table)

Sample Data Match Criteria

Logical conditions to filter sample data

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EODU_APPL_GRP Character(15) VARCHAR2(15) NOT NULL A group of records that make up an Application Group for processing sample data dates.

2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

4 EODU_AND_OR_OPER Character(1) VARCHAR2(1) NOT NULL Operator
1=AND
2=OR
Default Value: 1

5 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: EODU_REC_FLD_VW

6 EODU_LOGIC_OPR Character(1) VARCHAR2(1) NOT NULL Logic Operator
1=LIKE
2=NOT LIKE
3==
4=>
5=<
6=<>
7=>=
8=<=
9=IN
Default Value: 3

7 EODU_MATCH_VALUE Character(100) VARCHAR2(100) NOT NULL Value to Match

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EODU_APPL_GRP	Character(15)	VARCHAR2(15) NOT NULL	A group of records that make up an Application Group for processing sample data dates.
2	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
3	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
4	EODU_AND_OR_OPER	Character(1)	VARCHAR2(1) NOT NULL	Operator 1=AND 2=OR Default Value: 1
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: EODU_REC_FLD_VW
6	EODU_LOGIC_OPR	Character(1)	VARCHAR2(1) NOT NULL	Logic Operator 1=LIKE 2=NOT LIKE 3== 4=> 5=< 6=<> 7=>= 8=<= 9=IN Default Value: 3
7	EODU_MATCH_VALUE	Character(100)	VARCHAR2(100) NOT NULL	Value to Match