JPM_JP_PROPS

#	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	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	JPM_JP_SECTION_ID	Number(4,0)	SMALLINT NOT NULL	JPM
4	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: JPM_JP_PROPS_VW
5	SYSTEM_DATA_FLG	Character(1)	VARCHAR2(1) NOT NULL	This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA. Y/N Table Edit Default Value: N
6	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.
7	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
8	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.
9	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.
10	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.
11	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
12	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
13	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
14	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
15	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
16	JPM_PRP_DEFAULT	Character(10)	VARCHAR2(10) NOT NULL	Property Default Prompt Table: %EDITTABLE
17	JPM_PRP_DISPLAY	Character(1)	VARCHAR2(1) NOT NULL	Property Display Options D=Display Only E=Editable H=Hidden Default Value: E