I7 (1 points)
https://knobit.org/id/task/dm-physical-postgres/I7
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/I7 |
| rdfs:label | I7 (1 points) en |
| schema:hasPart | dm-physical-postgres I7: meaningful loan_id printed as the loan number |
| schema:identifier | I7 |
| schema:position | 11 |
| schema:text | Surrogate value with meaning: loan_id is built from the drawdown date and a daily sequence and printed on agreements and statements as the loan number. Fixed by making loan_id a meaningless identity value never shown to customers and adding loan_number as its own column with a unique constraint (BR-308, AP-4), existing values migrated into it. en |
Used by
| has question | Retail banking servicing schema on PostgreSQL (transactional physical design anomaly skills) |
|---|---|
| schema:isPartOf | dm-physical-postgres I7: meaningful loan_id printed as the loan number |