Repository Docs & Knowledge Base

Consolidated Spensara documentation repository (722 Markdown & architecture documents in ../repository)

Built Word Documents (.docx): Spensara Overview (.docx) Capability Assessment (.docx) Brink POS Ingestion Analysis (.docx) The Borg Ingestion Architecture (.docx)

Warehouse Model (93)

Analytical data warehouse schemas, curated tables, and Redshift/Athena data models.

warehouse-model/docs/features/ETL/warehouse-data/brinkPos-curated-model-mapps/pos_tenders.md 6,964 bytes · Updated Oct 23, 2026 10:44 AM EDT

Raw File

Brink mapping for `curated.pos_tenders`

Main staging sources

staging.brink_settings_get_tenders

Mapping groups

Business property mappings describe how Brink tender content is mapped or could be mapped into curated business fields.
Technical and ETL property mappings describe lineage, source reconciliation, tenant scoping, and ingestion metadata.

Business property mappings

Curated Column	Brink Staging Table	Brink Property Path	Current mapping	Status	Notes
`id`	`staging.brink_settings_get_tenders`	`tender_id`	`NULL`	`Not mapped`	Direct tender ID.
`usernumber`	`N/A`	`N/A`	`NULL`	`Not mapped`	No user-visible tender number is documented.
`name`	`staging.brink_settings_get_tenders`	`name`	`NULL`	`Not mapped`	Direct tender name.
`cash`	`staging.brink_settings_get_tenders`	`tender_type`	`NULL`	`Not mapped`	Requires a derived cash-like flag from Brink tender type.
`gcert`	`staging.brink_settings_get_tenders`	`tender_type`	`NULL`	`Not mapped`	Requires a derived gift-certificate/gift-card flag from Brink tender type.
`"change"`	`staging.brink_settings_get_tenders`	`allow_change`	`NULL`	`Not mapped`	Direct change behavior flag.
`reportas`	`staging.brink_settings_get_tenders`	`reconciliation_method`	`NULL`	`Not mapped`	Best documented reporting/reconciliation classification.
`house`	`staging.brink_settings_get_tenders`	`tender_type`	`NULL`	`Not mapped`	Requires a derived house-account style flag from Brink tender type.
`active`	`staging.brink_settings_get_tenders`	`active`	`NULL`	`Not mapped`	Direct active flag.
`tips`	`staging.brink_settings_get_tenders`	`allow_tips`	`NULL`	`Not mapped`	Direct tip-support flag.
`cardtype`	`staging.brink_settings_get_tenders`	`card_type`	`NULL`	`Not mapped`	Direct card type classification.
`fcurrncyid`	`N/A`	`N/A`	`NULL`	`Not mapped`	No foreign-currency identifier is documented.
`accntrcvbl`	`N/A`	`N/A`	`NULL`	`Not mapped`	No accounts-receivable flag is documented.
`cashcard`	`staging.brink_settings_get_tenders`	`tender_type`	`NULL`	`Not mapped`	Requires a derived hybrid tender-family mapping if needed.
`ischeck`	`staging.brink_settings_get_tenders`	`tender_type`	`NULL`	`Not mapped`	Requires a derived check-tender flag from Brink tender type.
`external`	`staging.brink_settings_get_tenders`	`requires_authorization`	`NULL`	`Not mapped`	Closest documented indicator of an externally authorized tender flow.
`debit`	`staging.brink_settings_get_tenders`	`card_type`	`NULL`	`Not mapped`	Requires a derived debit flag from Brink card type.
`giftcard`	`staging.brink_settings_get_tenders`	`tender_type`	`NULL`	`Not mapped`	Requires a derived gift-card flag from Brink tender type.
`iscredtcrd`	`staging.brink_settings_get_tenders`	`card_type`	`NULL`	`Not mapped`	Requires a derived credit-card flag from Brink card type.
`roundactiv`	`N/A`	`N/A`	`NULL`	`Not mapped`	No rounding-active flag is documented.
`roundto`	`N/A`	`N/A`	`NULL`	`Not mapped`	No rounding increment is documented.
`roundmthd`	`N/A`	`N/A`	`NULL`	`Not mapped`	No rounding method is documented on tenders.
`ebt`	`N/A`	`N/A`	`NULL`	`Not mapped`	No EBT flag is documented.
`ebttype`	`N/A`	`N/A`	`NULL`	`Not mapped`	No EBT subtype is documented.
`tdrsurch`	`N/A`	`N/A`	`NULL`	`Not mapped`	No tender surcharge field is documented.
`disloyalty`	`N/A`	`N/A`	`NULL`	`Not mapped`	No disable-loyalty flag is documented.
`iscampus`	`N/A`	`N/A`	`NULL`	`Not mapped`	No campus-payment flag is documented.
`payment_family`	`staging.brink_settings_get_tenders`	`tender_type`	`NULL`	`Not mapped`	Derived standardized family from Brink tender type and card type.
`payment_family_name`	`staging.brink_settings_get_tenders`	`tender_type`	`NULL`	`Not mapped`	Derived readable payment family from Brink tender type and card type.
`is_digital`	`staging.brink_settings_get_tenders`	`tender_type`	`NULL`	`Not mapped`	Derived boolean from standardized payment-family mapping.
`is_cash_equivalent`	`staging.brink_settings_get_tenders`	`tender_type`	`NULL`	`Not mapped`	Derived boolean from standardized payment-family mapping.
`processor_name`	`N/A`	`N/A`	`NULL`	`Not mapped`	No processor name is documented on the tender master.

