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

Human Resources - HR_COMMENTS	Central repository for comments.
Column Name	Descritpion
COMMENT_ID	System-generated primary key column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
SOURCE_TABLE_NAME	Name of table that holds the related object for the comment.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
COMMENT_TEXT	Actual text of the comment.
LAST_UPDATE_DATE	Standard Who column.

Human Resources - BEN_BENEFIT_CLASSIFICATIONS	Classification for a particular benefit, eg pension, health, life insurance, flex plan.
Column Name	Descritpion
BENEFIT_CLASSIFICATION_ID	Unique identifier for the benefit classification.
CONTRIBUTIONS_USED	Indicates whether the classification uses Benefit Contributions.
DEPENDENTS_ALLOWED_FLAG	Indicates whether the benefit can cover employee dependents.
DFLT_POST_TERMINATION_RULE	Used to derive post termination rule for benefit plans (including flex).
DFLT_PROCESSING_TYPE	Used to derive processing type for benefit plans (including flex).
BEN_CLASS_PROCESSING_RULE	Describes the processing that can act on benefits in this class.
COMMENTS	General remark.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
BUSINESS_GROUP_ID	Foreign key to HR_ALL_ORGANIZATION_UNITS.
CREATION_DATE	Standard Who column.
LEGISLATION_CODE	Legislation where the classification applies.
ACTIVE_FLAG	Indicates whether benefits of this classification can be created.
BENEFICIARY_ALLOWED_FLAG	Indicates whether the benefit can be paid to beneficiaries, eg life insurance plans.
BENEFIT_CLASSIFICATION_NAME	Name of the benefit classification.
BENEFIT_CLASSIFICATION_TYPE	Indicates whether the row is a (BEN)efit or (FLEX) plan.
CHARGEABLE_FLAG	Indicates whether the user can set-up charges for benefits of this classification.
COBRA_FLAG	Indicates whether benefits of this class are subject to COBRA.

Human Resources - HR_ASSIGNMENT_SETS	Formula definitions that identify sets of assignments.
Column Name	Descritpion
ASSIGNMENT_SET_ID	System-generated primary key column.
CREATION_DATE	Standard Who column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
PAYROLL_ID	Foreign key to PAY_PAYROLLS.
ASSIGNMENT_SET_NAME	Name of the assignment set.
FORMULA_ID	Foreign key to formula of type - Assignment Set.
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_ASSIGNMENT_SET_AMENDMENTS	Identifies explicit include and exclude rules for an assignment set.
Column Name	Descritpion
ASSIGNMENT_ID	Foreign key to PER_ASSIGNMENTS.
ASSIGNMENT_SET_ID	Foreign key to HR_ASSIGNMENT_SETS.
INCLUDE_OR_EXCLUDE	Identifies whether to explicitly include or exclude the assignment.
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_ASSIGNMENT_SET_CRITERIA	Identifies individual criteria in the definition of an assignment set.
Column Name	Descritpion
LINE_NO	Sequence in which this condition should be used for the set.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
ASSIGNMENT_SET_ID	Foreign key to HR_ASSIGNMENTS_SETS.
LEFT_OPERAND	Database item or text. Database item is prefixed online by &.
OPERATOR	How the left operand must relate to the right operand to succeed.
RIGHT_OPERAND	Database item or text. Database item is prefixed online by &.
LOGICAL	Logical link between this condition and the previous one (AND/OR).
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.

Human Resources - BEN_BENEFIT_CONTRIBUTIONS_F	Default contributions payable for cover by a specific benefit.
Column Name	Descritpion
EMPLOYEE_CONTRIBUTION	Default cost to employee for enrollment at a specific level of coverage.
EMPLOYER_CONTRIBUTION	Default cost to employer for employee enrollment at a specific level of coverage.
MAXIMUM_EMPLOYEE_CONTRIBUTION	Maximum cost to employee for enrollment at a specific level.
MAXIMUM_EMPLOYER_CONTRIBUTION	Maximum cost to employer for employee enrollment at a specific level.
MINIMUM_EMPLOYEE_CONTRIBUTION	Minimum cost to employee for enrollment.
MINIMUM_EMPLOYER_CONTRIBUTION	Minimum cost to employer for enrollment.
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.
ATTRIBUTE8	Descriptive flexfield column.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
BENEFIT_CONTRIBUTION_ID	Unique identifier for the benefit contribution.
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.
EFFECTIVE_START_DATE	Effective start date.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
EFFECTIVE_END_DATE	Effective end date.
BUSINESS_GROUP_ID	Foreign key to HR_ALL_ORGANIZATION_UNITS.
FORMULA_ID	Foreign key to PAY_FORMULAS.
ELEMENT_TYPE_ID	Foreign key to PAY_ELEMENT_TYPES.
COVERAGE_TYPE	Type of coverage, eg employee only, employee and spouse.

Human Resources - BEN_VALID_DEPENDENT_TYPES	Types of dependent relationship that are valid for cover by a specific benefit.
Column Name	Descritpion
VALID_DEPENDENT_TYPE_ID	Unique identifier for the dependent type.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
BUSINESS_GROUP_ID	Foreign key to HR_ALL_ORGANIZATION_UNITS.
LEGISLATION_CODE	The legislation in which the dependent type belongs.
CONTACT_TYPE	Type of contact used to define the maximum limit.
COVERAGE_TYPE	Type of cover used to define the maximum limit.
MAXIMUM_NUMBER	Maximum number of covered dependents for this relationship and cover.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.

Human Resources - BEN_COVERED_DEPENDENTS_F	Dependents covered by specific benefit plans.
Column Name	Descritpion
COVERED_DEPENDENT_ID	Unique identifier for the covered dependent.
CREATION_DATE	Standard Who column.
EFFECTIVE_START_DATE	Effective start date.
EFFECTIVE_END_DATE	Effective end date.
CONTACT_RELATIONSHIP_ID	Foreign key to PER_CONTACT_RELATIONSHIPS.
ELEMENT_ENTRY_ID	Foreign key to PAY_ELEMENT_ENTRIES.
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 - BEN_BENEFICIARIES_F	Beneficiaries for a benefit program
Column Name	Descritpion
SOURCE_TYPE	Identifies whether the beneficiary is a person or an organization.
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.
BENEFICIARY_ID	Unique ID for the beneficiary.
EFFECTIVE_START_DATE	Effective start date.
EFFECTIVE_END_DATE	Effective end date.
ELEMENT_ENTRY_ID	Foreign key to PAY_ELEMENT_ENTRIES.
BENEFIT_LEVEL	Primary, secondary benefit goes to the highest surviving level.
PROPORTION	Benefit is divided by proportion among beneficiaries at a benefit level.
SOURCE_ID	Identifies the beneficiary, person or organization, depending on SOURCE_TYPE.

Human Resources - HR_CALENDARS	Dated instances of a repeating pattern.
Column Name	Descritpion
CALENDAR_ID	System-generated primary key column.
LAST_UPDATE_LOGIN	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
CALENDAR_NAME	Unique name to identify the calendar.
PATTERN_START_POSITION	The sequence number of the pattern construction at which the calendar starts.
CALENDAR_START_TIME	The start date and time of the calendar.
PATTERN_ID	Foreign key to HR_PATTERNS.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
CREATION_DATE	Standard Who column.
CREATED_BY	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.

Human Resources - HR_CALENDAR_USAGES	Assignments of calendars to individual entities.
Column Name	Descritpion
CALENDAR_ID	Foreign key to HR_CALENDARS.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CALENDAR_USAGE_ID	System-generated primary key column.
PRIMARY_KEY_VALUE	Foreign key to the table/entity identified via the purpose_usage_id.
PURPOSE_USAGE_ID	Foreign key to HR_PATTERN_PURPOSE_USAGES.
START_DATE	The start (date and time) of the period of use of the calendar.
END_DATE	The end (date and time) of the period of use of the calendar.
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_EXCEPTION_USAGES	Identifies usage of defined exceptions to a repeating pattern.
Column Name	Descritpion
EXCEPTION_ID	Foreign key to HR_PATTERN_EXCEPTIONS.
LAST_UPDATE_LOGIN	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
EXCEPTION_USAGE_ID	System-generated primary key column.
EXCEPTION_REASON	Reason for applying the exception.
CALENDAR_ID	Foreign key to HR_CALENDARS. This column and calendar_usage_id are mutually exclusive.
CALENDAR_USAGE_ID	Foreign key to HR_CALENDAR_USAGES. This column and calendar_id are mutually exclusive.
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_API_BATCH_MESSAGE_LINES	Results and messages generated during batch API processing.
Column Name	Descritpion
LINE_ID	System-generated primary key column.
API_NAME	Name of the API.
BATCH_RUN_NUMBER	Indicates the batch run for the line.
STATUS	Indicates whether the API call succeeded or failed.
ERROR_MESSAGE	Holds the SQLERRM if STATUS = Fail.
ERROR_NUMBER	Holds the SQLCODE if STATUS = Fail.
EXTENDED_ERROR_MESSAGE	Holds the extended message text if STATUS = Fail.
SOURCE_ROW_INFORMATION	Free text that uniquely identifies the source row information.
SECURITY_GROUP_ID	Foreign Key to FND_SECURITY_GROUPS.

Human Resources - HR_API_TRANSACTIONS	Kiosk processes in progress
Column Name	Descritpion
TRANSACTION_ID	System-generated primary key column.
URL	URL to relaunch the suspended Transaction
STATUS	Transaction Status
SECTION_DISPLAY_NAME	Action Display Name
FUNCTION_ID	Selected Function
TRANSACTION_REF_TABLE	External TableName
TRANSACTION_REF_ID	External Table Primary Key
TRANSACTION_TYPE	WorkFlow or not
ASSIGNMENT_ID	Selected Assignment
API_ADDTNL_INFO	Any Additional Info
SELECTED_PERSON_ID	Selected Person Id for this Transaction
CREATOR_PERSON_ID	Foreign key to PER_PEOPLE_F.
ITEM_TYPE
ITEM_KEY
TRANSACTION_EFFECTIVE_DATE
PROCESS_NAME
TRANSACTION_PRIVILEGE	When this column is 'Private', only the creator of the kiosk process can modify the data values associated with it.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who Column.
PRODUCT_CODE

Human Resources - HR_API_TRANSACTION_STEPS	Kiosk workflow data rows
Column Name	Descritpion
TRANSACTION_STEP_ID	System-generated primary key column.
UPDATE_PERSON_ID	Foreign key to PER_PEOPLE_F.
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_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
TRANSACTION_ID	Foreign key to HR_API_TRANSACTIONS.
API_NAME	Name of the API that should be called to write this datarow to the HR schema.
API_DISPLAY_NAME	Name of the procedure within a web page that displays the data values for a this transaction step within the kiosk process.
PROCESSING_ORDER	Order that the transaction steps need to be dealt with.
ITEM_TYPE	Workflow key value.
ITEM_KEY	Workflow key value.
ACTIVITY_ID	Workflow key value.
CREATOR_PERSON_ID	Foreigh key to PER_PEOPLE_F.

Human Resources - HR_API_TRANSACTION_VALUES	Kiosk workflow data columns and values
Column Name	Descritpion
TRANSACTION_VALUE_ID	System-gnerated primary key column.
ORIGINAL_DATE_VALUE	If the column is a Date, this is where the original data value is stored, before the kiosk user changed it.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
TRANSACTION_STEP_ID	Foreign key to HR_API_TRANSACTION_STEPS.
DATATYPE	The datatype of the column of data this value record stores.
NAME	Column name that the value is for.
VARCHAR2_VALUE	If the column is a Varchar2, this is where the data value is stored.
NUMBER_VALUE	If the column is a number, this is where the data value is stored.
DATE_VALUE	If the column is a Date, this is where the data value is stored.
ORIGINAL_VARCHAR2_VALUE	If the column is a Varchar2, this is where the original data value is stored, before the kiosk user changed it.
ORIGINAL_NUMBER_VALUE	If the column is a Number, this is where the original data value is stored, before the kiosk user changed it.

Human Resources - HR_API_MODULES	Holds details of the business processes and row handlers.
Column Name	Descritpion
LEGISLATION_CODE	NULL for APIs implemented and maintained by HR core evelopment. Not null for extra legislation or legislation vertical market business processes which will contain customer hooks.
MODULE_PACKAGE	When API_MODULE_TYPE is 'BP' holds the name of the database package containing the business process procedure otherwise NULL.
SECURITY_GROUP_ID
LAST_UPDATE_DATE	Standard Who Column.
LAST_UPDATED_BY	Standard Who Column.
LAST_UPDATE_LOGIN	Standard Who Column.
API_MODULE_ID	Unique ID for the module.
CREATED_BY	Standard Who Column.
CREATION_DATE	Standard Who Column.
API_MODULE_TYPE	Module type of the API.
MODULE_NAME	Module name of the API.
DATA_WITHIN_BUSINESS_GROUP	Indicates if the data assoicated with this module is within the context of a business_group_id.

Human Resources - HR_API_HOOKS	Lists the hook points which are available in each API module.
Column Name	Descritpion
HOOK_PROCEDURE	Name of the procedure with HOOK_PACKAGE which the business process or row handler calls when the hook point is reached.
LEGISLATION_CODE	Identifies rows created by legislation group/partners or legislation vertical markets. Will be null for all hooks provided by HR development core products.
LEGISLATION_PACKAGE	Holds the name of the database package to be called, to derive the legislation code, when legislation specific logicexists and p_business_group_id is not a known parameter to the hook package.
LEGISLATION_FUNCTION	Name of the function, within the database package LEGISLATION_PACKAGE, to call when the legislation code needs to be known.
ENCODED_ERROR	Holds the error text in AOL encoded format if the code to call the legislation_procedure or hook_procedure could not be created by the preprocessor..
SECURITY_GROUP_ID
API_HOOK_ID	System generated primary key 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.
API_MODULE_ID	Foreign key to HR_API_MODULES
API_HOOK_TYPE	Type of hook
HOOK_PACKAGE	Name of the database package which the business process or row handler calls when the hook point is reached.

Human Resources - HR_API_HOOK_CALLS	Lists which extra logic, package procedures or formula, should be called from the API hook points.
Column Name	Descritpion
SEQUENCE	When more than one row exists for the same API_HOOK_ID, SEQUENCE affects the order of the hook calls.
ENABLED_FLAG	Indicates if the hook call should be generated.
CALL_PACKAGE	Name of the database package which the hook package should call to carry out the legislation, legislation vertical market or customer specific logic.
CALL_PROCEDURE	Name of the procedure, within CALL_PACKAGE, which the hook package should call to carry out the legislation, legislation vertical market or customer specific logic.
PRE_PROCESSOR_DATE	The last time the API hook pre-processor program attempted (successfully or unsuccessfully) to create the package body code for this hook call.
API_HOOK_CALL_ID	System generated primary key column.
ENCODED_ERROR	If the last time the API hook pre-processor program failed to make the source code for this hook call, the error details will be held in this column.
STATUS	Status of hook call code at pre-processor time (as of PRE_PROCESSOR_DATE).
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.
CREATION_DATE	Standard Who Column.
API_HOOK_ID	Foreign key to HR_API_HOOKS.
APPLICATION_ID	The APPLICATION_ID of Application as defined in the FND_APPLCATION table.
APP_INSTALL_STATUS	Indicates for which installation statuses the hook call should be included in the user hook package body.
SECURITY_GROUP_ID
API_HOOK_CALL_TYPE	Type of hook call.
LEGISLATION_CODE	Indicates if the extra logic should be called every time the hook point is reached or when the data corresponds to a particular legislation.

Human Resources - HR_API_USER_HOOK_REPORTS	Used to hold HR_API_USER_HOOK error information if this exists otherwise no information is held.
Column Name	Descritpion
SESSION_ID	Session_id for the hook report.
LINE	Primary Key, order sequence number.
TEXT	Text for user.
SECURITY_GROUP_ID

Human Resources - HR_DM_TABLES	This entity contains a HRMS table listing that will be processed by the data migrator.
Column Name	Descritpion
TABLE_ID	System-generated primary key column.
DERIVE_SQL_DELETE_SOURCE	The where clause of the select statement for deleting from the source database.
DERIVE_SQL_DOWNLOAD_ADD	The where clause of the select statement for additive migrations.
DERIVE_SQL_DOWNLOAD_FULL	The where clause of the select statement for full migrations.
DERIVE_SQL_CHK_SOURCE_TABLES	The source tables for the FROM clause for checking if a row exists in the destination database.
DERIVE_SQL_CHK_ROW_EXISTS	The where clause of the select statement for checking if a row exists in the destination database
SURROGATE_PK_COLUMN_NAME	Surrogate primary key column name for use in data tracked deletes.
TAB_DELETE	A flag used to indicate if the table is to be deleted, Y, or not, N.
LOADER_NAME	The description of the loader used for migration of AOL data..
LOADER_CONC_PROGRAM	The name of the loader concurrent program
LOADER_CONFIG_FILE	The name of the loader configuration file used for migration of AOL data.
TABLE_NAME	Name of the table.
LOADER_APPLICATION	The application short name for the loader used for migration of AOL data.
SHORT_NAME	A short form of the table name for use in dynamic SQL.
USE_DISTINCT_DOWNLOAD	A flag used to enforce the use of distinct in the select clause used during the download.
LAST_GENERATED_DATE	The date of the last successful generation of the TDS/TUDS packages for this table.
GENERATOR_VERSION	The version details of the main generator, TDS and TUPS packages are stored to enable regeneration of all TDS/TUPS when the generator is modified.
WHO_LINK_ALIAS	The alias of the table which contains the last update date information where the current table does not have an explicit last update date (ie no WHO columns).
GLOBAL_DATA	A Y indicates that this business group is not striped by business group and thus contain global data. These tables will be migrated in full.
ALWAYS_CHECK_ROW	A Y indicates that the TUPS should always check if a row exists in the destination database.
SEQUENCE_NAME	The sequence to be used to generate a new value for the primary key if a row is to be inserted but the id value used in the source database already exists. If this value is not null then a check will always be made to see if the id value ha
LAST_UPDATE_DATE	Standard Who column.
UPLOAD_TABLE_NAME	Name of the table as used by the TUPS. If the value is NULL then the TABLE_NAME is used.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
TABLE_ALIAS	The cursor alias for the table.
DATETRACK	A flag used to indicate if the table is data tracked, Y, or not data tracked, N.
APPLICATION	A flag used to indicate if the table contains application data, Y, or not, N.
PARTICIPANT	A flag used to indicate if the table contains participant data, Y, or not, N.
SECURITY_GROUP_ID
DERIVE_SQL_SOURCE_TABLES	The source tables for constructing the from clause for the derive SQL statements in the TDS.
DERIVE_SQL_CALC_RANGES	The where clause of the select statement for calculating ranges.

Human Resources - HR_DM_COLUMN_DEFINITIONS	Column definitions for sequence range management
Column Name	Descritpion
COLUMN_ID	System-generated primary key column.
COLUMN_PRECISION	The precision or the total number of digits.
RANGE_SIZE	The next Range_Size for the particular column precision.
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_DM_DATABASES	Table containing names of all databases within database farm
Column Name	Descritpion
DATABASE_ID	System-generated primary key column.
CREATION_DATE	Standard Who column.
DATABASE_NAME	Unique Database Names which will correspond to the TNS Name for the database.
DESCRIPTION	Free text description for the Database.
USER_NAME	Apps user name.
SECURITY_GROUP_ID
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_DM_SEQUENCE_DEFINITIONS	Table containing Sequence Name information for the PER/PAY/DT/FF/OTA/SSP/GHR/HXT/BEN applications.
Column Name	Descritpion
SEQUENCE_ID	System-generated primary key column.
SEQUENCE_NAME	Sequence Names for PER/PAY/DT/FF/OTA/SSP/GHR/HXT/BEN tables.
TABLE_NAME	Name of the table for which the Sequence is applied.
COLUMN_ID	Foreign Key to HR_DM_COLUMN_DEFINITIONS.COLUMN_ID.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
SECURITY_GROUP_ID
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.

Human Resources - HR_DM_SEQUENCE_HISTORIES	Table containing sequence information from the different Fidelity databases. To be updated before any changes to sequences are made to enable sequence history tracking.
Column Name	Descritpion
SEQUENCE_HISTORY_ID	System-generated primary key column.
CREATION_DATE	Standard Who column.
SEQUENCE_ID	Foreign Key to HR_DM_SEQUENCE_DEFINITIONS.SEQUENCE_ID.
DATABASE_ID	Foreign Key to HR_DM_DATABASES.DATABASE_ID.
TIMESTAMP	The time at which the sequence value was updated, in the format (YYYYMMDDHH24MISS).
SEQUENCE_VALUE	The value of the last number used from the sequence, read from the value of LAST_NUMBER in the table ALL_SEQUENCES. This value may be larger than the current value of the sequence with a maximum error of the sequence cache setting. It may a
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
SECURITY_GROUP_ID
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.

Human Resources - HR_DM_SEQUENCE_RANGES	Table containing Sequence Ranges for particular Sequence and Database. This table can hold multiple Ranges for a given Sequence and Database.
Column Name	Descritpion
SEQUENCE_RANGE_ID	System-generated primary key column.
CREATION_DATE	Standard Who column.
SEQUENCE_ID	Foreign Key to HR_DM_SEQUENCE_DEFINITIONS.SEQUENCE_ID.
DATABASE_ID	Foreign Key to HR_DM_DATABASES.DATABASE_ID. This refers to the database that the sequence range was originally created on. Once the Data Migrator has been moved, ID values in these sequence ranges will be found on other databases
MIN_VALUE	Minimum Range Value
MAX_VALUE	Maximum Range Value
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
SECURITY_GROUP_ID
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.

Human Resources - HR_DM_APPLICATION_GROUPS	Data Migrator locking ladder groups for applications.
Column Name	Descritpion
APP_GROUP_ID	Primary key for the table. Surrogate Id. Derived from HR_DM_APPLICATION_GROUPS _S sequence.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
GROUP_ID	Foreign key to HR_DM_GROUPS
APPLICATION_ID	The application_id from the table FND_APPLICATION. But there is no foreign key relationship.
MIGRATION_TYPE	The type of migration being undertaken. This value is a lookup code of the lookup type HR_DM_MIGRATION_TYPE and is defined in the table FND_LOOKUP_TYPES, FND_LOOKUP_VALUES.
GROUP_ORDER	The order used in the upload process. Groups have to loaded in the order specified. Master records must be loaded first before the children.
SECURITY_GROUP_ID
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.

Human Resources - HR_DM_DT_DELETES	This table holds the information for the deletion of date tracked data. This table is also used to hold participant data information of data that has been downloaded but not been uploaded.
Column Name	Descritpion
DT_DELETE_ID	System-generated primary key column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
SECURITY_GROUP_ID
TABLE_NAME	The name of the table
DATA_TYPE	The type of date tracked date referred to, either D for Delete or P for Pre-existing data.
ID_VALUE	The value of the primary key of the table. For a composite primary key, this value is that of the primary key column(s) not including EFFECTIVE_START_DATE and EFFECTIVE_END_DATE.
PK_COLUMN_1	The non-surrogate primary key can consist of several columns, each of which may be non-numeric.
PK_COLUMN_2	The non-surrogate primary key can consist of several columns, each of which may be non-numeric.
PK_COLUMN_3	The non-surrogate primary key can consist of several columns, each of which may be non-numeric.
PK_COLUMN_4	The non-surrogate primary key can consist of several columns, each of which may be non-numeric.
LAST_UPDATE_DATE	Standard Who column.

Human Resources - HR_DM_GROUPS	This table holds information about the groupings used in the data migration process.
Column Name	Descritpion
GROUP_ID	System-generated primary key column.
DESCRIPTION	Free text description.
GROUP_TYPE	The type of data contained within the group which indicates which type of loader is required or if an item is applicable to the clean up phase
SECURITY_GROUP_ID
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_DM_HIERARCHIES	This entity will contain the relationships between tables. The following relationship will be recorded:
Column Name	Descritpion
HIERARCHY_ID	System-generated primary key column.
PARENT_ID_COLUMN_NAME	The AOL developer key.
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.
HIERARCHY_TYPE	The hierarchy relationship. This value is a lookup code of the lookup type HR_DM_ HIERARCHY_TYPE and is defined in the table FND_LOOKUP_TYPES, FND_LOOKUP_VALUES.
SECURITY_GROUP_ID
SQL_ORDER	Information used to derive the cursor order in the TDS packages for complex relationships. This feature is not currently used.
TABLE_ID	Foreign Key to HR_DM_TABLES.TABLE_ID
COLUMN_NAME	The column name of the child table.
PARENT_TABLE_ID	Foreign Key to HR_DM_TABLES.TABLE_ID
PARENT_COLUMN_NAME	The column name in the parent table.v

Human Resources - HR_DM_MIGRATIONS	This table contains the data migration information. There is one row per migration in progress.
Column Name	Descritpion
MIGRATION_ID	System-generated primary key column.
MIGRATION_END_DATE	End date of the migration, when the migration status is F (Finished).
STATUS	Current status of the process. This value is a lookup code of the lookup type HR_DM_MIGRATION_STATUS and is defined in the table FND_LOOKUP_TYPES, FND_LOOKUP_TYPES_TL and FND_LOOKUP_VALUES.
MIGRATION_PROCESS	The description of the current process being undertaken by the data migrator.
EFFECTIVE_DATE	Start date of the migration, which is the system date (sysdate) at which the row in the HR_DM_MIGRATIONS table was created.
MIGRATION_COUNT	The number of runs of the migration. If the migration is rerun then this value is incremented.
SELECTIVE_MIGRATION_CRITERIA	Free form text describing the migration criteria.
ACTIVE_GROUP	The group_id for the group which is active during the delete phase of a delete migration. The group_id is defined in the table HR_DM_GROUPS.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
SOURCE_DATABASE_INSTANCE	The name of the source database.
CREATION_DATE	Standard Who column.
CREATED_BY	Standard Who column.
SECURITY_GROUP_ID
DESTINATION_DATABASE_INSTANCE	The name of the destination database
MIGRATION_TYPE	The type of migration being undertaken. This value is a lookup code of the lookup type HR_DM_MIGRATION_TYPE and is defined in the table FND_LOOKUP_TYPES, FND_LOOKUP_VALUES.
APPLICATION_ID	The application for which data is to be migrated as defined in the table FND_APPLICATION.
BUSINESS_GROUP_ID	The business group ID as defined in the table HR_ALL_ORGANIZATION_UNITS.
BUSINESS_GROUP_NAME	The business group name as defined in the table HR_ALL_ORGANIZATION_UNITS.
BUSINESS_GROUP_CREATED	For an FW migration, the business group needs to be created in the destination database, after which this entry is set to Y.
MIGRATION_START_DATE	Start date of the last run of the data migrator tool.

Human Resources - HR_DM_MIGRATION_RANGES	This table holds the allocated ranges for each slave process to process during each Download Application/Participant data phase of the migration.
Column Name	Descritpion
RANGE_ID	System-generated primary key column.
ROW_COUNT	The number of physical records that exist in the sequence range to be migrated.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATION_DATE	Standard Who column.
CREATED_BY	Standard Who column.
PHASE_ITEM_ID	Foreign Key to HR_DM_PHASE_ITEMS.PHASE_ITEM_ID.
SECURITY_GROUP_ID
STARTING_PROCESS_SEQUENCE	Initial value within the sequence to be processed.
ENDING_PROCESS_SEQUENCE	End value within the sequence to be processed.
STATUS	Current status of the process. This value is a lookup code of the lookup type HR_DM _STATUS and is defined in the tables FND_LOOKUP_TYPES, FND_LOOKUP_TYPES_TL and FND_LOOKUP_VALUES.
START_TIME	Start time of the migration range processing
END_TIME	End time of the migration range processing.

Human Resources - HR_DM_MIGRATION_REQUESTS	This table holds the information about the request id of the issuing concurrent program.
Column Name	Descritpion
MIGRATION_REQUEST_ID	System-generated primary key column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
MIGRATION_ID	Foreign Key to HR_DM_MIGRATIONS.MIGRATION_ID.
SECURITY_GROUP_ID
PHASE_ID	Foreign Key to HR_DM_PHASES.PHASE_ID.
PHASE_ITEM_ID	Foreign Key to HR_DM_PHASE_ITEMS.PHASE_ITEM_ID.
REQUEST_ID	The request id of the concurrent program found in the table FND_CONCURRENT_REQUESTS.
ENABLED_FLAG	This flag is set to Y for the current run, with any other runs having this flag set to N.
MASTER_SLAVE	This flag is set to M for a Master and S for a Slave.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.

Human Resources - HR_DM_PHASES	This table holds the information about each phase of the migration process.
Column Name	Descritpion
PHASE_ID	System-generated primary key column.
CREATION_DATE	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
MIGRATION_ID	Foreign Key to HR_DM_MIGRATIONS.MIGRATION_ID
SECURITY_GROUP_ID
PHASE_NAME	Name of the phase. This value is a lookup code of the lookup type HR_DM_MIGRATION_PHASE and is defined in the table FND_LOOKUP_TYPES, FND_LOOKUP_VALUES.
STATUS	Current status of the process. This value is a lookup code of the lookup type HR_DM_STATUS and is defined in the table FND_LOOKUP_TYPES, FND_LOOKUP_TYPES_TL and FND_LOOKUP_VALUES.
START_TIME	Start time of the migration range processing.
END_TIME	End time of the migration range processing.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.

Human Resources - HR_DM_PHASE_ITEMS	This table details the work to be undertaken for each phase of the Data Migrator.
Column Name	Descritpion
PHASE_ITEM_ID	System-generated primary key column.
START_TIME	Start time of the phase item processing.
END_TIME	End time of the phase item processing
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.
PHASE_ID	Foreign Key to HR_DM_PHASES. PHASE_ID.
SECURITY_GROUP_ID
LOADER_NAME	Loader name as derived from the HR_DM_TABLES.LOADER_NAME.
LOADER_PARAMS_ID	Foreign Key to HR_DM_LOADER_PARAMS. LOADER_ PARAMS_ID
BATCH_ID	The batch id used for Data pump
GROUP_ID	The group id from the table HR_DM_GROUPS. There is no foreign key relationship.
TABLE_NAME	Name of the table.
STATUS	Current status of the process. This value is a lookup code of the lookup type HR_DM_MIGRATION_STATUS and is defined in the table FND_LOOKUP_TYPES, FND_LOOKUP_TYPES_TL and FND_LOOKUP_VALUES.

Human Resources - HR_DM_TABLE_GROUPINGS	This entity holds the information for the grouping of tables.
Column Name	Descritpion
GROUPING_ID	System-generated primary key column.
LINK_VALUE	A value used by Data pump. This is not currently used.
TABLE_ID	Foreign Key to HR_DM_TABLES.TABLE_IDv
GROUP_ID	Foreign Key to HR_DM_GROUPS GROUP_ID.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
SECURITY_GROUP_ID
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.

Human Resources - HR_ALL_ORGANIZATION_UNITS_TL	Translated organization unit name definitions.
Column Name	Descritpion
ORGANIZATION_ID	Foreign key to HR_ALL_ORGANIZATION_UNITS.
CREATION_DATE	Standard Who column
LANGUAGE	Defined Language
SOURCE_LANG	Actual language
NAME	Translated name of the organization
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_DM_PHASE_RULES	This table contains the rules governing which phases apply to which migrations.
Column Name	Descritpion
MIGRATION_TYPE	The type of migration being undertaken. This value is a lookup code of the lookup type HR_DM_MIGRATION_TYPE and is defined in the table FND_LOOKUP_TYPES, FND_LOOKUP_VALUES.
PHASE_NAME	Name of the phase. This value is a lookup code of the lookup type HR_DM_MIGRATION_PHASE and is defined in the table FND_LOOKUP_TYPES, FND_LOOKUP_VALUES.
PREVIOUS_PHASE	Name of the previous phase. This value is a lookup code of the lookup type HR_DM_MIGRATION_PHASE and is defined in the table FND_LOOKUP_TYPES, FND_LOOKUP_VALUES.
NEXT_PHASE	Name of the next phase. This value is a lookup code of the lookup type HR_DM_MIGRATION_PHASE and is defined in the table FND_LOOKUP_TYPES, FND_LOOKUP_VALUES.
DATABASE_LOCATION	The location of the database to which this phase for the current migration type applies.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
PHASE_RULE_ID	System-generated primary key column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
SECURITY_GROUP_ID

Human Resources - HR_ALL_ORGANIZATION_UNITS	Organization unit definitions.
Column Name	Descritpion
ORGANIZATION_ID	System-generated primary key column.
INTERNAL_EXTERNAL_FLAG	Identifies whether the organization is treated as an employment unit within the business group.
ATTRIBUTE28	Descriptive flexfield column.
ATTRIBUTE29	Descriptive flexfield column.
INTERNAL_ADDRESS_LINE	Internal address line.
ATTRIBUTE30	Descriptive flexfield column.
TYPE	User-defined organization types, for example Region, Division, Department.
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.
ATTRIBUTE2	Descriptive flexfield column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
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.
COST_ALLOCATION_KEYFLEX_ID	Foreign key to PAY_COST_ALLOCATION_KEYFLEX.
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.
LOCATION_ID	Foreign key to HR_LOCATIONS. Default work site location for all assignments to this organization.
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.
SOFT_CODING_KEYFLEX_ID	Column obsolete
PARTY_ID	Foreign key to HZ_PARTIES. Not currently used, reserved for future use.
DATE_FROM	Start date of the organization.
ATTRIBUTE21	Descriptive flexfield column.
NAME	Name of the organization.
ATTRIBUTE22	Descriptive flexfield column.
ATTRIBUTE23	Descriptive flexfield column.
COMMENTS	General remark.
ATTRIBUTE24	Descriptive flexfield column.
ATTRIBUTE25	Descriptive flexfield column.
DATE_TO	End date of the organization.
ATTRIBUTE26	Descriptive flexfield column.
ATTRIBUTE27	Descriptive flexfield column.

Human Resources - HR_DM_LOADER_PARAMS	This entity contains the configuration data for the AOL loader files
Column Name	Descritpion
LOADER_PARAMS_ID	System-generated primary key column.
PARAMETER7	The parameter name / value pairs as required for the specified configuration file.
PARAMETER8	The parameter name / value pairs as required for the specified configuration file.
PARAMETER9	The parameter name / value pairs as required for the specified configuration file.
PARAMETER10	The parameter name / value pairs as required for the specified configuration file.
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.
TABLE_ID	Foreign Key to HR_DM_TABLES.TABLE_ID
SECURITY_GROUP_ID
APPLICATION_ID	The application_id from the table FND_APPLICATION.
PARAMETER1	The parameter name / value pairs as required for the specified configuration file.
PARAMETER2	The parameter name / value pairs as required for the specified configuration file.
PARAMETER3	The parameter name / value pairs as required for the specified configuration file.
PARAMETER4	The parameter name / value pairs as required for the specified configuration file.
PARAMETER5	The parameter name / value pairs as required for the specified configuration file.
PARAMETER6	The parameter name / value pairs as required for the specified configuration file.

