JPM_JPCATPRP_VW(SQL View) |
Index Back |
|---|---|
Profile Type/Cat Type PropsProfile Type Properties by Cat Type |
| SELECT A.JPM_CAT_TYPE , B.JPM_JP_TYPE , B.FIELDNAME , B.JPM_LABEL_TEXT , B.JPM_KEY_FLG , B.JPM_CAT_MIN_VALUE , B.JPM_CAT_MAX_VALUE , B.JPM_CAT_MAX_LENGTH , B.JPM_CAT_REQUIRED , B.JPM_JP_DISPLAY , B.JPM_JP_DISP_SUMM , B.JPM_SRCH_FLG , B.JPM_JP_PROP_SRC , B.JPM_PRP_DEFAULT , B.JPM_PRP_DISPLAY , A.JPM_JP_QUAL_SET , A.JPM_JP_QUAL_SET2 FROM PS_JPM_JP_SECTION A , PS_JPM_JP_PROPS B WHERE %EffdtCheck(JPM_JP_SECTION A1, A, %CurrentDateIn) AND B.JPM_JP_TYPE = A.JPM_JP_TYPE AND B.EFFDT = A.EFFDT AND B.JPM_JP_SECTION_ID = A.JPM_JP_SECTION_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  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. |
| 2 | JPM_JP_TYPE |
Character(12) | VARCHAR2(12) NOT NULL | Profile Type name for a JPM Profile Type |
| 3 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: JPM_JP_PROPS_VW |
| 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 Default Value: N |
| 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 Default Value: N |
| 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 Default Value: Y |
| 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 Default Value: N |
| 12 | JPM_SRCH_FLG | Character(1) | VARCHAR2(1) NOT NULL |
When ON indicates that the item, object or property is used during Search/Match processing.
Y/N Table Edit Default Value: N |
| 13 | JPM_JP_PROP_SRC | Character(1) | VARCHAR2(1) NOT NULL |
Indicates the source of a JPM catalog property
C=Catalog P=Profile Default Value: P |
| 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_JP_QUAL_SET | Character(12) | VARCHAR2(12) NOT NULL | 1st Instance Qualifier Set Name for a JPM Profile Item |
| 17 | JPM_JP_QUAL_SET2 | Character(12) | VARCHAR2(12) NOT NULL | 2nd Instance Qualifier Set Name for a JPM Profile Item |