Technical and ETL property mappings

Curated Column	Brink Staging Table	Brink Property Path	Current mapping	Status	Notes
`tender_key`	`N/A`	`N/A`	`NULL`	`Not mapped`	Warehouse-generated key.
`source_system`	`N/A`	`N/A`	`constant 'brink_pos'`	`Derived constant`	Warehouse constant, not a Brink API field.
`source_tender_id`	`staging.brink_settings_get_tenders`	`tender_id`	`NULL`	`Not mapped`	Direct Brink source ID.
`tenant_key`	`N/A`	`N/A`	`NULL`	`Not mapped`	Warehouse-generated tenant key.
`tenant_name`	`N/A`	`N/A`	`parameter @tenant_id`	`ETL context`	Tenant metadata is outside the documented Brink staging payloads.
`effective_from_utc`	`N/A`	`N/A`	`NULL`	`Not mapped`	No effective-start timestamp is documented on tenders.
`effective_to_utc`	`N/A`	`N/A`	`NULL`	`Not mapped`	No effective-end timestamp is documented on tenders.
`is_current`	`N/A`	`N/A`	`NULL`	`Not mapped`	Warehouse SCD field.
`_etl_batch_id`	staging.brink_settings_get_tenders	_etl_batch_id	`_etl_batch_id`	`Mapped`	ETL metadata propagated from staging.
`_etl_source_type`	staging.brink_settings_get_tenders	_etl_source_type	`_etl_source_type`	`Mapped`	ETL metadata propagated from staging.
`_etl_ingested_at`	staging.brink_settings_get_tenders	_etl_ingested_at_utc	`_etl_ingested_at_utc AS _etl_ingested_at`	`Mapped`	ETL metadata propagated from staging.

Portal and sample validation

Curated field	Additional validated source	How to use it
`name`	`temp/GetTenders_WhenConfigured_CallsRealBrinkEndpoint.xml -> Tenders[].Name`	Sample payload confirms the tender name exists in real Brink responses.
`tips`	`Settings.GetTenders -> Tenders[].MaxTipPercent`	Brink contract exposes richer tip configuration than the current boolean mapping.
`cash`	`Settings.GetTenders -> Tenders[].OpenDrawer`	This is a useful additional behavioral signal for cash-like tenders.
`active`	`Settings.GetTenders -> Tenders[].SignatureCapture / RequiresAuthorization / DefaultAmount / VarianceAmount`	Sample payloads and WSDL confirm extra tender configuration fields that can support future tender-family normalization.