Account - pharmalite Database

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

null

Account.MasterRecordId	FakeFK317C
Account.ParentId	FakeFK319C
Account.pharmalite__Primary_Parent__c	FakeFK321C
Account.PTLA_Formulary_Account__c	FakeFK322C
AccountContactRole.AccountId	FakeFK243C
AccountFeed.ParentId	FakeFK399C
AccountHistory.AccountId	FakeFK196C
AccountPartner.AccountFromId	FakeFK340C
AccountPartner.AccountToId	FakeFK341C
AccountShare.AccountId	FakeFK325C
ActivityHistory.AccountId	FakeFK281C
Asset.AccountId	FakeFK277C
Case.AccountId	FakeFK229C
Contact.AccountId	FakeFK300C
Contract.AccountId	FakeFK373C
Event.AccountId	FakeFK309C
Lead.ConvertedAccountId	FakeFK296C
OpenActivity.AccountId	FakeFK356C
Opportunity.AccountId	FakeFK431C
OpportunityPartner.AccountToId	FakeFK402C
Order.AccountId	FakeFK258C
Partner.AccountFromId	FakeFK210C
Partner.AccountToId	FakeFK211C
Task.AccountId	FakeFK334C
UserRole.PortalAccountId	FakeFK195C

Label: Account ID

IsDeleted

boolean

null

Label: Deleted

MasterRecordId

reference

null

Account.Id

FakeFK317C

Label: Master Record ID

Name

string

255

null

Label: Account Name

LastName

string

null

Label: Last Name

FirstName

string

null

Label: First Name

Salutation

picklist

null

Label: Salutation
Picklist: Mr. | Ms. | Mrs. | Dr. | Prof.

Type

picklist

null

RecordTypeId

reference

null

RecordType.Id

FakeFK318C

Label: Record Type ID

ParentId

reference

null

Account.Id

FakeFK319C

Label: Parent Account ID
Referenced: ChildAccounts

BillingStreet

textarea

255

null

Label: Billing Street

BillingCity

string

null

Label: Billing City

BillingState

string

null

Label: Billing State/Province

BillingPostalCode

string

null

Label: Billing Zip/Postal Code

BillingCountry

string

null

Label: Billing Country

ShippingStreet

textarea

255

null

Label: Shipping Street

ShippingCity

string

null

Label: Shipping City

ShippingState

string

null

Label: Shipping State/Province

ShippingPostalCode

string

null

Label: Shipping Zip/Postal Code

ShippingCountry

string

null

Label: Shipping Country

Phone

phone

null

Label: Account Phone

Fax

phone

null

Label: Account Fax

Website

url

255

null

Label: Website

Industry

picklist

null

AnnualRevenue

currency

null

Label: Annual Revenue

NumberOfEmployees

int

null

Label: Employees

Description

textarea

32000

null

Label: Account Description

OwnerId

reference

null

Label: Owner ID

CreatedDate

datetime

null

Label: Created Date

CreatedById

reference

null

Label: Created By ID

LastModifiedDate

datetime

null

Label: Last Modified Date

LastModifiedById

reference

null

Label: Last Modified By ID

SystemModstamp

datetime

null

Label: System Modstamp

LastActivityDate

date

null

Label: Last Activity

PersonContactId

reference

null

Contact.Id

FakeFK320C

Label: Contact ID

IsPersonAccount

boolean

null

Label: Is Person Account

PersonMailingStreet

textarea

255

null

Label: Mailing Street

PersonMailingCity

string

null

Label: Mailing City

PersonMailingState

string

null

Label: Mailing State/Province

PersonMailingPostalCode

string

null

Label: Mailing Zip/Postal Code

PersonMailingCountry

string

null

Label: Mailing Country

PersonOtherStreet

textarea

255

null

Label: Other Street

PersonOtherCity

string

null

Label: Other City

PersonOtherState

string

null

Label: Other State/Province

PersonOtherPostalCode

string

null

Label: Other Zip/Postal Code

PersonOtherCountry

string

null

Label: Other Country

PersonMobilePhone

phone

null

Label: Mobile

PersonHomePhone

phone

null

Label: Home Phone

PersonOtherPhone

phone

null

Label: Other Phone

PersonAssistantPhone

phone

null

Label: Asst. Phone

PersonEmail

null

Label: Email

PersonTitle

string

null

Label: Title

