PROFILES

0 rows


Description

Your organization’s defined profiles

Columns

Column Type Size Nulls Auto Default Children Parents Comments
PROFILE_ID int 4 null
SYSTEM_USER_PROFILES.PROFILE_ID Defined in XML R
SYSTEM_USERS.PROFILE_ID Defined in XML R

The user profile ID

PROFILE_NAME varchar 50 null

The user profile name

ASSIGNED_BY_SYSTEM_ADMIN_ONLY varchar 5 null

Whether this user profile can only be assigned by a system administrator (Yes/No)

SALESFORCE_CONTACT_ROLE_TYPE varchar 10 null

The type of Salesforce access that users with this profile will have (Read Only / Submit / Super User / No Access)

ROW_VERSION binary 8 null

System timestamp (for internal use)

LAST_SYNC_TIME datetime 16,3 (getdate())

Date and time Hub record was last modified

ACTIVE_HUB_PROCESS_ID bigint 8 null

The Hub sync process ID

ORG_ID int 4 null

Your organization’s unique identifier in the Active Net system

Indexes

Constraint Name Type Sort Column(s)
PROFILES_PROFILE_ID_ORG_ID_PK Primary key Asc/Asc PROFILE_ID + ORG_ID
PROFILES_ROW_VERSION_IX Performance Asc ROW_VERSION

Relationships