SQL> @streams_hc_10GR2.sql Connected. Session altered.

STREAMS Health Check (V3.0.20) for GIDQUEST.GAP.COM on Instance=GIDQUEST generated: 21:47:03 01/30/08

Configuration: Queue Capture Propagation Apply Database
Analysis: History Rules Notifications Configuration Performance Wait Analysis
Statistics: Streams Statistics Queue Capture Propagation Apply Apply_Errors
============================================================================================

++ DATABASE INFORMATION ++

DBID Name CREATED MIN_LOG PK_LOG UI_LOG FK_LOG ALL_LO FORCE_LOG RESETLOGS_TIME LOG_MODE ARCHIVE_CHANGE# OPEN_MODE DATABASE_ROLE ARCHIVELOG_CHANGE# CURRENT_SCN PLATFORM_ID PLATFORM_NAME
2602618207 GIDQUEST 18:24:31 07/03/07 YES NO NO NO NO YES 18:24:34 07/03/07 ARCHIVELOG 9066401 READ WRITE PRIMARY 9066415 9067341 10 Linux IA (32-bit)

============================================================================================

++ INSTANCE INFORMATION ++

INSTANCE Name HOST VERSION STARTUP_TIME STATUS PAR ARCHIVE LOGINS SHU INSTANCE_ROLE ACTIVE_ST
1 GIDQUEST rcltldbe01 10.2.0.3.0 15:48:00 01/30/08 OPEN NO STARTED ALLOWED NO PRIMARY_INSTANCE NORMAL


============================================================================================
+++ Current Database Incarnation +++

Current
Incarnation 		ResetLogs
Id 		ResetLogs
Change Number
2 626984674 456954

============================================================================================

++ REGISTRY INFORMATION ++

COMP_ID COMP_NAME VERSION STATUS MODIFIED SCHEMA
CATALOG Oracle Database Catalog Views 10.2.0.3.0 VALID 16-NOV-2006 19:12:12 SYS
CATPROC Oracle Database Packages and Types 10.2.0.3.0 VALID 16-NOV-2006 19:12:12 SYS
OWM Oracle Workspace Manager 10.2.0.1.0 VALID 16-NOV-2006 19:12:12 WMSYS
JAVAVM JServer JAVA Virtual Machine 10.2.0.3.0 VALID 16-NOV-2006 19:12:13 SYS
XML Oracle XDK 10.2.0.3.0 VALID 16-NOV-2006 19:12:13 SYS
CATJAVA Oracle Database Java Packages 10.2.0.3.0 VALID 16-NOV-2006 19:12:13 SYS
EXF Oracle Expression Filter 10.2.0.3.0 VALID 16-NOV-2006 19:12:14 EXFSYS
ODM Oracle Data Mining 10.2.0.3.0 VALID 16-NOV-2006 19:12:14 DMSYS
CONTEXT Oracle Text 10.2.0.3.0 VALID 16-NOV-2006 19:12:14 CTXSYS
XDB Oracle XML Database 10.2.0.3.0 VALID 16-NOV-2006 19:12:17 XDB
RUL Oracle Rules Manager 10.2.0.3.0 VALID 16-NOV-2006 19:12:17 EXFSYS
ORDIM Oracle interMedia 10.2.0.3.0 VALID 16-NOV-2006 19:12:17 ORDSYS
APS OLAP Analytic Workspace 10.2.0.3.0 VALID 16-NOV-2006 19:12:17 SYS
XOQ Oracle OLAP API 10.2.0.3.0 VALID 16-NOV-2006 19:12:17 SYS
AMD OLAP Catalog 10.2.0.3.0 VALID 16-NOV-2006 19:12:18 OLAPSYS
SDO Spatial 10.2.0.3.0 VALID 16-NOV-2006 19:12:18 MDSYS
EM Oracle Enterprise Manager 10.2.0.3.0 VALID 16-NOV-2006 19:11:37 SYSMAN

17 rows selected.

============================================================================================

++ NLS DATABASE PARAMETERS ++

PARAMETER VALUE
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8ISO8859P1
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 10.2.0.3.0

20 rows selected.

============================================================================================

++ GLOBAL NAME ++

GLOBAL_NAME
GIDQUEST.GAP.COM


============================================================================================

++ Key Init.ORA parameters ++

Parameter
Name 		Parameter
Value 		Description
processes 5000 user processes
sessions 5505 user and system sessions
sga_max_size 2147483648 max total SGA size
shared_pool_size 536870912 size in bytes of shared pool
streams_pool_size 318767104 size in bytes of the streams pool
sga_target 2147483648 Target size of SGA
compatible 10.2.0.3.0 Database will be completely compatible with this software ve rsion
archive_lag_target 0 Maximum number of seconds of redos the standby could lose
logmnr_max_persistent_sessions 1 maximum number of threads to mine
global_names TRUE enforce that database links have same name as remote databas e
job_queue_processes 4 number of job queue slave processes
_job_queue_interval 1 Wakeup interval in seconds for job queue co-ordinator
parallel_max_servers 160 maximum parallel query servers per instance
aq_tm_processes 0 number of AQ Time Managers to start

14 rows selected.


============================================================================================

++ STREAMS QUEUES IN DATABASE ++
==========================================================================================

Owner Queue Name Queue Table Enqueue
Enabled 		Dequeue
Enabled 		Primary
Instance
Owner 		Secondary
Instance
Owner 		Owner
Instance 		Network
Name 		Comment
STRMADMIN AQ$_PPCAPR_QUEUE_TABLE_E PPCAPR_QUEUE_TABLE NO NO 0 0 1   exception queue
STRMADMIN PPCAPR_QUEUE PPCAPR_QUEUE_TABLE YES YES 0 0 1    
SYS AQ$_SCHEDULER$_JOBQTAB_E SCHEDULER$_JOBQTAB NO NO 0 0 1   exception queue
SYS SCHEDULER$_JOBQ SCHEDULER$_JOBQTAB YES YES 0 0 1   Scheduler job queue



+++ Queue Subscribers ++

Queue
Name 		Queue Table Subscriber Delivery
Mode 		Queue
Queue 		Protocol
STRMADMIN.PPCAPR_QUEUE PPCAPR_QUEUE_TABLE ADDRESS : "STRMADMIN"."PPCAPR_QUEUE "@GIDQSTD1.GAP.COM PERSISTENT_OR_BUFFERED TRUE 0
SYS.SCHEDULER$_JOBQ SCHEDULER$_JOBQTAB CONSUMER: SCHEDULER_COORDINATOR PERSISTENT FALSE 0
SYS.SCHEDULER$_JOBQ SCHEDULER$_JOBQTAB CONSUMER: SCHEDULER_PICKUP PERSISTENT FALSE 0

Statistics: Streams Statistics Queue Capture Propagation Apply Apply_Errors
=========================================================================================

++ Minimum Archive Log Necessary to Restart Capture ++
Note: This query is valid for databases where the capture processes exist for the same source database.

Capture will restart from SCN 9018354 in the following file:
/oradata/GIDQUEST/1_392_626984674.arc (20:03:53 01/30/08)
/oradata/GIDQUEST/1_391_626984674.arc (20:03:53 01/30/08)
PL/SQL procedure successfully completed.

============================================================================================

++ CAPTURE PROCESSES IN DATABASE ++

Capture
Name 		Queue Capture
Type 		Status Positive
Rule Set 		Negative
Rule Set 		Days to
Retain
Checkpoints 		Version Logfile
Assignme 		Error
Number 		Status
Timestamp 		Capture
Error Message
PPCAPR_CAPTURE STRMADMIN.PPCAPR_QUEUE LOCAL ENABLED STRMADMIN.RULESET$_14 . 60 10.2.0.3.0 IMPLICIT   21:09:13 01/30/08  

++ CAPTURE PROCESS SOURCE INFORMATION ++

Capture
Name 		Capture
Type 		Source
Database 		First
SCN 		Start
SCN 		Captured
SCN 		Applied
SCN 		Last
Enqueued
SCN 		Required
Checkpoint
SCN 		Maximum
Checkpoint
SCN 		Source
Database
ID 		Source
ResetLogs
SCN 		Source
ResetLogs
Time 		Logminer
Session
ID
PPCAPR_CAPTURE LOCAL GIDQUEST.GAP.COM 9018354 9018354 9051357 9018354 9065201 0 9050039 2602618207 456954 626984674 1


++ CAPTURE PROCESS PARAMETERS ++

Capture
Name 		Parameter
Name 		Parameter
Value 		User
Set?
PPCAPR_CAPTURE DISABLE_ON_LIMIT N NO
  DOWNSTREAM_REAL_TIME_MINE Y NO
  MAXIMUM_SCN INFINITE NO
  MESSAGE_LIMIT INFINITE NO
  PARALLELISM 1 NO
  STARTUP_SECONDS 0 NO
  TIME_LIMIT INFINITE NO
  TRACE_LEVEL 127 YES
  WRITE_ALERT_LOG Y NO

9 rows selected.

============================================================================================

++ STREAMS CAPTURE RULES CONFIGURED WITH DBMS_STREAMS_ADM PACKAGE ++

Capture
Name 		Object Rule Set
Type 		Source
Database 		Rule
Type 		Tagged
Rules? 		Rule
Name
PPCAPR_CAPTURE PPCAPR. POSITIVE   SCHEMA DML NO STRMADMIN.PPCAPR12
PPCAPR_CAPTURE PPCAPR. POSITIVE   SCHEMA DDL NO STRMADMIN.PPCAPR13

++ STREAMS TABLE SUBSETTING RULES ++
no rows selected

++ CAPTURE RULES BY RULE SET ++

Capture
Name 		Rule Set
Name 		Rule
Name 		Rule
Condition
PPCAPR_CAPTURE STRMADMIN.RULESET$_14 STRMADMIN.PPCAPR12 ((:dml.get_object_owner() = 'PPCAPR') and :dml.is_ null_tag() = 'Y' )
  STRMADMIN.RULESET$_14 STRMADMIN.PPCAPR13 ((:ddl.get_object_owner() = 'PPCAPR' or :ddl.get_b ase_table_owner() = 'PPCAPR') and :ddl.is_null_tag() = 'Y' )

+** CAPTURE RULES IN NEGATIVE RULE SET **+

no rows selected

++ CAPTURE RULE TRANSFORMATIONS BY RULE SET ++
no rows selected
============================================================================================

++ Registered Log Files for Capture ++

Capture
Process
Name 		Source
Database 		Sequence
Number 		Archived Redo Log
File Name 		Archived Log
First SCN 		Archived Log Begi
Timestamp 		Archived Log
Last SCN 		Archived Log Last
Timestamp 		Archived Log
Registered Time 		Dictio
Build
Begin 		Dictio
Build
End 		Purgeable
Archive
Log
PPCAPR_CAPTURE GIDQUEST.G AP.COM 391 /oradata/GIDQUEST/1_391_626984674.a rc 9018350 20:03:53 01/30/08 9018354 20:03:53 01/30/08 20:06:51 01/30/08 NO NO NO
PPCAPR_CAPTURE GIDQUEST.G AP.COM 392 /oradata/GIDQUEST/1_392_626984674.a rc 9018354 20:03:53 01/30/08 9019382 20:03:59 01/30/08 20:06:53 01/30/08 YES YES NO
PPCAPR_CAPTURE GIDQUEST.G AP.COM 393 /oradata/GIDQUEST/1_393_626984674.a rc 9019382 20:03:59 01/30/08 9025394 20:07:06 01/30/08 20:07:53 01/30/08 NO NO NO
PPCAPR_CAPTURE GIDQUEST.G AP.COM 394 /oradata/GIDQUEST/1_394_626984674.a rc 9025394 20:07:06 01/30/08 9034770 20:07:47 01/30/08 21:09:13 01/30/08 NO NO NO
PPCAPR_CAPTURE GIDQUEST.G AP.COM 395 /oradata/GIDQUEST/1_395_626984674.a rc 9034770 20:07:47 01/30/08 9066401 21:29:44 01/30/08 21:29:45 01/30/08 NO NO NO
PPCAPR_CAPTURE GIDQUEST.G AP.COM 396 /oradata/GIDQUEST/1_396_626984674.a rc 9066401 21:29:44 01/30/08 9066410 21:29:46 01/30/08 21:29:46 01/30/08 NO NO NO
PPCAPR_CAPTURE GIDQUEST.G AP.COM 397 /oradata/GIDQUEST/1_397_626984674.a rc 9066410 21:29:46 01/30/08 9066415 21:29:50 01/30/08 21:29:51 01/30/08 NO NO NO

7 rows selected.

============================================================================================

++ CAPTURE EXTRA ATTRIBUTES ++

Capture Process Attribute Name Include Attribute in LCRs?
PPCAPR_CAPTURE ROW_ID NO
  SERIAL# NO
  SESSION# NO
  THREAD# NO
  TX_NAME NO
  USERNAME NO

6 rows selected.

============================================================================================

++ TABLES PREPARED FOR CAPTURE ++

Table
Owner 		Table
Name 		SCN Timestamp PK
Logging 		UI
Logging 		FK
Logging 		All
Logging
PPCAPR APPL_ST_T 9051963 21:09:41 01/30/08 NO NO NO NO
PPCAPR APSE_LVL_T 9052206 21:09:41 01/30/08 NO NO NO NO
PPCAPR ARCV_EV_T 9051966 21:09:41 01/30/08 NO NO NO NO
PPCAPR AWRD_ARBT_TYP_T 9051970 21:09:41 01/30/08 NO NO NO NO
PPCAPR AWRD_CALC_LVL_T 9051973 21:09:41 01/30/08 NO NO NO NO
PPCAPR AWRD_T 9051978 21:09:41 01/30/08 NO NO NO NO
PPCAPR AWRD_TYP_T 9051985 21:09:41 01/30/08 NO NO NO NO
PPCAPR A_B_TST_BKT_T 9051988 21:09:41 01/30/08 NO NO NO NO
PPCAPR A_B_TST_GRP_T 9051992 21:09:41 01/30/08 NO NO NO NO
PPCAPR BRD_CHNL_ASSN_T 9051995 21:09:41 01/30/08 NO NO NO NO
PPCAPR BRD_CHNL_PMOTN_ASSN_T 9051998 21:09:41 01/30/08 NO NO NO NO
PPCAPR BRD_RUL_ASSN_T 9052198 21:09:41 01/30/08 NO NO NO NO
PPCAPR BRD_T 9052002 21:09:41 01/30/08 NO NO NO NO
PPCAPR CD_REQ_STAT_TYP_T 9052008 21:09:41 01/30/08 NO NO NO NO
PPCAPR CD_REQ_T 9052012 21:09:41 01/30/08 NO NO NO NO
PPCAPR CHNL_PMOTN_ASSN_T 9052201 21:09:41 01/30/08 NO NO NO NO
PPCAPR CHNL_T 9052016 21:09:41 01/30/08 NO NO NO NO
PPCAPR CMPL_PRC_T 9052238 21:09:41 01/30/08 NO NO NO NO
PPCAPR CNCY_T 9052229 21:09:41 01/30/08 NO NO NO NO
PPCAPR CND_BRD_T 9052019 21:09:41 01/30/08 NO NO NO NO
PPCAPR CND_STY_CLR_T 9052023 21:09:41 01/30/08 NO NO NO NO
PPCAPR CND_T 9052026 21:09:41 01/30/08 NO NO NO NO
PPCAPR CND_TYP_T 9052032 21:09:41 01/30/08 NO NO NO NO
PPCAPR CR_CRD_TYP_T 9052035 21:09:41 01/30/08 NO NO NO NO
PPCAPR CTLG_ITM_TYP_T 9052039 21:09:41 01/30/08 NO NO NO NO
PPCAPR DSCT_TYP_T 9052043 21:09:41 01/30/08 NO NO NO NO
PPCAPR EV_T 9052046 21:09:41 01/30/08 NO NO NO NO
PPCAPR EXP_CATG_T 9052271 21:09:41 01/30/08 NO NO NO NO
PPCAPR FLAT_PRC_T 9052245 21:09:41 01/30/08 NO NO NO NO
PPCAPR GIDTLSD1_HEARTBEAT 9052274 21:09:41 01/30/08 NO NO NO NO
PPCAPR LST_PRC_T 9052235 21:09:41 01/30/08 NO NO NO NO
PPCAPR MPP_LIST_PRD_T 9052052 21:09:41 01/30/08 NO NO NO NO
PPCAPR MPP_LIST_T 9052055 21:09:41 01/30/08 NO NO NO NO
PPCAPR MPP_PRD_MSG_T 9052058 21:09:41 01/30/08 NO NO NO NO
PPCAPR MPP_PRD_MSG_TYP_T 9052062 21:09:41 01/30/08 NO NO NO NO
PPCAPR MPP_TYP_T 9052067 21:09:41 01/30/08 NO NO NO NO
PPCAPR MSG_PRTY_TYP_T 9052071 21:09:41 01/30/08 NO NO NO NO
PPCAPR MUP_ID_MAP_T 9052074 21:09:41 01/30/08 NO NO NO NO
PPCAPR MUP_NACTV_RSN_T 9052225 21:09:41 01/30/08 NO NO NO NO
PPCAPR MUP_STY_CLR_T 9052077 21:09:41 01/30/08 NO NO NO NO
PPCAPR MUP_T 9052084 21:09:41 01/30/08 NO NO NO NO
PPCAPR MUP_TYP_T 9052087 21:09:41 01/30/08 NO NO NO NO
PPCAPR PLAN_TABLE 9052091 21:09:41 01/30/08 NO NO NO NO
PPCAPR PMOTN_CATG_T 9052094 21:09:41 01/30/08 NO NO NO NO
PPCAPR PMOTN_CD_ASSN_T 9052195 21:09:41 01/30/08 NO NO NO NO
PPCAPR PMOTN_CD_SEQ_T 9052098 21:09:41 01/30/08 NO NO NO NO
PPCAPR PMOTN_CD_TYP_T 9052103 21:09:41 01/30/08 NO NO NO NO
PPCAPR PMOTN_CHG_HIST_T 9052106 21:09:41 01/30/08 NO NO NO NO
PPCAPR PMOTN_HIST_TYP_T 9052110 21:09:41 01/30/08 NO NO NO NO
PPCAPR PMOTN_NTE_T 9052114 21:09:41 01/30/08 NO NO NO NO
PPCAPR PMOTN_RUL_TIER_T 9052119 21:09:41 01/30/08 NO NO NO NO
PPCAPR PMOTN_SPSR_T 9052123 21:09:41 01/30/08 NO NO NO NO
PPCAPR PMOTN_STAT_TYP_T 9052127 21:09:41 01/30/08 NO NO NO NO
PPCAPR PMOTN_SUB_CATG_T 9052130 21:09:41 01/30/08 NO NO NO NO
PPCAPR PMOTN_T 9052134 21:09:41 01/30/08 NO NO NO NO
PPCAPR PMOTN_TAB_T 9052137 21:09:41 01/30/08 NO NO NO NO
PPCAPR PRAS_APPL_ST 9052293 21:09:41 01/30/08 NO NO NO NO
PPCAPR PRAS_AWRD 9052297 21:09:41 01/30/08 NO NO NO NO
PPCAPR PRAS_AWRDAAA 9052306 21:09:41 01/30/08 NO NO NO NO
PPCAPR PRAS_AWRDST 9052310 21:09:41 01/30/08 NO NO NO NO
PPCAPR PRAS_AWRDT 9052302 21:09:41 01/30/08 NO NO NO NO
PPCAPR PRAS_ZIPCD 9052290 21:09:41 01/30/08 NO NO NO NO
PPCAPR PRC_APPL_TYP_T 9052141 21:09:41 01/30/08 NO NO NO NO
PPCAPR PRC_T 9052211 21:09:41 01/30/08 NO NO NO NO
PPCAPR PRC_TYP_T 9052241 21:09:41 01/30/08 NO NO NO NO
PPCAPR RUL_SET_STAT_T 9052145 21:09:41 01/30/08 NO NO NO NO
PPCAPR RUL_SET_T 9052148 21:09:41 01/30/08 NO NO NO NO
PPCAPR RUL_T 9052277 21:09:41 01/30/08 NO NO NO NO
PPCAPR RUL_TIER_T 9052152 21:09:41 01/30/08 NO NO NO NO
PPCAPR RUL_T_TMP 9052281 21:09:41 01/30/08 NO NO NO NO
PPCAPR SCHEMA_AUD_LOG_T 9052260 21:09:41 01/30/08 NO NO NO NO
PPCAPR SCHEMA_VERSION 9052155 21:09:41 01/30/08 NO NO NO NO
PPCAPR SCHEMA_VER_T 9052264 21:09:41 01/30/08 NO NO NO NO
PPCAPR SHP_CHRG_TIER_T 9052160 21:09:41 01/30/08 NO NO NO NO
PPCAPR SHP_OPT_BRD_T 9052165 21:09:41 01/30/08 NO NO NO NO
PPCAPR SHP_OPT_T 9052168 21:09:41 01/30/08 NO NO NO NO
PPCAPR SHP_TYP_T 9052171 21:09:41 01/30/08 NO NO NO NO
PPCAPR SPSR_T 9052175 21:09:41 01/30/08 NO NO NO NO
PPCAPR STATTAB 9052178 21:09:41 01/30/08 NO NO NO NO
PPCAPR STG_73_FEED_DTL_T 9052221 21:09:41 01/30/08 NO NO NO NO
PPCAPR STG_92_FEED_DTL_T 9052248 21:09:41 01/30/08 NO NO NO NO
PPCAPR STG_MUP_FEED_T 9052183 21:09:41 01/30/08 NO NO NO NO
PPCAPR STG_PRC_FEED_STAT_CD_T 9052214 21:09:41 01/30/08 NO NO NO NO
PPCAPR STG_PRC_FEED_T 9052218 21:09:41 01/30/08 NO NO NO NO
PPCAPR STG_PRC_FEED_TYP_T 9052255 21:09:41 01/30/08 NO NO NO NO
PPCAPR STG_SUP_FEED_T 9052252 21:09:41 01/30/08 NO NO NO NO
PPCAPR T3 9052285 21:09:41 01/30/08 NO NO NO NO
PPCAPR TABLE2 9052267 21:09:41 01/30/08 NO NO NO NO
PPCAPR USE_LMT_T 9052188 21:09:41 01/30/08 NO NO NO NO
PPCAPR USE_LMT_TYP_T 9052191 21:09:41 01/30/08 NO NO NO NO
PPCAPR ZIPCD_OPT_ROLLUP_T 9051957 21:09:41 01/30/08 NO NO NO NO

