ECC Human Resources, Human Resources, SQL1
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 ...
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
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 |
| LOV |