Setting up User Attribute Master

OFSAAI captures some of the common user attributes such as Address, Designation, Date of Birth, Employee Code and so on. Additionally, if you want to capture user details such as Branch Code or Department Name, you can capture them by configuring User Attribute Master (CSSMS_ATTRIB_MAST) table.

You have to upload the CSSMS_ATTRIB_MAST table after entering the required information on the table. You should have Config Excel Advanced user role mapped to your user group. Note that this role is not available to SYSADMN user.

1. Download the CSSMS_ATTRIB_MAST table. For more information on how to download a table from Config Schema, see Config Schema Download section. You need to select CSSMS_ATTRIB_MAST from the Select the table drop-down list.
2. Open the downloaded file in MS Excel 2003/ 2007. The excel file will have columns ATTRIBUTE_ID, ATTRIBUTE_DESC, ALLOWED_VALUES, and TYPE.
3. Add data as shown in the following table:

   Table 13-19 Details of Attribute ID, Description, Values, and Types

   ATTRIBUTE_ID	ATTRIBUTE_DESC	ALLOWED_VALUES	TYPE
   BRANCH_CODE	Branch Code		0
   BRANCH_NAME	Branch Name	New York, Dallas	1
   DEPT_CODE	Department Code		0
   DEPT_NAME	Department Name		0

   TYPE – Enter Type as 1 if you want to give a list of values from which the user has to select the attribute value. In the ALLOWED_VALUES column, give the required values for the attribute. Enter Type as 0 if the attribute value has to be entered in a text field.
4. Save the file.
5. Upload the modified CSSMS_ATTRIB_MAST table. For more information on how to upload a table to Config Schema, see Config Schema Upload section. Note that you need to select CSSMS_ATTRIB_MAST from the Select the table drop-down list and Upload Type as Complete.
   An appropriate message based on the success or failure status is displayed.