The Employee Assignment Table: DSN8810.EMPPROJACT

The Employee Assignment Table: DSN8810.EMPPROJACT

DSN8810.EMPPROJACT details which employee performs which activity for each project. It effectively records the assignment of employees to a given activity for a given project. To accomplish this assignment, the table stores an employee number, a project number, and an activity number on every row, along with information about this employee's assignment. This additional information consists of the percentage of time the employee should spend on this activity, the date the activity starts, and the date the activity ends. No primary key is implemented, but a unique index is used on the combination of PROJNO , ACTNO , EMSTDATE , and EMPNO .

The table is a child of both DSN8810.PROJACT and DSN8810.EMP . Two indexes exist for this table: DSN8810.XEMPPROJACT1 is a unique index on PROJNO , ACTNO , EMSTDATE , and EMPNO ; and DSN8810.XEMPPROJACT2 is an index on EMPNO .

DSN8810.EMPPROJACT Table DDL

 CREATE TABLE DSN8810.EMPPROJACT  (EMPNO             CHAR(6)        NOT NULL,   PROJNO            CHAR(6)        NOT NULL,   ACTNO             SMALLINT       NOT NULL,   EMPTIME           DECIMAL(5,2),   EMSTDATE          DATE,   EMENDATE          DATE,   FOREIGN KEY REPAPA (PROJNO, ACTNO, EMSTDATE)     REFERENCES DSN8810.PROJACT ON DELETE RESTRICT,   FOREIGN KEY REPAE (EMPNO)     REFERENCES DSN8810.EMP ON DELETE RESTRICT ) IN DSN8D81A.DSN8S81P CCSID EBCDIC;