PER_PERIODS_OF_SERVICE_V

Details

• Schema: FUSION

• Object owner: PER

• Object type: VIEW

Columns

Name

PERIOD_OF_SERVICE_ID BUSINESS_GROUP_ID TERMINATION_ACCEPTED_PERSON_ID PERSON_ID DATE_START ACCEPTED_TERMINATION_DATE ACTUAL_TERMINATION_DATE NOTIFIED_TERMINATION_DATE PROJECTED_TERMINATION_DATE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE OBJECT_VERSION_NUMBER ADJUSTED_SVC_DATE PDS_INFORMATION_CATEGORY PDS_INFORMATION1 PDS_INFORMATION2 PDS_INFORMATION3 PDS_INFORMATION4 PDS_INFORMATION5 PDS_INFORMATION6 PDS_INFORMATION7 PDS_INFORMATION8 PDS_INFORMATION9 PDS_INFORMATION10 PDS_INFORMATION11 PDS_INFORMATION12 PDS_INFORMATION13 PDS_INFORMATION14 PDS_INFORMATION15 PDS_INFORMATION16 PDS_INFORMATION17 PDS_INFORMATION18 PDS_INFORMATION19 PDS_INFORMATION20 PDS_INFORMATION21 PDS_INFORMATION22 PDS_INFORMATION23 PDS_INFORMATION24 PDS_INFORMATION25 PDS_INFORMATION26 PDS_INFORMATION27 PDS_INFORMATION28 PDS_INFORMATION29 PDS_INFORMATION30 ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30 DATE_EMPLOYEE_DATA_VERIFIED FAST_PATH_EMPLOYEE LAST_WORKING_DATE LEGAL_ENTITY_ID LEGISLATION_CODE ON_MILITARY_SERVICE ORIGINAL_DATE_OF_HIRE PERIOD_TYPE PRIMARY_FLAG REHIRE_AUTHORIZOR REHIRE_REASON REHIRE_RECOMMENDATION WORKER_NUMBER ACTION_OCCURRENCE_ID COMMENTS REHIRE_AUTHORIZER_PERSON_ID PDS_INFORMATION_NUMBER1 PDS_INFORMATION_NUMBER2 PDS_INFORMATION_NUMBER3 PDS_INFORMATION_NUMBER4 PDS_INFORMATION_NUMBER5 PDS_INFORMATION_NUMBER6 PDS_INFORMATION_NUMBER7 PDS_INFORMATION_NUMBER8 PDS_INFORMATION_NUMBER9 PDS_INFORMATION_NUMBER10 PDS_INFORMATION_NUMBER11 PDS_INFORMATION_NUMBER12 PDS_INFORMATION_NUMBER13 PDS_INFORMATION_NUMBER14 PDS_INFORMATION_NUMBER15 PDS_INFORMATION_NUMBER16 PDS_INFORMATION_NUMBER17 PDS_INFORMATION_NUMBER18 PDS_INFORMATION_NUMBER19 PDS_INFORMATION_NUMBER20 PDS_INFORMATION_DATE1 PDS_INFORMATION_DATE2 PDS_INFORMATION_DATE3 PDS_INFORMATION_DATE4 PDS_INFORMATION_DATE5 PDS_INFORMATION_DATE6 PDS_INFORMATION_DATE7 PDS_INFORMATION_DATE8 PDS_INFORMATION_DATE9 PDS_INFORMATION_DATE10 PDS_INFORMATION_DATE11 PDS_INFORMATION_DATE12 PDS_INFORMATION_DATE13 PDS_INFORMATION_DATE14 PDS_INFORMATION_DATE15 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER11 ATTRIBUTE_NUMBER12 ATTRIBUTE_NUMBER13 ATTRIBUTE_NUMBER14 ATTRIBUTE_NUMBER15 ATTRIBUTE_NUMBER16 ATTRIBUTE_NUMBER17 ATTRIBUTE_NUMBER18 ATTRIBUTE_NUMBER19 ATTRIBUTE_NUMBER20 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 ATTRIBUTE_DATE11 ATTRIBUTE_DATE12 ATTRIBUTE_DATE13 ATTRIBUTE_DATE14 ATTRIBUTE_DATE15 REVOKE_USER_ACCESS

Query

SQL_Statement

