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

Human Resources - PER_SECURITY_PROFILES	Security profile definitions to restrict user access to specific HRMS records.
Column Name	Descritpion
SECURITY_PROFILE_ID	System-generated primary key column.
SECURITY_PROFILE_NAME	Security profile name.
VIEW_ALL_APPLICANTS_FLAG	Grant access to applicants (Y for all applicants, N for restricted access, X for no access)
VIEW_ALL_EMPLOYEES_FLAG	Grant access to employees (Y for all employees, N for restricted access, X for no access)
ALLOW_GRANTED_USER_FLAG
VIEW_ALL_CWK_FLAG	view all contingent workers flag
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
VIEW_ALL_CONTACTS_FLAG	view all contacts flag
VIEW_ALL_CANDIDATES_FLAG	view all candidates flag
VIEW_ALL_FLAG	Grant unrestricted access to all data (Y/N).
VIEW_ALL_ORGANIZATIONS_FLAG	Grant unrestricted access to all organizations ( Y/N).
POSITION_ID	Foreign key to PER_ALL_POSITIONS.
VIEW_ALL_PAYROLLS_FLAG	Grant unrestricted access to all payrolls (Y/N).
VIEW_ALL_POSITIONS_FLAG	Grant unrestricted access to all positions (Y/N).
INCLUDE_EXCLUDE_PAYROLL_FLAG	Include or exclude specific payrolls.
REPORTING_ORACLE_USERNAME	Reporting user name for the ID set up by the DBA.
ALLOW_GRANTED_USERS_FLAG	This column specifies whether people outside the security profile may be made visible to a person on an ad-hoc basis
RESTRICT_BY_SUPERVISOR_FLAG	Restrict the people that are visible to those within your supervisor hierarchy
SUPERVISOR_LEVELS	The number of levels to use for the supervisor hierarchy
EXCLUDE_SECONDARY_ASGS_FLAG	Only use primary assignments when building the supervisor hierarchy
EXCLUDE_PERSON_FLAG	Exclude the current person from the list of visible people
NAMED_PERSON_ID	The person to use for the top level in the supervisor hierarchy, or to use for the exclude user flag (optional)
ORGANIZATION_ID	Foreign key to HR_ORGANIZATION_UNITS.
CUSTOM_RESTRICTION_FLAG	Specifies if a custom restriction is to be used
RESTRICTION_TEXT	The sql fragment of the custom restriction
EXCLUDE_BUSINESS_GROUPS_FLAG	Specifies if all business groups are included for global security profiles
REQUEST_ID	Standard Who column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who column.
PROGRAM_UPDATE_DATE	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
POSITION_STRUCTURE_ID	Foreign key to PER_POSITION_STRUCTURES.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
ORG_SECURITY_MODE	Stores the mode by which organizations are secured.
RESTRICT_ON_INDIVIDUAL_ASG	Restrict on an individual assignment basis.
ORGANIZATION_STRUCTURE_ID	Foreign key to PER_ORGANIZATION_STRUCTURES.
TOP_ORGANIZATION_METHOD	Indicates whether the top organization is statically defined or whether it is used-based.
TOP_POSITION_METHOD	Indicates whether the top position is statically defined or whether it is used-based.
INCLUDE_TOP_ORGANIZATION_FLAG	Include top organization in hierarchy in access list (Y/N).
INCLUDE_TOP_POSITION_FLAG	Include top position in hierarchy in access list ( Y/N).

Human Resources - PER_JOBS	Jobs defined for a Business Group.
Column Name	Descritpion
JOB_ID	System-generated primary key 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.
ATTRIBUTE3	Descriptive flexfield column.
ATTRIBUTE4	Descriptive flexfield column.
ATTRIBUTE5	Descriptive flexfield column.
ATTRIBUTE6	Descriptive flexfield column.
ATTRIBUTE7	Descriptive flexfield column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ATTRIBUTE8	Descriptive flexfield column.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
JOB_DEFINITION_ID	Foreign key to PER_JOB_DEFINITIONS.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
JOB_INFORMATION_CATEGORY	Developer descriptive flexfield column.
JOB_INFORMATION1	Developer descriptive flexfield column.
DATE_FROM	Date from which an employee or applicant may be assigned to this job.
JOB_INFORMATION2	Developer descriptive flexfield column.
JOB_INFORMATION3	Developer descriptive flexfield column.
JOB_INFORMATION4	Developer descriptive flexfield column.
JOB_INFORMATION5	Developer descriptive flexfield column.
JOB_INFORMATION6	Developer descriptive flexfield column.
JOB_INFORMATION7	Developer descriptive flexfield column.
JOB_INFORMATION8	Developer descriptive flexfield column.
JOB_INFORMATION9	Developer descriptive flexfield column.
JOB_INFORMATION10	Developer descriptive flexfield column.
JOB_INFORMATION11	Developer descriptive flexfield column.
COMMENTS	General remark.
JOB_INFORMATION12	Developer descriptive flexfield column.
JOB_INFORMATION13	Developer descriptive flexfield column.
JOB_INFORMATION14	Developer descriptive flexfield column.
JOB_INFORMATION15	Developer descriptive flexfield column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
JOB_INFORMATION16	Developer descriptive flexfield column.
JOB_INFORMATION17	Developer descriptive flexfield column.
JOB_INFORMATION18	Developer descriptive flexfield column.
JOB_INFORMATION19	Developer descriptive flexfield column.
DATE_TO	Date after which employees and applicants may no longer be assigned to this job.
JOB_INFORMATION20	Developer descriptive flexfield column.
BENCHMARK_JOB_FLAG	Benchmark Job Flag
BENCHMARK_JOB_ID	Benchmark Job Id.
EMP_RIGHTS_FLAG	Additional employee rights.
JOB_GROUP_ID	Foreign key to per_job_groups.
APPROVAL_AUTHORITY	Approval Authority used by OAM
NAME	Job name, concatenated from the keyflex structure.
REQUEST_ID	Standard Who column.
PROGRAM_APPLICATION_ID	Standard Who column.

Human Resources - PER_JOB_DEFINITIONS	Job key flexfield combinations table.
Column Name	Descritpion
JOB_DEFINITION_ID	System-generated primary key column.
END_DATE_ACTIVE	Date after which key flexfield combination is invalid.
SEGMENT1	Key flexfield segment column.
SEGMENT2	Key flexfield segment column.
SEGMENT3	Key flexfield segment column.
SEGMENT4	Key flexfield segment column.
SEGMENT5	Key flexfield segment column.
SEGMENT6	Key flexfield segment column.
SEGMENT7	Key flexfield segment column.
SEGMENT8	Key flexfield segment column.
SEGMENT9	Key flexfield segment column.
REQUEST_ID	Standard Who column.
SEGMENT10	Key flexfield segment column.
SEGMENT11	Key flexfield segment column.
SEGMENT12	Key flexfield segment column.
SEGMENT13	Key flexfield segment column.
SEGMENT14	Key flexfield segment column.
SEGMENT15	Key flexfield segment column.
SEGMENT16	Key flexfield segment column.
SEGMENT17	Key flexfield segment column.
SEGMENT18	Key flexfield segment column.
SEGMENT19	Key flexfield segment column.
PROGRAM_APPLICATION_ID	Standard Who column.
SEGMENT20	Key flexfield segment column.
SEGMENT21	Key flexfield segment column.
SEGMENT22	Key flexfield segment column.
SEGMENT23	Key flexfield segment column.
SEGMENT24	Key flexfield segment column.
SEGMENT25	Key flexfield segment column.
SEGMENT26	Key flexfield segment column.
SEGMENT27	Key flexfield segment column.
SEGMENT28	Key flexfield segment column.
SEGMENT29	Key flexfield segment column.
PROGRAM_ID	Standard Who column.
SEGMENT30	Key flexfield segment column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
PROGRAM_UPDATE_DATE	Standard Who column.
ID_FLEX_NUM	Key flexfield structure foreign key.
SUMMARY_FLAG	Key flexfield summary flag.
ENABLED_FLAG	Key flexfield enabled flag.
START_DATE_ACTIVE	Date before which key flexfield combination is invalid.

Human Resources - PER_JOB_EVALUATIONS	Job evaluation details for specific jobs or positions.
Column Name	Descritpion
JOB_EVALUATION_ID	System-generated primary key column.
REQUEST_ID	Standard Who column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who column.
PROGRAM_UPDATE_DATE	Standard Who column.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
ATTRIBUTE1	Descriptive flexfield column.
ATTRIBUTE2	Descriptive flexfield column.
ATTRIBUTE3	Descriptive flexfield column.
ATTRIBUTE4	Descriptive flexfield column.
ATTRIBUTE5	Descriptive flexfield column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ATTRIBUTE6	Descriptive flexfield column.
ATTRIBUTE7	Descriptive flexfield column.
ATTRIBUTE8	Descriptive flexfield column.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
COMMENTS	General remark.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
DATE_EVALUATED	Evaluation date.
JOB_ID	Foreign key to PER_JOBS.
MEASURED_IN	The units of measure for the overall score.
OVERALL_SCORE	Evaluation score applied to the job or position.
POSITION_ID	Foreign key to PER_ALL_POSITIONS.
SYSTEM	Name of evaluation system.

Human Resources - PER_JOB_REQUIREMENTS	Requirements for specific jobs or positions. For example, skills, qualifications, experience, training.
Column Name	Descritpion
JOB_REQUIREMENT_ID	System-generated primary key column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
POSITION_ID	Foreign key to PER_ALL_POSITIONS.
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.
ATTRIBUTE3	Descriptive flexfield column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ATTRIBUTE4	Descriptive flexfield column.
ATTRIBUTE5	Descriptive flexfield column.
ATTRIBUTE6	Descriptive flexfield column.
ATTRIBUTE7	Descriptive flexfield column.
ATTRIBUTE8	Descriptive flexfield column.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ANALYSIS_CRITERIA_ID	Foreign key to PER_ANALYSIS_CRITERIA.
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.
COMMENTS	General remark.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
DATE_FROM	Date from which the requirement applies.
DATE_TO	Date after which the requirement no longer applies.
ESSENTIAL	Indicates if this is an essential requirement, or desirable.
JOB_ID	Foreign key to PER_JOBS.

Human Resources - PER_LETTER_GEN_STATUSES	Associations between letter types and possible status type changes.
Column Name	Descritpion
LETTER_GEN_STATUS_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.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ASSIGNMENT_STATUS_TYPE_ID	Identifies whether status type is HR applicant assignment status type or OTA booking status type.
LETTER_TYPE_ID	Foreign key to PER_LETTER_TYPES.
ENABLED_FLAG	Indicates whether the letter generation status is enabled.
REQUEST_ID	Standard Who column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who column.
PROGRAM_UPDATE_DATE	Standard Who column.

Human Resources - PER_LETTER_REQUESTS	Requests for specific types of standard letter.
Column Name	Descritpion
LETTER_REQUEST_ID	System-generated primary key column.
PROGRAM_UPDATE_DATE	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
REQUEST_ID	Standard Who column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
LETTER_TYPE_ID	Foreign key to PER_LETTER_TYPES.
DATE_FROM	Date on which the letter request was created.
REQUEST_STATUS	Letter request status: PENDING , REQUESTED or COMPLETED.
AUTO_OR_MANUAL	Indicates whether the request was created automatically by change of status, or manually by a user.
OBJECT_VERSION_NUMBER	Object Version Number
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who column.

Human Resources - PER_LETTER_REQUEST_LINES	Details of individual letter requests.
Column Name	Descritpion
LETTER_REQUEST_LINE_ID	System-generated primary key column.
PROGRAM_ID	Standard Who column.
PROGRAM_UPDATE_DATE	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
OTA_BOOKING_STATUS_TYPE_ID	Foreign key to OTA_BOOKING_STATUS_TYPES.
OTA_BOOKING_ID	Foreign key to OTA_DELEGATE_BOOKINGS.
OTA_EVENT_ID	Foreign key to OTA_EVENTS.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
REQUEST_ID	Standard Who column.
CONTRACT_ID	Foreign key to PER_CONTRACTS_F
LETTER_REQUEST_ID	Foreign key to PER_LETTER_REQUESTS.
PERSON_ID	Foreign key to PER_ALL_PEOPLE_F.
ASSIGNMENT_ID	Foreign key to PER_ALL_ASSIGNMENTS_F.
ASSIGNMENT_STATUS_TYPE_ID	Foreign key to PER_ASSIGNMENT_STATUS_TYPES.
DATE_FROM	Creation date of letter request line.
OBJECT_VERSION_NUMBER	Object Version Number.
PROGRAM_APPLICATION_ID	Standard Who column.

Human Resources - PER_LETTER_TYPES	Letter types and auto-request definitions.
Column Name	Descritpion
LETTER_TYPE_ID	System-generated primary key column.
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.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
CONCURRENT_PROGRAM_ID	The concurrent program that is run when a letter request for this letter type is submitted to the concurrent manager.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
GENERATION_STATUS_TYPE	Type of status change used to generate letter request lines e.g. a training booking or applicant assignment.
LETTER_TYPE_NAME	Letter type name, for example, Standard Offer Letter.
COMMENTS	General remark.
REQUEST_ID	Standard Who column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who column.
PROGRAM_UPDATE_DATE	Standard Who column.

Human Resources - PER_NUMBER_GENERATION_CONTROLS	PER_NUMBER_GENERATION_CONTROLS holds the numbers that are automatically generated for a Business Group.
Column Name	Descritpion
TYPE	Numeric sequence type.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
NEXT_VALUE	The next value in the sequence.
LAST_UPDATE_DATE	Standard Who column.

Human Resources - PER_ORGANIZATION_LIST	List of organizations that a secure user can access.
Column Name	Descritpion
USER_ID	Foreign key to FND_USER.
REQUEST_ID	Standard Who Column.
SECURITY_PROFILE_ID	Foreign key to PER_SECURITY_PROFILES.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who Column.
PROGRAM_UPDATE_DATE	Standard Who column.
ORGANIZATION_ID	Foreign key to HR_ORGANIZATION_UNITS.

Human Resources - PER_ORGANIZATION_STRUCTURES	Organization hierarchy names.
Column Name	Descritpion
ORGANIZATION_STRUCTURE_ID	System generated organization structure primary key from PER_ORGANIZATION_STRUCTURES_S.
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.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
NAME	Name of organization hierarchy.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
COMMENTS	General remark.
POSITION_CONTROL_STRUCTURE_FLG	Position Control Structure Flg
OBJECT_VERSION_NUMBER	OBJECT VERSION NUMBER
PRIMARY_STRUCTURE_FLAG	Identifies the primary organization hierarchy for a business group, (Y/N).
REQUEST_ID	Standard Who Column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who Column.
PROGRAM_UPDATE_DATE	Standard Who column.

Human Resources - PER_ORG_STRUCTURE_ELEMENTS	Organization hierarchy details showing parent-child reporting relationships between organizations.
Column Name	Descritpion
ORG_STRUCTURE_ELEMENT_ID	System generated organization structure element primary key, from PER_ORG_STRUCTURE_ELEMENTS_S.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
POSITION_CONTROL_ENABLED_FLAG	Position Control flag
PARTY_ID	Party Id
ORGANIZATION_ID_PARENT	Foreign key to HR_ORGANIZATION_UNITS. Identifies the parent organization.
ORG_STRUCTURE_VERSION_ID	Foreign key to PER_ORG_STRUCTURE_VERSIONS. Identifies the specific version of the hierarchy .
ORGANIZATION_ID_CHILD	Foreign key to HR_ORGANIZATION_UNITS. Identifies the child organization.
REQUEST_ID	Standard Who Column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who Column.
PROGRAM_UPDATE_DATE	Standard Who column.

Human Resources - PER_ORG_STRUCTURE_VERSIONS	Version control information for specific organization hierarchies.
Column Name	Descritpion
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ORGANIZATION_STRUCTURE_ID	Foreign key to PER_ORGANIZATION_STRUCTURES.
DATE_FROM	Start date of this version.
VERSION_NUMBER	User enterable version number, not necessarily contiguous.
COPY_STRUCTURE_VERSION_ID	Foreign key to PER_ORG_STRUCTURE_VERSIONS. Used if this version is copied from a previously existing structure.
DATE_TO	End date of this version.
REQUEST_ID	Standard Who Column.
PROGRAM_APPLICATION_ID	Standard Who column.
ORG_STRUCTURE_VERSION_ID	Primary key from PER_ORG_STRUCTURE_VERSIONS_S.
PROGRAM_ID	Standard Who Column.
PROGRAM_UPDATE_DATE	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
TOPNODE_POS_CTRL_ENABLED_FLAG	Indicates top node position controlled hierarchy

Human Resources - PER_PARENT_SPINES	Details of pay scales, (previously known as parent spines).
Column Name	Descritpion
NAME	Pay scale name.
COMMENTS	General remark.
INCREMENT_FREQUENCY	Number indicating the frequency with which increments should be applied. Used for information only.
INCREMENT_PERIOD	The period for which the INCREMENT_FREQUENCY applies, eg Year.
LAST_AUTOMATIC_INCREMENT_DATE	Date of last run of Increment Progression Points process against this Pay Scale.
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.
ATTRIBUTE3	Descriptive flexfield column.
ATTRIBUTE4	Descriptive flexfield column.
ATTRIBUTE5	Descriptive flexfield column.
ATTRIBUTE6	Descriptive flexfield column.
ATTRIBUTE7	Descriptive flexfield column.
ATTRIBUTE8	Descriptive flexfield column.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
OBJECT_VERSION_NUMBER	Object Version Number used by HRMS for locking purposes
INFORMATION_CATEGORY	Developer Descriptive Flexfield structure defining column
INFORMATION1	Developer-Descriptive Flexfield Segment
INFORMATION2	Developer-Descriptive Flexfield Segment
INFORMATION3	Developer-Descriptive Flexfield Segment
INFORMATION4	Developer-Descriptive Flexfield Segment
INFORMATION5	Developer-Descriptive Flexfield Segment
INFORMATION6	Developer-Descriptive Flexfield Segment
INFORMATION7	Developer-Descriptive Flexfield Segment
INFORMATION8	Developer-Descriptive Flexfield Segment
INFORMATION9	Developer-Descriptive Flexfield Segment
INFORMATION10	Developer-Descriptive Flexfield Segment
INFORMATION11	Developer-Descriptive Flexfield Segment
INFORMATION12	Developer-Descriptive Flexfield Segment
INFORMATION13	Developer-Descriptive Flexfield Segment
INFORMATION14	Developer-Descriptive Flexfield Segment
INFORMATION15	Developer-Descriptive Flexfield Segment
INFORMATION16	Developer-Descriptive Flexfield Segment
INFORMATION17	Developer-Descriptive Flexfield Segment
INFORMATION18	Developer-Descriptive Flexfield Segment
INFORMATION19	Developer-Descriptive Flexfield Segment
PARENT_SPINE_ID	System-generated primary key column.
INFORMATION20	Developer-Descriptive Flexfield Segment
INFORMATION21	Developer-Descriptive Flexfield Segment
INFORMATION22	Developer-Descriptive Flexfield Segment
INFORMATION23	Developer-Descriptive Flexfield Segment
INFORMATION24	Developer-Descriptive Flexfield Segment
INFORMATION25	Developer-Descriptive Flexfield Segment
INFORMATION26	Developer-Descriptive Flexfield Segment
INFORMATION27	Developer-Descriptive Flexfield Segment
INFORMATION28	Developer-Descriptive Flexfield Segment
INFORMATION29	Developer-Descriptive Flexfield Segment
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
INFORMATION30	Developer-Descriptive Flexfield Segment

Human Resources - PER_PERIODS_OF_SERVICE	Period of service details for an employee.
Column Name	Descritpion
PERIOD_OF_SERVICE_ID	System generated period of service primary key from PER_PERIODS_OF_SERVICE_S.
LAST_STANDARD_PROCESS_DATE	Last date for including the person in any standard payroll processing.
PDS_INFORMATION25	Developer descriptive flexfield column.
PDS_INFORMATION26	Developer descriptive flexfield column.
PDS_INFORMATION27	Developer descriptive flexfield column.
PDS_INFORMATION28	Developer descriptive flexfield column.
PDS_INFORMATION29	Developer descriptive flexfield column.
LEAVING_REASON	Reason for termination of employment.
PDS_INFORMATION30	Developer descriptive flexfield column.
NOTIFIED_TERMINATION_DATE	Date when the termination of employment was noted.
PROJECTED_TERMINATION_DATE	Projected employment termination date, used for information only.
ADJUSTED_SVC_DATE	Previous date of hire.
REQUEST_ID	Standard Who Column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who Column.
PROGRAM_UPDATE_DATE	Standard Who column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
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.
TERMINATION_ACCEPTED_PERSON_ID	Foreign key to PER_PEOPLE. Person who accepted or authorized employee termination.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
PERSON_ID	Foreign key to PER_PEOPLE.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
PRIOR_EMPLOYMENT_SSP_PAID_TO	Date SSP paid to in prior employment. (UK specific).
PRIOR_EMPLOYMENT_SSP_WEEKS	Number of weeks SSP paid for in prior employment. (UK specific).
DATE_START	Start date of the period of employment.
PDS_INFORMATION_CATEGORY	Developer descriptive flexfield structure defining column.
PDS_INFORMATION1	Developer descriptive flexfield column.
PDS_INFORMATION2	Developer descriptive flexfield column.
PDS_INFORMATION3	Developer descriptive flexfield column.
PDS_INFORMATION4	Developer descriptive flexfield column.
ACCEPTED_TERMINATION_DATE	Date when termination of employment was accepted.
PDS_INFORMATION5	Developer descriptive flexfield column.
PDS_INFORMATION6	Developer descriptive flexfield column.
PDS_INFORMATION7	Developer descriptive flexfield column.
PDS_INFORMATION8	Developer descriptive flexfield column.
PDS_INFORMATION9	Developer descriptive flexfield column.
ACTUAL_TERMINATION_DATE	Actual date of termination of employment.
PDS_INFORMATION10	Developer descriptive flexfield column.
PDS_INFORMATION11	Developer descriptive flexfield column.
PDS_INFORMATION12	Developer descriptive flexfield column.
PDS_INFORMATION13	Developer descriptive flexfield column.
PDS_INFORMATION14	Developer descriptive flexfield column.
COMMENTS	General remark.
PDS_INFORMATION15	Developer descriptive flexfield column.
PDS_INFORMATION16	Developer descriptive flexfield column.
PDS_INFORMATION17	Developer descriptive flexfield column.
PDS_INFORMATION18	Developer descriptive flexfield column.
PDS_INFORMATION19	Developer descriptive flexfield column.
FINAL_PROCESS_DATE	Final date for all payroll processing of this person.
PDS_INFORMATION20	Developer descriptive flexfield column.
PDS_INFORMATION21	Developer descriptive flexfield column.
PDS_INFORMATION22	Developer descriptive flexfield column.
PDS_INFORMATION23	Developer descriptive flexfield column.
PDS_INFORMATION24	Developer descriptive flexfield column.

