!   MEGA_FIELDS.CDO
!
!   Script file to define all fields specific to the Mega
!   Zillionare demonstration application.
!
DEFINE FIELD CDD_FIELDS.DRAW_DT
    DESCRIPTION IS /*Date of Mega Zillionare Drawing FORMAT YYYYMMDD*/
    DATATYPE IS TEXT
    SIZE IS 8 CHARACTERS.

DEFINE FIELD CDD_FIELDS.DRAWING_NO
    DESCRIPTION IS /*Number in Mega Zillionare drawing*/
    DATATYPE IS LONGWORD.

DEFINE FIELD CDD_FIELDS.NO_1
    BASED ON CDD_FIELDS.DRAWING_NO.

DEFINE FIELD CDD_FIELDS.NO_2
    BASED ON CDD_FIELDS.DRAWING_NO.


DEFINE FIELD CDD_FIELDS.NO_3
    BASED ON CDD_FIELDS.DRAWING_NO.


DEFINE FIELD CDD_FIELDS.NO_4
    BASED ON CDD_FIELDS.DRAWING_NO.


DEFINE FIELD CDD_FIELDS.NO_5
    BASED ON CDD_FIELDS.DRAWING_NO.

DEFINE FIELD CDD_FIELDS.MEGA_NO
    DESCRIPTION IS /*Super Duper Mega number part of drawing*/
    DATATYPE IS LONGWORD.


DEFINE FIELD CDD_FIELDS.ELM_NO
    DESCRIPTION IS /*Valid number in drawing currently 1-52*/
    DATATYPE IS LONGWORD.


DEFINE FIELD CDD_FIELDS.HIT_COUNT
    DESCRIPTION IS /*Count of drawings number has appeared in*/
    DATATYPE IS LONGWORD.

DEFINE FIELD CDD_FIELDS.LAST_DRAW_NO
    DESCRIPTION IS /*Last drawing this number appeared in*/
    DATATYPE IS LONGWORD.

DEFINE FIELD CDD_FIELDS.SINCE_LAST
    DESCRIPTION IS /*Count of drawing since number last appeared*/
    DATATYPE IS LONGWORD.

DEFINE FIELD CDD_FIELDS.CURR_SEQ
    DESCRIPTION IS /*Current count of hits in a row for this number*/
    DATATYPE IS LONGWORD.

DEFINE FIELD CDD_FIELDS.LONGEST_SEQ
    DESCRIPTION IS /*longest sequence of hits in a row*/
    DATATYPE IS LONGWORD.

DEFINE FIELD CDD_FIELDS.PCT_HITS
    DESCRIPTION IS /*Percentage of hits relative to total drawings*/
    DATATYPE IS G_FLOATING.

DEFINE FIELD CDD_FIELDS.MAX_BTWN
    DESCRIPTION IS /*Maximum number of drawings between hits*/
    DATATYPE IS LONGWORD.

DEFINE FIELD CDD_FIELDS.AVE_BTWN
    DESCRIPTION IS /*Average number of drawings between hits**/
    DATATYPE IS G_FLOATING.

COMMIT