My Payroll Table Descriptions hand book (I have big hands) Part 1

Payroll - PAY_ACTION_CLASSIFICATIONS	Payroll Action Type classifications.
Column Name	Descritpion
ACTION_TYPE	Type of action.
CLASSIFICATION_NAME	Classification of the action type.

Payroll - PAY_ACTION_INTERLOCKS	Assignment action interlock definitions to control rollback processing.
Column Name	Descritpion
LOCKING_ACTION_ID	Foreign key to PAY_ASSIGNMENT_ACTIONS.
LOCKED_ACTION_ID	Foreign key to PAY_ASSIGNMENT_ACTIONS.

Payroll - PAY_ACTION_PARAMETERS	Global parameters to control process execution.
Column Name	Descritpion
PARAMETER_NAME	Name of parameter to set.
PARAMETER_VALUE	Value for a specific parameter.

Payroll - PAY_ASSIGNMENT_ACTIONS	Action or process results, showing which assignments have been processed by a specific payroll action, or process.
Column Name	Descritpion
CHUNK_NUMBER	Number used to group events into chunks for parallelization.
ACTION_SEQUENCE	Absolute sequence number to determine physical order of events.
PRE_PAYMENT_ID	Foreign key to PAY_PRE_PAYMENTS.
SERIAL_NUMBER	Check or Magnetic Tape number.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
TAX_UNIT_ID	Identifies the Government Reporting Entity, or Legal Entity for the assignment.
SOURCE_ACTION_ID	Parent assignment action of this action.
RUN_TYPE_ID	Foreign key to PAY_RUN_TYPES_F. Identifies the type of run processed.
SECONDARY_STATUS	The processing status of Phase 2 of Purge.
START_DATE	Identifies the start of a date range the action relates to e.g. used for proration
END_DATE	Identifies the end of a date range the action relates to e.g. used for proration
OBJECT_ID	Dynamic Foreign Key to a Table identfied by the object type.
OBJECT_TYPE	Indicates the type of object that OBJECT_ID refers to.
PROCESS_PATH	process path, to be used in retry of reversals
ASSIGNMENT_ACTION_ID	The system generated primary key.
LABEL_IDENTIFIER
ASSIGNMENT_ID	Foreign key to PER_ASSIGNMENTS.
PAYROLL_ACTION_ID	Foreign key to PAY_PAYROLL_ACTIONS.
ACTION_STATUS	Valid statuses for an assignment action.

Payroll - PAY_ASSIGNMENT_LATEST_BALANCES	Denormalised assignment level latest balances.
Column Name	Descritpion
ASSIGNMENT_ID	Foreign key to PER_ALL_ASSIGNMENTS_F.
PREV_BALANCE_VALUE	Value of the balance prior to the current value.
PREV_ASSIGNMENT_ACTION_ID	Foreign key to PAY_ASSIGNMENT_ACTIONS
ASSIGNMENT_ACTION_ID	Foreign key to PAY_ASSIGNMENT_ACTIONS.
DEFINED_BALANCE_ID	Foreign key to PAY_DEFINED_BALANCES.
VALUE	Value of the balance.
LATEST_BALANCE_ID	Surrogate primary key.
EXPIRED_ASSIGNMENT_ACTION_ID	Foreign key to PAY_ASSIGNMENT_ACTIONS
EXPIRED_VALUE	Value of dimension of balance when it last expired

Payroll - PAY_ASSIGNMENT_LINK_USAGES_F	Intersection between PAY_ELEMENT_LINKS_F and PER_ALL_ASSIGNMENTS_F.
Column Name	Descritpion
ASSIGNMENT_LINK_USAGE_ID	System-generated primary key column.
EFFECTIVE_START_DATE	Effective start date of eligibility.
EFFECTIVE_END_DATE	Effective end date of eligibility.
ELEMENT_LINK_ID	Foreign key to PAY_ELEMENT_LINKS_F.
ASSIGNMENT_ID	Foreign key to PER_ALL_ASSIGNMENTS_F.

Payroll - PAY_BACKPAY_RULES	Balances to be recalculated by a RetroPay process.
Column Name	Descritpion
DEFINED_BALANCE_ID	Foreign key to PAY_DEFINED_BALANCES.
INPUT_VALUE_ID	Foreign key to PAY_INPUT_VALUES.
BACKPAY_SET_ID	Foreign key to PAY_BACKPAY_SETS.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.

Payroll - PAY_BACKPAY_SETS	Identifies backpay, or RetroPay sets.
Column Name	Descritpion
BACKPAY_SET_ID	Unique Identifier.
CREATION_DATE	Standard who column - date when this row was created.
BACKPAY_SET_TYPE	Indicates the RetroPay or backpay process to handle the set.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
BACKPAY_SET_NAME	User name for the set.
DESCRIPTION	Brief description of the RetroPay set.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).

Payroll - PAY_BALANCE_CLASSIFICATIONS	Information on which element classifications feed a balance.
Column Name	Descritpion
BALANCE_CLASSIFICATION_ID	System-generated primary key column.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
BALANCE_TYPE_ID	Foreign key to PAY_BALANCE_TYPES.
CLASSIFICATION_ID	Foreign key to PAY_ELEMENT_CLASSIFICATIONS.
SCALE	If 1, adds to balance, if -1 subtracts from balance.
LEGISLATION_SUBGROUP	Further identifies the legislation of startup data.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).

Payroll - PAY_BALANCE_DIMENSIONS	Information allowing the summation of a balance.
Column Name	Descritpion
BALANCE_DIMENSION_ID	System-generated primary key column.
DATABASE_ITEM_SUFFIX	Suffix to use when generating a database item (eg _ASG_PTD).
DIMENSION_NAME	User Name.
DIMENSION_TYPE	Controls whether latest balance is created and if so, what type, person or assignment level.
DESCRIPTION	User Description.
FEED_CHECKING_CODE	PL/SQL function to determine whether the Run Result Value should feed the balance.
LEGISLATION_SUBGROUP	Further identifies the legislation of startup data.
PAYMENTS_FLAG	One dimension only can be marked as being the PAYMENTS dimension.
EXPIRY_CHECKING_CODE	PL/SQL function which checks if latest balances should be reset.
EXPIRY_CHECKING_LEVEL	Controls balance expiry strategy.
FEED_CHECKING_TYPE	Controls feed checking strategy.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
DIMENSION_LEVEL	The level or group that the dimension describes
PERIOD_TYPE	The period for which the dimension totals
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
ASG_ACTION_BALANCE_DIM_ID	Used to calculate assignment contributions to group balance in rollback of group level run balances.
DATABASE_ITEM_FUNCTION	Use the balance function to retrieve balance value
SAVE_RUN_BALANCE_ENABLED	In conjunction with save_run_balance_enabled on pay_balance_categories_f, indicates whether run balances should be stored for defined balances with this dimension.
START_DATE_CODE	PL/SQL function which determines the start date for a dynamic period
APPLICATION_ID	Indicates which, non Payroll, application owns the record.
ROUTE_ID	Foreign key to FF_ROUTES.

Payroll - PAY_BALANCE_FEEDS_F	Controls which input values can feed a balance type.
Column Name	Descritpion
BALANCE_FEED_ID	System-generated primary key column.
LEGISLATION_SUBGROUP	Further identifies the legislation of startup data.
SOURCE_ID	For non Payroll balances, which object feeds the balance
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
EFFECTIVE_START_DATE	Effective start date.
CREATION_DATE	Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
EFFECTIVE_END_DATE	Effective end date.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
BALANCE_TYPE_ID	Foreign key to PAY_BALANCE_TYPES.
INPUT_VALUE_ID	Foreign key to PAY_INPUT_VALUES.
ELEMENT_TYPE_ID	Foreign Key to PAY_ELEMENT_TYPES_F
SCALE	Identifies whether a feed will add to or subtract from a balance.

Payroll - PAY_BALANCE_TYPES	Balance information.
Column Name	Descritpion
BALANCE_TYPE_ID	System-generated primary key column.
ASSIGNMENT_REMUNERATION_FLAG	Indicates the balance is used for assignment remuneration or for third party payments.
BALANCE_NAME	User name of balance.
BALANCE_UOM	Unit of measure, for example, Money.
COMMENTS	Descriptive information about the balance type.
LEGISLATION_SUBGROUP	Further identifies the legislation of startup data.
REPORTING_NAME	User name for reporting purposes.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield column.
ATTRIBUTE2	Descriptive flexfield column.
ATTRIBUTE3	Descriptive flexfield column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ATTRIBUTE4	Descriptive flexfield column.
ATTRIBUTE5	Descriptive flexfield column.
ATTRIBUTE6	Descriptive flexfield column.
ATTRIBUTE7	Descriptive flexfield column.
ATTRIBUTE8	Descriptive flexfield column.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
JURISDICTION_LEVEL	US specific. Indicates the jurisdiction level that applies to the balance type, federal, state, county or city.
TAX_TYPE	US specific. Tax type of the balance.
BALANCE_CATEGORY_ID	Foreign key to PAY_BALANCE_CATEGORIES_F
BASE_BALANCE_TYPE_ID	Associated balance type to allow defined relationship
INPUT_VALUE_ID	Foreign key to PAY_INPUT_VALUES_F for primary balance
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
APPLICATION_ID	Which non Payroll Application owns the record
CURRENCY_CODE	Foreign key to FND_CURRENCIES.

Payroll - PAY_CALENDARS	Details of user defined budgetary calendars.
Column Name	Descritpion
PERIOD_SET_NAME	Primary key.
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ACTUAL_PERIOD_TYPE	Foreign key to PER_TIME_PERIOD_TYPES.
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PROC_PERIOD_TYPE	Period type short code.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
START_DATE	Calendar start date.
COMMENTS	Descriptive information about the calendar.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment

Payroll - PAY_COIN_ANAL_ELEMENTS	Monetary unit quantities for automatic make-up of cash payments.
Column Name	Descritpion
COIN_ANAL_ELEMENT_ID	System-generated primary key column.
PRE_PAYMENT_ID	Foreign key to PAY_PRE_PAYMENTS.
MONETARY_UNIT_ID	Foreign key to PAY_MONETARY_UNITS.
NUMBER_OF_MONETARY_UNITS	Quantity of monetary units.

Payroll - PAY_CONSOLIDATION_SETS	Consolidation set of results of payroll processing.
Column Name	Descritpion
CONSOLIDATION_SET_ID	Consolidation set primary key.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
CONSOLIDATION_SET_NAME	Consolidation set name.
COMMENTS	Descriptive information about the consolidation set.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.

Payroll - PAY_COSTS	Cost details and values for run results.
Column Name	Descritpion
COST_ALLOCATION_KEYFLEX_ID	Foreign key to PAY_COST_ALLOCATION_KEYFLEX.
BALANCE_OR_COST	Indicates if the record is from the cost or balancing flexfield structures.
COSTED_VALUE	Actual value to be costed.
DEBIT_OR_CREDIT	Indicates whether the value is a debit (D) or credit (C).
DISTRIBUTED_INPUT_VALUE_ID	Component of foreign key to Run Result Value whose costing is distributed.
DISTRIBUTED_RUN_RESULT_ID	Component of foreign key to Run Result Value whose costing is distributed.
SOURCE_ID	Points to Parent COST_ID
TRANSFER_TO_GL_FLAG	Indicates whether Cost should be Transferred to the General Ledger
COST_ID	Surrogate primary key.
ASSIGNMENT_ACTION_ID	Foreign key to PAY_ASSIGNMENT_ACTIONS.
INPUT_VALUE_ID	Foreign key to PAY_INPUT_VALUES.
RUN_RESULT_ID	Foreign key to PAY_RUN_RESULTS.

Payroll - PAY_COST_ALLOCATIONS_F	Cost allocation details for an assignment.
Column Name	Descritpion
COST_ALLOCATION_ID	System-generated primary key column.
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
EFFECTIVE_START_DATE	Effective start date.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
EFFECTIVE_END_DATE	Effective end date.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
COST_ALLOCATION_KEYFLEX_ID	Foreign key to PAY_COST_ALLOCATION_KEYFLEX, holding individual segment values.
ASSIGNMENT_ID	Foreign key to PER_ASSIGNMENTS.
PROPORTION	Percentage of assignment costs to be apportioned to this key flexfield.
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).

Payroll - PAY_COST_ALLOCATION_KEYFLEX	Cost Allocation key flexfield combinations table.
Column Name	Descritpion
COST_ALLOCATION_KEYFLEX_ID	System-generated primary key column.
SEGMENT3	Key flexfield segment
SEGMENT4	Key flexfield segment
SEGMENT5	Key flexfield segment
SEGMENT6	Key flexfield segment
SEGMENT7	Key flexfield segment
SEGMENT8	Key flexfield segment
SEGMENT9	Key flexfield segment
SEGMENT10	Key flexfield segment
SEGMENT11	Key flexfield segment
SEGMENT12	Key flexfield segment
CONCATENATED_SEGMENTS	Key flexfield segment column.
SEGMENT13	Key flexfield segment
SEGMENT14	Key flexfield segment
SEGMENT15	Key flexfield segment
SEGMENT16	Key flexfield segment
SEGMENT17	Key flexfield segment
SEGMENT18	Key flexfield segment
SEGMENT19	Key flexfield segment
SEGMENT20	Key flexfield segment
SEGMENT21	Key flexfield segment column.
SEGMENT22	Key flexfield segment column.
ID_FLEX_NUM	Key flexfield structure foreign key.
SEGMENT23	Key flexfield segment column.
SEGMENT24	Key flexfield segment column.
SEGMENT25	Key flexfield segment column.
SEGMENT26	Key flexfield segment column.
SEGMENT27	Key flexfield segment column.
SEGMENT28	Key flexfield segment column.
SEGMENT29	Key flexfield segment column.
SEGMENT30	Key flexfield segment column.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
SUMMARY_FLAG	Key flexfield summary flag.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
ENABLED_FLAG	Key flexfield enabled flag.
START_DATE_ACTIVE	Date before which key flexfield combination is invalid.
END_DATE_ACTIVE	Date after which key flexfield combination is invalid.
SEGMENT1	Key flexfield segment
SEGMENT2	Key flexfield segment

Payroll - PAY_CUSTOMIZED_RESTRICTIONS	CustomForm restrictions for specific forms.
Column Name	Descritpion
CUSTOMIZED_RESTRICTION_ID	System-generated primary key column.
COMMENTS	General remark.
LEGISLATION_SUBGROUP	Identifies the startup legislation.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE	Identifies the legislation in which the restriction applies.
APPLICATION_ID	Foreign key to FND_FORM.
FORM_NAME	Foreign key to FND_FORM.
ENABLED_FLAG	Indicates whether the customization is enabled.
NAME	Name of the restriction.
QUERY_FORM_TITLE	User title for customized form when called in query mode.
STANDARD_FORM_TITLE	User title for customized form when called in standard mode.

Payroll - PAY_DEFINED_BALANCES	Intersection between PAY_BALANCE_TYPES and PAY_BALANCE_DIMENSIONS.
Column Name	Descritpion
DEFINED_BALANCE_ID	System-generated primary key column.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
GROSSUP_ALLOWED_FLAG	Indicates if this balance can be used in a grossup.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
SAVE_RUN_BALANCE	Determines whether run level balance values are stored in pay_run_balances.
RUN_BALANCE_STATUS	Displays current status of the associated run balance.
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
BALANCE_TYPE_ID	Foreign key to PAY_BALANCE_TYPES.
BALANCE_DIMENSION_ID	Foreign key to PAY_BALANCE_DIMENSIONS.
FORCE_LATEST_BALANCE_FLAG	Not currently supported.
LEGISLATION_SUBGROUP	Further identifies the legislation of startup data.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).

Payroll - PAY_ELEMENT_CLASSIFICATIONS	Element classifications for legislation and information needs.
Column Name	Descritpion
CLASSIFICATION_ID	System-generated primary key column.
DEFAULT_PRIORITY	Default processing priority for all elements with this classification.
DISTRIBUTABLE_OVER_FLAG	Indicates whether costs can be distributed over elements with this classification.
NON_PAYMENTS_FLAG	Indicates whether classifications can own foreign currency elements.
COSTING_DEBIT_OR_CREDIT	Indicates whether this classification creates debit or credit costing values by default.
PARENT_CLASSIFICATION_ID	Foreign key to PAY_ELEMENT_CLASSIFICATIONS (CLASSIFICATION_ID).
CREATE_BY_DEFAULT_FLAG	Indicates whether classification rules should be automatically created.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
CREATION_DATE	Standard who column - date when this row was created.
BALANCE_INITIALIZATION_FLAG	Indicates whether the classification is used for an initial balance upload type of element.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
FREQ_RULE_ENABLED	Indicates whether to allow frequency rules to be used
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
CLASSIFICATION_NAME	Name by which a user identifies the classification.
DESCRIPTION	Full description of the element classification.
LEGISLATION_SUBGROUP	Identifies the legislation of the classification.
COSTABLE_FLAG	Indicates whether elements with the classification can be costed.
DEFAULT_HIGH_PRIORITY	Upper end of default processing priority range.
DEFAULT_LOW_PRIORITY	Lower end of default processing priority range.