PersonDepartment

string

null

Label: Department

PersonAssistantName

string

null

Label: Assistant

PersonLeadSource

picklist

null

PersonBirthdate

date

null

Label: Birthdate

PersonDoNotCall

boolean

null

Label: Do Not Call

PersonLastCURequestDate

datetime

null

Label: Last Stay-in-Touch Request Date

PersonLastCUUpdateDate

datetime

null

Label: Last Stay-in-Touch Save Date

PersonEmailBouncedReason

string

255

null

Label: Email Bounced Reason

PersonEmailBouncedDate

datetime

null

Label: Email Bounced Date

Jigsaw

string

null

Label: Data.com Key

pharmalite__Consent_Last_Modified_By__c

reference

null

Label: Consent Last Modified By

pharmalite__Consent_Last_Modified_Date__c

datetime

null

Label: Consent Last Modified Date

pharmalite__Consent_Method__c

picklist

255

null

Label: Consent Method
Picklist: Phone | Email | In Person

pharmalite__Consent_Options__c

picklist

255

null

Label: Consent Status
Picklist: Consent to Process Data Received | Consent to Send Materials Received | Withdrawal | Delete

pharmalite__Email__c

null

Label: Email

pharmalite__Primary_Parent__c

reference

null

Account.Id

FakeFK321C

Label: Primary Parent
Help: Primary parent takes up to one day to update
Referenced: pharmalite__Primary_Parent__r

pharmalite__Specialty_1__c

picklist

255

null

gsdm__Email__c

null

Label: Email

AHA__c

string

null

Label: AHA #

Account_Type__c

picklist

255

null

Label: Account Type
Picklist: Admin Org | Network | PBM | Plan Provider | Specialty Org

Account__c

decimal

null

Label: Account
Formula: 1

AndexXa_Launch__c

boolean

null

Label: AndexXa Launch

Andexxa_HCO_Target__c

boolean

null

Label: AndexXa Target

Andexxanet_Dossier_Sent__c

boolean

null

Label: Andexxanet Dossier Sent

Average_Order_Time_Days__c

decimal

null

Label: Average Order Time Days

Beds__c

decimal

null

Label: # Beds

Betrixiban_Target__c

boolean

null

Label: Betrixaban Target

Credentials__c

picklist

255

null

Current_QTR_Region__c

string

100

null

Label: Current QTR Region

Current_Qtr_Area__c

string

255

null

Label: Current Qtr Area

Current_Qtr_Territory__c

string

100

null

Label: Current Qtr Territory

Decile__c

decimal

null

Label: Decile

Departments__c

decimal

null

Label: # Departments

Dossier_Sent__c

boolean

null

Label: Betrixaban Dossier Sent

Focus_Account__c

boolean

null

Label: Focus Account

HCO_Type__c

picklist

255

null

HCP_Type__c

picklist

255

null

HIN__c

string

null

Label: HIN

HMO__c

decimal

null

Label: HMO

IDN__c

textarea

255

null

Label: IDN Id

Is_Formulary_Sponsor__c

boolean

null

Label: Is_Formulary_Sponsor

Legacy_Network_External_Id__c

string

120

null

Label: Legacy Veeva Id

Legacy_SFDC_Id__c

string

null

Label: Legacy SFDC Id

Legacy_SFDC_JSON__c

textarea

16384

null

Label: Legacy SFDC Record

ME__c

string

null

Label: ME #

NET_AMA_Do_Not_Contact__c

picklist

255

null

Label: AMA Do Not Contact
Picklist: No | Unknown | Yes

NPI__c

string

255

null

Label: NPI

PDRP_Opt_Out_Date__c

date

null

Label: PDRP Opt-out date

PDRP_Opt_Out__c

boolean

null

Label: PDRP Opt-out

PTLA_AC_RP_Speaker__c

boolean

null

Label: Anticoagulation/Reversal Podium Speaker

PTLA_AC_R_Author__c

boolean

null

Label: Anticoagulation/Reversal Author

PTLA_ANNEXA_4_Investigator__c

picklist

255

null

Label: ANNEXA-4 Investigator
Picklist: Y | EC | SC | author

PTLA_ANNEXA_I_Investigator__c

picklist

255

null

Label: ANNEXA-I Investigator
Picklist: Y | EC | SC | author

PTLA_APEX_Investigator__c

