[Home] [Help] [Dependency Information]
Object Name: | HRIFV_PERIOD_OF_WORK |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view shows the period of work for your employees. The employee and assignment information
shown is that relevant at the time of hire, or the time of separation.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | |
PERSON_NAME | VARCHAR2 | (240) | ||
EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
ASSIGNMENT_NUMBER | VARCHAR2 | (30) | ||
APPLICANT_NUMBER | VARCHAR2 | (30) | ||
FIRST_NAME | VARCHAR2 | (150) | ||
LAST_NAME | VARCHAR2 | (150) | Yes | |
PREVIOUS_LAST_NAME | VARCHAR2 | (150) | ||
MIDDLE_NAMES | VARCHAR2 | (60) | ||
PREFERRED_NAME | VARCHAR2 | (80) | ||
TITLE | VARCHAR2 | (30) | ||
PREFIX | VARCHAR2 | (30) | ||
SUFFIX | VARCHAR2 | (30) | ||
EMPLOYMENT_CATEGORY | VARCHAR2 | (4000) | ||
REHIRE_REASON | VARCHAR2 | (60) | ||
REHIRE_RECOMMENDATION | VARCHAR2 | (4000) | ||
REHIRE_AUTHORIZOR | VARCHAR2 | (30) | ||
GENDER | VARCHAR2 | (4000) | ||
EMAIL_ADDRESS | VARCHAR2 | (240) | ||
ORIGINAL_DATE_OF_HIRE | DATE | |||
PERSON_START_DATE | DATE | Yes | ||
PERSON_END_DATE | VARCHAR2 | (9) | ||
ASSIGNMENT_START_DATE | DATE | Yes | ||
ASSIGNMENT_END_DATE | VARCHAR2 | (9) | ||
DATE_OF_BIRTH | DATE | |||
AGE_IN_DAYS | VARCHAR2 | (40) | ||
AGE_IN_YEARS | VARCHAR2 | (40) | ||
CURRENT_AGE_IN_DAYS | VARCHAR2 | (40) | ||
CURRENT_AGE_IN_YEARS | VARCHAR2 | (40) | ||
HIRE_DATE | DATE | Yes | ||
PERIOD_OF_WORK_DAYS | NUMBER | The period of time in days that the employee has been employed for this hire. If the employeehas separated from the enterprise the number of days between the hire and separated date will be shown. | ||
PERIOD_OF_WORK_YEARS | NUMBER | The period of time in years that the employee has been employed for this hire. If the employeehas separated from the enterprise the number of days between the hire and separated date will be shown. | ||
ACTUAL_SEPARATION_DATE | DATE | |||
SEPARATION_REASON | VARCHAR2 | (4000) | ||
SEPARATION_COMMENTS | CLOB | (4000) | ||
ACCEPTED_SEPARATION_DATE | DATE | |||
FINAL_PROCESS_DATE | DATE | |||
LAST_STANDARD_PROCESS_DATE | DATE | |||
NOTIFIED_SEPARATION_DATE | DATE | |||
PROJECTED_SEPARATION_DATE | DATE | |||
SEPARATION_REASON_CODE | VARCHAR2 | (30) | ||
EMPLOYMENT_CATEGORY_CODE | VARCHAR2 | (30) | ||
GENDER_CODE | VARCHAR2 | (30) | ||
REHIRE_RECOMMENDATION_CODE | VARCHAR2 | (30) | ||
PERSON_START_DATE_NN | DATE | Yes | ||
PERSON_END_DATE_NN | DATE | Yes | ||
ASSIGNMENT_START_DATE_NN | DATE | Yes | ||
ASSIGNMENT_END_DATE_NN | DATE | Yes | ||
PERIOD_OF_SERVICE_START_DATE | DATE | Yes | ||
PERIOD_OF_SERVICE_END_DATE_NN | DATE | |||
_DF:PERSON | CHAR | (22) | ||
_DF:ASSIGNMENT | CHAR | (27) | ||
_DF:SERVICE | CHAR | (33) | ||
_DF:ADDSRVINFO | CHAR | (35) | ||
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | |
ASSIGNMENT_ID | NUMBER | (10) | Yes | |
PERSON_ID | NUMBER | (10) | Yes | |
GRADE_ID | NUMBER | (15) | ||
JOB_ID | NUMBER | (15) | ||
ORGANIZATION_ID | NUMBER | (15) | Yes | |
POSITION_ID | NUMBER | (15) | ||
LOCATION_ID | NUMBER | (15) | ||
PERIOD_OF_SERVICE_ID | NUMBER | (15) | ||
RECRUITER_ID | NUMBER | (10) | ||
PAYROLL_ID | NUMBER | (9) | ||
PERSON_REFERRED_BY_ID | NUMBER | (10) | ||
SUPERVISOR_ID | NUMBER | (10) | ||
RECRUITMENT_ACTIVITY_ID | NUMBER | (15) | ||
SOURCE_ORGANIZATION_ID | NUMBER | (15) | ||
PEOPLE_GROUP_ID | NUMBER | (15) | ||
VACANCY_ID | NUMBER | (15) | ||
PAY_BASIS_ID | NUMBER | (9) | ||
APPLICATION_ID | NUMBER | (15) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | ||
CONTRACT_ID | NUMBER | (9) | ||
COLLECTIVE_AGREEMENT_ID | NUMBER | (9) | ||
PERSON_TYPE_ID | NUMBER | (15) | Yes | |
BENEFIT_GROUP_ID | NUMBER | (15) | ||
PERSON_COMMENT_ID | NUMBER | (15) | ||
TERMINATION_ACCEPTED_PERSON_ID | NUMBER | (10) |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_NAME
, PERSON_NAME
, EMPLOYEE_NUMBER
, ASSIGNMENT_NUMBER
, APPLICANT_NUMBER
, FIRST_NAME
, LAST_NAME
, PREVIOUS_LAST_NAME
, MIDDLE_NAMES
, PREFERRED_NAME
, TITLE
, PREFIX
, SUFFIX
, EMPLOYMENT_CATEGORY
, REHIRE_REASON
, REHIRE_RECOMMENDATION
, REHIRE_AUTHORIZOR
, GENDER
, EMAIL_ADDRESS
, ORIGINAL_DATE_OF_HIRE
, PERSON_START_DATE
, PERSON_END_DATE
, ASSIGNMENT_START_DATE
, ASSIGNMENT_END_DATE
, DATE_OF_BIRTH
, AGE_IN_DAYS
, AGE_IN_YEARS
, CURRENT_AGE_IN_DAYS
, CURRENT_AGE_IN_YEARS
, HIRE_DATE
, PERIOD_OF_WORK_DAYS
, PERIOD_OF_WORK_YEARS
, ACTUAL_SEPARATION_DATE
, SEPARATION_REASON
, SEPARATION_COMMENTS
, ACCEPTED_SEPARATION_DATE
, FINAL_PROCESS_DATE
, LAST_STANDARD_PROCESS_DATE
, NOTIFIED_SEPARATION_DATE
, PROJECTED_SEPARATION_DATE
, SEPARATION_REASON_CODE
, EMPLOYMENT_CATEGORY_CODE
, GENDER_CODE
, REHIRE_RECOMMENDATION_CODE
, PERSON_START_DATE_NN
, PERSON_END_DATE_NN
, ASSIGNMENT_START_DATE_NN
, ASSIGNMENT_END_DATE_NN
, PERIOD_OF_SERVICE_START_DATE
, PERIOD_OF_SERVICE_END_DATE_NN
, _DF:PERSON
, _DF:ASSIGNMENT
, _DF:SERVICE
, _DF:ADDSRVINFO
, BUSINESS_GROUP_ID
, ASSIGNMENT_ID
, PERSON_ID
, GRADE_ID
, JOB_ID
, ORGANIZATION_ID
, POSITION_ID
, LOCATION_ID
, PERIOD_OF_SERVICE_ID
, RECRUITER_ID
, PAYROLL_ID
, PERSON_REFERRED_BY_ID
, SUPERVISOR_ID
, RECRUITMENT_ACTIVITY_ID
, SOURCE_ORGANIZATION_ID
, PEOPLE_GROUP_ID
, VACANCY_ID
, PAY_BASIS_ID
, APPLICATION_ID
, SET_OF_BOOKS_ID
, CONTRACT_ID
, COLLECTIVE_AGREEMENT_ID
, PERSON_TYPE_ID
, BENEFIT_GROUP_ID
, PERSON_COMMENT_ID
, TERMINATION_ACCEPTED_PERSON_ID
FROM APPS.HRIFV_PERIOD_OF_WORK;
APPS.HRIFV_PERIOD_OF_WORK is not referenced by any database object
|
|
|