Payroll - PAY_ELEMENT_ENTRIES_F	Element entry list for each assignment.
Column Name	Descritpion
ELEMENT_ENTRY_ID	System-generated primary key column.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ASSIGNMENT_ID	Foreign key to PER_ALL_ASSIGNMENTS_F.
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
ENTRY_INFORMATION_CATEGORY	Developer descriptive flexfield column.
ENTRY_INFORMATION1	Developer descriptive flexfield column.
ENTRY_INFORMATION2	Developer descriptive flexfield column.
ENTRY_INFORMATION3	Developer descriptive flexfield column.
ENTRY_INFORMATION4	Developer descriptive flexfield column.
ENTRY_INFORMATION5	Developer descriptive flexfield column.
ENTRY_INFORMATION6	Developer descriptive flexfield column.
ENTRY_INFORMATION7	Developer descriptive flexfield column.
ENTRY_INFORMATION8	Developer descriptive flexfield column.
ENTRY_INFORMATION9	Developer descriptive flexfield column.
ENTRY_INFORMATION10	Developer descriptive flexfield column.
ENTRY_INFORMATION11	Developer descriptive flexfield column.
ENTRY_INFORMATION12	Developer descriptive flexfield column.
ENTRY_INFORMATION13	Developer descriptive flexfield column.
ENTRY_INFORMATION14	Developer descriptive flexfield column.
ENTRY_INFORMATION15	Developer descriptive flexfield column.
ENTRY_INFORMATION16	Developer descriptive flexfield column.
ENTRY_INFORMATION17	Developer descriptive flexfield column.
UPDATING_ACTION_ID	Foreign key to PAY_ASSIGNMENT_ACTIONS.
ENTRY_INFORMATION18	Developer descriptive flexfield column.
ENTRY_INFORMATION19	Developer descriptive flexfield column.
ENTRY_INFORMATION20	Developer descriptive flexfield column.
ENTRY_INFORMATION21	Developer descriptive flexfield column.
ENTRY_INFORMATION22	Developer descriptive flexfield column.
UPDATING_ACTION_TYPE	Action Type causing the update
ENTRY_INFORMATION23	Developer descriptive flexfield column.
ENTRY_INFORMATION24	Developer descriptive flexfield column.
ENTRY_INFORMATION25	Developer descriptive flexfield column.
ENTRY_INFORMATION26	Developer descriptive flexfield column.
ENTRY_INFORMATION27	Developer descriptive flexfield column.
EFFECTIVE_START_DATE	Effective start date for an element entry.
ENTRY_INFORMATION28	Developer descriptive flexfield column.
ENTRY_INFORMATION29	Developer descriptive flexfield column.
ENTRY_INFORMATION30	Developer descriptive flexfield column.
PREV_UPD_ACTION_ID	Updating action ID value
ELEMENT_LINK_ID	Foreign key to PAY_ELEMENT_LINKS_F. All entries are subject to a specific element link rule.
ORIGINAL_ENTRY_ID	Foreign key to PAY_ELEMENT_ENTRIES_F (ELEMENT_ENTRY_ID).
EFFECTIVE_END_DATE	Effective end date for an element entry.
CREATOR_TYPE	Sub-system responsible for maintaining an element entry. (Validated by a lookup).
ENTRY_TYPE	Sub-type for an element entry. (Validated by a lookup).
COMMENT_ID	Foreign key to HR_COMMENTS.
CREATOR_ID	Process responsible for creating an element entry.
REASON	Reason for element entry. (Validated by a lookup).
TARGET_ENTRY_ID	Foreign key to PAY_ELEMENT_ENTRIES_F (ELEMENT_ENTRY_ID).
SOURCE_ID	Process responsible for maintaining an element entry.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
SUBPRIORITY	Used to determine run processing order of entries of same priority.
PERSONAL_PAYMENT_METHOD_ID	Foreign key to PAY_PERSONAL_PAYMENT_METHODS
DATE_EARNED	Date earned for entry - used for mid-period GRE change.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
BALANCE_ADJ_COST_FLAG	Indicates whether a balance adjustment is to be costed.
COST_ALLOCATION_KEYFLEX_ID	Foreign key to PAY_COST_ALLOCATION_KEYFLEX.
SOURCE_ASG_ACTION_ID	Foreign key to PAY_ASSIGNMENT_ACTIONS. Identifies the source entries assignment action id.
SOURCE_LINK_ID	Foreign key to PAY_ELEMENT_LINKS_F. Identifies the source entries element link id.
SOURCE_TRIGGER_ENTRY	The element entry responsible for triggering a separate action.
SOURCE_PERIOD	Source Period of element entry
SOURCE_RUN_TYPE	Source Run Type of element entry
SOURCE_START_DATE	Identifies the start of a date range the source relates to e.g. used for proration
SOURCE_END_DATE	Identifies the end of a date range the source relates to e.g. used for proration
ELEMENT_TYPE_ID	Foreign key to PAY_ELEMENT_TYPES_F
LABEL_IDENTIFIER	Label Identifier
ALL_ENTRY_VALUES_NULL	Equals 'Y' when all the values for an entry are NULL. If one or more of the entry values are NOT NULL, or if there are no values for the entry, then this column will be NULL.

Payroll - PAY_ELEMENT_ENTRY_VALUES_F	Actual input values for specific element entries.
Column Name	Descritpion
ELEMENT_ENTRY_VALUE_ID	System-generated primary key column.
EFFECTIVE_START_DATE	Effective start date.
EFFECTIVE_END_DATE	Effective end date.
INPUT_VALUE_ID	Foreign key to PAY_INPUT_VALUES.
ELEMENT_ENTRY_ID	Foreign key to PAY_ELEMENT_ENTRIES.
SCREEN_ENTRY_VALUE	Actual entry value.

Payroll - PAY_ELEMENT_LINKS_F	Eligibility rules for an element type.
Column Name	Descritpion
ELEMENT_LINK_ID	System-generated primary key column.
ELEMENT_TYPE_ID	Foreign key to PAY_ELEMENT_TYPES_F.
LOCATION_ID	Foreign key to HR_LOCATIONS.
GRADE_ID	Foreign key to PER_GRADES.
BALANCING_KEYFLEX_ID	Foreign key to PAY_COST_ALLOCATION_KEYFLEX.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ELEMENT_SET_ID	Foreign key to PAY_ELEMENT_SETS.
PAY_BASIS_ID	Foreign key to PER_PAY_BASES.
COSTABLE_TYPE	Costable type for element entries subject to this link. (Validated by a lookup).
LINK_TO_ALL_PAYROLLS_FLAG	Indicates whether all payrolls are eligible for the element.
MULTIPLY_VALUE_FLAG	Indicates whether entries can be multiplied, for example, holiday pay.
EFFECTIVE_START_DATE	Effective start date.
STANDARD_LINK_FLAG	Indicates whether an element is standard (Y) or non-standard (N).
TRANSFER_TO_GL_FLAG	Indicates whether costed values for the element can be included in the transfer to General Ledger.
COMMENT_ID	Foreign key to HR_COMMENTS.
EMPLOYMENT_CATEGORY	Employment category criteria for the element. Validated by lookup.
QUALIFYING_AGE	Minimum age criteria for the element.
QUALIFYING_LENGTH_OF_SERVICE	Minimum length of service for eligibility for the element.
QUALIFYING_UNITS	Time units used by the QUALIFYING_LENGTH_OF_SERVICE. (Validated by a lookup).
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
EFFECTIVE_END_DATE	Effective end date.
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
PAYROLL_ID	Foreign key to PAY_ALL_PAYROLLS_F.
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
JOB_ID	Foreign key to PER_JOBS.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
POSITION_ID	Foreign key to PER_POSITIONS.
PEOPLE_GROUP_ID	Foreign key to PAY_PEOPLE_GROUPS.
COST_ALLOCATION_KEYFLEX_ID	Foreign key to PAY_COST_ALLOCATION_KEYFLEX.
ORGANIZATION_ID	Foreign key to HR_ORGANIZATION_UNITS.

Payroll - PAY_ELEMENT_SETS	Groups elements to restrict payroll runs, customize windows, or as a distribution set for costs.
Column Name	Descritpion
ELEMENT_SET_ID	System generated primary key column.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
ELEMENT_SET_NAME	User name for the element set.
ELEMENT_SET_TYPE	Type of element set. (Validated by a lookup).
COMMENTS	Descriptive information about the element set.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Payroll - PAY_ELEMENT_TYPES_F	Element definitions.
Column Name	Descritpion
ELEMENT_TYPE_ID	System-generated primary key column.
BENEFIT_CLASSIFICATION_ID	Foreign key to BEN_BENEFIT_CLASSIFICATIONS.
ITERATIVE_FORMULA_ID	Foreign Key to FF_FORMULAS_F to indicate the formula that defaults and changes the iterative element's input values.
ITERATIVE_PRIORITY	The order of the iterative adjustment processing for iterative elements
ADDITIONAL_ENTRY_ALLOWED_FLAG	Indicates whether a recurring element can also have an additional nonrecurring entry of this type in any payroll period.
CREATOR_TYPE	Sub-system responsible for creating the element definition.
RETRO_SUMM_ELE_ID	Element type id of the RetroPay summary element.
ADJUSTMENT_ONLY_FLAG	Indicates whether the element is used only for adjusting balances. Not used in US legislations.
GROSSUP_FLAG	Indicates if this element can be processed in a Net to Gross calculation.
PROCESS_MODE	Denotes the type of processing which may be applied to this element e.g. separate check,separate payment or process separately.
CLOSED_FOR_ENTRY_FLAG	Indicates whether entries can be currently entered or updated.
ELEMENT_NAME	User name for the element type. This is the name used to generate database item names.
ADVANCE_INDICATOR	Advance Indicator for element type
ADVANCE_PAYABLE	Advance Payable flag
ADVANCE_DEDUCTION	Advance Deduction flag
PROCESS_ADVANCE_ENTRY	Process Advance Entry flag
PRORATION_GROUP_ID	Foreign key to PAY_EVENT_GROUPS for elements to prorate.
PRORATION_FORMULA_ID	Foreign key to FF_FORMULAS_F to identify proration formula
RECALC_EVENT_GROUP_ID	Foreign key to PAY_EVENT_GROUPS for Recalculation.
ONCE_EACH_PERIOD_FLAG	Indicates if element should only be processed once per period.
REPORTING_NAME	Short name for the element, used in reports.
TIME_DEFINITION_TYPE	Indicates the type of time definition used with this Element
TIME_DEFINITION_ID	Foreign Key to PAY_TIME_DEFINITIONS.
EFFECTIVE_START_DATE	Effective start date.
ADVANCE_ELEMENT_TYPE_ID	Foreign key to PAY_ELEMENT_TYPES_F table
DEDUCTION_ELEMENT_TYPE_ID	Foreign key to PAY_ELEMENT_TYPES_F table
DESCRIPTION	Brief description of the element type.
INDIRECT_ONLY_FLAG	Indicates whether the element can be given to an assignment only as an indirect result from a formula.
MULTIPLE_ENTRIES_ALLOWED_FLAG	Indicates whether an assignment can have multiple normal entries for this element at any one time.
MULTIPLY_VALUE_FLAG	Indicates whether entries can be multiplied, for example, holiday pay.
POST_TERMINATION_RULE	Rule for element processing when a person is terminated.
PROCESS_IN_RUN_FLAG	Indicates whether the element can be processed in a payroll run.
EFFECTIVE_END_DATE	Effective end date.
PROCESSING_PRIORITY	Processing priority order for any entries of this element in a payroll run.
PROCESSING_TYPE	Indicates whether the element is recurring or nonrecurring.
STANDARD_LINK_FLAG	Indicates whether the default element link type is standard (Y) or non-standard (N).
COMMENT_ID	Foreign key to HR_COMMENTS.
LEGISLATION_SUBGROUP	Identifies the legislation of the predefined data for the element.
QUALIFYING_AGE	Age at which a person qualifies for this element.
QUALIFYING_LENGTH_OF_SERVICE	Length of service required for the person to qualify for this element.
QUALIFYING_UNITS	Units of measurement for qualifying length of service.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
LEGISLATION_CODE	Foreign Key to FND_TERRITORIES
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
FORMULA_ID	Foreign key to PAY_FORMULAS_F.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
ELEMENT_INFORMATION_CATEGORY	Developer descriptive flexfield column.
ELEMENT_INFORMATION1	Developer descriptive flexfield column.
INPUT_CURRENCY_CODE	Foreign key to FND_CURRENCIES.
ELEMENT_INFORMATION2	Developer descriptive flexfield column.
ELEMENT_INFORMATION3	Developer descriptive flexfield column.
ELEMENT_INFORMATION4	Developer descriptive flexfield column.
ELEMENT_INFORMATION5	Developer descriptive flexfield column.
ELEMENT_INFORMATION6	Developer descriptive flexfield column.
ELEMENT_INFORMATION7	Developer descriptive flexfield column.
ELEMENT_INFORMATION8	Developer descriptive flexfield column.
ELEMENT_INFORMATION9	Developer descriptive flexfield column.
ELEMENT_INFORMATION10	Developer descriptive flexfield column.
ELEMENT_INFORMATION11	Developer descriptive flexfield column.
OUTPUT_CURRENCY_CODE	Foreign key to FND_CURRENCIES.
ELEMENT_INFORMATION12	Developer descriptive flexfield column.
ELEMENT_INFORMATION13	Developer descriptive flexfield column.
ELEMENT_INFORMATION14	Developer descriptive flexfield column.
ELEMENT_INFORMATION15	Developer descriptive flexfield column.
ELEMENT_INFORMATION16	Developer descriptive flexfield column.
ELEMENT_INFORMATION17	Developer descriptive flexfield column.
ELEMENT_INFORMATION18	Developer descriptive flexfield column.
ELEMENT_INFORMATION19	Developer descriptive flexfield column.
ELEMENT_INFORMATION20	Developer descriptive flexfield column.
THIRD_PARTY_PAY_ONLY_FLAG	Indicates whether the element is paid by third party payments only.
CLASSIFICATION_ID	Foreign key to PAY_ELEMENT_CLASSIFICATIONS.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
ITERATIVE_FLAG	Indicates whether the element can be adjusted as a result of iterative rules.

Payroll - PAY_ELEMENT_TYPE_RULES	Include and exclude rules for specific elements in an element set.
Column Name	Descritpion
ELEMENT_TYPE_ID	Foreign key to PAY_ELEMENT_TYPES.
ELEMENT_SET_ID	Foreign key to PAY_ELEMENT_SETS.
INCLUDE_OR_EXCLUDE	Indicates whether the element should be included or excluded.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.

Payroll - PAY_ELE_CLASSIFICATION_RULES	Intersection table for PAY_ELEMENT_SETS and PAY_ELEMENT_CLASSIFICATIONS.
Column Name	Descritpion
ELEMENT_SET_ID	Foreign key to PAY_ELEMENT_SETS.
CLASSIFICATION_ID	Foreign key to PAY_ELEMENT_CLASSIFICATIONS.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.

Payroll - PAY_EXTERNAL_ACCOUNTS	Bank account details that enable payments to be made.
Column Name	Descritpion
EXTERNAL_ACCOUNT_ID	System-generated primary key column.
SEGMENT2	Key flexfield segment
SEGMENT3	Key flexfield segment
SEGMENT4	Key flexfield segment
SEGMENT5	Key flexfield segment
SEGMENT6	Key flexfield segment
SEGMENT7	Key flexfield segment
SEGMENT8	Key flexfield segment
SEGMENT9	Key flexfield segment
SEGMENT10	Key flexfield segment
SEGMENT11	Key flexfield segment
TERRITORY_CODE	Foreign key to FND_TERRITORIES.
SEGMENT12	Key flexfield segment
SEGMENT13	Key flexfield segment
SEGMENT14	Key flexfield segment
SEGMENT15	Key flexfield segment
SEGMENT16	Key flexfield segment
SEGMENT17	Key flexfield segment
SEGMENT18	Key flexfield segment
SEGMENT19	Key flexfield segment
SEGMENT20	Key flexfield segment
SEGMENT21	Key flexfield segment column.
PRENOTE_DATE	Date on which a prenote for this account was sent.
SEGMENT22	Key flexfield segment column.
SEGMENT23	Key flexfield segment column.
SEGMENT24	Key flexfield segment column.
SEGMENT25	Key flexfield segment column.
SEGMENT26	Key flexfield segment column.
SEGMENT27	Key flexfield segment column.
SEGMENT28	Key flexfield segment column.
SEGMENT29	Key flexfield segment column.
SEGMENT30	Key flexfield segment column.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
ID_FLEX_NUM	Key flexfield structure foreign key.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
SUMMARY_FLAG	Key flexfield summary flag.
ENABLED_FLAG	Key flexfield enabled flag.
START_DATE_ACTIVE	Date before which key flexfield combination is invalid.
END_DATE_ACTIVE	Date after which key flexfield combination is invalid.
SEGMENT1	Key flexfield segment

Payroll - PAY_FORMULA_RESULT_RULES_F	Rules for specific formula results.
Column Name	Descritpion
FORMULA_RESULT_RULE_ID	System-generated primary key column.
LEGISLATION_SUBGROUP	Identifies the startup data legislation for the formula result rule.
SEVERITY_LEVEL	Severity level for a message type result. Used to control the effect produced by the message.(Validated by a lookup).
INPUT_VALUE_ID	Foreign key to PAY_INPUT_VALUES_F.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
EFFECTIVE_START_DATE	Effective start date.
EFFECTIVE_END_DATE	Effective end date.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
ELEMENT_TYPE_ID	Foreign key to PAY_ELEMENT_TYPES.
STATUS_PROCESSING_RULE_ID	Foreign key to PAY_STATUS_PROCESSING_RULES.
RESULT_NAME	Name of the variable returned by the formula.
RESULT_RULE_TYPE	Formula result type for the formula result rule, for example, direct, indirect, message. (Validated by a lookup).

Payroll - PAY_GRADE_RULES_F	Stores the values for grade or progression point rates.
Column Name	Descritpion
GRADE_RULE_ID	System-generated primary key column.
MINIMUM	User defined minimum value.
SEQUENCE	Sequence denormalized from PER_GRADES when RATE_TYPE is grade.
VALUE	User defined value.
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
EFFECTIVE_START_DATE	Effective start date.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
CURRENCY_CODE	Currency identifier
EFFECTIVE_END_DATE	Effective end date.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
RATE_ID	Foreign key to PAY_RATES.
GRADE_OR_SPINAL_POINT_ID	Foreign key either to grades or to progression points, depending on RATE_TYPE.
RATE_TYPE	Indicates progression point (SP) or grade (G) rule.
MAXIMUM	User defined maximum value.
MID_VALUE	User defined mid value.

Payroll - PAY_INPUT_VALUES_F	Input value definitions for specific elements.
Column Name	Descritpion
INPUT_VALUE_ID	System-generated primary key column.
DISPLAY_SEQUENCE	Display sequence number for the input value.
GENERATE_DB_ITEMS_FLAG	Indicates whether database items are generated for the input values.
HOT_DEFAULT_FLAG	Indicates whether the default value is a HOT default. .
MANDATORY_FLAG	Indicates whether the input value is required for an entry. (Validated by a lookup).
NAME	User name for the input value.
UOM	Unit of measure for the input value (hours, monetary amount, etc).
DEFAULT_VALUE	Default for the input value on entry. Value may be overridden for an element link, and for specific entries.
LEGISLATION_SUBGROUP	Identifies the startup data legislation for the input value.
MAX_VALUE	Maximum value allowed on entry. May be overridden at the element link.
MIN_VALUE	Minimum value allowed on entry. May be overridden at the element link.
EFFECTIVE_START_DATE	Effective start date.
WARNING_OR_ERROR	Indicates the kind of message that is generated if the input value is not valid for min/max or formula validation.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
EFFECTIVE_END_DATE	Effective end date.
ELEMENT_TYPE_ID	Element Type Identifier
LOOKUP_TYPE	List of allowable input values
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
FORMULA_ID	Formula to generate the input value
VALUE_SET_ID	Value set used to validate the input value

