[Home] [Help]
View: PER_PERIODS_OF_SERVICE_V2
View Text
SELECT DISTINCT PPS.ROWID
, PPS.PERIOD_OF_SERVICE_ID
, PPS.BUSINESS_GROUP_ID + 0
, PPS.PERSON_ID
, PPS.DATE_START
, PPS.ACTUAL_TERMINATION_DATE
, PAF.ASSIGNMENT_NUMBER
, PAF.ASSIGNMENT_ID
FROM PER_PERIODS_OF_SERVICE PPS
, PER_ASSIGNMENTS_F PAF
WHERE PPS.PERIOD_OF_SERVICE_ID = PAF.PERIOD_OF_SERVICE_ID
AND PPS.PERSON_ID = PAF.PERSON_ID
Columns
Name |
ROW_ID |
PERIOD_OF_SERVICE_ID |
BUSINESS_GROUP_ID |
PERSON_ID |
DATE_START |
ACTUAL_TERMINATION_DATE |
ASSIGNMENT_NUMBER |
ASSIGNMENT_ID |