[Home] [Help]
View: PAY_PEOPLE_GROUPS_KFV
View Text
SELECT ROWID
, PEOPLE_GROUP_ID
, ID_FLEX_NUM
, (DECODE(ID_FLEX_NUM
, 101
, SEGMENT13
, NULL))
, (DECODE(ID_FLEX_NUM
, 101
, RPAD(NVL(SEGMENT13
, ' ')
, 60)
, NULL))
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, GROUP_NAME
, SUMMARY_FLAG
, ENABLED_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM PAY_PEOPLE_GROUPS
Columns
Name |
ROW_ID |
PEOPLE_GROUP_ID |
ID_FLEX_NUM |
CONCATENATED_SEGMENTS |
PADDED_CONCATENATED_SEGMENTS |
CREATED_BY |
CREATION_DATE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
GROUP_NAME |
SUMMARY_FLAG |
ENABLED_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |