Product: | HRI - Human Resources Intelligence |
---|---|
Description: | |
Implementation/DBA Data: | APPS.EDW_HR_ASGN_ASSGNMNT_LCV |
SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ ASSIGNMENT_PK
, ALL_FK
, NAME
, ASSIGNMENT_DP
, BUSINESS_GROUP
, ASSIGNMENT_NUMBER
, START_DATE
, END_DATE
, PRIMARY_FLAG
, INSTANCE
, ASSIGNMENT_ID
, ASSIGNMENT_STATUS_TYPE_ID
, BUSINESS_GROUP_ID
, PEOPLE_GROUP_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, TITLE
, NORMAL_HOURS_FREQUENCY
, NORMAL_HOURS
, ASSIGNMENT_STATUS
, ASSIGNMENT_TYPE
, MANAGER_FLAG
, TIME_NORMAL_START
, TIME_NORMAL_END
, PROBATION_PERIOD_UNIT
, PROBATION_PERIOD
, PERF_REVIEW_PERIOD_FRQNCY
, PERFORMANCE_REVIEW_PERIOD
, SLRY_REVIEW_PERIOD_FRQNCY
, SLRY_REVIEW_PERIOD
, HOURLY_SALARIED_FLAG
, CREATION_DATE
, LAST_UPDATE_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
FROM EDWBV_HR_ASGN_ASSGNMNT_LCV