Payroll - PAY_ALL_PAYROLLS_F	Payroll group definitions.
Column Name	Descritpion
PAYROLL_ID	System-generated primary key column.
SOFT_CODING_KEYFLEX_ID	Foreign key to HR_SOFT_CODING_KEYFLEX.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
PAYSLIP_VIEW_DATE_OFFSET	Number of days after payment date, on or after which, user can view his payslip
PERIOD_TYPE	Foreign key to PER_TIME_PERIOD_TYPES.
ORGANIZATION_ID	Foreign key to HR_ORGANIZATION_UNITS.
CUT_OFF_DATE_OFFSET	Number of days cut-off date for entries is offset from end of period.
DIRECT_DEPOSIT_DATE_OFFSET	Number of days regular direct deposit date is offset from end of period.
FIRST_PERIOD_END_DATE	End date of the first processing period. Used to generate first and all successive pay period dates for this payroll.
NEGATIVE_PAY_ALLOWED_FLAG	Indicates whether negative payments are allowed.
NUMBER_OF_YEARS	Number of years of pay periods to generate.
PAY_ADVICE_DATE_OFFSET	Number of days regular pay advice is offset from end of period.
PAY_DATE_OFFSET	Number of days regular pay date is offset from end of period.
EFFECTIVE_START_DATE	Effective start date.
PAYROLL_NAME	User name for this payroll.
WORKLOAD_SHIFTING_LEVEL	Indicates whether workload shifting is enabled, and at what levels. Not currently implemented.
COMMENT_ID	Foreign key to HR_COMMENTS.
MIDPOINT_OFFSET	Number of days to offset midpoint date for semi-monthly processing period.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
EFFECTIVE_END_DATE	Effective end date.
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
DEFAULT_PAYMENT_METHOD_ID	Foreign key to PAY_ORG_PAYMENT_METHODS.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
ARREARS_FLAG	Indicates whether payroll is an arrears payroll.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
MULTI_ASSIGNMENTS_FLAG	Indicates whether payroll is to process multiple assignments accumulatively
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
CONSOLIDATION_SET_ID	Foreign key to PAY_CONSOLIDATION_SETS.
PAYROLL_TYPE	Identifies the type of Payroll defined.
PRL_INFORMATION_CATEGORY	Developer descriptive flexfield structure definition column.
PRL_INFORMATION1	Developer descriptive flexfield column.
PRL_INFORMATION2	Developer descriptive flexfield column.
PRL_INFORMATION3	Developer descriptive flexfield column.
PRL_INFORMATION4	Developer descriptive flexfield column.
PRL_INFORMATION5	Developer descriptive flexfield column.
PRL_INFORMATION6	Developer descriptive flexfield column.
PRL_INFORMATION7	Developer descriptive flexfield column.
COST_ALLOCATION_KEYFLEX_ID	Foreign key to PAY_COST_ALLOCATION_KEYFLEX.
PRL_INFORMATION8	Developer descriptive flexfield column.
PRL_INFORMATION9	Developer descriptive flexfield column.
PRL_INFORMATION10	Developer descriptive flexfield column.
PRL_INFORMATION11	Developer descriptive flexfield column.
PRL_INFORMATION12	Developer descriptive flexfield column.
PRL_INFORMATION13	Developer descriptive flexfield column.
PRL_INFORMATION14	Developer descriptive flexfield column.
PRL_INFORMATION15	Developer descriptive flexfield column.
PRL_INFORMATION16	Developer descriptive flexfield column.
PRL_INFORMATION17	Developer descriptive flexfield column.
SUSPENSE_ACCOUNT_KEYFLEX_ID	Foreign key to PAY_COST_ALLOCATION_KEYFLEX.
PRL_INFORMATION18	Developer descriptive flexfield column.
PRL_INFORMATION19	Developer descriptive flexfield column.
PRL_INFORMATION20	Developer descriptive flexfield column.
PRL_INFORMATION21	Developer descriptive flexfield column.
PRL_INFORMATION22	Developer descriptive flexfield column.
PRL_INFORMATION23	Developer descriptive flexfield column.
PRL_INFORMATION24	Developer descriptive flexfield column.
PRL_INFORMATION25	Developer descriptive flexfield column.
PRL_INFORMATION26	Developer descriptive flexfield column.
PRL_INFORMATION27	Developer descriptive flexfield column.
GL_SET_OF_BOOKS_ID	Foreign key to GL_SETS_OF_BOOKS.
PRL_INFORMATION28	Developer descriptive flexfield column.
PRL_INFORMATION29	Developer descriptive flexfield column.
PRL_INFORMATION30	Developer descriptive flexfield column.
PERIOD_RESET_YEARS	Number of Years after which the payroll periods would be reset. Used for Lunar Month Period Types.

Payroll - HR_LEGISLATION_SUBGROUPS	Subgroups in a legislation, such as individual states in the USA.
Column Name	Descritpion
LEGISLATION_CODE	The legislation to which the subgroup belongs.
LEGISLATION_SUBGROUP	Lookup code of the legislation subgroup.
ACTIVE_INACTIVE_FLAG	Indicates whether the legislation subgroup can be used.
LEGISLATION_SUBGROUP_NAME	The lookup meaning of the legislation subgroup.

Payroll - HR_APPLICATION_OWNERSHIPS	Primary keys for entities which enable identification of products that use each piece of startup data.
Column Name	Descritpion
KEY_NAME	The name of the primary key for the type of data.
PRODUCT_NAME	Identifies the product that will use the data.
KEY_VALUE	The value of the primary key.

Payroll - PAY_ACCRUAL_BANDS	Length of service bands used in calculating accrual of paid time off.
Column Name	Descritpion
ACCRUAL_BAND_ID	System-generated primary key column.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ACCRUAL_PLAN_ID	Foreign key to PAY_ACCRUAL_PLANS.
ANNUAL_RATE	Amount of paid time off accrued in a year.
LOWER_LIMIT	Lower length of service limit for the rate.
UPPER_LIMIT	Upper length of service limit for the rate.
CEILING	Maximum entitlement an employee can hold at any time.
MAX_CARRY_OVER	Maximum unused entitlement that can be carried over into the next period.
LAST_UPDATE_DATE	Standard who column - date when a user last updated this row.

Payroll - PAY_ACCRUAL_PLANS	PTO accrual plan definitions, (Paid time off).
Column Name	Descritpion
ACCRUAL_PLAN_ID	System-generated primary key column.
RESIDUAL_INPUT_VALUE_ID	Identifies the element and input value that is used to record residual leave at the end of a period.
INFORMATION12	Developer descriptive flexfield column.
INFORMATION13	Developer descriptive flexfield column.
RESIDUAL_DATE_INPUT_VALUE_ID	Foreign key to PAY_INPUT_VALUES_F. Identifies the element and input value which stores the date when residual time becomes effective.
INFORMATION14	Developer descriptive flexfield column.
INFORMATION15	Developer descriptive flexfield column.
ACCRUAL_FORMULA_ID	Foreign key to FF_FORMULAS_F. Identifies the formula used to calculate accrued time.
INFORMATION16	Developer descriptive flexfield column.
INFORMATION17	Developer descriptive flexfield column.
ACCRUAL_PLAN_NAME	User defined accrual plan name.
INFORMATION18	Developer descriptive flexfield column.
INFORMATION19	Developer descriptive flexfield column.
ACCRUAL_CATEGORY	Indicates whether a plan is Sickness or Vacation.
INFORMATION20	Developer descriptive flexfield column.
INFORMATION21	Developer descriptive flexfield column.
ACCRUAL_START	Indicates accrual start rule. This can be hire date, beginning of year, or six months after hire.
INFORMATION22	Developer descriptive flexfield column.
INFORMATION23	Developer descriptive flexfield column.
ACCRUAL_UNITS_OF_MEASURE	Indicates whether the accrual units are hours or days.
INFORMATION24	Developer descriptive flexfield column.
INFORMATION25	Developer descriptive flexfield column.
INELIGIBLE_PERIOD_LENGTH	User defined period of ineligibility, in conjunction with the ineligible period type.
INFORMATION26	Developer descriptive flexfield column.
INFORMATION27	Developer descriptive flexfield column.
INELIGIBLE_PERIOD_TYPE	Period type for the INELIGIBLE_PERIOD_LENGTH, for example, weeks or months.
INFORMATION28	Developer descriptive flexfield column.
INFORMATION29	Developer descriptive flexfield column.
DESCRIPTION	Description of the accrual plan.
INFORMATION30	Developer descriptive flexfield column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
INELIGIBILITY_FORMULA_ID	Foreign key to FF_FORMULAS_F. Identifies the formula used to calculate whether an employee is eligible to accrue time.
PAYROLL_FORMULA_ID	Foreign key to FF_FORMULAS_F. Identifies the formula specified in run result rules used by payroll processing.
DEFINED_BALANCE_ID	Foreign key to PAY_DEFINED_BALANCES. Identifies the defined balance used to store Accruals.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
TAGGING_ELEMENT_TYPE_ID	Foreign key to PAY_ELEMENT_TYPES. Identifies the element that is used to flag retrospective net calculation rule element entries.
BALANCE_ELEMENT_TYPE_ID	Foreign key to PAY_ELEMENT_TYPES. Identifies the element that is used to manage the maintainance of an accrual payroll balance.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ACCRUAL_PLAN_ELEMENT_TYPE_ID	Foreign key to PAY_ELEMENT_TYPES. Identifies the element that is used to enrol employees in the accrual plan.
CREATION_DATE	Standard who column - date when this row was created.
INFORMATION_CATEGORY	Developer descriptive flexfield structure defining column.
PTO_INPUT_VALUE_ID	No longer used.
INFORMATION1	Developer descriptive flexfield column.
INFORMATION2	Developer descriptive flexfield column.
CO_FORMULA_ID	Foreign key to FF_FORMULAS_F. Identifies the formula to be used to calculate values for the PTO carryover process.
INFORMATION3	Developer descriptive flexfield column.
INFORMATION4	Developer descriptive flexfield column.
INFORMATION5	Developer descriptive flexfield column.
CO_INPUT_VALUE_ID	Identifies the input value that is used to record carryover entitlement from one period to the next.
INFORMATION6	Developer descriptive flexfield column.
INFORMATION7	Developer descriptive flexfield column.
CO_DATE_INPUT_VALUE_ID	Foreign key to PAY_INPUT_VALUES_F. Identifies the element and input value which stores the date when carried over time becomes effective.
INFORMATION8	Developer descriptive flexfield column.
INFORMATION9	Developer descriptive flexfield column.
CO_EXP_DATE_INPUT_VALUE_ID	Foreign key to PAY_INPUT_VALUES_F. Identifies the element and input value which stores the date when carried over time expires.
INFORMATION10	Developer descriptive flexfield column.
INFORMATION11	Developer descriptive flexfield column.

Payroll - PAY_ELE_PAYROLL_FREQ_RULES	Frequency rules for a deduction/payroll combination.
Column Name	Descritpion
ELE_PAYROLL_FREQ_RULE_ID	System-generated primary key column.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
RULE_DATE_CODE
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ELEMENT_TYPE_ID	Foreign key to PAY_ELEMENT_TYPES.
PAYROLL_ID	Foreign key to PAY_PAYROLLS.
RESET_PERIOD_TYPE	Frequency of reset. If pay period is a month or less then the reset period is Month. Pay periods greater than a month have a reset period of Year.
START_DATE	Start Date.
RESET_NO_OF_PERIODS	Not currently used.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).

Payroll - PAY_JOB_WC_CODE_USAGES	Workers Compensation codes for specific job and state combinations.
Column Name	Descritpion
JOB_ID	Foreign key to PER_JOBS.
STATE_CODE	Foreign key to PAY_STATE_RULES.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
WC_CODE	Foreign key to PAY_WC_RATES.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.

Payroll - PAY_FREQ_RULE_PERIODS	Stores frequency rule for a deduction/payroll combination.
Column Name	Descritpion
FREQ_RULE_PERIOD_ID	System-generated primary key column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ELE_PAYROLL_FREQ_RULE_ID	Foreign key to PAY_ELE_PAYROLL_FREQ_RULES.
PERIOD_NO_IN_RESET_PERIOD	Which period within the reset period is the rule valid.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.

Payroll - PAY_BALANCE_CONTEXT_VALUES	Localization balance contexts.
Column Name	Descritpion
CONTEXT_ID	Foreign key to FF_CONTEXTS.
LATEST_BALANCE_ID	Foreign key to either PAY_PERSON_LATEST_BALANCES or PAY_ASSIGNMENT_LATEST_BALANCES.
VALUE	Value of the context.

Payroll - PAY_BATCH_HEADERS	Header information for a Batch Element Entry batch.
Column Name	Descritpion
BATCH_ID	Surrogate primary key.
PURGE_AFTER_TRANSFER	Indicates if the batch lines should be automatically purged after transfer.
REJECT_IF_FUTURE_CHANGES	Indicates if the batch lines should be rejected if future changes already exist.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
REJECT_IF_RESULTS_EXISTS	Indicates if the batch line should be rolled back if run result exist.
PURGE_AFTER_ROLLBACK	Indicates if the batch line should be purged after rollback.
BUSINESS_GROUP_ID	Business group identifier.
REJECT_ENTRY_NOT_REMOVED	Indicates if the batch line's transfer status should not be reverted to unprocessed if there is no entry found or entry not removed.
ROLLBACK_ENTRY_UPDATES	Indicates whether or not to rollback the updates on the entry made by the Batch Element Entry transfer process.
BATCH_TYPE	Holds the batch type information for this batch.
BATCH_NAME	Name of the batch (non-unique).
BATCH_STATUS	Shows the status the batch is currently in.
ACTION_IF_EXISTS	What action should the process perform if the entry already exists.
BATCH_REFERENCE	User defined reference for batch.
BATCH_SOURCE	Free format specification of batch source.
COMMENTS	Batch header comment.
DATE_EFFECTIVE_CHANGES	Type of Date Effective change.

Payroll - PAY_BATCH_CONTROL_TOTALS	Holds user defined control totals for the Batch Element Entry process.
Column Name	Descritpion
BATCH_CONTROL_ID	Surrogate primary key.
BATCH_ID	Foreign key to PAY_BATCH_HEADERS.
CONTROL_STATUS	Control status.
CONTROL_TOTAL	Value of total to be checked against calculated value.
CONTROL_TYPE	User defined lookup value for CONTROL_TYPE.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.

Payroll - PAY_BATCH_LINES	Batch lines for a Batch Element Entry batch.
Column Name	Descritpion
BATCH_LINE_ID	Surrogate primary key.
EFFECTIVE_DATE	Effective end date.
ENTRY_INFORMATION20	Developer descriptive flexfield column.
ENTRY_INFORMATION21	Developer descriptive flexfield column.
ENTRY_INFORMATION22	Developer descriptive flexfield column.
ENTRY_INFORMATION23	Developer descriptive flexfield column.
ENTRY_INFORMATION24	Developer descriptive flexfield column.
ENTRY_INFORMATION25	Developer descriptive flexfield column.
ENTRY_INFORMATION26	Developer descriptive flexfield column.
ENTRY_INFORMATION27	Developer descriptive flexfield column.
ENTRY_INFORMATION28	Developer descriptive flexfield column.
ENTRY_INFORMATION29	Developer descriptive flexfield column.
ELEMENT_NAME	The element name.
ENTRY_INFORMATION30	Developer descriptive flexfield column.
EFFECTIVE_START_DATE	Effective start date.
EFFECTIVE_END_DATE	Effective end date.
DATE_EARNED	Date the entry was earned.
PERSONAL_PAYMENT_METHOD_ID	Used to identify third party payments
SUBPRIORITY	Subpriority for the entry.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
ENTRY_TYPE	Type of entry.
REASON	Holds the meaning, not the code.
SEGMENT1	Key flexfield segment
SEGMENT2	Key flexfield segment
SEGMENT3	Key flexfield segment
SEGMENT4	Key flexfield segment
SEGMENT5	Key flexfield segment
SEGMENT6	Key flexfield segment
COST_ALLOCATION_KEYFLEX_ID	Foreign key to PAY_COST_ALLOCATION_KEYFLEX.
SEGMENT7	Key flexfield segment
SEGMENT8	Key flexfield segment
SEGMENT9	Key flexfield segment
SEGMENT10	Key flexfield segment
SEGMENT11	Key flexfield segment
SEGMENT12	Key flexfield segment
SEGMENT13	Key flexfield segment
SEGMENT14	Key flexfield segment
SEGMENT15	Key flexfield segment
SEGMENT16	Key flexfield segment
ELEMENT_TYPE_ID	Foreign key to PAY_ELEMENT_TYPES.
SEGMENT17	Key flexfield segment
SEGMENT18	Key flexfield segment
SEGMENT19	Key flexfield segment
SEGMENT20	Key flexfield segment
SEGMENT21	Key flexfield segment column.
SEGMENT22	Key flexfield segment column.
SEGMENT23	Key flexfield segment column.
SEGMENT24	Key flexfield segment column.
SEGMENT25	Key flexfield segment column.
SEGMENT26	Key flexfield segment column.
ASSIGNMENT_ID	Foreign key to PER_ASSIGNMENTS.
SEGMENT27	Key flexfield segment column.
SEGMENT28	Key flexfield segment column.
SEGMENT29	Key flexfield segment column.
SEGMENT30	Key flexfield segment column.
VALUE_1	Element input-values.
VALUE_2	Element input-values.
VALUE_3	Element input-values.
VALUE_4	Element input-values.
VALUE_5	Element input-values.
VALUE_6	Element input-values.
BATCH_ID	Foreign key to PAY_BATCH_HEADERS.
VALUE_7	Element input-values.
VALUE_8	Element input-values.
VALUE_9	Element input-values.
VALUE_10	Element input-values.
VALUE_11	Element input-values.
VALUE_12	Element input-values.
VALUE_13	Element input-values.
VALUE_14	Element input-values.
VALUE_15	Element input-values.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
BATCH_LINE_STATUS	Status of line, see domain.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ASSIGNMENT_NUMBER	Assignment number.
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
BATCH_SEQUENCE	Batch sequence number.
ENTRY_INFORMATION_CATEGORY	Developer descriptive flexfield column.
ENTRY_INFORMATION1	Developer descriptive flexfield column.
ENTRY_INFORMATION2	Developer descriptive flexfield column.
ENTRY_INFORMATION3	Developer descriptive flexfield column.
ENTRY_INFORMATION4	Developer descriptive flexfield column.
ENTRY_INFORMATION5	Developer descriptive flexfield column.
ENTRY_INFORMATION6	Developer descriptive flexfield column.
ENTRY_INFORMATION7	Developer descriptive flexfield column.
ENTRY_INFORMATION8	Developer descriptive flexfield column.
ENTRY_INFORMATION9	Developer descriptive flexfield column.
CONCATENATED_SEGMENTS	Key flexfield segment column.
ENTRY_INFORMATION10	Developer descriptive flexfield column.
ENTRY_INFORMATION11	Developer descriptive flexfield column.
ENTRY_INFORMATION12	Developer descriptive flexfield column.
ENTRY_INFORMATION13	Developer descriptive flexfield column.
ENTRY_INFORMATION14	Developer descriptive flexfield column.
ENTRY_INFORMATION15	Developer descriptive flexfield column.
ENTRY_INFORMATION16	Developer descriptive flexfield column.
ENTRY_INFORMATION17	Developer descriptive flexfield column.
ENTRY_INFORMATION18	Developer descriptive flexfield column.
ENTRY_INFORMATION19	Developer descriptive flexfield column.

Payroll - PAY_BALANCE_BATCH_HEADERS	Batch header information for balance upload batch.
Column Name	Descritpion
BATCH_ID	Primary key.
UPLOAD_DATE	Date the balances were uploaded.
BATCH_TYPE
BATCH_NAME	User-defined name of the batch.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
BATCH_STATUS	Status of batch.
BATCH_REFERENCE	User reference for batch.
BATCH_SOURCE	User-defined source of batch.
BUSINESS_GROUP_NAME	Business Group name, may be entered instead of the batch id.
PAYROLL_ID	Foreign key to PAY_PAYROLLS.
PAYROLL_NAME	Payroll name, may be entered instead of the batch id.

