General informations
Fields (31)
Name | Label | Type | Description |
---|---|---|---|
Id | Person Employment ID | ID | |
OwnerId | Owner ID | LOOKUP | |
IsDeleted | Deleted | CHECKBOX | |
Name | Employer | TEXT(255) | |
CreatedDate | Created Date | DATETIME | |
CreatedById | Created By ID | LOOKUP | |
LastModifiedDate | Last Modified Date | DATETIME | |
LastModifiedById | Last Modified By ID | LOOKUP | |
SystemModstamp | System Modstamp | DATETIME | |
LastViewedDate | Last Viewed Date | DATETIME | |
LastReferencedDate | Last Referenced Date | DATETIME | |
RelatedPersonId | Related Person ID | LOOKUP | |
Position | Position | TEXT(255) | |
Occupation | Occupation | PICKLIST | |
EmploymentStatus | Employment Status | PICKLIST | |
AnnualIncome | Annual Income | CURRENCY(18,0) | |
EmployerStreet | Employer Street | TEXT AREA(255) | |
EmployerCity | Employer City | TEXT(40) | |
EmployerState | Employer State | TEXT(80) | |
EmployerPostalCode | Employer Postal Code | TEXT(20) | |
EmployerCountry | Employer Country | TEXT(80) | |
EmployerStateCode | Employer State Code | PICKLIST | |
EmployerCountryCode | Employer Country Code | PICKLIST | |
EmployerLatitude | Employer Latitude | NUMBER(3,15) | |
EmployerLongitude | Employer Longitude | NUMBER(3,15) | |
EmployerGeocodeAccuracy | Employer Geocode Accuracy | PICKLIST | |
EmployerAddress | Employer Address | AUTO NUMBER | |
EmployerPhone | Employer Phone | PHONE | |
StartDate | Start Date | DATE | |
EndDate | End Date | DATE | |
HealthcareProvider_Id_1 | HealthcareProvider_Healthcare Provider ID_1 | LOOKUP |
Fields Details (31)
Name | Id |
Label | Person Employment ID |
Type | ID |
Required | Yes |
Name | OwnerId |
Label | Owner ID |
Type | LOOKUP |
Foreign key | Yes |
Required | Yes |
Name | IsDeleted |
Label | Deleted |
Type | CHECKBOX |
Required | Yes |
Default value | false |
Name | Name |
Label | Employer |
Type | TEXT(255) |
Required | Yes |
Name | CreatedDate |
Label | Created Date |
Type | DATETIME |
Required | Yes |
Name | CreatedById |
Label | Created By ID |
Type | LOOKUP |
Foreign key | Yes |
Required | Yes |
Name | LastModifiedDate |
Label | Last Modified Date |
Type | DATETIME |
Required | Yes |
Name | LastModifiedById |
Label | Last Modified By ID |
Type | LOOKUP |
Foreign key | Yes |
Required | Yes |
Name | SystemModstamp |
Label | System Modstamp |
Type | DATETIME |
Required | Yes |
Name | LastViewedDate |
Label | Last Viewed Date |
Type | DATETIME |
Name | LastReferencedDate |
Label | Last Referenced Date |
Type | DATETIME |
Name | RelatedPersonId |
Label | Related Person ID |
Type | LOOKUP |
Foreign key | Yes |
Required | Yes |
Name | Position |
Label | Position |
Type | TEXT(255) |
Name | Occupation |
Label | Occupation |
Type | PICKLIST |
Picklist values | Dentists Physicians and surgeons Physician assistants Physical therapists Respiratory therapists Registered nurses Nurse midwives and nurse practitioners Health technologists and technicians (all) Dental hygienists Diagnostic related technologists and technicians Licensed practical and licensed vocational nurses Healthcare support occupations (all) Nursing, psychiatric, and home health aides Occupational and physical therapist assistants and aides Dental assistants Phlebotomists Pharmacists and pharmacy aides Other occupations within the healthcare sector |
Name | EmploymentStatus |
Label | Employment Status |
Type | PICKLIST |
Picklist values | Employed Self-Employed Home Maker Retired Student Unemployed with Income Unemployed without Income |
Name | AnnualIncome |
Label | Annual Income |
Type | CURRENCY(18,0) |
Name | EmployerStreet |
Label | Employer Street |
Type | TEXT AREA(255) |
Name | EmployerCity |
Label | Employer City |
Type | TEXT(40) |
Name | EmployerState |
Label | Employer State |
Type | TEXT(80) |
Name | EmployerPostalCode |
Label | Employer Postal Code |
Type | TEXT(20) |
Name | EmployerCountry |
Label | Employer Country |
Type | TEXT(80) |
Name | EmployerStateCode |
Label | Employer State Code |
Type | PICKLIST |
Picklist values | AC AG AG 05 02 AL AL AK AB AL AP AM AN AN AP 34 23 AO AR AZ AR AR AP AS AT ACT AV BA BC BS BA BT 11 BL BN BG BI BR BO BZ BS BR BC CA CA CL CM CB CI CW CE CT CZ CN CE CH CT CS 12 CH CH 50 CE CO CL CO CO CT CO CS CR KR CN DN DD DE DL DC DF DL D DG 38 EN ES DF FM FE FI FL FG FC FR 35 18 40 07 G 62 GE GA 21 GA GO GO GR GT 44 45 GR 52 GJ 10 46 HR HI 13 23 41 HG HP 34 01 91 42 43 28 08 ID IL IM IN IA IS 17 03 JA JK JH 32 36 22 37 46 14 KS KA KY KL KY KE KK 39 43 26 AQ LD LS SP LT LE LC LM 21 LK LI LO LD LA LH LU 92 MC MP MH ME MN MB MN MA MD MS MA MT MT MS MO MH VS ML ME ME MI MI 24 MI MG MN MS MO 04 45 MZ MO MN MT MB MO NL 20 42 NA 29 NA NE 15 NV NB NL NH NJ NM NSW NY 15 64 NC ND NT NT NO NS NL NU NU OA OR OY OG OH 44 33 47 OK OT ON OR OR 27 PD PA PA PB PR PR PV PA PE PG PU PE PC PI PI PT PN PZ PO PE PY PB PB 63 QC QLD QE QR RG RJ RA RC RE RI RI RN RJ RN RS RM RO RR RN RO 41 11 SA SL SC SP SK SS SV SE 61 37 31 14 25 32 22 51 SI SK SI SO SO SO SA SC SD SR TB 71 TM TN TA TAS TG TN TE TR TX 12 TA TL TO 09 36 13 31 16 TP TN TV TS TR TO UD UT UT UP VA VE VE VB VC VT VR VV VI VIC VA VT 30 WA WD WB WA WH WV WX WW WI WY 65 54 06 35 19 YU YT 53 ZA 33 |
Name | EmployerCountryCode |
Label | Employer Country Code |
Type | PICKLIST |
Picklist values | AF AX AL DZ AD AO AI AQ AG AR AM AW AU AT AZ BS BH BD BB BY BE BZ BJ BM BT BO BQ BA BW BV BR IO BN BG BF BI KH CM CA CV KY CF TD CL CN CX CC CO KM CG CD CK CR CI HR CW CY CZ DK DJ DM DO EC EG SV GQ ER EE SZ ET FK FO FJ FI FR GF PF TF GA GM GE DE GH GI GR GL GD GP GT GG GN GW GY HT HM VA HN HU IS IN ID IQ IE IM IL IT JM JP JE JO KZ KE KI KR XK KW KG LA LV LB LS LR LY LI LT LU MO MG MW MY MV ML MT MQ MR MU YT MX MD MC MN ME MS MA MZ MM NA NR NP NL NC NZ NI NE NG NU NF MK NO OM PK PS PA PG PY PE PH PN PL PT QA RE RO RU RW BL SH KN LC MF PM VC WS SM ST SA SN RS SC SL SG SX SK SI SB SO ZA GS SS ES LK SR SJ SE CH TW TJ TZ TH TL TG TK TO TT TN TR TM TC TV UG UA AE GB US UY UZ VU VE VN VG WF EH YE ZM ZW |
Name | EmployerLatitude |
Label | Employer Latitude |
Type | NUMBER(3,15) |
Name | EmployerLongitude |
Label | Employer Longitude |
Type | NUMBER(3,15) |
Name | EmployerGeocodeAccuracy |
Label | Employer Geocode Accuracy |
Type | PICKLIST |
Picklist values | Address NearAddress Block Street ExtendedZip Zip Neighborhood City County State Unknown |
Name | EmployerAddress |
Label | Employer Address |
Type | AUTO NUMBER |
Name | EmployerPhone |
Label | Employer Phone |
Type | PHONE |
Name | StartDate |
Label | Start Date |
Type | DATE |
Name | EndDate |
Label | End Date |
Type | DATE |
Name | HealthcareProvider_Id_1 |
Label | HealthcareProvider_Healthcare Provider ID_1 |
Type | LOOKUP |
Foreign key | Yes |
Parents relationships(12)
Children relationships(7)
Name | Parent object | Child object | Parent object field | Child object field |
---|---|---|---|---|
Owner | User | PersonEmployment |
|
|
CreatedBy | User | PersonEmployment |
|
|
LastModifiedBy | User | PersonEmployment |
|
|
RelatedPerson | Account | PersonEmployment |
|
|
RelatedPerson | Contact | PersonEmployment |
|
|
RelatedPerson | PartyProfile | PersonEmployment |
|
|
REFERENCE_21 | HealthcareProvider | PersonEmployment |
|
|
Object User-defined metadata (0)
Label | Value |
---|