Data Types

carrot understands many rich data types, including standard types such as docid\ uci5tctfvbhonej6zqijg and 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 docid\ kdvwa4opcqwedhpycth4l a true or false value (also known as "yes or no") true docid\ hyeq9eu9e7la rvhqtfvg a national currency, such as the dollar or euro docid\ xtaqdzvlbtakjxrnpfwe9 a date, independent of time date('2025 01 01') docid\ untq2eal5rmipnyczvfw1 a multiple choice value selected by a user enum("meets expectations") docid\ cmmcm qq2nl58kzvv7xzt an image stored on the charthop system docid ks5d2xbfor9d8wfrivny a monetary value, including currency and amount money(1000, 'usd') docid\ xwh cukhj9waqaefb7h71 represents a list of any other value \[1, 2, 3] docid\ n9trvqonnbknql9drnbp6 an empty value that means "data not set" null docid\ uci5tctfvbhonej6zqijg a number, either decimal or integer 42 123 docid\ fbn7bfahlfpv4f1c53dxa a percentage value 42% docid\ ujw2aqaktel5uuklup73s a piece of text "hello, world!" 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 docid\ khi0d64z7evk0dsm gjwf a mailing address, including street address, city, and postal code docid\ w1goorp7tqsqzcwiq8hzs the name of a person, including first, last, and preferred names docid\ yknkn59i xjwtq9io i3 a recurring pay rate, such as an hourly or yearly salary 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 docid\ pkteib crl7fmv5yfpshv a compensation band used to describe pay levels docid\ lt2ej7nqsjhebkll5xmaz a file that has been uploaded into the charthop system, such as a document docid 7kum4sl wt2y ldfmo6qb an organizational unit comprising jobs and people, such as a department, location, or team docid 09ad2ikreizwa j0dfobm a set of responsibilities represented as a box on the org chart docid\ bzrx1mtdjk8cgkaw7ujqj a person, such as an employee docid 8qnjloyooo5jnp4x2pucn an equity or stock option grant issued to a person docid\ rahsihytvr1nskqtdfkja time off requested or taken by a person, including paid and unpaid leave docid 6hg3wvt0l2n5ebyfdu tc a user of the charthop system this often represents the user identity of a corresponding docid\ bzrx1mtdjk8cgkaw7ujqj , but also might be an app or an external user who is not part of the organization