Human Resources - PER_PERSON_ANALYSES	Special information types for a person.
Column Name	Descritpion
PERSON_ANALYSIS_ID	System-generated primary key 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.
ATTRIBUTE3	Descriptive flexfield column.
ATTRIBUTE4	Descriptive flexfield column.
ATTRIBUTE5	Descriptive flexfield column.
ATTRIBUTE6	Descriptive flexfield column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ATTRIBUTE7	Descriptive flexfield column.
ATTRIBUTE8	Descriptive flexfield column.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ANALYSIS_CRITERIA_ID	Foreign key to PER_ANALYSIS_CRITERIA.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
PERSON_ID	Foreign key to PER_ALL_PEOPLE_F.
OBJECT_VERSION_NUMBER	System generated version of row. Increments by one with each update.
PARTY_ID	Foreign Key to HZ_PARTIES.
COMMENTS	General remark.
DATE_FROM	Start date for the personal analysis information.
DATE_TO	End date for the personal analysis information.
ID_FLEX_NUM	Key flexfield structure foreign key (denormalized from PER_ANALYSIS_CRITERIA).
REQUEST_ID	Standard Who Column.

Human Resources - PER_PERSON_LIST	List of people that a secure user can access.
Column Name	Descritpion
PERSON_ID	Foreign key to PER_PEOPLE.
SECURITY_PROFILE_ID	Foreign key to PER_SECURITY_PROFILES.
GRANTED_USER_ID	Foreign key to FND_USER.
REQUEST_ID	Standard Who Column.
PROGRAM_UPDATE_DATE	Standard Who column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who Column.

Human Resources - PER_PERSON_LIST_CHANGES	List of people that are to be added to current PER_PERSON_LIST.
Column Name	Descritpion
PERSON_ID	Foreign key to PER_PEOPLE.
SECURITY_PROFILE_ID	Foreign key to PER_SECURITY_PROFILES.
INCLUDE_FLAG	Include person in person list Y/N.
TERMINATION_FLAG	Y if the person is in this list because they are terminated.
REQUEST_ID	Standard Who Column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who Column.
PROGRAM_UPDATE_DATE	Standard Who column.

Human Resources - PER_PERSON_TYPES	Person types visible to specific Business Groups.
Column Name	Descritpion
PERSON_TYPE_ID	Unique key generated from sequence PER_PERSON_TYPES_S.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
SEEDED_PERSON_TYPE_KEY	Seeded person type key
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ACTIVE_FLAG	Indicates whether the type is active[Y/N].
DEFAULT_FLAG	Indicates whether this USER_PERSON_TYPE is the default for the current SYSTEM_PERSON_TYPE [Y/N].
SYSTEM_PERSON_TYPE	System name for the person type.
USER_PERSON_TYPE	User name for the person type. You can have multiple user names for each system name.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.

Human Resources - PER_POSITION_DEFINITIONS	Combinations of segments stored in the PER_POSTIONS table.
Column Name	Descritpion
POSITION_DEFINITION_ID	System-generated primary key 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.
SEGMENT12	Key flexfield segment column.
SEGMENT13	Key flexfield segment column.
ID_FLEX_NUM	Key flexfield structure foreign key.
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.
SEGMENT22	Key flexfield segment column.
SEGMENT23	Key flexfield segment column.
SUMMARY_FLAG	Key flexfield summary flag.
SEGMENT24	Key flexfield segment column.
SEGMENT25	Key flexfield segment column.
SEGMENT26	Key flexfield segment column.
SEGMENT27	Key flexfield segment column.
SEGMENT28	Key flexfield segment column.
SEGMENT29	Key flexfield segment column.
SEGMENT30	Key flexfield segment column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
ENABLED_FLAG	Key flexfield enabled flag.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
START_DATE_ACTIVE	Date from which the key flexfield combination is valid.
END_DATE_ACTIVE	Date after which the key flexfield combination is invalid.
SEGMENT1	Key flexfield segment column.
SEGMENT2	Key flexfield segment column.
SEGMENT3	Key flexfield segment column.

Human Resources - PER_POSITION_LIST	List of positions that a secure user can access.
Column Name	Descritpion
POSITION_ID	Foreign key to PER_ALL_POSITIONS.
USER_ID
REQUEST_ID	Standard Who column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who column.
PROGRAM_UPDATE_DATE	Standard Who column.
SECURITY_PROFILE_ID	Foreign key to PER_SECURITY_PROFILES.

Human Resources - PER_POSITION_STRUCTURES	Position Hierarchy names.
Column Name	Descritpion
PRIMARY_POSITION_FLAG	Is this primary position hierarchy for the business group (Y/N).
OBJECT_VERSION_NUMBER	OBJECT_VERSION_NUMBER
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.
ATTRIBUTE3	Descriptive flexfield column.
ATTRIBUTE4	Descriptive flexfield column.
ATTRIBUTE5	Descriptive flexfield column.
ATTRIBUTE6	Descriptive flexfield column.
ATTRIBUTE7	Descriptive flexfield column.
ATTRIBUTE8	Descriptive flexfield column.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
POSITION_STRUCTURE_ID	System generated position structures primary key from PER_POSITION_STRUCTURES_S.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
NAME	Unique name of the position hierarchy.
COMMENTS	General remark.

Human Resources - PER_POS_STRUCTURE_ELEMENTS	Position hierarchy details showing parent-child reporting relationships between positions.
Column Name	Descritpion
POS_STRUCTURE_ELEMENT_ID	System generated position structure element primary key from PER_POS_STRUCTURE_ELEMENTS_S.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
POS_STRUCTURE_VERSION_ID	Foreign key to PER_POS_STRUCTURE_VERSIONS.
SUBORDINATE_POSITION_ID	Foreign key to PER_ALL_POSITIONS. Identifies the child position.
PARENT_POSITION_ID	Foreign key to PER_ALL_POSITIONS. Identifies the parent position.
REQUEST_ID	Standard Who Column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who Column.
PROGRAM_UPDATE_DATE	Standard Who column.

Human Resources - PER_POS_STRUCTURE_VERSIONS	Version control information for specific position hierarchies.
Column Name	Descritpion
POS_STRUCTURE_VERSION_ID	Primary key system generated from PER_POS_STRUCTURE_VERSIONS_S.
PROGRAM_ID	Standard Who Column.
PROGRAM_UPDATE_DATE	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
POSITION_STRUCTURE_ID	Foreign key to PER_POSITION_STRUCTURES.
OBJECT_VERSION_NUMBER	OBJECT VERSION NUMBER
DATE_FROM	Start date of this version .
VERSION_NUMBER	User enterable version number, not necessarily contiguous.
COPY_STRUCTURE_VERSION_ID	Foreign key to PER_POS_STRUCTURE_VERSIONS. Used if this version is copied from a previously existing structure .
DATE_TO	End date of this version.
REQUEST_ID	Standard Who Column.
PROGRAM_APPLICATION_ID	Standard Who column.

Human Resources - PER_QUICKPAINT_INVOCATIONS	Identifies QuickPaint report runs.
Column Name	Descritpion
QP_INVOCATION_ID	Primary key.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
QP_REPORT_ID	Foreign key to FF_QP_REPORTS.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
EFFECTIVE_DATE	Date the QuickPaint was run.
CREATION_DATE	Standard Who column.
INVOCATION_CONTEXT	Assignment or assignment set identifier.
QP_SESSION_ID	Unique identifier for the QuickPaint run results for this session.
INVOCATION_TYPE	Indicates whether the QuickPaint report is for an assignment or assignment set.

Human Resources - PER_QUICKPAINT_RESULT_TEXT	Text description for the result of a single QuickPaint run.
Column Name	Descritpion
QP_INVOCATION_ID	Foreign key to PER_QUICKPAINT_INVOCATIONS.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
ASSIGNMENT_ID	Foreign key to PER_ASSIGNMENTS.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LINE_NUMBER	Sequence number of the text line.
TEXT	Text for the report line.
LAST_UPDATE_DATE	Standard Who column.

Human Resources - PER_RECRUITMENT_ACTIVITIES	Recruitment activities and costs.
Column Name	Descritpion
INTERNAL_CONTACT_PERSON_ID	Foreign key to PER_ALL_PEOPLE_F, identifies the internal contact for the activity.
PARENT_RECRUITMENT_ACTIVITY_ID	Foreign key to PER_RECRUITMENT_ACTIVITIES for the activity containing this one.
CURRENCY_CODE	Foreign key to FND_CURRENCIES for planned and actual cost figures.
DATE_START	Date on which this recruitment activity starts.
NAME	Name of the recruitment activity.
ACTUAL_COST	Actual cost of the activity.
COMMENTS	General remark.
CONTACT_TELEPHONE_NUMBER	Telephone number for recruitment contact.
DATE_CLOSING	Closing date for responses to recruitment activity.
DATE_END	Recruitment activity end date (for example, last day of recruitment fair).
EXTERNAL_CONTACT	Name of external contact for the activity.
PLANNED_COST	Budgeted cost of the recruitment activity.
TYPE	User-defined type of recruitment activity, for example, advertisement.
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.
ATTRIBUTE3	Descriptive flexfield column.
ATTRIBUTE4	Descriptive flexfield column.
ATTRIBUTE5	Descriptive flexfield column.
ATTRIBUTE6	Descriptive flexfield column.
ATTRIBUTE7	Descriptive flexfield column.
ATTRIBUTE8	Descriptive flexfield column.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
RECRUITING_SITE_RESPONSE
POSTING_CONTENT_ID	FK to IRC_POSTING_CONTENT
STATUS	Lookup Code - Seeded with Unapproved, Approved, Rejected, Closed and Hold.
RECRUITMENT_ACTIVITY_ID	System-generated primary key column.
INTERNAL_POSTING	Specifies if the posting is suitable for viewing by internal applicants.
EXTERNAL_POSTING	Spcifies if the posting is suitable for viewing by external applicants.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
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.
AUTHORISING_PERSON_ID	Foreign key to PER_ALL_PEOPLE_F, identifies the person authorizing the activity.
RECRUITING_SITE_ID	Foreign Key to IRC_ALL_RECRUITING_SITES
RUN_BY_ORGANIZATION_ID	Foreign key to HR_ORGANIZATION_UNITS for the organization responsible for the activity.

Human Resources - PER_RECRUITMENT_ACTIVITY_FOR	Vacancies associated with a specific recruitment activity.
Column Name	Descritpion
RECRUITMENT_ACTIVITY_FOR_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.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
VACANCY_ID	Foreign key to PER_ALL_VACANCIES.
RECRUITMENT_ACTIVITY_ID	Foreign key to PER_RECRUITMENT_ACTIVITIES.
REQUEST_ID	Standard Who column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who column.
PROGRAM_UPDATE_DATE	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.

Human Resources - PER_REQUISITIONS	Vacancy requisition details.
Column Name	Descritpion
REQUISITION_ID	System-generated primary key 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.
ATTRIBUTE3	Descriptive flexfield column.
ATTRIBUTE4	Descriptive flexfield column.
ATTRIBUTE5	Descriptive flexfield column.
ATTRIBUTE6	Descriptive flexfield column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ATTRIBUTE7	Descriptive flexfield column.
ATTRIBUTE8	Descriptive flexfield column.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
PERSON_ID	Foreign key to PER_ALL_PEOPLE_F, identifies the person raising the requisition.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
DATE_FROM	Start date of the requisition.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
NAME	Requisition name.
COMMENTS	General remark.
DATE_TO	End date of the requisition.
DESCRIPTION	Requisition description.
REQUEST_ID	Standard Who column.

Human Resources - PER_SECONDARY_ASS_STATUSES	Secondary assignment statuses used for information and reporting.
Column Name	Descritpion
SECONDARY_ASS_STATUS_ID	System-generated primary key 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.
ATTRIBUTE3	Descriptive flexfield column.
ATTRIBUTE4	Descriptive flexfield column.
ATTRIBUTE5	Descriptive flexfield column.
ATTRIBUTE6	Descriptive flexfield column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ATTRIBUTE7	Descriptive flexfield column.
ATTRIBUTE8	Descriptive flexfield column.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ASSIGNMENT_ID	Foreign key to PER_ALL_ASSIGNMENTS_F.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
ASSIGNMENT_STATUS_TYPE_ID	Foreign key to PER_ASSIGNMENT_STATUS_TYPES.
START_DATE	Date on which the status takes effect.
COMMENTS	General remark.
END_DATE	Date after which the status no longer applies.
REASON	Reason for the status.
REQUEST_ID	Standard Who column.

Human Resources - PER_SPECIAL_INFO_TYPES	Special information types available to a Business Group.
Column Name	Descritpion
SPECIAL_INFORMATION_TYPE_ID	System-generated primary key column.
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.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ID_FLEX_NUM	Key flexfield structure foreign key.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
MULTIPLE_OCCURRENCES_FLAG	If null, treat as Y.
COMMENTS	General remark.
ENABLED_FLAG	Indicates if a special information type is enabled for the Business Group.
REQUEST_ID	Standard Who Column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who Column.
PROGRAM_UPDATE_DATE	Standard Who column.

Human Resources - PER_SPINAL_POINTS	List of progression points in a pay scale.
Column Name	Descritpion
SPINAL_POINT	The name or number of the progression point.
REQUEST_ID	Standard Who Column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who Column.
PROGRAM_UPDATE_DATE	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
OBJECT_VERSION_NUMBER
INFORMATION_CATEGORY	Developer Descriptive Flexfield structure defining column
INFORMATION1	Developer-Descriptive Flexfield Segment
INFORMATION2	Developer-Descriptive Flexfield Segment
INFORMATION3	Developer-Descriptive Flexfield Segment
INFORMATION4	Developer-Descriptive Flexfield Segment
INFORMATION5	Developer-Descriptive Flexfield Segment
INFORMATION6	Developer-Descriptive Flexfield Segment
INFORMATION7	Developer-Descriptive Flexfield Segment
INFORMATION8	Developer-Descriptive Flexfield Segment
INFORMATION9	Developer-Descriptive Flexfield Segment
INFORMATION10	Developer-Descriptive Flexfield Segment
INFORMATION11	Developer-Descriptive Flexfield Segment
INFORMATION12	Developer-Descriptive Flexfield Segment
INFORMATION13	Developer-Descriptive Flexfield Segment
INFORMATION14	Developer-Descriptive Flexfield Segment
INFORMATION15	Developer-Descriptive Flexfield Segment
INFORMATION16	Developer-Descriptive Flexfield Segment
INFORMATION17	Developer-Descriptive Flexfield Segment
INFORMATION18	Developer-Descriptive Flexfield Segment
INFORMATION19	Developer-Descriptive Flexfield Segment
INFORMATION20	Developer-Descriptive Flexfield Segment
INFORMATION21	Developer-Descriptive Flexfield Segment
INFORMATION22	Developer-Descriptive Flexfield Segment
INFORMATION23	Developer-Descriptive Flexfield Segment
INFORMATION24	Developer-Descriptive Flexfield Segment
INFORMATION25	Developer-Descriptive Flexfield Segment
INFORMATION26	Developer-Descriptive Flexfield Segment
INFORMATION27	Developer-Descriptive Flexfield Segment
INFORMATION28	Developer-Descriptive Flexfield Segment
INFORMATION29	Developer-Descriptive Flexfield Segment
INFORMATION30	Developer-Descriptive Flexfield Segment
SPINAL_POINT_ID	System-generated primary key column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
PARENT_SPINE_ID	Foreign key to PER_PARENT_SPINES.
SEQUENCE	The incremental order of this point within the pay scale.

Human Resources - PER_SPINAL_POINT_PLACEMENTS_F	Details of assignment placements to a grade step and point.
Column Name	Descritpion
PLACEMENT_ID	System-generated primary key column.
REQUEST_ID	Standard Who Column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who Column.
PROGRAM_UPDATE_DATE	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
EFFECTIVE_START_DATE	Effective start date.
INCREMENT_NUMBER	Number to incrment by in auto increment process.
OBJECT_VERSION_NUMBER	Object Version Number
EFFECTIVE_END_DATE	Effective end date.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
INFORMATION1	Developer Descriptive Flexfield
ASSIGNMENT_ID	Foreign key to PER_ALL_ASSIGNMENTS_F.
INFORMATION2	Developer Descriptive Flexfield
INFORMATION3	Developer Descriptive Flexfield
INFORMATION4	Developer Descriptive Flexfield
INFORMATION5	Developer Descriptive Flexfield
INFORMATION6	Developer Descriptive Flexfield
INFORMATION7	Developer Descriptive Flexfield
STEP_ID	Foreign key to PER_SPINAL_POINT_STEPS.
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
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
INFORMATION28	Developer Descriptive Flexfield
INFORMATION29	Developer Descriptive Flexfield
AUTO_INCREMENT_FLAG	Indicates whether the default batch process should update this placement automatically.
INFORMATION30	Developer Descriptive Flexfield
INFORMATION_CATEGORY	Developer Descriptive Flexfield
PARENT_SPINE_ID	Foreign key to PER_PARENT_SPINES.
REASON	Reason for placing the assignment on this point.

Human Resources - PER_SPINAL_POINT_STEPS_F	Grade steps defined in a specific grade scale and their incremental order.
Column Name	Descritpion
STEP_ID	System-generated primary key column.
PROGRAM_ID	Standard Who Column.
PROGRAM_UPDATE_DATE	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
EFFECTIVE_START_DATE	Effective start date.
EFFECTIVE_END_DATE	Effective end date.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
INFORMATION1	Developer Descriptive Flexfield
SPINAL_POINT_ID	Foreign key to PER_SPINAL_POINTS.
INFORMATION2	Developer Descriptive Flexfield
INFORMATION3	Developer Descriptive Flexfield
INFORMATION4	Developer Descriptive Flexfield
INFORMATION5	Developer Descriptive Flexfield
INFORMATION6	Developer Descriptive Flexfield
INFORMATION7	Developer Descriptive Flexfield
GRADE_SPINE_ID	Foreign key to PER_GRADE_SPINES.
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
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
INFORMATION28	Developer Descriptive Flexfield
INFORMATION29	Developer Descriptive Flexfield
SEQUENCE	Denormalised from progression points.
INFORMATION30	Developer Descriptive Flexfield
INFORMATION_CATEGORY	Developer Descriptive Flexfield
OBJECT_VERSION_NUMBER
REQUEST_ID	Standard Who Column.
PROGRAM_APPLICATION_ID	Standard Who column.

Human Resources - PER_TIME_PERIODS	Time period definitions for payroll processing and HR budget calendars.
Column Name	Descritpion
TIME_PERIOD_ID	System-generated primary key column.
DESCRIPTION	Description.
PAY_ADVICE_DATE	Default pay advice date for the period.
PERIOD_SET_NAME	Foreign key to PAY_CALENDARS.
PERIOD_YEAR	Calendar year that includes the end date of the period. (Optional for payroll).
PROC_PERIOD_TYPE	Processing period type. For example, calendar month, year, quarter. Values are taken from PROC_PERIOD_TYPE domain.
QUARTER_NUM	Legislative quarter number that includes end date of the period. (Optional for payroll).
QUICKPAY_DISPLAY_NUMBER	Number of QuickPay runs processed in the period.
REGULAR_PAYMENT_DATE	Default payment date for the period, also the default for the payroll run.
RUN_DISPLAY_NUMBER	Number of payroll runs processed in the period.
STATUS	Status of period - O(pen) or (C)losed for payroll processing. See domain PROCESSING_PERIOD_STATUS.
PAYROLL_ID	Foreign key to PAY_PAYROLLS.
YEAR_NUMBER	Number of the year in an HR budget calendar.
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.
END_DATE	End date for the period.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
PERIOD_NAME	Period name. Unique within a payroll or budget calendar.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
REGULAR_DATE_EARNED	Default date earned for the regular run for the period.
PRD_INFORMATION_CATEGORY	Developer descriptive flexfield column.
PRD_INFORMATION1	Developer descriptive flexfield column.
PERIOD_NUM	Sequence number of this time period in the year.
PRD_INFORMATION2	Developer descriptive flexfield column.
PRD_INFORMATION3	Developer descriptive flexfield column.
PRD_INFORMATION4	Developer descriptive flexfield column.
PRD_INFORMATION5	Developer descriptive flexfield column.
PRD_INFORMATION6	Developer descriptive flexfield column.
PRD_INFORMATION7	Developer descriptive flexfield column.
PRD_INFORMATION8	Developer descriptive flexfield column.
PRD_INFORMATION9	Developer descriptive flexfield column.
PRD_INFORMATION10	Developer descriptive flexfield column.
PRD_INFORMATION11	Developer descriptive flexfield column.
PERIOD_TYPE	Type of time period, for example, week, month, quarter, year.
PRD_INFORMATION12	Developer descriptive flexfield column.
PRD_INFORMATION13	Developer descriptive flexfield column.
PRD_INFORMATION14	Developer descriptive flexfield column.
PRD_INFORMATION15	Developer descriptive flexfield column.
PRD_INFORMATION16	Developer descriptive flexfield column.
PRD_INFORMATION17	Developer descriptive flexfield column.
PRD_INFORMATION18	Developer descriptive flexfield column.
PRD_INFORMATION19	Developer descriptive flexfield column.
PRD_INFORMATION20	Developer descriptive flexfield column.
PRD_INFORMATION21	Developer descriptive flexfield column.
START_DATE	Start date of the period.
PRD_INFORMATION22	Developer descriptive flexfield column.
PRD_INFORMATION23	Developer descriptive flexfield column.
PRD_INFORMATION24	Developer descriptive flexfield column.
PRD_INFORMATION25	Developer descriptive flexfield column.
PRD_INFORMATION26	Developer descriptive flexfield column.
PRD_INFORMATION27	Developer descriptive flexfield column.
PRD_INFORMATION28	Developer descriptive flexfield column.
PRD_INFORMATION29	Developer descriptive flexfield column.
PRD_INFORMATION30	Developer descriptive flexfield column.
CUT_OFF_DATE	Default cut-off date for the period.
DEFAULT_DD_DATE	Default direct deposit date for the period.

