ROS.60050 ' ’’’’ r
ē
!"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~
”¢£¤„¦§Ø©Ŗ«¬®Æ°±²³“µ¶·ø¹ŗ»¼½¾æĄĮĀĆÄÅĘĒČÉŹĖĢĶĪĻŠŃŅÓŌÕÖ×ŲŁŚŪÜŻŽßąįāćäåęēčéźėģķīļšńņóōõö÷ųłśūüżž h !etSRW2_DATA_MODEL
e’’’’ $h h! "ntSRW2_DISPLAY_TAG ’’’’ %h !h" #5 SRW2_DISTRIBUTION ' ati’’’’ h h SRW2_ELEMENT ’’’’ hh f’’’’ +x )± Report run on: ’’’’ :x 8¹ Certification Expiration List ’’’’’’ 7x 5 (š Expiration dates between: ’’’’ *x (8gš &P_START_DATE 0’’’’ "x 00š and ’’’’’’ (x &UMš &P_END_DATE ’’’’ " x .R, Dept: ’’’’ / x - 9 Last, First Middle ’’’’’ + x )T_= Certification: ’’’’’ $ x "NI? Number: ’’’’ $ x " $A Earned: ’’’’ % x # C Renewed: 2G®’’’’ % x # E Expires: 8Qė’’’’ # x !!G MFS ID 2’’’’ " x Type: r25g25b0@ @ CT_’’’’ )00x " $& ' P 0 r50g25b0 @ (P’’’’ )00x " $& 'ER 1 r75g25b0Ą @ IP)’’’’ )00x " $& 'GA 2 r88g25b0ą @ ORG’’’’ +00x $ &( ) I 3 r100g25b0 ’’@ i’’’’ *00x" $ & (id 4 r0g25b50 @ E,’’’’ ,00x $ & ( *UP 5 r25g25b50 @ @ ’’’’ ,00x $ & ( *T_ 6 r50g25b50 @ ’’’’ ,00x $ & ( *( 7 r75g25b50 Ą @ ’’’’ ,00x $ & ( *ct 8 r88g25b50 ą @ ’’’’ ,00x $ & ( * 9
r100g25b50’’@ ’’’’ *00x" $ & (d : r0g25b75 0@ Ą '’’’’ ,00x $ & ( *pc ; r25g25b75 @ @ Ą ’’’’ ,00x $ & ( * < r50g25b75 @ Ą ’’’’ ,00x $ & ( *XP = r75g25b75 Ą @ Ą ’’’’ ,00x $ & ( * > r88g25b75 ą @ Ą ’’’’ ,00x $ & ( *d. ?
r100g25b75’’@ Ą ’’’’ *00x" $ & (’’ @ r0g25b88 5@ ą X’’’’ ,00x $ & ( *8h A r25g25b88 @ @ ą ’’’’ ,00x $ & ( * B r50g25b88 @ ą ’’’’ ,00x $ & ( *00 C r75g25b88 Ą @ ą @ r 08hi(jpn 8n ą 08x~0 0 š 0800 p¦¦ 0® p “
¢(¦0Ŗ«¬@² ¼ ĶB_LAST_NAME
0 ( , ( , ’ 8 .’’’’ ¾* Zp\cd(jpnpn8n8p8r8tvwxx~0dp ś č5 ` 88 ³ · P 88 M 0 88 , &00x $ D r88g25b88 ,08x *qr(vpz 00r100g75b100 ° ,08x *0«0¬p²² ć 00r100g100b100 Ą r bpdmnopATE_NUMBER 4 4 ’ < 2PRINTJOB
pf Š l bpdghijpn@n8r8t8vxyzx~000000 p¦¦Ŗ0®Æ °²³“µ¶·ø ŗ ¼0 B_EARN`id
h p Zp\hi(jpn ¼ ’ @ .|’’’’ ¾* Zp\B_LAST_NAME
0 ` BpDUV(Zp^00 p¦¦Ŗ0®Æ °²³“µ¶·ø ŗ ¼f B_RENER_G_ALTERNATE_ID ŖR Ķ0 ¼ ’ B ./’’’’ ¾* Zp\fg(jpnpn@n8r8t8vxyzx~000000 p¦¦Ŗ0®Æ °²³“µ¶·ø ŗ ¼E_ B_EXPIRES E_0 ¼ 4 ¼ ’ D .t’’’’ ŗ* Zp\ab(fpjpj0j8l8n8prstxz000000p¢¢¦0Ŗ« ¬®Æ°±²³“ ¶ ø B_id ES 0 ’ F .NE’’’’ æ* Zp\ij(nprpr@r8v8x8z|}~x0000 ”¢0£0¤pŖŖ®0²³“µ¶·ø¹ŗ»¼ ½ląB_DATE1_SEC1 ² 0 U U ’ /’’’’
I’’’’
I’’’’
I’’’’
N’’’’
” N’’’’
£ N’’’’
„ N’’’’
§ N’’’’
® °d’’’’
± ³r’’’’
¹ %’’’’
š ’’’’
š’’’’
š’’’’
š’’’’
, R%’’’’
9 °’’’’
= ³’’’’
? ³’’’’
A ³’’’’
C ³’’’’
E ³µP’’’’
G °’’’’
³’’’’ BpDWX(^pbpb0b0c@f8jl npq0r0s0t0u0v0wx0y0z{|}~ M_G_ORG_NAME_GRPFR Č p p 0 P_ ņ " & ’ ÆE,’’’’ ~ BpDQR(VpZpZ0Z0[@^8bd fhi0j0k0l0m0n0op0q0rstuvwx z |R_G_ORG_NAME ŖPFR0 ņ " _& ’ ±, ’’’’ BpD[\(bpfpf0f8h@j8npqrs0t0u0v0w0x0yz0{0|}~ M_G_ALTERNATE_ID_GRPFR Č ņ 0 ņ h ’ D ’’’’ BpDYZ(^pbpb0b8d@f8jlmno0p0q0r0s0t0uv0w0xyz{|}~ M_G_ALTERNATE_ID_HDR ĶČ ä h ’ ON_ID = PS_ORGANIZATION.ID(+))) AND LEFT IS NULL
and ct_type_id=nvl(:P_TYPE_ID, ct_type_id)
ORDER BY ORG_NAME, CT_CERTIFICATE.EXPIRES,
UPPER(PS_PERSON.LAST_NAME), UPPER(PS_PERSON.FIRST_NAME) „’’’’ **66O(R VZąZ(fjąj(vzz(z(~( RUNONLY ct_expiration_list_dept -l bĪ šKg
u pppp¢¢£¤„p¦p««¬ QNAME h y 2! Certification ' ACTI NAME I’’’’ É/ bpdwxyz{|ppp
000000p( ¢£¤p„p„„¦§Øp©p®®Æ°±p²pÅÅĘ ĒTCERTIFICATE_NUMBER h | Cert ! Number ' ' CERTIFICATE_NUMBER RNE’’’’ ±/ bpdklmnoppvvpwpwwxyz{0|0}0~000p( pppp¢¢£¤„p¦p® ÆWEARNED h MBER ! Earned _ ' ' EARNED ES ’’’’ Ŗ/ bpdlmnopqprrpspsstuvw0x0y0z0{0|0}p~( pppppp¦¦§ ØZRENEWED h ! Renewed _ ' RENEWED ’’’’ Ŗ/ bpdlmnopqprrpspsstuvw0x0y0z0{0|0}p~( pppppp¦¦§ Ø]EXPIRES h
! Expires _ ' EXPIRES #d.9Ń4 G_ALTERNATE_ID LIST_G_ALTERNATE_ID ’’’’ FpHSTUVWX0YZ[0\]^0_`abcxf8f8h8j8lnoppppp{ {p|p ā’G_ORG_NAME g +ķ>f(&
Č G_ORG_NAME LIST_G_ORG_NAME
00r88g75b100ą Ą ’’@ ą ž’’’’’’’ šx 0 ’’’’ø r ’’’’ 88 pn ą ’’’’ 2jk0l0m0n8p8rt v0x0yz{0|}ą~
pppppppĮpŃqųrrr0r0r0r0r0r22r3rVVrZrrrsrtr e a
¤ j xg
| 2corp1
Certification Expiration List CT_EXPIRATION_LIST_DEPT ¶·’’’’ „
B(F0JK@N@R@V@Z0^0_0`0a0b0cd0e0fgh0i0j0klmnopppp¢¢ £fr0r ś 0r @ @ P @ Report Parameters Enter values for the parameters 0 ’’’’ $00x ! " ŗ black ’’’’ (00x " $ & white ’’’’’’’’’’ %00x " # green ’’ ’’’’ )00x# $& '@n darkgreen 0’’’’ (00x " $ &0® gray96
=
=
=’’’’ (00x " $ & gray92zzz’’’’ (00x " $ & gray88 ø ø ø’’’’ (00x " $ &* gray84(õ(õ(õ’’’’ %00x !" #0 r0g0b0 ¢¢’’’’ (00x "$% & r25g0b0 @ ’’’’ (00x "$% &
r50g0b0 ’’’’ (00x "$% & r75g0b0 Ą ’’’’ (00x "$% &~ r88g0b0 ą ’’’’ (00x "$% &¶
r100g0b0’’ ’’’’ (00x!" $ & r0g0b50 ’ ’’’’ *00x "$ & ( r25g0b50@ ’’’’ *00x "$ & (I r50g0b50 I’’’’ *00x "$ & ( r75g0b50Ą ’’’’ *00x "$ & ( r88g0b50ą ’’’’ ,00x $& ( *’’ r100g0b50 ’’ ’’’’ (00x!" $ & r0g0b75 Ą ’’’’ *00x "$ & ( r25g0b75@ ĄĄ ’’’’ *00x "$ & (’’ r50g0b75 ĄĄ %’’’’ *00x "$ & ( r75g0b75Ą ĄĄ ’’’’ *00x "$ & ( r88g0b75ą ĄĄ ’’’’ ,00x $& ( *P r100g0b75 ’’ ĄĄ ’’’’ (00x!" $ & r0g0b88 ą ’’’’ *00x "$ & (x r25g0b88@ ąą ’’’’ *00x "$ & ( r50g0b88 ąą ’’’’ *00x "$ & ( r75g0b88Ą ąą @^’’’’ *00x "$ & (0r r88g0b88ą ąą R_’’’’ ,00x $& ( *ņ r100g0b88 ’’ ąą ’’’’ (00x"# $ &pf r0g0b100 ’’’’’’ ,00x $& ( * ! r25g0b100 @ ą’’’’’’ ,00x $& ( * " r50g0b100 ą’’’’’’ ,00x $& ( *pb # r75g0b100 Ą ą’’’’’’ ,00x $& ( *~ $ r88g0b100 ą ą’’’’’’ ,00x $& ( * h %
r100g0b100’’ ą’’’’’’ &00x " $)) & grayĄ Ą Ą NU’’’’ *00x " $ & (YP ' darkgray OR’’’’ &00x " $IC ( cyan r’’’’UP’’’’ *00x" $ & (UP ) darkcyan ’ T_’’’’ (00x " $ &(R * gray80333333’’’’ (00x " $ &ct + gray76=p=p=p’’’’ (00x " $ & , gray72G®G®G®’’’’ (00x " $ & - gray68QėQėQė’’’’ '00x! "$ % . r0g25b0 @ t’’’’ )00x " $& ' / r25g25b0@ @ ’’’’’’’ )00x " $& 'p 0 r50g25b0 @ 0’’’’ )00x " $& '§ 1 r75g25b0Ą @ ÅÅ’’’’ )00x " $& 'h 2 r88g25b0ą @ ’’’’ +00x $ &( ) 3 r100g25b0 ’’@ _’’’’ *00x" $ & (l 4 r0g25b50 @ x’’’’ ,00x $ & ( * 5 r25g25b50 @ @ ’’’’ ,00x $ & ( *ED 6 r50g25b50 @ ’’’’ ,00x $ & ( * 7 r75g25b50 Ą @ ’’’’ ,00x $ & ( *q 8 r88g25b50 ą @ ’’’’ ,00x $ & ( *p 9
r100g25b50’’@ ’’’’ *00x" $ & ( : r0g25b75 0@ Ą d ’’’’ ,00x $ & ( *NE ; r25g25b75 @ @ Ą ’’’’ ,00x $ & ( *v < r50g25b75 @ Ą ’’’’ ,00x $ & ( * = r75g25b75 Ą @ Ą ’’’’ ,00x $ & ( *pi > r88g25b75 ą @ Ą ’’’’ ,00x $ & ( *4 ?
r100g25b75’’@ Ą ’’’’ *00x" $ & ( @ r0g25b88 5@ ą Z’’’’ ,00x $ & ( *8l A r25g25b88 @ @ ą ’’’’ ,00x $ & ( * B r50g25b88 @ ą ’’’’ ,00x $ & ( *00 C r75g25b88 Ą @ ą @ ’’’’ Ä r ’’’’ .hh ,pnROSATTRIBS class attributes t’’’’ +hh )ROSLFDESC ros lf descrip ’’’’ )hh 'rVROSOBJMAP ros name->id
¤’’’’ +hh )
ROSSTRINGS tk2 uiStrings =’’’’ *hh (="ROSSTRUCTS struct types <’’’’ *hh (r=ROSTK2RESV tk2 reserved st’’’’ hh >
SRW2_ANCHOR d’’’’ &h!"h# $" SRW2_BODY_LOCATION dd’’’’ $h h! "SRW2_COLUMN <’’’’ #h h !etSRW2_DATA_MODEL e’’’’ $h h! "ntSRW2_DISPLAY_TAG ’’’’ %h !h" #5 SRW2_DISTRIBUTION & ati’’’’ h h SRW2_ELEMENT ’’’’ hh 8’’’’ +x )± Report run on: 0’’’’ :x 8 $¹ Certification Expiration List 0’’’’ 7x 50gš Expiration dates between: (’’’’ *x (’’š &P_START_DATE (’’’’ "x ’’š and ’’’’ (x &b1š &P_END_DATE ’’’’ " x ay, Dept: ’’’’ / x - 9 Last, First Middle ’’’’ + x )an= Certification: ’’’’ $ x "an? Number: ’’’’ $ x " A Earned: ’’’’ % x #ctC Renewed: ’’’’’’’ % x # E Expires: ’’’’’’’ # x !G MFS ID ė’’’’ " x $ Type: 0 @ t’’’’ )00x " $& ' / r25g25b0@ @ ’’’’’’’ )00x " $& 'p 0 r50g25b0 @ 0’’’’ )00x " $& '§ 1 r75g25b0Ą @ ÅÅ’’’’ )00x " $& 'h 2 r88g25b0ą @ ’’’’ +00x $ &( ) 3 r100g25b0 ’’@ _’’’’ *00x" $ & (l 4 r0g25b50 @ x’’’’ ,00x $ & ( * 5 r25g25b50 @ @ ’’’’ ,00x $ & ( *ED 6 r50g25b50 @ ’’’’ ,00x $ & ( * 7 r75g25b50 Ą @ ’’’’ ,00x $ & ( *q 8 r88g25b50 ą @ ’’’’ ,00x $ & ( *p 9
r100g25b50’’@ ’’’’ *00x" $ & ( : r0g25b75 0@ Ą d ’’’’ ,00x $ & ( *NE ; r25g25b75 @ @ Ą ’’’’ ,00x $ & ( *v < r50g25b75 @ Ą ’’’’ ,00x $ & ( * = r75g25b75 Ą @ Ą ’’’’ ,00x $ & ( *pi > r88g25b75 ą @ Ą ’’’’ ,00x $ & ( *4 ?
r100g25b75’’@ Ą ’’’’ *00x" $ & ( @ r0g25b88 5@ ą Z’’’’ ,00x $ & ( *8l A r25g25b88 @ @ ą ’’’’ ,00x $ & ( * B r50g25b88 @ ą ’’’’ ,00x $ & ( *00 C r75g25b88 Ą @ ą P ’’’’ r ’’’’ 88 pn RIBS class attributes t’’’’ +hh )ROSLFDESC ros lf descrip ’’’’ )hh 'rVROSOBJMAP ros name->id
¤’’’’ +hh )
ROSSTRINGS tk2 uiStrings =’’’’ *hh (="ROSSTRUCTS struct types <’’’’ *hh (r=ROSTK2RESV tk2 reserved st’’’’ hh >
SRW2_ANCHOR d’’’’ &h!"h# $" SRW2_BODY_LOCATION dd’’’’ $h h! "SRW2_COLUMN <’’’’ #h h !etSRW2_DATA_MODEL e’’’’ $h h! "ntSRW2_DISPLAY_TAG ’’’’ %h !h" #5 SRW2_DISTRIBUTION & ati’’’’ h h SRW2_ELEMENT ’’’’ hh 8’’’’ +x )± Report run on: 0’’’’ :x 8 $¹ Certification Expiration List 0’’’’ 7x 50gš Expiration dates between: (’’’’ *x (’’š &P_START_DATE (’’’’ "x ’’š and ’’’’ (x &b1š &P_END_DATE ’’’’ " x ay, Dept: ’’’’ / x - 9 Last, First Middle ’’’’ + x )an= Certification: ’’’’ $ x "an? Number: ’’’’ $ x " A Earned: ’’’’ % x #ctC Renewed: ’’’’’’’ % x # E Expires: ’’’’’’’ # x !G MFS ID ė’’’’ " x $ Type: 0 @ t’’’’ )00x " $& ' / r25g25b0@ @ ’’’’’’’ )00x " $& 'p 0 r50g25b0 @ 0’’’’ )00x " $& '§ 1 r75g25b0Ą @ ÅÅ’’’’ )00x " $& 'h 2 r88g25b0ą @ ’’’’ +00x $ &( ) 3 r100g25b0 ’’@ _’’’’ *00x" $ & (l 4 r0g25b50 @ x’’’’ ,00x $ & ( * 5 r25g25b50 @ @ ’’’’ ,00x $ & ( *ED 6 r50g25b50 @ ’’’’ ,00x $ & ( * 7 r75g25b50 Ą @ ’’’’ ,00x $ & ( *q 8 r88g25b50 ą @ ’’’’ ,00x $ & ( *p 9
r100g25b50’’@ ’’’’ *00x" $ & ( : r0g25b75 0@ Ą d ’’’’ ,00x $ & ( *NE ; r25g25b75 @ @ Ą ’’’’ ,00x $ & ( *v < r50g25b75 @ Ą ’’’’ ,00x $ & ( * = r75g25b75 Ą @ Ą ’’’’ ,00x $ & ( *pi > r88g25b75 ą @ Ą ’’’’ ,00x $ & ( *4 ?
r100g25b75’’@ Ą ’’’’ *00x" $ & ( @ r0g25b88 5@ ą Z’’’’ ,00x $ & ( *8l A r25g25b88 @ @ ą ’’’’ ,00x $ & ( * B r50g25b88 @ ą ’’’’ ,00x $ & ( *00 C r75g25b88 Ą @ ą ` ’’’’ r ’’’’ 88 RIBS class attributes ’’’’ +hh )&'ROSLFDESC ros lf descrip C’’’’ )hh 'VWROSOBJMAP ros name->id qrs’’’’ +hh )ROSSTRINGS tk2 uiStrings £’’’’ *hh (¶·ROSSTRUCTS struct types ŅÓ’’’’ *hh (ęēROSTK2RESV tk2 reserved ’’’’ &h!"h# $ SRW2_BODY_LOCATION ’’’’ #h h ! SRW2_DATA_MODEL ’’’’ hh SRW2_LAYOUT
’’’’ hh SRW2_LISTS ’’’’ #h h ! SRW2_PARAM_FORM
’’’’ h h W2TOOL_LIBRARY ’’’’ hh ntTOOL_MODULE G’’’’ $pp "h"VG_COLOR VG_COLOR ’’’’ +pp $&'( )VG_COLOR ITEMID @ ’’’’’ +pp $&'( )VG_COLOR CELLID @ &’’’’ -pp &()* +VG_COLOR NAME_SET @ o’’’’ /pp (*+, -VG_COLOR NAME_LENGTH ’’’’ /pp (*+, -VG_COLOR COLOR_NAME x ’’’’ 'pp "#$ %VG_COLOR RED !’’’’ )pp "$%& 'VG_COLOR GREEN RW2’’’’ )pp "$%& 'VG_COLOR BLUE LAYOUT ’’’’ %h !h" # SRW2_LAYOUT_GROUP (’’’’ hh 0®SRW2_LINK =
=’’’’ hh SRW2_LISTS ay’’’’ hh 0SRW2_MATRIX ’’’’ 'h"#h$ %’’SRW2_OGD_COLUMN_MAP *’’’’ $h h! "’’SRW2_OG_DOCUMENT ’’’’ #h h !¢SRW2_PARAM_FORM "’’’’ hh 0 SRW2_QUERY 0’’’’ %h !h" # SRW2_TEXT_SEGMENT 0’’’’ hh TOOL_ACCESS ’’’’’ h h %TOOL_COMMENT ’’’’ h h TOOL_LIBRARY
’’’’ hh TOOL_MODULE $’’’’ hh TOOL_PLSQL ’’’’ $pp "5gVG_COLOR VG_COLOR ’’’’ +pp $&'( )VG_COLOR ITEMID @ ’’’’ +pp $&'( )VG_COLOR CELLID @ ’’’’ -pp &()* +VG_COLOR NAME_SET @ 0’’’’ /pp (*+, -VG_COLOR NAME_LENGTH ’’’’ /pp (*+, -VG_COLOR COLOR_NAME x &’’’’ 'pp "#$ %VG_COLOR RED "’’’’ )pp "$%& 'VG_COLOR GREEN "’’’’ )pp "$%& 'VG_COLOR BLUE "’’’’ #x ! Ą MFS ID ’’’’ #x !00 Alt Id ’’’’’ !x Last ą ’’’’ *x ( & Certification ’’’’ #x ! &” Number 8’’’’ #x !£ Earned ’’’’ $x "„ Renewed ’’’’ $x "R_§ Expires ’’’’ 7x 5b8® Page & f’’’’ +x )± Report run on: ’’’’ :x 8¹ Certification Expiration List ’’’’’’ 7x 5 (š Expiration dates between: ’’’’ *x (8gš &P_START_DATE 0’’’’ "x 00š and ’’’’’’ (x &UMš &P_END_DATE ’’’’ " x .R, Dept: ’’’’ / x - 9 Last, First Middle ’’’’’ + x )T_= Certification: ’’’’’ $ x "NI? Number: ’’’’ $ x " $A Earned: ’’’’ % x # C Renewed: 2G®’’’’ % x # E Expires: 8Qė’’’’ # x !!G MFS ID 2’’’’ " x Type: r25g25b0@ @ CT_’’’’ )00x " $& ' P 0 r50g25b0 @ (P’’’’ )00x " $& 'ER 1 r75g25b0Ą @ IP)’’’’ )00x " $& 'GA 2 r88g25b0ą @ ORG’’’’ +00x $ &( ) I 3 r100g25b0 ’’@ i’’’’ *00x" $ & (id 4 r0g25b50 @ E,’’’’ ,00x $ & ( *UP 5 r25g25b50 @ @ ’’’’ ,00x $ & ( *T_ 6 r50g25b50 @ ’’’’ ,00x $ & ( *( 7 r75g25b50 Ą @ ’’’’ ,00x $ & ( *ct 8 r88g25b50 ą @ ’’’’ ,00x $ & ( * 9
r100g25b50’’@ ’’’’ *00x" $ & (d : r0g25b75 0@ Ą '’’’’ ,00x $ & ( *pc ; r25g25b75 @ @ Ą ’’’’ ,00x $ & ( * < r50g25b75 @ Ą ’’’’ ,00x $ & ( *XP = r75g25b75 Ą @ Ą ’’’’ ,00x $ & ( * > r88g25b75 ą @ Ą ’’’’ ,00x $ & ( *d. ?
r100g25b75’’@ Ą ’’’’ *00x" $ & (’’ @ r0g25b88 5@ ą X’’’’ ,00x $ & ( *8h A r25g25b88 @ @ ą ’’’’ ,00x $ & ( * B r50g25b88 @ ą ’’’’ ,00x $ & ( *00 C r75g25b88 Ą @ ą p ’’’’X r ’’’’S
N¢(¦0Ŗ«¬@²@¶0ŗ0»@¾@Ā@Ę@Ź@Ī@Ņ0Ö0×ŲŁ0Ś0Ū0Ü0ŻŽpßpßpąąįāćäåę č0ź0ėģķ8ī8š0ņóō öųłśū@žA11A
AAAAA 1"1#A&A*1.1/A2A6A:A>ABAF1J1KLMNOPQdp ś č5 L °PB ` `
Ŗ 2’ jj Å L °PBW2 š ` ` L °PB š ` `
h h ! SRW2_DATA_MODEL ’’’’ hh SRW2_LAYOUT
’’’’ hh SRW2_LISTS ’’’’ #h h ! SRW2_PARAM_FORM
’’’’ h h W2TOOL_LIBRARY ’’’’ hh ntTOOL_MODULE G’’’’ $pp "h"VG_COLOR VG_COLOR ’’’’ +pp $&'( )VG_COLOR ITEMID @ ’’’’’ +pp $&'( )VG_COLOR CELLID @ &’’’’ -pp &()* +VG_COLOR NAME_SET @ o’’’’ /pp (*+, -VG_COLOR NAME_LENGTH ’’’’ /pp (*+, -VG_COLOR COLOR_NAME x ’’’’ 'pp "#$ %VG_COLOR RED !’’’’ )pp "$%& 'VG_COLOR GREEN RW2’’’’ )pp "$%& 'VG_COLOR BLUE LAYOUT ’’’’ %h !h" # SRW2_LAYOUT_GROUP (’’’’ hh 0®SRW2_LINK =
=’’’’ hh SRW2_LISTS ay’’’’ hh 0SRW2_MATRIX ’’’’ 'h"#h$ %’’SRW2_OGD_COLUMN_MAP *’’’’ $h h! "’’SRW2_OG_DOCUMENT ’’’’ #h h !¢SRW2_PARAM_FORM "’’’’ hh 0 SRW2_QUERY 0’’’’ %h !h" # SRW2_TEXT_SEGMENT 0’’’’ hh TOOL_ACCESS ’’’’’ h h %TOOL_COMMENT ’’’’ h h TOOL_LIBRARY
’’’’ hh TOOL_MODULE $’’’’ hh TOOL_PLSQL ’’’’ $pp "5gVG_COLOR VG_COLOR ’’’’ +pp $&'( )VG_COLOR ITEMID @ ’’’’ +pp $&'( )VG_COLOR CELLID @ ’’’’ -pp &()* +VG_COLOR NAME_SET @ 0’’’’ /pp (*+, -VG_COLOR NAME_LENGTH ’’’’ /pp (*+, -VG_COLOR COLOR_NAME x &’’’’ 'pp "#$ %VG_COLOR RED "’’’’ )pp "$%& 'VG_COLOR GREEN "’’’’ )pp "$%& 'VG_COLOR BLUE "’’’’ #x ! Ą MFS ID ’’’’ #x !00 Alt Id ’’’’’ !x Last ą ’’’’ *x ( & Certification ’’’’ #x ! &” Number 8’’’’ #x !£ Earned ’’’’ $x "„ Renewed ’’’’ $x "R_§ Expires ’’’’ 7x 5b8® Page & f’’’’ +x )± Report run on: ’’’’ :x 8¹ Certification Expiration List ’’’’’’ 7x 5 (š Expiration dates between: ’’’’ *x (8gš &P_START_DATE 0’’’’ "x 00š and ’’’’’’ (x &UMš &P_END_DATE ’’’’ " x .R, Dept: ’’’’ / x - 9 Last, First Middle ’’’’’ + x )T_= Certification: ’’’’’ $ x "NI? Number: ’’’’ $ x " $A Earned: ’’’’ % x # C Renewed: 2G®’’’’ % x # E Expires: 8Qė’’’’ # x !!G MFS ID 2’’’’ " x Type: r25g25b0@ @ CT_’’’’ )00x " $& ' P 0 r50g25b0 @ (P’’’’ )00x " $& 'ER 1 r75g25b0Ą @ IP)’’’’ )00x " $& 'GA 2 r88g25b0ą @ ORG’’’’ +00x $ &( ) I 3 r100g25b0 ’’@ i’’’’ *00x" $ & (id 4 r0g25b50 @ E,’’’’ ,00x $ & ( *UP 5 r25g25b50 @ @ ’’’’ ,00x $ & ( *T_ 6 r50g25b50 @ ’’’’ ,00x $ & ( *( 7 r75g25b50 Ą @ ’’’’ ,00x $ & ( *ct 8 r88g25b50 ą @ ’’’’ ,00x $ & ( * 9
r100g25b50’’@ ’’’’ *00x" $ & (d : r0g25b75 0@ Ą '’’’’ ,00x $ & ( *pc ; r25g25b75 @ @ Ą ’’’’ ,00x $ & ( * < r50g25b75 @ Ą ’’’’ ,00x $ & ( *XP = r75g25b75 Ą @ Ą ’’’’ ,00x $ & ( * > r88g25b75 ą @ Ą ’’’’ ,00x $ & ( *d. ?
r100g25b75’’@ Ą ’’’’ *00x" $ & (’’ @ r0g25b88 5@ ą X’’’’ ,00x $ & ( *8h A r25g25b88 @ @ ą ’’’’ ,00x $ & ( * B r50g25b88 @ ą ’’’’ ,00x $ & ( *00 C r75g25b88 Ą @ ą ’’’’d r ’’’’]0808Ø[ E E
Oracle HTML Navigator
$%& 'VG_COLOR GREEN "’’’’ )pp "$%& 'VG_COLOR BLUE "’’’’ #x ! Ą MFS ID ’’’’ #x !00 Alt Id ’’’’’ !x Last ą ’’’’ *x ( & Certification ’’’’ #x ! &” Number 8’’’’ #x !£ Earned ’’’’ $x "„ Renewed ’’’’ $x "R_§ Expires ’’’’ 7x 5b8® Page & f’’’’ +x )± Report run on: ’’’’ :x 8¹ Certification Expiration List ’’’’’’ 7x 5 (š Expiration dates between: ’’’’ *x (8gš &P_START_DATE 0’’’’ "x 00š and ’’’’’’ (x &UMš &P_END_DATE ’’’’ " x .R, Dept: ’’’’ / x - 9 Last, First Middle ’’’’’ + x )T_= Certification: ’’’’’ $ x "NI? Number: ’’’’ $ x " $A Earned: ’’’’ % x # C Renewed: 2G®’’’’ % x # E Expires: 8Qė’’’’ # x !!G MFS ID 2’’’’ " x Type: r25g25b0@ @ CT_’’’’ )00x " $& ' P 0 r50g25b0 @ (P’’’’ )00x " $& 'ER 1 r75g25b0Ą @ IP)’’’’ )00x " $& 'GA 2 r88g25b0ą @ ORG’’’’ +00x $ &( ) I 3 r100g25b0 ’’@ i’’’’ *00x" $ & (id 4 r0g25b50 @ E,’’’’ ,00x $ & ( *UP 5 r25g25b50 @ @ ’’’’ ,00x $ & ( *T_ 6 r50g25b50 @ ’’’’ ,00x $ & ( *( 7 r75g25b50 Ą @ ’’’’ ,00x $ & ( *ct 8 r88g25b50 ą @ ’’’’ ,00x $ & ( * 9
r100g25b50’’@ ’’’’ *00x" $ & (d : r0g25b75 0@ Ą '’’’’ ,00x $ & ( *pc ; r25g25b75 @ @ Ą ’’’’ ,00x $ & ( * < r50g25b75 @ Ą ’’’’ ,00x $ & ( *XP = r75g25b75 Ą @ Ą ’’’’ ,00x $ & ( * > r88g25b75 ą @ Ą ’’’’ ,00x $ & ( *d. ?
r100g25b75’’@ Ą ’’’’ *00x" $ & (’’ @ r0g25b88 5@ ą X’’’’ ,00x $ & ( *8h A r25g25b88 @ @ ą ’’’’ ,00x $ & ( * B r50g25b88 @ ą ’’’’ ,00x $ & ( *00 C r75g25b88 Ą @ ą ’’’’“ r ’’’’ ,00x $ & ( *E D r88g25b88 ą @ ą ’’’’ ,00x $ & ( *EA E
r100g25b88’’@ ą ’’’’ *00x# $ & (in F r0g25b100 @ ’’to’’’’ ,00x $ & ( * & G
r25g25b100@ @ ’’’’’’ ,00x $ & ( *fi H
r50g25b100 @ ’’’’’’ ,00x $ & ( *il I
r75g25b100Ą @ ’’’’’’ ,00x $ & ( * t J
r88g25b100ą @ ’’’’’’ .00x & ( * ,ge K r100g25b100 ’’@ ’’e ’’’’ $00x ! "[0 L red ’’ ’’’’ (00x "$% &pa M darkred ’’’’ $00x "/
N blue ’’’’’’ (00x"# $ &t O darkblue ’’’’ (00x " $ & j P gray64\(\(\(’’’’ (00x " $ &
Q gray60ffffff’’’’ (00x " $ &rw R gray56p£p£p£’’’’ (00x " $ & * S gray52zįzįzį’’’’ '00x! "$ %nd T r0g50b0 e’’’’ )00x " $& '/* U r25g50b0@ */’’’’ )00x " $& 'f( V r50g50b0 {
’’’’ )00x " $& 'ge W r75g50b0Ą );
’’’’ )00x " $& '/
X r88g50b0ą m)
’’’’ +00x $ &( )ge Y r100g50b0 ’’ =’’’’ *00x" $ & (m, Z r0g50b50
’’’’ ,00x $ & ( *d [ r25g50b50 @ ’’’’ ,00x $ & ( *ni \ r50g50b50 ’’’’ ,00x $ & ( *fo ] r75g50b50 Ą ’’’’ ,00x $ & ( *ue ^ r88g50b50 ą ’’’’ ,00x $ & ( *ge _
r100g50b50’’ ’’’’ *00x" $ & (ag ` r0g50b75 0 Ą );’’’’ ,00x $ & ( *Y> a r25g50b75 @ Ą ’’’’ ,00x $ & ( *; b r50g50b75 Ą ’’’’ ,00x $ & ( *T c r75g50b75 Ą Ą ’’’’ ,00x $ & ( *.f d r88g50b75 ą Ą ’’’’ ,00x $ & ( *on e
r100g50b75’’ Ą ’’’’ *00x" $ & (to f r0g50b88 5 ą on’’’’ ,00x $ & ( *>
g r25g50b88 @ ą ’’’’ ,00x $ & ( *td h r50g50b88 ą ’’’’ ,00x $ & ( *or i r75g50b88 Ą ą ’’’’ ,00x $ & ( *AL j r88g50b88 ą ą ’’’’ ,00x $ & ( *ce k
r100g50b88’’ ą ’’’’ *00x# $ & (GR l r0g50b100 ’’’’’’ ,00x $ & ( *BL m
r25g50b100@ ’’’’’’ ,00x $ & ( *S n
r50g50b100 ’’’’’’ ,00x $ & ( *’’ o
r75g50b100Ą ’’’’’’ ,00x $ & ( * p
r88g50b100ą ’’’’’’ .00x & ( * , q r100g50b100 ’’ ’’mb’’’’ '00x "$ % r yellow’’’’ ’’’’ +00x $ &( ) s
darkyellow ’’’’ *00x "$ & (pi t magenta ’’ ’’’’’’ .00x &( * ,si u darkmagenta ’’’’ (00x " $ &po v gray48
’’’’ (00x " $ & w gray44\\\’’’’ (00x " $ & x gray40’’’’ (00x " $ &en y gray36£×£×£×’’’’ '00x! "$ %RT z r0g75b0 Ą ’’’’ )00x " $& 'nd { r25g75b0@ Ą ’’’’ )00x " $& 'E | r50g75b0 Ą x’’’’ )00x " $& ' } r75g75b0Ą Ą 9 ’’’’ )00x " $& '’’ ~ r88g75b0ą Ą )T_’’’’ +00x $ &( )’’ r100g75b0 ’’Ą I’’’’ .08x & ( * , 00r0g75b50 ĄĄ rn’’’’ 008x ( * , . 00r25g75b50 @ Ą ’’’’ 008x ( * , . 00r50g75b50 Ą ’’’’ 008x ( * , . 2 00r75g75b50 Ą Ą ’’’’ 008x ( * , .@ 00r88g75b50 ą Ą ’’’’ 008x ( * , .(P
00r100g75b50’’Ą ’’’’ .08x & ( * ,’’ 00r0g75b75 0Ą Ą GA’’’’ 008x ( * , . 00r25g75b75 @ Ą Ą ’’’’ 008x ( * , .0 00r50g75b75 Ą Ą ’’’’ 008x ( * , . 00r75g75b75 Ą Ą Ą ’’’’ 008x ( * , . $ 00r88g75b75 ą Ą Ą ’’’’ 008x ( * , . (
00r100g75b75’’Ą Ą ’’’’ .08x & ( * ,ct 00r0g75b88 5Ą ą ’’’’’’ 008x ( * , .
00r25g75b88 @ Ą ą ’’’’ 008x ( * , .g2 00r50g75b88 Ą ą ’’’’ 008x ( * , .b7 00r75g75b88 Ą Ą ą ’’’’ 008x ( * , . 00r88g75b88 ą Ą ą ’’’’ 008x ( * , .Ą
00r100g75b88’’Ą ą ’’’’ .08x ' ( * ,’’ 00r0g75b100 Ą ’’d.’’’’ 008x ( * , .
00r25g75b100@ Ą ’’’’’’ 008x ( * , .0
00r50g75b100 Ą ’’’’’’ 008x ( * , .
00r75g75b100Ą Ą ’’’’’’ 008x ( * , . $
00r88g75b100ą Ą ’’@ ą ’’’’p r ’’’’ 208x * , . 0E 00r100g75b100 ’’Ą ’’’’’’ .08x & ( * ,00 00custom1 ’’’’’’0’’’’ .08x & ( * ,10 00custom2 ’’’’’’’’’’ .08x & ( * ,@ 00custom3 ’’’’’’ $’’’’ .08x & ( * ,’’ 00custom4 ’’’’’’ (’’’’ ,08x $ & ( *’’ 00gray32®®®’’’’ ,08x $ & ( *’’ 00gray28øQøQøQ’’’’ ,08x $ & ( *e 00gray24ĀĀĀ’’’’ ,08x $ & ( * 00gray20ĢĢĢĢĢĢ’’’’ +08x % &( )0 00r0g88b0 ą ’’’’ -08x & (* +" ” 00r25g88b0@ ą ’’’’ -08x & (* + j ¢ 00r50g88b0 ą (’’’’ -08x & (* +ay £ 00r75g88b0Ą ą ’’’’ -08x & (* +p£ ¤ 00r88g88b0ą ą " $’’’’ /08x ( *, - „ 00r100g88b0 ’’ą ’’’’ .08x & ( * , ¦ 00r0g88b50 ą b0’’’’ 008x ( * , . " § 00r25g88b50 @ ą ’’’’ 008x ( * , .& Ø 00r50g88b50 ą ’’’’ 008x ( * , ./
© 00r75g88b50 Ą ą ’’’’ 008x ( * , . Ŗ 00r88g88b50 ą ą ’’’’ 008x ( * , .g5 «
00r100g88b50’’ą ’’’’ .08x & ( * ,b5 ¬ 00r0g88b75 0ą Ą ’’’’ 008x ( * , . 00r25g88b75 @ ą Ą ’’’’ 008x ( * , . ® 00r50g88b75 ą Ą ’’’’ 008x ( * , .’’ Æ 00r75g88b75 Ą ą Ą ’’’’ 008x ( * , . ° 00r88g88b75 ą ą Ą ’’’’ 008x ( * , .0 ±
00r100g88b75’’ą Ą ’’’’ .08x & ( * , ² 00r0g88b88 5ą ą b7’’’’ 008x ( * , . $ ³ 00r25g88b88 @ ą ą ’’’’ 008x ( * , . ( “ 00r50g88b88 ą ą ’’’’ 008x ( * , .on µ 00r75g88b88 Ą ą ą ’’’’ 008x ( * , . ¶ 00r88g88b88 ą ą ą ’’’’ 008x ( * , .5g ·
00r100g88b88’’ą ą ’’’’ .08x ' ( * ,b8 ø 00r0g88b100 ą ’’’’’’ 008x ( * , .Ą ¹
00r25g88b100@ ą ’’’’’’ 008x ( * , .ą ŗ
00r50g88b100 ą ’’’’’’ 008x ( * , .’’ »
00r75g88b100Ą ą ’’’’’’ 008x ( * , . ¼
00r88g88b100ą ą ’’’’’’ 208x * , . 00 ½ 00r100g88b100 ’’ą ’’b1’’’’ .08x & ( * , $ ¾ 00custom5 ’’’’’’Ą ’’’’ .08x & ( * , ( æ 00custom6 ’’’’’’’’’’’’ .08x & ( * , Ą 00custom7 ’’’’’’mb’’’’ .08x & ( * , Į 00custom8 ’’’’’’’’’’ ,08x $ & ( *rk Ā 00gray16×
×
×
’’’’ ,08x $ & ( *ge Ć 00gray12įGįGįG’’’’ ,08x $ & ( *rk Ä 00gray8 ė
ė
ė
’’’’ ,08x $ & ( * Å 00gray4 õĀõĀõĀ’’’’ -08x & (* +ay Ę 00r0g100b0 õ’’ ’’’’ /08x ( *, - Ē 00r25g100b0 @ ’’ $’’’’ /08x ( *, - Č 00r50g100b0 ’’ ’’’’ /08x ( *, - É 00r75g100b0 Ą ’’ 0’’’’ /08x ( *, - " Ź 00r88g100b0 ą ’’ ’’’’ /08x ( *, -& Ė
00r100g100b0’’’’ ’’’’ .08x ' ( * ,’’ Ģ 00r0g100b50 ’’ ’’’’’’ 008x ( * , . Ķ
00r25g100b50@ ’’ ’’’’ 008x ( * , .00 Ī
00r50g100b50 ’’ ’’’’ 008x ( * , .00 Ļ
00r75g100b50Ą ’’ ’’’’ 008x ( * , .00 Š
00r88g100b50ą ’’ ’’’’ 208x * , . 000 Ń 00r100g100b50 ’’’’ 8’’’’ .08x ' ( * ,8g Ņ 00r0g100b75 ’’Ą 8’’’’ 008x ( * , .00 Ó
00r25g100b75@ ’’Ą ’’’’ 008x ( * , .g7 Ō
00r50g100b75 ’’Ą ’’’’ 008x ( * , .5g Õ
00r75g100b75Ą ’’Ą ’’’’ 008x ( * , .0g Ö
00r88g100b75ą ’’Ą ’’’’ 208x * , . 05g × 00r100g100b75 ’’’’Ą ’’’’ .08x ' ( * ,b7 Ų 00r0g100b88 ’’ą ’’’’ 008x ( * , .5b Ł
00r25g100b88@ ’’ą ’’’’ 008x ( * , .88 Ś
00r50g100b88 ’’ą ’’’’ 008x ( * , .b8 Ū
00r75g100b88Ą ’’ą ’’’’ 008x ( * , .b8 Ü
00r88g100b88ą ’’ą ’’’’ 208x * , . 0b8 Ż 00r100g100b88 ’’’’ą (’’’’ 008x ( * , .ą Ž
00r0g100b100 ’’’’’’’’ 208x * , . 0’’ ß 00r25g100b100 @ ’’’’ *’’’’ 208x * , . 0d. ą 00r50g100b100 ’’’’’’’’ 208x * , . 0’’ į 00r75g100b100 Ą ’’’’ ’’’’ 208x * , . 0 ā 00r88g100b100 ą ’’’’00r75g75b100Ą Ą ’’’’’’ 008x ( * , . $
00r88g75b100ą Ą ’’@ ą ° ’’’’ r ’’’’ 208x * , . 0E ć 00r100g100b100’’’’’’’’’’ ] >p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ [ ’ ’L ’’’’’’’ ] >p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ [Ŗ ’ ’ m4 ’’’’ ] >p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ [Æ q ’ ’ 8øQ’’’’ b >p?p?p?0EFGHIJKLMNOP RTUVWXYZ[\]^_ `°Arial č ’’’’’’ ] >p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ [² ri ’ ’ ’’’’’’’ b >p?p?p?0EFGHIJKLMNOP RTUVWXYZ[\]^_ `³Arial č ’’’’’’ b >p?p?p?0EFGHIJKLMNOP RTUVWXYZ[\]^_ `µArial ’ ’ č ’’’’’’ ] >p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ [Č ri ’O’Ā ’’’’ ] >p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ [Ķ ri ’ OĀ Ą ’’’’ ] >p?p?pB0BCDEFGHIJKLMNOPQRSTUVWXYZ [ń ri ’ ’L 88b’’’’ h >p?p?p?0KLMNOPQRSTUV XZ[\]^_`abcde fóCourier New ’ ’ ° ’’’’ b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_ `Arial ° Ą ’’’’ a >p@p@p@0FGHIJKLMNOPQRSTUVWXYZ[\]^ _Arial 5’’’’’’ b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_ `%Arial x @ ’’’’ b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_ `IArial X Ą ’’’’ b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_ `NArial X ’’’’’’ b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_ `RArial L @ ’’’’ b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_ `Arial ’ ’ č Ą ’’’’ b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_ `Arial ’ ’ č 0 ’’’’ b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_ `µArial č 6 ’’’’ a >p@p@p@0FGHIJKLMNOPQRSTUVWXYZ[\]^ _ÅArial ’ ’L m8 ’’’’ b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_ `Arial ’ ’ ° įG’’’’ b >p@p@p@0FGHIJKLMNOPQ RTUVWXYZ[\]^_ ` Arial ’ ’ č ’’’’ 5p&*+.2 3ōb_1formattrigger š ’’’’ A p. 24:> ? b_date1_sec1formattrigger 00’’’’ [
p p,pCPQR0S0TUVWX YjALTERNATE_ID PS_PERSON.ALTERNATE_ID ALTERNATE_ID g "’’’’ U
p p*p?JKL0M0NOPQR SmFIRST_NAME PS_PERSON.FIRST_NAME FIRST_NAME g ’’’’ X
p p+pAMNO0P0QRSTU VpMIDDLE_NAME PS_PERSON.MIDDLE_NAME MIDDLE_NAME g ’’’’ R
p p)p=GHI0J0KLMNO PsLAST_NAME PS_PERSON.LAST_NAME LAST_NAME g 5g’’’’ I
p p&p7>?@0A0BCDEF GvACTIVE PS_PERSON.ACTIVE ACTIVE g ’’’’ J
p p$p:?@A0B0CDEFG HyNAME CT_CERTIFICATION.NAME NAME 2 g g1’’’’ r
p p2pTghi0j0klmno p|CERTIFICATE_NUMBER CT_CERTIFICATE.CERTIFICATE_NUMBER CERTIFICATE_NUMBER g ’’’’’’ N
p p&p<CDE0F0GHIJK LEARNED CT_CERTIFICATE.EARNED EARNED g 00’’’’ Q
p p'p>FGH0I0JKLMN ORENEWED CT_CERTIFICATE.RENEWED RENEWED
g ’’’’ Q
p p'p>FGH0I0JKLMN O
EXPIRES CT_CERTIFICATE.EXPIRES EXPIRES g ’ą ’’’’ =
p p"p/2340506789: ;id PS_PERSON.ID ID
g ’’’’ R
p p)p>GHI0J0KLMNO PORG_NAME PS_ORGANIZATION.NAME ORG_NAME d g ą ’’’’ B &p(,-.p2p2p223486888:8<>? @@Q_1 O0 «
» ’’’’ FpHWXYZ \^0_`a0bcd0efghixj8j8l8n8p rtpupup p
p 5gAG_ALTERNATE_ID gC& #d.9Ń4 G_ALTERNATE_ID LIST_G_ALTERNATE_ID ’’’’ FpHSTUVWX0YZ[0\]^0_`abcxf8f8h8j8lnoppppp{ {p|p ā’G_ORG_NAME g +ķ>f(&
Č G_ORG_NAME LIST_G_ORG_NAME
00r88g75b100ą Ą ’’@ ą Ą ’’’’Ü r ’’’’ ²/ bpdmnopqrpvvpwp{{|}~000000
p ”¢p£p££¤„¦p§pŖŖ«¬p®p®®Æ °2PRINTJOB
G_ Yes P Show Print Job Dialog Kg G’’’’ Ŗ/ bpdijklmnprrpsp{{|}~000000
ppppp¢¢£¤„p¦p¦¦§ Ø3MODE Default P Output Mode ’’’’’’ ®/ bpdopqrstpzzp{p~~000
000p ”p¢p¢¢£¤„p¦p¦¦§Ø©pŖpŖŖ« ¬4BACKGROUND ault No P Run in Background ’’’’ ®/ bpdpqrstupvvpwp00
0000ppp p”p¦¦§Ø©pŖpŖŖ« ¬5ORIENTATION
Default P Orientation Z’’’’ ¦/ bpdlmnopqprrpspsstuvw0x0y0z0{0|0}p~pppp ”p¢p¢¢£ ¤6DECIMAL Decimal Indicator E’’’’ ®/ bpdnopqrspvvpwpwwxyz{0|0}0~000ppp p”p¦¦§Ø©pŖpŖŖ« ¬7THOUSANDS Thousands Indicator ’’’’’’ ¦/ bpdmnopqrpvvpwpwwxy z|0}0~0000ppppp ”p¢p¢¢£ ¤8CURRENCY Currency Symbol `’’’’ Ŗ/ bpdklmnoppvvpwpyyz{|}0~00000pppp p¢¢£¤„p¦p¦¦§ Ø9COPIES 1 Number of Copies O’’’’ ²/ bpdnopqrspvvpwp||}~ 000
000p ”¢p£p££¤„¦p§pŖŖ«¬p®p®®Æ °:DESFORMAT dflt Destination Format p@’’’’ ¦/ bpdlmnopqprrpspsstu vx0y0z0{0|0}0~ppppp ”p¢p¢¢£ ¤;DESNAME Destination Name ’’’’ ®/ bpdlmnopqprrpspzz{|}~000000p
pp p”p¦¦§Ø©pŖpŖŖ« ¬f(&
Č G_ORG_NAME LIST_G_ORG_NAME
00r88g75b100ą Ą ’’@ ą Š ’’’’@ r ’’’’ ©/ bpdghijklprrpspsstuvw0x0y0z0{0|0}p~( pppp ”p¢p„„¦ §`id
h h
!
MFS ID _ ŌĄ ' ID Kg’’’’ «/ bpdqrstuvpzzp{p{{|}~000000
ppppppp§§Ø ©§P_start_date
P_START_DATE ’’’’ ©/ bpdopqrstpzzp{p{{|}~000000
ppppppp„„¦ §ØP_end_date
P_END_DATE ’’’’ °/ bpdmn pr tvpzzp{p{{|}~000000
p( pppp¢¢£¤„p¦p¬¬ ®ļORG_NAME &
d Name1 ' D_DA NAME1 ’’’’ ¤/ bpdnopqrspvvpwpwwxyz{0|0}0~000p
pppppp ” ¢¾P_TYPE_ID P_TYPE_ID ’’’’ Ć* Zp\lm(nprpr8r@v8z8|~x00 0”0¢£¤„¦0§0Øp®®²0¶·ø¹ŗ»¼½¾æĄ ĮB_PAGENUM1_SEC2 Æ0 l TH N @«U )
AN l N @« U PS_ ’D ¼Č ’’’’’ æ* Zp\ij(nprpr8r8t8v8xz{|x0000 ”¢0£0¤pŖŖ®0²³“µ¶·ø¹ŗ»¼ ½¢B_DATE1_SEC2 ² Æ0
U )
U U ’ v’’’’ Å* Zp\no(rpvpv8v8x@z8~x00 0”0¢£¤„¦0§0Øp®®²0¶·ø¹ŗ»¼½¾ ĄĀ Ć B_OR$BODY_SECTION Ŗ 00 +õ øV
+õ ø V ’D p’’’’ ³* Zp\`a(bpfpf8f8h@j8npqrxv000000p¢0¦§Ø©Ŗ«¬®Æ° ±tiÉB_1 ń0 S U 0 S U +õ ’ ’’’’ ¾* Zp\gh(nprpr0r0s8t8vxyzx~000000 p¦¦Ŗ0®Æ °²³“µ¶· ø ŗ ¼ B_ORG_NAME ’ * µ) p”p¦¦§Ø©pŖpŖŖ« ¬f(&
Č G_ORG_NAME LIST_G_ORG_NAME
00r88g75b100ą Ą ’’@ ą ą ’’’’Ü r ’’’’×0808ØÕ æ æ 1
° $" æ B_1FORMATTRIGGER m A «Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ wÄ SYS STANDARD $ «Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ 0 8 "PKG INIT"B_1FORMATTRIGGER"" n 9 ’’ $ «Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ 0 8
0 Ż
L "FUNCTION"B_1FORMATTRIGGER"RETURN"BOOLEAN"P_START_DATE""IS NULL"FALSE"TRUE""
# $ ( 3 5 7 : > A F J K R T X [ _ c f j l p r y h , “ ± · < Z . | “ ¼ · e Z e Z O ¤ µ ó ¬
"
’
’’ d ’’ «Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ 0 D
: : ķ ä d Ś % % hg ! x H 0 B_1FORMATTRIGGER )
4 \ ` @ @ B_ORG_NAME ’ * µ) p”p¦¦§Ø©pŖpŖŖ« ¬f(&
Č G_ORG_NAME LIST_G_ORG_NAME
00r88g75b100ą Ą ’’@ ą š ’’’’ r ’’’’,0808Ø* 1
° $" B_DATE1_SEC1FORMATTRIGGER ¹ A «Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ wÄ SYS STANDARD $ «Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ 0 8 % "PKG INIT"B_DATE1_SEC1FORMATTRIGGER"" n 9 ’’ $ «Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ 0 8
" " " " 4 ŗ
e e A R "FUNCTION"B_DATE1_SEC1FORMATTRIGGER"RETURN"BOOLEAN"P_TYPE_ID""IS NULL"FALSE"TRUE"" J
# $ ( 3 5 7 : > A F J K R T X [ _ c f j l p r y
h , “ ± · < Z . | “ ¼ · e Z e Z O ¤ µ ó ü c Q ¬
+
’
!
’’ d ’’ «Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ«Ķ 0 D
: : ż ( ä p Ś % % hg !Ø Ø T 0 B_DATE1_SEC1FORMATTRIGGER $ )
4 h l @ @ ’’’’¾0808ؼ ¦ ¦SELECT ALL PS_PERSON.ALTERNATE_ID, PS_PERSON.ID, PS_PERSON.FIRST_NAME,
PS_PERSON.MIDDLE_NAME, PS_PERSON.LAST_NAME, PS_PERSON.ACTIVE, CT_CERTIFICATION.NAME,
CT_CERTIFICATE.CERTIFICATE_NUMBER, CT_CERTIFICATE.EARNED, CT_CERTIFICATE.RENEWED,
CT_CERTIFICATE.EXPIRES, PS_ORGANIZATION.NAME as ORG_NAME
FROM CT_CERTIFICATION, CT_CERTIFICATE, PS_PERSON, PS_MEMBERSHIP, PS_ORGANIZATION
WHERE
(PS_PERSON.ACTIVE = 'YES'
AND CT_CERTIFICATE.EXPIRES BETWEEN NVL(:P_START_DATE, CT_CERTIFICATE.EXPIRES) AND NVL(:P_END_DATE, CT_CERTIFICATE.EXPIRES))
AND ((CT_CERTIFICATE.CT_CERTIFICATION_ID = CT_CERTIFICATION.ID)
AND (CT_CERTIFICATE.PS_PERSON_ID = PS_PERSON.ID)
AND (PS_MEMBERSHIP.ID (+) = PS_PERSON.MAIN_MEMBERSHIP)
AND (PS_MEMBERSHIP.PS_ORGANIZATION_ID = PS_ORGANIZATION.ID(+))) AND LEFT IS NULL
and ct_type_id=nvl(:P_TYPE_ID, ct_type_id)
ORDER BY ORG_NAME, CT_CERTIFICATE.EXPIRES,
UPPER(PS_PERSON.LAST_NAME), UPPER(PS_PERSON.FIRST_NAME) „’’’’ **66O(R VZąZ(fjąj(vzz(z(~( RUNONLY ct_expiration_list_dept -l bĪ šKg
u pppp¢¢£¤„p¦p««¬ QNAME h y 2! Certification ' ACTI NAME I’’’’ É/ bpdwxyz{|ppp
000000p( ¢£¤p„p„„¦§Øp©p®®Æ°±p²pÅÅĘ ĒTCERTIFICATE_NUMBER h | Cert ! Number ' ' CERTIFICATE_NUMBER RNE’’’’ ±/ bpdklmnoppvvpwpwwxyz{0|0}0~000p( pppp¢¢£¤„p¦p® ÆWEARNED h MBER ! Earned _ ' ' EARNED ES ’’’’ Ŗ/ bpdlmnopqprrpspsstuvw0x0y0z0{0|0}p~( pppppp¦¦§ ØZRENEWED h ! Renewed _ ' RENEWED ’’’’ Ŗ/ bpdlmnopqprrpspsstuvw0x0y0z0{0|0}p~( pppppp¦¦§ Ø]EXPIRES h
! Expires _ ' EXPIRES #d.9Ń4 G_ALTERNATE_ID LIST_G_ALTERNATE_ID ’’’’ FpHSTUVWX0YZ[0\]^0_`abcxf8f8h8j8lnoppppp{ {p|p ā’G_ORG_NAME g +ķ>f(&
Č G_ORG_NAME LIST_G_ORG_NAME
00r88g75b100ą Ą ’’@ ą ’’’’$ r ’’’’ ~ BpDUV(Zp^p^0^8`@b8fhijk0l0m0n0o0p0qr0s0tuvwxyz{ |R_G_ALTERNATE_ID ŖR Ķ0 ņ h ’ ’’’’ # JpLYZ(^pbpb8b8d8f8hjklmnopqr0s0t0upvp0 F_DATE1_SEC2 µ 00 (Ŗ 6«U ’fmMonth DD, RRRR HH:fmMI AM ’’’’ # JpL XZ(^pbpb8b0d@j8npqrst vxyz0{0|0}p~p~0~
F_ORG_NAME 2 0 «6U ¾ ’ ’ ¾)’’’’ # JpL Z\(bpfpf8f8h8j8lnopqrstuv0w0x0ypzpz0z{|}~
F_FIRST_NAME 0 0 X ( l ’ ’/’’’’ # JpL Z\(bpfpf@f8j8l8npqrstuvwx0y0z0{p|p~0~
F_MIDDLE_NAME 0 0 0 o ’ ’/’’’’ # JpL XZ(^pbpb8b8d8f8hjklmnopqr0s0t0upvpv0vwxyz{|} ~ F_LAST_NAME 00 & , r ’ ’/’’’’ # JpL TV(Zp^p^8^8`8b8dfghijklmn0o0p0qprpr0rstuvwxy z | ~F_NAME N N T x ’ ’/’’’’ # JpL bd(jpnpn8n8p8r8tvwxyz{|}~000pp0
F_CERTIFICATE_NUMBER
N @ { ’ ’/’’’’ # JpL VX(^pbpb@b8f8h8jlmnopqrst0u0v0wpxp0 F_EARNED C_NUMB0 Ų ~ ’MM/DD/RR ž/’’’’ # JpL VX(^pbpb@b8f8h8jlmnopqrst0u0v0wpxp0 F_RENEWED _NUMB Ų ’MM/DD/RR ž/’’’’ # JpL VX(^pbpb@b8f8h8jlmnopqrst0u0v0wpxp0 F_EXPIRES _NUMB Ų ’MM/DD/RR ž/’’’’ # JpL RT(Zp^p^0^8`8b8dfghijklmn0o0p0qprpr0rstuvwxy z | ~ F_id I _0 D’ /’’’’ # JpL TV(Zp^p^@^8b8d8fhijkl npqr0s0t0upvp0 āF_TYPE _0 ØŖ 6«U Då ’fmMonth DD, RRRR HH:fmMI AM LT’’’’ ^%./0(6:p;STpUpUUVWpXpXXYZp[p[[ \šópp0’’’’ (:P_start_date IS NULL) Ī uu SO’’’’ X% .01(26p7 LNpOpOOPQpRpRRSTpUpUU Vó’’’’ (:P_TYPE_ID IS NULL) å uu CT_CERTIFICATE.RENEWED,
CT_CERTIFICATE.EXPIRES, PS_ORGANIZATION.NAME as ORG_NAME
FROM CT_CERTIFICATION, CT_CERTIFICATE, PS_PERSON, PS_MEMBERSHIP, PS_ORGANIZATION
WHERE
(PS_PERSON.ACTIVE = 'YES'
AND CT_CERTIFICATE.EXPIRES BETWEEN NVL(:P_START_DATE, CT_CERTIFICATE.EXPIRES) AND NVL(:P_END_DATE, CT_CERTIFICATE.EXPIRES))
AND ((CT_CERTIFICATE.CT_CERTIFICATION_ID = CT_CERTIFICATION.ID)
AND (CT_CERTIFICATE.PS_PERSON_ID = PS_PERSON.ID)
AND (PS_MEMBERSHIP.ID (+) = PS_PERSON.MAIN_MEMBERSHIP)
AND (PS_MEMBERSHIP.PS_ORGANIZATION_ID = PS_ORGANIZATION.ID(+))) AND LEFT IS NULL
and ct_type_id=nvl(:P_TYPE_ID, ct_type_id)
ORDER BY ORG_NAME, CT_CERTIFICATE.EXPIRES,
UPPER(PS_PERSON.LAST_NAME), UPPER(PS_PERSON.FIRST_NAME) „’’’’ **66O(R VZąZ(fjąj(vzz(z(~( RUNONLY ct_expiration_list_dept -l bĪ šKg
u pppp¢¢£¤„p¦p««¬ QNAME h y 2! Certification ' ACTI NAME I’’’’ É/ bpdwxyz{|ppp
000000p( ¢£¤p„p„„¦§Øp©p®®Æ°±p²pÅÅĘ ĒTCERTIFICATE_NUMBER h | Cert ! Number ' ' CERTIFICATE_NUMBER RNE’’’’ ±/ bpdklmnoppvvpwpwwxyz{0|0}0~000p( pppp¢¢£¤„p¦p® ÆWEARNED h MBER ! Earned _ ' ' EARNED ES ’’’’ Ŗ/ bpdlmnopqprrpspsstuvw0x0y0z0{0|0}p~( pppppp¦¦§ ØZRENEWED h ! Renewed _ ' RENEWED ’’’’ Ŗ/ bpdlmnopqprrpspsstuvw0x0y0z0{0|0}p~( pppppp¦¦§ Ø]EXPIRES h
! Expires _ ' EXPIRES #d.9Ń4 G_ALTERNATE_ID LIST_G_ALTERNATE_ID ’’’’ FpHSTUVWX0YZ[0\]^0_`abcxf8f8h8j8lnoppppp{ {p|p ā’G_ORG_NAME g +ķ>f(&
Č G_ORG_NAME LIST_G_ORG_NAME
00r88g75b100ą Ą ’’@ ą ’’’’
4 r ’’’’ ¾* Zp\hi(jpnpn8n8p8r8tvwxx~000000 p¦¦Ŗ0®Æ °²³“µ¶·ø ŗ ¼ ĶB_LAST_NAME
0 ( , ( , ’ 8 .’’’’ ¾* Zp\cd(jpnpn8n8p8r8tvwxx~000000 p¦¦Ŗ0®Æ °²³“µ¶·ø ŗ ¼ B_NAME ME
, , ’ < .’’’’ Ź* Zp\qr(vpzpz8z8|8~8x0¢£0¤0„0¦§Ø©Ŗ0«0¬p²²¶0ŗ» ¼¾æĄĮĀĆÄ Ę ČvB_CERTIFICATE_NUMBER 4 4 ’ < > .pf’’’’ ¾* Zp\ef(jpnpn@n8r8t8vxyzx~000000 p¦¦Ŗ0®Æ °²³“µ¶·ø ŗ ¼0 B_EARNED TE_0 ¼ 4 ¼ ’ @ .|’’’’ ¾* Zp\fg(jpnpn@n8r8t8vxyzx~000000 p¦¦Ŗ0®Æ °²³“µ¶·ø ŗ ¼f B_RENEWED E_0 ¼ 4 ¼ ’ B ./’’’’ ¾* Zp\fg(jpnpn@n8r8t8vxyzx~000000 p¦¦Ŗ0®Æ °²³“µ¶·ø ŗ ¼E_ B_EXPIRES E_0 ¼ 4 ¼ ’ D .t’’’’ ŗ* Zp\ab(fpjpj0j8l8n8prstxz000000p¢¢¦0Ŗ« ¬®Æ°±²³“ ¶ ø B_id ES 0 ’ F .NE’’’’ æ* Zp\ij(nprpr@r8v8x8z|}~x0000 ”¢0£0¤pŖŖ®0²³“µ¶·ø¹ŗ»¼ ½ląB_DATE1_SEC1 ² 0 U U ’ /’’’’
I’’’’
I’’’’
I’’’’
N’’’’
” N’’’’
£ N’’’’
„ N’’’’
§ N’’’’
® °d’’’’
± ³r’’’’
¹ %’’’’
š ’’’’
š’’’’
š’’’’
š’’’’
, R%’’’’
9 °’’’’
= ³’’’’
? ³’’’’
A ³’’’’
C ³’’’’
E ³µP’’’’
G °’’’’
³’’’’ BpDWX(^pbpb0b0c@f8jl npq0r0s0t0u0v0wx0y0z{|}~ M_G_ORG_NAME_GRPFR Č p p 0 P_ ņ " & ’ ÆE,’’’’ ~ BpDQR(VpZpZ0Z0[@^8bd fhi0j0k0l0m0n0op0q0rstuvwx z |R_G_ORG_NAME ŖPFR0 ņ " _& ’ ±, ’’’’ BpD[\(bpfpf0f8h@j8npqrs0t0u0v0w0x0yz0{0|}~ M_G_ALTERNATE_ID_GRPFR Č ņ 0 ņ h ’ D ’’’’ BpDYZ(^pbpb0b8d@f8jlmno0p0q0r0s0t0uv0w0xyz{|}~ M_G_ALTERNATE_ID_HDR ĶČ ä h ’ ON_ID = PS_ORGANIZATION.ID(+))) AND LEFT IS NULL
and ct_type_id=nvl(:P_TYPE_ID, ct_type_id)
ORDER BY ORG_NAME, CT_CERTIFICATE.EXPIRES,
UPPER(PS_PERSON.LAST_NAME), UPPER(PS_PERSON.FIRST_NAME) „’’’’ **66O(R VZąZ(fjąj(vzz(z(~( RUNONLY ct_expiration_list_dept -l bĪ šKg
u pppp¢¢£¤„p¦p««¬ QNAME h y 2! Certification ' ACTI NAME I’’’’ É/ bpdwxyz{|ppp
000000p( ¢£¤p„p„„¦§Øp©p®®Æ°±p²pÅÅĘ ĒTCERTIFICATE_NUMBER h | Cert ! Number ' ' CERTIFICATE_NUMBER RNE’’’’ ±/ bpdklmnoppvvpwpwwxyz{0|0}0~000p( pppp¢¢£¤„p¦p® ÆWEARNED h MBER ! Earned _ ' ' EARNED ES ’’’’ Ŗ/ bpdlmnopqprrpspsstuvw0x0y0z0{0|0}p~( pppppp¦¦§ ØZRENEWED h ! Renewed _ ' RENEWED ’’’’ Ŗ/ bpdlmnopqprrpspsstuvw0x0y0z0{0|0}p~( pppppp¦¦§ Ø]EXPIRES h
! Expires _ ' EXPIRES #d.9Ń4 G_ALTERNATE_ID LIST_G_ALTERNATE_ID ’’’’ FpHSTUVWX0YZ[0\]^0_`abcxf8f8h8j8lnoppppp{ {p|p ā’G_ORG_NAME g +ķ>f(&
Č G_ORG_NAME LIST_G_ORG_NAME
00r88g75b100ą Ą ’’@ ą