Below you will find a list of all the fields which can be de-identified in your Penelope Sandbox. The exact fields will depend on the type/s of Sandbox your agency has chosen.


In this article

Specialized Masking

Anonymous Service

Blue Book

Case

Document

Billing

Event

Groups

Individual

Informal

Pre-Enrollment

Message

Policy

Referral

Service File

Worker


Important Information

  • Only the fields listed below are being masked. If the field is not listed then the data will remain.

  • Unless otherwise stated, if a field is being masked it will contain the text –masked– regardless of whether or not the field has data in it (i.e. if a field does not have data in it, it is considered null).

  • Some fields are de-identified using a specialized masking value instead of the text –masked–. This is being done so that the data (i.e. phone numbers and addresses) has a more realistic look, even though the data is fake. See Specialized Masking below for a list of field types and fake values to be applied.

  • Attachments are not copied when a Sandbox is created. The list of attachments names will be removed from the database.

  • Custom database tables will not be de-identified.

  • Database Tables with names starting with custom_migration, custom_ind_migration or custom_doc_migration will be dropped.

Specialized Masking

Data Element

Masked Value

Notes

Phone Number

000-000-0000

The value will be formatted according to the agency's default Phone Number Mask.

Extension

000

-

Email

firstname.lastname@example.com

-

URL

https://example.com

-

Address Line 1

123 Main Street

-

Address Line 2

Unit A

-

City

AnyTown

-

County/Suburb

AnyCounty

-

Postal Code

12345

This will be A1A 1A1 if the Canadian Postal Code Masking is turned on.

Date Of Birth

1900-01-01 or 1111-11-11

Set to default date of birth for the agency.

Anonymous Service Fields

Field

Masked Value

Notes

anonymous_service_text_1

--masked--

-

anonymous_service_memo_1

--masked--

-

anonymous_service_memo_2

--masked--

-

Blue Book Fields

Field

Masked Value

Notes

bluebook_lastname

"Bluebook: " + bluebook_id

bluebook_id is the Penelope internal ID for the Blue Book.

bluebook_firstname

--masked--

-

bluebook_role

--masked--

-

bluebook_notes

--masked--

-

bluebook_address_line_1

See Specialized Masking for value.

bluebook_address_line_2

See Specialized Masking for value.

bluebook_city

See Specialized Masking for value.

bluebook_county

See Specialized Masking for value.

bluebook_postal_code

See Specialized Masking for value.

bluebook_after_hours

--masked--

-

bluebook_referral_memo_1

--masked--

-

bluebook_referral_memo_2

--masked--

-

Important Blue Book Information

  • All contact information (phone numbers, emails, etc.) will be masked.

  • Masking will only be applied to Blue Book entries that have an entity type of Individual

Case Fields

Field

Masked Value

Notes

case_file_name

"Case: " + case_id

case_id is the Penelope ID associated with the Case.

case_file_annual_income

0

-

case_file_file_no

--masked--

-

case_intake_note

--masked--

-

case_file_text_1

--masked--

-

case_file_text_2

--masked--

-

case_file_text_3

--masked--

-

case_file_memo_1

--masked--

-

case_file_memo_2

--masked--

-

Document Fields

Field

Masked Value

Notes

other_answer

--masked--

This field will only contain --masked-- if it was not null.

answer_comment

--masked--

This field will only contain --masked-- if it was not null.

answer_text

--masked--

This field will only contain --masked-- if it was not null.

answer_memo

--masked--

This field will only contain --masked-- if it was not null.

document_signed_by

--masked--

-

electronic_signatures

This will be replaced with an image of --masked--.

-

Billing Fields

Field

Masked Value

Notes

bank_account_name

--masked--

-

bank_account_no

--masked--

-

tax_rate_registration_no

--masked--

-

batch_name

"Batch: " + batch_id

batch_id is the Penelope ID associated with the Batch.

debit_note_reference_no

--masked--

-

debit_note_description

--masked--

-

credit_description

--masked--

-

deposit_note

--masked--

-

invoice_bill_to

--masked--

-

invoice_name

--masked--

-

invoice_address_1

See Specialized Masking for value.

invoice_address_2

See Specialized Masking for value.

invoice_city

See Specialized Masking for value.

invoice_county

See Specialized Masking for value.

invoice_postal_code

See Specialized Masking for value.

invoice_properties

--masked--

-

Event Fields

Field

Masked Value

Notes

event_name

"Event: " + event_id

event_id is the Penelope ID associated with the Event.

event_notes

--masked--

-

event_other_location_description

--masked--

-

service_file_event_text_1

--masked--

-

service_file_event_text_2

--masked--

-

service_file_event_memo_1

--masked--

-

service_file_event_memo_2

--masked--

-

Groups Fields

Field

Masked Value

Notes

case_service_group_name

"Group: " + case_service_group_id

case_service_group_id is the Penelope ID associated with the Case Service Group.

case_service_group_notes

--masked--

-

wsextname

--masked--

ClientConnect

wsextdesc

--masked--

ClientConnect