Human Resources - PER_TIME_PERIOD_RULES	Rules for time periods used by the system.
Column Name	Descritpion
NUMBER_PER_FISCAL_YEAR	Number of periods of this type within a fiscal year.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
BASIC_PERIOD_TYPE	The basic period type. For instance, Y (yearly) has a base period of CM (calendar monthly).
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
PERIODS_PER_PERIOD	Number of basic periods per processing period.
PROC_PERIOD_TYPE	Code used to represent this period type within the system.
LAST_UPDATE_DATE	Standard Who column.

Human Resources - PER_TIME_PERIOD_SETS	Specific dates for a defined calendar.
Column Name	Descritpion
START_DATE	Start date of the calendar year.
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.
ATTRIBUTE3	Descriptive flexfield column.
ATTRIBUTE4	Descriptive flexfield column.
ATTRIBUTE5	Descriptive flexfield column.
PERIOD_SET_NAME	Foreign key to PAY_CALENDARS.
ATTRIBUTE6	Descriptive flexfield column.
ATTRIBUTE7	Descriptive flexfield column.
ATTRIBUTE8	Descriptive flexfield column.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
PERIOD_TYPE	Foreign key to PER_TIME_PERIOD_TYPES.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
END_DATE_Q1	First quarter end date.
END_DATE_Q2	Second quarter end date.
END_DATE_Q3	Third quarter end date.
END_DATE_Q4	Fourth quarter end date.
MONTH_MID_DAY	The numerical day which sub-divides the month into two.
YEAR_NUMBER	Number of the Year in the Calendar.

Human Resources - PER_IMAGES	Images for a designated row in a designated table.
Column Name	Descritpion
IMAGE_ID	System generated unique identifier from PER_IMAGES_S.
IMAGE	The digitized image, held in TIFF, BMP, JFIF, PCX, PICT or other supported format.
PARENT_ID	Primary key of row for which image is held.
TABLE_NAME	Table holding row for which image is held.

Human Resources - PER_PAY_BASES	Definitions of specific salary bases.
Column Name	Descritpion
PAY_BASIS_ID	System-generated primary key column.
ANNUALIZED_HOURS	This column is obsolete.
INFORMATION11	Developer Descriptive Flexfield Column
INFORMATION12	Developer Descriptive Flexfield Column
INFORMATION13	Developer Descriptive Flexfield Column
INFORMATION14	Developer Descriptive Flexfield Column
PAY_ANNUALIZATION_FACTOR	This is the factor by which the salary must multiplied to get an annual salary.
INFORMATION15	Developer Descriptive Flexfield Column
INFORMATION16	Developer Descriptive Flexfield Column
INFORMATION17	Developer Descriptive Flexfield Column
INFORMATION18	Developer Descriptive Flexfield Column
GRADE_ANNUALIZATION_FACTOR	The factor by which the grade range must be multiplied to obtain an annual grade range.
INFORMATION19	Developer Descriptive Flexfield Column
INFORMATION20	Developer Descriptive Flexfield Column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
OBJECT_VERSION_NUMBER	Object Version Number used by HRMS for locking purposes
ATTRIBUTE1	Descriptive flexfield column.
ATTRIBUTE2	Descriptive flexfield column.
ATTRIBUTE3	Descriptive flexfield column.
ATTRIBUTE4	Descriptive flexfield column.
INPUT_VALUE_ID	Foreign key to PAY_INPUT_VALUES_F. Identifies the input value to use for salary administration under this basis.
ATTRIBUTE5	Descriptive flexfield column.
ATTRIBUTE6	Descriptive flexfield column.
ATTRIBUTE7	Descriptive flexfield column.
ATTRIBUTE8	Descriptive flexfield column.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
RATE_ID	Foreign key to PAY_RATES. Identifies the pay rate to use to validate salary values.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
CREATION_DATE	Standard Who column.
INFORMATION_CATEGORY	Developer Descriptive Flexfield Column
NAME	Name of the pay basis.
INFORMATION1	Developer Descriptive Flexfield Column
INFORMATION2	Developer Descriptive Flexfield Column
PAY_BASIS	Time basis for recording actual salary values, for example, annual, monthly, hourly.
INFORMATION3	Developer Descriptive Flexfield Column
INFORMATION4	Developer Descriptive Flexfield Column
COMMENTS	General remark.
INFORMATION5	Developer Descriptive Flexfield Column
INFORMATION6	Developer Descriptive Flexfield Column
RATE_BASIS	Time basis for the related grade rate values. Must be the same as PAY_BASIS.
INFORMATION7	Developer Descriptive Flexfield Column
INFORMATION8	Developer Descriptive Flexfield Column
INFORMATION9	Developer Descriptive Flexfield Column
INFORMATION10	Developer Descriptive Flexfield Column

Human Resources - PER_PAY_PROPOSALS	Salary proposals and performance review information for employee assignments.
Column Name	Descritpion
PAY_PROPOSAL_ID	System-generated primary key column.
NEXT_PERF_REVIEW_DATE	Obsolete after 11.0.1
NEXT_SAL_REVIEW_DATE	Date of the next salary review.
PERFORMANCE_RATING	Obsolete after 11.0.1
PROPOSAL_REASON	A reason from HR_LOOKUPS of type PROPOSAL_REASON.
PROPOSED_SALARY_N	Proposed salary in numberic format. Replaces PROPOSED_SALARY in 11.5.
REVIEW_DATE	Obsolete after 11.0.1
APPROVED	Indicates the proposal has been approved.
MULTIPLE_COMPONENTS	Indicates whether this pay proposal is comprised of multiple components.
FORCED_RANKING	Ranking
PERFORMANCE_REVIEW_ID	Foreign Key to PER_PERFORMANCE_REVIEWS
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.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
ATTRIBUTE6	Descriptive flexfield column.
ATTRIBUTE7	Descriptive flexfield column.
ATTRIBUTE8	Descriptive flexfield column.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ASSIGNMENT_ID	Foreign key to PER_ASSIGNMENTS.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
EVENT_ID	Obsolete after 11.0.1
PROPOSED_SALARY	Old Proposed salary for the assignment. Replaced by numeric representation PROPOSED_SALARY_N in 11.5
DATE_TO	End Date of the salary proposal.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
CHANGE_DATE	Date of the salary proposal.
COMMENTS	General remark.
LAST_CHANGE_DATE	The date of the last approved proposal .

Human Resources - PER_SCHED_COBRA_PAYMENTS	Payment schedules for benefits provided by a COBRA coverage.
Column Name	Descritpion
SCHEDULED_COBRA_PAYMENT_ID	Unique ID generated from sequence PER_SCHED_COBRA_PAYMENTS_S.
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.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
COBRA_COVERAGE_ENROLLMENT_ID	Foreign key to PER_COBRA_COV_ENROLLMENTS.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
AMOUNT_DUE	Amount charged for COBRA benefits.
DATE_DUE	Date by which payment must be received from COBRA enrollee.
AMOUNT_RECEIVED	Amount received for the COBRA benefits.
COMMENTS	Comments related to the payment schedule.
DATE_RECEIVED	Date when COBRA payment was received.
GRACE_DUE_DATE	An extended due date that indicates the grace period for receiving late payment without penalty.

Human Resources - PER_SPECIAL_INFO_TYPE_USAGES	Limits usage of special information types to specific windows.
Column Name	Descritpion
SPECIAL_INFO_CATEGORY	Special information type category.
SPECIAL_INFORMATION_TYPE_ID	Foreign key to PER_SPECIAL_INFO_TYPES.
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 - PER_MASS_MOVES	High level mass move definition.
Column Name	Descritpion
NEW_ORGANIZATION_ID	Foreign key of target organization to HR_ORGANIZATION_UNITS.
STATUS	System assigned status (e.g. Unprocessed, Complete, Complete with Warnings, In-Error).
REASON	Breif description or purpose of the mass move.
BATCH_RUN_NUMBER	Identifies the batch run.
MASS_MOVE_ID	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.
BUSINESS_GROUP_ID	Foreign key of business group to HR_ORGANIZATION_UNITS.
CREATION_DATE	Standard Who column.
EFFECTIVE_DATE	Date the mass move changes becomes effective.
OLD_ORGANIZATION_ID	Foreign key of source organization to HR_ORGANIZATION_UNITS.

Human Resources - PER_MM_POSITIONS	PER_MM_POSITIONS holds positions that were defined as part of a mass move.
Column Name	Descritpion
DEACTIVATE_OLD_POSITION	Flag indicating the source position will be end dated.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
SELECT_POSITION	Is the position selected as having assignments to be moved?
POSITION_MOVED	Flag indicating the position was successfully moved.
NEW_POSITION_ID	Foreign key of target position to PER_ALL_POSITIONS.
NEW_POSITION_DEFINITION_ID	Foreign key to PER_POSITION_DEFINITIONS of the desired target position definition.
MASS_MOVE_ID	Foreign key to PER_MASS_MOVES.
TARGET_JOB_ID	Foreign key of target job to PER_JOBS.
SEGMENT1	Key flexfield segment column.
SEGMENT2	Key flexfield segment column.
SEGMENT3	Key flexfield segment column.
SEGMENT4	Key flexfield segment column.
SEGMENT5	Key flexfield segment column.
SEGMENT6	Key flexfield segment column.
SEGMENT7	Key flexfield segment column.
SEGMENT8	Key flexfield segment column.
SEGMENT9	Key flexfield segment column.
POSITION_ID	Foreign key of source position to PER_ALL_POSITIONS.
SEGMENT10	Key flexfield segment column.
SEGMENT11	Key flexfield segment column.
SEGMENT12	Key flexfield segment column.
SEGMENT13	Key flexfield segment column.
SEGMENT14	Key flexfield segment column.
SEGMENT15	Key flexfield segment column.
SEGMENT16	Key flexfield segment column.
SEGMENT17	Key flexfield segment column.
SEGMENT18	Key flexfield segment column.
SEGMENT19	Key flexfield segment column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
SEGMENT20	Key flexfield segment column.
SEGMENT21	Key flexfield segment column.
SEGMENT22	Key flexfield segment column.
SEGMENT23	Key flexfield segment column.
SEGMENT24	Key flexfield segment column.
SEGMENT25	Key flexfield segment column.
SEGMENT26	Key flexfield segment column.
SEGMENT27	Key flexfield segment column.
SEGMENT28	Key flexfield segment column.
SEGMENT29	Key flexfield segment column.
DEFAULT_FROM	Where the standard conditions and location information will default from? Position, Organization, or Business Group.
SEGMENT30	Key flexfield segment column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.

Human Resources - PER_MM_ASSIGNMENTS	PER_MM_ASSIGNMENTS holds assignments that were defined as part of a mass move.
Column Name	Descritpion
DEFAULT_FROM	Where the standard conditions and location information will default from? Assignment, Position, Organization, or Business Group.
SELECT_ASSIGNMENT	Is the assignment selected to be moved to the target position?
ASSIGNMENT_MOVED	Identifies if the assignment has been moved.
GRADE_ID	Foreign key to PER_GRADES
TAX_UNIT_ID	Foreign key of GRE/Legal Entity.
MASS_MOVE_ID	Foreign key to PER_MASS_MOVES.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
ASSIGNMENT_ID	Foreign key to PER_ALL_ASSIGNMENTS_F.
CREATION_DATE	Standard Who column.
OBJECT_VERSION_NUMBER	Object Version Number of the assignment being moved as of table population.
POSITION_ID	Foreign key of source position to PER_ALL_POSITIONS.

Human Resources - PER_MM_VALID_GRADES	PER_MM_VALID_GRADES holds valid grades that will be moved with a position during a mass move.
Column Name	Descritpion
ATTRIBUTE1	Descriptive flexfield column.
ATTRIBUTE2	Descriptive flexfield column.
ATTRIBUTE3	Descriptive flexfield column.
ATTRIBUTE4	Descriptive flexfield column.
ATTRIBUTE5	Descriptive flexfield column.
MASS_MOVE_ID	Foreign key to PER_MASS_MOVES.
ATTRIBUTE6	Descriptive flexfield column.
ATTRIBUTE7	Descriptive flexfield column.
ATTRIBUTE8	Descriptive flexfield column.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
POSITION_ID	Foreign key of source position to PER_ALL_POSITIONS.
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.
TARGET_GRADE_ID	Foreign key to PER_GRADES.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.

Human Resources - PER_MM_JOB_REQUIREMENTS	PER_MM_JOB_REQUIREMENTS holds data related to transferring position requirements to a newly created position.
Column Name	Descritpion
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.
MASS_MOVE_ID	Foreign key to PER_MASS_MOVES.
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.
SEGMENT12	Key flexfield segment column.
SEGMENT13	Key flexfield segment column.
SEGMENT14	Key flexfield segment column.
SEGMENT15	Key flexfield segment column.
ANALYSIS_CRITERIA_ID	Foreignkey to PER_ANALYSIS_CRITERIA of the source job requirement.
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.
DELETE_FLAG	Flag indicating that the source job requirement will be end dated.
SEGMENT26	Key flexfield segment column.
SEGMENT27	Key flexfield segment column.
SEGMENT28	Key flexfield segment column.
SEGMENT29	Key flexfield segment column.
SEGMENT30	Key flexfield segment column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
NEW_ANALYSIS_CRITERIA_ID	Foreign key to PER_ANALYSIS_CRITERIA of the desired target job requirement.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.

Human Resources - PER_JOB_EXTRA_INFO	Extra information for a job.
Column Name	Descritpion
JOB_EXTRA_INFO_ID	System-generated primary key column.
JEI_INFORMATION22	Developer descriptive flexfield
JEI_INFORMATION23	Developer descriptive flexfield
JEI_INFORMATION24	Developer descriptive flexfield
JEI_INFORMATION25	Developer descriptive flexfield
JEI_INFORMATION26	Developer descriptive flexfield
JEI_INFORMATION27	Developer descriptive flexfield
JEI_INFORMATION28	Developer descriptive flexfield
JEI_INFORMATION29	Developer descriptive flexfield
JEI_INFORMATION30	Developer descriptive flexfield
REQUEST_ID	Standard who column
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
PROGRAM_APPLICATION_ID	standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
PROGRAM_ID	standard who column
PROGRAM_UPDATE_DATE	standard who column
JEI_ATTRIBUTE_CATEGORY	Descriptive flexfield
JEI_ATTRIBUTE1	Descriptive flexfield
JEI_ATTRIBUTE2	Descriptive flexfield
JEI_ATTRIBUTE3	Descriptive flexfield
JEI_ATTRIBUTE4	Descriptive flexfield
JEI_ATTRIBUTE5	Descriptive flexfield
JEI_ATTRIBUTE6	Descriptive flexfield
JEI_ATTRIBUTE7	Descriptive flexfield
JEI_ATTRIBUTE8	Descriptive flexfield
JEI_ATTRIBUTE9	Descriptive flexfield
INFORMATION_TYPE	Foriegn Key to PER_JOB_INFO_TYPES
JEI_ATTRIBUTE10	Descriptive flexfield
JEI_ATTRIBUTE11	Descriptive flexfield
JEI_ATTRIBUTE12	Descriptive flexfield
JEI_ATTRIBUTE13	Descriptive flexfield
JEI_ATTRIBUTE14	Descriptive flexfield
JEI_ATTRIBUTE15	Descriptive flexfield
JEI_ATTRIBUTE16	Descriptive flexfield
JEI_ATTRIBUTE17	Descriptive flexfield
JEI_ATTRIBUTE18	Descriptive flexfield
JEI_ATTRIBUTE19	Descriptive flexfield
JOB_ID	Foriegn Key to PER_JOBS
JEI_ATTRIBUTE20	Descriptive flexfield
JEI_INFORMATION_CATEGORY	Developer descriptive flexfield
JEI_INFORMATION1	Developer descriptive flexfield
JEI_INFORMATION2	Developer descriptive flexfield
JEI_INFORMATION3	Developer descriptive flexfield
JEI_INFORMATION4	Developer descriptive flexfield
JEI_INFORMATION5	Developer descriptive flexfield
JEI_INFORMATION6	Developer descriptive flexfield
JEI_INFORMATION7	Developer descriptive flexfield
JEI_INFORMATION8	Developer descriptive flexfield
JEI_INFORMATION9	Developer descriptive flexfield
JEI_INFORMATION10	Developer descriptive flexfield
JEI_INFORMATION11	Developer descriptive flexfield
JEI_INFORMATION12	Developer descriptive flexfield
JEI_INFORMATION13	Developer descriptive flexfield
JEI_INFORMATION14	Developer descriptive flexfield
JEI_INFORMATION15	Developer descriptive flexfield
JEI_INFORMATION16	Developer descriptive flexfield
JEI_INFORMATION17	Developer descriptive flexfield
JEI_INFORMATION18	Developer descriptive flexfield
JEI_INFORMATION19	Developer descriptive flexfield
JEI_INFORMATION20	Developer descriptive flexfield
JEI_INFORMATION21	Developer descriptive flexfield

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

Human Resources - PER_PEOPLE_EXTRA_INFO	Extra information for a person.
Column Name	Descritpion
PEI_INFORMATION8	Developer descriptive flexfield
PEI_INFORMATION9	Developer descriptive flexfield
PEI_INFORMATION10	Developer descriptive flexfield
PEI_INFORMATION11	Developer descriptive flexfield
PEI_INFORMATION12	Developer descriptive flexfield
PEI_INFORMATION13	Developer descriptive flexfield
PEI_INFORMATION14	Developer descriptive flexfield
PEI_INFORMATION15	Developer descriptive flexfield
PEI_INFORMATION16	Developer descriptive flexfield
PEI_INFORMATION17	Developer descriptive flexfield
PEI_INFORMATION18	Developer descriptive flexfield
PEI_INFORMATION19	Developer descriptive flexfield
PEI_INFORMATION20	Developer descriptive flexfield
PEI_INFORMATION21	Developer descriptive flexfield
PEI_INFORMATION22	Developer descriptive flexfield
PEI_INFORMATION23	Developer descriptive flexfield
PEI_INFORMATION24	Developer descriptive flexfield
PEI_INFORMATION25	Developer descriptive flexfield
PEI_INFORMATION26	Developer descriptive flexfield
PEI_INFORMATION27	Developer descriptive flexfield
PEI_INFORMATION28	Developer descriptive flexfield
PEI_INFORMATION29	Developer descriptive flexfield
PEI_INFORMATION30	Developer descriptive flexfield
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
PARTY_ID	Foreign Key to HZ_PARTIES.
REQUEST_ID	Standard who column
PROGRAM_APPLICATION_ID	standard who column
PROGRAM_ID	standard who column
PROGRAM_UPDATE_DATE	standard who column
PEI_ATTRIBUTE_CATEGORY	Descriptive flexfield
PEI_ATTRIBUTE1	Descriptive flexfield
PEI_ATTRIBUTE2	Descriptive flexfield
PEI_ATTRIBUTE3	Descriptive flexfield
PEI_ATTRIBUTE4	Descriptive flexfield
PEI_ATTRIBUTE5	Descriptive flexfield
PERSON_EXTRA_INFO_ID	System-generated primary key column.
PEI_ATTRIBUTE6	Descriptive flexfield
PEI_ATTRIBUTE7	Descriptive flexfield
PEI_ATTRIBUTE8	Descriptive flexfield
PEI_ATTRIBUTE9	Descriptive flexfield
PEI_ATTRIBUTE10	Descriptive flexfield
PEI_ATTRIBUTE11	Descriptive flexfield
PEI_ATTRIBUTE12	Descriptive flexfield
PEI_ATTRIBUTE13	Descriptive flexfield
PEI_ATTRIBUTE14	Descriptive flexfield
PEI_ATTRIBUTE15	Descriptive flexfield
PEI_ATTRIBUTE16	Descriptive flexfield
PEI_ATTRIBUTE17	Descriptive flexfield
PEI_ATTRIBUTE18	Descriptive flexfield
PEI_ATTRIBUTE19	Descriptive flexfield
PEI_ATTRIBUTE20	Descriptive flexfield
PERSON_ID	Foriegn Key to PER_ALL_PEOPLE_F
PEI_INFORMATION_CATEGORY	Developer descriptive flexfield
PEI_INFORMATION1	Developer descriptive flexfield
PEI_INFORMATION2	Developer descriptive flexfield
INFORMATION_TYPE	Foreign Key to PER_PEOPLE_INFO_TYPES
PEI_INFORMATION3	Developer descriptive flexfield
PEI_INFORMATION4	Developer descriptive flexfield
PEI_INFORMATION5	Developer descriptive flexfield
PEI_INFORMATION6	Developer descriptive flexfield
PEI_INFORMATION7	Developer descriptive flexfield

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

