SVC_MCA_TOKEN

Details

Schema: FUSION
Object owner: FUSION
Object type: TABLE
Tablespace: REFERENCE

Primary Key

Name	Columns
SVC_MCA_TOKEN_PK	TOKEN_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
TOKEN_ID	NUMBER		18	Yes	Auto-generated number and primary key for this table.
TOKEN_CODE	VARCHAR2	64		Yes	Name of the token code displayed for this token.
NAME	VARCHAR2	64		Yes	A unique identifier that is a user friendly name for the token.	Active
ALT_ATTRIBUTE_NAME	VARCHAR2	64			Alternate attribute name for use in redwood implementation.	Active
DESCRIPTION	VARCHAR2	240		Yes	This is the user friendly name of the Token displayed to the user on the UI
CUSTOM_ATTR_FLAG	VARCHAR2	1		Yes	Indicates this is a custom attribute token
ENTITY_ID	NUMBER		18		This is the foreign key to the Business Object Entity
ENTITY_ATTRIBUTE_NAME	VARCHAR2	64			This is the name of the Entity Attribute from the Business Object Entity referenced by the ENTITY_ID
MAPPING_CODE	VARCHAR2	20		Yes	This will be mapped to the FND_LOOKUP_TYPE = ORA_SVC_MCA_MAPPING_CODE_CD
TOKEN_KEY_TYPE_CD	VARCHAR2	30			The token key type mapping to the lookup type 'ORA_SVC_TOKEN_KEY_TYPE_CD'.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that 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.	Active
DELETED_FLAG	VARCHAR2	1		Yes	Indicates whether the category is logically deleted (Y or N).	Active
SEED_DATA_SOURCE	VARCHAR2	512			Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
ORA_SEED_SET1	VARCHAR2	1		Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2	VARCHAR2	1		Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Foreign Keys

Table	Foreign Table	Foreign Key Column
SVC_MCA_TOKEN	svc_mca_bo_entity	ENTITY_ID
svc_mca_token_refs	svc_mca_token	TOKEN_ID
svc_bo_to_uwo_attrs	svc_mca_token	TOKEN_ID
svc_mca_param	svc_mca_token	TOKEN_ID
svc_mca_nav_action	svc_mca_token	TITLE_TOKEN_ID
svc_mca_entity_criteria	svc_mca_token	VALUE_START
svc_mca_entity_criteria	svc_mca_token	VALUE_END

Indexes

Index	Uniqueness	Tablespace	Columns	Status
SVC_MCA_TOKEN_N1	Non Unique	Default	ENTITY_ID
SVC_MCA_TOKEN_PK	Unique	Default	TOKEN_ID, ORA_SEED_SET1	Active
SVC_MCA_TOKEN_PK1	Unique	Default	TOKEN_ID, ORA_SEED_SET2
SVC_MCA_TOKEN_U1	Unique	Default	NAME, ORA_SEED_SET1
SVC_MCA_TOKEN_U11	Unique	Default	NAME, ORA_SEED_SET2
SVC_MCA_TOKEN_U2	Unique	Default	TOKEN_CODE, ORA_SEED_SET1
SVC_MCA_TOKEN_U21	Unique	Default	TOKEN_CODE, ORA_SEED_SET2