eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: EDW_HR_ASGN_ASSGNMNT_LCV

Product:	HRI - Human Resources Intelligence (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

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

Columns

Name
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
USER_ATTRIBUTE1
USER_ATTRIBUTE2
USER_ATTRIBUTE3
USER_ATTRIBUTE4
USER_ATTRIBUTE5