EM Database (Employee)

Field	Contents	Description
EMP_NUM	20 characters right aligned	User ID entered in the User dialog
PRE_NAME	4 characters left aligned	Title such as Mr., Ms., or Mrs.
FRST_NAME	10 characters left aligned	First name
MID_NAME	10 characters left aligned	Middle name
LAST_NAME	20 characters left aligned	Surname
POST_NAME	10 characters left aligned	Designation
BIRTH_DATE	8 character date	Birth date
S_DATE	8 character date	Start date
SIN	11 characters	Social insurance number
ADDR1	40 characters	Address line 1
ADDR2	40 characters	Address line 2
CITY	25 characters	City
PROV	20 characters	Province
COUNTRY	3 characters	Country
PT_CODE	10 characters	Postal or zip code
PHONE1	17 characters	Phone number 1
PHONE2	17 characters	Phone number 2
COST_RATE	7 digits and 2 decimal places	Plan rate entered in the Users dialog
STD_RATE	7 digits and 2 decimal places	Standard rate entered in the Users dialog
EMAIL	100	Email address
UNUSED		Unused
IDATE	8	Date employee made inactive
EXINFO	10	Memo used for reports
TGUID
CWGUID	22 characters	For internal purposes only. Unique identifier, created when the record is appended.
CWDATE	14	Marks date and time of database changes.
CREATED ON	14	Marks date the record was created.