Human Resources - HR_DM_RESOLVE_PKS	This entity contains the values of the primary key for both the source and destination database for each table for use by the TUPS package.
Column Name	Descritpion
SOURCE_DATABASE_INSTANCE	Name of the source database for which the primary key resolution information applies.
TABLE_NAME	Name of the table.
SOURCE_ID	The value of the primary key for the table in the source database.
DESTINATION_ID	The value of the primary key for the table in the source database.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
RESOLVE_PK_ID	System-generated primary key column.
CREATION_DATE	Standard Who column.
SECURITY_GROUP_ID

Human Resources - HR_DM_EXP_IMPS	This table holds the data from various tables in the source database that will be moved to the destination database using the transportable tablespace for upload in the destination database
Column Name	Descritpion
EXP_IMP_ID	System-generated primary key column.
PVAL008	The data from the source table.
PVAL098	The data from the source table.
PVAL099	The data from the source table.
PVAL100	The data from the source table.
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.
PVAL009	The data from the source table.
SECURITY_GROUP_ID
PVAL010	The data from the source table.
PVAL011	The data from the source table.
PVAL012	The data from the source table.
PVAL013	The data from the source table.
PVAL014	The data from the source table.
PVAL015	The data from the source table.
PVAL016	The data from the source table.
PVAL017	The data from the source table.
TABLE_NAME	The name of the source / destination table
PVAL018	The data from the source table.
PVAL019	The data from the source table.
PVAL020	The data from the source table.
PVAL021	The data from the source table.
PVAL022	The data from the source table.
PVAL023	The data from the source table.
PVAL024	The data from the source table.
PVAL025	The data from the source table.
PVAL026	The data from the source table.
PVAL027	The data from the source table.
PVAL001	The data from the source table.
PVAL028	The data from the source table.
PVAL029	The data from the source table.
PVAL030	The data from the source table.
PVAL031	The data from the source table.
PVAL032	The data from the source table.
PVAL033	The data from the source table.
PVAL034	The data from the source table.
PVAL035	The data from the source table.
PVAL036	The data from the source table.
PVAL037	The data from the source table.
PVAL002	The data from the source table.
PVAL038	The data from the source table.
PVAL039	The data from the source table.
PVAL040	The data from the source table.
PVAL041	The data from the source table.
PVAL042	The data from the source table.
PVAL043	The data from the source table.
PVAL044	The data from the source table.
PVAL045	The data from the source table.
PVAL046	The data from the source table.
PVAL047	The data from the source table.
PVAL003	The data from the source table.
PVAL048	The data from the source table.
PVAL049	The data from the source table.
PVAL050	The data from the source table.
PVAL051	The data from the source table.
PVAL052	The data from the source table.
PVAL053	The data from the source table.
PVAL054	The data from the source table.
PVAL055	The data from the source table.
PVAL056	The data from the source table.
PVAL057	The data from the source table.
PVAL004	The data from the source table.
PVAL058	The data from the source table.
PVAL059	The data from the source table.
PVAL060	The data from the source table.
PVAL061	The data from the source table.
PVAL062	The data from the source table.
PVAL063	The data from the source table.
PVAL064	The data from the source table.
PVAL065	The data from the source table.
PVAL066	The data from the source table.
PVAL067	The data from the source table.
PVAL005	The data from the source table.
PVAL068	The data from the source table.
PVAL069	The data from the source table.
PVAL070	The data from the source table.
PVAL071	The data from the source table.
PVAL072	The data from the source table.
PVAL073	The data from the source table.
PVAL074	The data from the source table.
PVAL075	The data from the source table.
PVAL076	The data from the source table.
PVAL077	The data from the source table.
PVAL006	The data from the source table.
PVAL078	The data from the source table.
PVAL079	The data from the source table.
PVAL080	The data from the source table.
PVAL081	The data from the source table.
PVAL082	The data from the source table.
PVAL083	The data from the source table.
PVAL084	The data from the source table.
PVAL085	The data from the source table.
PVAL086	The data from the source table.
PVAL087	The data from the source table.
PVAL007	The data from the source table.
PVAL088	The data from the source table.
PVAL089	The data from the source table.
PVAL090	The data from the source table.
PVAL091	The data from the source table.
PVAL092	The data from the source table.
PVAL093	The data from the source table.
PVAL094	The data from the source table.
PVAL095	The data from the source table.
PVAL096	The data from the source table.
PVAL097	The data from the source table.

Human Resources - HR_ALL_POSITIONS_F	Position definition information.
Column Name	Descritpion
EFFECTIVE_START_DATE	Effective Start Date, part of the primary key.
OBJECT_VERSION_NUMBER	Object version Number
EFFECTIVE_END_DATE	Effective End Date, part of the primary key.
AMENDMENT_DATE	Amendment Date
AMENDMENT_RECOMMENDATION	Amendment Recommendation
AMENDMENT_REF_NUMBER	Amendment Reference Number.
AVAIL_STATUS_PROP_END_DATE	Date the current status beomes void.
BARGAINING_UNIT_CD	Bargaining Unit
COMMENTS	Comments
COPIED_TO_OLD_TABLE_FLAG	Set to Y, if data has been copied to PER_ALL_POSITIONS
CURRENT_JOB_PROP_END_DATE	Proposed date for current Job to end.
CURRENT_ORG_PROP_END_DATE	Proposed date for current Organization to end.
AVAILABILITY_STATUS_ID	Current Status of the Position. Refers to PER_SHARED_TYPES.
DATE_EFFECTIVE	Date when position becomes effective.
DATE_END	Date after which position is no longer valid. For full HRMS installations, this column will remain null.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
EARLIEST_HIRE_DATE	Earliest hire date
FILL_BY_DATE	The desired date by which the position should be filled.
FREQUENCY	Frequency
FTE	The full-time equivalents(FTE) assigned to this position.
MAX_PERSONS	Maximum number of employees on this position.
NAME	Position Name
OVERLAP_PERIOD	Overlap period
OVERLAP_UNIT_CD	Unit of Period.
PAY_TERM_END_DAY_CD	End Day of Pay Term
PAY_TERM_END_MONTH_CD	End Month of Pay Term
PERMANENT_TEMPORARY_FLAG	Indicates wheather position is Temporary or Permanent.
ENTRY_GRADE_ID	Foreign key to PER_GRADES
PERMIT_RECRUITMENT_FLAG	Recruitment can start or not.
POSITION_TYPE	Identifies whether the position is single FTE and single incumbent, single FTE and shared, multiple FTE and multiple incumbents, or pooled.
POSTING_DESCRIPTION	Posting Description
PROBATION_PERIOD	Probationary period.
PROBATION_PERIOD_UNIT_CD	Qualifying units.
PROPOSED_FTE_FOR_LAYOFF	Proposed FTE for layoff
PROPOSED_DATE_FOR_LAYOFF	Proposed date for layoff
REPLACEMENT_REQUIRED_FLAG	Is replacement required when person assigned to position is absent.
REVIEW_FLAG	Identifies whether the characteristics of the position are under going review or change.
SEASONAL_FLAG	Is position Seasonal. Yes/No
SECURITY_REQUIREMENTS	Security Requirements.
STATUS	Status of the Position. Valid or null values are considered to be valid.
TERM_START_DAY_CD	Start Day of Work and Pay Term
ENTRY_GRADE_RULE_ID	Pseudo Foreign key to PAY_GRADE_RULES_F
TERM_START_MONTH_CD	Start Month of Work or Pay Term
TIME_NORMAL_FINISH	Finish time.
TIME_NORMAL_START	Start time.
UPDATE_SOURCE_CD	Update Source Code.
WORKING_HOURS	Working Hours
WORKS_COUNCIL_APPROVAL_FLAG	Work Council Approval Flag
WORK_PERIOD_TYPE_CD	Identifies that the position is only used during part of the year.
WORK_TERM_END_DAY_CD	End Day of Work Term
WORK_TERM_END_MONTH_CD	End Month of Work Term
ENTRY_STEP_ID	Pseudo Foreign key to PER_SPINAL_POINT_STEPS_F
JOB_ID	Foreign key to PER_JOBS
INFORMATION1	Developer Descriptive Flexfield
LOCATION_ID	Foreign key to HR_LOCATIONS_ALL
ORGANIZATION_ID	Foreign key to HR_ORGANIZATION_UNITS.
POSITION_ID	System-generated primary key column.
PAY_BASIS_ID	Foreign key to PER_PAY_BASES.
PAY_FREQ_PAYROLL_ID	Pseudo Foreign key to PAY_ALL_PAYROLLS_F
INFORMATION2	Developer Descriptive Flexfield
INFORMATION3	Developer Descriptive Flexfield
INFORMATION4	Developer Descriptive Flexfield
INFORMATION5	Developer Descriptive Flexfield
POSITION_DEFINITION_ID	Foreign key to PER_POSITION_DEFINITIONS
INFORMATION6	Developer Descriptive Flexfield
INFORMATION7	Developer Descriptive Flexfield
INFORMATION8	Developer Descriptive Flexfield
INFORMATION9	Developer Descriptive Flexfield
INFORMATION10	Developer Descriptive Flexfield
INFORMATION11	Developer Descriptive Flexfield
INFORMATION12	Developer Descriptive Flexfield
INFORMATION13	Developer Descriptive Flexfield
INFORMATION14	Developer Descriptive Flexfield
INFORMATION15	Developer Descriptive Flexfield
INFORMATION16	Developer Descriptive Flexfield
POSITION_TRANSACTION_ID	Foreign key to PQH_POSITION_TRANSACTIONS
INFORMATION17	Developer Descriptive Flexfield
INFORMATION18	Developer Descriptive Flexfield
INFORMATION19	Developer Descriptive Flexfield
INFORMATION20	Developer Descriptive Flexfield
INFORMATION21	Developer Descriptive Flexfield
INFORMATION22	Developer Descriptive Flexfield
INFORMATION23	Developer Descriptive Flexfield
INFORMATION24	Developer Descriptive Flexfield
INFORMATION25	Developer Descriptive Flexfield
INFORMATION26	Developer Descriptive Flexfield
INFORMATION27	Developer Descriptive Flexfield
PRIOR_POSITION_ID	Pseudo Foreign key to HR_ALL_POSITIONS_F
INFORMATION28	Developer Descriptive Flexfield
INFORMATION29	Developer Descriptive Flexfield
INFORMATION30	Developer Descriptive Flexfield
RELIEF_POSITION_ID	Pseudo Foreign key to HR_ALL_POSITIONS_F
INFORMATION_CATEGORY	Developer Descriptive Flexfield
ATTRIBUTE1	Descriptive Flexfield
ATTRIBUTE2	Descriptive Flexfield
ATTRIBUTE3	Descriptive Flexfield
ATTRIBUTE4	Descriptive Flexfield
ATTRIBUTE5	Descriptive Flexfield
ATTRIBUTE6	Descriptive Flexfield
ATTRIBUTE7	Descriptive Flexfield
ATTRIBUTE8	Descriptive Flexfield
SUCCESSOR_POSITION_ID	Pseudo Foreign key to HR_ALL_POSITIONS_F
ATTRIBUTE9	Descriptive Flexfield
ATTRIBUTE10	Descriptive Flexfield
ATTRIBUTE11	Descriptive Flexfield
ATTRIBUTE12	Descriptive Flexfield
ATTRIBUTE13	Descriptive Flexfield
ATTRIBUTE14	Descriptive Flexfield
ATTRIBUTE15	Descriptive Flexfield
ATTRIBUTE16	Descriptive Flexfield
ATTRIBUTE17	Descriptive Flexfield
ATTRIBUTE18	Descriptive Flexfield
SUPERVISOR_ID	Foreign key to PER_PEOPLE.
ATTRIBUTE19	Descriptive Flexfield
ATTRIBUTE20	Descriptive Flexfield
ATTRIBUTE21	Descriptive Flexfield
SUPERVISOR_POSITION_ID	Pseudo Foreign key to HR_ALL_POSITIONS_F
ATTRIBUTE22	Descriptive Flexfield
ATTRIBUTE23	Descriptive Flexfield
ATTRIBUTE24	Descriptive Flexfield
ATTRIBUTE25	Descriptive Flexfield
ATTRIBUTE26	Descriptive Flexfield
ATTRIBUTE27	Descriptive Flexfield
ATTRIBUTE28	Descriptive Flexfield
ATTRIBUTE29	Descriptive Flexfield
ATTRIBUTE30	Descriptive Flexfield
ATTRIBUTE_CATEGORY	Descriptive Flexfield
REQUEST_ID	Standard who column.
PROGRAM_APPLICATION_ID	Standard who column.
PROGRAM_ID	Standard who column.
PROGRAM_UPDATE_DATE	Standard who column.
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.

Human Resources - HR_FORM_DATA_GROUP_ITEMS	Links items with data groups for configurable forms
Column Name	Descritpion
FORM_DATA_GROUP_ITEM_ID	System-generated primary key using sequence HR_FORM_DATA_GROUP_ITEMS_S
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
FORM_DATA_GROUP_ID	Foreign Key to HR_FORM_DATA_GROUPS_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_FORM_DATA_GROUPS_TL	Translated form data group definitions for configurable forms
Column Name	Descritpion
FORM_DATA_GROUP_ID	System-generated primary key using sequence HR_FORM_DATA_GROUPS_TL_S
CREATION_DATE	Standard Who column.
LANGUAGE	Defined language
SOURCE_LANG	Actual language
USER_DATA_GROUP_NAME	Translated name of data group
DESCRIPTION	Translated description of the information type
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_FORM_DATA_GROUPS_B	Form data group definition for configurable forms
Column Name	Descritpion
FORM_DATA_GROUP_ID	System-generated primary key using sequence HR_FORM_DATA_GROUPS_B
CREATION_DATE	Standard Who column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
APPLICATION_ID	Foreign key to FND_FORM.APPLICATION_ID
FORM_ID	Foreign key to FND_FORM.FORM_ID
DATA_GROUP_NAME	Data Group Name
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_FORM_CANVASES_TL	Translated canvas definitions for configurable forms.
Column Name	Descritpion
FORM_CANVAS_ID	System-generated primary key using sequence HR_FORM_CANVASES_TL_S
CREATION_DATE	Standard Who column.
LANGUAGE	Defined language
SOURCE_LANG	Actual language
USER_CANVAS_NAME	Translated name of configurable canvas
DESCRIPTION	Translated description of the information type
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_FORM_CANVASES_B	Canvas definition for configurable forms
Column Name	Descritpion
FORM_CANVAS_ID	System-generated primary key using sequence HR_FORM_CANVASES_B_S
CREATION_DATE	Standard Who column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
FORM_WINDOW_ID	Foreign Key to HR_FORM_WINDOWS_B
CANVAS_NAME	Configurable canvas name
CANVAS_TYPE	Configurable canvas type
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_CANVAS_PROPERTIES	Canvas properties for configurable forms
Column Name	Descritpion
CANVAS_PROPERTY_ID	System-generated primary key using sequence HR_CANVAS_PROPERTIES_S
INFORMATION1	Developer descriptive flexfield column.
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.
FORM_CANVAS_ID	Foreign key to HR_FORM_CANVASES_B
INFORMATION11	Developer descriptive flexfield column.
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.
TEMPLATE_CANVAS_ID	Foreign Key to HR_TEMPLATE_CANVASSES_B
INFORMATION21	Developer descriptive flexfield column.
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.
HEIGHT	Canvas height
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.
VISIBLE	Visibility of canvas
WIDTH	Canvas width
X_POSITION	Canvas x-position
Y_POSITION	Canvas y-position
INFORMATION_CATEGORY	Developer descriptive flexfield column.

Human Resources - HR_FORM_TAB_PAGES_B	Definition of form tab page for configurable forms
Column Name	Descritpion
FORM_TAB_PAGE_ID	System-generated primary key using sequence HR_FORM_TAB_PAGES_B_S
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
FORM_CANVAS_ID	Foreign Key to HR_FORM_CANVASES_B
TAB_PAGE_NAME	Name of tab page. Should correspond to name in Form Builder
DISPLAY_ORDER	Display order of tab page. Should correspond to order in Form Builder
VISIBLE_OVERRIDE	If not null, overrides the visible property at template of form canvas level
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.

Human Resources - HR_FORM_PROPERTIES	Configurable properties for configurable forms modules
Column Name	Descritpion
FORM_PROPERTY_ID	System-generated primary key using sequence HR_FORM_PROPERTIES_S
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.
INFORMATION12	Developer descriptive flexfield column.
INFORMATION13	Developer descriptive flexfield column.
APPLICATION_ID	Foreign key to FND_FORM.APPLICATION_ID
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.
INFORMATION22	Developer descriptive flexfield column.
INFORMATION23	Developer descriptive flexfield column.
FORM_ID	Foreign key to FND_FORM.FORM_ID
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.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
FORM_TEMPLATE_ID	Foreign Key to HR_FORM_TEMPLATES_B
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.
HELP_TARGET	URL target for help on form
INFORMATION_CATEGORY	Developer descriptive flexfield column.
INFORMATION1	Developer descriptive flexfield column.
INFORMATION2	Developer descriptive flexfield column.
INFORMATION3	Developer descriptive flexfield column.

Human Resources - HR_FORM_ITEMS_TL	Translated definitions of form items for configurable forms
Column Name	Descritpion
FORM_ITEM_ID	System-generated primary key using sequence HR_FORM_CANVASES_S
CREATION_DATE	Standard Who column.
LANGUAGE	Defined language
SOURCE_LANG	Actual language
USER_ITEM_NAME	Translated name for the item
DESCRIPTION	Translated description of the information type
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_FORM_ITEMS_B	Definition of items available for configurable forms
Column Name	Descritpion
FORM_ITEM_ID	System-generated primary key using sequence HR_FORM_ITEMS_B_S
FORM_TAB_PAGE_ID_OVERRIDE	Foreign key to HR_FORM_TAB_PAGES_B: Not null indicates definition overrides template item definitions
VISIBLE_OVERRIDE	Item-visible property: Not null indicates definition overrides template item definitions
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.
APPLICATION_ID	Foreign key to FND_FORM.APPLICATION_ID
FORM_ID	Foreign key to FND_FORM.FORM_ID
FORM_CANVAS_ID	Foreign Key to HR_FORM_CANVASES_B
FULL_ITEM_NAME	Name of item
ITEM_TYPE	Type of item
FORM_TAB_PAGE_ID	Foreign Key to HR_FORM_TAB_PAGES_B
RADIO_BUTTON_NAME	Name for radio button items
REQUIRED_OVERRIDE	Item-required property: Not null indicates definition overrides template item definitions

Human Resources - HR_FORM_WINDOWS_TL	Translated definition of windows for configurable form
Column Name	Descritpion
FORM_WINDOW_ID	System-generated primary key using sequence HR_FORM_WINDOWS_TL
CREATION_DATE	Standard Who column.
LANGUAGE	Defined language
SOURCE_LANG	Actual language
USER_WINDOW_NAME	Translated window name
DESCRIPTION	Translated description of the information type
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_FORM_WINDOWS_B	Definition of windows for use in configurable forms
Column Name	Descritpion
FORM_WINDOW_ID	System-generated primary key using sequence HR_FORM_WINDOWS_B_S
CREATION_DATE	Standard Who column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
APPLICATION_ID	Foreign key to FND_FORM.APPLICATION_ID
FORM_ID	Foreign key to FND_FORM.FORM_ID
WINDOW_NAME	Name of window
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_FORM_TEMPLATES_TL	Translated template definition for use in configurable forms
Column Name	Descritpion
FORM_TEMPLATE_ID	System-generated primary key using sequence HR_FORM_TEMPLATES_TL_S
CREATION_DATE	Standard Who column.
LANGUAGE	Defined language
SOURCE_LANG	Actual language
USER_TEMPLATE_NAME	Translated name of template
DESCRIPTION	Translated description of the information type
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_FORM_TEMPLATES_B	Definition of template used by configurable forms
Column Name	Descritpion
FORM_TEMPLATE_ID	System-generated primary key using sequence HR_FORM_TEMPLATES_B
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.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
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.
ATTRIBUTE21	Descriptive flexfield column.
APPLICATION_ID	Foreign key to FND_FORM.APPLICATION_ID
ATTRIBUTE22	Descriptive flexfield column.
ATTRIBUTE23	Descriptive flexfield column.
ATTRIBUTE24	Descriptive flexfield column.
ATTRIBUTE25	Descriptive flexfield column.
ATTRIBUTE26	Descriptive flexfield column.
ATTRIBUTE27	Descriptive flexfield column.
ATTRIBUTE28	Descriptive flexfield column.
ATTRIBUTE29	Descriptive flexfield column.
ATTRIBUTE30	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
FORM_ID	Foreign key to FND_FORM.FORM_ID
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
TEMPLATE_NAME	Name of template
ENABLED_FLAG	Indicate if template is currently available to runtime engine
LEGISLATION_CODE	Legislation template is designed for. Name and legislation combination must be unique
ATTRIBUTE_CATEGORY	Descriptive flexfield column.
ATTRIBUTE1	Descriptive flexfield column.

Human Resources - HR_FORM_TAB_STACKED_CANVASES	Definition of stacked canvas for tab pages in configurable forms
Column Name	Descritpion
FORM_TAB_STACKED_CANVAS_ID	System-generated primary key using sequence HR_FORM_TAB_STACKED_CANVASES_S
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
FORM_TAB_PAGE_ID	A foreign key to HR_FORM_TAB_PAGES_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_FORM_TAB_PAGES_TL	Translated definition of form tab page for configurable forms
Column Name	Descritpion
FORM_TAB_PAGE_ID	System-generated primary key using sequence HR_FORM_TAB_PAGES_TL_S
CREATION_DATE	Standard Who column.
LANGUAGE	Defined language
SOURCE_LANG	Actual language
USER_TAB_PAGE_NAME	Translated name of tab page
DESCRIPTION	Translated description of the information type
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_ADE_STYLES	Test table for ADE
Column Name	Descritpion
STYLE_ID
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
LAST_UPDATE_DATE
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
STYLE_NAME
STYLE_TYPE
VIEW_NAME
API_NAME
RETURN_STYLE
RESPONSIBILITY_ID
LETTER_NAME
LETTER_FILE

Human Resources - HR_ADE_STYLE_COLUMNS	Test table for ADE
Column Name	Descritpion
STYLE_COLUMN_ID
LAST_UPDATE_DATE
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
STYLE_ID
COLUMN_NAME
DISPLAY_NAME
WIDTH
COLUMN_TYPE
COLUMN_DATATYPE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN

Human Resources - AME_ACTIONS	To be Updated
Column Name	Descritpion
ACTION_ID
END_DATE
DESCRIPTION
SECURITY_GROUP_ID
ACTION_TYPE_ID
PARAMETER
PARAMETER_TWO
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
START_DATE

Human Resources - AME_CALLING_APPS	To be Updated
Column Name	Descritpion
FND_APPLICATION_ID
START_DATE
END_DATE
SECURITY_GROUP_ID
APPLICATION_NAME
TRANSACTION_TYPE_ID
APPLICATION_ID
LINE_ITEM_ID_QUERY
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN

Human Resources - AME_CONDITION_USAGES	To be Updated
Column Name	Descritpion
RULE_ID
CONDITION_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
START_DATE
END_DATE
SECURITY_GROUP_ID

Human Resources - AME_TEMP_APPROVAL_PROCESSES
Column Name	Descritpion
APPLICATION_ID
TRANSACTION_ID
ROW_TIMESTAMP
RULE_ID

Human Resources - AME_STRING_VALUES	To be Updated
Column Name	Descritpion
CONDITION_ID
STRING_VALUE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
START_DATE
END_DATE
SECURITY_GROUP_ID

Human Resources - AME_RULE_USAGES	To be Updated
Column Name	Descritpion
ITEM_ID
END_DATE
SECURITY_GROUP_ID
PRIORITY
APPROVER_CATEGORY
USAGE_TYPE
RULE_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
START_DATE

Human Resources - AME_RULES	To be Updated
Column Name	Descritpion
RULE_ID
END_DATE
DESCRIPTION
SECURITY_GROUP_ID
RULE_KEY
ITEM_CLASS_ID
RULE_TYPE
ACTION_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
START_DATE

Human Resources - AME_MANDATORY_ATTRIBUTES	To be Updated
Column Name	Descritpion
ATTRIBUTE_ID
ACTION_TYPE_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
START_DATE
END_DATE
SECURITY_GROUP_ID

Human Resources - AME_HELP	To be Updated
Column Name	Descritpion
CONTEXT
FILE_NAME
SECURITY_GROUP_ID

Human Resources - AME_FIELD_HELP	To be Updated
Column Name	Descritpion
FIELD_NAME
PROCEDURE_NAME
PACKAGE_NAME
HELP_TEXT
SECURITY_GROUP_ID

Human Resources - AME_EXCEPTIONS_LOG	To be Updated
Column Name	Descritpion
LOG_ID
PACKAGE_NAME
ROUTINE_NAME
TRANSACTION_ID
APPLICATION_ID
EXCEPTION_NUMBER
EXCEPTION_STRING
SECURITY_GROUP_ID

Human Resources - AME_CONFIG_VARS	To be Updated
Column Name	Descritpion
VARIABLE_NAME
END_DATE
SECURITY_GROUP_ID
VARIABLE_VALUE
DESCRIPTION
CREATED_BY
APPLICATION_ID
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
START_DATE

Human Resources - AME_TEMP_OLD_APPROVER_LISTS	To be Updated
Column Name	Descritpion
TRANSACTION_ID
ITEM_CLASS
ITEM_ID
ACTION_TYPE_ID
APPLICATION_ID
APPROVAL_TYPE_ID
GROUP_OR_CHAIN_ID
OCCURRENCE
ORDER_NUMBER
USER_ID
PERSON_ID
API_INSERTION
AUTHORITY
APPROVAL_STATUS
SECURITY_GROUP_ID
NAME
APPROVER_CATEGORY

Human Resources - AME_TEMP_INSERTIONS	To be Updated
Column Name	Descritpion
TRANSACTION_ID
API_INSERTION
AUTHORITY
APPROVAL_STATUS
SECURITY_GROUP_ID
NAME
APPROVER_CATEGORY
ITEM_CLASS
ITEM_ID
SPECIAL_FORWARDEE
APPLICATION_ID
INSERTION_ORDER
ORDER_TYPE
PARAMETER
DESCRIPTION
ORDER_NUMBER
USER_ID
PERSON_ID

Human Resources - AME_TEMP_ATTRIBUTE_VALUES
Column Name	Descritpion
TRANSACTION_ID
APPLICATION_ID
ROW_TIMESTAMP
ATTRIBUTE_ID
ATTRIBUTE_VALUE
ATTRIBUTE_VALUE_2
ATTRIBUTE_VALUE_3

Human Resources - AME_TEMP_APPROVER_LISTS
Column Name	Descritpion
TRANSACTION_ID
APPLICATION_ID
ORDER_NUMBER
USER_ID
PERSON_ID
API_INSERTION
AUTHORITY
APPROVAL_STATUS

Human Resources - AME_CONDITIONS	To be Updated
Column Name	Descritpion
CONDITION_ID
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
START_DATE
END_DATE
SECURITY_GROUP_ID
CONDITION_KEY
CONDITION_TYPE
ATTRIBUTE_ID
PARAMETER_ONE
PARAMETER_TWO
PARAMETER_THREE
INCLUDE_LOWER_LIMIT
INCLUDE_UPPER_LIMIT
CREATED_BY
CREATION_DATE

Human Resources - AME_ATTRIBUTE_USAGES	To be Updated
Column Name	Descritpion
ATTRIBUTE_ID
START_DATE
END_DATE
SECURITY_GROUP_ID
APPLICATION_ID
QUERY_STRING
USE_COUNT
USER_EDITABLE
IS_STATIC
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN

Human Resources - AME_ACTION_TYPE_USAGES	To be Updated
Column Name	Descritpion
ACTION_TYPE_ID
RULE_TYPE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
START_DATE
END_DATE
SECURITY_GROUP_ID

Human Resources - AME_APPROVAL_GROUPS	To be Updated
Column Name	Descritpion
APPROVAL_GROUP_ID
DESCRIPTION
SECURITY_GROUP_ID
NAME
QUERY_STRING
IS_STATIC
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
START_DATE
END_DATE

Human Resources - AME_ATTRIBUTES	To be Updated
Column Name	Descritpion
ATTRIBUTE_ID
END_DATE
DESCRIPTION
SECURITY_GROUP_ID
APPROVER_TYPE_ID
ITEM_CLASS_ID
NAME
ATTRIBUTE_TYPE
LINE_ITEM
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
START_DATE

Human Resources - AME_APPROVAL_GROUP_ITEMS	To be Updated
Column Name	Descritpion
APPROVAL_GROUP_ITEM_ID
LAST_UPDATE_LOGIN
START_DATE
END_DATE
SECURITY_GROUP_ID
APPROVAL_GROUP_ID
PARAMETER_NAME
PARAMETER
ORDER_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE

Human Resources - AME_ACTION_TYPES	To be Updated
Column Name	Descritpion
ACTION_TYPE_ID
END_DATE
DESCRIPTION
SECURITY_GROUP_ID
DYNAMIC_DESCRIPTION
DESCRIPTION_QUERY
NAME
PROCEDURE_NAME
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
START_DATE

Human Resources - HR_DU_COLUMN_MAPPINGS	This table holds the relationship between the column name used in the source object (e.g. the spreadsheet column) and the output target (e.g. the Data Pump parameter name).
Column Name	Descritpion
COLUMN_MAPPING_ID	System generated primary key
LAST_UPDATE_LOGIN	Standard WHO column
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
SECURITY_GROUP_ID
API_MODULE_ID	Foreign Key to HR_API_MODULES.API_MODULE_ID
COLUMN_NAME	The name of the column loaded into HR_DU_UPLOAD_LINES.
MAPPED_TO_NAME	The name of the column / tag to which the column is mapped to.
MAPPING_TYPE	The output target for this mapping. This value is a lookup code of the lookup type HR_DU_MAPPING_TYPE and is defined in the table FND_LOOKUP_TYPES, FND_LOOKUP_TYPES_TL and FND_LOOKUP_VALUES
PARENT_API_MODULE_ID	Holds the API_MODULE_ID identifying which API module that column is attached to.
PARENT_TABLE	Used for generic entities such as phone. The column identifies where the calling API_MODULE_ID can be stored.
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column

Human Resources - HR_DU_DESCRIPTORS	This table holds the descriptor details for each API to be uploaded.
Column Name	Descritpion
DESCRIPTOR_ID	System generated primary key
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
SECURITY_GROUP_ID
UPLOAD_ID	Foreign Key to HR_DU_UPLOADS.UPLOAD_ID
UPLOAD_HEADER_ID	Foreign Key to HR_DU_UPLOAD_HEADERS.UPLOAD_HEADER_ID
DESCRIPTOR	The name of the descriptor tag
VALUE	The value of the descriptor tag
DESCRIPTOR_TYPE	Type of descriptor
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Human Resources - HR_DU_ERRORS	This table holds details about errors encountered during processing of a batch by any of the Data Uploader modules.
Column Name	Descritpion
ERROR_ID	System generated primary key
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
SECURITY_GROUP_ID
UPLOAD_ID	Foreign Key to HR_DU_UPLOADS.UPLOAD_ID
UPLOAD_HEADER_ID	Foreign Key to HR_DU_UPLOAD_HEADERS.UPLOAD_HEADER_ID
UPLOAD_LINE_ID	Foreign Key to HR_DU_UPLOAD_LINES.UPLOAD_LINE_ID
MODULE_ID	Foreign Key to HR_DU_MODULES.MODULE_ID
MESSAGE	The textual description of the error
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Human Resources - HR_DU_UPLOADS	This table holds the data relating to information uploaded from a single source file.
Column Name	Descritpion
UPLOAD_ID	System generated primary key
BUSINESS_GROUP_NAME	The name of the target business group for the data.
DO_REQUEST_ID	The request ID for the Data Output module, typically for Data Pump.
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
SECURITY_GROUP_ID
MODULE_ID	The current module processing this batch, it is a Foreign Key to HR_DU_MODULES.MODULE_ID
BATCH_ID	Foreign Key to HR_PUMP_BATCH_HEADERS.BATCH_ID
SOURCE	Filename of the source object
STATUS	Current status of the currently active module. This value is a lookup code of the lookup type HR_DU_ STATUS and is defined in the table FND_LOOKUP_TYPES, FND_LOOKUP_TYPES_TL and FND_LOOKUP_VALUES.
DATA_INPUT_STATUS	Current status of the data input process. This value is a lookup code of the lookup type HR_DU_STATUS and is defined in the table FND_LOOKUP_TYPES, FND_LOOKUP_TYPES_TL and FND_LOOKUP_VALUES
DATA_REFERENCE_COMPLETE	Indication of if the data reference process has been successfully completed and no further DP modules have been run.

