SYSTEM 2000 Database Definition for Database EMPLOYEE

The descriptor files created and used in this documentation are based on the complete database definition for the database EMPLOYEE:
Database Definition for Database EMPLOYEE
  SYSTEM RELEASE NUMBER  11.6A
  DATA BASE NAME IS      EMPLOYEE
  DEFINITION NUMBER             2
  DATA BASE CYCLE NUMBER       25
       1*  EMPLOYEE NUMBER (INTEGER NUMBER 9999)
       2*  LAST NAME (CHAR X(10) WITH  FEW FUTURE OCCURRENCES )
       3*  FORENAME (NON-KEY CHAR X(20))
       4*  HIRE DATE (DATE)
       5*  BIRTHDAY (DATE)
       6*  SOCIAL SECURITY NUMBER (NON-KEY CHAR X(11))
       7*  SEX (CHAR X(6) WITH MANY FUTURE OCCURRENCES )
       8*  ETHNIC ORIGIN (CHAR X(9) WITH SOME FUTURE OCCURRENCES )
       9*  EMPLOYEE STATUS (CHAR X(9) WITH MANY FUTURE OCCURRENCES )
      10*  OFFICE-EXTENSION (NON-KEY CHAR X(9))
      11*  ACCRUED VACATION (NON-KEY DECIMAL NUMBER 999.99)
      12*  ACCRUED SICK LEAVE (NON-KEY DECIMAL NUMBER 999.99)
      13*  SECURITY CLEARANCE (INTEGER NUMBER 999 WITH MANY FUTURE OCCURRENCES )
      14*  STREET ADDRESS (NON-KEY CHAR X(20))
      15*  CITY-STATE (NON-KEY CHAR X(15))
      16*  ZIP CODE (CHAR X(5) WITH  FEW FUTURE OCCURRENCES )
     100*  POSITION WITHIN COMPANY (RECORD)
       101*  POSITION TITLE (NON-KEY CHAR X(10) IN 100)
       102*  DEPARTMENT (CHAR X(14) IN 100 WITH SOME FUTURE OCCURRENCES )
       103*  MANAGER (CHAR XXX IN 100 WITH  FEW FUTURE OCCURRENCES )
       104*  POSITION TYPE (CHAR X(12) IN 100 WITH SOME FUTURE OCCURRENCES )
       105*  START DATE (DATE IN 100)
       106*  END DATE (NON-KEY DATE IN 100)
       110*  SALARY WITHIN POSITION (RECORD IN 100)
         111*  PAY RATE (MONEY $9999.99 IN 110)
         112*  PAY SCHEDULE (CHAR X(7) IN 110)
         113*  EFFECTIVE DATE (DATE IN 110)
         114*  CURRENT DEDUCTION (NON-KEY MONEY $9999.99 IN 110)
         120*  MONTHLY PAYROLL ACCOUNTING (RECORD IN 110)
           121*  PAYROLL MONTH (DATE IN 120)
           122*  REGULAR HOURS (NON-KEY DECIMAL NUMBER 999.99 IN 120)
           123*  OVERTIME HOURS (NON-KEY DECIMAL NUMBER 999.99 IN 120)
           124*  GROSS PAY (NON-KEY MONEY $9999.99 IN 120)
           125*  FEDERAL TAX DEDUCTION (NON-KEY MONEY $9999.99 IN 120)
           126*  NET PAY (NON-KEY MONEY $9999.99 IN 120)
       130*  ADDITIONAL INFORMATION (RECORD IN 100)
         131*  LINE NUMBER (DECIMAL NUMBER 99.9 IN 130)
         132*  COMMENT TEXT (NON-KEY TEXT X(7) IN 130)
     200*  JOB SKILLS (RECORD)
       201*  SKILL TYPE (CHAR X(12) IN 200 WITH SOME FUTURE OCCURRENCES )
       202*  PROFICIENCY (NON-KEY CHAR X(5) IN 200)
       203*  YEARS OF EXPERIENCE (NON-KEY INTEGER NUMBER 99 IN 200)
     300*  PERSONAL INTERESTS (RECORD)
       301*  INTEREST (CHAR X(12) IN 300 WITH  FEW FUTURE OCCURRENCES )
       302*  AFFILIATION (NON-KEY CHAR X(5) IN 300)
       303*  COMMENT (NON-KEY TEXT X(5) IN 300)
     400*  EDUCATIONAL BACKGROUND (RECORD)
       410*  EDUCATION (RECORD IN 400)
         411*  SCHOOL (CHAR X(15) IN 410)
         412*  DEGREE/CERTIFICATE (CHAR X(7) IN 410 WITH  FEW FUTURE OCCURRENCES
) 
         413*  DATE COMPLETED (DATE IN 410)
         414*  MAJOR FIELD (NON-KEY CHAR X(16) IN 410)
         415*  MINOR FIELD (NON-KEY CHAR X(12) IN 410)
       420*  TRAINING (RECORD IN 400)
         421*  SOURCE (NON-KEY CHAR X(12) IN 420)
         422*  CLASS NAME (CHAR X(12) IN 420 WITH  FEW FUTURE OCCURRENCES )
         423*  DATE ACCOMPLISHED (DATE IN 420)