VIEW: HR.HR_360_PERSON_VIEW#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, EMPLOYEE_NUMBER EMPLOYEE_NUMBER, USER_PERSON_TYPE USER_PERSON_TYPE, DATE_OF_BIRTH DATE_OF_BIRTH, TOWN_OF_BIRTH TOWN_OF_BIRTH, COUNTRY_OF_BIRTH COUNTRY_OF_BIRTH, DATE_OF_DEATH DATE_OF_DEATH, ORIGINAL_DATE_OF_HIRE ORIGINAL_DATE_OF_HIRE, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, SEX SEX, MARITAL_STATUS MARITAL_STATUS, FULL_NAME FULL_NAME, PRE_NAME_ADJUNCT PRE_NAME_ADJUNCT, SUFFIX SUFFIX, TITLE TITLE, LAST_NAME LAST_NAME, FIRST_NAME FIRST_NAME, MIDDLE_NAMES MIDDLE_NAMES, ADDRESS_TYPE ADDRESS_TYPE, DATE_FROM DATE_FROM, EMAIL_ADDRESS EMAIL_ADDRESS, PHONE_TYPE PHONE_TYPE, PHONE_NUMBER PHONE_NUMBER, NATIONALITY NATIONALITY, NATIONAL_IDENTIFIER NATIONAL_IDENTIFIER, CONTACT_NAME CONTACT_NAME, RELATIONSHIP RELATIONSHIP, EMP_JOB_NAME EMP_JOB_NAME, EMP_GRADE_NAME EMP_GRADE_NAME, POSITION_NAME POSITION_NAME, EMPLOYMENT_CATEGORY EMPLOYMENT_CATEGORY, NORMAL_HOURS NORMAL_HOURS, ASG_LOCATION ASG_LOCATION, ASSIGNMENT_STATUS ASSIGNMENT_STATUS, DEPARTMENT_NAME DEPARTMENT_NAME, BUSINESS_GROUP_NAME BUSINESS_GROUP_NAME, PAYROLL_NAME PAYROLL_NAME, SUPERVISOR_NAME SUPERVISOR_NAME, PER_ADD_LABLE1 PER_ADD_LABLE1, PER_ADD_LABLE2 PER_ADD_LABLE2, PER_ADD_LABLE3 PER_ADD_LABLE3, PER_ADD_LABLE4 PER_ADD_LABLE4, PER_ADD_LABLE5 PER_ADD_LABLE5, PER_ADD_LABLE6 PER_ADD_LABLE6, PER_ADD_LABLE7 PER_ADD_LABLE7, PER_ADD_LABLE8 PER_ADD_LABLE8, PER_ADD_LABLE9 PER_ADD_LABLE9, PER_ADD_LABLE10 PER_ADD_LABLE10, PER_ADD_LABLE11 PER_ADD_LABLE11, PER_ADD_LABLE12 PER_ADD_LABLE12, PER_ADD_LABLE13 PER_ADD_LABLE13, PER_ADD_LABLE14 PER_ADD_LABLE14, PER_ADD_LABLE15 PER_ADD_LABLE15, PER_ADD_LABLE16 PER_ADD_LABLE16, PER_ADD_LABLE17 PER_ADD_LABLE17, PER_ADD_LABLE18 PER_ADD_LABLE18, PER_ADD_LABLE19 PER_ADD_LABLE19, PER_ADD_LABLE20 PER_ADD_LABLE20, PER_ADD_LABLE21 PER_ADD_LABLE21, PER_ADD_LABLE22 PER_ADD_LABLE22, PER_ADD_LABLE23 PER_ADD_LABLE23, PER_ADD_LABLE24 PER_ADD_LABLE24, PER_ADD_LABLE25 PER_ADD_LABLE25, PER_ADD_LABLE26 PER_ADD_LABLE26, PER_ADD_LABLE27 PER_ADD_LABLE27, PER_ADD_LABLE28 PER_ADD_LABLE28, PER_ADD_LABLE29 PER_ADD_LABLE29, PER_ADD_LABLE30 PER_ADD_LABLE30, PER_ADD_LABLE31 PER_ADD_LABLE31, PER_ADD_LABLE32 PER_ADD_LABLE32, PER_ADD_LABLE33 PER_ADD_LABLE33, PER_ADD_LABLE34 PER_ADD_LABLE34, PER_ADD_LABLE35 PER_ADD_LABLE35, PER_ADD_LABLE36 PER_ADD_LABLE36, PER_ADD_LABLE37 PER_ADD_LABLE37, PER_ADD_LABLE38 PER_ADD_LABLE38, PER_ADD_LABLE39 PER_ADD_LABLE39, PER_ADD_LABLE40 PER_ADD_LABLE40, PER_ADD_LABLE41 PER_ADD_LABLE41, PER_ADD_LABLE42 PER_ADD_LABLE42, PER_ADD_LABLE43 PER_ADD_LABLE43, PER_ADD_LABLE44 PER_ADD_LABLE44, PER_ADD_LABLE45 PER_ADD_LABLE45, PER_ADD_LABLE46 PER_ADD_LABLE46, CON_ADD_LABLE1 CON_ADD_LABLE1, CON_ADD_LABLE2 CON_ADD_LABLE2, CON_ADD_LABLE3 CON_ADD_LABLE3, CON_ADD_LABLE4 CON_ADD_LABLE4, CON_ADD_LABLE5 CON_ADD_LABLE5, CON_ADD_LABLE6 CON_ADD_LABLE6, CON_ADD_LABLE7 CON_ADD_LABLE7, CON_ADD_LABLE8 CON_ADD_LABLE8, CON_ADD_LABLE9 CON_ADD_LABLE9, CON_ADD_LABLE10 CON_ADD_LABLE10, CON_ADD_LABLE11 CON_ADD_LABLE11, CON_ADD_LABLE12 CON_ADD_LABLE12, CON_ADD_LABLE13 CON_ADD_LABLE13, CON_ADD_LABLE14 CON_ADD_LABLE14, CON_ADD_LABLE15 CON_ADD_LABLE15, CON_ADD_LABLE16 CON_ADD_LABLE16, CON_ADD_LABLE17 CON_ADD_LABLE17, CON_ADD_LABLE18 CON_ADD_LABLE18, CON_ADD_LABLE19 CON_ADD_LABLE19, CON_ADD_LABLE20 CON_ADD_LABLE20, CON_ADD_LABLE21 CON_ADD_LABLE21, CON_ADD_LABLE22 CON_ADD_LABLE22, CON_ADD_LABLE23 CON_ADD_LABLE23, CON_ADD_LABLE24 CON_ADD_LABLE24, CON_ADD_LABLE25 CON_ADD_LABLE25, CON_ADD_LABLE26 CON_ADD_LABLE26, CON_ADD_LABLE27 CON_ADD_LABLE27, CON_ADD_LABLE28 CON_ADD_LABLE28, CON_ADD_LABLE29 CON_ADD_LABLE29, CON_ADD_LABLE30 CON_ADD_LABLE30, CON_ADD_LABLE31 CON_ADD_LABLE31, CON_ADD_LABLE32 CON_ADD_LABLE32, CON_ADD_LABLE33 CON_ADD_LABLE33, CON_ADD_LABLE34 CON_ADD_LABLE34, CON_ADD_LABLE35 CON_ADD_LABLE35, CON_ADD_LABLE36 CON_ADD_LABLE36, CON_ADD_LABLE37 CON_ADD_LABLE37, CON_ADD_LABLE38 CON_ADD_LABLE38, CON_ADD_LABLE39 CON_ADD_LABLE39, CON_ADD_LABLE40 CON_ADD_LABLE40, CON_ADD_LABLE41 CON_ADD_LABLE41, CON_ADD_LABLE42 CON_ADD_LABLE42, CON_ADD_LABLE43 CON_ADD_LABLE43, CON_ADD_LABLE44 CON_ADD_LABLE44, CON_ADD_LABLE45 CON_ADD_LABLE45, CON_ADD_LABLE46 CON_ADD_LABLE46, ADDRESS_STYLE ADDRESS_STYLE, STATUS STATUS, PER_STATUS_DATE PER_STATUS_DATE, RECSEQ RECSEQ, CWK_NUMBER CWK_NUMBER from "HR"."HR_360_PERSON_VIEW"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, USER_PERSON_TYPE USER_PERSON_TYPE
, DATE_OF_BIRTH DATE_OF_BIRTH
, TOWN_OF_BIRTH TOWN_OF_BIRTH
, COUNTRY_OF_BIRTH COUNTRY_OF_BIRTH
, DATE_OF_DEATH DATE_OF_DEATH
, ORIGINAL_DATE_OF_HIRE ORIGINAL_DATE_OF_HIRE
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, SEX SEX
, MARITAL_STATUS MARITAL_STATUS
, FULL_NAME FULL_NAME
, PRE_NAME_ADJUNCT PRE_NAME_ADJUNCT
, SUFFIX SUFFIX
, TITLE TITLE
, LAST_NAME LAST_NAME
, FIRST_NAME FIRST_NAME
, MIDDLE_NAMES MIDDLE_NAMES
, ADDRESS_TYPE ADDRESS_TYPE
, DATE_FROM DATE_FROM
, EMAIL_ADDRESS EMAIL_ADDRESS
, PHONE_TYPE PHONE_TYPE
, PHONE_NUMBER PHONE_NUMBER
, NATIONALITY NATIONALITY
, NATIONAL_IDENTIFIER NATIONAL_IDENTIFIER
, CONTACT_NAME CONTACT_NAME
, RELATIONSHIP RELATIONSHIP
, EMP_JOB_NAME EMP_JOB_NAME
, EMP_GRADE_NAME EMP_GRADE_NAME
, POSITION_NAME POSITION_NAME
, EMPLOYMENT_CATEGORY EMPLOYMENT_CATEGORY
, NORMAL_HOURS NORMAL_HOURS
, ASG_LOCATION ASG_LOCATION
, ASSIGNMENT_STATUS ASSIGNMENT_STATUS
, DEPARTMENT_NAME DEPARTMENT_NAME
, BUSINESS_GROUP_NAME BUSINESS_GROUP_NAME
, PAYROLL_NAME PAYROLL_NAME
, SUPERVISOR_NAME SUPERVISOR_NAME
, PER_ADD_LABLE1 PER_ADD_LABLE1
, PER_ADD_LABLE2 PER_ADD_LABLE2
, PER_ADD_LABLE3 PER_ADD_LABLE3
, PER_ADD_LABLE4 PER_ADD_LABLE4
, PER_ADD_LABLE5 PER_ADD_LABLE5
, PER_ADD_LABLE6 PER_ADD_LABLE6
, PER_ADD_LABLE7 PER_ADD_LABLE7
, PER_ADD_LABLE8 PER_ADD_LABLE8
, PER_ADD_LABLE9 PER_ADD_LABLE9
, PER_ADD_LABLE10 PER_ADD_LABLE10
, PER_ADD_LABLE11 PER_ADD_LABLE11
, PER_ADD_LABLE12 PER_ADD_LABLE12
, PER_ADD_LABLE13 PER_ADD_LABLE13
, PER_ADD_LABLE14 PER_ADD_LABLE14
, PER_ADD_LABLE15 PER_ADD_LABLE15
, PER_ADD_LABLE16 PER_ADD_LABLE16
, PER_ADD_LABLE17 PER_ADD_LABLE17
, PER_ADD_LABLE18 PER_ADD_LABLE18
, PER_ADD_LABLE19 PER_ADD_LABLE19
, PER_ADD_LABLE20 PER_ADD_LABLE20
, PER_ADD_LABLE21 PER_ADD_LABLE21
, PER_ADD_LABLE22 PER_ADD_LABLE22
, PER_ADD_LABLE23 PER_ADD_LABLE23
, PER_ADD_LABLE24 PER_ADD_LABLE24
, PER_ADD_LABLE25 PER_ADD_LABLE25
, PER_ADD_LABLE26 PER_ADD_LABLE26
, PER_ADD_LABLE27 PER_ADD_LABLE27
, PER_ADD_LABLE28 PER_ADD_LABLE28
, PER_ADD_LABLE29 PER_ADD_LABLE29
, PER_ADD_LABLE30 PER_ADD_LABLE30
, PER_ADD_LABLE31 PER_ADD_LABLE31
, PER_ADD_LABLE32 PER_ADD_LABLE32
, PER_ADD_LABLE33 PER_ADD_LABLE33
, PER_ADD_LABLE34 PER_ADD_LABLE34
, PER_ADD_LABLE35 PER_ADD_LABLE35
, PER_ADD_LABLE36 PER_ADD_LABLE36
, PER_ADD_LABLE37 PER_ADD_LABLE37
, PER_ADD_LABLE38 PER_ADD_LABLE38
, PER_ADD_LABLE39 PER_ADD_LABLE39
, PER_ADD_LABLE40 PER_ADD_LABLE40
, PER_ADD_LABLE41 PER_ADD_LABLE41
, PER_ADD_LABLE42 PER_ADD_LABLE42
, PER_ADD_LABLE43 PER_ADD_LABLE43
, PER_ADD_LABLE44 PER_ADD_LABLE44
, PER_ADD_LABLE45 PER_ADD_LABLE45
, PER_ADD_LABLE46 PER_ADD_LABLE46
, CON_ADD_LABLE1 CON_ADD_LABLE1
, CON_ADD_LABLE2 CON_ADD_LABLE2
, CON_ADD_LABLE3 CON_ADD_LABLE3
, CON_ADD_LABLE4 CON_ADD_LABLE4
, CON_ADD_LABLE5 CON_ADD_LABLE5
, CON_ADD_LABLE6 CON_ADD_LABLE6
, CON_ADD_LABLE7 CON_ADD_LABLE7
, CON_ADD_LABLE8 CON_ADD_LABLE8
, CON_ADD_LABLE9 CON_ADD_LABLE9
, CON_ADD_LABLE10 CON_ADD_LABLE10
, CON_ADD_LABLE11 CON_ADD_LABLE11
, CON_ADD_LABLE12 CON_ADD_LABLE12
, CON_ADD_LABLE13 CON_ADD_LABLE13
, CON_ADD_LABLE14 CON_ADD_LABLE14
, CON_ADD_LABLE15 CON_ADD_LABLE15
, CON_ADD_LABLE16 CON_ADD_LABLE16
, CON_ADD_LABLE17 CON_ADD_LABLE17
, CON_ADD_LABLE18 CON_ADD_LABLE18
, CON_ADD_LABLE19 CON_ADD_LABLE19
, CON_ADD_LABLE20 CON_ADD_LABLE20
, CON_ADD_LABLE21 CON_ADD_LABLE21
, CON_ADD_LABLE22 CON_ADD_LABLE22
, CON_ADD_LABLE23 CON_ADD_LABLE23
, CON_ADD_LABLE24 CON_ADD_LABLE24
, CON_ADD_LABLE25 CON_ADD_LABLE25
, CON_ADD_LABLE26 CON_ADD_LABLE26
, CON_ADD_LABLE27 CON_ADD_LABLE27
, CON_ADD_LABLE28 CON_ADD_LABLE28
, CON_ADD_LABLE29 CON_ADD_LABLE29
, CON_ADD_LABLE30 CON_ADD_LABLE30
, CON_ADD_LABLE31 CON_ADD_LABLE31
, CON_ADD_LABLE32 CON_ADD_LABLE32
, CON_ADD_LABLE33 CON_ADD_LABLE33
, CON_ADD_LABLE34 CON_ADD_LABLE34
, CON_ADD_LABLE35 CON_ADD_LABLE35
, CON_ADD_LABLE36 CON_ADD_LABLE36
, CON_ADD_LABLE37 CON_ADD_LABLE37
, CON_ADD_LABLE38 CON_ADD_LABLE38
, CON_ADD_LABLE39 CON_ADD_LABLE39
, CON_ADD_LABLE40 CON_ADD_LABLE40
, CON_ADD_LABLE41 CON_ADD_LABLE41
, CON_ADD_LABLE42 CON_ADD_LABLE42
, CON_ADD_LABLE43 CON_ADD_LABLE43
, CON_ADD_LABLE44 CON_ADD_LABLE44
, CON_ADD_LABLE45 CON_ADD_LABLE45
, CON_ADD_LABLE46 CON_ADD_LABLE46
, ADDRESS_STYLE ADDRESS_STYLE
, STATUS STATUS
, PER_STATUS_DATE PER_STATUS_DATE
, RECSEQ RECSEQ
, CWK_NUMBER CWK_NUMBER
FROM "HR"."HR_360_PERSON_VIEW"