Designer - Available Database FieldsDesigner – Available Database Fields

With IDpack, database management is handled automatically. You do not need to create or manage database tables yourself. Simply select the fields you need for data collection from our library of 132 available database fields. These fields can be used in Designer, Producer, imports, exports, and badge designs. Each project has its own Field Definitions, allowing you to customize the data structure for each project.

Need a field that is not listed? Request a custom field here.

Field Definitions (132)

Field DescriptionField Content ExampleAPI Field nameShortcodesField Type
AC ID34535idc_ac_id[ac_id]varchar(25)
Access4 P 2idc_access[access]varchar(75)
Address5555 Pacific Hill Ave, Los Angeles, CA, 90001idc_address[address]varchar(250)
Age24idc_age[age]decimal(10)
Allergieseggs, milk, peanutsidc_allergies[allergies]varchar(150)
Apartment NumberAAFidc_apartment_nb[apartment_nb]varchar(150)
AuthorizationR4idc_authorization[authorization]varchar(50)
BatchBC234IDidc_batch[batch]varchar(50)
Birthdate1970-25-04idc_birthdate[birthdate]date()
Blood TypeA RH NEGidc_bloodtype[bloodtype]varchar(25)
BrandBrand Nameidc_brand[brand]varchar(75)
Card verification value (CVV)524idc_cvv[cvv]int(4)
Category #1Coloridc_category1[category1]varchar(150)
Category #2Couleuridc_category2[category2]varchar(150)
Certifying InstructorJohn Malcomidc_certifying_instructor[certifying_instructor]varchar(150)
CityLos Angelesidc_city1[city1]varchar(150)
Civic Number345idc_civic_number1[civic_number1]varchar(150)
ClassAidc_class[class]varchar(75)
Club ID4581idc_club_id[club_id]varchar(150)
Cost187.79idc_cost[cost]decimal(10.2)
CountryUSidc_country1[country1]char(30)
Country NameUnited Statesidc_country_name[country_name]varchar(150)
CourseOneidc_course[course]varchar(250)
Course DateJan 17, 2023idc_course_date[course_date]date()
Coverage TypeEEidc_coverage_type[coverage_type]varchar(75)
CurrencyUSDidc_currency[currency]varchar(30)
Current Year2023idc_current_year[current_year]varchar(4)
DepartmentArtsidc_department[department]varchar(150)
Depth1.38idc_depth[depth]decimal(10.2)
Description3ft x 3ft Natural Oak Extending Dining Tableidc_description[description]varchar(250)
DivisionFinanceidc_division[division]varchar(150)
Driver's licenseTS-234-34534-103idc_driver[driver]varchar(100)
Email[email protected]idc_email[email]varchar(150)
Emergency ContactJulie Smith, (345) 555-2342idc_emergency_contact[emergency_contact]varchar(150)
Employee ID1234idc_employee_id[employee_id]varchar(150)
EncryptionWPAidc_encryption[encryption]varchar(150)
Expiration Date1998-19-02idc_expirationdate[expirationdate]date()
Eye colorBrownidc_eyecolor[eyecolor]smallint(3)
Fax Number (Home)213-555-8317idc_homefax[homefax]decimal(15)
Fax Number (Work)213-555-5219idc_workfax[workfax]decimal(15)
Feature #1Oakidc_feature1[feature1]varchar(25)
Feature #2Rectangleidc_feature2[feature2]varchar(25)
Feature #3Double Pedestalidc_feature3[feature3]varchar(25)
Feature #4Butterfly Extensionsidc_feature4[feature4]varchar(25)
Feature #5Wood and Steelidc_feature5[feature5]varchar(25)
First NameSteveidc_firstname[firstname]varchar(150)
Full NameSteve Smithidc_fullname[fullname]varchar(300)
Function #1Journalistidc_function1[function1]varchar(75)
Function #2Sportsidc_function2[function2]varchar(75)
GAMW (Authorizer)1234567890idc_gamw_id_authorizer[gamw_id_authorizer]int(10)
GAMW #1234567890idc_gamw_id[gamw_id]int(10)
GenderMaleidc_gender[gender]int(1)
Grade9th – Freshmanidc_grade[grade]varchar(75)
Group102idc_group[group]varchar(25)
Hair colorBlackidc_haircolor[haircolor]smallint(3)
Height6.05idc_height[height]varchar(15)
Injection 108/23/2021idc_injection1[injection1]date()
Injection 210/23/2021idc_injection2[injection2]date()
Issue DateSep 04, 2024idc_issuedate[issuedate]date()
LanguageENidc_language1[language1]varchar(30)
Last NameSmithidc_lastname[lastname]varchar(150)
Law 9idc_law_9[law_9]varchar(20)
Length15.50idc_length[length]decimal(10.2)
LocationBUILDING Aidc_location[location]varchar(75)
Medical StateGoodidc_medical_state[medical_state]varchar(50)
Medical Status5idc_medical_status[medical_status]varchar(25)
Member ID9012idc_member_id[member_id]varchar(150)
MSRP399.95idc_msrp[msrp]decimal(10.2)
Network NameSSIDidc_network_name[network_name]varchar(150)
NicknameMaverickidc_nickname[nickname]varchar(150)
NotesMy best friend!idc_notes[notes]text(1024)
Number of Cards2idc_nb_cards[nb_cards]smallint(3)
Order ID701-0253509-5186632idc_order_id[order_id]varchar(50)
OrganizationACME Example inc.idc_organization[organization]varchar(150)
Parent's first and last nameJohn Smithidc_parent_fullname[parent_fullname]varchar(250)
Passport #VG89103idc_passport[passport]varchar(25)
Password05#Y6NbBeX&?xl#2idc_pw[pw]varchar(150)
Permit #DR89823489234-CAidc_permit_nb[permit_nb]varchar(150)
Personal Identification Number (PIN)4593idc_pin_nb[pin_nb]varchar(150)
Phone Number (Home)213-555-8317idc_homephone[homephone]decimal(15)
Phone Number (Mobile)213-555-3453idc_mobilephone[mobilephone]decimal(15)
Phone Number (Work)213-555-9834idc_workphone[workphone]decimal(15)
PPA Expiration Date1998-19-02idc_expirationdate_ppa[expirationdate_ppa]date()
Price299.99idc_price[price]decimal(10.2)
Price Type/eachidc_pricetype[pricetype]smallint(3)
Product NameWOW Dining Tableidc_productname[productname]varchar(75)
Pronounshe/himidc_pronouns[pronouns]varchar(40)
QR coded174172a-ab34-4e4a-a88b-2076bd6e0db1a19b901b- ...idc_qrcode[qrcode]text(2048)
Race/GenderW/Fidc_race_gender[race_gender]varchar(50)
RankChiefidc_rank[rank]varchar(25)
RegionNassau Countyidc_region[region]varchar(150)
Registration Site23idc_registration_site[registration_site]varchar(25)
Resident ID3455467idc_resident_id[resident_id]varchar(25)
Residential DistrictVeniceidc_residential_district[residential_district]varchar(150)
ResultNEGATIVEidc_result[result]smallint(3)
Retraining DateJan 17, 2024idc_retraining_date[retraining_date]date()
RFID5737226704idc_rfid[rfid]varchar(36)
RFID Card TypeMIFARE Classicidc_rfid_cardtype[rfid_cardtype]varchar(25)
RFID CSN (Card Serial Number)7820706idc_rfid_csn[rfid_csn]varchar(75)
RFID JSON{"type": "MIFARE Classic","csn": "7820706"}idc_rfid_json[rfid_json]varchar(512)
Ship toMontreal, QCidc_ship_to[ship_to]varchar(75)
Shooting touridc_shooting_tour[shooting_tour]varchar(60)
SKUWDT950aidc_sku[sku]varchar(25)
SportOpen Water Swimmingidc_sport_en[sport_en]varchar(150)
Start Date2021-03-30idc_start_date[start_date]date()
State/ProvinceCAidc_state1[state1]varchar(150)
StatusActiveidc_status[status]varchar(50)
Street #15555 Pacific Hill Aveidc_street11[street11]varchar(150)
Street #2Suite #734idc_street21[street21]varchar(150)
Task #1Greetingidc_task1[task1]varchar(50)
Task #2Alumni Fairidc_task2[task2]varchar(50)
TeamAmigosidc_team_name1[team_name1]varchar(75)
Test Date09/28/2021idc_test_date[test_date]date()
Test NameCOVID-19idc_test_name[test_name]varchar(75)
Testing Equipment MakeBobcatidc_testing_equipment_make[testing_equipment_make]varchar(150)
Testing Equipment ModelCompact Track Loadersidc_testing_equipment_model[testing_equipment_model]varchar(150)
Title #1Chief Executive Officeridc_title1[title1]varchar(150)
Title #2Chief Technology Officeridc_title2[title2]varchar(150)
Tracking NumberLL 123 2431 34 PCidc_tracking_number[tracking_number]varchar(75)
Type #1Mediaidc_type1[type1]varchar(75)
Type #2Mediaidc_type2[type2]varchar(75)
Unique URLhttps://www.example.com/?id=234234idc_url[url]varchar(250)
UPC028611000059idc_upc[upc]decimal(12)
VaccineCOVID-19idc_vaccine[vaccine]varchar(50)
vCardBEGIN:VCARD ...idc_vcard[vcard]text(0)
VIP1idc_vip[vip]int(1)
WarehouseUnit Aidc_warehouse[warehouse]varchar(75)
Websitehttps://www.example.comidc_website[website]varchar(250)
Weight180.50idc_weight[weight]decimal(10.2)
Width2.25idc_width[width]decimal(10.2)
ZIP/Postal Code90001idc_zip1[zip1]varchar(15)
ZoneArea 51idc_zone[zone]varchar(75)