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

Payroll - PAY_LEGISLATION_RULES	Legislation specific rules and structure identifiers.
Column Name	Descritpion
LEGISLATION_CODE	Code identifying the legislation to which the rule applies.
RULE_TYPE	Type of rule.
RULE_MODE	Identifier or other value for the given legislation code and rule type.

Payroll - PAY_LEGISLATIVE_FIELD_INFO	Controls legislative rules on individual form fields
Column Name	Descritpion
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
PROMPT	The name to display (not translated)
VALIDATION_NAME	Name of validation to be applied
VALIDATION_TYPE	Type of validation used.
TARGET_LOCATION	Object, e.g. Form, for which the rule applies
RULE_TYPE	Identifies the rule applied to the field
RULE_MODE	Status of the rule e.g. enabled or disabled
PROMPT_MESSAGE	This will be the message which will be used for the Prompt text.
IN_LINE_MESSAGE	This will be the message which will be used for the In-line Tip text.
QUICK_TIP_MESSAGE	This will be the message which will be used for the Quick Tip text.
BUBBLE_TIP_MESSAGE	This will be the message which will be used for the Bubble Tip text.
CATEGORY	This will be the category in which the field will be grouped under..
FIELD_NAME	The form field name affected

Payroll - PAY_LINK_INPUT_VALUES_F	Input value overrides for a specific element link.
Column Name	Descritpion
LINK_INPUT_VALUE_ID	System-generated primary key column.
WARNING_OR_ERROR	Indicates whether a warning or error message is generated if the input value is not valid for 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.
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.
ELEMENT_LINK_ID	Element Link Value Identifier
INPUT_VALUE_ID	Input Value Identifier
COSTED_FLAG	Indicates whether an input value is costed.
DEFAULT_VALUE	Default for the input value on entry. May be overridden for a specific element entry.
MAX_VALUE	Maximum value allowed on entry. May be overridden for a specific element entry.
MIN_VALUE	Minimum value allowed on entry. May be overridden for a specific element entry.

Payroll - PAY_MESSAGE_LINES	Error messages from running a process.
Column Name	Descritpion
LINE_SEQUENCE	Displays sequence of this line. This is a global sequence.
PAYROLL_ID	Foreign key to PAY_PAYROLLS.
MESSAGE_LEVEL	Indicates the severity of the message, from fatal errors to general messages.
SOURCE_ID	Generic foreign key to the message owner.
SOURCE_TYPE	Specifies the message owner type: assignment action, payroll action or Business Group.
LINE_TEXT	Text for the line.

Payroll - PAY_MONETARY_UNITS	Valid denominations for currencies.
Column Name	Descritpion
MONETARY_UNIT_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.
CURRENCY_CODE	Foreign key to FND_CURRENCIES.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
MONETARY_UNIT_NAME	User definable name for the monetary unit.
RELATIVE_VALUE	Relative value to the base unit for the currency.
COMMENTS	General remark.
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_ORG_PAYMENT_METHODS_F	Payment methods used by a Business Group.
Column Name	Descritpion
ORG_PAYMENT_METHOD_ID	System-generated primary key column.
COMMENT_ID	Foreign key to PAY_COMMENTS.
EXCLUDE_MANUAL_PAYMENT	Indicates if manual payments are to be excluded
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
TYPE
ORGANIZATION_ID
ATTRIBUTE1	Descriptive flexfield segment
PARENT_ORG_PAYMENT_METHOD_ID
TIME_DEFINITION_ID
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
EFFECTIVE_START_DATE	Effective start date.
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
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
EFFECTIVE_END_DATE	Effective end date.
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.
PMETH_INFORMATION_CATEGORY	Descriptive flexfield structure defining column.
PMETH_INFORMATION1	Descriptive flexfield segment column.
PMETH_INFORMATION2	Descriptive flexfield segment column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
PMETH_INFORMATION3	Descriptive flexfield segment column.
PMETH_INFORMATION4	Descriptive flexfield segment column.
PMETH_INFORMATION5	Descriptive flexfield segment column.
PMETH_INFORMATION6	Descriptive flexfield segment column.
PMETH_INFORMATION7	Descriptive flexfield segment column.
PMETH_INFORMATION8	Descriptive flexfield segment column.
PMETH_INFORMATION9	Descriptive flexfield segment column.
PMETH_INFORMATION10	Descriptive flexfield segment column.
PMETH_INFORMATION11	Descriptive flexfield segment column.
PMETH_INFORMATION12	Descriptive flexfield segment column.
EXTERNAL_ACCOUNT_ID	Foreign key to PAY_EXTERNAL_ACCOUNTS.
PMETH_INFORMATION13	Descriptive flexfield segment column.
PMETH_INFORMATION14	Descriptive flexfield segment column.
PMETH_INFORMATION15	Descriptive flexfield segment column.
PMETH_INFORMATION16	Descriptive flexfield segment column.
PMETH_INFORMATION17	Descriptive flexfield segment column.
PMETH_INFORMATION18	Descriptive flexfield segment column.
PMETH_INFORMATION19	Descriptive flexfield segment column.
PMETH_INFORMATION20	Descriptive flexfield segment column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
CURRENCY_CODE	Foreign key to FND_CURRENCIES.
TRANSFER_TO_GL_FLAG	Transfer to GL flag.
PAYMENT_TYPE_ID	Foreign key to PAY_PAYMENT_TYPES.
COST_PAYMENT	Indicates if payments are to be costed.
DEFINED_BALANCE_ID	Foreign key to PAY_DEFINED_BALANCES.
COST_CLEARED_PAYMENT	Indicates if cleared payments are to be costed.
ORG_PAYMENT_METHOD_NAME	Name given to the payment method.
COST_CLEARED_VOID_PAYMENT	Indicates if cleared voided payments are to be costed.

Payroll - PAY_ORG_PAY_METHOD_USAGES_F	Payment methods available to assignments on a specific payroll.
Column Name	Descritpion
ORG_PAY_METHOD_USAGE_ID	Surrogate primary key for DateTrack entity.
CREATION_DATE	Standard who column - date when this row was created.
EFFECTIVE_START_DATE	Effective start date.
EFFECTIVE_END_DATE	Effective end date.
PAYROLL_ID	Foreign key to PAY_PAYROLLS.
ORG_PAYMENT_METHOD_ID	Foreign key to PAY_ORG_PAYMENT_METHODS.
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_PAYMENT_TYPES	Types of payment that can be processed by the system.
Column Name	Descritpion
PAYMENT_TYPE_ID	System generated unique key.
VALIDATION_DAYS	Number of days required before method is considered valid.
VALIDATION_VALUE	Payment value to be included in a validation record. Null/normal.
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.
RECONCILIATION_FUNCTION	PLSQL procedure for reconciling magnetic tape process.
TERRITORY_CODE	Foreign key to FND_TERRITORIES.
CURRENCY_CODE	Foreign key to FND_CURRENCIES.
CATEGORY	The different methods of payment check(cheque)/cash/magnetic tape, etc.
PAYMENT_TYPE_NAME	Name of the payment type.
ALLOW_AS_DEFAULT	Indicates if this payment method is the default payment method.
DESCRIPTION	Description of payment type.
PRE_VALIDATION_REQUIRED	Optional since only applies to magnetic category payment types.
PROCEDURE_NAME	PLSQL procedure for magnetic tape format.

Payroll - PAY_PAYROLL_ACTIONS	Holds information about a payroll process.
Column Name	Descritpion
PAYROLL_ACTION_ID	System generated primary key.
EFFECTIVE_DATE	Session date for the event; for payroll run, this is DATE PAID.
BATCH_PROCESS_MODE	Used by Batch Element Entry process.
ACTION_PARAMETER_GROUP_ID	Foreign key to PAY_ACTION_PARAMETER_GROUPS
ACTION_SEQUENCE	Absolute sequence number to determine physical order of actions.
ELEMENT_TYPE_ID	Foreign key to PAY_ELEMENT_TYPES_F. Used for Balance Adjustments
COST_ALLOCATION_KEYFLEX_ID	Used by balance_adjustments
CHEQUE_PROCEDURE	Lookup code for PLSQL procedure for ordering cheque/check output.
BALANCE_ADJ_COST_FLAG	Used by balance adjustments
RETRO_DEFINITION_ID	Foreign key to PAY_RETRO_DEFINITIONS
CHEQUE_REPORT	Lookup code for report run to print out cheques/checks.
COMMENTS	Comments field
CURRENT_CHUNK_NUMBER	Part of parallelization implementation - current chunk to process.
CURRENT_TASK	Indicates if payroll action is currently executing.
END_CHEQUE_NUMBER	Optional end of cheque/check number range to be used by the cheque/check writer process.
LEGISLATIVE_PARAMETERS	Free text in which process and legislation-dependent parameters are held.
OVERRIDING_DD_DATE	Overriding direct deposit date parameter for magnetic tape process.
ACTION_TYPE	Type of the payroll action.
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).
START_CHEQUE_NUMBER	Start number for the cheque/check writer process.
START_DATE	Optional start date for some payroll actions.
ELEMENT_SET_ID	Foreign key to PAY_ELEMENT_SETS.
ASSIGNMENT_SET_ID	Foreign key to HR_ASSIGNMENT_SETS.
DATE_EARNED	Date Earned value for a payroll run, usually the same value as Date Paid.
DISPLAY_RUN_NUMBER	Number displayed for payroll runs within a period.
PAY_ADVICE_DATE	Date to display on pay advices.
PAY_ADVICE_MESSAGE	Message text to print on all associated pay advices.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
BACKPAY_SET_ID	Foreign key to PAY_BACKPAY_SETS.
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
CONSOLIDATION_SET_ID	Foreign key to PAY_CONSOLIDATION_SETS.
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
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
PAYROLL_ID	Foreign key to PAY_PAYROLLS.
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.
TARGET_PAYROLL_ACTION_ID	The PAYROLL_ACTION_ID of a QuickPay run.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
TIME_PERIOD_ID	Foreign key to PER_TIME_PERIODS - the time period in which EFFECTIVE_DATE falls.
ORG_PAYMENT_METHOD_ID	Foreign key to PAY_ORG_PAYMENT_METHODS.
REPORT_TYPE	Foreign key to PAY_REPORT_FORMAT_MAPPINGS; used for Archive processes.
REPORT_QUALIFIER	Foreign key to PAY_REPORT_FORMAT_MAPPINGS; used for Archive processes.
MAGNETIC_FILE_NAME	Used for archive processes for the Magnetic file name.
REPORT_FILE_NAME	Used for archive processes.
REPORT_CATEGORY	Foreign key to PAY_REPORT_FORMAT_MAPPINGS; used for Archive processes.
PAYMENT_TYPE_ID	Foreign key to PAY_PAYMENT_TYPES.
RUN_TYPE_ID	Foreign key to PAY_RUN_TYPES_F. Identifies the type of run processed.
END_DATE	End Date of Payroll Action
ACTION_POPULATION_STATUS	Indicates if the insert of assignment actions is complete.
PURGE_PHASE	Value of the current purge phase, either 1 or 2.
BALANCE_SET_ID	Foeign Key to PAY_BALANCE_SETS.
ACTION_STATUS	Status of the process: Unprocessed, Processing, Error, Complete.
FUTURE_PROCESS_MODE	Used by PAYWSABL to prevent pre-payment of balance adjustments.
BATCH_ID	Foreign key to PAY_BATCH_HEADERS

Payroll - PAY_PAYROLL_GL_FLEX_MAPS	Payroll to GL key flexfield segment mappings.
Column Name	Descritpion
PAYROLL_ID	Foreign key to PAY_PAYROLLS.
GL_SET_OF_BOOKS_ID	Identifies set of books in GL.
GL_ACCOUNT_SEGMENT	Key flexfield segment column.
PAYROLL_COST_SEGMENT	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).
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_PAYROLL_LIST	List of payrolls that a secure user can access.
Column Name	Descritpion
PAYROLL_ID	Payroll accessible by the security profile.
SECURITY_PROFILE_ID	Security profile restricted by payroll.
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_PEOPLE_GROUPS	People group flexfield information.
Column Name	Descritpion
PEOPLE_GROUP_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
GROUP_NAME	Concatenation of key flexfield segments.
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 the key flexfield combination becomes active or valid.
END_DATE_ACTIVE	Date the key flexfield combination becomes inactive or invalid.
SEGMENT1	Key flexfield segment
SEGMENT2	Key flexfield segment

Payroll - PAY_PERSONAL_PAYMENT_METHODS_F	Personal payment method details for an employee.
Column Name	Descritpion
PERSONAL_PAYMENT_METHOD_ID	System-generated primary key column.
RUN_TYPE_ID	Foreign key to PAY_RUN_TYPES.
PPM_INFORMATION_CATEGORY	Developer descriptive flexfield column.
PPM_INFORMATION1	Developer descriptive flexfield column.
PPM_INFORMATION2	Developer descriptive flexfield column.
PPM_INFORMATION3	Developer descriptive flexfield column.
PPM_INFORMATION4	Developer descriptive flexfield column.
PPM_INFORMATION5	Developer descriptive flexfield column.
PPM_INFORMATION6	Developer descriptive flexfield column.
PPM_INFORMATION7	Developer descriptive flexfield column.
PPM_INFORMATION8	Developer descriptive flexfield column.
PPM_INFORMATION9	Developer descriptive flexfield column.
PPM_INFORMATION10	Developer descriptive flexfield column.
PPM_INFORMATION11	Developer descriptive flexfield column.
PPM_INFORMATION12	Developer descriptive flexfield column.
PPM_INFORMATION13	Developer descriptive flexfield column.
PPM_INFORMATION14	Developer descriptive flexfield column.
ORG_PAYMENT_METHOD_ID	Foreign key to PAY_ORG_PAYMENT_METHODS.
PPM_INFORMATION15	Developer descriptive flexfield column.
PPM_INFORMATION16	Developer descriptive flexfield column.
PPM_INFORMATION17	Developer descriptive flexfield column.
PPM_INFORMATION18	Developer descriptive flexfield column.
PPM_INFORMATION19	Developer descriptive flexfield column.
PPM_INFORMATION20	Developer descriptive flexfield column.
PPM_INFORMATION21	Developer descriptive flexfield column.
PPM_INFORMATION22	Developer descriptive flexfield column.
PPM_INFORMATION23	Developer descriptive flexfield column.
PPM_INFORMATION24	Developer descriptive flexfield column.
AMOUNT	Fixed amount to be allocated if more than one payment method.
PPM_INFORMATION25	Developer descriptive flexfield column.
PPM_INFORMATION26	Developer descriptive flexfield column.
PPM_INFORMATION27	Developer descriptive flexfield column.
PPM_INFORMATION28	Developer descriptive flexfield column.
PPM_INFORMATION29	Developer descriptive flexfield column.
PPM_INFORMATION30	Developer descriptive flexfield column.
COMMENT_ID	Foreign key to generic remark table.
PERCENTAGE	Percentage to be allocated if there is more than one payment method.
PRIORITY	Priority order for different payment methods for an employee.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
EFFECTIVE_START_DATE	Effective start 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
EFFECTIVE_END_DATE	Effective end date.
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).
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
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.
PAYEE_ID	The payee for a third party payment. This can be a person or an organization.
PAYEE_TYPE	For third party payments, indicates if the payee is a person or organization.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
EXTERNAL_ACCOUNT_ID	Foreign key to PAY_EXTERNAL_ACCOUNTS.
ASSIGNMENT_ID	Foreign key to PER_ASSIGNMENTS.
PERSON_ID	Foreign key to PER_PEOPLE.

