October 23, 2007, 02:04 PM
Adrian Wong Subtotal / Total not showing properly
Don't know why bits of code went missing. Posting it here again. The crucial parts are there now in the
... tags. Thank you.
-SET &ECHO=ALL;
SET NODATA = ' '
SET PRINTPLUS = ON
-DEFAULT &FROM_DATE = '20070301';
-DEFAULT &TO_DATE = '20070331';
-DEFAULT &ADATE1 = '20070601';
-DEFAULT &ADATE2 = '20070630';
-DEFAULT &OUTPUT = 'HTML';
-*
-SET &REP_NAME = 'Detailed Card Production Failures Report';
-SET &RUN_DATE = &DATEMtrDYY;
-SET &RUN_TIME = EDIT(HHMMSS('A8'),'99$:99$:99');
-SET &ORIENTATION = 'LANDSCAPE';
-SET &ADATETIME1 = EDIT(&ADATE1,'9999-99-99')| ' 00:00:00';
-SET &ADATETIME2 = EDIT(&ADATE2,'9999-99-99')| ' 23:59:59';
-SET &ADATE1TEXT = LCWORD(17,CHGDAT('YYMD', 'MXDYY', &ADATE1, 'A17'), 'A17');
-SET &ADATE2TEXT = LCWORD(17,CHGDAT('YYMD', 'MXDYY', &ADATE2, 'A17'), 'A17');
-SET &FROM_DATE = EDIT(&ADATE1,'9999-99-99');
-SET &TO_DATE = EDIT(&ADATE2,'9999-99-99');
-*
SET SQLENGINE=SQLORA
SQL SET SERVER DWD_DLHCM
SQL
SELECT cf.card_type_code, sr.reason_code, oi.card_dcn, oi.oi_identifier, cs.sts, oi.oi_effective_dt, oi.oi_dl,
oi.item_count
FROM DWDH_OWNER.DWDHF_ORDER_ITEM oi
,DWDH_OWNER.DWDHD_STATUS_REASON sr
,DWDH_OWNER.DWDHD_CARDFILE_TYPE cf
,DWGL_OWNER.DWGLD_COMPANY c
,(select card_dcn, cssr.status_code sts
from dwdhf_card_stock, dwdhd_status_reason cssr
where dwdhf_card_stock.dhd_status_reason_id = cssr.id
and cssr.status_code = 'DEST') cs
WHERE oi.dhd_status_reason_id = sr.id and sr.cur_ind_flg = 'Y'
AND oi.dhd_cardfile_type_id = cf.id and cf.cur_ind_flg = 'Y'
AND oi.gld_company_id = c.id and c.cur_ind_flg = 'Y'
AND sr.STATUS_CODE = 'PROD_F'
AND sr.REASON_CODE IN ('CARD_DAMAGED', 'DATA_QUALITY', 'SIGNATURE_QUALITY', 'IMAGE_QUALITY', 'INC_DATA')
AND TO_CHAR( oi.oi_effective_dt, 'YYYY-MM-DD') BETWEEN '&FROM_DATE' AND '&TO_DATE'
and oi.card_dcn = cs.card_dcn (+)
ORDER BY 1,4,6
;
TABLE ON TABLE HOLD AS DR2V4
END
-RUN
-*? HOLD DR2V4
-*0DEFINITION OF HOLD FILE: DR2V4
-* 0FIELDNAME ALIAS FORMAT
-* CARD_TYPE_CODE E01 A30
-* REASON_CODE E02 A30
-* CARD_DCN E03 A100 MISSING = ON
-* OI_IDENTIFIER E04 A100
-* STS E05 A30 MISSING = ON
-* OI_EFFECTIVE_DT E06 HYYMDS
-* OI_DL E07 A17 MISSING = ON
-* ITEM_COUNT E08 P2
TABLE FILE DR2V4
SUM ITEM_COUNT/D20
BY CARD_TYPE_CODE
PRINT
CARD_TYPE_CODE AS 'Card Type'
REASON_CODE AS 'Reason Code'
CARD_DCN AS 'DCN'
OI_IDENTIFIER AS 'Order ID'
STS AS 'Card Stock,Status'
OI_EFFECTIVE_DT AS 'Timestamp'
OI_DL AS 'DL'
BY
CARD_TYPE_CODE NOPRINT
BY
OI_IDENTIFIER NOPRINT
BY
OI_EFFECTIVE_DT NOPRINT
ON CARD_TYPE_CODE SUBFOOT
"Total <CARD_TYPE_CODE Production Failures : <ST.ITEM_COUNT "
HEADING
"DL Card and Health Card Contract Management"
"Detailed Card Production Failures Report"
"From: &ADATE1TEXT.EVAL To: &ADATE2TEXT.EVAL "
" "
-*FOOTING
ON TABLE SUBFOOT
"Total Card Production Failures : <TOT.ITEM_COUNT "
"Report ID: DR2V4 / Date: &RUN_DATE / Time: &RUN_TIME / <+34> Page <TABPAGENO of <TABLASTPAGE <90"
ON TABLE SET PAGE-NUM OFF
ON TABLE PCHOLD FORMAT '&OUTPUT'
ON TABLE SET CSSURL '/approot/mtomis/report.css'
ON TABLE SET STYLE *
-*
-GOTO STY_&OUTPUT.EVAL
-*
-STY_HTML
-STY_EXL2K
-MRNOEDIT -INCLUDE STYLE011
-GOTO STY_END
-*
-STY_PDF
-MRNOEDIT -INCLUDE STYLE021
-*
-STY_EXCEL
-STY_END
ENDSTYLE
END
-RUN
-*
-IF &LINES GT 0 GOTO REPORT_END;
-*
-NO_DATA
-MRNOEDIT -INCLUDE MISI200
-*
-REPORT_END
Output:
DL Card and Health Card Contract Management
Detailed Card Production Failures Report
From: June 01 2007 To: June 30 2007
Card Type
Reason Code
DCN
Order ID Card Stock
Status
Timestamp
DL
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl1 2007/06/07 11:00:00 D1234-56789-00001
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl1 2007/06/08 11:00:00 D1234-56789-00001
DLCARD_V1 CARD_DAMAGED DL0000001 release4orderitemidentifierdl1 DEST 2007/06/10 11:00:00 D1234-56789-00001
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl10 2007/06/07 11:09:00 D1234-56789-00010
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl10 2007/06/08 11:09:00 D1234-56789-00010
DLCARD_V1 CARD_DAMAGED DL0000004 release4orderitemidentifierdl10 DEST 2007/06/10 11:09:00 D1234-56789-00010
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl11 2007/06/07 11:10:00 D1234-56789-00011
DLCARD_V1 IMAGE_QUALITY DL0001175 release4orderitemidentifierdl1180 2007/06/04 12:19:00 D1234-56789-01180
DLCARD_V1 SIGNATURE_QUALITY DL0001175 release4orderitemidentifierdl1180 2007/06/04 12:29:00 D1234-56789-01180
DLCARD_V1 IMAGE_QUALITY DL0001175 release4orderitemidentifierdl1180 2007/06/04 12:39:00 D1234-56789-01180
DLCARD_V1 IMAGE_QUALITY DL0001176 release4orderitemidentifierdl1181 2007/06/05 12:00:00 D1234-56789-01181
DLCARD_V1 SIGNATURE_QUALITY DL0001176 release4orderitemidentifierdl1181 2007/06/05 12:29:00 D1234-56789-01181
DLCARD_V1 IMAGE_QUALITY DL0001176 release4orderitemidentifierdl1181 2007/06/05 12:39:00 D1234-56789-01181
DLCARD_V1 IMAGE_QUALITY DL0001177 release4orderitemidentifierdl1182 2007/06/05 12:01:00 D1234-56789-01182
DLCARD_V1 IMAGE_QUALITY DL0001178 release4orderitemidentifierdl1183 2007/06/05 12:02:00 D1234-56789-01183
DLCARD_V1 CARD_DAMAGED DL0001179 release4orderitemidentifierdl1184 DEST 2007/06/05 13:13:00 D1234-56789-01184
DLCARD_V1 CARD_DAMAGED DL0001216 release4orderitemidentifierdl1184 DEST 2007/06/05 13:33:00 D1234-56789-01184
DLCARD_V1 CARD_DAMAGED DL0001217 release4orderitemidentifierdl1184 DEST 2007/06/05 13:53:00 D1234-56789-01184
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl12 2007/06/07 11:11:00 D1234-56789-00012
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl13 2007/06/07 11:12:00 D1234-56789-00013
DLCARD_V1 INC_DATA release4orderitemidentifierdl14 2007/06/07 11:13:00 D1234-56789-00014
DLCARD_V1 INC_DATA release4orderitemidentifierdl14 2007/06/08 11:13:00 D1234-56789-00014
DLCARD_V1 CARD_DAMAGED DL0000005 release4orderitemidentifierdl14 DEST 2007/06/10 11:13:00 D1234-56789-00014
DLCARD_V1 INC_DATA release4orderitemidentifierdl15 2007/06/07 11:14:00 D1234-56789-00015
DLCARD_V1 INC_DATA release4orderitemidentifierdl15 2007/06/08 11:14:00 D1234-56789-00015
DLCARD_V1 CARD_DAMAGED DL0000006 release4orderitemidentifierdl15 DEST 2007/06/10 11:14:00 D1234-56789-00015
DLCARD_V1 INC_DATA release4orderitemidentifierdl16 2007/06/07 11:15:00 D1234-56789-00016
DLCARD_V1 INC_DATA release4orderitemidentifierdl16 2007/06/08 11:15:00 D1234-56789-00016
DLCARD_V1 INC_DATA release4orderitemidentifierdl17 2007/06/07 11:16:00 D1234-56789-00017
DLCARD_V1 INC_DATA release4orderitemidentifierdl17 2007/06/08 11:16:00 D1234-56789-00017
DLCARD_V1 INC_DATA release4orderitemidentifierdl18 2007/06/07 11:17:00 D1234-56789-00018
DLCARD_V1 INC_DATA release4orderitemidentifierdl18 2007/06/08 11:17:00 D1234-56789-00018
DLCARD_V1 INC_DATA release4orderitemidentifierdl19 2007/06/07 11:18:00 D1234-56789-00019
DLCARD_V1 INC_DATA release4orderitemidentifierdl19 2007/06/08 11:18:00 D1234-56789-00019
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl2 2007/06/07 11:01:00 D1234-56789-00002
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl2 2007/06/08 11:01:00 D1234-56789-00002
DLCARD_V1 CARD_DAMAGED DL0000002 release4orderitemidentifierdl2 DEST 2007/06/10 11:01:00 D1234-56789-00002
DLCARD_V1 INC_DATA release4orderitemidentifierdl20 2007/06/07 11:19:00 D1234-56789-00020
DLCARD_V1 INC_DATA release4orderitemidentifierdl20 2007/06/08 11:19:00 D1234-56789-00020
DLCARD_V1 CARD_DAMAGED DL0000007 release4orderitemidentifierdl20 DEST 2007/06/10 11:19:00 D1234-56789-00020
DLCARD_V1 INC_DATA release4orderitemidentifierdl21 2007/06/07 11:20:00 D1234-56789-00021
DLCARD_V1 INC_DATA release4orderitemidentifierdl22 2007/06/07 11:21:00 D1234-56789-00022
DLCARD_V1 INC_DATA release4orderitemidentifierdl22 2007/06/08 11:21:00 D1234-56789-00022
DLCARD_V1 INC_DATA release4orderitemidentifierdl23 2007/06/07 11:22:00 D1234-56789-00023
DLCARD_V1 INC_DATA release4orderitemidentifierdl23 2007/06/08 11:22:00 D1234-56789-00023
DLCARD_V1 INC_DATA release4orderitemidentifierdl24 2007/06/07 11:23:00 D1234-56789-00024
DLCARD_V1 INC_DATA release4orderitemidentifierdl24 2007/06/08 11:23:00 D1234-56789-00024
DLCARD_V1 INC_DATA release4orderitemidentifierdl25 2007/06/07 11:24:00 D1234-56789-00025
DLCARD_V1 INC_DATA release4orderitemidentifierdl26 2007/06/07 11:25:00 D1234-56789-00026
DL Card and Health Card Contract Management
Detailed Card Production Failures Report
From: June 01 2007 To: June 30 2007
Card Type
Reason Code
DCN
Order ID Card Stock
Status
Timestamp
DL
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl27 2007/06/07 11:26:00 D1234-56789-00027
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl27 2007/06/08 11:26:00 D1234-56789-00027
DLCARD_V1 CARD_DAMAGED DL0000008 release4orderitemidentifierdl27 DEST 2007/06/10 11:26:00 D1234-56789-00027
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl28 2007/06/07 11:27:00 D1234-56789-00028
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl28 2007/06/08 11:27:00 D1234-56789-00028
DLCARD_V1 CARD_DAMAGED DL0000009 release4orderitemidentifierdl28 DEST 2007/06/10 11:27:00 D1234-56789-00028
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl29 2007/06/07 11:28:00 D1234-56789-00029
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl29 2007/06/08 11:28:00 D1234-56789-00029
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl3 2007/06/07 11:02:00 D1234-56789-00003
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl3 2007/06/08 11:02:00 D1234-56789-00003
DLCARD_V1 CARD_DAMAGED DL0000003 release4orderitemidentifierdl3 DEST 2007/06/10 11:02:00 D1234-56789-00003
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl30 2007/06/07 11:29:00 D1234-56789-00030
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl31 2007/06/07 11:30:00 D1234-56789-00031
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl31 2007/06/08 11:30:00 D1234-56789-00031
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl32 2007/06/07 11:31:00 D1234-56789-00032
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl32 2007/06/08 11:31:00 D1234-56789-00032
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl33 2007/06/07 11:32:00 D1234-56789-00033
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl33 2007/06/08 11:32:00 D1234-56789-00033
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl34 2007/06/07 11:33:00 D1234-56789-00034
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl35 2007/06/07 11:34:00 D1234-56789-00035
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl36 2007/06/07 11:35:00 D1234-56789-00036
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl37 2007/06/07 11:36:00 D1234-56789-00037
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl38 2007/06/07 11:37:00 D1234-56789-00038
DLCARD_V1 SIGNATURE_QUALITY NULL release4orderitemidentifierdl39 2007/06/07 11:38:00 D1234-56789-00039
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl4 2007/06/07 11:03:00 D1234-56789-00004
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl4 2007/06/08 11:03:00 D1234-56789-00004
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl40 2007/06/07 11:39:00 D1234-56789-00040
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl41 2007/06/07 11:40:00 D1234-56789-00041
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl41 2007/06/08 11:40:00 D1234-56789-00041
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl42 2007/06/07 11:41:00 D1234-56789-00042
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl42 2007/06/08 11:41:00 D1234-56789-00042
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl43 2007/06/07 11:42:00 D1234-56789-00043
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl43 2007/06/08 11:42:00 D1234-56789-00043
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl44 2007/06/07 11:43:00 D1234-56789-00044
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl44 2007/06/08 11:43:00 D1234-56789-00044
DLCARD_V1 CARD_DAMAGED DL0000010 release4orderitemidentifierdl44 DEST 2007/06/10 11:43:00 D1234-56789-00044
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl45 2007/06/07 11:44:00 D1234-56789-00045
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl45 2007/06/08 11:44:00 D1234-56789-00045
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl46 2007/06/07 11:45:00 D1234-56789-00046
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl47 2007/06/07 11:46:00 D1234-56789-00047
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl48 2007/06/07 11:47:00 D1234-56789-00048
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl49 2007/06/07 11:48:00 D1234-56789-00049
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl5 2007/06/07 11:04:00 D1234-56789-00005
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl5 2007/06/08 11:04:00 D1234-56789-00005
DLCARD_V1 DATA_QUALITY NULL release4orderitemidentifierdl50 2007/06/07 11:49:00 D1234-56789-00050
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl6 2007/06/07 11:05:00 D1234-56789-00006
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl6 2007/06/08 11:05:00 D1234-56789-00006
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl7 2007/06/07 11:06:00 D1234-56789-00007
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl7 2007/06/08 11:06:00 D1234-56789-00007
DL Card and Health Card Contract Management
Detailed Card Production Failures Report
From: June 01 2007 To: June 30 2007
Card Type
Reason Code
DCN
Order ID Card Stock
Status
Timestamp
DL
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl8 2007/06/07 11:07:00 D1234-56789-00008
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl8 2007/06/08 11:07:00 D1234-56789-00008
DLCARD_V1 IMAGE_QUALITY NULL release4orderitemidentifierdl9 2007/06/07 11:08:00 D1234-56789-00009
Total DLCARD_V1 Production Failures : **
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc1 2007/06/08 11:00:00
HCARD_V1 CARD_DAMAGED HC0000001 release4orderitemidentifierhc10 DEST 2007/06/08 11:09:00
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc11 2007/06/08 11:10:00
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc12 2007/06/08 11:11:00
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc13 2007/06/08 11:12:00
HCARD_V1 INC_DATA release4orderitemidentifierhc14 2007/06/08 11:13:00
HCARD_V1 INC_DATA release4orderitemidentifierhc15 2007/06/08 11:14:00
HCARD_V1 INC_DATA release4orderitemidentifierhc16 2007/06/08 11:15:00
HCARD_V1 INC_DATA release4orderitemidentifierhc17 2007/06/08 11:16:00
HCARD_V1 INC_DATA release4orderitemidentifierhc18 2007/06/08 11:17:00
HCARD_V1 INC_DATA release4orderitemidentifierhc19 2007/06/08 11:18:00
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc2 2007/06/08 11:01:00
HCARD_V1 CARD_DAMAGED HC0000002 release4orderitemidentifierhc20 DEST 2007/06/08 11:19:00
HCARD_V1 INC_DATA release4orderitemidentifierhc21 2007/06/08 11:20:00
HCARD_V1 INC_DATA release4orderitemidentifierhc22 2007/06/08 11:21:00
HCARD_V1 INC_DATA release4orderitemidentifierhc23 2007/06/08 11:22:00
HCARD_V1 INC_DATA release4orderitemidentifierhc24 2007/06/08 11:23:00
HCARD_V1 INC_DATA release4orderitemidentifierhc25 2007/06/08 11:24:00
HCARD_V1 INC_DATA release4orderitemidentifierhc26 2007/06/08 11:25:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc27 2007/06/08 11:26:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc28 2007/06/08 11:27:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc29 2007/06/08 11:28:00
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc3 2007/06/08 11:02:00
HCARD_V1 CARD_DAMAGED HC0000003 release4orderitemidentifierhc30 DEST 2007/06/08 11:29:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc31 2007/06/08 11:30:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc32 2007/06/08 11:31:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc33 2007/06/08 11:32:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc34 2007/06/08 11:33:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc35 2007/06/08 11:34:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc36 2007/06/08 11:35:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc37 2007/06/08 11:36:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc38 2007/06/08 11:37:00
HCARD_V1 SIGNATURE_QUALITY release4orderitemidentifierhc39 2007/06/08 11:38:00
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc4 2007/06/08 11:03:00
HCARD_V1 CARD_DAMAGED HC0000004 release4orderitemidentifierhc40 DEST 2007/06/08 11:39:00
HCARD_V1 DATA_QUALITY release4orderitemidentifierhc41 2007/06/08 11:40:00
HCARD_V1 DATA_QUALITY release4orderitemidentifierhc42 2007/06/08 11:41:00
HCARD_V1 DATA_QUALITY release4orderitemidentifierhc43 2007/06/08 11:42:00
HCARD_V1 DATA_QUALITY release4orderitemidentifierhc44 2007/06/08 11:43:00
HCARD_V1 DATA_QUALITY release4orderitemidentifierhc45 2007/06/08 11:44:00
HCARD_V1 DATA_QUALITY release4orderitemidentifierhc46 2007/06/08 11:45:00
HCARD_V1 DATA_QUALITY release4orderitemidentifierhc47 2007/06/08 11:46:00
HCARD_V1 DATA_QUALITY release4orderitemidentifierhc48 2007/06/08 11:47:00
HCARD_V1 DATA_QUALITY release4orderitemidentifierhc49 2007/06/08 11:48:00
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc5 2007/06/08 11:04:00
DL Card and Health Card Contract Management
Detailed Card Production Failures Report
From: June 01 2007 To: June 30 2007
Card Type
Reason Code
DCN
Order ID Card Stock
Status
Timestamp
DL
HCARD_V1 CARD_DAMAGED HC0000005 release4orderitemidentifierhc50 DEST 2007/06/08 11:49:00
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc6 2007/06/08 11:05:00
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc7 2007/06/08 11:06:00
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc8 2007/06/08 11:07:00
HCARD_V1 IMAGE_QUALITY release4orderitemidentifierhc9 2007/06/08 11:08:00
Total HCARD_V1 Production Failures : 50
Total Card Production Failures : **
Report ID: DR2V4 / Date: October 23, 2007 / Time: 11:44:40 / Page 4 of 4
This message has been edited. Last edited by: Adrian Wong , October 23, 2007 05:00 PM