MSF0P5

The MSF0P5 table holds the actual custom attribute values stored against the object where the custom attribute's PROP_DATA_TYPE is:

B—Boolean
C—Decimal
D—Date
F—File
I—Integer
L—List
P—Timestamp
R—Rich Text
S—String
T—Time
X—Text Area.

Name	Type	Null	Comment
INSTANCE_ID	NUMBER 9	NOT NULL	Unique sequence number.
ENTITY_KEY	VARCHAR2 1000	NOT NULL	Key of the entity associated with the custom attribute: UID link to the custom attribute, where the associated entity has an ID field, for example, CCJOB.ID, or Holds the concatenated business key that make the record unique, where the associated entity does not have an ID field. For example, where the associated entity is CCPRICECAT, then this is a concatenation of PRICE_CAT_CODE + LAB_CODE + ORG_CODE.
ENTITY_TYPE	VARCHAR2 100	NOT NULL	The Service.Service.Object.CustomProperty. For example, CCQCTypeService.CCQCType.RULE.
PROPERTY_VALUE	VARCHAR2 1000		The property value, as a string, maximum 100 characters. Where the custom attribute's PROP_DATA_TYPE is: B—Boolean, then 'true' or 'false' D—Date, then date in the format YYYYMMdd F—File, then ID of the file in EFS L—List, then the value as selected from the list R—Rich Text, then the ID of the MSFRTA record containing the formatted text S—String, then the actual string X—Text Area, then the actual text T—Time, then the time in the format hhmmss All other types, then empty.
PROPERTY_VALUE_NUMERIC	FLOAT		The property value, as a numeric. Where the custom attribute's PROP_DATA_TYPE is: C—Decimal, then the actual value to the defined scale I—Integer, then the actual value All other types, then empty.
PROPERTY_VALUE_TIMESTAMP	TIMESTAMP(6		The property value, as a timestamp. Where the custom attribute's PROP_DATA_TYPE is: P—Timestamp, then the timestamp in the format dd-MMM-YY hh.mm.ss.000000000 AM/PM All other types, then empty.
LAST_MOD_TIME	CHAR 6	NOT NULL
LAST_MOD_USER	VARCHAR2 254	NOT NULL
LAST_MOD_DATE	CHAR 8	NOT NULL
LAST_MOD_EMP	CHAR 254	NOT NULL