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

Human Resources - PER_ABSENCE_ATTENDANCES	Records of absence, or attendance for an employee.
Column Name	Descritpion
ABSENCE_ATTENDANCE_ID	System-generated primary key column.
ABSENCE_HOURS	Duration of absence in hours. Entered by the user.
ABS_INFORMATION20	Developer descriptive flexfield column.
ABS_INFORMATION21	Developer descriptive flexfield column.
ABS_INFORMATION22	Developer descriptive flexfield column.
ABS_INFORMATION23	Developer descriptive flexfield column.
ABS_INFORMATION24	Developer descriptive flexfield column.
COMMENTS	General remark.
ABS_INFORMATION25	Developer descriptive flexfield column.
ABS_INFORMATION26	Developer descriptive flexfield column.
ABS_INFORMATION27	Developer descriptive flexfield column.
ABS_INFORMATION28	Developer descriptive flexfield column.
ABS_INFORMATION29	Developer descriptive flexfield column.
DATE_END	Actual end date of the absence period.
ABS_INFORMATION30	Developer descriptive flexfield column.
OBJECT_VERSION_NUMBER	OVN
DATE_NOTIFICATION	Date when absence was notified.
DATE_PROJECTED_END	Projected, or estimated end date for the absence period.
DATE_PROJECTED_START	Projected, or estimated start date for the absence period.
DATE_START	Actual start date of the absence period.
OCCURRENCE	The occurrence number for this type of absence.
SSP1_ISSUED	Used for Oracle SSP/SMP only. Indicates whether form SSP1 has been issued.
TIME_END	Actual end time for the absence period.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
TIME_PROJECTED_END	Projected, or estimated end time for the absence period.
TIME_PROJECTED_START	Projected, or estimated start time for the absence period.
TIME_START	Actual start time for the absence period.
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.
ABSENCE_ATTENDANCE_TYPE_ID	Type of absence. Foreign key to PER_ABSENCE_ATTENDANCE_TYPES.
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.
ABS_ATTENDANCE_REASON_ID	Reason for absence. Foreign key to PER_ABS_ATTENDANCE_REASONS.
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.
PERSON_ID	Foreign key to PER_PEOPLE.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
MATERNITY_ID	Foreign key to SSP_MATERNITIES.
SICKNESS_START_DATE	Actual start date of a period of sickness.
SICKNESS_END_DATE	Actual end date of a period of sickness.
PREGNANCY_RELATED_ILLNESS	Indicates whether the illness was pregnancy-related.
REASON_FOR_NOTIFICATION_DELAY	Free text reason for a delay in notifying the absence.
ACCEPT_LATE_NOTIFICATION_FLAG	Flag to indicate whether late notification was accepted.
LINKED_ABSENCE_ID	Foreign key to PER_ABSENCE_ATTENDANCES.
AUTHORISING_PERSON_ID	Foreign key to PER_PEOPLE.
BATCH_ID	Batch number for an absence entered in batch mode using BEE.
ABS_INFORMATION_CATEGORY	Developer descriptive flexfield structure defining column.
ABS_INFORMATION1	Developer descriptive flexfield column.
ABS_INFORMATION2	Developer descriptive flexfield column.
ABS_INFORMATION3	Developer descriptive flexfield column.
ABS_INFORMATION4	Developer descriptive flexfield column.
REPLACEMENT_PERSON_ID	Foreign key to PER_PEOPLE.
ABS_INFORMATION5	Developer descriptive flexfield column.
ABS_INFORMATION6	Developer descriptive flexfield column.
ABS_INFORMATION7	Developer descriptive flexfield column.
ABS_INFORMATION8	Developer descriptive flexfield column.
ABS_INFORMATION9	Developer descriptive flexfield column.
PERIOD_OF_INCAPACITY_ID	Obsolete column.
ABS_INFORMATION10	Developer descriptive flexfield column.
ABS_INFORMATION11	Developer descriptive flexfield column.
ABS_INFORMATION12	Developer descriptive flexfield column.
ABS_INFORMATION13	Developer descriptive flexfield column.
ABS_INFORMATION14	Developer descriptive flexfield column.
ABSENCE_DAYS	Duration of absence in days. Entered by the user.
ABS_INFORMATION15	Developer descriptive flexfield column.
ABS_INFORMATION16	Developer descriptive flexfield column.
ABS_INFORMATION17	Developer descriptive flexfield column.
ABS_INFORMATION18	Developer descriptive flexfield column.
ABS_INFORMATION19	Developer descriptive flexfield column.

Human Resources - PER_ABSENCE_ATTENDANCE_TYPES	User defined absence types.
Column Name	Descritpion
ABSENCE_ATTENDANCE_TYPE_ID	System-generated primary key column.
INCREASING_OR_DECREASING_FLAG	Indicates whether an entry of this type should increase or decrease the running total for this absence type.
INFORMATION10
INFORMATION11
REQUEST_ID	Standard Who column.
INFORMATION12
INFORMATION13
PROGRAM_APPLICATION_ID	Standard Who column.
INFORMATION14
INFORMATION15
PROGRAM_ID	Standard Who column.
INFORMATION16
INFORMATION17
PROGRAM_UPDATE_DATE	Standard Who column.
INFORMATION18
INFORMATION19
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
INFORMATION20
ATTRIBUTE1	Descriptive flexfield column.
ATTRIBUTE2	Descriptive flexfield column.
ATTRIBUTE3	Descriptive flexfield column.
ATTRIBUTE4	Descriptive flexfield column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
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.
INPUT_VALUE_ID	Foreign key to PAY_INPUT_VALUES. Identifies associated nonrecurring element and input value to use for running total.
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.
DATE_EFFECTIVE	Date from which the absence type can be used.
CREATION_DATE	Standard Who column.
OBJECT_VERSION_NUMBER	Version number of current row
NAME	Name of the absence type.
INFORMATION_CATEGORY	Developer Descriptive flexfield structure column
INFORMATION1
ABSENCE_CATEGORY	Category of the absence type taken from ABSENCE_CATEGORY lookup.
INFORMATION2
INFORMATION3
COMMENTS	General remark.
INFORMATION4
INFORMATION5
DATE_END	Date after which the absence type can no longer be used.
INFORMATION6
INFORMATION7
HOURS_OR_DAYS	Key unit of measure for this type of absence.
INFORMATION8
INFORMATION9

Human Resources - PER_ABS_ATTENDANCE_REASONS	Valid absence reasons for an absence type.
Column Name	Descritpion
ABS_ATTENDANCE_REASON_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.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ABSENCE_ATTENDANCE_TYPE_ID	Foreign key to PER_ABSENCE_ATTENDANCE_TYPES.
NAME	The name of the absence reason (within absence type).
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_ADDRESSES	Address information for people.
Column Name	Descritpion
ADDRESS_ID	System-generated primary key column.
DERIVED_LOCALE	derived locale
PARTY_ID	Party Id
STYLE	Address style - foreign key to FND_TERRITORIES.
ADDRESS_LINE1	The first line of the address.
ADDRESS_LINE2	The second line of the address.
ADDRESS_LINE3	The third line of the address.
ADDRESS_TYPE	Address type, for example, home, business, weekend.
COMMENTS	General remark.
COUNTRY	Country.
DATE_TO	End date at this address.
POSTAL_CODE	National code to identify addresses in a specific country.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
REGION_1	Primary region in which the address is located.
REGION_2	Sub region of region 1 in which the address is located.
REGION_3	Sub region of region 2 in which the address is located.
TELEPHONE_NUMBER_1	Telephone number for the address.
TELEPHONE_NUMBER_2	Second telephone number for the address.
TELEPHONE_NUMBER_3	Third telephone number for the address.
TOWN_OR_CITY	Town or city name.
REQUEST_ID	Standard Who column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who column.
PERSON_ID	Foreign key to PER_PEOPLE.
PROGRAM_UPDATE_DATE	Standard Who column.
ADDR_ATTRIBUTE_CATEGORY	Developers Descriptive flexfield column.
ADDR_ATTRIBUTE1	Descriptive flexfield column.
ADDR_ATTRIBUTE2	Descriptive flexfield column.
ADDR_ATTRIBUTE3	Descriptive flexfield column.
ADDR_ATTRIBUTE4	Descriptive flexfield column.
ADDR_ATTRIBUTE5	Descriptive flexfield column.
ADDR_ATTRIBUTE6	Descriptive flexfield column.
ADDR_ATTRIBUTE7	Descriptive flexfield column.
ADDR_ATTRIBUTE8	Descriptive flexfield column.
DATE_FROM	Start date at the address.
ADDR_ATTRIBUTE9	Descriptive flexfield column.
ADDR_ATTRIBUTE10	Descriptive flexfield column.
ADDR_ATTRIBUTE11	Descriptive flexfield column.
ADDR_ATTRIBUTE12	Descriptive flexfield column.
ADDR_ATTRIBUTE13	Descriptive flexfield column.
ADDR_ATTRIBUTE14	Descriptive flexfield column.
ADDR_ATTRIBUTE15	Descriptive flexfield column.
ADDR_ATTRIBUTE16	Descriptive flexfield column.
ADDR_ATTRIBUTE17	Descriptive flexfield column.
ADDR_ATTRIBUTE18	Descriptive flexfield column.
PRIMARY_FLAG	Indicates whether this is the primary address for the person.
ADDR_ATTRIBUTE19	Descriptive flexfield column.
ADDR_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.
ADD_INFORMATION13	Developers Descriptive flexfield column.
ADD_INFORMATION14	Developers Descriptive flexfield column.
ADD_INFORMATION15	Developers Descriptive flexfield column.
ADD_INFORMATION16	Developers Descriptive flexfield column.
ADD_INFORMATION17	Developers Descriptive flexfield column.
ADD_INFORMATION18	Developers Descriptive flexfield column.
ADD_INFORMATION19	Developers Descriptive flexfield column.
ADD_INFORMATION20	Developers Descriptive flexfield column.

Human Resources - PER_ANALYSIS_CRITERIA	Flexfield combination table for the personal analysis key flexfield.
Column Name	Descritpion
ANALYSIS_CRITERIA_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.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
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_APPLICATIONS	Applications for employment.
Column Name	Descritpion
APPLICATION_ID	System-generated primary key column.
TERMINATION_REASON	Reason for terminating the application.
REQUEST_ID	Standard Who column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who column.
PROGRAM_UPDATE_DATE	Standard Who column.
APPL_ATTRIBUTE_CATEGORY	Descriptive flexfield column.
APPL_ATTRIBUTE1	Descriptive flexfield column.
APPL_ATTRIBUTE2	Descriptive flexfield column.
APPL_ATTRIBUTE3	Descriptive flexfield column.
APPL_ATTRIBUTE4	Descriptive flexfield column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
APPL_ATTRIBUTE5	Descriptive flexfield column.
APPL_ATTRIBUTE6	Descriptive flexfield column.
APPL_ATTRIBUTE7	Descriptive flexfield column.
APPL_ATTRIBUTE8	Descriptive flexfield column.
APPL_ATTRIBUTE9	Descriptive flexfield column.
APPL_ATTRIBUTE10	Descriptive flexfield column.
APPL_ATTRIBUTE11	Descriptive flexfield column.
APPL_ATTRIBUTE12	Descriptive flexfield column.
APPL_ATTRIBUTE13	Descriptive flexfield column.
APPL_ATTRIBUTE14	Descriptive flexfield column.
PERSON_ID	Foreign key to PER_ALL_PEOPLE_F.
APPL_ATTRIBUTE15	Descriptive flexfield column.
APPL_ATTRIBUTE16	Descriptive flexfield column.
APPL_ATTRIBUTE17	Descriptive flexfield column.
APPL_ATTRIBUTE18	Descriptive flexfield column.
APPL_ATTRIBUTE19	Descriptive flexfield column.
APPL_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.
DATE_RECEIVED	Date application was received.
CREATION_DATE	Standard Who column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
COMMENTS	General remark.
CURRENT_EMPLOYER	Current employer of the applicant.
DATE_END	Date the application ends.
PROJECTED_HIRE_DATE	Projected hire date for the applicant.
SUCCESSFUL_FLAG	Indicates whether the application was successful.

Human Resources - PER_ALL_ASSIGNMENTS_F	Employee and applicant assignment details.
Column Name	Descritpion
ASSIGNMENT_ID	System-generated primary key column.
PAYROLL_ID	Foreign key to PAY_PAYROLLS.
VENDOR_ID	Foreign key reference to po_vendors
VENDOR_SITE_ID	Foreign key reference to po_vendor_sites_all
PO_HEADER_ID	Foreign key reference to po_headers_all
PO_LINE_ID	Foreign key reference to po_lines_all
PROJECTED_ASSIGNMENT_END	The date the assignment is expected to end
VENDOR_EMPLOYEE_NUMBER	Employee number of worker with vending organization
VENDOR_ASSIGNMENT_NUMBER	Assignment number of non-payrolled worker assignment with vending organization
ASSIGNMENT_CATEGORY	Assignment Category. This column is not currently used but reserved for future use.
PROJECT_TITLE	Title of project of which this assignment forms part
GRADE_LADDER_PGM_ID	Link assignment to grade_ladder for Benefits
SUPERVISOR_ASSIGNMENT_ID	Not to be used at the present time
LOCATION_ID	Foreign key to HR_LOCATIONS.
PERSON_REFERRED_BY_ID	Foreign key to PER_PEOPLE.
SUPERVISOR_ID	Foreign key to PER_PEOPLE.
SPECIAL_CEILING_STEP_ID	Foreign key to PER_SPINAL_POINT_STEPS.
PERSON_ID	Foreign key to PER_PEOPLE.
RECRUITMENT_ACTIVITY_ID	Foreign key to PER_RECRUITMENT_ACTIVITIES.
SOURCE_ORGANIZATION_ID	Foreign key to HR_ORGANIZATION_UNITS.
ORGANIZATION_ID	Foreign key to HR_ORGANIZATION_UNITS.
PEOPLE_GROUP_ID	Foreign key to PAY_PEOPLE_GROUPS.
EFFECTIVE_START_DATE	Effective start date.
SOFT_CODING_KEYFLEX_ID	Foreign key to HR_SOFT_CODING_KEYFLEX.
VACANCY_ID	Foreign key to PER_ALL_VACANCIES.
PAY_BASIS_ID	Foreign key to PER_PAY_BASES.
ASSIGNMENT_SEQUENCE	Used when defaulting assignment number.
ASSIGNMENT_TYPE	Assignment type; (E)mployee or (A)pplicant.
PRIMARY_FLAG	Indicates primary employee assignment. Y/N.
APPLICATION_ID	Foreign key to PER_APPLICATIONS.
ASSIGNMENT_NUMBER	Employee assignment number.
CHANGE_REASON	Reason the assignment last changed.
COMMENT_ID	Foreign key reference to HR_COMMENTS.
EFFECTIVE_END_DATE	Effective end date.
DATE_PROBATION_END	End date of probation period.
DEFAULT_CODE_COMB_ID	Foreign key to GL_CODE_COMBINATIONS.
EMPLOYMENT_CATEGORY	User defined category. For example Full-Time Permanent or Part-Time Permanent. Known as Assignment Category.
FREQUENCY	Frequency of normal working hours, - week, month, year.
INTERNAL_ADDRESS_LINE	Internal address details such as floor or office number.
MANAGER_FLAG	Indicates whether the employee in this assignment is designated a manager.
NORMAL_HOURS	Normal working hours.
PERF_REVIEW_PERIOD	Number of units of time between performance reviews.
PERF_REVIEW_PERIOD_FREQUENCY	Frequency units. Used with PERF_REVIEW_PERIOD to define time between reviews.
PERIOD_OF_SERVICE_ID	Foreign key to PER_PERIODS_OF_SERVICE.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
PROBATION_PERIOD	Duration of probation period.
PROBATION_UNIT	Units of probation period duration.
SAL_REVIEW_PERIOD	Length of time between salary reviews.
SAL_REVIEW_PERIOD_FREQUENCY	Used with SAL REVIEW PERIOD to define time between salary reviews.
SET_OF_BOOKS_ID	Foreign key to GL_SETS_OF_BOOKS.
SOURCE_TYPE	Recruitment activity source for applicant assignment, for example, Advertisement).
TIME_NORMAL_FINISH	Work day normal end time.
TIME_NORMAL_START	Work day normal start time.
BARGAINING_UNIT_CODE	Bargaining unit code
LABOUR_UNION_MEMBER_FLAG	Labour union member flag
RECRUITER_ID	Foreign key to PER_PEOPLE.
HOURLY_SALARIED_CODE	Identifies if the assignment is paid by the hour or by a salary.
CONTRACT_ID	Foreign key to PER_CONTRACTS_F
COLLECTIVE_AGREEMENT_ID	Foreign key to PER_COLLECTIVE_AGREEMENTS
CAGR_ID_FLEX_NUM	Keyflex Structure Identifier for Collectively Agreed Grade
CAGR_GRADE_DEF_ID	Foreign key to PER_CAGR_GRADES_DEF
ESTABLISHMENT_ID	Foreign key to HR_ORGANIZATION_UNITS
REQUEST_ID	Standard Who column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who column.
PROGRAM_UPDATE_DATE	Standard Who column.
GRADE_ID	Foreign key to PER_GRADES.
ASS_ATTRIBUTE_CATEGORY	Descriptive flexfield column.
ASS_ATTRIBUTE1	Descriptive flexfield column.
ASS_ATTRIBUTE2	Descriptive flexfield column.
ASS_ATTRIBUTE3	Descriptive flexfield column.
ASS_ATTRIBUTE4	Descriptive flexfield column.
ASS_ATTRIBUTE5	Descriptive flexfield column.
ASS_ATTRIBUTE6	Descriptive flexfield column.
ASS_ATTRIBUTE7	Descriptive flexfield column.
ASS_ATTRIBUTE8	Descriptive flexfield column.
ASS_ATTRIBUTE9	Descriptive flexfield column.
POSITION_ID	Foreign key to PER_ALL_POSITIONS.
ASS_ATTRIBUTE10	Descriptive flexfield column.
ASS_ATTRIBUTE11	Descriptive flexfield column.
ASS_ATTRIBUTE12	Descriptive flexfield column.
ASS_ATTRIBUTE13	Descriptive flexfield column.
APPLICANT_RANK	applicant rank
ASS_ATTRIBUTE14	Descriptive flexfield column.
ASS_ATTRIBUTE15	Descriptive flexfield column.
ASS_ATTRIBUTE16	Descriptive flexfield column.
ASS_ATTRIBUTE17	Descriptive flexfield column.
ASS_ATTRIBUTE18	Descriptive flexfield column.
ASS_ATTRIBUTE19	Descriptive flexfield column.
JOB_ID	Foreign key to PER_JOBS.
ASS_ATTRIBUTE20	Descriptive flexfield column.
ASS_ATTRIBUTE21	Descriptive flexfield column.
ASS_ATTRIBUTE22	Descriptive flexfield column.
ASS_ATTRIBUTE23	Descriptive flexfield column.
ASS_ATTRIBUTE24	Descriptive flexfield column.
ASS_ATTRIBUTE25	Descriptive flexfield column.
ASS_ATTRIBUTE26	Descriptive flexfield column.
ASS_ATTRIBUTE27	Descriptive flexfield column.
ASS_ATTRIBUTE28	Descriptive flexfield column.
ASS_ATTRIBUTE29	Descriptive flexfield column.
ASSIGNMENT_STATUS_TYPE_ID	Foreign key to PER_ASSIGNMENT_STATUS_TYPES.
ASS_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.
TITLE	Title for assignment.
NOTICE_PERIOD	notice period
NOTICE_PERIOD_UOM	notice period unit of measure
EMPLOYEE_CATEGORY	employee category
WORK_AT_HOME	work at home flag
JOB_POST_SOURCE_NAME	job post source name
POSTING_CONTENT_ID	The posting to which the applicant has applied.
PERIOD_OF_PLACEMENT_DATE_START	Part of foreign key to per_periods_of_placement
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.

Human Resources - PER_ASSIGNMENT_EXTRA_INFO	Extra information for an assignment.
Column Name	Descritpion
ASSIGNMENT_EXTRA_INFO_ID	System-generated primary key column.
AEI_ATTRIBUTE2	Descriptive flexfield column.
AEI_ATTRIBUTE3	Descriptive flexfield column.
AEI_ATTRIBUTE4	Descriptive flexfield column.
AEI_ATTRIBUTE5	Descriptive flexfield column.
AEI_ATTRIBUTE6	Descriptive flexfield column.
AEI_ATTRIBUTE7	Descriptive flexfield column.
AEI_ATTRIBUTE8	Descriptive flexfield column.
AEI_ATTRIBUTE9	Descriptive flexfield column.
AEI_ATTRIBUTE10	Descriptive flexfield column.
AEI_ATTRIBUTE11	Descriptive flexfield column.
ASSIGNMENT_ID	Foreign key to PER_ALL_ASSIGNMENTS_F.
AEI_ATTRIBUTE12	Descriptive flexfield column.
AEI_ATTRIBUTE13	Descriptive flexfield column.
AEI_ATTRIBUTE14	Descriptive flexfield column.
AEI_ATTRIBUTE15	Descriptive flexfield column.
AEI_ATTRIBUTE16	Descriptive flexfield column.
AEI_ATTRIBUTE17	Descriptive flexfield column.
AEI_ATTRIBUTE18	Descriptive flexfield column.
AEI_ATTRIBUTE19	Descriptive flexfield column.
AEI_ATTRIBUTE20	Descriptive flexfield column.
INFORMATION_TYPE	Foreign key to PER_ASSIGNMENT_INFO_TYPES.
AEI_INFORMATION_CATEGORY	Developer descriptive flexfield column.
AEI_INFORMATION1	Developer descriptive flexfield column.
AEI_INFORMATION2	Developer descriptive flexfield column.
AEI_INFORMATION3	Developer descriptive flexfield column.
AEI_INFORMATION4	Developer descriptive flexfield column.
AEI_INFORMATION5	Developer descriptive flexfield column.
REQUEST_ID	Standard Who column.
AEI_INFORMATION6	Developer descriptive flexfield column.
AEI_INFORMATION7	Developer descriptive flexfield column.
AEI_INFORMATION8	Developer descriptive flexfield column.
AEI_INFORMATION9	Developer descriptive flexfield column.
AEI_INFORMATION10	Developer descriptive flexfield column.
AEI_INFORMATION11	Developer descriptive flexfield column.
AEI_INFORMATION12	Developer descriptive flexfield column.
AEI_INFORMATION13	Developer descriptive flexfield column.
AEI_INFORMATION14	Developer descriptive flexfield column.
AEI_INFORMATION15	Developer descriptive flexfield column.
PROGRAM_APPLICATION_ID	Standard Who column.
AEI_INFORMATION16	Developer descriptive flexfield column.
AEI_INFORMATION17	Developer descriptive flexfield column.
AEI_INFORMATION18	Developer descriptive flexfield column.
AEI_INFORMATION19	Developer descriptive flexfield column.
AEI_INFORMATION20	Developer descriptive flexfield column.
AEI_INFORMATION21	Developer descriptive flexfield column.
AEI_INFORMATION22	Developer descriptive flexfield column.
PROGRAM_ID	Standard Who column.
AEI_INFORMATION23	Developer descriptive flexfield
AEI_INFORMATION24	Developer descriptive flexfield
AEI_INFORMATION25	Developer descriptive flexfield
AEI_INFORMATION26	Developer descriptive flexfield
AEI_INFORMATION27	Developer descriptive flexfield
AEI_INFORMATION28	Developer descriptive flexfield
AEI_INFORMATION29	Developer descriptive flexfield
AEI_INFORMATION30	Developer descriptive flexfield
PROGRAM_UPDATE_DATE	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
AEI_ATTRIBUTE_CATEGORY	Descriptive flexfield column.
CREATION_DATE	Standard Who column.
AEI_ATTRIBUTE1	Descriptive flexfield column.

