My Human Resources Table Descriptions hand book (I have big hands) part2

Human Resources - HR_LOCATIONS_ALL	Work location definitions.
Column Name	Descritpion
LOCATION_ID	System-generated primary key column.
DESIGNATED_RECEIVER_ID	Person foreign key - the contact person for this location.
COUNTRY	Country.
IN_ORGANIZATION_FLAG	Indicates whether this location is an internal site.
POSTAL_CODE	Postal code.
REGION_1	County (US, UK); Province (CA).
REGION_2	State (US); Province of work (CA).
REGION_3	Additional address segment - not used by seeded address structures.
TELEPHONE_NUMBER_1	Telephone number.
TELEPHONE_NUMBER_2	Telephone number.
TELEPHONE_NUMBER_3	Telephone number.
INACTIVE_DATE	Date after which this location is no longer valid.
LOC_INFORMATION13	Developer descriptive flexfield column.
LOC_INFORMATION14	Developer descriptive flexfield column.
INVENTORY_ORGANIZATION_ID	Inventory organization foreign key.
LOC_INFORMATION15	Developer descriptive flexfield column.
LOC_INFORMATION16	Developer descriptive flexfield column.
LOC_INFORMATION17	Developer descriptive flexfield column.
LOC_INFORMATION18	Developer descriptive flexfield column.
LOC_INFORMATION19	Developer descriptive flexfield column.
LOC_INFORMATION20	Developer descriptive flexfield column.
OFFICE_SITE_FLAG	Indicates whether this location can be used as an office site.
STYLE	Address style - foreign key to FND_TERRITORIES.
RECEIVING_SITE_FLAG	Indicates whether this location can be used as a receiving site.
GLOBAL_ATTRIBUTE1	Descriptive flexfield column
GLOBAL_ATTRIBUTE2	Descriptive flexfield colunm
GLOBAL_ATTRIBUTE3	Descriptive flexfield column
GLOBAL_ATTRIBUTE4	Descriptive flexfield column
GLOBAL_ATTRIBUTE5	Descriptive flexfield column
GLOBAL_ATTRIBUTE6	Descriptive flexfield column
GLOBAL_ATTRIBUTE7	Descriptive flexfield column
GLOBAL_ATTRIBUTE8	Descriptive flexfield column
GLOBAL_ATTRIBUTE9	Descriptive flexfield column
GLOBAL_ATTRIBUTE10	Descriptive flexfield column
GLOBAL_ATTRIBUTE11	Descriptive flexfield column
GLOBAL_ATTRIBUTE12	Descriptive flexfield column
GLOBAL_ATTRIBUTE13	Descriptive flexfield column
GLOBAL_ATTRIBUTE14	Descriptive flexfield column
GLOBAL_ATTRIBUTE15	Descriptive flexfield column
ENTERED_BY	Applications user who created this location; same as CREATED_BY.
SHIP_TO_LOCATION_ID	Ship-to location foreign key.
ADDRESS_LINE_1	1st line of location address.
GLOBAL_ATTRIBUTE16	Descriptive flexfield column
GLOBAL_ATTRIBUTE17	Descriptive flexfield column
GLOBAL_ATTRIBUTE18	Descriptive flexfield column
GLOBAL_ATTRIBUTE19	Descriptive flexfield column
GLOBAL_ATTRIBUTE20	Descriptive flexfield column
SHIP_TO_SITE_FLAG	Indicates whether items can be shipped to this location.
TAX_NAME	Default tax code for this location.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
ATTRIBUTE1	Descriptive flexfield column.
LOCATION_CODE	Location name.
ATTRIBUTE2	Descriptive flexfield column.
ATTRIBUTE3	Descriptive flexfield column.
ATTRIBUTE4	Descriptive flexfield column.
ATTRIBUTE5	Descriptive flexfield column.
ATTRIBUTE6	Descriptive flexfield column.
ATTRIBUTE7	Descriptive flexfield column.
ATTRIBUTE8	Descriptive flexfield column.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
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. Increments by one with each update.
TP_HEADER_ID	Unsupported in Oracle Human Resources. Used by Oracle EDI Gateway.
ECE_TP_LOCATION_CODE	Unsupported in Oracle Human Resources. Used by Oracle EDI Gateway.
GLOBAL_ATTRIBUTE_CATEGORY	Global descriptive flexlield structure defining colunm
BILL_TO_SITE_FLAG	Indicates whether you can bill items to this location.
BUSINESS_GROUP_ID	Business Group ID associated with location.
DERIVED_LOCALE	derived locale
ADDRESS_LINE_2	2nd line of location address.
LEGAL_ADDRESS_FLAG
DESCRIPTION	Brief description of the location.
TIMEZONE_CODE
ADDRESS_LINE_3	3rd line of location address.
TOWN_OR_CITY	Town or city.

Human Resources - HR_ORGANIZATION_INFORMATION	Additional attributes of an organization, dependent on class or organization information type.
Column Name	Descritpion
ORG_INFORMATION_ID	Developer descriptive flexfield column.
ORG_INFORMATION15	Developer descriptive flexfield column.
ORG_INFORMATION16	Developer descriptive flexfield column.
ORG_INFORMATION17	Developer descriptive flexfield column.
ORG_INFORMATION18	Developer descriptive flexfield column.
ORG_INFORMATION19	Developer descriptive flexfield column.
ORG_INFORMATION2	Developer descriptive flexfield column.
ORG_INFORMATION20	Developer descriptive flexfield column.
ORG_INFORMATION3	Developer descriptive flexfield column.
ORG_INFORMATION4	Developer descriptive flexfield column.
ORG_INFORMATION5	Developer descriptive flexfield column.
ORG_INFORMATION_CONTEXT	Developer descriptive flexfield column.
ORG_INFORMATION6	Developer descriptive flexfield column.
ORG_INFORMATION7	Developer descriptive flexfield column.
ORG_INFORMATION8	Developer descriptive flexfield column.
ORG_INFORMATION9	Developer descriptive flexfield column.
REQUEST_ID	Standard Who column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who column.
PROGRAM_UPDATE_DATE	Standard Who column.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
ATTRIBUTE1	Descriptive flexfield column.
ORGANIZATION_ID	Foreign key to HR_ORGANIZATION_UNITS.
ATTRIBUTE2	Descriptive flexfield column.
ATTRIBUTE3	Descriptive flexfield column.
ATTRIBUTE4	Descriptive flexfield column.
ATTRIBUTE5	Descriptive flexfield column.
ATTRIBUTE6	Descriptive flexfield column.
ATTRIBUTE7	Descriptive flexfield column.
ATTRIBUTE8	Descriptive flexfield column.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ORG_INFORMATION1	Developer descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
ORG_INFORMATION10	Developer descriptive flexfield 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. Increments by one with each update.
ORG_INFORMATION11	Developer descriptive flexfield column.
PARTY_ID	Foreign key to HZ_PARTIES
ORG_INFORMATION12	Developer descriptive flexfield column.
ORG_INFORMATION13	Developer descriptive flexfield column.
ORG_INFORMATION14	Developer descriptive flexfield column.

Human Resources - HR_ORG_INFORMATION_TYPES	Information types that are used to add information for an organization.
Column Name	Descritpion
ORG_INFORMATION_TYPE	Developer descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
DESCRIPTION	Description of information type.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
DESTINATION	Zoom or call form destination.
CREATION_DATE	Standard Who column.
DISPLAYED_ORG_INFORMATION_TYPE	Name of the information type that is visible to the user.
FND_APPLICATION_ID	Foreign key reference to AOL application.
LEGISLATION_CODE	Legislation code for Business Group.
NAVIGATION_METHOD	Navigation to be performed to maintain attributes for the organization type.

Human Resources - HR_ORG_INFO_TYPES_BY_CLASS	Defines organization information types for specific organization classifications.
Column Name	Descritpion
ORG_CLASSIFICATION	Classification type of an organization. For example, HR Organization, Business Group, etc.
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.
ENABLED_FLAG	Enabled Flag
ORG_INFORMATION_TYPE	Developer descriptive flexfield column.
MANDATORY_FLAG	An indication of whether a particular type of organization information is mandatory for a class.

Human Resources - HR_STU_EXCEPTIONS	Error conditions from the startup data process.
Column Name	Descritpion
TABLE_NAME	The name of the startup table where the error was found.
SURROGATE_ID	Id of the record which failed to validation check.
EXCEPTION_TEXT	Helpful error text to identify the validation check that failed.
TRUE_KEY	Helpful error text to identify the name of the item that failed.

Human Resources - HR_STU_HISTORY	Versions of HRMS Startup data installed
Column Name	Descritpion
PACKAGE_NAME	Label identifying the version of dat file installed
DATE_OF_EXPORT	Date the dat file was created
DATE_OF_IMPORT	Date the DAT file was installed
STATUS	Whether the merge is in Phase1/Phase2/Complete
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.

Human Resources - HR_SOFT_CODING_KEYFLEX	Legislation specific information for payrolls, organizations and assignments.
Column Name	Descritpion
SOFT_CODING_KEYFLEX_ID	System-generated primary key column.
START_DATE_ACTIVE	Date before which key flexfield combination is invalid.
END_DATE_ACTIVE	Date after which key flexfield combination is invalid.
SEGMENT1	Key flexfield segment column.
SEGMENT2	Key flexfield segment column.
SEGMENT3	Key flexfield segment column.
SEGMENT4	Key flexfield segment column.
SEGMENT5	Key flexfield segment column.
SEGMENT6	Key flexfield segment column.
SEGMENT7	Key flexfield segment column.
SEGMENT8	Key flexfield segment column.
CONCATENATED_SEGMENTS	Key flexfield segment column.
SEGMENT9	Key flexfield segment column.
SEGMENT10	Key flexfield segment column.
SEGMENT11	Key flexfield segment column.
SEGMENT12	Key flexfield segment column.
SEGMENT13	Key flexfield segment column.
SEGMENT14	Key flexfield segment column.
SEGMENT15	Key flexfield segment column.
SEGMENT16	Key flexfield segment column.
SEGMENT17	Key flexfield segment column.
SEGMENT18	Key flexfield segment column.
REQUEST_ID	Standard Who Column.
SEGMENT19	Key flexfield segment column.
SEGMENT20	Key flexfield segment column.
SEGMENT21	Key flexfield segment column.
SEGMENT22	Key flexfield segment column.
SEGMENT23	Key flexfield segment column.
SEGMENT24	Key flexfield segment column.
SEGMENT25	Key flexfield segment column.
SEGMENT26	Key flexfield segment column.
SEGMENT27	Key flexfield segment column.
SEGMENT28	Key flexfield segment column.
PROGRAM_APPLICATION_ID	Standard Who column.
SEGMENT29	Key flexfield segment column.
SEGMENT30	Key flexfield segment column.
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.
PROGRAM_ID	Standard Who Column.
PROGRAM_UPDATE_DATE	Standard Who column.
ID_FLEX_NUM	Key flexfield structure foreign key.
SUMMARY_FLAG	Key flexfield summary flag.
ENABLED_FLAG	Key flexfield enabled flag.

Human Resources - HR_NAVIGATION_CONTEXT_RULES	Context specific rules for taskflow navigation.
Column Name	Descritpion
NAV_CONTEXT_RULE_ID	System-generated primary key column.
GLOBAL_USAGE_ID	Foreign key to HR_NAV_UNIT_GLOBAL_USAGES.
EVALUATION_TYPE_CODE	Evaluation type of the criteria, for example Not Null or Equals.
VALUE	Acceptable value for the criteria that is acceptable under the rule.

Human Resources - HR_NAVIGATION_NODES	Taskflow node definitions.
Column Name	Descritpion
NAV_UNIT_ID	Foreign key to HR_NAVIGATION_UNITS.
NAV_NODE_ID	System-generated primary key column.
NAME	Name of the node.
CUSTOMIZED_RESTRICTION_ID	Customization ID of the node. Identifies any custom restriction to apply when the node is called.

Human Resources - HR_NAVIGATION_NODE_USAGES	Intersection table between HR_WORKFLOWS, HR_NAVIGATION_NODES and HR_NAVIGATION_PATHS.
Column Name	Descritpion
NAV_NODE_USAGE_ID	System-generated primary key column.
WORKFLOW_ID	Foreign key to HR_WORKFLOWS.
NAV_NODE_ID	Foreign key to HR_NAVIGATION_NODES.
TOP_NODE	Top node in the taskflow. There can be only one entry point, or node, in a taskflow.

Human Resources - HR_NAVIGATION_PATHS	Taskflow navigation path details.
Column Name	Descritpion
NAV_PATH_ID	System-generated primary key column.
CREATED_BY
CREATION_DATE
FROM_NAV_NODE_USAGE_ID	Foreign key to HR_NAVIGATION_NODE_USAGES.
LAST_UPDATED_BY
LAST_UPDATE_DATE
TO_NAV_NODE_USAGE_ID	Foreign key to HR_NAVIGATION_NODE_USAGES.
LAST_UPDATE_LOGIN
NAV_BUTTON_REQUIRED	Indicates whether a user button is displayed.
SEQUENCE	Sequence of user buttons, and the order of other options in the Others list.
OVERRIDE_LABEL	User defined label for a button.

Human Resources - HR_NAVIGATION_UNITS	Information about potential navigation options in a taskflow.
Column Name	Descritpion
NAV_UNIT_ID	System-generated primary key column.
CREATED_BY
CREATION_DATE
DEFAULT_WORKFLOW_ID	Foreign key to HR_WORKFLOWS.
LAST_UPDATED_BY
APPLICATION_ABBREV	Abbreviation of the application name.
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
DEFAULT_LABEL	Default label given to the navigation unit.
FORM_NAME	Shortened form name that the unit refers to.
MAX_NUMBER_OF_NAV_BUTTONS	Maximum number of buttons allowed on the form.
BLOCK_NAME	Used if more than one block within a form appears as a navigation option.