SELECT PERIOD_OF_SERVICE_ID, BUSINESS_GROUP_ID, TERMINATION_ACCEPTED_PERSON_ID, PERSON_ID, DATE_START, ACCEPTED_TERMINATION_DATE, ACTUAL_TERMINATION_DATE, NOTIFIED_TERMINATION_DATE, PROJECTED_TERMINATION_DATE, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, OBJECT_VERSION_NUMBER, ADJUSTED_SVC_DATE, PDS_INFORMATION_CATEGORY, PDS_INFORMATION1, PDS_INFORMATION2, PDS_INFORMATION3, PDS_INFORMATION4, PDS_INFORMATION5, PDS_INFORMATION6, PDS_INFORMATION7, PDS_INFORMATION8, PDS_INFORMATION9, PDS_INFORMATION10, PDS_INFORMATION11, PDS_INFORMATION12, PDS_INFORMATION13, PDS_INFORMATION14, PDS_INFORMATION15, PDS_INFORMATION16, PDS_INFORMATION17, PDS_INFORMATION18, PDS_INFORMATION19, PDS_INFORMATION20, PDS_INFORMATION21, PDS_INFORMATION22, PDS_INFORMATION23, PDS_INFORMATION24, PDS_INFORMATION25, PDS_INFORMATION26, PDS_INFORMATION27, PDS_INFORMATION28, PDS_INFORMATION29, PDS_INFORMATION30, ATTRIBUTE21, ATTRIBUTE22, ATTRIBUTE23, ATTRIBUTE24, ATTRIBUTE25, ATTRIBUTE26, ATTRIBUTE27, ATTRIBUTE28, ATTRIBUTE29, ATTRIBUTE30, DATE_EMPLOYEE_DATA_VERIFIED, FAST_PATH_EMPLOYEE, LAST_WORKING_DATE, LEGAL_ENTITY_ID, LEGISLATION_CODE, ON_MILITARY_SERVICE, ORIGINAL_DATE_OF_HIRE, PERIOD_TYPE, PRIMARY_FLAG, REHIRE_AUTHORIZOR, REHIRE_REASON, REHIRE_RECOMMENDATION, WORKER_NUMBER, ACTION_OCCURRENCE_ID, COMMENTS, REHIRE_AUTHORIZER_PERSON_ID, PDS_INFORMATION_NUMBER1, PDS_INFORMATION_NUMBER2, PDS_INFORMATION_NUMBER3, PDS_INFORMATION_NUMBER4, PDS_INFORMATION_NUMBER5, PDS_INFORMATION_NUMBER6, PDS_INFORMATION_NUMBER7, PDS_INFORMATION_NUMBER8, PDS_INFORMATION_NUMBER9, PDS_INFORMATION_NUMBER10, PDS_INFORMATION_NUMBER11, PDS_INFORMATION_NUMBER12, PDS_INFORMATION_NUMBER13, PDS_INFORMATION_NUMBER14, PDS_INFORMATION_NUMBER15, PDS_INFORMATION_NUMBER16, PDS_INFORMATION_NUMBER17, PDS_INFORMATION_NUMBER18, PDS_INFORMATION_NUMBER19, PDS_INFORMATION_NUMBER20, PDS_INFORMATION_DATE1, PDS_INFORMATION_DATE2, PDS_INFORMATION_DATE3, PDS_INFORMATION_DATE4, PDS_INFORMATION_DATE5, PDS_INFORMATION_DATE6, PDS_INFORMATION_DATE7, PDS_INFORMATION_DATE8, PDS_INFORMATION_DATE9, PDS_INFORMATION_DATE10, PDS_INFORMATION_DATE11, PDS_INFORMATION_DATE12, PDS_INFORMATION_DATE13, PDS_INFORMATION_DATE14, PDS_INFORMATION_DATE15, ATTRIBUTE_NUMBER1, ATTRIBUTE_NUMBER2, ATTRIBUTE_NUMBER3, ATTRIBUTE_NUMBER4, ATTRIBUTE_NUMBER5, ATTRIBUTE_NUMBER6, ATTRIBUTE_NUMBER7, ATTRIBUTE_NUMBER8, ATTRIBUTE_NUMBER9, ATTRIBUTE_NUMBER10, ATTRIBUTE_NUMBER11, ATTRIBUTE_NUMBER12, ATTRIBUTE_NUMBER13, ATTRIBUTE_NUMBER14, ATTRIBUTE_NUMBER15, ATTRIBUTE_NUMBER16, ATTRIBUTE_NUMBER17, ATTRIBUTE_NUMBER18, ATTRIBUTE_NUMBER19, ATTRIBUTE_NUMBER20, ATTRIBUTE_DATE1, ATTRIBUTE_DATE2, ATTRIBUTE_DATE3, ATTRIBUTE_DATE4, ATTRIBUTE_DATE5, ATTRIBUTE_DATE6, ATTRIBUTE_DATE7, ATTRIBUTE_DATE8, ATTRIBUTE_DATE9, ATTRIBUTE_DATE10, ATTRIBUTE_DATE11, ATTRIBUTE_DATE12, ATTRIBUTE_DATE13, ATTRIBUTE_DATE14, ATTRIBUTE_DATE15, REVOKE_USER_ACCESS FROM PER_PERIODS_OF_SERVICE