Entity Definition

Logical Name : WorkerCertificate
Physical Name : DO_CF_WRKR

An official document issued by a government or professional body that records the fact that a particular Worker is permitted to perform certain Tasks.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
WorkerID (FK)(PK) A unique system-assigned identifier for the Person who is a particular Worker. ID_WRKR Identity integer Worker(PA_WRKR)
WorkerCertificationTypeID (FK)(PK) A unique system-assigned identifier for a particular kind of WorkerCertification. CD_TYP_CF_WRKR Identity integer WorkerCertificationType(CO_TYP_CF_WRKR)
WorkerCertificationIssuingBodyID (FK) A unique retailer assigned identifier for the government or professional body that issues WorkerCertificates. ID_BDY_WRKR_CD_ISSG Identity integer WorkerCertificationIssuingBody(PA_BDY_WRKR_CF_ISSG)
CertificateID The sequence number printed on the document that differentiates this particular WorkerCertificate from others issued by the same WorkerCertificationIssuingBody. ID_CF Name varchar(40)
CertificationDate The date this WorkerCertificate was issued. DC_CF DateCalendar date
EffectiveDate The date from which this WorkerCertificate is valid. DC_EF EffectiveDate date
ExpirationDate The date from which this WorkerCertificate ceases to be valid. DC_EP ExpirationDate date


Parent Entity Verb Phrase Child Entity
Worker has WorkerCertificate
WorkerCertificationType classifies WorkerCertificate
WorkerCertificationIssuingBody issues WorkerCertificate

Logical Views containing WorkerCertificate

Logical View
Logical 11100 - Worker - Macro View
Logical 11120 - Worker - Job Definition View