91 rows selected.

++ SCHEMAS PREPARED FOR CAPTURE ++

Schema
Name 		Timestamp PK
Logging 		UI
Logging 		FK
Logging 		All
Logging
PPCAPR 21:09:41 01/30/08 IMPLICIT IMPLICIT IMPLICIT NO

++ DATABASE PREPARED FOR CAPTURE ++
no rows selected
============================================================================================

++ TABLES WITH SUPPLEMENTAL LOGGING ++
no rows selected

++ TABLE LEVEL SUPPLEMENTAL LOG GROUPS ENABLED FOR CAPTURE ++
no rows selected
++ SUPPLEMENTALLY LOGGED COLUMNS ++
no rows selected
Statistics: Streams Statistics Queue Capture Propagation Apply Apply_Errors

==========================================================================================

++ MESSAGING CLIENTS IN DATABASE ++
=========================================================================================

Messaging
Client 		Queue Owne Queue Name Positive
Rule Set 		Negative
Rule Set
SCHEDULER_COORDINATOR SYS SCHEDULER$_JOBQ RULESET$_4  
SCHEDULER_PICKUP SYS SCHEDULER$_JOBQ RULESET$_8  


++ MESSAGE CLIENT NOTIFICATIONS ++

Messaging
Client 		Queue
Owner 		Queue Name Notification
Type 		Notification
Action
SCHEDULER_PICKUP SYS SCHEDULER$_JOBQ PROCEDURE sys.dbms_isched.pickup_job


==========================================================================================

++ PROPAGATIONS IN DATABASE ++
=========================================================================================

Propagation Source Queue Destination Queue Q-2-Q Status Error Date Error Message
PPCAPR_PROPAGATE STRMADMIN.PPCAPR_QUEUE@GIDQUEST.GAP.COM STRMADMIN.PPCAPR_QUEUE@GIDQSTD1.GAP.COM TRUE ENABLED    


++ PROPAGATION RULE SETS IN DATABASE ++

Propagation Positive
Rule Set 		Negative
Rule Set
PPCAPR_PROPAGATE STRMADMIN.RULESET$_20 .

============================================================================================

++ STREAMS PROPAGATION RULES CONFIGURED ++

Name Object Rule Set
Type 		Source
Database 		Rule
Type 		Tagged
Rules? 		Rule
Name
PPCAPR_PROPAGATE PPCAPR. POSITIVE GIDQUEST.REGRES S.RDBMS.DEV.US. ORACLE.COM SCHEMA DML NO STRMADMIN.PPCAPR18
PPCAPR_PROPAGATE PPCAPR. POSITIVE GIDQUEST.REGRES S.RDBMS.DEV.US. ORACLE.COM SCHEMA DDL NO STRMADMIN.PPCAPR19

++ STREAMS TABLE SUBSETTING RULES ++
no rows selected

++ PROPAGATION RULES BY RULE SET ++

Rule Set
Name 		Rule
Name 		Rule
Condition
STRMADMIN.RULESET$_20 STRMADMIN.PPCAPR19 ((:ddl.get_object_owner() = 'PPCAPR' or :ddl.get_base_table_ owner() = 'PPCAPR') and :ddl.is_null_tag() = 'Y' and :ddl.get_source_database_na me() = 'GIDQUEST.REG RESS.RDBMS.DEV.US.ORACLE.COM' )
STRMADMIN.RULESET$_20 STRMADMIN.PPCAPR18 ((:dml.get_object_owner() = 'PPCAPR') and :dml.is_null_tag() = 'Y' and :dml.get_ source_database_name() = 'GIDQUEST.REGRESS.RDBMS.DEV.US.ORAC LE.COM' )

+** PROPAGATION RULES IN NEGATIVE RULE SET **+

no rows selected

++ PROPAGATION RULE TRANSFORMATIONS BY RULE SET ++
no rows selected
Statistics: Streams Statistics Queue Capture Propagation Apply Apply_Errors

============================================================================================

++ APPLY INFORMATION ++
no rows selected
++ APPLY PROCESS INFORMATION ++
no rows selected
++ APPLY PROCESS HANDLERS ++
no rows selected

++ APPLY PROCESS PARAMETERS ++
no rows selected
============================================================================================

++ STREAMS APPLY RULES CONFIGURED ++
no rows selected
++ STREAMS TABLE SUBSETTING RULES ++
no rows selected

++ APPLY Rules ++

++ APPLY RULES BY RULE SET ++
no rows selected
+** APPLY RULES IN NEGATIVE RULE SET **+

no rows selected

++ APPLY RULE TRANSFORMATIONS BY RULE SET ++
no rows selected
============================================================================================

++ APPLY HANDLERS ++
no rows selected

++ APPLY DML HANDLERS ++
no rows selected

++ DML HANDLER STATUS ++

no rows selected

++ RULE TRANSFORMATIONS STATUS ++
no rows selected

++ APPLY ENQUEUE directives ++
no rows selected

++ APPLY EXECUTE directives ++
no rows selected

++ Conflict Detection Control ++

no rows selected
============================================================================================

++ UPDATE CONFLICT RESOLUTION COLUMNS ++
no rows selected
============================================================================================

++ KEY COLUMNS SET FOR APPLY ++
no rows selected
============================================================================================

++ OBJECT DEPENDENCIES SET FOR APPLY ++
no rows selected
============================================================================================

++ VALUE DEPENDENCIES SET FOR APPLY ++
no rows selected
++ APPLY PROGRESS ++
no rows selected
Statistics: Streams Statistics Queue Capture Propagation Apply Apply_Errors
============================================================================================

++ ERROR QUEUE ++
no rows selected
Statistics: Streams Statistics Queue Capture Propagation Apply Apply_Errors

============================================================================================

++ INSTANTIATION SCNs for APPLY TABLES ++

Source
Database 		Database
Object 		IGNORE_SCN INSTANTIATION_SCN Apply
DBLink
GIDTLSD1 PPCAPR.APPL_ST_T 0 8246210267468  
GIDTLSD1 PPCAPR.APSE_LVL_T 0 8246210267465  
GIDTLSD1 PPCAPR.ARCV_EV_T 0 8246210267908  
GIDTLSD1 PPCAPR.AWRD_ARBT_TYP_T 0 8246210267460  
GIDTLSD1 PPCAPR.AWRD_CALC_LVL_T 0 8246210267456  
GIDTLSD1 PPCAPR.AWRD_T 0 8246210267524  
GIDTLSD1 PPCAPR.AWRD_TYP_T 0 8246210268045  
GIDTLSD1 PPCAPR.A_B_TST_BKT_T 0 8246210267904  
GIDTLSD1 PPCAPR.A_B_TST_GRP_T 0 8246210267899  
GIDTLSD1 PPCAPR.BRD_CHNL_ASSN_T 0 8246210268042  
GIDTLSD1 PPCAPR.BRD_CHNL_PMOTN_ASSN_T 0 8246210267510  
GIDTLSD1 PPCAPR.BRD_RUL_ASSN_T 0 8246210267507  
GIDTLSD1 PPCAPR.BRD_T 0 8246210268039  
GIDTLSD1 PPCAPR.CD_REQ_STAT_TYP_T 0 8246210268036  
GIDTLSD1 PPCAPR.CD_REQ_T 0 8246210267492  
GIDTLSD1 PPCAPR.CHNL_PMOTN_ASSN_T 0 8246210267483  
GIDTLSD1 PPCAPR.CHNL_T 0 8246210268033  
GIDTLSD1 PPCAPR.CMPL_PRC_T 0 8246210267263  
GIDTLSD1 PPCAPR.CNCY_T 0 8246210268030  
GIDTLSD1 PPCAPR.CND_BRD_T 0 8246210267513  
GIDTLSD1 PPCAPR.CND_STY_CLR_T 0 8246210267047  
GIDTLSD1 PPCAPR.CND_T 0 8246210267527  
GIDTLSD1 PPCAPR.CND_TYP_T 0 8246210268027  
GIDTLSD1 PPCAPR.CR_CRD_TYP_T 0 8246210268024  
GIDTLSD1 PPCAPR.CTLG_ITM_TYP_T 0 8246210268020  
GIDTLSD1 PPCAPR.DSCT_TYP_T 0 8246210268015  
GIDTLSD1 PPCAPR.EV_T 0 8246210267896  
GIDTLSD1 PPCAPR.EXP_CATG_T 0 8246210267892  
GIDTLSD1 PPCAPR.FLAT_PRC_T 0 8246210267291  
GIDTLSD1 PPCAPR.GIDTLSD1_HEARTBEAT 0 8246210267888  
GIDTLSD1 PPCAPR.LST_PRC_T 0 8246210267387  
GIDTLSD1 PPCAPR.MPP_LIST_PRD_T 0 8246210267383  
GIDTLSD1 PPCAPR.MPP_LIST_T 0 8246210267479  
GIDTLSD1 PPCAPR.MPP_PRD_MSG_T 0 8246210267379  
GIDTLSD1 PPCAPR.MPP_PRD_MSG_TYP_T 0 8246210268011  
GIDTLSD1 PPCAPR.MPP_TYP_T 0 8246210268007  
GIDTLSD1 PPCAPR.MSG_PRTY_TYP_T 0 8246210268003  
GIDTLSD1 PPCAPR.MUP_ID_MAP_T 0 8246210267503  
GIDTLSD1 PPCAPR.MUP_NACTV_RSN_T 0 8246210267999  
GIDTLSD1 PPCAPR.MUP_STY_CLR_T 0 8246210267534  
GIDTLSD1 PPCAPR.MUP_T 0 8246210267475  
GIDTLSD1 PPCAPR.MUP_TYP_T 0 8246210267995  
GIDTLSD1 PPCAPR.PLAN_TABLE 0 8246210267884  
GIDTLSD1 PPCAPR.PMOTN_CATG_T 0 8246210267989  
GIDTLSD1 PPCAPR.PMOTN_CD_ASSN_T 0 8246210267053  
GIDTLSD1 PPCAPR.PMOTN_CD_SEQ_T 0 8246210267984  
GIDTLSD1 PPCAPR.PMOTN_CD_TYP_T 0 8246210267980  
GIDTLSD1 PPCAPR.PMOTN_CHG_HIST_T 0 8246210267374  
GIDTLSD1 PPCAPR.PMOTN_HIST_TYP_T 0 8246210267976  
GIDTLSD1 PPCAPR.PMOTN_NTE_T 0 8246210267499  
GIDTLSD1 PPCAPR.PMOTN_RUL_TIER_T 0 8246210267530  
GIDTLSD1 PPCAPR.PMOTN_SPSR_T 0 8246210267486  
GIDTLSD1 PPCAPR.PMOTN_STAT_TYP_T 0 8246210267972  
GIDTLSD1 PPCAPR.PMOTN_SUB_CATG_T 0 8246210267968  
GIDTLSD1 PPCAPR.PMOTN_T 0 8246210267547  
GIDTLSD1 PPCAPR.PMOTN_TAB_T 0 8246210267543  
GIDTLSD1 PPCAPR.PRC_APPL_TYP_T 0 8246210267964  
GIDTLSD1 PPCAPR.PRC_T 0 8246210267879  
GIDTLSD1 PPCAPR.PRC_TYP_T 0 8246210267960  
GIDTLSD1 PPCAPR.RUL_SET_STAT_T 0 8246210267956  
GIDTLSD1 PPCAPR.RUL_SET_T 0 8246210267520  
GIDTLSD1 PPCAPR.RUL_T 0 8246210267220  
GIDTLSD1 PPCAPR.RUL_TIER_T 0 8246210267495  
GIDTLSD1 PPCAPR.RUL_T_TMP 0 8246210267344  
GIDTLSD1 PPCAPR.SCHEMA_AUD_LOG_T 0 8246210267952  
GIDTLSD1 PPCAPR.SCHEMA_VERSION 0 8246210267872  
GIDTLSD1 PPCAPR.SCHEMA_VER_T 0 8246210267948  
GIDTLSD1 PPCAPR.SHP_CHRG_TIER_T 0 8246210267944  
GIDTLSD1 PPCAPR.SHP_OPT_BRD_T 0 8246210267940  
GIDTLSD1 PPCAPR.SHP_OPT_T 0 8246210267936  
GIDTLSD1 PPCAPR.SHP_TYP_T 0 8246210267932  
GIDTLSD1 PPCAPR.SPSR_T 0 8246210267928  
GIDTLSD1 PPCAPR.STATTAB 0 8246210267516  
GIDTLSD1 PPCAPR.STG_73_FEED_DTL_T 0 8246210267868  
GIDTLSD1 PPCAPR.STG_92_FEED_DTL_T 0 8246210267865  
GIDTLSD1 PPCAPR.STG_MUP_FEED_T 0 8246210267864  
GIDTLSD1 PPCAPR.STG_PRC_FEED_STAT_CD_T 0 8246210267924  
GIDTLSD1 PPCAPR.STG_PRC_FEED_T 0 8246210267863  
GIDTLSD1 PPCAPR.STG_PRC_FEED_TYP_T 0 8246210267920  
GIDTLSD1 PPCAPR.STG_SUP_FEED_T 0 8246210267861  
GIDTLSD1 PPCAPR.TABLE2 0 8246210267915  
GIDTLSD1 PPCAPR.USE_LMT_T 0 8246210267471  
GIDTLSD1 PPCAPR.USE_LMT_TYP_T 0 8246210267911  
GIDTLSD1 PPCAPR.ZIPCD_OPT_ROLLUP_T 0 8246210267539  

84 rows selected.


++ INSTANTIATION SCNs for APPLY SCHEMA and DATABASE (DDL) ++

Source
Database 		Database
Object 		Database
Link 		Instantiation
SCN 		Schema o
Database
GIDTLSD1 PPCAPR   8246210267111 SCHEMA


============================================================================================

++ DBA OBJECTS - Rules, and Streams Processes ++

Object OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_TIME Status
SYS.PPCAPR_CAPTURE 62140 CAPTURE 20:03:59 01/30/08 21:09:11 01/30/08 VALID
STRMADMIN.PPCAPR12 62118 RULE 20:03:51 01/30/08 20:03:51 01/30/08 VALID
STRMADMIN.PPCAPR13 62119 RULE 20:03:51 01/30/08 20:03:51 01/30/08 VALID
STRMADMIN.PPCAPR18 62301 RULE 21:00:31 01/30/08 21:00:31 01/30/08 VALID
STRMADMIN.PPCAPR19 62302 RULE 21:00:31 01/30/08 21:00:31 01/30/08 VALID
SYS.ALERT_QUE$1 9730 RULE 18:53:57 11/16/06 18:53:57 11/16/06 VALID
SYS.RULE$_11 8518 RULE 18:51:40 11/16/06 18:51:40 11/16/06 VALID
SYS.RULE$_3 8512 RULE 18:51:39 11/16/06 18:51:39 11/16/06 VALID
SYS.RULE$_7 8515 RULE 18:51:40 11/16/06 18:51:40 11/16/06 VALID
STRMADMIN.PPCAPR_QUEUE_N 62116 RULE SET 19:07:15 01/30/08 19:07:15 01/30/08 VALID
STRMADMIN.PPCAPR_QUEUE_R 62115 RULE SET 19:07:15 01/30/08 21:00:31 01/30/08 VALID
STRMADMIN.RULESET$_14 62120 RULE SET 20:03:51 01/30/08 20:03:51 01/30/08 VALID
STRMADMIN.RULESET$_20 62303 RULE SET 21:00:31 01/30/08 21:00:31 01/30/08 VALID
SYS.ALERT_QUE$1 9729 RULE SET 18:53:57 11/16/06 18:53:57 11/16/06 VALID
SYS.ALERT_QUE_N 8841 RULE SET 18:51:56 11/16/06 18:51:56 11/16/06 VALID
SYS.ALERT_QUE_R 8840 RULE SET 18:51:56 11/16/06 18:53:57 11/16/06 VALID
SYS.AQ$_PROP_NOTIFY_1_N 62180 RULE SET 20:05:04 01/30/08 20:05:04 01/30/08 VALID
SYS.AQ$_PROP_NOTIFY_1_R 62179 RULE SET 20:05:04 01/30/08 20:05:04 01/30/08 VALID
SYS.RULESET$_4 8513 RULE SET 18:51:39 11/16/06 18:51:39 11/16/06 VALID
SYS.RULESET$_8 8516 RULE SET 18:51:40 11/16/06 18:51:40 11/16/06 VALID
SYS.SCHEDULER$_EVENT_QUEUE_N 5203 RULE SET 18:44:52 11/16/06 18:44:52 11/16/06 VALID
SYS.SCHEDULER$_EVENT_QUEUE_R 5202 RULE SET 18:44:52 11/16/06 18:44:52 11/16/06 VALID
SYS.SCHEDULER$_JOBQ_N 5117 RULE SET 18:44:51 11/16/06 18:44:51 11/16/06 VALID
SYS.SCHEDULER$_JOBQ_R 5116 RULE SET 18:44:51 11/16/06 18:51:40 11/16/06 VALID
SYS.SYS$SERVICE_METRICS_N 10204 RULE SET 18:55:23 11/16/06 18:55:23 11/16/06 VALID
SYS.SYS$SERVICE_METRICS_R 10203 RULE SET 18:55:23 11/16/06 18:55:23 11/16/06 VALID
SYSMAN.MGMT_NOTIFY_Q_N 49877 RULE SET 19:10:12 11/16/06 19:10:12 11/16/06 VALID
SYSMAN.MGMT_NOTIFY_Q_R 49876 RULE SET 19:10:12 11/16/06 19:10:12 11/16/06 VALID
WMSYS.WM$EVENT_QUEUE_N 10136 RULE SET 18:55:10 11/16/06 18:55:10 11/16/06 VALID
WMSYS.WM$EVENT_QUEUE_R 10135 RULE SET 18:55:10 11/16/06 18:55:10 11/16/06 VALID

30 rows selected.


============================================================================================

++ Check RECOVERABLE tables populated by MAINTAIN_{TABLE|SCHEMA|GLOBAL} scripts

no rows selected

++ Check RECOVERABLE error ++
no rows selected

++ Identify Script Blocks ++
no rows selected

++ History ++


++ Streams Buffered Queue History for last day ++

Interval
Begin
Time 		Interval
End
Time 		Snap ID Current
Number of Msgs
in Queue 		Current
Spilled Msgs
in Queue 		Cumulative
Total Msgs
for Queue 		Cumulative
Total Spilled
for Queue 		Queue
Name 		QUEUE_ID STARTUP_TIME Instance
Number 		Database
Identifier
30-JAN-08 08.00.18.354 PM 30-JAN-08 09.00.19.953 PM 2772 0 0 0 0 STRMADMIN.PPCAPR_QUEUE 62114 20:05:04 01/30/08 1 2602618207


++ Streams Buffered Subscriber History for last day ++

Interval
Begin
Time 		Interval
End
Time 		Snap ID SUBSCRIBER_ID Current
Number of Msgs
in Queue 		Cumulative
Total Msgs
for Queue 		Cumulative
Total Spilled
Messages 		SUBSCRIBER_NAME SUBSCRIBER_ADDRESS Queue
Name 		STARTUP_TIME Instance
Number 		Database
Identifier
30-JAN-08 08.00.18.354 PM 30-JAN-08 09.00.19.953 PM 2772 2 0 0 0   GIDQSTD1.GAP.COM STRMADMIN.PPCAPR_QUEUE 20:05:04 01/30/08 1 2602618207


++ Streams Capture History for last day ++

Interval
Begin
Time 		Interval
End
Time 		Capture Process Capture
Lag
(Seconds) 		TOTAL_MESSAGES_CAPTURED Total Messages
Enqueued 		Elapsed Time
Paused
(centisecs) 		Elapsed Time
Redo Wait
(centisecs) 		Elapsed Time
Rule Evaluation
(centisecs) 		Elapsed Time
Enqueuing Messages
(centisecs) 		STARTUP_TIME Instance
Number 		Database
Identifier
30-JAN-08 08.00.18.354 PM 30-JAN-08 09.00.19.953 PM PPCAPR_CAPTURE 0 30991 7991 0 94 1 345 20:06:51 01/30/08 1 2602618207


++ Streams Apply History for last day ++
no rows selected

++ SUSPICIOUS RULES ++


++ Check for MISSING RULES IN DBA_RULES ++
. Rows are returned if a rule is defined in DBA_STREAMS_TABLE_RULES (or SCHEMA, GLOBAL, too)
. but does not exist in the DBA_RULES view.

no rows selected

++ Check for EXTRA RULES IN DBA_RULES ++
. Rows are returned if a rule is defined in the DBA_RULES view
. but does not exist in the DBA_STREAMS_RULES view.

RULE_OWNER Rule
Name
SYS ALERT_QUE$1


++ Check for RULE_CONDITIONS DO NOT MATCH BETWEEN STREAMS AND RULES ++
. Rows are returned if the rule condition is different between the DBA_STREAMS_TABLE_RULES view
. and the DBA_RULES view. This indicates that a manual modification has been performed on the
. underlying rule. DBA_STREAMS_TABLE_RULES always shows the initial configuration rule condition.

no rows selected

++ Check for SOURCE DATABASE NAME DOES NOT MATCH FOR CAPTURE OR PROPAGATION RULES ++
. Rows are returned if the source database column in the DBA_STREAMS_ RULES view
. for capture and/or propagation defined at this site does not match the
. global_name of this site. For capture rules, the source database must match the global_name
. of database. For propagation rules, the source database name will typically be the
. global name of the database. In some cases, it may be correct to have a different source
. database name from the global name. For example, at an intermediate node between a source site
. and the ultimate target site OR when using a downstream capture configuration, the rule source database
. name field will be diferent from the local. global name of the intermediate site.

STREAMS_TYP Messaging
Client 		Rule
Name
PROPAGATION PPCAPR_PROPAGATE STRMADMIN.PPCAPR19
PROPAGATION PPCAPR_PROPAGATE STRMADMIN.PPCAPR18


