eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HR.PER_ALL_ASSIGNMENTS_F

Object Details

Object Name:	PER_ALL_ASSIGNMENTS_F
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_ALL_ASSIGNMENTS_F
Subobject Name:
Status:	VALID

PER_ALL_ASSIGNMENTS_F is the DateTracked table that holds information
about employee assignments. It also holds details of assignments for
which an applicant has applied. The ASSIGNMENT_TYPE is E for an
employee assignment, and A for an applicant assignment. Employees
must have at least one employee assignment at all times in a period of
service, and each assignment must have a unique number. Employees can
have multiple assignments at any time, but there must always be a
designated primary assignment. Applicants must have at least one
applicant assignment throughout their application. Each assignment
has an assignment status that can change over time.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_ASSIGNMENTS_F_PK

ASSIGNMENT_ID
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_ASSIGNMENTS_F_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE
PER_ASSIGNMENTS_F_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
PER_ASSIGNMENTS_F_FK13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECRUITMENT_ACTIVITY_ID
PER_ASSIGNMENTS_F_FK14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_ORGANIZATION_ID
PER_ASSIGNMENTS_F_FK15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID
PER_ASSIGNMENTS_F_FK16	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PEOPLE_GROUP_ID
PER_ASSIGNMENTS_F_FK17	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOFT_CODING_KEYFLEX_ID
PER_ASSIGNMENTS_F_FK18	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VACANCY_ID
PER_ASSIGNMENTS_F_FK19	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAY_BASIS_ID
PER_ASSIGNMENTS_F_FK20	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ESTABLISHMENT_ID
PER_ASSIGNMENTS_F_FK21	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COLLECTIVE_AGREEMENT_ID
PER_ASSIGNMENTS_F_FK22	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTRACT_ID
PER_ASSIGNMENTS_F_FK23	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CAGR_GRADE_DEF_ID
PER_ASSIGNMENTS_F_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GRADE_ID
PER_ASSIGNMENTS_F_FK31	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POSTING_CONTENT_ID
PER_ASSIGNMENTS_F_FK4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POSITION_ID
PER_ASSIGNMENTS_F_FK5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	JOB_ID
PER_ASSIGNMENTS_F_FK52	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID
PER_ASSIGNMENTS_F_FK53	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_SITE_ID
PER_ASSIGNMENTS_F_FK54	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_HEADER_ID
PER_ASSIGNMENTS_F_FK55	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_LINE_ID
PER_ASSIGNMENTS_F_FK6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_STATUS_TYPE_ID
PER_ASSIGNMENTS_F_FK8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_ID
PER_ASSIGNMENTS_F_N03	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GRADE_LADDER_PGM_ID
PER_ASSIGNMENTS_F_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUPERVISOR_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE
PER_ASSIGNMENTS_F_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SPECIAL_CEILING_STEP_ID
PER_ASSIGNMENTS_F_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE
PER_ASSIGNMENTS_F_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RECRUITER_ID
PER_ASSIGNMENTS_F_N50	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_NUMBER
PER_ASSIGNMENTS_F_N55	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUPERVISOR_ASSIGNMENT_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE
PER_ASSIGNMENTS_F_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYROLL_ID
PER_ASSIGNMENTS_F_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_REFERRED_BY_ID
PER_ASSIGNMENTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERIOD_OF_SERVICE_ID
PER_ASSIGNMENTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICATION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PER_ALL_ASSIGNMENTS_F	HR_ALL_ORGANIZATION_UNITS	PER_ALL_ASSIGNMENTS_F BUSINESS_GROUP_ID
PER_ALL_ASSIGNMENTS_F	HR_ALL_ORGANIZATION_UNITS	PER_ALL_ASSIGNMENTS_F SOURCE_ORGANIZATION_ID
PER_ALL_ASSIGNMENTS_F	HR_ALL_ORGANIZATION_UNITS	PER_ALL_ASSIGNMENTS_F ORGANIZATION_ID
PER_ALL_ASSIGNMENTS_F	HR_ALL_ORGANIZATION_UNITS	PER_ALL_ASSIGNMENTS_F ESTABLISHMENT_ID
PER_ALL_ASSIGNMENTS_F	HR_LOCATIONS_ALL	PER_ALL_ASSIGNMENTS_F LOCATION_ID
PER_ALL_ASSIGNMENTS_F	HR_SOFT_CODING_KEYFLEX	PER_ALL_ASSIGNMENTS_F SOFT_CODING_KEYFLEX_ID
PER_ALL_ASSIGNMENTS_F	PAY_PEOPLE_GROUPS	PER_ALL_ASSIGNMENTS_F PEOPLE_GROUP_ID
PER_ALL_ASSIGNMENTS_F	PER_ALL_VACANCIES	PER_ALL_ASSIGNMENTS_F VACANCY_ID
PER_ALL_ASSIGNMENTS_F	PER_APPLICATIONS	PER_ALL_ASSIGNMENTS_F APPLICATION_ID
PER_ALL_ASSIGNMENTS_F	PER_CAGR_GRADES_DEF	PER_ALL_ASSIGNMENTS_F CAGR_GRADE_DEF_ID
PER_ALL_ASSIGNMENTS_F	PER_COLLECTIVE_AGREEMENTS	PER_ALL_ASSIGNMENTS_F COLLECTIVE_AGREEMENT_ID
PER_ALL_ASSIGNMENTS_F	PER_GRADES	PER_ALL_ASSIGNMENTS_F GRADE_ID
PER_ALL_ASSIGNMENTS_F	PER_JOBS	PER_ALL_ASSIGNMENTS_F JOB_ID
PER_ALL_ASSIGNMENTS_F	PER_PAY_BASES	PER_ALL_ASSIGNMENTS_F PAY_BASIS_ID
PER_ALL_ASSIGNMENTS_F	PER_PERIODS_OF_SERVICE	PER_ALL_ASSIGNMENTS_F PERIOD_OF_SERVICE_ID
PER_ALL_ASSIGNMENTS_F	PER_RECRUITMENT_ACTIVITIES	PER_ALL_ASSIGNMENTS_F RECRUITMENT_ACTIVITY_ID

