NamespaceIL Compliance
	
Last Changed: 2011-04-01T18:39:46
Query SubjectB_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
Query ItemBLGROUP_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
Query ItemGROUP_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
Query ItemSERVER_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
Query ItemSTART_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
Query ItemEND_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
Query ItemIS_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
Query ItemSERVER_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
Query ItemBL_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
RelationshipB_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

RelationshipB_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

Query SubjectB_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
Query ItemCOMP_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
Query ItemCR_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
Query ItemCOMPLIANCE_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
Query ItemIS_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
Query ItemSTART_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
Query ItemEND_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
Query SubjectBL_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
Query ItemBL_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
Query ItemNAME
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
Query ItemDESCRIPTION
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
Query ItemIS_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
Query ItemOM_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
RelationshipCompliance 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

RelationshipCompliance 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

RelationshipCompliance 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

RelationshipCompliance 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

RelationshipCompliance 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

RelationshipCompliance 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

Query SubjectCompliance 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
Query ItemROLE_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
Query ItemROLE_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
Query ItemBL_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
Query ItemCREATED_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
Query ItemCREATED_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
Query ItemMODIFIED_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
Query ItemMODIFIED_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
Query ItemBL_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
Query ItemBL_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
Query ItemDESCRIPTION
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
Query ItemNAME
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
Query ItemIS_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
Query ItemIS_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
Query ItemDATE_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
Query ItemDATE_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
Query ItemBL_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
Query ItemIS_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
Query ItemIS_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
Query ItemSTART_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
Query ItemEND_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
Query SubjectCompliance 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
Query ItemUSER_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
Query ItemUSER_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
Query ItemBL_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
Query ItemDEFAULT_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
Query ItemCREATED_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
Query ItemCREATED_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
Query ItemMODIFIED_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
Query ItemMODIFIED_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
Query ItemBL_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
Query ItemDESCRIPTION
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
Query ItemNAME
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
Query ItemPASSWORD
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
Query ItemLAST_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
Query ItemFAILED_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
Query ItemLAST_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
Query ItemDATE_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
Query ItemDATE_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
Query ItemIS_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
Query ItemIS_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
Query ItemIS_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
Query ItemIS_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
Query ItemIS_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
Query ItemIS_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
Query ItemIS_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
Query ItemBL_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
Query ItemIS_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
Query ItemIS_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
Query ItemSTART_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
Query ItemEND_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
RelationshipCompliance 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

RelationshipCompliance 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