++ Check for GLOBAL RULE FOR CAPTURE SPECIFIED BUT CONDITION NOT MODIFIED ++
. Rows are returned if a global rule is defined in the DBA_STREAMS_GLOBAL_RULES view
. and the rule condition in the DBA_RULES view has not been modified.
. In 9iR2, the GLOBAL rule must be modified to eliminate any unsupported datatypes. For example,
. the streams administrator schema must be eliminated from the capture rules. Failure to do
. this will result in the abort of the capture process.
no rows selected

++ Check for No RULE SET DEFINED FOR CAPTURE ++

Capture requires a rule set to be defined to assure that only supported datatypes are captured.

no rows selected

++ Check for APPLY RULES WITH NO SOURCE DATABASE SPECIFIED
. Rows are returned if no source database is specified in the DBA_STREAMS_TABLE_RULES
. (SCHEMA,GLOBAL) view. An apply process can perform transactions from a single source database.
. In a typical replication environment, the source database name must be specified. In the single
. site case where captured events from the source database are handled by an apply process on the
. same database, the source database column does not need to be specified.

no rows selected

++ Check for SCHEMA RULES FOR NON_EXISTANT SCHEMA ++
no rows selected

+++ Fast Evaluation Rule Set Rules for queues +++

Rule Set Rule
Name 		RULE_CONDITION
STRMADMIN.PPCAPR_QUEUE_R STRMADMIN.PPCAPR18 ((:dml.get_object_owner() = 'PPCAPR') and :dml.is_null_tag() = 'Y' and :dml.get_ source_database_name() = 'GIDQUEST.REGRESS.RDBMS.DEV.US.ORACLE.COM' )
STRMADMIN.PPCAPR_QUEUE_R STRMADMIN.PPCAPR19 ((:ddl.get_object_owner() = 'PPCAPR' or :ddl.get_base_table_owner() = 'PPCAPR') and :ddl.is_null_tag() = 'Y' and :ddl.get_source_database_name() = 'GIDQUEST.REG RESS.RDBMS.DEV.US.ORACLE.COM' )
SYS.ALERT_QUE_R SYS.ALERT_QUE$1 tab.user_data.MESSAGE_LEVEL = 5 AND tab.user_data.MESSAGE_GROUP = 'High Availabi lity'
SYS.SCHEDULER$_JOBQ_R SYS.RULE$_11 :"VAR$_10".JOB_NAME IS NOT NULL
SYS.SCHEDULER$_JOBQ_R SYS.RULE$_3 :"VAR$_2".GET_FLAGS() IS NOT NULL
SYS.SCHEDULER$_JOBQ_R SYS.RULE$_7 :"VAR$_6".JOB_NAME IS NOT NULL

6 rows selected.


++ Check for CONSTRAINTS ON TABLES CONFIGURED IN STREAMS

