OBJ_M_CATEG
Located in the security domain, this is the main table involved in category management. This table did not exist before versions (4.X) of Business Objects.
This table is updated each time an operation is performed on categories (creation, deletion). When a document is assigned into a category, this table is not involved (the OBJ_M_DOCCATEG table is involved).
Categories can be created by General/Supervisor or by privileged users from Supervisor, Full Client or InfoView.
Name | Null ? | Type | Values |
M_CATEG_N_ID | NOT NULL | int10 | The category Identifier. Each task has a different BATCH_ID. This batchId is unique for each task in a security domain. It is computed from the OBJ_M_MAGICID table. "SELECT M_MAGIC_N_ID FROM OBJ_M_MAGICID WHERE M_MAGIC_C_NAME='CATEGORY'" is the SQL sentence that allows to get the ID of the next category. |
M_CATEG_C_NAME | char(255) | The name of the category. Category names are unique. Categories can be created at the supervisor level or by privileged end-users. | |
M_ACTOR_N_ID | int10 | The ID of the creator of the category (referenced in the OBJ_M_ACTOR table, in the security domain). If the creator is deleted with the supervisor module, then the supervisor (the one who deleted the creator of the category) becomes the owner of the category. A category can only have one creator. | |
M_CATEG_N_LAD | int10 | The date of the last operation which updated this table. See LAD. | |
M_CATEG_N_PARENTID | int10 | The ID of the parent category. Unused in 5.1 and prior versions. May be used in a future version |