JPM_JP_PROPS_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 , 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 , LST.EFFDT , LST.JPM_KEY_RECNAME , CAT.DESCR FROM PS_JPM_JP_TYPES TYPES , PS_JPM_JP_PROPS PROPS , PS_JPM_JP_SECTION SECT , PS_JPM_C_LIST_DEFN LST , PS_JPM_CAT_TYPES CAT WHERE %EffdtCheck(JPM_JP_TYPES TYPES1, TYPES, %CurrentDateIn) AND SECT.JPM_JP_TYPE = TYPES.JPM_JP_TYPE AND SECT.EFFDT = TYPES.EFFDT AND CAT.JPM_CAT_TYPE = SECT.JPM_CAT_TYPE AND PROPS.JPM_JP_TYPE = SECT.JPM_JP_TYPE AND PROPS.EFFDT = SECT.EFFDT AND PROPS.JPM_JP_SECTION_ID = SECT.JPM_JP_SECTION_ID AND PROPS.JPM_C_LIST_ID = LST.JPM_C_LIST_ID AND %EffdtCheck(JPM_C_LIST_DEFN LST1, LST, %CurrentDateIn) UNION SELECT PROPS.JPM_JP_TYPE , SECT.JPM_CAT_TYPE , PROPS.FIELDNAME , 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 , %DateNull , ' ' , CAT.DESCR FROM PS_JPM_JP_TYPES TYPES , PS_JPM_JP_SECTION SECT , PS_JPM_JP_PROPS PROPS , PS_JPM_CAT_TYPES CAT WHERE %EffdtCheck(JPM_JP_TYPES TYPES1, TYPES, %CurrentDateIn) AND SECT.JPM_JP_TYPE = TYPES.JPM_JP_TYPE AND SECT.EFFDT = TYPES.EFFDT AND CAT.JPM_CAT_TYPE = SECT.JPM_CAT_TYPE AND PROPS.JPM_JP_TYPE = SECT.JPM_JP_TYPE AND PROPS.EFFDT = SECT.EFFDT AND PROPS.JPM_JP_SECTION_ID = SECT.JPM_JP_SECTION_ID AND PROPS.JPM_C_LIST_ID = ' '

  • Related Language Record: JPM_JP_PROPS_LI

    • # 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 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.
    5 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

    6 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.
    7 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.
    8 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.
    9 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

    10 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

    11 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

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

    Y/N Table Edit

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

    Prompt Table: %EDITTABLE

    14 JPM_PRP_DISPLAY Character(1) VARCHAR2(1) NOT NULL Property Display Options
    D=Display Only
    E=Editable
    H=Hidden
    15 JPM_C_LIST_ID Character(18) VARCHAR2(18) NOT NULL JPM Custom prompt list id
    16 JPM_CLIST_EFFDT Date(10) DATE Custom List Effdt
    17 JPM_KEY_RECNAME Character(15) VARCHAR2(15) NOT NULL JPM - Record Name
    18 JPM_CONTENT_DESCR Character(30) VARCHAR2(30) NOT NULL Content Description