Object CONSTRAINT_NAME C Status Last
Change 		Search
Condition 		Reference
Constraint
PPCAPR.APPL_ST_T PK_AST_ASI P ENABLED 17:43:02 01 /30/08   .
PPCAPR.APPL_ST_T FK_AST_BC R ENABLED 17:43:06 01 /30/08   PPCAPR.PK_BT_BC
PPCAPR.APPL_ST_T NN_AST_LUD C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.APPL_ST_T NN_AST_LUUI C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.APPL_ST_T NN_AST_ASI C ENABLED 17:40:06 01 /30/08 "APPL_ST_ID" IS NOT NULL .
PPCAPR.APPL_ST_T NN_AST_CUI C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.APPL_ST_T NN_AST_ASC C ENABLED 17:40:06 01 /30/08 "APPL_ST_CD" IS NOT NULL .
PPCAPR.APPL_ST_T NN_AST_ASN C ENABLED 17:40:06 01 /30/08 "APPL_ST_NM" IS NOT NULL .
PPCAPR.APPL_ST_T NN_AST_CDD C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.APSE_LVL_T PK_ALT_ALC P ENABLED 17:43:03 01 /30/08   .
PPCAPR.APSE_LVL_T NN_ALT_LUUI C ENABLED 17:40:08 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.APSE_LVL_T NN_ALT_CUI C ENABLED 17:40:08 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.APSE_LVL_T NN_ALT_LUD C ENABLED 17:40:08 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.APSE_LVL_T NN_ALT_CD C ENABLED 17:40:08 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.APSE_LVL_T NN_ALT_ACCLC C ENABLED 17:40:08 01 /30/08 "ACS_LVL_CD" IS NOT NULL .
PPCAPR.APSE_LVL_T NN_ALT_ALC C ENABLED 17:40:08 01 /30/08 "APSE_LVL_CD" IS NOT NULL .
PPCAPR.ARCV_EV_T SYS_C0011934 C ENABLED 17:40:06 01 /30/08 "EVENT_ID" IS NOT NULL .
PPCAPR.ARCV_EV_T PK_AET_EI P ENABLED 17:43:02 01 /30/08   .
PPCAPR.AWRD_ARBT_TYP_T SYS_C0011940 C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.AWRD_ARBT_TYP_T SYS_C0011937 C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.AWRD_ARBT_TYP_T SYS_C0011938 C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.AWRD_ARBT_TYP_T SYS_C0011939 C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.AWRD_ARBT_TYP_T SYS_C0011935 C ENABLED 17:40:06 01 /30/08 "AWRD_ARBT_TYP_CD" IS NOT NULL .
PPCAPR.AWRD_ARBT_TYP_T PK_ABTT_AATC P ENABLED 17:43:02 01 /30/08   .
PPCAPR.AWRD_ARBT_TYP_T SYS_C0011936 C ENABLED 17:40:06 01 /30/08 "AWRD_ARBT_TYP_NM" IS NOT NULL .
PPCAPR.AWRD_CALC_LVL_T PK_ACL_ACLI P ENABLED 17:43:02 01 /30/08   .
PPCAPR.AWRD_CALC_LVL_T NN_ACL_ACLN C ENABLED 17:40:06 01 /30/08 "AWRD_CALC_LVL_NM" IS NOT NULL .
PPCAPR.AWRD_CALC_LVL_T NN_ACL_CD C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.AWRD_CALC_LVL_T NN_ACLT_PUD C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.AWRD_CALC_LVL_T NN_ACL_CUI C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.AWRD_CALC_LVL_T NN_ACLT_LUUI C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.AWRD_T FK_AT_TSTI R ENABLED 17:43:06 01 /30/08   PPCAPR.PK_STT_STI
PPCAPR.AWRD_T FK_AT_ACLI R ENABLED 17:43:06 01 /30/08   PPCAPR.PK_ACL_ACLI
PPCAPR.AWRD_T FK_AT_ATI R ENABLED 17:43:06 01 /30/08   PPCAPR.PK_ATT_ATI
PPCAPR.AWRD_T FK_AT_CITI R ENABLED 17:43:06 01 /30/08   PPCAPR.PK_CITT_CITI
PPCAPR.AWRD_T FK_AT_PRTI R ENABLED 17:43:06 01 /30/08   PPCAPR.PK_PRT_PRTI
PPCAPR.AWRD_T NN_AT_AN C ENABLED 17:40:06 01 /30/08 "AWRD_NM" IS NOT NULL .
PPCAPR.AWRD_T NN_AT_ATI C ENABLED 17:40:06 01 /30/08 "AWRD_TYP_ID" IS NOT NULL .
PPCAPR.AWRD_T NN_AT_CD C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.AWRD_T NN_AT_LUD C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.AWRD_T NN_AT_ACLI C ENABLED 17:40:06 01 /30/08 "AWRD_CALC_LVL_ID" IS NOT NULL .
PPCAPR.AWRD_T NN_AT_CUI C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.AWRD_T NN_AT_LUUI C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.AWRD_T NN_AT_PRTI C ENABLED 17:40:06 01 /30/08 "PMOTN_RUL_TIER_ID" IS NO T NULL .
PPCAPR.AWRD_T NN_AT_AATC C ENABLED 17:40:06 01 /30/08 "AWRD_ARBT_TYP_CD" IS NOT NULL .
PPCAPR.AWRD_T NN_AT_AC C ENABLED 17:40:06 01 /30/08 "AWRD_CNT" IS NOT NULL .
PPCAPR.AWRD_T PK_AT_AI P ENABLED 17:43:02 01 /30/08   .
PPCAPR.AWRD_T FK_AT_ARI R ENABLED 17:43:06 01 /30/08   PPCAPR.PK_RT_RI
PPCAPR.AWRD_T FK_AT_FSTI R ENABLED 17:43:06 01 /30/08   PPCAPR.PK_STT_STI
PPCAPR.AWRD_T SYS_C0012569 R DISABLED 17:43:06 01 /30/08   PPCAPR.PK_ABTT_AATC
PPCAPR.AWRD_TYP_T NN_ATT_LUUI C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.AWRD_TYP_T NN_ATT_CD C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.AWRD_TYP_T NN_ATT_ATN C ENABLED 17:40:06 01 /30/08 "AWRD_TYP_NM" IS NOT NULL .
PPCAPR.AWRD_TYP_T PK_ATT_ATI P ENABLED 17:43:02 01 /30/08   .
PPCAPR.AWRD_TYP_T NN_ATT_CUI C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.AWRD_TYP_T NN_ATT_LUD C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.A_B_TST_BKT_T NN_ABTBT_LUUI C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.A_B_TST_BKT_T NN_ABTBKT_TBI C ENABLED 17:40:06 01 /30/08 "TST_BKT_ID" IS NOT NULL .
PPCAPR.A_B_TST_BKT_T NN_ABTBT_CD C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.A_B_TST_BKT_T NN_ABTBT_TBSP C ENABLED 17:40:06 01 /30/08 "TST_BKT_SZ_PCT" IS NOT N ULL .
PPCAPR.A_B_TST_BKT_T NN_ABTBT_CUI C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.A_B_TST_BKT_T NN_ABTBT_LUD C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.A_B_TST_BKT_T FK_ABTBT_ABTGI R DISABLED 17:43:06 01 /30/08   PPCAPR.SYS_C0012486
PPCAPR.A_B_TST_BKT_T NN_ABTBT_ABTGI C ENABLED 17:40:06 01 /30/08 "A_B_TST_GRP_ID" IS NOT N ULL .
PPCAPR.A_B_TST_BKT_T PK_ABTBT_TBI P ENABLED 17:43:02 01 /30/08   .
PPCAPR.A_B_TST_GRP_T NN_ABTGT_LUUI C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.A_B_TST_GRP_T SYS_C0012486 P ENABLED 17:43:02 01 /30/08   .
PPCAPR.A_B_TST_GRP_T NN_ABTGT_CUI C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.A_B_TST_GRP_T NN_ABTGT_LUD C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.A_B_TST_GRP_T NN_ABTGT_CD C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.A_B_TST_GRP_T NN_ABTGT_ABTGI C ENABLED 17:40:06 01 /30/08 "A_B_TST_GRP_ID" IS NOT N ULL .
PPCAPR.A_B_TST_GRP_T NN_ABTGT_DI C ENABLED 17:40:06 01 /30/08 "DLT_IND" IS NOT NULL .
PPCAPR.BRD_CHNL_ASSN_T NN_BCAT_CUI C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.BRD_CHNL_ASSN_T NN_BCAT_LUUI C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.BRD_CHNL_ASSN_T NN_BCAT_LUD C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.BRD_CHNL_ASSN_T FK_BCA_BC R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_BT_BC
PPCAPR.BRD_CHNL_ASSN_T FK_BCA_CHC R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_CT_CHC
PPCAPR.BRD_CHNL_ASSN_T PK_BCA_BC_CHC P ENABLED 17:43:02 01 /30/08   .
PPCAPR.BRD_CHNL_ASSN_T NN_BCAT_CD C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.BRD_CHNL_PMOTN_ASSN_T FK_BCPA_PI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_PT_PI
PPCAPR.BRD_CHNL_PMOTN_ASSN_T FK_BCPA_BC_CHC R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_BCA_BC_CHC
PPCAPR.BRD_CHNL_PMOTN_ASSN_T NN_BCPA_CD C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.BRD_CHNL_PMOTN_ASSN_T PK_BCPA_PI_BC_CHC P ENABLED 17:43:02 01 /30/08   .
PPCAPR.BRD_CHNL_PMOTN_ASSN_T NN_BCPAT_LUD C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.BRD_CHNL_PMOTN_ASSN_T NN_BCPA_CUI C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.BRD_CHNL_PMOTN_ASSN_T NN_BCPAT_LUUI C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.BRD_RUL_ASSN_T NN_BRAT_LUUI C ENABLED 17:40:08 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.BRD_RUL_ASSN_T FK_BRAT_RI R ENABLED 17:43:05 01 /30/08   PPCAPR.PK_RT_RI
PPCAPR.BRD_RUL_ASSN_T SYS_C0012311 C ENABLED 17:40:08 01 /30/08 "RUL_ID" IS NOT NULL .
PPCAPR.BRD_RUL_ASSN_T SYS_C0012310 C ENABLED 17:40:08 01 /30/08 "BRD_CD" IS NOT NULL .
PPCAPR.BRD_RUL_ASSN_T PK_BRAT_BC_RI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.BRD_RUL_ASSN_T NN_BRAT_CD C ENABLED 17:40:08 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.BRD_RUL_ASSN_T NN_BART_LUD C ENABLED 17:40:08 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.BRD_RUL_ASSN_T FK_BRAT_BC R ENABLED 17:43:06 01 /30/08   PPCAPR.PK_BT_BC
PPCAPR.BRD_RUL_ASSN_T NN_BART_CUI C ENABLED 17:40:08 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.BRD_T NN_BT_BN C ENABLED 17:40:06 01 /30/08 "BRD_NM" IS NOT NULL .
PPCAPR.BRD_T NN_BT_CD C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.BRD_T NN_BT_LUD C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.BRD_T NN_BT_CUI C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.BRD_T NN_BT_LUUI C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.BRD_T NN_BT_ABN C ENABLED 17:40:06 01 /30/08 "ABBR_BRD_NM" IS NOT NULL .
PPCAPR.BRD_T PK_BT_BC P ENABLED 17:43:02 01 /30/08   .
PPCAPR.CD_REQ_STAT_TYP_T SYS_C0011988 C ENABLED 17:40:06 01 /30/08 "CD_REQ_STAT_TYP_ID" IS N OT NULL .
PPCAPR.CD_REQ_STAT_TYP_T NN_CRST_CRSTD C ENABLED 17:40:06 01 /30/08 "CD_REQ_STAT_TYP_DESC" IS NOT NULL .
PPCAPR.CD_REQ_STAT_TYP_T NN_CRST_CD C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.CD_REQ_STAT_TYP_T NN_CRSTT_LUD C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.CD_REQ_STAT_TYP_T NN_CRST_CUI C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.CD_REQ_STAT_TYP_T NN_CRSTT_LUUI C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.CD_REQ_STAT_TYP_T PK_CRST_CRSTI P ENABLED 17:43:02 01 /30/08   .
PPCAPR.CD_REQ_T NN_CR_CUI C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.CD_REQ_T NN_CRT_LUD C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.CD_REQ_T NN_CR_CD C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.CD_REQ_T NN_CRT_RD C ENABLED 17:40:06 01 /30/08 "REQOR_DESC" IS NOT NULL .
PPCAPR.CD_REQ_T NN_CRT_LUUI C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.CD_REQ_T NN_CD_CRSTI C ENABLED 17:40:06 01 /30/08 "CD_REQ_STAT_TYP_ID" IS N OT NULL .
PPCAPR.CD_REQ_T NN_CRT_PI C ENABLED 17:40:06 01 /30/08 "PMOTN_ID" IS NOT NULL .
PPCAPR.CD_REQ_T FK_CR_PI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_PT_PI
PPCAPR.CD_REQ_T FK_CR_CRSTI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_CRST_CRSTI
PPCAPR.CD_REQ_T NN_CRT_CRN C ENABLED 17:40:06 01 /30/08 "CD_REQ_CNT" IS NOT NULL .
PPCAPR.CD_REQ_T PK_CR_CRI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.CHNL_PMOTN_ASSN_T NN_CPAT_LUUI C ENABLED 17:40:08 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.CHNL_PMOTN_ASSN_T NN_CPAT_CUI C ENABLED 17:40:08 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.CHNL_PMOTN_ASSN_T FK_CPAT_CC R ENABLED 17:43:06 01 /30/08   PPCAPR.PK_CT_CHC
PPCAPR.CHNL_PMOTN_ASSN_T FK_CPAT_PI R ENABLED 17:43:06 01 /30/08   PPCAPR.PK_PT_PI
PPCAPR.CHNL_PMOTN_ASSN_T PK_CPAT_CC_PI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.CHNL_PMOTN_ASSN_T SYS_C0012316 C ENABLED 17:40:08 01 /30/08 "CHNL_CD" IS NOT NULL .
PPCAPR.CHNL_PMOTN_ASSN_T SYS_C0012317 C ENABLED 17:40:08 01 /30/08 "PMOTN_ID" IS NOT NULL .
PPCAPR.CHNL_PMOTN_ASSN_T NN_CPAT_LUD C ENABLED 17:40:08 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.CHNL_PMOTN_ASSN_T NN_CPAT_CD C ENABLED 17:40:08 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.CHNL_T PK_CT_CHC P ENABLED 17:43:03 01 /30/08   .
PPCAPR.CHNL_T NN_CT_LUUI C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.CHNL_T NN_CT_CD C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.CHNL_T NN_CT_LUDD C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.CHNL_T NN_CT_CUII C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.CHNL_T NN_CT_CN C ENABLED 17:40:06 01 /30/08 "CHNL_NM" IS NOT NULL .
PPCAPR.CMPL_PRC_T NN_CPT_PTI C ENABLED 17:40:08 01 /30/08 "PRC_TYP_ID" IS NOT NULL .
PPCAPR.CMPL_PRC_T NN_CPT_CC C ENABLED 17:40:08 01 /30/08 "CNCY_CD" IS NOT NULL .
PPCAPR.CMPL_PRC_T NN_CPT_LUUI C ENABLED 17:40:08 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.CMPL_PRC_T NN_CPT_LUD C ENABLED 17:40:08 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.CMPL_PRC_T NN_CPT_CUI C ENABLED 17:40:08 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.CMPL_PRC_T NN_CPT_CD C ENABLED 17:40:08 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.CMPL_PRC_T FK_CPT_CC R ENABLED 17:43:23 01 /30/08   PPCAPR.PK_CNCYT_CC
PPCAPR.CMPL_PRC_T NN_CPT_CII C ENABLED 17:40:08 01 /30/08 "CTLG_ITM_ID" IS NOT NULL .
PPCAPR.CMPL_PRC_T NN_CPT_IPI C ENABLED 17:40:08 01 /30/08 "CMPL_PRC_ID" IS NOT NULL .
PPCAPR.CMPL_PRC_T PK_CPT_PPI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.CMPL_PRC_T FK_CPT_LPI R ENABLED 17:43:22 01 /30/08   PPCAPR.PK_LPT_LPI
PPCAPR.CMPL_PRC_T FK_CPT_PTI R ENABLED 17:43:22 01 /30/08   PPCAPR.PL_PTT_PTI
PPCAPR.CMPL_PRC_T NN_CPT_PSD C ENABLED 17:40:08 01 /30/08 "PRC_STRT_DT" IS NOT NULL .
PPCAPR.CNCY_T PK_CNCYT_CC P ENABLED 17:43:03 01 /30/08   .
PPCAPR.CNCY_T NN_CNCT_CUI C ENABLED 17:40:08 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.CNCY_T NN_CNCT_LUD C ENABLED 17:40:08 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.CNCY_T NN_CNCT_CD C ENABLED 17:40:08 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.CNCY_T NN_CNCT_CC C ENABLED 17:40:08 01 /30/08 "CNCY_CD" IS NOT NULL .
PPCAPR.CNCY_T NN_CNCT_LUUI C ENABLED 17:40:08 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.CND_BRD_T PK_CBT_CBI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.CND_BRD_T SYS_C0012011 C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.CND_BRD_T SYS_C0012007 C ENABLED 17:40:06 01 /30/08 "CND_BRD_ID" IS NOT NULL .
PPCAPR.CND_BRD_T SYS_C0012008 C ENABLED 17:40:06 01 /30/08 "BRD_CD" IS NOT NULL .
PPCAPR.CND_BRD_T SYS_C0012009 C ENABLED 17:40:06 01 /30/08 "PPC_CATG_IND" IS NOT NUL L .
PPCAPR.CND_BRD_T SYS_C0012010 C ENABLED 17:40:06 01 /30/08 "CND_ID" IS NOT NULL .
PPCAPR.CND_BRD_T SYS_C0012012 C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.CND_BRD_T SYS_C0012013 C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.CND_BRD_T SYS_C0012014 C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.CND_BRD_T FK_CBT_CITI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_CITT_CITI
PPCAPR.CND_BRD_T FK_CBT_CI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_CT_CI
PPCAPR.CND_BRD_T FK_CBT_BC R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_BT_BC
PPCAPR.CND_STY_CLR_T SYS_C0012018 C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.CND_STY_CLR_T PK_CSCT_SCBI_BC_CBI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.CND_STY_CLR_T NN_CSCT_SBI C ENABLED 17:40:06 01 /30/08 "STY_BUS_ID" IS NOT NULL .
PPCAPR.CND_STY_CLR_T SYS_C0012016 C ENABLED 17:40:06 01 /30/08 "BRD_CD" IS NOT NULL .
PPCAPR.CND_STY_CLR_T SYS_C0012015 C ENABLED 17:40:06 01 /30/08 "STY_CLR_BUS_ID" IS NOT N ULL .
PPCAPR.CND_STY_CLR_T FK_CSCT_BC R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_BT_BC
PPCAPR.CND_STY_CLR_T FK_CSCT_CBI R ENABLED 17:43:17 01 /30/08   PPCAPR.PK_CBT_CBI
PPCAPR.CND_STY_CLR_T SYS_C0012019 C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.CND_STY_CLR_T SYS_C0012020 C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.CND_STY_CLR_T SYS_C0012021 C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.CND_STY_CLR_T SYS_C0012022 C ENABLED 17:40:06 01 /30/08 "CND_BRD_ID" IS NOT NULL .
PPCAPR.CND_T PK_CT_CI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.CND_T FK_CT_RI R ENABLED 17:43:22 01 /30/08   PPCAPR.PK_RT_RI
PPCAPR.CND_T FK_CT_CTI R ENABLED 17:43:22 01 /30/08   PPCAPR.PK_CTT_CTI
PPCAPR.CND_T SYS_C0012030 C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.CND_T SYS_C0012029 C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.CND_T SYS_C0012028 C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.CND_T SYS_C0012025 C ENABLED 17:40:06 01 /30/08 "CND_TYP_ID" IS NOT NULL .
PPCAPR.CND_T SYS_C0012026 C ENABLED 17:40:06 01 /30/08 "RUL_ID" IS NOT NULL .
PPCAPR.CND_T SYS_C0012027 C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.CND_T SYS_C0012023 C ENABLED 17:40:06 01 /30/08 "CND_ID" IS NOT NULL .
PPCAPR.CND_T SYS_C0012024 C ENABLED 17:40:06 01 /30/08 "CND_DESC" IS NOT NULL .
PPCAPR.CND_TYP_T SYS_C0012032 C ENABLED 17:40:06 01 /30/08 "CND_TYP_NM" IS NOT NULL .
PPCAPR.CND_TYP_T SYS_C0012031 C ENABLED 17:40:06 01 /30/08 "CND_TYP_ID" IS NOT NULL .
PPCAPR.CND_TYP_T PK_CTT_CTI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.CND_TYP_T SYS_C0012036 C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.CND_TYP_T SYS_C0012035 C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.CND_TYP_T SYS_C0012034 C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.CND_TYP_T SYS_C0012033 C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.CR_CRD_TYP_T NN_CCTT_PI C ENABLED 17:40:06 01 /30/08 "PLCC_IND" IS NOT NULL .
PPCAPR.CR_CRD_TYP_T NN_CCTT_LUUI C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.CR_CRD_TYP_T NN_CCTT_CUI C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.CR_CRD_TYP_T NN_CCTT_LUD C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.CR_CRD_TYP_T NN_CCTT_CD C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.CR_CRD_TYP_T NN_CCTT_CCTSN C ENABLED 17:40:06 01 /30/08 "CR_CRD_TYP_SHRT_NM" IS N OT NULL .
PPCAPR.CR_CRD_TYP_T NN_CCTT_CCTI C ENABLED 17:40:06 01 /30/08 "CR_CRD_TYP_ID" IS NOT NU LL .
PPCAPR.CR_CRD_TYP_T PK_CCTT_CCTI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.CTLG_ITM_TYP_T NN_CITT_CUI C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.CTLG_ITM_TYP_T NN_CITT_LUD C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.CTLG_ITM_TYP_T NN_CITT_CD C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.CTLG_ITM_TYP_T NN_CITT_CITI C ENABLED 17:40:06 01 /30/08 "CTLG_ITM_TYP_ID" IS NOT NULL .
PPCAPR.CTLG_ITM_TYP_T NN_CITT_LUUI C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.CTLG_ITM_TYP_T PK_CITT_CITI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.DSCT_TYP_T NN_DTT_LUUI C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.DSCT_TYP_T NN_DTT_CUI C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.DSCT_TYP_T PK_DT_DTC P ENABLED 17:43:03 01 /30/08   .
PPCAPR.DSCT_TYP_T NN_DTT_CD C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.DSCT_TYP_T NN_DT_DTD C ENABLED 17:40:06 01 /30/08 "DSCT_TYP_DESC" IS NOT NU LL .
PPCAPR.DSCT_TYP_T NN_DTT_LUD C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.EV_T PK_ET_EI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.EV_T SYS_C0012054 C ENABLED 17:40:06 01 /30/08 "EVENT_ID" IS NOT NULL .
PPCAPR.EXP_CATG_T NN_ECT_CD C ENABLED 17:40:08 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.EXP_CATG_T NN_ECT_EED C ENABLED 17:40:08 01 /30/08 "EFF_END_DTTM" IS NOT NUL L .
PPCAPR.EXP_CATG_T SYS_C0012465 C ENABLED 17:40:08 01 /30/08 "BUS_ID" IS NOT NULL .
PPCAPR.EXP_CATG_T NN_ECT_CUI C ENABLED 17:40:08 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.EXP_CATG_T SYS_C0012463 C ENABLED 17:40:08 01 /30/08 "BRD_CD" IS NOT NULL .
PPCAPR.EXP_CATG_T SYS_C0012462 C ENABLED 17:40:08 01 /30/08 "PMOTN_REF_ID" IS NOT NUL L .
PPCAPR.EXP_CATG_T SYS_C0012469 C ENABLED 17:40:08 01 /30/08 "UOW_ID" IS NOT NULL .
PPCAPR.EXP_CATG_T PK_ECT_PRI_UI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.EXP_CATG_T SYS_C0012466 C ENABLED 17:40:08 01 /30/08 "EFF_STRT_DTTM" IS NOT NU LL .
PPCAPR.FLAT_PRC_T PK_FPT_FPI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.FLAT_PRC_T FK_FPT_LPI R ENABLED 17:43:23 01 /30/08   PPCAPR.PK_LPT_LPI
PPCAPR.FLAT_PRC_T FK_FPT_PTI R ENABLED 17:43:23 01 /30/08   PPCAPR.PL_PTT_PTI
PPCAPR.FLAT_PRC_T FK_FPT_CC R ENABLED 17:43:23 01 /30/08   PPCAPR.PK_CNCYT_CC
PPCAPR.FLAT_PRC_T NN_FPT_LUUI C ENABLED 17:40:08 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.FLAT_PRC_T NN_FPT_LUD C ENABLED 17:40:08 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.FLAT_PRC_T NN_FPT_IPI C ENABLED 17:40:08 01 /30/08 "FLAT_PRC_ID" IS NOT NULL .
PPCAPR.FLAT_PRC_T NN_FPT_CD C ENABLED 17:40:08 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.FLAT_PRC_T NN_FPT_PED C ENABLED 17:40:08 01 /30/08 "PRC_END_DT" IS NOT NULL .
PPCAPR.FLAT_PRC_T NN_FPT_PSD C ENABLED 17:40:08 01 /30/08 "PRC_STRT_DT" IS NOT NULL .
PPCAPR.FLAT_PRC_T NN_FPT_PTI C ENABLED 17:40:08 01 /30/08 "PRC_TYP_ID" IS NOT NULL .
PPCAPR.FLAT_PRC_T NN_FPT_CC C ENABLED 17:40:08 01 /30/08 "CNCY_CD" IS NOT NULL .
PPCAPR.FLAT_PRC_T NN_FPT_CII C ENABLED 17:40:08 01 /30/08 "CTLG_ITM_ID" IS NOT NULL .
PPCAPR.FLAT_PRC_T NN_FPT_CUI C ENABLED 17:40:08 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.LST_PRC_T PK_LPT_LPI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.LST_PRC_T NN_LPT_LUUI C ENABLED 17:40:08 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.LST_PRC_T NN_LPT_LUD C ENABLED 17:40:08 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.LST_PRC_T NN_LPT_LPI C ENABLED 17:40:08 01 /30/08 "LST_PRC_ID" IS NOT NULL .
PPCAPR.LST_PRC_T NN_LPT_CD C ENABLED 17:40:08 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.LST_PRC_T NN_LPT_LPC C ENABLED 17:40:08 01 /30/08 "LST_PRC_AMT" IS NOT NULL .
PPCAPR.LST_PRC_T NN_LPT_CII C ENABLED 17:40:08 01 /30/08 "CTLG_ITM_ID" IS NOT NULL .
PPCAPR.LST_PRC_T NN_LPT_CUI C ENABLED 17:40:08 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.MPP_LIST_PRD_T PK_MLPT_BI_MLI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.MPP_LIST_PRD_T NN_MLPT_LUUI C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.MPP_LIST_PRD_T NN_MLPT_LUD C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.MPP_LIST_PRD_T FK_MLT_MLI R ENABLED 17:43:06 01 /30/08   PPCAPR.PK_MLT_MLI
PPCAPR.MPP_LIST_PRD_T NN_MLPT_CD C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.MPP_LIST_PRD_T NN_MLPT_MLI C ENABLED 17:40:06 01 /30/08 "MPP_LIST_ID" IS NOT NULL .
PPCAPR.MPP_LIST_PRD_T NN_MLPT_CISI C ENABLED 17:40:06 01 /30/08 "CTLG_ITM_STYP_ID" IS NOT NULL .
PPCAPR.MPP_LIST_PRD_T NN_MLPT_CUI C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.MPP_LIST_PRD_T NN_MLPT_BI C ENABLED 17:40:06 01 /30/08 "BUS_ID" IS NOT NULL .
PPCAPR.MPP_LIST_T NN_MLT_BC C ENABLED 17:40:06 01 /30/08 "BRD_CD" IS NOT NULL .
PPCAPR.MPP_LIST_T NN_MLT_PRI C ENABLED 17:40:06 01 /30/08 "PMOTN_REF_ID" IS NOT NUL L .
PPCAPR.MPP_LIST_T NN_MLT_MLI C ENABLED 17:40:06 01 /30/08 "MPP_LIST_ID" IS NOT NULL .
PPCAPR.MPP_LIST_T NN_MLT_ESD C ENABLED 17:40:06 01 /30/08 "EFF_STRT_DTTM" IS NOT NU LL .
PPCAPR.MPP_LIST_T NN_MLT_EED C ENABLED 17:40:06 01 /30/08 "EFF_END_DTTM" IS NOT NUL L .
PPCAPR.MPP_LIST_T NN_MLT_MLN C ENABLED 17:40:06 01 /30/08 "MPP_LIST_NM" IS NOT NULL .
PPCAPR.MPP_LIST_T NN_MLT_MTI C ENABLED 17:40:06 01 /30/08 "MPP_TYP_ID" IS NOT NULL .
PPCAPR.MPP_LIST_T NN_MLT_CUI C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.MPP_LIST_T NN_MLT_CD C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.MPP_LIST_T NN_MLT_LUUI C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.MPP_LIST_T NN_MLT_LUD C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.MPP_LIST_T PK_MLT_MLI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.MPP_LIST_T FK_MTT_MTI R ENABLED 17:43:06 01 /30/08   PPCAPR.PK_MTT_MTI
PPCAPR.MPP_PRD_MSG_T PK_MPMT_MPMI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.MPP_PRD_MSG_T FK_MPTT_MPTI R ENABLED 17:43:06 01 /30/08   PPCAPR.PK_MPTT_MPTI
PPCAPR.MPP_PRD_MSG_T FK_MPMTT_MPMTI R ENABLED 17:43:06 01 /30/08   PPCAPR.PK_MPMTT_MPMTI
PPCAPR.MPP_PRD_MSG_T NN_MPMT_PRI C ENABLED 17:40:06 01 /30/08 "PMOTN_REF_ID" IS NOT NUL L .
PPCAPR.MPP_PRD_MSG_T NN_MPMT_LUUI C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.MPP_PRD_MSG_T NN_MPMT_LUD C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.MPP_PRD_MSG_T NN_MPMT_CD C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.MPP_PRD_MSG_T NN_MPMT_CUI C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.MPP_PRD_MSG_T NN_MPMT_MTI C ENABLED 17:40:06 01 /30/08 "MPP_TYP_ID" IS NOT NULL .
PPCAPR.MPP_PRD_MSG_T NN_MPMT_MPMTI C ENABLED 17:40:06 01 /30/08 "MPP_PRD_MSG_TYP_ID" IS N OT NULL .
PPCAPR.MPP_PRD_MSG_T NN_MPMT_MPMT C ENABLED 17:40:06 01 /30/08 "MPP_PRD_MSG_TXT" IS NOT NULL .
PPCAPR.MPP_PRD_MSG_T NN_MPMT_EED C ENABLED 17:40:06 01 /30/08 "EFF_END_DTTM" IS NOT NUL L .
PPCAPR.MPP_PRD_MSG_T NN_MPMT_ESD C ENABLED 17:40:06 01 /30/08 "EFF_STRT_DTTM" IS NOT NU LL .
PPCAPR.MPP_PRD_MSG_T NN_MPMT_CISI C ENABLED 17:40:06 01 /30/08 "CTLG_ITM_STYP_ID" IS NOT NULL .
PPCAPR.MPP_PRD_MSG_T NN_MPMT_BI C ENABLED 17:40:06 01 /30/08 "BUS_ID" IS NOT NULL .
PPCAPR.MPP_PRD_MSG_T NN_MPMT_BC C ENABLED 17:40:06 01 /30/08 "BRD_CD" IS NOT NULL .
PPCAPR.MPP_PRD_MSG_T NN_MPMT_MPMI C ENABLED 17:40:06 01 /30/08 "MPP_PRD_MSG_ID" IS NOT N ULL .
PPCAPR.MPP_PRD_MSG_TYP_T PK_MPMTT_MPMTI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.MPP_PRD_MSG_TYP_T NN_MPMTT_MPMTD C ENABLED 17:40:06 01 /30/08 "MPP_PRD_MSG_TYE_DESC" IS NOT NULL .
PPCAPR.MPP_PRD_MSG_TYP_T NN_MPMTT_MPMTI C ENABLED 17:40:06 01 /30/08 "MPP_PRD_MSG_TYP_ID" IS N OT NULL .
PPCAPR.MPP_PRD_MSG_TYP_T NN_MPMTT_CUI C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.MPP_PRD_MSG_TYP_T NN_MPMTT_CD C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.MPP_PRD_MSG_TYP_T NN_MPMTT_LUUI C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.MPP_PRD_MSG_TYP_T NN_MPMTT_LUD C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.MPP_TYP_T NN_MTT_MTD C ENABLED 17:40:06 01 /30/08 "MPP_TYP_DESC" IS NOT NUL L .
PPCAPR.MPP_TYP_T NN_MTT_MTI C ENABLED 17:40:06 01 /30/08 "MPP_TYP_ID" IS NOT NULL .
PPCAPR.MPP_TYP_T NN_MTT_CUI C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.MPP_TYP_T NN_MTT_CD C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.MPP_TYP_T NN_MTT_LUUI C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.MPP_TYP_T NN_MTT_LUD C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.MPP_TYP_T PK_MTT_MTI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.MSG_PRTY_TYP_T PK_MPTT_MPTI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.MSG_PRTY_TYP_T NN_MPTT_MUD C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.MSG_PRTY_TYP_T NN_MPTT_LUUI C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.MSG_PRTY_TYP_T NN_MPTT_MPTI C ENABLED 17:40:06 01 /30/08 "MSG_PRTY_TYP_ID" IS NOT NULL .
PPCAPR.MSG_PRTY_TYP_T NN_MPTT_CUI C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.MSG_PRTY_TYP_T NN_MPTT_MPTD C ENABLED 17:40:06 01 /30/08 "MSG_PRTY_TYP_DESC" IS NO T NULL .
PPCAPR.MSG_PRTY_TYP_T NN_MPTT_CD C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.MUP_ID_MAP_T NN_MIMT_ESD C ENABLED 17:40:06 01 /30/08 "EFF_STRT_DT" IS NOT NULL .
PPCAPR.MUP_ID_MAP_T NN_MIMT_EED C ENABLED 17:40:06 01 /30/08 "EFF_END_DTTM" IS NOT NUL L .
PPCAPR.MUP_ID_MAP_T PK_MIMT_MI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.MUP_ID_MAP_T NN_MIMT_BC C ENABLED 17:40:06 01 /30/08 "BRD_CD" IS NOT NULL .
PPCAPR.MUP_ID_MAP_T NN_MIMT_GI C ENABLED 17:40:06 01 /30/08 "GRP_ID" IS NOT NULL .
PPCAPR.MUP_ID_MAP_T NN_MIMT_MI C ENABLED 17:40:06 01 /30/08 "MUP_ID" IS NOT NULL .
PPCAPR.MUP_ID_MAP_T NN_MIMT_MCI C ENABLED 17:40:06 01 /30/08 "MDSE_CO_ID" IS NOT NULL .
PPCAPR.MUP_NACTV_RSN_T NN_MNRT_LUD C ENABLED 17:40:08 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.MUP_NACTV_RSN_T NN_MNRT_LUUI C ENABLED 17:40:08 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.MUP_NACTV_RSN_T PK_MNRT_NRI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.MUP_NACTV_RSN_T NN_MNRT_NRI C ENABLED 17:40:08 01 /30/08 "NACTV_RSN_ID" IS NOT NUL L .
PPCAPR.MUP_NACTV_RSN_T NN_MNRT_NRD C ENABLED 17:40:08 01 /30/08 "NACTV_RSN_DESC" IS NOT N ULL .
PPCAPR.MUP_NACTV_RSN_T NN_MNRT_CUI C ENABLED 17:40:08 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.MUP_NACTV_RSN_T NN_MNRT_CD C ENABLED 17:40:08 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.MUP_STY_CLR_T FK_MSC_MI R ENABLED 17:43:06 01 /30/08   PPCAPR.PK_MT_MI
PPCAPR.MUP_STY_CLR_T PK_MSCT_MI_MSCI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.MUP_STY_CLR_T NN_MSC_LUD C ENABLED 17:40:06 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.MUP_STY_CLR_T NN_MSC_MI C ENABLED 17:40:06 01 /30/08 "MUP_ID" IS NOT NULL .
PPCAPR.MUP_STY_CLR_T NN_MSC_LSC C ENABLED 17:40:06 01 /30/08 "LGCY_STY_CD" IS NOT NULL .
PPCAPR.MUP_STY_CLR_T NN_MSC_LMC C ENABLED 17:40:06 01 /30/08 "LGCY_MKT_CD" IS NOT NULL .
PPCAPR.MUP_STY_CLR_T NN_MSC_LSCC C ENABLED 17:40:06 01 /30/08 "LGCY_STY_CLR_CD" IS NOT NULL .
PPCAPR.MUP_STY_CLR_T NN_MSC_CD C ENABLED 17:40:06 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.MUP_STY_CLR_T NN_MSC_SUD C ENABLED 17:40:06 01 /30/08 "SRC_UPDT_DTTM" IS NOT NU LL .
PPCAPR.MUP_STY_CLR_T NN_MSC_CUI C ENABLED 17:40:06 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.MUP_STY_CLR_T NN_MSC_LUUI C ENABLED 17:40:06 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.MUP_T NN_MT_CD C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.MUP_T FK_MT_DTC R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_DT_DTC
PPCAPR.MUP_T NN_MT_ESD C ENABLED 17:40:07 01 /30/08 "EFF_STRT_DT" IS NOT NULL .
PPCAPR.MUP_T NN_MT_DA C ENABLED 17:40:07 01 /30/08 "DSCT_AMT" IS NOT NULL .
PPCAPR.MUP_T NN_MT_MTC C ENABLED 17:40:07 01 /30/08 "MUP_TYP_CD" IS NOT NULL .
PPCAPR.MUP_T NN_MT_MXSI C ENABLED 17:40:07 01 /30/08 "MUP_XOS_STY_IND" IS NOT NULL .
PPCAPR.MUP_T NN_MT_DTC C ENABLED 17:40:07 01 /30/08 "DSCT_TYP_CD" IS NOT NULL .
PPCAPR.MUP_T NN_MT_MRI C ENABLED 17:40:07 01 /30/08 "MULT_RQM_IND" IS NOT NUL L .
PPCAPR.MUP_T NN_MT_CC C ENABLED 17:40:07 01 /30/08 "CHNL_CD" IS NOT NULL .
PPCAPR.MUP_T NN_MT_SUD C ENABLED 17:40:07 01 /30/08 "SRC_UPDT_DTTM" IS NOT NU LL .
PPCAPR.MUP_T NN_MT_BC C ENABLED 17:40:07 01 /30/08 "BRD_CD" IS NOT NULL .
PPCAPR.MUP_T NN_MT_LUUI C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.MUP_T NN_MT_LUD C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.MUP_T NN_MT_CUI C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.MUP_T NN_MT_QQ C ENABLED 17:40:07 01 /30/08 "QUAL_QTY" IS NOT NULL .
PPCAPR.MUP_T NN_MT_GI C ENABLED 17:40:07 01 /30/08 "GRP_ID" IS NOT NULL .
PPCAPR.MUP_T NN_MT_MCI C ENABLED 17:40:07 01 /30/08 "MDSE_CO_ID" IS NOT NULL .
PPCAPR.MUP_T PK_MT_MI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.MUP_T FK_MT_MTI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_MUP_TYP_T
PPCAPR.MUP_T FK_MT_BC_CHC R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_BCA_BC_CHC
PPCAPR.MUP_T NN_MT_EED C ENABLED 17:40:07 01 /30/08 "EFF_END_DT" IS NOT NULL .
PPCAPR.MUP_TYP_T SYS_C0012140 C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.MUP_TYP_T SYS_C0012139 C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.MUP_TYP_T SYS_C0012138 C ENABLED 17:40:07 01 /30/08 "MUP_TYP_DESC" IS NOT NUL L .
PPCAPR.MUP_TYP_T SYS_C0012137 C ENABLED 17:40:07 01 /30/08 "MUP_TYP_CD" IS NOT NULL .
PPCAPR.MUP_TYP_T PK_MUP_TYP_T P ENABLED 17:43:03 01 /30/08   .
PPCAPR.MUP_TYP_T SYS_C0012142 C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.MUP_TYP_T SYS_C0012141 C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.PMOTN_CATG_T NN_PCT_LUUI C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.PMOTN_CATG_T NN_PC_CUI C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.PMOTN_CATG_T NN_PC_PCN C ENABLED 17:40:07 01 /30/08 "PMOTN_CATG_NM" IS NOT NU LL .
PPCAPR.PMOTN_CATG_T PK_PC_PCC P ENABLED 17:43:03 01 /30/08   .
PPCAPR.PMOTN_CATG_T NN_PC_PCD C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.PMOTN_CATG_T NN_PCT_LUD C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.PMOTN_CD_ASSN_T PK_PCA_PI_PC1 P ENABLED 17:43:03 01 /30/08   .
PPCAPR.PMOTN_CD_ASSN_T SYS_C0012307 C ENABLED 17:40:08 01 /30/08 "PMOTN_ID" IS NOT NULL .
PPCAPR.PMOTN_CD_ASSN_T SYS_C0012309 C ENABLED 17:40:08 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.PMOTN_CD_ASSN_T SYS_C0012308 C ENABLED 17:40:08 01 /30/08 "PMOTN_CD" IS NOT NULL .
PPCAPR.PMOTN_CD_SEQ_T NN_PCST_PCSN C ENABLED 17:40:07 01 /30/08 "PMOTN_CD_SEQ_NBR" IS NOT NULL .
PPCAPR.PMOTN_CD_TYP_T NN_PCTT_CD C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.PMOTN_CD_TYP_T NN_PCTT_LUD C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.PMOTN_CD_TYP_T NN_PCTT_CUI C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.PMOTN_CD_TYP_T NN_PCTT_LUUI C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.PMOTN_CD_TYP_T PK_PCTT_PCTI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.PMOTN_CD_TYP_T NN_PCTT_PCTN C ENABLED 17:40:07 01 /30/08 "PMOTN_CD_TYP_NM" IS NOT NULL .
PPCAPR.PMOTN_CHG_HIST_T NN_PCHT_LUD C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.PMOTN_CHG_HIST_T NN_PCH_CD C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.PMOTN_CHG_HIST_T NN_PCH_PHTC C ENABLED 17:40:07 01 /30/08 "PMOTN_HIST_TYP_CD" IS NO T NULL .
PPCAPR.PMOTN_CHG_HIST_T NN_PCH_CUI C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.PMOTN_CHG_HIST_T NN_PCH_PI C ENABLED 17:40:07 01 /30/08 "PMOTN_ID" IS NOT NULL .
PPCAPR.PMOTN_CHG_HIST_T NN_PCHT_LUUI C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.PMOTN_CHG_HIST_T NN_PCHT_LUUN C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_NM" IS NOT NULL .
PPCAPR.PMOTN_CHG_HIST_T FK_PCH_PHTC R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_PHT_PHTC
PPCAPR.PMOTN_CHG_HIST_T FK_PCH_PI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_PT_PI
PPCAPR.PMOTN_CHG_HIST_T PK_PCH_PCHI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.PMOTN_HIST_TYP_T PK_PHT_PHTC P ENABLED 17:43:03 01 /30/08   .
PPCAPR.PMOTN_HIST_TYP_T NN_PHTT_LUUI C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.PMOTN_HIST_TYP_T NN_PHT_CD C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.PMOTN_HIST_TYP_T NN_PHTT_LUD C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.PMOTN_HIST_TYP_T NN_PHT_CUI C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.PMOTN_NTE_T PK_PN_PNI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.PMOTN_NTE_T FK_PN_PI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_PT_PI
PPCAPR.PMOTN_NTE_T NN_PNT_LUUI C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.PMOTN_NTE_T NN_PN_UN C ENABLED 17:40:07 01 /30/08 "USER_NM" IS NOT NULL .
PPCAPR.PMOTN_NTE_T NN_PN_PI C ENABLED 17:40:07 01 /30/08 "PMOTN_ID" IS NOT NULL .
PPCAPR.PMOTN_NTE_T NN_PNT_CUI C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.PMOTN_NTE_T NN_PNT_CD C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.PMOTN_NTE_T NN_PNT_LUD C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.PMOTN_RUL_TIER_T NN_PRTT_CST C ENABLED 17:40:07 01 /30/08 "CND_SUM_TXT" IS NOT NULL .
PPCAPR.PMOTN_RUL_TIER_T NN_PRT_SD C ENABLED 17:40:07 01 /30/08 "SHRT_DESC" IS NOT NULL .
PPCAPR.PMOTN_RUL_TIER_T NN_PRTT_PI1 C ENABLED 17:40:07 01 /30/08 "PMOTN_ID" IS NOT NULL .
PPCAPR.PMOTN_RUL_TIER_T PK_PRT_PRTI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.PMOTN_RUL_TIER_T FK_PRT_PI R ENABLED 17:43:06 01 /30/08   PPCAPR.PK_PT_PI
PPCAPR.PMOTN_RUL_TIER_T SYS_C0012174 C ENABLED 17:40:07 01 /30/08 "RUL_TIER_ID" IS NOT NULL .
PPCAPR.PMOTN_RUL_TIER_T NN_PRTT_LUUI C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.PMOTN_RUL_TIER_T NN_PRTT_LUD C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.PMOTN_RUL_TIER_T NN_PRTT_CUI C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.PMOTN_RUL_TIER_T NN_PRTT_CD C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.PMOTN_RUL_TIER_T FK_PRTT_RTI R ENABLED 17:43:06 01 /30/08   PPCAPR.PK_RTT_RTI
PPCAPR.PMOTN_SPSR_T SYS_C0012184 C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.PMOTN_SPSR_T SYS_C0012183 C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.PMOTN_SPSR_T FK_PST_PI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_PT_PI
PPCAPR.PMOTN_SPSR_T FK_PST_SI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_ST_SI
PPCAPR.PMOTN_SPSR_T PK_PST_PI_SI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.PMOTN_SPSR_T SYS_C0012179 C ENABLED 17:40:07 01 /30/08 "SPSR_ID" IS NOT NULL .
PPCAPR.PMOTN_SPSR_T SYS_C0012180 C ENABLED 17:40:07 01 /30/08 "PMOTN_ID" IS NOT NULL .
PPCAPR.PMOTN_SPSR_T SYS_C0012181 C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.PMOTN_SPSR_T SYS_C0012182 C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.PMOTN_STAT_TYP_T NN_PST_CD C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.PMOTN_STAT_TYP_T NN_PSTT_LUD C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.PMOTN_STAT_TYP_T PK_PST_PSI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.PMOTN_STAT_TYP_T NN_PSTT_LUUI C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.PMOTN_STAT_TYP_T NN_PST_CUI C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.PMOTN_SUB_CATG_T NN_PSCT_PCC C ENABLED 17:40:07 01 /30/08 "PMOTN_CATG_CD" IS NOT NU LL .
PPCAPR.PMOTN_SUB_CATG_T SYS_C0012579 R DISABLED 17:43:07 01 /30/08   PPCAPR.PK_PC_PCC
PPCAPR.PMOTN_SUB_CATG_T PK_PSCT_PCC_PSC P ENABLED 17:43:03 01 /30/08   .
PPCAPR.PMOTN_SUB_CATG_T NN_PSCT_PSC C ENABLED 17:40:07 01 /30/08 "PMOTN_SCATG_CD" IS NOT N ULL .
PPCAPR.PMOTN_SUB_CATG_T NN_PSCT_LUUI C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.PMOTN_SUB_CATG_T NN_PSCT_CD C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.PMOTN_SUB_CATG_T NN_PSCT_LUD C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.PMOTN_SUB_CATG_T NN_PSCT_CUI C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.PMOTN_SUB_CATG_T NN_PSCT_PSN C ENABLED 17:40:07 01 /30/08 "PMOTN_SCATG_NM" IS NOT N ULL .
PPCAPR.PMOTN_T NN_PT_IMN C ENABLED 17:40:07 01 /30/08 "INTR_MKT_NM" IS NOT NULL .
PPCAPR.PMOTN_T NN_PT_PFI C ENABLED 17:40:07 01 /30/08 "PRO_FORMA_IND" IS NOT NU LL .
PPCAPR.PMOTN_T NN_PT_PCTI C ENABLED 17:40:07 01 /30/08 "PMOTN_CD_TYP_ID" IS NOT NULL .
PPCAPR.PMOTN_T NN_PT_PSI C ENABLED 17:40:07 01 /30/08 "PMOTN_STAT_ID" IS NOT NU LL .
PPCAPR.PMOTN_T NN_PT_CPI C ENABLED 17:40:07 01 /30/08 "COR_PMOTN_IND" IS NOT NU LL .
PPCAPR.PMOTN_T NN_PT_RSI C DISABLED 17:40:07 01 /30/08 "RUL_SET_ID" IS NOT NULL .
PPCAPR.PMOTN_T NN_PT_LUUI C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.PMOTN_T NN_PT_AI C ENABLED 17:40:07 01 /30/08 "ACTV_IND" IS NOT NULL .
PPCAPR.PMOTN_T NN_PT_PCC C ENABLED 17:40:07 01 /30/08 "PMOTN_CATG_CD" IS NOT NU LL .
PPCAPR.PMOTN_T NN_PT_PATC C ENABLED 17:40:07 01 /30/08 "PRC_APPL_TYP_CD" IS NOT NULL .
PPCAPR.PMOTN_T NN_PT_CUI C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.PMOTN_T NN_PT_LUD C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.PMOTN_T NN_PT_PMN C ENABLED 17:40:07 01 /30/08 "PMOTN_MKT_NM" IS NOT NUL L .
PPCAPR.PMOTN_T NN_PT_PCRI C ENABLED 17:40:07 01 /30/08 "PMOTN_CD_RQM_IND" IS NOT NULL .
PPCAPR.PMOTN_T NN_PT_CD C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.PMOTN_T NN_PT_PSC C ENABLED 17:40:07 01 /30/08 "PMOTN_SCATG_CD" IS NOT N ULL .
PPCAPR.PMOTN_T NN_PT_PED C ENABLED 17:40:07 01 /30/08 "PMOTN_END_DTTM" IS NOT N ULL .
PPCAPR.PMOTN_T NN_PT_PSD C ENABLED 17:40:07 01 /30/08 "PMOTN_STRT_DTTM" IS NOT NULL .
PPCAPR.PMOTN_T PK_PT_PI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.PMOTN_T FK_PMT_PATC R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_PAT_PATC
PPCAPR.PMOTN_T FK_PMT_RSI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_RS_RSI
PPCAPR.PMOTN_T FK_PT_ALC R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_ALT_ALC
PPCAPR.PMOTN_T FK_PMT_AI R DISABLED 17:43:07 01 /30/08   PPCAPR.PK_AT_AI
PPCAPR.PMOTN_T FK_PMT_PCTI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_PCTT_PCTI
PPCAPR.PMOTN_T FK_PMT_PSI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_PST_PSI
PPCAPR.PMOTN_T SYS_C0012586 R DISABLED 17:43:07 01 /30/08   PPCAPR.PK_PSCT_PCC_PSC
PPCAPR.PMOTN_TAB_T PK_PTT_PI_TN P ENABLED 17:43:03 01 /30/08   .
PPCAPR.PMOTN_TAB_T SYS_C0012220 C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.PMOTN_TAB_T SYS_C0012218 C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.PMOTN_TAB_T FK_PTT_PI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_PT_PI
PPCAPR.PMOTN_TAB_T SYS_C0012214 C ENABLED 17:40:07 01 /30/08 "PMOTN_ID" IS NOT NULL .
PPCAPR.PMOTN_TAB_T SYS_C0012217 C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.PMOTN_TAB_T SYS_C0012216 C ENABLED 17:40:07 01 /30/08 "TAB_CMPL_IND" IS NOT NUL L .
PPCAPR.PMOTN_TAB_T SYS_C0012215 C ENABLED 17:40:07 01 /30/08 "TAB_NBR" IS NOT NULL .
PPCAPR.PMOTN_TAB_T SYS_C0012219 C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.PRC_APPL_TYP_T NN_PAT_CD C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.PRC_APPL_TYP_T NN_PAT_CUI C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.PRC_APPL_TYP_T NN_PATT_LUUI C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.PRC_APPL_TYP_T PK_PAT_PATC P ENABLED 17:43:03 01 /30/08   .
PPCAPR.PRC_APPL_TYP_T NN_PATT_LUD C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.PRC_T NN_PRCT_LUUI C ENABLED 17:40:08 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.PRC_T NN_PRCT_CUI C ENABLED 17:40:08 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.PRC_T NN_PRCT_CC C ENABLED 17:40:08 01 /30/08 "CNCY_CD" IS NOT NULL .
PPCAPR.PRC_T NN_PRCT_PTI C ENABLED 17:40:08 01 /30/08 "PRC_TYP_ID" IS NOT NULL .
PPCAPR.PRC_T NN_PRCT_CII C ENABLED 17:40:08 01 /30/08 "CTLG_ITM_ID" IS NOT NULL .
PPCAPR.PRC_T NN_PRCT_CD C ENABLED 17:40:08 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.PRC_T NN_PRCT_PSD C ENABLED 17:40:08 01 /30/08 "PRC_STRT_DT" IS NOT NULL .
PPCAPR.PRC_T SYS_C0012328 C ENABLED 17:40:08 01 /30/08 "ITM_PRC_ID" IS NOT NULL .
PPCAPR.PRC_T PK_PRCT_IPI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.PRC_T NN_PRCT_LUD C ENABLED 17:40:08 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.PRC_TYP_T PL_PTT_PTI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.PRC_TYP_T NN_PTT_LUD C ENABLED 17:40:08 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.PRC_TYP_T NN_PTT_CUI C ENABLED 17:40:08 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.PRC_TYP_T NN_PTT_LUUI C ENABLED 17:40:08 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.PRC_TYP_T NN_PTT_CD C ENABLED 17:40:08 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.PRC_TYP_T NN_PTT_PTI C ENABLED 17:40:08 01 /30/08 "PRC_TYP_ID" IS NOT NULL .
PPCAPR.RUL_SET_STAT_T SYS_C0012230 C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.RUL_SET_STAT_T SYS_C0012225 C ENABLED 17:40:07 01 /30/08 "RUL_SET_STAT_ID" IS NOT NULL .
PPCAPR.RUL_SET_STAT_T SYS_C0012226 C ENABLED 17:40:07 01 /30/08 "RUL_SET_STAT_NM" IS NOT NULL .
PPCAPR.RUL_SET_STAT_T SYS_C0012227 C ENABLED 17:40:07 01 /30/08 "RUL_SET_STAT_DESC" IS NO T NULL .
PPCAPR.RUL_SET_STAT_T PK_RSST_RSSI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.RUL_SET_STAT_T SYS_C0012228 C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.RUL_SET_STAT_T SYS_C0012229 C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.RUL_SET_STAT_T SYS_C0012231 C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.RUL_SET_T FK_RST_RSSI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_RSST_RSSI
PPCAPR.RUL_SET_T PK_RS_RSI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.RUL_SET_T NN_RS_CD C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.RUL_SET_T NN_RST_LUD C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.RUL_SET_T NN_RS_CUI C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.RUL_SET_T NN_RST_LUUI C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.RUL_T NN_RT_LUUI C ENABLED 17:40:08 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.RUL_T NN_RT_LUD C ENABLED 17:40:08 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.RUL_T NN_RT_CD C ENABLED 17:40:08 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.RUL_T PK_RT_RI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.RUL_T NN_RT_CUI C ENABLED 17:40:08 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.RUL_TIER_T FK_RT_RI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_RT_RI
PPCAPR.RUL_TIER_T NN_RTT_RSI C ENABLED 17:40:07 01 /30/08 "RUL_SET_ID" IS NOT NULL .
PPCAPR.RUL_TIER_T NN_RTT_ROSN C ENABLED 17:40:07 01 /30/08 "RUL_ORD_SEQ_NBR" IS NOT NULL .
PPCAPR.RUL_TIER_T NN_RTT_LUD C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.RUL_TIER_T NN_RTT_CUI C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.RUL_TIER_T NN_RTT_LUUI C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.RUL_TIER_T NN_RTT_RI C ENABLED 17:40:07 01 /30/08 "RUL_ID" IS NOT NULL .
PPCAPR.RUL_TIER_T SYS_C0012237 C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.RUL_TIER_T FK_RT_RSI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_RS_RSI
PPCAPR.RUL_TIER_T PK_RTT_RTI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.RUL_T_TMP SYS_C0012474 C ENABLED 17:40:08 01 /30/08 "RUL_ID" IS NOT NULL .
PPCAPR.RUL_T_TMP SYS_C0012478 C ENABLED 17:40:08 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.RUL_T_TMP SYS_C0012477 C ENABLED 17:40:08 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.RUL_T_TMP SYS_C0012476 C ENABLED 17:40:08 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.RUL_T_TMP SYS_C0012475 C ENABLED 17:40:08 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.SCHEMA_AUD_LOG_T NN_SALT_CA C ENABLED 17:40:08 01 /30/08 "CLEAN_APPL" IS NOT NULL .
PPCAPR.SCHEMA_AUD_LOG_T NN_GID_SALT_OI C ENABLED 17:40:08 01 /30/08 "OVRWRITE_IND" IS NOT NUL L .
PPCAPR.SCHEMA_AUD_LOG_T NN_GID_SALT_AD C ENABLED 17:40:08 01 /30/08 "APPL_DTTM" IS NOT NULL .
PPCAPR.SCHEMA_AUD_LOG_T NN_GID_SALT_SP C ENABLED 17:40:08 01 /30/08 "SVN_PATH" IS NOT NULL .
PPCAPR.SCHEMA_AUD_LOG_T NN_GID_SALT_RV C ENABLED 17:40:08 01 /30/08 "RLSE_VAL" IS NOT NULL .
PPCAPR.SCHEMA_AUD_LOG_T NN_GID_SALT_SFN C ENABLED 17:40:08 01 /30/08 "SVN_FIL_NM" IS NOT NULL .
PPCAPR.SCHEMA_AUD_LOG_T NN_GID_SALT_SAI C ENABLED 17:40:08 01 /30/08 "SCHEMA_AUD_ID" IS NOT NU LL .
PPCAPR.SCHEMA_AUD_LOG_T PK_GID_SALT_SAI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.SCHEMA_VER_T NN_GID_SVT_LUD C ENABLED 17:40:08 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.SCHEMA_VER_T NN_GID_SVT_AD C ENABLED 17:40:08 01 /30/08 "APPL_DTTM" IS NOT NULL .
PPCAPR.SCHEMA_VER_T NN_GID_SVT_DSN C ENABLED 17:40:08 01 /30/08 "DEPLOY_SCRIPT_NM" IS NOT NULL .
PPCAPR.SCHEMA_VER_T NN_GID_SVT_RV C ENABLED 17:40:08 01 /30/08 "RLSE_VAL" IS NOT NULL .
PPCAPR.SCHEMA_VER_T NN_SVT_CA C ENABLED 17:40:08 01 /30/08 "CLEAN_APPL" IS NOT NULL .
PPCAPR.SCHEMA_VER_T PK_GID_SVT_RV P ENABLED 17:43:03 01 /30/08   .
PPCAPR.SHP_CHRG_TIER_T SYS_C0012247 C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.SHP_CHRG_TIER_T SYS_C0012248 C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.SHP_CHRG_TIER_T SYS_C0012244 C ENABLED 17:40:07 01 /30/08 "SHP_OPT_ID" IS NOT NULL .
PPCAPR.SHP_CHRG_TIER_T SYS_C0012245 C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.SHP_CHRG_TIER_T SYS_C0012246 C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.SHP_CHRG_TIER_T FK_SCTT_BC_CC R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_BCA_BC_CHC
PPCAPR.SHP_CHRG_TIER_T PK_SCTT_SCTN_SOI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.SHP_CHRG_TIER_T SYS_C0012243 C ENABLED 17:40:07 01 /30/08 "SHP_CHRG_TIER_NBR" IS NO T NULL .
PPCAPR.SHP_CHRG_TIER_T FK_SCTT_SOI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_SOT_SOI
PPCAPR.SHP_OPT_BRD_T FK_SOBT_SOT_SOI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_BT_BC
PPCAPR.SHP_OPT_BRD_T FK_SOBT_BT_BC R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_SOT_SOI
PPCAPR.SHP_OPT_BRD_T PK_SOBT_SOBI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.SHP_OPT_BRD_T NN_SOBT_SOBI C ENABLED 17:40:07 01 /30/08 "SHP_OPT_BRD_ID" IS NOT N ULL .
PPCAPR.SHP_OPT_BRD_T NN_SOBT_BC C ENABLED 17:40:07 01 /30/08 "BRD_CD" IS NOT NULL .
PPCAPR.SHP_OPT_BRD_T NN_SOBT_SOI C ENABLED 17:40:07 01 /30/08 "SHP_OPT_ID" IS NOT NULL .
PPCAPR.SHP_OPT_BRD_T NN_SOBT_MINDDC C ENABLED 17:40:07 01 /30/08 "MIN_DLVR_DY_CNT" IS NOT NULL .
PPCAPR.SHP_OPT_BRD_T NN_SOBT_MAXDDC C ENABLED 17:40:07 01 /30/08 "MAX_DLVR_DY_CNT" IS NOT NULL .
PPCAPR.SHP_OPT_BRD_T NN_SOBT_ESD C ENABLED 17:40:07 01 /30/08 "EFF_STRT_DTTM" IS NOT NU LL .
PPCAPR.SHP_OPT_BRD_T NN_SOBT_END C ENABLED 17:40:07 01 /30/08 "EFF_END_DTTM" IS NOT NUL L .
PPCAPR.SHP_OPT_BRD_T NN_SOBT_CD C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.SHP_OPT_BRD_T NN_SOBT_LUD C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.SHP_OPT_T SYS_C0012259 C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.SHP_OPT_T PK_SOT_SOI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.SHP_OPT_T SYS_C0012262 C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.SHP_OPT_T SYS_C0012261 C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.SHP_OPT_T SYS_C0012260 C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.SHP_OPT_T FK_SOT_BC R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_STT_STI
PPCAPR.SHP_OPT_T SYS_C0012263 C ENABLED 17:40:07 01 /30/08 "SHP_TYP_ID" IS NOT NULL .
PPCAPR.SHP_OPT_T SYS_C0012258 C ENABLED 17:40:07 01 /30/08 "SHP_OPT_ID" IS NOT NULL .
PPCAPR.SHP_TYP_T PK_STT_STI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.SHP_TYP_T SYS_C0012268 C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.SHP_TYP_T SYS_C0012264 C ENABLED 17:40:07 01 /30/08 "SHP_TYP_ID" IS NOT NULL .
PPCAPR.SHP_TYP_T SYS_C0012265 C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.SHP_TYP_T SYS_C0012266 C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.SHP_TYP_T SYS_C0012267 C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.SPSR_T PK_ST_SI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.SPSR_T NN_ST_LUUI C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.SPSR_T NN_ST_CUI C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.SPSR_T NN_ST_SI C ENABLED 17:40:07 01 /30/08 "SPSR_ID" IS NOT NULL .
PPCAPR.SPSR_T NN_ST_CD C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.SPSR_T NN_ST_SN C ENABLED 17:40:07 01 /30/08 "SPSR_NM" IS NOT NULL .
PPCAPR.SPSR_T NN_ST_LUD C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.STG_73_FEED_DTL_T NN_S7FDT_KMII C ENABLED 17:40:08 01 /30/08 "KNOWN_MDSE_ITM_IND" IS N OT NULL .
PPCAPR.STG_73_FEED_DTL_T FK_S7FDT_SPFI R ENABLED 17:43:22 01 /30/08   PPCAPR.PK_SPFT_SPFI
PPCAPR.STG_73_FEED_DTL_T PK_S7FDT_SPFI_PFEN P ENABLED 17:43:03 01 /30/08   .
PPCAPR.STG_73_FEED_DTL_T NN_SPFDT_PFEN C ENABLED 17:40:08 01 /30/08 "PRC_FEED_ENT_NBR" IS NOT NULL .
PPCAPR.STG_73_FEED_DTL_T NN_SPFDT_MCI C ENABLED 17:40:08 01 /30/08 "MDSE_CO_ID" IS NOT NULL .
PPCAPR.STG_73_FEED_DTL_T NN_SPFDT_BC C ENABLED 17:40:08 01 /30/08 "BRD_CD" IS NOT NULL .
PPCAPR.STG_73_FEED_DTL_T NN_SPFDT_RI C ENABLED 17:40:08 01 /30/08 "REQ_ID" IS NOT NULL .
PPCAPR.STG_73_FEED_DTL_T NN_SPFDT_LSCC C ENABLED 17:40:08 01 /30/08 "LGCY_STY_CLR_CD" IS NOT NULL .
PPCAPR.STG_73_FEED_DTL_T NN_SPFDT_PA C ENABLED 17:40:08 01 /30/08 "PRC_AMT" IS NOT NULL .
PPCAPR.STG_73_FEED_DTL_T NN_SPFDT_ESD C ENABLED 17:40:08 01 /30/08 "EFF_STRT_DTTM" IS NOT NU LL .
PPCAPR.STG_73_FEED_DTL_T NN_SPFDT_SSI C ENABLED 17:40:08 01 /30/08 "STY_STAT_IND" IS NOT NUL L .
PPCAPR.STG_73_FEED_DTL_T NN_SPFDT_CUI C ENABLED 17:40:08 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.STG_73_FEED_DTL_T NN_SPFDT_CD C ENABLED 17:40:08 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.STG_73_FEED_DTL_T NN_SPFDT_LUUI C ENABLED 17:40:08 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.STG_73_FEED_DTL_T NN_SPFDT_LUD C ENABLED 17:40:08 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.STG_73_FEED_DTL_T NN_S7FDT_OSSI C ENABLED 17:40:08 01 /30/08 "OVRD_STY_STAT_IND" IS NO T NULL .
PPCAPR.STG_73_FEED_DTL_T NN_SPFDT_SPFI C ENABLED 17:40:08 01 /30/08 "STG_PRC_FEED_ID" IS NOT NULL .
PPCAPR.STG_92_FEED_DTL_T FK_S9FDT_SPFI R ENABLED 17:43:22 01 /30/08   PPCAPR.PK_SPFT_SPFI
PPCAPR.STG_92_FEED_DTL_T PK_S9FDT_SPFI_PFEN P ENABLED 17:43:03 01 /30/08   .
PPCAPR.STG_92_FEED_DTL_T NN_S9FDT_SPFI C ENABLED 17:40:08 01 /30/08 "STG_PRC_FEED_ID" IS NOT NULL .
PPCAPR.STG_92_FEED_DTL_T NN_S9FDT_PFEN C ENABLED 17:40:08 01 /30/08 "PRC_FEED_ENT_NBR" IS NOT NULL .
PPCAPR.STG_92_FEED_DTL_T NN_S9FDT_MCI C ENABLED 17:40:08 01 /30/08 "MDSE_CO_ID" IS NOT NULL .
PPCAPR.STG_92_FEED_DTL_T NN_S9FDT_BC C ENABLED 17:40:08 01 /30/08 "BRD_CD" IS NOT NULL .
PPCAPR.STG_92_FEED_DTL_T NN_S9FDT_RI C ENABLED 17:40:08 01 /30/08 "REQ_ID" IS NOT NULL .
PPCAPR.STG_92_FEED_DTL_T NN_S9FDT_LSCC C ENABLED 17:40:08 01 /30/08 "LGCY_STY_CLR_CD" IS NOT NULL .
PPCAPR.STG_92_FEED_DTL_T NN_S9FDT_PA C ENABLED 17:40:08 01 /30/08 "PRC_AMT" IS NOT NULL .
PPCAPR.STG_92_FEED_DTL_T NN_S9FDT_ESD C ENABLED 17:40:08 01 /30/08 "EFF_STRT_DTTM" IS NOT NU LL .
PPCAPR.STG_92_FEED_DTL_T NN_S9FDT_SSI C ENABLED 17:40:08 01 /30/08 "STY_STAT_IND" IS NOT NUL L .
PPCAPR.STG_92_FEED_DTL_T NN_S9FDT_CUI C ENABLED 17:40:08 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.STG_92_FEED_DTL_T NN_S9FDT_CD C ENABLED 17:40:08 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.STG_92_FEED_DTL_T NN_S9FDT_LUUI C ENABLED 17:40:08 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.STG_92_FEED_DTL_T NN_S9FDT_LUD C ENABLED 17:40:08 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.STG_92_FEED_DTL_T NN_S9FDT_KMII C ENABLED 17:40:08 01 /30/08 "KNOWN_MDSE_ITM_IND" IS N OT NULL .
PPCAPR.STG_92_FEED_DTL_T NN_S9FDT_EED C ENABLED 17:40:08 01 /30/08 "EFF_END_DTTM" IS NOT NUL L .
PPCAPR.STG_MUP_FEED_T SYS_C0012288 C ENABLED 17:40:07 01 /30/08 "STY_STAT_IND" IS NOT NUL L .
PPCAPR.STG_MUP_FEED_T SYS_C0012287 C ENABLED 17:40:07 01 /30/08 "MUP_IND" IS NOT NULL .
PPCAPR.STG_MUP_FEED_T SYS_C0012286 C ENABLED 17:40:07 01 /30/08 "PMOTN_IND" IS NOT NULL .
PPCAPR.STG_MUP_FEED_T SYS_C0012285 C ENABLED 17:40:07 01 /30/08 "LGCY_STY_CLR_CD" IS NOT NULL .
PPCAPR.STG_MUP_FEED_T SYS_C0012284 C ENABLED 17:40:07 01 /30/08 "LGCY_MKT_CD" IS NOT NULL .
PPCAPR.STG_MUP_FEED_T NN_SMFT_EED C ENABLED 17:40:07 01 /30/08 "EFF_END_DTTM" IS NOT NUL L .
PPCAPR.STG_MUP_FEED_T SYS_C0012282 C ENABLED 17:40:07 01 /30/08 "LGCY_STY_CD" IS NOT NULL .
PPCAPR.STG_MUP_FEED_T SYS_C0012281 C ENABLED 17:40:07 01 /30/08 "EFF_STRT_DTTM" IS NOT NU LL .
PPCAPR.STG_MUP_FEED_T SYS_C0012280 C ENABLED 17:40:07 01 /30/08 "GRP_ID" IS NOT NULL .
PPCAPR.STG_MUP_FEED_T SYS_C0012279 C ENABLED 17:40:07 01 /30/08 "DSCT_AMT" IS NOT NULL .
PPCAPR.STG_MUP_FEED_T SYS_C0012278 C ENABLED 17:40:07 01 /30/08 "QUAL_QTY" IS NOT NULL .
PPCAPR.STG_MUP_FEED_T NN_SMFT_CUI C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.STG_MUP_FEED_T SYS_C0012276 C ENABLED 17:40:07 01 /30/08 "MDSE_CO_ID" IS NOT NULL .
PPCAPR.STG_MUP_FEED_T SYS_C0012275 C ENABLED 17:40:07 01 /30/08 "BRD_CD" IS NOT NULL .
PPCAPR.STG_MUP_FEED_T FK_SMFT_MTC R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_MUP_TYP_T
PPCAPR.STG_MUP_FEED_T FK_SMFT_NRI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_MNRT_NRI
PPCAPR.STG_MUP_FEED_T NN_SMFT_KMII C ENABLED 17:40:07 01 /30/08 "KNOWN_MDSE_ITM_IND" IS N OT NULL .
PPCAPR.STG_MUP_FEED_T NN_SMFT_LUUI C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.STG_MUP_FEED_T NN_SMFT_LUD C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.STG_MUP_FEED_T NN_SMFT_CD C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.STG_MUP_FEED_T SYS_C0012290 C ENABLED 17:40:07 01 /30/08 "MULT_RQM_IND" IS NOT NUL L .
PPCAPR.STG_MUP_FEED_T SYS_C0012289 C ENABLED 17:40:07 01 /30/08 "SRC_UPDT_DTTM" IS NOT NU LL .
PPCAPR.STG_PRC_FEED_STAT_CD_T NN_SPFSCT_SC C ENABLED 17:40:08 01 /30/08 "STAT_CD" IS NOT NULL .
PPCAPR.STG_PRC_FEED_STAT_CD_T NN_SPFSCT_SN C ENABLED 17:40:08 01 /30/08 "STAT_NAME" IS NOT NULL .
PPCAPR.STG_PRC_FEED_STAT_CD_T NN_SPFSCT_LUUI C ENABLED 17:40:08 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.STG_PRC_FEED_STAT_CD_T NN_SPFSCT_CD C ENABLED 17:40:08 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.STG_PRC_FEED_STAT_CD_T NN_SPFSCT_LUD C ENABLED 17:40:08 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.STG_PRC_FEED_STAT_CD_T NN_SPFSCT_CUI C ENABLED 17:40:08 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.STG_PRC_FEED_STAT_CD_T PK_SPFSCT_SC P ENABLED 17:43:03 01 /30/08   .
PPCAPR.STG_PRC_FEED_STAT_CD_T NN_SPFSCT_SD C ENABLED 17:40:08 01 /30/08 "STAT_DESC" IS NOT NULL .
PPCAPR.STG_PRC_FEED_T PK_SPFT_SPFI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.STG_PRC_FEED_T FK_SPFT_SC R ENABLED 17:43:05 01 /30/08   PPCAPR.PK_SPFSCT_SC
PPCAPR.STG_PRC_FEED_T FK_SPFT_FTC R ENABLED 17:43:05 01 /30/08   PPCAPR.PK_SPFTT_FTC
PPCAPR.STG_PRC_FEED_T NN_SPFT_FTC C ENABLED 17:40:08 01 /30/08 "FEED_TYP_CD" IS NOT NULL .
PPCAPR.STG_PRC_FEED_T NN_SPFT_LUD C ENABLED 17:40:08 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.STG_PRC_FEED_T NN_SPFT_LUUI C ENABLED 17:40:08 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.STG_PRC_FEED_T NN_SPFT_CD C ENABLED 17:40:08 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.STG_PRC_FEED_T NN_SPFT_CUI C ENABLED 17:40:08 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.STG_PRC_FEED_T NN_SPFT_SC C ENABLED 17:40:08 01 /30/08 "STAT_CD" IS NOT NULL .
PPCAPR.STG_PRC_FEED_T NN_SPFT_SPFI C ENABLED 17:40:08 01 /30/08 "STG_PRC_FEED_ID" IS NOT NULL .
PPCAPR.STG_PRC_FEED_TYP_T NN_SPFTT_CUI C ENABLED 17:40:08 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.STG_PRC_FEED_TYP_T PK_SPFTT_FTC P ENABLED 17:43:03 01 /30/08   .
PPCAPR.STG_PRC_FEED_TYP_T NN_SPFTT_FTC C ENABLED 17:40:08 01 /30/08 "FEED_TYP_CD" IS NOT NULL .
PPCAPR.STG_PRC_FEED_TYP_T NN_SPFTT_FTD C ENABLED 17:40:08 01 /30/08 "FEED_TYP_DESC" IS NOT NU LL .
PPCAPR.STG_PRC_FEED_TYP_T NN_SPFTT_LUD C ENABLED 17:40:08 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.STG_PRC_FEED_TYP_T NN_SPFTT_LUUI C ENABLED 17:40:08 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.STG_PRC_FEED_TYP_T NN_SPFTT_CD C ENABLED 17:40:08 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.STG_SUP_FEED_T FK_SSFT_NRI R ENABLED 17:43:22 01 /30/08   PPCAPR.PK_MNRT_NRI
PPCAPR.STG_SUP_FEED_T PK_SSFT_SSFI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.STG_SUP_FEED_T NN_SSFT_MRI C ENABLED 17:40:08 01 /30/08 "MULT_RQM_IND" IS NOT NUL L .
PPCAPR.STG_SUP_FEED_T NN_SSFT_CD C ENABLED 17:40:08 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.STG_SUP_FEED_T NN_SSFT_LUD C ENABLED 17:40:08 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.STG_SUP_FEED_T NN_SSFT_LUUI C ENABLED 17:40:08 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.STG_SUP_FEED_T NN_SSFT_KMII C ENABLED 17:40:08 01 /30/08 "KNOWN_MDSE_ITM_IND" IS N OT NULL .
PPCAPR.STG_SUP_FEED_T NN_SSFT_SSFI C ENABLED 17:40:08 01 /30/08 "STG_SUP_FEED_ID" IS NOT NULL .
PPCAPR.STG_SUP_FEED_T NN_SSFT_BC C ENABLED 17:40:08 01 /30/08 "BRD_CD" IS NOT NULL .
PPCAPR.STG_SUP_FEED_T NN_SSFT_MCI C ENABLED 17:40:08 01 /30/08 "MDSE_CO_ID" IS NOT NULL .
PPCAPR.STG_SUP_FEED_T NN_SSFT_CUI C ENABLED 17:40:08 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.STG_SUP_FEED_T NN_SSFT_QQ C ENABLED 17:40:08 01 /30/08 "QUAL_QTY" IS NOT NULL .
PPCAPR.STG_SUP_FEED_T NN_SSFT_DA C ENABLED 17:40:08 01 /30/08 "DSCT_AMT" IS NOT NULL .
PPCAPR.STG_SUP_FEED_T NN_SSFT_GI C ENABLED 17:40:08 01 /30/08 "GRP_ID" IS NOT NULL .
PPCAPR.STG_SUP_FEED_T NN_SSFT_ESD C ENABLED 17:40:08 01 /30/08 "EFF_STRT_DTTM" IS NOT NU LL .
PPCAPR.STG_SUP_FEED_T NN_SSFT_LSC C ENABLED 17:40:08 01 /30/08 "LGCY_STY_CD" IS NOT NULL .
PPCAPR.STG_SUP_FEED_T NN_SSFT_EED C ENABLED 17:40:08 01 /30/08 "EFF_END_DTTM" IS NOT NUL L .
PPCAPR.STG_SUP_FEED_T NN_SSFT_LMC C ENABLED 17:40:08 01 /30/08 "LGCY_MKT_CD" IS NOT NULL .
PPCAPR.STG_SUP_FEED_T NN_SSFT_LSCC C ENABLED 17:40:08 01 /30/08 "LGCY_STY_CLR_CD" IS NOT NULL .
PPCAPR.STG_SUP_FEED_T NN_SSFT_PI C ENABLED 17:40:08 01 /30/08 "PMOTN_IND" IS NOT NULL .
PPCAPR.STG_SUP_FEED_T NN_SSFT_MI C ENABLED 17:40:08 01 /30/08 "MUP_IND" IS NOT NULL .
PPCAPR.STG_SUP_FEED_T FK_SSFT_MTC R ENABLED 17:43:22 01 /30/08   PPCAPR.PK_MUP_TYP_T
PPCAPR.STG_SUP_FEED_T NN_SSFT_SUD C ENABLED 17:40:08 01 /30/08 "SRC_UPDT_DTTM" IS NOT NU LL .
PPCAPR.STG_SUP_FEED_T NN_SSFT_SSI C ENABLED 17:40:08 01 /30/08 "STY_STAT_IND" IS NOT NUL L .
PPCAPR.USE_LMT_T FK_UL_BC R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_BT_BC
PPCAPR.USE_LMT_T FK_UL_BC_CHC R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_BCA_BC_CHC
PPCAPR.USE_LMT_T FK_UL_ULTI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_ULT_ULTI
PPCAPR.USE_LMT_T PK_UL_ULI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.USE_LMT_T NN_UL_ULI C ENABLED 17:40:07 01 /30/08 "USE_LMT_ID" IS NOT NULL .
PPCAPR.USE_LMT_T FK_ULT_CCTI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_CCTT_CCTI
PPCAPR.USE_LMT_T NN_UL_ULTI C ENABLED 17:40:07 01 /30/08 "USE_LMT_TYP_ID" IS NOT N ULL .
PPCAPR.USE_LMT_T NN_ULT_LUUI C ENABLED 17:40:07 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.USE_LMT_T NN_UL_CUI C ENABLED 17:40:07 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.USE_LMT_T NN_ULT_LUD C ENABLED 17:40:07 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.USE_LMT_T SYS_C0012298 C ENABLED 17:40:07 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.USE_LMT_T NN_ULT_PI C ENABLED 17:40:07 01 /30/08 "PMOTN_ID" IS NOT NULL .
PPCAPR.USE_LMT_T FK_UL_PI R ENABLED 17:43:07 01 /30/08   PPCAPR.PK_PT_PI
PPCAPR.USE_LMT_TYP_T NN_ULT_CD C ENABLED 17:40:08 01 /30/08 "CRT_DTTM" IS NOT NULL .
PPCAPR.USE_LMT_TYP_T NN_ULTT_LUD C ENABLED 17:40:08 01 /30/08 "LST_UPDT_DTTM" IS NOT NU LL .
PPCAPR.USE_LMT_TYP_T NN_ULT_CUI C ENABLED 17:40:08 01 /30/08 "CRT_USER_ID" IS NOT NULL .
PPCAPR.USE_LMT_TYP_T NN_ULTT_LUUI C ENABLED 17:40:08 01 /30/08 "LST_UPDT_USER_ID" IS NOT NULL .
PPCAPR.USE_LMT_TYP_T NN_ULTT_ULTN C ENABLED 17:40:08 01 /30/08 "USE_LMT_TYP_NM" IS NOT N ULL .
PPCAPR.USE_LMT_TYP_T PK_ULT_ULTI P ENABLED 17:43:03 01 /30/08   .
PPCAPR.ZIPCD_OPT_ROLLUP_T PK_ZORT_Z_NDDI P ENABLED 17:40:06 01 /30/08   .
PPCAPR.ZIPCD_OPT_ROLLUP_T NN_ZORT_Z C ENABLED 17:40:06 01 /30/08 "ZIPCD" IS NOT NULL .
PPCAPR.ZIPCD_OPT_ROLLUP_T NN_ZORT_NDDI C ENABLED 17:40:06 01 /30/08 "NXT_DY_DEL_IND" IS NOT N ULL .
PPCAPR.ZIPCD_OPT_ROLLUP_T NN_ZORT_TLD C ENABLED 17:40:06 01 /30/08 "TBL_LD_DTTM" IS NOT NULL .

