EO_DSSECRULES

(SQL Table)
 Index Back

Directory Interface

Directory Interface

  • Related Language Record: EO_DSSECRLS_LNG

  • Parent record: DSCONTDEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DSSRCHID Character(50) VARCHAR2(50) NOT NULL Directory Search Name

    Prompt Table: DSCONTDEFN

    2 DS_ARITH_SEQ Number(3,0) SMALLINT NOT NULL Sequence

    Default Value: 0

    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: EO_DSRECFLD_VW

    5 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
    6 DS_NEGATE Character(1) VARCHAR2(1) NOT NULL NEGATE
    F=Negate
    T=Do not negate

    Default Value: F

    7 DS_ENTRY_BOOL_OPR Character(3) VARCHAR2(3) NOT NULL AND\OR
    AND=AND
    OR=OR
    8 DSBOOLEAN_OPERATOR Character(1) VARCHAR2(1) NOT NULL Boolean Operator
    0=AND
    1=OR
    9 LEFT_BRACKET Character(1) VARCHAR2(1) NOT NULL Left Bracket
    N=NO
    Y=YES

    Y/N Table Edit

    Default Value: N

    10 RIGHT_BRACKET Character(1) VARCHAR2(1) NOT NULL Right Bracket
    N=NO
    Y=YES

    Y/N Table Edit

    Default Value: N

    11 DSSECVALUE Character(50) VARCHAR2(50) NOT NULL Rule value