Product: | HRI - Human Resources Intelligence |
---|---|
Description: | |
Implementation/DBA Data: | APPS.EDW_HR_PERM_ASSIGN_LCV |
SELECT ASSIGNMENT_PK
, ALL_FK
, SPRVSR_LVL1_FK
, NAME
, PERSON_DP
, BUSINESS_GROUP
, PERSON_NUM
, FULL_NAME
, LAST_NAME
, START_DATE
, END_DATE
, EMPLOYEE_FLAG
, APPLICANT_FLAG
, BUYER_FLAG
, PLANNER_FLAG
, SALES_REP_FLAG
, SYS_GEN_FLAG
, INSTANCE
, PERSON_ID
, SALESREP_ID
, PLANNER_CODE
, ORGANIZATION_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, FIRST_NAME
, MIDDLE_NAMES
, PREVIOUS_LAST_NAME
, KNOWN_AS
, TITLE
, NAME_SUFFIX
, NAME_PREFIX
, EMAIL_ADDRESS
, MARITAL_STATUS
, REHIRE_RCMMNDTN
, CRRSPNDNC_LANGUAGE
, DATE_EMP_DATA_VRFD
, DISABILITY_FLAG
, RESUME_UPDATED_DATE
, RESUME_EXISTS
, GENDER
, INTERNAL_LOCATION
, MAILSTOP
, FAST_PATH_EMPLOYEE
, NATIONAL_IDENTIFIER
, DATE_OF_BIRTH
, FTE_CAPACITY
, STUDENT_STATUS
, TOWN_OF_BIRTH
, REGION_OF_BIRTH
, COUNTRY_OF_BIRTH
, NATIONALITY
, GLOBAL_PERSON_ID
, CREATION_DATE
, LAST_UPDATE_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
FROM EDWBV_HR_PERM_ASSIGN_LCV