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)