Human Resources - HR_DU_UPLOAD_LINES	This table holds the details for each item to be uploaded with an item spanning one or more rows
Column Name	Descritpion
UPLOAD_LINE_ID	System generated primary key
PVAL005	The column data from the source data
PVAL095	The column data from the source data
PVAL096	The column data from the source data
PVAL097	The column data from the source data
PVAL098	The column data from the source data
PVAL099	The column data from the source data
PVAL100	The column data from the source data
PVAL101	The column data from the source data
PVAL102	The column data from the source data
PVAL103	The column data from the source data
PVAL104	The column data from the source data
PVAL006	The column data from the source data
PVAL105	The column data from the source data
PVAL106	The column data from the source data
PVAL107	The column data from the source data
PVAL108	The column data from the source data
PVAL109	The column data from the source data
PVAL110	The column data from the source data
PVAL111	The column data from the source data
PVAL112	The column data from the source data
PVAL113	The column data from the source data
PVAL114	The column data from the source data
PVAL007	The column data from the source data
PVAL115	The column data from the source data
PVAL116	The column data from the source data
PVAL117	The column data from the source data
PVAL118	The column data from the source data
PVAL119	The column data from the source data
PVAL120	The column data from the source data
PVAL121	The column data from the source data
PVAL122	The column data from the source data
PVAL123	The column data from the source data
PVAL124	The column data from the source data
PVAL008	The column data from the source data
PVAL125	The column data from the source data
PVAL126	The column data from the source data
PVAL127	The column data from the source data
PVAL128	The column data from the source data
PVAL129	The column data from the source data
PVAL130	The column data from the source data
PVAL131	The column data from the source data
PVAL132	The column data from the source data
PVAL133	The column data from the source data
PVAL134	The column data from the source data
PVAL009	The column data from the source data
PVAL135	The column data from the source data
PVAL136	The column data from the source data
PVAL137	The column data from the source data
PVAL138	The column data from the source data
PVAL139	The column data from the source data
PVAL140	The column data from the source data
PVAL141	The column data from the source data
PVAL142	The column data from the source data
PVAL143	The column data from the source data
PVAL144	The column data from the source data
PVAL010	The column data from the source data
PVAL145	The column data from the source data
PVAL146	The column data from the source data
PVAL147	The column data from the source data
PVAL148	The column data from the source data
PVAL149	The column data from the source data
PVAL150	The column data from the source data
PVAL151	The column data from the source data
PVAL152	The column data from the source data
PVAL153	The column data from the source data
PVAL154	The column data from the source data
PVAL011	The column data from the source data
PVAL155	The column data from the source data
PVAL156	The column data from the source data
PVAL157	The column data from the source data
PVAL158	The column data from the source data
PVAL159	The column data from the source data
PVAL160	The column data from the source data
PVAL161	The column data from the source data
PVAL162	The column data from the source data
PVAL163	The column data from the source data
PVAL164	The column data from the source data
PVAL012	The column data from the source data
PVAL165	The column data from the source data
PVAL166	The column data from the source data
PVAL167	The column data from the source data
PVAL168	The column data from the source data
PVAL169	The column data from the source data
PVAL170	The column data from the source data
PVAL171	The column data from the source data
PVAL172	The column data from the source data
PVAL173	The column data from the source data
PVAL174	The column data from the source data
PVAL013	The column data from the source data
PVAL175	The column data from the source data
PVAL176	The column data from the source data
PVAL177	The column data from the source data
PVAL178	The column data from the source data
PVAL179	The column data from the source data
PVAL180	The column data from the source data
PVAL181	The column data from the source data
PVAL182	The column data from the source data
PVAL183	The column data from the source data
PVAL184	The column data from the source data
PVAL014	The column data from the source data
PVAL185	The column data from the source data
PVAL186	The column data from the source data
PVAL187	The column data from the source data
PVAL188	The column data from the source data
PVAL189	The column data from the source data
PVAL190	The column data from the source data
PVAL191	The column data from the source data
PVAL192	The column data from the source data
PVAL193	The column data from the source data
PVAL194	The column data from the source data
UPLOAD_HEADER_ID	Foreign Key to HR_DU_UPLOAD_HEADERS.UPLOAD_HEADER_ID
PVAL015	The column data from the source data
PVAL195	The column data from the source data
PVAL196	The column data from the source data
PVAL197	The column data from the source data
PVAL198	The column data from the source data
PVAL199	The column data from the source data
PVAL200	The column data from the source data
PVAL201	The column data from the source data
PVAL202	The column data from the source data
PVAL203	The column data from the source data
PVAL204	The column data from the source data
PVAL016	The column data from the source data
PVAL205	The column data from the source data
PVAL206	The column data from the source data
PVAL207	The column data from the source data
PVAL208	The column data from the source data
PVAL209	The column data from the source data
PVAL210	The column data from the source data
PVAL211	The column data from the source data
PVAL212	The column data from the source data
PVAL213	The column data from the source data
PVAL214	The column data from the source data
PVAL017	The column data from the source data
PVAL215	The column data from the source data
PVAL216	The column data from the source data
PVAL217	The column data from the source data
PVAL218	The column data from the source data
PVAL219	The column data from the source data
PVAL220	The column data from the source data
PVAL221	The column data from the source data
PVAL222	The column data from the source data
PVAL223	The column data from the source data
PVAL224	The column data from the source data
PVAL018	The column data from the source data
PVAL225	The column data from the source data
PVAL226	The column data from the source data
PVAL227	The column data from the source data
PVAL228	The column data from the source data
PVAL229	The column data from the source data
PVAL230	The column data from the source data
LINE_TYPE	The type of data held in the row. This value is a lookup code of the lookup type HR_DU_LINE_TYPE and is defined in the table FND_LOOKUP_TYPES, FND_LOOKUP_TYPES_TL and FND_LOOKUP_VALUES
DI_LINE_NUMBER	Line number from the input file
LAST_UPDATE_DATE	Standard WHO column
PVAL019	The column data from the source data
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
PVAL020	The column data from the source data
SECURITY_GROUP_ID
PVAL021	The column data from the source data
PVAL022	The column data from the source data
PVAL023	The column data from the source data
PVAL024	The column data from the source data
BATCH_LINE_ID	Foreign Key to HR_PUMP_BATCH_LINES.BATCH_LINE_ID
PVAL025	The column data from the source data
PVAL026	The column data from the source data
PVAL027	The column data from the source data
PVAL028	The column data from the source data
PVAL029	The column data from the source data
PVAL030	The column data from the source data
PVAL031	The column data from the source data
PVAL032	The column data from the source data
PVAL033	The column data from the source data
PVAL034	The column data from the source data
STATUS	Current status of the batch line. This value is a lookup code of the lookup type HR_DU_STATUS and is defined in the table FND_LOOKUP_TYPES, FND_LOOKUP_TYPES_TL and FND_LOOKUP_VALUES.
PVAL035	The column data from the source data
PVAL036	The column data from the source data
PVAL037	The column data from the source data
PVAL038	The column data from the source data
PVAL039	The column data from the source data
ORIGINAL_UPLOAD_HEADER_ID	This field holds the value of its original upload header id if there were two headers with the same API value, in the same upload.
PVAL040	The column data from the source data
PVAL041	The column data from the source data
PVAL042	The column data from the source data
PVAL043	The column data from the source data
PVAL044	The column data from the source data
REFERENCE_TYPE	The type of referencing used for this row. Parent Child referenced rows will have a reference pointing at the child row with Child Parent references pointing from the child to the parent
PVAL045	The column data from the source data
PVAL046	The column data from the source data
PVAL047	The column data from the source data
PVAL048	The column data from the source data
PVAL049	The column data from the source data
PVAL050	The column data from the source data
PVAL051	The column data from the source data
PVAL052	The column data from the source data
PVAL053	The column data from the source data
PVAL054	The column data from the source data
PVAL001	The column data from the source data
PVAL055	The column data from the source data
PVAL056	The column data from the source data
PVAL057	The column data from the source data
PVAL058	The column data from the source data
PVAL059	The column data from the source data
PVAL060	The column data from the source data
PVAL061	The column data from the source data
PVAL062	The column data from the source data
PVAL063	The column data from the source data
PVAL064	The column data from the source data
PVAL002	The column data from the source data
PVAL065	The column data from the source data
PVAL066	The column data from the source data
PVAL067	The column data from the source data
PVAL068	The column data from the source data
PVAL069	The column data from the source data
PVAL070	The column data from the source data
PVAL071	The column data from the source data
PVAL072	The column data from the source data
PVAL073	The column data from the source data
PVAL074	The column data from the source data
PVAL003	The column data from the source data
PVAL075	The column data from the source data
PVAL076	The column data from the source data
PVAL077	The column data from the source data
PVAL078	The column data from the source data
PVAL079	The column data from the source data
PVAL080	The column data from the source data
PVAL081	The column data from the source data
PVAL082	The column data from the source data
PVAL083	The column data from the source data
PVAL084	The column data from the source data
PVAL004	The column data from the source data
PVAL085	The column data from the source data
PVAL086	The column data from the source data
PVAL087	The column data from the source data
PVAL088	The column data from the source data
PVAL089	The column data from the source data
PVAL090	The column data from the source data
PVAL091	The column data from the source data
PVAL092	The column data from the source data
PVAL093	The column data from the source data
PVAL094	The column data from the source data

Human Resources - HR_DU_UPLOAD_HEADERS	This table holds the details for each API to be uploaded.
Column Name	Descritpion
UPLOAD_HEADER_ID	System generated primary key
SECURITY_GROUP_ID
UPLOAD_ID	Foreign Key to HR_DU_UPLOADS.UPLOAD_ID
API_MODULE_ID	Foreign Key to HR_API_MODULES.API_MODULE_ID
STATUS	Current status of the batch header. This value is a lookup code of the lookup type HR_DU_STATUS and is defined in the table FND_LOOKUP_TYPES, FND_LOOKUP_TYPES_TL and FND_LOOKUP_VALUES.
SOURCE_REFERENCE_TYPE	The source type of referencing used for this batch. Parent Child referenced rows will have a reference pointing at the child row with Child Parent references pointing from the child to the parent.
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_DU_MODULES	This table holds the details about each module which can be used for either input, process or output with in the data Uploader.
Column Name	Descritpion
MODULE_ID	System generated primary key
LAST_UPDATE_LOGIN	Standard WHO column
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
SECURITY_GROUP_ID
MODULE_NAME	The name of the module
MODULE_TYPE	The type of processing that the module will perform.
MODULE_VALIDATE	The package procedure to be called to perform the required processing to validate that the module may proceed.
MODULE_ROLLBACK	The package procedure to be called to perform the required processing to rollback the actions of this module.
MODULE_PROCESS	The package procedure to be called to perform the required processing for this module.
DESCRIPTION	The description of what actions the module performs
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column

Human Resources - HR_EFC_ACTIONS	Contains one row for each time the EFC conversion process or delete _EFC table data process is run.
Column Name	Descritpion
EFC_ACTION_ID	Surrogate Primary Key.
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.
SECURITY_GROUP_ID
EFC_ACTION_TYPE	Based on the lookup type 'EFC_ACTION_TYPE'.
EFC_ACTION_STATUS	Based on the lookup type 'EFC_ACTION_STATUS'.
EFC_PROGRESS_STATUS	Based on the lookup type 'EFC_PROGRESS_STATUS'.
BUSINESS_GROUP_ID	ID of the business group which was modified by this conversion process.
ACTION_SEQUENCE	Order of the EFC process actions against this business group.
START_DATE	Date action was created. Time component will be populated. Value set from sysdate.
FINISH_DATE	Indicates when all the action steps were successfully completed.
MATCHING_EFC_ACTION_ID	Foreign key to HR_EFC_ACTIONS. Link between a delete action and the original conversion

Human Resources - HR_EFC_PROCESS_COMPONENTS	Holds one row for each processing script in each conversion processing run.
Column Name	Descritpion
EFC_PROCESS_COMPONENT_ID	Surrogate Primary Key.
LAST_UPDATE_LOGIN	Standard Who Column.
CREATED_BY	Standard Who Column.
CREATION_DATE	Standard Who Column.
SECURITY_GROUP_ID
EFC_ACTION_ID	Foreign Key to HR_EFC_ACTIONS.
PROCESS_COMPONENT_NAME	Name of the SQL script which ran this this component.
TABLE_NAME	Name of the table which has been modified by this process component.
TOTAL_WORKERS	Total number of worker processes which were executing different instances of this process component.
STEP	Indicate the main process step this process component is being executed in.
SUB_STEP	Holds the sub step number this process component was ran in.
LAST_UPDATE_DATE	Standard Who Column.
LAST_UPDATED_BY	Standard Who Column.

Human Resources - HR_EFC_ROUNDING_ERRORS	Holds one row for each time a rounding error adjustment has been made.
Column Name	Descritpion
EFC_ROUNDING_ERROR_ID	Surrogate Primary Key.
CREATED_BY	Standard Who Column.
CREATION_DATE	Standard Who Column.
SECURITY_GROUP_ID
EFC_ACTION_ID	Foreign Key to HR_EFC_ACTIONS.
SOURCE_ID	The value of the surrogate primary key ID value for the source table.
SOURCE_TABLE	Name of the table which has been adjusted.
SOURCE_COLUMN	Name of the column in the SOURCE_TABLE which has been adjusted.
ROUNDING_AMOUNT	The difference between the pre- and post- value on the source table column.
LAST_UPDATE_DATE	Standard Who Column.
LAST_UPDATED_BY	Standard Who Column.
LAST_UPDATE_LOGIN	Standard Who Column.

Human Resources - HR_EFC_WORKER_AUDITS	Holds one row for each HR_EFC_WORKER row per currency code processed for update scripts only.
Column Name	Descritpion
EFC_WORKER_AUDIT_ID	Surrogate Primary Key.
CREATION_DATE	Standard Who Column.
SECURITY_GROUP_ID
EFC_WORKER_ID	Foreign Key to HR_EFC_WORKERS.
COLUMN_NAME	Name of the column in the table mentioned in HR_EFC_PROCESS_COMPONENTS(TABLE_NAME).
CURRENCY_CODE	CURRENCY_CODE which has been processed.
NUMBER_OF_ROWS	The number of rows in the product table which have been handled by this worker instance.
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_EFC_WORKERS	Holds one row for each parallel worker instance of a processing component.
Column Name	Descritpion
EFC_WORKER_ID	Surrogate Primary Key.
PK5	The fifth column in the primary key of the last row which was successfully modified and committed.
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.
SPID	Populated from v$process value when sql_trace is enabled and the WORKER_PROCESS_STATUS is not 'C'.
SECURITY_GROUP_ID
EFC_PROCESS_COMPONENT_ID	Foreign Key to HR_EFC_PROCESS_COMPONENTS.
EFC_ACTION_ID	Foreign Key to HR_EFC_ACTIONS.
WORKER_NUMBER	Worker process Number.
WORKER_PROCESS_STATUS	Indicates how far this worker instance has reached in it's execution.
PK1	The first column in the primary key of the last row which was successfully modified and committed.
PK2	The second column in the primary key of the last row which was successfully modified and committed.
PK3	The third column in the primary key of the last row which was successfully modified and committed.
PK4	The forth column in the primary key of the last row which was successfully modified and committed.

Human Resources - AME_APPROVALS_HISTORY	To be Updated
Column Name	Descritpion
TRANSACTION_ID
APPLICATION_ID
APPROVAL_TYPE_ID
GROUP_OR_CHAIN_ID
OCCURRENCE
APPROVAL_STATUS
ROW_TIMESTAMP
USER_ID
PERSON_ID
SECURITY_GROUP_ID
NAME
APPROVER_CATEGORY
ITEM_CLASS
ITEM_ID
ACTION_TYPE_ID

Human Resources - AME_TEMP_HANDLER_STATES	To be Updated
Column Name	Descritpion
HANDLER_NAME
ROW_TIMESTAMP
APPLICATION_ID
PARAMETER
STATE
SECURITY_GROUP_ID

Human Resources - AME_TEST_TRANS_ATT_VALUES	To be Updated
Column Name	Descritpion
APPLICATION_ID
ATTRIBUTE_VALUE_2
ATTRIBUTE_VALUE_3
SECURITY_GROUP_ID
ITEM_ID
ITEM_CLASS_ID
TRANSACTION_ID
ROW_TIMESTAMP
ATTRIBUTE_ID
ATTRIBUTE_NAME
ATTRIBUTE_TYPE
IS_MANDATORY
LINE_ITEM_ID
ATTRIBUTE_VALUE_1

Human Resources - AME_TEMP_TRANSACTIONS	To be Updated
Column Name	Descritpion
APPLICATION_ID
TRANSACTION_ID
ROW_TIMESTAMP
SECURITY_GROUP_ID

Human Resources - AME_TEMP_DELETIONS	To be Updated
Column Name	Descritpion
TRANSACTION_ID
APPLICATION_ID
APPROVAL_TYPE_ID
GROUP_OR_CHAIN_ID
OCCURRENCE
USER_ID
PERSON_ID
SECURITY_GROUP_ID
NAME
APPROVER_CATEGORY
ITEM_CLASS
ITEM_ID
ACTION_TYPE_ID