Payroll - PAY_PERSON_LATEST_BALANCES	Latest balance values for a person.
Column Name	Descritpion
DEFINED_BALANCE_ID	Foreign key to PAY_DEFINED_BALANCES.
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.
PERSON_ID	Foreign key to PER_PEOPLE.
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 latest balance when it last expired.

Payroll - PAY_POPULATION_RANGES	PERSON_ID ranges for parallel processing.
Column Name	Descritpion
RAND_CHUNK_NUMBER	Chunk number allocated for the processing of people
PERSON_ID	Foreign Key to PER_PEOPLE - PERSON_ID
SOURCE_ID
SOURCE_TYPE
PAYROLL_ACTION_ID	Foreign key to PAY_PAYROLL_ACTIONS.
CHUNK_NUMBER	Chunk number allocated to the range of people.
STARTING_PERSON_ID	Foreign key to PER_PEOPLE - start of PERSON_ID range.
ENDING_PERSON_ID	Foreign key to PER_PEOPLE - end of PERSON_ID range.
RANGE_STATUS	Status value used for range synchronization.

Payroll - PAY_PRE_PAYMENTS	Pre-Payment details for an assignment, including the currency, the amount and the specific payment method.
Column Name	Descritpion
PRE_PAYMENT_ID	System-generated primary key column.
SOURCE_ACTION_ID	Foreign Key to PAY_ASSIGNMENT_ACTIONS. Used, for example, to identify part payments for a particular run type.
PREPAYMENT_ACTION_ID	Parent prepayment action
PERSONAL_PAYMENT_METHOD_ID	Foreign key to PAY_PERSONAL_PAYMENT_METHODS.
PAYROLL_ACTION_ID
ORGANIZATION_ID
ASSIGNMENT_ACTION_ID	Foreign key to PAY_ASSIGNMENT_ACTIONS.
PAYEES_ORG_PAYMENT_METHOD_ID
EFFECTIVE_DATE
ORG_PAYMENT_METHOD_ID	Foreign key to PAY_ORG_PAYMENT_METHODS.
VALUE	Value of payment in target currency.
BASE_CURRENCY_VALUE	Payment value in base currency.

Payroll - PAY_QUICKPAY_INCLUSIONS	List of element entries that can be included in a QuickPay run.
Column Name	Descritpion
ELEMENT_ENTRY_ID	Foreign key to PAY_ELEMENT_ENTRIES.
ASSIGNMENT_ACTION_ID	Foreign key to PAY_ASSIGNMENT_ACTIONS.

Payroll - PAY_RATES	Definitions of pay rates, or pay scales that may be applied to grades.
Column Name	Descritpion
RATE_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).
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
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
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
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
PARENT_SPINE_ID	Foreign key to PER_PARENT_SPINES. Known to users as Pay Scales.
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.
NAME	Name of the grade rate.
RATE_BASIS	Basis for pay rate
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
RATE_TYPE	The rate type.
ASG_RATE_TYPE	Categorizes the type of assignment rate such as "Overtime" or "Standard"
RATE_UOM	Unit of measure for the rate; number, integer or money.
COMMENTS	General remark.
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_RESTRICTION_PARAMETERS	Restrictions to the rows retrieved by a customized form.
Column Name	Descritpion
APPLICATION_ID	The Oracle application 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).
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.
FORM_NAME	The name of the form that can be customized.
RESTRICTION_CODE	The type of customization that can be applied.
MULTIPLE_RESTRICTIONS_FLAG	Indicates whether multiple restrictions apply.
EXCLUDE_ALLOWED_FLAG	Indicates whether the Exclude functionality is enabled for the restriction parameter.

Payroll - PAY_RESTRICTION_VALUES	The specific values to be used to customize a form.
Column Name	Descritpion
CUSTOMIZED_RESTRICTION_ID	System-generated primary key 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.
RESTRICTION_CODE	The customization type for which this row is a specific value.
VALUE	The specific value of the customization type.
INCLUDE_EXCLUDE_FLAG	Indicates whether this restriction is of type Include or Exclude.
REFERENCE_LEGISLATION_CODE	Legislation Code of the referenced restriction code

Payroll - PAY_RUN_RESULTS	Result of processing a single element entry.
Column Name	Descritpion
SOURCE_ID	Source element entry.
SOURCE_TYPE	For example, E-normal entry, I-indirect result.
STATUS	Processing status of the result.
JURISDICTION_CODE	US - Jurisdiction applying to the result.
START_DATE	Start date of the prorated result
END_DATE	End date of the Prorated result
ELEMENT_ENTRY_ID	Foreign key to PAY_ELEMENT_ENTRIES_F.
ENTRY_PROCESS_PATH
TIME_DEFINITION_ID	Foreign key to PAY_TIME_DEFINITIONS.
LOCAL_UNIT_ID	Foreign Key to HR_ORGANIZATION_UNITS.
RUN_RESULT_ID	Primary key.
ELEMENT_TYPE_ID	Foreign key to PAY_ELEMENT_TYPES.
ASSIGNMENT_ACTION_ID	Foreign key to PAY_ASSIGNMENT_ACTIONS.
ENTRY_TYPE	Denormalised from element entry.

Payroll - PAY_RUN_RESULT_VALUES	Result values from processing a single element entry.
Column Name	Descritpion
INPUT_VALUE_ID	Foreign key to PAY_INPUT_VALUES.
RUN_RESULT_ID	Foreign key to PAY_RUN_RESULTS.
RESULT_VALUE	The value of the result.
FORMULA_RESULT_FLAG	Indicates if the RESULT_VALUE was produced as a result of a Fast Formula calculation

Payroll - PAY_SECURITY_PAYROLLS	List of payrolls and security profile access rules.
Column Name	Descritpion
BUSINESS_GROUP_ID	Business Group for security profile.
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).
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.
SECURITY_PROFILE_ID	Security profile restricted by payroll.
PAYROLL_ID	Payroll accessible by the security profile.
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_STATUS_PROCESSING_RULES_F	Assignment status rules for processing specific elements.
Column Name	Descritpion
STATUS_PROCESSING_RULE_ID	System-generated primary key column.
COMMENT_ID	Foreign key to HR_COMMENTS.
LEGISLATION_SUBGROUP	Identifies the origin of the startup data for the processing rule.
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.
ASSIGNMENT_STATUS_TYPE_ID	Foreign key to PER_ASSIGNMENT_STATUS_TYPES. If the type is STANDARD then the rule applies to all assignment statuses.
FORMULA_ID	Foreign key to FF_FORMULAS.
PROCESSING_RULE	Indicates whether or not to process.

Payroll - PAY_SUB_CLASSIFICATION_RULES_F	Rules to determine the inclusion of an element in a secondary element classification.
Column Name	Descritpion
SUB_CLASSIFICATION_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.
EFFECTIVE_START_DATE	Effective start date.
EFFECTIVE_END_DATE	Effective end date.
ELEMENT_TYPE_ID	Foreign key to PAY_ELEMENT_TYPES_F.
CLASSIFICATION_ID	Foreign key to PAY_ELEMENT_CLASSIFICATIONS.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
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).

Payroll - PAY_USER_COLUMNS	Column definitions for user defined tables.
Column Name	Descritpion
USER_COLUMN_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.
USER_TABLE_ID	Foreign key to PAY_USER_TABLES.
FORMULA_ID	Foreign key to FF_FORMULAS_F.
USER_COLUMN_NAME	User name for the column.
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_USER_COLUMN_INSTANCES_F	Actual values for each row and column combination in a user defined table.
Column Name	Descritpion
USER_COLUMN_INSTANCE_ID	System-generated primary key 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.
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.
USER_ROW_ID	Foreign key to PAY_USER_ROWS.
USER_COLUMN_ID	Foreign key to PAY_USER_COLUMNS.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
LEGISLATION_SUBGROUP	Further identifies the legislation of startup data.
VALUE	Stored value.

Payroll - PAY_USER_ROWS_F	Row definitions for user defined tables.
Column Name	Descritpion
USER_ROW_ID	Surrogate primary key necessary due to DateTracked entity.
ROW_HIGH_RANGE	Upper value for range match of user key.
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.
USER_TABLE_ID	Foreign key to PAY_USER_TABLES.
ROW_LOW_RANGE_OR_NAME	Lower value for range match of user key, or actual value for exact match.
DISPLAY_SEQUENCE	Display sequence to use in preference to numeric/alpha order.
LEGISLATION_SUBGROUP	Further identifies the legislation of startup data.

Payroll - PAY_USER_TABLES	Table definitions for user defined tables.
Column Name	Descritpion
USER_TABLE_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.
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.
RANGE_OR_MATCH	Indicates whether the user key is exact match or within range.
USER_KEY_UNITS	Indicates the data type of the user key (number, date or character.
USER_TABLE_NAME	User name for the table.
LEGISLATION_SUBGROUP	Further identifies the legislation of startup data.
USER_ROW_TITLE	User title to appear above row values on form.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.

Payroll - PAY_STATE_RULES	US state tax information.
Column Name	Descritpion
WC_EXECUTIVE_WEEKLY_MAX	Workers compensation executive weekly limit.
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.
FS_LOOKUP_TYPE	Foreign key to HR_LOOKUPS lookup type. Identifies valid filing statuses for the state.
STATE_CODE	Abbreviation of the state name.
FIPS_CODE	Federal Information Processing Standard state code.
JURISDICTION_CODE	Extended geocode for the state.
NAME	State name.
HEAD_TAX_PERIOD	Period over which head tax is withheld.
WC_OVERTIME_HOURS	Flag to indicate whether overtime hour is to be included in the calculation of workers compensation.

Payroll - PAY_TAXABILITY_RULES	Taxability rules for categories of earnings and deductions.
Column Name	Descritpion
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.
CLASSIFICATION_ID	Foreign key to PAY_ELEMENT_CLASSIFICATIONS.
TAXABILITY_RULES_DATE_ID	Foreign key to PAY_TAXABILITY_RULES_DATES. Used to determine the length of time for which the taxability rules are valid. Allows for date-effective maintainence of rules.
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
STATUS	Determines whether the category is subject to tax. If set to 'D' then is not subject to tax.
SECONDARY_CLASSIFICATION_ID
JURISDICTION_CODE	Geocode of the jurisdiction: Federal or State.
TAX_TYPE	Type of tax the earnings or pre-tax deduction is subject to.
TAX_CATEGORY	Category of the earnings or pre-tax deduction, for example, Bonuses, Commissions.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.

Payroll - PAY_NET_CALCULATION_RULES	Element entry values which contribute to the net value of Paid Time Off.
Column Name	Descritpion
NET_CALCULATION_RULE_ID	System generated primary key for PAY_NET_CALCULATION_RULES.
ABSENCE_ATTENDANCE_TYPE_ID	Represents the absence type affecting accruals. Foreign key to PER_ABSENCE_ATTENDANCE_TYPES.
USE_ELEMENT_LINK	Determines whether the element link has been used when creating the PTO shadow elements (carry over, residual, tagging). It accepts "Yes" or "No".
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).
ACCRUAL_PLAN_ID	Foreign key to PAY_ACCRUAL_PLANS.
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.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
INPUT_VALUE_ID	Foreign key to PAY_INPUT_VALUES; the value to be included in the net calculation.
DATE_INPUT_VALUE_ID	Foreign key to PAY_INPUT_VALUES
ADD_OR_SUBTRACT	Add or subtract the input value when calculating the net value of PTO.

Payroll - PAY_US_COUNTIES	US counties and their VERTEX geocodes, used to validate US addresses.
Column Name	Descritpion
STATE_CODE	State geocode.
COUNTY_CODE	County geocode.
COUNTY_ABBREV	Abbreviation of county name.
COUNTY_NAME	County name.

Payroll - PAY_MAGNETIC_BLOCKS	Driving table for fixed format version of the magnetic tape process.
Column Name	Descritpion
MAGNETIC_BLOCK_ID	Surrogate primary key.
BLOCK_NAME	Descriptive block name.
MAIN_BLOCK_FLAG	Indicates whether the current block is the main entry block.
REPORT_FORMAT	Key from report format mapping table.
CURSOR_NAME	Holds package name.cursor name for driving cursor.
NO_COLUMN_RETURNED	Number of select values in cursor.

Payroll - PAY_MAGNETIC_RECORDS	Controls the detailed formatting of the fixed format version of the magnetic tape process.
Column Name	Descritpion
FORMULA_ID	Foreign key to PAY_FORMULAS.
BLOCK_LABEL
BLOCK_ROW_LABEL
MAGNETIC_BLOCK_ID	Foreign key to PAY_MAGNETIC_BLOCKS.
XML_PROC_NAME
NEXT_BLOCK_ID	Foreign key to PAY_MAGNETIC_BLOCKS.
OVERFLOW_MODE	Indicates whether the formula is run for each cursor row once only or more than once.
SEQUENCE	Sequence of formulas within a block.
FREQUENCY	Number of iterations within the block before the record is output.
LAST_RUN_EXECUTED_MODE	Specifies the rules for formula execution when the last row is retrieved from the cursor.
ACTION_LEVEL	Determines whether the record is precalculated due to multithreading.

Payroll - PAY_REPORT_FORMAT_MAPPINGS_F	Maps a report for a given jurisdiction to the fixed format defined for the magnetic tape.
Column Name	Descritpion
REPORT_FORMAT_MAPPING_ID	System generated primary key
ASSIGNMENT_ACTION_CODE	Contains name of the procedure used to create the assignment actions to be processed.
INITIALIZATION_CODE	Sets any global contexts that need to be set for the lifetime of the archiving. If this is NULL no archiving is performed.
ARCHIVE_CODE	Set contexts used during the archive.
MAGNETIC_CODE	Holds the driving PL/SQL procedure of the Magnetic Tape. If this is NULL no magnetic tape is produced.
REPORT_CATEGORY	Denotes the media type.
REPORT_NAME	The name of the report to be processed. If this is NULL no report is processed.
SORT_CODE	This is used to sort the assignment actions into the order in which they should appear in the report, if a report is being processed.
UPDATABLE_FLAG	Can archived data be modified (Y/N).
DEINITIALIZATION_CODE	Deinitializes any contexts set up by the initialization_code procedure.
TEMPORARY_ACTION_FLAG	Indicattes if the actions used bt the process are temporary
REPORT_TYPE	Report whose format is being mapped eg. W2.
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).
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.
REPORT_QUALIFIER	Refinement within report type eg. state for W2 reports.
REPORT_FORMAT	Fixed format to be used for the report for this qualifier.
EFFECTIVE_START_DATE	Effective start date.
EFFECTIVE_END_DATE	Effective end date.
BUSINESS_GROUP_ID	Business Group ID
LEGISLATION_CODE	Legislation Code
RANGE_CODE	Contains name of the procedure used to specify ranges of assignments to be processed in the archive.

Payroll - PAY_US_CITY_GEOCODES	Holds all distinct combinations of state code, county code and city code.
Column Name	Descritpion
STATE_CODE	Foreign key to PAY_US_COUNTIES.
COUNTY_CODE	Foreign key to PAY_US_COUNTIES.
CITY_CODE	Geocode representing a city.

