CSO_USER_ATTRIBUTES

Details

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

Primary Key

Name	Columns
CSO_USER_ATTRIBUTES_PK	PARTY_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PARTY_ID	NUMBER		18	Yes	Fusion apps identifier for this user.
ALIAS	VARCHAR2	100			This is the user alias field for this record.
DATE_ADDED	TIMESTAMP			Yes	This is the date that the record was added to the repository.
DATE_MODIFIED	TIMESTAMP			Yes	This is the date that the record was modified.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
DEFAULT_SUB_SITE_ID	VARCHAR2	32			This is the default View for a user.
LOCALE_ID	VARCHAR2	32			The locale associated with the current record.
LOOKUP_CODE_ID	VARCHAR2	32			Deprecated. Reference to LOOKUP_CODE table. Contains the user preference for format of eMails sent. Valid values are AOL, HTML, and plain text.
OWNER_SITE_ID	VARCHAR2	32			This is the GUID for the repository or view the user belongs to
PDIT_CHALLENGE	VARCHAR2	100			This is the PDIT challenge used in standalone PDIT environments.
OLD_RECORD_ID	VARCHAR2	32			This is the old-style GUID record ID that was associated with this user.
RECEIVE_PERFORM	CHAR	1			Flag indicating if user should receive email notifications for tasks they can perform
RECEIVE_ASSIGNED	CHAR	1			Flag indicating if user should receive email notifications for tasks they have been assigned.
REPUTATION_POINTS	NUMBER				Reputation Points for this user.
USER_LEVEL	VARCHAR2	32			This is the GUID for the reputation model the user belongs to
SUBSCRIPTION_SCHEDULE	NUMBER				The subscription schedule this user is on.
EXTERNAL_ID	NUMBER				This is the comment for the column EXTERNAL_ID.
TYPE_LOOKUP_CODE_ID	VARCHAR2	32			With the introduction of integration users, we want a strongly typed column (lookup code ID) do determine which type the user is (console, web, or integration).
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.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
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
CSO_USER_ATTRIBUTES	cso_site	DEFAULT_SUB_SITE_ID
CSO_USER_ATTRIBUTES	cso_locale	LOCALE_ID
CSO_USER_ATTRIBUTES	cso_lookup_code	LOOKUP_CODE_ID
CSO_USER_ATTRIBUTES	cso_lookup_code	TYPE_LOOKUP_CODE_ID
cso_content_autosave	cso_user_attributes	USER_PARTY_ID
cso_user_key_values	cso_user_attributes	USER_PARTY_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CSO_USER_ATTRIBUTES_N1	Non Unique	Default	LOCALE_ID
CSO_USER_ATTRIBUTES_N2	Non Unique	Default	LOOKUP_CODE_ID
CSO_USER_ATTRIBUTES_N3	Non Unique	Default	DEFAULT_SUB_SITE_ID
CSO_USER_ATTRIBUTES_N5	Non Unique	Default	TYPE_LOOKUP_CODE_ID
CSO_USER_ATTRIBUTES_U1	Unique	Default	PARTY_ID, ORA_SEED_SET1
CSO_USER_ATTRIBUTES_U11	Unique	Default	PARTY_ID, ORA_SEED_SET2