709 rows selected.

++ List INDEXES on TABLES ++

Table TABLE_TYPE INDEX_NAME INDEX_TYPE FUNCIDX_ST
PPCAPR.APPL_ST_T TABLE PK_AST_ASI NORMAL  
PPCAPR.APSE_LVL_T TABLE PK_ALT_ALC NORMAL  
PPCAPR.ARCV_EV_T TABLE PK_AET_EI NORMAL  
PPCAPR.AWRD_ARBT_TYP_T TABLE PK_ABTT_AATC NORMAL  
PPCAPR.AWRD_CALC_LVL_T TABLE PK_ACL_ACLI NORMAL  
PPCAPR.AWRD_T TABLE PK_AT_AI NORMAL  
PPCAPR.AWRD_TYP_T TABLE PK_ATT_ATI NORMAL  
PPCAPR.A_B_TST_BKT_T TABLE PK_ABTBT_TBI NORMAL  
PPCAPR.A_B_TST_GRP_T TABLE SYS_C0012486 NORMAL  
PPCAPR.BRD_CHNL_ASSN_T TABLE PK_BCA_BC_CHC NORMAL  
PPCAPR.BRD_CHNL_PMOTN_ASSN_T TABLE PK_BCPA_PI_BC_CHC NORMAL  
PPCAPR.BRD_RUL_ASSN_T TABLE PK_BRAT_BC_RI NORMAL  
PPCAPR.BRD_T TABLE PK_BT_BC NORMAL  
PPCAPR.CD_REQ_STAT_TYP_T TABLE PK_CRST_CRSTI NORMAL  
PPCAPR.CD_REQ_T TABLE PK_CR_CRI NORMAL  
PPCAPR.CHNL_PMOTN_ASSN_T TABLE PK_CPAT_CC_PI NORMAL  
PPCAPR.CHNL_T TABLE PK_CT_CHC NORMAL  
PPCAPR.CMPL_PRC_T TABLE PK_CPT_PPI NORMAL  
PPCAPR.CMPL_PRC_T TABLE INDX_CPT_CII NORMAL  
PPCAPR.CMPL_PRC_T TABLE FK_CPT_LPI NORMAL  
PPCAPR.CMPL_PRC_T TABLE FK_CPT_PTI NORMAL  
PPCAPR.CMPL_PRC_T TABLE FK_CPT_CC NORMAL  
PPCAPR.CMPL_PRC_T TABLE INDX_CPT_CC_CII_PED_PSD_PTI NORMAL  
PPCAPR.CNCY_T TABLE PK_CNCYT_CC NORMAL  
PPCAPR.CND_BRD_T TABLE PK_CBT_CBI NORMAL  
PPCAPR.CND_STY_CLR_T TABLE INDX_CSCT_CBI NORMAL  
PPCAPR.CND_STY_CLR_T TABLE PK_CSCT_SCBI_BC_CBI NORMAL  
PPCAPR.CND_T TABLE PK_CT_CI NORMAL  
PPCAPR.CND_TYP_T TABLE PK_CTT_CTI NORMAL  
PPCAPR.CR_CRD_TYP_T TABLE PK_CCTT_CCTI NORMAL  
PPCAPR.CTLG_ITM_TYP_T TABLE PK_CITT_CITI NORMAL  
PPCAPR.DSCT_TYP_T TABLE PK_DT_DTC NORMAL  
PPCAPR.EV_T TABLE PK_ET_EI NORMAL  
PPCAPR.EXP_CATG_T TABLE PK_ECT_PRI NORMAL  
PPCAPR.FLAT_PRC_T TABLE PK_FPT_FPI NORMAL  
PPCAPR.FLAT_PRC_T TABLE INDX_FPT_PSD_PED_PTI NORMAL  
PPCAPR.FLAT_PRC_T TABLE FK_FPT_LPI NORMAL  
PPCAPR.FLAT_PRC_T TABLE FK_FPT_PTI NORMAL  
PPCAPR.FLAT_PRC_T TABLE FK_FPT_CC NORMAL  
PPCAPR.LST_PRC_T TABLE PK_LPT_LPI NORMAL  
PPCAPR.MPP_LIST_PRD_T TABLE NU_MLPT_MLI NORMAL  
PPCAPR.MPP_LIST_PRD_T TABLE PK_MLPT_BI_MLI NORMAL  
PPCAPR.MPP_LIST_T TABLE NU_MLT_ESD_EED_BD NORMAL  
PPCAPR.MPP_LIST_T TABLE PK_MLT_MLI NORMAL  
PPCAPR.MPP_PRD_MSG_T TABLE NU_MPMT_BI_MPTI NORMAL  
PPCAPR.MPP_PRD_MSG_T TABLE NU_MPMT_IDX NORMAL  
PPCAPR.MPP_PRD_MSG_T TABLE PK_MPMT_MPMI NORMAL  
PPCAPR.MPP_PRD_MSG_TYP_T TABLE PK_MPMTT_MPMTI NORMAL  
PPCAPR.MPP_TYP_T TABLE PK_MTT_MTI NORMAL  
PPCAPR.MSG_PRTY_TYP_T TABLE NU_MPTT_MPTI NORMAL  
PPCAPR.MUP_ID_MAP_T TABLE PK_MIMT_MI NORMAL  
PPCAPR.MUP_ID_MAP_T TABLE UK_MIMT_GI_BC_MCI_EST_EET NORMAL  
PPCAPR.MUP_NACTV_RSN_T TABLE PK_MNRT_NRI NORMAL  
PPCAPR.MUP_STY_CLR_T TABLE PK_MSCT_MI_MSCI NORMAL  
PPCAPR.MUP_STY_CLR_T TABLE NU_MSCT_MI NORMAL  
PPCAPR.MUP_STY_CLR_T TABLE NU_MSCT_LSC_LSCC_LMC NORMAL  
PPCAPR.MUP_T TABLE PK_MT_MI NORMAL  
PPCAPR.MUP_TYP_T TABLE PK_MUP_TYP_T NORMAL  
PPCAPR.PMOTN_CATG_T TABLE PK_PC_PCC NORMAL  
PPCAPR.PMOTN_CD_ASSN_T TABLE PK_PCA_PI_PC1 NORMAL  
PPCAPR.PMOTN_CD_ASSN_T TABLE PMOTN_CD_ASSN_T_IDX1 NORMAL  
PPCAPR.PMOTN_CD_ASSN_T TABLE IDX_PCA_PI1 NORMAL  
PPCAPR.PMOTN_CD_TYP_T TABLE PK_PCTT_PCTI NORMAL  
PPCAPR.PMOTN_CHG_HIST_T TABLE PK_PCH_PCHI NORMAL  
PPCAPR.PMOTN_HIST_TYP_T TABLE PK_PHT_PHTC NORMAL  
PPCAPR.PMOTN_NTE_T TABLE PK_PN_PNI NORMAL  
PPCAPR.PMOTN_RUL_TIER_T TABLE PK_PRT_PRTI NORMAL  
PPCAPR.PMOTN_SPSR_T TABLE PK_PST_PI_SI NORMAL  
PPCAPR.PMOTN_STAT_TYP_T TABLE PK_PST_PSI NORMAL  
PPCAPR.PMOTN_SUB_CATG_T TABLE PK_PSCT_PCC_PSC NORMAL  
PPCAPR.PMOTN_T TABLE PK_PT_PI NORMAL  
PPCAPR.PMOTN_TAB_T TABLE PK_PTT_PI_TN NORMAL  
PPCAPR.PRC_APPL_TYP_T TABLE PK_PAT_PATC NORMAL  
PPCAPR.PRC_T TABLE UK_PRCT_CC_CII_PED_PSD_PTI NORMAL  
PPCAPR.PRC_T TABLE IDX_PRCT_PTI NORMAL  
PPCAPR.PRC_T TABLE PK_PRCT_IPI NORMAL  
PPCAPR.PRC_T TABLE IDX_PRCT_CII NORMAL  
PPCAPR.PRC_T TABLE IDX_PRCT_CII_PTI NORMAL  
PPCAPR.PRC_TYP_T TABLE PK_PTT_PTI NORMAL  
PPCAPR.RUL_SET_STAT_T TABLE PK_RSST_RSSI NORMAL  
PPCAPR.RUL_SET_T TABLE PK_RS_RSI NORMAL  
PPCAPR.RUL_T TABLE PK_RT_RI NORMAL  
PPCAPR.RUL_T TABLE SYS_IL0000061903C00009$$ LOB  
PPCAPR.RUL_TIER_T TABLE PK_RTT_RTI NORMAL  
PPCAPR.RUL_T_TMP TABLE SYS_IL0000061906C00009$$ LOB  
PPCAPR.SCHEMA_AUD_LOG_T TABLE PK_GID_SALT_SAI NORMAL  
PPCAPR.SCHEMA_VER_T TABLE PK_GID_SVT_RV NORMAL  
PPCAPR.SHP_CHRG_TIER_T TABLE PK_SCTT_SCTN_SOI NORMAL  
PPCAPR.SHP_OPT_BRD_T TABLE PK_SOBT_SOBI NORMAL  
PPCAPR.SHP_OPT_T TABLE PK_SOT_SOI NORMAL  
PPCAPR.SHP_OPT_T TABLE UK_SOT_SON NORMAL  
PPCAPR.SHP_TYP_T TABLE PK_STT_STI NORMAL  
PPCAPR.SHP_TYP_T TABLE UK_SOT_SONN NORMAL  
PPCAPR.SPSR_T TABLE PK_ST_SI NORMAL  
PPCAPR.STATTAB TABLE STATTAB NORMAL  
PPCAPR.STG_73_FEED_DTL_T TABLE PK_S7FDT_SPFI_PFEN NORMAL  
PPCAPR.STG_73_FEED_DTL_T TABLE IDX_S7FDT_F_KMII FUNCTION-B ASED NORMA L ENABLED
PPCAPR.STG_92_FEED_DTL_T TABLE IDX_S9FDT_F_KMII FUNCTION-B ASED NORMA L ENABLED
PPCAPR.STG_92_FEED_DTL_T TABLE PK_S9FDT_SPFI_PFEN NORMAL  
PPCAPR.STG_MUP_FEED_T TABLE IDX_SMFT_F_KMII FUNCTION-B ASED NORMA L ENABLED
PPCAPR.STG_PRC_FEED_STAT_CD_T TABLE PK_SPFSCT_SC NORMAL  
PPCAPR.STG_PRC_FEED_T TABLE PK_SPFT_SPFI NORMAL  
PPCAPR.STG_PRC_FEED_TYP_T TABLE PK_SPFTT_FTC NORMAL  
PPCAPR.STG_SUP_FEED_T TABLE PK_SSFT_SSFI NORMAL  
PPCAPR.STG_SUP_FEED_T TABLE IDX_SFFT_F_KMII FUNCTION-B ASED NORMA L ENABLED
PPCAPR.USE_LMT_T TABLE PK_UL_ULI NORMAL  
PPCAPR.USE_LMT_TYP_T TABLE PK_ULT_ULTI NORMAL  
PPCAPR.ZIPCD_OPT_ROLLUP_T TABLE PK_ZORT_Z_NDDI IOT - TOP  