Payroll - PAY_US_CITY_NAMES	US cities and their VERTEX geocodes, used to validate US addresses.
Column Name	Descritpion
CITY_NAME	City name.
LAST_UPDATE_DATE
LAST_UPDATED_BY
STATE_CODE	Foreign key to PAY_US_COUNTIES.
LAST_UPDATE_LOGIN
CREATED_BY
COUNTY_CODE	Foreign key to PAY_US_COUNTIES.
CREATION_DATE
CITY_CODE	Foreign key to PAY_US_CITY_GEOCODES.
PRIMARY_FLAG	Used when the geocode represents more than one city.
DISABLE	City name Disable option

Payroll - PAY_US_COUNTY_SCHOOL_DSTS	VERTEX geocodes for school districts that span counties.
Column Name	Descritpion
SCHOOL_DST_CODE	VERTEX geocode for county school district.
STATE_CODE	Foreign key to PAY_US_COUNTIES.
COUNTY_CODE	Foreign key to PAY_US_COUNTIES.
SCHOOL_DST_NAME	School district name.

Payroll - PAY_US_CITY_SCHOOL_DSTS	VERTEX geocodes for school districts within a city.
Column Name	Descritpion
SCHOOL_DST_CODE	VERTEX geocode for the school district.
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.
SCHOOL_DST_NAME	School district name.

Payroll - PAY_TEMP_BALANCE_ADJUSTMENTS	Holds temporary data used by the balance initialization process.
Column Name	Descritpion
BALANCE_TYPE_ID	Foreign key to PAY_BALANCE_TYPES.
EXPIRY_DATE	Date balance expires.
JURISDICTION_CODE	This is a geographical location context to the balance.
ORIGINAL_ENTRY_ID	Foreign key to PAY_ELEMENT_ENTRIES_F.
SOURCE_ID	Context of Source id
SOURCE_TEXT	Context of Source Text
RUN_TYPE_ID	Foreign key to PAY_RUN_TYPES_F.
BALANCE_DIMENSION_ID	Foreign key to PAY_BALANCE_DIMENSIONS.
SOURCE_NUMBER	Context of Source Number
SOURCE_TEXT2	Context of Source Text2
ELEMENT_LINK_ID	Foreign key to PAY_ELEMENT_LINKS_F.
JC_INPUT_VALUE_ID	Foreign key to PAY_INPUT_VALUES_F.
IBF_INPUT_VALUE_ID	Foreign key to PAY_INPUT_VALUES_F.
TAX_UNIT_ID	Foreign key to HR_ORGANIZATION_UNITS.
BATCH_LINE_ID	Foreign key to PAY_BALANCE_BATCH_LINES.
ADJUSTMENT_AMOUNT	The value by which the balance needs to be adjusted.
ADJUSTMENT_DATE	The date on which the balance needs to be adjusted.

Payroll - PAY_US_ASG_REPORTING	Denormalised performance table for accessing balances.
Column Name	Descritpion
ASSIGNMENT_ID	Foreign key to PER_ASSIGNMENTS.
EFFECTIVE_START_DATE	Effective start date.
EFFECTIVE_END_DATE	Effective end date.
JURISDICTION_CODE	Format XX-YYY-ZZZZ: XX - State, YYYY - County, ZZZZ - City.
TAX_UNIT_ID	Identifies the Government Reporting Entity, or Legal Entity for the assignment.

Payroll - PAY_TEST_CONTEXTS
Column Name	Descritpion
BUSINESS_GROUP_NAME
SESSIONID

Payroll - PAY_TEST_SUITE_USAGES
Column Name	Descritpion
SUITE_NAME
STAGE

Payroll - PAY_TEST_STAGES
Column Name	Descritpion
RUN_FLAG
THREADS
COMMENTS
STAGE_ID
STAGE
BUSINESS_GROUP_NAME
DATA_LOAD_PACKAGE
REFRESH

Payroll - PAY_TEST_STEPS
Column Name	Descritpion
PROCESS_NAME
COMMENTS
TEST_STEP_ID
STAGE
TESTID
STEPID

Payroll - PAY_TEST_PARAMETERS
Column Name	Descritpion
PARAMETER_NAME
PARAMETER_VALUE
TEST_PARAMETER_ID
STAGE
TESTID
STEPID

Payroll - PAY_TEST_PARAMETER_USAGES
Column Name	Descritpion
PROCESS_NAME
PARAMTER_USAGE_ID
MANDATORY
OPTIONAL
PARAMETER_NAME

Payroll - PAY_TEST_EXPIRY_INFO
Column Name	Descritpion
BALANCE_CONTEXTS
EXPIRY_INFORMATION
ASSIGNMENT_NUMBER
OWNER_EFFECTIVE_DATE
USER_EFFECTIVE_DATE
DIMENSION_NAME

Payroll - PAY_TEST_FEED_INFO
Column Name	Descritpion
FEED_FLAG
ASSIGNMENT_NUMBER
EFFECTIVE_DATE
DIMENSION_NAME
BALANCE_CONTEXTS

Payroll - PAY_TEST_RUNS
Column Name	Descritpion
SETUP_PROCEDURE
TEST_RES_PROCEDURE
COMMENTS
TEST_RUN_ID
STAGE
TESTID
RUN_TEST_FLAG

Payroll - PAY_US_CITY_TAX_INFO_F	Holds city tax information.
Column Name	Descritpion
CITY_TAX_INFO_ID	System-generated primary key 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).
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).
CITY_INFORMATION_CATEGORY	Developer descriptive flexfield
CITY_INFORMATION1	Developer descriptive flexfield
CITY_INFORMATION2	Developer descriptive flexfield
CITY_INFORMATION3	Developer descriptive flexfield
CITY_INFORMATION4	Developer descriptive flexfield
CITY_INFORMATION5	Developer descriptive flexfield
CITY_INFORMATION6	Developer descriptive flexfield
CITY_INFORMATION7	Developer descriptive flexfield
CITY_INFORMATION8	Developer descriptive flexfield
CITY_INFORMATION9	Developer descriptive flexfield
CITY_INFORMATION10	Developer descriptive flexfield
CITY_INFORMATION11	Developer descriptive flexfield
CITY_INFORMATION12	Developer descriptive flexfield
CITY_INFORMATION13	Developer descriptive flexfield
EFFECTIVE_START_DATE	Effective start date.
CITY_INFORMATION14	Developer descriptive flexfield
CITY_INFORMATION15	Developer descriptive flexfield
CITY_INFORMATION16	Developer descriptive flexfield
CITY_INFORMATION17	Developer descriptive flexfield
CITY_INFORMATION18	Developer descriptive flexfield
CITY_INFORMATION19	Developer descriptive flexfield
CITY_INFORMATION20	Developer descriptive flexfield
CITY_INFORMATION21	Developer descriptive flexfield
CITY_INFORMATION22	Developer descriptive flexfield
CITY_INFORMATION23	Developer descriptive flexfield
CITY_INFORMATION24	Developer descriptive flexfield
CITY_INFORMATION25	Developer descriptive flexfield
CITY_INFORMATION26	Developer descriptive flexfield
CITY_INFORMATION27	Developer descriptive flexfield
CITY_INFORMATION28	Developer descriptive flexfield
CITY_INFORMATION29	Developer descriptive flexfield
CITY_INFORMATION30	Developer descriptive flexfield
EFFECTIVE_END_DATE	Effective end date.
JURISDICTION_CODE	Full Jurisdiction geocode
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
CITY_ATTRIBUTE1	Descriptive flexfield column.
CITY_ATTRIBUTE2	Descriptive flexfield column.
CITY_ATTRIBUTE3	Descriptive flexfield column.
CITY_ATTRIBUTE4	Descriptive flexfield column.
CITY_ATTRIBUTE5	Descriptive flexfield column.
CITY_ATTRIBUTE6	Descriptive flexfield column.
CITY_ATTRIBUTE7	Descriptive flexfield column.
CITY_TAX	City tax exists for city (Y/N)
CITY_ATTRIBUTE8	Descriptive flexfield column.
CITY_ATTRIBUTE9	Descriptive flexfield column.
CITY_ATTRIBUTE10	Descriptive flexfield column.
CITY_ATTRIBUTE11	Descriptive flexfield column.
CITY_ATTRIBUTE12	Descriptive flexfield column.
CITY_ATTRIBUTE13	Descriptive flexfield column.
CITY_ATTRIBUTE14	Descriptive flexfield column.
CITY_ATTRIBUTE15	Descriptive flexfield column.
HEAD_TAX	Head Tax exists for city (Y/N)
CITY_ATTRIBUTE16	Descriptive flexfield column.
CITY_ATTRIBUTE17	Descriptive flexfield column.
CITY_ATTRIBUTE18	Descriptive flexfield column.
CITY_ATTRIBUTE19	Descriptive flexfield column.
CITY_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.
SCHOOL_TAX	School tax exists for city (Y/N)

Payroll - PAY_JP_PRE_TAX_OLD	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.
DISASTER_TAX_REDUCTION	Disaster Tax Reduction
SP_LTAX_DISTRICT_CODE	Special LTAX DISTRICT Code.
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_TAXABILITY_RULES_DATES	Maintains taxability rules date-effectively, to allow for end-of-year updates.
Column Name	Descritpion
TAXABILITY_RULES_DATE_ID	System generated primary-key column.
TAX_RULES_INFORMATION5	Developer descriptive flexfield column.
TAX_RULES_INFORMATION6	Developer descriptive flexfield column.
TAX_RULES_INFORMATION7	Developer descriptive flexfield column.
TAX_RULES_INFORMATION8	Developer descriptive flexfield column.
TAX_RULES_INFORMATION9	Developer descriptive flexfield column.
TAX_RULES_INFORMATION10	Developer descriptive flexfield column.
TAX_RULES_INFORMATION11	Developer descriptive flexfield column.
TAX_RULES_INFORMATION12	Developer descriptive flexfield column.
TAX_RULES_INFORMATION13	Developer descriptive flexfield column.
TAX_RULES_INFORMATION14	Developer descriptive flexfield column.
VALID_DATE_FROM	Start date of the length of time for which a set of taxability rules are valid.
TAX_RULES_INFORMATION15	Developer descriptive flexfield column.
TAX_RULES_INFORMATION16	Developer descriptive flexfield column.
TAX_RULES_INFORMATION17	Developer descriptive flexfield column.
TAX_RULES_INFORMATION18	Developer descriptive flexfield column.
TAX_RULES_INFORMATION19	Developer descriptive flexfield column.
TAX_RULES_INFORMATION20	Developer descriptive flexfield column.
TAX_RULES_INFORMATION21	Developer descriptive flexfield column.
TAX_RULES_INFORMATION22	Developer descriptive flexfield column.
TAX_RULES_INFORMATION23	Developer descriptive flexfield column.
TAX_RULES_INFORMATION24	Developer descriptive flexfield column.
VALID_DATE_TO	End date of he length of time for which a set of taxability rules are valid
TAX_RULES_INFORMATION25	Developer descriptive flexfield column.
TAX_RULES_INFORMATION26	Developer descriptive flexfield column.
TAX_RULES_INFORMATION27	Developer descriptive flexfield column.
TAX_RULES_INFORMATION28	Developer descriptive flexfield column.
TAX_RULES_INFORMATION29	Developer descriptive flexfield column.
TAX_RULES_INFORMATION30	Developer 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).
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
CREATION_DATE	Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER	System generated version of row. Increments by one with eah update.
TAX_RULES_INFORMATION_CATEGORY	Developer descriptive flexfield column.
TAX_RULES_INFORMATION1	Developer descriptive flexfield column.
TAX_RULES_INFORMATION2	Developer descriptive flexfield column.
TAX_RULES_INFORMATION3	Developer descriptive flexfield column.
TAX_RULES_INFORMATION4	Developer descriptive flexfield column.

Payroll - PAY_JP_SWOT_NUMBERS	Holds Japanese Tax Special Withholding Obligation Taxpayer Numbers.
Column Name	Descritpion
DISTRICT_CODE	Foreign key to PER_JP_ADDRESS_LOOKUPS.
REPORT_DISTRICT_CODE	Reporting District Code
SWOT_NUMBER	Unique identifier of special withholding obligation tax payer.
EFILE_EXCLUSIVE_FLAG	Efile Exclusive Flag for Salary Payment Report E-File
OUTPUT_FILE_NAME	Output File Name for Salary Payment Report E-File
IMPORT_EXCLUSIVE_FLAG
INPUT_FILE_NAME
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
ORGANIZATION_ID	Foreign key to HR_ALL_ORGANIZATION_UNITS.
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_SHADOW_BALANCE_TYPES	Element Template Shadow Balance Types
Column Name	Descritpion
BALANCE_TYPE_ID	System-generated primary key 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
ATTRIBUTE10	Descriptive flexfield segment
EXCLUSION_RULE_ID	Foreign key to PAY_TEMPLATE_EXCLUSION_RULES.
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.
ASSIGNMENT_REMUNERATION_FLAG	Indicates that the balance is used for assignment remuneration or for third party payments.
JURISDICTION_LEVEL	Indicates the jurisdiction level that applies to the balance type: federal, state, county or city - US-specific.
TAX_TYPE	Tax type of the balance (US-specific).
OBJECT_VERSION_NUMBER	Object version number column.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
TEMPLATE_ID	Foreign key to PAY_ELEMENT_TEMPLATES.
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.
CATEGORY_NAME	Name of the Balance Category
BALANCE_NAME	User name of balance.
BASE_BALANCE_TYPE_ID	Associated balance type to allow defined relationship
BASE_BALANCE_NAME	Associated balance name to allow defined relationship
INPUT_VALUE_ID	Foreign key to PAY_SHADOW_INPUT_VALUES for primary balance
BALANCE_UOM	Unit of measure, for example money.
CURRENCY_CODE	Currency code for this balance.
COMMENTS	Descriptive information about the balance type.
REPORTING_NAME	User's name for reporting purposes.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.

Payroll - PAY_SHADOW_FORMULAS	Element Template Shadow Formulas
Column Name	Descritpion
FORMULA_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.
FORMULA_TYPE_NAME	Name of the formula type.
TEMPLATE_TYPE	The element template type that this formula is used with.
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATIONS.
FORMULA_NAME	Name of the formula.
DESCRIPTION	Description of the formula.
FORMULA_TEXT	The text of the formula.
OBJECT_VERSION_NUMBER	Object version number column.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.

Payroll - PAY_TEMPLATE_CORE_OBJECTS	Keeps track of the core schema objects generated from an element template.
Column Name	Descritpion
TEMPLATE_CORE_OBJECT_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.
TEMPLATE_ID	Foreign key to PAY_ELEMENT_TEMPLATES.
CORE_OBJECT_TYPE	Type of generated core object.
CORE_OBJECT_ID	Primary key of the generated core object.
SHADOW_OBJECT_ID	Primary key of the shadow schema object used to generate the core schema object.
EFFECTIVE_DATE	Effective date of core object creation.
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).

Payroll - PAY_TEMPLATE_EXCLUSION_RULES	Controls the exclusion of an object from an Element Template
Column Name	Descritpion
EXCLUSION_RULE_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.
TEMPLATE_ID	Foreign key to PAY_ELEMENT_TEMPLATES.
FLEXFIELD_COLUMN	Configuration flexfield column on template against which the rule
EXCLUSION_VALUE	Value of configuration flexfield column for the exclusion to take
DESCRIPTION	Description of why this exclusion rule is present.
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).

