Credentialing Workflows Export
Data dictionary for the practitioner credentialing-workflows Excel export. Every column produced by the export, grouped by the Excel tab (section) it appears on. All unnested tabs carry workflow_id and entity_npi as join keys back to Main_Workflow_Data.
Schema
29 tabs317 fields
Main_Workflow_Data 40 fields
| Field | Type | Description |
|---|---|---|
| organization_name | STRING | Name of the client tenant/organization the workflow belongs to (e.g. a health plan name). |
| entity_npi | STRING | Practitioner's National Provider Identifier. Join key used across every other tab. |
| practitioner_prefix | STRING | Practitioner's name prefix/title (e.g. Dr.). |
| practitioner_first_name | STRING | Practitioner's first name. |
| practitioner_middle_name | STRING | Practitioner's middle name. |
| practitioner_last_name | STRING | Practitioner's last name. |
| practitioner_suffix | STRING | Practitioner's name suffix (e.g. Jr., MD). |
| entity_full_name | STRING | First, middle, and last name concatenated with spaces (blank parts omitted). |
| practitioner_external_id | STRING | External/client-supplied identifier for the practitioner. |
| practitioner_primary_email | STRING | Practitioner's primary email address. |
| practitioner_gender | STRING | Practitioner's recorded gender. |
| practitioner_race | STRING | Practitioner's recorded race. |
| practitioner_ethnicity | STRING | Practitioner's recorded ethnicity. |
| practitioner_is_deceased | BOOLEAN | Whether the practitioner is recorded as deceased. |
| practitioner_deceased_date | DATE | Date of death, if recorded. |
| practitioner_deceased_explanation | STRING | Free-text explanation/source for the deceased flag. |
| entity_created_at | DATE | Date the practitioner record was created in the tenant's network. |
| practitioner_initial_credentialing_date | DATE | Date of the practitioner's first (initial) credentialing. |
| practitioner_last_credentialed_date | DATE | Date the practitioner was most recently credentialed. |
| practitioner_next_credentialing_date | DATE | Date the practitioner's next (re)credentialing is due. |
| practitioner_attestation_date | DATE | Date of the practitioner's most recent attestation. |
| practitioner_reimbursement_id | STRING | Reimbursement/billing identifier for the practitioner. |
| practitioner_supervising_practitioner_id | STRING | Identifier of the practitioner's supervising practitioner, if applicable. |
| practitioner_caqh_provider_id | STRING | Practitioner's CAQH provider ID; used to join to the CAQH roster for outreach-blocker reporting. |
| practitioner_types | STRING | Comma-separated list of distinct, nonblank practitioner types recorded across the practitioner's licenses. |
| degrees | STRING | Comma-separated list of distinct, nonblank degrees recorded across the practitioner's education and training entries. |
| group_name | STRING | Provider group name associated with the practitioner workflow, when supplied. |
| workflow_id | STRING | Unique identifier of the credentialing workflow. Primary join key linking this tab to every unnested tab below. |
| workflow_created_at | DATE | Date the credentialing workflow was created. |
| workflow_latest_status | STRING | Most recent credentialing status/step name for the workflow (e.g. PSV_READY, CRED_APPROVED, WITHDRAWN_CANCELLED), derived from the latest timeline event. |
| workflow_latest_status_date | DATE | Date the workflow entered its most recent (latest) status. |
| credentialing_cycle | STRING | Credentialing cycle type (e.g. Initial, Annual/Recredentialing). |
| credentialing_due_date | DATE | Date by which credentialing/recredentialing is due. |
| previous_credentialed_date | DATE | Date of the practitioner's prior credentialing cycle. |
| line_of_business | STRING | Comma-separated, alphabetically sorted list of the practitioner's lines of business. |
| states_to_credential | STRING | Comma-separated, alphabetically sorted list of state abbreviations the practitioner is being credentialed in. |
| file_type | STRING | Most recent file-type classification for the practitioner (e.g. Clean, Dirty); defaults to "Unassigned" if never set. |
| file_type_reason | STRING | Reason associated with the most recent file_type change; defaults to "Unassigned". |
| application_received_date | DATE | Date the credentialing application was received (workflow creation date). |
| application_completion_date | DATE | Computed date the application was completed, sourced from the providerhub_reporting.application_complete_date dbt model: the last practitioner response date (inbound email or CAQH attestation) before the credentialing decision when a Section B (file-incomplete) outreach reason was raised; otherwise the workflow creation date. Always NULL in Open Workflow report files (report_type=open), since the application cannot be complete while the workflow is still open. In Terminal files, NULL only if the workflow has no matching row in that model. |
Emails 5 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| STRING | Email address on file for the practitioner. | |
| email_type | STRING | Category of the email address (e.g. work, personal). |
| email_source | STRING | System/process that sourced or verified this email record. |
Phone_Numbers 6 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| phone_number | STRING | Practitioner's phone number. |
| fax_number | STRING | Practitioner's fax number. |
| phone_type | STRING | Category of the phone number (e.g. office, mobile). |
| phone_source | STRING | System/process that sourced this phone record. |
Addresses 10 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| address1 | STRING | Street address line 1. |
| address2 | STRING | Street address line 2. |
| city | STRING | City. |
| state | STRING | State/territory abbreviation. |
| country | STRING | Country. |
| zipcode | STRING | Postal/ZIP code. |
| address_type | STRING | Type of address (e.g. mailing, home, practice). |
| source | STRING | System/process that sourced this address record. |
Licenses 16 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| license_number | STRING | State license number. |
| license_number_variations | STRING | Alternate/historical spellings or formats of the license number. |
| state | STRING | State that issued the license. |
| license_status | STRING | Current status of the license (e.g. Active, Inactive). |
| license_type | STRING | Type/category of license (e.g. MD, DO, NP). |
| license_source | STRING | Primary-source system used to verify the license. |
| practitioner_type | STRING | Practitioner type associated with this license record. |
| specialty | STRING | Specialty associated with this license. |
| expiration | DATE | License expiration date. |
| issue_date | DATE | Date the license was issued. |
| verified_date | DATE | Date the license was last primary-source verified. |
| board_action_flag | BOOLEAN | Whether a board/disciplinary action is flagged against this license. |
| url | STRING | URL to the primary-source verification record. |
| expiration_status | STRING | Computed status derived from `expiration`: "No Expiration", "EXPIRED", "Expiring Soon" (<=60 days), or "Active". |
Board_Certifications 20 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| certificate_id | STRING | Identifier of the board certificate. |
| certificate_type | STRING | Type of certificate (e.g. board certification). |
| certifying_board_name | STRING | Name of the certifying board (e.g. ABMS member board). |
| duration_type | STRING | Certification duration classification (e.g. time-limited vs. lifetime). |
| speciality | STRING | Certified specialty (source field name, note UK spelling). |
| subspeciality | STRING | Certified subspecialty (source field name, note UK spelling). |
| expiration_date | DATE | Certification expiration date. |
| expire_date | DATE | Secondary/raw expiration date field from the source system (may duplicate expiration_date). |
| issue_date | DATE | Date the certification was issued. |
| verified_date | DATE | Date the certification was last primary-source verified. |
| report_date | DATE | Date the certification was reported by the primary source. |
| flagged_date | DATE | Date the certification was flagged for review, if applicable. |
| is_primary | BOOLEAN | Whether this is the practitioner's primary board certification. |
| moc | STRING | Maintenance of Certification (MOC) status/indicator. |
| occurance_type | STRING | Occurrence/record type classification (source field name, note spelling). |
| record_type | STRING | Type of certification record. |
| source | STRING | System/process that sourced this certification record. |
| cert_status | STRING | Current status of the certification. |
Education_Training 14 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| type | STRING | Type of education/training record (e.g. Medical School, Residency, Fellowship). |
| degree | STRING | Degree earned (e.g. MD, DO). |
| institution | STRING | Name of the educational institution. |
| speciality | STRING | Specialty associated with the training (source field name, note UK spelling). |
| subspecialty | STRING | Subspecialty associated with the training. |
| start_date | DATE | Start date of the education/training period. |
| end_date | DATE | End date of the education/training period. |
| verified_date | DATE | Date the record was last primary-source verified. |
| status | STRING | Status of the education/training record. |
| source | STRING | System/process that sourced this record. |
| source_update_date | DATE | Date the source record was last updated. |
| licensing_board_reference | STRING | Reference identifier used by a licensing board for this record. |
Specialties 9 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| type | STRING | Type of specialty record. |
| specialty | STRING | Practitioner's specialty. |
| subspecialty | STRING | Practitioner's subspecialty. |
| primary_specialty | BOOLEAN | Whether this is the practitioner's primary specialty. |
| verified_date | DATE | Date the specialty was last primary-source verified. |
| source | STRING | System/process that sourced this record. |
| source_update_date | DATE | Date the source record was last updated. |
Practice_Locations 23 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| address1 | STRING | Practice location street address line 1. |
| address2 | STRING | Practice location street address line 2. |
| address3 | STRING | Practice location street address line 3. |
| address4 | STRING | Practice location street address line 4. |
| city | STRING | Practice location city. |
| state | STRING | Practice location state. |
| country | STRING | Practice location country. |
| county | STRING | Practice location county. |
| zipcode | STRING | Practice location ZIP/postal code. |
| npi | STRING | NPI of the practice location/facility (distinct from the practitioner's own NPI). |
| telephone_number | STRING | Practice location phone number. |
| fax_number | STRING | Practice location fax number. |
| healthcare_service_name | STRING | Name of the healthcare service/facility at this location. |
| start_date | DATE | Date the practitioner began practicing at this location. |
| clia_number | STRING | CLIA certificate number for the location's lab, if applicable. |
| clia_expiration_date | DATE | Expiration date of the location's CLIA certificate. |
| drawing_blood | BOOLEAN | Whether the location performs blood draws. |
| laboratory_services | BOOLEAN | Whether the location offers laboratory services. |
| phone_coverage24x7 | BOOLEAN | Whether the location provides 24/7 phone coverage. |
| total_location_hours | FLOAT | Total weekly hours the location is open. |
| verified_date | DATE | Date the practice location was last primary-source verified. |
Hospital_Affiliations 12 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| name | STRING | Name of the affiliated hospital. |
| state | STRING | State the hospital is located in. |
| specialty | STRING | Specialty associated with the affiliation. |
| type | STRING | Type of affiliation (e.g. admitting privileges, staff). |
| is_primary | BOOLEAN | Whether this is the practitioner's primary hospital affiliation. |
| start_date | DATE | Date the affiliation began. |
| end_date | DATE | Date the affiliation ended, if applicable. |
| verified_date | DATE | Date the affiliation was last primary-source verified. |
| status | STRING | Current status of the affiliation. |
| source | STRING | System/process that sourced this record. |
Malpractice_Insurance 14 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| carrier_name | STRING | Name of the malpractice insurance carrier. |
| policy_number | STRING | Insurance policy number. |
| type | STRING | Type of coverage (e.g. occurrence, claims-made). |
| effective_date | DATE | Date the policy became effective. |
| expiry_date | DATE | Date the policy expires. |
| aggregate_coverage_amount | FLOAT | Aggregate (annual total) coverage amount, in dollars. |
| occurrence_coverage_amount | FLOAT | Per-occurrence coverage amount, in dollars. |
| unlimited_coverage | BOOLEAN | Whether the policy provides unlimited coverage. |
| verified_date | DATE | Date the policy was last primary-source verified. |
| status | STRING | Current status of the policy. |
| source | STRING | System/process that sourced this record. |
| expiration_status | STRING | Computed status derived from expiry_date: "EXPIRED", "Expiring Soon" (<=60 days), or "Active". |
DEA 17 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| dea_number | STRING | DEA registration number. |
| number | STRING | Raw DEA number field from the source system (may duplicate dea_number). |
| state | STRING | State associated with the DEA registration. |
| type | STRING | Type of DEA registration. |
| provider_type | STRING | Provider type classification for the registration. |
| expiration_date | DATE | DEA registration expiration date. |
| expire_date | DATE | Secondary/raw expiration date field from the source system. |
| report_date | DATE | Date the registration was reported by the primary source. |
| flagged_date | DATE | Date the registration was flagged for review, if applicable. |
| affiliation | STRING | Business/practice affiliation on the registration. |
| cds_license_number | STRING | Associated state Controlled Dangerous Substances (CDS) license number. |
| verified_date | DATE | Date the registration was last primary-source verified. |
| status | STRING | Current status of the registration. |
| source | STRING | System/process that sourced this record. |
| url | STRING | URL to the primary-source verification record. |
NPDB_Reports 13 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| report_type | STRING | National Practitioner Data Bank report type. |
| type_of_action | STRING | Type of action reported. |
| allegation_nature | STRING | Nature of the underlying allegation. |
| specific_allegation | STRING | Specific allegation text/code. |
| specific_allegation_date | DATE | Date of the specific allegation. |
| allegations_description | STRING | Free-text description of the allegations. |
| procedure_description | STRING | Description of the procedure involved, if applicable. |
| outcome | STRING | Outcome/resolution of the report. |
| payment_date | DATE | Date of any associated payment. |
| verified_date | DATE | Date the report was last primary-source verified. |
| source | STRING | System/process that sourced this record. |
Sanctions 8 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| date_of_report | DATE | Date the sanction was reported. |
| sanction_type | STRING | Type of sanction (e.g. exclusion, suspension). |
| type_of_action | STRING | Type of action taken. |
| flagged_date | DATE | Date the sanction was flagged for review, if applicable. |
| verified_date | DATE | Date the sanction was last primary-source verified. |
| source | STRING | System/process that sourced this record (e.g. OIG, SAM.gov). |
Performance_Indicators 10 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| total_complaints | INTEGER | Total number of complaints recorded. |
| clinical_complaints | INTEGER | Number of clinical-quality complaints. |
| service_complaints | INTEGER | Number of service-related complaints. |
| benefits_complaints | INTEGER | Number of benefits-related complaints. |
| claim_complaints | INTEGER | Number of claims-related complaints. |
| access_issue_complaints | INTEGER | Number of access-to-care complaints. |
| report_date | DATE | Date the performance indicators were reported. |
| verified_date | DATE | Date the performance indicators were last primary-source verified. |
App_Verifications 6 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| verification_type | STRING | Type of application verification performed. |
| explanation | STRING | Free-text explanation/notes for the verification. |
| verified_date | DATE | Date the verification was completed. |
| source | STRING | System/process that sourced this record. |
Professional_IDs 9 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| type | STRING | Type of professional identifier (e.g. UPIN, taxonomy ID). |
| number | STRING | The identifier value. |
| state | STRING | State associated with the identifier, if applicable. |
| issue_date | DATE | Date the identifier was issued. |
| expiration_date | DATE | Date the identifier expires, if applicable. |
| source | STRING | System/process that sourced this record. |
| verified_date | DATE | Date the professional identifier was last primary-source verified. |
Languages 4 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| language | STRING | Language spoken by the practitioner. |
| is_primary | BOOLEAN | Whether this is the practitioner's primary language. |
Licensure_Actions 9 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| state | STRING | State that took the licensure action. |
| action_type | STRING | Type of licensure/disciplinary action. |
| details | STRING | Free-text details of the action. |
| last_action_date | DATE | Date of the most recent action. |
| report_date | DATE | Date the action was reported by the primary source. |
| source | STRING | System/process that sourced this record. |
| verified_date | DATE | Date the licensure action was last primary-source verified. |
Disclosure_Questions 7 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| question | STRING | Disclosure question text presented to the practitioner. |
| answer | STRING | Practitioner's answer to the disclosure question. |
| answer_flag | BOOLEAN | Whether the answer was flagged for follow-up (e.g. a "Yes" to a disqualifying question). |
| disclosure_date | DATE | Date the disclosure was recorded. |
| explanation | STRING | Practitioner-provided explanation for a flagged answer. |
CDS 11 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| number | STRING | Controlled Dangerous Substances (CDS) registration number. |
| state | STRING | State that issued the CDS registration. |
| provider_type | STRING | Provider type classification for the registration. |
| expiration_date | DATE | CDS registration expiration date. |
| expire_date | DATE | Secondary/raw expiration date field from the source system. |
| verified_date | DATE | Date the registration was last primary-source verified. |
| status | STRING | Current status of the registration. |
| source | STRING | System/process that sourced this record. |
| url | STRING | URL to the primary-source verification record. |
CLIA_Certificates 4 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| certificate_number | STRING | CLIA certificate number. |
| expiration_date | DATE | CLIA certificate expiration date. |
CMS_Specialties 4 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| cms_type_code | STRING | CMS specialty type code. |
| cms_type_name | STRING | CMS specialty type name/description. |
Medicaid 6 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| medicaid_number | STRING | Practitioner's Medicaid provider number. |
| medicaid_state | STRING | State the Medicaid number was issued in. |
| state | STRING | State associated with this Medicaid record. |
| cds_number | STRING | Associated CDS number, if recorded on this Medicaid record. |
Medicare 4 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| medicare_number | STRING | Practitioner's Medicare provider number (PTAN). |
| medicare_state | STRING | State the Medicare number was issued in. |
Work_History_Gaps 6 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| gap_start_date | DATE | Start date of the work history gap. |
| gap_end_date | DATE | End date of the work history gap. |
| explanation | STRING | Practitioner-provided explanation for the gap. |
| verified_date | DATE | Date the work history gap was last verified. |
X_Ray_Licenses 4 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| license_number | STRING | X-ray operator/technician license number. |
| expiration_date | DATE | X-ray license expiration date. |
Outreach 19 fields
| Field | Type | Description |
|---|---|---|
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| entity_npi | STRING | Practitioner NPI; joins to Main_Workflow_Data.entity_npi. |
| entity_full_name | STRING | Practitioner's full name. |
| outreach_id | STRING | Unique identifier of the outreach record. |
| outreach_type | STRING | Type of outreach (e.g. practitioner). |
| outreach_sent_by_email | STRING | Email of the internal user/system that initiated the outreach. |
| outreach_created_at | DATE | Date the outreach record was created. |
| credentialing_cycle | STRING | Credentialing cycle the outreach relates to. |
| outreach_reasons | STRING | Reason(s) the outreach was initiated (e.g. missing documents). |
| email_id | STRING | Unique identifier of the associated email. |
| email_direction | STRING | Direction of the email: INBOUND or OUTBOUND. |
| email_subject | STRING | Subject line of the email. |
| email_body | STRING | Raw body content of the email (may contain HTML). |
| email_sent_at | DATE | Date the email was sent. |
| email_sent_by_email | STRING | Email address of the sender. |
| email_to_addresses | STRING | Recipient (To) email address(es). |
| email_from_address | STRING | Sender (From) email address. |
| email_cc_addresses | STRING | CC email address(es). |
| email_bcc_addresses | STRING | BCC email address(es). |
Activity_Timeline 7 fields
| Field | Type | Description |
|---|---|---|
| event_id | STRING | Unique identifier of the timeline event. |
| workflow_id | STRING | Join key linking this row to Main_Workflow_Data.workflow_id. |
| created_at | TIMESTAMP | Timestamp the timeline event occurred. |
| created_by_email | STRING | Email of the user who triggered the event, if any. |
| previous_event_id | STRING | Identifier of the timeline event immediately preceding this one. |
| credentialing_status | STRING | Credentialing status/step name recorded by this event. |
| change_reason | STRING | Reason recorded for the status change, if any. |