108 rows selected.


++ List UNSUPPORTED TABLES IN STREAMS

Owner Table
Name 		REASON AUT
EXFSYS EXF$DEFIDXPARAM column with user-defined type NO
EXFSYS EXF$ESETIDXPARAM column with user-defined type NO
EXFSYS EXF$PREDATTRMAP column with user-defined type NO
EXFSYS RLM$EQUALSPEC column with user-defined type NO
EXFSYS RLM$INCRRRSCHACT column with user-defined type NO
EXFSYS RLM$SCHACTLIST column with user-defined type NO
MDSYS SDO_COORD_OP_PARAM_VALS column with user-defined type NO
MDSYS SDO_COORD_REF_SYS column with user-defined type NO
MDSYS SDO_CS_SRS column with user-defined type NO
MDSYS SDO_GEOM_METADATA_TABLE column with user-defined type NO
MDSYS SDO_GEOR_SYSDATA_TABLE column with user-defined type NO
MDSYS SDO_INDEX_METADATA_TABLE column with user-defined type NO
MDSYS SDO_STYLES_TABLE column with user-defined type NO
MDSYS SDO_TOPO_METADATA_TABLE column with user-defined type NO
STRMADMIN AQ$_PPCAPR_QUEUE_TABLE_C AQ queue table NO
STRMADMIN AQ$_PPCAPR_QUEUE_TABLE_D column with user-defined type NO
STRMADMIN AQ$_PPCAPR_QUEUE_TABLE_G column with user-defined type NO
STRMADMIN AQ$_PPCAPR_QUEUE_TABLE_H unsupported column exists NO
STRMADMIN AQ$_PPCAPR_QUEUE_TABLE_I unsupported column exists NO
STRMADMIN AQ$_PPCAPR_QUEUE_TABLE_P column with user-defined type NO
STRMADMIN AQ$_PPCAPR_QUEUE_TABLE_S AQ queue table NO
STRMADMIN AQ$_PPCAPR_QUEUE_TABLE_T AQ queue table NO
STRMADMIN PPCAPR_QUEUE_TABLE column with user-defined type NO
SYSMAN AQ$_MGMT_NOTIFY_QTABLE_G column with user-defined type NO
SYSMAN AQ$_MGMT_NOTIFY_QTABLE_H unsupported column exists NO
SYSMAN AQ$_MGMT_NOTIFY_QTABLE_I unsupported column exists NO
SYSMAN AQ$_MGMT_NOTIFY_QTABLE_S AQ queue table NO
SYSMAN AQ$_MGMT_NOTIFY_QTABLE_T AQ queue table NO
SYSMAN MGMT_BLACKOUT_SCHEDULE column with user-defined type NO
SYSMAN MGMT_DELTA_COMP_SUMMARIES column with user-defined type NO
SYSMAN MGMT_DELTA_SUMMARY_ERRORS column with user-defined type NO
SYSMAN MGMT_JOB_CRED_PARAMS column with user-defined type NO
SYSMAN MGMT_JOB_PARAMETER column with user-defined type NO
SYSMAN MGMT_JOB_PARAM_SOURCE column with user-defined type NO
SYSMAN MGMT_JOB_PROP_PARAMS column with user-defined type NO
SYSMAN MGMT_JOB_SCHEDULE column with user-defined type NO
SYSMAN MGMT_JOB_SEC_INFO column with user-defined type NO
SYSMAN MGMT_JOB_SQL_PARAMS column with user-defined type NO
SYSMAN MGMT_JOB_STEP_PARAMS column with user-defined type NO
SYSMAN MGMT_JOB_SUBST_PARAMS column with user-defined type NO
SYSMAN MGMT_JOB_USER_PARAMS column with user-defined type NO
SYSMAN MGMT_JOB_VALUE_PARAMS column with user-defined type NO
SYSMAN MGMT_NOTIFY_QTABLE column with user-defined type NO
SYSMAN PARAM_VALUES_TAB column with user-defined type NO
WMSYS AQ$_WM$EVENT_QUEUE_TABLE_G column with user-defined type NO
WMSYS AQ$_WM$EVENT_QUEUE_TABLE_H unsupported column exists NO
WMSYS AQ$_WM$EVENT_QUEUE_TABLE_I unsupported column exists NO
WMSYS AQ$_WM$EVENT_QUEUE_TABLE_S AQ queue table NO
WMSYS AQ$_WM$EVENT_QUEUE_TABLE_T AQ queue table NO
WMSYS WM$EVENT_AUX_PARAMS_NT column with user-defined type NO
WMSYS WM$EVENT_QUEUE_TABLE column with user-defined type NO
WMSYS WM$VERSIONED_TABLES column with user-defined type NO
WMSYS WM$VERSIONED_TABLES_UNDO_CODE column with user-defined type NO
XDB XDB$ALL_MODEL column with user-defined type NO
XDB XDB$ANY column with user-defined type NO
XDB XDB$ANYATTR column with user-defined type NO
XDB XDB$ATTRGROUP_DEF column with user-defined type NO
XDB XDB$ATTRGROUP_REF column with user-defined type NO
XDB XDB$ATTRIBUTE column with user-defined type NO
XDB XDB$CHOICE_MODEL column with user-defined type NO
XDB XDB$COLUMN_INFO column with user-defined type NO
XDB XDB$COMPLEX_TYPE column with user-defined type NO
XDB XDB$ELEMENT column with user-defined type NO
XDB XDB$GROUP_DEF column with user-defined type NO
XDB XDB$GROUP_REF column with user-defined type NO
XDB XDB$H_LINK column with user-defined type NO
XDB XDB$NLOCKS column with user-defined type NO
XDB XDB$RESOURCE column with user-defined type NO
XDB XDB$ROOT_INFO unsupported column exists NO
XDB XDB$SCHEMA column with user-defined type NO
XDB XDB$SEQUENCE_MODEL column with user-defined type NO
XDB XDB$SIMPLE_TYPE column with user-defined type NO