Payroll - PAY_BALANCE_BATCH_LINES	Individual batch lines for the balance upload process.
Column Name	Descritpion
ASSIGNMENT_ID	Foreign key to PER_ASSIGNMENTS.
BALANCE_NAME	Identifies the balance to upload by name. Alternatively use the BALANCE_TYPE_ID.
DIMENSION_NAME	Identifies the balance dimension by name. Alternatively use the BALANCE_TYPE_ID.
GRE_NAME	Government Reporting Entity name.
JURISDICTION_CODE	Jurisdiction code.
ORIGINAL_ENTRY_ID	Context of element entry id.
TAX_UNIT_ID	Foreign key to HR_ORGANIZATION_UNITS (ORGANIZATION_ID).
SOURCE_ID	Context of Source id
SOURCE_TEXT	Context of Source Text
BALANCE_DIMENSION_ID	Foreign key to PAY_BALANCE_DIMENSIONS.
RUN_TYPE_NAME	Description of Run Type.
RUN_TYPE_ID	Foreign key to PAY_RUN_TYPES_F.
BALANCE_TYPE_ID	Foreign key to PAY_BALANCE_TYPES.
UPLOAD_DATE	Date of upload for the individual line.
SOURCE_NUMBER	Context of Source Number
PAYROLL_ACTION_ID	Foreign key to PAY_PAYROLL_ACTIONS.
SOURCE_TEXT2	Context of Source Text2
BATCH_ID	Foreign key to balance batch headers.
BATCH_LINE_ID	Primary key.
BATCH_LINE_STATUS	Status of each balance batch line in the upload process.
VALUE	The balance value to upload.
ASSIGNMENT_NUMBER	Identifies the assignment for the balance value. Alternatively use the ASSIGNMENT_ID.

Payroll - HR_AUDITS	Main audit table that records the transactions carried out on an audited table from its shadow table.
Column Name	Descritpion
AUDIT_ID	Primary key from sequence HR_AUDITS_S.
TRANSACTION	Description of the audited transaction.
TRANSACTION_TYPE	Type of audit transaction, (I)nsert, (U)pdate or (D)elete.
USER_NAME	Name of user performing the transaction.
EFFECTIVE_END_DATE	Effective end date value of the audited transaction.
EFFECTIVE_START_DATE	Effective start date value of the audited transaction.
COMMIT_ID	Commit reference for the audited transaction.
CURRENT_SESSION_ID	Current session id of the audit process.
PRIMARY_KEY	Primary key column name of the audited table.
PRIMARY_KEY_VALUE	ID of the primary key for the audited table.
SEQUENCE_ID	Sequence of the transaction within a commit unit.
SESSION_ID	ORACLE session ID of the audited process.
TABLE_NAME	Name of audited table.
TIMESTAMP	Date and time the audited transaction took place.

Payroll - HR_AUDIT_COLUMNS	Column changes for specific audit transactions.
Column Name	Descritpion
AUDIT_ID	Foreign key to HR_AUDITS.
COLUMN_ID	Foreign key to FND_COLUMNS.
COLUMN_NAME	Name of the audited column subject to a change.
NEW_VALUE	New value of the column after the change.
OLD_VALUE	Old value of the column before the change.

Payroll - PAY_GB_TAX_CODE_INTERFACE	Interface table for the UK Start of Year process.
Column Name	Descritpion
DISTRICT_NUMBER	Tax district number.
DATE_OF_MESSAGE	Date the P6 message was sent
ISSUE_DATE	Date the P6 was issued
TOT_PAY_PREV_EMP	Total Pay from previous employer
TOT_TAX_PREV_EMP	Total Tax paid in previous employment
FORM_TYPE	Form Type issue by Inland Revenue
REQUEST_ID	Concurrent Program Request ID
EMPLOYER_REFERENCE	Employers reference for a PAYE scheme.
NATIONAL_INSURANCE_NUMBER	Employees reference (National Insurance number).
TAX_CODE	New tax code.
NON_CUMULATIVE_FLAG	Indicates whether the tax code is cumulative, where Y = non-cumulative and null = cumulative.
EMPLOYEE_NAME	Employee name, given as surname, title, initials and/or forenames.
WORKS_NUMBER	Works reference number.
PROCESSED_FLAG	Indicates whether the tax code amendments have been processed, where null = Unprocessed, P = Processed, R = Rejected.
EFFECTIVE_DATE	Effective_Date

Payroll - PAY_GB_YEAR_END_PAYROLLS	Payroll information for the UK EOY process.
Column Name	Descritpion
PAYROLL_ID	Foreign key to PAY_ALL_PAYROLLS_F.
PAYROLL_NAME	Name of the payroll.
PERIOD_TYPE	Foreign key to PER_TIME_PERIOD_TYPES.
PERMIT_NUMBER	Permit number issued by the DSS for use on the year end magnetic media.
SMP_COMPENSATION	Amount of NIC compensation (recoverable amount) on SMP for this Payroll and Year.
SMP_RECOVERED	Amount of SMP recovered for the payroll in the year.
SSP_RECOVERED	Amount of SSP recovered for the payroll in the year.
START_PREVIOUS_YEAR	Start date of the first period for the previous year.
START_YEAR	Start date of the first period in the year for this payroll.
TAX_DISTRICT_NAME	Name of the tax district.
TAX_DISTRICT_REFERENCE	Inspector of Taxes reference code.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
TAX_REFERENCE_NUMBER	Unique reference number allocated to employer by the Inspector of Taxes.
TAX_YEAR	Calendar year in which the specific Financial year ends.
ECON	Employers contracted out number.
EMPLOYERS_ADDRESS_LINE	Employers statutory reporting address.
EMPLOYERS_NAME	Employers statutory reporting name.
END_PREVIOUS_YEAR	End date of the last period of the previous year.
END_YEAR	End date of the last period in the year for this payroll.
MAX_PERIOD_NUMBER	Highest period number for the payroll, identifies week 53.

Payroll - PAY_GB_YEAR_END_VALUES	Extraction table for the UK End of Year process that holds information about the NI balances at the year end.
Column Name	Descritpion
EARNINGS	Balance value from NI_CATEGORY_ABLE_ASG_TD_YTD.
EMPLOYEES_CONTRIBUTIONS	Balance value from NI CO_ASG_TD_YTD.
TOTAL_CONTRIBUTIONS	Balance value from NI TOTAL_ASG_TD_YTD.
EARNINGS_CONTRACTED_OUT	Balance value from NI CO_ASG_TD_YTD.
CONTRIBUTIONS_CONTRACTED_OUT	Total amount of contracted out contributions taken from balance NI ABLE_ASG_TD_YTD.
ASSIGNMENT_ID	First part of foreign key to PAY_GB_YEAR_END_ASSIGNMENTS.
EFFECTIVE_END_DATE	Second part of foreign key to PAY_GB_YEAR_END_ASSIGNMENTS.
REPORTABLE	Y=report contributions on this assignment.
NI_CATEGORY_CODE	NI category code, (A, B, C, D, E, P, X, or Y).
SCON	NI Scheme contracted out number

Payroll - PAY_GB_SOY_OUTPUTS	Temporary table for GB Start of Year process outputs.
Column Name	Descritpion
TYPE	Type of report for the outputs.
LINE_NO	Line number within the appropriate SOY report output.
TEXT	Free format text for SOY report.
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).

Payroll - PAY_GB_YEAR_END_ASSIGNMENTS	Extraction table for UK End of Year processing, which holds information about assignments.
Column Name	Descritpion
ASSIGNMENT_ID	System-generated primary key column.
EFFECTIVE_END_DATE	Effective end date for a specific assignment in the financial year.
PAYROLL_ID	Foreign key to PAY_GB_YEAR_END_PAYROLLS.
ASSIGNMENT_NUMBER	Employee assignment number.
CHUNK_NUMBER	Number used to group events into chunks for parallelization.
DATE_OF_BIRTH	Date of birth.
DIRECTOR_INDICATOR	Indicates whether a person has been a company director during the financial year, where D = director and null = employee
EFFECTIVE_START_DATE	Effective start date for the assignment. If it starts before the start of the financial year, the entry is null.
EOY_PRIMARY_FLAG	Indicates whether the assignment shows the NI balances for a person with multiple assignments, where Y = report NI.
EXPENSE_CHECK_SEND_TO_ADDRESS	O(office),H(home),Null flag indicates distribution for the P60.
EXTRACT_DATE	Date the extract was run.
FIRST_NAME	First name of employee.
GROSS_PAY	Gross pay from balance GROSS_PAY_ASG_TD_YTD.
LAST_ASG_ACTION_ID	Assignment action identifier of the latest action for the assignment.
LAST_EFFECTIVE_DATE	Effective date of the latest action for the assignment.
LAST_NAME	Last name of employee .
LOCATION_ID	Foreign key to HR_LOCATIONS.
MIDDLE_NAME	Middle name of employee.
MULTIPLE_ASG_FLAG	Indicates whether a person has multiple payroll assignments.
NATIONAL_INSURANCE_NUMBER	National identifier for the person.
ORGANIZATION_ID	Foreign key to HR_ORGANIZATION_UNITS.
PENSIONER_INDICATOR	Indicates whether a person is an employee or pensioner, where P = pensioner and null = employee.
PEOPLE_GROUP_ID	Foreign key to PAY_PEOPLE_GROUPS.
PERSON_ID	Foreign key to PER_PEOPLE.
PREVIOUS_TAXABLE_PAY	Previous taxable pay amount (taken from result PAYE_DETAILS_PAY_PREVIOUS).
PREVIOUS_TAX_PAID	Previous tax paid amount (taken from result PAYE_DETAILS_TAX_PREVIOUS).
PREVIOUS_YEAR_ASG_ACTION_ID	Assignment action identifier of the latest action in the previous year.
PREVIOUS_YEAR_EFFECTIVE_DATE	Effective date of the latest action in the previous year.
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
SEX	Identifies gender of person, where M = male and F = female.
SMP	Total SMP amount paid (taken from balance SMP_TOTAL_ASG_TD_YTD).
SSP	Total SSP amount paid (taken from balance SSP_TOTAL_ASG_TD_YTD).
SUPERANNUATION_PAID	Total amount of superannuation paid (taken from balance SUPERANNUATION_TOTAL_ASG_TD_YTD).
SUPERANNUATION_REFUND	Indicates whether superannuation was refunded, where R = refund and null = deduction.
TAXABLE_PAY	Total amount of taxable pay (taken from balance TAXABLE_PAY_ASG_TD_YTD).
TAX_CODE	Tax code for the latest tax calculation.
TAX_PAID	Total tax paid (taken from balance PAYE_ASG_TD_YTD).
TAX_REFUND	Indicates whether tax has been refunded, where R = refunded and null = deduction).
TAX_RUN_RESULT_ID	Run result that last updated PAYE this year.
TERMINATION_DATE	Actual termination date or the tax reference transfer date, if the employee has changed tax districts during the year.
TITLE	Employees title
START_OF_EMP	Start date of employment
TERMINATION_TYPE	Indicates the type of termination, where R = tax reference transfer and L = leaver.
W1_M1_INDICATOR	Indicates tax basis, if cumulative then null, if non-cumulative, then either W for weekly basis or M for Monthly.
WEEK_53_INDICATOR	3(53), 4(54), 6(56) , null(other) max. period no. in the year.
WIDOWS_AND_ORPHANS	Balance value from WIDOWS_AND_ORPHANS_ASG_TD_YTD.
ADDRESS_LINE1	Employees primary address line 1
ADDRESS_LINE2	Employees primary address line 2
ADDRESS_LINE3	Employees primary address line 3
TOWN_OR_CITY	Employees primary address town or city
COUNTY	Employess primary address county
POSTAL_CODE	Employees primary address postcode

Payroll - HR_OWNER_DEFINITIONS	Stores internal record for ownership of seed data
Column Name	Descritpion
SESSION_ID
PRODUCT_SHORT_NAME

Payroll - PAY_COMPARISON_ROWS
Column Name	Descritpion
COMPARISON_SET_ID
FIELD7
FIELD8
FIELD9
FIELD10
FIELD11
FIELD12
COMPARISON_ROW_ID
FIELD13
FIELD14
FIELD1
FIELD2
FIELD3
FIELD4
FIELD5
FIELD6

Payroll - PAY_CA_EMP_FED_TAX_INFO_F	Canadian federal tax information
Column Name	Descritpion
EMP_FED_TAX_INF_ID	Unique identifier for the federal tax information record
BASIC_EXEMPTION_FLAG	If the flag is Y then tax_credit_amount is basic exempt amount, if it is 'N' then tax credit amount is different
ADDITIONAL_TAX	Additional tax deduction
ANNUAL_DEDN	Annual Deduction
TOTAL_EXPENSE_BY_COMMISSION	Estimated annual taxable income by commission
TOTAL_REMNRTN_BY_COMMISSION	Total revised expense amnount by remunaration
PRESCRIBED_ZONE_DEDN_AMT	Prescribed zone deduction
OTHER_FEDTAX_CREDITS	Other tax credits
CPP_QPP_EXEMPT_FLAG	Exempt flag for CPP
FED_EXEMPT_FLAG	Federal tax exempt flag
EFFECTIVE_START_DATE	Effective start date.
EI_EXEMPT_FLAG	EI tax exempt flag
TAX_CALC_METHOD	Federal tax calculation method
FED_OVERRIDE_AMOUNT	Federal tax override amount
FED_OVERRIDE_RATE	Federal tax override rate
CA_TAX_INFORMATION_CATEGORY	Descriptive flexfield structure defining column.
CA_TAX_INFORMATION1	Descriptive flexfield column.
CA_TAX_INFORMATION2	Descriptive flexfield column.
CA_TAX_INFORMATION3	Descriptive flexfield column.
CA_TAX_INFORMATION4	Descriptive flexfield column.
EFFECTIVE_END_DATE	Effective end date.
CA_TAX_INFORMATION5	Descriptive flexfield column.
CA_TAX_INFORMATION6	Descriptive flexfield column.
CA_TAX_INFORMATION7	Descriptive flexfield column.
CA_TAX_INFORMATION8	Descriptive flexfield column.
CA_TAX_INFORMATION9	Descriptive flexfield column.
CA_TAX_INFORMATION10	Descriptive flexfield column.
CA_TAX_INFORMATION11	Descriptive flexfield column.
CA_TAX_INFORMATION12	Descriptive flexfield column.
CA_TAX_INFORMATION13	Descriptive flexfield column.
CA_TAX_INFORMATION14	Descriptive flexfield column.
LEGISLATION_CODE	Legislation Code, which will be CA
CA_TAX_INFORMATION15	Descriptive flexfield column.
ASSIGNMENT_ID	Assignment ID for which the tax records are created.
CA_TAX_INFORMATION16	Descriptive flexfield column.
CA_TAX_INFORMATION17	Descriptive flexfield column.
CA_TAX_INFORMATION18	Descriptive flexfield column.
CA_TAX_INFORMATION19	Descriptive flexfield column.
CA_TAX_INFORMATION20	Descriptive flexfield column.
CA_TAX_INFORMATION21	Descriptive flexfield column.
CA_TAX_INFORMATION22	Descriptive flexfield column.
CA_TAX_INFORMATION23	Descriptive flexfield column.
CA_TAX_INFORMATION24	Descriptive flexfield column.
CA_TAX_INFORMATION25	Descriptive flexfield column.
BUSINESS_GROUP_ID	Business Group ID for which the tax records are created.
CA_TAX_INFORMATION26	Descriptive flexfield column.
CA_TAX_INFORMATION27	Descriptive flexfield column.
CA_TAX_INFORMATION28	Descriptive flexfield column.
CA_TAX_INFORMATION29	Descriptive flexfield column.
CA_TAX_INFORMATION30	Descriptive flexfield column.
EMPLOYMENT_PROVINCE	Province in which the employee is employed
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
FED_LSF_AMOUNT	Fed LSF Amount
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
TAX_CREDIT_AMOUNT	Tax credit amount
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
CLAIM_CODE	Claim code, Currently not used

Payroll - PAY_CA_EMP_PROV_TAX_INFO_F	Canadian provincial tax information
Column Name	Descritpion
EMP_PROVINCE_TAX_INF_ID	Unique identifier for the federal tax information record
BASIC_EXEMPTION_FLAG	Basic Exempt Flag. If this flag is Y then tax_credit amount is the basic exempt amount in PAY_CA_LEGISLATION_INFO
DEDUCTION_CODE	Deduction Code - currently not used
MARRIAGE_STATUS	Married/Unmarried status
NO_OF_INFIRM_DEPENDANTS	No of infirm dependants
NON_RESIDENT_STATUS	Non resident status
EFFECTIVE_START_DATE	Effective start date.
DISABILITY_STATUS	Disability status
NO_OF_DEPENDANTS	Total no of dependants
ANNUAL_DEDN	Annula deduction
TOTAL_EXPENSE_BY_COMMISSION	Estimated annual taxable income
TOTAL_REMNRTN_BY_COMMISSION	Estimated revised expense amount
PRESCRIBED_ZONE_DEDN_AMT	Precribe zone deduction amount
ADDITIONAL_TAX	Additional tax deduction
PROV_OVERRIDE_RATE	Override rate for federal tax calculation
EFFECTIVE_END_DATE	Effective end date.
PROV_OVERRIDE_AMOUNT	Override amount for federal tax
PROV_EXEMPT_FLAG	Exempt flag for provincial tax deduction
PMED_EXEMPT_FLAG	Provincial Medical plan exempt flag
WC_EXEMPT_FLAG	Workers compensation exempt flag
QPP_EXEMPT_FLAG	QPP exempt flag
OTHER_TAX_CREDIT	Other tax credit amounts
TAX_CALC_METHOD	Provincial tax calculation method
LEGISLATION_CODE	Legislation code
EXTRA_INFO_NOT_PROVIDED	Flag to indicate additional information is not provided or not
CA_TAX_INFORMATION_CATEGORY	Descriptive flexfield structure defining column.
CA_TAX_INFORMATION1	Descriptive flexfield column.
CA_TAX_INFORMATION2	Descriptive flexfield column.
CA_TAX_INFORMATION3	Descriptive flexfield column.
CA_TAX_INFORMATION4	Descriptive flexfield column.
CA_TAX_INFORMATION5	Descriptive flexfield column.
CA_TAX_INFORMATION6	Descriptive flexfield column.
CA_TAX_INFORMATION7	Descriptive flexfield column.
ASSIGNMENT_ID	Assignment ID
CA_TAX_INFORMATION8	Descriptive flexfield column.
CA_TAX_INFORMATION9	Descriptive flexfield column.
CA_TAX_INFORMATION10	Descriptive flexfield column.
CA_TAX_INFORMATION11	Descriptive flexfield column.
CA_TAX_INFORMATION12	Descriptive flexfield column.
CA_TAX_INFORMATION13	Descriptive flexfield column.
CA_TAX_INFORMATION14	Descriptive flexfield column.
CA_TAX_INFORMATION15	Descriptive flexfield column.
CA_TAX_INFORMATION16	Descriptive flexfield column.
CA_TAX_INFORMATION17	Descriptive flexfield column.
BUSINESS_GROUP_ID	Business Group ID
CA_TAX_INFORMATION18	Descriptive flexfield column.
CA_TAX_INFORMATION19	Descriptive flexfield column.
CA_TAX_INFORMATION20	Descriptive flexfield column.
CA_TAX_INFORMATION21	Descriptive flexfield column.
CA_TAX_INFORMATION22	Descriptive flexfield column.
CA_TAX_INFORMATION23	Descriptive flexfield column.
CA_TAX_INFORMATION24	Descriptive flexfield column.
CA_TAX_INFORMATION25	Descriptive flexfield column.
CA_TAX_INFORMATION26	Descriptive flexfield column.
PROVINCE_CODE	Province abbreviation
CA_TAX_INFORMATION27	Descriptive flexfield column.
CA_TAX_INFORMATION28	Descriptive flexfield column.
CA_TAX_INFORMATION29	Descriptive flexfield column.
CA_TAX_INFORMATION30	Descriptive flexfield column.
PROV_LSP_AMOUNT	PROV LSP Amount
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
JURISDICTION_CODE	Jurisdiction code - not used currently
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
TAX_CREDIT_AMOUNT	Tax Credit Amount
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
PPIP_EXEMPT_FLAG