Human Resources - PER_ASSIGNMENT_INFO_TYPES	Types of extra information that may be held against an assignment.
Column Name	Descritpion
INFORMATION_TYPE	The name or code of the information type, which is also the primary key.
LAST_UPDATE_DATE	Standard Who column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
ACTIVE_INACTIVE_FLAG	Indicates whether the information type is active or inactive.
MULTIPLE_OCCURENCES_FLAG	Indicates whether an assignment 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.
PROGRAM_ID	Standard Who column.
PROGRAM_UPDATE_DATE	Standard Who column.

Human Resources - PER_ASSIGNMENT_STATUS_TYPES	Predefined and user defined assignment status types.
Column Name	Descritpion
ASSIGNMENT_STATUS_TYPE_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.
LEGISLATION_CODE	The legislation to which the status type applies.
ACTIVE_FLAG	Indicates whether the status is currently available for use.
DEFAULT_FLAG	Indicates whether this is the default user status for the PER_SYSTEM_STATUS.
PRIMARY_FLAG	Indicates whether an assignment with this status is processed by Oracle HR.
USER_STATUS	User-defined status name.
PAY_SYSTEM_STATUS	Payroll status indicating whether the assignment is processed in payroll runs.
PER_SYSTEM_STATUS	HR status used extensively within the system to determine how the assignment is processed.

Human Resources - PER_ASS_STATUS_TYPE_AMENDS	User amendments to predefined assignment status types.
Column Name	Descritpion
ASS_STATUS_TYPE_AMEND_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.
ASSIGNMENT_STATUS_TYPE_ID	Foreign key to PER_ASSIGN MENT_STATUS_TYPES.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ACTIVE_FLAG	Indicates whether the status is currently available for use.
DEFAULT_FLAG	Indicates whether this is the default user status for the PER_SYSTEM_STATUS.
USER_STATUS	User-defined status name.
PAY_SYSTEM_STATUS	Payroll status indicating whether the assignment is processed in payroll runs.
PER_SYSTEM_STATUS	HR status used extensively within the system to determine how the assignment is processed.
LAST_UPDATE_DATE	Standard Who column.

Human Resources - PER_BOOKINGS	Event booking details.
Column Name	Descritpion
BOOKING_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.
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.
EVENT_ID	Foreign key to PER_EVENTS.
COL_16072666	Standard Who column.
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_BUDGETS	Definitions of HR budgets.
Column Name	Descritpion
BUDGET_ID	System-generated primary key 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.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
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_SET_NAME	Foreign key to PAY_CALENDARS.
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	Name of the budget.
BUDGET_TYPE_CODE	The type of the budget.
COMMENTS	General remark.
UNIT	Budget measurement type, for example, Headcount, FTE, Points.
REQUEST_ID	Standard Who column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who column.

Human Resources - PER_BUDGET_ELEMENTS	Combinations of organization, grade, job, and position used to define detailed budget values.
Column Name	Descritpion
BUDGET_ELEMENT_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.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
TRAINING_PLAN_ID	The training plan this budget relates to.
GRADE_ID	Foreign key to PER_GRADES.
TRAINING_PLAN_MEMBER_ID	The training plan member this budget relates to.
JOB_ID	Foreign key to PER_JOBS.
EVENT_ID	The Event this budget relates to.
POSITION_ID	Foreign key to PER_ALL_POSITIONS.
ORGANIZATION_ID	Foreign key to HR_ORGANIZATION_UNITS.
BUDGET_VERSION_ID	Foreign key to PER_BUDGET_VERSIONS.
REQUEST_ID	Standard Who column.
PROGRAM_APPLICATION_ID	Standard Who column.

Human Resources - PER_BUDGET_VALUES	Planned HR budget values for specific budget elements.
Column Name	Descritpion
BUDGET_VALUE_ID	System-generated primary key column.
LAST_UPDATE_DATE	Standard Who column.
BUDGET_INFORMATION8	Developer Descriptive flexfield column.
LAST_UPDATED_BY	Standard Who column.
BUDGET_INFORMATION9	Developer Descriptive flexfield column.
LAST_UPDATE_LOGIN	Standard Who column.
BUDGET_INFORMATION10	Developer Descriptive flexfield column.
CREATED_BY	Standard Who column.
BUDGET_INFORMATION11	Developer Descriptive flexfield column.
CREATION_DATE	Standard Who column.
BUDGET_INFORMATION12	Developer Descriptive flexfield column.
BUDGET_INFORMATION13	Developer Descriptive flexfield column.
BUDGET_INFORMATION14	Developer Descriptive flexfield column.
BUDGET_INFORMATION15	Developer Descriptive flexfield column.
BUDGET_INFORMATION16	Developer Descriptive flexfield column.
BUDGET_INFORMATION17	Developer Descriptive flexfield column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
BUDGET_INFORMATION18	Developer Descriptive flexfield column.
BUDGET_INFORMATION19	Developer Descriptive flexfield column.
BUDGET_INFORMATION20	Developer Descriptive flexfield column.
BUDGET_INFORMATION21	Developer Descriptive flexfield column.
INFORMATION_CATEGORY	Descriptive flexfield structure defining column.
BUDGET_INFORMATION22	Developer Descriptive flexfield column.
BUDGET_INFORMATION23	Developer Descriptive flexfield column.
BUDGET_INFORMATION24	Developer Descriptive flexfield column.
BUDGET_INFORMATION25	Developer Descriptive flexfield column.
BUDGET_INFORMATION26	Developer Descriptive flexfield column.
BUDGET_INFORMATION27	Developer Descriptive flexfield column.
BUDGET_ELEMENT_ID	Foreign key to PER_BUDGET_ELEMENTS.
BUDGET_INFORMATION28	Developer Descriptive flexfield column.
BUDGET_INFORMATION29	Developer Descriptive flexfield column.
BUDGET_INFORMATION30	Developer Descriptive flexfield column.
ATTRIBUTE_CATEGORY	Descriptive Flex Field Attribute Category.
BUDGET_INFORMATION1	Developer 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.
TIME_PERIOD_ID	Foreign key to PER_TIME_PERIODS.
ATTRIBUTE7	Descriptive flexfield column.
ATTRIBUTE8	Descriptive flexfield column.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
BUDGET_INFORMATION2	Developer 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.
VALUE	The budget value.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
BUDGET_INFORMATION3	Developer 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.
REQUEST_ID	Standard Who column.
ATTRIBUTE27	Descriptive flexfield column.
ATTRIBUTE28	Descriptive flexfield column.
ATTRIBUTE29	Descriptive flexfield column.
ATTRIBUTE30	Descriptive flexfield column.
BUDGET_INFORMATION4	Developer Descriptive flexfield column.
PROGRAM_APPLICATION_ID	Standard Who column.
BUDGET_INFORMATION5	Developer Descriptive flexfield column.
PROGRAM_ID	Standard Who column.
BUDGET_INFORMATION6	Developer Descriptive flexfield column.
PROGRAM_UPDATE_DATE	Standard Who column.
BUDGET_INFORMATION7	Developer Descriptive flexfield column.

Human Resources - PER_BUDGET_VERSIONS	Identifies specific versions of an HR budget.
Column Name	Descritpion
BUDGET_VERSION_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.
BUDGET_ID	Foreign key to PER_BUDGETS.
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	Date from which this version of the budget applies.
VERSION_NUMBER	Budget version number.
COMMENTS	General remark.
DATE_TO	Date to which this version of the budget applies.
REQUEST_ID	Standard Who column.
PROGRAM_APPLICATION_ID	Standard Who column.

Human Resources - PER_CAREER_PATHS	List of career paths for jobs.
Column Name	Descritpion
CAREER_PATH_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.
ATTRIBUTE10	Descriptive flexfield column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
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.
NAME	Career path name.
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.
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.

Human Resources - PER_CAREER_PATH_ELEMENTS	Progression paths for specific jobs.
Column Name	Descritpion
CAREER_PATH_ELEMENT_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.
SUBORDINATE_JOB_ID	Foreign key to PER_JOBS.
PARENT_JOB_ID	Foreign key to PER_JOBS.
CAREER_PATH_ID	Foreign key to PER_CAREER_PATHS.
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_CONTACT_RELATIONSHIPS	Contacts and relationship details for dependents, beneficiaries, emergency contacts, parents etc.
Column Name	Descritpion
COMMENTS	General remark.
CONT_INFORMATION9	Developer Descriptive Flexfield Column
CONT_INFORMATION10	Developer Descriptive Flexfield Column
CONT_INFORMATION11	Developer Descriptive Flexfield Column
CONT_INFORMATION12	Developer Descriptive Flexfield Column
PRIMARY_CONTACT_FLAG	Indicates whether the contact is the primary contact for the employee.
CONT_INFORMATION13	Developer Descriptive Flexfield Column
CONT_INFORMATION14	Developer Descriptive Flexfield Column
CONT_INFORMATION15	Developer Descriptive Flexfield Column
CONT_INFORMATION16	Developer Descriptive Flexfield Column
DATE_START	The start date of the relationship.
CONT_INFORMATION17	Developer Descriptive Flexfield Column
CONT_INFORMATION18	Developer Descriptive Flexfield Column
CONT_INFORMATION19	Developer Descriptive Flexfield Column
CONT_INFORMATION20	Developer Descriptive Flexfield Column
START_LIFE_REASON_ID	A foreign key to BEN_LER_F identifying the reason the relationship started.
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.
THIRD_PARTY_PAY_FLAG	Indicates whether the contact receives third party payments from the employee.
BONDHOLDER_FLAG	Indicates whether a person is a potential EE bondholder.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
DEPENDENT_FLAG	Dependent Flag
BENEFICIARY_FLAG	Beneficiary Flag
DATE_END	The date the relationship ended.
PARTY_ID	Party Flag
END_LIFE_REASON_ID	A foreign key to BEN_LER_F identifying the reason the relationship ended.
RLTD_PER_RSDS_W_DSGNTR_FLAG	Indicates whether the two people in the relationship live at the same address.
PERSONAL_FLAG	Indicates whether the relationship is a personal relationship.
SEQUENCE_NUMBER	The unique sequence number for the relationship used to identify contacts with a third party organization.
REQUEST_ID	Standard Who column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who column.
PROGRAM_UPDATE_DATE	Standard Who column.
CONT_ATTRIBUTE_CATEGORY	Descriptive flexfield column.
CONT_ATTRIBUTE1	Descriptive flexfield column.
CONT_ATTRIBUTE2	Descriptive flexfield column.
CONT_ATTRIBUTE3	Descriptive flexfield column.
CONT_ATTRIBUTE4	Descriptive flexfield column.
CONT_ATTRIBUTE5	Descriptive flexfield column.
CONT_ATTRIBUTE6	Descriptive flexfield column.
CONT_ATTRIBUTE7	Descriptive flexfield column.
CONT_ATTRIBUTE8	Descriptive flexfield column.
CONT_ATTRIBUTE9	Descriptive flexfield column.
CONT_ATTRIBUTE10	Descriptive flexfield column.
CONT_ATTRIBUTE11	Descriptive flexfield column.
CONT_ATTRIBUTE12	Descriptive flexfield column.
CONT_ATTRIBUTE13	Descriptive flexfield column.
CONT_ATTRIBUTE14	Descriptive flexfield column.
CONT_ATTRIBUTE15	Descriptive flexfield column.
CONTACT_RELATIONSHIP_ID	System-generated primary key column.
CONT_ATTRIBUTE16	Descriptive flexfield column.
CONT_ATTRIBUTE17	Descriptive flexfield column.
CONT_ATTRIBUTE18	Descriptive flexfield column.
CONT_ATTRIBUTE19	Descriptive flexfield column.
CONT_ATTRIBUTE20	Descriptive flexfield column.
CONT_INFORMATION_CATEGORY	Developer Descriptive Flexfield column
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
CONT_INFORMATION1	Developer Descriptive Flexfield Column
CONT_INFORMATION2	Developer Descriptive Flexfield Column
PERSON_ID	Foreign key to PER_PEOPLE.
CONT_INFORMATION3	Developer Descriptive Flexfield Column
CONT_INFORMATION4	Developer Descriptive Flexfield Column
CONTACT_PERSON_ID	Foreign key to PER_PEOPLE.
CONT_INFORMATION5	Developer Descriptive Flexfield Column
CONT_INFORMATION6	Developer Descriptive Flexfield Column
CONTACT_TYPE	Relationship between employee and contact.
CONT_INFORMATION7	Developer Descriptive Flexfield Column
CONT_INFORMATION8	Developer Descriptive Flexfield Column

Human Resources - PER_EVENTS	Record of events such as interviews and appraisals for applicants and employees.
Column Name	Descritpion
EVENT_ID	System-generated primary key column.
CONTACT_TELEPHONE_NUMBER	External contact telephone number.
DATE_END	End date of event or interview.
EMP_OR_APL	Indicates an employee or applicant (E=employee and A=applicant).
EVENT_OR_INTERVIEW	Indicates an event or interview (E = event and I = interview.
EXTERNAL_CONTACT	Name of the external contact. Only used for events.
TIME_END	Time the event or interview is expected to end.
TIME_START	Time the event or interview is expected to start.
REQUEST_ID	Standard Who column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_ID	Standard Who column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
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.
LOCATION_ID	Foreign key to HR_LOCATIONS.
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.
INTERNAL_CONTACT_PERSON_ID	Foreign key to PER_PEOPLE.
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.
ORGANIZATION_RUN_BY_ID	Foreign key to HR_ORGANIZATION_UNITS.
PARTY_ID	Foreign key to the HZ_PARTIES table.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
ASSIGNMENT_ID	Foreign key to PER_ASSIGNMENTS.
DATE_START	Start date of event or interview.
TYPE	Event type or interview name.
COMMENTS	General remark.

Human Resources - PER_FORM_FUNCTIONS	Navigation and person change information for the Enter Person information screens.
Column Name	Descritpion
FORM	Form name eg. PERPEEPI.
FUNCTION	Function to be carried out eg. CHANGE_PERSON_TYPE, NAVIGATE.
RESULT	The expected result eg. person type to appear on picklist.
INPUT	Value used as a reference eg. existing person type.
RESTRICTION_CODE	Form customization restriction code e.g. value relating to PERSON_TYPE.
RESTRICTION_VALUE	Value that is restricted by the customization.

Human Resources - PER_GRADES	Grade definitions for a business group.
Column Name	Descritpion
GRADE_ID	System-generated primary key column.
PROGRAM_APPLICATION_ID	Standard Who column.
INFORMATION12	Developer Descriptive Flexfield Column
INFORMATION13	Developer Descriptive Flexfield Column
PROGRAM_ID	Standard Who Column.
INFORMATION14	Developer Descriptive Flexfield Column
INFORMATION15	Developer Descriptive Flexfield Column
PROGRAM_UPDATE_DATE	Standard Who column.
INFORMATION16	Developer Descriptive Flexfield Column
INFORMATION17	Developer Descriptive Flexfield Column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
INFORMATION18	Developer Descriptive Flexfield Column
INFORMATION19	Developer Descriptive Flexfield Column
ATTRIBUTE1	Descriptive flexfield column.
INFORMATION20	Developer Descriptive Flexfield Column
OBJECT_VERSION_NUMBER	Object Version Number column used for HRMS locking purposes
ATTRIBUTE2	Descriptive flexfield column.
SHORT_NAME	Short Name
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.
GRADE_DEFINITION_ID	Foreign key to PER_GRADE_DEFINITIONS.
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	The date on which the grade becomes effective.
INFORMATION_CATEGORY	Developer Descriptive Flexfield Column
INFORMATION1	Developer Descriptive Flexfield Column
SEQUENCE	Sequence number for the grade. Used for ordering a list of grades.
INFORMATION2	Developer Descriptive Flexfield Column
INFORMATION3	Developer Descriptive Flexfield Column
COMMENTS	General remark.
INFORMATION4	Developer Descriptive Flexfield Column
INFORMATION5	Developer Descriptive Flexfield Column
DATE_TO	The date after which the grade is no longer effective.
INFORMATION6	Developer Descriptive Flexfield Column
INFORMATION7	Developer Descriptive Flexfield Column
NAME	Grade name.
INFORMATION8	Developer Descriptive Flexfield Column
INFORMATION9	Developer Descriptive Flexfield Column
REQUEST_ID	Standard Who Column.
INFORMATION10	Developer Descriptive Flexfield Column
INFORMATION11	Developer Descriptive Flexfield Column

Human Resources - PER_GRADE_DEFINITIONS	Grade key flexfield combinations table.
Column Name	Descritpion
GRADE_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.
OBJECT_VERSION_NUMBER	Object Version Number used by HRMS for locking purposes
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_GRADE_SPINES_F	Stores the progression points for each grade scale.
Column Name	Descritpion
GRADE_SPINE_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.
OBJECT_VERSION_NUMBER	Object Version Number used by HRMS for locking purposes
EFFECTIVE_END_DATE	Effective end date.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
PARENT_SPINE_ID	Foreign key to PER_PARENT_SPINES.
GRADE_ID	Foreign key to PER_GRADES.
CEILING_STEP_ID	Foreign key to PER_SPINAL_POINTS.
REQUEST_ID	Standard Who Column.
PROGRAM_APPLICATION_ID	Standard Who column.

Human Resources - PER_ALL_PEOPLE_F	DateTracked table holding personal information for employees, applicants and other people.
Column Name	Descritpion
PERSON_ID	System generated person primary key from PER_PEOPLE_S.
LAST_NAME	Last name of the person, (surname, family name).
HOLD_APPLICANT_DATE_UNTIL	Hold applicant until.
HONORS	Honors.
INTERNAL_LOCATION	Internal location.
KNOWN_AS	Preferred name, if different from first name.
LAST_MEDICAL_TEST_BY	Last medical test by.
LAST_MEDICAL_TEST_DATE	Last medical test date.
MAILSTOP	Internal mail location.
MARITAL_STATUS	Marital status.
MIDDLE_NAMES	Middle names.
NATIONALITY	Nationality.
NATIONAL_IDENTIFIER	Number by which a person is identified in a given legislation.
START_DATE	Start date for the person (not the DateTrack attribute).
OFFICE_NUMBER	Office number.
ON_MILITARY_SERVICE	On military service.
ORDER_NAME	Concatenated name used for ordering on select.
PRE_NAME_ADJUNCT	Name prefix.
PREVIOUS_LAST_NAME	Previous last name of person (if applicable).
PROJECTED_START_DATE	Currently unsupported.
REHIRE_AUTHORIZOR	Currently unsupported.
REHIRE_REASON	Reason for re-hiring.
REHIRE_RECOMMENDATION	Re-hire recommendation.
RESUME_EXISTS	Resume exists.
RESUME_LAST_UPDATED	Date resume last updated.
REGISTERED_DISABLED_FLAG	Flag indicating whether person is classified as disabled.
SECOND_PASSPORT_EXISTS	Second passport available flag.
SEX	Legal gender.
STUDENT_STATUS	Student status.
SUFFIX	Suffix after the surname e.g. Sr., Jr., III
TITLE	Title e.g. Mr, Mrs, Dr.
APPLICANT_NUMBER	Number assigned to person if ever classed as an applicant.
VENDOR_ID	Not used.
WORK_SCHEDULE	Work schedule.
WORK_TELEPHONE	Unsupported.
COORD_BEN_MED_PLN_NO	Coordination of benefits medical group plan number.
COORD_BEN_NO_CVG_FLAG	Coordination of benefits no other coverage flag
DPDNT_ADOPTION_DATE	Dependent adoption date
DPDNT_VLNTRY_SVCE_FLAG	Dependent voluntary service flag
RECEIPT_OF_DEATH_CERT_DATE	Receipt of death certificate date
USES_TOBACCO_FLAG	Uses tabacco flag
BENEFIT_GROUP_ID	Foreign key to benefits group table.
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.
EFFECTIVE_START_DATE	Effective start date.
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.
PER_INFORMATION_CATEGORY	Developer descriptive flexfield column.
PER_INFORMATION1	Developer descriptive flexfield column.
PER_INFORMATION2	Developer descriptive flexfield column.
PER_INFORMATION3	Developer descriptive flexfield column.
PER_INFORMATION4	Developer descriptive flexfield column.
PER_INFORMATION5	Developer descriptive flexfield column.
PER_INFORMATION6	Developer descriptive flexfield column.
PER_INFORMATION7	Developer descriptive flexfield column.
PER_INFORMATION8	Developer descriptive flexfield column.
PER_INFORMATION9	Developer descriptive flexfield column.
PER_INFORMATION10	Developer descriptive flexfield column.
PER_INFORMATION11	Developer descriptive flexfield column.
PER_INFORMATION12	Developer descriptive flexfield column.
PER_INFORMATION13	Developer descriptive flexfield column.
PER_INFORMATION14	Developer descriptive flexfield column.
PER_INFORMATION15	Developer descriptive flexfield column.
PER_INFORMATION16	Developer descriptive flexfield column.
PER_INFORMATION17	Developer descriptive flexfield column.
PER_INFORMATION18	Developer descriptive flexfield column.
PER_INFORMATION19	Developer descriptive flexfield column.
PER_INFORMATION20	Developer descriptive flexfield column.
PER_INFORMATION21	Developer descriptive flexfield.
PER_INFORMATION22	Developer descriptive flexfield.
PER_INFORMATION23	Developer descriptive flexfield.
BACKGROUND_CHECK_STATUS	Background check status.
PER_INFORMATION24	Developer descriptive flexfield.
PER_INFORMATION25	Developer descriptive flexfield.
PER_INFORMATION26	Developer descriptive flexfield.
PER_INFORMATION27	Developer descriptive flexfield.
PER_INFORMATION28	Developer descriptive flexfield.
PER_INFORMATION29	Developer descriptive flexfield.
PER_INFORMATION30	Developer descriptive flexfield.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
DATE_OF_DEATH	Date of death.
BACKGROUND_DATE_CHECK	Background date check.
ORIGINAL_DATE_OF_HIRE	Original date of hire.
TOWN_OF_BIRTH	Town that the person was born in
EFFECTIVE_END_DATE	Effective end date.
BLOOD_TYPE	Blood group.
REGION_OF_BIRTH	Region that the person was born in
COMMENT_ID	Foreign key reference to remark.
COUNTRY_OF_BIRTH	Country that the person was born in
GLOBAL_PERSON_ID	Global person identifier.
COORD_BEN_MED_PL_NAME	Benefits: Medical plan name.
COORD_BEN_MED_INSR_CRR_NAME	Benefits: Insurance carrier name.
CORRESPONDENCE_LANGUAGE	Correspondence Language validated against FND_LANGUAGES.
COORD_BEN_MED_INSR_CRR_IDENT	Benefits: Insurance carrier identification number.
COORD_BEN_MED_EXT_ER	Used for benefits.
CURRENT_APPLICANT_FLAG	Yes or null.
COORD_BEN_MED_CVG_STRT_DT	Benefits: start date of coverage plan.
COORD_BEN_MED_CVG_END_DT	Benefits: end date of coverage plan.
CURRENT_EMP_OR_APL_FLAG	Yes or null.
PARTY_ID	Party identifier.
CURRENT_EMPLOYEE_FLAG	Yes or null.
NPW_NUMBER	Number for contingent worker
CURRENT_NPW_FLAG	Indicator of contingent worker status
GLOBAL_NAME	Stores personal name according to the defined Global List Name format
LOCAL_NAME	Stores personal name according to the defined Local List Name format
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
DATE_EMPLOYEE_DATA_VERIFIED	Date when the employee last verified the data.
DATE_OF_BIRTH	Date of birth.
EMAIL_ADDRESS	Holds actual email identifier.
PERSON_TYPE_ID	Foreign key to PER_PERSON_TYPES.
EMPLOYEE_NUMBER	Number assigned to a person if they have been an employee.
EXPENSE_CHECK_SEND_TO_ADDRESS	Mailing address.
FAST_PATH_EMPLOYEE	Currently unsupported.
FIRST_NAME	First name of person.
FTE_CAPACITY	Full-time employment capacity.
FULL_NAME	Concatenation of last name, title, first name, middle names and the name the person is known by.

Human Resources - PER_ALL_POSITIONS	Dual-maintained position definition information.
Column Name	Descritpion
POSITION_DEFINITION_ID	Foreign key to PER_POSITION_DEFINITIONS.
DATE_EFFECTIVE	Date position effective from.
COMMENTS	General remark.
DATE_END	Date the position becomes void.
FREQUENCY	Frequency of working hours.
NAME	Name of the position.
PROBATION_PERIOD	Length of the probation period.
PROBATION_PERIOD_UNITS	Units that the probation period is measured in.
REPLACEMENT_REQUIRED_FLAG	Is replacement required when person assigned to position is absent.
TIME_NORMAL_FINISH	Normal end time.
TIME_NORMAL_START	Normal start time.
WORKING_HOURS	Number of normal working hours.
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.
POSITION_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.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
STATUS	Status of the Position
JOB_ID	Foreign key to PER_JOBS.
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.
ORGANIZATION_ID	Foreign key to HR_ORGANIZATION_UNITS.
SUCCESSOR_POSITION_ID	Foreign key to PER_ALL_POSITIONS.
RELIEF_POSITION_ID	Foreign key to PER_ALL_POSITIONS.
LOCATION_ID	Foreign key to HR_LOCATIONS.

Human Resources - PER_ALL_VACANCIES	Vacancies within a specific requisition.
Column Name	Descritpion
VACANCY_ID	System-generated primary key column.
RECRUITER_ID	Foreign key to PER_ALL_PEOPLE_F.
DATE_FROM	Date vacancy starts.
NAME	Vacancy name.
COMMENTS	General remark.
DATE_TO	Date vacancy ends.
DESCRIPTION	Vacancy description.
NUMBER_OF_OPENINGS	Number of people who can be hired for this vacancy.
STATUS	Status for the vacancy.
BUDGET_MEASUREMENT_TYPE	Type of budget measurment
BUDGET_MEASUREMENT_VALUE	Value of the budget measurement
REQUEST_ID	Standard Who column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
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.
POSITION_ID	Foreign key to PER_ALL_POSITIONS.
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.
JOB_ID	Foreign key to PER_JOBS.
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.
VACANCY_CATEGORY	Currently unsupported.
MANAGER_ID	Foreign key to HZ_PARTIES. Giving the designated Manager for the Job / Position that is be created in the Vacancy.
GRADE_ID	Foreign key to PER_GRADES.
SECURITY_METHOD	Type of security needed for the vacancy. Based upon lookup IRC_SECURITY_METHOD. The default is Business Security.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
ORGANIZATION_ID	Foreign key to HR_ORGANIZATION_UNITS.
REQUISITION_ID	Foreign key to PER_REQUISITIONS.
PEOPLE_GROUP_ID	Foreign key to PAY_PEOPLE_GROUPS.
LOCATION_ID	Foreign key to HR_LOCATIONS.

Human Resources - PER_COBRA_COVERAGE_STATUSES	Tracks the status of a COBRA enrollment.
Column Name	Descritpion
COBRA_COVERAGE_STATUS_ID	Primary Key generated from sequence PER_COBRA_COVERAGE_STATUS_S.
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.
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.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
COBRA_COVERAGE_ENROLLMENT_ID	Foreign key to PER_COBRA_COV_ENROLLMENTS.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
COBRA_COVERAGE_STATUS_TYPE	Status of the COBRA enrollment.
EFFECTIVE_DATE	Effective date of the COBRA enrollment.
COMMENTS	Comments.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
ATTRIBUTE1	Descriptive flexfield column.
ATTRIBUTE2	Descriptive flexfield column.

Human Resources - PER_COBRA_COV_ENROLLMENTS	Enrollments for people who are eligible for continued benefit coverage under COBRA.
Column Name	Descritpion
COBRA_COVERAGE_ENROLLMENT_ID	Primary Key generated from sequence PER_COBRA_COV_ENROLLMENTS_S.
GRACE_DAYS	The number of days after due date the COBRA enrollee has to make payment.
TERMINATION_REASON	If the status of the COBRA enrollment is terminated then the reason for the termination.
CONTACT_RELATIONSHIP_ID	Foreign key to PER_CONTACT_RELATIONSHIPS identifying the relationship between the employee and a covered dependent.
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_ASSIGNMENTS.
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.
PERIOD_TYPE	Foreign key to PER_TIME_PERIOD_TYPES.
QUALIFYING_DATE	The date from which a person qualifies for COBRA coverage.
QUALIFYING_EVENT	Foreign Key to PER_COBRA_QFYING_EVENTS_F identifying the qualifying event for COBRA coverage.
COMMENTS	Comments for the COBRA enrollment.
COVERAGE_END_DATE	The end date of the COBRA coverage.
COVERAGE_START_DATE	The actual start date of the COBRA coverage.

Human Resources - PER_COBRA_QFYING_EVENTS_F	Events that have meaning in the context of COBRA coverage, e.g. Divorce, Termination, Death etc.
Column Name	Descritpion
QUALIFYING_EVENT_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.
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.
LEGISLATION_CODE	Legislation code for this data. Always US for this entity.
ELECTOR	Person who elects to have the coverage. E(mployee) or D(ependent).
EVENT_COVERAGE	Maximum duration for coverage, in months.
QUALIFYING_EVENT	Type of qualifying event, from US_COBRA_EVENT lookup type.
LEGISLATION_SUBGROUP	Further identifies the legislation of startup data.

Human Resources - PER_COBRA_COVERAGE_BENEFITS_F	Details of a benefit that the employee accepts or rejects as part of their COBRA coverage.
Column Name	Descritpion
COBRA_COVERAGE_BENEFIT_ID	Primary key generated from sequence PER_COBRA_COVERAGE_BENEFITS_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.
EFFECTIVE_START_DATE	Effective start date.
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.
EFFECTIVE_END_DATE	Effective end date.
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.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
COBRA_COVERAGE_ENROLLMENT_ID	Foreign key to PER_COBRA_COV_ENROLLMENTS.
ELEMENT_TYPE_ID	Foreign key to PAY_ELEMENT_TYPES.
ACCEPT_REJECT_FLAG	Indicates whether the person has accepted or rejected coverage.
COVERAGE_AMOUNT	The employee charge for the benefit. Defaults to the sum of the employee and employer charges.
COVERAGE_TYPE	Who is covered by the benefit.

Human Resources - HR_WORKFLOWS	Taskflows in Oracle HRMS.
Column Name	Descritpion
WORKFLOW_ID	System-generated primary key column.
WORKFLOW_NAME	Name of the taskflow.
LEGISLATION_CODE	Legislation code of the taskflow.

Human Resources - PER_GENERIC_REPORT_OUTPUT	Text lines for output by a generic report script, including: title, header, footer and body lines.
Column Name	Descritpion
LINE_TYPE	Indicates whether line is in report title, header, footer or body.
LINE_NUMBER	Line number in title, header, footer or body.
LINE_CONTENT	Free text content of report line.

Human Resources - PER_ASSIGN_PROPOSAL_ANSWERS	Web Candidate Offer Answers
Column Name	Descritpion
PERSON_ID	Denormalized foreign key to PER_ALL_PEOPLE_F.
ANSWER_VALUE	The answer that the hiring manager typed into the Web Offers page for this question.
TYPE	Identifies the answer as being for either a Candidate Offer or an Appraisal Questionnaire
ANSWER_FOR_KEY	This is a generic column which should hold foreign key id for other tables. At the moment it holdsthe foreign key id of PER_APPRAISALS table when the per_assign_proposal_answers.TYPE column is 'Appraisal'.
LAST_UPDATED_BY	Standard who column
LAST_UPDATE_DATE	Standrad who column
LAST_UPDATE_LOGIN	Standard who column
CREATION_DATE	Standard who column
CREATED_BY	Standard who column
PROPOSAL_ANSWER_ID	System-generated primary key column.
ASSIGNMENT_ID	Foreign key to HR_ASSIGNMENTS.
PROPOSAL_QUESTION_NAME	Foreign key to PER_PROPOSAL_QUESTION_TYPES.
PROPOSAL_QUESTION_MEMBER_ID	Foreign key to PER_PROPOSAL_QUESTION_MEMBERS.
PROPOSAL_TEMPLATE_ID	Denormalized foreign key to PER_PROPOSAL_TEMPLATES.

Human Resources - PER_COMPETENCES	A competence is a definition of knowledge, skills, abilities or other charactaristics that a person may possess.
Column Name	Descritpion
COMPETENCE_ID	Unique Identifier of Competences
DATE_FROM	The date upon which the competence becomes active and can be used to create new competence elements.
UNIT_STANDARD_ID
CREDIT_TYPE
CREDITS
LEVEL_TYPE
LEVEL_NUMBER
FIELD
DATE_TO	The date after which the competence is no longer active and cannot be used to create competence elements
SUB_FIELD
PROVIDER
QA_ORGANIZATION
BEHAVIOURAL_INDICATOR	A description of the behavioural charactaristics that would typically be displayed when the competence is present
INFORMATION_CATEGORY
INFORMATION1
INFORMATION2
INFORMATION3
INFORMATION4
INFORMATION5
INFORMATION6
INFORMATION7
INFORMATION8
INFORMATION9
INFORMATION10
INFORMATION11
INFORMATION12
INFORMATION13
INFORMATION14
INFORMATION15
INFORMATION16
INFORMATION17
INFORMATION18
INFORMATION19
CERTIFICATION_REQUIRED	An indication of whether certification is required for this competence
INFORMATION20
EVALUATION_METHOD	An indication of the type of evaluation that should be performed for this competence
RENEWAL_PERIOD_FREQUENCY	The period of time that may elapse before the competence must be re-certified
RENEWAL_PERIOD_UNITS	The unit used to measure the period of time that may elapse before the competence must be re-certified
MAX_LEVEL	The maximum proficiency level for the competence
MIN_LEVEL	The minimum proficiency level for the competence
BUSINESS_GROUP_ID	Foreign Key to HR_ORGANIZATION_UNITS
RATING_SCALE_ID	General Rating Scale that the Competence is to use
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.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
NAME	The short name of the competence
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.
DESCRIPTION	Description of knowledge, skill, ability or other charactaristic that defines the competence.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
COMPETENCE_DEFINITION_ID	competence definition identifier
COMPETENCE_ALIAS	cpmetence alias
COMPETENCE_CLUSTER

Human Resources - PER_COMPETENCE_ELEMENTS	A competence element is used to record an individual competence and an evaluation rating.
Column Name	Descritpion
COMPETENCE_ELEMENT_ID	Unique identifier fo Competence Elements
BUSINESS_GROUP_ID	Foreign Key to HR_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.
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.
TYPE	The type of Competence Element.
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.
COMPETENCE_ID	Competence Used
OBJECT_ID	Generic Foreign Key id.
OBJECT_NAME	Generic Foreign Key Name.
PARTY_ID	Foreign key to HZ_PARTIES.
QUALIFICATION_TYPE_ID
MEMBER_COMPETENCE_SET_ID	Competence Set for the Element
UNIT_STANDARD_TYPE
STATUS
PROFICIENCY_LEVEL_ID	Low Proficiency Level for the Element
INFORMATION_CATEGORY
INFORMATION1
INFORMATION2
INFORMATION3
INFORMATION4
INFORMATION5
INFORMATION6
INFORMATION7
INFORMATION8
INFORMATION9
HIGH_PROFICIENCY_LEVEL_ID	High Proficiency Level for the Element
INFORMATION10
INFORMATION11
INFORMATION12
INFORMATION13
INFORMATION14
INFORMATION15
INFORMATION16
INFORMATION17
INFORMATION18
INFORMATION19
INFORMATION20
WEIGHTING_LEVEL_ID	Weighting on particular competence to be used in an Assessment Type
RATING_LEVEL_ID	Rating for a particular competence in an Element
PERSON_ID	The person for whom the competence element applies.
ENTERPRISE_ID	Foreign key to HR_ORGANIZATION_UNITS
JOB_ID	Competence element for the Job requirement.
VALID_GRADE_ID	Foriegn Key to PER_VALID_GRADES
POSITION_ID	Competence Element for the Position requirement
ORGANIZATION_ID	Competence Element for the Organizational requirement
WORK_ITEM_ID	Competence Element for the Work Item
COMPETENCE_SET_ID	Grouping of Competences - Competence Set
PARENT_COMPETENCE_ELEMENT_ID	Competence Element which this competence element referes to
ACTIVITY_VERSION_ID	Activity Version of a Training course. Inidicates what competences a particular training activity can provide and at what levels.
ASSESSMENT_ID	Competence Element for the Assessment
ASSESSMENT_TYPE_ID	Competence Element for the Assessment Type
MANDATORY	An indication of whether the delivered competence should be automatically included in a persons competence profile or whether it should be manually selected.
EFFECTIVE_DATE_FROM	The date upon which the competence rating is effective
EFFECTIVE_DATE_TO	The date after which the competence rating is no longer valid
GROUP_COMPETENCE_TYPE	A group of competences used in an assessment template
COMPETENCE_TYPE	The categorization of a competence
SEQUENCE_NUMBER	A number to control the display sequence of elements within a profile
NORMAL_ELAPSE_DURATION	The elapsed time before a competence should be achieved within a planned competence profile
NORMAL_ELAPSE_DURATION_UNIT	The units for the elapsed time before a competence should be achieved within planned competence profile
SOURCE_OF_PROFICIENCY_LEVEL	The method by which the proficiency level was established e.g. Mandatory Delivered Competence, Assessemnt Rating
LINE_SCORE	The calculated score for a single line in an assessment
CERTIFICATION_DATE	The date on which the competence rating is certified
CERTIFICATION_METHOD	An indication of the process undertaken to determine he competence
NEXT_CERTIFICATION_DATE	The date on the which the next certification is due
COMMENTS	Comments

Human Resources - PER_ASSESSMENT_TYPES	The definition of an assessment template
Column Name	Descritpion
ASSESSMENT_TYPE_ID	Unique identifier of assessment type
DATE_FROM	Indication of when the assessment type will be avialable for use
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.
ASSESSMENT_CLASSIFICATION	An indication of whether the Assessment is designed to evaluate Performance, Proficiency or Both
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.
DISPLAY_ASSESSMENT_COMMENTS	An indication of whether the Comments item should be displayed on the Competence Assessment Questionnaire
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.
DESCRIPTION	A description of the assessment type
RATING_SCALE_COMMENT	Comments relating to the use of the Performance Rating Scale that will be displayed on an Assessment of this type
WEIGHTING_SCALE_COMMENT	Comments relating to the use of the Weighting Scale that will be displayed on an Assessment of this type
COMMENTS	Comments about the assessment type
INSTRUCTIONS	General Instructions to be displayed on any assessment of this type
LINE_SCORE_FORMULA	The formula used to calculate the score for each assessment line
TOTAL_SCORE_FORMULA	The formula used to calculate the total score for the assessment
WEIGHTING_CLASSIFICATION	An indication of whether the Weighting Value applies to the Proficiency Level or the Performance Rating
RATING_SCALE_ID	The rating scale used in the assessment template
WEIGHTING_SCALE_ID	The weighting scale used in the assessment template
BUSINESS_GROUP_ID	Foreign Key to HR_ORGANIZATION_UNITS
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
NAME	The title of the Assessmnt TYpe
DATE_TO	Indication of when the assessment type will be unavialable for use

Human Resources - PER_ASSESSMENTS	The grouping of a set of assessment elements.
Column Name	Descritpion
ASSESSMENT_TYPE_ID	The assessment type used by the assessment
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
ATTRIBUTE1	Descriptive flexfield column.
GROUP_DATE	The date that the group was created on
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.
GROUP_INITIATOR_ID	Foreign key to PER_ALL_PEOPLE_F, holds the ID of the person who created the 360 degree assessment.
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.
ASSESSOR_PERSON_ID	Foreign key to the assessor
ASSESSMENT_GROUP_ID	Asessment Group to be used
ASSESSMENT_DATE	The date of the competence assessment
STATUS	An indication of the status of the competence assessment
ASSESSMENT_PERIOD_START_DATE	The start date of the period to which the assessment applies
ASSESSMENT_PERIOD_END_DATE	The end date of the period to which the competence assessment applies
COMMENTS	Additional comments that an assessor may wish add about the overall assessment
TOTAL_SCORE	The overall score derived from the sum of the individual assessment line scores
APPRAISAL_ID	Foreign key to PER_APPRAISALS
ASSESSMENT_ID	Unique identifier for Assessment
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
PERSON_ID	Foreign key to the Assessee

Human Resources - PER_ASSESSMENT_GROUPS	Grouping of People for 360 reviews
Column Name	Descritpion
ASSESSMENT_GROUP_ID	Unique identifier of assessment group
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.
BUSINESS_GROUP_ID	Foreign Key to HR_ORGANIZATION_UNITS
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
NAME	The name of the Assessment Group
MEMBERSHIP_LIST	The set of people who will carry out asssessments i.e. the 360 degree assessment group
COMMENTS	Comments

Human Resources - PER_ESTABLISHMENT_ATTENDANCES	A record of educational establishments that a person is currently attending or has previously attended.
Column Name	Descritpion
ATTENDANCE_ID	PK of entity
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
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.
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.
ESTABLISHMENT	Used for on the fly establishment creation.
PARTY_ID	Foreign to hz_parties.
ADDRESS	Stores Address
ATTENDED_START_DATE	Maintains the attendance start date at a particular establishment
PERSON_ID	Foreign key to PER_ALL_PEOPLE_F.
FULL_TIME	Stores whether the attendance at an establishment was full-time
ATTENDED_END_DATE	Maintains the date attendance ended at a particular establishment
ESTABLISHMENT_ID	PK of entity

Human Resources - PER_ESTABLISHMENTS	This entity is used to maintain a list of educational establishments e.g. schools, colleges, universities, etc.
Column Name	Descritpion
ESTABLISHMENT_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.
EST_INFORMATION_CATEGORY	Developer descriptive flexfield structure defining column.
EST_INFORMATION1	Developer descriptive flexfield column.
EST_INFORMATION2	Developer descriptive flexfield column.
EST_INFORMATION3	Developer descriptive flexfield column.
EST_INFORMATION4	Developer descriptive flexfield column.
EST_INFORMATION5	Developer descriptive flexfield column.
EST_INFORMATION6	Developer descriptive flexfield column.
EST_INFORMATION7	Developer descriptive flexfield column.
EST_INFORMATION8	Developer descriptive flexfield column.
EST_INFORMATION9	Developer descriptive flexfield column.
EST_INFORMATION10	Developer descriptive flexfield column.
EST_INFORMATION11	Developer descriptive flexfield column.
EST_INFORMATION12	Developer descriptive flexfield column.
EST_INFORMATION13	Developer descriptive flexfield column.
EST_INFORMATION14	Developer descriptive flexfield column.
NAME	Maintains the name of an educational establishment
EST_INFORMATION15	Developer descriptive flexfield column.
EST_INFORMATION16	Developer descriptive flexfield column.
EST_INFORMATION17	Developer descriptive flexfield column.
EST_INFORMATION18	Developer descriptive flexfield column.
EST_INFORMATION19	Developer descriptive flexfield column.
EST_INFORMATION20	Developer descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who Column.
LAST_UPDATED_BY	Standard Who Column.
LAST_UPDATE_LOGIN	Standard Who Column.
CREATION_DATE	Standard Who Column.
CREATED_BY	Standard Who Column.
PARTY_ID	Foriegn key to hz_parties.
LOCATION	Holds the location details of an establishment

Human Resources - PER_DEPLOYMENT_FACTORS	A factor affecting a person's capacity to be deployed within an organization.
Column Name	Descritpion
BUSINESS_GROUP_ID	FK to hr_organization_units table.
OBJECT_VERSION_NUMBER	Object version number is used to uniquely identify if a user is looking at the current record in the database.
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.
WORK_ANY_COUNTRY	Yes/No field to descibe whether work is required to be done in an
LAST_UPDATE_LOGIN	Standard Who Column.
CREATED_BY	Standard Who Column.
CREATION_DATE	Standard Who Column.
WORK_ANY_LOCATION	Willingness to work in any location.
RELOCATE_DOMESTICALLY	Willingness to relocate domestically.
RELOCATE_INTERNATIONALLY	Willingness to relocate internationally.
TRAVEL_REQUIRED	Indicates whether travel is required
COUNTRY1	Attribute used to state a country where work will be required.
COUNTRY2	Attribute used to store a country where work may be required.
DEPLOYMENT_FACTOR_ID	PK of per_deployment_factors table.
COUNTRY3	Attribute used to store country where work may be required to be
WORK_DURATION	Work duration that is required.
WORK_SCHEDULE	Indicates work schedule desired.
WORK_HOURS	Indicates work hours desired.
FTE_CAPACITY	Indicates full time capacity.
VISIT_INTERNATIONALLY	Indicates whether a person is willing to visit internationally.
ONLY_CURRENT_LOCATION	Indicates that a person is only willing to work within his/her cu
NO_COUNTRY1	Indicates a country that a person does not want to work in.
NO_COUNTRY2	Indicates a country that a person is not interested in working in
NO_COUNTRY3	Indicates a country that a person is not interested in working in
COMMENTS	Comments related to the persons deployment.
EARLIEST_AVAILABLE_DATE	Used to indicate earliest available date for a persons transfer.
AVAILABLE_FOR_TRANSFER	Indicates whether a person is available for transfer.
RELOCATION_PREFERENCE	Indicates a persons relocation preference.
RELOCATION_REQUIRED	Indicates that the job/position requires relocation.
PASSPORT_REQUIRED	Indicates that a passport is required for the job/position.
LOCATION1	Indicates a location where the job/position will required work to
LOCATION2	Indicates a location where the job/position will require work to
LOCATION3	Indicates a location where the job/position will require work to
OTHER_REQUIREMENTS	Comments relevant to the job/position.
POSITION_ID	FK to PER_ALL_POSITIONS table.
SERVICE_MINIMUM	Indicates the minimum length of service to be considered for the
PERSON_ID	FK to PER_ALL_PEOPLE_F table.
JOB_ID	FK to per_jobs table.

Human Resources - PER_APPRAISAL_TEMPLATES	The heading or grouping of appraisal questions.
Column Name	Descritpion
APPRAISAL_TEMPLATE_ID	Primary key of Appraisal Template
DATE_TO	The date until which the Appraisal Template is valid
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
ASSESSMENT_TYPE_ID	Unique identifier of assessment type
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.
RATING_SCALE_ID	Primary Key for PER_RATING_SCALES
QUESTIONNAIRE_TEMPLATE_ID	Foreign key to PER_PROPOSAL_QUESTION_TYPES.
QUESTIONNAIRE_LANGUAGE	The language of the Questionnaire
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
NAME	Name or Title of the Appraisal Template
DESCRIPTION	A brief description of the nature and purpose of the appraisal te
INSTRUCTIONS	General instructions on how to complete the Appraisal
DATE_FROM	The date from which the Appraisal Template is valid

Human Resources - PER_APPRAISALS	An appraisal is a record of an evaluation of a person by others.
Column Name	Descritpion
APPRAISAL_ID	Primary key of Appraisals
APPRAISAL_PERIOD_END_DATE	The date on which the review period ended
APPRAISAL_PERIOD_START_DATE	The date on which the review period started
TYPE	The type of appraisal being performed e.g. Annual Review
NEXT_APPRAISAL_DATE	The proposed date of the next appraisal
STATUS	The status of the appraisal within an approval process. e.g. awai
COMMENTS	General comments about the appraisal
OVERALL_PERFORMANCE_LEVEL_ID	Unique identifier of the Rating Level
OPEN	Denotes whether the appraisal can be modified or not.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
ATTRIBUTE1	Descriptive flexfield column.
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ATTRIBUTE2	Descriptive flexfield column.
ATTRIBUTE3	Descriptive flexfield column.
ATTRIBUTE4	Descriptive flexfield column.
ATTRIBUTE5	Descriptive flexfield column.
ATTRIBUTE6	Descriptive flexfield column.
ATTRIBUTE7	Descriptive flexfield column.
ATTRIBUTE8	Descriptive flexfield column.
ATTRIBUTE9	Descriptive flexfield column.
ATTRIBUTE10	Descriptive flexfield column.
ATTRIBUTE11	Descriptive flexfield column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE17	Descriptive flexfield column.
ATTRIBUTE18	Descriptive flexfield column.
ATTRIBUTE19	Descriptive flexfield column.
ATTRIBUTE20	Descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
APPRAISAL_TEMPLATE_ID	Primary key of Appraisal Template
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
SYSTEM_TYPE	Appraisal System Type as defined in lookup APPRAISAL_SYS_TYPE
APPRAISAL_SYSTEM_STATUS	Denotes the current system status of Appraisal
SYSTEM_PARAMS	Appraisal System Parameters containing Approval process name, Function customization information, Approvals Enabled
APPRAISEE_ACCESS	Contains Accesswhich determines the information that will be shown to the Appraisee
MAIN_APPRAISER_ID	Foreign key to PER_ALL_PEOPLE_F, holds the ID of the person who is the Main Appraiser and is the one who gives Final Ratings for the Appraisal
ASSIGNMENT_ID	Foreign key to PER_ALL_ASSIGNMENTS_F, holds the ID of the Assignment on which this Appraisal is performed.
APPRAISEE_PERSON_ID	Foreign key to PER_ALL_ASSIGNMENTS_F, holds the ID of the person on whom the appraisal is being performed.
ASSIGNMENT_START_DATE	Start Date of the Assignment which is copied from the ASSIGNMENT_ID of this Appraisal.
ASSIGNMENT_BUSINESS_GROUP_ID	Business Group Id which is copied from PER_ALL_ASSIGNMENTS_F corresponding to the ASSIGNMENT_ID and ASSIGNMENT_START_DATE of this Appraisal.
ASSIGNMENT_ORGANIZATION_ID	Organization Id which is copied from PER_ALL_ASSIGNMENTS_F corresponding to the ASSIGNMENT_ID and ASSIGNMENT_START_DATE of this Appraisal.
ASSIGNMENT_JOB_ID	Job Id which is copied from PER_ALL_ASSIGNMENTS_F corresponding to the ASSIGNMENT_ID and ASSIGNMENT_START_DATE of this Appraisal.
ASSIGNMENT_POSITION_ID	Position Id which is copied from PER_ALL_ASSIGNMENTS_F corresponding to the ASSIGNMENT_ID and ASSIGNMENT_START_DATE of this Appraisal.
ASSIGNMENT_GRADE_ID	Grade Id which is copied from PER_ALL_ASSIGNMENTS_F corresponding to the ASSIGNMENT_ID and ASSIGNMENT_START_DATE of this Appraisal.
POTENTIAL_READINESS_LEVEL	Readiness Level of the Appraisee given during Final Ratings. Uses the lookup READINESS_LEVEL for the values.
POTENTIAL_SHORT_TERM_WORKOPP	Potential Short Term Work Opportunity for the Appraisee given during Final Ratings.
POTENTIAL_LONG_TERM_WORKOPP	Potential Long Term Work Opportunity for the Appraisee given during Final Ratings.
POTENTIAL_DETAILS	Potential Details for the Appraisee given during Final Ratings.
APPRAISER_PERSON_ID	Foreign key to PER_ALL_ASSIGNMENTS_F, holds the ID of the person performing the appraisal.
EVENT_ID	Foreign key to PER_EVENTS. Refers to the Event recorded for this Appraisal. The event can be used to refer to PER_PERFORMANCE_REVIEWS to get the Performance Rating for the Appraisal.
APPRAISAL_DATE	The date on which the appraisal takes place
GROUP_DATE	The date the group was created on.
GROUP_INITIATOR_ID	The ID of the user who created the group.

Human Resources - HR_WORKING_PERSON_LISTS	Holds a list of people who constitute a user current list, used in the Line Manager Web pages
Column Name	Descritpion
MULTIPLE_SELECTION	An indication that the row is part of a set currently being worked with.
WORKING_PERSON_LIST_ID	Primary key of HR_WORKING_PERSON_LISTS.
OWNING_PERSON_ID	Foreign key to PER_ALL_PEOPLE_F, holds the ID of the person whow owns the list.
SELECTED_PERSON_ID	Foreign key to PER_ALL_PEOPLE_F, holds the ID of the selected person.
SELECTED_ASSIGNMENT_ID	Assignment Id of the selected person
CURRENT_SELECTION	An indication that the person is currently being worked with.

Human Resources - PER_COBRA_DEPENDENTS_F	Holds employee dependents coverage for a COBRA qualifying event.
Column Name	Descritpion
EFFECTIVE_END_DATE	Effective end date of a dependents cobra coverage
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.
COBRA_DEPENDENT_ID	System generated primary key.
COBRA_COVERAGE_ENROLLMENT_ID	FK to per_cobra_cov_enrollments
CONTACT_RELATIONSHIP_ID	FK to per_contact_relationships table
EFFECTIVE_START_DATE	Effective start date of dependents cobra coverage

Human Resources - PER_COBRA_COVERAGE_PERIODS	Holds coverage periods for COBRA qualifying events.
Column Name	Descritpion
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.
COBRA_COVERAGE_ID	System generated primary key.
QUALIFYING_EVENT	Qualifying event code.
EFFECTIVE_START_DATE	Effective start date of when this type of event coverage began
EFFECTIVE_END_DATE	Effective end date of when this type of event coverage ends
COVERAGE	Number used to describe the period of the coverage.
COVERAGE_UOM	Coverage units e.g. days, months, etc.
TYPE_CODE	Type code which describes special circumstances for the qualifyin

Human Resources - PER_ASSIGNMENT_BUDGET_VALUES_F	Budget values for an assignment.
Column Name	Descritpion
EFFECTIVE_END_DATE	Date track effective date column
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
ASSIGNMENT_ID	Foreign key to PER_ASSIGNMENTS.
UNIT	Budget measurement units, for example, headcount, FTE, points.
VALUE	Budget measurement value.
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
ASSIGNMENT_BUDGET_VALUE_ID	System-generated primary key column.
EFFECTIVE_START_DATE	Date track effective date column

Human Resources - PER_ASSIGNMENT_INFO_TYPES_TL	Translated types of extra information that may be held against an assignment.
Column Name	Descritpion
INFORMATION_TYPE	Foreign key to PER_ASSIGNMENT_INFO_TYPES
SOURCE_LANG	Actual language
DESCRIPTION	Translated description of the information type
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LANGUAGE	Defined language

Human Resources - PER_ASSIGNMENT_STATUS_TYPES_TL	Predefined and user defined translated assignment status types.
Column Name	Descritpion
ASSIGNMENT_STATUS_TYPE_ID	Foreign key to PER_ASSIGNMENT_STATUS_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
LANGUAGE	Defined language
SOURCE_LANG	Actual Language
USER_STATUS	Translated user defined status name
EXTERNAL_STATUS	User defined status for the applicant to see

Human Resources - PER_ASS_STATUS_TYPE_AMENDS_TL	Translated user amendments to predefined assignment status types.
Column Name	Descritpion
ASS_STATUS_TYPE_AMEND_ID	Foreign key to PER_ASS_STATUS_TYPE_AMENDS
LANGUAGE	Defined language
SOURCE_LANG	Actual Language
USER_STATUS	User-defined status name.
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_CAGR_GRADES	The reference collectively agreed grades for a Collective Agreement.
Column Name	Descritpion
CAGR_GRADE_STRUCTURE_ID	Foreign key to PER_CAGR_GRADE_STRUCTURES
CREATION_DATE	Standard Who column
CAGR_GRADE_DEF_ID	Foreign key to PER_CAGR_GRADES_DEF
SEQUENCE	Sequence number of the grade within the structure
CAGR_GRADE_ID	System generated primary key from PER_CAGR_GRADES_S
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
CREATED_BY	Standard Who column

Human Resources - PER_CAGR_GRADES_DEF	Collective agreement grades key flexfield combinations table.
Column Name	Descritpion
CAGR_GRADE_DEF_ID	System-generated primary key using sequence PER_CAGR_GRADES_DEF_S
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
CONCATENATED_SEGMENTS	Concatination of all selected segments
LAST_UPDATE_DATE	Standard Who column
LAST_UPDATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
SUMMARY_FLAG	Key flexfield summary flag
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
ENABLED_FLAG	Key flexfield enabled flag
START_DATE_ACTIVE	Date the key flexfield combination becomes active or valid
END_DATE_ACTIVE	Date the key flexfield combination becomes inactive or invalid
SEGMENT1	Key flexfield segment column
SEGMENT2	Key flexfield segment column
SEGMENT3	Key flexfield segment column

Human Resources - PER_CAGR_GRADE_STRUCTURES	The valid collectively agreed grade key flexfield structures for a particular collective agreement
Column Name	Descritpion
CAGR_GRADE_STRUCTURE_ID	System-generated primary key using sequence PER_CAGR_GRADE_STRUCTURES_S
ATTRIBUTE4	Descriptive flexfield column
ATTRIBUTE5	Descriptive flexfield column
ATTRIBUTE6	Descriptive flexfield column
ATTRIBUTE7	Descriptive flexfield column
ATTRIBUTE8	Descriptive flexfield column
ID_FLEX_NUM	Key flexfield structure foreign key
ATTRIBUTE9	Descriptive flexfield column
ATTRIBUTE10	Descriptive flexfield column
ATTRIBUTE11	Descriptive flexfield column
ATTRIBUTE12	Descriptive flexfield column
ATTRIBUTE13	Descriptive flexfield column
COLLECTIVE_AGREEMENT_ID	Foreign key to PER_COLLECTIVE_AGREEMENTS
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
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
DYNAMIC_INSERT_ALLOWED	An indication of whether the assignment CA grades can vary from the collectively agreed set
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
ATTRIBUTE1	Descriptive flexfield column
ATTRIBUTE2	Descriptive flexfield column
ATTRIBUTE3	Descriptive flexfield column

Human Resources - PER_COLLECTIVE_AGREEMENTS	Collective agreement information.
Column Name	Descritpion
COLLECTIVE_AGREEMENT_ID	System generated primary key.
EMPLOYER_SIGNATORY	The name of the signatory on behalf of the employer
BARGAINING_UNIT_SIGNATORY	The name of the signatory on behalf of the bargaining unit
JURISDICTION	The jurisdication or coverage of the collective agreement
AUTHORIZING_BODY	The administrative body which authorizes the collective agreement
NAME	Name of the Collective agreement
AUTHORIZED_DATE	The date on which the collective agreement is authorized
STATUS	The status of the collective agreement
PL_ID	Foreign Key to BEN_PL table.
CAG_INFORMATION_CATEGORY	Developer descriptive flexfield structure defining column
CAG_INFORMATION1	Developer descriptive flexfield column
CAG_INFORMATION2	Developer descriptive flexfield column
CAG_INFORMATION3	Developer descriptive flexfield column
EMPLOYER_ORGANIZATION_ID	Foreign key to HR_ALL_ORGANIZATION_UNITS
CAG_INFORMATION4	Developer descriptive flexfield column
CAG_INFORMATION5	Developer descriptive flexfield column
CAG_INFORMATION6	Developer descriptive flexfield column
CAG_INFORMATION7	Developer descriptive flexfield column
CAG_INFORMATION8	Developer descriptive flexfield column
BARGAINING_ORGANIZATION_ID	Foreign key to HR_ALL_ORGANIZATION_UNITS
CAG_INFORMATION9	Developer descriptive flexfield column
CAG_INFORMATION10	Developer descriptive flexfield column
CAG_INFORMATION11	Developer descriptive flexfield column
CAG_INFORMATION12	Developer descriptive flexfield column
CAG_INFORMATION13	Developer descriptive flexfield column
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
CAG_INFORMATION14	Developer descriptive flexfield column
CAG_INFORMATION15	Developer descriptive flexfield column
CAG_INFORMATION16	Developer descriptive flexfield column
CAG_INFORMATION17	Developer descriptive flexfield column
CAG_INFORMATION18	Developer descriptive flexfield column
CAG_INFORMATION19	Developer descriptive flexfield column
CAG_INFORMATION20	Developer descriptive flexfield column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield column
ATTRIBUTE2	Descriptive flexfield column
BUSINESS_GROUP_ID	Foreign key to HR_ALL_ORGANIZATION_UNITS
ATTRIBUTE3	Descriptive flexfield column
ATTRIBUTE4	Descriptive flexfield column
ATTRIBUTE5	Descriptive flexfield column
ATTRIBUTE6	Descriptive flexfield column
ATTRIBUTE7	Descriptive flexfield column
ATTRIBUTE8	Descriptive flexfield column
ATTRIBUTE9	Descriptive flexfield column
ATTRIBUTE10	Descriptive flexfield column
ATTRIBUTE11	Descriptive flexfield column
ATTRIBUTE12	Descriptive flexfield column
CAG_NUMBER	Collective agreement reference number
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
DESCRIPTION	Description
LAST_UPDATE_LOGIN	Standard Who column
CREATED_BY	Standard Who column
CREATION_DATE	Standard Who column
START_DATE	Start Date of agreement
END_DATE	End Date of agreement

Human Resources - PER_CONTRACTS_F	The details of a persons contract of employment
Column Name	Descritpion
BUSINESS_GROUP_ID	Foreign key to HR_ALL_ORGANIZATION_UNITS
STATUS_REASON	The reason for change of status of the contract
DOC_STATUS	This column holds the status of the physical contract
DOC_STATUS_CHANGE_DATE	Holds the date that the doc_status column last changed its value.
DESCRIPTION	Description
DURATION	The duration of the contract
DURATION_UNITS	The units of time in which the duration is expressed
CONTRACTUAL_JOB_TITLE	The contractual job title - N.B. not related to PER_JOBS
PARTIES	The signatory parties (other than the employee)
START_REASON	The reason for the contracts existence
END_REASON	The reason for ending the contract
NUMBER_OF_EXTENSIONS	The number of times the contract has been extended
EXTENSION_REASON	The reason for extending the contract
EFFECTIVE_START_DATE	Effective Start Date
EXTENSION_PERIOD	The period of time for which the contract has been extended
EXTENSION_PERIOD_UNITS	The units of time in which the extension period has been expressed
CTR_INFORMATION_CATEGORY	Developer descriptive flexfield structure defining column
CTR_INFORMATION1	Developer descriptive flexfield column
CTR_INFORMATION2	Developer descriptive flexfield column
CTR_INFORMATION3	Developer descriptive flexfield column
CTR_INFORMATION4	Developer descriptive flexfield column
CTR_INFORMATION5	Developer descriptive flexfield column
CTR_INFORMATION6	Developer descriptive flexfield column
CTR_INFORMATION7	Developer descriptive flexfield column
EFFECTIVE_END_DATE	Effective End Date
CTR_INFORMATION8	Developer descriptive flexfield column
CTR_INFORMATION9	Developer descriptive flexfield column
CTR_INFORMATION10	Developer descriptive flexfield column
CTR_INFORMATION11	Developer descriptive flexfield column
CTR_INFORMATION12	Developer descriptive flexfield column
CTR_INFORMATION13	Developer descriptive flexfield column
CTR_INFORMATION14	Developer descriptive flexfield column
CTR_INFORMATION15	Developer descriptive flexfield column
CTR_INFORMATION16	Developer descriptive flexfield column
CTR_INFORMATION17	Developer descriptive flexfield column
PERSON_ID	Foreign key to PER_ALL_PEOPLE_F
CTR_INFORMATION18	Developer descriptive flexfield column
CTR_INFORMATION19	Developer descriptive flexfield column
CTR_INFORMATION20	Developer descriptive flexfield column
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1	Descriptive flexfield column
OBJECT_VERSION_NUMBER	System generated version of row. Increments by one each update
ATTRIBUTE2	Descriptive flexfield column
ATTRIBUTE3	Descriptive flexfield column
ATTRIBUTE4	Descriptive flexfield column
ATTRIBUTE5	Descriptive flexfield column
ATTRIBUTE6	Descriptive flexfield column
CONTRACT_ID	System generated primary key.
REFERENCE	The title or reference number of the contract
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
TYPE	The type of contract
STATUS	The status of the contract

Human Resources - PER_CHECKLIST_ITEMS	Checklist information.
Column Name	Descritpion
CHECKLIST_ITEM_ID	System generated primary key
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.
PERSON_ID	Foreign key to PER_ALL_PEOPLE_F
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.
ITEM_CODE	Constrained to HR_LOOKUPS.LOOKUP_CODE fo LOOKUP_TYPE = CHECKLIST
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.
DATE_DUE	Date due for completion
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_DONE	Actual date of completion
STATUS	Constrained to HR_LOOKUPS.LOOKUP_CODE for LOOKUP_TYPE = CHECKLIST_STATUS
NOTES	Free text for comments
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.

Human Resources - HR_WINDOW_PROPERTIES_B	Properties of windows for configurable forms
Column Name	Descritpion
WINDOW_PROPERTY_ID	System-generated primary key using sequence HR_WINDOW_PROPERTIES_B_S
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.
FORM_WINDOW_ID	Foreign Key to HR_FORM_WINDOWS_B
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.
TEMPLATE_WINDOW_ID	Foreign Key to HR_TEMPLATE_WINDOWS_B
INFORMATION22	Developer descriptive flexfield column.
INFORMATION23	Developer descriptive flexfield column.
INFORMATION24	Developer descriptive flexfield column.
INFORMATION25	Developer descriptive flexfield column.
INFORMATION26	Developer descriptive flexfield column.
INFORMATION27	Developer descriptive flexfield column.
INFORMATION28	Developer descriptive flexfield column.
INFORMATION29	Developer descriptive flexfield column.
INFORMATION30	Developer descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
HEIGHT	Height of window
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
WIDTH	Width of window
X_POSITION	x-position of window
Y_POSITION	y-position of window
INFORMATION_CATEGORY	Developer descriptive flexfield column.
INFORMATION1	Developer descriptive flexfield column.

Human Resources - HR_WINDOW_PROPERTIES_TL	Translated properties of windows for configurable forms
Column Name	Descritpion
WINDOW_PROPERTY_ID	System-generated primary key using sequence HR_WINDOW_PROPERTIES_TL_S
LANGUAGE	Defined language
SOURCE_LANG	Actual language
TITLE	Translated title of window
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.

Human Resources - PER_DISABILITIES_F	Hold Disability information for one person
Column Name	Descritpion
EFFECTIVE_START_DATE	Effective Start Date
ATTRIBUTE2	Descriptive flex column.
ATTRIBUTE3	Descriptive flex column.
ATTRIBUTE4	Descriptive flex column.
ATTRIBUTE5	Descriptive flex column.
ATTRIBUTE6	Descriptive flex column.
ATTRIBUTE7	Descriptive flex column.
ATTRIBUTE8	Descriptive flex column.
ATTRIBUTE9	Descriptive flex column.
ATTRIBUTE10	Descriptive flex column.
ATTRIBUTE11	Descriptive flex column.
EFFECTIVE_END_DATE	Effective End Date
ATTRIBUTE12	Descriptive flex column.
ATTRIBUTE13	Descriptive flex column.
ATTRIBUTE14	Descriptive flex column.
ATTRIBUTE15	Descriptive flex column.
ATTRIBUTE16	Descriptive flex column.
ATTRIBUTE17	Descriptive flex column.
ATTRIBUTE18	Descriptive flex column.
ATTRIBUTE19	Descriptive flex column.
ATTRIBUTE20	Descriptive flex column.
ATTRIBUTE21	Descriptive flex column.
PERSON_ID	Foreign key to PER_PEOPLE_F.
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.
ATTRIBUTE29	Descriptive flex column.
ATTRIBUTE30	Descriptive flex column.
DIS_INFORMATION_CATEGORY	Developer descriptive flex structure defining column
INCIDENT_ID	Foreign key to PER_WORK_INCIDENTS.
DIS_INFORMATION1	Developer descriptive flex column.
DIS_INFORMATION2	Developer descriptive flex column.
DIS_INFORMATION3	Developer descriptive flex column.
DIS_INFORMATION4	Developer descriptive flex column.
DIS_INFORMATION5	Developer descriptive flex column.
DIS_INFORMATION6	Developer descriptive flex column.
DIS_INFORMATION7	Developer descriptive flex column.
DIS_INFORMATION8	Developer descriptive flex column.
DIS_INFORMATION9	Developer descriptive flex column.
DIS_INFORMATION10	Developer descriptive flex column.
ORGANIZATION_ID	Foreign key to HR_ALL_ORGANIZATION_UNITS.
DIS_INFORMATION11	Developer descriptive flex column.
DIS_INFORMATION12	Developer descriptive flex column.
DIS_INFORMATION13	Developer descriptive flex column.
DIS_INFORMATION14	Developer descriptive flex column.
DIS_INFORMATION15	Developer descriptive flex column.
DIS_INFORMATION16	Developer descriptive flex column.
DIS_INFORMATION17	Developer descriptive flex column.
DIS_INFORMATION18	Developer descriptive flex column.
DIS_INFORMATION19	Developer descriptive flex column.
DIS_INFORMATION20	Developer descriptive flex column.
DIS_INFORMATION21	Developer descriptive flex column.
DIS_INFORMATION22	Developer descriptive flex column.
REGISTRATION_ID	ID given to person following registration with disability organization.
DIS_INFORMATION23	Developer descriptive flex column.
DIS_INFORMATION24	Developer descriptive flex column.
DIS_INFORMATION25	Developer descriptive flex column.
DIS_INFORMATION26	Developer descriptive flex column.
DIS_INFORMATION27	Developer descriptive flex column.
DIS_INFORMATION28	Developer descriptive flex column.
DIS_INFORMATION29	Developer descriptive flex column.
DIS_INFORMATION30	Developer descriptive flex column.
LAST_UPDATE_DATE	standard Who column.
LAST_UPDATED_BY	standard Who column.
REGISTRATION_DATE	Date of registration with organization for the disabled.
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.
REGISTRATION_EXP_DATE	Expiry date of registration with organization for the disabled.
DISABILITY_ID	Primary key. Generated from sequence PER_DISABILITIES_S.
CATEGORY	Official category of disability.
DESCRIPTION	Description of disability.
DEGREE	Assessed percentage of disability.
STATUS	Status of the record
ASSIGNMENT_ID
QUOTA_FTE	Full time equivalence quota.
REASON	Reason for disability.
PRE_REGISTRATION_JOB	Name of job held by person at disability registration date.
WORK_RESTRICTION	Description of restriction(s) to work.
ATTRIBUTE_CATEGORY	Descriptive flex structure defining column.
ATTRIBUTE1	Descriptive flex column.

Human Resources - PER_COMPETENCE_DEFINITIONS	COMPETENCES Key flexfield combinations table
Column Name	Descritpion
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.
COMPETENCE_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.

Human Resources - PER_BF_BALANCE_AMOUNTS	Holds assignment level run amount and summary values for backfeed balances by payroll processing period
Column Name	Descritpion
BALANCE_AMOUNT_ID	Unique System Identifier
RUN_AMOUNT	Run amount balance
OBJECT_VERSION_NUMBER	System generated version of row
BBA_ATTRIBUTE_CATEGORY
BBA_ATTRIBUTE1
BBA_ATTRIBUTE2
BBA_ATTRIBUTE3
BBA_ATTRIBUTE4
BBA_ATTRIBUTE5
BBA_ATTRIBUTE6
BBA_ATTRIBUTE7
BALANCE_TYPE_ID	FK to PER_BF_BALANCE_TYPES
BBA_ATTRIBUTE8
BBA_ATTRIBUTE9
BBA_ATTRIBUTE10
BBA_ATTRIBUTE11
BBA_ATTRIBUTE12
BBA_ATTRIBUTE13
BBA_ATTRIBUTE14
BBA_ATTRIBUTE15
BBA_ATTRIBUTE16
BBA_ATTRIBUTE17
PROCESSED_ASSIGNMENT_ID	FK to PER_BF_PROCESSED_ASSIGNMENTS
BBA_ATTRIBUTE18
BBA_ATTRIBUTE19
BBA_ATTRIBUTE20
BBA_ATTRIBUTE21
BBA_ATTRIBUTE22
BBA_ATTRIBUTE23
BBA_ATTRIBUTE24
BBA_ATTRIBUTE25
BBA_ATTRIBUTE26
BBA_ATTRIBUTE27
BUSINESS_GROUP_ID	FK to HR_ALL_ORGANIZATION_UNITS
BBA_ATTRIBUTE28
BBA_ATTRIBUTE29
BBA_ATTRIBUTE30
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
YTD_AMOUNT	Year To Date balance amount
FYTD_AMOUNT	Financial Year to Date Balance amount
SECURITY_GROUP_ID
PTD_AMOUNT	Period to Date balance amount.
MTD_AMOUNT	Month to Date Balance Amount
QTD_AMOUNT	Quarter to Date balance amount

Human Resources - PER_BF_PAYMENT_DETAILS	Holds details of payments that have been processed by a 3rd party payroll provider, by assignment.
Column Name	Descritpion
PAYMENT_DETAIL_ID	System Generated unique identifier for row
OBJECT_VERSION_NUMBER	System generated version of row
BPD_ATTRIBUTE_CATEGORY
BPD_ATTRIBUTE1
BPD_ATTRIBUTE2
BPD_ATTRIBUTE3
BPD_ATTRIBUTE4
BPD_ATTRIBUTE5
BPD_ATTRIBUTE6
BPD_ATTRIBUTE7
BPD_ATTRIBUTE8
PROCESSED_ASSIGNMENT_ID	FK to PER_BF_PROCESSED_ASSIGNMENTS
BPD_ATTRIBUTE9
BPD_ATTRIBUTE10
BPD_ATTRIBUTE11
BPD_ATTRIBUTE12
BPD_ATTRIBUTE13
BPD_ATTRIBUTE14
BPD_ATTRIBUTE15
BPD_ATTRIBUTE16
BPD_ATTRIBUTE17
BPD_ATTRIBUTE18
PERSONAL_PAYMENT_METHOD_ID	FK to PAY_PERSONAL_PAYMENT_METHODS_F
BPD_ATTRIBUTE19
BPD_ATTRIBUTE20
BPD_ATTRIBUTE21
BPD_ATTRIBUTE22
BPD_ATTRIBUTE23
BPD_ATTRIBUTE24
BPD_ATTRIBUTE25
BPD_ATTRIBUTE26
BPD_ATTRIBUTE27
BPD_ATTRIBUTE28
BUSINESS_GROUP_ID	Business group id
BPD_ATTRIBUTE29
BPD_ATTRIBUTE30
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
CHECK_NUMBER	Number of the check that was issued
PAYMENT_DATE	Date the check was issued
SECURITY_GROUP_ID
AMOUNT	Amount
CHECK_TYPE	Country specific type

Human Resources - PER_BF_PROCESSED_ASSIGNMENTS	Intersection table storing details of assignments that have been processed by a 3rd party payroll provider in each payroll run
Column Name	Descritpion
PROCESSED_ASSIGNMENT_ID	System Generated unique identifier for row
BPA_ATTRIBUTE5
BPA_ATTRIBUTE6
BPA_ATTRIBUTE7
BPA_ATTRIBUTE8
BPA_ATTRIBUTE9
BPA_ATTRIBUTE10
BPA_ATTRIBUTE11
BPA_ATTRIBUTE12
BPA_ATTRIBUTE13
BPA_ATTRIBUTE14
PAYROLL_RUN_ID	FK to PER_BF_PAYROLL_RUN
BPA_ATTRIBUTE15
BPA_ATTRIBUTE16
BPA_ATTRIBUTE17
BPA_ATTRIBUTE18
BPA_ATTRIBUTE19
BPA_ATTRIBUTE20
BPA_ATTRIBUTE21
BPA_ATTRIBUTE22
BPA_ATTRIBUTE23
BPA_ATTRIBUTE24
ASSIGNMENT_ID	FK to PER_ALL_ASSIGNMENTS_F
BPA_ATTRIBUTE25
BPA_ATTRIBUTE26
BPA_ATTRIBUTE27
BPA_ATTRIBUTE28
BPA_ATTRIBUTE29
BPA_ATTRIBUTE30
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
CREATED_BY	Standard WHO Column
OBJECT_VERSION_NUMBER	System generated version of row. Increments by one with each update
CREATION_DATE	Standard WHO Column
BPA_ATTRIBUTE_CATEGORY
BPA_ATTRIBUTE1
SECURITY_GROUP_ID
BPA_ATTRIBUTE2
BPA_ATTRIBUTE3
BPA_ATTRIBUTE4

Human Resources - PER_BF_PAYROLL_RUNS	Payrolls processed by 3rd party payroll provider.
Column Name	Descritpion
PAYROLL_RUN_ID	System generated unique identifier for row
BPR_ATTRIBUTE1
BPR_ATTRIBUTE2
BPR_ATTRIBUTE3
BPR_ATTRIBUTE4
BPR_ATTRIBUTE5
BPR_ATTRIBUTE6
BPR_ATTRIBUTE7
BPR_ATTRIBUTE8
BPR_ATTRIBUTE9
BPR_ATTRIBUTE10
PAYROLL_ID	FK to PAY_ALL_PAYROLLS_F
BPR_ATTRIBUTE11
BPR_ATTRIBUTE12
BPR_ATTRIBUTE13
BPR_ATTRIBUTE14
BPR_ATTRIBUTE15
BPR_ATTRIBUTE16
BPR_ATTRIBUTE17
BPR_ATTRIBUTE18
BPR_ATTRIBUTE19
BPR_ATTRIBUTE20
BUSINESS_GROUP_ID	Business group id
BPR_ATTRIBUTE21
BPR_ATTRIBUTE22
BPR_ATTRIBUTE23
BPR_ATTRIBUTE24
BPR_ATTRIBUTE25
BPR_ATTRIBUTE26
BPR_ATTRIBUTE27
BPR_ATTRIBUTE28
BPR_ATTRIBUTE29
BPR_ATTRIBUTE30
PAYROLL_IDENTIFIER	An identifier to uniquely identify this payroll run from others which may have also been run in the same period
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
PERIOD_START_DATE	Start Date of the payroll period.
PERIOD_END_DATE	End Date of the payroll period.
SECURITY_GROUP_ID
PROCESSING_DATE	Date the payroll was processed
OBJECT_VERSION_NUMBER	System generated version of row. Increments by one with each update
BPR_ATTRIBUTE_CATEGORY

Human Resources - PER_BF_BALANCE_TYPES	Types of balances that can be held
Column Name	Descritpion
BALANCE_TYPE_ID	System Generated Unique Identifer for this row
DATE_TO	Date the type is valid until
OBJECT_VERSION_NUMBER	System generated version of row
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
INPUT_VALUE_ID	FK to pay_input_values_f
BUSINESS_GROUP_ID	FK to HR_ALL_ORGANIZATION_UNITS
DISPLAYED_NAME	Balance type name that is displayed for users to see.
INTERNAL_NAME	Internal name of the balance
UOM	Unit of Measure for the balance
SECURITY_GROUP_ID
CURRENCY	Currency of the balance, if the UOM is money.
CATEGORY	Allows groupings of balance types for reporting purposes
DATE_FROM	Date the type is valid from

Human Resources - PER_CA_EE_REPORT_LINES
Column Name	Descritpion
REQUEST_ID
SEGMENT7
SEGMENT8
SEGMENT9
SEGMENT10
SEGMENT11
SEGMENT12
SEGMENT13
SEGMENT14
SEGMENT15
SEGMENT16
LINE_NUMBER
SEGMENT17
SEGMENT18
SEGMENT19
SEGMENT20
SEGMENT21
SEGMENT22
SEGMENT23
SEGMENT24
SEGMENT25
SEGMENT26
CONTEXT
SEGMENT27
SEGMENT28
SEGMENT29
SEGMENT30
SEGMENT1
SEGMENT2
SEGMENT3
SEGMENT4
SEGMENT5
SEGMENT6

Human Resources - PER_CPN_DATA_UPGRADE	Used to log errors / warnings during the conversion of competences to a key flex structure.
Column Name	Descritpion
LOG_TYPE	log type
LOG_INFO	log information

Human Resources - PER_GEN_HIERARCHY
Column Name	Descritpion
BUSINESS_GROUP_ID
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
NAME
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
TYPE
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
ATTRIBUTE21
ATTRIBUTE22
ATTRIBUTE23
ATTRIBUTE24
ATTRIBUTE25
REQUEST_ID
ATTRIBUTE26
ATTRIBUTE27
ATTRIBUTE28
ATTRIBUTE29
ATTRIBUTE30
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
LAST_UPDATE_DATE
INFORMATION1	Developer Descriptive Flexfield
LAST_UPDATED_BY
HIERARCHY_ID
LAST_UPDATE_LOGIN
CREATED_BY
INFORMATION2	Developer Descriptive Flexfield
INFORMATION3	Developer Descriptive Flexfield
INFORMATION4	Developer Descriptive Flexfield
INFORMATION5	Developer Descriptive Flexfield
INFORMATION6	Developer Descriptive Flexfield
INFORMATION7	Developer Descriptive Flexfield
CREATION_DATE
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
OBJECT_VERSION_NUMBER
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
ATTRIBUTE_CATEGORY
INFORMATION30	Developer Descriptive Flexfield
INFORMATION_CATEGORY	Developer Descriptive Flexfield
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5

Human Resources - PER_GEN_HIERARCHY_NODES
Column Name	Descritpion
BUSINESS_GROUP_ID
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ENTITY_ID
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
ATTRIBUTE21
ATTRIBUTE22
HIERARCHY_VERSION_ID
ATTRIBUTE23
ATTRIBUTE24
ATTRIBUTE25
ATTRIBUTE26
ATTRIBUTE27
ATTRIBUTE28
ATTRIBUTE29
ATTRIBUTE30
NODE_TYPE
PARENT_HIERARCHY_NODE_ID
SEQ
REQUEST_ID
PROGRAM_APPLICATION_ID
INFORMATION1	Developer Descriptive Flexfield
PROGRAM_ID
HIERARCHY_NODE_ID
PROGRAM_UPDATE_DATE
LAST_UPDATE_DATE
INFORMATION2	Developer Descriptive Flexfield
INFORMATION3	Developer Descriptive Flexfield
INFORMATION4	Developer Descriptive Flexfield
INFORMATION5	Developer Descriptive Flexfield
INFORMATION6	Developer Descriptive Flexfield
INFORMATION7	Developer Descriptive Flexfield
LAST_UPDATED_BY
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
LAST_UPDATE_LOGIN
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
CREATED_BY
INFORMATION30	Developer Descriptive Flexfield
INFORMATION_CATEGORY	Developer Descriptive Flexfield
CREATION_DATE
OBJECT_VERSION_NUMBER
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2

Human Resources - PER_GEN_HIERARCHY_VERSIONS
Column Name	Descritpion
BUSINESS_GROUP_ID
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
VERSION_NUMBER
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
HIERARCHY_ID
ATTRIBUTE21
ATTRIBUTE22
ATTRIBUTE23
ATTRIBUTE24
ATTRIBUTE25
ATTRIBUTE26
ATTRIBUTE27
ATTRIBUTE28
ATTRIBUTE29
ATTRIBUTE30
DATE_FROM
DATE_TO
STATUS
VALIDATE_FLAG
INFORMATION1	Developer Descriptive Flexfield
REQUEST_ID
HIERARCHY_VERSION_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
INFORMATION2	Developer Descriptive Flexfield
INFORMATION3	Developer Descriptive Flexfield
INFORMATION4	Developer Descriptive Flexfield
INFORMATION5	Developer Descriptive Flexfield
INFORMATION6	Developer Descriptive Flexfield
INFORMATION7	Developer Descriptive Flexfield
PROGRAM_UPDATE_DATE
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
LAST_UPDATE_DATE
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
LAST_UPDATED_BY
INFORMATION30	Developer Descriptive Flexfield
INFORMATION_CATEGORY	Developer Descriptive Flexfield
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
ATTRIBUTE_CATEGORY

Human Resources - PER_ELECTIONS	Holds election related information.
Column Name	Descritpion
BUSINESS_GROUP_ID	Business Group Id
ATTRIBUTE12	Attribute12
ATTRIBUTE13	Attribute13
ATTRIBUTE14	Attribute14
ATTRIBUTE15	Attribute15
ATTRIBUTE16	Attribute16
ATTRIBUTE17	Attribute17
ATTRIBUTE18	Attribute18
ATTRIBUTE19	Attribute19
ATTRIBUTE20	Attribute20
ATTRIBUTE21	Attribute21
ELECTION_DATE	Election Date
ATTRIBUTE22	Attribute22
ATTRIBUTE23	Attribute23
ATTRIBUTE24	Attribute24
ATTRIBUTE25	Attribute25
ATTRIBUTE26	Attribute26
ATTRIBUTE27	Attribute27
DESCRIPTION	Description
ATTRIBUTE28	Attribute28
ATTRIBUTE29	Attribute29
ATTRIBUTE30	Attribute30
ELECTION_INFO_CATEGORY	Election Info Category
REP_BODY_ID	Rep Body Id
ELECTION_INFORMATION1	Election Information 1
ELECTION_INFORMATION2	Election Information 2
ELECTION_INFORMATION3	Election Information 3
ELECTION_INFORMATION4	Election Information 4
ELECTION_INFORMATION5	Election Information 5
ELECTION_INFORMATION6	Election Information 6
ELECTION_INFORMATION7	Election Information 7
ELECTION_INFORMATION8	Election Information 8
ELECTION_INFORMATION9	Election Information 9
ELECTION_INFORMATION10	Election Information 10
PREVIOUS_ELECTION_DATE	Previous Election Date
ELECTION_INFORMATION11	Election Information 11
ELECTION_INFORMATION12	Election Information 12
ELECTION_INFORMATION13	Election Information 13
ELECTION_INFORMATION14	Election Information 14
ELECTION_INFORMATION15	Election Information 15
ELECTION_INFORMATION16	Election Information 16
ELECTION_INFORMATION17	Election Information 17
ELECTION_INFORMATION18	Election Information 18
ELECTION_INFORMATION19	Election Information 19
ELECTION_INFORMATION20	Election Information 20
NEXT_ELECTION_DATE	Next Election Date
ELECTION_INFORMATION21	Election Information 21
ELECTION_INFORMATION22	Election Information 22
ELECTION_INFORMATION23	Election Information 23
ELECTION_INFORMATION24	Election Information 24
ELECTION_INFORMATION25	Election Information 25
ELECTION_INFORMATION26	Election Information 26
ELECTION_INFORMATION27	Election Information 27
ELECTION_INFORMATION28	Election Information 28
ELECTION_INFORMATION29	Election Information 29
ELECTION_INFORMATION30	Election Information 30
RESULT_PUBLISH_DATE	Result Publish Date
LAST_UPDATE_DATE	Last Update Date
LAST_UPDATED_BY	Lst Update By
LAST_UPDATE_LOGIN	Last Update Login
CREATED_BY	Created By
CREATION_DATE	Creation Date
OBJECT_VERSION_NUMBER	Object Version Number
ATTRIBUTE_CATEGORY	Attribute Category
ATTRIBUTE1	Attribute1
ELECTION_ID	Election Id
ATTRIBUTE2	Attribute2
ATTRIBUTE3	Attribute3
ATTRIBUTE4	Attribute4
ATTRIBUTE5	Attribute5
ATTRIBUTE6	Attribute6
ATTRIBUTE7	Attribute7
ATTRIBUTE8	Attribute8
ATTRIBUTE9	Attribute9
ATTRIBUTE10	Attribute10
ATTRIBUTE11	Attribute11

Human Resources - PER_ELECTION_CANDIDATES	Holds information of Election candidates.
Column Name	Descritpion
BUSINESS_GROUP_ID	Foreign key to HR_ALL_ORGANIZATION_UNITS
ATTRIBUTE14	Attribute 14
ATTRIBUTE15	Attribute 15
ATTRIBUTE16	Attribute 16
ATTRIBUTE17	Attribute 17
ATTRIBUTE18	Attribute 18
ATTRIBUTE19	Attribute 19
ATTRIBUTE20	Attribute 20
ATTRIBUTE21	Attribute 21
ATTRIBUTE22	Attribute 22
ATTRIBUTE23	Attribute 23
ELECTION_ID	Election id
ATTRIBUTE24	Attribute 24
ATTRIBUTE25	Attribute 25
PERSON_ID	Foreign Key to PER_ALL_PEOPLE_F
ATTRIBUTE26	Attribute 26
ATTRIBUTE27	Attribute 27
ATTRIBUTE28	Attribute 28
ATTRIBUTE29	Attribute 29
ATTRIBUTE30	Attribute 30
CANDIDATE_INFO_CATEGORY	Candidate Info Category
CANDIDATE_INFORMATION1	Candidate Information 1
CANDIDATE_INFORMATION2	Candidate Information 2
CANDIDATE_INFORMATION3	Candidate Information 3
CANDIDATE_INFORMATION4	Candidate Information 4
RANK	Rank in the election
CANDIDATE_INFORMATION5	Candidate Information 5
CANDIDATE_INFORMATION6	Candidate Information 6
CANDIDATE_INFORMATION7	Candidate Information 7
CANDIDATE_INFORMATION8	Candidate Information 8
CANDIDATE_INFORMATION9	Candidate Information 9
CANDIDATE_INFORMATION10	Candidate Information 10
CANDIDATE_INFORMATION11	Candidate Information 11
CANDIDATE_INFORMATION12	Candidate Information 12
CANDIDATE_INFORMATION13	Candidate Information 13
CANDIDATE_INFORMATION14	Candidate Information 14
ROLE_ID	Foreign Key to PER_ROLES
CANDIDATE_INFORMATION15	Candidate Information 15
CANDIDATE_INFORMATION16	Candidate Information 16
CANDIDATE_INFORMATION17	Candidate Information 17
CANDIDATE_INFORMATION18	Candidate Information 18
CANDIDATE_INFORMATION19	Candidate Information 19
CANDIDATE_INFORMATION20	Candidate Information 20
CANDIDATE_INFORMATION21	Candidate Information 21
CANDIDATE_INFORMATION22	Candidate Information 22
CANDIDATE_INFORMATION23	Candidate Information 23
CANDIDATE_INFORMATION24	Candidate Information 24
ATTRIBUTE_CATEGORY	Attribute Category
CANDIDATE_INFORMATION25	Candidate Information 25
CANDIDATE_INFORMATION26	Candidate Information 26
CANDIDATE_INFORMATION27	Candidate Information 27
CANDIDATE_INFORMATION28	Candidate Information 28
CANDIDATE_INFORMATION29	Candidate Information 29
CANDIDATE_INFORMATION30	Candidate Information 30
LAST_UPDATE_DATE	Last Update Date
LAST_UPDATED_BY	Last Update By
LAST_UPDATE_LOGIN	Last Update Login
CREATED_BY	Created By
ATTRIBUTE1	Attribute 1
CREATION_DATE	Creation Date
OBJECT_VERSION_NUMBER	Object Version Nubmer
ATTRIBUTE2	Attribute 2
ATTRIBUTE3	Attribute 3
ELECTION_CANDIDATE_ID	System generated primary key
ATTRIBUTE4	Attribute 4
ATTRIBUTE5	Attribute 5
ATTRIBUTE6	Attribute 6
ATTRIBUTE7	Attribute 7
ATTRIBUTE8	Attribute 8
ATTRIBUTE9	Attribute 9
ATTRIBUTE10	Attribute 10
ATTRIBUTE11	Attribute 11
ATTRIBUTE12	Attribute 12
ATTRIBUTE13	Attribute 13

Human Resources - PER_ELECTION_CONSTITUENCYS	This table holds information related to constituencies participating in the election.
Column Name	Descritpion
ELECTION_ID	Election ID
ATTRIBUTE16	Attribute 16
ATTRIBUTE17	Attribute 17
ATTRIBUTE18	Attribute 18
ATTRIBUTE19	Attribute 19
ATTRIBUTE20	Attribute 20
ATTRIBUTE21	Attribute 21
ATTRIBUTE22	Attribute 22
ATTRIBUTE23	Attribute 23
ATTRIBUTE24	Attribute 24
ATTRIBUTE25	Attribute 25
BUSINESS_GROUP_ID	Business Group ID
ATTRIBUTE26	Attribute 26
ATTRIBUTE27	Attribute 27
ATTRIBUTE28	Attribute 28
ATTRIBUTE29	Attribute 29
ATTRIBUTE30	Attribute 30
LAST_UPDATE_DATE	Last Update Date
LAST_UPDATED_BY	Last Update By
LAST_UPDATE_LOGIN	Last Update Login
CREATED_BY	Created By
CREATION_DATE	Creation Date
CONSTITUENCY_ID	Constituency ID
OBJECT_VERSION_NUMBER	Object Version Number
ATTRIBUTE_CATEGORY	Attribute Category
ATTRIBUTE1	Attribute 1
ATTRIBUTE2	Attribute 2
ATTRIBUTE3	Attribute 3
ATTRIBUTE4	Attribute 4
ATTRIBUTE5	Attribute 5
ELECTION_CONSTITUENCY_ID	Election Constituency ID
ATTRIBUTE6	Attribute 6
ATTRIBUTE7	Attribute 7
ATTRIBUTE8	Attribute 8
ATTRIBUTE9	Attribute 9
ATTRIBUTE10	Attribute 10
ATTRIBUTE11	Attribute 11
ATTRIBUTE12	Attribute 12
ATTRIBUTE13	Attribute 13
ATTRIBUTE14	Attribute 14
ATTRIBUTE15	Attribute 15

Human Resources - PER_ASSIGNMENT_BUDGET_VALU_EFC	This is a copy of the PER_ASSIGNMENT_BUDGET_VALUES_F table which is populated by the EFC (Euro as Functional Currency) process.
Column Name	Descritpion
ASSIGNMENT_BUDGET_VALUE_ID	Refer to column comment on base table.
EFFECTIVE_START_DATE	Refer to column comment on base table.
EFFECTIVE_END_DATE	Refer to column comment on base table.
EFC_ACTION_ID	Foreign Key to HR_EFC_ACTIONS.
VALUE	Refer to column comment on base table.
EFC_BG_CURRENCY	Business Group Currency for EFC conversion.

Human Resources - PER_BUDGET_VALUES_EFC	This is a copy of the PER_BUDGET_VALUES table which is populated by the EFC (Euro as Functional Currency) process.
Column Name	Descritpion
BUDGET_VALUE_ID	Refer to column comment on base table.
EFC_ACTION_ID	Foreign Key to HR_EFC_ACTIONS.
VALUE	Refer to column comment on base table.
BUDGET_CURRENCY	Refer to column comment on base table.
EFC_BG_CURRENCY	Business Group Currency for EFC conversion.

Human Resources - PER_BF_PAYMENT_DETAILS_EFC
Column Name	Descritpion
PAYMENT_DETAIL_ID
EFC_ACTION_ID
AMOUNT
CURRENCY_CODE
SECURITY_GROUP_ID

Human Resources - PER_BF_BALANCE_TYPES_EFC
Column Name	Descritpion
BALANCE_TYPE_ID
EFC_ACTION_ID
CURRENCY
SECURITY_GROUP_ID

Human Resources - PER_BF_BALANCE_AMOUNTS_EFC
Column Name	Descritpion
BALANCE_AMOUNT_ID
INPUT_CURRENCY_CODE
EFC_ACTION_ID
YTD_AMOUNT
FYTD_AMOUNT
PTD_AMOUNT
MTD_AMOUNT
SECURITY_GROUP_ID
QTD_AMOUNT
RUN_AMOUNT
CURRENCY

Human Resources - PER_ASSIGNMENT_EXTRA_INFO_EFC	This is a copy of the PER_ASSIGNMENT_EXTRA_INFO table which is populated by the EFC (Euro as Functional Currency) process.
Column Name	Descritpion
ASSIGNMENT_EXTRA_INFO_ID	Refer to column comment on base table.
AEI_INFORMATION13	Refer to column comment on base table.
EFC_ACTION_ID	Foreign Key to HR_EFC_ACTIONS.
INPUT_CURRENCY_CODE	Refer to column comment on base table.
AEI_INFORMATION7	Refer to column comment on base table.
AEI_INFORMATION6	Refer to column comment on base table.

Human Resources - PER_ABSENCE_ATTENDANCES_EFC	This is a copy of the PER_ABSENCE_ATTENDANCES table which is populated by the EFC (Euro as Functional Currency) process.
Column Name	Descritpion
ABSENCE_ATTENDANCE_ID	Refer to column comment on base table.
EFC_ACTION_ID	Foreign Key to HR_EFC_ACTIONS.Foreign Key to HR_EFC_ACTIONS.
ABS_INFORMATION7	Refer to column comment on base table.
ABS_INFORMATION8	Refer to column comment on base table.
ABS_INFORMATION9	Refer to column comment on base table.
ABS_INFORMATION11	Refer to column comment on base table.
ABS_INFORMATION13	Refer to column comment on base table.
ABS_INFORMATION15	Refer to column comment on base table.

Human Resources - PER_CAGR_APIS
Column Name	Descritpion
CAGR_API_ID
API_NAME
CATEGORY_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER

Human Resources - PER_CAGR_API_PARAMETERS
Column Name	Descritpion
CAGR_API_PARAM_ID
OBJECT_VERSION_NUMBER
CAGR_API_ID
DISPLAY_NAME
PARAMETER_NAME
COLUMN_TYPE
COLUMN_SIZE
UOM_PARAMETER
UOM_LOOKUP
DEFAULT_UOM	Lookup Type used to define values for the Entitlement Item based on this parameter
HIDDEN
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE

Human Resources - PER_CAGR_ENTITLEMENT_LINES_F
Column Name	Descritpion
CAGR_ENTITLEMENT_LINE_ID
EFFECTIVE_END_DATE
GRADE_SPINE_ID
PARENT_SPINE_ID
STEP_ID
FROM_STEP_ID
TO_STEP_ID
STATUS
OIPL_ID	Foreign Key to BEN_OIPL
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
CAGR_ENTITLEMENT_ID
ELIGY_PRFL_ID
MANDATORY
VALUE
RANGE_FROM
RANGE_TO
EFFECTIVE_START_DATE

Human Resources - PER_CAGR_ENTITLEMENTS
Column Name	Descritpion
CAGR_ENTITLEMENT_ID
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
CAGR_ENTITLEMENT_ITEM_ID
COLLECTIVE_AGREEMENT_ID
START_DATE
END_DATE
STATUS
FORMULA_CRITERIA
FORMULA_ID
UNITS_OF_MEASURE
MESSAGE_LEVEL
LAST_UPDATE_DATE

Human Resources - PER_CAGR_ENTITLEMENT_ITEMS_TL
Column Name	Descritpion
ITEM_NAME
LANGUAGE
SOURCE_LANG
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CAGR_ENTITLEMENT_ITEM_ID
CREATION_DATE

Human Resources - PER_CAGR_API_PARAMETERS_TL
Column Name	Descritpion
DISPLAY_NAME
LANGUAGE
SOURCE_LANG
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
CAGR_API_PARAM_ID

Human Resources - PER_CAGR_LOG
Column Name	Descritpion
LOG_ID
CAGR_REQUEST_ID
TEXT
PRIORITY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE

Human Resources - PER_CAGR_REQUESTS
Column Name	Descritpion
CAGR_REQUEST_ID	System generated primary key from PER_CAGR_REQUESTS_S
OPERATION_MODE	Mode of Operation for Collective Agreement Request.
BUSINESS_GROUP_ID	Business Group
ASSIGNMENT_ID	FK to PER_ALL_ASSIGNMENTS_F.
ASSIGNMENT_SET_ID	FK to HR_ASSIGNMENT_SETS.
COLLECTIVE_AGREEMENT_ID	FK to PER_COLLECTIVE_AGREEMENTS.
COLLECTIVE_AGREEMENT_SET_ID	FK to PER_COLLECTIVE_AGREEMENT_SETS
PROCESS_DATE	Date the Collective Agreement Request was executed.
PAYROLL_ID	FK to PAY_PAYROLLS_F.
CAGR_ENTITLEMENT_ITEM_ID	FK to PER_CAGR_ENTITLEMENT_ITEMS.
PERSON_ID	FK to PER_ALL_PEOPLE_F.
COMMIT_FLAG	Indicates if commit is allowed for the request.
DENORMALISE_FLAG	Indicates if denormalisation is allowed for the request.
PARENT_REQUEST_ID

Human Resources - PER_CAGR_APIS_TL
Column Name	Descritpion
API_NAME
LANGUAGE
SOURCE_LANG
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
CAGR_API_ID

Human Resources - PER_CAGR_ENTITLEMENT_RESULTS
Column Name	Descritpion
CATEGORY_NAME
CAGR_ENTITLEMENT_ID
CAGR_ENTITLEMENT_LINE_ID
ASSIGNMENT_ID
VALUE
UNITS_OF_MEASURE
RANGE_FROM
RANGE_TO
GRADE_SPINE_ID
PARENT_SPINE_ID
CAGR_REQUEST_ID
STEP_ID
BUSINESS_GROUP_ID	Business Group of the entitlement item parent
FROM_STEP_ID
TO_STEP_ID
BENEFICIAL_FLAG
LEGISLATION_CODE	Legislation Code of the parent Entitlement Item.
OIPL_ID
ELIGY_PRFL_ID
START_DATE
FORMULA_ID
CHOSEN_FLAG	Idicates user has selected this record to be denormalized.
COLUMN_TYPE
COLUMN_SIZE
RETAINED_ENT_RESULT_ID	FK to per_cagr_retained_rights.
FLEX_VALUE_SET_ID
MULTIPLE_ENTRIES_ALLOWED_FLAG
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
END_DATE
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
COLLECTIVE_AGREEMENT_ID
CAGR_ENTITLEMENT_RESULT_ID
CAGR_ENTITLEMENT_ITEM_ID
ELEMENT_TYPE_ID
INPUT_VALUE_ID
CAGR_API_ID
CAGR_API_PARAM_ID

Human Resources - PER_CAGR_RETAINED_RIGHTS
Column Name	Descritpion
CAGR_RETAINED_RIGHT_ID
CAGR_API_PARAM_ID
CAGR_ENTITLEMENT_LINE_ID
FREEZE_FLAG
VALUE
RANGE_FROM
RANGE_TO
UNITS_OF_MEASURE
OIPL_ID
ELIGY_PRFL_ID
CAGR_ENTITLEMENT_RESULT_ID
START_DATE
END_DATE
GRADE_SPINE_ID
ASSIGNMENT_ID
PARENT_SPINE_ID
STEP_ID
FROM_STEP_ID
TO_STEP_ID
FORMULA_ID
COLUMN_TYPE
CAGR_ENTITLEMENT_ITEM_ID
COLUMN_SIZE
BUSINESS_GROUP_ID
FLEX_VALUE_SET_ID
MULTIPLE_ENTRIES_ALLOWED_FLAG
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
COLLECTIVE_AGREEMENT_ID
OBJECT_VERSION_NUMBER
CAGR_ENTITLEMENT_ID
CATEGORY_NAME
ELEMENT_TYPE_ID
INPUT_VALUE_ID
CAGR_API_ID

Human Resources - PER_CAGR_ENTITLEMENT_ITEMS
Column Name	Descritpion
OBJECT_VERSION_NUMBER
BUSINESS_GROUP_ID
ITEM_NAME
ELEMENT_TYPE_ID
INPUT_VALUE_ID
COLUMN_TYPE
COLUMN_SIZE
LEGISLATION_CODE
BENEFICIAL_RULE
CAGR_API_ID
CAGR_API_PARAM_ID
CATEGORY_NAME	Category of the Entitlement Item.
UOM	Unit of measure for the entitlement item.
CAGR_ENTITLEMENT_ITEM_ID
BENEFICIAL_FORMULA_ID
FLEX_VALUE_SET_ID
BENEFICIAL_RULE_VALUE_SET_ID	FK to FND value sets.
MULTIPLE_ENTRIES_ALLOWED_FLAG	Indicates whether an entitlement item can have multiple normal entries for this element at any one time.
OPT_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE

Human Resources - IRC_JOB_BASKET_ITEMS	The jobs that an applicant has placed in their job basket
Column Name	Descritpion
RECRUITMENT_ACTIVITY_ID	Foreign Key to PER_RECRUITMENT_ACTIVITIES
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.
JOB_BASKET_ITEM_ID
PERSON_ID
PARTY_ID	Foreign key to HZ_PARTIES

Human Resources - IRC_DEFAULT_POSTINGS	Stores a library of postings, each mapped to one of a position, a job or an organization.
Column Name	Descritpion
POSITION_ID	The position the posting is for.
ATTRIBUTE1	Descriptive flexfield column.
ATTRIBUTE2	Descriptive flexfield column.
ATTRIBUTE3	Descriptive flexfield column.
ATTRIBUTE4	Descriptive flexfield column.
JOB_ID	The job the posting is for.
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.
ORGANIZATION_ID	The organization the posting is for.
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.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining 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.
OBJECT_VERSION_NUMBER	The position which the default posting is for
DEFAULT_POSTING_ID	Primary Key.

Human Resources - IRC_REFERENCES	Not currently used.
Column Name	Descritpion
PARTY_RELATIONSHIP_ID	The party relationship for this referee.
REFERENCE_STATUS	Status of the reference - lookup
REFERENCE_STATUS_DATE_CHANGED	Date of last status change
COMMENTS	Comments received from the referee.
REFERENCE_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.
CREATION_DATE	Standard WHO column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.

Human Resources - IRC_VAC_ALLOWED_STATUS_TYPES	Stores the recruiting statuses that are valid for a particular vacancy, and the sequence that it should be used in.
Column Name	Descritpion
ASSIGNMENT_STATUS_TYPE_ID	The allowed assignment status.
ACTIVE_FLAG	Y or N. Indicates whether this is still an active status for this vacancy.
DISPLAY_SEQUENCE	Number indicating the position of this recruiting status amongst the other recruiting statuses that are valid for this vacancy.
LAST_UPDATE_DATE	Standard WHO column.
LAST_UPDATED_BY	Standard WHO column.
LAST_UPDATE_LOGIN	Standard WHO column.
VACANCY_ID	The vacancy that this list is for.
CREATED_BY	Standard WHO column.
CREATION_DATE	Standard WHO column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.

Human Resources - IRC_NOTIFICATION_PREFERENCES	Stores an applicants preferences to do with being contacted by the customer.
Column Name	Descritpion
NOTIFICATION_PREFERENCE_ID
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
AGENCY_ID
MATCHING_JOBS	Y or N. Depending on whether the person would liek to be notified of jobs that match their criteria and / or skill set.
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.
MATCHING_JOB_FREQ	How often the user wants to receive job matching notifications.
ATTRIBUTE11	Descriptive flexfield column.
ATTRIBUTE12	Descriptive flexfield column.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRBIUTE16	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.
RECEIVE_INFO_MAIL	Y or N. Depending upon whether the person would like to receive informational notifications.
ATTRIBUTE29	Descriptive flexfield column.
ATTRIBUTE30	Descriptive flexfield column.
ALLOW_ACCESS	Phase 1 only. Specifies if the recruiter can contact the applicant.
ADDRESS_ID	The address that the person wants to use to be contacted at (employees only).
ATTEMPT_ID	Most recent registration assessment attempt of the candidate.
ATTRBIUTE5	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.
PERSON_ID	Notification Pref for this person
PARTY_ID	The person who's preferences thes

Human Resources - IRC_DEFAULT_POSTINGS_TL	Contains the tranlated versions of the default postings.
Column Name	Descritpion
LANGUAGE	The language that the default posting is in.
SOURCE_LANGUAGE	The source language the default posting was first copied from.
ORG_NAME	Organization name.
ORG_DESCRIPTION	A written desciption introducing a Department or Division of the Customer to the Postion Seeker.
JOB_TITLE	The discretionary Job / Position Title that a Manager would have the facility to enter.
BRIEF_DESCRIPTION	A brief statement outlining the duties, purpose and conditions for the Job / Position.
DETAILED_DESCRIPTION	A detailed statement of the duties, purposes and conditions for the Job / Position.
JOB_REQUIREMENTS	A summary of the required or desired competencies, education and / or qualificaitons for the Job / Position.
DEFAULT_POSTING_ID	Primary Key.
ADDITIONAL_DETAILS	Text detail that a Manager would have the facility to enter.
HOW_TO_APPLY	A summary that oulines to the Position Seeker how to apply or express an interest in a specific Job Posting.
IMAGE_URL	The URL of an image.
IMAGE_URL_ALT	The ALT test of the image.

Human Resources - IRC_DOCUMENTS	Stores documents that a registered user wishes to store on the database. Examples include resumes and cover letters.
Column Name	Descritpion
PERSON_ID	FK to PER_ALL_PEOPLE_F.
PARTY_ID	FK to HZ_PARTIES
ASSIGNMENT_ID	FK to PER_ALL_ASSIGNMENTS_F.
BINARY_DOC	Binary representation of the document.
CHARACTER_DOC	Character representation of the document.
FILE_NAME	Name of file uploaded.
FILE_FORMAT	BINARY or TEXT indicator for the format of the document
MIME_TYPE	MIME type of the document
DESCRIPTION	Description of the document.
TYPE	Type of document. Defined by Lookup - IRC_DOCUMENT_TYPE
PARSED_XML	Parsed XML version of the document
LAST_UPDATE_DATE	Standard WHO column.
DOCUMENT_ID	Primary Key
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.

Human Resources - IRC_SEARCH_CRITERIA	Contains job matching preferences and saved advanced search criteria
Column Name	Descritpion
OBJECT_TYPE	Type of the parent object - PARTY or VACANCY
GEOMETRY
WORK_AT_HOME	Lookup to determine how desirable working at home is.
MIN_QUAL_LEVEL	Minimum qualification level required by a vacancy.
MAX_QUAL_LEVEL	Maximum qualification level required by a vacancy.
USE_FOR_MATCHING	Indicates whether a saved search is to be used for job matching purposes.
DESCRIPTION	A description of the saved search.
DATE_POSTED	Days since job got posted.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
ATTRIBUTE1	Descriptive flexfield column.
ATTRIBUTE2	Descriptive flexfield column.
ATTRIBUTE3	Descriptive flexfield column.
ATTRIBUTE4	Descriptive flexfield column.
SEARCH_NAME	If saved search criteria, the name of the search
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.
SEARCH_CRITERIA_ID	Primary Key
SEARCH_TYPE	A for Advanced, B for Basic
PROFESSIONAL_AREA	Professional area that the user wishes to work in, or the vacancy is in.
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.
LOCATION	Location a person is interested in
ATTRIBUTE25	Descriptive flexfield column.
ATTRIBUTE26	Descriptive flexfield column.
ATTRIBUTE27	Descriptive flexfield column.
ATTRIBUTE28	Descriptive flexfield column.
ATTRIBUTE29	Descriptive flexfield column.
ATTRIBUTE30	Descriptive flexfield column.
ISC_INFORMATION_CATEGORY	Developer Descriptive flexfield structure defining column.
ISC_INFORMATION1	Developer Descriptive flexfield column.
ISC_INFORMATION2	Developer Descriptive flexfield column.
ISC_INFORMATION3
ISC_INFORMATION4	Developer Descriptive flexfield column.
DISTANCE_TO_LOCATION	The distance the user is willing to travel to work. Based upon lookup value.
ISC_INFORMATION5	Developer Descriptive flexfield column.
ISC_INFORMATION6	Developer Descriptive flexfield column.
ISC_INFORMATION7	Developer Descriptive flexfield column.
ISC_INFORMATION8	Developer Descriptive flexfield column.
ISC_INFORMATION9	Developer Descriptive flexfield column.
ISC_INFORMATION10	Developer Descriptive flexfield column.
ISC_INFORMATION11	Developer Descriptive flexfield column.
ISC_INFORMATION12	Developer Descriptive flexfield column.
ISC_INFORMATION13	Developer Descriptive flexfield column.
ISC_INFORMATION14	Developer Descriptive flexfield column.
EMPLOYEE	Y or N. Is the person interested in employee positions. Is the job suitable for employees?
ISC_INFORMATION15	Developer Descriptive flexfield column.
ISC_INFORMATION16	Developer Descriptive flexfield column.
ISC_INFORMATION17	Developer Descriptive flexfield column.
ISC_INFORMATION18	Developer Descriptive flexfield column.
ISC_INFORMATION19	Developer Descriptive flexfield column.
ISC_INFORMATION20	Developer Descriptive flexfield column.
ISC_INFORMATION21	Developer Descriptive flexfield column.
ISC_INFORMATION22	Developer Descriptive flexfield column.
ISC_INFORMATION23	Developer Descriptive flexfield column.
ISC_INFORMATION24	Developer Descriptive flexfield column.
CONTRACTOR	Y or N. Is the person interested in a contractor position / is the vacancy suitable for contractors?
ISC_INFORMATION25	Developer Descriptive flexfield column.
ISC_INFORMATION26	Developer Descriptive flexfield column.
ISC_INFORMATION27	Developer Descriptive flexfield column.
ISC_INFORMATION28	Developer Descriptive flexfield column.
ISC_INFORMATION29	Developer Descriptive flexfield column.
ISC_INFORMATION30	Developer Descriptive flexfield column.
LAST_UPDATE_DATE	Standard WHO column.
LAST_UPDATED_BY	Standard WHO column.
LAST_UPDATE_LOGIN	Standard WHO column.
CREATED_BY	Standard WHO column.
EMPLOYMENT_CATEGORY	Style of employement (full time / part time) the user is interested in.
CREATION_DATE	Standard WHO column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
OBJECT_ID	ID of the parent object
KEYWORDS	List of keywords that the user wishes to be included as part of the search criteria.
TRAVEL_PERCENTAGE	Percentage of time a person is willing to spend travelling.
MIN_SALARY	The minimum amount a user is willing to accept as a salary, or the minimum amount to be paid for a position.
MAX_SALARY	The maximum amount to be paid for a position.
SALARY_CURRENCY	The currency that the MAX_SALARY column is in.
SALARY_PERIOD	The period the salary applies for.
MATCH_COMPETENCE	Y or N. Depending on whether the user wishes to match jobs against the competencies they've entered.
MATCH_QUALIFICATION	Y or N. Depending on whether the user wishes to match jobs against their qualifications.
JOB_TITLE	Title of the job the user wishes to be included in their search.
DEPARTMENT	Department that the user wishes to search on.
GEOCODE_LOCATION
GEOCODE_COUNTRY
DERIVED_LOCATION
LOCATION_ID

Human Resources - IRC_POSTING_CONTENTS	Stores the actual content of a posting in a table where it can be reused.
Column Name	Descritpion
DISPLAY_MANAGER_INFO	Y or N. Depending on whether manager wishes to post contact information.
ATTRIBUTE1	Descriptive flexfield column.
ATTRIBUTE2	Descriptive flexfield column.
ATTRIBUTE3	Descriptive flexfield column.
ATTRIBUTE4	Descriptive flexfield column.
DISPLAY_RECRUITER_INFO	Y or N. Depending on whether recruiter wishes to post contact information.
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.
DATE_APPROVED	Date on which Posting Content is Approved.
ATTRIBUTE13	Descriptive flexfield column.
ATTRIBUTE14	Descriptive flexfield column.
ATTRBIUTE16	Descriptive flexfield column.
ATTRIBUTE15	Descriptive flexfield column.
ATTRIBUTE16	Descriptive flexfield column.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining 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.
IPC_INFORMATION_CATEGORY	Developer Descriptive flexfield structure defining column.
IPC_INFORMATION1	Developer Descriptive flexfield column.
IPC_INFORMATION2	Developer Descriptive flexfield column.
IPC_INFORMATION3	Developer Descriptive flexfield column.
IPC_INFORMATION4	Developer Descriptive flexfield column.
IPC_INFORMATION5	Developer Descriptive flexfield column.
IPC_INFORMATION6	Developer Descriptive flexfield column.
IPC_INFORMATION7	Developer Descriptive flexfield column.
IPC_INFORMATION8	Developer Descriptive flexfield column.
IPC_INFORMATION9	Developer Descriptive flexfield column.
IPC_INFORMATION10	Developer Descriptive flexfield column.
IPC_INFORMATION11	Developer Descriptive flexfield column.
IPC_INFORMATION12	Developer Descriptive flexfield column.
IPC_INFORMATION13	Developer Descriptive flexfield column.
IPC_INFORMATION14	Developer Descriptive flexfield column.
IPC_INFORMATION15	Developer Descriptive flexfield column.
IPC_INFORMATION16	Developer Descriptive flexfield column.
IPC_INFORMATION17	Developer Descriptive flexfield column.
IPC_INFORMATION18	Developer Descriptive flexfield column.
IPC_INFORMATION19	Developer Descriptive flexfield column.
IPC_INFORMATION20	Developer Descriptive flexfield column.
IPC_INFORMATION21	Developer Descriptive flexfield column.
IPC_INFORMATION22	Developer Descriptive flexfield column.
IPC_INFORMATION23	Developer Descriptive flexfield column.
IPC_INFORMATION24	Developer Descriptive flexfield column.
ATTRBIUTE5	Descriptive flexfield column.
IPC_INFORMATION25	Developer Descriptive flexfield column.
IPC_INFORMATION26	Developer Descriptive flexfield column.
IPC_INFORMATION27	Developer Descriptive flexfield column.
IPC_INFORMATION28	Developer Descriptive flexfield column.
IPC_INFORMATION29	Developer Descriptive flexfield column.
IPC_INFORMATION30	Developer Descriptive flexfield column.
LAST_UPDATE_DATE	Standard WHO column.
LAST_UPDATED_BY	Standard WHO column.
LAST_UPDATE_LOGIN	Standard WHO column.
CREATED_BY	Standard WHO column.
CREATION_DATE	Standard WHO column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
RECRUITER_FULL_NAME	Full name of the Recruiter of the vacancy to which this posting is attached
RECRUITER_EMAIL	Email of the recruiter for the vacancy to which this posting is attached.
RECRUITER_WORK_TELEPHONE	Work telephone of the recruiter of the vacancy
MANAGER_FULL_NAME	Full name of the manager of the vacancy to which this posting is attached
MANAGER_EMAIL	Email of the manager for the vacancy.
MANAGER_WORK_TELEPHONE	Work telephone of the manager of the vacancy.
POSTING_CONTENT_ID	Primary key column

Human Resources - IRC_ASSIGNMENT_STATUSES	Stored assignment statuses for a particular applicant assignment.
Column Name	Descritpion
ASSIGNMENT_ID	The assignment that these statuses are for.
ASSIGNMENT_STATUS_TYPE_ID	The assignment status.
STATUS_CHANGE_DATE	The date and time of the status change
STATUS_CHANGE_REASON	Description of why the status was updated.
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_ID	Primary Key.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.

Human Resources - IRC_POSTING_CONTENTS_TL	Stores the translation content of the advert.
Column Name	Descritpion
LANGUAGE	One row for each installed language.
SOURCE_LANGUAGE	Source language.
NAME	The name of the Job Posting Content.
ORG_NAME	Organization name.
ORG_DESCRIPTION	A written description introducing a Department or Division of the Customer to the Position Seeker.
JOB_TITLE	The discretionary Job / Position Title that a manager has the facility to enter.
BRIEF_DESCRIPTION	A brief statement outlining the duties, purpose and conditions for the Job / Position.
DETAILED_DESCRIPTION	A detailed statement of the duties, purposes and conditions of the Job / Position.
POSTING_CONTENT_ID	Primary Key Column.
JOB_REQUIREMENTS	A summary of the required or desired competencies, education and / or qualifications for the Job / Position.
ADDITIONAL_DETAILS	Text detail that a Manager would has the facility to enter.
HOW_TO_APPLY	A summary that outlines to the Position Seeker how to apply or express interest in a specific Job Posting.
BENEFIT_INFO	Information about the benefits that a person will receive.
IMAGE_URL	The URL of an image.
IMAGE_URL_ALT	The ALT text of the image.

Human Resources - IRC_VARIABLE_COMP_ELEMENTS	Variable compensation element data. This data is utilized for display purposes only.
Column Name	Descritpion
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
VACANCY_ID	The vacancy which the variable compensation element is for
VARIABLE_COMP_LOOKUP	Reference to lookup code detailing a variable compensation element for the vacancy

Human Resources - IRC_REC_TEAM_MEMBERS	Stores the list of people who are working on a particular vacancy
Column Name	Descritpion
JOB_ID	Not currently used
START_DATE	The date a person becomes part of a recruiting team
END_DATE	The date a person is no longer part of a recruiting team
UPDATE_ALLOWED	Specifies if the person can update the vacancy
DELETE_ALLOWED	Specifies if the person can delete the vacancy
LAST_UPDATE_DATE	Standard WHO column
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
REC_TEAM_MEMBER_ID
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
PERSON_ID	The person who is a member of the team
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
PARTY_ID	The person who is a memeber of the team
VACANCY_ID	The vacancy which the team is for

Human Resources - IRC_VACANCY_CONSIDERATIONS	This table holds the consideration of a Manager or a Recruiter a candidate in the pool and their Vacancy
Column Name	Descritpion
PARTY_ID	this stores the party_id
VACANCY_ID	Foreign Key to per_all_vacancies
CONSIDERATION_STATUS	Whether party is being considered for the Vacancy
LAST_UPDATE_DATE	Standard WHO column
VACANCY_CONSIDERATION_ID
LAST_UPDATED_BY	Standard WHO column
LAST_UPDATE_LOGIN	Standard WHO column
CREATED_BY	Standard WHO column
CREATION_DATE	Standard WHO column
PERSON_ID
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.

Human Resources - PER_CAGR_COPY_LOG
Column Name	Descritpion
BUSINESS_GROUP_ID	Business group of copied object
BUSINESS_GROUP_NAME	Name of Business Group
COPIED_ITEM_NAME	Copied Item Name
COPIED_ITEM_TYPE_ID	Copied Item Type Id, allows order of report to work
COPIED_ITEM_TYPE	Copied Item Type
ACTION_ID	ID number to sort action type, copied, existing, failed
ACTION_TYPE	Name of Action
ERROR_MESSAGE	Error message if fails in called code
CAGR_COPY_LOG_ID	Primary key of table
CAGR_NAME	Collective Agreement Name
CAGR_ENTITLEMENT_NAME	CAGR Entitlement Item Name
LAST_UPDATE_BY	Standard Who Column
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CREATED_BY	ID of creator
CREATION_DATE	Date of creation
ELIGIBILITY_NAME	Name of eligibility profile item is used in.

Human Resources - PER_CONTACT_EXTRA_INFO_F	Extra information for a contact relationship.
Column Name	Descritpion
EFFECTIVE_START_DATE	Effective start date.
CEI_INFORMATION15	Developer descriptive flexfield column.
CEI_INFORMATION16	Developer descriptive flexfield column.
CEI_INFORMATION17	Developer descriptive flexfield column.
CEI_INFORMATION18	Developer descriptive flexfield column.
CEI_INFORMATION19	Developer descriptive flexfield column.
CEI_INFORMATION20	Developer descriptive flexfield column.
CEI_INFORMATION21	Developer descriptive flexfield column.
CEI_INFORMATION22	Developer descriptive flexfield column.
CEI_INFORMATION23	Developer descriptive flexfield column.
CEI_INFORMATION24	Developer descriptive flexfield column.
EFFECTIVE_END_DATE	Effective end date.
CEI_INFORMATION25	Developer descriptive flexfield column.
CEI_INFORMATION26	Developer descriptive flexfield column.
CEI_INFORMATION27	Developer descriptive flexfield column.
CEI_INFORMATION28	Developer descriptive flexfield column.
CEI_INFORMATION29	Developer descriptive flexfield column.
CEI_INFORMATION30	Developer descriptive flexfield column.
CEI_ATTRIBUTE_CATEGORY	Descriptive flexfield column.
CEI_ATTRIBUTE1	Descriptive flexfield column.
CEI_ATTRIBUTE2	Descriptive flexfield column.
CEI_ATTRIBUTE3	Descriptive flexfield column.
CONTACT_RELATIONSHIP_ID	Foreign key to PER_CONTACT_RELATIONSHIPS.
CEI_ATTRIBUTE4	Descriptive flexfield column.
CEI_ATTRIBUTE5	Descriptive flexfield column.
CEI_ATTRIBUTE6	Descriptive flexfield column.
CEI_ATTRIBUTE7	Descriptive flexfield column.
CEI_ATTRIBUTE8	Descriptive flexfield column.
CEI_ATTRIBUTE9	Descriptive flexfield column.
CEI_ATTRIBUTE10	Descriptive flexfield column.
CEI_ATTRIBUTE11	Descriptive flexfield column.
CEI_ATTRIBUTE12	Descriptive flexfield column.
CEI_ATTRIBUTE13	Descriptive flexfield column.
INFORMATION_TYPE	Foreign key to PER_CONTACT_INFO_TYPES.
CEI_ATTRIBUTE14	Descriptive flexfield column.
CEI_ATTRIBUTE15	Descriptive flexfield column.
CEI_ATTRIBUTE16	Descriptive flexfield column.
CEI_ATTRIBUTE17	Descriptive flexfield column.
CEI_INFORMATION_CATEGORY	Developer descriptive flexfield column.
CEI_ATTRIBUTE18	Descriptive flexfield column.
CEI_ATTRIBUTE19	Descriptive flexfield column.
CEI_ATTRIBUTE20	Descriptive flexfield column.
CEI_INFORMATION1	Developer 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.
CEI_INFORMATION2	Developer descriptive flexfield column.
LAST_UPDATE_LOGIN	Standard who column.
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.
CEI_INFORMATION3	Developer descriptive flexfield column.
CEI_INFORMATION4	Developer descriptive flexfield column.
CONTACT_EXTRA_INFO_ID	System-generated primary key column.
CEI_INFORMATION5	Developer descriptive flexfield column.
CEI_INFORMATION6	Developer descriptive flexfield column.
CEI_INFORMATION7	Developer descriptive flexfield column.
CEI_INFORMATION8	Developer descriptive flexfield column.
CEI_INFORMATION9	Developer descriptive flexfield column.
CEI_INFORMATION10	Developer descriptive flexfield column.
CEI_INFORMATION11	Developer descriptive flexfield column.
CEI_INFORMATION12	Developer descriptive flexfield column.
CEI_INFORMATION13	Developer descriptive flexfield column.
CEI_INFORMATION14	Developer descriptive flexfield column.

Human Resources - PER_CONTACT_INFO_TYPES	Types of extra information that may be held against a contact relationship.
Column Name	Descritpion
ACTIVE_INACTIVE_FLAG	Indicates whether the information type is active or inactive.
MULTIPLE_OCCURENCES_FLAG	Indicates whether a contact relationship may have multiple occurrences of this type.
LEGISLATION_CODE	The legislation to which the information type applies.
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.
INFORMATION_TYPE	The name or code of the information type, which is also the primary key.
REQUEST_ID	Standard who column.
PROGRAM_APPLICATION_ID	Standard who column.
PROGRAM_ID	Standard who column.
PROGRAM_UPDATE_DATE	Standard who column.
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.

Human Resources - PER_CONTACT_INFO_TYPES_TL	Translated types of extra information that may be held against a contact relationship.
Column Name	Descritpion
LANGUAGE	Defined language.
SOURCE_LANG	Actual language.
DESCRIPTION	Translated description.
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.
INFORMATION_TYPE	Foreign key to PER_CONTACT_INFO_TYPES.

Human Resources - PER_GEN_HIER_NODE_TYPES
Column Name	Descritpion
HIER_NODE_TYPE_ID
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
BUSINESS_GROUP_ID
IDENTIFIER_KEY
HIERARCHY_TYPE
PARENT_NODE_TYPE
CHILD_NODE_TYPE
CHILD_VALUE_SET
LAST_UPDATE_DATE
LAST_UPDATED_BY

Human Resources - HR_WIP_LOCKS	Stores context lock for a transaction
Column Name	Descritpion
LOCK_ID
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
TRANSACTION_ID
TABLE_NAME
PRIMARY_KEY_VAL1
PRIMARY_KEY_VAL2
PRIMARY_KEY_VAL3
PRIMARY_KEY_VAL4
PRIMARY_KEY_VAL5
LAST_UPDATE_DATE

Human Resources - HR_WIP_TRANSACTIONS	Stores the transaction information and state
Column Name	Descritpion
TRANSACTION_ID
DML_MODE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
CREATOR_USER_ID
ITEM_TYPE
ITEM_KEY
FUNCTION_ID
STATE
SUB_STATE
VO_CACHE
CONTEXT_DISPLAY_TEXT

Human Resources - IRC_ALL_RECRUITING_SITES	This table currently stores a list of all of the third parties which you have agreements with to send adverts to. In future it may be expanded for other uses too.
Column Name	Descritpion
SITE_NAME	Obsolete
ATTRIBUTE9	Descriptive Flexfield Column
ATTRIBUTE10	Descriptive Flexfield Column
ATTRIBUTE11	Descriptive Flexfield Column
ATTRIBUTE12	Descriptive Flexfield Column
DATE_FROM	The date the recruiting site can be used from.
ATTRIBUTE13	Descriptive Flexfield Column
ATTRIBUTE14	Descriptive Flexfield Column
ATTRIBUTE15	Descriptive Flexfield Column
ATTRIBUTE16	Descriptive Flexfield Column
DATE_TO	The date the recruiting site can be used to.
ATTRIBUTE17	Descriptive Flexfield Column
ATTRIBUTE18	Descriptive Flexfield Column
INTERNAL	Not currently used
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
EXTERNAL	Not currently used
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
OBJECT_VERSION_NUMBER	The position which the default posting is for
INTERNAL_NAME
THIRD_PARTY	Specifies if the site is a third party site.
REDIRECTION_URL	Obsolete
POSTING_URL	Obsolete
POSTING_USERNAME	The username need to gain access to the site.
POSTING_PASSWORD	The password for the posting site
POSTING_COST	Cost of the posting.
POSTING_COST_PERIOD	Period that the posting cost is for.
RECRUITING_SITE_ID	Primary Key
POSTING_COST_CURRENCY	Currency of the posting cost.
STYLESHEET	The location of the stylesheet - this allows other DTDs to be supported.
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

Human Resources - PER_COMPETENCES_TL	This table is used for language translations
Column Name	Descritpion
LANGUAGE
SOURCE_LANG
NAME	The short name of the competence
COMPETENCE_ALIAS
BEHAVIOURAL_INDICATOR	A description of the behavioural charactaristics that would typically be displayed when the competence is possessed at this level
DESCRIPTION	The description of the rating scale
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.
COMPETENCE_ID	Unique Identifier of Competences

Human Resources - PER_GRADES_TL	Trnslated fields for per_grades
Column Name	Descritpion
GRADE_ID	Foreign key for per_grades
LANGUAGE	Defined language.
SOURCE_LANG	Actual language
NAME	Grade name.
CREATED_BY	Standard Who column.
CREATION_DATE	Standard Who column.
LAST_UPDATED_BY	Standard Who column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.

Human Resources - PER_EMPDIR_LOCATIONS
Column Name	Descritpion
ORIG_SYSTEM
ADDRESS_LINE_2
ADDRESS_LINE_3
TOWN_OR_CITY
REGION_1
REGION_2
REGION_3
POSTAL_CODE
INACTIVE_DATE
OFFICE_SITE_FLAG
RECEIVING_SITE_FLAG
ORIG_SYSTEM_ID
TELEPHONE_NUMBER_1
TELEPHONE_NUMBER_2
TELEPHONE_NUMBER_3
TIMEZONE_ID
OBJECT_VERSION_NUMBER
PARTITION_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
BUSINESS_GROUP_ID
CREATION_DATE
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
TIMEZONE_CODE
DERIVED_LOCALE
TAX_NAME
COUNTRY
STYLE
ADDRESS
ADDRESS_LINE_1

Human Resources - PER_EMPDIR_LOCATIONS_TL
Column Name	Descritpion
ORIG_SYSTEM
LAST_UPDATE_BY
CREATED_BY
CREATION_DATE
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ORIG_SYSTEM_ID
LOCATION_CODE
DESCRIPTION
LANGUAGE
SOURCE_LANG
OBJECT_VERSION_NUMBER
PARTITION_ID
LAST_UPDATE_DATE

Human Resources - PER_EMPDIR_JOBS
Column Name	Descritpion
ORIG_SYSTEM
LAST_UPDATE_DATE
LAST_UPDATE_BY
CREATED_BY
CREATION_DATE
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ORIG_SYSTEM_ID
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
BUSINESS_GROUP_ID
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
JOB_DEFINITION_ID
NAME
LANGUAGE
SOURCE_LANG
OBJECT_VERSION_NUMBER
PARTITION_ID

Human Resources - PER_EMPDIR_PEOPLE
Column Name	Descritpion
PERSON_KEY
FIRST_NAME
PER_INFORMATION28
PER_INFORMATION29
PER_INFORMATION30
DIRECT_REPORTS
TOTAL_REPORTS
LAST_NAME_ALTERNATE
FIRST_NAME_ALTERNATE
PRE_NAME_ADJUNCT
PERSON_TYPE
USER_NAME
ACTIVE
EMPLOYEE_NUMBER
KNOWN_AS
MIDDLE_NAMES
ORIG_SYSTEM
PREVIOUS_LAST_NAME
START_DATE
ORIGINAL_DATE_OF_HIRE
EMAIL_ADDRESS
WORK_TELEPHONE
MAILSTOP
OFFICE_NUMBER
ORDER_NAME
PARTITION_ID
OBJECT_VERSION_NUMBER
ORIG_SYSTEM_ID
GLOBAL_PERSON_ID
PARTY_ID
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
BUSINESS_GROUP_ID
CREATION_DATE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
LEGISLATION_CODE
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
DISPLAY_NAME
ATTRIBUTE19
ATTRIBUTE20
ATTRIBUTE21
ATTRIBUTE22
ATTRIBUTE23
ATTRIBUTE24
ATTRIBUTE25
ATTRIBUTE26
ATTRIBUTE27
ATTRIBUTE28
FULL_NAME
ATTRIBUTE29
ATTRIBUTE30
PER_INFORMATION_CATEGORY
PER_INFORMATION1
PER_INFORMATION2
PER_INFORMATION3
PER_INFORMATION4
PER_INFORMATION5
PER_INFORMATION6
PER_INFORMATION7
FULL_NAME_ALTERNATE
PER_INFORMATION8
PER_INFORMATION9
PER_INFORMATION10
PER_INFORMATION11
PER_INFORMATION12
PER_INFORMATION13
PER_INFORMATION14
PER_INFORMATION15
PER_INFORMATION16
PER_INFORMATION17
LAST_NAME
PER_INFORMATION18
PER_INFORMATION19
PER_INFORMATION20
PER_INFORMATION21
PER_INFORMATION22
PER_INFORMATION23
PER_INFORMATION24
PER_INFORMATION25
PER_INFORMATION26
PER_INFORMATION27

Human Resources - PER_EMPDIR_ORGANIZATIONS
Column Name	Descritpion
ORIG_SYSTEM
LANGUAGE
SOURCE_LANG
OBJECT_VERSION_NUMBER
PARTITION_ID
LAST_UPDATE_DATE
LAST_UPDATE_BY
CREATED_BY
CREATION_DATE
REQUEST_ID
PROGRAM_APPLICATION_ID
ORIG_SYSTEM_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
BUSINESS_GROUP_ID
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
LOCATION_ID
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
REPRESENTATIVE1_ID
REPRESENTATIVE2_ID
REPRESENTATIVE3_ID
REPRESENTATIVE4_ID
NAME

Human Resources - PER_EMPDIR_ASSIGNMENTS
Column Name	Descritpion
ORIG_SYSTEM
ORGANIZATION_ID
PRIMARY_FLAG
ACTIVE
ASSIGNMENT_NUMBER
DISCRETIONARY_TITLE
EMPLOYEE_CATEGORY
EMPLOYMENT_CATEGORY
ASSIGNMENT_CATEGORY
WORK_AT_HOME
OBJECT_VERSION_NUMBER
ORIG_SYSTEM_ID
PARTITION_ID
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
BUSINESS_GROUP_ID
ASS_ATTRIBUTE_CATEGORY
ASS_ATTRIBUTE1
ASS_ATTRIBUTE2
ASS_ATTRIBUTE3
ASS_ATTRIBUTE4
ASS_ATTRIBUTE5
ASS_ATTRIBUTE6
ASS_ATTRIBUTE7
ASS_ATTRIBUTE8
ASS_ATTRIBUTE9
POSITION_ID
ASS_ATTRIBUTE10
ASS_ATTRIBUTE11
ASS_ATTRIBUTE12
ASS_ATTRIBUTE13
ASS_ATTRIBUTE14
ASS_ATTRIBUTE15
ASS_ATTRIBUTE16
ASS_ATTRIBUTE17
ASS_ATTRIBUTE18
ASS_ATTRIBUTE19
JOB_ID
ASS_ATTRIBUTE20
ASS_ATTRIBUTE21
ASS_ATTRIBUTE22
ASS_ATTRIBUTE23
ASS_ATTRIBUTE24
ASS_ATTRIBUTE25
ASS_ATTRIBUTE26
ASS_ATTRIBUTE27
ASS_ATTRIBUTE28
ASS_ATTRIBUTE29
LOCATION_ID
ASS_ATTRIBUTE30
SUPERVISOR_ID
SUPERVISOR_ASSIGNMENT_ID
PERSON_ID

Human Resources - PER_EMPDIR_PHONES
Column Name	Descritpion
ORIG_SYSTEM
OBJECT_VERSION_NUMBER
PARTITION_ID
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
ORIG_SYSTEM_ID
CREATION_DATE
DATE_FROM
DATE_TO
PHONE_TYPE
PHONE_NUMBER
PHONE_KEY
PARENT_ID
PARENT_TABLE

Human Resources - PER_EMPDIR_POSITIONS
Column Name	Descritpion
ORIG_SYSTEM
SOURCE_LANG
OBJECT_VERSION_NUMBER
PARTITION_ID
LAST_UPDATE_DATE
LAST_UPDATE_BY
CREATED_BY
CREATION_DATE
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
ORIG_SYSTEM_ID
PROGRAM_UPDATE_DATE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
BUSINESS_GROUP_ID
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
JOB_ID
ATTRIBUTE19
ATTRIBUTE20
LOCATION_ID
ORGANIZATION_ID
POSITION_DEFINITION_ID
NAME
LANGUAGE

Human Resources - PER_COMPETENCE_OUTCOMES	Competence outcomes
Column Name	Descritpion
OUTCOME_ID	System-generated primay key column.
OUTCOME_NUMBER	Outcome number
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.
ASSESSMENT_CRITERIA	Assessment criteria
DATE_FROM	The date upon which the outcome becomes active.
DATE_TO	The date after which the outcome is no longer active.
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
COMPETENCE_ID	Foreign key to PER_COMPETENCES.
ATTRIBUTE20
INFORMATION_CATEGORY
INFORMATION1
INFORMATION2
INFORMATION3
INFORMATION4
INFORMATION5
INFORMATION6
INFORMATION7
INFORMATION8
INFORMATION9
NAME	Outcome name.
INFORMATION10
INFORMATION11
INFORMATION12
INFORMATION13
INFORMATION14
INFORMATION15
INFORMATION16
INFORMATION17
INFORMATION18
INFORMATION19
INFORMATION20
LAST_UPDATE_DATE	Standard Who column.
LAST_UPDATE_BY	Standard Who column

Human Resources - PER_COMP_ELEMENT_OUTCOMES	The outcomes achieved towards a given Competency .
Column Name	Descritpion
COMP_ELEMENT_OUTCOME_ID	System-generated primary key column.
COMPETENCE_ELEMENT_ID	Foreign key to PER_COMPETENCE_ELEMENTS.
CREATION_DATE	Standard Who column.
OUTCOME_ID	Foreign key to PER_COMPETENCE_OUTCOMES.
DATE_FROM
DATE_TO
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.
INFORMATION_CATEGORY	Developer descriptive flexfield defining column.
INFORMATION1	Developer descriptive flexfield column.
INFORMATION2	Developer descriptive flexfield column.
INFORMATION3	Developer descriptive flexfield column.
INFORMATION4	Developer descriptive flexfield column.
INFORMATION5	Developer descriptive flexfield column.
INFORMATION6	Developer descriptive flexfield column.
INFORMATION7	Developer descriptive flexfield column.
INFORMATION8	Developer descriptive flexfield column.
INFORMATION9	Developer descriptive flexfield column.
INFORMATION10	Developer descriptive flexfield column.
INFORMATION11	Developer descriptive flexfield column.
INFORMATION12	Developer descriptive flexfield column.
INFORMATION13	Developer descriptive flexfield column.
INFORMATION14	Developer descriptive flexfield column.
INFORMATION15	Developer descriptive flexfield column.
INFORMATION16	Developer descriptive flexfield column.
INFORMATION17	Developer descriptive flexfield column.
INFORMATION18	Developer descriptive flexfield column.
INFORMATION19	Developer descriptive flexfield column.
INFORMATION20	Developer descriptive flexfield column.
LAST_UPDATE_DATE	Standard Who column.
LAST_UPATE_BY	Standard Who column.
LAST_UPDATE_LOGIN	Standard Who column.
CREATED_BY	Standard Who column.

Human Resources - PER_ASSIGNMENT_LIST	List of assignments that a secure user can access.
Column Name	Descritpion
SECURITY_PROFILE_ID	Foreign key to PER_SECURITY_PROFILES.
ASSIGNMENT_ID	Foreign key to PER_ALL_ASSIGNMENTS_F.
PERSON_ID	Foreign key to PER_ALL_PEOPLE_F.
REQUEST_ID	Standard Who column.
PROGRAM_ID	Standard Who column.
PROGRAM_APPLICATION_ID	Standard Who column.
PROGRAM_UPDATE_DATE	Standard Who column.
USER_ID	Foreign key to FND_USER.

Human Resources - IRC_AGENCY_VACANCIES
Column Name	Descritpion
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
VACANCY_ID
ATTRIBUTE19
ATTRIBUTE20
ATTRIBUTE21
ATTRIBUTE22
ATTRIBUTE23
ATTRIBUTE24
ATTRIBUTE25
ATTRIBUTE26
ATTRIBUTE27
ATTRIBUTE28
START_DATE
ATTRIBUTE29
ATTRIBUTE30
OBJECT_VERSION_NUMBER
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
END_DATE
MAX_ALLOWED_APPLICANTS
MANAGE_APPLICANTS_ALLOWED
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
AGENCY_VACANCY_ID
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
AGENCY_ID
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12

Human Resources - IRC_ASSIGNMENT_DETAILS_F	iRecruitment specific additional assignment details.
Column Name	Descritpion
ASSIGNMENT_ID	Foreign key to PER_ALL_ASSIGNMENTS_F.
EFFECTIVE_START_DATE	Effective start date.
EFFECTIVE_END_DATE	Effective end date.
DETAILS_VERSION	Version of the assignment details with in the effective date range.
LATEST_DETAILS	Flag to identify the latest assignment details with in the effective date range.
ATTEMPT_ID	Foreign key to OTA_ATTEMPTS.
LAST_UPDATE_DATE	Standard WHO column.
LAST_UPDATED_BY	Standard WHO column.
ASSIGNMENT_DETAILS_ID	System-generated primary key 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.

Human Resources - IRC_PENDING_DATA	Stores User applications created on High Availability instance
Column Name	Descritpion
EMAIL_ADDRESS	Email Address of the User applying for the Vacancy or registering with the site
PER_INFORMATION2	Developer descriptive flexfield column.
PER_INFORMATION3	Developer descriptive flexfield column.
PER_INFORMATION4	Developer descriptive flexfield column.
PER_INFORMATION5	Developer descriptive flexfield column.
PER_INFORMATION6	Developer descriptive flexfield column.
PER_INFORMATION7	Developer descriptive flexfield column.
PER_INFORMATION8	Developer descriptive flexfield column.
PER_INFORMATION9	Developer descriptive flexfield column.
PER_INFORMATION10	Developer descriptive flexfield column.
PER_INFORMATION11	Developer descriptive flexfield column.
VACANCY_ID	Vacancy Id the user has applied for
PER_INFORMATION12	Developer descriptive flexfield column.
PER_INFORMATION13	Developer descriptive flexfield column.
PER_INFORMATION14	Developer descriptive flexfield column.
PER_INFORMATION15	Developer descriptive flexfield column.
PER_INFORMATION16	Developer descriptive flexfield column.
PER_INFORMATION17	Developer descriptive flexfield column.
PER_INFORMATION18	Developer descriptive flexfield column.
PER_INFORMATION19	Developer descriptive flexfield column.
PER_INFORMATION20	Developer descriptive flexfield column.
PER_INFORMATION21	Developer descriptive flexfield column.
LAST_NAME	Last Name of the user
PER_INFORMATION22	Developer descriptive flexfield column.
PER_INFORMATION23	Developer descriptive flexfield column.
PER_INFORMATION24	Developer descriptive flexfield column.
PER_INFORMATION25	Developer descriptive flexfield column.
PER_INFORMATION26	Developer descriptive flexfield column.
PER_INFORMATION27	Developer descriptive flexfield column.
PER_INFORMATION28	Developer descriptive flexfield column.
PER_INFORMATION29	Developer descriptive flexfield column.
PER_INFORMATION30	Developer descriptive flexfield column.
LAST_UPDATE_DATE	Date when this row was last updated
FIRST_NAME	First Name of the user
CREATION_DATE	Date when this row was created
ERROR_MESSAGE	Capture error messages that may have been encountered when processing this row.
ALLOW_ACCESS	Specifies if the recruiter or manager can contact the applicant.
USER_GUID	Global Unique Identifier assigned to the User submitting the application
VISITOR_RESP_KEY	Visitor Responsibility Key through which the user has applied for the job
VISITOR_RESP_APPL_ID	Visitor Responsibility Application Id through which the user has applied for the job
USER_PASSWORD	Password given by user when registering and applying for a Vacancy
SECURITY_GROUP_KEY	Security Group through which the user has applied for the job
RESUME_FILE_NAME	Name of file uploaded.
RESUME_DESCRIPTION	Description of the resume file
RESUME_MIME_TYPE	MIME type of the document
RESUME	Binary representation of the resume.
SOURCE_TYPE	Recruitment activity source for applicant assignment, for example, Advertisement).
PENDING_DATA_ID	Primary key column
JOB_POST_SOURCE_NAME	job post source name
POSTING_CONTENT_ID	Posting Content Id
PERSON_ID	Person Id
PROCESSED	Column indicates the processed state of this application
SEX	Legal gender.
DATE_OF_BIRTH	Date of birth.
PER_INFORMATION_CATEGORY	Developer descriptive flexfield column.
PER_INFORMATION1	Developer descriptive flexfield column.

