IL Patch Last Changed: 2011-04-28T14:12:33

AIX_UPDATE_TYPE

name (en)	AIX_UPDATE_TYPE
name (zh)	(zh) New Query Subject1
name (fr)	(fr) New Query Subject1
name (de)	(de) New Query Subject1
name (ja)	(ja) New Query Subject1
name (es)	(es) New Query Subject1
Status	valid
Last Changed	2011-05-24T17:59:32
lastChangedBy	Primary\BLAdmin(BLAdmins)
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql Select * from [ORA75].AIX_UPDATE_TYPE filters filterDefinition displayName Site Access Filter expression [IL Patch].[AIX_UPDATE_TYPE].[BL_SITE_ID] IN (#csv(split(',', $account.parameters.siteIdList))#) tableType table
BL_SITE_ID name (en) BL_SITE_ID name (zh) (zh) BL_SITE_ID name (fr) (fr) BL_SITE_ID name (de) (de) BL_SITE_ID name (ja) (ja) BL_SITE_ID name (es) (es) BL_SITE_ID Last Changed 2011-05-24T16:43:48 lastChangedBy Primary\BLAdmin(BLAdmins) externalName BL_SITE_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
AIX_UPDATE_TYPE_ID name (en) AIX_UPDATE_TYPE_ID name (zh) (zh) AIX_UPDATE_TYPE_ID name (fr) (fr) AIX_UPDATE_TYPE_ID name (de) (de) AIX_UPDATE_TYPE_ID name (ja) (ja) AIX_UPDATE_TYPE_ID name (es) (es) AIX_UPDATE_TYPE_ID Last Changed 2011-05-24T16:43:48 lastChangedBy Primary\BLAdmin(BLAdmins) externalName AIX_UPDATE_TYPE_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
NAME name (en) NAME name (zh) (zh) NAME name (fr) (fr) NAME name (de) (de) NAME name (ja) (ja) NAME name (es) (es) NAME Last Changed 2011-05-24T16:43:48 lastChangedBy Primary\BLAdmin(BLAdmins) externalName NAME usage attribute datatype characterLength16 precision 100 scale 0 size 202 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
DESCRIPTION name (en) DESCRIPTION name (zh) (zh) DESCRIPTION name (fr) (fr) DESCRIPTION name (de) (de) DESCRIPTION name (ja) (ja) DESCRIPTION name (es) (es) DESCRIPTION Last Changed 2011-05-24T16:43:48 lastChangedBy Primary\BLAdmin(BLAdmins) externalName DESCRIPTION usage attribute datatype characterLength16 precision 255 scale 0 size 512 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
BL_VALUE_ID name (en) BL_VALUE_ID name (zh) (zh) BL_VALUE_ID name (fr) (fr) BL_VALUE_ID name (de) (de) BL_VALUE_ID name (ja) (ja) BL_VALUE_ID name (es) (es) BL_VALUE_ID Last Changed 2011-05-24T16:43:48 lastChangedBy Primary\BLAdmin(BLAdmins) externalName BL_VALUE_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate sum semiAggregate sum collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0

B_BLGROUP_PATCH

name (en)	B_BLGROUP_PATCH
name (zh)	(zh) B_BLGROUP_PATCH
name (fr)	(fr) B_BLGROUP_PATCH
name (de)	(de) B_BLGROUP_PATCH
name (ja)	(ja) B_BLGROUP_PATCH
name (es)	(es) B_BLGROUP_PATCH
Status	valid
Last Changed	2013-07-02T17:30:17
lastChangedBy	PATCH_SITE\BLAdmin(BLAdmins)
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql Select B_BLGROUP_PATCH.BLGROUP_PATCH_ID, B_BLGROUP_PATCH.GROUP_HIST_ID, B_BLGROUP_PATCH.DEPOT_OBJECT_HIST_ID, B_BLGROUP_PATCH.START_DATETIME, B_BLGROUP_PATCH.END_DATETIME, B_BLGROUP_PATCH.IS_DELETED, B_BLGROUP_PATCH.DEPOT_OBJECT_ID, B_BLGROUP_PATCH.BL_SITE_ID From [ORA75].B_BLGROUP_PATCH as B_BLGROUP_PATCH tableType table
BLGROUP_PATCH_ID name (en) BLGROUP_PATCH_ID name (zh) (zh) BLGROUP_PATCH_ID name (fr) (fr) BLGROUP_PATCH_ID name (de) (de) BLGROUP_PATCH_ID name (ja) (ja) BLGROUP_PATCH_ID name (es) (es) BLGROUP_PATCH_ID Last Changed 2013-07-02T17:29:46 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName BLGROUP_PATCH_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
GROUP_HIST_ID name (en) GROUP_HIST_ID name (zh) (zh) GROUP_HIST_ID name (fr) (fr) GROUP_HIST_ID name (de) (de) GROUP_HIST_ID name (ja) (ja) GROUP_HIST_ID name (es) (es) GROUP_HIST_ID Last Changed 2013-07-02T17:29:46 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName GROUP_HIST_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
DEPOT_OBJECT_HIST_ID name (en) DEPOT_OBJECT_HIST_ID name (zh) (zh) DEPOT_OBJECT_HIST_ID name (fr) (fr) DEPOT_OBJECT_HIST_ID name (de) (de) DEPOT_OBJECT_HIST_ID name (ja) (ja) DEPOT_OBJECT_HIST_ID name (es) (es) DEPOT_OBJECT_HIST_ID Last Changed 2013-07-02T17:29:46 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName DEPOT_OBJECT_HIST_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
START_DATETIME name (en) START_DATETIME name (zh) (zh) START_DATETIME name (fr) (fr) START_DATETIME name (de) (de) START_DATETIME name (ja) (ja) START_DATETIME name (es) (es) START_DATETIME Last Changed 2013-07-02T17:29:46 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName START_DATETIME usage identifier datatype dateTime precision 0 scale 0 size 12 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1
END_DATETIME name (en) END_DATETIME name (zh) (zh) END_DATETIME name (fr) (fr) END_DATETIME name (de) (de) END_DATETIME name (ja) (ja) END_DATETIME name (es) (es) END_DATETIME Last Changed 2013-07-02T17:29:46 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName END_DATETIME usage identifier datatype dateTime precision 0 scale 0 size 12 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1
IS_DELETED name (en) IS_DELETED name (zh) (zh) IS_DELETED name (fr) (fr) IS_DELETED name (de) (de) IS_DELETED name (ja) (ja) IS_DELETED name (es) (es) IS_DELETED Last Changed 2013-07-02T17:29:46 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName IS_DELETED usage fact datatype int16 precision 0 scale 0 size 2 nullable false regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
DEPOT_OBJECT_ID name (en) DEPOT_OBJECT_ID name (zh) (zh) DEPOT_OBJECT_ID name (fr) (fr) DEPOT_OBJECT_ID name (de) (de) DEPOT_OBJECT_ID name (ja) (ja) DEPOT_OBJECT_ID name (es) (es) DEPOT_OBJECT_ID Last Changed 2013-07-02T17:29:46 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName DEPOT_OBJECT_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
BL_SITE_ID name (en) BL_SITE_ID name (zh) (zh) BL_SITE_ID name (fr) (fr) BL_SITE_ID name (de) (de) BL_SITE_ID name (ja) (ja) BL_SITE_ID name (es) (es) BL_SITE_ID Last Changed 2013-07-02T17:29:46 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName BL_SITE_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
PARENT_GROUP_ID name (en) PARENT_GROUP_ID name (zh) (zh) PARENT_GROUP_ID name (fr) (fr) PARENT_GROUP_ID name (de) (de) PARENT_GROUP_ID name (ja) (ja) PARENT_GROUP_ID name (es) (es) PARENT_GROUP_ID Last Changed 2016-04-12T17:35:55 lastChangedBy Primary\smendu(GlobalReportAdmins) expression [IL Patch].[D_SMART_GROUP].[PARENT_GROUP_ID] usage identifier datatype decimal precision 38 scale 0 size 20 regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS

B_BLGROUP_PATCH <--> D_SMART_GROUP

name ()	B_BLGROUP_PATCH <--> D_SMART_GROUP
Status	valid
expression	[IL Patch].[B_BLGROUP_PATCH].[GROUP_HIST_ID] =[IL Patch].[D_SMART_GROUP].[GROUP_HIST_ID]
left	refobj [IL Patch].[B_BLGROUP_PATCH] mincard one maxcard one
right	refobj [IL Patch].[D_SMART_GROUP] mincard one maxcard one

---

B_BLGROUP_PATCH <--> PATCH_D_DEPOT_OBJECT

name ()	B_BLGROUP_PATCH <--> PATCH_D_DEPOT_OBJECT
Status	valid
expression	[IL Patch].[B_BLGROUP_PATCH].[DEPOT_OBJECT_HIST_ID] =[IL Patch].[PATCH_D_DEPOT_OBJECT].[DEPOT_OBJECT_HIST_ID] AND[IL Patch].[B_BLGROUP_PATCH].[PARENT_GROUP_ID] =[IL Patch].[PATCH_D_DEPOT_OBJECT].[GROUP_ID]
left	refobj [IL Patch].[B_BLGROUP_PATCH] mincard one maxcard one
right	refobj [IL Patch].[PATCH_D_DEPOT_OBJECT] mincard one maxcard one

---

B_BLGROUP_SERVER

name (en)	B_BLGROUP_SERVER
name (zh)	(zh) B_BLGROUP_SERVER
name (fr)	(fr) B_BLGROUP_SERVER
name (de)	(de) B_BLGROUP_SERVER
name (ja)	(ja) B_BLGROUP_SERVER
name (es)	(es) B_BLGROUP_SERVER
Status	valid
Last Changed	2011-07-08T12:10:00
lastChangedBy	OM82DEV\BLAdmin(BLAdmins)
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql Select * from [ORA75].B_BLGROUP_SERVER tableType table
BLGROUP_SERVER_ID name (en) BLGROUP_SERVER_ID name (zh) (zh) BLGROUP_SERVER_ID name (fr) (fr) BLGROUP_SERVER_ID name (de) (de) BLGROUP_SERVER_ID name (ja) (ja) BLGROUP_SERVER_ID name (es) (es) BLGROUP_SERVER_ID Last Changed 2011-07-08T12:16:31 lastChangedBy OM82DEV\BLAdmin(BLAdmins) externalName BLGROUP_SERVER_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1
GROUP_HIST_ID name (en) GROUP_HIST_ID name (zh) (zh) GROUP_HIST_ID name (fr) (fr) GROUP_HIST_ID name (de) (de) GROUP_HIST_ID name (ja) (ja) GROUP_HIST_ID name (es) (es) GROUP_HIST_ID Last Changed 2011-07-08T12:23:42 lastChangedBy OM82DEV\BLAdmin(BLAdmins) externalName GROUP_HIST_ID usage attribute datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1
SERVER_HIST_ID name (en) SERVER_HIST_ID name (zh) (zh) SERVER_HIST_ID name (fr) (fr) SERVER_HIST_ID name (de) (de) SERVER_HIST_ID name (ja) (ja) SERVER_HIST_ID name (es) (es) SERVER_HIST_ID Last Changed 2011-07-08T12:16:44 lastChangedBy OM82DEV\BLAdmin(BLAdmins) externalName SERVER_HIST_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1
START_DATETIME name (en) START_DATETIME name (zh) (zh) START_DATETIME name (fr) (fr) START_DATETIME name (de) (de) START_DATETIME name (ja) (ja) START_DATETIME name (es) (es) START_DATETIME Last Changed 2011-07-08T12:09:59 lastChangedBy OM82DEV\BLAdmin(BLAdmins) externalName START_DATETIME usage identifier datatype dateTime precision 0 scale 0 size 12 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1
END_DATETIME name (en) END_DATETIME name (zh) (zh) END_DATETIME name (fr) (fr) END_DATETIME name (de) (de) END_DATETIME name (ja) (ja) END_DATETIME name (es) (es) END_DATETIME Last Changed 2011-07-08T12:09:59 lastChangedBy OM82DEV\BLAdmin(BLAdmins) externalName END_DATETIME usage identifier datatype dateTime precision 0 scale 0 size 12 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1
IS_DELETED name (en) IS_DELETED name (zh) (zh) IS_DELETED name (fr) (fr) IS_DELETED name (de) (de) IS_DELETED name (ja) (ja) IS_DELETED name (es) (es) IS_DELETED Last Changed 2011-07-08T12:17:09 lastChangedBy OM82DEV\BLAdmin(BLAdmins) externalName IS_DELETED usage attribute datatype int16 precision 0 scale 0 size 2 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1
SERVER_ID name (en) SERVER_ID name (zh) (zh) SERVER_ID name (fr) (fr) SERVER_ID name (de) (de) SERVER_ID name (ja) (ja) SERVER_ID name (es) (es) SERVER_ID Last Changed 2011-07-08T12:17:15 lastChangedBy OM82DEV\BLAdmin(BLAdmins) externalName SERVER_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1
BL_SITE_ID name (en) BL_SITE_ID name (zh) (zh) BL_SITE_ID name (fr) (fr) BL_SITE_ID name (de) (de) BL_SITE_ID name (ja) (ja) BL_SITE_ID name (es) (es) BL_SITE_ID Last Changed 2011-07-08T12:17:17 lastChangedBy OM82DEV\BLAdmin(BLAdmins) externalName BL_SITE_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1

B_CATALOG_UPD_JOB_ASSOC

name (en)	B_CATALOG_UPD_JOB_ASSOC
name (zh)	(zh) B_CATALOG_UPD_JOB_ASSOC
name (fr)	(fr) B_CATALOG_UPD_JOB_ASSOC
name (de)	(de) B_CATALOG_UPD_JOB_ASSOC
name (ja)	(ja) B_CATALOG_UPD_JOB_ASSOC
name (es)	(es) B_CATALOG_UPD_JOB_ASSOC
Status	valid
Last Changed	2013-07-10T12:27:05
lastChangedBy	PATCH_SITE\BLAdmin(BLAdmins)
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql SELECT * FROM B_CATALOG_UPD_JOB_ASSOC tableType table
GROUP_ID name (en) GROUP_ID name (zh) (zh) GROUP_ID name (fr) (fr) GROUP_ID name (de) (de) GROUP_ID name (ja) (ja) GROUP_ID name (es) (es) GROUP_ID Last Changed 2013-07-10T12:27:03 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName GROUP_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
IS_DELETED name (en) IS_DELETED name (zh) (zh) IS_DELETED name (fr) (fr) IS_DELETED name (de) (de) IS_DELETED name (ja) (ja) IS_DELETED name (es) (es) IS_DELETED Last Changed 2013-07-10T12:27:03 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName IS_DELETED usage fact datatype int16 precision 0 scale 0 size 2 nullable false regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
JOB_HIST_ID name (en) JOB_HIST_ID name (zh) (zh) JOB_HIST_ID name (fr) (fr) JOB_HIST_ID name (de) (de) JOB_HIST_ID name (ja) (ja) JOB_HIST_ID name (es) (es) JOB_HIST_ID Last Changed 2013-07-10T12:27:03 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName JOB_HIST_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
GROUP_HIST_ID name (en) GROUP_HIST_ID name (zh) (zh) GROUP_HIST_ID name (fr) (fr) GROUP_HIST_ID name (de) (de) GROUP_HIST_ID name (ja) (ja) GROUP_HIST_ID name (es) (es) GROUP_HIST_ID Last Changed 2013-07-10T12:27:03 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName GROUP_HIST_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
BL_SITE_ID name (en) BL_SITE_ID name (zh) (zh) BL_SITE_ID name (fr) (fr) BL_SITE_ID name (de) (de) BL_SITE_ID name (ja) (ja) BL_SITE_ID name (es) (es) BL_SITE_ID Last Changed 2013-07-10T12:27:03 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName BL_SITE_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1

B_CATALOG_UPD_JOB_ASSOC <--> D_BLGROUP

name ()	B_CATALOG_UPD_JOB_ASSOC <--> D_BLGROUP
Status	valid
expression	[IL Patch].[B_CATALOG_UPD_JOB_ASSOC].[GROUP_ID] =[IL Patch].[D_BLGROUP].[GROUP_ID] AND[IL Patch].[B_CATALOG_UPD_JOB_ASSOC].[BL_SITE_ID] =[IL Patch].[D_BLGROUP].[BL_SITE_ID] AND[IL Patch].[D_BLGROUP].[IS_LATEST_VERSION] = 1
left	refobj [IL Patch].[B_CATALOG_UPD_JOB_ASSOC] mincard one maxcard one
right	refobj [IL Patch].[D_BLGROUP] mincard one maxcard one

---

BL_PATCH_ANALYSIS_RES_DATA <--> D_SERVER

name ()	BL_PATCH_ANALYSIS_RES_DATA <--> D_SERVER
Status	valid
expression	[IL Patch].[F_PATCH_ANALYSIS_RESULT_DTL].[SERVER_HIST_ID] =[IL Patch].[D_SERVER].[SERVER_HIST_ID]
left	refobj [IL Patch].[F_PATCH_ANALYSIS_RESULT_DTL] mincard one maxcard many
right	refobj [IL Patch].[D_SERVER] mincard one maxcard one

---

BL_PATCH_ANALYSIS_RES_DATA <--> F_JOB_RUN

name ()	BL_PATCH_ANALYSIS_RES_DATA <--> F_JOB_RUN
Status	valid
expression	[IL Patch].[F_PATCH_ANALYSIS_RESULT_DTL].[JOB_RUN_HIST_ID] =[IL Patch].[F_JOB_RUN].[JOB_RUN_HIST_ID]
left	refobj [IL Patch].[F_PATCH_ANALYSIS_RESULT_DTL] mincard one maxcard many
right	refobj [IL Patch].[F_JOB_RUN] mincard one maxcard one

---

BL_PATCH_ANALYSIS_RES_DATA <--> PATCH_D_DEPOT_OBJECT

name ()	BL_PATCH_ANALYSIS_RES_DATA <--> PATCH_D_DEPOT_OBJECT
Status	valid
expression	[IL Patch].[F_PATCH_ANALYSIS_RESULT_DTL].[DEPOT_OBJECT_HIST_ID] =[IL Patch].[PATCH_D_DEPOT_OBJECT].[DEPOT_OBJECT_HIST_ID]
left	refobj [IL Patch].[F_PATCH_ANALYSIS_RESULT_DTL] mincard one maxcard many
right	refobj [IL Patch].[PATCH_D_DEPOT_OBJECT] mincard one maxcard one

---

BL_PATCH_BULLETIN_IMPACT

name (en)	BL_PATCH_BULLETIN_IMPACT
name (zh)	(zh) BL_PATCH_BULLETIN_IMPACT
name (fr)	(fr) BL_PATCH_BULLETIN_IMPACT
name (de)	(de) BL_PATCH_BULLETIN_IMPACT
name (ja)	(ja) BL_PATCH_BULLETIN_IMPACT
name (es)	(es) BL_PATCH_BULLETIN_IMPACT
Status	valid
Last Changed	2013-08-20T11:09:54
lastChangedBy	Primary\BLAdmin(BLAdmins)
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql Select * from BL_PATCH_IMPACT tableType table
BL_PATCH_IMPACT_ID name (en) BL_PATCH_IMPACT_ID name (zh) (zh) BL_PATCH_IMPACT_ID name (fr) (fr) BL_PATCH_IMPACT_ID name (de) (de) BL_PATCH_IMPACT_ID name (ja) (ja) BL_PATCH_IMPACT_ID name (es) (es) BL_PATCH_IMPACT_ID Last Changed 2013-08-20T11:09:53 lastChangedBy Primary\BLAdmin(BLAdmins) externalName BL_PATCH_IMPACT_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
NAME name (en) NAME name (zh) (zh) NAME name (fr) (fr) NAME name (de) (de) NAME name (ja) (ja) NAME name (es) (es) NAME Last Changed 2013-08-20T11:09:53 lastChangedBy Primary\BLAdmin(BLAdmins) externalName NAME usage attribute datatype characterLength16 precision 100 scale 0 size 202 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
DESCRIPTION name (en) DESCRIPTION name (zh) (zh) DESCRIPTION name (fr) (fr) DESCRIPTION name (de) (de) DESCRIPTION name (ja) (ja) DESCRIPTION name (es) (es) DESCRIPTION Last Changed 2013-08-20T11:09:53 lastChangedBy Primary\BLAdmin(BLAdmins) externalName DESCRIPTION usage attribute datatype characterLength16 precision 255 scale 0 size 512 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
BL_VALUE_ID name (en) BL_VALUE_ID name (zh) (zh) BL_VALUE_ID name (fr) (fr) BL_VALUE_ID name (de) (de) BL_VALUE_ID name (ja) (ja) BL_VALUE_ID name (es) (es) BL_VALUE_ID Last Changed 2013-08-20T11:09:53 lastChangedBy Primary\BLAdmin(BLAdmins) externalName BL_VALUE_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate sum semiAggregate sum collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0

BL_PATCH_BULLETIN_IMPACT <--> D_DEPOT_SOFTWARE_WIN_BULLETIN

name ()	BL_PATCH_BULLETIN_IMPACT <--> D_DEPOT_SOFTWARE_WIN_BULLETIN
Status	valid
expression	[IL Patch].[BL_PATCH_BULLETIN_IMPACT].[BL_PATCH_IMPACT_ID] =[IL Patch].[D_DEPOT_SOFTWARE_WIN_BULLETIN].[VENDOR_IMPACT_ID]
left	refobj [IL Patch].[BL_PATCH_BULLETIN_IMPACT] mincard one maxcard one
right	refobj [IL Patch].[D_DEPOT_SOFTWARE_WIN_BULLETIN] mincard one maxcard one

---

BL_PATCH_IMPACT

name (en)	BL_PATCH_IMPACT
name (zh)	(zh) New Query Subject9
name (fr)	(fr) New Query Subject9
name (de)	(de) New Query Subject9
name (ja)	(ja) New Query Subject9
name (es)	(es) New Query Subject9
Status	valid
Last Changed	2011-05-24T17:40:05
lastChangedBy	Primary\BLAdmin(BLAdmins)
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql Select * from [ORA75].BL_PATCH_IMPACT tableType table
BL_PATCH_IMPACT_ID name (en) BL_PATCH_IMPACT_ID name (zh) (zh) BL_PATCH_IMPACT_ID name (fr) (fr) BL_PATCH_IMPACT_ID name (de) (de) BL_PATCH_IMPACT_ID name (ja) (ja) BL_PATCH_IMPACT_ID name (es) (es) BL_PATCH_IMPACT_ID Last Changed 2011-05-24T17:39:53 lastChangedBy Primary\BLAdmin(BLAdmins) externalName BL_PATCH_IMPACT_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
NAME name (en) NAME name (zh) (zh) NAME name (fr) (fr) NAME name (de) (de) NAME name (ja) (ja) NAME name (es) (es) NAME Last Changed 2011-05-24T17:39:53 lastChangedBy Primary\BLAdmin(BLAdmins) externalName NAME usage attribute datatype characterLength16 precision 100 scale 0 size 202 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
DESCRIPTION name (en) DESCRIPTION name (zh) (zh) DESCRIPTION name (fr) (fr) DESCRIPTION name (de) (de) DESCRIPTION name (ja) (ja) DESCRIPTION name (es) (es) DESCRIPTION Last Changed 2011-05-24T17:39:53 lastChangedBy Primary\BLAdmin(BLAdmins) externalName DESCRIPTION usage attribute datatype characterLength16 precision 255 scale 0 size 512 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
BL_VALUE_ID name (en) BL_VALUE_ID name (zh) (zh) BL_VALUE_ID name (fr) (fr) BL_VALUE_ID name (de) (de) BL_VALUE_ID name (ja) (ja) BL_VALUE_ID name (es) (es) BL_VALUE_ID Last Changed 2011-05-24T17:39:53 lastChangedBy Primary\BLAdmin(BLAdmins) externalName BL_VALUE_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate sum semiAggregate sum collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0

BL_PATCH_IMPACT <--> D_DEPOT_SOFTWARE_HOTFIX

name ()	BL_PATCH_IMPACT <--> D_DEPOT_SOFTWARE_HOTFIX
Status	valid
expression	[IL Patch].[BL_PATCH_IMPACT].[BL_PATCH_IMPACT_ID] = [IL Patch].[D_DEPOT_SOFTWARE_HOTFIX].[BL_PATCH_IMPACT_ID]
left	refobj [IL Patch].[BL_PATCH_IMPACT] mincard one maxcard one
right	refobj [IL Patch].[D_DEPOT_SOFTWARE_HOTFIX] mincard one maxcard many

---

BL_PATCH_LANGUAGE

name (en)	BL_PATCH_LANGUAGE
name (zh)	(zh) New Query Subject8
name (fr)	(fr) New Query Subject8
name (de)	(de) New Query Subject8
name (ja)	(ja) New Query Subject8
name (es)	(es) New Query Subject8
Status	valid
Last Changed	2011-05-24T18:02:58
lastChangedBy	Primary\BLAdmin(BLAdmins)
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql Select * from [ORA75].BL_PATCH_LANGUAGE filters filterDefinition displayName Site Access Filter expression [IL Patch].[BL_PATCH_LANGUAGE].[BL_SITE_ID] IN (#csv(split(',', $account.parameters.siteIdList))#) tableType table
BL_PATCH_LANGUAGE_ID name (en) BL_PATCH_LANGUAGE_ID name (zh) (zh) BL_PATCH_LANGUAGE_ID name (fr) (fr) BL_PATCH_LANGUAGE_ID name (de) (de) BL_PATCH_LANGUAGE_ID name (ja) (ja) BL_PATCH_LANGUAGE_ID name (es) (es) BL_PATCH_LANGUAGE_ID Last Changed 2011-05-24T17:38:32 lastChangedBy Primary\BLAdmin(BLAdmins) externalName BL_PATCH_LANGUAGE_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
BL_SITE_ID name (en) BL_SITE_ID name (zh) (zh) BL_SITE_ID name (fr) (fr) BL_SITE_ID name (de) (de) BL_SITE_ID name (ja) (ja) BL_SITE_ID name (es) (es) BL_SITE_ID Last Changed 2011-05-24T17:38:32 lastChangedBy Primary\BLAdmin(BLAdmins) externalName BL_SITE_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
CODE name (en) CODE name (zh) (zh) CODE name (fr) (fr) CODE name (de) (de) CODE name (ja) (ja) CODE name (es) (es) CODE Last Changed 2011-05-24T17:38:32 lastChangedBy Primary\BLAdmin(BLAdmins) externalName CODE usage attribute datatype characterLength16 precision 50 scale 0 size 102 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
NAME name (en) NAME name (zh) (zh) NAME name (fr) (fr) NAME name (de) (de) NAME name (ja) (ja) NAME name (es) (es) NAME Last Changed 2011-05-24T17:38:32 lastChangedBy Primary\BLAdmin(BLAdmins) externalName NAME usage attribute datatype characterLength16 precision 50 scale 0 size 102 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
EXTENSION name (en) EXTENSION name (zh) (zh) EXTENSION name (fr) (fr) EXTENSION name (de) (de) EXTENSION name (ja) (ja) EXTENSION name (es) (es) EXTENSION Last Changed 2011-05-24T17:38:32 lastChangedBy Primary\BLAdmin(BLAdmins) externalName EXTENSION usage attribute datatype characterLength16 precision 50 scale 0 size 102 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0

BL_PATCH_LANGUAGE <--> D_DEPOT_SOFTWARE_HOTFIX

name ()	BL_PATCH_LANGUAGE <--> D_DEPOT_SOFTWARE_HOTFIX
Status	valid
expression	[IL Patch].[BL_PATCH_LANGUAGE].[BL_PATCH_LANGUAGE_ID] = [IL Patch].[D_DEPOT_SOFTWARE_HOTFIX].[BL_PATCH_LANGUAGE_ID]
left	refobj [IL Patch].[BL_PATCH_LANGUAGE] mincard one maxcard one
right	refobj [IL Patch].[D_DEPOT_SOFTWARE_HOTFIX] mincard one maxcard many

---

BL_PATCH_PRODUCT

name (en)	BL_PATCH_PRODUCT
name (zh)	(zh) New Query Subject7
name (fr)	(fr) New Query Subject7
name (de)	(de) New Query Subject7
name (ja)	(ja) New Query Subject7
name (es)	(es) New Query Subject7
Status	valid
Last Changed	2011-05-24T18:02:14
lastChangedBy	Primary\BLAdmin(BLAdmins)
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql Select * from [ORA75].BL_PATCH_PRODUCT filters filterDefinition displayName Site Access Filter expression [IL Patch].[BL_PATCH_PRODUCT].[BL_SITE_ID] IN (#csv(split(',', $account.parameters.siteIdList))#) tableType table
BL_PATCH_PRODUCT_ID name (en) BL_PATCH_PRODUCT_ID name (zh) (zh) BL_PATCH_PRODUCT_ID name (fr) (fr) BL_PATCH_PRODUCT_ID name (de) (de) BL_PATCH_PRODUCT_ID name (ja) (ja) BL_PATCH_PRODUCT_ID name (es) (es) BL_PATCH_PRODUCT_ID Last Changed 2011-05-24T17:36:00 lastChangedBy Primary\BLAdmin(BLAdmins) externalName BL_PATCH_PRODUCT_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
BL_SITE_ID name (en) BL_SITE_ID name (zh) (zh) BL_SITE_ID name (fr) (fr) BL_SITE_ID name (de) (de) BL_SITE_ID name (ja) (ja) BL_SITE_ID name (es) (es) BL_SITE_ID Last Changed 2011-05-24T17:36:00 lastChangedBy Primary\BLAdmin(BLAdmins) externalName BL_SITE_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
NAME name (en) NAME name (zh) (zh) NAME name (fr) (fr) NAME name (de) (de) NAME name (ja) (ja) NAME name (es) (es) NAME Last Changed 2011-05-24T17:35:59 lastChangedBy Primary\BLAdmin(BLAdmins) externalName NAME usage attribute datatype characterLength16 precision 255 scale 0 size 512 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0

BL_PATCH_PRODUCT <--> D_DEPOT_SOFTWARE_HOTFIX

name ()	BL_PATCH_PRODUCT <--> D_DEPOT_SOFTWARE_HOTFIX
Status	valid
expression	[IL Patch].[BL_PATCH_PRODUCT].[BL_PATCH_PRODUCT_ID] = [IL Patch].[D_DEPOT_SOFTWARE_HOTFIX].[BL_PATCH_PRODUCT_ID]
left	refobj [IL Patch].[BL_PATCH_PRODUCT] mincard one maxcard one
right	refobj [IL Patch].[D_DEPOT_SOFTWARE_HOTFIX] mincard one maxcard many

---

BL_SITE

name (en)	BL_SITE
name (zh)	补丁程序站点 1
name (fr)	Site1 du correctif
name (de)	Patch-Site1
name (ja)	パッチ サイト1
name (es)	Sitio de parches1
Status	valid
Last Changed	2011-05-06T10:53:14
lastChangedBy	Primary\BLAdmin(BLAdmins)
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql Select * from [ORA75].BL_SITE filters filterDefinition displayName Site Access Filter expression [IL Patch].[BL_SITE].[BL_SITE_ID] IN (#csv(split(',', $account.parameters.siteIdList))#) tableType table
BL_SITE_ID name (en) BL_SITE_ID name (zh) BL_SITE_ID name (fr) BL_SITE_ID name (de) BL_SITE_ID name (ja) BL_SITE_ID name (es) BL_SITE_ID Last Changed 2009-08-24T14:26:15 lastChangedBy Primary\ReportsSystem(ReportsSystems) externalName BL_SITE_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
NAME name (en) NAME name (zh) 名称 name (fr) NOM name (de) NAME name (ja) 名前 name (es) NOMBRE Last Changed 2009-08-20T14:10:03 lastChangedBy Primary\ReportsSystem(ReportsSystems) externalName NAME usage attribute datatype characterLength16 precision 64 scale 0 size 130 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
DESCRIPTION name (en) DESCRIPTION name (zh) 描述 name (fr) DESCRIPTION name (de) BESCHREIBUNG name (ja) 説明 name (es) DESCRIPCIÓN Last Changed 2009-08-20T14:10:03 lastChangedBy Primary\ReportsSystem(ReportsSystems) externalName DESCRIPTION usage attribute datatype characterLength16 precision 256 scale 0 size 514 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
IS_PRIMARY_SITE name (en) IS_PRIMARY_SITE name (zh) IS_PRIMARY_SITE name (fr) IS_PRIMARY_SITE name (de) IS_PRIMARY_SITE name (ja) IS_PRIMARY_SITE name (es) IS_PRIMARY_SITE Last Changed 2009-09-25T18:31:09 lastChangedBy Primary\BLAdmin(GlobalReportAdmins) externalName IS_PRIMARY_SITE usage attribute datatype int16 precision 0 scale 0 size 2 nullable false regularAggregate count semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
OM_VERSION name (en) OM_VERSION name (zh) (zh) OM_VERSION name (fr) (fr) OM_VERSION name (de) (de) OM_VERSION name (ja) (ja) OM_VERSION name (es) (es) OM_VERSION Last Changed 2011-05-06T10:53:12 lastChangedBy Primary\BLAdmin(BLAdmins) externalName OM_VERSION usage attribute datatype characterLength16 precision 255 scale 0 size 512 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0

CATALOG_UPDATE_JOB

name (en)	CATALOG_UPDATE_JOB
name (zh)	(zh) CATALOG_UPDATE_JOB
name (fr)	(fr) CATALOG_UPDATE_JOB
name (de)	(de) CATALOG_UPDATE_JOB
name (ja)	(ja) CATALOG_UPDATE_JOB
name (es)	(es) CATALOG_UPDATE_JOB
Status	valid
Last Changed	2013-07-10T12:25:38
lastChangedBy	PATCH_SITE\BLAdmin(BLAdmins)
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql Select CATALOG_UPDATE_JOB.* from [ORA75].F_JOB_RUN CATALOG_UPDATE_JOB, ( select distinct JOB_ID, BL_SITE_ID from [ORA75].B_JOB_ALLOWED_ROLE where ROLE_ID in (#$account.parameters.roleId#, 1000008) OR (#$account.parameters.roleId# in (3, 10, 11, 1000010)) ) BJAR WHERE CATALOG_UPDATE_JOB.BL_SITE_ID=BJAR.BL_SITE_ID AND CATALOG_UPDATE_JOB.JOB_ID=BJAR.JOB_ID filters filterDefinition displayName Site Access Filter expression [IL Patch].[CATALOG_UPDATE_JOB].[BL_SITE_ID] IN (#csv(split(',', $account.parameters.siteIdList))#) filterDefinition displayName Only Patch Catalog Update Job expression [IL Patch].[CATALOG_UPDATE_JOB].[OBJECT_TYPE_ID] IN (229, 232, 235, 238, 241) tableType table
JOB_RUN_HIST_ID name (en) JOB_RUN_HIST_ID name (zh) (zh) JOB_RUN_HIST_ID name (fr) (fr) JOB_RUN_HIST_ID name (de) (de) JOB_RUN_HIST_ID name (ja) (ja) JOB_RUN_HIST_ID name (es) (es) JOB_RUN_HIST_ID Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName JOB_RUN_HIST_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
JOB_RUN_ID name (en) JOB_RUN_ID name (zh) (zh) JOB_RUN_ID name (fr) (fr) JOB_RUN_ID name (de) (de) JOB_RUN_ID name (ja) (ja) JOB_RUN_ID name (es) (es) JOB_RUN_ID Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName JOB_RUN_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
JOB_HIST_ID name (en) JOB_HIST_ID name (zh) (zh) JOB_HIST_ID name (fr) (fr) JOB_HIST_ID name (de) (de) JOB_HIST_ID name (ja) (ja) JOB_HIST_ID name (es) (es) JOB_HIST_ID Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName JOB_HIST_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
JOB_ID name (en) JOB_ID name (zh) (zh) JOB_ID name (fr) (fr) JOB_ID name (de) (de) JOB_ID name (ja) (ja) JOB_ID name (es) (es) JOB_ID Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName JOB_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
APPLICATION_SERVER_ID name (en) APPLICATION_SERVER_ID name (zh) (zh) APPLICATION_SERVER_ID name (fr) (fr) APPLICATION_SERVER_ID name (de) (de) APPLICATION_SERVER_ID name (ja) (ja) APPLICATION_SERVER_ID name (es) (es) APPLICATION_SERVER_ID Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName APPLICATION_SERVER_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
ROLE_HIST_ID name (en) ROLE_HIST_ID name (zh) (zh) ROLE_HIST_ID name (fr) (fr) ROLE_HIST_ID name (de) (de) ROLE_HIST_ID name (ja) (ja) ROLE_HIST_ID name (es) (es) ROLE_HIST_ID Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName ROLE_HIST_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
USER_HIST_ID name (en) USER_HIST_ID name (zh) (zh) USER_HIST_ID name (fr) (fr) USER_HIST_ID name (de) (de) USER_HIST_ID name (ja) (ja) USER_HIST_ID name (es) (es) USER_HIST_ID Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName USER_HIST_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
OBJECT_TYPE_ID name (en) OBJECT_TYPE_ID name (zh) (zh) OBJECT_TYPE_ID name (fr) (fr) OBJECT_TYPE_ID name (de) (de) OBJECT_TYPE_ID name (ja) (ja) OBJECT_TYPE_ID name (es) (es) OBJECT_TYPE_ID Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName OBJECT_TYPE_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
PROGRESS_STATUS_ID name (en) PROGRESS_STATUS_ID name (zh) (zh) PROGRESS_STATUS_ID name (fr) (fr) PROGRESS_STATUS_ID name (de) (de) PROGRESS_STATUS_ID name (ja) (ja) PROGRESS_STATUS_ID name (es) (es) PROGRESS_STATUS_ID Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName PROGRESS_STATUS_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
START_DATE_ID name (en) START_DATE_ID name (zh) (zh) START_DATE_ID name (fr) (fr) START_DATE_ID name (de) (de) START_DATE_ID name (ja) (ja) START_DATE_ID name (es) (es) START_DATE_ID Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName START_DATE_ID usage fact datatype decimal precision 19 scale 0 size 10 nullable false regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
START_TIME_ID name (en) START_TIME_ID name (zh) (zh) START_TIME_ID name (fr) (fr) START_TIME_ID name (de) (de) START_TIME_ID name (ja) (ja) START_TIME_ID name (es) (es) START_TIME_ID Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName START_TIME_ID usage fact datatype decimal precision 19 scale 0 size 10 nullable false regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
END_DATE_ID name (en) END_DATE_ID name (zh) (zh) END_DATE_ID name (fr) (fr) END_DATE_ID name (de) (de) END_DATE_ID name (ja) (ja) END_DATE_ID name (es) (es) END_DATE_ID Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName END_DATE_ID usage fact datatype decimal precision 19 scale 0 size 10 nullable true regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
END_TIME_ID name (en) END_TIME_ID name (zh) (zh) END_TIME_ID name (fr) (fr) END_TIME_ID name (de) (de) END_TIME_ID name (ja) (ja) END_TIME_ID name (es) (es) END_TIME_ID Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName END_TIME_ID usage fact datatype decimal precision 19 scale 0 size 10 nullable true regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
RUN_START_TIME name (en) RUN_START_TIME name (zh) (zh) RUN_START_TIME name (fr) (fr) RUN_START_TIME name (de) (de) RUN_START_TIME name (ja) (ja) RUN_START_TIME name (es) (es) RUN_START_TIME Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName RUN_START_TIME usage identifier datatype dateTime precision 0 scale 0 size 12 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1
RUN_END_TIME name (en) RUN_END_TIME name (zh) (zh) RUN_END_TIME name (fr) (fr) RUN_END_TIME name (de) (de) RUN_END_TIME name (ja) (ja) RUN_END_TIME name (es) (es) RUN_END_TIME Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName RUN_END_TIME usage identifier datatype dateTime precision 0 scale 0 size 12 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1
EXECUTION_TIME name (en) EXECUTION_TIME name (zh) (zh) EXECUTION_TIME name (fr) (fr) EXECUTION_TIME name (de) (de) EXECUTION_TIME name (ja) (ja) EXECUTION_TIME name (es) (es) EXECUTION_TIME Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName EXECUTION_TIME usage fact datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
OVERALL_EXIT name (en) OVERALL_EXIT name (zh) (zh) OVERALL_EXIT name (fr) (fr) OVERALL_EXIT name (de) (de) OVERALL_EXIT name (ja) (ja) OVERALL_EXIT name (es) (es) OVERALL_EXIT Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName OVERALL_EXIT usage fact datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
IS_ERRORS name (en) IS_ERRORS name (zh) (zh) IS_ERRORS name (fr) (fr) IS_ERRORS name (de) (de) IS_ERRORS name (ja) (ja) IS_ERRORS name (es) (es) IS_ERRORS Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName IS_ERRORS usage fact datatype int16 precision 0 scale 0 size 2 nullable true regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
IS_WARNINGS name (en) IS_WARNINGS name (zh) (zh) IS_WARNINGS name (fr) (fr) IS_WARNINGS name (de) (de) IS_WARNINGS name (ja) (ja) IS_WARNINGS name (es) (es) IS_WARNINGS Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName IS_WARNINGS usage fact datatype int16 precision 0 scale 0 size 2 nullable true regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
IS_CANCELLED name (en) IS_CANCELLED name (zh) (zh) IS_CANCELLED name (fr) (fr) IS_CANCELLED name (de) (de) IS_CANCELLED name (ja) (ja) IS_CANCELLED name (es) (es) IS_CANCELLED Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName IS_CANCELLED usage fact datatype int16 precision 0 scale 0 size 2 nullable true regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
IS_REBOOT name (en) IS_REBOOT name (zh) (zh) IS_REBOOT name (fr) (fr) IS_REBOOT name (de) (de) IS_REBOOT name (ja) (ja) IS_REBOOT name (es) (es) IS_REBOOT Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName IS_REBOOT usage fact datatype int16 precision 0 scale 0 size 2 nullable true regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
IS_RESET name (en) IS_RESET name (zh) (zh) IS_RESET name (fr) (fr) IS_RESET name (de) (de) IS_RESET name (ja) (ja) IS_RESET name (es) (es) IS_RESET Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName IS_RESET usage fact datatype int16 precision 0 scale 0 size 2 nullable true regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
IN_PROGRESS_WORK_ITEMS name (en) IN_PROGRESS_WORK_ITEMS name (zh) (zh) IN_PROGRESS_WORK_ITEMS name (fr) (fr) IN_PROGRESS_WORK_ITEMS name (de) (de) IN_PROGRESS_WORK_ITEMS name (ja) (ja) IN_PROGRESS_WORK_ITEMS name (es) (es) IN_PROGRESS_WORK_ITEMS Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName IN_PROGRESS_WORK_ITEMS usage fact datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
FINISHED_WORK_ITEMS name (en) FINISHED_WORK_ITEMS name (zh) (zh) FINISHED_WORK_ITEMS name (fr) (fr) FINISHED_WORK_ITEMS name (de) (de) FINISHED_WORK_ITEMS name (ja) (ja) FINISHED_WORK_ITEMS name (es) (es) FINISHED_WORK_ITEMS Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName FINISHED_WORK_ITEMS usage fact datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
TOTAL_WORK_ITEMS name (en) TOTAL_WORK_ITEMS name (zh) (zh) TOTAL_WORK_ITEMS name (fr) (fr) TOTAL_WORK_ITEMS name (de) (de) TOTAL_WORK_ITEMS name (ja) (ja) TOTAL_WORK_ITEMS name (es) (es) TOTAL_WORK_ITEMS Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName TOTAL_WORK_ITEMS usage fact datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
DATE_MODIFIED name (en) DATE_MODIFIED name (zh) (zh) DATE_MODIFIED name (fr) (fr) DATE_MODIFIED name (de) (de) DATE_MODIFIED name (ja) (ja) DATE_MODIFIED name (es) (es) DATE_MODIFIED Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName DATE_MODIFIED usage identifier datatype dateTime precision 0 scale 0 size 12 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1
IS_DELETED name (en) IS_DELETED name (zh) (zh) IS_DELETED name (fr) (fr) IS_DELETED name (de) (de) IS_DELETED name (ja) (ja) IS_DELETED name (es) (es) IS_DELETED Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName IS_DELETED usage fact datatype int16 precision 0 scale 0 size 2 nullable false regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
IS_RUN_BY_BATCH_JOB name (en) IS_RUN_BY_BATCH_JOB name (zh) (zh) IS_RUN_BY_BATCH_JOB name (fr) (fr) IS_RUN_BY_BATCH_JOB name (de) (de) IS_RUN_BY_BATCH_JOB name (ja) (ja) IS_RUN_BY_BATCH_JOB name (es) (es) IS_RUN_BY_BATCH_JOB Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName IS_RUN_BY_BATCH_JOB usage fact datatype int16 precision 0 scale 0 size 2 nullable false regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
IS_LATEST_RUN name (en) IS_LATEST_RUN name (zh) (zh) IS_LATEST_RUN name (fr) (fr) IS_LATEST_RUN name (de) (de) IS_LATEST_RUN name (ja) (ja) IS_LATEST_RUN name (es) (es) IS_LATEST_RUN Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName IS_LATEST_RUN usage fact datatype int16 precision 0 scale 0 size 2 nullable false regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
BL_SITE_ID name (en) BL_SITE_ID name (zh) (zh) BL_SITE_ID name (fr) (fr) BL_SITE_ID name (de) (de) BL_SITE_ID name (ja) (ja) BL_SITE_ID name (es) (es) BL_SITE_ID Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName BL_SITE_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
ETL_SEQ_ID name (en) ETL_SEQ_ID name (zh) (zh) ETL_SEQ_ID name (fr) (fr) ETL_SEQ_ID name (de) (de) ETL_SEQ_ID name (ja) (ja) ETL_SEQ_ID name (es) (es) ETL_SEQ_ID Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName ETL_SEQ_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
JOB_VERSION_ID name (en) JOB_VERSION_ID name (zh) (zh) JOB_VERSION_ID name (fr) (fr) JOB_VERSION_ID name (de) (de) JOB_VERSION_ID name (ja) (ja) JOB_VERSION_ID name (es) (es) JOB_VERSION_ID Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName JOB_VERSION_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
STATUS_NAME name (en) STATUS_NAME name (zh) (zh) STATUS_NAME name (fr) (fr) STATUS_NAME name (de) (de) STATUS_NAME name (ja) (ja) STATUS_NAME name (es) (es) STATUS_NAME Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName STATUS_NAME usage attribute datatype nVarChar precision 255 scale 0 size 512 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1
JOB_TYPE name (en) JOB_TYPE name (zh) (zh) JOB_TYPE name (fr) (fr) JOB_TYPE name (de) (de) JOB_TYPE name (ja) (ja) JOB_TYPE name (es) (es) JOB_TYPE Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName JOB_TYPE usage attribute datatype nVarChar precision 255 scale 0 size 512 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1
ICON name (en) ICON name (zh) (zh) ICON name (fr) (fr) ICON name (de) (de) ICON name (ja) (ja) ICON name (es) (es) ICON Last Changed 2013-07-10T12:20:07 lastChangedBy PATCH_SITE\BLAdmin(BLAdmins) externalName ICON usage attribute datatype nVarChar precision 255 scale 0 size 512 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1

CATALOG_UPDATE_JOB <--> B_CATALOG_UPD_JOB_ASSOC

name ()	CATALOG_UPDATE_JOB <--> B_CATALOG_UPD_JOB_ASSOC
Status	valid
expression	[IL Patch].[CATALOG_UPDATE_JOB].[JOB_HIST_ID] =[IL Patch].[B_CATALOG_UPD_JOB_ASSOC].[JOB_HIST_ID]
left	refobj [IL Patch].[CATALOG_UPDATE_JOB] mincard one maxcard one
right	refobj [IL Patch].[B_CATALOG_UPD_JOB_ASSOC] mincard one maxcard one

---

Copy (2) of PATCH_REPORTS_BOOLEAN_LOOKUP <--> patch_f_job_run

name ()	Copy (2) of PATCH_REPORTS_BOOLEAN_LOOKUP <--> patch_f_job_run
Status	valid
expression	[IL Patch].[PATCH_JOB_RUN_LATEST_BOOLEAN_LOOKUP].[VAL_ID] =[IL Patch].[F_JOB_RUN].[IS_LATEST_RUN]
left	refobj [IL Patch].[PATCH_JOB_RUN_LATEST_BOOLEAN_LOOKUP] mincard one maxcard one
right	refobj [IL Patch].[F_JOB_RUN] mincard one maxcard many

---

Copy of B_BLGROUP_SERVER

name (en)	Copy of B_BLGROUP_SERVER
name (zh)	(zh) Copy of B_BLGROUP_SERVER
name (fr)	(fr) Copy of B_BLGROUP_SERVER
name (de)	(de) Copy of B_BLGROUP_SERVER
name (ja)	(ja) Copy of B_BLGROUP_SERVER
name (es)	(es) Copy of B_BLGROUP_SERVER
Status	valid
Last Changed	2011-07-08T12:10:00
lastChangedBy	OM82DEV\BLAdmin(BLAdmins)
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql Select * from [ORA75].B_BLGROUP_SERVER tableType table
BLGROUP_SERVER_ID name (en) BLGROUP_SERVER_ID name (zh) (zh) BLGROUP_SERVER_ID name (fr) (fr) BLGROUP_SERVER_ID name (de) (de) BLGROUP_SERVER_ID name (ja) (ja) BLGROUP_SERVER_ID name (es) (es) BLGROUP_SERVER_ID Last Changed 2011-07-08T12:16:31 lastChangedBy OM82DEV\BLAdmin(BLAdmins) externalName BLGROUP_SERVER_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1
GROUP_HIST_ID name (en) GROUP_HIST_ID name (zh) (zh) GROUP_HIST_ID name (fr) (fr) GROUP_HIST_ID name (de) (de) GROUP_HIST_ID name (ja) (ja) GROUP_HIST_ID name (es) (es) GROUP_HIST_ID Last Changed 2011-07-08T12:23:42 lastChangedBy OM82DEV\BLAdmin(BLAdmins) externalName GROUP_HIST_ID usage attribute datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1
SERVER_HIST_ID name (en) SERVER_HIST_ID name (zh) (zh) SERVER_HIST_ID name (fr) (fr) SERVER_HIST_ID name (de) (de) SERVER_HIST_ID name (ja) (ja) SERVER_HIST_ID name (es) (es) SERVER_HIST_ID Last Changed 2011-07-08T12:16:44 lastChangedBy OM82DEV\BLAdmin(BLAdmins) externalName SERVER_HIST_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1
START_DATETIME name (en) START_DATETIME name (zh) (zh) START_DATETIME name (fr) (fr) START_DATETIME name (de) (de) START_DATETIME name (ja) (ja) START_DATETIME name (es) (es) START_DATETIME Last Changed 2011-07-08T12:09:59 lastChangedBy OM82DEV\BLAdmin(BLAdmins) externalName START_DATETIME usage identifier datatype dateTime precision 0 scale 0 size 12 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1
END_DATETIME name (en) END_DATETIME name (zh) (zh) END_DATETIME name (fr) (fr) END_DATETIME name (de) (de) END_DATETIME name (ja) (ja) END_DATETIME name (es) (es) END_DATETIME Last Changed 2011-07-08T12:09:59 lastChangedBy OM82DEV\BLAdmin(BLAdmins) externalName END_DATETIME usage identifier datatype dateTime precision 0 scale 0 size 12 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1
IS_DELETED name (en) IS_DELETED name (zh) (zh) IS_DELETED name (fr) (fr) IS_DELETED name (de) (de) IS_DELETED name (ja) (ja) IS_DELETED name (es) (es) IS_DELETED Last Changed 2011-07-08T12:17:09 lastChangedBy OM82DEV\BLAdmin(BLAdmins) externalName IS_DELETED usage attribute datatype int16 precision 0 scale 0 size 2 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1
SERVER_ID name (en) SERVER_ID name (zh) (zh) SERVER_ID name (fr) (fr) SERVER_ID name (de) (de) SERVER_ID name (ja) (ja) SERVER_ID name (es) (es) SERVER_ID Last Changed 2011-07-08T12:17:15 lastChangedBy OM82DEV\BLAdmin(BLAdmins) externalName SERVER_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1
BL_SITE_ID name (en) BL_SITE_ID name (zh) (zh) BL_SITE_ID name (fr) (fr) BL_SITE_ID name (de) (de) BL_SITE_ID name (ja) (ja) BL_SITE_ID name (es) (es) BL_SITE_ID Last Changed 2011-07-08T12:17:17 lastChangedBy OM82DEV\BLAdmin(BLAdmins) externalName BL_SITE_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1

Copy of B_BLGROUP_SERVER <--> D_SERVER_SMART_GROUP

name ()	Copy of B_BLGROUP_SERVER <--> D_SERVER_SMART_GROUP
Status	valid
expression	[IL Patch].[Copy of B_BLGROUP_SERVER].[GROUP_HIST_ID] =[IL Patch].[D_SERVER_SMART_GROUP].[GROUP_HIST_ID]
left	refobj [IL Patch].[Copy of B_BLGROUP_SERVER] mincard one maxcard one
right	refobj [IL Patch].[D_SERVER_SMART_GROUP] mincard one maxcard one

---

Copy of Copy (2) of BL_PATCH_JOB_RES_SERVER_CNT <--> patch_f_job_run

name ()	Copy of Copy (2) of BL_PATCH_JOB_RES_SERVER_CNT <--> patch_f_job_run
Status	valid
expression	[IL Patch].[F_PATCH_ANALYSIS_RESULT_ASMRY].[JOB_RUN_HIST_ID] =[IL Patch].[F_JOB_RUN].[JOB_RUN_HIST_ID] AND[IL Patch].[F_PATCH_ANALYSIS_RESULT_ASMRY].[JOB_HIST_ID] =[IL Patch].[F_JOB_RUN].[JOB_HIST_ID]
left	refobj [IL Patch].[F_PATCH_ANALYSIS_RESULT_ASMRY] mincard one maxcard many
right	refobj [IL Patch].[F_JOB_RUN] mincard one maxcard one

---

Copy of Copy (2) of Patch Job <--> patch_f_job_run

name ()	Copy of Copy (2) of Patch Job <--> patch_f_job_run
Status	valid
expression	[IL Patch].[D_JOB].[JOB_HIST_ID] =[IL Patch].[F_JOB_RUN].[JOB_HIST_ID]
left	refobj [IL Patch].[D_JOB] mincard one maxcard one
right	refobj [IL Patch].[F_JOB_RUN] mincard one maxcard many

---

Copy of Copy of Copy of Copy of Patch Server <--> Patch Server Group

name ()	Copy of Copy of Copy of Copy of Patch Server <--> Patch Server Group
Status	valid
expression	[IL Patch].[D_SERVER].[SERVER_HIST_ID] =[IL Patch].[Copy of B_BLGROUP_SERVER].[SERVER_HIST_ID]
left	refobj [IL Patch].[D_SERVER] mincard one maxcard one
right	refobj [IL Patch].[Copy of B_BLGROUP_SERVER] mincard one maxcard one

---

Copy of Copy of Copy of Patch Server <--> Patch Server Group

name ()	Copy of Copy of Copy of Patch Server <--> Patch Server Group
Status	valid
expression	[IL Patch].[D_SERVER].[SERVER_HIST_ID] =[IL Patch].[B_BLGROUP_SERVER].[SERVER_HIST_ID]
left	refobj [IL Patch].[D_SERVER] mincard one maxcard one
right	refobj [IL Patch].[B_BLGROUP_SERVER] mincard one maxcard one

---

Copy of Copy of Patch_OBJECT_TYPE <--> Patch_ D_DEPOT_OBJECT

name ()	Copy of Copy of Patch_OBJECT_TYPE <--> Patch_ D_DEPOT_OBJECT
Status	valid
expression	[IL Patch].[PATCH_OBJECT_TYPE].[OBJECT_TYPE_ID] =[IL Patch].[PATCH_D_DEPOT_OBJECT].[OBJECT_TYPE_ID]
left	refobj [IL Patch].[PATCH_OBJECT_TYPE] mincard zero maxcard one
right	refobj [IL Patch].[PATCH_D_DEPOT_OBJECT] mincard one maxcard many

---

D_BLGROUP

name (en)	D_BLGROUP
name (zh)	(zh) New Query Subject10
name (fr)	(fr) New Query Subject10
name (de)	(de) New Query Subject10
name (ja)	(ja) New Query Subject10
name (es)	(es) New Query Subject10
Status	valid
Last Changed	2015-02-19T16:10:16
lastChangedBy	Primary\BLAdmin(BLAdmins)
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql Select * from D_BLGROUP filters filterDefinition displayName Site Access Filter expression [IL Patch].[D_BLGROUP].[BL_SITE_ID] IN (#csv(split(',', $account.parameters.siteIdList))#) filterDefinition displayName Catalog Group Filter expression [IL Patch].[D_BLGROUP].[GROUP_TYPE_NAME] in ('AIX Patch Catalog', 'Windows Patch Catalog', 'Linux Patch Catalog', 'Solaris Patch Catalog','Suse Patch Catalog','Ubuntu Patch Catalog') tableType table
determinants
GROUP_HIST_ID name (en) GROUP_HIST_ID name (zh) (zh) GROUP_HIST_ID name (fr) (fr) GROUP_HIST_ID name (de) (de) GROUP_HIST_ID name (ja) (ja) GROUP_HIST_ID name (es) (es) GROUP_HIST_ID Last Changed 2011-07-28T17:41:15 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName GROUP_HIST_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
GROUP_ID name (en) GROUP_ID name (zh) (zh) GROUP_ID name (fr) (fr) GROUP_ID name (de) (de) GROUP_ID name (ja) (ja) GROUP_ID name (es) (es) GROUP_ID Last Changed 2011-07-28T17:41:17 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName GROUP_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
PARENT_GROUP_ID name (en) PARENT_GROUP_ID name (zh) (zh) PARENT_GROUP_ID name (fr) (fr) PARENT_GROUP_ID name (de) (de) PARENT_GROUP_ID name (ja) (ja) PARENT_GROUP_ID name (es) (es) PARENT_GROUP_ID Last Changed 2011-07-28T17:41:17 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName PARENT_GROUP_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
GROUP_TYPE_NAME name (en) GROUP_TYPE_NAME name (zh) (zh) GROUP_TYPE_NAME name (fr) (fr) GROUP_TYPE_NAME name (de) (de) GROUP_TYPE_NAME name (ja) (ja) GROUP_TYPE_NAME name (es) (es) GROUP_TYPE_NAME Last Changed 2011-07-28T17:41:30 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName GROUP_TYPE_NAME usage identifier datatype characterLength16 precision 50 scale 0 size 102 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
PARENT_GROUP_PATH name (en) PARENT_GROUP_PATH name (zh) (zh) PARENT_GROUP_PATH name (fr) (fr) PARENT_GROUP_PATH name (de) (de) PARENT_GROUP_PATH name (ja) (ja) PARENT_GROUP_PATH name (es) (es) PARENT_GROUP_PATH Last Changed 2011-07-28T17:40:44 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName PARENT_GROUP_PATH usage attribute datatype characterLength16 precision 2000 scale 0 size 4002 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
CREATED_BY_ROLE_ID name (en) CREATED_BY_ROLE_ID name (zh) (zh) CREATED_BY_ROLE_ID name (fr) (fr) CREATED_BY_ROLE_ID name (de) (de) CREATED_BY_ROLE_ID name (ja) (ja) CREATED_BY_ROLE_ID name (es) (es) CREATED_BY_ROLE_ID Last Changed 2011-07-28T17:42:01 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName CREATED_BY_ROLE_ID usage attribute datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate count semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
FQ_PATH name (en) FQ_PATH name (zh) (zh) FQ_PATH name (fr) (fr) FQ_PATH name (de) (de) FQ_PATH name (ja) (ja) FQ_PATH name (es) (es) FQ_PATH Last Changed 2011-07-28T17:40:44 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName FQ_PATH usage attribute datatype characterLength16 precision 2000 scale 0 size 4002 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
CREATED_BY_USER_ID name (en) CREATED_BY_USER_ID name (zh) (zh) CREATED_BY_USER_ID name (fr) (fr) CREATED_BY_USER_ID name (de) (de) CREATED_BY_USER_ID name (ja) (ja) CREATED_BY_USER_ID name (es) (es) CREATED_BY_USER_ID Last Changed 2011-07-28T17:42:03 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName CREATED_BY_USER_ID usage attribute datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate count semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
MODIFIED_BY_ROLE_ID name (en) MODIFIED_BY_ROLE_ID name (zh) (zh) MODIFIED_BY_ROLE_ID name (fr) (fr) MODIFIED_BY_ROLE_ID name (de) (de) MODIFIED_BY_ROLE_ID name (ja) (ja) MODIFIED_BY_ROLE_ID name (es) (es) MODIFIED_BY_ROLE_ID Last Changed 2011-07-28T17:42:03 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName MODIFIED_BY_ROLE_ID usage attribute datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate count semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
MODIFIED_BY_USER_ID name (en) MODIFIED_BY_USER_ID name (zh) (zh) MODIFIED_BY_USER_ID name (fr) (fr) MODIFIED_BY_USER_ID name (de) (de) MODIFIED_BY_USER_ID name (ja) (ja) MODIFIED_BY_USER_ID name (es) (es) MODIFIED_BY_USER_ID Last Changed 2011-07-28T17:42:03 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName MODIFIED_BY_USER_ID usage attribute datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate count semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
BL_ACL_ID name (en) BL_ACL_ID name (zh) (zh) BL_ACL_ID name (fr) (fr) BL_ACL_ID name (de) (de) BL_ACL_ID name (ja) (ja) BL_ACL_ID name (es) (es) BL_ACL_ID Last Changed 2011-07-28T17:42:03 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName BL_ACL_ID usage attribute datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
NAME name (en) NAME name (zh) (zh) NAME name (fr) (fr) NAME name (de) (de) NAME name (ja) (ja) NAME name (es) (es) NAME Last Changed 2011-07-28T17:40:44 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName NAME usage attribute datatype characterLength16 precision 255 scale 0 size 512 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
DESCRIPTION name (en) DESCRIPTION name (zh) (zh) DESCRIPTION name (fr) (fr) DESCRIPTION name (de) (de) DESCRIPTION name (ja) (ja) DESCRIPTION name (es) (es) DESCRIPTION Last Changed 2011-07-28T17:40:44 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName DESCRIPTION usage attribute datatype characterLength16 precision 255 scale 0 size 512 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
DATE_CREATED name (en) DATE_CREATED name (zh) (zh) DATE_CREATED name (fr) (fr) DATE_CREATED name (de) (de) DATE_CREATED name (ja) (ja) DATE_CREATED name (es) (es) DATE_CREATED Last Changed 2011-07-28T17:40:44 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName DATE_CREATED usage identifier datatype dateTime precision 0 scale 0 size 12 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
DATE_MODIFIED name (en) DATE_MODIFIED name (zh) (zh) DATE_MODIFIED name (fr) (fr) DATE_MODIFIED name (de) (de) DATE_MODIFIED name (ja) (ja) DATE_MODIFIED name (es) (es) DATE_MODIFIED Last Changed 2011-07-28T17:40:44 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName DATE_MODIFIED usage identifier datatype dateTime precision 0 scale 0 size 12 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
IS_MATCH_ALL_CONDITIONS name (en) IS_MATCH_ALL_CONDITIONS name (zh) (zh) IS_MATCH_ALL_CONDITIONS name (fr) (fr) IS_MATCH_ALL_CONDITIONS name (de) (de) IS_MATCH_ALL_CONDITIONS name (ja) (ja) IS_MATCH_ALL_CONDITIONS name (es) (es) IS_MATCH_ALL_CONDITIONS Last Changed 2011-07-28T17:42:03 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName IS_MATCH_ALL_CONDITIONS usage attribute datatype int16 precision 0 scale 0 size 2 nullable true regularAggregate count semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
IS_DELETED name (en) IS_DELETED name (zh) (zh) IS_DELETED name (fr) (fr) IS_DELETED name (de) (de) IS_DELETED name (ja) (ja) IS_DELETED name (es) (es) IS_DELETED Last Changed 2011-07-28T17:42:03 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName IS_DELETED usage attribute datatype int16 precision 0 scale 0 size 2 nullable false regularAggregate count semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
BL_SITE_ID name (en) BL_SITE_ID name (zh) (zh) BL_SITE_ID name (fr) (fr) BL_SITE_ID name (de) (de) BL_SITE_ID name (ja) (ja) BL_SITE_ID name (es) (es) BL_SITE_ID Last Changed 2011-07-28T17:42:12 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName BL_SITE_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
IS_LATEST_VERSION name (en) IS_LATEST_VERSION name (zh) (zh) IS_LATEST_VERSION name (fr) (fr) IS_LATEST_VERSION name (de) (de) IS_LATEST_VERSION name (ja) (ja) IS_LATEST_VERSION name (es) (es) IS_LATEST_VERSION Last Changed 2011-07-28T17:42:03 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName IS_LATEST_VERSION usage attribute datatype int16 precision 0 scale 0 size 2 nullable false regularAggregate count semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
START_DATETIME name (en) START_DATETIME name (zh) (zh) START_DATETIME name (fr) (fr) START_DATETIME name (de) (de) START_DATETIME name (ja) (ja) START_DATETIME name (es) (es) START_DATETIME Last Changed 2011-07-28T17:40:44 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName START_DATETIME usage identifier datatype dateTime precision 0 scale 0 size 12 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0
END_DATETIME name (en) END_DATETIME name (zh) (zh) END_DATETIME name (fr) (fr) END_DATETIME name (de) (de) END_DATETIME name (ja) (ja) END_DATETIME name (es) (es) END_DATETIME Last Changed 2011-07-28T17:40:44 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName END_DATETIME usage identifier datatype dateTime precision 0 scale 0 size 12 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8ISO8859P1 collationSequenceLevel 0