[Home] [Help] [Dependency Information]
Object Name: | HRFV_TERMINATIONS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PER.HRFV_TERMINATIONS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view shows information about employees who leave the enterprise. Current
employees are not shown. The information shown is
effective as of the employee's termination date.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | |
PERSON_NAME | VARCHAR2 | (240) | ||
BUDGET_MEASUREMENT_TYPE | VARCHAR2 | (4000) | ||
BUDGET_MEASUREMENT_CODE | VARCHAR2 | (30) | Yes | |
TERMINATION_DATE | DATE | |||
ASSIGNMENT_NUMBER | VARCHAR2 | (30) | ||
TERMINATION_REASON | VARCHAR2 | (4000) | ||
EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
PERSON_TYPE | VARCHAR2 | (80) | Yes | |
EMPLOYEE_PERSON_TYPE | VARCHAR2 | (4000) | ||
USER_CONCAT_PERSON_TYPE | VARCHAR2 | (4000) | ||
EMPLOYMENT_CATEGORY | VARCHAR2 | (4000) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | |
GRADE_NAME | VARCHAR2 | (240) | ||
JOB_NAME | VARCHAR2 | (700) | ||
POSITION_NAME | VARCHAR2 | (240) | ||
LOCATION_NAME | VARCHAR2 | (60) | ||
DATE_NOTIFIED | DATE | |||
COMMENTS | CLOB | (4000) | ||
ACCEPTED_BY | VARCHAR2 | (240) | ||
MONTHS_IN_SERVICE | NUMBER | |||
MONTHS_IN_ORGANIZATION | NUMBER | |||
MONTHS_IN_GRADE | NUMBER | |||
MONTHS_IN_JOB | NUMBER | |||
MONTHS_IN_POSITION | NUMBER | |||
MONTHS_IN_LOCATION | NUMBER | |||
SYSTEM_PERSON_TYPE_CODE | VARCHAR2 | (30) | Yes | |
_DF | CHAR | (33) | ||
_DF:PPOSDDF | CHAR | (35) | ||
ASSIGNMENT_ID | NUMBER | (10) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
GRADE_ID | NUMBER | (15) | ||
JOB_ID | NUMBER | (15) | ||
LOCATION_ID | NUMBER | (15) | ||
ORGANIZATION_ID | NUMBER | (15) | Yes | |
PERIOD_OF_SERVICE_ID | NUMBER | (9) | Yes | |
PERSON_ID | NUMBER | (10) | Yes | |
POSITION_ID | NUMBER | (15) | ||
PERSON_TYPE_ID | NUMBER | (15) | Yes | |
PPF_LAST_UPDATE_DATE | DATE | Last Update Date WHO column from per_all_people_f | ||
PPOS_LAST_UPDATE_DATE | DATE | Last Update Date WHO column from per_periods_of_service | ||
PAF_LAST_UPDATE_DATE | DATE | Last Update Date WHO column from per_assignments_f | ||
PPF_LAST_UPDATED_BY | NUMBER | (15) | ||
PPOS_LAST_UPDATED_BY | NUMBER | (15) | ||
PAF_LAST_UPDATED_BY | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_NAME
, PERSON_NAME
, BUDGET_MEASUREMENT_TYPE
, BUDGET_MEASUREMENT_CODE
, TERMINATION_DATE
, ASSIGNMENT_NUMBER
, TERMINATION_REASON
, EMPLOYEE_NUMBER
, PERSON_TYPE
, EMPLOYEE_PERSON_TYPE
, USER_CONCAT_PERSON_TYPE
, EMPLOYMENT_CATEGORY
, ORGANIZATION_NAME
, GRADE_NAME
, JOB_NAME
, POSITION_NAME
, LOCATION_NAME
, DATE_NOTIFIED
, COMMENTS
, ACCEPTED_BY
, MONTHS_IN_SERVICE
, MONTHS_IN_ORGANIZATION
, MONTHS_IN_GRADE
, MONTHS_IN_JOB
, MONTHS_IN_POSITION
, MONTHS_IN_LOCATION
, SYSTEM_PERSON_TYPE_CODE
, _DF
, _DF:PPOSDDF
, ASSIGNMENT_ID
, BUSINESS_GROUP_ID
, GRADE_ID
, JOB_ID
, LOCATION_ID
, ORGANIZATION_ID
, PERIOD_OF_SERVICE_ID
, PERSON_ID
, POSITION_ID
, PERSON_TYPE_ID
, PPF_LAST_UPDATE_DATE
, PPOS_LAST_UPDATE_DATE
, PAF_LAST_UPDATE_DATE
, PPF_LAST_UPDATED_BY
, PPOS_LAST_UPDATED_BY
, PAF_LAST_UPDATED_BY
FROM APPS.HRFV_TERMINATIONS;
APPS.HRFV_TERMINATIONS is not referenced by any database object
|
|
|