Entity AnItemLookup

Description of Entity AnItemLookup

This entity generates the Statistics report. It is a look up table for the analysis item.


List of all Dependencies of the Entity AnItemLookup

Name

Code

Class Name

Relation_718699

Relation_718699

Reference

Relation_718698

Relation_718698

Reference

Relation_718719

Relation_718719

Reference


List of Attributes of the Entity AnItemLookup

Name

Code

SysTableId

SysTableId

SysAttributeId

SysAttributeId

Anlys Lookup ID

AnlysLookupId

Anlys Map Field

AnlysMapField

Anlys Table

AnlysTable

Anlys Function

AnlysFunction

Anlys Condition

AnlysCondition

Anlys Map Field Prev

AnlysMapFieldPrev

Anlys Map Field Var

AnlysMapFieldVar


Entity Attribute SysTableId of the Entity AnItemLookup

Card of Attribute SysTableId of the Entity AnItemLookup

Name

SysTableId

Code

SysTableId

Data Type

char(100)

Mandatory

No


Description of Attribute SysTableId of the Entity AnItemLookup

Shows the identity of the system table. It is also the primary key for the SystemTable entity.
Example: Country / Leave Policy / TMSShift etc


Entity Attribute SysAttributeId of the Entity AnItemLookup

Card of Attribute SysAttributeId of the Entity AnItemLookup

Name

SysAttributeId

Code

SysAttributeId

Data Type

char(100)

Mandatory

No


Description of Attribute SysAttributeId of the Entity AnItemLookup

Shows the identity of the system attribute. It is the primary key for the SystemAttribute table.
Example: AdjType / AlertIsSummarized / AllowanceSGSPGenId etc


Entity Attribute Anlys Lookup ID of the Entity AnItemLookup

Card of Attribute Anlys Lookup ID of the Entity AnItemLookup

Name

Anlys Lookup ID

Code

AnlysLookupId

Data Type

char(50)

Mandatory

Yes


Description of Attribute Anlys Lookup ID of the Entity AnItemLookup

Shows the identity for the lookup table. This is also the primary key for the AnItemLookup table.


Entity Attribute Anlys Map Field of the Entity AnItemLookup

Card of Attribute Anlys Map Field of the Entity AnItemLookup

Name

Anlys Map Field

Code

AnlysMapField

Data Type

char(50)

Mandatory

No


Description of Attribute Anlys Map Field of the Entity AnItemLookup

Shows the map field of the analysis.


Entity Attribute Anlys Table of the Entity AnItemLookup

Card of Attribute Anlys Table of the Entity AnItemLookup

Name

Anlys Table

Code

AnlysTable

Data Type

char(100)

Mandatory

No


Description of Attribute Anlys Table of the Entity AnItemLookup

An analysis table for the lookup field.


Entity Attribute Anlys Function of the Entity AnItemLookup

Card of Attribute Anlys Function of the Entity AnItemLookup

Name

Anlys Function

Code

AnlysFunction

Data Type

char(200)

Mandatory

No


Description of Attribute Anlys Function of the Entity AnItemLookup

Shows the function for the analysis.


Entity Attribute Anlys Condition of the Entity AnItemLookup

Card of Attribute Anlys Condition of the Entity AnItemLookup

Name

Anlys Condition

Code

AnlysCondition

Data Type

char(255)

Mandatory

No


Description of Attribute Anlys Condition of the Entity AnItemLookup

Shows the condition for the analysis.


Entity Attribute Anlys Map Field Prev of the Entity AnItemLookup

Card of Attribute Anlys Map Field Prev of the Entity AnItemLookup

Name

Anlys Map Field Prev

Code

AnlysMapFieldPrev

Data Type

char(50)

Mandatory

No


Description of Attribute Anlys Map Field Prev of the Entity AnItemLookup

Shows the previous analysis map field.


Entity Attribute Anlys Map Field Var of the Entity AnItemLookup

Card of Attribute Anlys Map Field Var of the Entity AnItemLookup

Name

Anlys Map Field Var

Code

AnlysMapFieldVar

Data Type

char(50)

Mandatory

No


Description of Attribute Anlys Map Field Var of the Entity AnItemLookup

Shows the variable of the analysis map field.