Human Resources - HR_NAV_UNIT_GLOBAL_USAGES	Global variable usage by specific navigation unit. (Form or block).
Column Name	Descritpion
GLOBAL_USAGE_ID	System-generated primary key column.
NAV_UNIT_ID	Foreign key to HR_NAVIGATION_UNITS.
GLOBAL_NAME	Name of the global parameter.
IN_OR_OUT	Indicates whether the global parameter is passed in or out.
MANDATORY_FLAG	Specifies whether the global parameter is mandatory or optional.

Human Resources - HR_INCOMPATIBILITY_RULES	Incompatibility rules for navigation units.
Column Name	Descritpion
FROM_NAV_UNIT_ID	Foreign key to HR_NAVIGATION_UNITS.
TO_NAV_UNIT_ID	Foreign key to HR_NAVIGATION_UNITS.

Human Resources - HR_PATTERNS	A repeating time pattern, eg a work pattern, SSP qualifying pattern or a resource schedule.
Column Name	Descritpion
PATTERN_ID	System-generated primary key column.
LAST_UPDATE_DATE	Standard Who column.
PATTERN_NAME	Unique name to identify a pattern.
PATTERN_START_WEEKDAY	A day of the week on which the pattern must start.
PATTERN_START_TIME	A time of day (format HH:MI) at which the pattern must start.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.

Human Resources - HR_PATTERN_BITS	A defined period of time used to construct a pattern.
Column Name	Descritpion
PATTERN_BIT_ID	System-generated primary key column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
PATTERN_BIT_CODE	Unique name or code to identify the pattern bit.
BIT_MEANING	Explanation of the pattern bit and its purpose.
TIME_UNIT_MULTIPLIER	The figure by which the base time unit must be multiplied to find the duration of the pattern bit.
BASE_TIME_UNIT	Real time unit (hours/days/weeks) from which the pattern bit duration is derived.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.

Human Resources - HR_PATTERN_CONSTRUCTIONS	Decomposition of a repeating pattern into its individual 'bits' of time.
Column Name	Descritpion
PATTERN_CONSTRUCTION_ID	System-generated primary key column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
SEQUENCE_NO	The order of this row within its parent pattern.
AVAILABILITY	The availability applicable for the duration of the specified pattern bit. This may not be specified if no pattern_bit_id is specified.
PATTERN_ID	Foreign key to HR_PATTERNS. The pattern for which this construction is a part.
PATTERN_BIT_ID	Foreign key to HR_PATTERN_BITS.
COMPONENT_PATTERN_ID	Foreign key to HR_PATTERNS (PATTERN_ID). Identifies a pattern whose construction must be substituted into this point of the parent pattern.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.

Human Resources - HR_PATTERN_EXCEPTIONS	An exception to a repeating pattern.
Column Name	Descritpion
EXCEPTION_ID	System-generated primary key column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
PATTERN_ID	Foreign key to HR_PATTERNS.
EXCEPTION_NAME	Unique name of this exception, eg 'Thanksgiving Day 1996'.
EXCEPTION_START_TIME	The start date and time from which the exception will be applied.
EXCEPTION_END_TIME	The end date and time of the exception (derived from the start time and the duration of the pattern).
EXCEPTION_CATEGORY	A category for the exception (eg Company Holidays). Validated by lookup (EXCEPTION CATEGORY).
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.

Human Resources - HR_PATTERN_PURPOSES	Potential purpose for the parent pattern, eg 'Work Pattern', 'Resource schedule', etc.
Column Name	Descritpion
PATTERN_PURPOSE_ID	System-generated primary key column.
PATTERN_PURPOSE	Purpose for which the parent pattern may be used. Validated by lookup (PATTERN PURPOSE)
PATTERN_ID	Foreign key to HR_PATTERNS.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.

Human Resources - HR_PATTERN_PURPOSE_USAGES	Valid combinations of entities and pattern purposes.
Column Name	Descritpion
PURPOSE_USAGE_ID	System-generated primary key column.
LAST_UPDATE_DATE	Standard Who column.
ENTITY_NAME	Name of the entity. Validated by lookup (SCHEDULABLE ENTITY).
PATTERN_PURPOSE	Purpose of a pattern which is valid with the entity name. Validated by lookup (PATTERN PURPOSE).
HIERARCHY_LEVEL	Patterns may be inherited from higher level entities. The level is specified here.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.

Human Resources - HR_S_APPLICATION_OWNERSHIPS	- Retrofitted
Column Name	Descritpion
KEY_NAME
PRODUCT_NAME
KEY_VALUE

Human Resources - HR_S_ASSIGNMENT_INFO_TYPES	- Retrofitted
Column Name	Descritpion
INFORMATION_TYPE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
ACTIVE_INACTIVE_FLAG
MULTIPLE_OCCURENCES_FLAG
DESCRIPTION
LEGISLATION_CODE
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE

Human Resources - HR_S_ASSIGNMENT_STATUS_TYPES	- Retrofitted
Column Name	Descritpion
ASSIGNMENT_STATUS_TYPE_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
BUSINESS_GROUP_ID
LEGISLATION_CODE
ACTIVE_FLAG
DEFAULT_FLAG
PRIMARY_FLAG
USER_STATUS
PAY_SYSTEM_STATUS
PER_SYSTEM_STATUS

Human Resources - HR_S_BALANCE_CLASSIFICATIONS	- Retrofitted
Column Name	Descritpion
BALANCE_CLASSIFICATION_ID
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
BUSINESS_GROUP_ID
LEGISLATION_CODE
BALANCE_TYPE_ID
CLASSIFICATION_ID
SCALE
LEGISLATION_SUBGROUP
LAST_UPDATE_DATE
LAST_UPDATED_BY

Human Resources - HR_S_BALANCE_DIMENSIONS	- Retrofitted
Column Name	Descritpion
BALANCE_DIMENSION_ID
FEED_CHECKING_TYPE
LEGISLATION_SUBGROUP
PAYMENTS_FLAG
EXPIRY_CHECKING_CODE
EXPIRY_CHECKING_LEVEL
DIMENSION_LEVEL
BUSINESS_GROUP_ID
PERIOD_TYPE
ASG_ACTION_BALANCE_DIM_ID
LEGISLATION_CODE
SAVE_RUN_BALANCE_ENABLED
START_DATE_CODE
ROUTE_ID
DATABASE_ITEM_FUNCTION
DATABASE_ITEM_SUFFIX
DIMENSION_NAME
DIMENSION_TYPE
DESCRIPTION
FEED_CHECKING_CODE

Human Resources - HR_S_BALANCE_FEEDS_F	- Retrofitted
Column Name	Descritpion
BALANCE_FEED_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
BUSINESS_GROUP_ID
LEGISLATION_CODE
BALANCE_TYPE_ID
INPUT_VALUE_ID
SCALE
LEGISLATION_SUBGROUP

Human Resources - HR_S_BALANCE_TYPES	- Retrofitted
Column Name	Descritpion
BALANCE_TYPE_ID
LEGISLATION_SUBGROUP
REPORTING_NAME
TAX_TYPE
BALANCE_CATEGORY_ID
BASE_BALANCE_TYPE_ID
INPUT_VALUE_ID
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
BUSINESS_GROUP_ID
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
LEGISLATION_CODE
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
LAST_UPDATE_DATE
LAST_UPDATED_BY
CURRENCY_CODE
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
ASSIGNMENT_REMUNERATION_FLAG
BALANCE_NAME
BALANCE_UOM
COMMENTS
JURISDICTION_LEVEL

Human Resources - HR_S_BENEFIT_CLASSIFICATIONS	- Retrofitted
Column Name	Descritpion
BENEFIT_CLASSIFICATION_ID
CONTRIBUTIONS_USED
DEPENDENTS_ALLOWED_FLAG
DFLT_POST_TERMINATION_RULE
DFLT_PROCESSING_TYPE
BEN_CLASS_PROCESSING_RULE
COMMENTS
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
BUSINESS_GROUP_ID
CREATION_DATE
LEGISLATION_CODE
ACTIVE_FLAG
BENEFICIARY_ALLOWED_FLAG
BENEFIT_CLASSIFICATION_NAME
BENEFIT_CLASSIFICATION_TYPE
CHARGEABLE_FLAG
COBRA_FLAG

Human Resources - HR_S_COBRA_QFYING_EVENTS_F	- Retrofitted
Column Name	Descritpion
QUALIFYING_EVENT_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
BUSINESS_GROUP_ID
LEGISLATION_CODE
ELECTOR
EVENT_COVERAGE
QUALIFYING_EVENT
LEGISLATION_SUBGROUP

Human Resources - HR_S_COMMON_LOOKUPS	- Retrofitted
Column Name	Descritpion
APPLICATION_ID
ENABLED_FLAG
DESCRIPTION
START_DATE_ACTIVE
END_DATE_ACTIVE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
LOOKUP_TYPE
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
LOOKUP_CODE
MEANING
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN

Human Resources - HR_S_COMMON_LOOKUP_TYPES	- Retrofitted
Column Name	Descritpion
APPLICATION_ID
LOOKUP_TYPE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
CUSTOMIZATION_LEVEL
LOOKUP_TYPE_MEANING

Human Resources - HR_S_CONTEXTS	- Retrofitted
Column Name	Descritpion
CONTEXT_ID
CONTEXT_LEVEL
CONTEXT_NAME
DATA_TYPE

Human Resources - HR_S_DATABASE_ITEMS	- Retrofitted
Column Name	Descritpion
USER_NAME
CREATED_BY
CREATION_DATE
USER_ENTITY_ID
DATA_TYPE
DEFINITION_TEXT
NULL_ALLOWED_FLAG
DESCRIPTION
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN

Human Resources - HR_S_DEFINED_BALANCES	- Retrofitted
Column Name	Descritpion
DEFINED_BALANCE_ID
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
BUSINESS_GROUP_ID
GROSSUP_ALLOWED_FLAG
SAVE_RUN_BALANCE
LEGISLATION_CODE
RUN_BALANCE_STATUS
BALANCE_TYPE_ID
BALANCE_DIMENSION_ID
FORCE_LATEST_BALANCE_FLAG
LEGISLATION_SUBGROUP
LAST_UPDATE_DATE
LAST_UPDATED_BY

Human Resources - HR_S_ELEMENT_CLASSIFICATIONS	- Retrofitted
Column Name	Descritpion
CLASSIFICATION_ID
DEFAULT_PRIORITY
DISTRIBUTABLE_OVER_FLAG
NON_PAYMENTS_FLAG
COSTING_DEBIT_OR_CREDIT
PARENT_CLASSIFICATION_ID
CREATE_BY_DEFAULT_FLAG
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
BUSINESS_GROUP_ID
CREATION_DATE
BALANCE_INITIALIZATION_FLAG
OBJECT_VERSION_NUMBER
LEGISLATION_CODE
FREQ_RULE_ENABLED
CLASSIFICATION_NAME
DESCRIPTION
LEGISLATION_SUBGROUP
COSTABLE_FLAG
DEFAULT_HIGH_PRIORITY
DEFAULT_LOW_PRIORITY

Human Resources - HR_S_ELEMENT_SETS	- Retrofitted
Column Name	Descritpion
ELEMENT_SET_ID
CREATED_BY
CREATION_DATE
BUSINESS_GROUP_ID
LEGISLATION_CODE
ELEMENT_SET_NAME
ELEMENT_SET_TYPE
COMMENTS
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN

Human Resources - HR_S_ELEMENT_TYPES_F	- Retrofitted
Column Name	Descritpion
ELEMENT_TYPE_ID
BENEFIT_CLASSIFICATION_ID
ADDITIONAL_ENTRY_ALLOWED_FLAG
ADJUSTMENT_ONLY_FLAG
CREATOR_TYPE
RETRO_SUMM_ELE_ID
CLOSED_FOR_ENTRY_FLAG
GROSSUP_FLAG
PROCESS_MODE
ELEMENT_NAME
ADVANCE_INDICATOR
ADVANCE_PAYABLE
INDIRECT_ONLY_FLAG
ADVANCE_DEDUCTION
PROCESS_ADVANCE_ENTRY
MULTIPLE_ENTRIES_ALLOWED_FLAG
PRORATION_GROUP_ID
PRORATION_FORMULA_ID
MULTIPLY_VALUE_FLAG
RECALC_EVENT_GROUP_ID
ONCE_EACH_PERIOD_FLAG
POST_TERMINATION_RULE
PROCESS_IN_RUN_FLAG
EFFECTIVE_START_DATE
PROCESSING_PRIORITY
PROCESSING_TYPE
STANDARD_LINK_FLAG
COMMENT_ID
DESCRIPTION
LEGISLATION_SUBGROUP
QUALIFYING_AGE
QUALIFYING_LENGTH_OF_SERVICE
QUALIFYING_UNITS
REPORTING_NAME
EFFECTIVE_END_DATE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
BUSINESS_GROUP_ID
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
LEGISLATION_CODE
ATTRIBUTE20
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
ELEMENT_INFORMATION_CATEGORY
ELEMENT_INFORMATION1
ELEMENT_INFORMATION2
ELEMENT_INFORMATION3
FORMULA_ID
ELEMENT_INFORMATION4
ELEMENT_INFORMATION5
ELEMENT_INFORMATION6
ELEMENT_INFORMATION7
ELEMENT_INFORMATION8
ELEMENT_INFORMATION9
ELEMENT_INFORMATION10
ELEMENT_INFORMATION11
ELEMENT_INFORMATION12
ELEMENT_INFORMATION13
INPUT_CURRENCY_CODE
ELEMENT_INFORMATION14
ELEMENT_INFORMATION15
ELEMENT_INFORMATION16
ELEMENT_INFORMATION17
ELEMENT_INFORMATION18
ELEMENT_INFORMATION19
ELEMENT_INFORMATION20
THIRD_PARTY_PAY_ONLY_FLAG
OUTPUT_CURRENCY_CODE
OBJECT_VERSION_NUMBER
ITERATIVE_FLAG
CLASSIFICATION_ID
ITERATIVE_FORMULA_ID
ITERATIVE_PRIORITY

Human Resources - HR_S_ELEMENT_TYPE_RULES	- Retrofitted
Column Name	Descritpion
ELEMENT_TYPE_ID
ELEMENT_SET_ID
INCLUDE_OR_EXCLUDE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE

Human Resources - HR_S_ELE_CLASSN_RULES	- Retrofitted
Column Name	Descritpion
ELEMENT_SET_ID
CLASSIFICATION_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE

Human Resources - HR_S_FORMULAS_F	- Retrofitted
Column Name	Descritpion
FORMULA_ID
STICKY_FLAG
COMPILE_FLAG
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
BUSINESS_GROUP_ID
LEGISLATION_CODE
FORMULA_TYPE_ID
FORMULA_NAME
DESCRIPTION
FORMULA_TEXT

Human Resources - HR_S_FORMULA_RESULT_RULES_F	- Retrofitted
Column Name	Descritpion
FORMULA_RESULT_RULE_ID
LEGISLATION_SUBGROUP
SEVERITY_LEVEL
INPUT_VALUE_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
EFFECTIVE_START_DATE
OBJECT_VERSION_NUMBER
EFFECTIVE_END_DATE
BUSINESS_GROUP_ID
LEGISLATION_CODE
ELEMENT_TYPE_ID
STATUS_PROCESSING_RULE_ID
RESULT_NAME
RESULT_RULE_TYPE

Human Resources - HR_S_FORMULA_TYPES	- Retrofitted
Column Name	Descritpion
FORMULA_TYPE_ID
FORMULA_TYPE_NAME
TYPE_DESCRIPTION
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE

Human Resources - HR_S_FTYPE_CONTEXT_USAGES	- Retrofitted
Column Name	Descritpion
FORMULA_TYPE_ID
CONTEXT_ID

Human Resources - HR_S_FUNCTIONS	- Retrofitted
Column Name	Descritpion
FUNCTION_ID
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
DESCRIPTION	Description of the function.
BUSINESS_GROUP_ID
LEGISLATION_CODE
CLASS
NAME
ALIAS_NAME
DATA_TYPE
DEFINITION
LAST_UPDATE_DATE

Human Resources - HR_S_FUNCTION_CONTEXT_USAGES	- Retrofitted
Column Name	Descritpion
FUNCTION_ID
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
SEQUENCE_NUMBER
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
CONTEXT_ID
LAST_UPDATE_DATE	Standard Who column.

Human Resources - HR_S_FUNCTION_PARAMETERS	- Retrofitted
Column Name	Descritpion
FUNCTION_ID
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
SEQUENCE_NUMBER
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CLASS
CREATION_DATE	Standard Who column.
CONTINUING_PARAMETER
DATA_TYPE
NAME
OPTIONAL

Human Resources - HR_S_GLOBALS_F	- Retrofitted
Column Name	Descritpion
GLOBAL_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
BUSINESS_GROUP_ID
LEGISLATION_CODE
DATA_TYPE
GLOBAL_NAME
GLOBAL_DESCRIPTION
GLOBAL_VALUE

Human Resources - HR_S_HISTORY	- Retrofitted
Column Name	Descritpion
PACKAGE_NAME
DATE_OF_EXPORT
DATE_OF_IMPORT
STATUS
LEGISLATION_CODE

Human Resources - HR_S_INPUT_VALUES_F	- Retrofitted
Column Name	Descritpion
LOOKUP_TYPE
BUSINESS_GROUP_ID
LEGISLATION_CODE
FORMULA_ID
VALUE_SET_NAME
VALUE_SET_ID
DISPLAY_SEQUENCE
GENERATE_DB_ITEMS_FLAG
HOT_DEFAULT_FLAG
MANDATORY_FLAG
NAME
UOM
DEFAULT_VALUE
LEGISLATION_SUBGROUP
MAX_VALUE
MIN_VALUE
WARNING_OR_ERROR
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
INPUT_VALUE_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
ELEMENT_TYPE_ID

Human Resources - HR_S_LEGISLATION_RULES	- Retrofitted
Column Name	Descritpion
LEGISLATION_CODE
RULE_TYPE
RULE_MODE

Human Resources - HR_S_LEGISLATION_SUBGROUPS	- Retrofitted
Column Name	Descritpion
LEGISLATION_CODE
LEGISLATION_SUBGROUP
ACTIVE_INACTIVE_FLAG
LEGISLATION_SUBGROUP_NAME

Human Resources - HR_S_LEGISLATIVE_FIELD_INFO	- Retrofitted
Column Name	Descritpion
LEGISLATION_CODE
PROMPT
VALIDATION_NAME
VALIDATION_TYPE
TARGET_LOCATION
RULE_TYPE
RULE_MODE
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

Human Resources - HR_S_LOOKUP_TYPE_USAGES	- Retrofitted
Column Name	Descritpion
LOOKUP_TYPE
OWNING_APPLICATION_ID
USING_APPLICATION_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN

Human Resources - HR_S_MONETARY_UNITS	- Retrofitted
Column Name	Descritpion
MONETARY_UNIT_ID
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
CURRENCY_CODE
BUSINESS_GROUP_ID
LEGISLATION_CODE
MONETARY_UNIT_NAME
RELATIVE_VALUE
COMMENTS
LAST_UPDATE_DATE
LAST_UPDATED_BY

Human Resources - HR_S_ORG_INFORMATION_TYPES	- Retrofitted
Column Name	Descritpion
ORG_INFORMATION_TYPE
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
DESCRIPTION
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
DESTINATION
CREATION_DATE	Standard Who column.
DISPLAYED_ORG_INFORMATION_TYPE
FND_APPLICATION_ID
LEGISLATION_CODE
NAVIGATION_METHOD

Human Resources - HR_S_ORG_INFO_TYPES_BY_CLASS	- Retrofitted
Column Name	Descritpion
ORG_CLASSIFICATION
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
ENABLED_FLAG
ORG_INFORMATION_TYPE
MANDATORY_FLAG

Human Resources - HR_S_PAYMENT_TYPES	- Retrofitted
Column Name	Descritpion
PAYMENT_TYPE_ID
VALIDATION_DAYS
VALIDATION_VALUE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
RECONCILIATION_FUNCTION	PLSQL procedure for reconciling magnetic tape process.
TERRITORY_CODE
CURRENCY_CODE
CATEGORY
PAYMENT_TYPE_NAME
ALLOW_AS_DEFAULT
DESCRIPTION
PRE_VALIDATION_REQUIRED
PROCEDURE_NAME

Human Resources - HR_S_ROUTES	- Retrofitted
Column Name	Descritpion
ROUTE_ID
CREATION_DATE
ROUTE_NAME
USER_DEFINED_FLAG
DESCRIPTION
TEXT
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
OPTIMIZER_HINT
CREATED_BY

Human Resources - HR_S_ROUTE_CONTEXT_USAGES	- Retrofitted
Column Name	Descritpion
ROUTE_ID
CONTEXT_ID
SEQUENCE_NO

Human Resources - HR_S_ROUTE_PARAMETERS	- Retrofitted
Column Name	Descritpion
ROUTE_PARAMETER_ID
ROUTE_ID
DATA_TYPE
PARAMETER_NAME
SEQUENCE_NO

Human Resources - HR_S_ROUTE_PARAMETER_VALUES	- Retrofitted
Column Name	Descritpion
ROUTE_PARAMETER_ID
USER_ENTITY_ID
VALUE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE

Human Resources - HR_S_STATE_RULES	- Retrofitted
Column Name	Descritpion
STATE_CODE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
FIPS_CODE
FS_LOOKUP_TYPE
JURISDICTION_CODE
NAME
HEAD_TAX_PERIOD
WC_OVERTIME_HOURS
WC_EXECUTIVE_WEEKLY_MAX
LAST_UPDATE_DATE

Human Resources - HR_S_STATUS_PROCESSING_RULES_F	- Retrofitted
Column Name	Descritpion
STATUS_PROCESSING_RULE_ID
COMMENT_ID
LEGISLATION_SUBGROUP
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
EFFECTIVE_START_DATE
OBJECT_VERSION_NUMBER
EFFECTIVE_END_DATE
BUSINESS_GROUP_ID
LEGISLATION_CODE
ELEMENT_TYPE_ID
ASSIGNMENT_STATUS_TYPE_ID
FORMULA_ID
PROCESSING_RULE

Human Resources - HR_S_SUB_CLASSN_RULES_F	- Retrofitted
Column Name	Descritpion
SUB_CLASSIFICATION_RULE_ID
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
ELEMENT_TYPE_ID
CLASSIFICATION_ID
BUSINESS_GROUP_ID
LEGISLATION_CODE
LAST_UPDATE_DATE
LAST_UPDATED_BY

Human Resources - HR_S_TAXABILITY_RULES	- Retrofitted
Column Name	Descritpion
LEGISLATION_CODE	Foreign key to FND_TERRITORIES.
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.
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CLASSIFICATION_ID
CREATED_BY
CREATION_DATE
STATUS
SECONDARY_CLASSIFICATION_ID
JURISDICTION_CODE	Geocode of the jurisdiction: Federal or State.
TAX_CATEGORY
TAX_TYPE

Human Resources - HR_S_USER_COLUMNS	- Retrofitted
Column Name	Descritpion
USER_COLUMN_ID
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
BUSINESS_GROUP_ID
LEGISLATION_CODE
USER_TABLE_ID
FORMULA_ID
USER_COLUMN_NAME
LEGISLATION_SUBGROUP
LAST_UPDATE_DATE
LAST_UPDATED_BY

Human Resources - HR_S_USER_COLUMN_INSTANCES_F	- Retrofitted
Column Name	Descritpion
USER_COLUMN_INSTANCE_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
USER_ROW_ID
USER_COLUMN_ID
BUSINESS_GROUP_ID
LEGISLATION_CODE
LEGISLATION_SUBGROUP
VALUE

Human Resources - HR_S_USER_ENTITIES	- Retrofitted
Column Name	Descritpion
USER_ENTITY_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
BUSINESS_GROUP_ID
LEGISLATION_CODE
ROUTE_ID
NOTFOUND_ALLOWED_FLAG
USER_ENTITY_NAME
CREATOR_ID
CREATOR_TYPE
ENTITY_DESCRIPTION

Human Resources - HR_S_USER_ROWS_F	- Retrofitted
Column Name	Descritpion
USER_ROW_ID
ROW_HIGH_RANGE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
EFFECTIVE_START_DATE
OBJECT_VERSION_NUMBER
EFFECTIVE_END_DATE
BUSINESS_GROUP_ID
LEGISLATION_CODE
USER_TABLE_ID
ROW_LOW_RANGE_OR_NAME
DISPLAY_SEQUENCE
LEGISLATION_SUBGROUP

Human Resources - HR_S_USER_TABLES	- Retrofitted
Column Name	Descritpion
USER_TABLE_ID
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
BUSINESS_GROUP_ID
LEGISLATION_CODE
RANGE_OR_MATCH
USER_KEY_UNITS
USER_TABLE_NAME
LEGISLATION_SUBGROUP
USER_ROW_TITLE
LAST_UPDATE_DATE

Human Resources - HR_S_VALID_DEPENDENT_TYPES	- Retrofitted
Column Name	Descritpion
VALID_DEPENDENT_TYPE_ID
CREATED_BY
CREATION_DATE
BUSINESS_GROUP_ID
LEGISLATION_CODE
CONTACT_TYPE
COVERAGE_TYPE
MAXIMUM_NUMBER
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN

Human Resources - HR_S_WC_STATE_SURCHARGES	- Retrofitted
Column Name	Descritpion
SURCHARGE_ID
CREATED_BY
CREATION_DATE
STATE_CODE
ADD_TO_RT
NAME
POSITION
RATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN

Human Resources - HR_S_QP_REPORTS	- Retrofitted
Column Name	Descritpion
QP_REPORT_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
BUSINESS_GROUP_ID
LEGISLATION_CODE
FORMULA_ID
FORMULA_TYPE_ID
QP_REPORT_NAME
QP_ALTERED_FORMULA
QP_DESCRIPTION
QP_TEXT

Human Resources - HR_LOCATION_INFO_TYPES	Types of extra information that may be held against a Location.
Column Name	Descritpion
INFORMATION_TYPE	The name or code of the information type, which is also the primary key.
PROGRAM_ID	Standard who column
PROGRAM_UPDATE_DATE	Standard who column
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
CREATED_BY	Standard who column
ACTIVE_INACTIVE_FLAG	Indicates whether the information type is active or inactive.
CREATION_DATE	Standard who column
MULTIPLE_OCCURENCES_FLAG	Indicates whether a location may have multiple occurrences of this type.
DESCRIPTION	Description of the information type.
LEGISLATION_CODE	The legislation to which the information type applies.
REQUEST_ID	Standard who column
PROGRAM_APPLICATION_ID	Standard who column

Human Resources - HR_LOCATION_EXTRA_INFO	Extra information for a location.
Column Name	Descritpion
LOCATION_EXTRA_INFO_ID	System-generated primary key column.
REQUEST_ID	Standard who column
LEI_INFORMATION25	Developer descriptive flexfield
LEI_INFORMATION26	Developer descriptive flexfield
LEI_INFORMATION27	Developer descriptive flexfield
LEI_INFORMATION28	Developer descriptive flexfield
LEI_INFORMATION29	Developer descriptive flexfield
LEI_INFORMATION30	Developer descriptive flexfield
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
PROGRAM_APPLICATION_ID	standard who column
PROGRAM_ID	standard who column
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
PROGRAM_UPDATE_DATE	standard who column
LEI_ATTRIBUTE_CATEGORY	Descriptive flexfield
LEI_ATTRIBUTE1	Descriptive flexfield
LEI_ATTRIBUTE2	Descriptive flexfield
LEI_ATTRIBUTE3	Descriptive flexfield
LEI_ATTRIBUTE4	Descriptive flexfield
LEI_ATTRIBUTE5	Descriptive flexfield
LEI_ATTRIBUTE6	Descriptive flexfield
LEI_ATTRIBUTE7	Descriptive flexfield
LEI_ATTRIBUTE8	Descriptive flexfield
LEI_ATTRIBUTE9	Descriptive flexfield
LEI_ATTRIBUTE10	Descriptive flexfield
LEI_ATTRIBUTE11	Descriptive flexfield
LEI_ATTRIBUTE12	Descriptive flexfield
LEI_ATTRIBUTE13	Descriptive flexfield
LEI_ATTRIBUTE14	Descriptive flexfield
LEI_ATTRIBUTE15	Descriptive flexfield
LEI_ATTRIBUTE16	Descriptive flexfield
LEI_ATTRIBUTE17	Descriptive flexfield
LEI_ATTRIBUTE18	Descriptive flexfield
LEI_ATTRIBUTE19	Descriptive flexfield
LEI_ATTRIBUTE20	Descriptive flexfield
INFORMATION_TYPE	Foriegn Key to HR_LOCATION_INFO_TYPES
LEI_INFORMATION_CATEGORY	Developer descriptive flexfield
LEI_INFORMATION1	Developer descriptive flexfield
LEI_INFORMATION2	Developer descriptive flexfield
LEI_INFORMATION3	Developer descriptive flexfield
LEI_INFORMATION4	Developer descriptive flexfield
LEI_INFORMATION5	Developer descriptive flexfield
LEI_INFORMATION6	Developer descriptive flexfield
LEI_INFORMATION7	Developer descriptive flexfield
LEI_INFORMATION8	Developer descriptive flexfield
LEI_INFORMATION9	Developer descriptive flexfield
LOCATION_ID	Foriegn Key to HR_LOCATIONS
LEI_INFORMATION10	Developer descriptive flexfield
LEI_INFORMATION11	Developer descriptive flexfield
LEI_INFORMATION12	Developer descriptive flexfield
LEI_INFORMATION13	Developer descriptive flexfield
LEI_INFORMATION14	Developer descriptive flexfield
LEI_INFORMATION15	Developer descriptive flexfield
LEI_INFORMATION16	Developer descriptive flexfield
LEI_INFORMATION17	Developer descriptive flexfield
LEI_INFORMATION18	Developer descriptive flexfield
LEI_INFORMATION19	Developer descriptive flexfield
LEI_INFORMATION20	Developer descriptive flexfield
LEI_INFORMATION21	Developer descriptive flexfield
LEI_INFORMATION22	Developer descriptive flexfield
LEI_INFORMATION23	Developer descriptive flexfield
LEI_INFORMATION24	Developer descriptive flexfield

Human Resources - HR_S_US_CITY_NAMES	US cities and their VERTEX geocodes, used to validate US addresses.
Column Name	Descritpion
CITY_NAME	City name.
DISABLE
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.
PRIMARY_FLAG	Used when the geocode represents more than one city.

Human Resources - HR_S_US_ZIP_CODES	Valid zip code ranges for VERTEX cities, used to validate US addresses.
Column Name	Descritpion
ZIP_START	Start of zip code range.
ZIP_END	End of zip code range.
STATE_CODE	State geocode. Foreign key to PAY_US_COUNTIES.
COUNTY_CODE	County geocode. Foreign key to PAY_US_COUNTIES.
CITY_CODE	City geocode. Foreign key to PAY_US_CITY_GEOCODES.

Human Resources - HR_S_US_CITY_TAX_INFO_F	Element definitions.
Column Name	Descritpion
CITY_TAX_INFO_ID	System-generated primary key column.
REQUEST_ID	Standard Concurrent Program Who column.
PROGRAM_APPLICATION_ID	Standard Concurrent Program Who column.
PROGRAM_ID	Standard Concurrent Program Who column.
PROGRAM_UPDATE_DATE	Standard Concurrent Program Who column.
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 defining 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.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
SCHOOL_TAX	School tax exists for city (Y/N)

Human Resources - HR_S_US_COUNTY_TAX_INFO_F	Element definitions.
Column Name	Descritpion
COUNTY_TAX_INFO_ID	System-generated primary key column.
REQUEST_ID	Standard Concurrent Program Who column.
PROGRAM_APPLICATION_ID	Standard Concurrent Program Who column.
PROGRAM_ID	Standard Concurrent Program Who column.
PROGRAM_UPDATE_DATE	Standard Concurrent Program Who column.
CNTY_INFORMATION_CATEGORY	Developer Descriptive Flexfield
CNTY_INFORMATION1	Developer Descriptive Flexfield
CNTY_INFORMATION2	Developer Descriptive Flexfield
CNTY_INFORMATION3	Developer Descriptive Flexfield
CNTY_INFORMATION4	Developer Descriptive Flexfield
CNTY_INFORMATION5	Developer Descriptive Flexfield
CNTY_INFORMATION6	Developer Descriptive Flexfield
CNTY_INFORMATION7	Developer Descriptive Flexfield
CNTY_INFORMATION8	Developer Descriptive Flexfield
CNTY_INFORMATION9	Developer Descriptive Flexfield
CNTY_INFORMATION10	Developer Descriptive Flexfield
CNTY_INFORMATION11	Developer Descriptive Flexfield
CNTY_INFORMATION12	Developer Descriptive Flexfield
CNTY_INFORMATION13	Developer Descriptive Flexfield
EFFECTIVE_START_DATE	Effective start date.
CNTY_INFORMATION14	Developer Descriptive Flexfield
CNTY_INFORMATION15	Developer Descriptive Flexfield
CNTY_INFORMATION16	Developer Descriptive Flexfield
CNTY_INFORMATION17	Developer Descriptive Flexfield
CNTY_INFORMATION18	Developer Descriptive Flexfield
CNTY_INFORMATION19	Developer Descriptive Flexfield
CNTY_INFORMATION20	Developer Descriptive Flexfield
CNTY_INFORMATION21	Developer Descriptive Flexfield
CNTY_INFORMATION22	Developer Descriptive Flexfield
CNTY_INFORMATION23	Developer Descriptive Flexfield
CNTY_INFORMATION24	Developer Descriptive Flexfield
CNTY_INFORMATION25	Developer Descriptive Flexfield
CNTY_INFORMATION26	Developer Descriptive Flexfield
CNTY_INFORMATION27	Developer Descriptive Flexfield
CNTY_INFORMATION28	Developer Descriptive Flexfield
CNTY_INFORMATION29	Developer Descriptive Flexfield
CNTY_INFORMATION30	Developer Descriptive Flexfield
EFFECTIVE_END_DATE	Effective end date.
JURISDICTION_CODE	Full Jurisdiction geocode
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
CNTY_ATTRIBUTE1	Descriptive flexfield column.
CNTY_ATTRIBUTE2	Descriptive flexfield column.
CNTY_ATTRIBUTE3	Descriptive flexfield column.
CNTY_ATTRIBUTE4	Descriptive flexfield column.
CNTY_ATTRIBUTE5	Descriptive flexfield column.
CNTY_ATTRIBUTE6	Descriptive flexfield column.
CNTY_ATTRIBUTE7	Descriptive flexfield column.
COUNTY_TAX	County tax exists for county (Y/N)
CNTY_ATTRIBUTE8	Descriptive flexfield column.
CNTY_ATTRIBUTE9	Descriptive flexfield column.
CNTY_ATTRIBUTE10	Descriptive flexfield column.
CNTY_ATTRIBUTE11	Descriptive flexfield column.
CNTY_ATTRIBUTE12	Descriptive flexfield column.
CNTY_ATTRIBUTE13	Descriptive flexfield column.
CNTY_ATTRIBUTE14	Descriptive flexfield column.
CNTY_ATTRIBUTE15	Descriptive flexfield column.
HEAD_TAX	Head Tax exists for county (Y/N)
CNTY_ATTRIBUTE16	Descriptive flexfield column.
CNTY_ATTRIBUTE17	Descriptive flexfield column.
CNTY_ATTRIBUTE18	Descriptive flexfield column.
CNTY_ATTRIBUTE19	Descriptive flexfield column.
CNTY_ATTRIBUTE20	Descriptive flexfield column.
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.
SCHOOL_TAX	School tax exists for county (Y/N)

Human Resources - HR_S_US_FEDERAL_TAX_INFO_F	Element definitions.
Column Name	Descritpion
FEDERAL_TAX_INFO_ID	System-generated primary key column.
SS_ER_RATE	SS ER rate
FED_INFORMATION28	Developer descriptive flexfield column.
FED_INFORMATION29	Developer descriptive flexfield column.
FED_INFORMATION30	Developer descriptive flexfield column.
MEDI_EE_RATE	MEDI EE rate
MEDI_ER_RATE	MEDI ER rate
REQUEST_ID	Standard Concurrent Program Who column.
PROGRAM_APPLICATION_ID	Standard Concurrent Program Who column.
PROGRAM_ID	Standard Concurrent Program Who column.
PROGRAM_UPDATE_DATE	Standard Concurrent Program Who column.
EFFECTIVE_START_DATE	Effective start date.
EFFECTIVE_END_DATE	Effective end date.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
FED_ATTRIBUTE1	Descriptive flexfield column.
FED_ATTRIBUTE2	Descriptive flexfield column.
FED_ATTRIBUTE3	Descriptive flexfield column.
FED_ATTRIBUTE4	Descriptive flexfield column.
FED_ATTRIBUTE5	Descriptive flexfield column.
FUTA_WAGE_LIMIT	FUTA ER wage base limit
FED_ATTRIBUTE6	Descriptive flexfield column.
FED_ATTRIBUTE7	Descriptive flexfield column.
FED_ATTRIBUTE8	Descriptive flexfield column.
FED_ATTRIBUTE9	Descriptive flexfield column.
FED_ATTRIBUTE10	Descriptive flexfield column.
FED_ATTRIBUTE11	Descriptive flexfield column.
FED_ATTRIBUTE12	Descriptive flexfield column.
FED_ATTRIBUTE13	Descriptive flexfield column.
FUTA_RATE	FUTA ER rate
FED_ATTRIBUTE14	Descriptive flexfield column.
FED_ATTRIBUTE15	Descriptive flexfield column.
FED_ATTRIBUTE16	Descriptive flexfield column.
FED_ATTRIBUTE17	Descriptive flexfield column.
FED_ATTRIBUTE18	Descriptive flexfield column.
FED_ATTRIBUTE19	Descriptive flexfield column.
FED_ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
SS_EE_WAGE_LIMIT	SS EE wage base limit
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
FED_INFORMATION_CATEGORY	Developer descriptive flexfield column.
FED_INFORMATION1	Developer descriptive flexfield column.
FED_INFORMATION2	Developer descriptive flexfield column.
FED_INFORMATION3	Developer descriptive flexfield column.
FED_INFORMATION4	Developer descriptive flexfield column.
FED_INFORMATION5	Developer descriptive flexfield column.
FED_INFORMATION6	Developer descriptive flexfield column.
FED_INFORMATION7	Developer descriptive flexfield column.
SS_EE_RATE	SS EE rate
FED_INFORMATION8	Developer descriptive flexfield column.
FED_INFORMATION9	Developer descriptive flexfield column.
FED_INFORMATION10	Developer descriptive flexfield column.
FED_INFORMATION11	Developer descriptive flexfield column.
FED_INFORMATION12	Developer descriptive flexfield column.
FED_INFORMATION13	Developer descriptive flexfield column.
FED_INFORMATION14	Developer descriptive flexfield column.
FED_INFORMATION15	Developer descriptive flexfield column.
FED_INFORMATION16	Developer descriptive flexfield column.
FED_INFORMATION17	Developer descriptive flexfield column.
SS_ER_WAGE_LIMIT	SS ER wage base limit
FED_INFORMATION18	Developer descriptive flexfield column.
FED_INFORMATION19	Developer descriptive flexfield column.
FED_INFORMATION20	Developer descriptive flexfield column.
FED_INFORMATION21	Developer descriptive flexfield column.
FED_INFORMATION22	Developer descriptive flexfield column.
FED_INFORMATION23	Developer descriptive flexfield column.
FED_INFORMATION24	Developer descriptive flexfield column.
FED_INFORMATION25	Developer descriptive flexfield column.
FED_INFORMATION26	Developer descriptive flexfield column.
FED_INFORMATION27	Developer descriptive flexfield column.

Human Resources - HR_S_US_STATE_TAX_INFO_F	Element definitions.
Column Name	Descritpion
STATE_TAX_INFO_ID	System-generated primary key column.
SHI_EE_WAGE_LIMIT	SHI EE wage base limit
STA_INFORMATION30	Developer descriptive flexfield column.
SHI_ER_WAGE_LIMIT	SHI EE wage base limit
REQUEST_ID	Standard Concurrent Program Who column.
PROGRAM_APPLICATION_ID	Standard Concurrent Program Who column.
PROGRAM_ID	Standard Concurrent Program Who column.
PROGRAM_UPDATE_DATE	Standard Concurrent Program Who column.
STATE_CODE	State Geocode
EFFECTIVE_START_DATE	Effective start date.
EFFECTIVE_END_DATE	Effective end date.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
STA_ATTRIBUTE1	Descriptive flexfield column.
STA_ATTRIBUTE2	Descriptive flexfield column.
STA_ATTRIBUTE3	Descriptive flexfield column.
STA_ATTRIBUTE4	Descriptive flexfield column.
STA_ATTRIBUTE5	Descriptive flexfield column.
STA_ATTRIBUTE6	Descriptive flexfield column.
STA_ATTRIBUTE7	Descriptive flexfield column.
SIT_EXISTS	State Income tax exists for state (Y/N)
STA_ATTRIBUTE8	Descriptive flexfield column.
STA_ATTRIBUTE9	Descriptive flexfield column.
STA_ATTRIBUTE10	Descriptive flexfield column.
STA_ATTRIBUTE11	Descriptive flexfield column.
STA_ATTRIBUTE12	Descriptive flexfield column.
STA_ATTRIBUTE13	Descriptive flexfield column.
STA_ATTRIBUTE14	Descriptive flexfield column.
STA_ATTRIBUTE15	Descriptive flexfield column.
SUI_EE_WAGE_LIMIT	SUI EE wage base limit
STA_ATTRIBUTE16	Descriptive flexfield column.
STA_ATTRIBUTE17	Descriptive flexfield column.
STA_ATTRIBUTE18	Descriptive flexfield column.
STA_ATTRIBUTE19	Descriptive flexfield column.
STA_ATTRIBUTE20	Descriptive flexfield column.
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.
SUI_ER_WAGE_LIMIT	SUI ER wage base limit
STA_INFORMATION_CATEGORY	Developer descriptive flexfield column.
STA_INFORMATION1	Developer descriptive flexfield column.
STA_INFORMATION2	Developer descriptive flexfield column.
STA_INFORMATION3	Developer descriptive flexfield column.
STA_INFORMATION4	Developer descriptive flexfield column.
STA_INFORMATION5	Developer descriptive flexfield column.
STA_INFORMATION6	Developer descriptive flexfield column.
STA_INFORMATION7	Developer descriptive flexfield column.
STA_INFORMATION8	Developer descriptive flexfield column.
STA_INFORMATION9	Developer descriptive flexfield column.
SDI_EE_WAGE_LIMIT	SDI EE wage base limit
STA_INFORMATION10	Developer descriptive flexfield column.
STA_INFORMATION11	Developer descriptive flexfield column.
STA_INFORMATION12	Developer descriptive flexfield column.
STA_INFORMATION13	Developer descriptive flexfield column.
STA_INFORMATION14	Developer descriptive flexfield column.
STA_INFORMATION15	Developer descriptive flexfield column.
STA_INFORMATION16	Developer descriptive flexfield column.
STA_INFORMATION17	Developer descriptive flexfield column.
STA_INFORMATION18	Developer descriptive flexfield column.
STA_INFORMATION19	Developer descriptive flexfield column.
SDI_ER_WAGE_LIMIT	SDI ER wage base limit
STA_INFORMATION20	Developer descriptive flexfield column.
STA_INFORMATION21	Developer descriptive flexfield column.
STA_INFORMATION22	Developer descriptive flexfield column.
STA_INFORMATION23	Developer descriptive flexfield column.
STA_INFORMATION24	Developer descriptive flexfield column.
STA_INFORMATION25	Developer descriptive flexfield column.
STA_INFORMATION26	Developer descriptive flexfield column.
STA_INFORMATION27	Developer descriptive flexfield column.
STA_INFORMATION28	Developer descriptive flexfield column.
STA_INFORMATION29	Developer descriptive flexfield column.

Human Resources - HR_PUMP_BATCH_HEADERS	Stores information on a batch to be loaded by the data pump.
Column Name	Descritpion
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.
BATCH_ID	System generated primary key column.
REFERENCE	User-defined reference information.
ATOMIC_LINKED_CALLS	Flag parameter to control linked API execution.
BATCH_NAME	User's name for the batch.
BATCH_STATUS	Processing status of the batch.
BUSINESS_GROUP_NAME	Business group for which the batch is run.

Human Resources - HR_PUMP_BATCH_EXCEPTIONS	Holds data pump processing exception (error) information.
Column Name	Descritpion
SOURCE_ID	Foreign key value for the message source table.
SOURCE_TYPE	Specifies the source of the exception.
EXCEPTION_LEVEL	Indicates the severity of the exception.
EXCEPTION_SEQUENCE	Sequence number generated using HR_PUMP_BATCH_EXCEPTIONS_S.
EXCEPTION_TEXT	The exception message text.
FORMAT	The format in which the message text is held.

Human Resources - HR_PUMP_MODULE_PARAMETERS	Holds seeded information about API parameters for data pump code generation.
Column Name	Descritpion
DEFAULT_VALUE	Non-standard default value for this parameter.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
MAPPING_DEFINITION	Value is specific to MAPPING_TYPE.
API_MODULE_TYPE	Used with MODULE_NAME to identify the API.
MAPPING_TYPE	Used to specify how data pump show process this API parameter.
MODULE_NAME
API_PARAMETER_NAME	Name of the API parameter.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.

Human Resources - HR_PUMP_REQUESTS	Holds information on data pump concurrent requests currently running.
Column Name	Descritpion
BATCH_ID	Foreign key to HR_PUMP_BATCH_HEADERS. Specifies the batch being processed by the data pump process.
PROCESS_TYPE	Used to specify the type of the data pump process.
REQUEST_ID	Specifies the concurrent manager REQUEST_ID for this process.

Human Resources - HR_PUMP_BATCH_LINES	Each rows stores the information required to make an API call. OUT-parameter values are written back after the API call.
Column Name	Descritpion
LINK_VALUE	Used to group API calls for execution within a single thread.
PVAL044
PVAL045
PVAL046
PVAL047
PVAL048
USER_SEQUENCE	Used to override the default ordering of API calls by BATCH_LINE_ID.
PVAL049
PVAL050
PVAL051
PVAL052
PVAL053
PROCESS_SEQUENCE	Used by the system to order API calls during a data pump run.
PVAL054
PVAL055
PVAL056
PVAL057
PVAL058
PVAL059
PVAL060
PVAL061
PVAL062
PVAL063
PVAL001	The PVAL columns are used to hold API parameter values.
PVAL064
PVAL065
PVAL066
PVAL067
PVAL068
PVAL069
PVAL070
PVAL071
PVAL072
PVAL073
PVAL002
PVAL074
PVAL075
PVAL076
PVAL077
PVAL078
PVAL079
PVAL080
PVAL081
PVAL082
PVAL083
PVAL003
PVAL084
PVAL085
PVAL086
PVAL087
PVAL088
PVAL089
PVAL090
PVAL091
PVAL092
PVAL093
API_MODULE_ID	Foreign key to HR_API_MODULES. Specifies the API to be executed.
PVAL004
PVAL094
PVAL095
PVAL096
PVAL097
PVAL098
PVAL099
PVAL100
PVAL101
PVAL102
PVAL103
PVAL005
PVAL104
PVAL105
PVAL106
PVAL107
PVAL108
PVAL109
PVAL110
PVAL111
PVAL112
PVAL113
PVAL006
PVAL114
PVAL115
PVAL116
PVAL117
PVAL118
PVAL119
PVAL120
PVAL121
PVAL122
PVAL123
PVAL007
PVAL124
PVAL125
PVAL126
PVAL127
PVAL128
PVAL129
PVAL130
PVAL131
PVAL132
PVAL133
PVAL008
PVAL134
PVAL135
PVAL136
PVAL137
PVAL138
PVAL139
PVAL140
PVAL141
PVAL142
PVAL143
PVAL009
PVAL144
PVAL145
PVAL146
PVAL147
PVAL148
PVAL149
PVAL150
PVAL151
PVAL152
PVAL153
PVAL010
PVAL154
PVAL155
PVAL156
PVAL157
PVAL158
PVAL159
PVAL160
PVAL161
PVAL162
PVAL163
PVAL011
PVAL164
PVAL165
PVAL166
PVAL167
PVAL168
PVAL169
PVAL170
PVAL171
PVAL172
PVAL173
PVAL012
PVAL174
PVAL175
PVAL176
PVAL177
PVAL178
PVAL179
PVAL180
PVAL181
PVAL182
PVAL183
PVAL013
PVAL184
PVAL185
PVAL186
PVAL187
PVAL188
PVAL189
PVAL190
PVAL191
PVAL192
PVAL193
BATCH_ID	Foreign key to HR_PUMP_BATCH_HEADERS. Specifies the batch that this API call belongs to.
PVAL014
PVAL194
PVAL195
PVAL196
PVAL197
PVAL198
PVAL199
PVAL200
PVAL201
PVAL202
PVAL203
PVAL015
PVAL204
PVAL205
PVAL206
PVAL207
PVAL208
PVAL209
PVAL210
PVAL211
PVAL212
PVAL213
PVAL016
PVAL214
PVAL215
PVAL216
PVAL217
PVAL218
PVAL219
PVAL220
PVAL221
PVAL222
PVAL223
PVAL017
PVAL224
PVAL225
PVAL226
PVAL227
PVAL228
PVAL229
PVAL230
PLONGVAL	Used to store LONG parameter values.
PVAL018
BUSINESS_GROUP_NAME	If not null, this value overrides BUSINESS_GROUP_NAME from HR_PUMP_BATCH_HEADERS.
PVAL019
PVAL020
PVAL021
PVAL022
PVAL023
BATCH_LINE_ID	System generated primary key.
PVAL024
PVAL025
PVAL026
PVAL027
PVAL028
PVAL029
PVAL030
PVAL031
PVAL032
PVAL033
LINE_STATUS	Processing status of this batch line.
PVAL034
PVAL035
PVAL036
PVAL037
PVAL038
PVAL039
PVAL040
PVAL041
PVAL042
PVAL043

Human Resources - HR_PUMP_RANGES	Controls the parallelisation of the work when the data pump is running on multiprocessor platforms.
Column Name	Descritpion
STARTING_PROCESS_SEQUENCE	Start value of the range to be processed.
BATCH_ID	Foreign key to HR_PUMP_BATCH_LINES. Specifies the batch to be executed.
ENDING_PROCESS_SEQUENCE	End value of the range to be processed.
RANGE_NUMBER	Used with BATCH_ID to identify the range.
RANGE_STATUS	Processing status for this range.

Human Resources - HR_PUMP_DEFAULT_EXCEPTIONS	Lists API modules that do not conform to the API parameter defaulting rules.
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
MODULE_NAME
API_MODULE_TYPE	Used with MODULE_NAME to identify the API.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.

Human Resources - HR_PUMP_BATCH_LINE_USER_KEYS	User keys and their associated information is stored here on the creation of entities that require user keys.
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
UNIQUE_KEY_ID	System generated primary key.
USER_KEY_ID	Surrogate primary key value reference using this user key.
USER_KEY_VALUE	Name value used in data pump API calls.
BATCH_LINE_ID	Foreign key to HR_PUMP_BATCH_LINES. Specifies the API call that created this user key.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.

Human Resources - HR_QUEST_ANSWER_VALUES	Answer values for a questionnaire.
Column Name	Descritpion
QUEST_ANSWER_VAL_ID	System generated primary key from HR_QUEST_ANSWER_VALUES_S.
LAST_UPDATE_DATE	Standard Who column.
CREATION_DATE	Standard Who column.
QUESTIONNAIRE_ANSWER_ID	Foreign key to HR_QUEST_ANSWERS.
FIELD_ID	Foreign key to HR_QUEST_FIELDS.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
VALUE	Answer value.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.

Human Resources - HR_QUEST_ANSWERS	Answers for a questionnaire.
Column Name	Descritpion
QUESTIONNAIRE_ANSWER_ID	System generated primary key from HR_QUEST_ANSWERS_S.
LAST_UPDATE_DATE	Standard Who column.
CREATION_DATE	Standard Who column.
QUESTIONNAIRE_TEMPLATE_ID	Foreign Key to HR_QUESTIONNAIRES.
TYPE	Type of object that this answer set is for (eg. APPRAISAL, PARTICIPANT).
TYPE_OBJECT_ID	Primary key identifier for the object using this answer set.
BUSINESS_GROUP_ID	Foreign key to HR_ALL_ORGANIZATION_UNITS.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.

Human Resources - HR_QUEST_FIELDS	Fields of a questionnaire.
Column Name	Descritpion
FIELD_ID	System generated primary key from HR_QUEST_FIELDS_S.
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.
QUESTIONNAIRE_TEMPLATE_ID	Foreign Key to HR_QUESTIONNAIRES.
NAME	Field name.
TYPE	Field type.
HTML_TEXT	Additional HTML code used to define this field.
SQL_REQUIRED_FLAG	Indicates whether a SQL statement is used to determine available values for this field.
SQL_TEXT	SQL statement used to generate available values for this field.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.

Human Resources - HR_QUESTIONNAIRES	Questionnaires used within SSHR.
Column Name	Descritpion
QUESTIONNAIRE_TEMPLATE_ID	System generated primary key from HR_QUESTIONNAIRES_S.
LAST_UPDATE_DATE	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
NAME	Questionnaire name.
TEXT	HTML code for the questionnaire.
AVAILABLE_FLAG	Indicates whether the questionnaire is available for use.
BUSINESS_GROUP_ID	Foreign key to HR_ALL_ORGANIZATION_UNITS.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.

Human Resources - HR_LOCATIONS_ALL_TL	Translated location codes and descriptions.
Column Name	Descritpion
LANGUAGE	Defined language
SOURCE_LANG	Actual language
LOCATION_CODE	Translated location name
DESCRIPTION	Translated description of the location.
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
CREATED_BY	Standard who column
LOCATION_ID	Foreign key to HR_LOCATIONS_ALL
CREATION_DATE	Standard who column

Human Resources - HR_PUMP_MAPPING_PACKAGES	Lists PL/SQL packages that contain the parameter mapping functions used by data pump generated code. If module_package and module_name are both null then the mapping functions may be used by all APIs.
Column Name	Descritpion
MODULE_NAME	PL/SQL function name of this API.
API_MODULE_TYPE	If module_name is not null this column must specify the module type for this API.
MODULE_PACKAGE	API PL/SQL package to which the mapping functions apply.
CHECKING_ORDER	Order of checking mapping functions package. A lower value means that the package is checked earlier.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
MAPPING_PACKAGE	Name of PL/SQL package containing parameter mapping functions for this API.
CREATION_DATE	Standard Who column.

Human Resources - HR_TIPS	Help components used within SSHR.
Column Name	Descritpion
SCREEN	Name of the screen that the tip is valid for.
FIELD	Name of the field that this tip is for.
LANGUAGE_CODE	Language code that the tip is valid for.
TEXT	Tip text.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ENABLED_FLAG	Flag that indicates if this tip is enabled.
TIP_ID	System generated primary key from HR_TIPS_S.
FILENAME	Name of the file that the tip was loaded from.

Human Resources - HR_LEGISLATION_INSTALLATIONS	Status of each product/legislation combination installed
Column Name	Descritpion
LEGISLATION_CODE	legislation code indicating which localisation can be installed for the product
STATUS	indicated whether current product is installed
ACTION	indicated what action is being performed on localisation (install/upgrade/force-reinstall)
PI_STEPS_EXIST	indicates presence of legislative steps for this localisation
VIEW_NAME	view used by driver to determine what steps to apply
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
APPLICATION_SHORT_NAME	application short name

