EOCC_CONFIG_CRT

(SQL Table)
Index Back

Criteria Definition

Component Configuration Utility Criteria

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PNLGRPNAME Character(18) VARCHAR2(18) NOT NULL Component Name

Prompt Table: PSPNLGRPNAME_VW

2 MARKET Character(3) VARCHAR2(3) NOT NULL Market
3 EOCC_CONFIG_TYPE Character(4) VARCHAR2(4) NOT NULL Configuration type
MASK=Masking
STD=Standard
TRK=Change Tracking

Default Value: STD

4 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
5 EOCC_SEQUENCE_NBR Number(4,0) SMALLINT NOT NULL Sequence Number
6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
7 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
8 PNLFLDID Number(4,0) SMALLINT NOT NULL Page Field ID

Default Value: 1

9 EOCC_CRITERIA_SYM Character(1) VARCHAR2(1) NOT NULL Criteria Symbol
A=Equals
B=Less Than
C=Greater Than
D=Not Greater Than
E=Not Lesser Than
F=Not Equals
G=Contains No Value
H=Contains Value
I=Between
J=Not Between
K=In List
L=Begins With
M=Contains
N=Does not Contain
O=Not in List
10 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
11 EOCC_VALUE_MATCH Character(30) VARCHAR2(30) NOT NULL Value To Match
12 OCCURSLEVEL Number(1,0) SMALLINT NOT NULL Occurs level
13 EOCC_FIELD_TYPE Number(2,0) SMALLINT NOT NULL Field Type
14 EOCC_VALUE_MATCH2 Character(30) VARCHAR2(30) NOT NULL Value To Match
15 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text
16 RECNAME1 Character(15) VARCHAR2(15) NOT NULL Record Name 1
17 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1
18 RECNAME_BASE Character(15) VARCHAR2(15) NOT NULL Base record name
19 PTAI_SYSTEM_DATA Character(1) VARCHAR2(1) NOT NULL Option to mark the AG template as System delivered data.

Default Value: N