[Home] [Help]
View: EDW_HR_PERM_ASSIGN_LCV
| Product: | HRI - Human Resources Intelligence (Obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
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
Columns
| Name |
| 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 |
| USER_ATTRIBUTE1 |
| USER_ATTRIBUTE2 |
| USER_ATTRIBUTE3 |
| USER_ATTRIBUTE4 |
| USER_ATTRIBUTE5 |