Human Resources - HR_DE_ORGANIZATION_LINKS	Holds extra information for Organizations links with External Orgs
Column Name	Descritpion
PARENT_ORGANIZATION_ID	Organization id of the parent in the relationship
ORG_LINK_INFORMATION15	Developer descriptive flex column.
ORG_LINK_INFORMATION16	Developer descriptive flex column.
ORG_LINK_INFORMATION17	Developer descriptive flex column.
ORG_LINK_INFORMATION18	Developer descriptive flex column.
ORG_LINK_INFORMATION19	Developer descriptive flex column.
ORG_LINK_INFORMATION20	Developer descriptive flex column.
ORG_LINK_INFORMATION21	Developer descriptive flex column.
ORG_LINK_INFORMATION22	Developer descriptive flex column.
ORG_LINK_INFORMATION23	Developer descriptive flex column.
ORG_LINK_INFORMATION24	Developer descriptive flex column.
CHILD_ORGANIZATION_ID	Organization id of the Child in the relationship
ORG_LINK_INFORMATION25	Developer descriptive flex column.
ORG_LINK_INFORMATION26	Developer descriptive flex column.
ORG_LINK_INFORMATION27	Developer descriptive flex column.
ORG_LINK_INFORMATION28	Developer descriptive flex column.
ORG_LINK_INFORMATION29	Developer descriptive flex column.
ORG_LINK_INFORMATION30	Developer descriptive flex column.
BUSINESS_GROUP_ID	Business Group ID
ATTRIBUTE_CATEGORY	Determines the type of Info held in the Descriptive FF segments below
ATTRIBUTE1	Descriptive Flex column
ATTRIBUTE2	Descriptive Flex column
ATTRIBUTE3	Descriptive Flex column
ATTRIBUTE4	Descriptive Flex column
ATTRIBUTE5	Descriptive Flex column
ATTRIBUTE6	Descriptive Flex column
ATTRIBUTE7	Descriptive Flex column
ATTRIBUTE8	Descriptive Flex column
ATTRIBUTE9	Descriptive Flex column
ATTRIBUTE10	Descriptive Flex column
ATTRIBUTE11	Descriptive Flex column
ATTRIBUTE12	Descriptive Flex column
ATTRIBUTE13	Descriptive Flex column
ATTRIBUTE14	Descriptive Flex column
ATTRIBUTE15	Descriptive Flex column
ATTRIBUTE16	Descriptive Flex column
ATTRIBUTE17	Descriptive Flex column
ATTRIBUTE18	Descriptive Flex column
ATTRIBUTE19	Descriptive Flex column
ATTRIBUTE20	Descriptive Flex column
ORG_LINK_TYPE	Holds the Type of Link that the Organizations have
ATTRIBUTE21	Descriptive Flex column
ATTRIBUTE22	Descriptive Flex column
ATTRIBUTE23	Descriptive Flex column
ATTRIBUTE24	Descriptive Flex column
ORG_LINK_INFORMATION_CATEGORY	Determines the type of Info held in the segments below
ATTRIBUTE25	Descriptive Flex column
ATTRIBUTE26	Descriptive Flex column
ORG_LINK_INFORMATION1	Developer descriptive flex column.
ATTRIBUTE27	Descriptive Flex column
ATTRIBUTE28	Descriptive Flex column
ATTRIBUTE29	Descriptive Flex column
ATTRIBUTE30	Descriptive Flex 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	Object Version Number
ORG_LINK_INFORMATION2	Developer descriptive flex column.
ORG_LINK_INFORMATION3	Developer descriptive flex column.
ORG_LINK_INFORMATION4	Developer descriptive flex column.
ORGANIZATION_LINK_ID	System-generated primary key column.
ORG_LINK_INFORMATION5	Developer descriptive flex column.
ORG_LINK_INFORMATION6	Developer descriptive flex column.
ORG_LINK_INFORMATION7	Developer descriptive flex column.
ORG_LINK_INFORMATION8	Developer descriptive flex column.
ORG_LINK_INFORMATION9	Developer descriptive flex column.
ORG_LINK_INFORMATION10	Developer descriptive flex column.
ORG_LINK_INFORMATION11	Developer descriptive flex column.
ORG_LINK_INFORMATION12	Developer descriptive flex column.
ORG_LINK_INFORMATION13	Developer descriptive flex column.
ORG_LINK_INFORMATION14	Developer descriptive flex column.

Human Resources - HR_DE_SOC_INS_CONTR_LVLS_F	Holds German Social Insurance Contibution data
Column Name	Descritpion
SOC_INS_CONTR_LVLS_ID	System-generated primary key column.
EFFECTIVE_END_DATE	Effective end date
ATTRIBUTE11
ATTRIBUTE10
FLAT_TAX_LIMIT_PER_MONTH
FLAT_TAX_LIMIT_PER_YEAR
MIN_INCREASED_CONTRIBUTION
ATTRIBUTE12
ATTRIBUTE14
MAX_INCREASED_CONTRIBUTION
ATTRIBUTE16
MONTH1
ATTRIBUTE1
ATTRIBUTE18
MONTH1_MIN_CONTRIBUTION
ATTRIBUTE20
MONTH1_MAX_CONTRIBUTION
ATTRIBUTE15
ATTRIBUTE22
MONTH2
ATTRIBUTE24
MONTH2_MIN_CONTRIBUTION
ATTRIBUTE13
ATTRIBUTE26
MONTH2_MAX_CONTRIBUTION
EMPLOYEE_CONTRIBUTION
CONTRIBUTION_LEVEL_TYPE
ORGANIZATION_ID	Organization id
ATTRIBUTE17
ATTRIBUTE29
ATTRIBUTE30
ATTRIBUTE21
ATTRIBUTE19
ATTRIBUTE23
ATTRIBUTE27
NORMAL_PERCENTAGE	Normal Percentage
ATTRIBUTE25
ATTRIBUTE5
ATTRIBUTE3
NORMAL_AMOUNT	Normal Amount
ATTRIBUTE9
INCREASED_PERCENTAGE	Increased Percentage
OBJECT_VERSION_NUMBER	Object version number
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ATTRIBUTE_CATEGORY
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
INCREASED_AMOUNT	Increased Amount
ATTRIBUTE7
ATTRIBUTE2
REDUCED_PERCENTAGE	Reduced Percentage
ATTRIBUTE4
REDUCED_AMOUNT	Reduced Amount
ATTRIBUTE28
ATTRIBUTE6
EFFECTIVE_START_DATE	Effective start date
ATTRIBUTE8

Human Resources - HR_DE_LIABILITY_PREMIUMS_F	Holds Liability Insurance Providers Premium rates for the Organization
Column Name	Descritpion
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_DATE	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
ORGANIZATION_LINK_ID	Foreign key maintained at the relationship level of Internal and external orgs
EFFECTIVE_START_DATE	Effective Start date
EFFECTIVE_END_DATE	Effective End date
STD_PERCENTAGE	Standard Percentage agreed upon
CALCULATION_METHOD	Calculation method of Standard Working hours
LIABILITY_PREMIUMS_ID	System-generated primary key column.
STD_WORKING_HOURS_PER_YEAR	Standard Working hours per year
MAX_REMUNERATION	Maximum remuneration to be given to an employee
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6

Human Resources - HR_H2PI_DATA_FEED_HIST	This table stores information about date feed history for Oracle HR to Oracle Payroll Interface (H2PI).
Column Name	Descritpion
START_DATE	Start date for data transfer.
CREATION_DATE	Standard who column
OBJECT_VERSION_NUMBER	Object version number.
REQUEST_ID	Concurrent request id.
PROGRAM_APPLICATION_ID	Program application id.
PROGRAM_ID	Program id.
PROGRAM_UPDATE_DATE	Program update date.
END_DATE	End date for data transfer.
SEQUENCE_NUMBER	System generated primary key column.
BUSINESS_GROUP_ID	Business group id.
CLIENT_ID	Client id
BUSINESS_GROUP_NAME	Business group name.
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_H2PI_ADDRESSES	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to addresses while data upload is in progress.
Column Name	Descritpion
LAST_UPD_DATE	Last Update date
ADDRESS_LINE2	The Second line of address
ADDRESS_LINE3	The third line of address
TOWN_OR_CITY	Town or city name
REGION_1	Primary region in which address is located
REGION_2	Sub region of region 1 in which address is located
REGION_3	Sub region of region 2 in which address is located
POSTAL_CODE	National code to identify addresses in a specific country
COUNTRY	Country
TELEPHONE_NUMBER_1	Telehone number of the address
TELEPHONE_NUMBER_2	Second telephone number of the address
BUSINESS_GROUP_ID	Business group ID
TELEPHONE_NUMBER_3	Third telephone number of the address
ADD_INFORMATION13	Address information column
ADD_INFORMATION14	Address information column
ADD_INFORMATION15	Address information column
ADD_INFORMATION16	Address information column
CLIENT_ID	Client id
ADD_INFORMATION17	Address information column
ADD_INFORMATION18	Address information column
ADD_INFORMATION19	Address information column
ADD_INFORMATION20	Address information column
ADDR_ATTRIBUTE_CATEGORY	Descriptive flexfield column
ADDRESS_ID	System generated primary key column
ADDR_ATTRIBUTE1	Descriptive flexfield column
ADDR_ATTRIBUTE2	Descriptive flexfield column
ADDR_ATTRIBUTE3	Descriptive flexfield column
ADDR_ATTRIBUTE4	Descriptive flexfield column
ADDR_ATTRIBUTE5	Descriptive flexfield column
ADDR_ATTRIBUTE6	Descriptive flexfield column
ADDR_ATTRIBUTE7	Descriptive flexfield column
ADDR_ATTRIBUTE8	Descriptive flexfield column
ADDR_ATTRIBUTE9	Descriptive flexfield column
ADDR_ATTRIBUTE10	Descriptive flexfield column
PERSON_ID	Person ID
ADDR_ATTRIBUTE11	Descriptive flexfield column
ADDR_ATTRIBUTE12	Descriptive flexfield column
ADDR_ATTRIBUTE13	Descriptive flexfield column
ADDR_ATTRIBUTE14	Descriptive flexfield column
ADDR_ATTRIBUTE15	Descriptive flexfield column
ADDR_ATTRIBUTE16	Descriptive flexfield column
ADDR_ATTRIBUTE17	Descriptive flexfield column
ADDR_ATTRIBUTE18	Descriptive flexfield column
ADDR_ATTRIBUTE19	Descriptive flexfield column
ADDR_ATTRIBUTE20	Descriptive flexfield column
STYLE	Address style
STATUS	Status of record for upload
DATE_FROM	Start date of address
DATE_TO	End date of address
ADDRESS_TYPE	Address type, for example, home,business, weekend
ADDRESS_LINE1	The first line of address

Human Resources - HR_H2PI_CITY_TAX_RULES	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to us employees city tax rules while data upload is in progress.
Column Name	Descritpion
PERSON_ID	Person ID
ADDITIONAL_WA_RATE	Additional WA rate
FILING_STATUS_CODE	Tax filing status code
JURISDICTION_CODE	Full jurisdiction code
LIT_ADDITIONAL_TAX	LIT additional code
LIT_OVERRIDE_AMOUNT	LIT override amount
LIT_OVERRIDE_RATE	LIT override rate
WITHHOLDING_ALLOWANCES	Withholding allowance
LIT_EXEMPT	LIT exempt
SD_EXEMPT	SD exempt
HT_EXEMPT	HT exempt
EMP_CITY_TAX_RULE_ID	System generated primary key column
SCHOOL_DISTRICT_CODE	School district code
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
COUNTY_CODE	County code
CITY_CODE	City code
BUSINESS_GROUP_ID	Business group ID
CLIENT_ID	Client id

Human Resources - HR_H2PI_PAY_BASES
Column Name	Descritpion
LAST_UPD_DATE	Last update date
PAY_BASIS_ID	System generated primary key column
BUSINESS_GROUP_ID	Business group ID
CLIENT_ID	Client id
NAME	Pay basis name
PAY_BASIS	Pay basis
STATUS	Status of record for upload

Human Resources - HR_H2PI_PAYROLLS
Column Name	Descritpion
LAST_UPD_DATE	Last update date
STATUS	Status of record for upload
BUSINESS_GROUP_ID	Business group Id
CLIENT_ID	Client id
PAYROLL_ID	System generated primary key column
PAYROLL_NAME	Payroll name
FIRST_PERIOD_END_DATE	End date of first payroll period
NUMBER_OF_YEARS	Number of years for payroll
PERIOD_TYPE	Period type
EFFECTIVE_START_DATE	Effective start date for the payroll
EFFECTIVE_END_DATE	Effective end date for the payroll

Human Resources - HR_H2PI_PAYMENT_METHODS
Column Name	Descritpion
LAST_UPD_DATE	Last update date
PERCENTAGE	Percentage
PRIORITY	Priority
ATTRIBUTE_CATEGORY	Descriptive flexfield 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
BUSINESS_GROUP_ID	Business group ID
ATTRIBUTE8	Descriptive flexfield column
ATTRIBUTE9	Descriptive flexfield column
ATTRIBUTE10	Descriptive flexfield column
ATTRIBUTE11	Descriptive flexfield column
ATTRIBUTE12	Descriptive flexfield column
CLIENT_ID	Client id
ATTRIBUTE13	Descriptive flexfield column
ATTRIBUTE14	Descriptive flexfield column
ATTRIBUTE15	Descriptive flexfield column
ATTRIBUTE16	Descriptive flexfield column
ATTRIBUTE17	Descriptive flexfield column
PERSONAL_PAYMENT_METHOD_ID	System generated primary key column
ATTRIBUTE18	Descriptive flexfield column
ATTRIBUTE19	Descriptive flexfield column
ATTRIBUTE20	Descriptive flexfield column
PAYEE_ID	Payee ID
PAYEE_TYPE	Payee type
TERRITORY_CODE	Territory code
PRENOTE_DATE	Prenote date
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
ASSIGNMENT_ID	Assignment ID
SEGMENT7	Key flexfield segment column
SEGMENT8	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
PERSON_ID	Person ID
SEGMENT17	Key flexfield segment column
SEGMENT18	Key flexfield segment 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
EFFECTIVE_START_DATE	Effective start date of personal payment method
SEGMENT27	Key flexfield segment column
SEGMENT28	Key flexfield segment column
SEGMENT29	Key flexfield segment column
SEGMENT30	Key flexfield segment column
STATUS	Status of record for upload
EFFECTIVE_END_DATE	Effective end date personal payment method
ORG_PAYMENT_METHOD_ID	Organization payment method ID
AMOUNT	Amount

Human Resources - HR_H2PI_PATCH_STATUS
Column Name	Descritpion
PATCH_NUMBER	Patch number
PATCH_NAME	Patch name
STATUS	Status of record for upload
APPLIED_DATE	Date on which patch was applied
BUSINESS_GROUP_ID	Business group ID
CLIENT_ID	Client id

Human Resources - HR_H2PI_ORG_PAYMENT_METHODS
Column Name	Descritpion
LAST_UPD_DATE	Last update date
TERRITORY_CODE	Territory code
STATUS	Status of record for upload
ORG_PAYMENT_METHOD_ID	System generated primary key column
BUSINESS_GROUP_ID	Business group ID
CLIENT_ID	Client id
ORG_PAYMENT_METHOD_NAME	Organization payment method name
EFFECTIVE_START_DATE	Effective start date of organization payment method
EFFECTIVE_END_DATE	Effective end date of organization payment method
CURRENCY_CODE	Currency code for payment
EXTERNAL_ACCOUNT_ID	External account ID
PAYMENT_TYPE_NAME	Payment type name

Human Resources - HR_H2PI_LOCATIONS	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to locations while data upload is in progress.
Column Name	Descritpion
LAST_UPD_DATE	Last update date
COUNTRY	Country
POSTAL_CODE	Postal code
REGION_1	Region 1
REGION_2	Region 2
REGION_3	Region 3
STYLE	Address Style
INACTIVE_DATE	Inactive date
TELEPHONE_NUMBER_1	Primary phone number of the location
TELEPHONE_NUMBER_2	Another phone number of the location
TELEPHONE_NUMBER_3	Another phone number of the location
BUSINESS_GROUP_ID	Business group ID
LOC_INFORMATION13	Developer descriptive flexfield column
LOC_INFORMATION14	Developer descriptive flexfield column
LOC_INFORMATION15	Developer descriptive flexfield column
LOC_INFORMATION16	Developer descriptive flexfield column
LOC_INFORMATION17	Developer descriptive flexfield column
CLIENT_ID	Client id
LOC_INFORMATION18	Developer descriptive flexfield column
LOC_INFORMATION19	Developer descriptive flexfield column
LOC_INFORMATION20	Developer descriptive flexfield column
ATTRIBUTE_CATEGORY	Developer descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield column
LOCATION_ID	Location ID
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
LOCATION_CODE	Location code
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
STATUS	Status of record for loading
DESCRIPTION	Location description
ADDRESS_LINE_1	Address line 1
ADDRESS_LINE_2	Address line 2
ADDRESS_LINE_3	Address line 3
TOWN_OR_CITY	Nam of town or city

Human Resources - HR_H2PI_INPUT_VALUES
Column Name	Descritpion
LAST_UPD_DATE
DEFAULT_VALUE
LOOKUP_TYPE
STATUS
BUSINESS_GROUP_ID
CLIENT_ID	Client id
ELEMENT_TYPE_ID
LEGISLATION_CODE	Legislation Code
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
INPUT_VALUE_ID
NAME
UOM
MANDATORY_FLAG

Human Resources - HR_H2PI_HR_ORGANIZATIONS
Column Name	Descritpion
LAST_UPD_DATE	Last update date
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
ATTRIBUTE8	Descriptive flexfield column
ATTRIBUTE9	Descriptive flexfield column
ATTRIBUTE10	Descriptive flexfield column
BUSINESS_GROUP_ID	Business group ID
ATTRIBUTE11	Descriptive flexfield column
ATTRIBUTE12	Descriptive flexfield column
ATTRIBUTE13	Descriptive flexfield column
ATTRIBUTE14	Descriptive flexfield column
ATTRIBUTE15	Descriptive flexfield column
CLIENT_ID	Client id
ATTRIBUTE16	Descriptive flexfield column
ATTRIBUTE17	Descriptive flexfield column
ATTRIBUTE18	Descriptive flexfield column
ATTRIBUTE19	Descriptive flexfield column
ATTRIBUTE20	Descriptive flexfield column
ORGANIZATION_ID	Organization ID
STATUS	Status of record for upload
NAME	Organization name
DATE_FROM	Start date of organization
DATE_TO	End date of organization
LOCATION_ID	Location ID
INTERNAL_EXTERNAL_FLAG	As an employment unit within the group
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column

Human Resources - HR_H2PI_ORGANIZATION_INFO	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to organization info while data upload is in progress.
Column Name	Descritpion
LAST_UPD_DATE	Last update date
ORG_INFORMATION5	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
ORG_INFORMATION10	Developer descriptive flexfield column
ORG_INFORMATION11	Developer descriptive flexfield column
ORG_INFORMATION12	Developer descriptive flexfield column
ORG_INFORMATION13	Developer descriptive flexfield column
ORG_INFORMATION14	Developer descriptive flexfield column
BUSINESS_GROUP_ID	Business group ID
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
CLIENT_ID	Client id
ORG_INFORMATION20	Developer descriptive flexfield column
STATUS	Status of record for upload
ORG_INFORMATION_ID	Organization information ID
ORGANIZATION_ID	Organization ID
ORG_INFORMATION_CONTEXT	Organization information context
ORG_INFORMATION1	Developer descriptive flexfield column
ORG_INFORMATION2	Developer descriptive flexfield column
ORG_INFORMATION3	Developer descriptive flexfield column
ORG_INFORMATION4	Developer descriptive flexfield column