Human Resources - IRC_ALL_RECRUITING_SITES_TL	Contains the tranlated versions of the recruiting sites.
Column Name	Descritpion
LANGUAGE	The language that the Recruiting site is in. And part of Primary Key
SOURCE_LANG	The source language the Recruitng site was first copied from.
SITE_NAME	The name of the recruiting site.
REDIRECTION_URL	Specify the Redirection URL
POSTING_URL	Specifies the URL to send third party postings too.
RECRUITING_SITE_ID	Primary Key

Human Resources - IRC_OFFERS	Table to maintain details of iRecruitment Offers
Column Name	Descritpion
OFFER_VERSION	Version of the Offer starting at 1.
OFFER_ASSIGNMENT_ID	Offer asignment for applicant
ADDRESS_ID	Id of Address where the offer has to be sent
TEMPLATE_ID	Id of letter template. Set to null if offer letter uploaded and overridden
OFFER_LETTER	Offer letter either generated when Offer extended or uploaded by the Super user
OFFER_LETTER_FILE_NAME	Filename of the uploaded offer letter
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
LATEST_OFFER	Flag to identify the latest offer
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CREATION_DATE	Creation Date
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
ATTRIBUTE21
ATTRIBUTE22
ATTRIBUTE23
ATTRIBUTE24
ATTRIBUTE25
LAST_UPDATE_DATE	Date when this row was last updated
ATTRIBUTE26
ATTRIBUTE27
ATTRIBUTE28
ATTRIBUTE29
ATTRIBUTE30
OBJECT_VERSION_NUMBER	System generated version of row. Increments by 1 with each update.
OFFER_LETTER_FILE_TYPE	Offer Letter File Type
CREATED_BY	User Id of creator
LAST_UPDATED_BY	User Id of last user to update the offer version
LAST_UPDATE_LOGIN	Standard Who Column
OFFER_STATUS	Status Of Offer Version
DISCRETIONARY_JOB_TITLE	Job Title that can be used instead of the Title against the Job Table
OFFER_EXTENDED_METHOD	Flag set when the offer is extended - SYSTEM/HARDCOPY
OFFER_ID	Primary Key Column
RESPONDENT_ID	User Id of the person responding to the Offer Extension
EXPIRY_DATE	Date the current Offer Version expires
PROPOSED_START_DATE	Proposed date of employee start
OFFER_LETTER_TRACKING_CODE	Tracking code from shipping company
OFFER_POSTAL_SERVICE	Name of the company handling the delivery of offer
OFFER_SHIPPING_DATE	Date Paper Offer was posted
VACANCY_ID	Vacancy Applied For
APPLICANT_ASSIGNMENT_ID	Applicant assignment for applicant

