PAY_TAX_CALC_STMT_ELEMENTS

This table contains Tax Calculation Elements seed data which store information about Calculation Results and Calculation Steps for specific tax calculation done in payroll run.

Details

Schema: FUSION
Object owner: PAY
Object type: TABLE
Tablespace: REFERENCE

Primary Key

Name	Columns
PAY_TAX_CALC_STMT_ELEMENTS_PK	TCS_ELEMENT_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TCS_ELEMENT_ID	NUMBER		18	Yes	System-generated primary key column.
TCS_BASE_ELEMENT_NAME	VARCHAR2	100		Yes	Unique Name to identify the object.
LEGISLATION_CODE	VARCHAR2	30			Foreign key to FND_TERRITORIES.
ELEMENT_USAGE	VARCHAR2	30		Yes	This column is to categorize the object's usage.
ELEMENT_TYPE	VARCHAR2	30		Yes	This column is to categorize the object's type.
SEQUENCE	NUMBER		18	Yes	Display sequence number for the objects.
PARENT_TCS_ELEMENT_ID	NUMBER		18		Parent TCS Element Id of the object.
TAX_TYPE	VARCHAR2	50		Yes	Primary Tax Type of the object.
TAX_SUB_TYPE	VARCHAR2	50		Yes	Tax Sub Type of the current object.
ACTIVE_FLAG	VARCHAR2	30			Indicates whether this object is active.
VALIDATION_EXPRESSION	VARCHAR2	1000			Validation expression of the object.
CALCULATION_EXPRESSION	VARCHAR2	1000			Calculation expression of the object.
DISPLAY	VARCHAR2	30			Indicates whether this object to be displayed.
FORMAT	VARCHAR2	150			This column indicates the format style of the object.
MODULE_ID	VARCHAR2	32			Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
SGUID	VARCHAR2	32			The seed global unique identifier. Oracle internal use only.
ENTERPRISE_ID	NUMBER		18	Yes	Foreign key to PER_ENTERPRISES.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
SEED_DATA_SOURCE	VARCHAR2	512			Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
ORA_SEED_SET1	VARCHAR2	1		Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N.
ORA_SEED_SET2	VARCHAR2	1		Yes	Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N.

Foreign Keys

Table	Foreign Table	Foreign Key Column
pay_tax_calc_stmt_elements_tl	pay_tax_calc_stmt_elements	TCS_ELEMENT_ID

Indexes

Index	Uniqueness	Tablespace	Columns
PAY_TAX_CALC_STMT_ELEMENTS_N1	Non Unique	Default	LEGISLATION_CODE, TAX_TYPE, TAX_SUB_TYPE, ELEMENT_USAGE
PAY_TAX_CALC_STMT_ELEMENTS_N2	Non Unique	Default	LAST_UPDATE_DATE
PAY_TAX_CALC_STMT_ELEMENTS_N3	Non Unique	Default	PARENT_TCS_ELEMENT_ID
PAY_TAX_CALC_STMT_ELEMENTS_PK	Unique	Default	TCS_ELEMENT_ID, ORA_SEED_SET1
PAY_TAX_CALC_STMT_ELEMENTS_PK1	Unique	Default	TCS_ELEMENT_ID, ORA_SEED_SET2
PAY_TAX_CALC_STMT_ELEMENTS_U1	Unique	Default	TCS_BASE_ELEMENT_NAME, LEGISLATION_CODE, ORA_SEED_SET1
PAY_TAX_CALC_STMT_ELEMENTS_U11	Unique	Default	TCS_BASE_ELEMENT_NAME, LEGISLATION_CODE, ORA_SEED_SET2