FCM_ATTRIBUTES
This table stores the custom attributes defined by the administrator.
Details
Object type: TABLE
Primary Key
| Name | Columns |
|---|---|
|
FCM_ATTRIBUTES_PK |
ATTRIBUTE_ID |
Columns
| Name | Data Type | Length | Precision | Scale | Null Allowed | Comments |
|---|---|---|---|---|---|---|
|
ATTRIBUTE_ID |
NUMBER |
18 |
0 |
No |
Unique ID |
|
|
APP_ID |
NUMBER |
1 |
0 |
No |
The Application ID |
|
|
DELETED |
VARCHAR2 |
1 |
No |
Y=Yes N=No |
||
|
ATTRIBUTE_NAME |
VARCHAR2 |
765 |
No |
Attribute display name |
||
|
ATTRIBUTE_TYPE |
VARCHAR2 |
25 |
No |
Possible values are BOOLEAN, DATE, NUMBER, LIST, TEXT. |
||
|
ORDER_SEQ |
NUMBER |
0 |
Yes |
The order of the attributes in account segments and component segments. |
||
|
USED_FOR |
VARCHAR2 |
10 |
No |
Denotes which view type an attribute is used for User, Account Segment or Segments. Possible values are USER, ACCTSEG, SEGMENT or SYSTEM. |
||
|
NEGATIVE_NUMBER_FORMAT |
VARCHAR2 |
15 |
Yes |
If the Custom Attribute is NUMBER type, this is the display format to be used for negative numbers. |
||
|
SCALE |
VARCHAR2 |
15 |
Yes |
If the Custom Attribute is NUMBER type, this is the SCALE for the display format. |
||
|
THOUSANDS_SEPARATOR_FLAG |
VARCHAR2 |
1 |
Yes |
If the Custom Attribute is NUMBER type, this is the character to be used for thousands separator |
||
|
DECIMAL_PLACES |
NUMBER |
2 |
0 |
Yes |
If the Custom Attribute is NUMBER type, this is the # of decimal places used for the display format. |
|
|
CURRENCY_SYMBOL |
VARCHAR2 |
255 |
Yes |
If the Custom Attribute is NUMBER type, this is the currency symbol used for the display format. |
||
|
PERCENTAGE |
VARCHAR2 |
1 |
No |
Denotes whether attribute is to be displayed as a percentage. |
||
|
TEXT_LINES |
NUMBER |
0 |
Yes |
Number of lines for a multi-line text attribute. |
||
|
INCLUDE_ATTACHMENTS |
VARCHAR2 |
1 |
No |
Y=Yes to include attachments (used only for multi-line text attributes). |
||
|
IS_CALCULATION |
VARCHAR2 |
1 |
Yes |
Y=Yes, N=No to indicate whether the attribute is a calculation |
||
|
CALCULATION_ID |
NUMBER |
18 |
0 |
Yes |
The ID of the calculation in FCM_CALCULATIONS table. |
|
|
ATTRIBUTE_SOURCE |
VARCHAR2 |
30 |
Yes |
The source of the calculation, for instance, R for reconciliation, T for transaction. |
||
|
DISPLAY_TO_USER |
VARCHAR2 |
1 |
Yes |
Y=Yes, N=No to indicate whether the attribute should be displayed to user of hidden. |
||
|
OBJECT_VERSION_NUMBER |
NUMBER |
No |
Used to implement optimistic locking. This number is incremented every time the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. |
|||
|
LAST_UPDATE_LOGIN |
NUMBER |
Yes |
Who column. Stores the ID of the user who last updated this row. |
|||
|
LAST_UPDATE_DATE |
DATE |
No |
Who column. Stores the date when this row was last updated. |
|||
|
LAST_UPDATED_BY |
VARCHAR2 |
255 |
No |
Who column. Stores the ID of the user who last updated this row. |
||
|
CREATION_DATE |
DATE |
No |
Who column. Stores the date when this row was created in the database. |
|||
|
CREATED_BY |
VARCHAR2 |
255 |
No |
Who column. Stores the ID of the user who created this row. |
||
|
SUB_SEGMENT |
VARCHAR2 |
1 |
Yes |
Whether the attribute is a sub segment profile segment. |
||
|
TARGET_DIM |
VARCHAR2 |
5 |
Yes |
The target dimension in DM |
||
|
HAS_DND_ACCESS |
VARCHAR2 |
1 |
Yes |
Whether attribute is used in Do Not Display access. |
||
|
TOTALING_METHOD |
VARCHAR2 |
20 |
Yes |
The totaling method of the attribute, if numeric |
||
|
RECON_DASHBOARD_TABLE |
VARCHAR2 |
32 |
Yes |
The table name of the attribute where reconciliation values are stored, for instance ARM_RECON_ATTRIBUTES_1. |
||
|
TRANS_DASHBOARD_TABLE |
VARCHAR2 |
32 |
Yes |
The table name of the attribute where transaction values are stored, for instance ARM_TRANS_ATTRIBUTES_1. |
||
|
DASHBOARD_COLUMN |
VARCHAR2 |
32 |
Yes |
The column name in the recon/ transaction table for the attribute |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
|
FCM_ATTRIBUTES_N1 |
NONUNIQUE |
APP_ID, USED_FOR |
|
FCM_ATTRIBUTES_PK |
UNIQUE |
ATTRIBUTE_ID |