Human Resources - IRC_OFFER_STATUS_HISTORY	Table to maintain history of offers statuses
Column Name	Descritpion
OFFER_ID	Foreign Key To Offers
STATUS_CHANGE_DATE	Date Offer Status Change
LAST_UPDATE_DATE	Date Offer Last Updated
CREATED_BY	User Id of Creator
LAST_UPDATED_BY	User Id of last user to update the offer version
LAST_UPDATE_LOGIN	Standard Who Column
OFFER_STATUS	Status Of Offer Version
CHANGE_REASON	Reason for status Change - Accepted or Declined
DECLINE_REASON	Applicant Decline Reason
OBJECT_VERSION_NUMBER	Object Version Number
OFFER_STATUS_HISTORY_ID	Primary Key Column
CREATION_DATE	Creation Date

Human Resources - IRC_NOTES	IRC Offer Notes Table
Column Name	Descritpion
OFFER_STATUS_HISTORY_ID
NOTE_TEXT
CREATION_DATE
LAST_UPDATE_DATE
CREATED_BY
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
NOTE_ID

Human Resources - IRC_TEMPLATE_ASSOCIATIONS	Offer Template Association table
Column Name	Descritpion
TEMPLATE_ID
DEFAULT_ASSOCIATION
JOB_ID
POSITION_ID
ORGANIZATION_ID
START_DATE
END_DATE
CREATION_DATE
LAST_UPDATE_DATE
CREATED_BY
TEMPLATE_ASSOCIATION_ID
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER

Human Resources - IRC_LOCATION_CRITERIA_VALUES	The Locations the Candidate has saved as part of Job Searches
Column Name	Descritpion
LAST_UPDATE_LOGIN	Standard Who Column
CREATED_BY	User Id of Creator
CREATION_DATE	Creation Date
OBJECT_VERSION_NUMBER	Object Version Number
SEARCH_CRITERIA_ID	Foreign key to IRC_SEARCH_CRITERIA table
LOCATION_CRITERIA_VALUE_ID	Primary Key for the table
DERIVED_LOCALE	Derived Locale of the Location that the user has selected in the saved job search.
LAST_UPDATE_DATE	Date when this row was last updated.
LAST_UPDATED_BY	User Id of last user to update this Location Search Criteria

Human Resources - IRC_PROF_AREA_CRITERIA_VALUES	The Professional Area saved by the Candidate as part of Job Searches
Column Name	Descritpion
LAST_UPDATED_BY	User Id of last user to update this Professional Area Search Criteria
LAST_UPDATE_LOGIN	Standard Who Column
CREATED_BY	User Id of Creator
CREATION_DATE	Creation Date
OBJECT_VERSION_NUMBER	Object Version Number
SEARCH_CRITERIA_ID	Foreign key to IRC_SEARCH_CRITERIA table
PROF_AREA_CRITERIA_VALUE_ID	Primary Key for the table
PROFESSIONAL_AREA	Lookup code value from IRC_PROFESSIONAL_AREA lookup
LAST_UPDATE_DATE	Date when this record was last updated