72 rows selected.


++ STREAMS DICTIONARY INFORMATION ++
Capture processes defined on system

Queue
Name 		Capture
Name 		Capture
Number 		Positive
Rule Set 		Negative
Rule Set
STRMADMIN.PPCAPR_QUEUE PPCAPR_CAPTURE 1 STRMADMIN.RULESET$_14 .


Apply processes defined on system

no rows selected

Propagations defined on system

Queue
Name 		Destination Positive
Rule Set 		Negative
Rule Set
STRMADMIN.PPCAPR_QUEUE STRMADMIN.PPCAPR_QUEUE@GIDQSTD1.GAP .COM STRMADMIN.RULESET$_20 .


Streams rules defined on system

Streams Name Streams Type Number of
Rules
PPCAPR_CAPTURE 1 2
PPCAPR_PROPAGATE 2 2


++
++ LOGMINER DATABASE MAP ++
Databases with information in logminer tables

Global
Name 		Logminer
Identifier 		FLAGS SRC
GIDQUEST.GAP.COM 100   UID$
GIDQUEST.GAP.COM 101   MAP

Logminer
Identifier 		SESSION#
100 1

SESSION# CLIENT# SESSION_NAME DB_ID ResetLogs
Change Number 		SESSION_ATTR SESSION_ATTR_VERBOSE Start
SCN 		END_SCN SPILL_SCN SPILL_TIME OLDEST_SCN RESUME_SCN GLOBAL_DB_NAME RESET_TIMESTAMP BRANCH_SCN Version SPARE1 SPARE2 SPARE3 SPARE4 SPARE5 SPARE6 SPARE7 SPARE8
1 0 PPCAPR_CAPTURE 2602618207 456954 1067451088   9018354 0 0   0 0 GIDQUEST.GAP.COM 626984674 0 10.2.0.3.0                


++ LOGMINER CACHE OBJECTS ++
Objects of interest to Streams from each source database

Logminer
Identifier 		Number of
Interesting
DB Objects
100 379
101 91


Intcol Verification

no rows selected

++ Queue Memory and Flow Control Values ++

ADDR INDX INST_ID FRUSED_KWQBPMT FLC1_KWQBPMT FLC2_KWQBPMT FLC3_KWQBPMT
BF3C30B0 0 1 3 5000 200 1000


++ JOBS in Database ++

JOB LOG_USER PRIV_USER SCHEMA_USER LAST_DATE LAST_SEC THIS_DATE THIS_SEC NEXT_DATE NEXT_SEC TOTAL_TIME B INTERVAL FAILURES WHAT NLS_ENV MISC_ENV INSTANCE
1 SYSMAN SYSMAN SYSMAN 21:46:32 01/30/08 21:46:32     21:47:32 01/30/08 21:47:32 3758 N sysdate + 1 / (24 * 60) 0 EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS(); NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA' NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANGUAGE='AMERICAN' NLS _SORT='BINARY' 0102000000000000 0
29 SYS SYS SYS     21:44:09 01/30/08 21:44:09 21:44:09 01/30/08 21:44:09 178 N null   next_date := sys.dbms_aqadm.aq$_propaq(job); NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA' NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANGUAGE='AMERICAN' NLS _SORT='BINARY' 0102000000000000 1
24 SYS SYS SYS     21:18:44 01/30/08 21:18:44 21:18:44 01/30/08 21:18:44 1703 N null   next_date := sys.dbms_aqadm.aq$_propaq(job); NLS_LANGUAGE='AMERICAN' NLS_TERRITORY='AMERICA' NLS_CURRENCY='$' NLS_ISO_CURRENCY='AMERICA' NLS_NUMERIC_CHARACTERS='.,' NLS_DATE_FORMAT='DD-MON-RR' NLS_DATE_LANGUAGE='AMERICAN' NLS _SORT='BINARY' 0102000000000000 1

++ DBA_QUEUE_SCHEDULES ++

SCHEMA QNAME Destination START_DATE START_TI PROPAGATION_WINDOW Archived Log Last
Timestamp 		LATENCY S PROCESS_ SESSION_ID INSTANCE LAST_RUN_DATE LAST_RUN CURRENT_START_DAT CURRENT_ NEXT_RUN_DATE NEXT_RUN TOTAL_TIME TOTAL_NUMBER TOTAL_BYTES MAX_NUMBER MAX_BYTES AVG_NUMBER AVG_SIZE AVG_TIME FAILURES LAST_ERROR_DATE LAST_ERR LAST_ERROR_MSG MESSAGE_DE ELAPSED_DEQUEUE_TIME ELAPSED_PICKLE_TIME
STRMADMIN PPCAPR_QUEUE "STRMADMIN"."PPCAPR_QUEUE"@GIDQSTD1 .GAP.COM 21:00:31 01/30/08 21:00:31     1 N J000 5490, 575 1     21:00:31 01/30/08 21:00:31     0 0 0 0 0 0 0 0 0       BUFFERED 0 0
STRMADMIN PPCAPR_QUEUE "STRMADMIN"."PPCAPR_QUEUE"@GIDQSTD1 .GAP.COM 21:00:31 01/30/08 21:00:31     1 N J000 5490, 575 1     21:00:31 01/30/08 21:00:31     0 0 0 0 0 0 0 0 0       PERSISTENT    
STRMADMIN PPCAPR_QUEUE GIDQSTD1.GAP.COM 21:02:51 01/30/08 21:02:51     60 N J001 5482, 151 1     21:02:51 01/30/08 21:02:51     0 0 0 0 0 0 0 0 0       BUFFERED 0 0
STRMADMIN PPCAPR_QUEUE GIDQSTD1.GAP.COM 21:02:51 01/30/08 21:02:51     60 N J001 5482, 151 1     21:02:51 01/30/08 21:02:51     0 0 0 0 0 0 0 0 0       PERSISTENT    



++ Agents ++

AGENT_NAME HTTP SMTP
SCHEDULER$_EVENT_AGENT NO NO
SERVER_ALERT NO NO
HAE_SUB NO NO
RCLTLDBE01_1830 NO NO
STRMADMIN NO NO
PPCAPR_CAPTURE NO NO

6 rows selected.



++ Agent Privileges ++

AGENT_NAME DB_USERNAME HTTP SMTP
PPCAPR_CAPTURE STRMADMIN NO NO
RCLTLDBE01_1830 DBSNMP NO NO
SCHEDULER$_EVENT_AGENT SYS NO NO
SERVER_ALERT SYS NO NO
STRMADMIN STRMADMIN NO NO
HAE_SUB   NO NO

6 rows selected.


++ Current Long Running Transactions ++
Current transactions open for more than 20 minutes

no rows selected

++ Streams Pool Advice ++

Stream Pool Size
Factor 		Stream Pool Size
Estimate 		Spill Count
Estimated 		Spill Time
Estimated 		UnSpill Count
Estimated 		UnSpill Time
Estimated
.16 48 467 4 0 0
.26 80 0 0 0 0
.37 112 0 0 0 0
.47 144 0 0 0 0
.58 176 0 0 0 0
.68 208 0 0 0 0
.79 240 0 0 0 0
.89 272 0 0 0 0
1.00 304 0 0 0 0
1.11 336 0 0 0 0
1.21 368 0 0 0 0
1.32 400 0 0 0 0
1.42 432 0 0 0 0
1.53 464 0 0 0 0
1.63 496 0 0 0 0
1.74 528 0 0 0 0
1.84 560 0 0 0 0
1.95 592 0 0 0 0
2.05 624 0 0 0 0
2.16 656 0 0 0 0

20 rows selected.

++ STREAMS ALERTS History (10.2.0.3+)

+++ Most recent Streams alerts(max=10) occuring within last 10 days +++

no rows selected



++ init.ora parameters ++
Key parameters are aq_tm_processes, job_queue_processes
streams_pool_size, sga_max_size, global_name, compatible