Payroll - PAY_SHADOW_BALANCE_CLASSI	Element Template Shadow Balance Classifications
Column Name	Descritpion
BALANCE_TYPE_ID	Foreign key to PAY_SHADOW_BALANCE_TYPES.
CREATION_DATE	Standard who column - date when this row was created.
EXCLUSION_RULE_ID	Foreign key to PAY_TEMPLATE_EXCLUSION_RULES.
BALANCE_CLASSIFICATION_ID	System-generated primary key.
ELEMENT_CLASSIFICATION	Element classification for feeding the balance. Note: using name
SCALE	If 1, add to balance. If -1, subtract from balance.
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).

Payroll - PAY_SHADOW_DEFINED_BALANCES	Element Template Shadow Defined Balances
Column Name	Descritpion
DEFINED_BALANCE_ID	System-generated primary key.
CREATION_DATE	Standard who column - date when this row was created.
GROSSUP_ALLOWED_FLAG	Indicates if this element can be processed in a Net to Gross calculation.
EXCLUSION_RULE_ID	Foreign key to PAY_TEMPLATE_EXCLUSION_RULES.
BALANCE_TYPE_ID	Foreign key to PAY_SHADOW_BALANCE_TYPES.
DIMENSION_NAME	Name of dimension for this balance.
OBJECT_VERSION_NUMBER	Object version number column.
FORCE_LATEST_BALANCE_FLAG	Not currently supported in the core schema.
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_SHADOW_BALANCE_FEEDS	Element Template Shadow Balance Feeds
Column Name	Descritpion
BALANCE_FEED_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.
INPUT_VALUE_ID	Foreign key to PAY_SHADOW_INPUT_VALUES.
BALANCE_TYPE_ID	Foreign key to PAY_SHADOW_BALANCE_TYPES.
EXCLUSION_RULE_ID	Foreign key to PAY_TEMPLATE_EXCLUSION_RULES.
SCALE	Indicates whether the feed adds to or subtracts from a balance.
BALANCE_NAME	Name of an existing balance to be used instead of a shadow balance.
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).

Payroll - PAY_SHADOW_ELEMENT_TYPES	Element Template Shadow Element Type
Column Name	Descritpion
TEMPLATE_ID	Foreign key to PAY_ELEMENT_TEMPLATES.
MULTIPLY_VALUE_FLAG	Indicates whether entries can be multiplied, for example, holiday
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.
RELATIVE_PROCESSING_PRIORITY	Processing priority relative to the processing priority on the te
PROCESSING_TYPE	Indicates whether the element is recurring or nonrecurring.
STANDARD_LINK_FLAG	Indicates whether the default element link type is standard (Y) o
INPUT_CURRENCY_CODE	Foreign key to FND_CURRENCIES.
OUTPUT_CURRENCY_CODE	Foreign key to FND_CURRENCIES.
BENEFIT_CLASSIFICATION_NAME	Benefit classification name. Note: the name is used rather than t
DESCRIPTION	Brief description of the element type.
ELEMENT_TYPE_ID	System-generated primary key column.
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 ele
QUALIFYING_UNITS	Units of measurement for qualifying length of service.
REPORTING_NAME	Short name for the element, used in reports.
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
CLASSIFICATION_NAME	Element classification name. Note: the name is used rather than t
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
EXCLUSION_RULE_ID	Foreign key to PAY_TEMPLATE_EXCLUSION_RULES.
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ADDITIONAL_ENTRY_ALLOWED_FLAG	Indicates whether a recurring element can also have an additional nonrecurring entry of this type in any payroll period.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
PAYROLL_FORMULA_ID	Foreign key to PAY_SHADOW_FORMULAS.
ELEMENT_INFORMATION_CATEGORY	Developer descriptive flexfield column.
ELEMENT_INFORMATION1	Developer descriptive flexfield column.
ELEMENT_INFORMATION2	Developer descriptive flexfield column.
ELEMENT_INFORMATION3	Developer descriptive flexfield column.
ELEMENT_INFORMATION4	Developer descriptive flexfield column.
ADJUSTMENT_ONLY_FLAG	Indicates whether the element is used only for adjusting balances
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.
ELEMENT_INFORMATION12	Developer descriptive flexfield column.
ELEMENT_INFORMATION13	Developer descriptive flexfield column.
ELEMENT_INFORMATION14	Developer descriptive flexfield column.
CLOSED_FOR_ENTRY_FLAG	Indicates whether entries can be currently entered or updated.
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 onl
SKIP_FORMULA	Name of element skip formula for thiis element type.
ELEMENT_NAME	User name for the element type.
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.
ITERATIVE_FLAG	Indicates wether the element can be adjusted by iterative rules
ITERATIVE_PRIORITY	The order of the iterative adjustment processing for iterative elements
ITERATIVE_FORMULA_NAME	Name of the seeded iterative formula to be used
PROCESS_MODE	Denotes the type of processing which may be applied to this element e.g. separate check,separate payment or process separately.
GROSSUP_FLAG	Indicates if this element can be processed in a Net to Gross calculation.
ADVANCE_INDICATOR	Advance indicator for element type.
ADVANCE_PAYABLE	Advance payable flag.
ADVANCE_DEDUCTION	Advance deduction flag.
PROCESS_ADVANCE_ENTRY	Process advance entry flag.
INDIRECT_ONLY_FLAG	Indicates whether the element can be given to an assignment only as an indirect result from a formula.
PRORATION_GROUP	Name of the seeded proration group to be used.
PRORATION_FORMULA	Name of the seeded proration formula to be used.
RECALC_EVENT_GROUP	Name of the seeded recalculation event group to be used.
ONCE_EACH_PERIOD_FLAG	Indicates whether or not the element should only be
MULTIPLE_ENTRIES_ALLOWED_FLAG	Indicates whether an assignment can have multiple normal entries for this element at any one time.

Payroll - PAY_SHADOW_FORMULA_RULES	Element Template Shadow Formula Result Rules
Column Name	Descritpion
ELEMENT_TYPE_ID	Foreign key to PAY_SHADOW_ELEMENT_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).
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_NAME	Name of an element type created externally to this element template.
FORMULA_RESULT_RULE_ID	System-generated primary key column.
SHADOW_ELEMENT_TYPE_ID	Foreign key to PAY_SHADOW_ELEMENT_TYPES.
EXCLUSION_RULE_ID	Foreign key to PAY_TEMPLATE_EXCLUSION_RULES.
RESULT_NAME	Name of the variable returned by the formula.
INPUT_VALUE_ID	Foreign key to PAY_SHADOW_INPUT_VALUES.
RESULT_RULE_TYPE	Result type for the rule.
SEVERITY_LEVEL	Severity level for a message type result.
OBJECT_VERSION_NUMBER	Object version number column.

Payroll - PAY_SHADOW_INPUT_VALUES	Element Template Shadow Input Values
Column Name	Descritpion
ELEMENT_TYPE_ID	Foreign key to PAY_SHADOW_ELEMENT_TYPES.
DEFAULT_VALUE	Default for the input value on entry. The default may be overridd
MAX_VALUE	Maximum value allowed on entry (may be overridden).
MIN_VALUE	Minimum value allowed on entry (may be overridden).
WARNING_OR_ERROR	Indicates the kind of message to generate if input validation fai
DEFAULT_VALUE_COLUMN	Refers to one of the CONFIGURATION_INFORMATION flexfield columns that contains an override for DEFAULT_VALUE.
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).
EXCLUSION_RULE_ID	Foreign key to PAY_SHADOW_EXCLUSION_RULES.
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.
FORMULA_ID	Foreign key to PAY_SHADOW_FORMULAS.
INPUT_VALIDATION_FORMULA	Name of the input validation formula.
DISPLAY_SEQUENCE	Display sequence number for the input value.
INPUT_VALUE_ID	System-generated primary key column.
GENERATE_DB_ITEMS_FLAG	Indicates whether or not database items are generated for the inp
HOT_DEFAULT_FLAG	Indicates whether or not the default value is a HOT default.
MANDATORY_FLAG	Indicates whether or not the input value is required for an entry
NAME	User name for the input value.
UOM	Unit of measure for the input value (hours, monetary amount etc).
LOOKUP_TYPE	Lookup type for values restricted by lookup type.

Payroll - PAY_SHADOW_SUB_CLASSI_RULES	Element Template Shadow Sub-Classification Rules
Column Name	Descritpion
SUB_CLASSIFICATION_RULE_ID	System-generated primary key column.
ELEMENT_TYPE_ID	Foreign key to PAY_SHADOW_ELEMENT_TYPES.
ELEMENT_CLASSIFICATION	Element classification name. Note: the name is used rather than t
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.
EXCLUSION_RULE_ID	Foreign key to PAY_TEMPLATE_EXCLUSION_RULES.

Payroll - PAY_PATCH_STATUS	Used to track the application of patches.
Column Name	Descritpion
ID	System-generated primary key column.
LEGISLATION_CODE	Foreign Key to FND_TERRITORIES.
APPLICATION_RELEASE	Release of Application patch was applied in.
PREREQ_PATCH_NAME	Pre-requisite patch name
PATCH_NUMBER	ARU or Bug number of the patch
PATCH_NAME	Name of the patch
PHASE	Last successfully completed phase of a multi-phase patch to complete successfuly
PROCESS_TYPE	Indicates the type of patch. For example: Statutory update
APPLIED_DATE	The date on which the patch was initialy applied
STATUS	Status of the patch
DESCRIPTION	Description of the contents of the patch
UPDATE_DATE	Date of the most recent application of the patch

Payroll - PAY_ORG_PAYMENT_METHODS_F_TL	Translated payment method information
Column Name	Descritpion
ORG_PAYMENT_METHOD_ID	System generated primary key from PAY_ORG_PAYMENT_METHODS_F.
ORG_PAYMENT_METHOD_NAME	Translated name given to the payment method.
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.

Payroll - PAY_PAYMENT_TYPES_TL	Translated payment type details
Column Name	Descritpion
PAYMENT_TYPE_NAME	Translated name of the payment type.
DESCRIPTION	Translated description of payment 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).
PAYMENT_TYPE_ID	System-generated primary key from PAY_PAYMENT_TYPES.
CREATION_DATE	Standard who column - date when this row was created.

Payroll - PAY_ROUTE_TO_DESCR_FLEXS	Store of routes to Descriptive Flexfields
Column Name	Descritpion
APPLICATION_ID	Application identifier
DESCRIPTIVE_FLEXFIELD_NAME	Name of the Descriptive Flexfield
ROUTE_NAME	Name of the route.
USER_KEY	Name of the entity
DESCRIPTIVE_FLEX_CONTEXT_CODE	The context field value
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).
ROUTE_TO_DESCR_FLEXS_ID	Unique Identifier
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_US_CONTRIBUTION_HISTORY	Contribution History stores yearly consolidated contribution data for a Person per GRE per contribution type
Column Name	Descritpion
CONTR_HISTORY_ID	System-generated primary key column.
CONTR_INFORMATION13	Developer Descriptive flexfield column.
CONTR_INFORMATION14	Developer Descriptive flexfield column.
CONTR_INFORMATION15	Developer Descriptive flexfield column.
CONTR_INFORMATION16	Developer Descriptive flexfield column.
CONTR_INFORMATION17	Developer Descriptive flexfield column.
CONTR_INFORMATION18	Developer Descriptive flexfield column.
CONTR_INFORMATION19	Developer Descriptive flexfield column.
CONTR_INFORMATION20	Developer Descriptive flexfield column.
CONTR_INFORMATION21	Developer Descriptive flexfield column.
CONTR_INFORMATION22	Developer Descriptive flexfield column.
CONTR_INFORMATION23	Developer Descriptive flexfield column.
CONTR_INFORMATION24	Developer Descriptive flexfield column.
CONTR_INFORMATION25	Developer Descriptive flexfield column.
CONTR_INFORMATION26	Developer Descriptive flexfield column.
CONTR_INFORMATION27	Developer Descriptive flexfield column.
CONTR_INFORMATION28	Developer Descriptive flexfield column.
AMT_CONTR	Amount Contributed
CONTR_INFORMATION29	Developer Descriptive flexfield column.
CONTR_INFORMATION30	Developer 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).
PERSON_ID	Foreign Key to PER_PEOPLE_F
CREATION_DATE	Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER	Object Version Number
MAX_CONTR_ALLOWED	Maximum Contribution
INCLUDABLE_COMP	Incudable Compensation which is used to calculate the Maximum Contribution
DATE_FROM	Date From
SOURCE_SYSTEM	Source System
CONTR_INFORMATION_CATEGORY	Developer Descriptive flexfield structure defining column.
DATE_TO	Date To
CONTR_INFORMATION1	Developer Descriptive flexfield column.
CONTR_INFORMATION2	Developer Descriptive flexfield column.
CONTR_TYPE	Contribution Type
CONTR_INFORMATION3	Developer Descriptive flexfield column.
CONTR_INFORMATION4	Developer Descriptive flexfield column.
TAX_UNIT_ID	Government Reporting Entity, or Legal Entity
CONTR_INFORMATION5	Developer Descriptive flexfield column.
CONTR_INFORMATION6	Developer Descriptive flexfield column.
BUSINESS_GROUP_ID	Business Group ID
CONTR_INFORMATION7	Developer Descriptive flexfield column.
CONTR_INFORMATION8	Developer Descriptive flexfield column.
LEGISLATION_CODE	Legislation Code
CONTR_INFORMATION9	Developer Descriptive flexfield column.
CONTR_INFORMATION10	Developer Descriptive flexfield column.
CONTR_INFORMATION11	Developer Descriptive flexfield column.
CONTR_INFORMATION12	Developer Descriptive flexfield column.