Human Resources - PER_ABS_ATTENDANCE_TYPES_TL	Holds translated information for Absence Types
Column Name	Descritpion
LANGUAGE	Language of this row, part of the system primary key
SOURCE_LANG	Language from which this row was copied
NAME	Translated name of Absence Type
CREATED_BY	Standard AOL Audit Column
CREATION_DATE	Standard AOL Audit Column
LAST_UPDATED_BY	Standard AOL Audit Column
LAST_UPDATE_DATE	Standard AOL Audit Column
LAST_UPDATE_LOGIN	Standard AOL Audit Column
ABSENCE_ATTENDANCE_TYPE_ID	System generated primary key column

Human Resources - PER_CALENDAR_ENTRIES	Calendar Entries
Column Name	Descritpion
OBJECT_VERSION_NUMBER	Object Version Number
LEGISLATION_CODE	Legislation Code for seeded entry.
IDENTIFIER_KEY	Developer Id Key for seeded entry.
ORGANIZATION_STRUCTURE_ID	FK to PER_ORGANIZATION_STRUCTURES.
ORG_STRUCTURE_VERSION_ID	FK to PER_ORG_STRUCTURE_VERSIONS.
BUSINESS_GROUP_ID	Foreign Key to HR_ALL_ORGANIZATION_UNITS table
NAME	Name of the Calendar Entry
TYPE	Type of the Calendar Entry
START_DATE	Start Date of the Calendar Entry
START_HOUR	The hour the Calendar Entry starts
START_MIN	The minute the Calendar Entry starts
END_DATE	End Date of the Calendar Entry
END_HOUR	The hour the Calendar Entry ends
END_MIN	The minute the Calendar Entry ends
HIERARCHY_ID	Foreign Key to PER_GENERIC_HIERARCHY table
VALUE_SET_ID	Foreign Key to FND_FLEX_VALUE_SETS table
CALENDAR_ENTRY_ID	Calendar Entry Primary Key
DESCRIPTION	Description
LAST_UPDATE_DATE	Last Update Date
LAST_UPDATED_BY	Last Updated BY
LAST_UPDATE_LOGIN	Last Update Login
CREATED_BY	Created By
CREATION_DATE	Creation Date