Payroll - PAY_GL_INTERFACE	Costed details to be passed to the General Ledger
Column Name	Descritpion
ASSIGNMENT_ACTION_ID	Foreign Key to PAY_ASSIGNMENT_ACTIONS
ACCOUNTING_DATE	Accounting date for estimated cost reversals
RUN_PAYROLL_ACTION_ID	Foreign Key to PAY_PAYROLL_ACTIONS
COST_ALLOCATION_KEYFLEX_ID	Foreign Key to PAY_COST_ALLOCATION_KEYFLEX
CURRENCY_CODE	Currency Code of result
ENTERED_DR	Deduction costed values
ENTERED_CR	Credit costed values

Payroll - PAY_BALANCE_SETS	Allows related balances to be grouped for reporting purposes.
Column Name	Descritpion
BALANCE_SET_ID	System-generated primary key column.
ATTRIBUTE_5	Descriptive flexfield column.
ATTRIBUTE_6	Descriptive flexfield column.
ATTRIBUTE_7	Descriptive flexfield column.
ATTRIBUTE_8	Descriptive flexfield column.
ATTRIBUTE_9	Descriptive flexfield column.
ATTRIBUTE_10	Descriptive flexfield column.
ATTRIBUTE_11	Descriptive flexfield column.
ATTRIBUTE_12	Descriptive flexfield column.
ATTRIBUTE_13	Descriptive flexfield column.
ATTRIBUTE_14	Descriptive flexfield column.
BALANCE_SET_NAME	User name to identify set.
ATTRIBUTE_15	Descriptive flexfield column.
ATTRIBUTE_16	Descriptive flexfield column.
ATTRIBUTE_17	Descriptive flexfield column.
ATTRIBUTE_18	Descriptive flexfield column.
ATTRIBUTE_19	Descriptive flexfield column.
ATTRIBUTE_20	Descriptive flexfield column.
ATTRIBUTE_21	Descriptive flexfield column.
ATTRIBUTE_22	Descriptive flexfield column.
ATTRIBUTE_23	Descriptive flexfield column.
ATTRIBUTE_24	Descriptive flexfield column.
COMMENTS	Free format comments about the set.
ATTRIBUTE_25	Descriptive flexfield column.
ATTRIBUTE_26	Descriptive flexfield column.
ATTRIBUTE_27	Descriptive flexfield column.
ATTRIBUTE_28	Descriptive flexfield column.
ATTRIBUTE_29	Descriptive flexfield column.
ATTRIBUTE_30	Descriptive flexfield column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
ATTRIBUTE_1	Descriptive flexfield column.
ATTRIBUTE_2	Descriptive flexfield column.
ATTRIBUTE_3	Descriptive flexfield column.
ATTRIBUTE_4	Descriptive flexfield column.

Payroll - PAY_CA_LEGISLATION_INFO	Canadian legislation specific data
Column Name	Descritpion
LOOKUP_TYPE	Lookup Type
LOOKUP_CODE	Lookup Code
JURISDICTION_CODE	Jurisdiction Code
INFORMATION_TYPE	Information Type
INFORMATION_VALUE	Value for the information type
START_DATE	Start date of the record
END_DATE	End date of the record

Payroll - HR_REPORT_LOOKUPS	Reports Select /Sort Parameter QuickCodes defined for Oracle Payroll Applications Year end Reports.
Column Name	Descritpion
REPORT_LOOKUP_TYPE	Sort or Select parameter
LOOKUP_CODE	Foreign key for lookup to use
ENABLED_FLAG	Indicates if the lookup enabled
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REPORT_NAME	Name of report using the lookup

Payroll - PAY_ELEMENT_TEMPLATES	Element Templates
Column Name	Descritpion
TEMPLATE_ID	System-generated primary key column.
PREFERENCE_INFO_CATEGORY	Developer descriptive flexfield column.
PREFERENCE_INFORMATION1	Developer descriptive flexfield column.
PREFERENCE_INFORMATION2	Developer descriptive flexfield column.
PREFERENCE_INFORMATION3	Developer descriptive flexfield column.
PREFERENCE_INFORMATION4	Developer descriptive flexfield column.
PREFERENCE_INFORMATION5	Developer descriptive flexfield column.
PREFERENCE_INFORMATION6	Developer descriptive flexfield column.
PREFERENCE_INFORMATION7	Developer descriptive flexfield column.
PREFERENCE_INFORMATION8	Developer descriptive flexfield column.
PREFERENCE_INFORMATION9	Developer descriptive flexfield column.
TEMPLATE_TYPE	Element template type.
PREFERENCE_INFORMATION10	Developer descriptive flexfield column.
PREFERENCE_INFORMATION11	Developer descriptive flexfield column.
PREFERENCE_INFORMATION12	Developer descriptive flexfield column.
PREFERENCE_INFORMATION13	Developer descriptive flexfield column.
PREFERENCE_INFORMATION14	Developer descriptive flexfield column.
PREFERENCE_INFORMATION15	Developer descriptive flexfield column.
PREFERENCE_INFORMATION16	Developer descriptive flexfield column.
PREFERENCE_INFORMATION17	Developer descriptive flexfield column.
PREFERENCE_INFORMATION18	Developer descriptive flexfield column.
PREFERENCE_INFORMATION19	Developer descriptive flexfield column.
TEMPLATE_NAME	User name for this template.
PREFERENCE_INFORMATION20	Developer descriptive flexfield column.
PREFERENCE_INFORMATION21	Developer descriptive flexfield column.
PREFERENCE_INFORMATION22	Developer descriptive flexfield column.
PREFERENCE_INFORMATION23	Developer descriptive flexfield column.
PREFERENCE_INFORMATION24	Developer descriptive flexfield column.
PREFERENCE_INFORMATION25	Developer descriptive flexfield column.
PREFERENCE_INFORMATION26	Developer descriptive flexfield column.
PREFERENCE_INFORMATION27	Developer descriptive flexfield column.
PREFERENCE_INFORMATION28	Developer descriptive flexfield column.
PREFERENCE_INFORMATION29	Developer descriptive flexfield column.
BASE_PROCESSING_PRIORITY	Base value to add to differential values for element processing
PREFERENCE_INFORMATION30	Developer descriptive flexfield column.
CONFIGURATION_INFO_CATEGORY	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION1	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION2	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION3	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION4	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION5	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION6	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION7	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION8	Developer descriptive flexfield column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
CONFIGURATION_INFORMATION9	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION10	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION11	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION12	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION13	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION14	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION15	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION16	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION17	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION18	Developer descriptive flexfield column.
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
CONFIGURATION_INFORMATION19	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION20	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION21	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION22	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION23	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION24	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION25	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION26	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION27	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION28	Developer descriptive flexfield column.
VERSION_NUMBER	Version number for the template as a whole (for support purposes).
CONFIGURATION_INFORMATION29	Developer descriptive flexfield column.
CONFIGURATION_INFORMATION30	Developer descriptive flexfield column.
OBJECT_VERSION_NUMBER	Object version number column.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
BASE_NAME	User-supplied name for placeholder substitution.
MAX_BASE_NAME_LENGTH	Maximum length of BASE_NAME to avoid name clashes in generated objects e.g. database items.

Payroll - HR_S_MAGNETIC_BLOCKS
Column Name	Descritpion
MAGNETIC_BLOCK_ID
BLOCK_NAME
MAIN_BLOCK_FLAG
REPORT_FORMAT
CURSOR_NAME
NO_COLUMN_RETURNED

Payroll - HR_S_MAGNETIC_RECORDS
Column Name	Descritpion
FORMULA_ID
MAGNETIC_BLOCK_ID
NEXT_BLOCK_ID
OVERFLOW_MODE
SEQUENCE
FREQUENCY
LAST_RUN_EXECUTED_MODE

Payroll - HR_S_REPORT_FORMAT_MAPPINGS_F
Column Name	Descritpion
REPORT_TYPE
MAGNETIC_CODE
REPORT_CATEGORY
REPORT_NAME
SORT_CODE
REPORT_QUALIFIER
REPORT_FORMAT
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
RANGE_CODE
ASSIGNMENT_ACTION_CODE
INITIALIZATION_CODE
ARCHIVE_CODE

Payroll - HR_S_US_GARN_EXEMPTION_RULES_F
Column Name	Descritpion
EXEMPTION_RULE_ID
DEPENDENTS_CALC_RULE
DEPENDENT_AMOUNT_VALUE
DI_PCT
DI_PCT_DEPENDENTS
DI_PCT_DEPENDENTS_IN_ARREARS
DI_PCT_IN_ARREARS
EXEMPTION_BALANCE
EXEMPTION_BALANCE_MAX_PCT
EXEMPTION_BALANCE_MIN_PCT
MARITAL_STATUS
EFFECTIVE_START_DATE
MIN_WAGE_FACTOR
PRORATION_RULE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
EFFECTIVE_END_DATE
GARN_CATEGORY
STATE_CODE
ADDL_DEP_AMOUNT_VALUE
AMOUNT_VALUE
CALC_RULE
CREATOR_TYPE

Payroll - HR_S_US_GARN_FEE_RULES_F
Column Name	Descritpion
FEE_RULE_ID
FEE_RULE
MAX_FEE_AMOUNT
PCT_CURRENT
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
TAKE_FEE_ON_PRORATION
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
GARN_CATEGORY
STATE_CODE
ADDL_GARN_FEE_AMOUNT
CORRESPONDENCE_FEE
CREATOR_TYPE
FEE_AMOUNT

Payroll - HR_S_US_GARN_LIMIT_RULES_F
Column Name	Descritpion
LIMIT_RULE_ID
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
GARN_CATEGORY
STATE_CODE
MAX_WITHHOLDING_AMOUNT
MAX_WITHHOLDING_DURATION_DAYS
MIN_WITHHOLDING_AMOUNT
LAST_UPDATE_DATE

Payroll - HR_S_TAXABILITY_RULES_DATES
Column Name	Descritpion
TAXABILITY_RULES_DATE_ID
TAX_RULES_INFORMATION5
TAX_RULES_INFORMATION6
TAX_RULES_INFORMATION7
TAX_RULES_INFORMATION8
TAX_RULES_INFORMATION9
TAX_RULES_INFORMATION10
TAX_RULES_INFORMATION11
TAX_RULES_INFORMATION12
TAX_RULES_INFORMATION13
TAX_RULES_INFORMATION14
VALID_DATE_FROM
TAX_RULES_INFORMATION15
TAX_RULES_INFORMATION16
TAX_RULES_INFORMATION17
TAX_RULES_INFORMATION18
TAX_RULES_INFORMATION19
TAX_RULES_INFORMATION20
TAX_RULES_INFORMATION21
TAX_RULES_INFORMATION22
TAX_RULES_INFORMATION23
TAX_RULES_INFORMATION24
VALID_DATE_TO
TAX_RULES_INFORMATION25
TAX_RULES_INFORMATION26
TAX_RULES_INFORMATION27
TAX_RULES_INFORMATION28
TAX_RULES_INFORMATION29
TAX_RULES_INFORMATION30
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
LEGISLATION_CODE
CREATION_DATE
OBJECT_VERSION_NUMBER
TAX_RULES_INFORMATION_CATEGORY
TAX_RULES_INFORMATION1
TAX_RULES_INFORMATION2
TAX_RULES_INFORMATION3
TAX_RULES_INFORMATION4

Payroll - PAY_ACTION_CONTEXTS	Assignment Action Contexts.
Column Name	Descritpion
ASSIGNMENT_ACTION_ID	Foreign Key to PAY_ASSIGNMENT_ACTIONS
ASSIGNMENT_ID	Foreign key to PER_ASSIGNMENTS_F
CONTEXT_ID	Foreign key to FF_CONTEXTS
CONTEXT_VALUE	Value of the context used in the process

Payroll - PAY_BALANCE_TYPES_TL	Translated balance type definitions
Column Name	Descritpion
BALANCE_NAME	Translated user name of balance.
REPORTING_NAME	Tanslated user name for reporting purposes.
LANGUAGE	Language of translation.
SOURCE_LANG	Source language of the row.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
BALANCE_TYPE_ID	System-generated primary key column from PAY_BALANCE_TYPES.
CREATION_DATE	Standard who column - date when this row was created.

Payroll - PAY_CE_RECONCILED_PAYMENTS	Holds reconciliation information for payments processed through Oracle Cash Management.
Column Name	Descritpion
ASSIGNMENT_ACTION_ID	Foreign Key to PAY_ASSIGNMENT_ACTIONS
TRX_TYPE	'Payment' or 'Stopped'. Transaction type information from bank statement.
STATUS_CODE	To indicate if cleared or voided.
CLEARED_AMOUNT	Amount cleared in bank statement.
CLEARED_DATE	Date payment cleared in bank statement.
CLEARED_BASE_AMOUNT	Cleared amount in base currency.
RECONCILED_PAYMENT_ID	System-generated primary key column.

Payroll - PAY_ELEMENT_CLASSIFICATIONS_TL	Translated element classification definitions
Column Name	Descritpion
CLASSIFICATION_NAME	Translated name by which a user identifies the classification.
DESCRIPTION	Translated description of the element classification.
LANGUAGE	Language of translation.
SOURCE_LANG	Source language of the row.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CLASSIFICATION_ID	System-generated primary key column from PAY_ELEMENT_CLASSIFICATIONS.
CREATION_DATE	Standard who column - date when this row was created.

Payroll - PAY_ELEMENT_TYPES_F_TL	Translated element definitions
Column Name	Descritpion
ELEMENT_NAME	Translated user name for the element type.
REPORTING_NAME	Translated short name for the element.
DESCRIPTION	Translated brief description of the element type.
LANGUAGE	Language of translation.
SOURCE_LANG	Source language of the row.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ELEMENT_TYPE_ID	System-generated primary key from PAY_ELEMENT_TYPES_F.
CREATION_DATE	Standard who column - date when this row was created.

Payroll - PAY_INPUT_VALUES_F_TL	Translated input value definitions
Column Name	Descritpion
NAME	Translated user name for the input value.
LANGUAGE	Language of translation.
SOURCE_LANG	Source language of the row.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
INPUT_VALUE_ID	System-generated primary key from PAY_INPUT_VALUES_F.

Payroll - PAY_ITERATIVE_RULES_F	Holds the processing rules of iterative elements.
Column Name	Descritpion
ELEMENT_TYPE_ID	Foreign key to PAY_ELEMENT_TYPES_F
EFFECTIVE_START_DATE	Effective start date.
EFFECTIVE_END_DATE	Effective end date.
RESULT_NAME	The name of a variable returned from the iterative Fast Formula
ITERATIVE_RULE_TYPE	Denotes how the results from the formula are processed
INPUT_VALUE_ID	Foreign key to PAY_INPUT_VALUES_F.
SEVERITY_LEVEL	Indicates the kind of message returned if the processed value is not valid.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ITERATIVE_RULE_ID	System-generated primary key.
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.

Payroll - PAY_CA_FILE_CREATION_NUMBERS	Used by Canadian direct deposit
Column Name	Descritpion
ORIGINATOR_ID	Bank supplied customer identifier
SEQUENCE_NUMBER	Sequence number
FILE_CREATION_NUMBER	File creation number identifies a particular direct deposit file

Payroll - PAY_CA_PMED_ACCOUNTS	Canadian Provincial Medical account information
Column Name	Descritpion
SOURCE_ID	Internal unique code for Provincial Medical account number. This is generated from PAY_WCI_RATES_S.
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ATTRIBUTE16	Descriptive Flexfield column.
ATTRIBUTE17	Descriptive Flexfield column.
ATTRIBUTE18	Descriptive Flexfield column.
ATTRIBUTE19	Descriptive Flexfield column.
ATTRIBUTE20	Descriptive Flexfield column.
ATTRIBUTE21	Descriptive Flexfield column.
ATTRIBUTE22	Descriptive Flexfield column.
ACCOUNT_NUMBER	Provincial Medical account number.
ATTRIBUTE23	Descriptive Flexfield column.
ATTRIBUTE24	Descriptive Flexfield column.
ATTRIBUTE25	Descriptive Flexfield column.
ATTRIBUTE26	Descriptive Flexfield column.
ATTRIBUTE27	Descriptive Flexfield column.
ATTRIBUTE28	Descriptive Flexfield column.
ATTRIBUTE29	Descriptive Flexfield column.
ATTRIBUTE30	Descriptive Flexfield column.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
ENABLED	Enabled flag.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER	Object Version Number
DESCRIPTION	Description of account number
BUSINESS_GROUP_ID	Business Group Identifier. Foreign Key to HR_ALL_ORGANIZATION_UNITS
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ORGANIZATION_ID	Organization Id. Foreign Key to HR_ALL_ORGANIZATION_UNITS
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment

Payroll - PAY_AU_MODULES	Defines the processes that can be executed by the generic code caller.
Column Name	Descritpion
MODULE_ID	System Generated primary key from PAY_AU_MODULES_S
FORMULA_NAME	Name of formula referenced by module.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER	System generated version of row. Increments by one with each update.
NAME	Module name
ENABLED_FLAG	Enabled flag
MODULE_TYPE_ID	Foreign key to PAY_AU_MODULE_TYPES
BUSINESS_GROUP_ID	Foriegn key to HR_ORGANIZATION_UNITS
LEGISLATION_CODE	Foreign key to FND_TERRITORIES
DESCRIPTION	Module description
PACKAGE_NAME	Name of the package involved in this module.
PROCEDURE_FUNCTION_NAME	Procedure or Funtion name within the package.

Payroll - PAY_AU_PROCESSES	This table defines the processes that can be executed by the generic code caller.
Column Name	Descritpion
PROCESS_ID	The system generated primary key from the sequence PAY_AU_PROCESSES_S
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER	System generated version of row. Increments on each row update.
ACCRUAL_CATEGORY	Accrual Category for the process
SHORT_NAME	Short name of the process
NAME	Name of the process
ENABLED_FLAG	This flag indicates if the process is enabled.
BUSINESS_GROUP_ID	Part of the unique key
LEGISLATION_CODE	Part of the unique key
DESCRIPTION	Process description
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.

