NameDescriptionTypeAdditional information
cust_num

integer

None.

last_name

string

Required

String length: inclusive between 0 and 40

first_name

string

Required

String length: inclusive between 0 and 40

id_num

string

Matching regular expression pattern: ^[0-9]{9}$|null

String length: inclusive between 0 and 9

street

string

String length: inclusive between 0 and 33

home

integer

None.

p_o_b

integer

None.

email

string

Max length: 30

mailing

string

Matching regular expression pattern: ^[yn]{1}$

String length: inclusive between 0 and 1

sex

string

Matching regular expression pattern: ^[mfu/s]{1}$

String length: inclusive between 0 and 1

personalSituation

string

Matching regular expression pattern: ^[bmwdn]{1}$

String length: inclusive between 0 and 1

born

date

None.

brit_name

string

String length: inclusive between 0 and 40

father_name

string

String length: inclusive between 0 and 40

creation_date

date

None.

remark

string

String length: inclusive between 0 and 254

created_record

date

None.

updated_record

date

None.

city_code

integer

None.

branch_code

integer

None.

business_branch_code

integer

None.

insur_code

integer

None.

district_code

integer

None.

active

string

Matching regular expression pattern: ^[yn]{1}$

String length: inclusive between 0 and 1

prefix

string

String length: inclusive between 0 and 1

oocust

integer

None.

addphone_rem

string

String length: inclusive between 0 and 20

mactokef

date

None.

status_code

integer

None.

pasport

string

String length: inclusive between 0 and 16

adviser_code

integer

None.

menahel_code

string

String length: inclusive between 0 and 15

apartment_num

string

String length: inclusive between 0 and 4

oow_code

integer

None.

azip

string

String length: inclusive between 0 and 7

file_finish

string

String length: inclusive between 0 and 5

sensitivity

string

String length: inclusive between 0 and 240

brit_name_first

string

String length: inclusive between 0 and 40

smoker

string

Matching regular expression pattern: ^[yna]{1}$

String length: inclusive between 0 and 1

elevator

string

Matching regular expression pattern: ^[yna]{1}$

String length: inclusive between 0 and 1

jump_sensitivity

string

Matching regular expression pattern: ^[yn]{1}$

String length: inclusive between 0 and 1

with_password

string

Matching regular expression pattern: ^[yn]{1}$

String length: inclusive between 0 and 1

sendmail_from

date

None.

palestinian

string

Matching regular expression pattern: ^[yn]{1}$

String length: inclusive between 0 and 1

get_reminder_sms

string

Matching regular expression pattern: ^[yn]{1}$

String length: inclusive between 0 and 1

get_whatsapp

string

Matching regular expression pattern: ^[yn]{1}$

String length: inclusive between 0 and 1

internet_answers

string

Matching regular expression pattern: ^[yn]{1}$

String length: inclusive between 0 and 1

old_cust_num

integer

None.

archive_num

integer

None.

clalit_num

string

Max length: 11

String length: inclusive between 0 and 11

homephone

string

String length: inclusive between 0 and 12

workphone

string

String length: inclusive between 0 and 12

mobilephone

string

String length: inclusive between 0 and 12

fax

string

Max length: 12

addphone

string

Max length: 12

import_cust_num

integer

None.

entrance

string

String length: inclusive between 0 and 2

country_code

integer

None.

blood_type

string

String length: inclusive between 0 and 5

escort_phone

string

Max length: 12

prof_code

integer

None.

mother_tongue_code

integer

None.

parent_account

integer

None.

interface_code

string

String length: inclusive between 0 and 10

interest_name

string

String length: inclusive between 0 and 50

campaign_name

string

String length: inclusive between 0 and 50

adv_source_name

string

String length: inclusive between 0 and 50

old_code

integer

None.

source_code

integer

None.

system_customer

string

String length: inclusive between 0 and 1

date_came_daycare

date

None.

birth_week

string

None.

birth_weight

decimal number

None.

corrected_age_date

date

None.

receiving_marketing_materials

date

None.

VIP_cust

string

Matching regular expression pattern: ^[yn]{1}$

String length: inclusive between 0 and 1

last_health_declaration

date

None.

em_update_code

integer

None.

em_create_code

integer

None.

room

integer

None.

recruitment_date

date

None.

release_date

date

None.

service_type

string

None.

profile

string

None.

unit

string

None.

deficiencies

string

None.

representative_attorney

string

None.

role

string

None.

date_Disabled

date

None.

From_Old_System

boolean

None.

Countries

Country

None.

Employees

Employee

None.

InsurerBranches

InsurerBranch

None.

InsurerDistricts

InsurerDistrict

None.

Insurers

Insurer

None.

Statuses

Status

None.

custPermanentDrugs

Collection of custPermanentDrug

None.

DelAppointments

Collection of DelAppointment

None.

MedicalSheets

Collection of MedicalSheet

None.

MedicalSheetHistorys

Collection of MedicalSheetHistory

None.

Prescriptions

Collection of Prescription

None.

EligPayments

Collection of EligPayment

None.

TimeTable

Collection of TimeTable

None.

TransferAppointmentsLog

Collection of TransferAppointmentsLogLine

None.

WaitForAppointments

Collection of WaitForAppointment

None.

DocumentsStores

Collection of DocumentsStore

None.

FeaturesCust

Collection of FeaturesCust

None.

BackgroundDiseaseCust

Collection of BackgroundDiseaseCust

None.

ServiceRecord

Collection of ServiceRecord

None.

CustContact

Collection of CustContact

None.

MedicalMeasurements

Collection of MedicalMeasurement

None.

PermissionsToCust

Collection of PermissionsToCust

None.

WithPicture

boolean

None.

city_name

string

None.

FullName

string

None.

AgeYears

integer

None.

AgeMonth

integer

None.

FullAddress

string

None.

WithDrugs

boolean

None.

CustAccountNum

integer

None.