Assignment Date Table

From edegan.com
Jump to navigation Jump to search

Table Purpose

Table Structure

             Table "public.assignmentdate"
   Column     |          Type          | Modifiers 
--------------+------------------------+-----------
reelno        | integer                | 
frameno       | integer                | 
recdate       | date                   | 
actionkeycode | character varying(500) | 
trandate      | date                   | 
dateproduced  | date                   | 

Example of table entries:

reelno | frameno |  recdate   | actionkeycode |  trandate  | dateproduced 
-------+---------+------------+---------------+------------+--------------
 39090 |     698 | 2016-07-07 | DA            | 2016-07-08 | 2013-11-01
 39092 |     620 | 2016-07-07 | DA            | 2016-07-08 | 2013-11-01
 39090 |     667 | 2016-07-07 | DA            | 2016-07-08 | 2013-11-01
 39090 |     676 | 2016-07-07 | DA            | 2016-07-08 | 2013-11-01
 39090 |     740 | 2016-07-07 | DA            | 2016-07-08 | 2013-11-01
 39092 |     129 | 2016-07-07 | DA            | 2016-07-08 | 2013-11-01
 39090 |     591 | 2016-07-07 | DA            | 2016-07-08 | 2013-11-01
 39090 |     664 | 2016-07-07 | DA            | 2016-07-08 | 2013-11-01
 39094 |      73 | 2016-07-07 | DA            | 2016-07-08 | 2013-11-01
 39094 |      38 | 2016-07-07 | DA            | 2016-07-08 | 2013-11-01

Table Variables

Current Problems