Human Resources - PER_POSITION_EXTRA_INFO	Extra information for a position.
Column Name	Descritpion
INFORMATION_TYPE	Foriegn Key to PER_POSITION_INFO_TYPES
POEI_INFORMATION2	Developer descriptive flexfield
POEI_INFORMATION3	Developer descriptive flexfield
POEI_INFORMATION4	Developer descriptive flexfield
POEI_INFORMATION5	Developer descriptive flexfield
POEI_INFORMATION6	Developer descriptive flexfield
POEI_INFORMATION7	Developer descriptive flexfield
POEI_INFORMATION8	Developer descriptive flexfield
POEI_INFORMATION9	Developer descriptive flexfield
POEI_INFORMATION10	Developer descriptive flexfield
POEI_INFORMATION11	Developer descriptive flexfield
POEI_INFORMATION12	Developer descriptive flexfield
POEI_INFORMATION13	Developer descriptive flexfield
POEI_INFORMATION14	Developer descriptive flexfield
POEI_INFORMATION15	Developer descriptive flexfield
POEI_INFORMATION16	Developer descriptive flexfield
POEI_INFORMATION17	Developer descriptive flexfield
POEI_INFORMATION18	Developer descriptive flexfield
POEI_INFORMATION19	Developer descriptive flexfield
POEI_INFORMATION20	Developer descriptive flexfield
POEI_INFORMATION21	Developer descriptive flexfield
POEI_INFORMATION22	Developer descriptive flexfield
POEI_INFORMATION23	Developer descriptive flexfield
POEI_INFORMATION24	Developer descriptive flexfield
POEI_INFORMATION25	Developer descriptive flexfield
POEI_INFORMATION26	Developer descriptive flexfield
POEI_INFORMATION27	Developer descriptive flexfield
POEI_INFORMATION28	Developer descriptive flexfield
POEI_INFORMATION29	Developer descriptive flexfield
POEI_INFORMATION30	Developer descriptive flexfield
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
POSITION_EXTRA_INFO_ID	System-generated primary key column.
REQUEST_ID	Standard who column
PROGRAM_APPLICATION_ID	standard who column
PROGRAM_ID	standard who column
PROGRAM_UPDATE_DATE	standard who column
POEI_ATTRIBUTE_CATEGORY	Descriptive flexfield
POEI_ATTRIBUTE1	Descriptive flexfield
POEI_ATTRIBUTE2	Descriptive flexfield
POEI_ATTRIBUTE3	Descriptive flexfield
POEI_ATTRIBUTE4	Descriptive flexfield
POEI_ATTRIBUTE5	Descriptive flexfield
POEI_ATTRIBUTE6	Descriptive flexfield
POEI_ATTRIBUTE7	Descriptive flexfield
POEI_ATTRIBUTE8	Descriptive flexfield
POEI_ATTRIBUTE9	Descriptive flexfield
POEI_ATTRIBUTE10	Descriptive flexfield
POEI_ATTRIBUTE11	Descriptive flexfield
POEI_ATTRIBUTE12	Descriptive flexfield
POSITION_ID	Foriegn Key to PER_ALL_POSITIONS
POEI_ATTRIBUTE13	Descriptive flexfield
POEI_ATTRIBUTE14	Descriptive flexfield
POEI_ATTRIBUTE15	Descriptive flexfield
POEI_ATTRIBUTE16	Descriptive flexfield
POEI_ATTRIBUTE17	Descriptive flexfield
POEI_ATTRIBUTE18	Descriptive flexfield
POEI_ATTRIBUTE19	Descriptive flexfield
POEI_ATTRIBUTE20	Descriptive flexfield
POEI_INFORMATION_CATEGORY	Developer descriptive flexfield
POEI_INFORMATION1	Developer descriptive flexfield

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

Human Resources - PER_PHONES	PER_PHONES holds phone numbers for current and ex-employees, current and ex-applicants and employee contacts.
Column Name	Descritpion
PHONE_ID	Primary Key
VALIDITY	Valid times that this phone number can be used.
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.
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.
ATTRIBUTE22	Descriptive flexfield column.
ATTRIBUTE23	Descriptive flexfield column.
ATTRIBUTE24	Descriptive flexfield column.
DATE_FROM	Date the phone number becomes effective.
ATTRIBUTE25	Descriptive flexfield column.
ATTRIBUTE26	Descriptive flexfield column.
ATTRIBUTE27	Descriptive flexfield column.
ATTRIBUTE28	Descriptive flexfield column.
ATTRIBUTE29	Descriptive flexfield column.
ATTRIBUTE30	Descriptive flexfield column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
DATE_TO	Date the phone number is no longer effective.
LAST_UPDATE_LOGIN	Standard Who column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
PARTY_ID	Foreign Key to HZ_PARTIES
PHONE_TYPE	Foreign Key to HR_LOOKUPS with type = 'PHONE_TYPE';
PHONE_NUMBER	Telephone Number in any format.
PARENT_ID	Combination of this field and PARENT_TABLE define a dynamic foreign key.
PARENT_TABLE	Combination of this field and PARENT_ID define a dynamic foreign key. This contains the exact table name (e.g. PER_ALL_PEOPLE_F) to which the PARENT_ID points.

Human Resources - PER_PROPOSAL_TEMPLATES	- Retrofitted
Column Name	Descritpion
TYPE	The type of proposal.
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
PROPOSAL_TEMPLATE_ID	System-generated primary key column.
PROPOSAL_NAME	Name of the Candidate Offer Template or Profile. This is what the hiring manager sees in her select list.
DESCRIPTION	An optional description of the Candidate Offer Profille or Template.

Human Resources - PER_PROPOSAL_CATEGORY_MEMBERS	Web Offers profile categories of questions
Column Name	Descritpion
PROPOSAL_CATEGORY_MEMBER_ID	System-generated primary key column.
TYPE	Identifies theCategory Member as being for either a Candidate Offer or an Appraisal Questionnaire
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who columns
LAST_UPDATE_LOGIN	Standard who column
CREATION_DATE	Standard who column
PROPOSAL_CATEGORY_TYPE_ID	Foreign key to PER_PROPOSAL_CATEGORY_TYPES.
CREATED_BY	Standard who column
PROPOSAL_TEMPLATE_ID	Foreign key to PER_PROPOSAL_TEMPLATES.
PARENT_CATEGORY_TYPE_ID	Foreign key to PER_PROPOSAL_CATEGORY_MEMBERS. This column is named incorrectly.
CATEGORY_DISPLAY_ORDER	The order the cateogies within a parent category will display on the Web Offers page.
PARENT_DISPLAY_ORDER	The order that the categories will display on the Web Offer page.
DISPLAY_CATEGORY_HEADER	If the category has a header defined in PER_PROPOSAL_CATEGORY_TYPES, indicate if the header should display on the Web Offer page.

Human Resources - PER_PROPOSAL_CATEGORY_TYPES	Generic web offer category definitions
Column Name	Descritpion
TYPE	Identifies the Category Type as being for either a Candidate Offer or an Appraisal Questionnaire
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
PROPOSAL_CATEGORY_TYPE_ID	System-generated primary key column.
CATEGORY_NAME	A unique name for the category. This is what displays to the hiring manger on the web offers page.
HEADING_TEXT	A category can have a heading that displays above the cateogry name on the web offers page. You can indicate in PER_PROPOSAL_CATEGORY_MEMBERS if the heading should display for a specific profile or template.
NOTE_TEXT	If this field is filled in, the category will have field-level help attached to it on the web offers page.
FOOTER_TEXT	Not used at this time.
HELP_TEXT	Not used at this time.

Human Resources - PER_PROPOSAL_OFFER_PARAGRAPHS	Web Offer letter text
Column Name	Descritpion
PARAGRAPH_NO	A unique key column.
LAST_UPDATE_LOGIN	Standard who column
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
BODY_TEXT	The text of a specific paragraph that will be displayed on the Candidate Offer letter when it is generated.
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column

Human Resources - PER_PROPOSAL_QUESTION_MEMBERS	Web offer profile questions
Column Name	Descritpion
PROPOSAL_QUESTION_MEMBER_ID	System-generated primary key column.
DEFAULT_VALUE_TYPE	Is the default value for the field based on SQL or a specific value. Overrides any value in PER_PROPOSAL_QUESTION_TYPES.
DEFAULT_VALUE	The default value for the question that the hiring manger will see on the web offers page. Overrides any value in PER_PROPOSAL_QUESTION_TYPES.
LOOKUP_TYPE	If the question is a combo list or radio button, this causes the values available to come from a specific lookup type. Overrides any value in PER_PROPOSAL_QUESTION_TYPES.
OPTION_SQL_TEXT	If the question is a combo list or radio button, this causes the values available to come from running the specified SQL statement. Overrides any value in PER_PROPOSAL_QUESTION_TYPES.
PROVIDE_FIND	If the question requires a list of values, this field should be 'Y'. Overrides any value in PER_PROPOSAL_QUESTION_TYPES.
FIND_FILTER_COLUMN	If the question requires a list of values, this field indicates what column in the FIND_SELECT_SQL should be written back to this question's answer value. Overrides any value in PER_PROPOSAL_QUESTION_TYPES.
FIND_SELECT_SQL	If the question requires a list of values, this field contains the SQL to run the list of values. Overrides any value in PER_PROPOSAL_QUESTION_TYPES.
QUESTION_DISPLAY_ORDER	The order this question should appear on the Web Offers page in relation to the other questions within the same category. Overrides any value in PER_PROPOSAL_QUESTION_TYPES.
PROPOSAL_QUESTION_NAME	Foreign key to PER_PROPOSAL_QUESTION_TYPES.
TYPE	Identifies the Question Member as being for either a Candidate Offer or an Appraisal Questionnaire
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who columns
LAST_UPDATE_LOGIN	Standard who column
CREATION_DATE	Standard who column
PROPOSAL_CATEGORY_MEMBER_ID	Foreign key to PER_PROPOSAL_CATEGORY_MEMBERS.
CREATED_BY	Standard who column
APPROVAL_DISPLAY_STATUS	The value of this column determines if the approval mgr will see the question and answer always, only if the hiring manger entered a value for the question or only on the 'details' page.
FULL_TEXT	The label for the question that the hiring manger will see on the web offers page. Overrides any value in PER_PROPOSAL_QUESTION_TYPES.
ALIGN	The alignment for the the question that the hiring manger will see on the web offers page. Overrides any value in PER_PROPOSAL_QUESTION_TYPES.
QUESTION_HEADER	A label that displays above the question label. Overrides any value in PER_PROPOSAL_QUESTION_TYPES.
HELP_TEXT	Not used at this time.
NOTE_TEXT	Placing a value here causes the question to have field level help on the web offers page. Overrides any value in PER_PROPOSAL_QUESTION_TYPES, unless this value is null and the Types table has a value.

Human Resources - PER_PROPOSAL_QUESTION_TYPES	Generic web offer questions
Column Name	Descritpion
PROPOSAL_QUESTION_NAME	The primary key column.
MAXLENGTH	The maximum number of characters allowed for entry.
DEFAULT_VALUE_TYPE	Is the default value for the field based on SQL or a specific value.
DEFAULT_VALUE	The default value for the question that the hiring manger will see on the web offers page.
LOOKUP_TYPE	If the question is a combo list or radio button, this causes the values available to come from a specific lookup type.
OPTION_SQL_TEXT	If the question is a combo list or radio button, this causes the values available to come from running the specified SQL statement.
PROVIDE_FIND	If the question requires a list of values, this field should be 'Y'.
FIND_FILTER_COLUMN	If the question requires a list of values, this field indicates what column in the FIND_SELECT_SQL should be written back to this question's answer value.
FIND_SELECT_SQL	If the question requires a list of values, this field contains the SQL to run the list of values.
FULL_TEXT	The label for the question that the hiring manger will see on the web offers page.
TYPE	Identifies the Question Type as being for either a Candidate Offer or an Appraisal Questionnaire
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column
CREATION_DATE	Standard who column
ALIGN	The alignment for the the question that the hiring manger will see on the web offers page.
CREATED_BY	Standard who column
QUESTION_HEADER	A label that displays above the question label.
HELP_TEXT	Not used at this time.
NOTE_TEXT	Placing a value here causes the question to have field level help on the web offers page.
HTML_TYPE	Determines the HTML style of field that this question uses on the web offers page.
WIDTH_SIZE	Determines how wide the question entry area will be on the web offer page.
HEIGHT_SIZE	For HTML styles that take a 'height' parameter, this defines how large the field will display.

Human Resources - PER_RATING_SCALES	A scale used to rate compentencies.
Column Name	Descritpion
RATING_SCALE_ID	Primary Key for PER_RATING_SCALES
TYPE	The type of Rating Scale e.g. Performance, Proficiency, Weighting
DESCRIPTION	The description of the rating scale
DEFAULT_FLAG	An indication that the rating scale is the preferred scale in the absence of another specifically chosen scale.
MAX_SCALE_STEP	The maximum rating level within this rating scale
MIN_SCALE_STEP	The minimum level in use within this rating scale
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.
BUSINESS_GROUP_ID	Foreign Key to HR_ORGANIZATION_UNITS
ATTRIBUTE6	Descriptive flexfield column.
ATTRIBUTE7	Descriptive flexfield column.
ATTRIBUTE8	Descriptive flexfield column.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
OBJECT_VERSION_NUMBER	Object Version Number
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
NAME	The name of the rating scale

Human Resources - PER_RATING_LEVELS	A rating scale step is a single point on a rating scale and is used to rate competences.
Column Name	Descritpion
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.
STEP_VALUE	The sequence number of the rating scale used for ordering the steps
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 columns.
LAST_UPDATED_BY	Standard Who columns.
LAST_UPDATE_LOGIN	Standard Who columns.
CREATED_BY	Standard Who columns.
CREATION_DATE	Standard Who columns.
NAME	A description of the rating level that the step indicates e.g. Poor, Average, Excellent
RATING_SCALE_ID	The rating level for the Rating Scale
COMPETENCE_ID	The rating level for the Competence
BEHAVIOURAL_INDICATOR	A description of the behavioural charactaristics that would typically be displayed when the competence is possessed at this level
RATING_LEVEL_ID	Unique identifier of the Rating Level
BUSINESS_GROUP_ID	Foreign Key to HR_ORGANIZATION_UNITS
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.

Human Resources - PER_QUALIFICATION_TYPES	Maintains the list of qualiification types that can be attained.
Column Name	Descritpion
QUALIFICATION_TYPE_ID	PK of entity
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
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.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who Column.
LAST_UPDATED_BY	Standard Who Column.
LAST_UPDATE_LOGIN	Standard Who Column.
CREATED_BY	Standard Who Column.
CREATION_DATE	Standard Who Column.
NAME	Holds name of qualification type.
CATEGORY	A grouping or categorization of the qualification type.
INFORMATION1	Developer Descriptive Flexfield
RANK	Holds the rank of the qualification
INFORMATION2	Developer Descriptive Flexfield
INFORMATION3	Developer Descriptive Flexfield
INFORMATION4	Developer Descriptive Flexfield
INFORMATION5	Developer Descriptive Flexfield
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
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
INFORMATION28	Developer Descriptive Flexfield
INFORMATION29	Developer Descriptive Flexfield
INFORMATION30	Developer Descriptive Flexfield
INFORMATION_CATEGORY	Developer Descriptive Flexfield
QUAL_FRAMEWORK_ID	Unit Standard Framework Qualification Id
QUALIFICATION_TYPE	Unit Standard Framework Qualification Type
CREDIT_TYPE	Unit Standard Framework Credit Type
CREDITS	Unist Standard Framework Credits
LEVEL_TYPE	Unit Standard Framework Level Type
LEVEL_NUMBER	Unit Standard Framework Level
FIELD	Unit Standard Framework Field
SUB_FIELD	Unit Standard Framework Sub Field
PROVIDER	Unit Standard Framework Provider
QA_ORGANIZATION	Unit Standard Framework QA Organization

Human Resources - PER_QUALIFICATIONS	A record of educational qualification, certificates, licenses, etc that a person holds or is acquiring.
Column Name	Descritpion
QUALIFICATION_ID	PK of entity
STATUS	Used to indicate what status the qualification is at.
AWARDED_DATE	Holds date the qualification was awarded e.g. the date the result
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.
FEE	Stores the total amount of tuition fees for the qualification
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
FEE_CURRENCY	Holds the currency in which the tuition fees were paid
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
QUA_INFORMATION_CATEGORY	Developer descriptive flexfield structure defining column.
TRAINING_COMPLETED_AMOUNT	Used to hold an amount of training completed, this refers to the
QUA_INFORMATION1	Developer descriptive flexfield column.
QUA_INFORMATION2	Descriptive flexfield column.
REIMBURSEMENT_ARRANGEMENTS	Used to store all reimbursement coindtion information.
QUA_INFORMATION3	Descriptive flexfield column.
QUA_INFORMATION4	Descriptive flexfield column.
TRAINING_COMPLETED_UNITS	Holds the unit of measure for training completed
QUA_INFORMATION5	Descriptive flexfield column.
QUA_INFORMATION6	Descriptive flexfield column.
TOTAL_TRAINING_AMOUNT	Number of occurences of the training_unit in order to complete th
QUA_INFORMATION7	Descriptive flexfield column.
QUA_INFORMATION8	Descriptive flexfield column.
START_DATE	Holds date the qualification was started
QUA_INFORMATION9	Descriptive flexfield column.
QUA_INFORMATION10	Descriptive flexfield column.
END_DATE	Holds the date the qualification was ended
QUA_INFORMATION11	Descriptive flexfield column.
QUA_INFORMATION12	Descriptive flexfield column.
LICENSE_NUMBER	Holds license number of attained qualification.
QUA_INFORMATION13	Descriptive flexfield column.
QUA_INFORMATION14	Descriptive flexfield column.
EXPIRY_DATE	Holds date of license expiration.
QUA_INFORMATION15	Descriptive flexfield column.
QUA_INFORMATION16	Descriptive flexfield column.
LICENSE_RESTRICTIONS	Holds the license arrangements
QUA_INFORMATION17	Descriptive flexfield column.
QUA_INFORMATION18	Descriptive flexfield column.
PROJECTED_COMPLETION_DATE	Holds the date when the qualification is expected to be completed
QUA_INFORMATION19	Descriptive flexfield column.
QUA_INFORMATION20	Descriptive flexfield column.
PARTY_ID	Foreign key to hz_parties.
LAST_UPDATE_DATE	Standard Who Column.
AWARDING_BODY	Holds awarding body
LAST_UPDATED_BY	Standard Who Column.
LAST_UPDATE_LOGIN	Standard Who Column.
CREATED_BY	Standard Who Column.
CREATION_DATE	Standard Who Column.
TUITION_METHOD	Holds tuition method used to attain the qualification
GROUP_RANKING	Holds group ranking of how person performed.
COMMENTS	Used to hold comments.
BUSINESS_GROUP_ID	Foreign Key to HR_ORGANIZATION_UNITS
QUALIFICATION_TYPE_ID	PK of entity
ATTENDANCE_ID	PK of entity
PROFESSIONAL_BODY_NAME	Name of professional body belonged to.
MEMBERSHIP_NUMBER	Membership number for professional body belonged to
MEMBERSHIP_CATEGORY	Category of membership of professional body belonged to
SUBSCRIPTION_PAYMENT_METHOD	Method of payment of subscription charge for professional body belonged to.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
PERSON_ID	Maintains person who hold qualification.
TITLE	Maintains the qualification title e.g. Computing with Business, e
GRADE_ATTAINED	Maintains the grade that was attained for the qualification.

Human Resources - PER_SUBJECTS_TAKEN	Holds a record of a person's subject usages for a qualification
Column Name	Descritpion
SUBJECTS_TAKEN_ID	Pk of entity
QUALIFICATION_ID	PK of entity
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
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.
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.
SUB_INFORMATION_CATEGORY	Developer descriptive flexfield structure defining column.
SUB_INFORMATION1	Developer descriptive flexfield column.
SUB_INFORMATION2	Developer descriptive flexfield column.
SUB_INFORMATION3	Developer descriptive flexfield column.
SUB_INFORMATION4	Developer descriptive flexfield column.
SUB_INFORMATION5	Developer descriptive flexfield column.
SUB_INFORMATION6	Developer descriptive flexfield column.
SUB_INFORMATION7	Developer descriptive flexfield column.
SUB_INFORMATION8	Developer descriptive flexfield column.
SUB_INFORMATION9	Developer descriptive flexfield column.
SUB_INFORMATION10	Developer descriptive flexfield column.
SUB_INFORMATION11	Developer descriptive flexfield column.
SUB_INFORMATION12	Developer descriptive flexfield column.
SUB_INFORMATION13	Developer descriptive flexfield column.
START_DATE	Holds start date of subject
SUB_INFORMATION14	Developer descriptive flexfield column.
SUB_INFORMATION15	Developer descriptive flexfield column.
SUB_INFORMATION16	Developer descriptive flexfield column.
SUB_INFORMATION17	Developer descriptive flexfield column.
SUB_INFORMATION18	Developer descriptive flexfield column.
SUB_INFORMATION19	Developer descriptive flexfield column.
SUB_INFORMATION20	Developer descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who Column.
LAST_UPDATED_BY	Standard Who Column.
LAST_UPDATE_LOGIN	Standard Who Column.
CREATED_BY	Standard Who Column.
CREATION_DATE	Standard Who Column.
MAJOR	Stores whether it is a primary or non-primary subject.
SUBJECT_STATUS	Stores whether the subject was passed or failed
SUBJECT	Holds subject name
GRADE_ATTAINED	Stores the grade_attained for a subject
END_DATE	Holds end date of subject

Human Resources - PER_INFO_TYPE_SECURITY	Cross table between Responsibilty and Info_type tables, used to secure info types based on responsibility.
Column Name	Descritpion
INFORMATION_TYPE	Foriegn key to INFO_TYPE_TABLE_NAME
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
PER_INFO_TYPE_SECURITY_ID	System generated primary key.
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
APPLICATION_ID	Foreign key to FND_RESPONSIBILITY
RESPONSIBILITY_ID	Foreign Key to FND_RESPONSIBILITY
INFO_TYPE_TABLE_NAME	Name of Info Type Table, used to join to info type table

