RAIS RAIS 4 Fiche technique télécharger pdf (Page 59)

RAIS 3.0 Programmer’s Guide – Part I : Advanced Customization

57

4.4 Workers

Person

PK PK Person ID

U1 Regulatory Authority Number

Name

Birth Date

FK1,I1 FK Sex ID

RAIS_TIME_STAMP

Person History

PK PK Person History ID

FK4,I4 FK Person ID

FK2,I2 FK Facility ID

FK1,I1 FK Department ID

Status Date

FK5,I5 FK Worker Status ID

FK3,I3 FK Monitoring Status ID

Expe rience

FK6,I6 FK Trustworthiness ID

RAIS_TIME_STAMP

Person History Person Task

PK PK Person History Person Task ID

RAIS_TEMP

FK1,I1 FK Person History ID

FK2,I2 FK Person Task ID

RAIS_TIME_STAMP

Person Professional Degree

PK PK Person Professional De gree ID

FK1,I1 FK Person ID

FK2,I2 FK Professional Degree ID

RAIS_TIME_STAMP

Person Sta tus

PK PK Person Status ID

Status

RAIS_TIME_STAMP

Person Academic Degree

PK PK Person Academic Degree ID

FK1,I1 FK Person ID

FK2,I2 FK Field ID

FK3,I3 FK Branch ID

FK4,I4 FK Academic Qualification Degree ID

RAIS_TIME_STAMP

Person Task Practice

PK PK Person Ta sk Practice ID

RAIS_TEMP

FK1,I1 FK Person Task ID

FK2,I2 FK Practice ID

RAIS_TIME_STAMP

Practice

PK PK Practice ID

Practice Name

FK2,I2 FK Inspection Frequency ID

Inspection Frequency

FK1,I1 FK Practice Category ID

RAIS_TIME_STAMP

Person Task

PK PK Person Task ID

Task

RAIS_TIME_STAMP

Facility

PK PK Facility ID

U1 Regulatory Authority Number

Facility Name

Legal Person

FK3,I3 FK Facility Status ID

FK2,I2 FK Region ID

FK1,I1 FK District ID

Address

Phone

Fax

RAIS_TIME_STAMP

Depa rtment

PK PK Department ID

U1 Regulatory Authority Number

Department Name

Legal Person

FK4,I4 FK Department Status ID

FK3,I3 FK Facility ID

FK1,I1 FK Region ID

FK2,I2 FK District ID

Address

Phone

Fax

RAIS_TIME_STAMP

Monitoring Status

PK PK Monitoring Status ID

Status

RAIS_TIME_STAMP

4.5 Inspections

Inspection

PK PK Inspection ID

U1 Inspection No

FK2,I2 FK Facility ID

FK1,I1 FK Department ID

FK3,I3 FK Regular Inspection ID

FK4,I4 FK Full Inspection ID

FK5,I5 FK Announced Insption ID

RAIS_TIME_STAMP

Inspection History

PK PK Inspection History ID

FK2,I2 FK Inspection ID

Status Date

FK1,I1 FK Inspection Status ID

Comments

RAIS_TIME_STAMP

Inspection History Officer

PK PK Inspection History Officer ID

RAIS_TEMP

FK1,I1 FK Inspection History ID

FK2,I2 FK Officer ID

RAIS_TIME_STAMP

Facility

PK PK Facility ID

U1 Regulatory Authority Number

Facility Name

Legal Person

FK3,I3 FK Facility Status ID

FK2,I2 FK Region ID

FK1,I1 FK District ID

Address

Phone

Fax

RAIS_TIME_STAMP

Department

PK PK Department ID

U1 Regulatory Authority Number

Department Name

Legal Person

FK4,I4 FK Department Status ID

FK3,I3 FK Facility ID

FK1,I1 FK Region ID

FK2,I2 FK District ID

Address

Phone

Fax

RAIS_TIME_STAMP

Inspection Non-Compliance

PK PK Inspection Non-Compliance ID

RAIS_TEMP

FK1,I1 FK Inspection ID

FK2,I2 FK Non-Compliance ID

RAIS_TIME_STAMP

Inspection Status

PK PK Inspection Status ID

Inspection Status

RAIS_TIME_STAMP

Inspection Asso

PK PK Inspection Asso ID

RAIS_TEMP

FK1,I1 FK Inspection ID

FK2,I2 FK Asso ID

RAIS_TIME_STAMP

Officer

PK PK Officer ID

Officer Name

FK2,I2 FK Sex ID

FK1,I1 FK Authority ID

RAIS_TIME_STAMP

Inspection Generator

PK PK Inspection Generator ID

RAIS_TEMP

FK1,I1 FK Inspection ID

FK2,I2 FK Generator ID

RAIS_TIME_STAMP

Inspection Sealed

PK PK Inspection Sealed ID

RAIS_TEMP

FK1,I1 FK Inspection ID

FK2,I2 FK Sealed ID

RAIS_TIME_STAMP

Inspection Unsealed

PK PK Inspection Unsealed ID

RAIS_TEMP

FK1,I1 FK Inspection ID

FK2,I2 FK Unsealed ID

RAIS_TIME_STAMP

Non-Compliance

PK PK Non-Compliance ID

Name

FK1,I1 FK Category ID

RAIS_TIME_STAMP

1 2 ... 54 55 56 57 58 59 60 61

Commentaires sur ces manuels

Pas de commentaire