JPM_CAT_PROPS

#	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. Prompt Table: JPM_CAT_TYPES
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: JPM_CAT_PRPS_VW
3	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.
4	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
5	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.
6	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.
7	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.
8	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
9	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
10	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
11	FIELDVALUE	Character(4)	VARCHAR2(4) NOT NULL	Field Value
12	JPM_PRP_DEFAULT	Character(10)	VARCHAR2(10) NOT NULL	Property Default Prompt Table: %EDITTABLE
13	JPM_PRP_DISPLAY	Character(1)	VARCHAR2(1) NOT NULL	Property Display Options D=Display Only E=Editable H=Hidden Default Value: E