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


VIEW: APPS.HRIFV_US_EMPASGDTL_EMPXASG

Object Details
Object Name: HRIFV_US_EMPASGDTL_EMPXASG
Object Type: VIEW
Owner: APPS
FND Design Data: ViewHRI.HRIFV_US_EMPASGDTL_EMPXASG
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_NAME VARCHAR2 (240) Yes
RECORD_START_DATE DATE

RECORD_END_DATE DATE

EMPLOYEE_START_DATE DATE
Yes
EMPLOYEE_END_DATE DATE
Yes
ASSIGNMENT_START_DATE DATE
Yes
ASSIGNMENT_END_DATE DATE
Yes
EMPLOYEE_NAME VARCHAR2 (240)
EMPLOYEE_NUMBER VARCHAR2 (30)
MIDDLE_NAMES VARCHAR2 (60)
PREFERRED_NAME VARCHAR2 (80)
FIRST_NAME VARCHAR2 (150)
LAST_NAME VARCHAR2 (150) Yes
GENDER VARCHAR2 (4000)
PREVIOUS_LAST_NAME VARCHAR2 (150)
REGISTERED_DISABLED VARCHAR2 (4000)
TOWN_OF_BIRTH VARCHAR2 (90)
REGION_OF_BIRTH VARCHAR2 (90)
COUNTRY_OF_BIRTH VARCHAR2 (90)
DATE_OF_BIRTH DATE

MARITAL_STATUS VARCHAR2 (4000)
NATIONALITY VARCHAR2 (4000)
NATIONAL_IDENTIFIER VARCHAR2 (30)
APPLICANT_NUMBER VARCHAR2 (30)
EMAIL_ADDRESS VARCHAR2 (240)
MAIL_DESTINATION VARCHAR2 (4000)
SECOND_PASSPORT VARCHAR2 (4000)
OFFICE_NUMBER VARCHAR2 (45)
INTERNAL_LOCATION VARCHAR2 (45)
MAILSTOP VARCHAR2 (45)
WORK_SCHEDULE VARCHAR2 (30)
FTE_CAPACITY NUMBER (5)
RESUME_EXISTS VARCHAR2 (4000)
RESUME_LAST_UPDATED DATE

CURRENT_APPLICANT_FLAG VARCHAR2 (4000)
CURRENT_EMPLOYEE_FLAG VARCHAR2 (4000)
DATE_EMPLOYEE_DATA_VERIFIED DATE

DATE_OF_DEATH DATE

FAST_PATH_EMPLOYEE VARCHAR2 (4000)
HOLD_APPLICATION_UNTIL DATE

HONORS VARCHAR2 (45)
ON_MILITARY_SERVICE VARCHAR2 (4000)
PROJECTED_START_DATE DATE

STUDENT_STATUS VARCHAR2 (4000)
HIRE_DATE DATE

ORIGINAL_DATE_OF_HIRE DATE

ASSIGNMENT_TITLE VARCHAR2 (30)
ASSIGNMENT_NUMBER VARCHAR2 (30)
NORMAL_START_TIME VARCHAR2 (5)
NORMAL_END_TIME VARCHAR2 (5)
PRIMARY_FLAG VARCHAR2 (4000)
INTERNAL_ADDRESS VARCHAR2 (80)
MANAGER_FLAG VARCHAR2 (4000)
EMPLOYMENT_CATEGORY VARCHAR2 (4000)
WORKING_HOURS_AMOUNT NUMBER (22)
WORKING_HOURS_FREQUENCY VARCHAR2 (4000)
ETHNIC_ORIGIN VARCHAR2 (4000)
I9 VARCHAR2 (4000)
I9_EXPIRY_DATE DATE