NAME Rule
Type 		VALUE
O7_DICTIONARY_ACCESSIBILITY boolean FALSE
_job_queue_interval integer 1
active_instance_count integer  
aq_tm_processes integer 0
archive_lag_target integer 0
asm_diskgroups string  
asm_diskstring string  
asm_power_limit integer 1
audit_file_dest string /opt/oracle/admin/gidquest/adu mp
audit_sys_operations boolean FALSE
audit_syslog_level string  
audit_trail string NONE
background_core_dump string partial
background_dump_dest string /opt/oracle/admin/gidquest/bdu mp
backup_tape_io_slaves boolean FALSE
bitmap_merge_area_size integer 1048576
blank_trimming boolean FALSE
buffer_pool_keep string  
buffer_pool_recycle string  
circuits integer  
cluster_database boolean FALSE
cluster_database_instances integer 1
cluster_interconnects string  
commit_point_strength integer 1
commit_write string  
compatible string 10.2.0.3.0
control_file_record_keep_time integer 7
control_files string /oradata/GIDQUEST/gidquest/con trol01.ctl, /oradata/GIDQUEST/ gidquest/control02.ctl, /orada ta/GIDQUEST/gidquest/control03 .ctl
core_dump_dest string /opt/oracle/admin/gidquest/cdu mp
cpu_count integer 8
create_bitmap_area_size integer 8388608
create_stored_outlines string  
cursor_sharing string EXACT
cursor_space_for_time boolean FALSE
db_16k_cache_size big integer 0
db_2k_cache_size big integer 0
db_32k_cache_size big integer 0
db_4k_cache_size big integer 0
db_8k_cache_size big integer 0
db_block_buffers integer 0
db_block_checking string FALSE
db_block_checksum string TRUE
db_block_size integer 8192
db_cache_advice string ON
db_cache_size big integer 0
db_create_file_dest string  
db_create_online_log_dest_1 string  
db_create_online_log_dest_2 string  
db_create_online_log_dest_3 string  
db_create_online_log_dest_4 string  
db_create_online_log_dest_5 string  
db_domain string  
db_file_multiblock_read_count integer 16
db_file_name_convert string  
db_files integer 200
db_flashback_retention_target integer 1440
db_keep_cache_size big integer 0
db_name string GIDQUEST
db_recovery_file_dest string /opt/oracle/flash_recovery_are a
db_recovery_file_dest_size big integer 2G
db_recycle_cache_size big integer 0
db_unique_name string GIDQUEST
db_writer_processes integer 1
dbwr_io_slaves integer 0
ddl_wait_for_locks boolean FALSE
dg_broker_config_file1 string /opt/oracle/product/10.2/db/db s/dr1GIDQUEST.dat
dg_broker_config_file2 string /opt/oracle/product/10.2/db/db s/dr2GIDQUEST.dat
dg_broker_start boolean FALSE
disk_asynch_io boolean TRUE
dispatchers string (PROTOCOL=TCP) (SERVICE=gidque stXDB)
distributed_lock_timeout integer 60
dml_locks integer 24220
drs_start boolean FALSE
event string  
fal_client string  
fal_server string  
fast_start_io_target integer 0
fast_start_mttr_target integer 0
fast_start_parallel_rollback string LOW
file_mapping boolean FALSE
fileio_network_adapters string  
filesystemio_options string none
fixed_date string  
gc_files_to_locks string  
gcs_server_processes integer 0
global_context_pool_size string  
global_names boolean TRUE
hash_area_size integer 131072
hi_shared_memory_address integer 0
hs_autoregister boolean TRUE
ifile file  
instance_groups string  
instance_name string GIDQUEST
instance_number integer 0
instance_type string RDBMS
java_max_sessionspace_size integer 0
java_pool_size big integer 0
java_soft_sessionspace_limit integer 0
job_queue_processes integer 4
large_pool_size big integer 0
ldap_directory_access string NONE
license_max_sessions integer 0
license_max_users integer 0
license_sessions_warning integer 0
local_listener string LISTENER_GIDQUEST
lock_name_space string  
lock_sga boolean FALSE
log_archive_config string  
log_archive_dest string  
log_archive_dest_1 string LOCATION=/oradata/GIDQUEST
log_archive_dest_10 string  
log_archive_dest_2 string  
log_archive_dest_3 string  
log_archive_dest_4 string  
log_archive_dest_5 string  
log_archive_dest_6 string  
log_archive_dest_7 string  
log_archive_dest_8 string  
log_archive_dest_9 string  
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
log_archive_dest_state_9 string enable
log_archive_duplex_dest string  
log_archive_format string %t_%s_%r.arc
log_archive_local_first boolean TRUE
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
log_buffer integer 15271936
log_checkpoint_interval integer 0
log_checkpoint_timeout integer 1800
log_checkpoints_to_alert boolean FALSE
log_file_name_convert string  
logmnr_max_persistent_sessions integer 1
max_commit_propagation_delay integer 0
max_dispatchers integer  
max_dump_file_size string UNLIMITED
max_enabled_roles integer 150
max_shared_servers integer  
nls_calendar string  
nls_comp string  
nls_currency string  
nls_date_format string  
nls_date_language string  
nls_dual_currency string  
nls_iso_currency string  
nls_language string AMERICAN
nls_length_semantics string BYTE
nls_nchar_conv_excp string FALSE
nls_numeric_characters string  
nls_sort string  
nls_territory string AMERICA
nls_time_format string  
nls_time_tz_format string  
nls_timestamp_format string  
nls_timestamp_tz_format string  
object_cache_max_size_percent integer 10
object_cache_optimal_size integer 102400
olap_page_pool_size big integer 0
open_cursors integer 300
open_links integer 4
open_links_per_instance integer 4
optimizer_dynamic_sampling integer 2
optimizer_features_enable string 10.2.0.3
optimizer_index_caching integer 0
optimizer_index_cost_adj integer 100
optimizer_mode string ALL_ROWS
optimizer_secure_view_merging boolean TRUE
os_authent_prefix string ops$
os_roles boolean FALSE
parallel_adaptive_multi_user boolean TRUE
parallel_automatic_tuning boolean FALSE
parallel_execution_message_size integer 2148
parallel_instance_group string  
parallel_max_servers integer 160
parallel_min_percent integer 0
parallel_min_servers integer 0
parallel_server boolean FALSE
parallel_server_instances integer 1
parallel_threads_per_cpu integer 2
pga_aggregate_target big integer 790M
plsql_ccflags string  
plsql_code_type string INTERPRETED
plsql_compiler_flags string INTERPRETED, NON_DEBUG
plsql_debug boolean FALSE
plsql_native_library_dir string  
plsql_native_library_subdir_count integer 0
plsql_optimize_level integer 2
plsql_v2_compatibility boolean FALSE
plsql_warnings string DISABLE:ALL
pre_page_sga boolean FALSE
processes integer 5000
query_rewrite_enabled string TRUE
query_rewrite_integrity string enforced
rdbms_server_dn string  
read_only_open_delayed boolean FALSE
recovery_parallelism integer 0
recyclebin string on
remote_archive_enable string true
remote_dependencies_mode string TIMESTAMP
remote_listener string  
remote_login_passwordfile string EXCLUSIVE
remote_os_authent boolean FALSE
remote_os_roles boolean FALSE
replication_dependency_tracking boolean TRUE
resource_limit boolean FALSE
resource_manager_plan string  
resumable_timeout integer 0
rollback_segments string  
serial_reuse string disable
service_names string GIDQUEST
session_cached_cursors integer 20
session_max_open_files integer 10
sessions integer 5505
sga_max_size big integer 2G
sga_target big integer 2G
shadow_core_dump string partial
shared_memory_address integer 0
shared_pool_reserved_size big integer 26843545
shared_pool_size big integer 512M
shared_server_sessions integer  
shared_servers integer 1
skip_unusable_indexes boolean TRUE
smtp_out_server string  
sort_area_retained_size integer 0
sort_area_size integer 65536
spfile string /opt/oracle/product/10.2/db/db s/spfileGIDQUEST.ora
sql92_security boolean FALSE
sql_trace boolean FALSE
sql_version string NATIVE
sqltune_category string DEFAULT
standby_archive_dest string ?/dbs/arch
standby_file_management string MANUAL
star_transformation_enabled string FALSE
statistics_level string TYPICAL
streams_pool_size big integer 304M
tape_asynch_io boolean TRUE
thread integer 0
timed_os_statistics integer 0
timed_statistics boolean TRUE
trace_enabled boolean TRUE
tracefile_identifier string  
transactions integer 6055
transactions_per_rollback_segment integer 5
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS1
use_indirect_data_buffers boolean FALSE
user_dump_dest string /opt/oracle/admin/gidquest/udu mp
utl_file_dir string  
workarea_size_policy string AUTO


+++ STREAMS STATISTICS +++

Session altered.

STREAMS Health Check (V3.0.20) for GIDQUEST.GAP.COM on Instance=GIDQUEST generated: 21:47:07 01/30/08

=========================================================================================

++ MESSAGES IN BUFFER QUEUE ++

Queue
Name 		STARTUP_TIME Current Number of
Outstanding
Messages
in Queue 		Current Number of
Spilled
Messages
in Queue 		Cumulative
Number
of Messages
in Queue 		Cumulative Number
of Spilled
Messages
in Queue 		Current Number of
Expired
Messages
in Queue
STRMADMIN.PPCAPR_QUEUE 20:05:04 01/30/08 0 0 0 0 0

Configuration: Queue Capture Propagation Apply Database
Analysis: History Rules Notifications Configuration Performance Wait Analysis
============================================================================================

++ CAPTURE STATISTICS ++

Capture
Process
Number 		Capture
Name 		Startup Timestamp Session
ID 		Session
Serial
Number 		State Last
State Change
Time 		Redo Entries
Scanned 		Total
LCRs
Enqueued 		Total
Messages
Created
C001 PPCAPR_CAP TURE 21:09:13 01/30/08 5473 183 CAPTURING CHANGES 21:46:48 01/30/08 40127 1035 51718

Capture
Name 		Current Time Capture Process T Last Redo
Message Number 		Last Redo
Message
Create Time 		Last
Enqueue
Time 		Last Queued
Message Number 		Last Queued
Message
Create Time 		Available
Message Number 		Available
Message
Create Time
PPCAPR_CAP TURE 21:47:08 01/30/08 21:46:48 01/30/08 9067341 21:46:48 01/30/08 21:11:43 01/30/08 9065201   9067342 21:47:05 01/30/08

Capture
Name 		Logminer Last
Processed Message 		Last Message
Written to Redo
PPCAPR_CAP TURE 9067341 9067342

Capture
Name 		Prefilter
Events
Discarded 		Prefilter
Events
Kept 		Prefilter
Evaluations 		Undecided
After
Prefilter 		Full
Evaluations
PPCAPR_CAPTURE 28978 0 29107 129 10

Capture
Name 		Elapsed Time
Capture
(centisecs) 		Elapsed Time
Rule Evaluation
(centisecs) 		Elapsed Time
Enqueuing Messages
(centisecs) 		Elapsed Time
LCR Creation
(centisecs) 		Elapsed Time
Redo Wait
(centisecs) 		Elapsed Time
Paused
(centisecs) 		Total
Messages
Created 		Total
LCRs
Enqueued 		Full
Evaluations
PPCAPR_CAPTURE 219279 1 176 5689 317 0 51718 1035 10


++ LOGMINER STATISTICS ++
++ (pageouts imply logminer spill) ++

Capture
Name 		Statistic Value
PPCAPR_CAPTURE bytes of redo processed 18116952
PPCAPR_CAPTURE bytes paged out 0
PPCAPR_CAPTURE bytes checkpointed 3328
PPCAPR_CAPTURE seconds spent in checkpoint 0


++ BUFFERED PUBLISHERS ++

INST_ID QUEUE_ID QUEUE_SCHEMA Queue Name SENDER_NAME SENDER_ADDRESS SENDER_PROTOCOL Current
Number of Msgs
in Queue 		Cumulative
Total Msgs
for Queue 		LAST_ENQUEUED_MSG UNBROWSED_MSGS OVERSPILLED_MSGS MEMORY_USAGE PUBLISHER_STATE
1 62114 STRMADMIN PPCAPR_QUEUE PPCAPR_CAPTURE   1 0 0 0 0 0 3 PUBLISHING MESSAGES

============================================================================================

++ OPEN STREAMS CAPTURE TRANSACTIONS ++

+** Count **+
no rows selected

+** Detail **+
no rows selected
Configuration: Queue Capture Propagation Apply Database
Analysis: History Rules Notifications Configuration Performance Wait Analysis
Statistics Quick Link: Queue Capture Propagation Apply Errors
=========================================================================================

++ SCHEDULE FOR EACH PROPAGATION++
=========================================================================================

Propagation
Name 		Start Date Duration
in Seconds 		Next
Time 		Latency
in Seconds 		Status Process Total Bytes
Propagated 		Number of
Failures 		Message
Delivery
Mode 		Q-2-Q Error Message
PPCAPR_PROPAGATE 21:02:51 01/30/08     60 Enabled J001 0 0 BUFFERED TRUE  
PPCAPR_PROPAGATE 21:00:31 01/30/08     1 Enabled J000 0 0 BUFFERED TRUE  
PPCAPR_PROPAGATE 21:00:31 01/30/08     1 Enabled J000 0 0 PERSISTENT TRUE  
PPCAPR_PROPAGATE 21:02:51 01/30/08     60 Enabled J001 0 0 PERSISTENT TRUE  

Propagation
Name 		Message
Delivery
Mode 		Last
Run 		Current
Start 		Next
Run 		Last
Error
PPCAPR_PROPAGATE BUFFERED   21:02:51 01/30/08    
PPCAPR_PROPAGATE BUFFERED   21:00:31 01/30/08    
PPCAPR_PROPAGATE PERSISTENT   21:00:31 01/30/08    
PPCAPR_PROPAGATE PERSISTENT   21:02:51 01/30/08    


++ EVENTS AND BYTES PROPAGATED FOR EACH PROPAGATION++

Propagation
Name 		Message
Delivery
Mode 		Schedule
Status 		Instance Name
(Instance Number) 		Total
Events
Propagated 		Total Bytes
Propagated 		Elapsed
Dequeue Time
(Seconds) 		Total Time
(Seconds) 		Elapsed
Pickle Time
(Seconds)
PPCAPR_PROPAGATE BUFFERED Enabled 1 0 0 0 0 0
PPCAPR_PROPAGATE BUFFERED Enabled 1 0 0 0 0 0
PPCAPR_PROPAGATE PERSISTENT Enabled 1 0 0     0
PPCAPR_PROPAGATE PERSISTENT Enabled 1 0 0     0

++ PROPAGATION SENDER STATISTICS ++

Queue ID Source
Queue
Owner 		Source
Queue
Name 		Destination
Queue
Owner 		Destination
Queue
Name 		Startup Timestamp Destination
Database
Link 		High
Water
Mark 		Target
Ack 		Schedule
Status 		Total
Messages 		Total Bytes
Propagated 		Elapsed
Dequeue Time
(CentiSecs) 		Total Time
(CentiSecs) 		Elapsed
Propagation Time
(Seconds) 		Max Msgs
per
Window 		Max
Size
62114 STRMADMIN PPCAPR_QUEUE     21:00:31 01/30/08 "STRMADMIN"."PP CAPR_QUEUE"@GID QSTD1.GAP.COM 0 0 SCHEDULE ENABLED 0 0 0 0 0 0 0
62114 STRMADMIN PPCAPR_QUEUE     20:05:05 01/30/08 GIDQSTD1.GAP.CO M 0 0 SCHEDULE ENABLED 0 0 0 0 0 0 0

Statistics Quick Link: Queue Capture Propagation Apply Errors

++ PROPAGATION RECEIVER STATISTICS++

no rows selected

++ BUFFERED SUBSCRIBERS ++

INST_ID Queue ID Source
Queue
Owner 		Source
Queue
Name 		SUBSCRIBER_ID SUBSCRIBER_NAME SUBSCRIBER_ADDRESS Protocol SUBSCRIBER_TYPE Startup
Time 		LAST_BROWSED_SEQ LAST_BROWSED_NUM LAST_DEQUEUED_SEQ LAST_DEQUEUED_NUM CURRENT_ENQ_SEQ Current
Number of Msgs
in Queue 		Cumulative
Total Msgs
for Queue 		TOTAL_DEQUEUED_MSG Cumulative
Total Spilled
Messages 		Current Number of
Expired
Messages
in Queue 		MESSAGE_LAG
1 62114 STRMADMIN PPCAPR_QUEUE 2   GIDQSTD1.GAP.COM 0 PROXY 20:05:04 01/30/08 0 0 0 0 0 0 0 0 0 0 0
1 62114 STRMADMIN PPCAPR_QUEUE 4   "STRMADMIN"."PPCAPR_QUEUE"@GIDQSTD1.GAP.COM 0 PROXY 20:05:04 01/30/08 0 0 0 0 0 0 0 0 0 0 0

Configuration: Queue Capture Propagation Apply Database
Analysis: History Rules Notifications Configuration Performance Wait Analysis
Statistics Quick Link: Queue Capture Propagation Apply Errors
============================================================================================

++ APPLY STATISTICS ++

============================================================================================

++ APPLY Reader Statistics ++
no rows selected
no rows selected
no rows selected
============================================================================================

++ APPLY SPILLED TRANSACTIONS ++
no rows selected
============================================================================================

++ APPLY Coordinator Statistics ++
no rows selected
no rows selected
no rows selected
============================================================================================

++ APPLY Server Statistics ++
no rows selected
no rows selected
no rows selected
no rows selected
Statistics: Streams Statistics Queue Capture Propagation Apply Apply_Errors
no rows selected
++ APPLY PROGRESS ++
no rows selected
============================================================================================

++ OPEN STREAMS APPLY TRANSACTIONS ++

+** Count **+
no rows selected

+** Detail **+
no rows selected

Configuration: Queue Capture Propagation Apply Database
Analysis: History Rules Notifications Configuration Performance Wait Analysis
Statistics Quick Link: Queue Capture Propagation Apply Errors

++ STATISTICS on RULES and RULE SETS
++
++ RULE SET STATISTICS

INST_ID Owner Name CPU_TIME ELAPSED_TIME FIRST_LOAD_TIME LAST_LOAD_TIME LAST_LOADING_TIME SHARABLE_MEM RELOADS INVALIDATIONS EVALUATIONS FIRST_HIT_EVALUATIONS SIMPLE_RULES_ONLY_EVALUATIONS SQL_FREE_EVALUATIONS SQL_EXECUTIONS CONDITIONS_PROCESSED TRUE_RULES MAYBE_RULES VARIABLE_VALUE_FUNCTION_CALLS VARIABLE_METHOD_FUNCTION_CALLS EVALUATION_FUNCTION_CALLS
1 SYS ALERT_QUE_R 11 32 18:53:57 11/16/06 15:50:33 01/30/08 30 31004 1 0 129 0 129 0 0 129 2 0 0 0 0
1 STRMADMIN RULESET$_20 135 140 21:00:31 01/30/08   0 59966 1 0 2006 2006 3010 0 0 3024 0 0 8 7036 2006
1 STRMADMIN RULESET$_14 35 24 20:03:51 01/30/08   0 47974 1 0 629 629 1238 0 0 1859 28 567 20 3001 629


++ RULE STATISTICS

INST_ID RULE_SET_OBJECT_ID EVALUATION_CONTEXT_OBJECT_ID RULE_OWNER Rule RULE_CONDITION TRUE_HITS MAYBE_HITS SQL_EVALUATIONS
1 8840 8825 SYS ALERT_QUE$1 tab.user_data.MESSAGE_LEVEL = 5 AND tab.user_data.MESSAGE_GROUP = 'High Availability' 2 0 0
1 62120 8411 STRMADMIN PPCAPR13 ((:ddl.get_object_owner() = 'PPCAPR' or :ddl.get_base_table_owner() = 'PPCAPR') and :ddl.is_null_tag() = 'Y' ) 14 547 0
1 62120 8411 STRMADMIN PPCAPR12 ((:dml.get_object_owner() = 'PPCAPR') and :dml.is_null_tag() = 'Y' ) 14 20 0


Function created.

No errors.

Procedure created.

No errors.


============================================================================================
==================================== Summary ===============================================
============================================================================================


++
++ Notifications ++
++

+
+
+
+
+
PL/SQL procedure successfully completed.


++
++ SYS Checks
++

+
+
PL/SQL procedure successfully completed.


++
++ init.ora checks ++
++
PL/SQL procedure successfully completed.


++
++ Configuration checks ++
++
+ WARNING: the Propagation process 'PPCAPR_PROPAGATE' has latency 60, it should be 5 or less!
+ Set the latency by calling dbms_aqadm.alter_schedule(queue_name,destination,latency=>5)
+
+ ERROR: The rule STRMADMIN.PPCAPR19 specifies an unknown source database: GIDQUEST.REGRESS.RDBMS.DEV.US.ORACLE.COM.
+ ERROR: The rule STRMADMIN.PPCAPR18 specifies an unknown source database: GIDQUEST.REGRESS.RDBMS.DEV.US.ORACLE.COM.
+
+
+ SUGGESTION: One or more propagation processes contain rule sets.
+ If a Propagation process will unconditionally forward all incoming
+ messages to its destination queue, and no rule-based transformations are
+ performed by the Propagation process, you should consider removing
+ the rule set for the Propagation process via dbms_propagation_adm.alter_propagation.
+ This will improve Propagation performance.
+
PL/SQL procedure successfully completed.


++
++ Performance Checks ++
++
++ Note: Performance only checked for enabled Streams processes!
++ Aborted and disabled processes will not report performance warnings!

+
PL/SQL procedure successfully completed.

================================================================================
++ STREAMS Process Wait Analysis ++

Analysis of last 30 minutes of Streams processes

Note: When computing the busiest component, be sure to subtract the percentage where BUSY = 'NO'
Note: 'no rows selected' means that the process was performing no busy work, or that no such process exists on the system.
Note: A null Wait Event implies running - either on the cpu or waiting for cpu

++ LOGMINER READER PROCESSES ++

LOGMINER_READER_NAME EVENT_COUNT TOTAL_COUNT PERCENTAGE BUSY Wait Event
PPCAPR_CAPTURE - reader 2 1800 .1 YES ARCH wait on c/f tx acquire 2
  16 1800 .9 YES log file sequential read
  18 1800 1.0 YES control file sequential read
  183 1800 10.2 YES  
  1581 1800 87.8 YES Streams capture: waiting for archive log
******************************     ----------    
TOTAL     100.0    


++ LOGMINER PREPARER PROCESSES ++
no rows selected

++ LOGMINER BUILDER PROCESSES ++

LOGMINER_BUILDER_NAME EVENT_COUNT TOTAL_COUNT PERCENTAGE BUSY Wait Event
PPCAPR_CAPTURE - builder 1 1801 .1 YES  
******************************     ----------    
TOTAL     .1    


++ CAPTURE PROCESSES ++

Capture
Name 		EVENT_COUNT TOTAL_COUNT PERCENTAGE BUSY Wait Event
PPCAPR_CAPTURE 847 1801 47.0 NO Streams capture: waiting for archive log
******************************     ----------    
TOTAL     47.0    


++ PROPAGATION SENDER PROCESSES ++
no rows selected

++ PROPAGATION RECEIVER PROCESSES ++
no rows selected

++ APPLY READER PROCESSES ++
no rows selected

++ APPLY COORDINATOR PROCESSES ++
no rows selected

++ APPLY SERVER PROCESSES ++
no rows selected
currently spooling to GIDQUEST.html Turning Spool OFF!!!