Human Resources - PER_PROPOSAL_QUESTIONS_ADV	Web Offer advanced questions
Column Name	Descritpion
PROPOSAL_QUESTION_ADV_ID
TYPE
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who columns
LAST_UPDATE_LOGIN	Standard who column
CREATION_DATE	Standard who column
PROPOSAL_QUESTION_MEMBER_ID
CREATED_BY	Standard who column
REQUIRED_QUESTION_MEMBER_ID
EXCLUSIVE_QUESTION_MEMBER_ID
REQUIRED
DATA_TYPE
ENABLE_VALIDATION

Human Resources - PER_SUCCESSION_PLANNING	The record of a person's proposed succession to a position.
Column Name	Descritpion
TIME_SCALE	Lookup to PER_TIME_SCALES
OBJECT_VERSION_NUMBER	Object version number is used to identfiy whether a user is looking at the latest record.
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.
END_DATE	The end date of the succession plan
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
AVAILABLE_FOR_PROMOTION	Indicates whether a person is due for promotion
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who Column.
LAST_UPDATED_BY	Standard Who Column.
LAST_UPDATE_LOGIN	Standard Who Column.
CREATED_BY	Standard Who Column.
CREATION_DATE	Standard Who Column.
MANAGER_COMMENTS	Comments added by a manager.
SUCCESSION_PLAN_ID	PK for PER_SUCCESSION_PLANNING table.
PERSON_ID	Foreign key to PER_ALL_PEOPLE_F table, can not be included as a foreign key due to datetrack of person table.
POSITION_ID	FK to PER_ALL_POSITIONS table.
BUSINESS_GROUP_ID	This attribute must relate to a value in the hr_organization_units table.
START_DATE	The start date of the succession plan entry

Human Resources - PER_OBJECTIVES	A target or goal which may be evaluated during an appraisal.
Column Name	Descritpion
NAME	The title of of the objective
TARGET_DATE	The date on which the objective is targetteg to be achieved
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.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
START_DATE	Start date of the objective
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
ATTRIBUTE21	Descriptive flexfield column.
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.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
SCORECARD_ID	The personal scorecard to which the objective belongs.
COPIED_FROM_LIBRARY_ID	When this objective is created by eligibility, this is the ID of the library objective from which it was copied.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
COPIED_FROM_OBJECTIVE_ID	When this objective is copied from another, this is the ID of the objective from which it was copied.
NEXT_REVIEW_DATE	Informational-only date to indicate when the objective should next be reviewed.
GROUP_CODE	Uses the lookup type HR_WPM_GROUP to categorize objectives.
PRIORITY_CODE	Uses the lookup type HR_WPM_PRIORITY to provide a default priority.
APPRAISE_FLAG	Uses the lookup type YES_NO to provide a default for whether this objective should be appraised.
WEIGHTING_PERCENT	Provides a default weighting for this objective, used to score overall appraisal ratings.
COMPLETE_PERCENT	The percentage complete.
MEASUREMENT_STYLE_CODE	Uses the lookup type HR_WPM_MEASUREMENT_STYLE to indicate the style of measurement.
MEASURE_NAME	The measure by which this objective's completion should be scored against.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
VERIFIED_FLAG	Uses the lookup type YES_NO to indicate whether the objective's achievement has been verified against the measure.
TARGET_VALUE	The target measure, either a Maximum target or a Minimum target, depending on the measure_type.
ACTUAL_VALUE	The actual quantity achieved against the target measure.
UOM_CODE	Uses the lookup type HR_WPM_MEASURE_UOM to determine the measure's unit of measure.
MEASURE_TYPE_CODE	Uses the lookup type HR_WPM_MEASURE_TYPE to determine whether the target measure is a minimum or maximum.
MEASURE_COMMENTS	Comments regarding the measure and target.
ALIGNED_WITH_OBJECTIVE_ID	An objective that this objective contributes towards.
OWNING_PERSON_ID	Foreign key to PER_ALL_PEOPLE_F
SHARING_ACCESS_CODE	Uses the lookup type HR_WPM_OBJECTIVE_SHARING to define the objective's access permissions.
ACHIEVEMENT_DATE	The date on which the objective is achieved
DETAIL	A detailed definition of the objective
COMMENTS	General comments about the objective
SUCCESS_CRITERIA	The success criteria or performance metrics used for the objective.
OBJECTIVE_ID	Primary key of the Objective
APPRAISAL_ID	Primary key of Appraisals

Human Resources - PER_PERFORMANCE_RATINGS	A single evaluation of an objective.
Column Name	Descritpion
PERFORMANCE_RATING_ID	Primary key of the Performance Rating
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
ATTRIBUTE1	Descriptive flexfield column
ATTRIBUTE2	Descriptive flexfield column
ATTRIBUTE3	Descriptive flexfield column
COMMENTS	A comment on the performance of a person against an objective
ATTRIBUTE4	Descriptive flexfield column
ATTRIBUTE5	Descriptive flexfield column
ATTRIBUTE6	Descriptive flexfield column
ATTRIBUTE7	Descriptive flexfield column
ATTRIBUTE8	Descriptive flexfield column
ATTRIBUTE9	Descriptive flexfield column
ATTRIBUTE10	Descriptive flexfield column
ATTRIBUTE11	Descriptive flexfield column
ATTRIBUTE12	Descriptive flexfield column
ATTRIBUTE13	Descriptive flexfield column
ATTRIBUTE14	Descriptive flexfield column
ATTRIBUTE15	Descriptive flexfield column
ATTRIBUTE16	Descriptive flexfield column
ATTRIBUTE17	Descriptive flexfield column
ATTRIBUTE18	Descriptive flexfield column
ATTRIBUTE19	Descriptive flexfield column
ATTRIBUTE20	Descriptive flexfield column
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
PERSON_ID
OBJECTIVE_ID	Primary key of the Objective
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
APPRAISAL_ID	Primary key of Appraisals
PERFORMANCE_LEVEL_ID	Unique identifier of the Rating Level

Human Resources - PER_PARTICIPANTS	A person participating in an appraisal or assessment.
Column Name	Descritpion
PARTICIPANT_ID	Primary key of the Participant
PARTICIPATION_TYPE	Denotes the type of participation. e.g. as a group appraiser or reviewer
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.
PARTICIPATION_STATUS	The status of the participation, either open or closed. i.e. whether a participant may make modifications or not.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LAST_NOTIFIED_DATE	The last date a participant was sent a notification.
QUESTIONNAIRE_TEMPLATE_ID	Foreign Key to HR_QUESTIONNAIRES. Contains the Questionnaire associated to this Participant.
DATE_COMPLETED	The date on which the participation takes place
COMMENTS	The participants comments about their role in a process
PERSON_ID	The person who is the participant
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
PARTICIPATION_IN_TABLE	The table to which the participant record is related
PARTICIPATION_IN_COLUMN	The column to which the participant_in_id is related
PARTICIPATION_IN_ID	The ID of the foreign key in table defined in PARTICIPATION_IN_TA

Human Resources - PER_JP_SCHOOL_LOOKUPS	Lookups for Japanese Educational Institutions
Column Name	Descritpion
MAJOR_KANA	Major in Kana Characters
CREATED_BY	Standard Who Column.
CREATION_DATE	Standard Who Column.
LAST_UPDATED_BY	Standard Who Column.
LAST_UPDATE_DATE	Standard Who Column.
SCHOOL_ID	Primary Key (Characters)
LAST_UPDATE_LOGIN	Standard Who Column.
SCHOOL_NAME	School Name in Kanji Characters
SCHOOL_NAME_KANA	School Name in Kana Characters
MAJOR	Major in Kanji Characters

Human Resources - PER_JP_BANK_LOOKUPS	Lookups for Japanese Bank Branches
Column Name	Descritpion
BRANCH_NAME	Bank Branch Name in Kanji Characters
BRANCH_NAME_KANA	Bank Branch Name in Kana Characters
CREATED_BY	Standard Who Column.
CREATION_DATE	Standard Who Column.
LAST_UPDATED_BY	Standard Who Column.
BANK_CODE	Bank Code
LAST_UPDATE_DATE	Standard Who Column.
LAST_UPDATE_LOGIN	Standard Who Column.
BANK_NAME	Bank Name in Kanji Characters
BANK_NAME_KANA	Bank name in Kana Characters
BRANCH_CODE	Bank Branch Code

Human Resources - PER_JP_ADDRESS_LOOKUPS	Lookups for Japanese Addresses
Column Name	Descritpion
CREATED_BY	Standard Who Column.
CREATION_DATE	Standard Who Column.
LAST_UPDATED_BY	Standard Who Column.
LAST_UPDATE_DATE	Standard Who Column.
LAST_UPDATE_LOGIN	Standard Who Column.
DISTRICT_CODE	District Code
ADDRESS_LINE_1	Address Line 1 in Kanji characters
ADDRESS_LINE_1_KANA	Address Line 1 in Kana characters
DISTRICT_NAME_KANA	District Name in Kana characters

Human Resources - PER_PERSON_TYPE_USAGES_F	Identifies the types a person may be.
Column Name	Descritpion
EFFECTIVE_END_DATE	Effective end date.
ATTRIBUTE26	Descriptive flexfield column.
ATTRIBUTE27	Descriptive flexfield column.
ATTRIBUTE28	Descriptive flexfield column.
ATTRIBUTE29	Descriptive flexfield column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
ATTRIBUTE30	Descriptive flexfield column.
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column
PERSON_TYPE_USAGE_ID	System generated primary key.
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
REQUEST_ID	Standard Who column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who column.
PROGRAM_UPDATE_DATE	Standard who column
ATTRIBUTE_CATEGORY	Descriptive flexfield column.
ATTRIBUTE1	Descriptive flexfield column.
ATTRIBUTE2	Descriptive flexfield column.
ATTRIBUTE3	Descriptive flexfield column.
PERSON_ID	Foreign key to person table.
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.
PERSON_TYPE_ID	Foreign key to person types table.
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.
EFFECTIVE_START_DATE	Effective start date.
ATTRIBUTE22	Descriptive flexfield column.
ATTRIBUTE23	Descriptive flexfield column.
ATTRIBUTE24	Descriptive flexfield column.
ATTRIBUTE25	Descriptive flexfield column.

Human Resources - PER_PERSON_DLVRY_METHODS	The communication delivery method for a person.
Column Name	Descritpion
COMM_DLVRY_METHOD	The delivery method which can be used for the person.
PREFERRED_FLAG	Indicates which delivery method is preferred.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
LAST_UPDATED_BY	Standard who column
DELIVERY_METHOD_ID	Generated primary key
LAST_UPDATE_DATE	Standard who column
LAST_UPDATE_LOGIN	Standard who column
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
REQUEST_ID	Standard who column
PROGRAM_UPDATE_DATE	Standard who column
PROGRAM_APPLICATION_ID	Standard who column
PROGRAM_ID	Standard who column
ATTRIBUTE_CATEGORY	Descriptive flexfield column.
DATE_START
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.
DATE_END
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
PERSON_ID	Foreign key to person.

Human Resources - PER_PERFORMANCE_REVIEWS	Performance review information for employees.
Column Name	Descritpion
PERFORMANCE_REVIEW_ID	System-generated primary key column.
NEXT_PERF_REVIEW_DATE	Date of the next performance review.
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.
PERSON_ID	Foreign key to PER_ALL_PEOPLE_F
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
EVENT_ID	Foreign key to PER_EVENTS
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
ATTRIBUTE21	Descriptive flexfield column.
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.
REVIEW_DATE	Date of performance review.
ATTRIBUTE29	Descriptive flexfield column.
ATTRIBUTE30	Descriptive flexfield 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
PERFORMANCE_RATING	A performance value from HR_LOOKUPS of type PERFORMANCE_RATING.

Human Resources - PER_JP_POSTAL_CODES	Lookups for Japanese postal codes and districts
Column Name	Descritpion
POSTAL_CODE	Primary Key (Characters)
DISTRICT_CODE	Japanese district code
REGION	Japanese Region Name in Kanji Characters
REGION_KANA	Japanese Region Name in Kana Characters
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 - PER_SALARY_SURVEY_MAPPINGS	Mapping information for a salary survey line.
Column Name	Descritpion
PARENT_ID	Foreign key to either PER_JOBS or HR_ALL_POSITIONS_F
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
PARENT_TABLE_NAME	Code identifying the table to which PARENT_ID applies
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
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.
SALARY_SURVEY_LINE_ID	Foreign key to PER_SALARY_SURVEY_LINES.
BUSINESS_GROUP_ID	Foreign key to HR_ALL_ORGANIZATIONS identifying the business group.
LOCATION_ID	Foreign key to HR_LOCATIONS.
GRADE_ID	Foreign key to PER_GRADES.
COMPANY_ORGANIZATION_ID	Foreign key to HR_LOCATIONS.
COMPANY_AGE_CODE	Code to indicate the age band in the company.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
SALARY_SURVEY_MAPPING_ID	System-generated primary key 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.

Human Resources - PER_STANDARD_HOLIDAYS	Statutory Holiday information.
Column Name	Descritpion
HOLIDAY_DATE_END	he end date for a multi-day holiday.
HOLIDAY_TYPE	The type of holiday.
LEGISLATION_CODE	Legislation Code.
SUB_LEGISLATION_CODE	Code of regions within a legislation.
ALTERNATIVES_PERMITTED	Is it allowable to take this holiday on another day?
BUSINESS_GROUP_ID	Foreign key to HR_ALL_ORGANIZATION_UNITS.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
ATTRIBUTE1	Descriptive flexfield column.
ATTRIBUTE2	Descriptive flexfield column.
ATTRIBUTE3	Descriptive flexfield column.
STANDARD_HOLIDAY_ID	System generated primary key 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.
NAME	The name of the holiday.
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.
HOLIDAY_DATE	The date of the holiday. This will be the start date for a multi-day holiday.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.

Human Resources - PER_STD_HOLIDAY_ABSENCES	Records when Statutory Holidays are taken.
Column Name	Descritpion
ACTUAL_DATE_TAKEN	The date on which the Standard Holiday was taken as leave.
STD_HOLIDAY_ABSENCES_ID	System generated primary key column.
REASON	The reason for not taking the leave on the date of the Standard Holiday.
EXPIRED	Is the Standard Holiday no longer valid as leave?
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
ATTRIBUTE1	Descriptive flexfield column.
DATE_NOT_TAKEN	Date of the Standard Holiday.
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.
PERSON_ID	Foreign key to PER_ALL_PEOPLE_F.
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.
STANDARD_HOLIDAY_ID	Foreign key to PER_STANDARD_HOLIDAYS.
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 - PER_SALARY_SURVEYS	Market salary survey information.
Column Name	Descritpion
SURVEY_COMPANY_CODE	Code for the name of the company that this survey applies to.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
IDENTIFIER	Two letter abbreviation used to restrict mapping of specified survey values to company values.
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.
SURVEY_TYPE_CODE	Code to indicate if the survey is based on Annual, Monthly, Hourly, or Period salary.
SALARY_SURVEY_ID	System-generated primary key.
BASE_REGION	An information flag to denote if there is a regional or national average.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
SURVEY_NAME	The name of the survey.
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.

Human Resources - PER_SALARY_SURVEY_LINES	Details for market salary surveys.
Column Name	Descritpion
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.
SALARY_SURVEY_ID	Foreign key to PER_SALARY_SURVEYS.
ATTRIBUTE6	Descriptive flexfield column.
ATTRIBUTE7	Descriptive flexfield column.
ATTRIBUTE8	Descriptive flexfield column.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
SURVEY_JOB_NAME_CODE	Code representing the Job type that this survey line applies to. User Defined Lookup.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
SURVEY_REGION_CODE	Code representing the Region that this survey line applies to. User Defined Lookup.
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.
ATTRIBUTE21	Descriptive Flexfield
ATTRIBUTE22	Descriptive Flexfield
ATTRIBUTE23	Descriptive Flexfield
ATTRIBUTE24	Descriptive Flexfield
ATTRIBUTE25	Descriptive Flexfield
ATTRIBUTE26	Descriptive Flexfield
SURVEY_SENIORITY_CODE	Code representing the Seniority that this survey line applies to. User Defined Lookup.
ATTRIBUTE27	Descriptive Flexfield
ATTRIBUTE28	Descriptive Flexfield
ATTRIBUTE29	Descriptive Flexfield
ATTRIBUTE30	Descriptive Flexfield
COMPANY_SIZE_CODE	Code representing the size of the company that the survey line applies to. User Defined Lookup.
TENTH_PERCENTILE
TWENTY_FIFTH_PERCENTILE	Twenty fifth Percentile
FIFTIETH_PERCENTILE	fiftieth percentile
SEVENTY_FIFTH_PERCENTILE	Seventy Fifth Percentile
INDUSTRY_CODE	Code representing the industry associated with the survey line. User Defined Lookup.
NINETIETH_PERCENTILE	Ninetieth Percentile
MINIMUM_BONUS	Minimum Bonus
MEAN_BONUS	Mean Bonus
MAXIMUM_BONUS	Maximum Bonus
SURVEY_AGE_CODE	Code representing the Survey Age for the survey line.
MINIMUM_SALARY_INCREASE	Minimum Salary Increase
MEAN_SALARY_INCREASE	Mean Salary Increase
MAXIMUM_SALARY_INCREASE	Maximum Salary Increase
MIN_VARIABLE_COMPENSATION	Minimum Variable compensation
START_DATE	The date from which the the data in the survey line applies.
MEAN_VARIABLE_COMPENSATION	Mean Variable Compensation
MAX_VARIABLE_COMPENSATION	Maximum Variable Compensation
MINIMUM_STOCK	Minimum Stock
MEAN_STOCK	Mean Stock
END_DATE	The date after which the data in the survey line no longer applies.
MAXIMUM_STOCK	Maximum Stock
STOCK_DISPLAY_TYPE	Stock Display Type
DIFFERENTIAL	A percentage representing the amount by which pay figures for the survey line are above or below the specified base region average .
CURRENCY_CODE	Foreign Key to FND_CURRENCIES
MINIMUM_PAY	The Minimum Pay for this job.
MEAN_PAY	The Mean Pay for this job.
MAXIMUM_PAY	The Maximum Pay for this job.
GRADUATE_PAY	The graduate Pay for this job.
STARTING_PAY	The Minimum Pay for this job.
PERCENTAGE_CHANGE	The Percentage change in pay for this job.
JOB_FIRST_QUARTILE	The First Quartile for this job.
JOB_MEDIAN_QUARTILE	The Median Quartile for this job.
JOB_THIRD_QUARTILE	The Third Quartile for this job.
JOB_FOURTH_QUARTILE	The Fourth Quartile for this job.
MINIMUM_TOTAL_COMPENSATION	The Minimum Total Compensation for this job.
MEAN_TOTAL_COMPENSATION	The Mean Total Compensation for this job.
MAXIMUM_TOTAL_COMPENSATION	The maximum total compensation for this job.
COMPNSTN_FIRST_QUARTILE	First Quartile for the compensation in the survey line.
COMPNSTN_MEDIAN_QUARTILE	Median Quartile for the compensation in the survey line.
COMPNSTN_THIRD_QUARTILE	Third Quartile for the compensation in the survey line.
COMPNSTN_FOURTH_QUARTILE	Fourth Quartile for the compensation in the survey line.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
SALARY_SURVEY_LINE_ID	System-generated primary key column.

Human Resources - PER_SEC_PROFILE_ASSIGNMENTS	Security profile assignments for User, Responsibility and Business Group.
Column Name	Descritpion
SEC_PROFILE_ASSIGNMENT_ID	System-generated primary key column.
CREATION_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
BUSINESS_GROUP_ID	Foreign key to HR_ALL_ORGANIZATION_UNITS.
USER_ID	Foreign key to FND_USER.
SECURITY_GROUP_ID	Foreign key to FND_SECURITY_GROUPS.
SECURITY_PROFILE_ID	Foreign key to PER_SECURITY_PROFILES.
RESPONSIBILITY_ID	Foreign key to FND_RESPONSIBILITY.
RESPONSIBILITY_APPLICATION_ID	Foreign key to FND_RESPONSIBILITY.
START_DATE	Start date of the security profile assignment.
END_DATE	End date of the security profile assignment.
CREATED_BY	Standard Who column.

Human Resources - PER_PERSON_TYPES_TL	Translated person types information.
Column Name	Descritpion
PERSON_TYPE_ID	Foreign key to PER_PERSON_TYPES
LANGUAGE	Defined language
SOURCE_LANG	Actual language
USER_PERSON_TYPE	Translated user name for the person type
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column

Human Resources - PER_STARTUP_PERSON_TYPES_TL	Predefined list of translated person types.
Column Name	Descritpion
SYSTEM_PERSON_TYPE	System code for the person type
CREATION_DATE	Standard Who column
DEFAULT_FLAG	Indicates whether this is the default name for a particular system code.
CURRENT_APPLICANT_FLAG	Flag to indicate whether this is an Applicant type.
CURRENT_EMP_OR_APL_FLAG	Flag to indicate whether this is an Employee and an Applicant type.
CURRENT_EMPLOYEE_FLAG	Flag to indicate whether this is an Employee type.
SEEDED_PERSON_TYPE_KEY	Seeded person type key
USER_PERSON_TYPE	User-defined name for the person type
LANGUAGE	Defined language
SOURCE_LANG	Actual language
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 - PER_HTML_TOOLKIT_REC_TYPES	Default values for the HR html toolkit.
Column Name	Descritpion
ATTRIBUTE_NAME	The name of an attribute within the record type. e.g. ALIGN)
DATA_TYPE	The datatype of the attribute.
DEFAULT_VALUE	The default value for the attribute.
CUSTOM_VALUE	The customer value for the attribute. (This will be substituted for the default value at runtime.)
MESSAGE_NAME	Foreign Key to FND_NEW_MESSAGES to provide a description of the object type.
HTML_TOOLKIT_REC_TYPE_ID	System generated 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.
OBJECT_TYPE_NAME	HTML object type.
RECORD_TYPE_NAME	Name of the corresponding record value in the toolkit. e.g. PromptFormat
RECORD_TYPE_SEQUENCE	Display order.