picklist

255

null

Label: APEX Investigator
Picklist: Y | EC | SC | author | PI | Yes

PTLA_ATS_Trauma_Level_2017__c

string

255

null

Label: ATS Trauma Level 2017

PTLA_A_Next_Appointment_Date__c

date

null

Label: Next Appointment Date

PTLA_Account_Category__c

string

120

null

Label: Account Category

PTLA_Account_Status__c

picklist

255

null

Label: Account Status
Picklist: Active | Inactive

PTLA_Advanced_primary_stroke_Center__c

string

null

Label: Advanced primary stroke Center

PTLA_Advisory_Board_Flag__c

boolean

null

Label: Advisory Board

PTLA_Advisory_Board_Specify__c

textarea

255

null

Label: Advisory Board (Specify)

PTLA_Advisory_Board__c

picklist

255

null

PTLA_Andexanet_Speaker_Flag__c

boolean

null

Label: Andexanet Speaker

PTLA_Andexanet_Speaker__c

picklist

255

null

Label: Andexanet Speaker
Picklist: Y | Y (unbranded)

PTLA_Andexxa_Advocacy_Level__c

picklist

255

null

PTLA_Andexxa_Authorization_Date__c

date

null

Label: Andexxa Authorization Date

PTLA_Andexxa_Department__c

picklist

255

null

PTLA_Andexxa_KOL_Mapping_Project__c

picklist

255

null

Label: Andexxa KOL Mapping Project
Picklist: Y

PTLA_Andexxa_Latest_Speaker_Attendance__c

date

null

Label: Latest Speaker Attendance

PTLA_Andexxa_Order_Report_Opt_Out__c

boolean

null

Label: Andexxa Order Report Opt-Out

PTLA_Andexxa_Role_in_ADX__c

picklist

255

null

PTLA_Andexxa_Status__c

picklist

255

null

Label: Andexxa Purchasing Status
Help: Approved- Authorized but no sales yet
Ordered - Authorized and made 1st order
Activated- Authorized and 2 or more orders
Declined- HCO is authorized but not interested
Picklist: Approved | Ordered | Activated | Declined

PTLA_Annual_Discharge__c

decimal

null

Label: Annual Discharge

PTLA_App_Account__c

boolean

null

Label: Mobile App Account?

PTLA_BRAVO_Investigator__c

picklist

255

null

Label: BRAVO Investigator
Picklist: Y | Co-chair | EC | SC | author

PTLA_Betrixaban_Speaker_Flag__c

boolean

null

Label: Betrixaban Speaker

PTLA_Betrixaban_Speaker__c

picklist

255

null

Label: Betrixaban Speaker
Picklist: Y | Y (unbranded) | Yes | Yes (unbranded)

PTLA_Bevyxxa_KOL_Mapping_Project__c

picklist

255

null

Label: Bevyxxa KOL Mapping Project
Picklist: Y

PTLA_Bleed_Discharges_2014__c

string

255

null

Label: Bleed Discharges

PTLA_CMS_Certification__c

string

100

null

Label: CMS Certification #

PTLA_Campaign_Summary__c

textarea

2048

null

Label: Campaign Summary

PTLA_ComOps_Country__c

string

null

Label: Country

PTLA_Comprehensive_Stroke_Center_2018__c

string

255

null

Label: Comprehensive Stroke Center - 2018

PTLA_Conference_Congress_Attendee__c

boolean

null

Label: Conference/Congress Attendee

PTLA_Consignment_Eligible__c

picklist

255

null

Label: Consignment Eligible
Picklist: Yes | No

PTLA_Consignment_End_Date__c

date

null

Label: Consignment End Date

PTLA_Consignment_On_Site__c

picklist

255

null

Label: Consignment Inventory On Site
Picklist: Yes | No

PTLA_Consignment_Start_Date__c

date

null

Label: Consignment Start Date

PTLA_Expected_Frequency_of_Contact__c

picklist

255

null

Label: Expected Frequency of Contact
Picklist: Annually | Bi-annually | Quarterly | Closed 2016

PTLA_External_Id__c

string

null

Label: External Id

PTLA_FOP__c

string

120

null

Label: FOP

PTLA_Guideline_Committee_Member__c

boolean

null

Label: Guideline Committee Member

PTLA_Guideline_Committee_Member_specify__c

textarea

255

null

