IL Compliance Last Changed: 2011-04-01T18:39:46

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-08-16T14:47:08
lastChangedBy	primary\BLAdmin(BLAdmins-rename)
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-08-16T14:47:07 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName BLGROUP_SERVER_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 2011-08-16T14:47:07 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName GROUP_HIST_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum 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-08-16T14:47:07 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName SERVER_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 2011-08-16T14:47:07 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 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-08-16T14:47:07 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 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-08-16T14:47:07 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName IS_DELETED usage fact datatype int16 precision 0 scale 0 size 2 nullable false regularAggregate sum semiAggregate sum 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-08-16T14:47:07 lastChangedBy primary\BLAdmin(BLAdmins-rename) externalName SERVER_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 2011-08-16T14:47:07 lastChangedBy primary\BLAdmin(BLAdmins-rename) 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_BLGROUP_SERVER <--> D_BLGROUP_SER_SMART_GROUP

name ()	B_BLGROUP_SERVER <--> D_BLGROUP_SER_SMART_GROUP
Status	valid
expression	[IL Compliance].[B_BLGROUP_SERVER].[GROUP_HIST_ID] =[IL Compliance].[D_BLGROUP_SER_SMART_GROUP].[GROUP_HIST_ID]
left	refobj [IL Compliance].[B_BLGROUP_SERVER] mincard one maxcard one
right	refobj [IL Compliance].[D_BLGROUP_SER_SMART_GROUP] mincard one maxcard one

---

B_BLGROUP_SERVER <--> D_BLGROUP_SERVER_GROUP

name ()	B_BLGROUP_SERVER <--> D_BLGROUP_SERVER_GROUP
Status	valid
expression	[IL Compliance].[B_BLGROUP_SERVER].[GROUP_HIST_ID] =[IL Compliance].[D_BLGROUP_SERVER_GROUP].[GROUP_HIST_ID]
left	refobj [IL Compliance].[B_BLGROUP_SERVER] mincard one maxcard one
right	refobj [IL Compliance].[D_BLGROUP_SERVER_GROUP] mincard one maxcard one

---

B_COMP_RULE_CR_GROUP

name (en)	B_COMP_RULE_CR_GROUP
name (zh)	B_COMP_RULE_CR_GROUP
name (fr)	B_COMP_RULE_CR_GROUP
name (de)	B_COMP_RULE_CR_GROUP
name (ja)	B_COMP_RULE_CR_GROUP
name (es)	B_COMP_RULE_CR_GROUP
Status	valid
Last Changed	2007-10-11T15:56:02
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql Select * from [ORA75].B_COMP_RULE_CR_GROUP tableType table
determinants	determinant name () COMP_RULE_GROUP_ID key refobj [IL Compliance].[B_COMP_RULE_CR_GROUP].[COMP_RULE_GROUP_ID] attributes refobj [IL Compliance].[B_COMP_RULE_CR_GROUP].[COMPLIANCE_RULE_HIST_ID] refobj [IL Compliance].[B_COMP_RULE_CR_GROUP].[CR_GROUP_HIST_ID] refobj [IL Compliance].[B_COMP_RULE_CR_GROUP].[END_DATETIME] refobj [IL Compliance].[B_COMP_RULE_CR_GROUP].[IS_DELETED] refobj [IL Compliance].[B_COMP_RULE_CR_GROUP].[START_DATETIME] canGroup false identifiesRow true
COMP_RULE_GROUP_ID name (en) COMP_RULE_GROUP_ID name (zh) COMP_RULE_GROUP_ID name (fr) COMP_RULE_GROUP_ID name (de) COMP_RULE_GROUP_ID name (ja) COMP_RULE_GROUP_ID name (es) COMP_RULE_GROUP_ID Last Changed 2007-10-11T15:56:02 externalName COMP_RULE_GROUP_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName EN_OR_WE8MSWIN1252 collationSequenceLevel 2
CR_GROUP_HIST_ID name (en) CR_GROUP_HIST_ID name (zh) CR_GROUP_HIST_ID name (fr) CR_GROUP_HIST_ID name (de) CR_GROUP_HIST_ID name (ja) CR_GROUP_HIST_ID name (es) CR_GROUP_HIST_ID Last Changed 2007-10-11T15:56:02 externalName CR_GROUP_HIST_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName EN_OR_WE8MSWIN1252 collationSequenceLevel 2
COMPLIANCE_RULE_HIST_ID name (en) COMPLIANCE_RULE_HIST_ID name (zh) COMPLIANCE_RULE_HIST_ID name (fr) COMPLIANCE_RULE_HIST_ID name (de) COMPLIANCE_RULE_HIST_ID name (ja) COMPLIANCE_RULE_HIST_ID name (es) COMPLIANCE_RULE_HIST_ID Last Changed 2007-10-11T15:56:02 externalName COMPLIANCE_RULE_HIST_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName EN_OR_WE8MSWIN1252 collationSequenceLevel 2
IS_DELETED name (en) IS_DELETED name (zh) IS_DELETED name (fr) IS_DELETED name (de) IS_DELETED name (ja) IS_DELETED name (es) IS_DELETED Last Changed 2007-10-11T15:58:46 externalName IS_DELETED usage attribute datatype int16 precision 0 scale 0 size 2 nullable false regularAggregate count semiAggregate unsupported collationSequenceName EN_OR_WE8MSWIN1252 collationSequenceLevel 2
START_DATETIME name (en) START_DATETIME name (zh) START_DATETIME name (fr) START_DATETIME name (de) START_DATETIME name (ja) START_DATETIME name (es) START_DATETIME Last Changed 2007-10-11T15:56:02 externalName START_DATETIME usage identifier datatype dateTime precision 0 scale 0 size 12 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8MSWIN1252 collationSequenceLevel 2
END_DATETIME name (en) END_DATETIME name (zh) END_DATETIME name (fr) END_DATETIME name (de) END_DATETIME name (ja) END_DATETIME name (es) END_DATETIME Last Changed 2007-10-11T15:56:02 externalName END_DATETIME usage identifier datatype dateTime precision 0 scale 0 size 12 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8MSWIN1252 collationSequenceLevel 2

BL_SITE