Human Resources - PER_SHARED_TYPES	Holds 'type' and 'status' information.
Column Name	Descritpion
SHARED_TYPE_ID	Unique key generated from sequence PER_PERSON_TYPES_S.
INFORMATION5	Developer descriptive flexfield
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
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
INFORMATION15	Developer descriptive flexfield
INFORMATION16	Developer descriptive flexfield
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
SHARED_TYPE_NAME	User defined name to a System defined Type.
INFORMATION25	Developer descriptive flexfield
INFORMATION26	Developer descriptive flexfield
INFORMATION27	Developer descriptive flexfield
INFORMATION28	Developer descriptive flexfield
INFORMATION29	Developer descriptive flexfield
INFORMATION30	Developer descriptive flexfield
INFORMATION_CATEGORY	Developer descriptive flexfield
OBJECT_VERSION_NUMBER	Object Version Number
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LOOKUP_TYPE	Lookup Type
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
SYSTEM_TYPE_CD	Lookup Code
INFORMATION1	Developer descriptive flexfield
INFORMATION2	Developer descriptive flexfield
INFORMATION3	Developer descriptive flexfield
INFORMATION4	Developer descriptive flexfield

Human Resources - PER_SHARED_TYPES_TL	Translated information for shared types.
Column Name	Descritpion
SHARED_TYPE_ID	System generated primary key
LANGUAGE	Define language, part of primary key.
SOURCE_LANG	Actual Language
SHARED_TYPE_NAME	Translated user defined name for the type.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.

Human Resources - PER_JOB_GROUPS	Holds Job Group Information. Each Job will be a member of a Job Group and a Job Group can optionally be within a business group.
Column Name	Descritpion
BUSINESS_GROUP_ID	Foreign key to PER_JOB_DEFINITIONS
LEGISLATION_CODE	The legislation to which the Job Group applies.
INTERNAL_NAME	The name of the Job Group held internally on the system. This name cannot be updated once the job group has been created.
DISPLAYED_NAME	The name displayed on any form or report. The user can update this name after the Job Group has been created.
ID_FLEX_NUM	The key flex field that all jobs created within this job group should use
MASTER_FLAG	Certain jobs can be defined as 'Master Jobs' which some organizations use as a 'template' for other jobs of the same level or grade.
OBJECT_VERSION_NUMBER	System generated version of row. Increments by one for each update
CREATION_DATE	Standard WHO column
JOB_GROUP_ID	System generated primary key
CREATED_BY	Standard WHO column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column

Human Resources - PER_ROLES	Holds the different roles that a person performs.
Column Name	Descritpion
ROLE_ID	System generated primary key
JOB_GROUP_ID	Foreign key to PER_JOB_GROUPS
ATTRIBUTE9	Descriptive Flexfield column
ATTRIBUTE10	Descriptive Flexfield column
ATTRIBUTE11	Descriptive Flexfield column
ATTRIBUTE12	Descriptive Flexfield column
ATTRIBUTE13	Descriptive Flexfield column
ATTRIBUTE14	Descriptive Flexfield column
ATTRIBUTE15	Descriptive Flexfield column
ATTRIBUTE16	Descriptive Flexfield column
ATTRIBUTE17	Descriptive Flexfield column
ATTRIBUTE18	Descriptive Flexfield column
PERSON_ID	Foreign Key to PER_PEOPLE_F
ATTRIBUTE19	Descriptive Flexfield column
ATTRIBUTE20	Descriptive Flexfield column
ROLE_INFORMATION_CATEGORY	Developer Descriptive flexfield column
ROLE_INFORMATION1	Developer Descriptive flexfield column
ROLE_INFORMATION2	Developer Descriptive flexfield column
ROLE_INFORMATION3	Developer Descriptive flexfield column
ORGANIZATION_ID	Foreign key to HR_ORGANIZATION_UNITS
ROLE_INFORMATION4	Developer Descriptive flexfield column
ROLE_INFORMATION5	Developer Descriptive flexfield column
ROLE_INFORMATION6	Developer Descriptive flexfield column
ROLE_INFORMATION7	Developer Descriptive flexfield column
JOB_ID	Foreign key to PER_JOBS
ROLE_INFORMATION8	Developer Descriptive flexfield column
ROLE_INFORMATION9	Developer Descriptive flexfield column
ROLE_INFORMATION10	Developer Descriptive flexfield column
ROLE_INFORMATION11	Developer Descriptive flexfield column
ROLE_INFORMATION12	Developer Descriptive flexfield column
ROLE_INFORMATION13	Developer Descriptive flexfield column
ROLE_INFORMATION14	Developer Descriptive flexfield column
ROLE_INFORMATION15	Developer Descriptive flexfield column
ROLE_INFORMATION16	Developer Descriptive flexfield column
ROLE_INFORMATION17	Developer Descriptive flexfield column
ROLE_INFORMATION18	Developer Descriptive flexfield column
ROLE_INFORMATION19	Developer Descriptive flexfield column
ROLE_INFORMATION20	Developer Descriptive flexfield column
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
OBJECT_VERSION_NUMBER	System generated version number for each row. Increments by one on each update.
START_DATE	The date on which the role is effective for this person
END_DATE	The date on which this person will finish the role
OLD_END_DATE	This column is used to hold the original END_DATE value once a person is terminated. If the termination is reversed, the end date of the role is restored from the value held in this columm
CONFIDENTIAL_DATE	The date on which a Confidentiality Agreement was signed
EMP_RIGHTS_FLAG	Additional employee rights.
END_OF_RIGHTS_DATE	The date on which the employee's additional rights terminate
PRIMARY_CONTACT_FLAG	Signifies whether this person is the primary contact for the role
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
ATTRIBUTE8	Descriptive Flexfield column

Human Resources - PER_MEDICAL_ASSESSMENTS	Hold Medical Assessment information for one person
Column Name	Descritpion
PERSON_ID	Foreign Key to Per_Person_F
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.
EXAMINER_NAME	Medical Examiners Name
ATTRIBUTE19	Descriptive flex column.
ATTRIBUTE20	Descriptive flex column.
ATTRIBUTE21	Descriptive flex column.
ATTRIBUTE22	Descriptive flex column.
ATTRIBUTE23	Descriptive flex column.
ATTRIBUTE24	Descriptive flex column.
ATTRIBUTE25	Descriptive flex column.
ATTRIBUTE26	Descriptive flex column.
ATTRIBUTE27	Descriptive flex column.
ATTRIBUTE28	Descriptive flex column.
ORGANIZATION_ID	Foreign key to HR_ALL_ORGANIZATION_UNITS.
ATTRIBUTE29	Descriptive flex column.
ATTRIBUTE30	Descriptive flex column.
MEA_INFORMATION_CATEGORY	Developer descriptive flex structure defining column
MEA_INFORMATION1	Developer descriptive flex column.
MEA_INFORMATION2	Developer descriptive flex column.
MEA_INFORMATION3	Developer descriptive flex column.
MEA_INFORMATION4	Developer descriptive flex column.
MEA_INFORMATION5	Developer descriptive flex column.
MEA_INFORMATION6	Developer descriptive flex column.
CONSULTATION_DATE	Date of medical consultation
MEA_INFORMATION7	Developer descriptive flex column.
MEA_INFORMATION8	Developer descriptive flex column.
MEA_INFORMATION9	Developer descriptive flex column.
MEA_INFORMATION10	Developer descriptive flex column.
MEA_INFORMATION11	Developer descriptive flex column.
MEA_INFORMATION12	Developer descriptive flex column.
MEA_INFORMATION13	Developer descriptive flex column.
MEA_INFORMATION14	Developer descriptive flex column.
MEA_INFORMATION15	Developer descriptive flex column.
MEA_INFORMATION16	Developer descriptive flex column.
CONSULTATION_TYPE	Type of medical assessment
MEA_INFORMATION17	Developer descriptive flex column.
MEA_INFORMATION18	Developer descriptive flex column.
MEA_INFORMATION19	Developer descriptive flex column.
MEA_INFORMATION20	Developer descriptive flex column.
MEA_INFORMATION21	Developer descriptive flex column.
MEA_INFORMATION22	Developer descriptive flex column.
MEA_INFORMATION23	Developer descriptive flex column.
MEA_INFORMATION24	Developer descriptive flex column.
MEA_INFORMATION25	Developer descriptive flex column.
MEA_INFORMATION26	Developer descriptive flex column.
CONSULTATION_RESULT	Result of medical assessment
MEA_INFORMATION27	Developer descriptive flex column.
MEA_INFORMATION28	Developer descriptive flex column.
MEA_INFORMATION29	Developer descriptive flex column.
MEA_INFORMATION30	Developer 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	System-generated version of row. Increments by one with each update.
DISABILITY_ID	Foreign Key to Per_Disabilities_F
INCIDENT_ID	Foreign Key to Per_Work_Incidents
MEDICAL_ASSESSMENT_ID	Primary key. Generated from sequence PER_MEDICAL_ASSESSMENT_S
NEXT_CONSULTATION_DATE	Date of next medical assessments
DESCRIPTION	Description of medical assessment
ATTRIBUTE_CATEGORY	Descriptive flex structure defining column.
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.

Human Resources - PER_QUERY_CRITERIA	Used to store criteria to build up a query
Column Name	Descritpion
FIELD	The name of the query column. Part of the composite primary key
FIELD_TYPE	The field type (V, D or N)
VARCHAR2_VALUE	The varchar2 value
DATE_VALUE	The date value
NUMBER_VALUE	The number value
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
QUERY_ID	Part of the composite primary key

Human Resources - PER_KR_ADDRESSES	KR specific
Column Name	Descritpion
POSTAL_CODE	Postal Code
CITY_PROVINCE	City or Province(Si/Do in Korea)
DISTRICT	District(Gu/Gun in Korea)
ADDRESS	Address Line
TOWN_VILLAGE	Town or Village(Dong/Eup/Myeon/Ri in Korea)
HOUSE_NUMBER	Range of House Number or Specific Area(Bunji in Korea)
ENABLED_FLAG	Enabled Flag
CREATED_BY	Standard Who Column
CREATION_DATE	Standard Who Column
LAST_UPDATE_DATE	Standard Who Column
LAST_UPDATED_BY	Standard Who Column
POSTAL_CODE_ID	Postal Code ID
LAST_UPDATE_LOGIN	Standard Who Column
POSTAL_CODE_SEQUENCE	Postal Code Sequence

Human Resources - PER_PERIODS_OF_SERVICE_EFC	This is a copy of the PER_PERIODS_OF_SERVICE table which is populated by the EFC (Euro as Functional Currency) process.
Column Name	Descritpion
PERIOD_OF_SERVICE_ID	Foreign Key to PER_PERIODS_OF_SERVICE.
EFC_ACTION_ID	Foreign Key to HR_EFC_ACTIONS.
PDS_INFORMATION4	Refer to column comment on base table.
EFC_BG_CURRENCY	Original currency from the business group prior to the EFC process.

Human Resources - PER_PAY_PROPOSAL_COMPONENT_EFC	This is a copy of the PER_PAY_PROPOSAL_COMPONENT table which is populated by the EFC (Euro as Functional Currency) process.
Column Name	Descritpion
EFC_ACTION_ID	Foreign Key to HR_EFC_ACTIONS.
CHANGE_AMOUNT_N	Refer to column comment on base table.
INPUT_CURRENCY_CODE	Refer to column comment on base table.
COMPONENT_ID	Refer to column comment on base table.

Human Resources - PER_SALARY_SURVEY_LINES_EFC	This is a copy of the PER_SALARY_SURVEY_LINES table which is populated by the EFC (Euro as Functional Currency) process.
Column Name	Descritpion
EFC_ACTION_ID	Foreign Key to HR_EFC_ACTIONS.
MINIMUM_PAY	Refer to column comment on base table.
MAXIMUM_PAY	Refer to column comment on base table.
MEAN_PAY	Refer to column comment on base table.
GRADUATE_PAY	Refer to column comment on base table.
STARTING_PAY	Refer to column comment on base table.
JOB_FIRST_QUARTILE	Refer to column comment on base table.
JOB_MEDIAN_QUARTILE	Refer to column comment on base table.
SALARY_SURVEY_LINE_ID	Refer to column comment on base table.
JOB_THIRD_QUARTILE	Refer to column comment on base table.
JOB_FOURTH_QUARTILE	Refer to column comment on base table.
MINIMUM_TOTAL_COMPENSATION	Refer to column comment on base table.
MEAN_TOTAL_COMPENSATION	Refer to column comment on base table.
MAXIMUM_TOTAL_COMPENSATION	Refer to column comment on base table.
COMPNSTN_FIRST_QUARTILE	Refer to column comment on base table.
COMPNSTN_MEDIAN_QUARTILE	Refer to column comment on base table.
COMPNSTN_THIRD_QUARTILE	Refer to column comment on base table.
COMPNSTN_FOURTH_QUARTILE	Refer to column comment on base table.
CURRENCY_CODE	Refer to column comment on base table.

Human Resources - PER_RECRUITMENT_ACTIVITIES_EFC	This is a copy of the PER_RECRUITMENT_ACTIVITIES table which is populated by the EFC (Euro as Functional Currency) process.
Column Name	Descritpion
RECRUITMENT_ACTIVITY_ID	Refer to column comment on base table.
EFC_ACTION_ID	Foreign Key to HR_EFC_ACTIONS.
ACTUAL_COST	Refer to column comment on base table.
PLANNED_COST	Refer to column comment on base table.
CURRENCY_CODE	Refer to column comment on base table.

Human Resources - PER_QUALIFICATIONS_EFC	This is a copy of the PER_QUALIFICATIONS table which is populated by the EFC (Euro as Functional Currency) process.
Column Name	Descritpion
QUALIFICATION_ID	Refer to column comment on base table.
EFC_ACTION_ID	Foreign Key to HR_EFC_ACTIONS.
FEE	Refer to column comment on base table.
FEE_CURRENCY	Refer to column comment on base table.

Human Resources - PER_PAY_PROPOSALS_EFC	This is a copy of the PER_PAY_PROPOSALS table which is populated by the EFC (Euro as Functional Currency) process.
Column Name	Descritpion
PAY_PROPOSAL_ID	Refer to column comment on base table.
EFC_ACTION_ID	Foreign Key to HR_EFC_ACTIONS.
PROPOSED_SALARY_N	Refer to column comment on base table.
INPUT_CURRENCY_CODE	Refer to column comment on base table.

Human Resources - PER_PERSON_TYPE_USAGES_UPGRADE	Used in the upgrade of the person type usage model
Column Name	Descritpion
OBJECT_VERSION_NUMBER
APP_PERSON_TYPE_ID	Foreign key to person types table
EMP_PERSON_TYPE_ID	Foreign key to person types 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
PERSON_TYPE_ID	Primary key and Foreign key to person types table

Human Resources - PER_PREVIOUS_EMPLOYERS
Column Name	Descritpion
PREVIOUS_EMPLOYER_ID	Surrogate ID for ZPrevious Employer record
EMPLOYER_COUNTRY	Country of the Employer
EMPLOYER_ADDRESS	Address for the employer
EMPLOYER_TYPE	Category of the employer
EMPLOYER_SUBTYPE	Category of the employer
DESCRIPTION	Description for the service history period
PEM_ATTRIBUTE_CATEGORY	Descriptive Flexfield Attribute Category
PEM_ATTRIBUTE1
PEM_ATTRIBUTE2
PEM_ATTRIBUTE3
PEM_ATTRIBUTE4
BUSINESS_GROUP_ID	Business Group under which this previous employer record is defined.
PEM_ATTRIBUTE5
PEM_ATTRIBUTE6
PEM_ATTRIBUTE7
PEM_ATTRIBUTE8
PEM_ATTRIBUTE9
PEM_ATTRIBUTE10
PEM_ATTRIBUTE11
PEM_ATTRIBUTE12
PEM_ATTRIBUTE13
PEM_ATTRIBUTE14
PERSON_ID	This is the FK of the person to which previous employer record applies
PEM_ATTRIBUTE15
PEM_ATTRIBUTE16
PEM_ATTRIBUTE17
PEM_ATTRIBUTE18
PEM_ATTRIBUTE19
PEM_ATTRIBUTE20
PEM_ATTRIBUTE21
PEM_ATTRIBUTE22
PEM_ATTRIBUTE23
PEM_ATTRIBUTE24
PARTY_ID	This is the FK to the Party to which previous employer record applies
PEM_ATTRIBUTE25
PEM_ATTRIBUTE26
PEM_ATTRIBUTE27
PEM_ATTRIBUTE28
PEM_ATTRIBUTE29
PEM_ATTRIBUTE30
PEM_INFORMATION_CATEGORY
PEM_INFORMATION1
PEM_INFORMATION2
PEM_INFORMATION3
START_DATE	Start Date of the Previous Employer Record
PEM_INFORMATION4
PEM_INFORMATION5
PEM_INFORMATION6
PEM_INFORMATION7
PEM_INFORMATION8
PEM_INFORMATION9
PEM_INFORMATION10
PEM_INFORMATION11
PEM_INFORMATION12
PEM_INFORMATION13
END_DATE	End Date of the Previous Employer Record
PEM_INFORMATION14
PEM_INFORMATION15
PEM_INFORMATION16
PEM_INFORMATION17
PEM_INFORMATION18
PEM_INFORMATION19
PEM_INFORMATION20
PEM_INFORMATION21
PEM_INFORMATION22
PEM_INFORMATION23
PERIOD_YEARS	The whole number of years at the previous employer
PEM_INFORMATION24
PEM_INFORMATION25
PEM_INFORMATION26
PEM_INFORMATION27
PEM_INFORMATION28
PEM_INFORMATION29
PEM_INFORMATION30
OBJECT_VERSION_NUMBER	Used to store object version number
LAST_UPDATE_DATE	Standard WHO columns
LAST_UPDATED_BY
PERIOD_DAYS	The Number of days on top of the whole year at the previous employer
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
ALL_ASSIGNMENTS
PERIOD_MONTHS
EMPLOYER_NAME	Identifier for the employer

Human Resources - PER_PREV_JOB_INFO_TYPES	Used to store previous job info types
Column Name	Descritpion
INFORMATION_TYPE	identifier for the information type
CREATED_BY
CREATION_DATE
ACTIVE_INACTIVE_FLAG	Identifies if the information type is currently active
MULTIPLE_OCCURANCES_FLAG	Identifies if it is possible to have more than one of this information type for a single previous job
DESCRIPTION	Description for the information type
LEGISLATION_CODE	legislation to which the information type belongs
OBJECT_VERSION_NUMBER	Used to store object version number
LAST_UPDATE_DATE	Standard WHO columns
LAST_UPDATED_BY
LAST_UPDATE_LOGIN

Human Resources - PER_PREVIOUS_JOBS	Used to store Previous Jobs
Column Name	Descritpion
PREVIOUS_JOB_ID	Primary Key of the Table
PJO_ATTRIBUTE_CATEGORY
PJO_ATTRIBUTE1
PJO_ATTRIBUTE2
PJO_ATTRIBUTE3
PJO_ATTRIBUTE4
PJO_ATTRIBUTE5
PJO_ATTRIBUTE6
PJO_ATTRIBUTE7
PJO_ATTRIBUTE8
PJO_ATTRIBUTE9
PREVIOUS_EMPLOYER_ID	Must exist in PER_PREVIOUS_EMPLOYERS
PJO_ATTRIBUTE10
PJO_ATTRIBUTE11
PJO_ATTRIBUTE12
PJO_ATTRIBUTE13
PJO_ATTRIBUTE14
PJO_ATTRIBUTE15
PJO_ATTRIBUTE16
PJO_ATTRIBUTE17
PJO_ATTRIBUTE18
PJO_ATTRIBUTE19
START_DATE	Start date of the job
PJO_ATTRIBUTE20
PJO_ATTRIBUTE21
PJO_ATTRIBUTE22
PJO_ATTRIBUTE23
PJO_ATTRIBUTE24
PJO_ATTRIBUTE25
PJO_ATTRIBUTE26
PJO_ATTRIBUTE27
PJO_ATTRIBUTE28
PJO_ATTRIBUTE29
END_DATE	End date of the job
PJO_ATTRIBUTE30
PJO_INFORMATION_CATEGORY
PJO_INFORMATION1
PJO_INFORMATION2
PJO_INFORMATION3
PJO_INFORMATION4
PJO_INFORMATION5
PJO_INFORMATION6
PJO_INFORMATION7
PJO_INFORMATION8
PERIOD_YEARS	The whole number of Years at the previous job
PJO_INFORMATION9
PJO_INFORMATION10
PJO_INFORMATION11
PJO_INFORMATION12
PJO_INFORMATION13
PJO_INFORMATION14
PJO_INFORMATION15
PJO_INFORMATION16
PJO_INFORMATION17
PJO_INFORMATION18
PERIOD_DAYS	the number of days on top of the whole years at the previous employer
PJO_INFORMATION19
PJO_INFORMATION20
PJO_INFORMATION21
PJO_INFORMATION22
PJO_INFORMATION23
PJO_INFORMATION24
PJO_INFORMATION25
PJO_INFORMATION26
PJO_INFORMATION27
PJO_INFORMATION28
JOB_NAME	Identifier for the Job
PJO_INFORMATION29
PJO_INFORMATION30
OBJECT_VERSION_NUMBER	Used to store object version number
LAST_UPDATE_DATE	Standard WHO columns
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
ALL_ASSIGNMENTS
PERIOD_MONTHS
EMPLOYMENT_CATEGORY	category of the person while they did the job
DESCRIPTION	Description for the job

