Table: PAY_ELEMENT_TYPES_F

Product:	PAY - Payroll
Description:	Element definitions.
Implementation/DBA Data:	HR.PAY_ELEMENT_TYPES_F

Primary Key: PAY_ELEMENT_TYPES_F_PK

1. ELEMENT_TYPE_ID
2. EFFECTIVE_START_DATE
3. EFFECTIVE_END_DATE

Primary Key: PAY_ELEMENT_TYPES_F_UK2

1. ELEMENT_NAME
2. BUSINESS_GROUP_ID
3. LEGISLATION_CODE
4. EFFECTIVE_START_DATE
5. EFFECTIVE_END_DATE

Foreign Keys

Table		Foreign Table	Foreign Key Column
PAY_ELEMENT_TYPES_F		PAY_ELEMENT_CLASSIFICATIONS	PAY_ELEMENT_TYPES_F.CLASSIFICATION_ID
PAY_ELEMENT_TYPES_F		BEN_BENEFIT_CLASSIFICATIONS	PAY_ELEMENT_TYPES_F.BENEFIT_CLASSIFICATION_ID
PAY_ELEMENT_TYPES_F		PAY_EVENT_GROUPS	PAY_ELEMENT_TYPES_F.PRORATION_GROUP_ID