EQRY_DEF

(SQL Table)
 Index Back

Named eQuery Criteria

Named eQuery Criteria

  • Related Language Record: EQRY_DEF_LNG

  • Parent Record Of EQRY_CRITERIA EQRY_PART_CRIT EQRY_PART_DEF

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EQRY_NAME Character(20) VARCHAR2(20) NOT NULL Query Name
    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 EQRY_ORIG_CLASSID Character(12) VARCHAR2(12) NOT NULL Target class ID when query was saved
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 PRIVATE_QUERY_FLAG Character(1) VARCHAR2(1) NOT NULL Yes/No Flag to indicate if its a private query

    Default Value: Y

    6 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.

    Y/N Table Edit