Human Resources - PER_PREVIOUS_JOB_USAGES	Used to store previous job Usages
Column Name	Descritpion
PREVIOUS_JOB_USAGE_ID	Surrogate Id for a Previous employer record
PJU_ATTRIBUTE2
PJU_ATTRIBUTE3
PJU_ATTRIBUTE4
PJU_ATTRIBUTE5
PJU_ATTRIBUTE6
PJU_ATTRIBUTE7
PJU_ATTRIBUTE8
PJU_ATTRIBUTE9
PJU_ATTRIBUTE10
PJU_ATTRIBUTE11
ASSIGNMENT_ID	This is the FK of the assignment to which previous job usage record applies
PJU_ATTRIBUTE12
PJU_ATTRIBUTE13
PJU_ATTRIBUTE14
PJU_ATTRIBUTE15
PJU_ATTRIBUTE16
PJU_ATTRIBUTE17
PJU_ATTRIBUTE18
PJU_ATTRIBUTE19
PJU_ATTRIBUTE20
PJU_INFORMATION_CATEGORY
PREVIOUS_JOB_ID	This is the FK of the previous job to which previous job usage recod applies
PJU_INFORMATION1
PJU_INFORMATION2
PJU_INFORMATION3
PJU_INFORMATION4
PJU_INFORMATION5
PJU_INFORMATION6
PJU_INFORMATION7
PJU_INFORMATION8
PJU_INFORMATION9
PJU_INFORMATION10
START_DATE	Start date of the job
PJU_INFORMATION11
PJU_INFORMATION12
PJU_INFORMATION13
PJU_INFORMATION14
PJU_INFORMATION15
PJU_INFORMATION16
PJU_INFORMATION17
PJU_INFORMATION18
PJU_INFORMATION19
PJU_INFORMATION20
END_DATE	End date of the job
OBJECT_VERSION_NUMBER	Used to store object version number
LAST_UPDATE_DATE	Standard WHO columns
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
PREVIOUS_EMPLOYER_ID
PERIOD_MONTHS
PERIOD_YEARS	The whole number of years at the previous job
PERIOD_DAYS	the number of days on top of the whole year at the previous employer
PJU_ATTRIBUTE_CATEGORY
PJU_ATTRIBUTE1

Human Resources - PER_PREV_JOB_EXTRA_INFO	Previous Jobs extra info
Column Name	Descritpion
PREVIOUS_JOB_EXTRA_INFO_ID	This is the Surrogate ID for Previous Job record
PJI_ATTRIBUTE6
PJI_ATTRIBUTE7
PJI_ATTRIBUTE8
PJI_ATTRIBUTE9
PJI_ATTRIBUTE10
PJI_ATTRIBUTE11
PJI_ATTRIBUTE12
PJI_ATTRIBUTE13
PJI_ATTRIBUTE14
PJI_ATTRIBUTE15
PREVIOUS_JOB_ID
PJI_ATTRIBUTE16
PJI_ATTRIBUTE17
PJI_ATTRIBUTE18
PJI_ATTRIBUTE19
PJI_ATTRIBUTE20
PJI_ATTRIBUTE21
PJI_ATTRIBUTE22
PJI_ATTRIBUTE23
PJI_ATTRIBUTE24
PJI_ATTRIBUTE25
INFORMATION_TYPE	Information type for this extra job information
PJI_ATTRIBUTE26
PJI_ATTRIBUTE27
PJI_ATTRIBUTE28
PJI_ATTRIBUTE29
PJI_ATTRIBUTE30
PJI_INFORMATION_CATEGORY
PJI_INFORMATION1
PJI_INFORMATION2
PJI_INFORMATION3
PJI_INFORMATION4
PJI_ATTRIBUTE_CATEGORY
PJI_INFORMATION5
PJI_INFORMATION6
PJI_INFORMATION7
PJI_INFORMATION8
PJI_INFORMATION9
PJI_INFORMATION10
PJI_INFORMATION11
PJI_INFORMATION12
PJI_INFORMATION13
PJI_INFORMATION14
PJI_ATTRIBUTE1
PJI_INFORMATION15
PJI_INFORMATION16
PJI_INFORMATION17
PJI_INFORMATION18
PJI_INFORMATION19
PJI_INFORMATION20
PJI_INFORMATION21
PJI_INFORMATION22
PJI_INFORMATION23
PJI_INFORMATION24
PJI_ATTRIBUTE2
PJI_INFORMATION25
PJI_INFORMATION26
PJI_INFORMATION27
PJI_INFORMATION28
PJI_INFORMATION29
PJI_INFORMATION30
OBJECT_VERSION_NUMBER	Used to store object version number
LAST_UPDATE_DATE	Standard WHO columns
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
PJI_ATTRIBUTE3
CREATED_BY
CREATION_DATE
PJI_ATTRIBUTE4
PJI_ATTRIBUTE5

Human Resources - PER_KR_GRADES	KR specific
Column Name	Descritpion
BUSINESS_GROUP_ID	Foreign key to HR_ALL_ORGANIZATION_UNITS
GRADE_NAME	Grdade name
SEQUENCE	Sequence to be displayed
ENABLED_FLAG	Grade enabled flag
START_DATE_ACTIVE	Date before which the grade is invalid
END_DATE_ACTIVE	Date after which the grade is invalid
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update
LAST_UPDATE_DATE	Standard WHO column
GRADE_ID	Unique identifier for the grade
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column

Human Resources - PER_KR_G_POINT_AMOUNT_F	KR specific
Column Name	Descritpion
EFFECTIVE_START_DATE	Effective start date
ATTRIBUTE8	Descriptive flexfield column
ATTRIBUTE9	Descriptive flexfield column
ATTRIBUTE10	Descriptive flexfield column
ATTRIBUTE11	Descriptive flexfield column
ATTRIBUTE12	Descriptive flexfield column
ATTRIBUTE13	Descriptive flexfield column
ATTRIBUTE14	Descriptive flexfield column
ATTRIBUTE15	Descriptive flexfield column
ATTRIBUTE16	Descriptive flexfield column
ATTRIBUTE17	Descriptive flexfield column
EFFECTIVE_END_DATE	Effective end date
ATTRIBUTE18	Descriptive flexfield column
ATTRIBUTE19	Descriptive flexfield column
ATTRIBUTE20	Descriptive flexfield column
ATTRIBUTE21	Descriptive flexfield column
ATTRIBUTE22	Descriptive flexfield column
ATTRIBUTE23	Descriptive flexfield column
ATTRIBUTE24	Descriptive flexfield column
ATTRIBUTE25	Descriptive flexfield column
ATTRIBUTE26	Descriptive flexfield column
ATTRIBUTE27	Descriptive flexfield column
GRADE_POINT_ID	Foreign key to PER_KR_G_POINTS
ATTRIBUTE28	Descriptive flexfield column
ATTRIBUTE29	Descriptive flexfield column
ATTRIBUTE30	Descriptive flexfield column
GRADE_POINT_AMOUNT	Amount for the grade point
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
GRADE_POINT_AMOUNT_ID	Unique identifier for the grade point amount
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
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

Human Resources - PER_KR_G_POINTS	KR specific
Column Name	Descritpion
GRADE_ID	Foreign key to PER_KR_GRADES
GRADE_POINT_NAME	Grade point name
SEQUENCE	Sequence to be displayed
ENABLED_FLAG	Grade point enabled flag
START_DATE_ACTIVE	Date before which the grade is invalid
END_DATE_ACTIVE	Date after which the grade is invalid
OBJECT_VERSION_NUMBER	System-generated version of row. Increment by one with each update
LAST_UPDATE_DATE	Standard WHO column
GRADE_POINT_ID	Unique identifier for the grade point
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column

Human Resources - PER_KR_GRADE_AMOUNT_F	KR specific
Column Name	Descritpion
EFFECTIVE_START_DATE	Effective start date
ATTRIBUTE8	Descriptive flexfield column
ATTRIBUTE9	Descriptive flexfield column
ATTRIBUTE10	Descriptive flexfield column
ATTRIBUTE11	Descriptive flexfield column
ATTRIBUTE12	Descriptive flexfield column
ATTRIBUTE13	Descriptive flexfield column
ATTRIBUTE14	Descriptive flexfield column
ATTRIBUTE15	Descriptive flexfield column
ATTRIBUTE16	Descriptive flexfield column
ATTRIBUTE17	Descriptive flexfield column
EFFECTIVE_END_DATE	Effective end date
ATTRIBUTE18	Descriptive flexfield column
ATTRIBUTE19	Descriptive flexfield column
ATTRIBUTE20	Descriptive flexfield column
ATTRIBUTE21	Descriptive flexfield column
ATTRIBUTE22	Descriptive flexfield column
ATTRIBUTE23	Descriptive flexfield column
ATTRIBUTE24	Descriptive flexfield column
ATTRIBUTE25	Descriptive flexfield column
ATTRIBUTE26	Descriptive flexfield column
ATTRIBUTE27	Descriptive flexfield column
GRADE_ID	Foreign key to PER_KR_GRADES
ATTRIBUTE28	Descriptive flexfield column
ATTRIBUTE29	Descriptive flexfield column
ATTRIBUTE30	Descriptive flexfield column
GRADE_AMOUNT	Amount for the grade
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
GRADE_AMOUNT_ID	Unique identifier for the grade amount
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
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

Human Resources - PER_PERIODS_OF_PLACEMENT	Periods of placement details for a non-payrolled worker
Column Name	Descritpion
PERIOD_OF_PLACEMENT_ID	System generated primary key column. There is also a user-key on this table (person_id and date_start). This PK is implemented because of API standards and alter effective date form functionality.
ATTRIBUTE11	Descriptive flexfield column
ATTRIBUTE12	Descriptive flexfield column
BUSINESS_GROUP_ID	Foreign key to hr_organization_units
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
ATTRIBUTE22	Descriptive flexfield column
PERSON_ID	Foreign key to per_all_people_f
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
INFORMATION_CATEGORY	Developer Descriptive flexfield structure defining column
INFORMATION1	Developer Descriptive flexfield column
DATE_START	Start date of period of placement
INFORMATION2	Developer Descriptive flexfield column
INFORMATION3	Developer Descriptive flexfield column
INFORMATION4	Developer Descriptive flexfield column
INFORMATION5	Developer Descriptive flexfield column
INFORMATION6	Developer Descriptive flexfield column
INFORMATION7	Developer Descriptive flexfield column
INFORMATION8	Developer Descriptive flexfield column
INFORMATION9	Developer Descriptive flexfield column
INFORMATION10	Developer Descriptive flexfield column
INFORMATION11	Developer Descriptive flexfield column
ACTUAL_TERMINATION_DATE	Actual date of termination of period of placement
INFORMATION12	Developer Descriptive flexfield column
INFORMATION13	Developer Descriptive flexfield column
INFORMATION14	Developer Descriptive flexfield column
INFORMATION15	Developer Descriptive flexfield column
INFORMATION16	Developer Descriptive flexfield column
INFORMATION17	Developer Descriptive flexfield column
INFORMATION18	Developer Descriptive flexfield column
INFORMATION19	Developer Descriptive flexfield column
INFORMATION20	Developer Descriptive flexfield column
INFORMATION21	Developer Descriptive flexfield column
FINAL_PROCESS_DATE	Final date for all payroll processing of this person.
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
CREATED_BY	AOL Who Columns
LAST_STANDARD_PROCESS_DATE	Last date for including the person in any standard payroll processing.
CREATION_DATE	AOL Who Columns
LAST_UPDATED_BY	AOL Who Columns
PROJECTED_TERMINATION_DATE	Projected date of termination of period of placement. For information.
LAST_UPDATE_DATE	AOL Who Columns
LAST_UPDATE_LOGIN	AOL Who Columns
TERMINATION_REASON	Reason for terminating placement
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield column
ATTRIBUTE2	Descriptive flexfield column
OBJECT_VERSION_NUMBER	system generated version of row. Incremented with each update.
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

Human Resources - PER_HEADCOUNT_PORTLET_TBL
Column Name	Descritpion
PERIOD
TOTAL
GAIN
LOSS
NET
ANNUALIZED_PERCENT
LAST_UPDATE_DATE

Human Resources - PER_SECURITY_ORGANIZATIONS	List of organizations to include or exclude from security list
Column Name	Descritpion
ORGANIZATION_ID	organization identifier
LAST_UPDATE_DATE	WHO column
LAST_UPDATE_LOGIN	WHO column
CREATED_BY	WHO column
CREATION_DATE	WHO column
SECURITY_PROFILE_ID	security profile identifier
ENTRY_TYPE	entry type
SECURITY_ORGANIZATION_ID	security organization identifier
OBJECT_VERSION_NUMBER	internal used by APIs
LAST_UPDATED_BY	WHO column

Human Resources - PER_NL_ABSENCE_ACTIONS	Dutch Specific Absence Actions
Column Name	Descritpion
ABSENCE_ACTION_ID	Absence Action ID
LAST_UPDATE_DATE	STANDARD WHO Column
LAST_UPDATE_BY	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	STANDARD WHO Column
ENABLED	Enable absence action
ABSENCE_ATTENDANCE_ID	Absence Attendance ID
EXPECTED_DATE	Absence Action Expected Date
DESCRIPTION	Absence Action Description
ACTUAL_START_DATE	Absence Action Actual Start Date
ACTUAL_END_DATE	Absence Action Actual End Date
HOLDER	Holder
COMMENTS	Absence Action Comments
DOCUMENT_LINK	Absence Action Attached Document
DOCUMENT_FILE_NAME	Holds the File Name of the Absence Action Attached Document

Human Resources - PER_NL_ABSENCE_CHANGES	Dutch Specific Absence Changes
Column Name	Descritpion
ABSENCE_ATTENDANCE_ID	Absence Attendance ID
DATE_CHANGED	Date Changed
UPDATE_TYPE	Update Type
REPORTED_INDICATOR	Reported Indicator
PERSON_ID	Person ID
SICKNESS_START_DATE	Sickness Start Date
PERCENTAGE_SICK	Percentage Sick
RECOVERY_DATE	Recovery Date

Human Resources - PER_NL_ASG_SCL_UPGRADE	Records the Dutch Assignment SCL Context Information Migrated used by the Report
Column Name	Descritpion
BUSINESS_GROUP_ID	Business Group Id
PERSON_ID	Person Id
ASSIGNMENT_ID	Assignment ID
EFFECTIVE_START_DATE	Effective Start Date
EFFECTIVE_END_DATE	Effective End Date
RECORD_TYPE	Record Type
REPORT_TEXT	Record text

Human Resources - PER_QUALIFICATIONS_TL	Translated qualification details.
Column Name	Descritpion
LANGUAGE	Defined language
SOURCE_LANG	Actual language
TITLE	Translated TITLE from PER_QUALIFICATIONS
GROUP_RANKING	Translated group_ranking
LICENSE_RESTRICTIONS	Translated license_restrictions
AWARDING_BODY	Translated awarding_body
GRADE_ATTAINED	Translated grade_attained
REIMBURSEMENT_ARRANGEMENTS	Translated reimbursement_arrangements
QUALIFICATION_ID	Foreign key to PER_QUALIFICATIONS
TRAINING_COMPLETED_UNITS	Translated training_completed_units
MEMBERSHIP_CATEGORY	Translated membership_category
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 - PER_RATING_SCALES_TL	Translated rating scale name and description.
Column Name	Descritpion
RATING_SCALE_ID
LANGUAGE
SOURCE_LANG
NAME	Translated name of the rating scale.
DESCRIPTION	Translated description of the rating scale.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
LAST_UPDATED_BY	Standrd Who column
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column

Human Resources - PER_RATING_LEVELS_TL	A rating scale step is a single point on a rating scale and is used to rate competences.
Column Name	Descritpion
RATING_LEVEL_ID	Unique identifier of the Rating Level
LAST_UPDATE_LOGIN	Standard Who columns.
LANGUAGE	Defined language
SOURCE_LANG	Actual language
NAME	A description of the rating level that the step indicates e.g. Poor, Average, Excellent
BEHAVIOURAL_INDICATOR	A description of the behavioural charactaristics that would typically be displayed when the competence is possessed at this level
CREATED_BY	Standard Who columns.
CREATION_DATE	Standard Who columns.
LAST_UPDATED_BY	Standard Who columns.
LAST_UPDATE_DATE	Standard Who columns.

Human Resources - PER_QUALIFICATION_TYPES_TL	Maintains the list of qualiification type translations
Column Name	Descritpion
LANGUAGE	Defined Language
SOURCE_LANG	Actual language
NAME	Holds translated name of qualification type.
CREATED_BY	Standard Who columns.
CREATION_DATE	Standard Who columns.
LAST_UPDATED_BY	Standard Who columns.
LAST_UPDATE_DATE	Standard Who columns.
LAST_UPDATE_LOGIN	Standard Who columns.
QUALIFICATION_TYPE_ID	PK of entity

Human Resources - PER_JOBS_TL	Translated columns for per_jobs
Column Name	Descritpion
JOB_ID	Foreign key to per_jobs
LANGUAGE	Defined language.
SOURCE_LANG	Actual language
NAME	Translated Job name, concatenated from the keyflex structure.
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 - PER_SUBJECTS_TAKEN_TL	Translated grade_attained.
Column Name	Descritpion
LANGUAGE	Defined Language
SOURCE_LANG	Actual Language
GRADE_ATTAINED	Translated grade attained for a subject.
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
SUBJECTS_TAKEN_ID	Foreign Key to PER_SUBJECTS_TAKEN

Human Resources - PER_RI_SETUP_SUB_TASKS	Workbench setup sub-tasks
Column Name	Descritpion
SETUP_SUB_TASK_SEQUENCE	Setup sub task sequence
SETUP_SUB_TASK_STATUS	Setup sub task status
SETUP_SUB_TASK_TYPE	Setup task type
SETUP_SUB_TASK_DATA_PUMP_LINK	Setup sub task data pump link
SETUP_SUB_TASK_ACTION	Setup task action
SETUP_SUB_TASK_CREATION_DATE	Setup task creation date
SETUP_SUB_TASK_CODE	Setup sub task code
SETUP_SUB_TASK_LAST_MOD_DATE	Setup task last modified date
LAST_UPDATE_DATE	Standard Who column
SETUP_TASK_CODE	Setup Task Code
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
CREATED_BY	Standard who column
CREATION_DATE	Standard who column
OBJECT_VERSION_NUMBER	Object Version Number
LEGISLATION_CODE	Legislation Code

Human Resources - PER_RI_SETUP_SUB_TASKS_TL	TL table for PER_RI_SETUP_SUB_TASKS
Column Name	Descritpion
LANGUAGE	Language
SOURCE_LANG	Source language
SETUP_SUB_TASK_NAME	Setup sub task name
SETUP_SUB_TASK_DESCRIPTION	Setup sub task description
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
CREATED_BY	Standard who column
SETUP_SUB_TASK_CODE	Setup sub task code
CREATION_DATE	Standard who column

Human Resources - PER_RI_SETUP_TASKS	Workbench Setup Tasks
Column Name	Descritpion
WORKBENCH_ITEM_CODE	Workbench Item code
SETUP_TASK_SEQUENCE	Setup task sequence
SETUP_TASK_STATUS	Setup task status
SETUP_TASK_CREATION_DATE	Setup task creation date
SETUP_TASK_LAST_MODIFIED_DATE	Setup task last modified date
SETUP_TASK_TYPE	Setup task type
SETUP_TASK_CODE	Setup Task Code
SETUP_TASK_ACTION	Setup task action
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

Human Resources - PER_RI_SETUP_TASKS_TL	TL table for PER_RI_SETUP_TASKS table
Column Name	Descritpion
LANGUAGE	Language
SOURCE_LANG	Source language
SETUP_TASK_NAME	Setup task name
SETUP_TASK_DESCRIPTION	Setup task description
LAST_UPDATE_DATE	Standard who column
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_LOGIN	Standard who column
CREATED_BY	Standard who column
SETUP_TASK_CODE	Setup task code
CREATION_DATE	Standard who column

Human Resources - PER_RI_VIEW_REPORTS	Stores data related to view reports for HRMS
Column Name	Descritpion
WORKBENCH_VIEW_REPORT_CODE	Workbench report code
WORKBENCH_VIEW_REPORT_TYPE	Workbench view report type
WORKBENCH_VIEW_REPORT_ACTION	workbench view report action
WORKBENCH_VIEW_COUNTRY	workbench view country
WB_VIEW_REPORT_INSTRUCTION	Workbench view report instruction
LAST_UPDATE_DATE	Standard WHO column
WORKBENCH_ITEM_CODE	Workbench item code
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
OBJECT_VERSION_NUMBER	Object Version Number

Human Resources - PER_RI_VIEW_REPORTS_TL	Workbench View Reports Translation Table
Column Name	Descritpion
LANGUAGE	Language
SOURCE_LANG	Source Language
WORKBENCH_VIEW_REPORT_NAME	Workbench view report name
WB_VIEW_REPORT_DESCRIPTION	Workbench view report description
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
CREATED_BY	Standard WHO column
WORKBENCH_VIEW_REPORT_CODE	Workbench View Report Code
CREATION_DATE	Standard WHO column

Human Resources - PER_RI_WORKBENCH_ITEMS	Workbench items
Column Name	Descritpion
MENU_ID	Menu_id
WORKBENCH_ITEM_SEQUENCE	Workbench item sequence
WORKBENCH_PARENT_ITEM_CODE	Workbench parent item code
WORKBENCH_ITEM_CREATION_DATE	Workbench item creation date
WORKBENCH_ITEM_TYPE	Workbench item type
OBJECT_VERSION_NUMBER	Object version number
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
WORKBENCH_ITEM_CODE	Workbench Item code
LAST_UPDATE_LOGIN	Standard WHO Column
CREATED_BY	Srandard WHO column
CREATION_DATE	Standard WHO column

Human Resources - PER_RI_WORKBENCH_ITEMS_TL	Translation table for Per_ri_workbench_items
Column Name	Descritpion
LANGUAGE	Language
SOURCE_LANG	Source Language
WORKBENCH_ITEM_NAME	Workbench Item name
WORKBENCH_ITEM_DESCRIPTION	Workbench Item description
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
CREATED_BY	Standard WHO Column
WORKBENCH_ITEM_CODE	Workbench item code
CREATION_DATE	Standard WHO Column

