LED_INQ_CF

(SQL Table)
 Index Back

Inquiry Criteria - ChartFields

  • Parent record: LED_INQ_CRIT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: LED_INQ_CRIT.OPRID

    2 SAVED_SEARCH Character(30) VARCHAR2(30) NOT NULL Saved Search Name

    Default Value: LED_INQ_CRIT.SAVED_SEARCH

    3 INQUIRY_TYPE Character(1) VARCHAR2(1) NOT NULL Inquiry Type specifies Saved Search or Personalization to distinguish the type of search crieria.
    P=Personalization
    S=Saved Search

    Default Value: P

    4 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField

    Prompt Table: CFS_LED_LBL_VW2

    5 CHARTFIELD_VALUE Character(30) VARCHAR2(30) NOT NULL ChartField Value

    Prompt Table: %EDITTABLE

    6 CFV_SET Character(20) VARCHAR2(20) NOT NULL ChartField Value Set

    Prompt Table: CFV_SET_INQ_VW2

    7 SUM_BY_SW Character(1) VARCHAR2(1) NOT NULL Sum By

    Y/N Table Edit

    Default Value: N

    8 VALUE_REQUIRED Character(1) VARCHAR2(1) NOT NULL Value Required
    N=Not Required
    O=Optional
    Y=Required

    Y/N Table Edit

    Default Value: N

    9 ORDERBYNUM Number(3,0) SMALLINT NOT NULL Order-By Number