name (en)	BL_SITE
name (zh)	兼容性服务器站点
name (fr)	Conformité - site de serveur
name (de)	Compliance-Server-Site
name (ja)	コンプライアンス サーバ
name (es)	Sitio de servidor de cumplimiento
Status	valid
Last Changed	2011-04-09T12:20:02
lastChangedBy	Primary\BLAdmin(BLAdmins)
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql Select * from BL_SITE filters filterDefinition displayName Site Access Filter expression [IL Compliance].[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 2010-02-05T15:58:46 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName BL_SITE_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum collationSequenceName EN_OR_WE8MSWIN1252 collationSequenceLevel 0 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
NAME name (en) NAME name (zh) 名称 name (fr) NOM name (de) NAME name (ja) 名前 name (es) NOMBRE Last Changed 2010-02-05T15:58:46 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName NAME usage attribute datatype characterLength16 precision 64 scale 0 size 130 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8MSWIN1252 collationSequenceLevel 0 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
DESCRIPTION name (en) DESCRIPTION name (zh) 描述 name (fr) DESCRIPTION name (de) BESCHREIBUNG name (ja) 説明 name (es) DESCRIPCIÓN Last Changed 2010-02-05T15:58:46 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName DESCRIPTION usage attribute datatype characterLength16 precision 256 scale 0 size 514 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName EN_OR_WE8MSWIN1252 collationSequenceLevel 0 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
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 2010-02-05T15:58:46 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName IS_PRIMARY_SITE usage fact datatype int16 precision 0 scale 0 size 2 nullable false regularAggregate sum semiAggregate sum collationSequenceName EN_OR_WE8MSWIN1252 collationSequenceLevel 0 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
OM_VERSION name (en) OM_VERSION name (zh) OM_VERSION name (fr) OM_VERSION name (de) OM_VERSION name (ja) OM_VERSION name (es) OM_VERSION Last Changed 2010-10-14T17:33:33 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_WE8MSWIN1252 collationSequenceLevel 0

Compliance Compoenent <--> F_COMPLIANCE_RULE_RESULT

name ()	Compliance Compoenent <--> F_COMPLIANCE_RULE_RESULT
Status	valid
expression	[IL Compliance].[D_COMPONENT].[COMPONENT_HIST_ID] =[IL Compliance].[F_COMPLIANCE_RULE_RESULT].[COMPONENT_HIST_ID]
left	refobj [IL Compliance].[D_COMPONENT] mincard one maxcard one
right	refobj [IL Compliance].[F_COMPLIANCE_RULE_RESULT] mincard one maxcard many

---

Compliance Compoenent <--> F_COMPONENT_EXCEPTION

name ()	Compliance Compoenent <--> F_COMPONENT_EXCEPTION
Status	valid
expression	[IL Compliance].[D_COMPONENT].[COMPONENT_HIST_ID] =[IL Compliance].[F_DCOMPONENT_EXCEPTION].[COMPONENT_HIST_ID]
left	refobj [IL Compliance].[D_COMPONENT] mincard one maxcard one
right	refobj [IL Compliance].[F_DCOMPONENT_EXCEPTION] mincard one maxcard many

---

Compliance Create Role <--> Compliance Compoenent

name ()	Compliance Create Role <--> Compliance Compoenent
Status	valid
expression	[IL Compliance].[Component Created D_BLROLE].[ROLE_ID] =[IL Compliance].[D_COMPONENT].[CREATED_BY_ROLE_ID] AND[IL Compliance].[Component Created D_BLROLE].[BL_SITE_ID] =[IL Compliance].[D_COMPONENT].[BL_SITE_ID] and [IL Compliance].[Component Created D_BLROLE].[IS_LATEST_VERSION] =1
left	refobj [IL Compliance].[Component Created D_BLROLE] mincard one maxcard one
right	refobj [IL Compliance].[D_COMPONENT] mincard one maxcard many

---

Compliance Created User <--> Compliance Compoenent

name ()	Compliance Created User <--> Compliance Compoenent
Status	valid
expression	[IL Compliance].[Component Created D_BLUSER].[USER_ID] =[IL Compliance].[D_COMPONENT].[CREATED_BY_USER_ID] AND[IL Compliance].[Component Created D_BLUSER].[BL_SITE_ID] =[IL Compliance].[D_COMPONENT].[BL_SITE_ID] and [IL Compliance].[Component Created D_BLUSER].[IS_LATEST_VERSION] =1
left	refobj [IL Compliance].[Component Created D_BLUSER] mincard one maxcard one
right	refobj [IL Compliance].[D_COMPONENT] mincard one maxcard many

---

Compliance OS->Compliance_SERVER

name ()	Compliance OS->Compliance_SERVER
Status	valid
expression	[IL Compliance].[OS].[OS_ID] =[IL Compliance].[D_SERVER].[OS_ID]
left	refobj [IL Compliance].[OS] mincard one maxcard one
right	refobj [IL Compliance].[D_SERVER] mincard one maxcard one

---

Compliance Run By User <--> F_JOB_RUN

name ()	Compliance Run By User <--> F_JOB_RUN
Status	valid
expression	[IL Compliance].[Compliance Run D_BLUSER].[USER_HIST_ID] =[IL Compliance].[F_JOB_RUN].[USER_HIST_ID]
left	refobj [IL Compliance].[Compliance Run D_BLUSER] mincard one maxcard one
right	refobj [IL Compliance].[F_JOB_RUN] mincard one maxcard many

---

Compliance Run D_BLROLE

name (en)	Compliance Run D_BLROLE
name (zh)	兼容性运行者角色
name (fr)	Conformité - exécution par rôle
name (de)	Compliance – Ausgeführt durch Rolle
name (ja)	コンプライアンス 実行したロール
name (es)	Ejecución por función de cumplimiento
Status	valid
Last Changed	2011-04-09T12:21:30
lastChangedBy	Primary\BLAdmin(BLAdmins)
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql Select * from D_BLROLE filters filterDefinition displayName Site Access Filter expression [IL Compliance].[Compliance Run D_BLROLE].[BL_SITE_ID] IN (#csv(split(',', $account.parameters.siteIdList))#) filterDefinition displayName Valid Role expression [IL Compliance].[Compliance Run D_BLROLE].[ROLE_ID] <>1000011 and [IL Compliance].[Compliance Run D_BLROLE].[ROLE_ID] <>1999999 tableType table
ROLE_HIST_ID name (en) ROLE_HIST_ID name (zh) ROLE_HIST_ID name (fr) ROLE_HIST_ID name (de) ROLE_HIST_ID name (ja) ROLE_HIST_ID name (es) ROLE_HIST_ID Last Changed 2010-02-16T19:04:51 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName ROLE_HIST_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
ROLE_ID name (en) ROLE_ID name (zh) ROLE_ID name (fr) ROLE_ID name (de) ROLE_ID name (ja) ROLE_ID name (es) ROLE_ID Last Changed 2010-02-16T19:04:53 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName ROLE_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
BL_VALUE_ID name (en) BL_VALUE_ID name (zh) BL_VALUE_ID name (fr) BL_VALUE_ID name (de) BL_VALUE_ID name (ja) BL_VALUE_ID name (es) BL_VALUE_ID Last Changed 2010-02-16T19:04:53 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName BL_VALUE_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
CREATED_BY_ROLE_ID name (en) CREATED_BY_ROLE_ID name (zh) CREATED_BY_ROLE_ID name (fr) CREATED_BY_ROLE_ID name (de) CREATED_BY_ROLE_ID name (ja) CREATED_BY_ROLE_ID name (es) CREATED_BY_ROLE_ID Last Changed 2010-02-16T19:04:53 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName CREATED_BY_ROLE_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
CREATED_BY_USER_ID name (en) CREATED_BY_USER_ID name (zh) CREATED_BY_USER_ID name (fr) CREATED_BY_USER_ID name (de) CREATED_BY_USER_ID name (ja) CREATED_BY_USER_ID name (es) CREATED_BY_USER_ID Last Changed 2010-02-16T19:04:53 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName CREATED_BY_USER_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
MODIFIED_BY_ROLE_ID name (en) MODIFIED_BY_ROLE_ID name (zh) MODIFIED_BY_ROLE_ID name (fr) MODIFIED_BY_ROLE_ID name (de) MODIFIED_BY_ROLE_ID name (ja) MODIFIED_BY_ROLE_ID name (es) MODIFIED_BY_ROLE_ID Last Changed 2010-02-16T19:04:53 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName MODIFIED_BY_ROLE_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
MODIFIED_BY_USER_ID name (en) MODIFIED_BY_USER_ID name (zh) MODIFIED_BY_USER_ID name (fr) MODIFIED_BY_USER_ID name (de) MODIFIED_BY_USER_ID name (ja) MODIFIED_BY_USER_ID name (es) MODIFIED_BY_USER_ID Last Changed 2010-02-16T19:04:53 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName MODIFIED_BY_USER_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
BL_ACL_ID name (en) BL_ACL_ID name (zh) BL_ACL_ID name (fr) BL_ACL_ID name (de) BL_ACL_ID name (ja) BL_ACL_ID name (es) BL_ACL_ID Last Changed 2010-02-16T19:04:53 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName BL_ACL_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
BL_ACL_TEMPLATE_ID name (en) BL_ACL_TEMPLATE_ID name (zh) BL_ACL_TEMPLATE_ID name (fr) BL_ACL_TEMPLATE_ID name (de) BL_ACL_TEMPLATE_ID name (ja) BL_ACL_TEMPLATE_ID name (es) BL_ACL_TEMPLATE_ID Last Changed 2010-02-16T19:04:53 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName BL_ACL_TEMPLATE_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
DESCRIPTION name (en) DESCRIPTION name (zh) 描述 name (fr) DESCRIPTION name (de) BESCHREIBUNG name (ja) 説明 name (es) DESCRIPCIÓN Last Changed 2010-02-16T16:45:39 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName DESCRIPTION usage attribute datatype nVarChar precision 255 scale 0 size 512 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
NAME name (en) NAME name (zh) 名称 name (fr) NOM name (de) NAME name (ja) 名前 name (es) NOMBRE Last Changed 2010-02-16T16:45:39 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName NAME usage attribute datatype nVarChar precision 255 scale 0 size 512 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
IS_ENABLED name (en) IS_ENABLED name (zh) IS_ENABLED name (fr) IS_ENABLED name (de) IS_ENABLED name (ja) IS_ENABLED name (es) IS_ENABLED Last Changed 2010-02-16T19:05:00 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName IS_ENABLED usage attribute datatype int16 precision 0 scale 0 size 2 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
IS_SYSTEM_ROLE name (en) IS_SYSTEM_ROLE name (zh) IS_SYSTEM_ROLE name (fr) IS_SYSTEM_ROLE name (de) IS_SYSTEM_ROLE name (ja) IS_SYSTEM_ROLE name (es) IS_SYSTEM_ROLE Last Changed 2010-02-16T16:45:39 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName IS_SYSTEM_ROLE usage fact datatype int16 precision 0 scale 0 size 2 nullable false regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
DATE_CREATED name (en) DATE_CREATED name (zh) DATE_CREATED name (fr) DATE_CREATED name (de) DATE_CREATED name (ja) DATE_CREATED name (es) DATE_CREATED Last Changed 2010-02-16T16:45:39 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName DATE_CREATED usage identifier datatype dateTime precision 0 scale 0 size 12 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
DATE_MODIFIED name (en) DATE_MODIFIED name (zh) DATE_MODIFIED name (fr) DATE_MODIFIED name (de) DATE_MODIFIED name (ja) DATE_MODIFIED name (es) DATE_MODIFIED Last Changed 2010-02-16T16:45:39 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName DATE_MODIFIED usage identifier datatype dateTime precision 0 scale 0 size 12 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
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 2010-02-16T19:04:53 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName BL_SITE_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
IS_DELETED name (en) IS_DELETED name (zh) IS_DELETED name (fr) IS_DELETED name (de) IS_DELETED name (ja) IS_DELETED name (es) IS_DELETED Last Changed 2010-02-16T19:05:01 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName IS_DELETED usage attribute datatype int16 precision 0 scale 0 size 2 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
IS_LATEST_VERSION name (en) IS_LATEST_VERSION name (zh) IS_LATEST_VERSION name (fr) IS_LATEST_VERSION name (de) IS_LATEST_VERSION name (ja) IS_LATEST_VERSION name (es) IS_LATEST_VERSION Last Changed 2010-02-16T19:05:01 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName IS_LATEST_VERSION usage attribute datatype int16 precision 0 scale 0 size 2 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
START_DATETIME name (en) START_DATETIME name (zh) START_DATETIME name (fr) START_DATETIME name (de) START_DATETIME name (ja) START_DATETIME name (es) START_DATETIME Last Changed 2010-02-16T16:45:39 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName START_DATETIME usage identifier datatype dateTime precision 0 scale 0 size 12 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
END_DATETIME name (en) END_DATETIME name (zh) END_DATETIME name (fr) END_DATETIME name (de) END_DATETIME name (ja) END_DATETIME name (es) END_DATETIME Last Changed 2010-02-16T16:45:39 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName END_DATETIME usage identifier datatype dateTime precision 0 scale 0 size 12 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS

Compliance Run D_BLUSER

name (en)	Compliance Run D_BLUSER
name (zh)	兼容性运行者用户
name (fr)	Conformité - exécution par utilisateur
name (de)	Compliance – Ausgeführt durch Benutzer
name (ja)	コンプライアンス 実行したユーザ
name (es)	Ejecución por usuario de cumplimiento
Status	valid
Last Changed	2011-04-09T12:21:43
lastChangedBy	Primary\BLAdmin(BLAdmins)
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql Select * from D_BLUSER filters filterDefinition displayName Site acees Filter expression [IL Compliance].[Compliance Run D_BLUSER].[BL_SITE_ID] IN (#csv(split(',', $account.parameters.siteIdList))#) filterDefinition displayName Valid User expression [IL Compliance].[Compliance Run D_BLUSER].[USER_ID] <>1000011 and [IL Compliance].[Compliance Run D_BLUSER].[USER_ID] <>1999999 tableType table
USER_HIST_ID name (en) USER_HIST_ID name (zh) USER_HIST_ID name (fr) USER_HIST_ID name (de) USER_HIST_ID name (ja) USER_HIST_ID name (es) USER_HIST_ID Last Changed 2010-02-16T19:03:07 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName USER_HIST_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
USER_ID name (en) USER_ID name (zh) USER_ID name (fr) USER_ID name (de) USER_ID name (ja) USER_ID name (es) USER_ID Last Changed 2010-02-16T19:03:09 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName USER_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
BL_VALUE_ID name (en) BL_VALUE_ID name (zh) BL_VALUE_ID name (fr) BL_VALUE_ID name (de) BL_VALUE_ID name (ja) BL_VALUE_ID name (es) BL_VALUE_ID Last Changed 2010-02-16T19:03:09 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName BL_VALUE_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
DEFAULT_ROLE_ID name (en) DEFAULT_ROLE_ID name (zh) DEFAULT_ROLE_ID name (fr) DEFAULT_ROLE_ID name (de) DEFAULT_ROLE_ID name (ja) DEFAULT_ROLE_ID name (es) DEFAULT_ROLE_ID Last Changed 2010-02-16T19:03:09 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName DEFAULT_ROLE_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
CREATED_BY_ROLE_ID name (en) CREATED_BY_ROLE_ID name (zh) CREATED_BY_ROLE_ID name (fr) CREATED_BY_ROLE_ID name (de) CREATED_BY_ROLE_ID name (ja) CREATED_BY_ROLE_ID name (es) CREATED_BY_ROLE_ID Last Changed 2010-02-16T19:03:09 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName CREATED_BY_ROLE_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
CREATED_BY_USER_ID name (en) CREATED_BY_USER_ID name (zh) CREATED_BY_USER_ID name (fr) CREATED_BY_USER_ID name (de) CREATED_BY_USER_ID name (ja) CREATED_BY_USER_ID name (es) CREATED_BY_USER_ID Last Changed 2010-02-16T19:03:09 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName CREATED_BY_USER_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
MODIFIED_BY_ROLE_ID name (en) MODIFIED_BY_ROLE_ID name (zh) MODIFIED_BY_ROLE_ID name (fr) MODIFIED_BY_ROLE_ID name (de) MODIFIED_BY_ROLE_ID name (ja) MODIFIED_BY_ROLE_ID name (es) MODIFIED_BY_ROLE_ID Last Changed 2010-02-16T19:03:09 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName MODIFIED_BY_ROLE_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
MODIFIED_BY_USER_ID name (en) MODIFIED_BY_USER_ID name (zh) MODIFIED_BY_USER_ID name (fr) MODIFIED_BY_USER_ID name (de) MODIFIED_BY_USER_ID name (ja) MODIFIED_BY_USER_ID name (es) MODIFIED_BY_USER_ID Last Changed 2010-02-16T19:03:09 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName MODIFIED_BY_USER_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
BL_ACL_ID name (en) BL_ACL_ID name (zh) BL_ACL_ID name (fr) BL_ACL_ID name (de) BL_ACL_ID name (ja) BL_ACL_ID name (es) BL_ACL_ID Last Changed 2010-02-16T19:03:09 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName BL_ACL_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
DESCRIPTION name (en) DESCRIPTION name (zh) 描述 name (fr) DESCRIPTION name (de) BESCHREIBUNG name (ja) 説明 name (es) DESCRIPCIÓN Last Changed 2010-02-16T17:00:33 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName DESCRIPTION usage attribute datatype nVarChar precision 255 scale 0 size 512 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
NAME name (en) NAME name (zh) 名称 name (fr) NOM name (de) NAME name (ja) 名前 name (es) NOMBRE Last Changed 2010-02-16T17:00:33 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName NAME usage attribute datatype nVarChar precision 255 scale 0 size 512 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
PASSWORD name (en) PASSWORD name (zh) PASSWORD name (fr) PASSWORD name (de) PASSWORD name (ja) PASSWORD name (es) PASSWORD Last Changed 2010-02-16T17:00:33 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName PASSWORD usage attribute datatype nVarChar precision 2000 scale 0 size 4002 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
LAST_PWD_CHANGE_DATE name (en) LAST_PWD_CHANGE_DATE name (zh) LAST_PWD_CHANGE_DATE name (fr) LAST_PWD_CHANGE_DATE name (de) LAST_PWD_CHANGE_DATE name (ja) LAST_PWD_CHANGE_DATE name (es) LAST_PWD_CHANGE_DATE Last Changed 2010-02-16T17:00:33 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName LAST_PWD_CHANGE_DATE usage identifier datatype dateTime precision 0 scale 0 size 12 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
FAILED_LOGINS name (en) FAILED_LOGINS name (zh) FAILED_LOGINS name (fr) FAILED_LOGINS name (de) FAILED_LOGINS name (ja) FAILED_LOGINS name (es) FAILED_LOGINS Last Changed 2010-02-16T19:03:21 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName FAILED_LOGINS usage attribute datatype decimal precision 38 scale 0 size 20 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
LAST_FAILED_LOGIN_DATE name (en) LAST_FAILED_LOGIN_DATE name (zh) LAST_FAILED_LOGIN_DATE name (fr) LAST_FAILED_LOGIN_DATE name (de) LAST_FAILED_LOGIN_DATE name (ja) LAST_FAILED_LOGIN_DATE name (es) LAST_FAILED_LOGIN_DATE Last Changed 2010-02-16T17:00:33 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName LAST_FAILED_LOGIN_DATE usage identifier datatype dateTime precision 0 scale 0 size 12 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
DATE_CREATED name (en) DATE_CREATED name (zh) DATE_CREATED name (fr) DATE_CREATED name (de) DATE_CREATED name (ja) DATE_CREATED name (es) DATE_CREATED Last Changed 2010-02-16T17:00:33 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName DATE_CREATED usage identifier datatype dateTime precision 0 scale 0 size 12 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
DATE_MODIFIED name (en) DATE_MODIFIED name (zh) DATE_MODIFIED name (fr) DATE_MODIFIED name (de) DATE_MODIFIED name (ja) DATE_MODIFIED name (es) DATE_MODIFIED Last Changed 2010-02-16T17:00:33 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName DATE_MODIFIED usage identifier datatype dateTime precision 0 scale 0 size 12 nullable true regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
IS_PWD_EVER_EXPIRED name (en) IS_PWD_EVER_EXPIRED name (zh) IS_PWD_EVER_EXPIRED name (fr) IS_PWD_EVER_EXPIRED name (de) IS_PWD_EVER_EXPIRED name (ja) IS_PWD_EVER_EXPIRED name (es) IS_PWD_EVER_EXPIRED Last Changed 2010-02-16T19:03:24 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName IS_PWD_EVER_EXPIRED usage attribute datatype int16 precision 0 scale 0 size 2 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
IS_ENABLED name (en) IS_ENABLED name (zh) IS_ENABLED name (fr) IS_ENABLED name (de) IS_ENABLED name (ja) IS_ENABLED name (es) IS_ENABLED Last Changed 2010-02-16T19:03:24 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName IS_ENABLED usage attribute datatype int16 precision 0 scale 0 size 2 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
IS_ENABLED_SECUR_ID_AUTH name (en) IS_ENABLED_SECUR_ID_AUTH name (zh) IS_ENABLED_SECUR_ID_AUTH name (fr) IS_ENABLED_SECUR_ID_AUTH name (de) IS_ENABLED_SECUR_ID_AUTH name (ja) IS_ENABLED_SECUR_ID_AUTH name (es) IS_ENABLED_SECUR_ID_AUTH Last Changed 2010-02-16T19:03:24 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName IS_ENABLED_SECUR_ID_AUTH usage attribute datatype int16 precision 0 scale 0 size 2 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
IS_ENABLED_SRP_AUTH name (en) IS_ENABLED_SRP_AUTH name (zh) IS_ENABLED_SRP_AUTH name (fr) IS_ENABLED_SRP_AUTH name (de) IS_ENABLED_SRP_AUTH name (ja) IS_ENABLED_SRP_AUTH name (es) IS_ENABLED_SRP_AUTH Last Changed 2010-02-16T19:03:24 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName IS_ENABLED_SRP_AUTH usage attribute datatype int16 precision 0 scale 0 size 2 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
IS_ENABLED_ADK_AUTH name (en) IS_ENABLED_ADK_AUTH name (zh) IS_ENABLED_ADK_AUTH name (fr) IS_ENABLED_ADK_AUTH name (de) IS_ENABLED_ADK_AUTH name (ja) IS_ENABLED_ADK_AUTH name (es) IS_ENABLED_ADK_AUTH Last Changed 2010-02-16T19:03:24 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName IS_ENABLED_ADK_AUTH usage attribute datatype int16 precision 0 scale 0 size 2 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
IS_ENABLED_LDAP_AUTH name (en) IS_ENABLED_LDAP_AUTH name (zh) IS_ENABLED_LDAP_AUTH name (fr) IS_ENABLED_LDAP_AUTH name (de) IS_ENABLED_LDAP_AUTH name (ja) IS_ENABLED_LDAP_AUTH name (es) IS_ENABLED_LDAP_AUTH Last Changed 2010-02-16T19:03:24 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName IS_ENABLED_LDAP_AUTH usage attribute datatype int16 precision 0 scale 0 size 2 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
IS_ENABLED_PKI_AUTH name (en) IS_ENABLED_PKI_AUTH name (zh) IS_ENABLED_PKI_AUTH name (fr) IS_ENABLED_PKI_AUTH name (de) IS_ENABLED_PKI_AUTH name (ja) IS_ENABLED_PKI_AUTH name (es) IS_ENABLED_PKI_AUTH Last Changed 2010-02-16T19:03:24 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName IS_ENABLED_PKI_AUTH usage attribute datatype int16 precision 0 scale 0 size 2 nullable true regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
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 2010-02-16T19:03:09 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName BL_SITE_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
IS_DELETED name (en) IS_DELETED name (zh) IS_DELETED name (fr) IS_DELETED name (de) IS_DELETED name (ja) IS_DELETED name (es) IS_DELETED Last Changed 2010-02-16T19:03:24 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName IS_DELETED usage attribute datatype int16 precision 0 scale 0 size 2 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
IS_LATEST_VERSION name (en) IS_LATEST_VERSION name (zh) IS_LATEST_VERSION name (fr) IS_LATEST_VERSION name (de) IS_LATEST_VERSION name (ja) IS_LATEST_VERSION name (es) IS_LATEST_VERSION Last Changed 2010-02-16T19:03:24 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName IS_LATEST_VERSION usage attribute datatype int16 precision 0 scale 0 size 2 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
START_DATETIME name (en) START_DATETIME name (zh) START_DATETIME name (fr) START_DATETIME name (de) START_DATETIME name (ja) START_DATETIME name (es) START_DATETIME Last Changed 2010-02-16T17:00:33 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName START_DATETIME usage identifier datatype dateTime precision 0 scale 0 size 12 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
END_DATETIME name (en) END_DATETIME name (zh) END_DATETIME name (fr) END_DATETIME name (de) END_DATETIME name (ja) END_DATETIME name (es) END_DATETIME Last Changed 2010-02-16T17:00:33 lastChangedBy Primary\GRB(GlobalReportAdmins) externalName END_DATETIME usage identifier datatype dateTime precision 0 scale 0 size 12 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS

Compliance Server <--> F_COMPONENT_EXCEPTION

name ()	Compliance Server <--> F_COMPONENT_EXCEPTION
Status	valid
expression	[IL Compliance].[D_SERVER].[SERVER_HIST_ID] =[IL Compliance].[F_DCOMPONENT_EXCEPTION].[SERVER_HIST_ID]
left	refobj [IL Compliance].[D_SERVER] mincard one maxcard one
right	refobj [IL Compliance].[F_DCOMPONENT_EXCEPTION] mincard one maxcard many

---

Compliance Server Site <--> Compliance Server

name ()	Compliance Server Site <--> Compliance Server
Status	valid
expression	[IL Compliance].[BL_SITE].[BL_SITE_ID] =[IL Compliance].[D_SERVER].[BL_SITE_ID]
left	refobj [IL Compliance].[BL_SITE] mincard one maxcard one
right	refobj [IL Compliance].[D_SERVER] mincard one maxcard one

---

Compliance_B_SERVER_GROUP

name (en)	Compliance_B_SERVER_GROUP
name (zh)	Compliance_B_SERVER_GROUP
name (fr)	Compliance_B_SERVER_GROUP
name (de)	Compliance_B_SERVER_GROUP
name (ja)	Compliance_B_SERVER_GROUP
name (es)	Compliance_B_SERVER_GROUP
Status	valid
Last Changed	2010-10-26T14:46:35
lastChangedBy	Primary\BLAdmin(GlobalReportAdmins)
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) BLGROUP_SERVER_ID name (fr) BLGROUP_SERVER_ID name (de) BLGROUP_SERVER_ID name (ja) BLGROUP_SERVER_ID name (es) BLGROUP_SERVER_ID Last Changed 2009-03-20T16:56:03 lastChangedBy Primary\BLAdmin(GlobalReportAdmins) externalName BLGROUP_SERVER_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) GROUP_HIST_ID name (fr) GROUP_HIST_ID name (de) GROUP_HIST_ID name (ja) GROUP_HIST_ID name (es) GROUP_HIST_ID Last Changed 2009-03-20T16:56:03 lastChangedBy Primary\BLAdmin(GlobalReportAdmins) externalName GROUP_HIST_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1
SERVER_HIST_ID name (en) SERVER_HIST_ID name (zh) SERVER_HIST_ID name (fr) SERVER_HIST_ID name (de) SERVER_HIST_ID name (ja) SERVER_HIST_ID name (es) SERVER_HIST_ID Last Changed 2009-03-20T16:56:03 lastChangedBy Primary\BLAdmin(GlobalReportAdmins) externalName SERVER_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) START_DATETIME name (fr) START_DATETIME name (de) START_DATETIME name (ja) START_DATETIME name (es) START_DATETIME Last Changed 2009-03-20T16:56:03 lastChangedBy Primary\BLAdmin(GlobalReportAdmins) 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) END_DATETIME name (fr) END_DATETIME name (de) END_DATETIME name (ja) END_DATETIME name (es) END_DATETIME Last Changed 2009-03-20T16:56:03 lastChangedBy Primary\BLAdmin(GlobalReportAdmins) 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) IS_DELETED name (fr) IS_DELETED name (de) IS_DELETED name (ja) IS_DELETED name (es) IS_DELETED Last Changed 2009-03-20T16:56:03 lastChangedBy Primary\BLAdmin(GlobalReportAdmins) externalName IS_DELETED usage fact datatype int16 precision 0 scale 0 size 2 nullable false regularAggregate sum semiAggregate sum 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 2010-10-26T14:46:33 lastChangedBy Primary\BLAdmin(GlobalReportAdmins) externalName SERVER_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 2010-10-26T14:46:33 lastChangedBy Primary\BLAdmin(GlobalReportAdmins) externalName BL_SITE_ID usage fact datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate sum semiAggregate sum collationSequenceName en collationSequenceLevel 1