Human Resources - HR_S_US_CITY_GEOCODES
Column Name	Descritpion
STATE_CODE
COUNTY_CODE
CITY_CODE

Human Resources - HR_S_US_CITY_SCHOOL_DSTS
Column Name	Descritpion
SCHOOL_DST_CODE
STATE_CODE
COUNTY_CODE
CITY_CODE
SCHOOL_DST_NAME

Human Resources - HR_JP_PARAMETERS	This table holds unique id for Japanese legislative specific data in order not to hard-code Multibyte characters in Japanese localization code objects.
Column Name	Descritpion
PARAMETER_NAME	Name that system uses instead of multibyte key.
PARAMETER_VALUE	System generated identification number for the multibyte key.
OWNER	Module or function name that includes the parameters.

Human Resources - HR_S_REPORT_LOOKUPS
Column Name	Descritpion
REPORT_NAME
REPORT_LOOKUP_TYPE
LOOKUP_CODE
ENABLED_FLAG
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN

Human Resources - HR_SUMMARY	HR_SUMMARY holds all data for the Generic Summary Process.
Column Name	Descritpion
ID_VALUE	System-generated primary key column.
TEXT_VALUE3	Text column.
TEXT_VALUE4	Text column.
TEXT_VALUE5	Text column.
TEXT_VALUE6	Text column.
TEXT_VALUE7	Text column.
NUM_VALUE1	Numeric column.
NUM_VALUE2	Numeric column.
NUM_VALUE3	Numeric column.
DATE_VALUE1	Date column.
DATE_VALUE2	Date column.
TYPE	The name of the information type.
DATE_VALUE3	Date column.
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.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
OBJECT_VERSION_NUMBER	System-generated version of the row. Increments by one with each update.
FK_VALUE1	Foreign Key to id_value in HR_SUMMARY of different TYPE.
FK_VALUE2	Foreign Key to id_value in HR_SUMMARY of different TYPE.
FK_VALUE3	Foreign Key to id_value in HR_SUMMARY of different TYPE.
TEXT_VALUE1	Text column.
TEXT_VALUE2	Text column.

Human Resources - HR_TEMPLATE_WINDOWS_B	Definition of window for a template, for configurable forms
Column Name	Descritpion
TEMPLATE_WINDOW_ID	System-generated primary key using sequence HR_TEMPLATE_WINDOWS_B_S
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
FORM_TEMPLATE_ID	Foreign Key to HR_FORM_TEMPLATES_B
FORM_WINDOW_ID	Foreign Key to HR_FORM_WINDOWS_B
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.

Human Resources - HR_TEMPLATE_TAB_PAGES_B	Definition of tab page for template, for configurable forms
Column Name	Descritpion
TEMPLATE_TAB_PAGE_ID	System-generated primary key using sequence HR_TEMPLATE_TAB_PAGES_B_S
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
TEMPLATE_CANVAS_ID	Foreign Key to HR_TEMPLATE_CANVASES_B
FORM_TAB_PAGE_ID	Foreign Key to HR_FORM_TAB_PAGES_B
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.

Human Resources - HR_TEMPLATE_ITEM_TAB_PAGES	Information about which tab pages item belongs to on template for configurable form.
Column Name	Descritpion
TEMPLATE_ITEM_TAB_PAGE_ID	System-generated primary key using sequence HR_TEMPLATE_ITEM_TAB_PAGES_S
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
TEMPLATE_ITEM_ID	Foreign Key to HR_TEMPLATE_ITEMS_B
TEMPLATE_TAB_PAGE_ID	Foreign Key to HR_TEMPLATE_TAB_PAGES_B
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.

Human Resources - HR_TEMPLATE_ITEM_CONTEXT_PAGES	Information about which tab pages item belongs to for a specific context, on template for configurable form.
Column Name	Descritpion
TEMPLATE_ITEM_CONTEXT_PAGE_ID	System-generated primary key using sequence HR_TEMPLATE_ITEM_CONTEXT_PAGES_S
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
TEMPLATE_ITEM_CONTEXT_ID	Foreign Key to HR_TEMPLATE_ITEM_CONTEXTS_B
TEMPLATE_TAB_PAGE_ID	Foreign Key to HR_TEMPLATE_TAB_PAGES_B
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.

Human Resources - HR_TEMPLATE_ITEM_CONTEXTS_B	Definition of items on a template for given context, for configurable forms
Column Name	Descritpion
TEMPLATE_ITEM_CONTEXT_ID	System-generated primary key using sequence HR_TEMPLATE_ITEM_CONTEXTS_B_S
CREATION_DATE	Standard Who column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
TEMPLATE_ITEM_ID	Foreign Key to HR_TEMPLATE_ITEMS_B
CONTEXT_TYPE	Type of context. Initially will be restricted to "Descriptive Flexfield" and "Key Flexfield"
ITEM_CONTEXT_ID	Foreign Key to HR_ITEM_CONTEXTS
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.

Human Resources - HR_TEMPLATE_ITEMS_B	Definition of items on template for configurable forms
Column Name	Descritpion
TEMPLATE_ITEM_ID	System-generated primary key using sequence HR_TEMPLATE_ITEMS_B_S
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
FORM_TEMPLATE_ID	Foreign Key to HR_FORM_TEMPLATES_B
FORM_ITEM_ID	Foreign Key to HR_FORM_ITEMS_B
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.

Human Resources - HR_TEMPLATE_DATA_GROUPS	Definition for data group on template for configurable forms
Column Name	Descritpion
TEMPLATE_DATA_GROUP_ID	System-generated primary key using sequence HR_TEMPLATE_DATA_GROUPS_S
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
FORM_TEMPLATE_ID	Foreign Key to HR_FORM_TEMPLATES_B
FORM_DATA_GROUP_ID	Foreign Key to HR_FORM_DATA_GROUPS_B
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.

Human Resources - HR_TEMPLATE_CANVASES_B	Definition of canvases on template for configurable forms
Column Name	Descritpion
TEMPLATE_CANVAS_ID	System-generated primary key using sequence HR_TEMPLATE_CANVASES_B_S
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
TEMPLATE_WINDOW_ID	Foreign Key to HR_TEMPLATE_WINDOWS_B
FORM_CANVAS_ID	Foreign Key to HR_FORM_CANVASES_B
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.

Human Resources - HR_TAB_PAGE_PROPERTIES_TL	Translated properties of tab pages for configurable forms
Column Name	Descritpion
TAB_PAGE_PROPERTY_ID	System-generated primary key using sequence HR_TAB_PAGE_PROPERTIES_TL_S
LANGUAGE	Defined language
SOURCE_LANG	Actual language
LABEL	Translated text to be used as tab page label
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.

Human Resources - HR_TAB_PAGE_PROPERTIES_B	Properties of tab pages for configurable forms
Column Name	Descritpion
TAB_PAGE_PROPERTY_ID	System-generated primary key using sequence HR_TAB_PAGE_PROPERTIES_B_S
INFORMATION5	Developer descriptive flexfield column.
INFORMATION6	Developer descriptive flexfield column.
INFORMATION7	Developer descriptive flexfield column.
INFORMATION8	Developer descriptive flexfield column.
INFORMATION9	Developer descriptive flexfield column.
INFORMATION10	Developer descriptive flexfield column.
INFORMATION11	Developer descriptive flexfield column.
INFORMATION12	Developer descriptive flexfield column.
INFORMATION13	Developer descriptive flexfield column.
INFORMATION14	Developer descriptive flexfield column.
FORM_TAB_PAGE_ID	Foreign Key to HR_FORM_TAB_PAGES_B
INFORMATION15	Developer descriptive flexfield column.
INFORMATION16	Developer descriptive flexfield column.
INFORMATION17	Developer descriptive flexfield column.
INFORMATION18	Developer descriptive flexfield column.
INFORMATION19	Developer descriptive flexfield column.
INFORMATION20	Developer descriptive flexfield column.
INFORMATION21	Developer descriptive flexfield column.
INFORMATION22	Developer descriptive flexfield column.
INFORMATION23	Developer descriptive flexfield column.
INFORMATION24	Developer descriptive flexfield column.
TEMPLATE_TAB_PAGE_ID	Foreign Key to HR_TEMPLATE_TAB_PAGES_B
INFORMATION25	Developer descriptive flexfield column.
INFORMATION26	Developer descriptive flexfield column.
INFORMATION27	Developer descriptive flexfield column.
INFORMATION28	Developer descriptive flexfield column.
INFORMATION29	Developer descriptive flexfield column.
NAVIGATION_DIRECTION	Direction of navigation on tab page. Left to right or top to bottom.
INFORMATION30	Developer descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
VISIBLE	Visible property of tab page.
CREATION_DATE	Standard Who column.
OBJECT_VERSION_NUMBER	Object version number is used to uniquely identify if a user is looking at the current record in the database.
INFORMATION_CATEGORY	Developer descriptive flexfield column.
INFORMATION1	Developer descriptive flexfield column.
INFORMATION2	Developer descriptive flexfield column.
INFORMATION3	Developer descriptive flexfield column.
INFORMATION4	Developer descriptive flexfield column.

Human Resources - HR_SOURCE_FORM_TEMPLATES	Identities of templates which have been copied and the resulting copy. Helps distinguish seeded templates from copied ones.
Column Name	Descritpion
SOURCE_FORM_TEMPLATE_ID	System-generated primary key using sequence HR_SOURCE_FORM_TEMPLATES_S
FORM_TEMPLATE_ID_TO	Foreign key to HR_FORM_TEMPLATES. Identity of template which was copied to.
FORM_TEMPLATE_ID_FROM	Foreign key to HR_FORM_TEMPLATES. Identity of template which was copied from
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	Object version number is used to uniquely identify if a user is looking at the current record in the database.

Human Resources - HR_ITEM_PROPERTIES_TL	Translatable properties of items for configurable forms
Column Name	Descritpion
ITEM_PROPERTY_ID	System-generated primary key using sequence HR_ITEM_PROPERTIES_TL_S
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LANGUAGE	Defined language
SOURCE_LANG	Actual language
DEFAULT_VALUE	Translated default value for item
INFORMATION_PROMPT	Translated prompt for information entry on popup menu
LABEL	Translated text for the item label
PROMPT_TEXT	Translated text for the item prompt
TOOLTIP_TEXT	Translated text for the item's tooltip
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.

Human Resources - HR_ITEM_PROPERTIES_B	Properties for form or template items used by configurable forms.
Column Name	Descritpion
ITEM_PROPERTY_ID	System-generated primary key using sequence HR_ITEM_PROPERTIES_B_S
FORMAT_MASK	Format mask for item
HEIGHT	Height of item
INFORMATION_FORMULA_ID	Foreign key to FF_FORMULAS_F
INFORMATION_PARAMETER_ITEM_ID1	Foreign key to HR_FORM_ITEMS_B. That item holds parameter to be passed to information formula
INFORMATION_PARAMETER_ITEM_ID2	Foreign key to HR_FORM_ITEMS_B. That item holds parameter to be passed to information formula
INFORMATION_PARAMETER_ITEM_ID3	Foreign key to HR_FORM_ITEMS_B. That item holds parameter to be passed to information formula
INFORMATION_PARAMETER_ITEM_ID4	Foreign key to HR_FORM_ITEMS_B. That item holds parameter to be passed to information formula
INFORMATION_PARAMETER_ITEM_ID5	Foreign key to HR_FORM_ITEMS_B. That item holds parameter to be passed to information formula
INSERT_ALLOWED	Insert property of item
PROMPT_ALIGNMENT_OFFSET	Prompt alignment offset property of item
FORM_ITEM_ID	Foreign key to HR_FORM_ITEMS_B
PROMPT_DISPLAY_STYLE	Display style of item prompt
PROMPT_EDGE	Attachment edge of item prompt
PROMPT_EDGE_ALIGNMENT	Alignment edge of item prompt
PROMPT_EDGE_OFFSET	Offset of prompt for item
PROMPT_TEXT_ALIGNMENT	Alignment of prompt text for item
QUERY_ALLOWED	Query allowed property for item
REQUIRED	Required property of item
UPDATE_ALLOWED	Update allowed property of item
VALIDATION_FORMULA_ID	Foreign key to FF_FORMULAS_F
VALIDATION_PARAMETER_ITEM_ID1	Foreign key to HR_FORM_ITEMS_B. That item holds parameter to be passed to validation formula
TEMPLATE_ITEM_ID	Foreign key to HR_TEMPLATE_ITEMS_B
VALIDATION_PARAMETER_ITEM_ID2	Foreign key to HR_FORM_ITEMS_B. That item holds parameter to be passed to validation formula
VALIDATION_PARAMETER_ITEM_ID3	Foreign key to HR_FORM_ITEMS_B. That item holds parameter to be passed to validation formula
VALIDATION_PARAMETER_ITEM_ID4	Foreign key to HR_FORM_ITEMS_B. That item holds parameter to be passed to validation formula
VALIDATION_PARAMETER_ITEM_ID5	Foreign key to HR_FORM_ITEMS_B. That item holds parameter to be passed to validation formula
VISIBLE	Visible property of item
WIDTH	Width of item
X_POSITION	x-position of item
Y_POSITION	y-position of item
INFORMATION_CATEGORY	Developer descriptive flexfield column.
INFORMATION1	Developer descriptive flexfield column.
TEMPLATE_ITEM_CONTEXT_ID	Foreign ket to HR_TEMPLATE_ITEM_CONTEXTS_B
INFORMATION2	Developer descriptive flexfield column.
INFORMATION3	Developer descriptive flexfield column.
INFORMATION4	Developer descriptive flexfield column.
INFORMATION5	Developer descriptive flexfield column.
INFORMATION6	Developer descriptive flexfield column.
INFORMATION7	Developer descriptive flexfield column.
INFORMATION8	Developer descriptive flexfield column.
INFORMATION9	Developer descriptive flexfield column.
INFORMATION10	Developer descriptive flexfield column.
INFORMATION11	Developer descriptive flexfield column.
ALIGNMENT	Alignment property of item
INFORMATION12	Developer descriptive flexfield column.
INFORMATION13	Developer descriptive flexfield column.
INFORMATION14	Developer descriptive flexfield column.
INFORMATION15	Developer descriptive flexfield column.
INFORMATION16	Developer descriptive flexfield column.
INFORMATION17	Developer descriptive flexfield column.
INFORMATION18	Developer descriptive flexfield column.
INFORMATION19	Developer descriptive flexfield column.
INFORMATION20	Developer descriptive flexfield column.
INFORMATION21	Developer descriptive flexfield column.
BEVEL	Border bevel property of item
INFORMATION22	Developer descriptive flexfield column.
INFORMATION23	Developer descriptive flexfield column.
INFORMATION24	Developer descriptive flexfield column.
INFORMATION25	Developer descriptive flexfield column.
INFORMATION26	Developer descriptive flexfield column.
INFORMATION27	Developer descriptive flexfield column.
INFORMATION28	Developer descriptive flexfield column.
INFORMATION29	Developer descriptive flexfield column.
INFORMATION30	Developer descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
CASE_RESTRICTION	Case restriction of item
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
NEXT_NAVIGATION_ITEM_ID	Foreign key to HR_TEMPLATE_ITEMS_B.
PREVIOUS_NAVIGATION_ITEM_ID	Foreign key to HR_TEMPLATE_ITEMS_B.
OBJECT_VERSION_NUMBER	Object version number is used to uniquely identify if a user is looking at the current record in the database.
DEFAULT_VALUE
ENABLED	Is item enabled or disabled