Human Resources - PER_CAL_ENTRY_VALUES	Calendar Entry Values
Column Name	Descritpion
CALENDAR_ENTRY_ID	Foreign Key to PER_CALENDAR_ENTRIES
HIERARCHY_NODE_ID	Foreign Key to PER_GEN_HIERARCHY_NODES table
IDVALUE	Value Set value
ORG_STRUCTURE_ELEMENT_ID	FK to PER_ORG_STRUCTURE_ELEMENTS.
ORGANIZATION_ID	FK to HR_ALL_ORGANIZATION_UNITS.
OVERRIDE_NAME	Overriding name for entry value
OVERRIDE_TYPE	Overriding type for entry value
PARENT_ENTRY_VALUE_ID	Foreign Key to PER_CAL_ENTRY_VALUES table
USAGE_FLAG	Usage indicator flag
IDENTIFIER_KEY	Identifier key for seeded entry values
LAST_UPDATE_DATE	Last Update Date
LAST_UPDATED_BY	Last Updated By
LAST_UPDATE_LOGIN	Last Update Login
CAL_ENTRY_VALUE_ID	Calendar Entry Values Primary Key
CREATED_BY	Created By
CREATION_DATE	Creation Date
OBJECT_VERSION_NUMBER	Object Version Number

Human Resources - PER_CAL_ENTRY_ORG_LIST	Calendar Entry Org Coverage Cache
Column Name	Descritpion
CALENDAR_ENTRY_ID	Calendar Entry Identifier
LAST_UPDATE_LOGIN	Standard WHO Column
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
ORGANIZATION_ID	Organization Identifier
OVR_CAL_ENTRY_VALUE_ID	Overriding Calendar Entry Value Identifier
LAST_UPDATE_DATE	Standard WHO Column
LAST_UPDATED_BY

Human Resources - PER_CAL_ENTRY_GEO_LIST	Calendar Entry Geo Coverage Cache
Column Name	Descritpion
CALENDAR_ENTRY_ID	Calendar Entry Identifier
LAST_UPDATED_BY	Standard WHO Column
LAST_UPDATE_LOGIN	Standard WHO Column
CREATED_BY	Standard WHO Column
CREATION_DATE	Standard WHO Column
HIERARCHY_NODE_ID	Generic Hierarchy based Geographic Hierarchy Node Identifier
OVR_CAL_ENTRY_VALUE_ID	Overriding Calendar Entry Value Identifier
LAST_UPDATE_DATE	Standard WHO Column

Human Resources - PER_CAL_MAP_CACHE	Calendar Entry to Person Assignment Mapping Cache
Column Name	Descritpion
ASSIGNMENT_ID	Assignment Identifier
EVENT_NAME	Calendar Event Name
EVENT_TYPE	Calendar Event Type
START_DATE	Calendar Event Start Date
END_DATE	Calendar Event End Date
START_HOUR	Calendar Event Start Hour
END_HOUR	Calendar Event End Hour
START_MINUTE	Calendar Event Start Minute
PERSON_ID	Person Identifier
END_MINUTE	Calendar Event End Minute
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_CHECKLISTS
Column Name	Descritpion
NAME	Name of the Checklist
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.
DESCRIPTION	Description of the Checklist
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
CHECKLIST_CATEGORY	Category of the Checklist
INFORMATION20	Developer-Descriptive Flexfield Segment
EVENT_REASON_ID	Identifies the Life event reason. FK to BEN_LER_F
BUSINESS_GROUP_ID	Foreign key to HR_ORGANIZATION_UNITS.
CHECKLIST_ID	Checklist Identifier Primary Key
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_ABSENCE_CASES	This table is to store the Details of Absence Cases. Absence Case is a collection of Absences of an Employee grouped manually based on some criteria.
Column Name	Descritpion
ABSENCE_CASE_ID
AC_INFORMATION4
AC_INFORMATION5
AC_INFORMATION6
AC_INFORMATION7
AC_INFORMATION8
BUSINESS_GROUP_ID
AC_INFORMATION9
AC_INFORMATION10
AC_INFORMATION11
AC_INFORMATION12
AC_INFORMATION13
NAME
AC_INFORMATION14
AC_INFORMATION15
AC_INFORMATION16
AC_INFORMATION17
AC_INFORMATION18
AC_INFORMATION19
AC_INFORMATION20
AC_INFORMATION21
AC_INFORMATION22
AC_INFORMATION23
PERSON_ID
AC_INFORMATION24
AC_INFORMATION25
AC_INFORMATION26
AC_INFORMATION27
AC_INFORMATION28
AC_INFORMATION29
AC_INFORMATION30
AC_ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
INCIDENT_ID
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ABSENCE_CATEGORY
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
ATTRIBUTE21
ATTRIBUTE22
AC_INFORMATION_CATEGORY
ATTRIBUTE23
ATTRIBUTE24
ATTRIBUTE25
ATTRIBUTE26
ATTRIBUTE27
ATTRIBUTE28
ATTRIBUTE29
ATTRIBUTE30
LAST_UPDATE_DATE
LAST_UPDATED_BY
AC_INFORMATION1
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
OBJECT_VERSION_NUMBER
COMMENTS	Absence Case Comments
AC_INFORMATION2
AC_INFORMATION3

Human Resources - PER_ALLOCATED_TASKS	Allocated Tasks
Column Name	Descritpion
ALLOCATED_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.
TASK_NAME	Name of the Allocated Task
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
DESCRIPTION	Description of the Allocated Task
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
MANDATORY_FLAG
INFORMATION20	Developer-Descriptive Flexfield Segment
STATUS
PERFORMER_ORIG_SYSTEM	Performer of the Task
PERFORMER_ORIG_SYS_ID
TASK_OWNER_PERSON_ID	Owner of the Task
ALLOCATED_TASK_ID
TASK_SEQUENCE
TARGET_START_DATE
TARGET_END_DATE
ACTUAL_START_DATE
ACTUAL_END_DATE
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_ALLOCATED_CHECKLISTS	Allocated Checklists
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.
PERSON_ID	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
ASSIGNMENT_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
INFORMATION18	Developer-Descriptive Flexfield Segment
INFORMATION19	Developer-Descriptive Flexfield Segment
INFORMATION20	Developer-Descriptive Flexfield Segment
CHECKLIST_NAME	Name of the Allocated Checklist
DESCRIPTION
ALLOCATED_CHECKLIST_ID
CHECKLIST_CATEGORY
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_BEN_IDENTIFIED_EVENTS
Column Name	Descritpion
EVENT_REASON_ID
PERSON_ID	Checklist Task Identifier Primary Key
ASSIGNMENT_ID
STATUS
EFFECTIVE_DATE	Name of the Allocated Checklist
BEN_IDENTIFIED_EVENT_ID
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_APPRAISAL_PERIODS	This table holds planned appraisal periods, defined as part of the performance management plan.
Column Name	Descritpion
OBJECT_VERSION_NUMBER	System-generated version of row. Increments by one with each update.
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.
ATTRIBUTE25	Descriptive flexfield column.
ATTRIBUTE26	Descriptive flexfield column.
PLAN_ID	The performance management plan to which this appraisal period belongs.
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.
APPRAISAL_TEMPLATE_ID	The appraisal template used for this round of appraisals.
START_DATE	The start date of the period that this appraisal appraises.
END_DATE	The end date of the period that this appraisal appraises.
TASK_START_DATE	The date that the appraisal itself should start. This date is the start date of the appraisal task.
TASK_END_DATE	The date that the appraisal itself should finish. This date is the end date of the appraisal task.
INITIATOR_CODE	Uses the lookup type HR_WPM_APPRAISAL_INITIATOR to record the role of the person who should initiate the appraisal.
APPRAISAL_PERIOD_ID	System generated appraisal period primary key from PER_APPRAISAL_PERIODS_S.
APPRAISAL_SYSTEM_TYPE	Appraisal system type (360 or standard)
AUTO_CONC_PROCESS	Auto Concurrent Process (Yes/No)
DAYS_BEFORE_TASK_ST_DT	Days before how many days the conc process has to start from task start date
APPRAISAL_ASSMT_STATUS	Appraisal assessment status
APPRAISAL_TYPE	Appraisal purpose
ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column.
ATTRIBUTE1	Descriptive flexfield column.