View: PER_WORKFORCE_CURRENT_X

Product:	PER - Human Resources
Description:	Date-effective view.
Implementation/DBA Data:	APPS.PER_WORKFORCE_CURRENT_X

View Text

SELECT P.EMPLOYEE_NUMBER
, P.CURRENT_EMPLOYEE_FLAG
, P.BUSINESS_GROUP_ID
, A.ORGANIZATION_ID
, P.PERSON_ID
, A.ASSIGNMENT_ID
, P.LAST_UPDATE_DATE
, P.LAST_UPDATED_BY LAST_UPDATED_BY
, P.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, P.CREATION_DATE CREATION_DATE
, P.CREATED_BY CREATED_BY
, P.NPW_NUMBER
, P.CURRENT_NPW_FLAG
, A.VENDOR_ID
, A.VENDOR_EMPLOYEE_NUMBER
, A.VENDOR_ASSIGNMENT_NUMBER
, A.VENDOR_SITE_ID
, A.PO_HEADER_ID
, A.PO_LINE_ID
, P.FULL_NAME FULL_NAME
, P.FIRST_NAME FIRST_NAME
, P.MIDDLE_NAMES MIDDLE_NAMES
, P.LAST_NAME LAST_NAME
, P.PRE_NAME_ADJUNCT PRE_NAME_ADJUNCT
, A.LOCATION_ID LOCATION_ID
, A.SUPERVISOR_ID SUPERVISOR_ID
, A.SUPERVISOR_ASSIGNMENT_ID SUPERVISOR_ASSIGNMENT_ID
, A.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, A.DEFAULT_CODE_COMB_ID DEFAULT_CODE_COMB_ID
, PS.ACTUAL_TERMINATION_DATE ACTUAL_TERMINATION_DATE
, A.PROJECT_TITLE PROJECT_TITLE
, A.TITLE BILLING_TITLE
, P.EMAIL_ADDRESS EMAIL_ADDRESS
, P.EXPENSE_CHECK_SEND_TO_ADDRESS
, A.ASSIGNMENT_TYPE
, P.ATTRIBUTE1 ATTRIBUTE1
, P.ATTRIBUTE2 ATTRIBUTE2
, P.ATTRIBUTE3 ATTRIBUTE3
, P.ATTRIBUTE4 ATTRIBUTE4
, P.ATTRIBUTE5 ATTRIBUTE5
, P.ATTRIBUTE6 ATTRIBUTE6
, P.ATTRIBUTE7 ATTRIBUTE7
, P.ATTRIBUTE8 ATTRIBUTE8
, P.ATTRIBUTE9 ATTRIBUTE9
, P.ATTRIBUTE10 ATTRIBUTE10
, P.ATTRIBUTE11 ATTRIBUTE11
, P.ATTRIBUTE12 ATTRIBUTE12
, P.ATTRIBUTE13 ATTRIBUTE13
, P.ATTRIBUTE14 ATTRIBUTE14
, P.ATTRIBUTE15 ATTRIBUTE15
, P.ATTRIBUTE16 ATTRIBUTE16
, P.ATTRIBUTE17 ATTRIBUTE17
, P.ATTRIBUTE18 ATTRIBUTE18
, P.ATTRIBUTE19 ATTRIBUTE19
, P.ATTRIBUTE20 ATTRIBUTE20
, P.ATTRIBUTE21 ATTRIBUTE21
, P.ATTRIBUTE22 ATTRIBUTE22
, P.ATTRIBUTE23 ATTRIBUTE23
, P.ATTRIBUTE24 ATTRIBUTE24
, P.ATTRIBUTE25 ATTRIBUTE25
, P.ATTRIBUTE26 ATTRIBUTE26
, P.ATTRIBUTE27 ATTRIBUTE27
, P.ATTRIBUTE28 ATTRIBUTE28
, P.ATTRIBUTE29 ATTRIBUTE29
, P.ATTRIBUTE30 ATTRIBUTE30
, P.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, P.PARTY_ID PARTY_ID
, P.GLOBAL_NAME
, P.LOCAL_NAME
, P.LIST_NAME
FROM PER_PEOPLE_F P
, PER_ALL_ASSIGNMENTS_F A
, PER_PERIODS_OF_SERVICE PS
WHERE A.PERSON_ID = P.PERSON_ID
AND A.PERSON_ID = PS.PERSON_ID
AND A.ASSIGNMENT_TYPE='E'
AND P.EMPLOYEE_NUMBER IS NOT NULL
AND A.PERIOD_OF_SERVICE_ID = PS.PERIOD_OF_SERVICE_ID
AND A.PRIMARY_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN A.EFFECTIVE_START_DATE
AND A.EFFECTIVE_END_DATE
AND (PS.ACTUAL_TERMINATION_DATE>= TRUNC(SYSDATE) OR PS.ACTUAL_TERMINATION_DATE IS NULL) UNION ALL SELECT P.EMPLOYEE_NUMBER
, P.CURRENT_EMPLOYEE_FLAG
, P.BUSINESS_GROUP_ID
, A.ORGANIZATION_ID
, P.PERSON_ID
, A.ASSIGNMENT_ID
, P.LAST_UPDATE_DATE
, P.LAST_UPDATED_BY LAST_UPDATED_BY
, P.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, P.CREATION_DATE CREATION_DATE
, P.CREATED_BY CREATED_BY
, P.NPW_NUMBER
, P.CURRENT_NPW_FLAG
, A.VENDOR_ID
, A.VENDOR_EMPLOYEE_NUMBER
, A.VENDOR_ASSIGNMENT_NUMBER
, A.VENDOR_SITE_ID
, A.PO_HEADER_ID
, A.PO_LINE_ID
, P.FULL_NAME FULL_NAME
, P.FIRST_NAME FIRST_NAME
, P.MIDDLE_NAMES MIDDLE_NAMES
, P.LAST_NAME LAST_NAME
, P.PRE_NAME_ADJUNCT PRE_NAME_ADJUNCT
, A.LOCATION_ID LOCATION_ID
, A.SUPERVISOR_ID SUPERVISOR_ID
, A.SUPERVISOR_ASSIGNMENT_ID SUPERVISOR_ASSIGNMENT_ID
, A.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, A.DEFAULT_CODE_COMB_ID DEFAULT_CODE_COMB_ID
, PP.ACTUAL_TERMINATION_DATE ACTUAL_TERMINATION_DATE
, A.PROJECT_TITLE PROJECT_TITLE
, A.TITLE BILLING_TITLE
, P.EMAIL_ADDRESS EMAIL_ADDRESS
, P.EXPENSE_CHECK_SEND_TO_ADDRESS
, A.ASSIGNMENT_TYPE
, P.ATTRIBUTE1 ATTRIBUTE1
, P.ATTRIBUTE2 ATTRIBUTE2
, P.ATTRIBUTE3 ATTRIBUTE3
, P.ATTRIBUTE4 ATTRIBUTE4
, P.ATTRIBUTE5 ATTRIBUTE5
, P.ATTRIBUTE6 ATTRIBUTE6
, P.ATTRIBUTE7 ATTRIBUTE7
, P.ATTRIBUTE8 ATTRIBUTE8
, P.ATTRIBUTE9 ATTRIBUTE9
, P.ATTRIBUTE10 ATTRIBUTE10
, P.ATTRIBUTE11 ATTRIBUTE11
, P.ATTRIBUTE12 ATTRIBUTE12
, P.ATTRIBUTE13 ATTRIBUTE13
, P.ATTRIBUTE14 ATTRIBUTE14
, P.ATTRIBUTE15 ATTRIBUTE15
, P.ATTRIBUTE16 ATTRIBUTE16
, P.ATTRIBUTE17 ATTRIBUTE17
, P.ATTRIBUTE18 ATTRIBUTE18
, P.ATTRIBUTE19 ATTRIBUTE19
, P.ATTRIBUTE20 ATTRIBUTE20
, P.ATTRIBUTE21 ATTRIBUTE21
, P.ATTRIBUTE22 ATTRIBUTE22
, P.ATTRIBUTE23 ATTRIBUTE23
, P.ATTRIBUTE24 ATTRIBUTE24
, P.ATTRIBUTE25 ATTRIBUTE25
, P.ATTRIBUTE26 ATTRIBUTE26
, P.ATTRIBUTE27 ATTRIBUTE27
, P.ATTRIBUTE28 ATTRIBUTE28
, P.ATTRIBUTE29 ATTRIBUTE29
, P.ATTRIBUTE30 ATTRIBUTE30
, P.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, P.PARTY_ID PARTY_ID
, P.GLOBAL_NAME GLOBAL_NAME
, P.LOCAL_NAME LOCAL_NAME
, P.LIST_NAME LIST_NAME
FROM PER_PEOPLE_F P
, PER_ALL_ASSIGNMENTS_F A
, PER_PERIODS_OF_PLACEMENT PP
WHERE A.PERSON_ID = P.PERSON_ID
AND A.PERSON_ID = PP.PERSON_ID
AND A.ASSIGNMENT_TYPE='C'
AND P.NPW_NUMBER IS NOT NULL
AND A.PERIOD_OF_PLACEMENT_DATE_START = PP.DATE_START
AND A.PRIMARY_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN A.EFFECTIVE_START_DATE
AND A.EFFECTIVE_END_DATE
AND (PP.ACTUAL_TERMINATION_DATE>= TRUNC(SYSDATE) OR PP.ACTUAL_TERMINATION_DATE IS NULL)

Columns