Human Resources - HR_ITEM_CONTEXTS	Combinations table for the item context key flexfield ICX
Column Name	Descritpion
ITEM_CONTEXT_ID	System-generated primary key using sequence HR_ITEM_CONTEXTS_S
SEGMENT4	Key flexfield column.
SEGMENT5	Key flexfield column.
SEGMENT6	Key flexfield column.
SEGMENT7	Key flexfield column.
SEGMENT8	Key flexfield column.
SEGMENT9	Key flexfield column.
SEGMENT10	Key flexfield column.
SEGMENT11	Key flexfield column.
SEGMENT12	Key flexfield column.
SEGMENT13	Key flexfield column.
ID_FLEX_NUM	Key flexfield structure identifier
SEGMENT14	Key flexfield column.
SEGMENT15	Key flexfield column.
SEGMENT16	Key flexfield column.
SEGMENT17	Key flexfield column.
SEGMENT18	Key flexfield column.
SEGMENT19	Key flexfield column.
SEGMENT20	Key flexfield column.
SEGMENT21	Key flexfield column.
SEGMENT22	Key flexfield column.
SEGMENT23	Key flexfield column.
SUMMARY_FLAG	Key flexfield summary flag
SEGMENT24	Key flexfield column.
SEGMENT25	Key flexfield column.
SEGMENT26	Key flexfield column.
SEGMENT27	Key flexfield column.
SEGMENT28	Key flexfield column.
SEGMENT29	Key flexfield column.
SEGMENT30	Key flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
ENABLED_FLAG	Key flexfield enabled flag
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
OBJECT_VERSION_NUMBER	Object version number is used to uniquely identify if a user is looking at the current record in the database.
START_DATE_ACTIVE	Start date
END_DATE_ACTIVE	End date
SEGMENT1	Key flexfield column.
SEGMENT2	Key flexfield column.
SEGMENT3	Key flexfield column.

Human Resources - HR_LAYOUTS	Information about an instance of a Self-Service User Interface configuration.
Column Name	Descritpion
LAYOUT_NAME	Developer Key for the layout name.
APPLICATION_ID	Application that owns the layout.
LAYOUT_TYPE	Type of layout.
MODIFIER_LEVEL	Scope of the layout.
MODIFIER_VALUE	Value associated with the modifier level.
TOP_LEVEL_REGION_CODE	Top level AK region associated with the page.
OBJECT_VERSION_NUMBER	OVN
LAST_UPDATE_DATE
LAYOUT_ID	System generated primary key from HR_LAYOUTS_S.
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE

Human Resources - HR_LAYOUTS_TL	Translation table for HR_LAYOUTS.
Column Name	Descritpion
DISPLAY_LAYOUT_NAME
LANGUAGE
SOURCE_LANG
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
LAYOUT_ID

Human Resources - HR_LAYOUT_COMP_DEFINITIONS	Definitions of the set of User Interface components that can be used within a configurable Self Service User Interface Layout.
Column Name	Descritpion
COMPONENT_TYPE
COMPONENT_CLASS
RENDER_TYPE
OBJECT_VERSION_NUMBER
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
LAYOUT_COMP_DEFINITION_ID
CREATION_DATE

Human Resources - HR_LAYOUT_COMP_QUAL_RULES	Set of rules that determine whether a Self Service User Interface component can use a particular layout qualifier.
Column Name	Descritpion
RULE_NAME
RULE_TYPE
RULE_DETAIL
RULE_VALUE
LAYOUT_COMP_QUALIFIER_ID
OBJECT_VERSION_NUMBER
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
LAYOUT_COMP_QUAL_RULE_ID
CREATED_BY
CREATION_DATE

Human Resources - HR_LAYOUT_COMP_PROMPTS	Set of prompt codes associated with a Configurable UI Layout Component
Column Name	Descritpion
LAYOUT_COMPONENT_ID
PROMPT_ALIAS
PROMPT_TYPE
REGION_CODE
REGION_APPLICATION_ID
ATTRIBUTE_CODE
ATTRIBUTE_APPLICATION_ID
OBJECT_VERSION_NUMBER
LAST_UPDATE_DATE
LAYOUT_COMP_PROMPT_ID
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE

Human Resources - HR_LAYOUT_COMP_QUALIFIERS	Set of layout qualifiers which can be used to modify the rendering of a Self Service User Interface component.
Column Name	Descritpion
QUALIFIER_NAME
QUALIFIER_ATTRIBUTE17
QUALIFIER_ATTRIBUTE18
QUALIFIER_ATTRIBUTE19
QUALIFIER_ATTRIBUTE20
QUALIFIER_ATTRIBUTE21
QUALIFIER_ATTRIBUTE22
QUALIFIER_ATTRIBUTE23
QUALIFIER_ATTRIBUTE24
QUALIFIER_ATTRIBUTE25
QUALIFIER_ATTRIBUTE26
QUALIFIER_ATTRIBUTE_CATEGORY
QUALIFIER_ATTRIBUTE27
QUALIFIER_ATTRIBUTE28
QUALIFIER_ATTRIBUTE29
QUALIFIER_ATTRIBUTE30
OBJECT_VERSION_NUMBER
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
QUALIFIER_ATTRIBUTE1
LAYOUT_COMPONENT_ID
QUALIFIER_ATTRIBUTE2
QUALIFIER_ATTRIBUTE3
QUALIFIER_ATTRIBUTE4
QUALIFIER_ATTRIBUTE5
QUALIFIER_ATTRIBUTE6
LAYOUT_COMP_QUALIFIER_ID
QUALIFIER_ATTRIBUTE7
QUALIFIER_ATTRIBUTE8
QUALIFIER_ATTRIBUTE9
QUALIFIER_ATTRIBUTE10
QUALIFIER_ATTRIBUTE11
QUALIFIER_ATTRIBUTE12
QUALIFIER_ATTRIBUTE13
QUALIFIER_ATTRIBUTE14
QUALIFIER_ATTRIBUTE15
QUALIFIER_ATTRIBUTE16

Human Resources - HR_LAYOUT_COMPONENTS	Set of User Interface Components used within a configurable Self-Service layout.
Column Name	Descritpion
LAYOUT_ID
LAYOUT_COMP_DEFINITION_ID
PARENT_COMPONENT_ID
COMPONENT_NAME
COMPONENT_VALUE
SEQUENCE
NAME_VALUE_STRING
REGION_CODE
LAYOUT_COMPONENT_ID
REGION_CODE_APP_ID
ATTRIBUTE_CODE
ATTRIBUTE_CODE_APP_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
CREATED_BY
CREATION_DATE

Human Resources - HR_SUMMARY_EFC	This is a copy of the HR_SUMMARY table which is populated by the EFC (Euro as Functional Currency) process.
Column Name	Descritpion
ID_VALUE	Foreign Key to HR_SUMMARY.
EFC_ACTION_ID	Foreign Key to HR_EFC_ACTIONS.
NUM_VALUE1	Refer to column comment on base table.
NUM_VALUE2	Refer to column comment on base table

Human Resources - HR_ORGANIZATION_INFORMATIO_EFC	This is a copy of theHR_ORGANIZATION_INFORMATION table which is populated by the EFC (Euro as Functional Currency) process.
Column Name	Descritpion
ORG_INFORMATION_ID	Refer to column comment on base table.
EFC_ACTION_ID	Foreign Key to HR_EFC_ACTIONS.
ORG_INFORMATION5	Refer to column comment on base table.
ORG_INFORMATION6	Refer to column comment on base table.
ORG_INFORMATION10	Refer to column comment on base table.
EFC_BG_CURRENCY	Refer to column comment on base table.

Human Resources - HR_S_MAGNETIC_BLOCKS
Column Name	Descritpion
MAGNETIC_BLOCK_ID
BLOCK_NAME
MAIN_BLOCK_FLAG
REPORT_FORMAT
CURSOR_NAME
NO_COLUMN_RETURNED

Human Resources - HR_S_REPORT_FORMAT_ITEMS_F
Column Name	Descritpion
REPORT_QUALIFIER
REPORT_CATEGORY
USER_ENTITY_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
ARCHIVE_TYPE
UPDATABLE_FLAG
DISPLAY_SEQUENCE
REPORT_TYPE
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. Increments by one with each update.
REPORT_FORMAT_ITEM_ID	System generated Primary Key

Human Resources - HR_S_REPORT_FORMAT_MAPPINGS_F
Column Name	Descritpion
BUSINESS_GROUP_ID
LAST_UPDATE_DATE	Standard Who column.
LEGISLATION_CODE
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. Increments by one with each update.
REPORT_TYPE
REPORT_QUALIFIER
REPORT_FORMAT
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
RANGE_CODE
REPORT_FORMAT_MAPPING_ID
ASSIGNMENT_ACTION_CODE
INITIALIZATION_CODE
ARCHIVE_CODE
MAGNETIC_CODE
REPORT_CATEGORY
REPORT_NAME
SORT_CODE
UPDATABLE_FLAG
DEINITIALIZATION_CODE
TEMPORARY_ACTION_FLAG

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

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

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

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

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

Human Resources - HR_H2PI_SALARIES
Column Name	Descritpion
LAST_UPD_DATE	Last update date
ATTRIBUTE2	Descriptive flexfield column
ATTRIBUTE3	Descriptive flexfield column
ATTRIBUTE4	Descriptive flexfield column
ATTRIBUTE5	Descriptive flexfield column
ATTRIBUTE6	Descriptive flexfield column
ATTRIBUTE7	Descriptive flexfield column
ATTRIBUTE8	Descriptive flexfield column
ATTRIBUTE9	Descriptive flexfield column
ATTRIBUTE10	Descriptive flexfield column
ATTRIBUTE11	Descriptive flexfield column
BUSINESS_GROUP_ID	Business group ID
ATTRIBUTE12	Descriptive flexfield column
ATTRIBUTE13	Descriptive flexfield column
ATTRIBUTE14	Descriptive flexfield column
ATTRIBUTE15	Descriptive flexfield column
ATTRIBUTE16	Descriptive flexfield column
CLIENT_ID	Client id
ATTRIBUTE17	Descriptive flexfield column
ATTRIBUTE18	Descriptive flexfield column
ATTRIBUTE19	Descriptive flexfield column
ATTRIBUTE20	Descriptive flexfield column
STATUS	Status of record fro upload
PAY_PROPOSAL_ID	System generated primary key column
ASSIGNMENT_ID	Assignment ID
PERSON_ID	Person ID
CHANGE_DATE	Date of salary proposal
PROPOSED_SALARY_N	Format, replaces salary in 11.5
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield column

Human Resources - HR_H2PI_US_MODIFIED_GEOCODES	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to US midified geocodes while data upload is in progress.
Column Name	Descritpion
CITY_NAME	City name
STATUS	Status code of record for upload
STATE_CODE	State code
COUNTY_CODE	County code
NEW_CITY_CODE	New code for city
OLD_CITY_CODE	Old code for city
PRIMARY_FLAG	Primary flag
PROCESS_TYPE	Process type
PATCH_NAME	Patch name
BUSINESS_GROUP_ID	Business group ID
CLIENT_ID	Client id

Human Resources - HR_H2PI_US_CITY_NAMES
Column Name	Descritpion
CITY_NAME	City name
STATE_CODE	State code
COUNTY_CODE	County code
CITY_CODE	City code
PRIMARY_FLAG	Primary flag
BUSINESS_GROUP_ID	Business group ID
CLIENT_ID	Client id
STATUS	Status

Human Resources - HR_H2PI_PERIODS_OF_SERVICE
Column Name	Descritpion
LAST_UPD_DATE	Last update date
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield column
ATTRIBUTE2	Descriptive flexfield column
ATTRIBUTE3	Descriptive flexfield column
ATTRIBUTE4	Descriptive flexfield column
ATTRIBUTE5	Descriptive flexfield column
ATTRIBUTE6	Descriptive flexfield column
ATTRIBUTE7	Descriptive flexfield column
ATTRIBUTE10	Descriptive flexfield column
ATTRIBUTE11	Descriptive flexfield column
BUSINESS_GROUP_ID	Business group ID
ATTRIBUTE12	Descriptive flexfield column
ATTRIBUTE13	Descriptive flexfield column
ATTRIBUTE14	Descriptive flexfield column
ATTRIBUTE15	Descriptive flexfield column
ATTRIBUTE16	Descriptive flexfield column
CLIENT_ID	Client id
ATTRIBUTE17	Descriptive flexfield column
ATTRIBUTE18	Descriptive flexfield column
ATTRIBUTE19	Descriptive flexfield column
ATTRIBUTE20	Descriptive flexfield column
STATUS	Status of record for upload
PERIOD_OF_SERVICE_ID	System generated primary key column
PERSON_ID	Person ID
DATE_START	Start date for the period of service
ACTUAL_TERMINATION_DATE	Actual date of termination of employee
FINAL_PROCESS_DATE	Final date for all payroll processing for this person
LAST_STANDARD_PROCESS_DATE	Last date for including this person in any standard process
LEAVING_REASON	Reason for leaving employment

Human Resources - HR_H2PI_STATE_TAX_RULES
Column Name	Descritpion
PERSON_ID	Person ID
FILING_STATUS_CODE	W4 filing state status code
REMAINDER_PERCENT	Remainder percentage
SECONDARY_WA	W4 secondary allowance
SIT_ADDITIONAL_TAX	W4 additional state income tax
SIT_OVERRIDE_AMOUNT	W4 additional state income tax override amount
SIT_OVERRIDE_RATE	W4 additional state income tax override rate (%)
WITHHOLDING_ALLOWANCES	State income tax withholding allowance
EXCESSIVE_WA_REJECT_DATE	The allowance reject date
SDI_EXEMPT	SDI exempt flag, Y- if exempt, N- if not exempt
SIT_EXEMPT	SIT exempt flag, Y- if exempt, N- if not exempt
EMP_STATE_TAX_RULE_ID	System generated primary key column
SIT_OPTIONAL_CALC_IND	W4 state income tax optional calculation code
STATE_NON_RESIDENT_CERT	Non-resident certification flag
SUI_EXEMPT	SUI exempt flag, Y- if exempt, N- if not exempt
WC_EXEMPT	WC exempt flag, Y- if exempt, N- if not exempt
SUI_WAGE_BASE_OVERRIDE_AMOUNT	SUI base wages override amount
SUPP_TAX_OVERRIDE_RATE	SUI base wages override rate
LAST_UPD_DATE	Last update date
OBJECT_VERSION_NUMBER	Object version number
STATUS	Status of record for upload
EFFECTIVE_START_DATE	Effective start date
EFFECTIVE_END_DATE	Effective end date
ASSIGNMENT_ID	Assignment ID
STATE_CODE	State code
JURISDICTION_CODE	Jurisdiction code in format XX-YYY-ZZZZ
BUSINESS_GROUP_ID	Business group ID
CLIENT_ID	Client id
ADDITIONAL_WA_AMOUNT	Extra W4 witholding allowance amount

Human Resources - HR_KI_EXT_APPLICATIONS	This table holds the details of the KI integration external applications
Column Name	Descritpion
EXTERNAL_APPLICATION_NAME	Name of the external application
EXTERNAL_APPLICATION_ID	app_id of the external application
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
EXT_APPLICATION_ID	System-generated primary key

Human Resources - HR_KI_SESSIONS
Column Name	Descritpion
KI_SESSION_ID
URL
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
LAST_UPDATE_DATE

Human Resources - HR_NAVIGATION_UNITS_TL	Translated fields for hr_navigation_units
Column Name	Descritpion
LANGUAGE
SOURCE_LANG
DEFAULT_LABEL
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
NAV_UNIT_ID

Human Resources - HR_NAVIGATION_PATHS_TL
Column Name	Descritpion
LANGUAGE
SOURCE_LANG
OVERRIDE_LABEL
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
NAV_PATH_ID

Human Resources - HR_PTL_SUMMARY_DATA
Column Name	Descritpion
SUMMARY_DATA_ID
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
SOURCE_TYPE
SUM_INFORMATION_CATEGORY
SUM_INFORMATION1
SUM_INFORMATION2
SUMMARY_CONTEXT_TYPE
SUM_INFORMATION3
SUM_INFORMATION4
SUM_INFORMATION5
SUM_INFORMATION6
SUM_INFORMATION7
SUM_INFORMATION8
SUM_INFORMATION9
SUM_INFORMATION10
SUM_INFORMATION11
SUM_INFORMATION12
SUMMARY_CONTEXT_ID
SUM_INFORMATION13
SUM_INFORMATION14
SUM_INFORMATION15
SUM_INFORMATION16
SUM_INFORMATION17
SUM_INFORMATION18
SUM_INFORMATION19
SUM_INFORMATION20
SUM_INFORMATION21
SUM_INFORMATION22
EFFECTIVE_DATE
SUM_INFORMATION23
SUM_INFORMATION24
SUM_INFORMATION25
SUM_INFORMATION26
SUM_INFORMATION27
SUM_INFORMATION28
SUM_INFORMATION29
SUM_INFORMATION30
SUM_INFORMATION31
SUM_INFORMATION32
EFFECTIVE_END_DATE
SUM_INFORMATION33
SUM_INFORMATION34
SUM_INFORMATION35
SUM_INFORMATION36
SUM_INFORMATION37
SUM_INFORMATION38
SUM_INFORMATION39
SUM_INFORMATION40
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
LAST_UPDATED_BY

Human Resources - HR_NAME_FORMATS	Contains the format masks used to determine the displayed formats of personal names in Applications. Oracle will seed rows in this table which cannot be deleted, but can be modified by customers. Additional rows can be created.
Column Name	Descritpion
FORMAT_NAME	User identifier for name format
LEGISLATION_CODE	Legislation applicable for format
USER_FORMAT_CHOICE	User Format Choice: Global or Local
FORMAT_MASK	Stores the actual mask used to create names according to format
OBJECT_VERSION_NUMBER	Change indicator for row
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
NAME_FORMAT_ID	Entity identifier
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Human Resources - HR_S_DIMENSION_ROUTES	-Retrofitted
Column Name	Descritpion
BALANCE_DIMENSION_ID
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
ROUTE_ID
ROUTE_TYPE
PRIORITY
RUN_DIMENSION_ID
BALANCE_TYPE_COLUMN
DECODE_REQUIRED
LAST_UPDATE_DATE
LAST_UPDATED_BY

Human Resources - HR_S_BALANCE_CATEGORIES_F
Column Name	Descritpion
CATEGORY_NAME
PBC_INFORMATION12
PBC_INFORMATION13
PBC_INFORMATION14
PBC_INFORMATION15
PBC_INFORMATION16
PBC_INFORMATION17
PBC_INFORMATION18
PBC_INFORMATION19
PBC_INFORMATION20
PBC_INFORMATION21
EFFECTIVE_START_DATE
PBC_INFORMATION22
PBC_INFORMATION23
PBC_INFORMATION24
PBC_INFORMATION25
PBC_INFORMATION26
PBC_INFORMATION27
PBC_INFORMATION28
PBC_INFORMATION29
PBC_INFORMATION30
LAST_UPDATE_DATE
EFFECTIVE_END_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
USER_CATEGORY_NAME
LEGISLATION_CODE
BUSINESS_GROUP_ID
SAVE_RUN_BALANCE_ENABLED
PBC_INFORMATION_CATEGORY
PBC_INFORMATION1
BALANCE_CATEGORY_ID
PBC_INFORMATION2
PBC_INFORMATION3
PBC_INFORMATION4
PBC_INFORMATION5
PBC_INFORMATION6
PBC_INFORMATION7
PBC_INFORMATION8
PBC_INFORMATION9
PBC_INFORMATION10
PBC_INFORMATION11

Human Resources - HR_PERSON_DEPLYMT_CONTACTS	Contacts to recreate in new business group for deployed employees
Column Name	Descritpion
PERSON_DEPLOYMENT_ID	Deployment for which the contact relationship record is to be copied over
CONTACT_RELATIONSHIP_ID	Contact Relationship record that will be copied to the new business group
OBJECT_VERSION_NUMBER	Version number of row
CREATED_BY	AOL WHO Column
CREATION_DATE	AOL WHO Column
LAST_UPDATED_BY	AOL WHO Column
LAST_UPDATE_DATE	AOL WHO Column
LAST_UPDATE_LOGIN	AOL WHO Column
PERSON_DEPLYMT_CONTACT_ID	Unique identifier for this row

Human Resources - HR_PERSON_DEPLYMT_EITS	Extra Information to recreate in new business group for deployed employees
Column Name	Descritpion
PERSON_DEPLOYMENT_ID	Deployment for which the Extra Information record is to be copied over
PERSON_EXTRA_INFO_ID	Extra Information record that will be copied to new business group
OBJECT_VERSION_NUMBER	Version number of row
CREATED_BY	AOL WHO column
CREATION_DATE	AOL WHO column
LAST_UPDATED_BY	AOL WHO column
LAST_UPDATE_DATE	AOL WHO column
LAST_UPDATE_LOGIN	AOL WHO column
PERSON_DEPLYMT_EIT_ID	Unique identifier of this row

Human Resources - HR_PERSON_DEPLOYMENTS	Record of cross-business group periods of work for an employee
Column Name	Descritpion
OBJECT_VERSION_NUMBER	Version number of row
GRADE_ID	Unique identifier of the grade for the assignment
SUPERVISOR_ID	Unique identifier of the manager for the assignment
SUPERVISOR_ASSIGNMENT_ID	Unique identifier of the assignment which manager performs as supervisor for the assignment
RETAIN_DIRECT_REPORTS	Identify if employee's direct reports are to be supervised by the new assignment or not
PAYROLL_ID	Unique identifier of the payroll for the assignment
PAY_BASIS_ID	Unique identifier of the salary basis for the assignment
PROPOSED_SALARY	Proposed salary for the deployment
PEOPLE_GROUP_ID	Unique identifier of the People Group key flexfield combination for the assignment
SOFT_CODING_KEYFLEX_ID	Unique identifier of the Soft Coded Key Flexfield combination for the assignment
ASSIGNMENT_STATUS_TYPE_ID
FROM_BUSINESS_GROUP_ID	Employee's business group prior to deployment
ASS_STATUS_CHANGE_REASON	Unique identifier of the assignment status for the assignment
ASSIGNMENT_CATEGORY	Unique identifier of the assignment category for the assignment
PER_INFORMATION_CATEGORY	Person Developer Descriptive Flexfield structure defining column
PER_INFORMATION1	Person Developer Descriptive Flexfield column
PER_INFORMATION2	Person Developer Descriptive Flexfield column
TO_BUSINESS_GROUP_ID	Employee's business group during deployment
PER_INFORMATION3	Person Developer Descriptive Flexfield column
PER_INFORMATION4	Person Developer Descriptive Flexfield column
PER_INFORMATION5	Person Developer Descriptive Flexfield column
PER_INFORMATION6	Person Developer Descriptive Flexfield column
PER_INFORMATION7	Person Developer Descriptive Flexfield column
PER_INFORMATION8	Person Developer Descriptive Flexfield column
PER_INFORMATION9	Person Developer Descriptive Flexfield column
PER_INFORMATION10	Person Developer Descriptive Flexfield column
PER_INFORMATION11	Person Developer Descriptive Flexfield column
PER_INFORMATION12	Person Developer Descriptive Flexfield column
FROM_PERSON_ID	Identifier of person record of home business group
PER_INFORMATION13	Person Developer Descriptive Flexfield column
PER_INFORMATION14	Person Developer Descriptive Flexfield column
PER_INFORMATION15	Person Developer Descriptive Flexfield column
PER_INFORMATION16	Person Developer Descriptive Flexfield column
PER_INFORMATION17	Person Developer Descriptive Flexfield column
PER_INFORMATION18	Person Developer Descriptive Flexfield column
PER_INFORMATION19	Person Developer Descriptive Flexfield column
PER_INFORMATION20	Person Developer Descriptive Flexfield column
PER_INFORMATION21	Person Developer Descriptive Flexfield column
PER_INFORMATION22	Person Developer Descriptive Flexfield column
TO_PERSON_ID	Identifier of person record of host business group
PER_INFORMATION23	Person Developer Descriptive Flexfield column
PER_INFORMATION24	Person Developer Descriptive Flexfield column
PER_INFORMATION25	Person Developer Descriptive Flexfield column
PER_INFORMATION26	Person Developer Descriptive Flexfield column
PER_INFORMATION27	Person Developer Descriptive Flexfield column
PER_INFORMATION28	Person Developer Descriptive Flexfield column
PERSON_TYPE_ID	Person Type
PER_INFORMATION29	Person Developer Descriptive Flexfield column
PER_INFORMATION30	Person Developer Descriptive Flexfield column
CREATED_BY	AOL WHO column
CREATION_DATE	AOL WHO column
START_DATE	Start Date
LAST_UPDATED_BY	AOL WHO column
LAST_UPDATE_DATE	AOL WHO column
LAST_UPDATE_LOGIN	AOL WHO column
END_DATE	End Date
DEPLOYMENT_REASON	Reason that employee is being transferred
EMPLOYEE_NUMBER	Employee number
PERSON_DEPLOYMENT_ID	Unique identifier for the employee's deployment record
LEAVING_REASON	Leaving Reason
LEAVING_PERSON_TYPE_ID	Termination person type
PERMANENT	Permanent flag
STATUS	Status of deployment
STATUS_CHANGE_REASON	Reason status changed
STATUS_CHANGE_DATE	Date of status change
DEPLYMT_POLICY_ID	Reserved for Oracle future use
ORGANIZATION_ID	Unique identifier of the Organization
LOCATION_ID	Unique identifier of the Location for the assignment
JOB_ID	Unique identifier of the job for the assignment
POSITION_ID	Unique identifier of the position for the assignment

Human Resources - HR_MBS_WRKFC_JCX_SUPH_MV
Column Name	Descritpion
EFFECTIVE_START_DATE
COMPARATIO
RANGE_POSITION
QUARTILE
EFFECTIVE_END_DATE
JOB_ID
COUNTRY
PAY_BASIS_ID
SUPERVISOR_ID
TOTAL_HEADCOUNT
MED_ANL_SLRY
ANL_SLRY_CURRENCY