Proofpoint Security Awareness
Explore the interactive ERD
Table & Field Reference
training_enrollment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
email_address | Unknown | FK |
assignment_creation | Unknown | |
assignment_due_date | Unknown | |
assignment_id | Unknown | |
assignment_name | Unknown | |
assignment_start_date | Unknown | |
assignment_type | Unknown | |
enrollment_removal_date | Unknown | |
enrollment_removal_reason | Unknown | |
is_auto_enroll | Unknown | |
manager_emailaddress | Unknown | |
module_attempt_status | Unknown | |
module_due_date | Unknown | |
module_enrollment_date | Unknown | |
module_id | Unknown | |
module_name_admin | Unknown | |
module_name_user | Unknown | |
user_assignment_completion_date_time | Unknown | |
user_assignment_status | Unknown | |
user_module_completion_date_time | Unknown |
phish_alarm
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
email_address | Unknown | FK |
action | Unknown | |
assessment_soft_deleted_date | Unknown | |
campaign_name | Unknown | |
elapsed_hour | Unknown | |
email_client_version | Unknown | |
emailtype | Unknown | |
id | Unknown | |
os | Unknown | |
received_date | Unknown | |
reported_date | Unknown |
knowledge_assessment
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
email_address | Unknown | FK |
assessment_name | Unknown | |
assessment_status | Unknown | |
assessment_type | Unknown | |
assignment_average_score | Unknown | |
assignment_deleted_date | Unknown | |
assignment_due_date | Unknown | |
assignment_name | Unknown | |
assignment_start_date | Unknown | |
assignment_status | Unknown | |
attempt_date | Unknown | |
category | Unknown | |
category_benchmark_all | Unknown | |
category_benchmark_industry | Unknown | |
company_average_score | Unknown | |
correct | Unknown | |
id | Unknown | |
is_ae_enabled | Unknown | |
is_custom_question | Unknown | |
question_date | Unknown | |
question_id | Unknown | |
question_latency | Unknown | |
question_text | Unknown | |
question_type | Unknown | |
questions_in_category | Unknown | |
seconds_in_attempt | Unknown | |
selected_answer | Unknown | |
user_answered_on_assignment | Unknown | |
user_assignment_status | Unknown | |
user_correcton_assignment | Unknown | |
user_removed_from_assignment | Unknown | |
user_score_on_assignment | Unknown |
phishing_extended
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
email_address | Unknown | FK |
afr | Unknown | |
assessment_is_archived | Unknown | |
auto_enrollment | Unknown | |
browser | Unknown | |
browser_version | Unknown | |
campaign_end_date | Unknown | |
campaign_guid | Unknown | |
campaign_name | Unknown | |
campaign_start_date | Unknown | |
campaign_status | Unknown | |
campaign_type | Unknown | |
event_timestamp | Unknown | |
event_type | Unknown | |
id | Unknown | |
ip_address | Unknown | |
mobile_device_used | Unknown | |
os | Unknown | |
os_version | Unknown | |
sent_timestamp | Unknown | |
template_name | Unknown | |
template_subject | Unknown | |
user_agent | Unknown | |
user_guid | Unknown | |
who_is_city | Unknown | |
who_is_continent | Unknown | |
who_is_country | Unknown | |
who_is_domain | Unknown | |
who_is_isp | Unknown | |
who_is_latitude | Unknown | |
who_is_longitude | Unknown | |
who_is_organization | Unknown | |
who_is_state | Unknown |
users
| Column | Type | Keys |
|---|---|---|
email_address | Unknown | PK |
activeflag | Unknown | |
data_last_updated | Unknown | |
deleted_date | Unknown | |
first_name | Unknown | |
id | Unknown | |
last_name | Unknown | |
locale | Unknown | |
sso_id | Unknown | |
tags | Unknown | |
timezone | Unknown |
phishing
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
email_address | Unknown | FK |
assessment_is_archived | Unknown | |
auto_enrollment | Unknown | |
campaign_end_date | Unknown | |
campaign_name | Unknown | |
campaign_start_date | Unknown | |
campaign_status | Unknown | |
campaign_type | Unknown | |
event_timestamp | Unknown | |
event_type | Unknown | |
id | Unknown | |
sent_timestamp | Unknown | |
template_name | Unknown | |
template_subject | Unknown |
training
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
email_address | Unknown | FK |
assignment_deleted | Unknown | |
assignment_deleted_date | Unknown | |
assignment_due_date | Unknown | |
assignment_method | Unknown | |
assignment_name | Unknown | |
assignment_start_date | Unknown | |
assignment_status | Unknown | |
duration | Unknown | |
force_completed_date | Unknown | |
id | Unknown | |
is_auto_enroll | Unknown | |
is_free_play | Unknown | |
module_attempt_date | Unknown | |
module_attempt_end_status | Unknown | |
module_attempt_score | Unknown | |
module_attempt_score_answered | Unknown | |
module_attempt_score_correct | Unknown | |
module_attempt_status | Unknown | |
module_last_action | Unknown | |
module_name_admin | Unknown | |
module_name_user | Unknown | |
module_type | Unknown | |
seconds_in_module_attempt | Unknown | |
user_assignment_status | Unknown | |
user_removed_from_assignment | Unknown |