VISA_TYPE VARCHAR2 (4000)
VIETNAM_VETS_STATUS VARCHAR2 (4000)
STUDENT VARCHAR2 (4000)
NEW_HIRE_STATUS VARCHAR2 (4000)
EXCLUSION_REASON VARCHAR2 (150)
CHILD_SUPPORT_OBLIGATION VARCHAR2 (4000)
SOCIAL_SECURITY_NUMBER VARCHAR2 (30)
USER_ASSIGNMENT_STATUS VARCHAR2 (80)
PER_SYSTEM_ASSIGNMENT_STATUS VARCHAR2 (4000)
PAY_SYSTEM_ASSIGNMENT_STATUS VARCHAR2 (4000)
_DF:ASG CHAR (27)
_DF:PEO CHAR (22)
GENDER_CODE VARCHAR2 (30)
REGISTERED_DISABLED_CODE VARCHAR2 (30)
MARITAL_STATUS_CODE VARCHAR2 (30)
NATIONALITY_CODE VARCHAR2 (30)
MAIL_DESTINATION_CODE VARCHAR2 (30)
SECOND_PASSPORT_CODE VARCHAR2 (30)
RESUME_EXISTS_CODE VARCHAR2 (30)
CURRENT_APPLICANT_CODE VARCHAR2 (30)
CURRENT_EMPLOYEE_CODE VARCHAR2 (30)
FAST_PATH_EMPLOYEE_CODE VARCHAR2 (30)
ON_MILITARY_SERVICE_CODE VARCHAR2 (30)
STUDENT_STATUS_CODE VARCHAR2 (30)
PRIMARY_FLAG_CODE VARCHAR2 (30) Yes
MANAGER_FLAG_CODE VARCHAR2 (30)
EMPLOYMENT_CATEGORY_CODE VARCHAR2 (30)
WORKING_HOURS_FREQUENCY_CODE VARCHAR2 (30)
ETHNIC_ORIGIN_CODE VARCHAR2 (150)
I9_CODE VARCHAR2 (150)
VISA_TYPE_CODE VARCHAR2 (150)
VIETNAM_VETS_STATUS_CODE VARCHAR2 (150)
STUDENT_CODE VARCHAR2 (150)
NEW_HIRE_STATUS_CODE VARCHAR2 (150)
CHILD_SUPPORT_OBLIGATION_CODE VARCHAR2 (150)
PER_SYSTEM_ASGN_STATUS_CODE VARCHAR2 (30)
PAY_SYSTEM_ASGN_STATUS_CODE VARCHAR2 (1)
PERSON_ID NUMBER (10) Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
BENEFIT_GROUP_ID NUMBER (15)
PERSON_TYPE_ID NUMBER (15) Yes
PERSON_COMMENT_ID NUMBER (15)
ASSIGNMENT_ID NUMBER (10) Yes
GRADE_ID NUMBER (15)
JOB_ID NUMBER (15)
LOCATION_ID NUMBER (15)
ORGANIZATION_ID NUMBER (15) Yes
PAYROLL_ID NUMBER (9)
PERIOD_OF_SERVICE_ID NUMBER (15)
PEOPLE_GROUP_ID NUMBER (15)
POSITION_ID NUMBER (15)
RECRUITMENT_ACTIVITY_ID NUMBER (15)
SALARY_BASIS_ID NUMBER (9)
SUPERVISOR_ID NUMBER (10)
SPECIAL_CEILING_STEP_ID NUMBER (15)
ASSIGNMENT_COMMENT_ID NUMBER (15)
SET_OF_BOOKS_ID NUMBER (15)
COLLECTIVE_AGREEMENT_ID NUMBER (9)
CONTRACT_ID NUMBER (9)
VACANCY_ID NUMBER (15)
RECRUITER_ID NUMBER (10)
PERSON_REFERRED_BY_ID NUMBER (10)
SOURCE_ORGANIZATION_ID NUMBER (15)
Query Text

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