Label: Guideline Committee Member (specify)

PTLA_HCO_HQ_Email_Opt_Out__c

boolean

null

Label: HCO HQ Email Opt-Out
Help: HCO Headquarter Marketing Email Opt Out including HCPS at this HCO. Personalized email is not part of this opt out.

PTLA_Has_Ordered_Andexxa__c

string

1300

null

Label: Ordered Andexxa?
Formula: IF(PTLA_Andexxa_Order_Count__c > 0, “Yes”, “No”)

PTLA_IIS_Investigator__c

picklist

255

null

Label: IIS Investigator
Picklist: Y

PTLA_ISR_Investigator__c

picklist

255

null

Label: ISR Investigator
Picklist: Y

PTLA_Interest_In_buying_Andexxa__c

boolean

null

Label: Andexxa Interested in Buying

PTLA_Is_Focus_HCP__c

boolean

null

Label: Is Focus HCP?

PTLA_Is_Quarterly_Full_Account__c

boolean

null

Label: Is Quarterly Full Account

PTLA_Last_Call_Date__c

datetime

null

Label: Last Call Date

PTLA_LexisNexis_Specialty__c

string

120

null

Label: LexisNexis Specialty

PTLA_Local_KOL__c

boolean

null

Label: Local KOL

PTLA_Lockwood_Tier_1_Project__c

picklist

255

null

Label: Lockwood Tier 1 Project
Picklist: Yes | No

PTLA_MDM_Id__c

string

null

Label: PTLA ID

PTLA_MSL_App_Account__c

boolean

null

Label: MSL App Account
Formula: OR(IsPersonAccount = false, PTLA_App_Account__c)

PTLA_MSL_KOL__c

boolean

null

Label: MSL KOL
Formula: OR(IF(PTLA_Andexanet_Speaker_Flag__c = False, False, True),
IF(PTLA_Betrixaban_Speaker_Flag__c = False, False, True),
IF(ISPICKVAL(PTLA_ANNEXA_4_Investigator__c, ""), FALSE, TRUE),
IF(ISPICKVAL(PTLA_ANNEXA_I_Investigator__c, ""), FALSE, TRUE),
IF(ISPICKVAL(PTLA_APEX_Investigator__c, ""), FALSE, TRUE),
IF(ISPICKVAL(PTLA_ISR_Investigator__c, ""), FALSE, TRUE),
IF(PTLA_Steeprock_KOL__c = False, False, True),
IF(PTLA_AC_R_Author__c = False, False, True),
IF(PTLA_AC_RP_Speaker__c = False, False, True),
IF(PTLA_Advisory_Board_Flag__c = False, False, True),
IF (ISBLANK(PTLA_Advisory_Board_Specify__c), FALSE, TRUE),
IF(PTLA_Guideline_Committee_Member__c = False, False, True),
IF (ISBLANK(PTLA_Guideline_Committee_Member_specify__c), FALSE, TRUE),
IF(PTLA_Society_Leadership__c = False, False, True),
IF (ISBLANK(PTLA_Society_Leadership_Specify__c), FALSE, TRUE),
IF(ISPICKVAL(PTLA_Expected_Frequency_of_Contact__c, ""), FALSE, TRUE),
IF(ISPICKVAL(PTLA_No_Limited_Access__c, ""), FALSE, TRUE),
IF (ISBLANK(PTLA_Other__c), FALSE, TRUE))

PTLA_MSL_Project__c

string

255

null

Label: MSL Project

PTLA_Mariner_PI__c

picklist

255

null

Label: Mariner PI
Picklist: Y | EC | SC | Author

PTLA_Medical_Degree__c

picklist

255

null

Label: Medical Degree
Picklist: AC | ADT | AMT | AT | ATH | AUD | DA | DAUD | DC | DDS | DH | DMD | DN | DO | DO-L | DOM | DO-S | DPM | DVM | EMS | ET | FNP | HBP | HMD | MA | MD | MD-S | MFT | MHC | MW | NA | ND | NM | NP | OD | OT | OTA | PA | PHAR | PHARM | PHARMD | PHD | PHT | PRF | PSY | PT | PTA | PVN | RADT | RN | RT | RVT | SLP | SLPA | SW | VMD | VT

PTLA_No_Access__c

boolean

null

Label: No Access

PTLA_No_Access_without_Contract__c

boolean

null

Label: No Access Without Contract

PTLA_No_Limited_Access__c

picklist

255

null

Label: No/Limited Access
Picklist: Y

PTLA_Non_Affiliated__c

boolean

null

Label: Non-Affiliated?

PTLA_Other__c

string

255

null

Label: Other

PTLA_Primary_DEA__c

string

null

Label: Primary DEA#

PTLA_Profiles__c

string

255

null

Label: Profiles?

PTLA_Readmission_Rate__c

string

null

Label: Readmission Rate

PTLA_Sales_Key_Opinion_Leader__c

boolean

null

Label: National KOL

PTLA_Sales_Territory__c

string

1300

null

Label: Sales Territory
Formula: PTLA_Territory__c

PTLA_Segment__c

picklist

255

null

Label: Segment
Help: 1: Decile = 10 or 9
2: Decile = 8, 7 or 6
3: Decile = 5, 4 or 3
Picklist: 1 | 2 | 3 | Non-Target

PTLA_Society_Leadership_Specify__c

textarea

255

null

Label: Society Leadership (Specify)

PTLA_Society_Leadership__c

boolean

null

Label: Society Leadership

PTLA_Specialty_Distributor__c

picklist

255

null

Label: Specialty Distributor
Picklist: AmerisourceBergen | Cardinal Health | FFF | McKesson

PTLA_Steeprock_KOL__c

boolean

null

Label: Steeprock KOL

PTLA_Territory__c

string

255

null

Label: Sales Territory

PTLA_Top20_Milestone_Captured__c

boolean

null

Label: Top20 Milestone Captured?
Formula: NOT(AND (
IsBlank(Text(PTLA_Andexxa_Department__c)) ,
IsBlank(Text(PTLA_Andexxa_Role_in_ADX__c)) ,
IsBlank(Text(PTLA_Andexxa_Advocacy_Level__c)) ,
IsBlank(PTLA_A_Next_Appointment_Date__c) ,
IsBlank(Text(PTLA_Andexanet_Speaker__c))
))

PTLA_Total_Calls__c

decimal

null

Label: Total Calls

P_Alternate_Email__c

null

Label: Alternate Email
Help: Approved Email Only

P_Approved_Email_Status__c

picklist

255

null

Label: Approved Email Status
Picklist: Opted-In | Opted-Out

P_Comprehensive_Stroke_Center__c

picklist

255

null

Label: Comprehensive Stroke Center
Picklist: Yes | No

P_Global_KOL__c

boolean

null

Label: Global KOL

P_National_KOL__c

boolean

null

Label: National KOL

P_Overall_potential__c

string

100

null

Label: Overall potential

P_Primary_Address_line1__c

string

200

null

Label: Primary Address

P_Primary_Address_line2__c

string

200

null

Label: Primary Address Line 2

P_Primary_City__c

string

null

Label: Primary City

P_Primary_State__c

string

255

null

Label: Primary State

P_Priority_HCP_Betrixiban__c

boolean

null

Label: Priority HCP Betrixaban

P_Priority_Institution__c

boolean

null

Label: Priority Institution

P_Trauma_Center_Tier__c

picklist

255

null

Label: Trauma Center Tier
Picklist: Level 1 | Level 2 | Level 3

Primary_Zip__c

string

null

Label: Primary Zip

Regional_Strategy__c

textarea

32000

null

Label: Regional Strategy

Speaker__c

boolean

null

Label: Speaker?

Specialty_1__c

string

255

null

Label: Primary Specialty

Specialty_2__c

string

255

null

Label: Secondary Specialty

Tier__c

picklist

255

null

Label: Tier
Picklist: Tier3 | 1 | 2

Top_150_Andexxanet__c

boolean

null

Label: Top Andexanet

Use_Primary_Address__c

boolean

null

Label: Use Primary Address

PTLA_Andexxa_First_Order_Date__c

date

null

Label: Andexxa_First_Order_Date

PTLA_Andexxa_Last_Order_Date__c

date

null

Label: Andexxa Last Order Date

PTLA_Andexxa_Order_Count__c

decimal

null

Label: Andexxa Order Count

PTLA_Andexxa_Order_Quantity__c

decimal

null

Label: Andexxa Order Quantity

PTLA_Andexxa_Total_Sold_Amount__c

currency

null

Label: Andexxa Total Sold Amount

PTLA_Formulary_Record_Count__c

decimal

null

Label: Formulary Approval Records

PTLA_Formulary_Wins_Count__c

decimal

null

Label: Formulary Wins

PTLA_Pull_Through_Count__c

decimal

null

Label: Pull Through Count

PTLA_Alternate_Name__c

string

100

null

Label: Alternate Name

PTLA_Formulary_Account__c

reference

null

Account.Id

FakeFK322C

Label: Formulary Account
Referenced: Formulary_Accounts__r

PTLA_Is_Parent_Target_HCP_Andex__c

boolean

null

Label: Affiliated to Target (AndexXa)
Formula: pharmalite__Primary_Parent__r.Andexxa_HCO_Target__c

PTLA_Medical_Degree_2__c

picklist

255

null

Label: Medical Degree 2
Picklist: AC | ADT | AMT | AT | ATH | AUD | DA | DAUD | DC | DDS | DH | DMD | DN | DO | DO-L | DOM | DO-S | DPM | DVM | EMS | ET | FNP | HBP | HMD | MA | MD | MD-S | MFT | MHC | MW | NA | ND | NM | NP | OD | OT | OTA | PA | PHAR | PHARM | PHARMD | PHD | PHT | PRF | PSY | PT | PTA | PVN | RADT | RN | RT | RVT | SLP | SLPA | SW | VMD | VT

PTLA_Medical_Degree_3__c

picklist

255

null

Label: PTLA Medical Degree
Picklist: AC | ADT | AMT | AT | ATH | AUD | DA | DAUD | DC | DDS | DH | DMD | DN | DO | DO-L | DOM | DO-S | DPM | DVM | EMS | ET | FNP | HBP | HMD | MA | MD | MD-S | MFT | MHC | MW | NA | ND | NM | NP | OD | OT | OTA | PA | PHAR | PHARM | PHARMD | PHD | PHT | PRF | PSY | PT | PTA | PVN | RADT | RN | RT | RVT | SLP | SLPA | SW | VMD | VT

PTLA_Place_of_Employment__c

picklist

255

null

PTLA_Specialty_1__c

picklist

255

null

PTLA_Specialty_2__c

picklist

255

null

PTLA_Type_of_Practice__c

picklist

255

null

PTLA_MDM_URI__c

string

255

null

Label: PTLA ID URI

PTLA_MSL_Territory__c

string

255

null

Label: MSL Territory

PTLA_Authorized_to_Purchase__c

picklist

255

null

Label: Andexxa Authorized to Purchase
Picklist: Yes | No

PTLA_DCR_Notes__c

textarea

32768

null

Label: DCR Notes

PTLA_DCR_Sync_Status_Details__c

textarea

16384

null

Label: DCR Sync Status Details

PTLA_DCR_Sync_Status__c

string

255

null

Label: DCR Sync Status

IDN_Name__c

string

255

null

Label: IDN

IDN_Parent_Name__c

string

255

null

Label: IDN Parent

IDN_Parent__c

string

255

null

Label: IDN Parent Id

PTLA_Primary_GPO_Name__c

string

255

null

Label: Primary GPO

PTLA_Primary_GPO__c

string

255

null

Label: Primary GPO Id

Full_Name_First_Last__c

string

1300

null

Label: Full Name (First Last)
Formula: IF(IsPersonAccount, FirstName + " " + LastName, Name)

Full_Name__c

string

1300

null

Label: Full Name (First Middle Last)
Formula: IF(
IsPersonAccount, IF(NOT(ISBLANK(MiddleName)), FirstName + " " + MiddleName + " " + LastName, FirstName + " " + LastName), Name)

PTLA_DCR_New_Account__c

boolean

null

Label: DCR New Account

PTLA_Primary_State__c

picklist

255

null

Label: State
Picklist: AL | AK | AZ | AR | CA | CO | CT | DE | FL | GA | HI | ID | IL | IN | IA | KS | KY | LA | ME | MD | MA | MI | MN | MS | MO | MT | NE | NV | NH | NJ | NM | NY | NC | ND | OH | OK | OR | PA | RI | SC | SD | TN | TX | UT | VT | VA | WA | WV | WI | WY

Indexes

Constraint Name	Type	Sort	Column(s)
FakeIndex0	Must be unique	Asc	Id

Relationships

Close relationships within degrees of separation

One
Two degrees