Human Resources - PER_RI_DEPENDENCIES	Dependencies among Workbench tasks
Column Name	Descritpion
DEPENDENT_ITEM_CODE	Dependent Item Code
DEPENDENCY_ITEM_SEQUENCE	Dependency Item Sequence
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
WORKBENCH_ITEM_CODE	Workbench Item Code

Human Resources - PER_RI_REQUESTS	Concurrent requests for workbench componenets
Column Name	Descritpion
BATCH_ID	Batch Id
REQUEST_ID	Request Id
BUSINESS_GROUP_ID	Business 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
SETUP_TASK_CODE	Setup Task Code
CONTEXT_CODE	Context Code

Human Resources - PER_PERSON_LIST_CHG_ARCH	Archive table to hold content of PER_PERSON_LIST_CHANGES on upgrade.
Column Name	Descritpion
PERSON_ID	Foreign key to PER_PEOPLE.
SECURITY_PROFILE_ID	Foreign key to PER_SECURITY_PROFILES.
INCLUDE_FLAG	Include person in person list Y/N.
TERMINATION_FLAG	Y if the person is in this list because they are terminated.
REQUEST_ID	Standard Who Column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who Column.
PROGRAM_UPDATE_DATE	Standard Who column.

Human Resources - PER_SECURITY_USERS	List of users for a security profile whose access permissions will be stored in static lists duringSecurity List Maintenance.
Column Name	Descritpion
SECURITY_PROFILE_ID	Foreign key to PER_SECURITY_PROFILES.
USER_ID	Foreign key to FND_USER.
PROCESS_IN_NEXT_RUN_FLAG
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
SECURITY_USER_ID	System-generated primary key column.
CREATION_DATE	Standard Who column.

Human Resources - PER_INTERIM_ENTITY_LIST
Column Name	Descritpion
ENTITY_NAME
STATE
PK1
PK2
PK3
PK4
PK5

Human Resources - PER_RI_RT_GEN	TestSuite Generator Request Details
Column Name	Descritpion
JOB_NAME	Job Name
REQUEST_ID	The Request ID
USER_ID	The User ID
SUBMISSION_DATE	The Date of Submission
COMPLETION_DATE	The Date of Completion
REQUEST_STATUS	Request Status
REQUEST_PHASE	Request Phase
TEST_SUITE	The Blob Column containing the test suite

Human Resources - PER_RI_CONFIG_INFORMATION	To Store Input Values Specified by the user in Rapid Implementation Configuration Wizard
Column Name	Descritpion
CONFIG_INFORMATION_ID	Primary Key, System Generated Sequence Number
CONFIG_INFORMATION17	Configuration Information 17
CONFIG_INFORMATION18	Configuration Information 18
CONFIG_INFORMATION19	Configuration Information 19
CONFIG_INFORMATION20	Configuration Information 20
CONFIG_INFORMATION21	Configuration Information 21
CONFIG_INFORMATION22	Configuration Information 22
CONFIG_INFORMATION23	Configuration Information 23
CONFIG_INFORMATION24	Configuration Information 24
CONFIG_INFORMATION25	Configuration Information 25
CONFIG_INFORMATION26	Configuration Information 26
CONFIG_SEQUENCE	Sequence of the Configuration
CONFIG_INFORMATION27	Configuration Information 27
CONFIG_INFORMATION28	Configuration Information 28
CONFIG_INFORMATION_CATEGORY	Lookup PER_RI_CONFIGURATION_CATEGORY
CONFIG_INFORMATION29	Configuration Information 29
CONFIG_INFORMATION30	Configuration Information 30
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
CONFIG_INFORMATION1	Configuration Information 1
CONFIG_INFORMATION2	Configuration Information 2
CONFIG_INFORMATION3	Configuration Information 3
CONFIG_INFORMATION4	Configuration Information 4
CONFIG_INFORMATION5	Configuration Information 5
CONFIG_INFORMATION6	Configuration Information 6
CONFIGURATION_CODE	Foreign Key (PER_RI_CONFIGURATIONS.CONFIGURATION_CODE)
CONFIG_INFORMATION7	Configuration Information 7
CONFIG_INFORMATION8	Configuration Information 8
CONFIG_INFORMATION9	Configuration Information 9
CONFIG_INFORMATION10	Configuration Information 10
CONFIG_INFORMATION11	Configuration Information 11
CONFIG_INFORMATION12	Configuration Information 12
CONFIG_INFORMATION13	Configuration Information 13
CONFIG_INFORMATION14	Configuration Information 14
CONFIG_INFORMATION15	Configuration Information 15
CONFIG_INFORMATION16	Configuration Information 16

Human Resources - PER_PTU_DFF_MAPPING_HEADERS	Table for storing DFF migration mapping Information from PER_ALL_PEOPLE_F to PER_PERSON_TYPE_USAGES_F.
Column Name	Descritpion
MAPPING_HEADER_ID	System generated primary key from PER_PTU_DFF_MAPPING_HEADERS_S.
LAST_UPDATED_BY	Standard Who Column.
LAST_UPDATE_DATE	Standard Who Column.
LAST_UPDATE_LOGIN	Standard Who Column.
PER_DFF_CONTEXT_FIELD_CODE	The Context field value defined for the PER_PEOPLE DFF.
PER_DFF_CONTEXT_FIELD_NAME	The name of the reference field for the PER_PEOPLE DFF.
PER_DFF_CONTEXT_FIELD_DESC	The Context name.
DATA_MAPPING_COMPLETE	Data mapping code Y or N.
REQUEST_ID	Standard Who Column.
MIGRATION_STATUS	Migration Status COMPLETE or PENDING.
CREATED_BY	Standard Who Column.
CREATION_DATE	Standard Who Column.

Human Resources - PER_RI_CONFIGURATIONS	This table stores information about configurations created by the users including the name,description and status of the configuration
Column Name	Descritpion
CONFIGURATION_TYPE	Stores information about the configuration type, Lookup PER_RI_CONFIGURATION_TYPE
CONFIGURATION_STATUS	Status of the configuration that has been saved. Lookup PER_RI_CONFIGURATION_STATUS
OBJECT_VERSION_NUMBER	Object Version Number
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
CONFIGURATION_CODE	Primary Key to the PER_RI_CONFIGURATIONS table, System Generated number

Human Resources - PER_PTU_DFF_MAPPING_LINES	Table for storing DFF migration mapping Information from PER_ALL_PEOPLE_F to PER_PERSON_TYPE_USAGES_F.
Column Name	Descritpion
MAPPING_LINE_ID	System generated primary key from PER_PTU_DFF_MAPPING_LINES_S.
CREATION_DATE	Standard Who Column.
LAST_UPDATED_BY	Standard Who Column.
LAST_UPDATE_DATE	Standard Who Column.
LAST_UPDATE_LOGIN	Standard Who Column.
MAPPING_HEADER_ID	Foreign key to PER_PTU_DFF_MAPPING_HEADERS.
PER_DFF_ATTRIBUTE	Descriptive flexfield column name of the PER_PEOPLE DFF.
PER_END_USER_COLUMN_NAME	End user coulmn name of the Descriptive flexfield column.
PTU_DFF_CONTEXT_FIELD_CODE	The Context field value defined for the PER_PERSON_TYPE_USAGES DFF.
PTU_DFF_CONTEXT_FIELD_DESC	The Context name.
PTU_DFF_ATTRIBUTE	Descriptive flexfield column name of the PER_PERSON_TYPE_USAGES DFF.
PTU_END_USER_COLUMN_NAME	End user coulmn name of the Descriptive flexfield column.
CREATED_BY	Standard Who Column.

Human Resources - PER_PTU_DFF_MIG_FAILED_PEOPLE	This table is used to store the details of the person records failed to migrate to PER_PERSON_TYPE_USAGES_F from PER_ALL_PEOPLE_F.
Column Name	Descritpion
PERSON_ID	Person ID from PER_ALL_PEOPLE_F.
LAST_UPDATE_LOGIN	Standard Who Column.
BUSINESS_GROUP_ID	Business Group Id of the Person.
REQUEST_ID	Standard Who Column.
ERROR_DESCRIPTION	The description of the error occurred in the migration process.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
CREATED_BY	Standard Who Column.
CREATION_DATE	Standard Who Column.
LAST_UPDATED_BY	Standard Who Column.
LAST_UPDATE_DATE	Standard Who Column.

Human Resources - PER_RI_CONFIGURATIONS_TL	This is the Translation Table for the PER_RI_CONFIGURATIONS table
Column Name	Descritpion
CONFIGURATION_NAME	The Name of the Configuration
CONFIGURATION_DESCRIPTION	Configuration Description
LANGUAGE	Language
SOURCE_LANG	Source Language
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
CREATED_BY	Standard WHO Column
CONFIGURATION_CODE	Foreign Key to PER_RI_CONFIGURATIONS.CONFIGURATION_CODE
CREATION_DATE	Standard WHO Column

Human Resources - PER_RI_CONFIG_DEFAULTS	This table store the default values for the parameters which needs to be passed in the PL/SQL APIs calls to insert rows into datapump batch lines table (HR_PUMP_BATCH_LINES). This is another key table for Organization Structures Configurati
Column Name	Descritpion
PARAMETER_NAME	Primary Key, Name of the Parameter
PARAMETER_DEFAULT_VALUE	Default Value for the Parameter
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_NAME	Primary Key, API Module Name

Human Resources - PER_RI_CONFIG_LOCATIONS	This stores locations information specified by the user in the Organization Structures Configuration wizard (configurations) it is required to have this table since we need to show all the legislation specific validation from flexfield when
Column Name	Descritpion
CONFIGURATION_CONTEXT	Lookup PER_RI_CONFIG_LOCATION_CONTEXT
LOC_INFORMATION13	Location Information 13
LOC_INFORMATION14	Location Information 14
LOC_INFORMATION15	Location Information 15
LOC_INFORMATION16	Location Information 16
LOC_INFORMATION17	Location Information 17
LOC_INFORMATION18	Location Information 18
LOC_INFORMATION19	Location Information 19
LOC_INFORMATION20	Location Information 20
OBJECT_VERSION_NUMBER	Object Version Number
LAST_UPDATE_DATE	Standard WHO Column
LOCATION_ID	Sequence, Stores the Location ID
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
LOCATION_CODE	Location Code
DESCRIPTION	Description of the Location
STYLE	Location Style
ADDRESS_LINE_1	Adddress Line 1
ADDRESS_LINE_2	Address Line 2
CONFIGURATION_CODE	Foreign Key (PER_RI_CONFIGURATIONS.CONFIGURATION_CODE)
ADDRESS_LINE_3	Address Line 3
TOWN_OR_CITY	Town Or City
COUNTRY	Country Name
POSTAL_CODE	Postal Code
REGION_1	Region 1
REGION_2	Region 2
REGION_3	Region 3
TELEPHONE_NUMBER_1	Telephone Number 1
TELEPHONE_NUMBER_2	Telephone Number 2
TELEPHONE_NUMBER_3	Telephone Number 3

Human Resources - PER_TASKS_IN_CHECKLIST
Column Name	Descritpion
CHECKLIST_ID
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.
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.
CHECKLIST_TASK_NAME	Checklist Task Identifier Primary Key
INFORMATION_CATEGORY	Developer Descriptive Flexfield structure defining column
INFORMATION1	Developer-Descriptive Flexfield Segment
INFORMATION2	Developer-Descriptive Flexfield Segment
INFORMATION3	Developer-Descriptive Flexfield Segment
INFORMATION4	Developer-Descriptive Flexfield Segment
INFORMATION5	Developer-Descriptive Flexfield Segment
INFORMATION6	Developer-Descriptive Flexfield Segment
INFORMATION7	Developer-Descriptive Flexfield Segment
INFORMATION8	Developer-Descriptive Flexfield Segment
INFORMATION9	Developer-Descriptive Flexfield Segment
ELIGIBILITY_OBJECT_ID	Foreign key to BEN_ELIG_OBJ_F.ELIG_OBJ_ID
INFORMATION10	Developer-Descriptive Flexfield Segment
INFORMATION11	Developer-Descriptive Flexfield Segment
INFORMATION12	Developer-Descriptive Flexfield Segment
INFORMATION13	Developer-Descriptive Flexfield Segment
INFORMATION14	Developer-Descriptive Flexfield Segment
INFORMATION15	Developer-Descriptive Flexfield Segment
INFORMATION16	Developer-Descriptive Flexfield Segment
INFORMATION17	Developer-Descriptive Flexfield Segment
ELIGIBILITY_PROFILE_ID
INFORMATION18	Developer-Descriptive Flexfield Segment
INFORMATION19	Developer-Descriptive Flexfield Segment
AME_ATTRIBUTE_IDENTIFIER
INFORMATION20	Developer-Descriptive Flexfield Segment
DESCRIPTION	Description of the Checklist
MANDATORY_FLAG	Denotes whether this task is mandatory or not.
TARGET_DURATION	Target Duration units
TARGET_DURATION_UOM	Target Duration Unit of measure (Days. Weeks, Months)
TASK_IN_CHECKLIST_ID
TASK_SEQUENCE
ACTION_URL
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.

Human Resources - PER_OBJECTIVES_LIBRARY	This table holds a library of objectives - objectives that are well written, SMART and re-usable.
Column Name	Descritpion
OBJECTIVE_ID	System generated objective primary key from PER_OBJECTIVES_LIBRARY_S.
ATTRIBUTE2	Descriptive flexfield column.
TARGET_DATE	The date by when the objective should be met.
ATTRIBUTE3	Descriptive flexfield column.
ATTRIBUTE4	Descriptive flexfield column.
ATTRIBUTE5	Descriptive flexfield column.
ATTRIBUTE6	Descriptive flexfield column.
ATTRIBUTE7	Descriptive flexfield column.
ATTRIBUTE8	Descriptive flexfield column.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
ATTRIBUTE21	Descriptive flexfield column.
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.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
NEXT_REVIEW_DATE	Informational-only date to indicate when the objective should next be reviewed.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
GROUP_CODE	Uses the lookup type HR_WPM_GROUP to categorize objectives.
PRIORITY_CODE	Uses the lookup type HR_WPM_PRIORITY to provide a default priority.
OBJECTIVE_NAME	A short reference to summarize the objective.
APPRAISE_FLAG	Uses the lookup type YES_NO to provide a default for whether this objective should be appraised.
WEIGHTING_PERCENT	Provides a default weighting for this objective, used to score overall appraisal ratings.
MEASUREMENT_STYLE_CODE	Uses the lookup type HR_WPM_MEASUREMENT_STYLE to indicate the style of measurement.
MEASURE_NAME	The measure by which this objective's completion should be scored against.
TARGET_VALUE	The target measure, either a Maximum target or a Minimum target, depending on the measure_type.
VALID_FROM	The date from which the objective is valid.
UOM_CODE	Uses the lookup type HR_WPM_MEASURE_UOM to determine the measure's unit of measure.
MEASURE_TYPE_CODE	Uses the lookup type HR_WPM_MEASURE_TYPE to determine whether the target measure is a minimum or maximum.
VALID_TO	The date when the objective is no longer valid.
MEASURE_COMMENTS	Comments regarding the measure and target.
ELIGIBILITY_TYPE_CODE	Uses the lookup type HR_WPM_ELIGIBILITY to determine the type of eligibility used.
DETAILS	Provides further objective details.
SUCCESS_CRITERIA	Additional criteria that determines the success of this objective.
COMMENTS	General comments about this objective.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
ATTRIBUTE1	Descriptive flexfield column.

Human Resources - PER_SCORECARD_SHARING	This table holds access permisssions for what people can access which scorecard.
Column Name	Descritpion
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
SCORECARD_ID	The scorecard for which designated objectives are shared.
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.
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.
ATTRIBUTE22	Descriptive flexfield column.
PERSON_ID	The ID of the person that has access to the scorecard being shared.
ATTRIBUTE23	Descriptive flexfield column.
ATTRIBUTE24	Descriptive flexfield column.
ATTRIBUTE25	Descriptive flexfield column.
ATTRIBUTE26	Descriptive flexfield column.
ATTRIBUTE27	Descriptive flexfield column.
ATTRIBUTE28	Descriptive flexfield column.
ATTRIBUTE29	Descriptive flexfield column.
ATTRIBUTE30	Descriptive flexfield column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
SHARING_INSTANCE_ID	System generated sharing instance primary key from PER _SCORECARD_SHARING_S.

Human Resources - PER_PERF_MGMT_PLANS	This table holds Performance Management Plans - a plan that controls and automates goal setting and performance management by defining the time-period, the people, and the process.
Column Name	Descritpion
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
ASSIGNMENT_TYPES_CODE	Uses HR_WPM_ASG_TYPES to determine which assignments will receive a scorecard.
PRIMARY_ASG_ONLY_FLAG	When set to 'Y', personal scorecards are only created for the primary assignment.
INCLUDE_OBJ_SETTING_FLAG	When set to 'Y', it indicates that objective setting will be part of this plan's process.
OBJ_SETTING_START_DATE	The date when objective setting should start.
OBJ_SETTING_DEADLINE	The date by which objectives should be set.
OBJ_SET_OUTSIDE_PERIOD_FLAG	When set to 'Y', objectives can be set at any point during the plan.
METHOD_CODE	Uses HR_WPM_PLAN_METHOD to determine the method of setting objectives: 'CAS' for a cascading objectives method, 'PAR' for non-cascading method.
NOTIFY_POPULATION_FLAG	When set to 'Y', notifications will be automatically sent to the plan's population.
AUTOMATIC_ALLOCATION_FLAG	When set to 'Y', objectives from the objectives library are automatically allocated to plan members that are eligible.
COPY_PAST_OBJECTIVES_FLAG	When set to 'Y', incomplete objectives are copied from the Previous Plan (as defined against this plan). When the Previous Plan is not defined, incomplete objectives are instead copied from the most recent past appraisal (which itself cann
PLAN_NAME	The name for the performance management plan.
SHARING_ALIGNMENT_TASK_FLAG	When set to 'Y', an additional manager and employee task is displayed for objective sharing and alignment.
INCLUDE_APPRAISALS_FLAG	When set to 'Y', it indicates that appraisals will be part of this plan's process.
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.
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.
ATTRIBUTE22	Descriptive flexfield column.
ADMINISTRATOR_PERSON_ID	The designated person who is the administrator of the plan.
ATTRIBUTE23	Descriptive flexfield column.
ATTRIBUTE24	Descriptive flexfield column.
ATTRIBUTE25	Descriptive flexfield column.
ATTRIBUTE26	Descriptive flexfield column.
ATTRIBUTE27	Descriptive flexfield column.
ATTRIBUTE28	Descriptive flexfield column.
ATTRIBUTE29	Descriptive flexfield column.
ATTRIBUTE30	Descriptive flexfield column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
PREVIOUS_PLAN_ID	The Id of the Performance Management Plan that preceded this one.
START_DATE	The date when the plan starts.
END_DATE	The date when the plan ends.
STATUS_CODE	Uses the lookup type HR_WPM_PLAN_STATUS to define the plan's status.
HIERARCHY_TYPE_CODE	Uses the lookup type HR_WPM_PLAN_HIER_TYPE to define the type of hierarchy used to define the plan's population.
PLAN_ID	System generated plan primary key from PER_PERF_MGMT_PLANS_S.
SUPERVISOR_ID	When the hierarchy type is 'SUP', this is the top supervisor in the hierarchy.
SUPERVISOR_ASSIGNMENT_ID	When the hierarchy type is 'SUP_ASG', this is the assignment for the top supervisor in the hierarchy.
ORGANIZATION_STRUCTURE_ID	When the hierarchy type is 'ORG', this is the organization hierarchy used to define the plan's population.
ORG_STRUCTURE_VERSION_ID	The version number of the organization hierarchy.
TOP_ORGANIZATION_ID	When the hierarchy type is 'ORG', this is the top organization in the hierarchy.
POSITION_STRUCTURE_ID	When the hierarchy type is 'POS', this is the position hierarchy used to define the plan's population.
POS_STRUCTURE_VERSION_ID	The version number of the position hierarchy.
TOP_POSITION_ID	When the hierarchy type is 'POS', this is the top position in the hierarchy.
HIERARCHY_LEVELS	The levels to go down the hierarchy before excluding people from the plan's population; null for all levels.
AUTOMATIC_ENROLLMENT_FLAG	When set to 'Y', life events are used to automatically enroll/de-enroll people from the plan.

Human Resources - PER_PERSONAL_SCORECARDS	This table holds Personal Scorecards - one worker's objectives for one particular performance management plan, which provides a goal setting, performance review and scoring basis.
Column Name	Descritpion
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
SCORECARD_NAME	The name for the scorecard, normally defaulted from the plan name.
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.
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.
ATTRIBUTE22	Descriptive flexfield column.
PERSON_ID	The person to which this scorecard belongs. This column is denormalized to improve query performance.
ATTRIBUTE23	Descriptive flexfield column.
ATTRIBUTE24	Descriptive flexfield column.
ATTRIBUTE25	Descriptive flexfield column.
ATTRIBUTE26	Descriptive flexfield column.
ATTRIBUTE27	Descriptive flexfield column.
ATTRIBUTE28	Descriptive flexfield column.
ATTRIBUTE29	Descriptive flexfield column.
ATTRIBUTE30	Descriptive flexfield column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
ASSIGNMENT_ID	The assignment of the person to which this scorecard belongs.
START_DATE	The date when the scorecard becomes effective, normally defaulted from the plan start date.
END_DATE	The date when the scorecard becomes ineffective, normally defaulted from the plan end date.
PLAN_ID	The performance management plan to which this scorecard belongs.
STATUS_CODE	Uses the lookup type HR_WPM_SCORECARD_STATUS to define the scorecard's status.
SCORECARD_ID	System generated scorecard primary key from PER_PERSONAL_SCORECARDS_S.
CREATOR_TYPE	Defines how the scorecard was created: 'AUTO' when the scorecard was created automatically during plan publication, or 'MANUAL' when it was created manually through the bespoke interfaces.
ERROR_LOG	If an error occurs during the transfer of this scorecard, this contains an error log.