Human Resources - HR_H2PI_ELEMENT_ENTRY_VALUES
Column Name	Descritpion
LAST_UPD_DATE	Last update date
BUSINESS_GROUP_ID	Business group id
CLIENT_ID	Client id
ELEMENT_ENTRY_ID	Element entry id
PERSON_ID	Person ID
EFFECTIVE_START_DATE	Effective start date
EFFECTIVE_END_DATE	Effective end date
INPUT_VALUE_ID	Input value id
SCREEN_ENTRY_VALUE	Screen entry value
STATUS	Status of record for upload

Human Resources - HR_H2PI_MESSAGE_LINES	This table stores information about all the messages for Oracle HR to Oracle Payroll Interface (H2PI).
Column Name	Descritpion
TO_BUSINESS_GROUP_ID	To Business group id.
REQUEST_ID	Concurrent program Request ID
FROM_ID	From id
TABLE_NAME	Table name
MESSAGE_LEVEL	Message level
MESSAGE_NAME_ENCODED	Message name encoded
API_MODULE_ID	API module id

Human Resources - HR_H2PI_ID_MAPPING	This table stores information about ID mapping for Oracle HR to Oracle Payroll Interface (H2PI).
Column Name	Descritpion
FROM_ID	From id- id from HR side.
CREATION_DATE	Standard who column.
TO_ID	To id- id from Payroll side.
TABLE_NAME	Table name.
TO_BUSINESS_GROUP_ID	Business group id for Payroll side.
ID_COLUMN_NAME	Name of the column corresponding to the mapping.
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_H2PI_ORGANIZATION_CLASS
Column Name	Descritpion
LAST_UPD_DATE	Last update date
BUSINESS_GROUP_ID	Business group ID
CLIENT_ID	Client id
ORG_INFORMATION_ID	System generated primary key column
ORGANIZATION_ID	Organization ID
ORG_INFORMATION_CONTEXT	Organization information context
ORG_INFORMATION1	Organization information1
ORG_INFORMATION2	Organization information2
STATUS	Status of record for upload

Human Resources - HR_H2PI_FEDERAL_TAX_RULES
Column Name	Descritpion
PERSON_ID	Person ID
FILING_STATUS_CODE	The W4 filing status code
FIT_OVERRIDE_AMOUNT	Federal income tax override amount
FIT_OVERRIDE_RATE	Federal income tax override rate (%)
WITHHOLDING_ALLOWANCES	W4 withholding allowance
CUMULATIVE_TAXATION	Cumulative taxation flag Y or N
EIC_FILING_STATUS_CODE	EIC filing status code
FIT_ADDITIONAL_TAX	Federal income tax additional tax
FIT_EXEMPT	Federal income tax exempt
FUTA_TAX_EXEMPT	FUTA tax exemption flag
MEDICARE_TAX_EXEMPT	Medicare tax exemption flag
EMP_FED_TAX_RULE_ID	System generated primary key column
SS_TAX_EXEMPT	Social security tax exempt flag
STATUTORY_EMPLOYEE	Statutory employee flag
W2_FILED_YEAR	The year W2 was filed
SUPP_TAX_OVERRIDE_RATE	Supplimental override rate
EXCESSIVE_WA_REJECT_DATE	The allowance rejet date
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
SUI_STATE_CODE	SUI state code
SUI_JURISDICTION_CODE	SUI jurisdiction code in format XX-YYY-ZZZZ, XX state, YYY county, ZZZZ-city
BUSINESS_GROUP_ID	Business group ID
CLIENT_ID	Client id
ADDITIONAL_WA_AMOUNT	The extra W4 withholding amount

Human Resources - HR_H2PI_EMPLOYEES	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to employees while data upload is in progress.
Column Name	Descritpion
LAST_UPD_DATE	Last update date
MIDDLE_NAMES	Middle name of the person
SUFFIX	Suffix after the surname e.g. Sr., Jr., III
START_DATE	Start date of person ( not the DateTrace attribute)
TITLE	Title e.g. Mr., Mrs.,Dr.
PRE_NAME_ADJUNCT	Name perfix
DATE_OF_BIRTH	Date of birth
MARITAL_STATUS	Marital status
REHIRE_REASON	Reason for re-hiring
SEX	Legal gender
NATIONALITY	Nationality
BUSINESS_GROUP_ID	Business group ID
NATIONAL_IDENTIFIER	Number by which a person is identified in a given legislation
CORRESPONDENCE_LANGUAGE	Corrospondence language
REGISTERED_DISABLED_FLAG	Flag indicating whether person is classified as disabled
DATE_OF_DEATH	Date of death
EMAIL_ADDRESS	Email address
CLIENT_ID	Client id
EXPENSE_CHECK_SEND_TO_ADDRESS	Mailing address
OFFICE_NUMBER	Office number
PER_INFORMATION_CATEGORY	Developer descriptive flexfiled column
PER_INFORMATION1	Developer descriptive flexfiled column
PER_INFORMATION2	Developer descriptive flexfiled column
PERSON_ID	System generated person primary key from PER_PERSON_S
PER_INFORMATION3	Developer descriptive flexfiled column
PER_INFORMATION4	Developer descriptive flexfiled column
PER_INFORMATION5	Developer descriptive flexfiled column
PER_INFORMATION6	Developer descriptive flexfiled column
PER_INFORMATION7	Developer descriptive flexfiled column
PER_INFORMATION8	Developer descriptive flexfiled column
PER_INFORMATION9	Developer descriptive flexfiled column
PER_INFORMATION10	Developer descriptive flexfiled column
PER_INFORMATION11	Developer descriptive flexfiled column
PER_INFORMATION12	Developer descriptive flexfiled column
EFFECTIVE_START_DATE	Effective start date
PER_INFORMATION13	Developer descriptive flexfiled column
PER_INFORMATION14	Developer descriptive flexfiled column
PER_INFORMATION15	Developer descriptive flexfiled column
PER_INFORMATION16	Developer descriptive flexfiled column
PER_INFORMATION17	Developer descriptive flexfiled column
PER_INFORMATION18	Developer descriptive flexfiled column
PER_INFORMATION19	Developer descriptive flexfiled column
PER_INFORMATION20	Developer descriptive flexfiled column
PER_INFORMATION21	Developer descriptive flexfiled column
PER_INFORMATION22	Developer descriptive flexfiled column
EFFECTIVE_END_DATE	Effective end date
PER_INFORMATION23	Developer descriptive flexfiled column
PER_INFORMATION24	Developer descriptive flexfiled column
PER_INFORMATION25	Developer descriptive flexfiled column
PER_INFORMATION26	Developer descriptive flexfiled column
PER_INFORMATION27	Developer descriptive flexfiled column
PER_INFORMATION28	Developer descriptive flexfiled column
PER_INFORMATION29	Developer descriptive flexfiled column
PER_INFORMATION30	Developer descriptive flexfiled column
ATTRIBUTE_CATEGORY	Developer flexfield structure defining column
ATTRIBUTE1	Descriptive flexfiled column
EMPLOYEE_NUMBER	Number assigned to a person if they have been employee
ATTRIBUTE2	Descriptive flexfiled column
ATTRIBUTE3	Descriptive flexfiled column
ATTRIBUTE4	Descriptive flexfiled column
ATTRIBUTE5	Descriptive flexfiled column
ATTRIBUTE6	Descriptive flexfiled column
ATTRIBUTE7	Descriptive flexfiled column
ATTRIBUTE8	Descriptive flexfiled column
ATTRIBUTE9	Descriptive flexfiled column
ATTRIBUTE10	Descriptive flexfiled column
ATTRIBUTE11	Descriptive flexfiled column
PERSON_TYPE	Person Type
ATTRIBUTE12	Descriptive flexfiled column
ATTRIBUTE13	Descriptive flexfiled column
ATTRIBUTE14	Descriptive flexfiled column
ATTRIBUTE15	Descriptive flexfiled column
ATTRIBUTE16	Descriptive flexfiled column
ATTRIBUTE17	Descriptive flexfiled column
ATTRIBUTE18	Descriptive flexfiled column
ATTRIBUTE19	Descriptive flexfiled column
ATTRIBUTE20	Descriptive flexfiled column
ATTRIBUTE21	Descriptive flexfiled column
LAST_NAME	Last name of the person,(surname, family name)
ATTRIBUTE22	Descriptive flexfiled column
ATTRIBUTE23	Descriptive flexfiled column
ATTRIBUTE24	Descriptive flexfiled column
ATTRIBUTE25	Descriptive flexfiled column
ATTRIBUTE26	Descriptive flexfiled column
ATTRIBUTE27	Descriptive flexfiled column
ATTRIBUTE28	Descriptive flexfiled column
ATTRIBUTE29	Descriptive flexfiled column
ATTRIBUTE30	Descriptive flexfiled column
STATUS	Status of record for upload
FIRST_NAME	First name of the person

Human Resources - HR_H2PI_ELEMENT_TYPES
Column Name	Descritpion
LAST_UPD_DATE	Last update date
ELEMENT_TYPE_ID	System generated primary key column
BUSINESS_GROUP_ID	Business group ID
CLIENT_ID	Client id
LEGISLATION_CODE	Legislation Code
ELEMENT_NAME	Element name
PROCESSING_TYPE	Processing type
EFFECTIVE_START_DATE	Effective start date
EFFECTIVE_END_DATE	Effective end date
STATUS	Status of record for upload

Human Resources - HR_H2PI_ELEMENT_NAMES
Column Name	Descritpion
LAST_UPD_DATE	Last update date
BUSINESS_GROUP_ID	Business group ID
CLIENT_ID	Client id
ELEMENT_TYPE_ID	Element type ID
ELEMENT_NAME	Element name
REPORTING_NAME	Element reporting name
STATUS	Status of record for upload

Human Resources - HR_H2PI_ELEMENT_LINKS
Column Name	Descritpion
LAST_UPD_DATE	Last update date
PAY_BASIS_ID	Pay Basis ID
LINK_TO_ALL_PAYROLLS_FLAG	Indicates whether this element is linked to all payorlls
STATUS	Status of column for upload
ELEMENT_LINK_ID	System generated primary key column
BUSINESS_GROUP_ID	Business group ID
CLIENT_ID	Client id
EFFECTIVE_START_DATE	Effective start date
EFFECTIVE_END_DATE	Effective end date
PAYROLL_ID	Payroll ID
COST_ALLOCATION_KEYFLEX_ID	Cost allocation ID
ELEMENT_TYPE_ID	Element Type ID
ORGANIZATION_ID	Organization ID
LOCATION_ID	Location ID

Human Resources - HR_H2PI_ELEMENT_ENTRIES	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to element entries while data upload is in progress.
Column Name	Descritpion
LAST_UPD_DATE	Last update date
ENTRY_TYPE	Subtype for an element entry
DATE_EARNED	Date earned for entry- used for mid period GRE changes
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
BUSINESS_GROUP_ID	Business group ID
ATTRIBUTE8	Descriptive flexfield column
ATTRIBUTE9	Descriptive flexfield column
ATTRIBUTE10	Descriptive flexfield column
ATTRIBUTE11	Descriptive flexfield column
ATTRIBUTE12	Descriptive flexfield column
CLIENT_ID	Client id
ATTRIBUTE13	Descriptive flexfield column
ATTRIBUTE14	Descriptive flexfield column
ATTRIBUTE15	Descriptive flexfield column
ATTRIBUTE16	Descriptive flexfield column
ATTRIBUTE17	Descriptive flexfield column
ELEMENT_ENTRY_ID	System generated primary key column
ATTRIBUTE18	Descriptive flexfield column
ATTRIBUTE19	Descriptive flexfield column
ATTRIBUTE20	Descriptive flexfield column
CONCATENATED_SEGMENTS	Key flexfield segment column
ID_FLEX_NUM	Key flexfield structure foreign key
SUMMARY_FLAG	Key flexfield structure summary flag
ENABLED_FLAG	Key flexfield structure enabled flag
START_DATE_ACTIVE	Date before which key flexfield combination is invalid
END_DATE_ACTIVE	Date after which key flexfield combination is invalid
SEGMENT1	Key flexfield segment column
PERSON_ID	Person ID
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
SEGMENT9	Key flexfield segment column
SEGMENT10	Key flexfield segment column
SEGMENT11	Key flexfield segment column
EFFECTIVE_START_DATE	Effective start date for element entry
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
SEGMENT19	Key flexfield segment column
SEGMENT20	Key flexfield segment column
SEGMENT21	Key flexfield segment column
EFFECTIVE_END_DATE	Effective end date for element entry
SEGMENT22	Key flexfield segment column
SEGMENT23	Key flexfield segment column
SEGMENT24	Key flexfield segment column
SEGMENT25	Key flexfield segment column
SEGMENT26	Key flexfield segment column
SEGMENT27	Key flexfield segment column
SEGMENT28	Key flexfield segment column
SEGMENT29	Key flexfield segment column
SEGMENT30	Key flexfield segment column
STATUS	Status of record for upload
ASSIGNMENT_ID	Assignment ID
ELEMENT_LINK_ID	Element Link ID
CREATOR_TYPE	Subsystem resposible for maintaining elememt entry

Human Resources - HR_H2PI_COUNTY_TAX_RULES	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to us employee county tax rules while data upload is in progress.
Column Name	Descritpion
PERSON_ID	Person ID
FILING_STATUS_CODE	County tax filing status code
JURISDICTION_CODE	Jurisdiction code
LIT_ADDITIONAL_TAX	LIT additional Tax
LIT_OVERRIDE_AMOUNT	LIT override amont
LIT_OVERRIDE_RATE	LIT override rate
WITHHOLDING_ALLOWANCES	Withoulding allowances
LIT_EXEMPT	LIT exempt
SD_EXEMPT	SD exempt
HT_EXEMPT	HT exempt
SCHOOL_DISTRICT_CODE	School district code
EMP_COUNTY_TAX_RULE_ID	System generated primary key value column
LAST_UPD_DATE	Last update date
OBJECT_VERSION_NUMBER	Object version number
STATUS	Status of record for uplaod
EFFECTIVE_START_DATE	Effective start date
EFFECTIVE_END_DATE	Effective end date
ASSIGNMENT_ID	Assignment ID
STATE_CODE	State code
COUNTY_CODE	County code
BUSINESS_GROUP_ID	Business group ID
CLIENT_ID	Client id
ADDITIONAL_WA_RATE	Additional WA rate

Human Resources - HR_H2PI_COST_ALLOCATIONS	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to cost allocations s while data upload is in progress.
Column Name	Descritpion
LAST_UPD_DATE	Last update date
ID_FLEX_NUM	Key flexfield structure foreign key
SUMMARY_FLAG	Key flexfield summary flag
ENABLED_FLAG	Key flexfield enabled flag
START_DATE_ACTIVE	Date before which key flexfiled segment combination is invalid
END_DATE_ACTIVE	Date after which key flexfiled segment 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
BUSINESS_GROUP_ID	Business group ID
SEGMENT6	Key flexfield segment column
SEGMENT7	Key flexfield segment column
SEGMENT8	Key flexfield segment column
SEGMENT9	Key flexfield segment column
SEGMENT10	Key flexfield segment column
CLIENT_ID	Client id
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
COST_ALLOCATION_ID	System generated primary key column
SEGMENT16	Key flexfield segment column
SEGMENT17	Key flexfield segment column
SEGMENT18	Key flexfield segment 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
PERSON_ID	Person ID
SEGMENT26	Key flexfield segment column
SEGMENT27	Key flexfield segment column
SEGMENT28	Key flexfield segment column
SEGMENT29	Key flexfield segment column
SEGMENT30	Key flexfield segment column
STATUS	Status of record for upload
EFFECTIVE_START_DATE	Effective start date
EFFECTIVE_END_DATE	Effective end date
ASSIGNMENT_ID	Assignment ID
PROPORTION	Percentage of assignment cost to be apportioned to this key flexfield
CONCATENATED_SEGMENTS	Key flexfield segment column

Human Resources - HR_H2PI_BG_AND_GRE	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to bg_and_gre while data upload is in progress.
Column Name	Descritpion
LAST_UPD_DATE	Last update date
ORGANIZATION_ID	Organization id
BUSINESS_GROUP_ID	Business group id
CLIENT_ID	Client id
DATE_FROM	Start date of organization
NAME	Name of organization
DATE_TO	End date of organization
LOCATION_ID	Location ID
STATUS	Status of record for upload