Payroll - PAY_STAT_TRANS_AUDIT	This table is used to store the history of a transaction to meet the statutory requirement. e.g. For US Localization, the table stores the details of the W4 Changes done when an employee login from Self Service and modifies his records. Thi
Column Name	Descritpion
STAT_TRANS_AUDIT_ID	Primary Key for the Table
SOURCE1_TYPE	What is the column type which is in Source1 column e.g. JURISDICTION
SOURCE2	The 2nd value which is relevent for this transaction
SOURCE2_TYPE	Type of value in Souce2
SOURCE3	3rd value which is relevent for this transaction
SOURCE3_TYPE	Type of value in Souce3
SOURCE4	4th value which is relevent for this transaction
SOURCE4_TYPE	Type of value in Souce4
SOURCE5	5th value which is relevent for this transaction
SOURCE5_TYPE	Type of value in Souce5
TRANSACTION_PARENT_ID	If the main/parent transaction has caused few other updates. This coulmn will store the STAT_TRANS_AUDIT_ID for the parent record. e.g. for W4 if the Federal tax record is updates, the states which follow the federal will also be updated.
TRANSACTION_TYPE	Transaction type e.g. ONLINE_TAX_FORMS
AUDIT_INFORMATION_CATEGORY	Audit Information Category e.g. W4FED, W4STATE
AUDIT_INFORMATION1	Audit Information1
AUDIT_INFORMATION2	Audit Information2
AUDIT_INFORMATION3	Audit Information3
AUDIT_INFORMATION4	Audit Information4
AUDIT_INFORMATION5	Audit Information5
AUDIT_INFORMATION6	Audit Information6
AUDIT_INFORMATION7	Audit Information7
AUDIT_INFORMATION8	Audit Information8
AUDIT_INFORMATION9	Audit Information9
TRANSACTION_SUBTYPE	Transaction Subtype e.g. W4
AUDIT_INFORMATION10	Audit Information10
AUDIT_INFORMATION11	Audit Information11
AUDIT_INFORMATION12	Audit Information12
AUDIT_INFORMATION13	Audit Information13
AUDIT_INFORMATION14	Audit Information14
AUDIT_INFORMATION15	Audit Information15
AUDIT_INFORMATION16	Audit Information16
AUDIT_INFORMATION17	Audit Information17
AUDIT_INFORMATION18	Audit Information18
AUDIT_INFORMATION19	Audit Information19
TRANSACTION_DATE	Transaction Date
AUDIT_INFORMATION20	Audit Information20
AUDIT_INFORMATION21	Audit Information21
AUDIT_INFORMATION22	Audit Information22
AUDIT_INFORMATION23	Audit Information23
AUDIT_INFORMATION24	Audit Information24
AUDIT_INFORMATION25	Audit Information25
AUDIT_INFORMATION26	Audit Information26
AUDIT_INFORMATION27	Audit Information27
AUDIT_INFORMATION28	Audit Information28
AUDIT_INFORMATION29	Audit Information29
TRANSACTION_EFFECTIVE_DATE	Transaction Effective Date
AUDIT_INFORMATION30	Audit Information30
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.
TITLE	Title
OBJECT_VERSION_NUMBER	Object Version Number
BUSINESS_GROUP_ID	Business Group ID
PERSON_ID	Person ID
ASSIGNMENT_ID	Assignment ID
SOURCE1	The value which is relevent for this transaction.e.g. for W4 this coulumn is used to identify if the Federal or the State tax record was updated. So, we store the Federal jurisdiction code (00-000-0000) or the state jurisdiction_code (XX-00

Payroll - PAY_RUN_TYPE_USAGES_F	Holds child run types where the run type parent is of type Cumulative.
Column Name	Descritpion
CHILD_RUN_TYPE_ID	Foreign key for the child run type
EFFECTIVE_START_DATE	Effective start date.
EFFECTIVE_END_DATE	Effective end date.
SEQUENCE	The order in which run type will be processed.
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).
RUN_TYPE_USAGE_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.
PARENT_RUN_TYPE_ID	Foreign key for the parent run type
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.

Payroll - PAY_PROCESS_GROUP_ACTIONS	Processes within the Process Group
Column Name	Descritpion
SEQUENCE	Sequence number for the processing. Also part of the Primary Key.
AOL_PROCESS_NAME	Name of the AOL executable to be used.
ARGUMENT_LIST	Select statement that defines the arguments to be used with this process.
PROCESS_GROUP_ID	System Generated Primary Key

Payroll - PAY_PROCESS_GROUPS	Defines groups of processes
Column Name	Descritpion
GROUP_NAME	Name of the Processing Group
BUSINESS_GROUP_ID	Foreign Key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE	Foreign Key to FND_TERRITORIES.
DESCRIPTION	Free text description for user entry.
PROCESS_GROUP_ID	System-generated primary key column.

Payroll - PAY_RUN_TYPES_F	The different types of Payroll Run processing
Column Name	Descritpion
RUN_INFORMATION3	Descriptive flexfield segment column.
RUN_INFORMATION4	Descriptive flexfield segment column.
RUN_TYPE_NAME	Name of the run type.
RUN_INFORMATION5	Descriptive flexfield segment column.
RUN_INFORMATION6	Descriptive flexfield segment column.
RUN_INFORMATION7	Descriptive flexfield segment column.
RUN_INFORMATION8	Descriptive flexfield segment column.
RUN_INFORMATION9	Descriptive flexfield segment column.
RUN_INFORMATION10	Descriptive flexfield segment column.
RUN_INFORMATION11	Descriptive flexfield segment column.
RUN_INFORMATION12	Descriptive flexfield segment column.
RUN_INFORMATION13	Descriptive flexfield segment column.
RUN_INFORMATION14	Descriptive flexfield segment column.
RUN_METHOD	Run type category, either 'Normal', 'Separate Payment','Process Separately' or 'Cumulative'.
RUN_INFORMATION15	Descriptive flexfield segment column.
RUN_INFORMATION16	Descriptive flexfield segment column.
RUN_INFORMATION17	Descriptive flexfield segment column.
RUN_INFORMATION18	Descriptive flexfield segment column.
RUN_INFORMATION19	Descriptive flexfield segment column.
RUN_INFORMATION20	Descriptive flexfield segment column.
RUN_INFORMATION21	Descriptive flexfield segment column.
RUN_INFORMATION22	Descriptive flexfield segment column.
RUN_INFORMATION23	Descriptive flexfield segment column.
RUN_INFORMATION24	Descriptive flexfield segment column.
EFFECTIVE_START_DATE	Effective start date.
RUN_INFORMATION25	Descriptive flexfield segment column.
RUN_INFORMATION26	Descriptive flexfield segment column.
RUN_INFORMATION27	Descriptive flexfield segment column.
RUN_INFORMATION28	Descriptive flexfield segment column.
RUN_INFORMATION29	Descriptive flexfield segment column.
RUN_INFORMATION30	Descriptive flexfield segment column.
EFFECTIVE_END_DATE	Effective end date.
BUSINESS_GROUP_ID	Business group id
LEGISLATION_CODE	Legislation code
SHORTNAME	A shortname or label for the run type.
SRS_FLAG	Flag to indicate if a run type can be used in Standard Report Submission
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).
RUN_TYPE_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.
RUN_INFORMATION_CATEGORY	Descriptive flexfield structure defining column.
RUN_INFORMATION1	Descriptive flexfield segment column.
RUN_INFORMATION2	Descriptive flexfield segment column.

Payroll - PAY_TRIGGER_EVENTS	Definitions of triggers that are dynamically generated
Column Name	Descritpion
TABLE_NAME	Name of the table on which the trigger will be created. This value may not be updated once the record has been created. The trigger name will be dynamically derived according to the following format; __DYT, where TABLE_N
SHORT_NAME	The user-key or pseudo-key of the triggers table. Allows users to allocate short descriptive names totriggers providing an easy method of searching the list of trigger definitions for maintenance purposes.
DESCRIPTION	A textual description of the trigger which will be added, as a comment, to the trigger body code.
GENERATED_FLAG	Holds Y if the trigger has been generated into the database, otherwise holds N.
ENABLED_FLAG	Holds Y if the trigger has been generated in to the database and is enabled. If the trigger is not generated or is disabled this flag will hold the value N.
PROTECTED_FLAG	Designed to allow seeded triggers that aren't necessarily created dynamically, to be treated as if they were. I.e. Viewed within the forms but no changes can be made.
TRIGGERING_ACTION	Contains I, U or D to determine whether the trigger fires on Insert, Update or Delete. This value cannot be updated once the row has been created. This character makes up part of the trigger name. All triggers will fire after the row has
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_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_TRIGGER_DECLARATIONS	Variables declared in dynamic triggers
Column Name	Descritpion
EVENT_ID	Foreign key to PAY_TRIGGER_EVENTS.
VARIABLE_NAME	The name of the variable to be defined. Any name entered here will have the text l_ prepended to it. In-line initialisation of variables is not permitted.
DATA_TYPE	The type of the variable to declare, either C, N or D for Character (VARCHAR2), Number or Date respectively.
VARIABLE_SIZE	The size of the variable to declare. Sizes can only be specified for Character type variables.
DECLARATION_ID	System-generated primary key column.

Payroll - PAY_TRIGGER_COMPONENTS	Stored procedures that are executed from dynamic triggers
Column Name	Descritpion
EVENT_ID	Foreign key to PAY_TRIGGER_EVENTS.
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
BUSINESS_GROUP_ID	The business_group_id value for the current row. Only required for business specific components. Foreign key to HR_ORGANIZATION_UNITS.
PAYROLL_ID	A foreign key to PAY_ALL_PAYROLLS_F indicating whether this component is relevant to a particular payroll or not.
MODULE_NAME	The name of the procedure to call if this component is in context. (I.e. The legislation and business are correct for this component.) This can be a standalone procedure name or a package.procedure type reference to a procedure stored in
ENABLED_FLAG	Allows separate parts of the trigger to be switched on and off whilst still maintaining a record of a components' definition. The trigger will require re-generation if any component is switched on or if an existing component is switched of
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).
COMPONENT_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_TRIGGER_INITIALISATIONS	How dynamically generated triggers initialise their local variables
Column Name	Descritpion
EVENT_ID	Foreign key to PAY_TRIGGER_EVENTS.
PROCESS_ORDER	Because one initialisation can depend on the value of another variable, the user can specify the order in which these processing steps will take place.
PLSQL_CODE	The code to be executed for this step. Depending on the value of the PROCESS_TYPE column this will be interpreted in the following ways;F - This is the name of a function which returns the value to be used for initialisation.P - This is t
PROCESS_TYPE	This determines how the PLSQL_CODE value is interpreted. It can take one of the following values;F - The initialisation is done via a function call.P - The initialisation is done via a procedure call.S - A SQL SELECT statement is used for
INITIALISATION_ID	System-generated primary key column.

Payroll - PAY_TRIGGER_SUPPORT	Allows support package for dynamically generated trigger to be linked to the trigger
Column Name	Descritpion
EVENT_ID	Foreign key to PAY_TRIGGER_EVENTS.
HEADER_CODE	Package header pl/sql code
BODY_CODE	Package body pl/sql code
SUPPORT_ID	System-generated primary key column.

Payroll - PAY_TRIGGER_PARAMETERS	Parameter mappings for dynamically generated procedure and function calls
Column Name	Descritpion
USAGE_TYPE	Defines the way in which the mapping will be interpreted;I - The mapping is used by a row in the initialisations entity.C - The mapping is used by a row in the components entity.
USAGE_ID	A soft foreign key to either component_id or initialisation_id depending on the value of usage_type.
PARAMETER_TYPE	How this parameter mapping will be used;R - Return. Only valid for I-type usages where the initialisation is if type F, S, A. The mapping defines the local variable into which the function, assignment or select list item will return it's
PARAMETER_NAME	The name of the function or procedure parameter to map, or the name of a placeholder in an SQL or PL/SQL statement. This value will be automatically populated based on the usage of the mapping and the user will not be permitted to change i
VALUE_NAME	The full name of the local or bind variable to map to the parameter, placeholder or return value. This should include the l_, :old, :new prefix. Where possible these values will be automatically generated based on name matching but they m
AUTOMATIC	A Y or N flag indicating that this mapping was automatically generated, this allows the mapping to be changed if the automatic mapper is called again for this usage. If the user changes the mapping in any way then this flag is changed to N
PARAMETER_ID	System-generated primary key column.

Payroll - PAY_SHADOW_ITERATIVE_RULES	Element Template Shadow Iterative Rules
Column Name	Descritpion
ITERATIVE_RULE_ID	System generated Primary Key column
ELEMENT_TYPE_ID	Foreign Key to PAY_SHADOW_ELEMENT_TYPES
RESULT_NAME	Variable name returned fom the iterative Fast Formula
ITERATIVE_RULE_TYPE	Denotes how the results of the formula are processed
INPUT_VALUE_ID	Foreign Key to PAY_SHADOW_INPUT_VALUES
SEVERITY_LEVEL	Indicates message returned if process value is not valid.
EXCLUSION_RULE_ID	Exclusion Rule for this Iterative Rule
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).
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).
OBJECT_VERSION_NUMBER	Object Version Number

Payroll - PAY_SHADOW_GU_BAL_EXCLUSIONS	Element Template Grossup Balance Exclusions
Column Name	Descritpion
SOURCE_ID	Foreign Key to PAY_SHADOW_ELEMENT_TYPES
SOURCE_TYPE	Should always be 'ET' for 'Element Type'
BALANCE_TYPE_NAME	Name of a seeded Balance Type
BALANCE_TYPE_ID	Foreign Key to PAY_SHADOW_BALANCE_TYPES
EXCLUSION_RULE_ID	Exclusion rule for this grossup balance exclusion
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	Primary Key for PAY_SHADOW_GU_BAL_EXCLUSIONS
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).
OBJECT_VERSION_NUMBER	Object Version Number

Payroll - PAY_SHADOW_ELE_TYPE_USAGES	Element Template Shadow Element Type Usages
Column Name	Descritpion
ELEMENT_TYPE_USAGE_ID	Primary Key for PAY_SHADOW_ELE_TYPE_USAGES
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
OBJECT_VERSION_NUMBER	Object Version Number
ELEMENT_TYPE_ID	Foreign Key to PAY_SHADOW_ELEMENT_TYPES
INCLUSION_FLAG	Indicates if the shadow element is included in this run type
RUN_TYPE_NAME	Name of seeded run type.
EXCLUSION_RULE_ID	Exclusion rule for this shadow element type usage
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).
CREATION_DATE	Standard who column - date when this row was created.

Payroll - PAY_MONITOR_BALANCE_RETRIEVALS	Monitors the source of balance retrievals
Column Name	Descritpion
MODULE_NAME	Session monitor name or default 'Monitoring all calls to route'.
DATE_MONITORED	System date of the monitored session.
DEFINED_BALANCE_ID	Balance being retrieved. Foreign key to PAY_DEFINED_BALANCES.
ASSIGNMENT_ACTION_ID	Foreign key to PAY_ASSIGNMENT_ACTIONS.
REASON	Free text for user entry.

Payroll - PAY_REPORT_FORMAT_ITEMS_F	Individual items for the report mapping.
Column Name	Descritpion
REPORT_QUALIFIER	Foreign key to PAY_REPORT_FORMAT_MAPPINGS_F
REPORT_CATEGORY	Foreign key to PAY_REPORT_FORMAT_MAPPINGS_F
USER_ENTITY_ID	Foreign key to FF_USER_ENTITIES.
EFFECTIVE_START_DATE	Effective start date.
EFFECTIVE_END_DATE	Effective end date.
ARCHIVE_TYPE	Source of archive value.
UPDATABLE_FLAG	Can archived data be modified (Y/N).
DISPLAY_SEQUENCE	Order of items for display
REPORT_TYPE	Foreign key to PAY_REPORT_FORMAT_MAPPINGS_F.
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).
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.
REPORT_FORMAT_ITEM_ID	System generated primary key

Payroll - PAY_LEGISLATION_CONTEXTS	Maps core contexts to legislative names
Column Name	Descritpion
CONTEXT_ID	Foreign key to FF_CONTEXTS.
LEGISLATION_NAME	Context name used by the legislation
INPUT_VALUE_NAME	Input Value Name used to identify the context value
LEGISLATION_CODE	Identifies legislation owning the definition

Payroll - PAY_RUN_TYPE_ORG_METHODS_F	Organisation level payment methods associated with a particular run type.
Column Name	Descritpion
ORG_PAYMENT_METHOD_ID	Foreign key to PAY_ORG_PAYMENT_METHODS_F
EFFECTIVE_START_DATE	Effective start date.
RUN_TYPE_ORG_METHOD_ID	Primary key
EFFECTIVE_END_DATE	Effective end date.
BUSINESS_GROUP_ID	Business group
LEGISLATION_CODE	Legislation code
PRIORITY	Priority order for different payment methods for a run type.
PERCENTAGE	Percentage to be allocated if there is more than one payment method.
AMOUNT	Fixed amount to be allocated if more than one payment method.
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).
RUN_TYPE_ID	Foreign key to PAY_RUN_TYPES_F
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_LINK_INPUT_VALUES_F_EFC	This is a copy of the PAY_LINK_INPUT_VALUES_F table which is populated by the EFC (Euro as a Functional Currency) process.
Column Name	Descritpion
LINK_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_PAYROLL_ACTIONS_EFC	This is a copy of the PAY_PAYROLL_ACTIONS table which is populated by the EFC (Euro as a Functional Currency) process.
Column Name	Descritpion
PAYROLL_ACTION_ID	Unique identifier from the base table.
EFC_ACTION_ID	Foreign key to HR_EFC_ACTIONS
PAYMENT_TYPE_ID	Foreign key to PAY_PAYMENT_TYPES.
CURRENCY_CODE	Currency code before the conversion.

Payroll - PAY_PRE_PAYMENTS_EFC	This is a copy of the PAY_PRE_PAYMENTS table which is populated by the EFC (Euro as a Functional Currency) process.
Column Name	Descritpion
PRE_PAYMENT_ID	Unique identifier from the base table.
EFC_ACTION_ID	Foreign key to HR_EFC_ACTIONS
VALUE	Value before conversion.
BASE_CURRENCY_VALUE	Value before conversion.
PBT_CURRENCY_CODE	Balance Type currency before conversion.
OPM_CURRENCY_CODE	Org Payment Method currency before conversion.
OUTPUT_CURRENCY_CODE	Output currency before the conversion.
CURRENCY_CODE	Currency before the conversion.

Payroll - PAY_RUN_TYPE_ORG_METHODS_F_EFC	This is a copy of the PAY_RUN_TYPE_ORG_METHODS_F table which is populated by the EFC (Euro as a Functional Currency) process.
Column Name	Descritpion
EFFECTIVE_START_DATE	Effective start date.
EFFECTIVE_END_DATE	Effective end date.
OUTPUT_CURRENCY_CODE	Output currency before conversion.
AMOUNT	Value from base table before conversion.
CURRENCY_CODE	Conversion currency code
EFC_ACTION_ID	Foreign key to HR_EFC_ACTIONS
RUN_TYPE_ORG_METHOD_ID	Unique identifier from the base table.

Payroll - PAY_RUN_RESULT_VALUES_EFC	This is a copy of the PAY_RUN_RESULT_VALUES table which is populated by the EFC (Euro as a Functional Currency) process.
Column Name	Descritpion
INPUT_VALUE_ID	Composite unique identifier from the base table.
RUN_RESULT_ID	Composite unique identifier from the base table.
EFC_ACTION_ID	Foreign key to HR_EFC_ACTIONS
RESULT_VALUE	Value before conversion.
OUTPUT_CURRENCY_CODE	Currency before conversion

Payroll - PAY_PERSONAL_PAYMENT_METHO_EFC	This is a copy of the PAY_PERSONAL_PAYMENT_METHODS_F table which is populated by the EFC (Euro as a Functional Currency) process.
Column Name	Descritpion
PERSONAL_PAYMENT_METHOD_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
OUTPUT_CURRENCY_CODE	Output currency before the conversion.
AMOUNT	Amount before the conversion.
CURRENCY_CODE	Currency code before the conversion.

Payroll - PAY_ORG_PAYMENT_METHODS_F_EFC	This is a copy of the PAY_ORG_PAYMENT_METHODS_F table which is populated by the EFC (Euro as a Functional Currency) process.
Column Name	Descritpion
ORG_PAYMENT_METHOD_ID	Unique identifier from the base table.
EFC_ACTION_ID	Foreign key to HR_EFC_ACTIONS
EFFECTIVE_START_DATE	Start date from the base table.
EFFECTIVE_END_DATE	End date from the base table.
PAYMENT_TYPE_ID	Foreign key to PAY_PAYMENT_TYPES.
CURRENCY_CODE	Currency code before the conversion.

Payroll - PAY_RETRO_NOTIF_REPORTS	Populated and used in the RetroNotification Report
Column Name	Descritpion
PAYROLL_ID	Foreign key to PAY_PAYROLLS_F
REPORT_DATE	Effective date of the report execution
ASSIGNMENT_ID	Foreign key to PER_ASSIGNMENTS_F
ELEMENT_ENTRY_ID	Foreign key to PAY_ELEMENT_ENTRIES_F
EVENT_GROUP_ID	Foreign key to PAY_EVENT_GROUPS
DATE_PROCESSED	Report date processed
DATE_EARNED	Report date earned
CHANGE_TYPE	Type of event change processed
REPORT_ID	RetroNotification unique identifier
ASSIGNMENT_SET_ID	Id of generated assignment set
BUSINESS_GROUP_ID	Business Group identifier for the report

Payroll - PAY_PROCESS_EVENTS	Process event capture table.
Column Name	Descritpion
ASSIGNMENT_ID	Assignment for which the event was detected.
EFFECTIVE_DATE	Effective date of event.
CHANGE_TYPE	Type of change detected.
STATUS	Has this record been subsequently processed
DESCRIPTION	Brief description of the event change
EVENT_UPDATE_ID	Foreign key to PAY_EVENT_UPDATES
BUSINESS_GROUP_ID	Business Group triggering the event
ORG_PROCESS_EVENT_GROUP_ID	Not currently used.
PROCESS_EVENT_ID	System-generated primary key column.
SURROGATE_KEY	Column that triggered to event monitor
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.
CALCULATION_DATE	Date event was processed
RETROACTIVE_STATUS	Has the event been processed in RetroNotification
NOTED_VALUE	A value from the originated row that is needed in the case of a delete.

Payroll - PAY_REPORT_TOTALS	A temporary table to be used in T4/T4A/RL1 Register Report.
Column Name	Descritpion
PAYROLL_ACTION_ID	Foreign key to PAY_PAYROLL_ACTIONS
INFORMATION_VALUE2	Report total value
INFORMATION_VALUE3	Report total value
INFORMATION_VALUE4	Report total value
INFORMATION_VALUE5	Report total value
ATTRIBUTE_TYPE	Report total identifier
ATTRIBUTE_VALUE	Report total identifier value
BUSINESS_GROUP_ID	Business Group the totals relate to
ASSIGNMENT_ACTION_ID	Foreign key to PAY_ASSIGNMENT_ACTIONS
INFORMATION_TYPE1	Report total attribute
INFORMATION_TYPE2	Report total attribute
INFORMATION_TYPE3	Report total attribute
INFORMATION_TYPE4	Report total attribute
INFORMATION_TYPE5	Report total attribute
INFORMATION_VALUE1	Report total value

Payroll - PAY_PSS_TRANSACTION_STEPS	Table holding (denormalised) work-in-progress for Payroll Payments self-service.
Column Name	Descritpion
AMOUNT	The proposed amount value.
EXTERNAL_ACCOUNT_ID	Reference to the proposed bank details in PAY_EXTERNAL_ACCOUNTS.
TRANSACTION_ID	System-generated value that groups a set of rows together into a transaction.
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
SOURCE_TABLE	Payments table from which the data is stored.
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	Proposed descriptive flex segment.
ATTRIBUTE17	Proposed descriptive flex segment.
ATTRIBUTE18	Proposed descriptive flex segment.
ATTRIBUTE19	Proposed descriptive flex segment.
STATE	The state of this transaction step.
ATTRIBUTE20	Proposed descriptive flex segment.
O_REAL_PRIORITY	The current actual priority for the payment.
O_LOGICAL_PRIORITY	The current priority for display to the user.
O_AMOUNT_TYPE	Whether the current amount is monetary or a percentage of net pay.
O_AMOUNT	The current amount value.
O_EXTERNAL_ACCOUNT_ID	Reference to the current bank details in PAY_EXTERNAL_ACCOUNTS.
O_ATTRIBUTE_CATEGORY	Current Payments descriptive flex context.
O_ATTRIBUTE1	Current Payments descriptive flex segment.
O_ATTRIBUTE2	Current Payments descriptive flex segment.
O_ATTRIBUTE3	Current Payments descriptive flex segment.
PERSONAL_PAYMENT_METHOD_ID	Primary key for existing payment method.
O_ATTRIBUTE4	Current Payments descriptive flex segment.
O_ATTRIBUTE5	Current Payments descriptive flex segment.
O_ATTRIBUTE6	Current Payments descriptive flex segment.
O_ATTRIBUTE7	Current Payments descriptive flex segment.
O_ATTRIBUTE8	Current Payments descriptive flex segment.
O_ATTRIBUTE9	Current Payments descriptive flex segment.
O_ATTRIBUTE10	Current Payments descriptive flex segment.
O_ATTRIBUTE11	Current Payments descriptive flex segment.
O_ATTRIBUTE12	Current Payments descriptive flex segment.
O_ATTRIBUTE13	Current Payments descriptive flex segment.
UPDATE_OVN	OBJECT_VERSION_NUMBER required for updates.
O_ATTRIBUTE14	Current Payments descriptive flex segment.
O_ATTRIBUTE15	Current Payments descriptive flex segment.
O_ATTRIBUTE16	Current Payments descriptive flex segment.
O_ATTRIBUTE17	Current Payments descriptive flex segment.
O_ATTRIBUTE18	Current Payments descriptive flex segment.
O_ATTRIBUTE19	Current Payments descriptive flex segment.
O_ATTRIBUTE20	Current Payments descriptive flex segment.
RUN_TYPE_ID	Foreign key to PAY_RUN_TYPES.
DELETE_OVN	OBJECT_VERSION_NUMBER used for deletes.
UPDATE_DATETRACK_MODE	Datetrack mode used for updates.
DELETE_DATETRACK_MODE	Datetrack mode used for deletes.
DELETE_DISABLED	Whether or not deletes are allowed for this payment method.
EFFECTIVE_DATE	Effective date of updates/creates.
TRANSACTION_STEP_ID	System-generated primary key column.
ORG_PAYMENT_METHOD_ID	ORG_PAYMENT_METHOD_ID used in this transaction step.
ASSIGNMENT_ID	The assignment that this payment method relates to.
PAYMENT_TYPE	The payment type of this payment.
CURRENCY_CODE	The currency for this payment.
TERRITORY_CODE	The territory for this payment.
REAL_PRIORITY	The actual priority value to be allocated to this payment when it is updated.
LOGICAL_PRIORITY	The proposed priority displayed to the user.
AMOUNT_TYPE	Whether the proposed amount is monetary or a percentage of net pay.

Payroll - PAY_PURGE_ACTION_TYPES	Details of the processing order required to purge action types.
Column Name	Descritpion
CATEGORY	Processing category of the purge action type.
PROCESSING_ORDER	Determines the order of the action types to be purged.
ACTION_TYPE	Type of payroll action.

Payroll - PAY_RUN_TYPES_F_TL	Translated run type descriptions
Column Name	Descritpion
LANGUAGE	Language of translation.
SOURCE_LANG	Source language of the row.
RUN_TYPE_NAME	Translated name given to the run type.
SHORTNAME	Translated shortname for the run type.
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).
RUN_TYPE_ID	Primary key
CREATION_DATE	Standard who column - date when this row was created.

Payroll - PAY_PURGE_ROLLUP_BALANCES	Populated during Purge. Stores details of the balance values being removed.
Column Name	Descritpion
DEFINED_BALANCE_ID	Foreign key to PAY_DEFINED_BALANCES.
JURISDICTION_CODE	US only. Jurisdiction applying to the value.
TAX_UNIT_ID	Tax Unit identifier.
ORIGINAL_ENTRY_ID	Foreign key to element entry.
SOURCE_ID	Source foreign key based on the source type.
SOURCE_TEXT	For example, E-normal entry, I-indirect result.
VALUE	Value of the rolled up balance
ASSIGNMENT_ACTION_ID	Foreign key to PAY_ASSIGNMENT_ACTIONS.

Payroll - PAY_RUN_BALANCES	Store of run level balances.
Column Name	Descritpion
DEFINED_BALANCE_ID	Foreign key to pay_defined_balances.
EFFECTIVE_DATE	Effective date of the associated payroll action.
BALANCE_VALUE	The balance value.
ASSIGNMENT_ACTION_ID	Foreign key to pay_assignment_actions.
ASSIGNMENT_ID	Associated assignment id.
ACTION_SEQUENCE	The action sequence for the assignment action id.
PAYROLL_ACTION_ID	Associated payroll action id.
TAX_UNIT_ID	Government Reporting Entity, or Legal Entity context value for the balance.
JURISDICTION_CODE	Jurisdiction context value for the balance.
JURISDICTION_COMP1	Jurisdiction context value for the balance split into component parts.
RUN_BALANCE_ID	System generated primary key
JURISDICTION_COMP2	Jurisdiction context value for the balance split into component parts.
JURISDICTION_COMP3	Jurisdiction context value for the balance split into component parts.
SOURCE_ID	Source id context value for the balance.
SOURCE_NUMBER	Source Number context value for the balance.
SOURCE_NUMBER2	Source Number2 context value for the balance.
SOURCE_TEXT	Source text context value for the balance.
SOURCE_TEXT2	Source text2 context value for the balance.
TIME_DEFINITION_ID	Foreign Key to PAY_TIME_DEFINITIONS.
BALANCE_DATE	Value of the Balance Date Context
TAX_GROUP	Tax group context value for the balance.
LOCAL_UNIT_ID	Local Unit context value for the balance
ORGANIZATION_ID	Third Party Payee Organization context value for the balance

Payroll - PAY_RECORDED_REQUESTS	Dated process information.
Column Name	Descritpion
RECORDED_DATE	The associated date for this process.
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
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.
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.
RECORDED_REQUEST_ID	The system generated primary key.

Payroll - PAY_QUICKPAY_EXCLUSIONS	List of element entries that are to be excluded from a QuickPay run.
Column Name	Descritpion
ASSIGNMENT_ACTION_ID	Foreign key to PAY_ASSIGNMENT_ACTIONS.
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_ENTRY_ID	Foreign key to PAY_ELEMENT_ENTRIES.

Payroll - PAY_RETRO_ASSIGNMENTS	Identifies assignment for reprocessing
Column Name	Descritpion
ASSIGNMENT_ID	Foreign key to PER_ALL_ASSIGNMENTS_F
REPROCESS_DATE	The earliest effective date of all retrospective events Interpreted on child entries.
START_DATE	Earliest start date for for events that have been Interpreted
APPROVAL_STATUS	An indicator of the manual intervention in confirming this Assignment for re-processing.
SUPERSEDING_RETRO_ASG_ID	If this Retro-Assignment is superceded the parent identifier is given here.
RETRO_ASSIGNMENT_ACTION_ID	The Foreign key to PAY_ASSIGNMENT_ACTIONS
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.
RETRO_ASSIGNMENT_ID	Unique Identifier for Retro-Assignment row.
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

Payroll - PAY_RETRO_COMPONENTS
Column Name	Descritpion
SHORT_NAME
COMPONENT_NAME
RETRO_TYPE
LEGISLATION_CODE
RECALCULATION_STYLE	Indicates the type of RetroPay calculation required.
DATE_OVERRIDE_PROCEDURE	Indicates the procedure used to derive the override date.
RETRO_COMPONENT_ID

Payroll - PAY_RETRO_COMPONENT_USAGES
Column Name	Descritpion
RETRO_COMPONENT_ID	Foreign key to PAY_RETRO_COMPONENTS
CREATOR_ID	Foreign key to record determined by CREATOR_TYPE
CREATOR_TYPE	Indicates if creator is either Element Classification or Type
DEFAULT_COMPONENT	Indicates if component is the default
REPROCESS_TYPE	How should the element be processed
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.
RETRO_COMPONENT_USAGE_ID	System-generated primary key column.
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).
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
REPLACE_RUN_FLAG	Indicates whether an element type will trigger the RetroPay replacement functionality.
USE_OVERRIDE_DATES	Indicates whether an element type can have its calculation date overridden.

Payroll - PAY_RETRO_DEFINITIONS
Column Name	Descritpion
SHORT_NAME
DEFINITION_NAME
LEGISLATION_CODE
RETRO_DEFINITION_ID

Payroll - PAY_RETRO_DEFN_COMPONENTS
Column Name	Descritpion
RETRO_DEFINITION_ID
RETRO_COMPONENT_ID
PRIORITY
DEFINITION_COMPONENT_ID

Payroll - PAY_RETRO_ENTRIES	Identifies the Entries required for re-processing.
Column Name	Descritpion
ELEMENT_ENTRY_ID	Foreign key to PAY_ELEMENT_ENTRIES_F
REPROCESS_DATE	The date re-processing is required.
EFFECTIVE_DATE	Effective date of the Retro-Entry.
RETRO_COMPONENT_ID	Foreign key to pay_retro_components.
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_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).
RETRO_ASSIGNMENT_ID	Foreign Key to PAY_RETRO_ASSIGNMENTS.
LAST_UPDATE_LOGIN
ELEMENT_TYPE_ID
OWNER_TYPE
SYSTEM_REPROCESS_DATE

Payroll - PAY_SHADOW_BAL_ATTRIBUTES
Column Name	Descritpion
ATTRIBUTE_NAME	Name referring to an existing balance attribute defintion.
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.
EXCLUSION_RULE_ID	Foreign key to PAY_TEMPLATE_EXCLUSION_RULES.
DEFINED_BALANCE_ID	Foreign key to PAY_SHADOW_DEFINED_BALANCES.
OBJECT_VERSION_NUMBER	Object version number column.
BALANCE_ATTRIBUTE_ID	System generated primary key 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).

Payroll - PAY_TEMPLATE_FF_USAGES	Allows multiple formulas to be associated with a shadow object.
Column Name	Descritpion
TEMPLATE_ID	Foreign key to PAY_ELEMENT_TEMPLATES.
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.
FORMULA_ID	Foreign key to PAY_SHADOW_FORMULAS.
OBJECT_ID	Reference to object with which the formula is associated.
OBJECT_VERSION_NUMBER	Object version number column.
EXCLUSION_RULE_ID	Foreign key to PAY_TEMPLATE_EXCLUSION_RULES.
TEMPLATE_FF_USAGE_ID	System generated primary key 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).

Payroll - PAY_MX_EARN_EXEMPTION_RULES_F	Used to hold the Earnings exemption rules for Mexico
Column Name	Descritpion
EXEMPTION_RULE_ID	Part of the primary key
LOW_RANGE_FACTOR	Factor of Range Basis that is used to determine the limit of the Lower Range
LOW_RANGE_BASIS	Earnings Basis used in the Lower Range limit. Eg: MW, GMW, etc.
HIGH_RANGE_FACTOR	Factor of Range Basis that is used to determine the limit of the Higher Range
HIGH_EXEMPT_FACTOR	Factor of Earnings that is exempt in the Higher Range
HIGH_RANGE_BASIS	Earnings Basis used in the Higher Range limit. Eg: MW, GMW, etc.
DESCRIPTION	Description of the Exemption computation process
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
EFFECTIVE_END_DATE	Effective end date
TAX_TYPE	Type of Tax for which this exemption is defined
ELEMENT_CLASSIFICATION_ID	The Element Classification for the Earnings Category. Foreign Key to PAY_ELEMENT_CLASSIFICATIONS.
STATE_CODE	State Code
CALC_RULE	Type of calculation involved
LOW_EXEMPT_FACTOR	Factor of Earnings that is exempt in the Lower Range

Payroll - PAY_MX_LEGISLATION_INFO_F	Mexican legislation specific data
Column Name	Descritpion
LEGISLATION_INFO_ID
LEGISLATION_INFO5	Segment 5
LEGISLATION_INFO6	Segment 6
LEGISLATION_INFO11	Segment 11
LEGISLATION_INFO12	Segment 12
LEGISLATION_INFO7	Segment 7
LEGISLATION_INFO13	Segment 13
LEGISLATION_INFO14	Segment 14
LEGISLATION_INFO8	Segment 8
LEGISLATION_INFO15	Segment 15
LEGISLATION_INFO16	Segment 16
LEGISLATION_INFO9	Segment 9
LEGISLATION_INFO17	Segment 17
LEGISLATION_INFO18	Segment 18
LEGISLATION_INFO10	Segment 10
LEGISLATION_INFO19	Segment 19
LEGISLATION_INFO20	Segment 20
LEGISLATION_INFO21	Segment 21
LEGISLATION_INFO22	Segment 22
LEGISLATION_INFO23	Segment 23
LEGISLATION_INFO24	Segment 24
LEGISLATION_INFO25	Segment 25
LEGISLATION_INFO26	Segment 26
LEGISLATION_INFO27	Segment 27
LEGISLATION_INFO28	Segment 28
EFFECTIVE_START_DATE	Date after which current record is valid
LEGISLATION_INFO29	Segment 29
LEGISLATION_INFO30	Segment 30
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_END_DATE	Date before which current record is valid
JURISDICTION_CODE	Jurisdiction code of current record
LEGISLATION_INFO_TYPE	Legislation Info Type
LEGISLATION_INFO1	Segment 1
LEGISLATION_INFO2	Segment 2
LEGISLATION_INFO3	Segment 3
LEGISLATION_INFO4	Segment 4

Payroll - PAY_NL_IZA_UPLD_STATUS	Holds the Status of the Data Records in the Processed IZA File
Column Name	Descritpion
BUSINESS_GROUP_ID	Foreign key to HR_ALL_ORGANIZATION_UNITS.
PROVINCE_CODE	Province Code in the IZA Data Record
DATE_OF_BIRTH	Date of Birth of Employee in the IZA Data Record
PARTICIPANT_NUMBER	IZA Participant Number of the Employee in the IZA Data Record
EMPLOYEE_NAME	Name of Employee in the IZA Data Record
CONTRIBUTION_1	Contribution Amount from the IZA File
CORRECTION_CONTRIBUTION_1	Correction Contribution Amount from the IZA File
DATE_CORRECTION_1	Date of Correction of Contribution Amount
CONTRIBUTION_2	2nd Contribution Amount from the IZA File
CORRECTION_CONTRIBUTION_2	2nd Correction Contribution Amount from the IZA File
DATE_CORRECTION_2	Date of 2nd Correction of Contribution Amount
REJECT_REASON	Reject Reason Code for Data records in Rejected Status
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).
ORGANIZATION_ID	Foreign key to HR_ALL_ORGANIZATION_UNITS.
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.
EMPLOYER_NUMBER	Employer Number in the IZA File
SUB_EMPLOYER_NUMBER	Sub Employer Number in the IZA File
PAYROLL_CENTER	Payroll Center Name in the IZA File Start Record
PROCESS_YEAR_MONTH	Processing Year Month last date in the IZA File
PERSON_ID	Foreign key to PER_ALL_PEOPLE_F
EMPLOYEE_NUMBER	Employee Number in the IZA Data Record
PROCESS_STATUS	Process Status of the Employee Data Record

Payroll - PAY_RANGES_F	List of ranges for each Tax Table Number present in PAY_RANGE_TABLES_F
Column Name	Descritpion
RANGE_TABLE_ID	Foreign key to PAY_RANGE_TABLES_F
LOW_BAND	Lower band of the range
HIGH_BAND	Higher band of the range
AMOUNT1	Amount1 will contain amount
AMOUNT2	Amount2 will contain amount
EFFECTIVE_START_DATE	Effective start date of the record
EFFECTIVE_END_DATE	Effective end date of the record
OBJECT_VERSION_NUMBER	Object version number of the record
RANGE_ID	Primary key to PAY_RANGES_F

Payroll - PAY_RANGE_TABLES_F
Column Name	Descritpion
EFFECTIVE_START_DATE	Effective start date
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
EFFECTIVE_END_DATE	Effective end date
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ATTRIBUTE16	Descriptive flexfield segment
ATTRIBUTE17	Descriptive flexfield segment
ATTRIBUTE18	Descriptive flexfield segment
ATTRIBUTE19	Descriptive flexfield segment
ATTRIBUTE20	Descriptive flexfield segment
ATTRIBUTE21	Descriptive flexfield segment
ATTRIBUTE22	Descriptive flexfield segment
ATTRIBUTE23	Descriptive flexfield segment
RANGE_TABLE_NUMBER	Range Table Number contains the Tax Table Number for this range
ATTRIBUTE24	Descriptive flexfield segment
ATTRIBUTE25	Descriptive flexfield segment
ATTRIBUTE26	Descriptive flexfield segment
ATTRIBUTE27	Descriptive flexfield segment
ATTRIBUTE28	Descriptive flexfield segment
ATTRIBUTE29	Descriptive flexfield segment
ATTRIBUTE30	Descriptive flexfield segment
RAN_INFORMATION_CATEGORY	Descriptive flexfield structure definition column
RAN_INFORMATION1	Descriptive flexfield segment
RAN_INFORMATION2	Descriptive flexfield segment
ROW_VALUE_UOM	Unit of Measurement
RAN_INFORMATION3	Descriptive flexfield segment
RAN_INFORMATION4	Descriptive flexfield segment
RAN_INFORMATION5	Descriptive flexfield segment
RAN_INFORMATION6	Descriptive flexfield segment
RAN_INFORMATION7	Descriptive flexfield segment
RAN_INFORMATION8	Descriptive flexfield segment
RAN_INFORMATION9	Descriptive flexfield segment
RAN_INFORMATION10	Descriptive flexfield segment
RAN_INFORMATION11	Descriptive flexfield segment
RAN_INFORMATION12	Descriptive flexfield segment
PERIOD_FREQUENCY	Period frequency is the basis on which a value is calculated
RAN_INFORMATION13	Descriptive flexfield segment
RAN_INFORMATION14	Descriptive flexfield segment
RAN_INFORMATION15	Descriptive flexfield segment
RAN_INFORMATION16	Descriptive flexfield segment
RAN_INFORMATION17	Descriptive flexfield segment
RAN_INFORMATION18	Descriptive flexfield segment
RAN_INFORMATION19	Descriptive flexfield segment
RAN_INFORMATION20	Descriptive flexfield segment
RAN_INFORMATION21	Descriptive flexfield segment
RAN_INFORMATION22	Descriptive flexfield segment
EARNINGS_TYPE	Earnings type is the type of earnings
RAN_INFORMATION23	Descriptive flexfield segment
RAN_INFORMATION24	Descriptive flexfield segment
RAN_INFORMATION25	Descriptive flexfield segment
RAN_INFORMATION26	Descriptive flexfield segment
RAN_INFORMATION27	Descriptive flexfield segment
RAN_INFORMATION28	Descriptive flexfield segment
RAN_INFORMATION29	Descriptive flexfield segment
RAN_INFORMATION30	Descriptive flexfield segment
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE	Foreign Key to FND_TERRITORIES
RANGE_TABLE_ID	Primary key to PAY_RANGES_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_UPDATED_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).
CREATED_DATE	Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER	Object version number of the record
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment

Payroll - PAY_MONETARY_UNITS_TL	Translated data for the table PAY_MONETARY_UNITS_TL
Column Name	Descritpion
MONETARY_UNIT_ID	System generated key from PAY_MONETARY_UNITS
MONETARY_UNIT_NAME	Translated monetary unit name
LANGUAGE	Language of translation
SOURCE_LANG	Source language of the row
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_RANGE_TEMP	Intermediate Table to store processing data for Tax Tables
Column Name	Descritpion
RANGE_TABLE_NUMBER	Range Table Number contains the Tax Table Number for this range
ROW_VALUE_UOM	Unit of Measurement
PERIOD_FREQUENCY	Period frequency is the basis on which a value is calculated
EARNINGS_TYPE	Earnings type is the type of earnings
LOW_BAND	Lower band of the range
HIGH_BAND	Higher band of the range
AMOUNT1	Amount1 will contain amount
AMOUNT2	Amount2 will contain amount
RANGE_ID	Primary key to PAY_RANGES_F

Payroll - PAY_PL_PAYE_DETAILS_F	Tax Details of a Polish Person
Column Name	Descritpion
PAYE_DETAILS_ID	System generated Primary Key column
INCOME_REDUCTION	Income reduction type of the Tax record.
INCOME_REDUCTION_AMOUNT	Income reduction amount of the tax record.
RATE_OF_TAX	Rate of tax of the tax record.
CREATED_BY	Standard WHO column.
CREATION_DATE	Standard WHO column.
LAST_UPDATED_BY	Standard WHO column.
LAST_UPDATE_DATE	Standard WHO column.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who lasted updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PROGRAM_ID	Identifies the concurrent program.
PROGRAM_LOGIN_ID	Identifies the Oracle Applications Concurrent Program Login ID.
EFFECTIVE_START_DATE	Effective Start Date of the Tax record.
PROGRAM_APPLICATION_ID	Identifies the Oracle Application that spawned the concurrent program.
REQUEST_ID	Identifies the concurrent request instance that spawned the concurrent program.
EFFECTIVE_END_DATE	Effective End Date of the Tax record.
PER_OR_ASG_ID	Foreign key to PER_ALL_ASSIGNMENTS_F table when the Contract Category is Civil. If Contract Category is Normal then it is the foreign key to PER_ALL_PEOPLE_F.
BUSINESS_GROUP_ID	Foreign key TO HR_ORGANIZATION_UNITS
CONTRACT_CATEGORY	Contract category of the assignment.
OBJECT_VERSION_NUMBER	Object Version Number of the record.
TAX_REDUCTION	Tax Reduction
TAX_CALC_WITH_SPOUSE_CHILD	Tax Calculation with Spouse/Child.

Payroll - PAY_PL_SII_DETAILS_F	SII Details of a Polish Person
Column Name	Descritpion
SII_DETAILS_ID	System generated Primary Key column
PENSION_CONTRIBUTION	Pension Contribution type
SICKNESS_CONTRIBUTION	Sickness Contribution type
WORK_INJURY_CONTRIBUTION	Work Injury Contribution type
LABOR_CONTRIBUTION	Labor Contribution type
HEALTH_CONTRIBUTION	Health Contribution type
UNEMPLOYMENT_CONTRIBUTION	Unemployment Contribution type
OLD_AGE_CONT_END_REASON
PENSION_CONT_END_REASON
SICKNESS_CONT_END_REASON
WORK_INJURY_CONT_END_REASON
EFFECTIVE_START_DATE	Effective Start date of the SII record.
LABOR_FUND_CONT_END_REASON
HEALTH_CONT_END_REASON
UNEMPLOYMENT_CONT_END_REASON
CREATED_BY	Standard WHO column.
CREATION_DATE	Standard WHO column.
LAST_UPDATED_BY	Standard WHO column.
LAST_UPDATE_DATE	Standard WHO column.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who lasted updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PROGRAM_ID	Identifies the concurrent program.
PROGRAM_LOGIN_ID	Identifies the Oracle Applications Concurrent Program Login ID.
EFFECTIVE_END_DATE	Effective End date of the SII record.
PROGRAM_APPLICATION_ID	Identifies the Oracle Application that spawned the concurrent program.
REQUEST_ID	Identifies the concurrent request instance that spawned the concurrent program.
PER_OR_ASG_ID	Foreign key to PER_ALL_ASSIGNMENTS_F table when the Contract Category is Civil. If Contract Category is Normal then it is the foreign key to PER_ALL_PEOPLE_F.
BUSINESS_GROUP_ID	Foreign key TO HR_ORGANIZATION_UNITS
CONTRACT_CATEGORY	Contract category of the assignment.
OBJECT_VERSION_NUMBER	Object Version Number of the record.
EMP_SOCIAL_SECURITY_INFO	Code corresponding to the Employee Social Security Information
OLD_AGE_CONTRIBUTION	Old Age Contribution type

Payroll - PAY_UPGRADE_DEFINITIONS	Defines a Data Upgrade that needs to be performed.
Column Name	Descritpion
UPGRADE_DEFINITION_ID	System Generated primary key column
LEGISLATIVELY_ENABLED	Determines if legislations need to enable a global upgrade
UPGRADE_METHOD	Indicates how the upgrade can be performed
UPGRADE_PROCEDURE	The procedure that actually performs the upgrade.
QUALIFYING_PROCEDURE	This procedure indicates if the object(defined by the THREADING_LEVEL) requires the upgrade to be performed..
SHORT_NAME	Internal Name for the Upgrade
FIRST_PATCHSET	The name of the patchset the upgrade was first delivered in.
OWNER_APPLICATION_ID	Application responsible for upgrade
NAME	Descriptive Name of the upgrade
VALIDATE_CODE	Procedure call to determine if upgrade is needed.
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).
LEGISLATION_CODE	Legislation Code
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).
DESCRIPTION	Detailed Description of the Upgrade
CREATION_DATE	Standard who column - date when this row was created.
ADDITIONAL_INFO	Free text to supply extra information on upgrade
UPGRADE_LEVEL	The scope of the upgrade is defined by the UPGRADE LEVEL.
CRITICALITY	Advises the user on the imporance of the data upgrade
THREADING_LEVEL	Determines how an upgrade process distributes its work.
FAILURE_POINT	Determines if the system should error based on the upgrade.

Payroll - PAY_UPGRADE_LEGISLATIONS	PAY_UPGRADE_LEGISLATIONS identifies which Global upgrades can be used.
Column Name	Descritpion
UPGRADE_DEFINITION_ID	Foreign key to PAY_UPGRADE_DEFINITIONS
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.
LEGISLATION_CODE	Legislation Code

Payroll - PAY_UPGRADE_STATUS	Status of Upgrades performed
Column Name	Descritpion
UPGRADE_DEFINITION_ID	Foreign key to PAY_UPGRADE_DEFINITIONS
EXECUTED	Identifies if upgrade found work to perform
REQUEST_ID	The id of the latest run of the process
STATUS	Current Statis of the Upgrade
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS
LEGISLATION_CODE	Legislation Code

Payroll - PAY_UPGRADE_DEFINITIONS_TL	Translated data for the table PAY_UPGRADE_DEFINITIONS_TL
Column Name	Descritpion
UPGRADE_DEFINITION_ID	Foreign Key to PAY_UPGRADE_DEFINITIONS
ADDITIONAL_INFO	Translation of the Additional Info
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).
LANGUAGE	Language of Translation
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).
SOURCE_LANG	Source Language of the row
CREATION_DATE	Standard who column - date when this row was created.
NAME	Descriptive Name of the Upgrade
DESCRIPTION	Translation of the Description Column in PAY_UPGRADE_DEFINITIONS

Payroll - PAY_UPGRADE_PARAMETERS	Holds additional parameters to define an upgrade process.
Column Name	Descritpion
PARAMETER_NAME	Name of parameter used for process specifics.
PARAMETER_VALUE	The value of the parameter for this upgrade
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).
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.
UPGRADE_DEFINITION_ID	Foreign Key to PAY_UPGRADE_DEFINITIONS.

Payroll - PAY_REPORT_FORMAT_MAPPINGS_TL	Translated name for report format mappings
Column Name	Descritpion
REPORT_FORMAT_MAPPING_ID	Foreign Key to PAY_REPORT_FORMAT_MAPPINGS_F
LANGUAGE	Language of Translation
SOURCE_LANG	Source Language of the row
DISPLAY_NAME	Name used when displaying this definition.

Payroll - PAY_REPORT_FORMAT_PARAMETERS	Parameters for a Report Format
Column Name	Descritpion
PARAMETER_NAME
PARAMETER_VALUE
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).
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.
REPORT_FORMAT_MAPPING_ID	Foreign Key to PAY_REPORT_FORMAT_MAPPINGS_F

Payroll - PAY_REPORT_CATEGORIES	Holds Report Category Definitions
Column Name	Descritpion
REPORT_GROUP_ID	Report Group ID
CATEGORY_NAME	Report Category Name
SHORT_NAME	Report Category Short Name
LEGISLATION_CODE	Legislation Code
BUSINESS_GROUP_ID	Business Group ID
LAST_UPDATED_BY	Last Updated By
LAST_UPDATE_DATE	Last Updated Date
LAST_UPDATED_DATE	Last Updated Date
CREATED_BY	Created By
REPORT_CATEGORY_ID	Report Category ID
CREATION_DATE	Creation Date
OBJECT_VERSION_NUMBER	Object Version Number
LAST_UPDATE_LOGIN	Last Update Login

Payroll - PAY_REPORT_RECORD_TEMPLATES
Column Name	Descritpion
MAGNETIC_BLOCK_ID
SEQUENCE
TEMPLATE_NAME
REPORT_VARIABLE_ID

Payroll - PAY_REPORT_DEFINITIONS
Column Name	Descritpion
REPORT_GROUP_ID
REPORT_NAME
REPORT_TYPE
REPORT_LEVEL
MAGNETIC_BLOCK_ID
APPLICATION_SHORT_NAME
ALTERABLE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
REPORT_DEFINITION_ID
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER

Payroll - PAY_REPORT_GROUPS
Column Name	Descritpion
REPORT_FORMAT_MAPPING_ID
REPORT_GROUP_NAME
LEGISLATION_CODE
BUSINESS_GROUP_ID
SHORT_NAME
THREAD_LEVEL
QUALIFYING_PROCEDURE
REPORT_LEVEL
ASG_MAGNETIC_BLOCK_ID
LAST_UPDATED_BY
LAST_UPDATE_DATE
REPORT_GROUP_ID
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
REPORT_ON_FULL_XML

Payroll - PAY_REPORT_VARIABLES
Column Name	Descritpion
REPORT_DEFINITION_ID
DEFINITION_TYPE
NAME
VALUE
LEGISLATION_CODE
BUSINESS_GROUP_ID
LAST_UPDATED_BY
LAST_UPDATE_DATE
REPORT_VARIABLE_ID
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER

Payroll - PAY_REPORT_MAGNETIC_PROCEDURES
Column Name	Descritpion
MAGNETIC_BLOCK_ID
SEQUENCE
REPORT_GROUP_ID
LEGISLATION_CODE
PROCEDURE_NAME
REPORT_MAGNETIC_PROCEDURE_ID

Payroll - PAY_REPORT_CATEGORY_COMPONENTS
Column Name	Descritpion
REPORT_CATEGORY_ID
REPORT_DEFINITION_ID
BREAKOUT_VARIABLE_ID
ORDER_BY_VARIABLE_ID
STYLE_SHEET_VARIABLE_ID
LEGISLATION_CODE
BUSINESS_GROUP_ID
LAST_UPDATED_BY
LAST_UPDATE_DATE
REPORT_CATEGORY_COMP_ID
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER

Payroll - PAY_OBJECT_GROUPS	Grouping of People and Assignments for processing.
Column Name	Descritpion
OBJECT_GROUP_ID	System generated primary key
SOURCE_ID	Foreign Key to a table denoted by the SOURCE_TYPE
PERIOD_OF_SERVICE_ID	Foreign Key to PER_PERIODS_OF_SERVICE
SOURCE_TYPE	Denotes the table from which the SOURCE_ID is from.
START_DATE	This is the start date for the Object Group
END_DATE	This is the End Date for the Object Group
PAYROLL_ID	Foreign Key to PAY_PAYROLLS_F
GROUP_DEFINITION_ID	Foreign Key to PAY_GROUP_DEFINITIONS
PARENT_OBJECT_GROUP_ID	Foreign Key to PAY_OBJECT_GROUPS

Payroll - PAY_TEMP_OBJECT_ACTIONS	Holds details of an object that is to be processed
Column Name	Descritpion
OBJECT_ACTION_ID	Surrogate Primary Key
OBJECT_ID	Foreign Key to a database object defined by the Object Type
OBJECT_TYPE	Indicates the type of object that the object id is pointing to
PAYROLL_ACTION_ID	Foreign Key to the PAY_PAYROLL_ACTION Table
ACTION_STATUS	Valid statuses for an object action.
CHUNK_NUMBER	Number used to group events into chunks for parallelization.
ACTION_SEQUENCE	Absolute sequence number to determine physical order of events.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.

Payroll - PAY_LATEST_BALANCES	Latest balance values for a person or assignment.
Column Name	Descritpion
LATEST_BALANCE_ID	Surrogate primary key.
EXPIRED_VALUE	Value of Expired Balance
EXPIRED_DATE	Date on which the Expired Value Expired.
PREV_ASSIGNMENT_ACTION_ID	Foreign Key to PAY_ASSIGNMENT_ACTIONS
PREV_BALANCE_VALUE	Prevous Value of the Balance
PREV_EXPIRY_DATE	Date on which the Previous Balance Value will expire
TAX_UNIT_ID	Foreign Key the HR_ORGANIZATION_UNITS
JURISDICTION_CODE	Jurisdiction context value for the balance.
ORIGINAL_ENTRY_ID	Original Entry Id context value for balance
SOURCE_ID	Source Id context value for balance
SOURCE_TEXT	Source Text context value for balance
DEFINED_BALANCE_ID	Foreign key to PAY_DEFINED_BALANCES.
SOURCE_TEXT2	Source Text 2 context value for balance
SOURCE_NUMBER	Source Number context value for balance
SOURCE_NUMBER2	Source Number2 context value for balance
ASSIGNMENT_ACTION_ID	Foreign key to PAY_ASSIGNMENT_ACTIONS.
TAX_GROUP	Tax Group context value for balance
VALUE	Value of the Balance
PAYROLL_ID	Payroll Id context value for balance
LOCAL_UNIT_ID	Local Unit Id context value for balance
PERSON_ID	Foreign Key to PER_PEOPLE_F
ORGANIZATION_ID	Organization Id context value for balance
PROCESS_GROUP_ID	Foreign Key to PAY_OBJECT_GROUPS
ASSIGNMENT_ID	Foreign Key to PER_ASSIGNMENTS_F
EXPIRY_DATE	Date on which the current balance value will expire
EXPIRED_ASSIGNMENT_ACTION_ID	Foreign Key to PAY_ASSIGNMENT_ACTIONS

Payroll - PAY_USER_ROWS_F_TL	Translated User Rows Names.
Column Name	Descritpion
USER_ROW_ID
LANGUAGE
SOURCE_LANG
ROW_LOW_RANGE_OR_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE

Payroll - PAY_USER_COLUMNS_TL	Translated User Column Names
Column Name	Descritpion
USER_COLUMN_ID
LANGUAGE
SOURCE_LANG
USER_COLUMN_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE

Payroll - PAY_USER_TABLES_TL	Translated User Table Name and Row Titles
Column Name	Descritpion
USER_TABLE_ID
CREATION_DATE
LANGUAGE
SOURCE_LANG
USER_TABLE_NAME
USER_ROW_TITLE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY

Payroll - PAY_PAYMENT_GL_ACCOUNTS_F
Column Name	Descritpion
PAY_GL_ACCOUNT_ID
EFFECTIVE_START_DATE	Organisation payment methods effective start date
EFFECTIVE_END_DATE	Organisation payment methods effective end date
SET_OF_BOOKS_ID	Set of Books
GL_CASH_AC_ID	Cash Account
GL_CASH_CLEARING_AC_ID	Cash Clearing Account
GL_CONTROL_AC_ID	Payroll Control Account
GL_ERROR_AC_ID	Bank Error Account
EXTERNAL_ACCOUNT_ID	Foreign key to PAY_EXTERNAL_ACCOUNT
ORG_PAYMENT_METHOD_ID	Foreign key to PAY_ORG_PAYMENT_METHODS
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
OBJECT_VERSION_NUMBER	System generated version of row.

Payroll - PAY_PAYMENT_COSTS
Column Name	Descritpion
PAYMENT_COST_ID	Primary Key
SOURCE_ACTION_ID	AAC ID of the source
PRE_PAYMENT_ID	Identifier for the Pre Payment process.
ASSIGNMENT_ID	Assignment Id of the assignment
SOURCE_ID	Points to the payment_cost_id.
ACCOUNT_ID	GL Account Identifier
ACCOUNT_TYPE
VALUE	Costed amount
CURRENCY_CODE	Currency code of costed amount
DEBIT_OR_CREDIT	Debit or Credit. (UseLookup DEBIT_CREDIT)
ACCOUNTING_DATE	Payment Date or Cleared Date or Voided Date
ASSIGNMENT_ACTION_ID	AAC ID of Costing of Payment process.
TRANSFER_TO_GL_FLAG	Transfer the cost to GL or not
SOURCE_TYPE	Pre-Payment or Cheque or Magnetic Tape or Void or External/Manual Payment

Payroll - PAY_PAYMENT_COSTS_EFC
Column Name	Descritpion
EFC_ACTION_ID
VALUE
OUTPUT_CURRENCY_CODE
CURRENCY_CODE
PAYMENT_COST_ID

Payroll - PAY_LEG_SETUP_DEFAULTS	Controls legislative default parameters for setup of new legislations.
Column Name	Descritpion
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
CURRENCY_CODE	Currency Code
TAX_UNIT_FLAG	Tax Unit Dimension Flag
TAX_START_DATE	Tax Start Date
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_TIME_SPANS
Column Name	Descritpion
CREATOR_ID
CREATOR_TYPE
START_TIME_DEF_ID
END_TIME_DEF_ID
TIME_SPAN_ID

Payroll - PAY_TIME_DEFINITIONS	Stores details of period of time
Column Name	Descritpion
SHORT_NAME
DEFINITION_NAME
DEFINITION_TYPE	Indicates the Type of Time Definition.
PERIOD_TYPE
PERIOD_UNIT
DAY_ADJUSTMENT
DYNAMIC_CODE
BUSINESS_GROUP_ID
LEGISLATION_CODE
NUMBER_OF_YEARS	Number of Years a Static Period Time Definition has periods.
TIME_DEFINITION_ID
START_DATE	Date on which a Static Period Time Defintion Starts
PERIOD_TIME_DEFINITION_ID	Foreign Key to PAY_TIME_DEFINITIONS.
CREATOR_ID	Foreign Key to the source of the time definition.
CREATOR_TYPE	Denotes the source of the time definition.
OBJECT_VERSION_NUMBER

Payroll - PAY_TIME_DEF_USAGES
Column Name	Descritpion
USAGE_TYPE
OBJECT_VERSION_NUMBER
TIME_DEFINITION_ID