[Home] [Help] [Dependency Information]
Object Name: | HR_360_PERSON_VIEW# |
---|---|
Object Type: | VIEW |
Owner: | HR |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | VARCHAR2 | (1000) | ||
EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
USER_PERSON_TYPE | VARCHAR2 | (60) | ||
DATE_OF_BIRTH | DATE | |||
TOWN_OF_BIRTH | VARCHAR2 | (90) | ||
COUNTRY_OF_BIRTH | VARCHAR2 | (90) | ||
DATE_OF_DEATH | DATE | |||
ORIGINAL_DATE_OF_HIRE | DATE | |||
EFFECTIVE_START_DATE | DATE | |||
SEX | VARCHAR2 | (30) | ||
MARITAL_STATUS | VARCHAR2 | (30) | ||
FULL_NAME | VARCHAR2 | (240) | ||
PRE_NAME_ADJUNCT | VARCHAR2 | (30) | ||
SUFFIX | VARCHAR2 | (30) | ||
TITLE | VARCHAR2 | (30) | ||
LAST_NAME | VARCHAR2 | (150) | ||
FIRST_NAME | VARCHAR2 | (150) | ||
MIDDLE_NAMES | VARCHAR2 | (90) | ||
ADDRESS_TYPE | VARCHAR2 | (30) | ||
DATE_FROM | DATE | |||
EMAIL_ADDRESS | VARCHAR2 | (240) | ||
PHONE_TYPE | VARCHAR2 | (30) | ||
PHONE_NUMBER | VARCHAR2 | (60) | ||
NATIONALITY | VARCHAR2 | (30) | ||
NATIONAL_IDENTIFIER | VARCHAR2 | (30) | ||
CONTACT_NAME | VARCHAR2 | (240) | ||
RELATIONSHIP | VARCHAR2 | (30) | ||
EMP_JOB_NAME | VARCHAR2 | (700) | ||
EMP_GRADE_NAME | VARCHAR2 | (240) | ||
POSITION_NAME | VARCHAR2 | (240) | ||
EMPLOYMENT_CATEGORY | VARCHAR2 | (30) | ||
NORMAL_HOURS | NUMBER | |||
ASG_LOCATION | VARCHAR2 | (60) | ||
ASSIGNMENT_STATUS | VARCHAR2 | (80) | ||
DEPARTMENT_NAME | VARCHAR2 | (240) | ||
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | ||
PAYROLL_NAME | VARCHAR2 | (80) | ||
SUPERVISOR_NAME | VARCHAR2 | (240) | ||
PER_ADD_LABLE1 | VARCHAR2 | (240) | ||
PER_ADD_LABLE2 | VARCHAR2 | (240) | ||
PER_ADD_LABLE3 | VARCHAR2 | (240) | ||
PER_ADD_LABLE4 | VARCHAR2 | (240) | ||
PER_ADD_LABLE5 | VARCHAR2 | (240) | ||
PER_ADD_LABLE6 | VARCHAR2 | (240) | ||
PER_ADD_LABLE7 | VARCHAR2 | (240) | ||
PER_ADD_LABLE8 | VARCHAR2 | (240) | ||
PER_ADD_LABLE9 | VARCHAR2 | (240) | ||
PER_ADD_LABLE10 | VARCHAR2 | (240) | ||
PER_ADD_LABLE11 | VARCHAR2 | (240) | ||
PER_ADD_LABLE12 | VARCHAR2 | (240) | ||
PER_ADD_LABLE13 | VARCHAR2 | (240) | ||
PER_ADD_LABLE14 | VARCHAR2 | (240) | ||
PER_ADD_LABLE15 | VARCHAR2 | (240) | ||
PER_ADD_LABLE16 | VARCHAR2 | (240) | ||
PER_ADD_LABLE17 | VARCHAR2 | (240) | ||
PER_ADD_LABLE18 | VARCHAR2 | (240) | ||
PER_ADD_LABLE19 | VARCHAR2 | (240) | ||
PER_ADD_LABLE20 | VARCHAR2 | (240) | ||
PER_ADD_LABLE21 | VARCHAR2 | (240) | ||
PER_ADD_LABLE22 | VARCHAR2 | (240) | ||
PER_ADD_LABLE23 | VARCHAR2 | (240) | ||
PER_ADD_LABLE24 | VARCHAR2 | (240) | ||
PER_ADD_LABLE25 | VARCHAR2 | (240) | ||
PER_ADD_LABLE26 | VARCHAR2 | (240) | ||
PER_ADD_LABLE27 | VARCHAR2 | (240) | ||
PER_ADD_LABLE28 | VARCHAR2 | (240) | ||
PER_ADD_LABLE29 | VARCHAR2 | (240) | ||
PER_ADD_LABLE30 | VARCHAR2 | (240) | ||
PER_ADD_LABLE31 | VARCHAR2 | (240) | ||
PER_ADD_LABLE32 | VARCHAR2 | (240) | ||
PER_ADD_LABLE33 | VARCHAR2 | (240) | ||
PER_ADD_LABLE34 | VARCHAR2 | (240) | ||
PER_ADD_LABLE35 | VARCHAR2 | (240) | ||
PER_ADD_LABLE36 | VARCHAR2 | (240) | ||
PER_ADD_LABLE37 | VARCHAR2 | (240) | ||
PER_ADD_LABLE38 | VARCHAR2 | (240) | ||
PER_ADD_LABLE39 | VARCHAR2 | (240) | ||
PER_ADD_LABLE40 | VARCHAR2 | (240) | ||
PER_ADD_LABLE41 | VARCHAR2 | (240) | ||
PER_ADD_LABLE42 | VARCHAR2 | (240) | ||
PER_ADD_LABLE43 | VARCHAR2 | (240) | ||
PER_ADD_LABLE44 | VARCHAR2 | (240) | ||
PER_ADD_LABLE45 | VARCHAR2 | (240) | ||
PER_ADD_LABLE46 | VARCHAR2 | (240) | ||
CON_ADD_LABLE1 | VARCHAR2 | (240) | ||
CON_ADD_LABLE2 | VARCHAR2 | (240) | ||
CON_ADD_LABLE3 | VARCHAR2 | (240) | ||
CON_ADD_LABLE4 | VARCHAR2 | (240) | ||
CON_ADD_LABLE5 | VARCHAR2 | (240) | ||
CON_ADD_LABLE6 | VARCHAR2 | (240) | ||
CON_ADD_LABLE7 | VARCHAR2 | (240) | ||
CON_ADD_LABLE8 | VARCHAR2 | (240) | ||
CON_ADD_LABLE9 | VARCHAR2 | (240) | ||
CON_ADD_LABLE10 | VARCHAR2 | (240) | ||
CON_ADD_LABLE11 | VARCHAR2 | (240) | ||
CON_ADD_LABLE12 | VARCHAR2 | (240) | ||
CON_ADD_LABLE13 | VARCHAR2 | (240) | ||
CON_ADD_LABLE14 | VARCHAR2 | (240) | ||
CON_ADD_LABLE15 | VARCHAR2 | (240) | ||
CON_ADD_LABLE16 | VARCHAR2 | (240) | ||
CON_ADD_LABLE17 | VARCHAR2 | (240) | ||
CON_ADD_LABLE18 | VARCHAR2 | (240) | ||
CON_ADD_LABLE19 | VARCHAR2 | (240) | ||
CON_ADD_LABLE20 | VARCHAR2 | (240) | ||
CON_ADD_LABLE21 | VARCHAR2 | (240) | ||
CON_ADD_LABLE22 | VARCHAR2 | (240) | ||
CON_ADD_LABLE23 | VARCHAR2 | (240) | ||
CON_ADD_LABLE24 | VARCHAR2 | (240) | ||
CON_ADD_LABLE25 | VARCHAR2 | (240) | ||
CON_ADD_LABLE26 | VARCHAR2 | (240) | ||
CON_ADD_LABLE27 | VARCHAR2 | (240) | ||
CON_ADD_LABLE28 | VARCHAR2 | (240) | ||
CON_ADD_LABLE29 | VARCHAR2 | (240) | ||
CON_ADD_LABLE30 | VARCHAR2 | (240) | ||
CON_ADD_LABLE31 | VARCHAR2 | (240) | ||
CON_ADD_LABLE32 | VARCHAR2 | (240) | ||
CON_ADD_LABLE33 | VARCHAR2 | (240) | ||
CON_ADD_LABLE34 | VARCHAR2 | (240) | ||
CON_ADD_LABLE35 | VARCHAR2 | (240) | ||
CON_ADD_LABLE36 | VARCHAR2 | (240) | ||
CON_ADD_LABLE37 | VARCHAR2 | (240) | ||
CON_ADD_LABLE38 | VARCHAR2 | (240) | ||
CON_ADD_LABLE39 | VARCHAR2 | (240) | ||
CON_ADD_LABLE40 | VARCHAR2 | (240) | ||
CON_ADD_LABLE41 | VARCHAR2 | (240) | ||
CON_ADD_LABLE42 | VARCHAR2 | (240) | ||
CON_ADD_LABLE43 | VARCHAR2 | (240) | ||
CON_ADD_LABLE44 | VARCHAR2 | (240) | ||
CON_ADD_LABLE45 | VARCHAR2 | (240) | ||
CON_ADD_LABLE46 | VARCHAR2 | (240) | ||
ADDRESS_STYLE | VARCHAR2 | (30) | ||
STATUS | VARCHAR2 | (10) | ||
PER_STATUS_DATE | DATE | |||
RECSEQ | VARCHAR2 | (150) | ||
CWK_NUMBER | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, EMPLOYEE_NUMBER
, USER_PERSON_TYPE
, DATE_OF_BIRTH
, TOWN_OF_BIRTH
, COUNTRY_OF_BIRTH
, DATE_OF_DEATH
, ORIGINAL_DATE_OF_HIRE
, EFFECTIVE_START_DATE
, SEX
, MARITAL_STATUS
, FULL_NAME
, PRE_NAME_ADJUNCT
, SUFFIX
, TITLE
, LAST_NAME
, FIRST_NAME
, MIDDLE_NAMES
, ADDRESS_TYPE
, DATE_FROM
, EMAIL_ADDRESS
, PHONE_TYPE
, PHONE_NUMBER
, NATIONALITY
, NATIONAL_IDENTIFIER
, CONTACT_NAME
, RELATIONSHIP
, EMP_JOB_NAME
, EMP_GRADE_NAME
, POSITION_NAME
, EMPLOYMENT_CATEGORY
, NORMAL_HOURS
, ASG_LOCATION
, ASSIGNMENT_STATUS
, DEPARTMENT_NAME
, BUSINESS_GROUP_NAME
, PAYROLL_NAME
, SUPERVISOR_NAME
, PER_ADD_LABLE1
, PER_ADD_LABLE2
, PER_ADD_LABLE3
, PER_ADD_LABLE4
, PER_ADD_LABLE5
, PER_ADD_LABLE6
, PER_ADD_LABLE7
, PER_ADD_LABLE8
, PER_ADD_LABLE9
, PER_ADD_LABLE10
, PER_ADD_LABLE11
, PER_ADD_LABLE12
, PER_ADD_LABLE13
, PER_ADD_LABLE14
, PER_ADD_LABLE15
, PER_ADD_LABLE16
, PER_ADD_LABLE17
, PER_ADD_LABLE18
, PER_ADD_LABLE19
, PER_ADD_LABLE20
, PER_ADD_LABLE21
, PER_ADD_LABLE22
, PER_ADD_LABLE23
, PER_ADD_LABLE24
, PER_ADD_LABLE25
, PER_ADD_LABLE26
, PER_ADD_LABLE27
, PER_ADD_LABLE28
, PER_ADD_LABLE29
, PER_ADD_LABLE30
, PER_ADD_LABLE31
, PER_ADD_LABLE32
, PER_ADD_LABLE33
, PER_ADD_LABLE34
, PER_ADD_LABLE35
, PER_ADD_LABLE36
, PER_ADD_LABLE37
, PER_ADD_LABLE38
, PER_ADD_LABLE39
, PER_ADD_LABLE40
, PER_ADD_LABLE41
, PER_ADD_LABLE42
, PER_ADD_LABLE43
, PER_ADD_LABLE44
, PER_ADD_LABLE45
, PER_ADD_LABLE46
, CON_ADD_LABLE1
, CON_ADD_LABLE2
, CON_ADD_LABLE3
, CON_ADD_LABLE4
, CON_ADD_LABLE5
, CON_ADD_LABLE6
, CON_ADD_LABLE7
, CON_ADD_LABLE8
, CON_ADD_LABLE9
, CON_ADD_LABLE10
, CON_ADD_LABLE11
, CON_ADD_LABLE12
, CON_ADD_LABLE13
, CON_ADD_LABLE14
, CON_ADD_LABLE15
, CON_ADD_LABLE16
, CON_ADD_LABLE17
, CON_ADD_LABLE18
, CON_ADD_LABLE19
, CON_ADD_LABLE20
, CON_ADD_LABLE21
, CON_ADD_LABLE22
, CON_ADD_LABLE23
, CON_ADD_LABLE24
, CON_ADD_LABLE25
, CON_ADD_LABLE26
, CON_ADD_LABLE27
, CON_ADD_LABLE28
, CON_ADD_LABLE29
, CON_ADD_LABLE30
, CON_ADD_LABLE31
, CON_ADD_LABLE32
, CON_ADD_LABLE33
, CON_ADD_LABLE34
, CON_ADD_LABLE35
, CON_ADD_LABLE36
, CON_ADD_LABLE37
, CON_ADD_LABLE38
, CON_ADD_LABLE39
, CON_ADD_LABLE40
, CON_ADD_LABLE41
, CON_ADD_LABLE42
, CON_ADD_LABLE43
, CON_ADD_LABLE44
, CON_ADD_LABLE45
, CON_ADD_LABLE46
, ADDRESS_STYLE
, STATUS
, PER_STATUS_DATE
, RECSEQ
, CWK_NUMBER
FROM HR.HR_360_PERSON_VIEW#;
|
|
|