database catcom
screen size 24 by 80
{


   Site     Extn Group   [f002                ] Parent Grp    Extn
  [f000]    [f001    ]   [f003                ] [f004    ]   [f005  ]
 ------------------------------------------------------------------------------ 
   Surname            First Name    Title          Telephone [f009      ]
  [f006           ]  [f007      ]  [f008                                    ]

   Emp ID             Section            Division  Location  
  [f010      ]       [f011          ]   [f12]     [f013                     ]

   Fax Number         Mobile             Pager          Voice Mail
  [f014      ]       [f015      ]       [f016       ]  [f017                ]

 ------------------------------------------------------------------------------ 
   TEC           Instrument                 EquipType   Job Number
  [f018      ]  I________________________I  [f019  ]   [f020                ]
   Bundle I______________________________I
   E-Mail                                               Updated         Listed
  [f021                                              ] [upddate   ]       [a]
}
end

tables
directtemplate
directcustom
end

attributes
f000 = directtemplate.site[1,4], required, upshift,
	comments = "Enter Valid Site Name";
f001 = directtemplate.extgroupunique, required, upshift,
	comments = "Enter Valid Extension Group";
f002 = FORMONLY.grname1, NOENTRY;
f003 = FORMONLY.grname2, NOENTRY;
f004 = FORMONLY.pargrid, NOENTRY;
f005 = directtemplate.extension, required,
	comments = "Enter Extension Number  - Valid Chararacters Are: 0-9";

f006 = directcustom.surname[1,15], upshift,
    comments = "Enter Surname  - Valid Characters Are: Spaces '-./ A-Z";
f007 = directcustom.firstname, upshift,
    comments = "Enter Prefname  - Valid characters Are: Spaces '-/ 0-9 A-Z";
f008 = directcustom.title, upshift,
    comments = "Enter Title";
f009 = directcustom.telephone,  upshift,
    comments = "Enter Telephone number ";

f010 = directcustom.empid, upshift,
    comments = "Enter Employee number";
f011 = directcustom.section,  upshift,
    comments = "Enter Section";
f12 = directcustom.division,  upshift,
    comments = "Enter Division";
f013 = directcustom.location,  upshift,
    comments = "Enter Location";

f014 = directcustom.faxno, upshift,
    comments = "Enter Fax number";
f015 = directcustom.mobile,  upshift,
    comments = "Enter Mobile number";
f016 = directcustom.pager,  upshift,
    comments = "Enter Access Pager number";
f017 = directcustom.voicemail,  upshift,
    comments = "Enter Voice Mail";

f018 = directtemplate.firstinit[1,10], noentry,
    comments = "Telephone Equipment Code";
f019 = directtemplate.equip_type[1,6],  upshift,
    comments = "Enter Equipment Type";
f020 = directcustom.jobno, upshift,
    comments = "Enter Job Number";

f021 = directcustom.email, COMMENTS = "Enter E-Mail Address";
upddate = directcustom.date_updated, NOENTRY, NOUPDATE;
a    = directtemplate.secure_code, upshift, include = ("Y", "N"), default = "Y",
	comments = "Enter (Y)es Or (N)o For Listed On Enquiry";

end