Entity Definition

Logical Name : TaxCertificateProgramCoverage
Physical Name : CO_TX_CF_PRGM_CVG

An association Tax certificate programs and the issued tax certificates that are applicable to them.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
IssuedToPartyID (FK)(PK) A unique, system assigned identity for a Party. ID_PRTY_ISS_TO Identity integer TaxCertificate(PA_TX_CF)
TaxCertificateSequenceNumber (FK)(PK) A sequential counter used to uniquely identify a tax certificate for a specific party. AI_PA_TX_CF LineNumber smallint TaxCertificate(PA_TX_CF)
TaxCertificateProgramID (FK)(PK) A system assigned unique identifier fo a tax certificate program. ID_TX_CF_PRGM Identity integer TaxCertificateProgram(CO_TX_CF_PRGM)


Parent Entity Verb Phrase Child Entity
TaxCertificateProgram covers TaxCertificateProgramCoverage
TaxCertificate is covered by TaxCertificateProgramCoverage

Logical Views containing TaxCertificateProgramCoverage

Logical View
Logical 02341 - Retail Transaction - Change for Charities View
Logical 05050 - Taxation - Registration and Certification View