SELECT BUSINESS_GROUP_NAME
,      RECORD_START_DATE
,      RECORD_END_DATE
,      EMPLOYEE_START_DATE
,      EMPLOYEE_END_DATE
,      ASSIGNMENT_START_DATE
,      ASSIGNMENT_END_DATE
,      EMPLOYEE_NAME
,      EMPLOYEE_NUMBER
,      MIDDLE_NAMES
,      PREFERRED_NAME
,      FIRST_NAME
,      LAST_NAME
,      GENDER
,      PREVIOUS_LAST_NAME
,      REGISTERED_DISABLED
,      TOWN_OF_BIRTH
,      REGION_OF_BIRTH
,      COUNTRY_OF_BIRTH
,      DATE_OF_BIRTH
,      MARITAL_STATUS
,      NATIONALITY
,      NATIONAL_IDENTIFIER
,      APPLICANT_NUMBER
,      EMAIL_ADDRESS
,      MAIL_DESTINATION
,      SECOND_PASSPORT
,      OFFICE_NUMBER
,      INTERNAL_LOCATION
,      MAILSTOP
,      WORK_SCHEDULE
,      FTE_CAPACITY
,      RESUME_EXISTS
,      RESUME_LAST_UPDATED
,      CURRENT_APPLICANT_FLAG
,      CURRENT_EMPLOYEE_FLAG
,      DATE_EMPLOYEE_DATA_VERIFIED
,      DATE_OF_DEATH
,      FAST_PATH_EMPLOYEE
,      HOLD_APPLICATION_UNTIL
,      HONORS
,      ON_MILITARY_SERVICE
,      PROJECTED_START_DATE
,      STUDENT_STATUS
,      HIRE_DATE
,      ORIGINAL_DATE_OF_HIRE
,      ASSIGNMENT_TITLE
,      ASSIGNMENT_NUMBER
,      NORMAL_START_TIME
,      NORMAL_END_TIME
,      PRIMARY_FLAG
,      INTERNAL_ADDRESS
,      MANAGER_FLAG
,      EMPLOYMENT_CATEGORY
,      WORKING_HOURS_AMOUNT
,      WORKING_HOURS_FREQUENCY
,      ETHNIC_ORIGIN
,      I9
,      I9_EXPIRY_DATE
,      VISA_TYPE
,      VIETNAM_VETS_STATUS
,      STUDENT
,      NEW_HIRE_STATUS
,      EXCLUSION_REASON
,      CHILD_SUPPORT_OBLIGATION
,      SOCIAL_SECURITY_NUMBER
,      USER_ASSIGNMENT_STATUS
,      PER_SYSTEM_ASSIGNMENT_STATUS
,      PAY_SYSTEM_ASSIGNMENT_STATUS
,      _DF:ASG
,      _DF:PEO
,      GENDER_CODE
,      REGISTERED_DISABLED_CODE
,      MARITAL_STATUS_CODE
,      NATIONALITY_CODE
,      MAIL_DESTINATION_CODE
,      SECOND_PASSPORT_CODE
,      RESUME_EXISTS_CODE
,      CURRENT_APPLICANT_CODE
,      CURRENT_EMPLOYEE_CODE
,      FAST_PATH_EMPLOYEE_CODE
,      ON_MILITARY_SERVICE_CODE
,      STUDENT_STATUS_CODE
,      PRIMARY_FLAG_CODE
,      MANAGER_FLAG_CODE
,      EMPLOYMENT_CATEGORY_CODE
,      WORKING_HOURS_FREQUENCY_CODE
,      ETHNIC_ORIGIN_CODE
,      I9_CODE
,      VISA_TYPE_CODE
,      VIETNAM_VETS_STATUS_CODE
,      STUDENT_CODE
,      NEW_HIRE_STATUS_CODE
,      CHILD_SUPPORT_OBLIGATION_CODE
,      PER_SYSTEM_ASGN_STATUS_CODE
,      PAY_SYSTEM_ASGN_STATUS_CODE
,      PERSON_ID
,      BUSINESS_GROUP_ID
,      BENEFIT_GROUP_ID
,      PERSON_TYPE_ID
,      PERSON_COMMENT_ID
,      ASSIGNMENT_ID
,      GRADE_ID
,      JOB_ID
,      LOCATION_ID
,      ORGANIZATION_ID
,      PAYROLL_ID
,      PERIOD_OF_SERVICE_ID
,      PEOPLE_GROUP_ID
,      POSITION_ID
,      RECRUITMENT_ACTIVITY_ID
,      SALARY_BASIS_ID
,      SUPERVISOR_ID
,      SPECIAL_CEILING_STEP_ID
,      ASSIGNMENT_COMMENT_ID
,      SET_OF_BOOKS_ID
,      COLLECTIVE_AGREEMENT_ID
,      CONTRACT_ID
,      VACANCY_ID
,      RECRUITER_ID
,      PERSON_REFERRED_BY_ID
,      SOURCE_ORGANIZATION_ID
FROM APPS.HRIFV_US_EMPASGDTL_EMPXASG;

Dependencies

[top of page]

APPS.HRIFV_US_EMPASGDTL_EMPXASG references the following:

SchemaAPPS
PL/SQL PackageFND_DATE - show dependent code
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_BIS - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPER_ALL_PEOPLE_F
ViewPER_ASSIGNMENTS_F
SynonymPER_ASSIGNMENT_STATUS_TYPES
SynonymPER_ASSIGNMENT_STATUS_TYPES_TL
SynonymPER_ASS_STATUS_TYPE_AMENDS
SynonymPER_ASS_STATUS_TYPE_AMENDS_TL
ViewPER_BUSINESS_GROUPS
SynonymPER_PERIODS_OF_SERVICE

APPS.HRIFV_US_EMPASGDTL_EMPXASG is not referenced by any database object