Chapter Contents
Previous
Next
SAS/ACCESS Interface to SYSTEM 2000 Data Management Software: Reference

SYSTEM 2000 Database Definition

This section shows the complete database definition for the EMPLOYEE database. The descriptor files created and used in this manual are based on this database.

EMPLOYEE Database Definition
  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 OCCUR^|
RENCES ) 
         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)


Chapter Contents
Previous
Next
Top of Page

Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.