JPM_PRI_N_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_CAT_REQUIRED , PROPS.JPM_JP_DISPLAY , PROPS.JPM_JP_DISP_SUMM , PROPS.JPM_SRCH_FLG 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_NP_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 %EffdtCheck(JPM_JP_PROPS PROPS1, PROPS, %CurrentDateIn) AND %EffdtCheck(JPM_JP_SECTION SECT1, SECT, %CurrentDateIn)

# 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_CAT_REQUIRED Character(1) VARCHAR2(1) NOT NULL Used to indicate that the property, item or relationship must be used.

Y/N Table Edit

7 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

8 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

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

Y/N Table Edit