Payroll - PAY_AU_PROCESS_MODULES	Defines the intersection between processes and modules used by the generic code caller.
Column Name	Descritpion
PROCESS_MODULE_ID	System generated primary key from PAY_AU_PROCESS_MODULES_S
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER	Systme generated version of the row, increments by one with each update.
PROCESS_ID	Foreign key to PAY_AU_PROCESSES
MODULE_ID	Foreign key to PAY_AU_MODULES
PROCESS_SEQUENCE	Process sequence.
ENABLED_FLAG	Flag to indicate whether this process module is enabled.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.

Payroll - PAY_AU_MODULE_TYPES	Defines the module types used in the generic code caller
Column Name	Descritpion
MODULE_TYPE_ID	System generated primary key.
OBJECT_VERSION_NUMBER	System generated version of the row. Increments by one with each update.
NAME	Moudle type name.
ENABLED_FLAG	Flag indicates if module is enabled.
DESCRIPTION	Module type description.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Payroll - PAY_AU_MODULE_PARAMETERS	Defines the parameters associated with the module used in the generic code
Column Name	Descritpion
MODULE_PARAMETER_ID	System generated primary key
FUNCTION_RETURN_FLAG	Flag indicates that the parameter is a function return.
ENABLED_FLAG	Flag indicates that the parameter is enabled.
EXTERNAL_NAME	Name of the parameter in the module. Parameters are passed by name and this is when the external name is used.
DATABASE_ITEM_NAME	This is the name of the X_ (extract) database item that the result should be saved against.
CONSTANT_VALUE	Constant value for the parameter.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
MODULE_ID	Foreign key to pay_au_modules
OBJECT_VERSION_NUMBER	System generated version number of the row. Increments by one with each update.
INTERNAL_NAME	Used to key the parameter in the generic code caller internal parameter data store.
DATA_TYPE	Paramter data type
INPUT_FLAG	Flag to indicate if the parameter is an input.
CONTEXT_FLAG	Flag indicates that the parameter is a context. (Flag is ignored for procedures ot functions).
OUTPUT_FLAG	Flag indicates if the paramters is an output.
RESULT_FLAG	Flag indicates that the paramters is to be stored as a result.
ERROR_MESSAGE_FLAG	Flag indicates that the parameter is an error message.

Payroll - PAY_AU_PROCESS_PARAMETERS	Defines the parameters for a process.
Column Name	Descritpion
PROCESS_PARAMETER_ID	System generated primary key.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER	System generated version of row, increments with each update.
PROCESS_ID	Foreign key to PAY_AU_PROCESSES.
INTERNAL_NAME	Internal name of the process parameter.
DATA_TYPE	Data Type
ENABLED_FLAG	Enabled flag
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.

Payroll - PAY_GROSSUP_BAL_EXCLUSIONS	Stores balances which will be excluded for gross up by the net to gross process
Column Name	Descritpion
START_DATE	Date the exclusion begins
END_DATE	Date the exclusion ends
SOURCE_ID	Foreign key to table denoted by source_type, e.g element_entry_id
SOURCE_TYPE	Indicates the source of the id e.g. E - Element Entry.
BALANCE_TYPE_ID	Foreign key to PAY_BALANCE_TYPES.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
GROSSUP_BALANCES_ID	System-generated primary key column.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.

Payroll - PAY_FUNCTIONAL_AREAS	Holds definitions of functional areas
Column Name	Descritpion
SHORT_NAME	Short user identifying name
DESCRIPTION	More descriptive version of short name
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
AREA_ID	System-generated primary key column.

Payroll - PAY_FUNCTIONAL_USAGES	Enables functional areas for specific legislations, business groups and payrolls
Column Name	Descritpion
AREA_ID	Foreign key to PAY_FUNCTIONAL_AREAS.
LEGISLATION_CODE	Legislation code. Set if seeded data.
BUSINESS_GROUP_ID	Business Group which created the data.
PAYROLL_ID	Foreign key to PAY_ALL_PAYROLLS_F.
LAST_UPDATE_DATE	Standard Who Column - date when a user last updated this row.
LAST_UPDATED_BY	Standard Who Column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard Who Column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard Who Column - user who created this row (foreign key to FND_USER.USER_ID).
USAGE_ID	System-generated primary key column.
CREATION_DATE	Standard Who Column - date when this row was created.

Payroll - PAY_FUNCTIONAL_TRIGGERS	Defines the triggers contained in a functional area
Column Name	Descritpion
AREA_ID	Foreign key to PAY_FUNCTIONAL_AREAS.
EVENT_ID	Foreign key to PAY_TRIGGER_EVENTS.
LAST_UPDATE_DATE	Standard Who Column - date when a user last updated this row.
LAST_UPDATED_BY	Standard Who Column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard Who Column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard Who Column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard Who Column - date when this row was created.
TRIGGER_ID	System-generated primary key column.

Payroll - PAY_ELEMENT_TYPE_INFO_TYPES	Types of extra information that may be held against an element.
Column Name	Descritpion
INFORMATION_TYPE	The name or code of the information type, which is also the primary key.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
ACTIVE_INACTIVE_FLAG	Indicates whether the information type is active or inactive.
MULTIPLE_OCCURENCES_FLAG	Indicates whether an element may have multiple occurrences of this type.
DESCRIPTION	Description of the information type.
LEGISLATION_CODE	The legislation to which the information type applies.
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).

Payroll - PAY_ELEMENT_TYPE_EXTRA_INFO	Stores extra information for an element
Column Name	Descritpion
ELEMENT_TYPE_EXTRA_INFO_ID	System generated primary key column.
EEI_ATTRIBUTE2	Descriptive flexfield column.
EEI_ATTRIBUTE3	Descriptive flexfield column.
EEI_ATTRIBUTE4	Descriptive flexfield column.
EEI_ATTRIBUTE5	Descriptive flexfield column.
EEI_ATTRIBUTE6	Descriptive flexfield column.
EEI_ATTRIBUTE7	Descriptive flexfield column.
EEI_ATTRIBUTE8	Descriptive flexfield column.
EEI_ATTRIBUTE9	Descriptive flexfield column.
EEI_ATTRIBUTE10	Descriptive flexfield column.
EEI_ATTRIBUTE11	Descriptive flexfield column.
ELEMENT_TYPE_ID	Foreign key to PAY_ELEMENT_TYPES_F.
EEI_ATTRIBUTE12	Descriptive flexfield column.
EEI_ATTRIBUTE13	Descriptive flexfield column.
EEI_ATTRIBUTE14	Descriptive flexfield column.
EEI_ATTRIBUTE15	Descriptive flexfield column.
EEI_ATTRIBUTE16	Descriptive flexfield column.
EEI_ATTRIBUTE17	Descriptive flexfield column.
EEI_ATTRIBUTE18	Descriptive flexfield column.
EEI_ATTRIBUTE19	Descriptive flexfield column.
EEI_ATTRIBUTE20	Descriptive flexfield column.
EEI_INFORMATION_CATEGORY	Developer descriptive flexfield column.
INFORMATION_TYPE	Foreign key to PAY_ELEMENT_TYPE_INFO_TYPES to identify the type of information
EEI_INFORMATION1	Developer descriptive flexfield column.
EEI_INFORMATION2	Developer descriptive flexfield column.
EEI_INFORMATION3	Developer descriptive flexfield column.
EEI_INFORMATION4	Developer descriptive flexfield column.
EEI_INFORMATION5	Developer descriptive flexfield column.
EEI_INFORMATION6	Developer descriptive flexfield column.
EEI_INFORMATION7	Developer descriptive flexfield column.
EEI_INFORMATION8	Developer descriptive flexfield column.
EEI_INFORMATION9	Developer descriptive flexfield column.
EEI_INFORMATION10	Developer descriptive flexfield column.
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
EEI_INFORMATION11	Developer descriptive flexfield column.
EEI_INFORMATION12	Developer descriptive flexfield column.
EEI_INFORMATION13	Developer descriptive flexfield column.
EEI_INFORMATION14	Developer descriptive flexfield column.
EEI_INFORMATION15	Developer descriptive flexfield column.
EEI_INFORMATION16	Developer descriptive flexfield column.
EEI_INFORMATION17	Developer descriptive flexfield column.
EEI_INFORMATION18	Developer descriptive flexfield column.
EEI_INFORMATION19	Developer descriptive flexfield column.
EEI_INFORMATION20	Developer descriptive flexfield column.
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
EEI_INFORMATION21	Developer descriptive flexfield column.
EEI_INFORMATION22	Developer descriptive flexfield column.
EEI_INFORMATION23	Developer descriptive flexfield column.
EEI_INFORMATION24	Developer descriptive flexfield column.
EEI_INFORMATION25	Developer descriptive flexfield column.
EEI_INFORMATION26	Developer descriptive flexfield column.
EEI_INFORMATION27	Developer descriptive flexfield column.
EEI_INFORMATION28	Developer descriptive flexfield column.
EEI_INFORMATION29	Developer descriptive flexfield column.
EEI_INFORMATION30	Developer descriptive flexfield column.
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
EEI_ATTRIBUTE_CATEGORY	Descriptive flexfield column.
EEI_ATTRIBUTE1	Descriptive flexfield column.

Payroll - PAY_ELEMENT_TYPE_USAGES_F	Used to store elements included or excluded from a defined run type.
Column Name	Descritpion
ELEMENT_TYPE_ID	Foreign key to PAY_ELEMENT_TYPES_F.
INCLUSION_FLAG	Reserved for future functionality.
USAGE_TYPE	This column is used to determine the type of usage for this row.
EFFECTIVE_START_DATE	Effective start date.
EFFECTIVE_END_DATE	Effective end date.
BUSINESS_GROUP_ID	Business group.
LEGISLATION_CODE	Legislation code.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
ELEMENT_TYPE_USAGE_ID	Primary key
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
RUN_TYPE_ID	Foreign key to PAY_RUN_TYPES_F.

Payroll - PAY_JP_BANK_BRANCHES	This table is used for Japanese bank branch information.
Column Name	Descritpion
BRANCH_CODE	Unique code of the bank branch.
BRANCH_NAME	The name of the bank branch.
BRANCH_NAME_KANA	The name of the bank branch in katakana.
ENABLED_FLAG	Indicates if the bank branch is enabled.
START_DATE_ACTIVE	The date when the bank branch becomes activate.
END_DATE_ACTIVE	The date when the bank branch becomes inactive.
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
BANK_CODE	Foreign key to PAY_JP_BANKS.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Payroll - PAY_JP_BANKS	This table is used for Japanese bank information.
Column Name	Descritpion
BANK_NAME	The name of the bank.
BANK_NAME_KANA	The name of the bank in katakana.
ENABLED_FLAG	Indicates if the bank is enabled.
START_DATE_ACTIVE	The date when the bank becomes active.
END_DATE_ACTIVE	The date when the bank becomes inactive.
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
BANK_CODE	Unique code for the bank.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Payroll - PAY_ACTION_INFORMATION	Archived data stored by legislation
Column Name	Descritpion
ACTION_INFORMATION_ID	System-generated primary key column.
ACTION_INFORMATION3	Developer descriptive flexfield column.
ACTION_INFORMATION4	Developer descriptive flexfield column.
ACTION_INFORMATION5	Developer descriptive flexfield column.
ACTION_INFORMATION6	Developer descriptive flexfield column.
ACTION_INFORMATION7	Developer descriptive flexfield column.
ACTION_INFORMATION8	Developer descriptive flexfield column.
ACTION_INFORMATION9	Developer descriptive flexfield column.
ACTION_CONTEXT_ID	Foreign key to PAY_ACTION_CONTEXTS.
ACTION_INFORMATION10	Developer descriptive flexfield column.
ACTION_INFORMATION11	Developer descriptive flexfield column.
ACTION_INFORMATION12	Developer descriptive flexfield column.
ACTION_INFORMATION13	Developer descriptive flexfield column.
ACTION_INFORMATION14	Developer descriptive flexfield column.
ACTION_CONTEXT_TYPE	Type of context archived in table.
ACTION_INFORMATION15	Developer descriptive flexfield column.
ACTION_INFORMATION16	Developer descriptive flexfield column.
ACTION_INFORMATION17	Developer descriptive flexfield column.
ACTION_INFORMATION18	Developer descriptive flexfield column.
ACTION_INFORMATION19	Developer descriptive flexfield column.
ACTION_INFORMATION20	Developer descriptive flexfield column.
ACTION_INFORMATION21	Developer descriptive flexfield column.
ACTION_INFORMATION22	Developer descriptive flexfield column.
ACTION_INFORMATION23	Developer descriptive flexfield column.
ACTION_INFORMATION24	Developer descriptive flexfield column.
ACTION_INFORMATION25	Developer descriptive flexfield column.
TAX_UNIT_ID	Identifies the Government Reporting Entity, or Legal Entity for the assignment.
ACTION_INFORMATION26	Developer descriptive flexfield column.
EFFECTIVE_DATE	Effective date of the record.
ACTION_INFORMATION27	Developer descriptive flexfield column.
ASSIGNMENT_ID	Assignment ID for which this action is archived
ACTION_INFORMATION28	Developer descriptive flexfield column.
ACTION_INFORMATION29	Developer descriptive flexfield column.
ACTION_INFORMATION30	Developer descriptive flexfield column.
JURISDICTION_CODE	Archived context information
SOURCE_ID	Archived context information
SOURCE_TEXT	Archived context information
TAX_GROUP	Archived context information
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
ACTION_INFORMATION_CATEGORY	Developer descriptive flexfield column.
ACTION_INFORMATION1	Developer descriptive flexfield column.
ACTION_INFORMATION2	Developer descriptive flexfield column.

Payroll - PAY_FR_CONTRIBUTION_USAGES	PAY_FR_CONTRIBUTION_USAGES holds the definition of statutory payroll contributions in the French legislation.
Column Name	Descritpion
CONTRIBUTION_USAGE_ID	System generated primary key column
CONTRIBUTION_TYPE	The type of body receiving the contribution, eg 'AGIRC', 'ARRCO', 'URSSAF','ASSEDIC'.
CONTRIBUTION_USAGE_TYPE	The type of contribution usage, eg Standard, Part-Time.
RATE_CATEGORY	The categorization of the rate type used by this contribution usage, eg 'S' - Standard, 'W' - Work Accident., 'T' - Transport Tax, 'R' - Rebate, 'C' - Cadre
BUSINESS_GROUP_ID	Business Group owning this specific contribution usage.
OBJECT_VERSION_NUMBER	System generated version of row. Increments by one with each update.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
DATE_FROM	Date from which this row applies
CODE_RATE_ID	A unique identifier of a Rate Type within a Contribution Code.
DATE_TO	Date after which this row no longer appies
GROUP_CODE	The element group for the contribution usage.
PROCESS_TYPE	The assignments process type, eg Normal, VRP.
ELEMENT_NAME	The pay element that uses this contribution type.
RATE_TYPE	The type of rate that is used by this contribution type.
CONTRIBUTION_CODE	The standard contribution code for statutory reporting.
RETRO_CONTRIBUTION_CODE	The contribution code used on statutory reports when retropayments have been made with this contributon usage.

Payroll - PAY_BALANCE_TYPES_EFC	This is a copy of the PAY_BALANCE_TYPES table which is populated by the EFC (Euro as a Functional Currency) process.
Column Name	Descritpion
BALANCE_TYPE_ID	Unique identifier from the base table.
EFC_ACTION_ID	Foreign key to HR_EFC_ACTIONS
CURRENCY_CODE	Currency from the base table prior to conversion.

Payroll - PAY_COSTS_EFC	This is a copy of the PAY_COSTS table which is populated by the EFC (Euro as a Functional Currency) process.
Column Name	Descritpion
COST_ID	Unique identifier from base table.
EFC_ACTION_ID	Foreign key to HR_EFC_ACTIONS
COSTED_VALUE	Original value to be costed.
OUTPUT_CURRENCY_CODE	Original currency code used.

Payroll - PAY_GRADE_RULES_F_EFC	This is a copy of the PAY_GRADE_RULES_F table which is populated by the EFC (Euro as a Functional Currency) process.
Column Name	Descritpion
GRADE_RULE_ID	Unique identifier from the base table.
EFC_BG_CURRENCY	Business Group currency.
EFFECTIVE_START_DATE	Start date from the base table.
EFFECTIVE_END_DATE	End date from the base table.
EFC_ACTION_ID	Foreign key to HR_EFC_ACTIONS
VALUE	Value before conversion.
MAXIMUM	Value before conversion.
MINIMUM	Value before conversion.
MID_VALUE	Value before conversion.
CURRENCY_CODE	Currency before conversion.

Payroll - PAY_INPUT_VALUES_F_EFC	This is a copy of the PAY_INPUT_VALUES_F table which is populated by the EFC (Euro as a Functional Currency) process.
Column Name	Descritpion
INPUT_VALUE_ID	Unique identifier from the base table.
EFFECTIVE_START_DATE	Start date from the base table.
EFFECTIVE_END_DATE	End date from the base table.
EFC_ACTION_ID	Foreign key to HR_EFC_ACTIONS
DEFAULT_VALUE	Value before conversion.
MAX_VALUE	Value before conversion.
MIN_VALUE	Value before conversion.
INPUT_CURRENCY_CODE	Currency code before conversion.

Payroll - PAY_ELEMENT_TYPES_F_EFC	This is a copy of the PAY_ELEMENT_TYPES_F table which is populated by the EFC (Euro as a Functional Currency) process.
Column Name	Descritpion
ELEMENT_TYPE_ID	Unique identifier from the base table.
EFFECTIVE_START_DATE	Effective start date from base table.
EFFECTIVE_END_DATE	Effective end date from base table.
EFC_ACTION_ID	Foreign key to HR_EFC_ACTIONS
INPUT_CURRENCY_CODE	Input currency before conversion.
OUTPUT_CURRENCY_CODE	Output currency before conversion.

Payroll - PAY_ELEMENT_ENTRY_VALUES_F_EFC	This is a copy of the PAY_ELEMENT_ENTRY_VALUES_F table which is populated by the EFC (Euro as a Functional Currency) process.
Column Name	Descritpion
ELEMENT_ENTRY_VALUE_ID	Unique identifier from the base table.
EFFECTIVE_END_DATE	Effective end date from base table.
EFC_ACTION_ID	Foreign key to HR_EFC_ACTIONS
SCREEN_ENTRY_VALUE	Value before conversion.
INPUT_CURRENCY_CODE	Currency code before conversion
EFFECTIVE_START_DATE	Effective start date from base table.
EFC_BG_CURRENCY	Business Group currency code
NIP_PL_UOM	Foreign key to OAB model
PGM_UOM	Foreign key to OAB model

