DSSECFILTER

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DSSRCHID Character(50) VARCHAR2(50) NOT NULL Directory Search Name
2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
3 LEFT_BRACKET Character(1) VARCHAR2(1) NOT NULL LEFT_BRACKET
N=NO
Y=YES
4 RIGHT_BRACKET Character(1) VARCHAR2(1) NOT NULL RIGHT_BRACKET
N=NO
Y=YES
5 DSATTR Character(50) VARCHAR2(50) NOT NULL Attribute Value
6 DSNAMEAT Character(100) VARCHAR2(100) NOT NULL LDAP Attribute Name

Prompt Table: DSATTRIB_VW

7 DSSRCHFILTER Character(254) VARCHAR2(254) NOT NULL Directory Search Filter
8 OPERATION Character(3) VARCHAR2(3) NOT NULL Arithmetic Operation
<=Less Than
<==Less Than or Equal To
<>=Not Equal To
==Equal To
>=Greater Than
>==Greater Than or Equal To
9 BOOLEAN_OPERATOR2 Character(1) VARCHAR2(1) NOT NULL Boolean Operator
0=AND
1=OR
2=NoOp
3=END