Columns

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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ASSIGNMENT_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      BUSINESS_GROUP_ID
,      RECRUITER_ID
,      GRADE_ID
,      POSITION_ID
,      JOB_ID
,      ASSIGNMENT_STATUS_TYPE_ID
,      PAYROLL_ID
,      LOCATION_ID
,      PERSON_REFERRED_BY_ID
,      SUPERVISOR_ID
,      SPECIAL_CEILING_STEP_ID
,      PERSON_ID
,      RECRUITMENT_ACTIVITY_ID
,      SOURCE_ORGANIZATION_ID
,      ORGANIZATION_ID
,      PEOPLE_GROUP_ID
,      SOFT_CODING_KEYFLEX_ID
,      VACANCY_ID
,      PAY_BASIS_ID
,      ASSIGNMENT_SEQUENCE
,      ASSIGNMENT_TYPE
,      PRIMARY_FLAG
,      APPLICATION_ID
,      ASSIGNMENT_NUMBER
,      CHANGE_REASON
,      COMMENT_ID
,      DATE_PROBATION_END
,      DEFAULT_CODE_COMB_ID
,      EMPLOYMENT_CATEGORY
,      FREQUENCY
,      INTERNAL_ADDRESS_LINE
,      MANAGER_FLAG
,      NORMAL_HOURS
,      PERF_REVIEW_PERIOD
,      PERF_REVIEW_PERIOD_FREQUENCY
,      PERIOD_OF_SERVICE_ID
,      PROBATION_PERIOD
,      PROBATION_UNIT
,      SAL_REVIEW_PERIOD
,      SAL_REVIEW_PERIOD_FREQUENCY
,      SET_OF_BOOKS_ID
,      SOURCE_TYPE
,      TIME_NORMAL_FINISH
,      TIME_NORMAL_START
,      BARGAINING_UNIT_CODE
,      LABOUR_UNION_MEMBER_FLAG
,      HOURLY_SALARIED_CODE
,      CONTRACT_ID
,      COLLECTIVE_AGREEMENT_ID
,      CAGR_ID_FLEX_NUM
,      CAGR_GRADE_DEF_ID
,      ESTABLISHMENT_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ASS_ATTRIBUTE_CATEGORY
,      ASS_ATTRIBUTE1
,      ASS_ATTRIBUTE2
,      ASS_ATTRIBUTE3
,      ASS_ATTRIBUTE4
,      ASS_ATTRIBUTE5
,      ASS_ATTRIBUTE6
,      ASS_ATTRIBUTE7
,      ASS_ATTRIBUTE8
,      ASS_ATTRIBUTE9
,      ASS_ATTRIBUTE10
,      ASS_ATTRIBUTE11
,      ASS_ATTRIBUTE12
,      ASS_ATTRIBUTE13
,      ASS_ATTRIBUTE14
,      ASS_ATTRIBUTE15
,      ASS_ATTRIBUTE16
,      ASS_ATTRIBUTE17
,      ASS_ATTRIBUTE18
,      ASS_ATTRIBUTE19
,      ASS_ATTRIBUTE20
,      ASS_ATTRIBUTE21
,      ASS_ATTRIBUTE22
,      ASS_ATTRIBUTE23
,      ASS_ATTRIBUTE24
,      ASS_ATTRIBUTE25
,      ASS_ATTRIBUTE26
,      ASS_ATTRIBUTE27
,      ASS_ATTRIBUTE28
,      ASS_ATTRIBUTE29
,      ASS_ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      TITLE
,      OBJECT_VERSION_NUMBER
,      NOTICE_PERIOD
,      NOTICE_PERIOD_UOM
,      EMPLOYEE_CATEGORY
,      WORK_AT_HOME
,      JOB_POST_SOURCE_NAME
,      POSTING_CONTENT_ID
,      PERIOD_OF_PLACEMENT_DATE_START
,      VENDOR_ID
,      VENDOR_EMPLOYEE_NUMBER
,      VENDOR_ASSIGNMENT_NUMBER
,      ASSIGNMENT_CATEGORY
,      PROJECT_TITLE
,      APPLICANT_RANK
,      VENDOR_SITE_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      PROJECTED_ASSIGNMENT_END
,      GRADE_LADDER_PGM_ID
,      SUPERVISOR_ASSIGNMENT_ID
FROM HR.PER_ALL_ASSIGNMENTS_F;

Dependencies

[top of page]

HR.PER_ALL_ASSIGNMENTS_F does not reference any database object

HR.PER_ALL_ASSIGNMENTS_F is referenced by following:

HR: PER_ALL_ASSIGNMENTS_F#