1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
|
--------------------------------------------------------------------------
Informix SQL Script Files
--------------------------------------------------------------------------
Name Function
byCat.sql problem reports by program category
cat_rev.sql critical problem reports by category
crCodes.sql create severity and state code tables
crHist.sql create statistical history table
crGNATS.sql create main problem reports table
crOGNATS.sql create problem reports buffer tables
cust_rev.sql critical problem reports by customer
engr_rev.sql critical problem reports by responsible person
loadOGNATS.sql manage data from previous weeks
loadGNATS.sql upload current data
monthly.sql generate cumulative problem report graph by month
pick_id.sql list details for selected problem reports
statesumm.sql problem report statistics by report state
--------------------------------------------------------------------------
Informix ACE Report Generator Source Files
--------------------------------------------------------------------------
Name Function
bcust.ace customer problem reports
cust_p_rev.ace customer summary statistics
enhreq.ace change requests not closed
history.ace historical statistics in absolute count
historyPC.ace historical statistics as percentage of total reports
open.ace problem reports not closed
wk_delta.ace change statistics
wk_open.ace new problem reports not closed
wk_st_chng.ace state changes for problem reports
--------------------------------------------------------------------------
Informix 4GL Source Files
--------------------------------------------------------------------------
Name Function
calc_age.4gl calculate age of problem reports
summ_wk.4gl calculate summary statistics
--------------------------------------------------------------------------
Unix Shell Scripts
--------------------------------------------------------------------------
Name Function
Ignats.cust generate customer reports
Ignats.setup extract data from GNATS and load into database
Ignats.summdy generate list of critical problem reports not closed
Ignats.summmn generate historical data
Ignats.summwk generate weekly statistics report
Ignats.wkbuffs manage data from previous weeks
Ignats.wkchng generate report of changes in past week
|