Query SubjectCompliance_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
Query ItemBLGROUP_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
Query ItemGROUP_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
Query ItemSERVER_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
Query ItemSTART_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
Query ItemEND_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
Query ItemIS_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
Query ItemSERVER_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
Query ItemBL_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
Query SubjectCOMPLIANCE_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
Query ItemLANGUAGE_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
Query ItemVAL_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
Query ItemBOOLEAN_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
Query SubjectCOMPLIANCE_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
Query ItemLANGUAGE_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
Query ItemVAL_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
Query ItemBOOLEAN_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
Query SubjectCOMPLIANCE_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
Query ItemLANGUAGE_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
Query ItemVAL_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
Query ItemBOOLEAN_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
Query SubjectCOMPLIANCE_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
Query ItemLANGUAGE_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
Query ItemVAL_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
Query ItemBOOLEAN_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
Query SubjectCOMPLIANCE_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
Query ItemLANGUAGE_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
Query ItemVAL_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
Query ItemBOOLEAN_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
Query SubjectCOMPLIANCE_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
Query ItemLANGUAGE_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
Query ItemVAL_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
Query ItemBOOLEAN_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
Query SubjectCOMPLIANCE_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
Query ItemLANGUAGE_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
Query ItemVAL_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
Query ItemBOOLEAN_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
Query SubjectCOMPLIANCE_TEMPLATE_DELETED_BOOLEAN_LOOKUP
name (en) COMPLIANCE_TEMPLATE_DELETED_BOOLEAN_LOOKUP
name (zh) (zh) Copy of Copy of Copy of Copy of REPORTS_BOOLEAN_LOOKUP
name (fr) (fr) Copy of Copy of Copy of Copy of REPORTS_BOOLEAN_LOOKUP
name (de) (de) Copy of Copy of Copy of Copy of REPORTS_BOOLEAN_LOOKUP
name (ja) (ja) Copy of Copy of Copy of Copy of REPORTS_BOOLEAN_LOOKUP
name (es) (es) Copy of Copy of Copy of Copy of REPORTS_BOOLEAN_LOOKUP
Status valid
Last Changed 2011-04-20T11:59: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_TEMPLATE_DELETED_BOOLEAN_LOOKUP].[LANGUAGE_CD] = upper(#sq( $Language_lookup{$runLocale})#)
tableType table
determinants
Query ItemLANGUAGE_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
Query ItemVAL_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
Query ItemBOOLEAN_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
Query SubjectComponent Created D_BLROLE
name (en) Component Created D_BLROLE
name (zh) 兼容性创建角色
name (fr) Conformité - rôle créé
name (de) Compliance – Erstellte Rolle
name (ja) コンプライアンス ロールの作成
name (es) Función de creación de cumplimiento
Status valid
Last Changed 2011-04-09T12:20: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].[Component Created D_BLROLE].[BL_SITE_ID] IN (#csv(split(',', $account.parameters.siteIdList))#)
filterDefinition
displayName Valid Role
expression [IL Compliance].[Component Created D_BLROLE].[ROLE_ID] <>1000011 and [IL Compliance].[Component Created D_BLROLE].[ROLE_ID] <>1999999
tableType table
Query ItemROLE_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-16T13:55:59
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemROLE_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-16T13:56:01
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemBL_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-16T13:56:01
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemCREATED_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-16T13:56:01
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemCREATED_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-16T13:56:01
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemMODIFIED_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-16T13:56:01
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemMODIFIED_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-16T13:56:01
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemBL_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-16T13:56:01
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemBL_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-16T13:56:01
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDESCRIPTION
name (en) DESCRIPTION
name (zh) 描述
name (fr) DESCRIPTION
name (de) BESCHREIBUNG
name (ja) 説明
name (es) DESCRIPCIÓN
Last Changed 2010-02-16T13:15:28
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName DESCRIPTION
usage attribute
datatype characterLength16
precision 255
scale 0
size 512
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemNAME
name (en) NAME
name (zh) 名称
name (fr) NOM
name (de) NAME
name (ja) 名前
name (es) NOMBRE
Last Changed 2010-02-16T13:15:28
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName NAME
usage attribute
datatype characterLength16
precision 255
scale 0
size 512
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T13:56:48
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_ENABLED
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T13:56:47
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_SYSTEM_ROLE
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDATE_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-16T13:15:28
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDATE_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-16T13:15:28
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemBL_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-16T13:56:01
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T13:56:48
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_DELETED
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T13:56:48
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_LATEST_VERSION
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemSTART_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-16T13:15:28
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemEND_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-16T13:15:28
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query SubjectComponent Created D_BLUSER
name (en) Component Created D_BLUSER
name (zh) 兼容性创建用户
name (fr) Conformité - utilisateur créé
name (de) Compliance – Erstellter Benutzer
name (ja) コンプライアンス 作成したユーザ
name (es) Usuario de creación de cumplimiento
Status valid
Last Changed 2011-04-09T12:20:44
lastChangedBy Primary\BLAdmin(BLAdmins)
definition
dbQuery
sources
dataSourceRef [].[dataSources].[ORA75]
sql Select * from D_BLUSER
filters
filterDefinition
displayName Valid User
expression [IL Compliance].[Component Created D_BLUSER].[USER_ID] <>1000011 and [IL Compliance].[Component Created D_BLUSER].[USER_ID] <>1999999
filterDefinition
displayName Site Access Filter
expression [IL Compliance].[Component Created D_BLUSER].[BL_SITE_ID] IN (#csv(split(',', $account.parameters.siteIdList))#)
tableType table
Query ItemUSER_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-16T14:00:38
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemUSER_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-16T14:00:40
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemBL_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-16T14:00:40
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDEFAULT_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-16T14:00:40
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemCREATED_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-16T14:00:40
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemCREATED_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-16T14:00:40
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemMODIFIED_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-16T14:00:40
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemMODIFIED_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-16T14:00:40
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemBL_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-16T14:00:40
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDESCRIPTION
name (en) DESCRIPTION
name (zh) 描述
name (fr) DESCRIPTION
name (de) BESCHREIBUNG
name (ja) 説明
name (es) DESCRIPCIÓN
Last Changed 2010-02-16T13:15:53
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName DESCRIPTION
usage attribute
datatype characterLength16
precision 255
scale 0
size 512
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemNAME
name (en) NAME
name (zh) 名称
name (fr) NOM
name (de) NAME
name (ja) 名前
name (es) NOMBRE
Last Changed 2010-02-16T13:15:53
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName NAME
usage attribute
datatype characterLength16
precision 255
scale 0
size 512
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemPASSWORD
name (en) PASSWORD
name (zh) PASSWORD
name (fr) PASSWORD
name (de) PASSWORD
name (ja) PASSWORD
name (es) PASSWORD
Last Changed 2010-02-16T13:15:53
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName PASSWORD
usage attribute
datatype characterLength16
precision 2000
scale 0
size 4002
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemLAST_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-16T13:15:53
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemFAILED_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-16T14:00:53
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemLAST_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-16T13:15:53
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDATE_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-16T13:15:53
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDATE_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-16T13:15:53
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T14:00:55
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_PWD_EVER_EXPIRED
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T14:00:55
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_ENABLED
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T14:00:55
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_ENABLED_SECUR_ID_AUTH
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T14:00:55
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_ENABLED_SRP_AUTH
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T14:00:55
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_ENABLED_ADK_AUTH
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T14:00:55
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_ENABLED_LDAP_AUTH
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T14:00:55
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_ENABLED_PKI_AUTH
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemBL_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-16T14:00:40
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T14:00:55
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_DELETED
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T14:00:55
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_LATEST_VERSION
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemSTART_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-16T13:15:53
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemEND_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-16T13:15:53
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query SubjectComponent Modified D_BLROLE
name (en) Component Modified D_BLROLE
name (zh) 兼容性修改角色
name (fr) Conformité - rôle modifié
name (de) Compliance – Geänderte Rolle
name (ja) コンプライアンス 変更したロール
name (es) Función de modificación de cumplimiento
Status valid
Last Changed 2011-04-09T12:20:54
lastChangedBy Primary\BLAdmin(BLAdmins)
definition
dbQuery
sources
dataSourceRef [].[dataSources].[ORA75]
sql Select * from D_BLROLE
filters
filterDefinition
displayName Site Access Filter
expression [IL Compliance].[Component Modified D_BLROLE].[BL_SITE_ID] IN (#csv(split(',', $account.parameters.siteIdList))#)
filterDefinition
displayName Valid Role
expression [IL Compliance].[Component Modified D_BLROLE].[ROLE_ID] <>1000011 and [IL Compliance].[Component Modified D_BLROLE].[ROLE_ID] <>1999999
tableType table
Query ItemROLE_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-16T14:02:25
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemROLE_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-16T14:02:26
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemBL_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-16T14:02:26
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemCREATED_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-16T14:02:26
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemCREATED_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-16T14:02:26
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemMODIFIED_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-16T14:02:26
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemMODIFIED_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-16T14:02:26
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemBL_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-16T14:02:26
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemBL_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-16T14:02:26
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDESCRIPTION
name (en) DESCRIPTION
name (zh) 描述
name (fr) DESCRIPTION
name (de) BESCHREIBUNG
name (ja) 説明
name (es) DESCRIPCIÓN
Last Changed 2010-02-16T13:17:31
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName DESCRIPTION
usage attribute
datatype characterLength16
precision 255
scale 0
size 512
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemNAME
name (en) NAME
name (zh) 名称
name (fr) NOM
name (de) NAME
name (ja) 名前
name (es) NOMBRE
Last Changed 2010-02-16T13:17:31
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName NAME
usage attribute
datatype characterLength16
precision 255
scale 0
size 512
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T14:02:37
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_ENABLED
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T14:02:38
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_SYSTEM_ROLE
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDATE_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-16T13:17:31
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDATE_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-16T13:17:31
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemBL_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-16T14:02:38
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName BL_SITE_ID
usage attribute
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T14:02:38
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_DELETED
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T14:02:38
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_LATEST_VERSION
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemSTART_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-16T13:17:31
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemEND_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-16T13:17:31
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query SubjectComponent Modified D_BLUSER
name (en) Component Modified D_BLUSER
name (zh) 兼容性修改用户
name (fr) Conformité - utilisateur modifié
name (de) Compliance – Geänderter Benutzer
name (ja) コンプライアンス 変更したユーザ
name (es) Usuario de modificación de cumplimiento
Status valid
Last Changed 2011-04-09T12:21:04
lastChangedBy Primary\BLAdmin(BLAdmins)
definition
dbQuery
sources
dataSourceRef [].[dataSources].[ORA75]
sql Select * from D_BLUSER
filters
filterDefinition
displayName valid User
expression [IL Compliance].[Component Modified D_BLUSER].[USER_ID] <>1000011 and [IL Compliance].[Component Modified D_BLUSER].[USER_ID] <>1999999
filterDefinition
displayName Site Access Filter
expression [IL Compliance].[Component Modified D_BLUSER].[BL_SITE_ID] IN (#csv(split(',', $account.parameters.siteIdList))#)
tableType table
Query ItemUSER_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-16T14:03:52
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemUSER_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-16T14:03:54
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemBL_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-16T14:03:54
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDEFAULT_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-16T14:03:54
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemCREATED_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-16T14:03:54
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemCREATED_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-16T14:03:54
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemMODIFIED_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-16T14:03:54
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemMODIFIED_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-16T14:03:54
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemBL_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-16T14:03:54
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDESCRIPTION
name (en) DESCRIPTION
name (zh) 描述
name (fr) DESCRIPTION
name (de) BESCHREIBUNG
name (ja) 説明
name (es) DESCRIPCIÓN
Last Changed 2010-02-16T13:52:50
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName DESCRIPTION
usage attribute
datatype characterLength16
precision 255
scale 0
size 512
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemNAME
name (en) NAME
name (zh) 名称
name (fr) NOM
name (de) NAME
name (ja) 名前
name (es) NOMBRE
Last Changed 2010-02-16T13:52:50
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName NAME
usage attribute
datatype characterLength16
precision 255
scale 0
size 512
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemPASSWORD
name (en) PASSWORD
name (zh) PASSWORD
name (fr) PASSWORD
name (de) PASSWORD
name (ja) PASSWORD
name (es) PASSWORD
Last Changed 2010-02-16T13:52:50
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName PASSWORD
usage attribute
datatype characterLength16
precision 2000
scale 0
size 4002
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemLAST_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-16T13:52:50
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemFAILED_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-16T14:04:04
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemLAST_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-16T13:52:50
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDATE_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-16T13:52:50
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDATE_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-16T13:52:50
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T14:04:06
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_PWD_EVER_EXPIRED
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T14:04:06
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_ENABLED
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T14:04:06
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_ENABLED_SECUR_ID_AUTH
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T14:04:06
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_ENABLED_SRP_AUTH
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T14:04:06
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_ENABLED_ADK_AUTH
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T14:04:06
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_ENABLED_LDAP_AUTH
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T14:04:06
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_ENABLED_PKI_AUTH
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemBL_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-16T14:03:54
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T14:04:06
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_DELETED
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-16T14:04:06
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_LATEST_VERSION
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemSTART_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-16T13:52:49
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemEND_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-16T13:52:49
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query SubjectD_BLGROUP
name (en) D_BLGROUP
name (zh) (zh) D_BLGROUP
name (fr) (fr) D_BLGROUP
name (de) (de) D_BLGROUP
name (ja) (ja) D_BLGROUP
name (es) (es) D_BLGROUP
Status valid
Last Changed 2011-08-16T14:05:30
lastChangedBy primary\BLAdmin(BLAdmins-rename)
definition
dbQuery
sources
dataSourceRef [].[dataSources].[ORA75]
sql Select * from [ORA75].D_BLGROUP
filters
filterDefinition
displayName Site Access Filter
expression [IL Compliance].[D_BLGROUP].[BL_SITE_ID] IN (#csv(split(',', $account.parameters.siteIdList))#)
filterDefinition
displayName JobGroupsOnly
expression [IL Compliance].[D_BLGROUP].[GROUP_TYPE_NAME] in ('Job Group')
tableType table
Query ItemGROUP_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-28T18:15:58
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
Query ItemGROUP_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-28T18:16:02
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
Query ItemPARENT_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-28T18:16:02
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
Query ItemGROUP_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-28T15:30:04
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName GROUP_TYPE_NAME
usage attribute
datatype characterLength16
precision 50
scale 0
size 102
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemPARENT_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-28T15:30:04
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
Query ItemCREATED_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-28T18:16:02
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName CREATED_BY_ROLE_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemFQ_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-28T15:30:04
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
Query ItemCREATED_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-28T18:16:02
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName CREATED_BY_USER_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemMODIFIED_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-28T18:16:02
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName MODIFIED_BY_ROLE_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemMODIFIED_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-28T18:16:02
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName MODIFIED_BY_USER_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemBL_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-28T18:16:02
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName BL_ACL_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemNAME
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-28T15:30:04
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
Query ItemDESCRIPTION
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-28T15:30:03
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
Query ItemDATE_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-28T15:30:03
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
Query ItemDATE_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-28T15:30:03
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
Query ItemIS_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-28T18:16:17
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
Query ItemIS_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-28T18:16:23
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
Query ItemBL_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-28T18:16:02
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
Query ItemIS_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-28T18:16:23
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
Query ItemSTART_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-28T15:30:03
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
Query ItemEND_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-28T15:30:03
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
RelationshipD_BLGROUP <-> D_JOB
name () D_BLGROUP <-> D_JOB
Status valid
expression [IL Compliance].[D_BLGROUP].[BL_SITE_ID] =[IL Compliance].[D_JOB].[BL_SITE_ID] AND[IL Compliance].[D_BLGROUP].[GROUP_ID] =[IL Compliance].[D_JOB].[GROUP_ID] and [IL Compliance].[D_BLGROUP].[IS_LATEST_VERSION] =1
left
refobj [IL Compliance].[D_BLGROUP]
mincard one
maxcard one
right
refobj [IL Compliance].[D_JOB]
mincard one
maxcard one

Query SubjectD_BLGROUP_SER_SMART_GROUP
name (en) D_BLGROUP_SER_SMART_GROUP
name (zh) (zh) D_BLGROUP_SER_SMART_GROUP
name (fr) (fr) D_BLGROUP_SER_SMART_GROUP
name (de) (de) D_BLGROUP_SER_SMART_GROUP
name (ja) (ja) D_BLGROUP_SER_SMART_GROUP
name (es) (es) D_BLGROUP_SER_SMART_GROUP
Status valid
Last Changed 2015-11-26T13:30:30
lastChangedBy Primary\BLAdmin(BLAdmins)
definition
dbQuery
sources
dataSourceRef [].[dataSources].[ORA75]
sql Select * from [ORA75].D_BLGROUP
filters
filterDefinition
displayName SiteAccessFilter
expression [IL Compliance].[D_BLGROUP_SER_SMART_GROUP].[BL_SITE_ID] IN (#csv(split(',', $account.parameters.siteIdList))#)
filterDefinition
displayName ServerSmartGroupsOnly
expression [IL Compliance].[D_BLGROUP_SER_SMART_GROUP].[GROUP_TYPE_NAME] in ('Server Smart Group')
filterDefinition
displayName Deleted ServerGroup Filter
expression [IL Compliance].[D_BLGROUP_SER_SMART_GROUP].[IS_DELETED] =0 and [IL Compliance].[D_BLGROUP_SER_SMART_GROUP].[IS_LATEST_VERSION] =1
tableType table
Query ItemGROUP_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:43:38
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_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemGROUP_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-08-16T14:43:38
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName GROUP_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemPARENT_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-08-16T14:43:38
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName PARENT_GROUP_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemGROUP_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-08-16T14:43:38
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName GROUP_TYPE_NAME
usage attribute
datatype characterLength16
precision 50
scale 0
size 102
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemPARENT_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-08-16T14:43:38
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
Query ItemCREATED_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-08-16T14:43:38
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName CREATED_BY_ROLE_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemFQ_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-08-16T14:43:38
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
Query ItemCREATED_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-08-16T14:43:38
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName CREATED_BY_USER_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemMODIFIED_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-08-16T14:43:38
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName MODIFIED_BY_ROLE_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemMODIFIED_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-08-16T14:43:38
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName MODIFIED_BY_USER_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemBL_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-08-16T14:43:38
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName BL_ACL_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemNAME
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-08-16T14:43:38
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
Query ItemDESCRIPTION
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-08-16T14:43:38
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
Query ItemDATE_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-08-16T14:43:38
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
Query ItemDATE_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-08-16T14:43:38
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
Query ItemIS_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-08-16T14:43:38
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName IS_MATCH_ALL_CONDITIONS
usage fact
datatype int16
precision 0
scale 0
size 2
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemIS_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:43:38
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_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemBL_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:43:38
lastChangedBy primary\BLAdmin(BLAdmins-rename)
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
Query ItemIS_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-08-16T14:43:38
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName IS_LATEST_VERSION
usage fact
datatype int16
precision 0
scale 0
size 2
nullable false
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemSTART_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:43:38
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
Query ItemEND_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:43:38
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
Query SubjectD_BLGROUP_SERVER_GROUP
name (en) D_BLGROUP_SERVER_GROUP
name (zh) (zh) Copy of D_BLGROUP_SER_SMART_GROUP
name (fr) (fr) Copy of D_BLGROUP_SER_SMART_GROUP
name (de) (de) Copy of D_BLGROUP_SER_SMART_GROUP
name (ja) (ja) Copy of D_BLGROUP_SER_SMART_GROUP
name (es) (es) Copy of D_BLGROUP_SER_SMART_GROUP
Status valid
Last Changed 2015-11-26T13:30:53
lastChangedBy Primary\BLAdmin(BLAdmins)
definition
dbQuery
sources
dataSourceRef [].[dataSources].[ORA75]
sql Select * from [ORA75].D_BLGROUP
filters
filterDefinition
displayName ServerGroupsOnly
expression [IL Compliance].[D_BLGROUP_SERVER_GROUP].[GROUP_TYPE_NAME] in ('Server Group')
filterDefinition
displayName SiteAccessFilter
expression [IL Compliance].[D_BLGROUP_SERVER_GROUP].[BL_SITE_ID] IN (#csv(split(',', $account.parameters.siteIdList))#)
filterDefinition
displayName Deleted ServerGroup Filter
expression [IL Compliance].[D_BLGROUP_SERVER_GROUP].[IS_DELETED] =0 and [IL Compliance].[D_BLGROUP_SERVER_GROUP].[IS_LATEST_VERSION] =1
tableType table
Query ItemGROUP_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:43:38
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_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemGROUP_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-08-16T14:43:38
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName GROUP_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemPARENT_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-08-16T14:43:38
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName PARENT_GROUP_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemGROUP_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-08-16T14:43:38
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName GROUP_TYPE_NAME
usage attribute
datatype characterLength16
precision 50
scale 0
size 102
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemPARENT_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-08-16T14:43:38
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
Query ItemCREATED_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-08-16T14:43:38
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName CREATED_BY_ROLE_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemFQ_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-08-16T14:43:38
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
Query ItemCREATED_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-08-16T14:43:38
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName CREATED_BY_USER_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemMODIFIED_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-08-16T14:43:38
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName MODIFIED_BY_ROLE_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemMODIFIED_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-08-16T14:43:38
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName MODIFIED_BY_USER_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemBL_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-08-16T14:43:38
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName BL_ACL_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemNAME
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-08-16T14:43:38
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
Query ItemDESCRIPTION
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-08-16T14:43:38
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
Query ItemDATE_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-08-16T14:43:38
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
Query ItemDATE_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-08-16T14:43:38
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
Query ItemIS_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-08-16T14:43:38
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName IS_MATCH_ALL_CONDITIONS
usage fact
datatype int16
precision 0
scale 0
size 2
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemIS_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:43:38
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_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemBL_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:43:38
lastChangedBy primary\BLAdmin(BLAdmins-rename)
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
Query ItemIS_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-08-16T14:43:38
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName IS_LATEST_VERSION
usage fact
datatype int16
precision 0
scale 0
size 2
nullable false
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemSTART_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:43:38
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
Query ItemEND_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:43:38
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
Query SubjectD_BLGROUP_TEMPLATE
name (en) D_BLGROUP_TEMPLATE
name (zh) (zh) Copy of D_BLGROUP
name (fr) (fr) Copy of D_BLGROUP
name (de) (de) Copy of D_BLGROUP
name (ja) (ja) Copy of D_BLGROUP
name (es) (es) Copy of D_BLGROUP
Status valid
Last Changed 2011-08-16T14:09:24
lastChangedBy primary\BLAdmin(BLAdmins-rename)
definition
dbQuery
sources
dataSourceRef [].[dataSources].[ORA75]
sql Select * from [ORA75].D_BLGROUP
filters
filterDefinition
displayName Site Access Filter
expression [IL Compliance].[D_BLGROUP_TEMPLATE].[BL_SITE_ID] IN (#csv(split(',', $account.parameters.siteIdList))#)
filterDefinition
displayName TemplateGroupsOnly
expression [IL Compliance].[D_BLGROUP_TEMPLATE].[GROUP_TYPE_NAME] in ('Component Template Group')
tableType table
Query ItemGROUP_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-28T18:15:58
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
Query ItemGROUP_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-28T18:16:02
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
Query ItemPARENT_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-28T18:16:02
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
Query ItemGROUP_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-28T15:30:04
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName GROUP_TYPE_NAME
usage attribute
datatype characterLength16
precision 50
scale 0
size 102
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemPARENT_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-28T15:30:04
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
Query ItemCREATED_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-28T18:16:02
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName CREATED_BY_ROLE_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemFQ_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-28T15:30:04
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
Query ItemCREATED_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-28T18:16:02
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName CREATED_BY_USER_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemMODIFIED_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-28T18:16:02
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName MODIFIED_BY_ROLE_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemMODIFIED_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-28T18:16:02
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName MODIFIED_BY_USER_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemBL_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-28T18:16:02
lastChangedBy primary\BLAdmin(BLAdmins-rename)
externalName BL_ACL_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemNAME
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-28T15:30:04
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
Query ItemDESCRIPTION
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-28T15:30:03
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
Query ItemDATE_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-28T15:30:03
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
Query ItemDATE_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-28T15:30:03
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
Query ItemIS_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-28T18:16:17
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
Query ItemIS_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-28T18:16:23
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
Query ItemBL_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-28T18:16:02
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
Query ItemIS_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-28T18:16:23
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
Query ItemSTART_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-28T15:30:03
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
Query ItemEND_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-28T15:30:03
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
Query SubjectD_COMPLIANCE_RULE
name (en) D_COMPLIANCE_RULE
name (zh) D_COMPLIANCE_RULE
name (fr) D_COMPLIANCE_RULE
name (de) D_COMPLIANCE_RULE
name (ja) D_COMPLIANCE_RULE
name (es) D_COMPLIANCE_RULE
Status valid
Last Changed 2008-08-01T15:00:02
definition
dbQuery
sources
dataSourceRef [].[dataSources].[ORA75]
sql Select * from [ORA75].D_COMPLIANCE_RULE
filters
filterDefinition
displayName Site Access Filter
expression [IL Compliance].[D_COMPLIANCE_RULE].[BL_SITE_ID] IN (#csv(split(',', $account.parameters.siteIdList))#)
tableType table
determinants
determinant
name () COMPLIANCE_RULE_HIST_ID
key
refobj [IL Compliance].[D_COMPLIANCE_RULE].[COMPLIANCE_RULE_HIST_ID]
attributes
refobj [IL Compliance].[D_COMPLIANCE_RULE].[BL_SITE_ID]
refobj [IL Compliance].[D_COMPLIANCE_RULE].[COMMENTS]
refobj [IL Compliance].[D_COMPLIANCE_RULE].[COMPLIANCE_RULE_ID]
refobj [IL Compliance].[D_COMPLIANCE_RULE].[CONDITION_ID]
refobj [IL Compliance].[D_COMPLIANCE_RULE].[DATE_CREATED]
refobj [IL Compliance].[D_COMPLIANCE_RULE].[DATE_MODIFIED]
refobj [IL Compliance].[D_COMPLIANCE_RULE].[DESCRIPTION]
refobj [IL Compliance].[D_COMPLIANCE_RULE].[END_DATETIME]
refobj [IL Compliance].[D_COMPLIANCE_RULE].[IS_AUTO_REPAIR]
refobj [IL Compliance].[D_COMPLIANCE_RULE].[IS_COMMENTED_OUT]
refobj [IL Compliance].[D_COMPLIANCE_RULE].[IS_DELETED]
refobj [IL Compliance].[D_COMPLIANCE_RULE].[IS_LATEST_VERSION]
refobj [IL Compliance].[D_COMPLIANCE_RULE].[IS_OVERFLOW]
refobj [IL Compliance].[D_COMPLIANCE_RULE].[NAME]
refobj [IL Compliance].[D_COMPLIANCE_RULE].[OCN]
refobj [IL Compliance].[D_COMPLIANCE_RULE].[REFERENCE_NUMBER]
refobj [IL Compliance].[D_COMPLIANCE_RULE].[REPAIR_ACTION_ID]
refobj [IL Compliance].[D_COMPLIANCE_RULE].[RULE_STRING]
refobj [IL Compliance].[D_COMPLIANCE_RULE].[START_DATETIME]
refobj [IL Compliance].[D_COMPLIANCE_RULE].[TEMPLATE_VERSION_ID]
refobj [IL Compliance].[D_COMPLIANCE_RULE].[TEMPLATE_ID]
refobj [IL Compliance].[D_COMPLIANCE_RULE].[COMPLIANCE_RULE_VERSION_ID]
refobj [IL Compliance].[D_COMPLIANCE_RULE].[OBJECT_OVERFLOW_ID]
canGroup false
identifiesRow true
Query ItemCOMPLIANCE_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:14
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
Query ItemCOMPLIANCE_RULE_ID
name (en) COMPLIANCE_RULE_ID
name (zh) COMPLIANCE_RULE_ID
name (fr) COMPLIANCE_RULE_ID
name (de) COMPLIANCE_RULE_ID
name (ja) COMPLIANCE_RULE_ID
name (es) COMPLIANCE_RULE_ID
Last Changed 2007-10-11T16:00:28
externalName COMPLIANCE_RULE_ID
usage attribute
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemCOMPLIANCE_RULE_VERSION_ID
name (en) COMPLIANCE_RULE_VERSION_ID
name (zh) COMPLIANCE_RULE_VERSION_ID
name (fr) COMPLIANCE_RULE_VERSION_ID
name (de) COMPLIANCE_RULE_VERSION_ID
name (ja) COMPLIANCE_RULE_VERSION_ID
name (es) COMPLIANCE_RULE_VERSION_ID
Last Changed 2008-08-01T15:03:31
externalName COMPLIANCE_RULE_VERSION_ID
usage attribute
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate count
semiAggregate unsupported
Query ItemTEMPLATE_ID
name (en) TEMPLATE_ID
name (zh) TEMPLATE_ID
name (fr) TEMPLATE_ID
name (de) TEMPLATE_ID
name (ja) TEMPLATE_ID
name (es) TEMPLATE_ID
Last Changed 2008-08-01T15:03:33
externalName TEMPLATE_ID
usage attribute
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate count
semiAggregate unsupported
Query ItemTEMPLATE_VERSION_ID
name (en) TEMPLATE_VERSION_ID
name (zh) TEMPLATE_VERSION_ID
name (fr) TEMPLATE_VERSION_ID
name (de) TEMPLATE_VERSION_ID
name (ja) TEMPLATE_VERSION_ID
name (es) TEMPLATE_VERSION_ID
Last Changed 2008-08-01T15:03:33
externalName TEMPLATE_VERSION_ID
usage attribute
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate count
semiAggregate unsupported
Query ItemOCN
name (en) OCN
name (zh) OCN
name (fr) OCN
name (de) OCN
name (ja) OCN
name (es) OCN
Last Changed 2007-10-11T16:00:29
externalName OCN
usage attribute
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemCONDITION_ID
name (en) CONDITION_ID
name (zh) CONDITION_ID
name (fr) CONDITION_ID
name (de) CONDITION_ID
name (ja) CONDITION_ID
name (es) CONDITION_ID
Last Changed 2007-10-11T16:00:29
externalName CONDITION_ID
usage attribute
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemREPAIR_ACTION_ID
name (en) REPAIR_ACTION_ID
name (zh) REPAIR_ACTION_ID
name (fr) REPAIR_ACTION_ID
name (de) REPAIR_ACTION_ID
name (ja) REPAIR_ACTION_ID
name (es) REPAIR_ACTION_ID
Last Changed 2007-10-11T16:00:29
externalName REPAIR_ACTION_ID
usage attribute
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemNAME
name (en) NAME
name (zh) 名称
name (fr) NOM
name (de) NAME
name (ja) 名前
name (es) NOMBRE
Last Changed 2007-10-11T15:56:14
externalName NAME
usage attribute
datatype characterLength16
precision 255
scale 0
size 512
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemDESCRIPTION
name (en) DESCRIPTION
name (zh) 描述
name (fr) DESCRIPTION
name (de) BESCHREIBUNG
name (ja) 説明
name (es) DESCRIPCIÓN
Last Changed 2007-10-11T15:56:14
externalName DESCRIPTION
usage attribute
datatype characterLength16
precision 255
scale 0
size 512
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemCOMMENTS
name (en) COMMENTS
name (zh) 备注
name (fr) COMMENTAIRES
name (de) KOMMENTARE
name (ja) コメント
name (es) COMENTARIOS
Last Changed 2007-10-11T15:56:14
externalName COMMENTS
usage attribute
datatype characterLength16
precision 2000
scale 0
size 4002
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemREFERENCE_NUMBER
name (en) REFERENCE_NUMBER
name (zh) REFERENCE_NUMBER
name (fr) REFERENCE_NUMBER
name (de) REFERENCE_NUMBER
name (ja) REFERENCE_NUMBER
name (es) REFERENCE_NUMBER
Last Changed 2007-10-11T15:56:14
externalName REFERENCE_NUMBER
usage attribute
datatype characterLength16
precision 255
scale 0
size 512
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemBL_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 2007-10-11T15:56:14
externalName BL_SITE_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemRULE_STRING
name (en) RULE_STRING
name (zh) RULE_STRING
name (fr) RULE_STRING
name (de) RULE_STRING
name (ja) RULE_STRING
name (es) RULE_STRING
Last Changed 2007-10-11T15:56:14
externalName RULE_STRING
usage attribute
datatype characterLength16
precision 2000
scale 0
size 4002
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemIS_OVERFLOW
name (en) IS_OVERFLOW
name (zh) IS_OVERFLOW
name (fr) IS_OVERFLOW
name (de) IS_OVERFLOW
name (ja) IS_OVERFLOW
name (es) IS_OVERFLOW
Last Changed 2007-10-11T16:00:29
externalName IS_OVERFLOW
usage attribute
datatype int16
precision 0
scale 0
size 2
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemOBJECT_OVERFLOW_ID
name (en) OBJECT_OVERFLOW_ID
name (zh) OBJECT_OVERFLOW_ID
name (fr) OBJECT_OVERFLOW_ID
name (de) OBJECT_OVERFLOW_ID
name (ja) OBJECT_OVERFLOW_ID
name (es) OBJECT_OVERFLOW_ID
Last Changed 2008-08-20T16:58:28
externalName OBJECT_OVERFLOW_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate count
semiAggregate unsupported
Query ItemIS_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-11T16:00:29
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
Query ItemDATE_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 2007-10-11T15:56:14
externalName DATE_CREATED
usage identifier
datatype dateTime
precision 0
scale 0
size 12
nullable false
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemDATE_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 2007-10-11T15:56:14
externalName DATE_MODIFIED
usage identifier
datatype dateTime
precision 0
scale 0
size 12
nullable false
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemIS_COMMENTED_OUT
name (en) IS_COMMENTED_OUT
name (zh) IS_COMMENTED_OUT
name (fr) IS_COMMENTED_OUT
name (de) IS_COMMENTED_OUT
name (ja) IS_COMMENTED_OUT
name (es) IS_COMMENTED_OUT
Last Changed 2007-10-11T16:00:29
externalName IS_COMMENTED_OUT
usage attribute
datatype int16
precision 0
scale 0
size 2
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemIS_AUTO_REPAIR
name (en) IS_AUTO_REPAIR
name (zh) IS_AUTO_REPAIR
name (fr) IS_AUTO_REPAIR
name (de) IS_AUTO_REPAIR
name (ja) IS_AUTO_REPAIR
name (es) IS_AUTO_REPAIR
Last Changed 2007-10-11T16:00:29
externalName IS_AUTO_REPAIR
usage attribute
datatype int16
precision 0
scale 0
size 2
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemIS_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 2007-10-11T16:00:29
externalName IS_LATEST_VERSION
usage attribute
datatype int16
precision 0
scale 0
size 2
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemSTART_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:14
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
Query ItemEND_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:14
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
RelationshipD_COMPLIANCE_RULE <--> B_COMP_RULE_CR_GROUP
name () D_COMPLIANCE_RULE <--> B_COMP_RULE_CR_GROUP
Status valid
expression [IL Compliance].[D_COMPLIANCE_RULE].[COMPLIANCE_RULE_HIST_ID] =[IL Compliance].[B_COMP_RULE_CR_GROUP].[COMPLIANCE_RULE_HIST_ID]
left
refobj [IL Compliance].[D_COMPLIANCE_RULE]
mincard one
maxcard one
right
refobj [IL Compliance].[B_COMP_RULE_CR_GROUP]
mincard one
maxcard one

RelationshipD_COMPLIANCE_RULE <--> F_COMPLIANCE_RULE_RESULT
name () D_COMPLIANCE_RULE <--> F_COMPLIANCE_RULE_RESULT
Status valid
expression [IL Compliance].[D_COMPLIANCE_RULE].[COMPLIANCE_RULE_HIST_ID] =[IL Compliance].[F_COMPLIANCE_RULE_RESULT].[COMPLIANCE_RULE_HIST_ID]
left
refobj [IL Compliance].[D_COMPLIANCE_RULE]
mincard one
maxcard one
right
refobj [IL Compliance].[F_COMPLIANCE_RULE_RESULT]
mincard one
maxcard many

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

Query SubjectD_COMPLIANCE_RULE_GRP
name (en) D_COMPLIANCE_RULE_GRP
name (zh) D_COMPLIANCE_RULE_GRP
name (fr) D_COMPLIANCE_RULE_GRP
name (de) D_COMPLIANCE_RULE_GRP
name (ja) D_COMPLIANCE_RULE_GRP
name (es) D_COMPLIANCE_RULE_GRP
Status valid
Last Changed 2008-08-01T15:04:46
definition
dbQuery
sources
dataSourceRef [].[dataSources].[ORA75]
sql Select * from [ORA75].D_COMPLIANCE_RULE_GRP
filters
filterDefinition
displayName Site Access Filter
expression [IL Compliance].[D_COMPLIANCE_RULE_GRP].[BL_SITE_ID] IN (#csv(split(',', $account.parameters.siteIdList))#)
tableType table
determinants
determinant
name () CR_GROUP_HIST_ID
key
refobj [IL Compliance].[D_COMPLIANCE_RULE_GRP].[CR_GROUP_HIST_ID]
attributes
refobj [IL Compliance].[D_COMPLIANCE_RULE_GRP].[COMMENTS]
refobj [IL Compliance].[D_COMPLIANCE_RULE_GRP].[CR_GROUP_ID]
refobj [IL Compliance].[D_COMPLIANCE_RULE_GRP].[DESCRIPTION]
refobj [IL Compliance].[D_COMPLIANCE_RULE_GRP].[END_DATETIME]
refobj [IL Compliance].[D_COMPLIANCE_RULE_GRP].[IS_DELETED]
refobj [IL Compliance].[D_COMPLIANCE_RULE_GRP].[IS_LATEST_VERSION]
refobj [IL Compliance].[D_COMPLIANCE_RULE_GRP].[NAME]
refobj [IL Compliance].[D_COMPLIANCE_RULE_GRP].[OCN]
refobj [IL Compliance].[D_COMPLIANCE_RULE_GRP].[REFERENCE_NUMBER]
refobj [IL Compliance].[D_COMPLIANCE_RULE_GRP].[START_DATETIME]
refobj [IL Compliance].[D_COMPLIANCE_RULE_GRP].[BL_SITE_ID]
refobj [IL Compliance].[D_COMPLIANCE_RULE_GRP].[CR_GROUP_VERSION_ID]
canGroup false
identifiesRow true
Query ItemCR_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:15
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
Query ItemCR_GROUP_ID
name (en) CR_GROUP_ID
name (zh) CR_GROUP_ID
name (fr) CR_GROUP_ID
name (de) CR_GROUP_ID
name (ja) CR_GROUP_ID
name (es) CR_GROUP_ID
Last Changed 2007-10-11T16:00:40
externalName CR_GROUP_ID
usage attribute
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemCR_GROUP_VERSION_ID
name (en) CR_GROUP_VERSION_ID
name (zh) CR_GROUP_VERSION_ID
name (fr) CR_GROUP_VERSION_ID
name (de) CR_GROUP_VERSION_ID
name (ja) CR_GROUP_VERSION_ID
name (es) CR_GROUP_VERSION_ID
Last Changed 2008-08-01T15:04:22
externalName CR_GROUP_VERSION_ID
usage attribute
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate count
semiAggregate unsupported
Query ItemOCN
name (en) OCN
name (zh) OCN
name (fr) OCN
name (de) OCN
name (ja) OCN
name (es) OCN
Last Changed 2007-10-11T16:00:42
externalName OCN
usage attribute
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemNAME
name (en) NAME
name (zh) 名称
name (fr) NOM
name (de) NAME
name (ja) 名前
name (es) NOMBRE
Last Changed 2007-10-11T15:56:15
externalName NAME
usage attribute
datatype characterLength16
precision 255
scale 0
size 512
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemDESCRIPTION
name (en) DESCRIPTION
name (zh) 描述
name (fr) DESCRIPTION
name (de) BESCHREIBUNG
name (ja) 説明
name (es) DESCRIPCIÓN
Last Changed 2007-10-11T15:56:15
externalName DESCRIPTION
usage attribute
datatype characterLength16
precision 255
scale 0
size 512
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemCOMMENTS
name (en) COMMENTS
name (zh) 备注
name (fr) COMMENTAIRES
name (de) KOMMENTARE
name (ja) コメント
name (es) COMENTARIOS
Last Changed 2007-10-11T15:56:15
externalName COMMENTS
usage attribute
datatype characterLength16
precision 2000
scale 0
size 4002
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemREFERENCE_NUMBER
name (en) REFERENCE_NUMBER
name (zh) REFERENCE_NUMBER
name (fr) REFERENCE_NUMBER
name (de) REFERENCE_NUMBER
name (ja) REFERENCE_NUMBER
name (es) REFERENCE_NUMBER
Last Changed 2007-10-11T15:56:15
externalName REFERENCE_NUMBER
usage attribute
datatype characterLength16
precision 255
scale 0
size 512
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemBL_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 2008-08-01T15:04:24
externalName BL_SITE_ID
usage attribute
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate count
semiAggregate unsupported
Query ItemIS_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-11T16:00:42
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
Query ItemIS_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 2007-10-11T16:00:42
externalName IS_LATEST_VERSION
usage attribute
datatype int16
precision 0
scale 0
size 2
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemSTART_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:15
externalName START_DATETIME
usage identifier
datatype dateTime
precision 0
scale 0
size 12
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
Query ItemEND_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:15
externalName END_DATETIME
usage identifier
datatype dateTime
precision 0
scale 0
size 12
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 2
RelationshipD_COMPLIANCE_RULE_GRP <--> B_COMP_RULE_CR_GROUP
name () D_COMPLIANCE_RULE_GRP <--> B_COMP_RULE_CR_GROUP
Status valid
expression [IL Compliance].[D_COMPLIANCE_RULE_GRP].[CR_GROUP_HIST_ID] =[IL Compliance].[B_COMP_RULE_CR_GROUP].[CR_GROUP_HIST_ID]
left
refobj [IL Compliance].[D_COMPLIANCE_RULE_GRP]
mincard one
maxcard one
right
refobj [IL Compliance].[B_COMP_RULE_CR_GROUP]
mincard one
maxcard one

RelationshipD_COMPLIANCE_RULE_GRP<-->COMPLIANCE_RULE_GRP_DELETED_BOOLEAN_LOOKUP
name () D_COMPLIANCE_RULE_GRP<-->COMPLIANCE_RULE_GRP_DELETED_BOOLEAN_LOOKUP
Status valid
expression [IL Compliance].[D_COMPLIANCE_RULE_GRP].[IS_DELETED] =[IL Compliance].[COMPLIANCE_RULE_GRP_DELETED_BOOLEAN_LOOKUP].[VAL_ID]
left
refobj [IL Compliance].[D_COMPLIANCE_RULE_GRP]
mincard one
maxcard many
right
refobj [IL Compliance].[COMPLIANCE_RULE_GRP_DELETED_BOOLEAN_LOOKUP]
mincard one
maxcard one

RelationshipD_COMPLIANCE_RULE<-->COMPLIANCE_RULE_DELETED_BOOLEAN_LOOKUP
name () D_COMPLIANCE_RULE<-->COMPLIANCE_RULE_DELETED_BOOLEAN_LOOKUP
Status valid
expression [IL Compliance].[D_COMPLIANCE_RULE].[IS_DELETED] =[IL Compliance].[COMPLIANCE_RULE_DELETED_BOOLEAN_LOOKUP].[VAL_ID]
left
refobj [IL Compliance].[D_COMPLIANCE_RULE]
mincard one
maxcard many
right
refobj [IL Compliance].[COMPLIANCE_RULE_DELETED_BOOLEAN_LOOKUP]
mincard one
maxcard one

Query SubjectD_COMPONENT
name (en) D_COMPONENT
name (zh) 兼容性组件
name (fr) Composant de conformité
name (de) Compliance-Komponente
name (ja) コンプライアンス コンポーネント
name (es) Componente de cumplimiento
Status valid
Last Changed 2011-04-01T18:42:54
lastChangedBy Primary\BLAdmin(BLAdmins)
definition
dbQuery
sources
dataSourceRef [].[dataSources].[ORA75]
sql Select * from D_COMPONENT
filters
filterDefinition
displayName Site Access Filter
expression [IL Compliance].[D_COMPONENT].[BL_SITE_ID] IN (#csv(split(',', $account.parameters.siteIdList))#)
tableType table
Query ItemCOMPONENT_HIST_ID
name (en) COMPONENT_HIST_ID
name (zh) COMPONENT_HIST_ID
name (fr) COMPONENT_HIST_ID
name (de) COMPONENT_HIST_ID
name (ja) COMPONENT_HIST_ID
name (es) COMPONENT_HIST_ID
Last Changed 2010-01-19T17:54:05
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName COMPONENT_HIST_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
Query ItemCOMPONENT_ID
name (en) COMPONENT_ID
name (zh) COMPONENT_ID
name (fr) COMPONENT_ID
name (de) COMPONENT_ID
name (ja) COMPONENT_ID
name (es) COMPONENT_ID
Last Changed 2010-01-19T17:54:05
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName COMPONENT_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
Query ItemCOMPONENT_VERSION_ID
name (en) COMPONENT_VERSION_ID
name (zh) COMPONENT_VERSION_ID
name (fr) COMPONENT_VERSION_ID
name (de) COMPONENT_VERSION_ID
name (ja) COMPONENT_VERSION_ID
name (es) COMPONENT_VERSION_ID
Last Changed 2010-01-19T17:54:05
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName COMPONENT_VERSION_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
Query ItemOCN
name (en) OCN
name (zh) OCN
name (fr) OCN
name (de) OCN
name (ja) OCN
name (es) OCN
Last Changed 2010-01-19T17:54:05
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName OCN
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
Query ItemBL_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-01-19T17:54:05
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName BL_VALUE_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
Query ItemSERVER_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 2010-01-19T17:54:05
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName SERVER_HIST_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
Query ItemTEMPLATE_HIST_ID
name (en) TEMPLATE_HIST_ID
name (zh) TEMPLATE_HIST_ID
name (fr) TEMPLATE_HIST_ID
name (de) TEMPLATE_HIST_ID
name (ja) TEMPLATE_HIST_ID
name (es) TEMPLATE_HIST_ID
Last Changed 2010-01-19T17:54:04
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName TEMPLATE_HIST_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemPROTOTYPE_BL_VALUE_ID
name (en) PROTOTYPE_BL_VALUE_ID
name (zh) PROTOTYPE_BL_VALUE_ID
name (fr) PROTOTYPE_BL_VALUE_ID
name (de) PROTOTYPE_BL_VALUE_ID
name (ja) PROTOTYPE_BL_VALUE_ID
name (es) PROTOTYPE_BL_VALUE_ID
Last Changed 2010-01-19T17:54:04
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName PROTOTYPE_BL_VALUE_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemTEMPLATE_ID
name (en) TEMPLATE_ID
name (zh) TEMPLATE_ID
name (fr) TEMPLATE_ID
name (de) TEMPLATE_ID
name (ja) TEMPLATE_ID
name (es) TEMPLATE_ID
Last Changed 2010-01-19T17:54:04
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName TEMPLATE_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
Query ItemTEMPLATE_VERSION_ID
name (en) TEMPLATE_VERSION_ID
name (zh) TEMPLATE_VERSION_ID
name (fr) TEMPLATE_VERSION_ID
name (de) TEMPLATE_VERSION_ID
name (ja) TEMPLATE_VERSION_ID
name (es) TEMPLATE_VERSION_ID
Last Changed 2010-01-19T17:54:04
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName TEMPLATE_VERSION_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
Query ItemCREATED_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-01-19T17:54:04
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName CREATED_BY_ROLE_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemCREATED_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-01-19T17:54:04
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName CREATED_BY_USER_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemMODIFIED_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-01-19T17:54:04
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName MODIFIED_BY_ROLE_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemMODIFIED_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-01-19T17:54:04
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName MODIFIED_BY_USER_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemBL_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-01-19T17:54:04
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName BL_ACL_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
Query ItemNAME
name (en) NAME
name (zh) 名称
name (fr) NOM
name (de) NAME
name (ja) 名前
name (es) NOMBRE
Last Changed 2010-01-19T17:54:04
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName NAME
usage attribute
datatype characterLength16
precision 255
scale 0
size 512
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDESCRIPTION
name (en) DESCRIPTION
name (zh) 描述
name (fr) DESCRIPTION
name (de) BESCHREIBUNG
name (ja) 説明
name (es) DESCRIPCIÓN
Last Changed 2010-01-19T17:54:04
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName DESCRIPTION
usage attribute
datatype characterLength16
precision 255
scale 0
size 512
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_SAVED_EXPLICITLY
name (en) IS_SAVED_EXPLICITLY
name (zh) IS_SAVED_EXPLICITLY
name (fr) IS_SAVED_EXPLICITLY
name (de) IS_SAVED_EXPLICITLY
name (ja) IS_SAVED_EXPLICITLY
name (es) IS_SAVED_EXPLICITLY
Last Changed 2010-01-19T17:54:04
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_SAVED_EXPLICITLY
usage fact
datatype int16
precision 0
scale 0
size 2
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_VALID
name (en) IS_VALID
name (zh) IS_VALID
name (fr) IS_VALID
name (de) IS_VALID
name (ja) IS_VALID
name (es) IS_VALID
Last Changed 2010-01-19T17:54:04
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_VALID
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
Query ItemDATE_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-01-19T17:54:04
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName DATE_CREATED
usage identifier
datatype dateTime
precision 0
scale 0
size 12
nullable false
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDATE_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-01-19T17:54:04
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName DATE_MODIFIED
usage identifier
datatype dateTime
precision 0
scale 0
size 12
nullable false
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_EXCLUDED
name (en) IS_EXCLUDED
name (zh) IS_EXCLUDED
name (fr) IS_EXCLUDED
name (de) IS_EXCLUDED
name (ja) IS_EXCLUDED
name (es) IS_EXCLUDED
Last Changed 2010-01-19T17:54:04
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_EXCLUDED
usage fact
datatype int16
precision 0
scale 0
size 2
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-01-19T17:54:04
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_DELETED
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
Query ItemBL_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-01-19T17:54:04
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
Query ItemIS_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-01-19T17:54:04
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_LATEST_VERSION
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
Query ItemSTART_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-01-19T17:54:04
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_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemEND_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-01-19T17:54:04
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_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query SubjectD_COMPONENT_EXCEPTION
name (en) D_COMPONENT_EXCEPTION
name (zh) D_COMPONENT_EXCEPTION
name (fr) D_COMPONENT_EXCEPTION
name (de) D_COMPONENT_EXCEPTION
name (ja) D_COMPONENT_EXCEPTION
name (es) D_COMPONENT_EXCEPTION
Status valid
Last Changed 2010-01-12T17:10:08
lastChangedBy Primary\GRB(GlobalReportAdmins)
definition
dbQuery
sources
dataSourceRef [].[dataSources].[ORA75]
sql Select * from [ORA75].D_COMPONENT_EXCEPTION
filters
filterDefinition
displayName Site Access Filter
expression [IL Compliance].[D_COMPONENT_EXCEPTION].[BL_SITE_ID] IN (#csv(split(',', $account.parameters.siteIdList))#)
tableType table
Query ItemCOMPONENT_EXCEPTION_HIST_ID
name (en) COMPONENT_EXCEPTION_HIST_ID
name (zh) COMPONENT_EXCEPTION_HIST_ID
name (fr) COMPONENT_EXCEPTION_HIST_ID
name (de) COMPONENT_EXCEPTION_HIST_ID
name (ja) COMPONENT_EXCEPTION_HIST_ID
name (es) COMPONENT_EXCEPTION_HIST_ID
Last Changed 2010-01-12T17:10:18
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName COMPONENT_EXCEPTION_HIST_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemCOMPONENT_EXCEPTION_ID
name (en) COMPONENT_EXCEPTION_ID
name (zh) COMPONENT_EXCEPTION_ID
name (fr) COMPONENT_EXCEPTION_ID
name (de) COMPONENT_EXCEPTION_ID
name (ja) COMPONENT_EXCEPTION_ID
name (es) COMPONENT_EXCEPTION_ID
Last Changed 2010-01-12T17:10:19
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName COMPONENT_EXCEPTION_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemNAME
name (en) NAME
name (zh) 名称
name (fr) NOM
name (de) NAME
name (ja) 名前
name (es) NOMBRE
Last Changed 2010-01-12T17:05:08
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName NAME
usage attribute
datatype characterLength16
precision 255
scale 0
size 512
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDESCRIPTION
name (en) DESCRIPTION
name (zh) 描述
name (fr) DESCRIPTION
name (de) BESCHREIBUNG
name (ja) 説明
name (es) DESCRIPCIÓN
Last Changed 2010-01-12T17:05:08
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName DESCRIPTION
usage attribute
datatype characterLength16
precision 255
scale 0
size 512
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemROLE_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-01-12T17:10:19
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName ROLE_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemUSER_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-01-12T17:10:19
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName USER_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDATE_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-01-12T17:05:08
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDATE_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-01-12T17:05:08
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemCOMMENTS
name (en) COMMENTS
name (zh) 备注
name (fr) COMMENTAIRES
name (de) KOMMENTARE
name (ja) コメント
name (es) COMENTARIOS
Last Changed 2010-01-12T17:05:08
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName COMMENTS
usage attribute
datatype characterLength16
precision 2000
scale 0
size 4002
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemREFERENCE_NUMBER
name (en) REFERENCE_NUMBER
name (zh) REFERENCE_NUMBER
name (fr) REFERENCE_NUMBER
name (de) REFERENCE_NUMBER
name (ja) REFERENCE_NUMBER
name (es) REFERENCE_NUMBER
Last Changed 2010-01-12T17:05:08
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName REFERENCE_NUMBER
usage attribute
datatype characterLength16
precision 255
scale 0
size 512
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemEXPIRATION_DATE
name (en) EXPIRATION_DATE
name (zh) EXPIRATION_DATE
name (fr) EXPIRATION_DATE
name (de) EXPIRATION_DATE
name (ja) EXPIRATION_DATE
name (es) EXPIRATION_DATE
Last Changed 2010-01-12T17:05:08
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName EXPIRATION_DATE
usage identifier
datatype dateTime
precision 0
scale 0
size 12
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-01-12T17:10:27
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_DELETED
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemBL_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-01-12T17:10:19
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-01-12T17:10:28
lastChangedBy Primary\GRB(GlobalReportAdmins)
externalName IS_LATEST_VERSION
usage attribute
datatype decimal
precision 1
scale 0
size 1
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemSTART_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-01-12T17:05:07
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemEND_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-01-12T17:05:07
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_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
RelationshipD_COMPONENT_EXCEPTION <--> F_COMPONENT_EXCEPTION
name () D_COMPONENT_EXCEPTION <--> F_COMPONENT_EXCEPTION
Status valid
expression [IL Compliance].[D_COMPONENT_EXCEPTION].[COMPONENT_EXCEPTION_HIST_ID] =[IL Compliance].[F_DCOMPONENT_EXCEPTION].[COMPONENT_EXCEPTION_HIST_ID]
left
refobj [IL Compliance].[D_COMPONENT_EXCEPTION]
mincard one
maxcard one
right
refobj [IL Compliance].[F_DCOMPONENT_EXCEPTION]
mincard one
maxcard many

RelationshipD_COMPONENT_EXCEPTION<-->COMPLIANCE_COMPONENT_EXCEPTION_DELETED_BOOLEAN_LOOKUP
name () D_COMPONENT_EXCEPTION<-->COMPLIANCE_COMPONENT_EXCEPTION_DELETED_BOOLEAN_LOOKUP
Status valid
expression [IL Compliance].[D_COMPONENT_EXCEPTION].[IS_DELETED] =[IL Compliance].[COMPLIANCE_COMPONENT_EXCEPTION_DELETED_BOOLEAN_LOOKUP].[VAL_ID]
left
refobj [IL Compliance].[D_COMPONENT_EXCEPTION]
mincard one
maxcard many
right
refobj [IL Compliance].[COMPLIANCE_COMPONENT_EXCEPTION_DELETED_BOOLEAN_LOOKUP]
mincard one
maxcard one

RelationshipD_COMPONENT<-->COMPLIANCE_COMPONENT_DELETED_BOOLEAN_LOOKUP
name () D_COMPONENT<-->COMPLIANCE_COMPONENT_DELETED_BOOLEAN_LOOKUP
Status valid
expression [IL Compliance].[D_COMPONENT].[IS_DELETED] =[IL Compliance].[COMPLIANCE_COMPONENT_DELETED_BOOLEAN_LOOKUP].[VAL_ID]
left
refobj [IL Compliance].[D_COMPONENT]
mincard one
maxcard many
right
refobj [IL Compliance].[COMPLIANCE_COMPONENT_DELETED_BOOLEAN_LOOKUP]
mincard one
maxcard one

Query SubjectD_DATE
name (en) D_DATE
name (zh) (zh) D_DATE
name (fr) (fr) D_DATE
name (de) (de) D_DATE
name (ja) (ja) D_DATE
name (es) (es) D_DATE
Status valid
Last Changed 2011-04-01T19:15:24
lastChangedBy Primary\BLAdmin(BLAdmins)
definition
dbQuery
sources
dataSourceRef [].[dataSources].[ORA75]
sql Select * from [ORA75].D_DATE
tableType table
Query ItemDATE_ID
name (en) DATE_ID
name (zh) (zh) DATE_ID
name (fr) (fr) DATE_ID
name (de) (de) DATE_ID
name (ja) (ja) DATE_ID
name (es) (es) DATE_ID
Last Changed 2011-04-01T19:15:23
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName DATE_ID
usage fact
datatype decimal
precision 19
scale 0
size 10
nullable false
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemFULL_DATE
name (en) FULL_DATE
name (zh) (zh) FULL_DATE
name (fr) (fr) FULL_DATE
name (de) (de) FULL_DATE
name (ja) (ja) FULL_DATE
name (es) (es) FULL_DATE
Last Changed 2011-04-01T19:15:23
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName FULL_DATE
usage identifier
datatype dateTime
precision 0
scale 0
size 12
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemDAY_OF_WEEK
name (en) DAY_OF_WEEK
name (zh) (zh) DAY_OF_WEEK
name (fr) (fr) DAY_OF_WEEK
name (de) (de) DAY_OF_WEEK
name (ja) (ja) DAY_OF_WEEK
name (es) (es) DAY_OF_WEEK
Last Changed 2011-04-01T19:15:23
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName DAY_OF_WEEK
usage attribute
datatype characterLength16
precision 20
scale 0
size 42
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemDAY_IN_MONTH
name (en) DAY_IN_MONTH
name (zh) (zh) DAY_IN_MONTH
name (fr) (fr) DAY_IN_MONTH
name (de) (de) DAY_IN_MONTH
name (ja) (ja) DAY_IN_MONTH
name (es) (es) DAY_IN_MONTH
Last Changed 2011-04-01T19:15:23
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName DAY_IN_MONTH
usage attribute
datatype characterLength16
precision 20
scale 0
size 42
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemDAY_NUMBER_IN_YEAR
name (en) DAY_NUMBER_IN_YEAR
name (zh) (zh) DAY_NUMBER_IN_YEAR
name (fr) (fr) DAY_NUMBER_IN_YEAR
name (de) (de) DAY_NUMBER_IN_YEAR
name (ja) (ja) DAY_NUMBER_IN_YEAR
name (es) (es) DAY_NUMBER_IN_YEAR
Last Changed 2011-04-01T19:15:23
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName DAY_NUMBER_IN_YEAR
usage attribute
datatype characterLength16
precision 20
scale 0
size 42
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemHOLIDAY
name (en) HOLIDAY
name (zh) (zh) HOLIDAY
name (fr) (fr) HOLIDAY
name (de) (de) HOLIDAY
name (ja) (ja) HOLIDAY
name (es) (es) HOLIDAY
Last Changed 2011-04-01T19:15:23
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName HOLIDAY
usage fact
datatype int16
precision 0
scale 0
size 2
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemWEEKDAY_FLAG
name (en) WEEKDAY_FLAG
name (zh) (zh) WEEKDAY_FLAG
name (fr) (fr) WEEKDAY_FLAG
name (de) (de) WEEKDAY_FLAG
name (ja) (ja) WEEKDAY_FLAG
name (es) (es) WEEKDAY_FLAG
Last Changed 2011-04-01T19:15:23
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName WEEKDAY_FLAG
usage fact
datatype int16
precision 0
scale 0
size 2
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemWEEK_NUM_IN_YEAR
name (en) WEEK_NUM_IN_YEAR
name (zh) (zh) WEEK_NUM_IN_YEAR
name (fr) (fr) WEEK_NUM_IN_YEAR
name (de) (de) WEEK_NUM_IN_YEAR
name (ja) (ja) WEEK_NUM_IN_YEAR
name (es) (es) WEEK_NUM_IN_YEAR
Last Changed 2011-04-01T19:15:23
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName WEEK_NUM_IN_YEAR
usage attribute
datatype characterLength16
precision 20
scale 0
size 42
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemCAL_MONTH
name (en) CAL_MONTH
name (zh) (zh) CAL_MONTH
name (fr) (fr) CAL_MONTH
name (de) (de) CAL_MONTH
name (ja) (ja) CAL_MONTH
name (es) (es) CAL_MONTH
Last Changed 2011-04-01T19:15:23
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName CAL_MONTH
usage attribute
datatype characterLength16
precision 20
scale 0
size 42
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemCAL_QUARTER
name (en) CAL_QUARTER
name (zh) (zh) CAL_QUARTER
name (fr) (fr) CAL_QUARTER
name (de) (de) CAL_QUARTER
name (ja) (ja) CAL_QUARTER
name (es) (es) CAL_QUARTER
Last Changed 2011-04-01T19:15:23
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName CAL_QUARTER
usage attribute
datatype characterLength16
precision 20
scale 0
size 42
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemCAL_YEAR
name (en) CAL_YEAR
name (zh) (zh) CAL_YEAR
name (fr) (fr) CAL_YEAR
name (de) (de) CAL_YEAR
name (ja) (ja) CAL_YEAR
name (es) (es) CAL_YEAR
Last Changed 2011-04-01T19:15:23
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName CAL_YEAR
usage attribute
datatype characterLength16
precision 20
scale 0
size 42
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemDAY_IN_FISCAL_MONTH
name (en) DAY_IN_FISCAL_MONTH
name (zh) (zh) DAY_IN_FISCAL_MONTH
name (fr) (fr) DAY_IN_FISCAL_MONTH
name (de) (de) DAY_IN_FISCAL_MONTH
name (ja) (ja) DAY_IN_FISCAL_MONTH
name (es) (es) DAY_IN_FISCAL_MONTH
Last Changed 2011-04-01T19:15:23
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName DAY_IN_FISCAL_MONTH
usage attribute
datatype characterLength16
precision 20
scale 0
size 42
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemFISCAL_WEEK
name (en) FISCAL_WEEK
name (zh) (zh) FISCAL_WEEK
name (fr) (fr) FISCAL_WEEK
name (de) (de) FISCAL_WEEK
name (ja) (ja) FISCAL_WEEK
name (es) (es) FISCAL_WEEK
Last Changed 2011-04-01T19:15:23
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName FISCAL_WEEK
usage attribute
datatype characterLength16
precision 20
scale 0
size 42
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemFISCAL_MONTH
name (en) FISCAL_MONTH
name (zh) (zh) FISCAL_MONTH
name (fr) (fr) FISCAL_MONTH
name (de) (de) FISCAL_MONTH
name (ja) (ja) FISCAL_MONTH
name (es) (es) FISCAL_MONTH
Last Changed 2011-04-01T19:15:23
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName FISCAL_MONTH
usage attribute
datatype characterLength16
precision 20
scale 0
size 42
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemFISCAL_QUARTER
name (en) FISCAL_QUARTER
name (zh) (zh) FISCAL_QUARTER
name (fr) (fr) FISCAL_QUARTER
name (de) (de) FISCAL_QUARTER
name (ja) (ja) FISCAL_QUARTER
name (es) (es) FISCAL_QUARTER
Last Changed 2011-04-01T19:15:23
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName FISCAL_QUARTER
usage attribute
datatype characterLength16
precision 20
scale 0
size 42
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
Query ItemFISCAL_YEAR
name (en) FISCAL_YEAR
name (zh) (zh) FISCAL_YEAR
name (fr) (fr) FISCAL_YEAR
name (de) (de) FISCAL_YEAR
name (ja) (ja) FISCAL_YEAR
name (es) (es) FISCAL_YEAR
Last Changed 2011-04-01T19:15:22
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName FISCAL_YEAR
usage attribute
datatype characterLength16
precision 20
scale 0
size 42
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8ISO8859P1
collationSequenceLevel 0
RelationshipD_DATE <--> F_JOB_RUN
name () D_DATE <--> F_JOB_RUN
Status valid
expression [IL Compliance].[D_DATE].[DATE_ID] =[IL Compliance].[F_JOB_RUN].[START_DATE_ID]
left
refobj [IL Compliance].[D_DATE]
mincard one
maxcard one
right
refobj [IL Compliance].[F_JOB_RUN]
mincard one
maxcard many

Query SubjectD_JOB
name (en) D_JOB
name (zh) (zh) D_JOB
name (fr) (fr) D_JOB
name (de) (de) D_JOB
name (ja) (ja) D_JOB
name (es) (es) D_JOB
Status valid
Last Changed 2014-07-15T15:26:19
lastChangedBy Primary\BLAdmin(BLAdmins)
definition
dbQuery
sources
dataSourceRef [].[dataSources].[ORA75]
sql Select D_JOB.* from [ORA75].D_JOB D_JOB, ( select distinct JOB_ID, BL_SITE_ID from B_JOB_ALLOWED_ROLE BR where (BR.ROLE_ID in (#$account.parameters.roleId#, 1000008) OR (#$account.parameters.roleId# in (3, 10, 11, 1000010)) ) AND 0=(#$account.parameters.show_all_roles_data_for_user#) UNION select DISTINCT BR.JOB_ID, BR.BL_SITE_ID from D_BLROLE DR,D_BLUSER DU ,B_ROLE_USER BRU,B_JOB_ALLOWED_ROLE BR WHERE DR.ROLE_HIST_ID=BRU.ROLE_HIST_ID AND BRU.USER_HIST_ID=DU.USER_HIST_ID AND DU.IS_DELETED=0 AND DU.NAME =#sq($account.personalInfo.userName)# AND DR.ROLE_ID=BR.ROLE_ID AND DR.BL_SITE_ID=BR.BL_SITE_ID AND 1=(#$account.parameters.show_all_roles_data_for_user#) AND DR.ROLE_ID not in (3, 10, 11, 1000010) Union select DISTINCT BR.JOB_ID, BR.BL_SITE_ID from B_JOB_ALLOWED_ROLE BR where BR.ROLE_ID=1000008 AND NOT EXISTS ( select DR.ROLE_ID from D_BLROLE DR,D_BLUSER DU ,B_ROLE_USER BRU where DR.ROLE_HIST_ID=BRU.ROLE_HIST_ID AND BRU.USER_HIST_ID=DU.USER_HIST_ID AND DU.IS_DELETED=0 AND DU.NAME= (#sq($account.personalInfo.userName)#) AND 1=(#$account.parameters.show_all_roles_data_for_user#) AND DR.ROLE_ID in (3, 10, 11, 1000010)) UNION SELECT DISTINCT BR.JOB_ID, BR.BL_SITE_ID from B_JOB_ALLOWED_ROLE BR where EXISTS ( select DR.ROLE_ID from D_BLROLE DR, B_ROLE_USER BRU, D_BLUSER DU where DR.ROLE_HIST_ID=BRU.ROLE_HIST_ID AND BRU.USER_HIST_ID=DU.USER_HIST_ID AND DU.IS_DELETED=0 AND DU.NAME=#sq($account.personalInfo.userName)# AND 1=(#$account.parameters.show_all_roles_data_for_user#) AND DR.ROLE_ID in (3, 10, 11, 1000010))) BJAR WHERE D_JOB.BL_SITE_ID=BJAR.BL_SITE_ID AND D_JOB.JOB_ID=BJAR.JOB_ID
filters
filterDefinition
displayName SiteAccessFilter
expression [IL Compliance].[D_JOB].[BL_SITE_ID] in (#$account.parameters.siteIdList# )
filterDefinition
displayName ComplianceJobs
expression [IL Compliance].[D_JOB].[OBJECT_TYPE_ID] in (5106,5126)
tableType table
Query ItemJOB_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 2011-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName JOB_HIST_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
Query ItemJOB_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 2011-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName JOB_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
Query ItemJOB_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 2011-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName JOB_VERSION_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
Query ItemOCN
name (en) OCN
name (zh) (zh) OCN
name (fr) (fr) OCN
name (de) (de) OCN
name (ja) (ja) OCN
name (es) (es) OCN
Last Changed 2011-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName OCN
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
Query ItemGROUP_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-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName GROUP_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemOBJECT_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 2011-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName OBJECT_TYPE_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemCREATED_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-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName CREATED_BY_ROLE_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemCREATED_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-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName CREATED_BY_USER_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemMODIFIED_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-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName MODIFIED_BY_ROLE_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemMODIFIED_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-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName MODIFIED_BY_USER_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemBL_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-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName BL_ACL_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
Query ItemBL_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-04-01T19:10:21
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_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemNAME
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-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName NAME
usage attribute
datatype characterLength16
precision 255
scale 0
size 512
nullable false
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemFQ_NAME
name (en) FQ_NAME
name (zh) (zh) FQ_NAME
name (fr) (fr) FQ_NAME
name (de) (de) FQ_NAME
name (ja) (ja) FQ_NAME
name (es) (es) FQ_NAME
Last Changed 2011-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName FQ_NAME
usage attribute
datatype characterLength16
precision 600
scale 0
size 1202
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDESCRIPTION
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-04-01T19:10:21
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_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemLOCKED_BY_USER_ID
name (en) LOCKED_BY_USER_ID
name (zh) (zh) LOCKED_BY_USER_ID
name (fr) (fr) LOCKED_BY_USER_ID
name (de) (de) LOCKED_BY_USER_ID
name (ja) (ja) LOCKED_BY_USER_ID
name (es) (es) LOCKED_BY_USER_ID
Last Changed 2011-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName LOCKED_BY_USER_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_SAVED_EXPLICITLY
name (en) IS_SAVED_EXPLICITLY
name (zh) (zh) IS_SAVED_EXPLICITLY
name (fr) (fr) IS_SAVED_EXPLICITLY
name (de) (de) IS_SAVED_EXPLICITLY
name (ja) (ja) IS_SAVED_EXPLICITLY
name (es) (es) IS_SAVED_EXPLICITLY
Last Changed 2011-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName IS_SAVED_EXPLICITLY
usage fact
datatype int16
precision 0
scale 0
size 2
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDATE_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-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName DATE_CREATED
usage identifier
datatype dateTime
precision 0
scale 0
size 12
nullable false
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDATE_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-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName DATE_MODIFIED
usage identifier
datatype dateTime
precision 0
scale 0
size 12
nullable false
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName IS_DELETED
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
Query ItemBL_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-04-01T19:10:21
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_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemIS_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-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName IS_LATEST_VERSION
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
Query ItemSTART_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-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName START_DATETIME
usage identifier
datatype dateTime
precision 0
scale 0
size 12
nullable false
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemEND_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-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName END_DATETIME
usage identifier
datatype dateTime
precision 0
scale 0
size 12
nullable false
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemPARENT_JOB_ID
name (en) PARENT_JOB_ID
name (zh) (zh) PARENT_JOB_ID
name (fr) (fr) PARENT_JOB_ID
name (de) (de) PARENT_JOB_ID
name (ja) (ja) PARENT_JOB_ID
name (es) (es) PARENT_JOB_ID
Last Changed 2011-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName PARENT_JOB_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemPARENT_JOB_VERSION_ID
name (en) PARENT_JOB_VERSION_ID
name (zh) (zh) PARENT_JOB_VERSION_ID
name (fr) (fr) PARENT_JOB_VERSION_ID
name (de) (de) PARENT_JOB_VERSION_ID
name (ja) (ja) PARENT_JOB_VERSION_ID
name (es) (es) PARENT_JOB_VERSION_ID
Last Changed 2011-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName PARENT_JOB_VERSION_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemPARENT_JOB_NAME
name (en) PARENT_JOB_NAME
name (zh) (zh) PARENT_JOB_NAME
name (fr) (fr) PARENT_JOB_NAME
name (de) (de) PARENT_JOB_NAME
name (ja) (ja) PARENT_JOB_NAME
name (es) (es) PARENT_JOB_NAME
Last Changed 2011-04-01T19:10:21
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName PARENT_JOB_NAME
usage attribute
datatype characterLength16
precision 255
scale 0
size 512
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDATE_DELETED
name (en) DATE_DELETED
name (zh) (zh) DATE_DELETED
name (fr) (fr) DATE_DELETED
name (de) (de) DATE_DELETED
name (ja) (ja) DATE_DELETED
name (es) (es) DATE_DELETED
Last Changed 2011-07-05T19:28:07
lastChangedBy OM82DEV\BLAdmin(BLAdmins)
externalName DATE_DELETED
usage identifier
datatype dateTime
precision 0
scale 0
size 12
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemJOB_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 2011-07-05T19:28:07
lastChangedBy OM82DEV\BLAdmin(BLAdmins)
externalName JOB_TYPE
usage attribute
datatype characterLength16
precision 255
scale 0
size 512
nullable true
regularAggregate unsupported
semiAggregate unsupported
collationSequenceName EN_OR_WE8MSWIN1252
collationSequenceLevel 0
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
RelationshipD_JOB <--> F_JOB_RUN
name () D_JOB <--> F_JOB_RUN
Status valid
expression [IL Compliance].[D_JOB].[JOB_HIST_ID] =[IL Compliance].[F_JOB_RUN].[JOB_HIST_ID]
left
refobj [IL Compliance].[D_JOB]
mincard one
maxcard one
right
refobj [IL Compliance].[F_JOB_RUN]
mincard one
maxcard many

RelationshipD_JOB<-->COMPLIANCE_JOB_DELETED_BOOLEAN_LOOKUP
name () D_JOB<-->COMPLIANCE_JOB_DELETED_BOOLEAN_LOOKUP
Status valid
expression [IL Compliance].[D_JOB].[IS_DELETED] =[IL Compliance].[COMPLIANCE_JOB_DELETED_BOOLEAN_LOOKUP].[VAL_ID]
left
refobj [IL Compliance].[D_JOB]
mincard one
maxcard many
right
refobj [IL Compliance].[COMPLIANCE_JOB_DELETED_BOOLEAN_LOOKUP]
mincard one
maxcard one

Query SubjectD_SERVER
name (en) D_SERVER
name (zh) 兼容性服务器
name (fr) Serveur de conformité
name (de) Compliance-Server
name (ja) コンプライアンス サーバ1
name (es) Servidor de cumplimiento
Status valid
Last Changed 2014-05-13T23:33:43
lastChangedBy Primary\BLAdmin(GlobalReportAdmins)
definition
dbQuery
sources
dataSourceRef [].[dataSources].[ORA75]
sql Select D_SERVER.* from [ORA75].D_SERVER D_SERVER, ( select distinct SERVER_ID, BL_SITE_ID from B_SERVER_ALLOWED_ROLE BR where (BR.ROLE_ID in (#$account.parameters.roleId#, 1000008) OR (#$account.parameters.roleId# in (3, 10, 11, 1000010)) ) AND 0=(#$account.parameters.show_all_roles_data_for_user#) UNION select DISTINCT BR.SERVER_ID, BR.BL_SITE_ID from D_BLROLE DR,D_BLUSER DU ,B_ROLE_USER BRU,B_SERVER_ALLOWED_ROLE BR WHERE DR.ROLE_HIST_ID=BRU.ROLE_HIST_ID AND BRU.USER_HIST_ID=DU.USER_HIST_ID AND DU.IS_DELETED=0 AND DU.NAME =#sq($account.personalInfo.userName)# AND DR.ROLE_ID=BR.ROLE_ID AND DR.BL_SITE_ID=BR.BL_SITE_ID AND 1=(#$account.parameters.show_all_roles_data_for_user#) AND DR.ROLE_ID not in (3, 10, 11, 1000010) Union select DISTINCT BR.SERVER_ID, BR.BL_SITE_ID from B_SERVER_ALLOWED_ROLE BR where BR.ROLE_ID=1000008 AND NOT EXISTS ( select DR.ROLE_ID from D_BLROLE DR,D_BLUSER DU ,B_ROLE_USER BRU where DR.ROLE_HIST_ID=BRU.ROLE_HIST_ID AND BRU.USER_HIST_ID=DU.USER_HIST_ID AND DU.IS_DELETED=0 AND DU.NAME= (#sq($account.personalInfo.userName)#) AND 1=(#$account.parameters.show_all_roles_data_for_user#) AND DR.ROLE_ID in (3, 10, 11, 1000010)) UNION SELECT DISTINCT BR.SERVER_ID, BR.BL_SITE_ID from B_SERVER_ALLOWED_ROLE BR where EXISTS ( select DR.ROLE_ID from D_BLROLE DR, B_ROLE_USER BRU, D_BLUSER DU where DR.ROLE_HIST_ID=BRU.ROLE_HIST_ID AND BRU.USER_HIST_ID=DU.USER_HIST_ID AND DU.IS_DELETED=0 AND DU.NAME=#sq($account.personalInfo.userName)# AND 1=(#$account.parameters.show_all_roles_data_for_user#) AND DR.ROLE_ID in (3, 10, 11, 1000010)) ) BSAR WHERE D_SERVER.BL_SITE_ID=BSAR.BL_SITE_ID AND D_SERVER.SERVER_ID=BSAR.SERVER_ID
filters
filterDefinition
displayName Site Access Filter
expression [IL Compliance].[D_SERVER].[BL_SITE_ID] IN (#csv(split(',', $account.parameters.siteIdList))#)
tableType table
Query ItemSERVER_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 2008-10-10T19:59:36
externalName SERVER_HIST_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemSERVER_ID
name (en) SERVER_ID
name (zh) SERVER_ID
name (fr) SERVER_ID
name (de) SERVER_ID
name (ja) SERVER_ID
name (es) SERVER_ID
Last Changed 2008-10-10T19:59:39
externalName SERVER_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable false
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemBL_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 2008-10-10T19:59:39
externalName BL_VALUE_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemOS_ID
name (en) OS_ID
name (zh) OS_ID
name (fr) OS_ID
name (de) OS_ID
name (ja) OS_ID
name (es) OS_ID
Last Changed 2008-10-10T19:59:39
externalName OS_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemDEVICE_TYPE_ID
name (en) DEVICE_TYPE_ID
name (zh) DEVICE_TYPE_ID
name (fr) DEVICE_TYPE_ID
name (de) DEVICE_TYPE_ID
name (ja) DEVICE_TYPE_ID
name (es) DEVICE_TYPE_ID
Last Changed 2008-10-10T19:59:39
externalName DEVICE_TYPE_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemPM_DEVICE_ID
name (en) PM_DEVICE_ID
name (zh) PM_DEVICE_ID
name (fr) PM_DEVICE_ID
name (de) PM_DEVICE_ID
name (ja) PM_DEVICE_ID
name (es) PM_DEVICE_ID
Last Changed 2010-07-27T14:42:10
lastChangedBy Primary\BLAdmin(BLAdmins)
externalName PM_DEVICE_ID
usage fact
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate sum
semiAggregate sum
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemPLATFORM_ID
name (en) PLATFORM_ID
name (zh) PLATFORM_ID
name (fr) PLATFORM_ID
name (de) PLATFORM_ID
name (ja) PLATFORM_ID
name (es) PLATFORM_ID
Last Changed 2008-10-10T19:59:39
externalName PLATFORM_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemCREATED_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 2008-10-10T19:59:39
externalName CREATED_BY_ROLE_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20
nullable true
regularAggregate count
semiAggregate unsupported
collationSequenceName EN_MS_SQL_Latin1_General_Cp1_AS_CI
collationSequenceLevel 1
originalCollationSequenceName SQL_Latin1_General_CP1_CI_AS
Query ItemCREATED_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 2008-10-10T19:59:39
externalName CREATED_BY_USER_ID
usage identifier
datatype decimal
precision 38
scale 0
size 20