ECC Human Resources, Human Resources, SQL1

➜ Back to Library
Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Person Id, Person, Image, Business Group Id, People Effective Start Date, People Effective End Date, First Name, Last Name, Middle Name ...
Imported from Enterprise Command Center
Dataset Key: PER
Query Procedure: PER_ECC_DATA_LOAD.GET_ECC_DATA_LOAD_INFO
Security Procedure: PER_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues 
select
x.*
from
(
select * from (SELECT ECC_SPEC_ID
        ,PERSON_ID
               ,PERSON
               ,IMAGE
               ,BUSINESS_GROUP_ID
               ,PEOPLE_EFFECTIVE_START_DATE
               ,PEOPLE_EFFECTIVE_END_DATE
               ,FIRST_NAME
               ,LAST_NAME
               ,MIDDLE_NAME
               ,KNOWN_AS
               ,FULL_NAME
               ,EMAIL_ADDRESS
               ,MARITAL_STATUS
               ,NATIONALITY
               ,PERSON_TYPE
               ,CURRENTLY_EMPLOYEE
               ,CURRENTLY_APPLICANT
               ,CURRENTLY_CONTINGENT_WORKER
               ,DATE_OF_BIRTH
               ,AGE
               ,BIRTH_ANNIVERSARY
               ,GENDER
               ,WORK_EXPERIENCE
               ,BLOOD_GROUP
               ,JOINING_DATE
               ,RELIEVING_DATE
               ,TENURE
               ,WORK_ANNIVERSARY
    ,LOGGED_USER_ID
    ,SECURITY_PROFILE_ID
               ,PEO_LAST_UPDATE_DATE
,LANGUAGE
FROM PER_ECC_PEOPLE_V where language in ('US')) PIVOT (max(MARITAL_STATUS) as MARITAL_STATUS, max(NATIONALITY) as NATIONALITY, max(GENDER) as GENDER, max(PERSON_TYPE) as PERSON_TYPE for LANGUAGE in ('US' "US"))
) x
where
2=2
Parameter Name SQL text Validation
Security Profile 
x.security_profile_id in (select psp.security_profile_id from per_security_profiles psp where psp.security_profile_name=:security_profile)
 LOV
Download
Related Blitz Reports
ECC Procurement, Purchase Orders ECC Contract Lifecycle Management, Requisitions, SQL12 ECC Discrete Manufacturing, Resources ECC Procurement, Requisitions ECC Sourcing, Negotiations, SQL2 ECC Human Resources, Human Resources, SQL2 ECC Discrete Manufacturing, Outside Processing ECC Sourcing, Negotiations, SQL1 ECC Procurement, Indirect Procurement, SQL1
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: