JPM_PRI_P_PRP_I

(SQL View)
 Index Back

Properties for Primary Person

Interface View for Property Configuration for each Content Section / Content Type in the Primary Person Profile Type

SELECT PROPS.JPM_JP_TYPE , SECT.JPM_CAT_TYPE , PROPS.FIELDNAME , FLDSEQ.FIELDNUM , PROPS.JPM_LABEL_TEXT , PROPS.JPM_KEY_FLG , PROPS.JPM_CAT_MIN_VALUE , PROPS.JPM_CAT_MAX_VALUE , PROPS.JPM_CAT_MAX_LENGTH , PROPS.JPM_CAT_REQUIRED , PROPS.JPM_JP_DISPLAY , PROPS.JPM_JP_DISP_SUMM , PROPS.JPM_SRCH_FLG , PROPS.JPM_PRP_DEFAULT , PROPS.JPM_PRP_DISPLAY , PROPS.JPM_C_LIST_ID FROM PS_JPM_JP_PROPS PROPS , PS_JPM_JP_SECTION SECT , PS_JPM_PROPSEQ_VW FLDSEQ , PS_JPM_JP_PRI_TYPE JPMCFG WHERE PROPS.JPM_JP_TYPE = JPMCFG.JPM_PRI_PERS_TYPE AND PROPS.JPM_JP_TYPE = SECT.JPM_JP_TYPE AND PROPS.JPM_JP_SECTION_ID = SECT.JPM_JP_SECTION_ID AND FLDSEQ.FIELDNAME = PROPS.FIELDNAME AND PROPS.EFFDT = SECT.EFFDT AND %EffdtCheck(JPM_JP_TYPES TYPES, SECT, %CurrentDateIn)

  • Related Language Record: JPM_PRI_P_PRPLI

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JPM_JP_TYPE Character(12) VARCHAR2(12) NOT NULL Profile Type name for a JPM Profile Type
    2 JPM_CAT_TYPE Character(12) VARCHAR2(12) NOT NULL The name of the type of items that will be used in a Catalog and or in a Profile.
    3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    4 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    5 JPM_LABEL_TEXT Character(30) VARCHAR2(30) NOT NULL User defined text to be displayed as a label for a field or property within JPM User Interfaces.
    6 JPM_KEY_FLG Character(1) VARCHAR2(1) NOT NULL Indicates if this JPM Profile or Catalog property is to be considered a key on the Profile or Catalog Item.

    Y/N Table Edit

    Default Value: N

    7 JPM_CAT_MIN_VALUE Number(10,2) DECIMAL(9,2) NOT NULL Specifies the minimum value a property in a Catalog Item or Profile Item may be.
    8 JPM_CAT_MAX_VALUE Number(10,2) DECIMAL(9,2) NOT NULL Specifies the maximum value a property in a Catalog Item or Profile Item may be.
    9 JPM_CAT_MAX_LENGTH Number(4,0) SMALLINT NOT NULL Specifies the maximum length in characters that a property value in a Catalog Item or Profile Item may be.
    10 JPM_CAT_REQUIRED Character(1) VARCHAR2(1) NOT NULL Used to indicate that the property, item or relationship must be used.

    Y/N Table Edit

    11 JPM_JP_DISPLAY Character(1) VARCHAR2(1) NOT NULL Flag to indicate whether a JPM profile item field should be displayed on the profile item detail page

    Y/N Table Edit

    12 JPM_JP_DISP_SUMM Character(1) VARCHAR2(1) NOT NULL Flag to indicate if field is to be shown on the JPM Profile content summary grid

    Y/N Table Edit

    13 JPM_JP_SRCH_FLG Character(1) VARCHAR2(1) NOT NULL Can be Searched (Search/Match)

    Y/N Table Edit

    14 JPM_PRP_DEFAULT Character(10) VARCHAR2(10) NOT NULL Property Default

    Prompt Table: %EDITTABLE

    15 JPM_PRP_DISPLAY Character(1) VARCHAR2(1) NOT NULL Property Display Options
    D=Display Only
    E=Editable
    H=Hidden

    Default Value: E

    16 JPM_C_LIST_ID Character(18) VARCHAR2(18) NOT NULL JPM Custom prompt list id