case_service_group_event_notes

--masked--

-

otherlocationdesc

--masked--

-

Individual Fields

Field

Masked Value

Notes

individual_lastname

"Individual: " + kindid

kindid is the Penelope ID associated with the Individual.

individual_firstname

--masked--

-

individual_date_of_birth

See Specialized Masking for value.

individual_notes

--masked--

-

individual_safety_concern_text

--masked--

--masked-- if individual_saftey_concern field is true otherwise it will be left blank.

individual_financial_concern_text

--masked--

--masked-- if individual_saftey_financial field is true otherwise it will be left blank.

individual_nii

--masked--

-

individual_ssn

--masked--

-

individual_address_line_1

See Specialized Masking for value.

individual_address_line_2

See Specialized Masking for value.

individual_address_city

See Specialized Masking for value.

individual_address_county

See Specialized Masking for value.

individual_address_postal_code

See Specialized Masking for value.

individual_text_1

--masked--

-

individual_text_2

--masked--

-

individual_text_3

--masked--

-

individual_text_4

--masked--

-

individual_text_5

--masked--

-

individual_text_6

--masked--

-

individual_text_7

--masked--

-

individual_text_8

--masked--

-

individual_memo_1

--masked--

-

individual_memo_2

--masked--

-

individual_employee_id

--masked--

-

individual_employee

--masked--

-

individual_work_contact

--masked--

-

individual_work_address_1

See Specialized Masking for value.

individual_work_address_2

See Specialized Masking for value.

individual_work_address_city

See Specialized Masking for value.

individual_work_address_postal_code

See Specialized Masking for value.

individual_work_url

See Specialized Masking for value.

individual_work_comments

--masked--

-

individual_additional_address_line_1

See Specialized Masking for value.

individual_additional_address_line_2

See Specialized Masking for value.

individual_additional_address_city

See Specialized Masking for value.

individual_additional_address_county

See Specialized Masking for value.

individual_additional_address_postal_code

See Specialized Masking for value.

individual_additional_address_comment

--masked--

-

Important Individual Information

  • All Individual contact information (phone numbers, emails etc) will be de-Identified.

  • All Individual identifiers will be removed.

  • All Individual Credit Card information will be removed including Credit Card Payment History

Informal Series Field

Field

Masked Value

Notes

informal_series_name

"Informal Series: + " informal_series_id

informal_series_id is the Penelope internal ID for the Informal Series.

Pre-Enrollment Fields

Field

Masked Value

Notes

preenrollment_notes

--masked--

-

preenrollment_closing_notes

--masked--

-

Message Fields

Field

Masked Value

Notes

message_subject

"Thread: " + thread_id

thread_id is the Penelope internal ID for the Message Subject.

message_message

--masked--

-

Policy Fields

Field

Masked Value

Notes

policy_name

"Policy: " + policy_id

-policy_id is the Penelope internal ID for the Policy.

policy_number

--masked--

-

policy_notes

--masked--

-

policy_coverage_authorization

--masked--

-

policy_coverage_notes

--masked--

-

policy_individual_member_no

--masked--

-

policy_individual_group_no

--masked--

-

policy_individual_notes

--masked--

-

Referral Fields

Field

Masked Value

Notes

referral_client_needs

--masked--

-

referral_client_instructions

--masked--

-

referral_note_title

"Referral Note " + referral_note_id

referral_note_id is the Penelope internal ID for the Policy.

referral_note

--masked--

-

Service File Fields

Field

Masked Value

Notes

service_file_text_1

--masked--

-

service_file_text_2

--masked--

-

service_file_memo_1

--masked--

-

service_file_memo_2

--masked--

-

service_file_close_notes

--masked--

-

service_file_note_title

Service File Note + service_file_note_id

-

service_file_note

--masked--

-

referring_physician_identification

--masked--

Service File CMS - Referring Physician

funder_specific_pin_number

--masked--

Service File CMS - Funder Specific

funder_specific_group_number

--masked--

Service File CMS - Funder Specific

funder_specific_box24k

--masked--

Service File CMS - Funder Specific

funder_specific_box19

--masked--

Service File CMS - Funder Specific

funder_specific_box10d

--masked--

Service File CMS - Funder Specific

Worker Fields

Field

Masked Value

Notes

worker_phone_1

--masked--

-

worker_phone_2

--masked--

-

worker_extension

--masked--

-

worker_email

--masked--

-

worker_address_1

--masked--

-

worker_address_2

--masked--

-

worker_city

--masked--

-

worker_postal_code

--masked--

-

worker_ssn

--masked--

-

worker_employee_id_number

--masked--

-

worker_national_provider_number

--masked--

-

worker_medicare_number

--masked--

-

worker_tax_number

--masked--

-

worker_registration_number

--masked--

-

worker_fahcsia_number

--masked--

-

Important Worker Information

  • Worker Names will not be De-Identified.

  • Worker message settings will not be de-identified.

  • All worker identifiers will be removed with the exception of Single Sign-On information.

  • All worker PINS will be removed.

Did this answer your question?