Sage EasyPay Data Model

Entity AnlysProject

Description of Entity AnlysProject

This entity generates the Statistics report. This has information about the analysis project. Shows the cycle method, its basis and policy etc.

List of all Dependencies of the Entity AnlysProject

Relation_726684

Reference

Relation_652260

Reference

List of Attributes of the Entity AnlysProject

Entity Attribute Anlys Project ID of the Entity AnlysProject

Card of Attribute Anlys Project ID of the Entity AnlysProject

Name	Anlys Project ID
Code	AnlysProjectId
Data Type	char(30)
Mandatory	Yes

Description of Attribute Anlys Project ID of the Entity AnlysProject

Shows the identity of the analysis project. This holds the primary key for the AnlysProject table.

Entity Attribute Description of the Entity AnlysProject

Card of Attribute Description of the Entity AnlysProject

Name	Description
Code	AnlysProjectDesc
Data Type	char(100)
Mandatory	No

Description of Attribute Description of the Entity AnlysProject

Stores the description about the analysis project.

Entity Attribute Anlys Project Type of the Entity AnlysProject

Card of Attribute Anlys Project Type of the Entity AnlysProject

Name	Anlys Project Type
Code	AnlysProjectType
Data Type	char(20)
Mandatory	No

Description of Attribute Anlys Project Type of the Entity AnlysProject

Shows the type for the analysis project.

Entity Attribute Basis1 of the Entity AnlysProject

Card of Attribute Basis1 of the Entity AnlysProject

Name	Basis1
Code	Basis1
Data Type	char(20)
Mandatory	No

Description of Attribute Basis1 of the Entity AnlysProject

Shows the basis for the analysis project.
Example: Category / Department / Position / Leave Group etc

Entity Attribute Basis2 of the Entity AnlysProject

Card of Attribute Basis2 of the Entity AnlysProject

Name	Basis2
Code	Basis2
Data Type	char(20)
Mandatory	No

Description of Attribute Basis2 of the Entity AnlysProject

Shows the basis for the analysis project.
Example: Category / Department / Position / Leave Group etc

Entity Attribute Basis3 of the Entity AnlysProject

Card of Attribute Basis3 of the Entity AnlysProject

Name	Basis3
Code	Basis3
Data Type	char(20)
Mandatory	No

Description of Attribute Basis3 of the Entity AnlysProject

Shows the basis for the analysis project.
Example: Category / Department / Position / Leave Group etc

Entity Attribute Cycle Method of the Entity AnlysProject

Card of Attribute Cycle Method of the Entity AnlysProject

Name	Cycle Method
Code	CycleMethod
Data Type	char(20)
Mandatory	No

Description of Attribute Cycle Method of the Entity AnlysProject

Displays the cycle method for the analysis project.

Entity Attribute Cycle Group By of the Entity AnlysProject

Card of Attribute Cycle Group By of the Entity AnlysProject

Name	Cycle Group By
Code	CycleGroupBy
Data Type	char(20)
Mandatory	No

Description of Attribute Cycle Group By of the Entity AnlysProject

Shows how the cycle is grouped by.
Example: By sub period / calendar etc

Entity Attribute Cycle Sub Group By of the Entity AnlysProject

Card of Attribute Cycle Sub Group By of the Entity AnlysProject

Name	Cycle Sub Group By
Code	CycleSubGroupBy
Data Type	char(20)
Mandatory	No

Description of Attribute Cycle Sub Group By of the Entity AnlysProject

Shows how the cycle is grouped by.
Example: PayRecType / LeaveTypeId etc

Entity Attribute Summary Level of the Entity AnlysProject

Card of Attribute Summary Level of the Entity AnlysProject

Name	Summary Level
Code	SummaryLevel
Data Type	char(20)
Mandatory	No

Description of Attribute Summary Level of the Entity AnlysProject

Shows the summary level for the analysis project.
Example: SumLevelCompany / SumLevelBasis / SumLevelEmployee etc

Entity Attribute Is System Project of the Entity AnlysProject

Card of Attribute Is System Project of the Entity AnlysProject

Name	Is System Project
Code	IsSystemProject
Data Type	smallint
Mandatory	No

Name	Anlys Project Sub Type
Code	AnlysProjectSubType
Data Type	char(20)
Mandatory	No

Name	BasisPolicyId1
Code	BasisPolicyId1
Data Type	char(20)
Mandatory	No

Name	BasisPolicyId2
Code	BasisPolicyId2
Data Type	char(20)
Mandatory	No

Name	BasisPolicyId3
Code	BasisPolicyId3
Data Type	char(20)
Mandatory	No

Description of Attribute BasisPolicyId3 of the Entity AnlysProject

Shows the identity of the basis policy for the analysis project.

Home