Skip to content

app.import_mapping_profiles

TableRow level security on

Saved column maps that make a repeat import one click (Section 4.6.2).

Primary key: id

Columns of app.import_mapping_profiles
ColumnTypeNullableDescription
iduuidNoPrimary key, UUID v7.
org_iduuidNoOwning org. A row never moves to another org.References app.organizations.id
target_codetextNoTarget the profile maps onto.References private.import_targets.code
nametextNoProfile name, such as Crew roster from payroll export.
created_attimestamp with time zoneNoWhen the row was inserted. Set by the database.
created_byuuidYesPerson who inserted the row, or null for a platform process. Set by the database.References app.people.id
updated_attimestamp with time zoneNoWhen the row last changed. Set by the database.
updated_byuuidYesPerson who last changed the row, or null for a platform process. Set by the database.References app.people.id
deleted_attimestamp with time zoneYesSoft delete time. A row with deleted_at set is ignored by every access helper.