Data Types

carrot understands many rich data types, including standard types such as number docid\ uci5tctfvbhonej6zqijg and string docid\ ujw2aqaktel5uuklup73s that are common across systems, as well as a number of charthop specific data types basic data types these data types are basic building blocks of the system type description example syntax boolean docid\ kdvwa4opcqwedhpycth4l a true or false value (also known as "yes or no") true currency docid\ hyeq9eu9e7la rvhqtfvg a national currency, such as the dollar or euro date docid\ xtaqdzvlbtakjxrnpfwe9 a date, independent of time date('2025 01 01') enum docid\ untq2eal5rmipnyczvfw1 a multiple choice value selected by a user enum("meets expectations") image docid\ cmmcm qq2nl58kzvv7xzt an image stored on the charthop system money docid ks5d2xbfor9d8wfrivny a monetary value, including currency and amount money(1000, 'usd') list docid\ xwh cukhj9waqaefb7h71 represents a list of any other value \[1, 2, 3] null docid\ n9trvqonnbknql9drnbp6 an empty value that means "data not set" null number docid\ uci5tctfvbhonej6zqijg a number, either decimal or integer 42 123 percent docid\ fbn7bfahlfpv4f1c53dxa a percentage value 42% string docid\ ujw2aqaktel5uuklup73s a piece of text "hello, world!" timestamp docid\ j1ufztc3 yprdi3ucin3u a moment in time (both date and time, timezone independent) charthop data types these data types represent more complex structures that can be used inside other fields type description address docid\ khi0d64z7evk0dsm gjwf a mailing address, including street address, city, and postal code name docid\ w1goorp7tqsqzcwiq8hzs the name of a person, including first, last, and preferred names payinterval docid\ yknkn59i xjwtq9io i3 a recurring pay rate, such as an hourly or yearly salary variablecomp docid\ ny nabmax4hu45w8svldt target variable compensation, such as an annual bonus or commission target charthop entity types these data types represent important objects within the charthop data model entity type description comp band docid\ pkteib crl7fmv5yfpshv a compensation band used to describe pay levels file docid\ lt2ej7nqsjhebkll5xmaz a file that has been uploaded into the charthop system, such as a document group docid 7kum4sl wt2y ldfmo6qb an organizational unit comprising jobs and people, such as a department, location, or team job docid 09ad2ikreizwa j0dfobm a set of responsibilities represented as a box on the org chart person docid\ bzrx1mtdjk8cgkaw7ujqj a person, such as an employee stockgrant docid 8qnjloyooo5jnp4x2pucn an equity or stock option grant issued to a person timeoff docid\ rahsihytvr1nskqtdfkja time off requested or taken by a person, including paid and unpaid leave user docid 6hg3wvt0l2n5ebyfdu tc a user of the charthop system this often represents the user identity of a corresponding person docid\ bzrx1mtdjk8cgkaw7ujqj , but also might be an app or an external user who is not part of the organization