Human Resources - HR_H2PI_ASSIGNMENTS	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to assignments while data upload is in progress.
Column Name	Descritpion
LAST_UPD_DATE	Last update date
NORMAL_HOURS	Normal working hours
TITLE	Title of assignment
PAY_BASIS_ID	Pay basis ID
LOCATION_ID	Location ID
ORGANIZATION_ID	Organization ID
PAYROLL_ID	Payroll ID
HOURLY_SALARIED_CODE	Identifies if assignment is paid by hour or by salary
SEGMENT1	Key flexfield segment column
SEGMENT2	Key flexfield segment column
SEGMENT3	Key flexfield segment column
SEGMENT4	Key flexfield segment column
BUSINESS_GROUP_ID	Business group id
SEGMENT5	Key flexfield segment column
SEGMENT6	Key flexfield segment column
SEGMENT7	Key flexfield segment column
SEGMENT8	Key flexfield segment column
SEGMENT9	Key flexfield segment column
CLIENT_ID	Client id
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
ASSIGNMENT_ID	System generated primary key column
SEGMENT15	Key flexfield segment column
SEGMENT16	Key flexfield segment column
SEGMENT17	Key flexfield segment column
SEGMENT18	Key flexfield segment 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
PERSON_ID	Person ID
SEGMENT25	Key flexfield segment column
SEGMENT26	Key flexfield segment column
SEGMENT27	Key flexfield segment column
SEGMENT28	Key flexfield segment column
SEGMENT29	Key flexfield segment column
SEGMENT30	Key flexfield segment column
TIME_NORMAL_FINISH	Workday normal end time
TIME_NORMAL_START	Workday normal start time
EMPLOYMENT_CATEGORY	User defined category.For example Full Time or Part Time
ASS_ATTRIBUTE_CATEGORY	Descriptive flexfield column
EFFECTIVE_START_DATE	Effective start date
ASS_ATTRIBUTE1	Descriptive flexfield column
ASS_ATTRIBUTE2	Descriptive flexfield column
ASS_ATTRIBUTE3	Descriptive flexfield column
ASS_ATTRIBUTE4	Descriptive flexfield column
ASS_ATTRIBUTE5	Descriptive flexfield column
ASS_ATTRIBUTE6	Descriptive flexfield column
ASS_ATTRIBUTE7	Descriptive flexfield column
ASS_ATTRIBUTE8	Descriptive flexfield column
ASS_ATTRIBUTE9	Descriptive flexfield column
ASS_ATTRIBUTE10	Descriptive flexfield column
EFFECTIVE_END_DATE	Effective end date
ASS_ATTRIBUTE11	Descriptive flexfield column
ASS_ATTRIBUTE12	Descriptive flexfield column
ASS_ATTRIBUTE13	Descriptive flexfield column
ASS_ATTRIBUTE14	Descriptive flexfield column
ASS_ATTRIBUTE15	Descriptive flexfield column
ASS_ATTRIBUTE16	Descriptive flexfield column
ASS_ATTRIBUTE17	Descriptive flexfield column
ASS_ATTRIBUTE18	Descriptive flexfield column
ASS_ATTRIBUTE19	Descriptive flexfield column
ASS_ATTRIBUTE20	Descriptive flexfield column
ASSIGNMENT_NUMBER	Employee assignment number
ASS_ATTRIBUTE21	Descriptive flexfield column
ASS_ATTRIBUTE22	Descriptive flexfield column
ASS_ATTRIBUTE23	Descriptive flexfield column
ASS_ATTRIBUTE24	Descriptive flexfield column
ASS_ATTRIBUTE25	Descriptive flexfield column
ASS_ATTRIBUTE26	Descriptive flexfield column
ASS_ATTRIBUTE27	Descriptive flexfield column
ASS_ATTRIBUTE28	Descriptive flexfield column
ASS_ATTRIBUTE29	Descriptive flexfield column
ASS_ATTRIBUTE30	Descriptive flexfield column
PRIMARY_FLAG	Indicates primary employee assignment Y/N
STATUS	Status of record for upload
FREQUENCY	Frequency of normal working hours,- week,month, year

Human Resources - HR_DM_LOADER_PHASE_ITEMS	This entity contains the migration specific configuration data for the AOL loader files.
Column Name	Descritpion
DA_PHASE_ITEM_ID	Phase_item_id of the DA phase
CUSTOM_CODE_SPECIFIED	Y indicates that custom code specified that the flexfield be downloaded.
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.
SECURITY_GROUP_ID
UA_PHASE_ITEM_ID	Phase_item_id of the UA phase
LOADER_NAME	The description of the loader used for migration of AOL data.
LOADER_CONC_PROGRAM	The name of the loader concurrent program
LOADER_CONFIG_FILE	The name of the loader configuration file used for migration of AOL data.
LOADER_APPLICATION	The application short name for the loader used for migration of AOL data.
APPLICATION_ID	The application_id from the table FND_APPLICATION.
FILENAME	The filename used for the downloaded data file
LOADER_PHASE_ITEM_ID	System-generated primary key column.
PARAMETER_1	The parameter name / value pairs as required for the specified configuration file.
PARAMETER_2	The parameter name / value pairs as required for the specified configuration file.
PARAMETER_3	The parameter name / value pairs as required for the specified configuration file.
PARAMETER_4	The parameter name / value pairs as required for the specified configuration file.
PARAMETER_5	The parameter name / value pairs as required for the specified configuration file.
PARAMETER_6	The parameter name / value pairs as required for the specified configuration file.
PARAMETER_7	The parameter name / value pairs as required for the specified configuration file.
PARAMETER_8	The parameter name / value pairs as required for the specified configuration file.
PARAMETER_9	The parameter name / value pairs as required for the specified configuration file.
PARAMETER_10	The parameter name / value pairs as required for the specified configuration file.

Human Resources - HR_EFC_CURRENCY_HISTORIES	Contains one row per NCU currency as defined in FND_CURRENCIES at the time of the EFC processing with details of the NCU.
Column Name	Descritpion
EFC_ACTION_ID	Foreign Key to HR_EFC_ACTIONS.
CURRENCY_CODE	as defined in FND_CURRENCIES
SECURITY_GROUP_ID
CREATOR	created_by value from FND_CURRENCIES
DERIVE_EFFECTIVE	value from FND_CURRENCIES
DERIVE_FACTOR	value from FND_CURRENCIES
LAST_UPDATED_BY	Standard Who Column.
LAST_UPDATE_LOGIN	Standard Who Column.
CREATED_BY	Standard Who Column.
EFC_CURRENCY_HISTORY_ID	Surrogate Primary Key.
CREATION_DATE	Standard Who Column.
LAST_UPDATE_DATE	Standard Who Column.

Human Resources - HR_AUTHORIA_MAPPINGS	Authoria Mapping Information
Column Name	Descritpion
PL_ID	Foreign key to BEN_PL_F
PLIP_ID	Foreign key to BEN_PLIP_F
OPEN_ENROLLMENT_FLAG	Flag to indicate if the target page is applicable to open enrollment.
TARGET_PAGE	The Authoria page name.
AUTHORIA_MAPPING_ID	System generated primary key.
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.
OBJECT_VERSION_NUMBER	Object version number

Human Resources - HR_ATH_ELIGIBLE_TBLS
Column Name	Descritpion
ATH_UID	Authoria schema username
ATH_PWD	Authoria schema password
ATH_TABLENAME	Table name
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
ATH_DSN	DSN for the table

Human Resources - HR_ATH_ENROLL_TBLS	This table contains ODBC connectivity information for the Authoria enrolled plans table(s).
Column Name	Descritpion
ATH_UID	Authoria schema username
ATH_PWD	Authoria schema password
ATH_TABLENAME	Table name
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
ATH_DSN	DSN for the table

Human Resources - HR_ATH_VARIABLEMAP	Variable mappings table for the Authoria Integration
Column Name	Descritpion
ATH_TABLENAME	Name of the bridge table that contains this variable.
ATH_COLUMNNAME	Name of the column in the bridge table that contains this variable.
ATH_VARNAME	Name of the Authoria variable.
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.
ATH_VARIABLEMAP_ID	System generated primary key
OBJECT_VERSION_NUMBER	Object version number
ATH_DSN	DSN for this table

Human Resources - HR_ALL_POSITIONS_F_TL	Translation table
Column Name	Descritpion
LANGUAGE	Defined Language
SOURCE_LANG	Actual language
NAME	Translated Position Name
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.
POSITION_ID	Foreign key to base table

Human Resources - AME_APPROVAL_GROUP_MEMBERS	To be Updated
Column Name	Descritpion
PARAMETER_NAME
PARAMETER
QUERY_STRING
ORDER_NUMBER
SECURITY_GROUP_ID
ORIG_SYSTEM
ORIG_SYSTEM_ID
APPROVAL_GROUP_ID

Human Resources - AME_TEMP_TRANS_LOCKS	To be Updated
Column Name	Descritpion
TRANSACTION_TYPE_ID
TRANSACTION_ID
ROW_TIMESTAMP
FND_APPLICATION_ID

Human Resources - AME_APPROVER_TYPES	To be Updated
Column Name	Descritpion
START_DATE
END_DATE
ORIG_SYSTEM
QUERY_VARIABLE_1_LABEL
QUERY_VARIABLE_2_LABEL
QUERY_VARIABLE_3_LABEL
QUERY_VARIABLE_4_LABEL
QUERY_VARIABLE_5_LABEL
VARIABLE_1_LOV_QUERY
APPROVER_TYPE_ID
VARIABLE_2_LOV_QUERY
VARIABLE_3_LOV_QUERY
VARIABLE_4_LOV_QUERY
VARIABLE_5_LOV_QUERY
QUERY_PROCEDURE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN

Human Resources - AME_APPROVER_TYPE_USAGES	To be Updated
Column Name	Descritpion
ACTION_TYPE_ID
START_DATE
END_DATE
APPROVER_TYPE_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN

Human Resources - AME_ACTION_TYPE_CONFIG
Column Name	Descritpion
APPLICATION_ID
LAST_UPDATE_LOGIN
START_DATE
END_DATE
ACTION_TYPE_ID
VOTING_REGIME
ORDER_NUMBER
CHAIN_ORDERING_MODE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE

Human Resources - AME_ACTION_USAGES
Column Name	Descritpion
RULE_ID
ACTION_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
START_DATE
END_DATE

Human Resources - AME_APPROVAL_GROUP_CONFIG
Column Name	Descritpion
APPLICATION_ID
START_DATE
END_DATE
APPROVAL_GROUP_ID
VOTING_REGIME
ORDER_NUMBER
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN

Human Resources - AME_ITEM_CLASSES
Column Name	Descritpion
ITEM_CLASS_ID
NAME
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
START_DATE
END_DATE

Human Resources - AME_ITEM_CLASS_USAGES
Column Name	Descritpion
APPLICATION_ID
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
START_DATE
END_DATE
ITEM_CLASS_ID
ITEM_ID_QUERY
ITEM_CLASS_ORDER_NUMBER
ITEM_CLASS_PAR_MODE
ITEM_CLASS_SUBLIST_MODE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY

Human Resources - AME_TEMP_TRANS_ATT_VALUES
Column Name	Descritpion
APPLICATION_ID
ATTRIBUTE_VALUE_2
ATTRIBUTE_VALUE_3
SECURITY_GROUP_ID
ITEM_ID
ITEM_CLASS_ID
TRANSACTION_ID
ROW_TIMESTAMP
ATTRIBUTE_ID
ATTRIBUTE_NAME
ATTRIBUTE_TYPE
IS_MANDATORY
LINE_ITEM_ID
ATTRIBUTE_VALUE_1

Human Resources - HR_DOCUMENT_EXTRA_INFO	Documents of Record Information
Column Name	Descritpion
PERSON_ID	Foreign Key to PER_PEOPLE_F.
DEI_ATTRIBUTE4	Descriptive flexfield column.
DEI_ATTRIBUTE5	Descriptive flexfield column.
DEI_ATTRIBUTE6	Descriptive flexfield column.
DEI_ATTRIBUTE7	Descriptive flexfield column.
DEI_ATTRIBUTE8	Descriptive flexfield column.
DEI_ATTRIBUTE9	Descriptive flexfield column.
DEI_ATTRIBUTE10	Descriptive flexfield column.
DEI_ATTRIBUTE11	Descriptive flexfield column.
DEI_ATTRIBUTE12	Descriptive flexfield column.
DEI_ATTRIBUTE13	Descriptive flexfield column.
DOCUMENT_TYPE_ID	Foriegn key to HR_DOCUMENT_TYPES.
DEI_ATTRIBUTE14	Descriptive flexfield column.
DEI_ATTRIBUTE15	Descriptive flexfield column.
DEI_ATTRIBUTE16	Descriptive flexfield column.
DEI_ATTRIBUTE17	Descriptive flexfield column.
DEI_ATTRIBUTE18	Descriptive flexfield column.
DEI_ATTRIBUTE19	Descriptive flexfield column.
DEI_ATTRIBUTE20	Descriptive flexfield column.
DEI_ATTRIBUTE21	Descriptive flexfield column.
DEI_ATTRIBUTE22	Descriptive flexfield column.
DEI_ATTRIBUTE23	Descriptive flexfield column.
DOCUMENT_NUMBER	Number assigned to the Document.
DEI_ATTRIBUTE24	Descriptive flexfield column.
DEI_ATTRIBUTE25	Descriptive flexfield column.
DEI_ATTRIBUTE26	Descriptive flexfield column.
DEI_ATTRIBUTE27	Descriptive flexfield column.
DEI_ATTRIBUTE28	Descriptive flexfield column.
DEI_ATTRIBUTE29	Descriptive flexfield column.
DEI_ATTRIBUTE30	Descriptive flexfield column.
DEI_INFORMATION_CATEGORY	Developer Descriptive flexfield structure column.
DEI_INFORMATION1	Developer Descriptive flexfield column.
DEI_INFORMATION2	Developer Descriptive flexfield column.
DATE_FROM	Date from which Document is valid.
DEI_INFORMATION3	Developer Descriptive flexfield column.
DEI_INFORMATION4	Developer Descriptive flexfield column.
DEI_INFORMATION5	Developer Descriptive flexfield column.
DEI_INFORMATION6	Developer Descriptive flexfield column.
DEI_INFORMATION7	Developer Descriptive flexfield column.
DEI_INFORMATION8	Developer Descriptive flexfield column.
DEI_INFORMATION9
DEI_INFORMATION10	Developer Descriptive flexfield column.
DEI_INFORMATION11	Developer Descriptive flexfield column.
DEI_INFORMATION12	Developer Descriptive flexfield column.
DATE_TO	Date till document is valid.
DEI_INFORMATION13	Developer Descriptive flexfield column.
DEI_INFORMATION14	Developer Descriptive flexfield column.
DEI_INFORMATION15	Developer Descriptive flexfield column.
DEI_INFORMATION16	Developer Descriptive flexfield column.
DEI_INFORMATION17	Developer Descriptive flexfield column.
DEI_INFORMATION18	Developer Descriptive flexfield column.
DEI_INFORMATION19	Developer Descriptive flexfield column.
DEI_INFORMATION20	Developer Descriptive flexfield column.
DEI_INFORMATION21	Developer Descriptive flexfield column.
DEI_INFORMATION22	Developer Descriptive flexfield column.
ISSUED_BY	Name of the document issuing aurhority.
DEI_INFORMATION23	Developer Descriptive flexfield column.
DEI_INFORMATION24	Developer Descriptive flexfield column.
DEI_INFORMATION25	Developer Descriptive flexfield column.
DEI_INFORMATION26	Developer Descriptive flexfield column.
DEI_INFORMATION27	Developer Descriptive flexfield column.
DEI_INFORMATION28	Developer Descriptive flexfield column.
DEI_INFORMATION29	Developer Descriptive flexfield column.
DEI_INFORMATION30	Developer Descriptive flexfield column.
REQUEST_ID	Standard Who column.
PROGRAM_APPLICATION_ID	Standard Who column.
ISSUED_AT	Place where document was issued.
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.
CREATION_DATE	Standard Who column.
ISSUED_DATE	Date of issue.
DOCUMENT_EXTRA_INFO_ID	System-generated primary key column.
ISSUING_AUTHORITY	Department or Organization who issued the document.
VERIFIED_BY	Name of HR person who verified the document.
VERIFIED_DATE	Date on which document was verified.
RELATED_OBJECT_NAME	Name of any other object related to the document.
RELATED_OBJECT_ID_COL	Name of the column that uniquely identified the related object.
RELATED_OBJECT_ID	Value in the column that uniquely identified the related object.
DEI_ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
DEI_ATTRIBUTE1	Descriptive flexfield column.
DEI_ATTRIBUTE2	Descriptive flexfield column.
DEI_ATTRIBUTE3	Descriptive flexfield column.

Human Resources - HR_DOCUMENT_TYPES	Document Types for Documents od Record
Column Name	Descritpion
CREATION_DATE	Standard Who column.
CATEGORY_CODE
SUB_CATEGORY_CODE	Foreign Key from PER_SHARED_TYPES.
ACTIVE_INACTIVE_FLAG	Indicates whether the document type is active or inactive.
MULTIPLE_OCCURENCES_FLAG	Indicates whether a person may have multiple occurrences of this type.
LEGISLATION_CODE	The legislation to which the document type applies.
AUTHORIZATION_REQUIRED	Indicates whether or not the document type requires authorization.
DOCUMENT_TYPE_ID	System-generated primary key column.
WARNING_PERIOD	Indicates that warning is required number of days before expiry of document.
REQUEST_ID	Standard Who column.
PROGRAM_APPLICATION_ID	Standard Who column.
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.

Human Resources - HR_DOCUMENT_TYPES_TL	Translated Document Types for Documents of Record
Column Name	Descritpion
LANGUAGE	Defined language.
SOURCE_LANGUAGE	Actual language.
DOCUMENT_TYPE	Translated name of document type.
DESCRIPTION	Translated description of document type.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
DOCUMENT_TYPE_ID	Foreign key to HR_DOCUMENT_TYPES
CREATION_DATE	Standard Who column.