Using QMF

Q.PROJECT

This table provides information about project schedules. The columns are as follows:

PROJNO

Number of the project (must be unique)

PRODNUM

Number of the product

DEPT

Number of the department responsible for the project

STARTD

Date the project is to start

ENDD

Date the project is to end

TIMESTAMP

Year, month, day, and time of the report

This table is for installations that support date/time data. It shows dates and times in ISO format. This format is an arbitrary choice. The table you see depends on the choice made by your installation.

   PROJNO  PRODNUM    DEPT  STARTD      ENDD        TIMESTAMP        
   ------  -------  ------  ----------  ----------  --------------------------
   1401         10      20  1996-01-01  1998-03-31  1994-12-18-10.14.44.000001
   1402         50      66  1996-01-30  1997-06-30  1994-12-18-10.15.01.999998
   1403        150      51  1996-02-02  1999-05-29  1994-12-18-10.22.23.000001
   1404        190      38  1997-01-04  1999-06-30  1994-12-18-10.25.43.999999
   1405        160      15  1997-04-29  1999-10-30  1995-12-31-14.23.00.999999
   1406         20      20  1997-07-11  1998-12-31  1996-01-05-13.31.18.009999
   1407         50      42  1997-12-12  2000-06-15  1996-01-05-13.42.27.000000
   1408         30      42  1999-03-13  2000-09-30  1996-01-05-13.44.16.999999
   1409         10      66  1998-06-15  1999-12-31  1996-03-13-09.12.57.149572
   1410        190      10  1998-09-29  2000-03-31  1996-03-13-12.18.23.402917
   1501         30      51  1999-01-04  1999-12-31  1996-03-13-12.22.14.201966
   1502        150      38  1999-03-01  2000-07-17  1996-03-13-13.17.48.948276