MSF0P1

The MSP0P1 table holds the properties of a custom attribute and is maintained by the MSECAT—Custom Attribute Types application.

Name Type Null Comment

PROPERTY_ID

 CHAR 200 NOT NULL ID of the Custom Attribute Type
PROPERTY_NAME CHAR 100 NOT NULL Key name of the custom attribute type, for example, STRING_20, DECIMAL_5_2
PROPERTY_DESC VARCHAR2 250 NOT NULL  
PROP_STATUS CHAR 1 NOT NULL A = Active
PROP_ENTITY_TYPE CHAR 100 NOT NULL SERVICE
PROP_MANDATORY CHAR 1 NOT NULL N or ' '.
PROP_PROTECTED CHAR 1 NOT NULL N or ' '.
PROPERTY_OWNER CHAR 1 NOT NULL  
CUST_ATT_FIELD_TY CHAR 100 NOT NULL  
DEFLT_VALUE CHAR 100 NOT NULL The default value.
DISPLAY_LABEL CHAR 20 NOT NULL The default label when the custom attribute is added to a form.
LONG_DSPLY_LABEL VARCHAR2 250 NOT NULL The long display label.
FIELD_TYPE CHAR 5 NOT NULL Ellipse field type, where required.
PROP_DATA_TYPE CHAR 1 NOT NULL

Type of custom attribute:

  • B—Boolean

  • C—Decimal

  • D—Date

  • F—File

  • I—Integer

  • L—List

  • M—Image

  • P—Timestamp

  • R—Rich Text

  • S—String

  • T—Time

  • X—Text Area.
EDIT_MASK VARCHAR2 100 NOT NULL Edit mask.
START_VAL NUMBER 17,6 NOT NULL Starting value of the acceptable range of values for decimal and integer values.
END_VAL NUMBER 17, 6 NOT NULL Ending value of the acceptable range of values for decimal and integer values.
PROP_LENGTH NUMBER 4 NOT NULL The length for string values.
PROP_SCALE NUMBER 2 NOT NULL Scale of an acceptable value for decimal values, for example, 0.
RANGE CHAR 1 NOT NULL  
MULTILINGUAL CHAR 1 NOT NULL N or ' '.
MULTIPLICITY CHAR 4 NOT NULL Indicates whether more than one entry can be made in the field, for example, "Registered, Not Started". N or ' '.
SPECIAL_EDIT CHAR 5 NOT NULL Special editing codes, where required.
VALIDATOR_ID NUMBER 9 NOT NULL ID of the validation service (defined in MSFPV1). 0 if none.
LAST_MOD_DATE CHAR 8 NOT NULL

 
LAST_MOD_TIME CHAR 6 NOT NULL  
LAST_MOD_USER VARCHAR2 254 NOT NULL  
LAST_MOD_EMP CHAR 254 NOT NULL