I12 (1 points)
https://knobit.org/id/task/dm-physical-postgres/I12
Also as Turtle · JSON-LD · RDF/XML
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
|---|---|
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/task/dm-physical-postgres/I12 |
| rdfs:label | I12 (1 points) en |
| schema:hasPart | dm-physical-postgres I12: nullable channel on the payment volume join |
| schema:identifier | I12 |
| schema:position | 16 |
| schema:text | Nullable foreign key on a reporting join path: payment.channel_id is null for payments generated by standing orders (BR-314), and v_payment_volume_by_channel inner-joins payment_channel, so those payments drop out of the bank's daily volume. Fixed by an outer join with a label for payments with no channel, the nullability kept because BR-314 makes it true; a documented not-applicable channel row with the column made not null also passes. en |
Used by
| has question | Retail banking servicing schema on PostgreSQL (transactional physical design anomaly skills) |
|---|---|
| schema:isPartOf | dm-physical-postgres I12: nullable channel on the payment volume join |