company_users

NEW

In short

This table contains information about the users associated to a company. It allows to easily retrieve their ids, role and permissions in the data sharing.

This table is suited for incremental ingestion with an ETL tool. For standard data analysis, use schema pennylane.

In Pennylane, it is possible to give access to a company’s data to multiple users. Each user is associated to a role that gives them permissions to access and perform actions on the different modules and features of the application.

This table contains the list of users that have access to a company, as well as their role and their eligibility to use data sharing feature.

Available Columns

user_id

bigint

ID of the user in the Pennylane app. This ID is used to identify the user in the other data models.

company_id

bigint

Unique ID of the company on Pennylane, referring to companies.id.

company_name

character varying

Company's display name on Pennylane. This name may differ from the legal registration name. This name is used for display and search in the application.

user_email

character varying

Email address of the user.

user_first_name

character varying

First name of the user.

user_last_name

character varying

Last name of the user.

user_last_activity

date

Last date of activity of the user on Pennylane. In case a user has never logged in, the value is NULL. In case a user belongs to several companies, the value is the last activity date related to any of the companies.

role

character varying

Role of the user when accessing a company. This role determines the permissions the user has in the data sharing.
Examples: "employee", "internal_accountant", "purchasing_manager"

firm_id

bigint

ID of the accounting firm the company belongs to. When the accounting is managed internally and not by an accounting firm, the value is NULL.

firm_name

character varying

Name of the accounting firm the company belongs to. When the accounting is managed internally and not by an accounting firm, the value is NULL.

eligible_to_data_sharing

boolean

true the user has the right to activate and use the data sharing feature. false the user does not have the right to activate and use the data sharing feature. This is determined by the user's role. The feature must be activated for the user to be able to use it.

created_at

timestamp without time zone

Date and time when the user was created on Pennylane.

updated_at

timestamp without time zone

Date and time when the user was last updated on Pennylane.

synchronised_at

timestamp without time zone

Date and time when the user's information was last synchronised with Pennylane's application.

deleted_at

timestamp without time zone

Date and time when the user was deleted. If the user is not deleted, the value is NULL.