COMPLIANCE_COMPONENT_DELETED_BOOLEAN_LOOKUP

name (en)	COMPLIANCE_COMPONENT_DELETED_BOOLEAN_LOOKUP
name (zh)	(zh) Copy of Copy of Copy of REPORTS_BOOLEAN_LOOKUP
name (fr)	(fr) Copy of Copy of Copy of REPORTS_BOOLEAN_LOOKUP
name (de)	(de) Copy of Copy of Copy of REPORTS_BOOLEAN_LOOKUP
name (ja)	(ja) Copy of Copy of Copy of REPORTS_BOOLEAN_LOOKUP
name (es)	(es) Copy of Copy of Copy of REPORTS_BOOLEAN_LOOKUP
Status	valid
Last Changed	2011-04-20T11:55:33
lastChangedBy	Primary\BLAdmin(BLAdmins)
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql Select * from [ORA75].REPORTS_BOOLEAN_LOOKUP as REPORTS_BOOLEAN_LOOKUP filters filterDefinition displayName Locale Filter expression [IL Compliance].[COMPLIANCE_COMPONENT_DELETED_BOOLEAN_LOOKUP].[LANGUAGE_CD] = upper(#sq( $Language_lookup{$runLocale})#) tableType table
determinants
LANGUAGE_CD name (en) LANGUAGE_CD name (zh) (zh) LANGUAGE_CD name (fr) (fr) LANGUAGE_CD name (de) (de) LANGUAGE_CD name (ja) (ja) LANGUAGE_CD name (es) (es) LANGUAGE_CD Last Changed 2011-01-20T14:32:31 externalName LANGUAGE_CD usage identifier datatype character precision 2 scale 0 size 6 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
VAL_ID name (en) VAL_ID name (zh) (zh) VAL_ID name (fr) (fr) VAL_ID name (de) (de) VAL_ID name (ja) (ja) VAL_ID name (es) (es) VAL_ID Last Changed 2011-01-20T14:32:31 externalName VAL_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
BOOLEAN_VALUE name (en) BOOLEAN_VALUE name (zh) (zh) BOOLEAN_VALUE name (fr) (fr) BOOLEAN_VALUE name (de) (de) BOOLEAN_VALUE name (ja) (ja) BOOLEAN_VALUE name (es) (es) BOOLEAN_VALUE Last Changed 2011-01-20T14:32:31 externalName BOOLEAN_VALUE usage attribute datatype characterLength16 precision 10 scale 0 size 22 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS

COMPLIANCE_COMPONENT_EXCEPTION_DELETED_BOOLEAN_LOOKUP

name (en)	COMPLIANCE_COMPONENT_EXCEPTION_DELETED_BOOLEAN_LOOKUP
name (zh)	(zh) Copy (2) of Copy (2) of REPORTS_BOOLEAN_LOOKUP
name (fr)	(fr) Copy (2) of Copy (2) of REPORTS_BOOLEAN_LOOKUP
name (de)	(de) Copy (2) of Copy (2) of REPORTS_BOOLEAN_LOOKUP
name (ja)	(ja) Copy (2) of Copy (2) of REPORTS_BOOLEAN_LOOKUP
name (es)	(es) Copy (2) of Copy (2) of REPORTS_BOOLEAN_LOOKUP
Status	valid
Last Changed	2011-04-21T16:07:56
lastChangedBy	Primary\BLAdmin(BLAdmins)
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql Select * from [ORA75].REPORTS_BOOLEAN_LOOKUP as REPORTS_BOOLEAN_LOOKUP filters filterDefinition displayName Locale Filter expression [IL Compliance].[COMPLIANCE_COMPONENT_EXCEPTION_DELETED_BOOLEAN_LOOKUP].[LANGUAGE_CD] = upper(#sq( $Language_lookup{$runLocale})#) tableType table
determinants
LANGUAGE_CD name (en) LANGUAGE_CD name (zh) (zh) LANGUAGE_CD name (fr) (fr) LANGUAGE_CD name (de) (de) LANGUAGE_CD name (ja) (ja) LANGUAGE_CD name (es) (es) LANGUAGE_CD Last Changed 2011-01-20T14:32:31 externalName LANGUAGE_CD usage identifier datatype character precision 2 scale 0 size 6 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
VAL_ID name (en) VAL_ID name (zh) (zh) VAL_ID name (fr) (fr) VAL_ID name (de) (de) VAL_ID name (ja) (ja) VAL_ID name (es) (es) VAL_ID Last Changed 2011-01-20T14:32:31 externalName VAL_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
BOOLEAN_VALUE name (en) BOOLEAN_VALUE name (zh) (zh) BOOLEAN_VALUE name (fr) (fr) BOOLEAN_VALUE name (de) (de) BOOLEAN_VALUE name (ja) (ja) BOOLEAN_VALUE name (es) (es) BOOLEAN_VALUE Last Changed 2011-01-20T14:32:31 externalName BOOLEAN_VALUE usage attribute datatype characterLength16 precision 10 scale 0 size 22 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS

COMPLIANCE_JOB_DELETED_BOOLEAN_LOOKUP

name (en)	COMPLIANCE_JOB_DELETED_BOOLEAN_LOOKUP
name (zh)	(zh) REPORTS_BOOLEAN_LOOKUP
name (fr)	(fr) REPORTS_BOOLEAN_LOOKUP
name (de)	(de) REPORTS_BOOLEAN_LOOKUP
name (ja)	(ja) REPORTS_BOOLEAN_LOOKUP
name (es)	(es) REPORTS_BOOLEAN_LOOKUP
Status	valid
Last Changed	2011-04-20T11:17:53
lastChangedBy	Primary\BLAdmin(BLAdmins)
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql Select * from [ORA75].REPORTS_BOOLEAN_LOOKUP as REPORTS_BOOLEAN_LOOKUP filters filterDefinition displayName Locale Filter expression [IL Compliance].[COMPLIANCE_JOB_DELETED_BOOLEAN_LOOKUP].[LANGUAGE_CD] = upper(#sq( $Language_lookup{$runLocale})#) tableType table
determinants
LANGUAGE_CD name (en) LANGUAGE_CD name (zh) (zh) LANGUAGE_CD name (fr) (fr) LANGUAGE_CD name (de) (de) LANGUAGE_CD name (ja) (ja) LANGUAGE_CD name (es) (es) LANGUAGE_CD Last Changed 2011-01-20T14:32:31 externalName LANGUAGE_CD usage identifier datatype character precision 2 scale 0 size 6 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
VAL_ID name (en) VAL_ID name (zh) (zh) VAL_ID name (fr) (fr) VAL_ID name (de) (de) VAL_ID name (ja) (ja) VAL_ID name (es) (es) VAL_ID Last Changed 2011-01-20T14:32:31 externalName VAL_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
BOOLEAN_VALUE name (en) BOOLEAN_VALUE name (zh) (zh) BOOLEAN_VALUE name (fr) (fr) BOOLEAN_VALUE name (de) (de) BOOLEAN_VALUE name (ja) (ja) BOOLEAN_VALUE name (es) (es) BOOLEAN_VALUE Last Changed 2011-01-20T14:32:31 externalName BOOLEAN_VALUE usage attribute datatype characterLength16 precision 10 scale 0 size 22 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS

COMPLIANCE_JOB_RUN_DELETED_BOOLEAN_LOOKUP

name (en)	COMPLIANCE_JOB_RUN_DELETED_BOOLEAN_LOOKUP
name (zh)	(zh) Copy of Copy of REPORTS_BOOLEAN_LOOKUP
name (fr)	(fr) Copy of Copy of REPORTS_BOOLEAN_LOOKUP
name (de)	(de) Copy of Copy of REPORTS_BOOLEAN_LOOKUP
name (ja)	(ja) Copy of Copy of REPORTS_BOOLEAN_LOOKUP
name (es)	(es) Copy of Copy of REPORTS_BOOLEAN_LOOKUP
Status	valid
Last Changed	2011-04-20T11:52:56
lastChangedBy	Primary\BLAdmin(BLAdmins)
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql Select * from [ORA75].REPORTS_BOOLEAN_LOOKUP as REPORTS_BOOLEAN_LOOKUP filters filterDefinition displayName Locale Filter expression [IL Compliance].[COMPLIANCE_JOB_RUN_DELETED_BOOLEAN_LOOKUP].[LANGUAGE_CD] = upper(#sq( $Language_lookup{$runLocale})#) tableType table
determinants
LANGUAGE_CD name (en) LANGUAGE_CD name (zh) (zh) LANGUAGE_CD name (fr) (fr) LANGUAGE_CD name (de) (de) LANGUAGE_CD name (ja) (ja) LANGUAGE_CD name (es) (es) LANGUAGE_CD Last Changed 2011-01-20T14:32:31 externalName LANGUAGE_CD usage identifier datatype character precision 2 scale 0 size 6 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
VAL_ID name (en) VAL_ID name (zh) (zh) VAL_ID name (fr) (fr) VAL_ID name (de) (de) VAL_ID name (ja) (ja) VAL_ID name (es) (es) VAL_ID Last Changed 2011-01-20T14:32:31 externalName VAL_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
BOOLEAN_VALUE name (en) BOOLEAN_VALUE name (zh) (zh) BOOLEAN_VALUE name (fr) (fr) BOOLEAN_VALUE name (de) (de) BOOLEAN_VALUE name (ja) (ja) BOOLEAN_VALUE name (es) (es) BOOLEAN_VALUE Last Changed 2011-01-20T14:32:31 externalName BOOLEAN_VALUE usage attribute datatype characterLength16 precision 10 scale 0 size 22 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS

COMPLIANCE_JOB_RUN_LATEST_BOOLEAN_LOOKUP

name (en)	COMPLIANCE_JOB_RUN_LATEST_BOOLEAN_LOOKUP
name (zh)	(zh) Copy of REPORTS_BOOLEAN_LOOKUP
name (fr)	(fr) Copy of REPORTS_BOOLEAN_LOOKUP
name (de)	(de) Copy of REPORTS_BOOLEAN_LOOKUP
name (ja)	(ja) Copy of REPORTS_BOOLEAN_LOOKUP
name (es)	(es) Copy of REPORTS_BOOLEAN_LOOKUP
Status	valid
Last Changed	2011-04-20T11:57:56
lastChangedBy	Primary\BLAdmin(BLAdmins)
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql Select * from [ORA75].REPORTS_BOOLEAN_LOOKUP as REPORTS_BOOLEAN_LOOKUP filters filterDefinition displayName Locale Filter expression [IL Compliance].[COMPLIANCE_JOB_RUN_LATEST_BOOLEAN_LOOKUP].[LANGUAGE_CD] = upper(#sq( $Language_lookup{$runLocale})#) tableType table
determinants
LANGUAGE_CD name (en) LANGUAGE_CD name (zh) (zh) LANGUAGE_CD name (fr) (fr) LANGUAGE_CD name (de) (de) LANGUAGE_CD name (ja) (ja) LANGUAGE_CD name (es) (es) LANGUAGE_CD Last Changed 2011-01-20T14:32:31 externalName LANGUAGE_CD usage identifier datatype character precision 2 scale 0 size 6 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
VAL_ID name (en) VAL_ID name (zh) (zh) VAL_ID name (fr) (fr) VAL_ID name (de) (de) VAL_ID name (ja) (ja) VAL_ID name (es) (es) VAL_ID Last Changed 2011-01-20T14:32:31 externalName VAL_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
BOOLEAN_VALUE name (en) BOOLEAN_VALUE name (zh) (zh) BOOLEAN_VALUE name (fr) (fr) BOOLEAN_VALUE name (de) (de) BOOLEAN_VALUE name (ja) (ja) BOOLEAN_VALUE name (es) (es) BOOLEAN_VALUE Last Changed 2011-01-20T14:32:31 externalName BOOLEAN_VALUE usage attribute datatype characterLength16 precision 10 scale 0 size 22 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS

COMPLIANCE_RULE_DELETED_BOOLEAN_LOOKUP

name (en)	COMPLIANCE_RULE_DELETED_BOOLEAN_LOOKUP
name (zh)	(zh) Copy of Copy (2) of REPORTS_BOOLEAN_LOOKUP
name (fr)	(fr) Copy of Copy (2) of REPORTS_BOOLEAN_LOOKUP
name (de)	(de) Copy of Copy (2) of REPORTS_BOOLEAN_LOOKUP
name (ja)	(ja) Copy of Copy (2) of REPORTS_BOOLEAN_LOOKUP
name (es)	(es) Copy of Copy (2) of REPORTS_BOOLEAN_LOOKUP
Status	valid
Last Changed	2011-04-21T12:45:04
lastChangedBy	Primary\BLAdmin(BLAdmins)
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql Select * from [ORA75].REPORTS_BOOLEAN_LOOKUP as REPORTS_BOOLEAN_LOOKUP filters filterDefinition displayName Locale Filter expression [IL Compliance].[COMPLIANCE_RULE_DELETED_BOOLEAN_LOOKUP].[LANGUAGE_CD] = upper(#sq( $Language_lookup{$runLocale})#) tableType table
determinants
LANGUAGE_CD name (en) LANGUAGE_CD name (zh) (zh) LANGUAGE_CD name (fr) (fr) LANGUAGE_CD name (de) (de) LANGUAGE_CD name (ja) (ja) LANGUAGE_CD name (es) (es) LANGUAGE_CD Last Changed 2011-01-20T14:32:31 externalName LANGUAGE_CD usage identifier datatype character precision 2 scale 0 size 6 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
VAL_ID name (en) VAL_ID name (zh) (zh) VAL_ID name (fr) (fr) VAL_ID name (de) (de) VAL_ID name (ja) (ja) VAL_ID name (es) (es) VAL_ID Last Changed 2011-01-20T14:32:31 externalName VAL_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
BOOLEAN_VALUE name (en) BOOLEAN_VALUE name (zh) (zh) BOOLEAN_VALUE name (fr) (fr) BOOLEAN_VALUE name (de) (de) BOOLEAN_VALUE name (ja) (ja) BOOLEAN_VALUE name (es) (es) BOOLEAN_VALUE Last Changed 2011-01-20T14:32:31 externalName BOOLEAN_VALUE usage attribute datatype characterLength16 precision 10 scale 0 size 22 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS

COMPLIANCE_RULE_GRP_DELETED_BOOLEAN_LOOKUP

name (en)	COMPLIANCE_RULE_GRP_DELETED_BOOLEAN_LOOKUP
name (zh)	(zh) Copy (2) of REPORTS_BOOLEAN_LOOKUP
name (fr)	(fr) Copy (2) of REPORTS_BOOLEAN_LOOKUP
name (de)	(de) Copy (2) of REPORTS_BOOLEAN_LOOKUP
name (ja)	(ja) Copy (2) of REPORTS_BOOLEAN_LOOKUP
name (es)	(es) Copy (2) of REPORTS_BOOLEAN_LOOKUP
Status	valid
Last Changed	2011-04-21T12:38:57
lastChangedBy	Primary\BLAdmin(BLAdmins)
definition	dbQuery sources dataSourceRef [].[dataSources].[ORA75] sql Select * from [ORA75].REPORTS_BOOLEAN_LOOKUP as REPORTS_BOOLEAN_LOOKUP filters filterDefinition displayName Locale Filter expression [IL Compliance].[COMPLIANCE_RULE_GRP_DELETED_BOOLEAN_LOOKUP].[LANGUAGE_CD] = upper(#sq( $Language_lookup{$runLocale})#) tableType table
determinants
LANGUAGE_CD name (en) LANGUAGE_CD name (zh) (zh) LANGUAGE_CD name (fr) (fr) LANGUAGE_CD name (de) (de) LANGUAGE_CD name (ja) (ja) LANGUAGE_CD name (es) (es) LANGUAGE_CD Last Changed 2011-01-20T14:32:31 externalName LANGUAGE_CD usage identifier datatype character precision 2 scale 0 size 6 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
VAL_ID name (en) VAL_ID name (zh) (zh) VAL_ID name (fr) (fr) VAL_ID name (de) (de) VAL_ID name (ja) (ja) VAL_ID name (es) (es) VAL_ID Last Changed 2011-01-20T14:32:31 externalName VAL_ID usage identifier datatype decimal precision 38 scale 0 size 20 nullable false regularAggregate count semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
BOOLEAN_VALUE name (en) BOOLEAN_VALUE name (zh) (zh) BOOLEAN_VALUE name (fr) (fr) BOOLEAN_VALUE name (de) (de) BOOLEAN_VALUE name (ja) (ja) BOOLEAN_VALUE name (es) (es) BOOLEAN_VALUE Last Changed 2011-01-20T14:32:31 externalName BOOLEAN_VALUE usage attribute datatype characterLength16 precision 10 scale 0 size 22 nullable false regularAggregate unsupported semiAggregate unsupported collationSequenceName en collationSequenceLevel 1 originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS