Results for “termination_date”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_R_PROJECT_RESOURCES_IND_T_V is an Oracle E-Business Suite Projects (PA) schema view owned by the APPS schema. It exposes information about project resources from the perspective of individual persons who hold an assignment and who are registered as resources in Oracle Projects. The view is defined with a filter requiring NVL(PAR.FUTURE_TERM_WF_FLAG,'N') = 'Y', which restricts the result set to resources flagged for future termination workflow processing — a construct frequently encountered in Oracle Projects resource-management and assignment-termination reporting. Because it joins human-resources person and assignment data with Projects resource data, the view is used principally for reporting and integration where a resource must be resolved to a person identity, assignment status, job, email, and contact details.

Underlying Base Objects

The view is defined over the following documented base objects, most of which are referenced through APPS synonyms: PA_RESOURCES, PA_RESOURCE_TXN_ATTRIBUTES, PER_ALL_ASSIGNMENTS_F, PER_ALL_PEOPLE_F, PER_ASSIGNMENT_STATUS_TYPES, PER_JOBS, PER_PERIODS_OF_PLACEMENT, PER_PERIODS_OF_SERVICE, PER_PERSON_TYPES, PER_PERSON_TYPE_USAGES_F, and the PA_EXPENDITURES_UTILS package. The core join path is ASGN.PERSON_ID = PER.PERSON_ID, then PER.PERSON_ID = PARTA.PERSON_ID, and PARTA.RESOURCE_ID = PAR.RESOURCE_ID, linking the person-record chain to the Projects resource. Periods of service and periods of placement are unioned to supply ACTUAL_TERMINATION_DATE. Person types are resolved through PER_PERSON_TYPE_USAGES_F joined to PER_PERSON_TYPES, and assignment validity is enforced via PER_ASSIGNMENT_STATUS_TYPES where the system status is ACTIVE_ASSIGN or ACTIVE_CWK. PA_EXPENDITURES_UTILS.GETORGTLNAME is invoked to derive the operating unit/group name.

Key Columns

• PERSON_ID – Identifier of the person associated with the assignment.
• NAME – First 60 characters of the person's full name (PER.FULL_NAME).
• ORGANIZATION_ID – Organization owning the assignment.
• ASSIGNMENT_START_DATE / ASSIGNMENT_END_DATE – Effective dates of the assignment record.
• START_DATE / TERMINATION_DATE – SYSDATE and the actual termination date from service or placement.
• P_TYPE / USER_TYPE – Decoded system person type (EMP or CWK) and the user-defined person type.
• PER_EMP_NUMBER – Employee number for employees or NPW number for contingent workers.
• PER_EMAIL – Person's email address (PER.EMAIL_ADDRESS), the column most often retrieved when users search for "per_email".
• PER_WORK_PHONE, PER_FIRST_NAME, PER_LAST_NAME, PER_MIDDLE_NAME – Contact and name components sourced from PER_ALL_PEOPLE_F.
• JOB_NAME, JOB_ID, JOB_GROUP_ID, SUPERVISOR_ID – Job and supervision attributes drawn from PER_JOBS and the assignment.
• ORG_NAME, RESOURCE_TYPE – Business group/operating unit name and the literal 'EMPLOYEE'.

Common Use Cases and Queries

Typical uses include retrieving resource contact information, validating active resource assignments, and driving integrations that need person email addresses linked to Projects resources. A representative query returning email addresses for project resources is:

• SELECT person_id, name, per_email, per_work_phone FROM apps.pa_r_project_resources_ind_t_v WHERE person_id = :p_person_id;
• SELECT person_id, per_first_name, per_last_name, per_email FROM apps.pa_r_project_resources_ind_t_v WHERE UPPER(per_email) LIKE UPPER('%'||:search||'%');
• SELECT organization_id, COUNT(*) FROM apps.pa_r_project_resources_ind_t_v GROUP BY organization_id;

Because the view enforces the FUTURE_TERM_WF_FLAG and active assignment status filters, results represent the subset of project resources eligible for termination processing rather than the complete resource population. Queries requiring the full set of resources should join PA_RESOURCES directly instead.