Payroll - PAY_EVENT_UPDATES	Process event update transactions
Column Name	Descritpion
TABLE_NAME	Name of table to monitor
COLUMN_NAME	Name of column to monitor
DATED_TABLE_ID	Foreign key to PAY_DATED_TABLES.
BUSINESS_GROUP_ID	Business group. Populated for customer created data.
LEGISLATION_CODE	Legislation code. Populated for seeded data.
CHANGE_TYPE	Events detected should be marked as this type of change.
EVENT_TYPE	Event to monitor e.g. Insert, Update, Delete
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
EVENT_UPDATE_ID	System-generated primary key column.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.

Payroll - PAY_EVENT_GROUPS	Provides grouping for user control of event monitoring
Column Name	Descritpion
EVENT_GROUP_NAME	User displayed name for the group
EVENT_GROUP_TYPE	Type of group
PRORATION_TYPE	If used for Proration, identifies the type
TIME_DEFINITION_ID
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE	Foreign Key to FND_TERRITORIES
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
EVENT_GROUP_ID	System-generated primary key column
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.

Payroll - PAY_DATETRACKED_EVENTS	Stores details of events to track on HRMS Datetrack tables
Column Name	Descritpion
EVENT_GROUP_ID	Foreign key to PAY_EVENT_GROUPS.
DATED_TABLE_ID	Foreign key to PAY_DATED_TABLES.
COLUMN_NAME	Foreign key to PAY_DATED_TABLES. Mandatory if update_type is UPDATE.
UPDATE_TYPE	The type of change to detect
PRORATION_STYLE	Type of Proration to apply
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
DATETRACKED_EVENT_ID	System-generated primary key column.
CREATION_DATE	Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.

Payroll - PAY_DATED_TABLES	Holds details of datetracked columns
Column Name	Descritpion
TABLE_NAME	HRMS table name.
APPLICATION_ID	Owning application.
SURROGATE_KEY_NAME	Identifies column holding surrogate key
START_DATE_NAME	Column containing effective start date.
END_DATE_NAME	Column holding effective end date.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE	Foreign Key to FND_TERRITORIES
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
DATED_TABLE_ID	Unique identifier.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
DYN_TRIGGER_TYPE	Type of dynamic triggers to be created for this dated table. Eg As database triggers or in a package or both.
DYN_TRIGGER_PACKAGE_NAME	Package name to store dynamic trigger generated code.
DYN_TRIG_PKG_GENERATED	Flag to indicate if dynamic trigger code has been generated in to a package.
OWNER	Table Owner

Payroll - PAY_EVENT_PROCEDURES	Code to execute if event detected.
Column Name	Descritpion
DATED_TABLE_ID	Foreign key to PAY_DATED_TABLES.
PROCEDURE_NAME	Pl/sql procedure name to call for event handling.
PROCEDURE_TYPE
TIME_DEFINITION_ID
BUSINESS_GROUP_ID	Business group to monitor the event on.
LEGISLATION_CODE	Monitor all changes for this legislation
COLUMN_NAME	Column on datetracked table to monitor
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
EVENT_PROCEDURE_ID	System-generated primary key column.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.

Payroll - PAY_CUSTOM_RESTRICTIONS_TL	Translated data for the table PAY_CUSTOMIZED_RESTRICTIONS
Column Name	Descritpion
QUERY_FORM_TITLE	Translated title for form called in query mode.
STANDARD_FORM_TITLE	Translated title for customized form.
LANGUAGE	Language of translation.
SOURCE_LANG	Source language of the row.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CUSTOMIZED_RESTRICTION_ID	Unique identifier from base table.
CREATION_DATE	Standard who column - date when this row was created.

Payroll - PAY_IE_PRSI_DETAILS_F	PAY_IE_PRSI_DETAILS_F holds the PRSI Details for an assignment. It is a Date Tracked table.
Column Name	Descritpion
PRSI_DETAILS_ID	System-generated primary key column.
OVERRIDDEN_INS_WEEKS	Overridden Insurable Weeks indicates number of weeks in the current pay period to override standard default number of weeks
NON_STANDARD_INS_WEEKS	Non Standard Insurable Weeks
EXEMPTION_START_DATE	Start Date of Exemption Certificate
EXEMPTION_END_DATE	End Date of Exemption Certificate
CERT_ISSUED_BY	Exemption Certificate Issued By
DIRECTOR_FLAG	Director Flag (Yes/No ).
COMMUNITY_FLAG	Indicates if it is a community employment. Yes or No Flag
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
EFFECTIVE_START_DATE	Date Track Effective Start Date
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
EFFECTIVE_END_DATE	Date Track Effective End Date
OBJECT_VERSION_NUMBER	Object Version Number
ASSIGNMENT_ID	Foreign key to PER_ALL_ASSIGNMENTS_F Table
CONTRIBUTION_CLASS	PRSI Contribution Class
OVERRIDDEN_SUBCLASS	PRSI contribution subclass which overrides the subclass derived from earning level
SOC_BEN_FLAG	Indicates whether person receives social benefits. Yes/No Flag.
SOC_BEN_START_DATE	Social Benefit Start Date

Payroll - PAY_IE_PAYE_DETAILS_F	PAY_IE_PAYE_DETAILS_F holds the PAYE Tax Details for an assignment. It is a Date Tracked table.
Column Name	Descritpion
PAYE_DETAILS_ID	System-generated primary key column.
CERTIFICATE_END_DATE	End Date of the Certificate of tax credit
TAX_ASSESS_BASIS	Basis of PAYE Tax Assessment
WEEKLY_TAX_CREDIT	Tax Credit Amount For A Week
WEEKLY_STD_RATE_CUT_OFF	Standard Rate Cut Off Amount For A Week
MONTHLY_TAX_CREDIT	Tax Credit Amount For A Month
MONTHLY_STD_RATE_CUT_OFF	Standard Rate Cut Off Amount For A Month
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
EFFECTIVE_START_DATE	Date Track Effective Start Date
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
CERTIFICATE_ISSUE_DATE	Issue Date of Certificate of tax credit
EFFECTIVE_END_DATE	Date Track Effective End Date
OBJECT_VERSION_NUMBER	Object Version Number
ASSIGNMENT_ID	Foreign key to PER_ALL_ASSIGNMENTS_F Table
INFO_SOURCE	PAYE Information Source, e.g., P45, Electronic, Certificate of Tax Credit
COMM_PERIOD_NO	Pay period number when for example emergency tax basis commences.
TAX_BASIS	PAYE Tax Basis for example Cumulative, Emergency etc.
CERTIFICATE_START_DATE	Start Date of Certificate of tax credit

Payroll - PAY_BALANCE_SET_MEMBERS	Individual members of the balance set
Column Name	Descritpion
BALANCE_SET_ID	Foreign key to PAY_BALANCE_SETS.
BALANCE_DIMENSION_ID	Foreign key to PAY_BALANCE_DIMENSIONS.
DEFINED_BALANCE_ID	Foreign key to PAY_DEFINED_BALANCES.
BALANCE_SET_MEMBER_ID	Unique Identifier.

Payroll - PAY_IE_TAX_BODY_INTERFACE	PAY_IE_TAX_BODY_INTERFACE,Interface table used for uploading data into PAYE tables from a flat file.
Column Name	Descritpion
RECORD_TYPE	Record Type Information HC for Header record, PC for body record, TC for trailer record
CERT_START_DATE	Cretificate Start Date
CERT_END_DATE	Certificate End Date
WK_MTH_INDICATOR	Week/Month Indicator
CERT_DATE	Certificate Date
LAST_NAME	Employee Last Name
FIRST_NAME	Employee First Name
ADDRESS_LINE1	Employee Address Line1
ADDRESS_LINE2	Employee Address Line2
ADDRESS_LINE3	Employee Address Line3
PROCESSED_FLAG	Processed Flag, Indicating record has been processed
PROCESS_FLAG	Process Flag, Y indicates the First Phase of validation is sucessful and the records will be used in the second phase validation
PROCESSED_DATE	Date when Processed
TOT_PAY_TO_DATE
TOT_TAX_TO_DATE	Total Tax to Date
EXEMPTION_INDICATOR
STD_RATE_OF_TAX
HIGHER_RATE_OF_TAX
PPS_NUMBER	PPS Number of the person
EMPLOYER_NUMBER	Employer Paye Reference Number
WK_RATE_CUTOFF	Weekly Rate Cutoff
WORKS_NUMBER	Works Number which is equal to Employee Number
MTH_TAX_CREDIT	Monthly Tax Credit
MTH_RATE_CUTOFF	Monthly Tax Credit
WK_TAX_CREDIT	Weekly Tax Credit

Payroll - PAY_IE_TAX_HEADER_INTERFACE	PAY_IE_TAX_HEADER_INTERFACE,Interface table used for uploading data into PAYE tables from a flat file.
Column Name	Descritpion
RECORD_TYPE	Record Type Indicator, HC for Header Record
EMPLOYER_NUMBER	Employer Paye Reference Number
EMPLOYER_NAME	Employer Name
EMPLOYER_UNIT_NO	Employer Unit Number
TAX_YEAR	Tax Year
FILLER	Filler for further use

Payroll - PAY_IE_TAX_TRAILER_INTERFACE	PAY_IE_TAX_TRAILER_INTERFACE,Interface table used for uploading data into PAYE tables from a flat file.
Column Name	Descritpion
RECORD_TYPE	Record Type Indicator, TC for Trailer Record
FILLER	Filler for Further use
RECORD_ID	Record Id
EMPLOYER_NUMBER	Employer Paye Reference Number
RECORD_NO	Record Number
TOTAL_MTH_RATE_CUTOFF	Total Monthly Rate Cutoff
TOTAL_WK_RATE_CUTOFF	Total Weekly Rate Cutoff
TOTAL_MTH_TAX_CREDIT	Total Monthly tax Credit
TOTAL_WK_TAX_CREDIT	Total Weekly Tax Credit

Payroll - PAY_IE_TAX_ERROR	PAY_IE_TAX_ERROR,Table used to populate errors occured during uploading PAYE details.
Column Name	Descritpion
PPS_NUMBER	Employee PPS Number
EMPLOYEE_NUMBER	Employee Number
FULL_NAME	Employee Full Name
PAYROLL_NAME	Payroll Name which is assigned to Employee
TAX_DISTRICT	Tax District Information
ERROR_STACK_MESSAGE	Error Message from the stack
ERROR_MESSAGE	Error Messages
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
ERROR_DATE	Error Date

Payroll - PAY_IE_SOCIAL_BENEFITS_F	PAY_IE_SOCIAL_BENEFITS_F holds the social benefit details for an assignment.This is a date tracked table
Column Name	Descritpion
SOCIAL_BENEFIT_ID	System-generated primary key column.
BENEFIT_AMOUNT	Benefit Amount,Initially defaulted from global value
BENEFIT_TYPE	Benefit Type ie Sickness or Occupational Injury Benefit
CALCULATION_OPTION	Calculation Option ie. option 1,2 or 3
REDUCED_TAX_CREDIT	Reduced Tax Credit amount derived from PAYE and Taxable Benefit Amount,if option is 2
REDUCED_STANDARD_CUTOFF	Reduced Standard Cutoff derived fom PAYE and Benefit percentage if option is 2
INCIDENT_ID	Incident ID ,refernced from per_work_incidents
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
EFFECTIVE_START_DATE	Date Track Effective Start Date
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
EFFECTIVE_END_DATE	Date Track Effective End Date
OBJECT_VERSION_NUMBER	Object Version Number
ASSIGNMENT_ID	Foreign key to PER_ALL_ASSIGNMENTS_F Table
ABSENCE_START_DATE	Absence start Date derived from the absence management system
ABSENCE_END_DATE	Absence End Date derived from the absence management system

Payroll - PAY_AC_VENDOR_MAPPINGS	North American Table to control the mapping of internal Values to External Vendor Values
Column Name	Descritpion
MAPPING_TYPE	Name of the Mapping Type that is being set.
INTERNAL_VALUE	Internal Oracle Value that is to be translated
VENDOR_VALUE	The External Value that the Oracle Internal value is to be translated into.
JURISDICTION_CODE	This is the jurisdiction to which the translation relates to.
INTERNAL_TAX_ID	This is the internal tax Identifier that the translation relates to
INTERNAL_RUN_ID	This is the internal Run Definition Identifier that the translation relates to.

Payroll - PAY_DIMENSION_ROUTES	Stores balance dimension relationships.
Column Name	Descritpion
BALANCE_DIMENSION_ID	Foreign key to pay_balance_dimensions.
RETRIEVAL_COLUMN	Used in Non Payroll applications to indicated the name of the column to be summed.
ROUTE_ID	Foreign key to ff_routes.
ROUTE_TYPE	Either 'RR' for run result route or 'RB' for run balance route.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PRIORITY	Prioritises dimension route relationships.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
RUN_DIMENSION_ID	Run level balance dimension id. Also a foreign key to pay_balance_dimensions.
CREATION_DATE	Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
BALANCE_TYPE_COLUMN	Denotes the join to balance types that need to be used in the route
DECODE_REQUIRED	Appends a decode clause in the route whenused in combination of Balance Type Column

Payroll - PAY_BALANCE_ATTRIBUTES	Holds mappings between attributes and defined balances.
Column Name	Descritpion
ATTRIBUTE_ID	Foreign key table PAY_BAL_ATTRIBUTE_DEFINITIONS.
DEFINED_BALANCE_ID	Foreign key to PAY_DEFINED_BALANCES.
BUSINESS_GROUP_ID	Business group id
LEGISLATION_CODE	Legislation code
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
BALANCE_ATTRIBUTE_ID	Primary key
CREATION_DATE	Standard who column - date when this row was created.

Payroll - PAY_BALANCE_CATEGORIES_F	Holds seeded categories for balances.
Column Name	Descritpion
CATEGORY_NAME	Name of the category
PBC_INFORMATION12	Developer descriptive flexfield column.
PBC_INFORMATION13	Developer descriptive flexfield column.
PBC_INFORMATION14	Developer descriptive flexfield column.
PBC_INFORMATION15	Developer descriptive flexfield column.
PBC_INFORMATION16	Developer descriptive flexfield column.
PBC_INFORMATION17	Developer descriptive flexfield column.
PBC_INFORMATION18	Developer descriptive flexfield column.
PBC_INFORMATION19	Developer descriptive flexfield column.
PBC_INFORMATION20	Developer descriptive flexfield column.
PBC_INFORMATION21	Developer descriptive flexfield column.
EFFECTIVE_START_DATE	Effective start date
PBC_INFORMATION22	Developer descriptive flexfield column.
PBC_INFORMATION23	Developer descriptive flexfield column.
PBC_INFORMATION24	Developer descriptive flexfield column.
PBC_INFORMATION25	Developer descriptive flexfield column.
PBC_INFORMATION26	Developer descriptive flexfield column.
PBC_INFORMATION27	Developer descriptive flexfield column.
PBC_INFORMATION28	Developer descriptive flexfield column.
PBC_INFORMATION29	Developer descriptive flexfield column.
PBC_INFORMATION30	Developer descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
EFFECTIVE_END_DATE	Effective end date
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
LEGISLATION_CODE	Legislation code
BUSINESS_GROUP_ID	Business group id
SAVE_RUN_BALANCE_ENABLED	Flag used in conjunction with dimension information for enabling run balances.
USER_CATEGORY_NAME	Displayed name
PBC_INFORMATION_CATEGORY	Developer descriptive flexfield column.
PBC_INFORMATION1	Developer descriptive flexfield column.
BALANCE_CATEGORY_ID	Primary key
PBC_INFORMATION2	Developer descriptive flexfield column.
PBC_INFORMATION3	Developer descriptive flexfield column.
PBC_INFORMATION4	Developer descriptive flexfield column.
PBC_INFORMATION5	Developer descriptive flexfield column.
PBC_INFORMATION6	Developer descriptive flexfield column.
PBC_INFORMATION7	Developer descriptive flexfield column.
PBC_INFORMATION8	Developer descriptive flexfield column.
PBC_INFORMATION9	Developer descriptive flexfield column.
PBC_INFORMATION10	Developer descriptive flexfield column.
PBC_INFORMATION11	Developer descriptive flexfield column.

Payroll - PAY_BAL_ATTRIBUTE_DEFAULTS	Balance attribution defaulted according to values in this table.
Column Name	Descritpion
BALANCE_CATEGORY_ID	Foreign key to table PAY_BALANCE_CATEGORIES_F
BALANCE_DIMENSION_ID	Foreign key to table PAY_BALANCE_DIMENSIONS
ATTRIBUTE_ID	Foreign key to table PAY_BAL_ATTRIBUTE_DEFINITIONS
BUSINESS_GROUP_ID	Business group id
LEGISLATION_CODE	Legislation code
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
BAL_ATTRIBUTE_DEFAULT_ID	Primary key
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.

Payroll - PAY_BAL_ATTRIBUTE_DEFINITIONS	Balance attributes help to identify which balances should be usedin which reports.
Column Name	Descritpion
ATTRIBUTE_NAME	Name of the attribute
ALTERABLE	Flag specifying whether associated dimensions can be added or removed.
BUSINESS_GROUP_ID	Business group id
LEGISLATION_CODE	Legislation code
USER_ATTRIBUTE_NAME	Displayed name
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ATTRIBUTE_ID	Primary key
CREATION_DATE	Standard who column - date when this row was created.

Payroll - PAY_EVENT_QUALIFIERS_F	Event Qualification definitions
Column Name	Descritpion
EVENT_QUALIFIER_ID	System generated primary key column
QUALIFIER_DEFINITION	QUALIFIER_DEFINITION holds the select portion of the statement that is used to qualify the event.
QUALIFIER_WHERE_CLAUSE	QUALIFIER_DEFINITION holds the from/where portion of the statement that is used to qualify the event.
ENTRY_QUALIFICATION	ASSIGNMENT_QUALIFICATION is used to determine whether this particular event is valid for a specified element_entry
ASSIGNMENT_QUALIFICATION	ASSIGNMENT_QUALIFICATION is used to determine whether this particular event is valid for a specified assignment
MULTI_EVENT_SQL	MULTI_EVENT_SQL contains a select statement that is used to identify potential rows that need to have the comparison performed.
OBJECT_VERSION_NUMBER	Standard Object Version Number
CREATION_DATE	Standard who column - date when this row was created.
EFFECTIVE_START_DATE	Effective Start Date
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
EFFECTIVE_END_DATE	Effective End Date
DATED_TABLE_ID	Foreign key to PAY_DATED_TABLES.
COLUMN_NAME	COLUMN_NAME contains the column that this qualifier is for.
QUALIFIER_NAME	This is the User name for the Qualification
LEGISLATION_CODE	Foreign Key to FND_TERRITORIES
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS
COMPARISON_COLUMN	COMPARISON_COLUMN holds the column name or value definition that is used for the comparision in the event qualification

Payroll - PAY_EVENT_VALUE_CHANGES_F	Values changes that cause an event
Column Name	Descritpion
EVENT_VALUE_CHANGE_ID	System generated primary key column
FROM_VALUE	The before value to be tested
TO_VALUE	The after value to be tested.
PRORATION_STYLE	PRORATION_STYLE indicates the type of proration that should occur when this event is encountered.
QUALIFIER_VALUE	QUALIFIER_VALUE contains a derived value that indicates whether the before and after value should be compared.
OBJECT_VERSION_NUMBER	Object Version Number
EFFECTIVE_START_DATE	Effective Start Date
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
EFFECTIVE_END_DATE	Effective End Date
EVENT_QUALIFIER_ID	Foreign Key to PAY_EVENT_QUALIFIERS_F
DATETRACKED_EVENT_ID	Foreign Key to PAY_DATETRACKED_EVENTS
DEFAULT_EVENT	This denotes whether this is the default event entry
VALID_EVENT	This value denotes whether this is a valid event to be reported.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS
LEGISLATION_CODE	Foreign Key to FND_TERRITORIES

Payroll - PAY_ACTION_PARAMETER_GROUPS	Groups of Pay Action Parameters
Column Name	Descritpion
ACTION_PARAMETER_GROUP_NAME	User defined identifier of the Group.
ACTION_PARAMETER_GROUP_ID	System-generated primary key column.

Payroll - PAY_ACTION_PARAMETER_VALUES	Values for the specified action parameters
Column Name	Descritpion
PARAMETER_VALUE	Value for a specific Parameter
ACTION_PARAMETER_GROUP_ID	Group_id of group of parameter value
PARAMETER_NAME	Name of Parameter to Set

Payroll - PAY_BALANCE_VALIDATION	Balance Validity information
Column Name	Descritpion
BALANCE_VALIDATION_ID	System generated primary key column.
DEFINED_BALANCE_ID	Foreign key to PAY_DEFINED_BALANCES.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
RUN_BALANCE_STATUS	Status of the Run Balance population.
BALANCE_LOAD_DATE	The Date from which run balances where loaded for this Balance

Payroll - PAY_BANK_BRANCHES	Stores bank branch information to enable entry of bank account details with the correct branch information (e.g. GB bank, sort code, branch).
Column Name	Descritpion
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
BANK_CODE	Reference to the bank that this branch belongs to.
BRANCH	Bank branch name as on PAY_EXTERNAL_ACCOUNTS.
LONG_BRANCH	Longer version of the bank branch name to assist validation only.
EXTRA_INFORMATION1	Other bank branch information e.g. GB building society account.
EXTRA_INFORMATION2	Other bank branch information e.g. GB building society account.
EXTRA_INFORMATION3	Other bank branch information e.g. GB building society account.
EXTRA_INFORMATION4	Other bank branch information e.g. GB building society account.
BRANCH_CODE	Short code that identifies a bank branch e.g. GB sort code.
EXTRA_INFORMATION5	Other bank branch information e.g. GB building society account.
ENABLED_FLAG	Yes/No flag for whether or not this branch is enabled.
START_DATE_ACTIVE	Date from which this bank branch is active.
END_DATE_ACTIVE	Date until which this branch is active.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.

Payroll - PAY_ELEMENT_SPAN_USAGES	RetroPay functionality to determine which retro element should be used
Column Name	Descritpion
ELEMENT_SPAN_USAGE_ID	System-generated primary key column.
LEGISLATION_CODE	Foreign Key to FND_TERRITORIES
TIME_SPAN_ID	Foreign key to PAY_TIME_SPANS
RETRO_COMPONENT_USAGE_ID	Foreign key to PAY_RETRO_COMPONENT_USAGES
ADJUSTMENT_TYPE	Type of adjustment (Credit, Debit)
RETRO_ELEMENT_TYPE_ID	Foreign key to PAY_ELEMENT_TYPES_F
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.

Payroll - PAY_ENTRY_PROCESS_DETAILS	Internal processing details for certain element entries
Column Name	Descritpion
SOURCE_ASG_ACTION_ID	Foreign key to PAY_ASSIGNMENT_ACTIONS
RETRO_COMPONENT_ID	Foreign key to PAY_RETRO_COMPONENTS
RUN_RESULT_ID	Foreign key to PAY_RUN_RESULTS
TAX_UNIT_ID	Foreign key to HR_ORGANIZATION_UNITS
PROCESS_PATH	Process Path is used to identify the Run Type that the entry should be processed in.
ADJUSTMENT_TYPE
ENTRY_PROCESS_PATH
TIME_DEFINITION_ID	Foreign Key to PAY_TIM_DEFINITIONS.
ELEMENT_ENTRY_ID	Foreign key to PAY_ELEMENT_ENTRIES_F
SOURCE_ELEMENT_TYPE_ID	Foreign key to PAY_ELEMENT_TYPES_F
SOURCE_ENTRY_ID	Foreign key to PAY_ELEMENT_ENTRIES_F

Payroll - PAY_JP_PRE_TAX	This table is a temporary table for Japanese legislative reports.
Column Name	Descritpion
PRE_TAX_ID	System-generated primary key column.
HI_PREM_EE	Employee's premium for HI.
HI_PREM_ER	Employer's premium for HI.
CI_PREM_EE	Employee's premium for CI.
CI_PREM_ER	Employer's premium for CI.
WP_ORGANIZATION_ID	WP organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS.
WP_PREM_EE	Employee's premium for WP.
WP_PREM_ER	Employer's premium for WP.
WPF_ORGANIZATION_ID	WPF organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS.
WPF_PREM_EE	Employee's premium for WPF.
WPF_PREM_ER	Employee's premium for WPF.
ACTION_ID	System-generated non-unique column. Used for which row should be processed by PAY_JP_PRE_TAX_PKG.
UI_ORGANIZATION_ID	UI organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS.
UI_CATEGORY	Employee's caterogy on UI.
UI_PREM_EE	Employee's premium for UI.
UI_SAL_AMT	Salary amount for UI.
WAI_ORGANIZATION_ID	WAI organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS.
WAI_CATEGORY	Employee's category on UI.
WAI_SAL_AMT	Salary amount for WAI.
ITAX_ORGANIZATION_ID	ITAX organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS.
ITAX_CATEGORY	Employee's category on ITAX calc.
ITAX_YEA_CATEGORY	Employee's processing category for (Re-)Year-End-Adjustment(YEA).
ASSIGNMENT_ACTION_ID	Foreign key to PAY_ASSIGNMENT_ACTIONS.
ITAX	ITAX Amount (Excluding ITAX Adjustment amount for YEA).
ITAX_ADJUSTMENT	ITAX Adjustment amount for YEA.
PREVIOUS_ITAX	ITAX from previous career.
LTAX_ORGANIZATION_ID	LTAX organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS.
LTAX_DISTRICT_CODE	LTAX DISTRICT Code.
LTAX_SWOT_NO	LTAX SWOT Number.
LTAX	LTAX amount (excluding lumpsum LTax).
LTAX_LUMPSUM	LTAX Amount for lumpsum.
SP_LTAX	Special LTAX Amount.
SP_LTAX_INCOME	Taxable amount for special LTAX.
ACTION_STATUS	Valid status for the assignment_action_id of PAY_JP_PRE_TAX_PKG process.
SP_LTAX_SHI	Special LTAX amount for DISTRICT.
SP_LTAX_TO	Special LTAX amount for prefecture.
MUTUAL_AID	Premium for Mutual Aid.
SALARY_CATEGORY	Salary category.
TAXABLE_SAL_AMT	Taxable salary amount (including salary for non-resident and terminator).
TAXABLE_MAT_AMT	Taxable material salary amount (including salary for non-resident and terminator).
PREVIOUS_TAXABLE_AMT	Taxable amount from previous career.
HI_ORGANIZATION_ID	HI organization_id. Foreign key to HR_ALL_ORGANIZATION_UNITS.

Payroll - PAY_FILE_DETAILS	Report file details that have been saved in the system
Column Name	Descritpion
FILE_DETAIL_ID	System generated Primary Key
BLOB_FILE_FRAGMENT
INTERNAL_FILE_NAME
SOURCE_ID	Foreign Key to an entity described by the SOURCE_TYPE column
SEQUENCE
SOURCE_TYPE	Denotes the source of the SOURCE_ID attribute
FILE_TYPE	Denotes the type of file.
FILE_LOCATION	The Operating System location of the file.
FILE_FRAGMENT	Whole or Partial file content

Payroll - PAY_DYNDBI_CHANGES	Internal table to control the generation of dynamic database item names.
Column Name	Descritpion
TYPE	The entity type for which the dynamic database item names must be generated. The types are DB (defined balance), ET (element type), and EIV (element input value).
LANGUAGE	The language in which the database item names should be translated.
ID	Together with TYPE, ID uniquely identifies an object for which new dynamic database item names must be generated.

Payroll - PAY_GROUP_DEFINITIONS	Stores the Processing Groups in the System
Column Name	Descritpion
GROUP_DEFINITION_ID	System generated primary key.
NAME	User name of the Processing Group

Payroll - PAY_CHUNK_STATUS	Shows which chunks have been processed by a specific payroll action, or process.
Column Name	Descritpion
PAYROLL_ACTION_ID	Foreign Key to PAY_PAYROLL_ACTIONS
CHUNK_NUMBER	Number used to group events into chunks for parallelization.
RAND_CHUNK_NUMBER	Number used to group events into chunks for parallelization.
POPULATION_STATUS	Valid population statuses for a Chunk.
PROCESS_STATUS	Valid process statuses for a Chunk

Payroll - PAY_ADJUST_BATCH_GROUPS	Batch Group information for balance upload batch.
Column Name	Descritpion
BATCH_GROUP_ID
BATCH_ID
BATCH_GROUP_STATUS
CONSOLIDATION_SET_ID
PAYROLL_ID
EFFECTIVE_DATE
PREPAY_FLAG

Payroll - PAY_ADJUST_BATCH_LINES
Column Name	Descritpion
BATCH_LINE_ID
INPUT_VALUE_ID3
INPUT_VALUE_ID4
INPUT_VALUE_ID5
INPUT_VALUE_ID6
INPUT_VALUE_ID7
INPUT_VALUE_ID8
INPUT_VALUE_ID9
INPUT_VALUE_ID10
INPUT_VALUE_ID11
INPUT_VALUE_ID12
BATCH_ID
INPUT_VALUE_ID13
INPUT_VALUE_ID14
INPUT_VALUE_ID15
ENTRY_VALUE1
ENTRY_VALUE2
ENTRY_VALUE3
ENTRY_VALUE4
ENTRY_VALUE5
ENTRY_VALUE6
ENTRY_VALUE7
BATCH_LINE_STATUS
ENTRY_VALUE8
ENTRY_VALUE9
ENTRY_VALUE10
ENTRY_VALUE11
ENTRY_VALUE12
ENTRY_VALUE13
ENTRY_VALUE14
ENTRY_VALUE15
BALANCE_ADJ_COST_FLAG
COST_ALLOCATION_KEYFLEX_ID
BATCH_GROUP_ID
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
BATCH_LINE_SEQUENCE
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ASSIGNMENT_ID
ATTRIBUTE20
RUN_TYPE_ID
ORIGINAL_ENTRY_ID
TAX_UNIT_ID
ELEMENT_LINK_ID
ELEMENT_TYPE_ID
INPUT_VALUE_ID1
INPUT_VALUE_ID2

Payroll - PAY_CA_DISPLAY_CITIES	Canadian cities and their geocodes, used to update city names with their correct Canadian French spellings
Column Name	Descritpion
CITY_NAME	City name.
STATE_CODE	Foreign key to PAY_US_COUNTIES.
COUNTY_CODE	Foreign key to PAY_US_COUNTIES.
CITY_CODE	Foreign key to PAY_US_CITY_GEOCODES.
DISPLAY_CITY_NAME	Represents correct Canadian French spelling of city name

Payroll - PAY_DBITL_UPDATE_ERRORS	Internal table used for logging errors encountered when updating seeded Database Item translated names.
Column Name	Descritpion
USER_ENTITY_ID
TRANSLATED_NAME	The new translated Database Item name.
MESSAGE_TEXT	The error message text.
USER_NAME	The base (non-translated) Database Item name.

Payroll - PAY_ELE_TMPLT_CLASS_USAGES	Element Templates and Classifications
Column Name	Descritpion
ELE_TMPLT_CLASS_INFO14	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO15	Developer descriptive flexfield column.
CLASSIFICATION_ID	Element Classification ID
ELE_TMPLT_CLASS_INFO16	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO17	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO18	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO19	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO20	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO21	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO22	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO23	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO24	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO25	Developer descriptive flexfield column.
TEMPLATE_ID	Element Template ID
ELE_TMPLT_CLASS_INFO26	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO27	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO28	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO29	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO30	Developer descriptive flexfield column.
DISPLAY_PROCESS_MODE	Display Process Mode
DISPLAY_ARREARAGE	Display Arrearage
ELE_TMPLT_CLASS_INFO_CATEGORY	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO1	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO2	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO3	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO4	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO5	Developer descriptive flexfield column.
ELE_TEMPLATE_CLASSIFICATION_ID	Element Template Classification ID
ELE_TMPLT_CLASS_INFO6	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO7	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO8	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO9	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO10	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO11	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO12	Developer descriptive flexfield column.
ELE_TMPLT_CLASS_INFO13	Developer descriptive flexfield column.

Payroll - PAY_ELEMENT_CLASS_USAGES_F	Used to store element classifications included in a defined run type.
Column Name	Descritpion
ELEMENT_CLASS_USAGE_ID	Primary Key.
LAST_UPDATE_DATE	Standard who column.
LAST_UPDATED_BY	Standard who column.
LAST_UPDATE_LOGIN	Standard who column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
EFFECTIVE_START_DATE	Effective start date.
EFFECTIVE_END_DATE	Effective end date.
RUN_TYPE_ID	Foreign key to PAY_RUN_TYPES_F.
CLASSIFICATION_ID	Foreign key to PAY_ELEMENT_CLASSIFICATIONS.
BUSINESS_GROUP_ID	Business Group.
LEGISLATION_CODE	Legislation Code
INCLUSION_FLAG
CREATED_BY	Standard who column.
CREATION_DATE	Standard who column.

Payroll - PAY_ELEMENT_SETS_TL	Translated Element Sets Names
Column Name	Descritpion
ELEMENT_SET_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
ELEMENT_SET_ID
LANGUAGE
SOURCE_LANG

Payroll - PAY_BALANCE_DIMENSIONS_TL	Translated Balance Dimensions and Database Item Suffixes.
Column Name	Descritpion
BALANCE_DIMENSION_ID
CREATED_BY
CREATION_DATE
LANGUAGE
SOURCE_LANG
DIMENSION_NAME
DATABASE_ITEM_SUFFIX
DESCRIPTION
LAST_UPDATE_LOGIN
LAST_UPDATED_BY
LAST_UPDATE_DATE

Payroll - PAY_BALANCE_CATEGORIES_F_TL	Translated Balance Categories names.
Column Name	Descritpion
BALANCE_CATEGORY_ID
LANGUAGE
SOURCE_LANG
USER_CATEGORY_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE

Payroll - FF_GLOBALS_F_TL	Translated Globals Name
Column Name	Descritpion
GLOBAL_ID
CREATION_DATE
LANGUAGE
SOURCE_LANG
GLOBAL_NAME
GLOBAL_DESCRIPTION
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY

Payroll - FF_FORMULAS_F_TL	Translated Formula Names and description
Column Name	Descritpion
FORMULA_ID
CREATION_DATE
LANGUAGE
SOURCE_LANG
FORMULA_NAME
DESCRIPTION
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY

Payroll - PAY_CONTRIBUTING_PAYMENTS
Column Name	Descritpion
ASSIGNMENT_ACTION_ID
CONTRIBUTING_PRE_PAYMENT_ID
PRE_PAYMENT_ID
PAYROLL_ACTION_ID

Payroll - PAY_CE_RECONCILED_PAYMENTS_EFC
Column Name	Descritpion
EFC_ACTION_ID
CLEARED_AMOUNT
CLEARED_BASE_AMOUNT
OPM_CURRENCY_CODE
ABA_CURRENCY_CODE
OUTPUT_CURRENCY_CODE
RECONCILED_PAYMENT_ID

Payroll - PAY_EVENT_GROUP_USAGES	Provides grouping for user control of event monitoring
Column Name	Descritpion
EVENT_GROUP_USAGE_ID	Surrogate Primary Key
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
EVENT_GROUP_ID	Foreign key to PAY_EVENT_GROUPS
ELEMENT_SET_ID	Foreign key to type 'E' element set on PAY_ELEMENT_SETS
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE	Foreign Key to FND_TERRITORIES
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Payroll - HR_PUMP_SPREAD_LOADERS	Stores internal record for Data Pump Spread Sheet Loader seed data
Column Name	Descritpion
MODULE_NAME
ENTITY_SQL_OBJECT_NAME
ENTITY_SQL_WHERE_CLAUSE
ENTITY_SQL_PARAMETERS
ENTITY_SQL_ORDER_BY
INTEGRATOR_CODE
ENTITY_NAME
MODULE_MODE
API_MODULE_ID
INTEGRATOR_PARAMETERS
ENTITY_SQL_COLUMN_NAME
ENTITY_SQL_COLUMN_ID
ENTITY_SQL_ADDL_COLUMN

Payroll - PAY_BATCH_ELEMENT_LINKS	Batch table for element links
Column Name	Descritpion
BATCH_ELEMENT_LINK_ID	System-generated primary key column.
ELEMENT_TYPE_ID	Foreign key to PAY_ELEMENT_TYPES_F.
LOCATION_ID	Foreign key to HR_LOCATIONS.
GRADE_ID	Foreign key to PER_GRADES.
BALANCING_KEYFLEX_ID	Foreign key to PAY_COST_ALLOCATION_KEYFLEX.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ELEMENT_SET_ID	Foreign key to PAY_ELEMENT_SETS.
PAY_BASIS_ID	Foreign key to PER_PAY_BASES.
COSTABLE_TYPE	Costable type for element entries subject to this link. (Validated by a lookup).
LINK_TO_ALL_PAYROLLS_FLAG	Indicates whether all payrolls are eligible for the element.
MULTIPLY_VALUE_FLAG	Indicates whether entries can be multiplied, for example, holiday pay.
ELEMENT_LINK_ID	Foreign key to PAY_ELEMENT_LINKS_F.
STANDARD_LINK_FLAG	Indicates whether an element is standard (Y) or non-standard (N).
TRANSFER_TO_GL_FLAG	Indicates whether costed values for the element can be included in the transfer to General Ledger.
COMMENT_ID	Foreign key to HR_COMMENTS.
EMPLOYMENT_CATEGORY	Employment category criteria for the element. Validated by lookup.
QUALIFYING_AGE	Minimum age criteria for the element.
QUALIFYING_LENGTH_OF_SERVICE	Minimum length of service for eligibility for the element.
QUALIFYING_UNITS	Time units used by the QUALIFYING_LENGTH_OF_SERVICE. (Validated by a lookup).
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
EFFECTIVE_DATE	Effective date.
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
PAYROLL_ID	Foreign key to PAY_ALL_PAYROLLS_F.
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
JOB_ID	Foreign key to PER_JOBS.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
POSITION_ID	Foreign key to PER_POSITIONS.
PEOPLE_GROUP_ID	Foreign key to PAY_PEOPLE_GROUPS.
COST_ALLOCATION_KEYFLEX_ID	Foreign key to PAY_COST_ALLOCATION_KEYFLEX.
ORGANIZATION_ID	Foreign key to HR_ORGANIZATION_UNITS.