DBA Data[Home] [Help] [Dependency Information]

TABLE: HR.HR_360_PERSON_VIEW

Object Details
Object Name: HR_360_PERSON_VIEW
Object Type: TABLE
Owner: HR
Subobject Name:
Status: VALID


HR_360_PERSON_VIEW is the table that holds the information to be delivered in the 360 Response message for the 360 degree view request in HR HelpDesk.The 360 Response XML message is genertaed with this information in the XML Gateway.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID VARCHAR2 (1000)
Transaction Id from the 360 view Request message.
EMPLOYEE_NUMBER VARCHAR2 (30)
Employee Number.
USER_PERSON_TYPE VARCHAR2 (60)
User Person Type eg Employee,Ex-Employee .
DATE_OF_BIRTH DATE

Date Of Birth.
TOWN_OF_BIRTH VARCHAR2 (90)
Town Of Birth.
COUNTRY_OF_BIRTH VARCHAR2 (90)
Country Of Birth.
DATE_OF_DEATH DATE

Date Of Death.
ORIGINAL_DATE_OF_HIRE DATE

Original Date Of Hire.
EFFECTIVE_START_DATE DATE

Effective Start Date.
SEX VARCHAR2 (30)
Sex.
MARITAL_STATUS VARCHAR2 (30)
Marital Status.
FULL_NAME VARCHAR2 (240)
Concatenation of last name, title, first name, middle names and the name the person is known by.
PRE_NAME_ADJUNCT VARCHAR2 (30)
Name Prefix.
SUFFIX VARCHAR2 (30)
Suffix after the surname eg Sr.,Jr.,III.
TITLE VARCHAR2 (30)
Title Eg Mr.,Mrs.,Dr.
LAST_NAME VARCHAR2 (150)
Last name of the person, (surname, family name).
FIRST_NAME VARCHAR2 (150)
First Name of the Person.
MIDDLE_NAMES VARCHAR2 (90)
Middle names.
ADDRESS_TYPE VARCHAR2 (30)
Address type, for example, home, business, weekend.
DATE_FROM DATE

Start date at the address.
EMAIL_ADDRESS VARCHAR2 (240)
Holds actual email identifier.
PHONE_TYPE VARCHAR2 (30)
Phone Type.
PHONE_NUMBER VARCHAR2 (60)
Telephone Number in any format.
NATIONALITY VARCHAR2 (30)
Nationality.
NATIONAL_IDENTIFIER VARCHAR2 (30)
Number by which a person is identified in a given legislation.
CONTACT_NAME VARCHAR2 (240)
Name of the Primary Contact .
RELATIONSHIP VARCHAR2 (30)
Relationship of the Primary Contact .
EMP_JOB_NAME VARCHAR2 (700)
Name of the Job.
EMP_GRADE_NAME VARCHAR2 (240)
Name of the Grade.
POSITION_NAME VARCHAR2 (240)
Name of the Position.
EMPLOYMENT_CATEGORY VARCHAR2 (30)
User defined category. For example Full-Time Permanent or Part-Time Permanent. Known as Assignment Category.
NORMAL_HOURS NUMBER

Normal working hours.
ASG_LOCATION VARCHAR2 (60)
Assignment Location.
ASSIGNMENT_STATUS VARCHAR2 (80)
Assignment Status.
DEPARTMENT_NAME VARCHAR2 (240)
Name of the Department.
BUSINESS_GROUP_NAME VARCHAR2 (240)
Name of the Business Group.
PAYROLL_NAME VARCHAR2 (80)
Name of the Payroll.
SUPERVISOR_NAME VARCHAR2 (240)
Name of the Supervisor.
PER_ADD_LABLE1 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE2 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE3 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE4 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE5 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE6 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE7 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE8 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE9 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE10 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE11 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE12 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE13 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE14 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE15 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE16 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE17 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE18 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE19 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE20 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE21 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE22 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE23 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE24 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE25 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE26 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE27 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE28 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE29 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE30 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE31 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE32 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE33 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE34 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE35 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE36 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE37 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE38 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE39 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE40 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE41 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE42 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE43 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE44 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE45 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
PER_ADD_LABLE46 VARCHAR2 (240)
Column to store Employee or Contingent worker Address Label and Data.
CON_ADD_LABLE1 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE2 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE3 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE4 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE5 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE6 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE7 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE8 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE9 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE10 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE11 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE12 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE13 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE14 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE15 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE16 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE17 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE18 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE19 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE20 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE21 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE22 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE23 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE24 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE25 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE26 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE27 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE28 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE29 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE30 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE31 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE32 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE33 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE34 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE35 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE36 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE37 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE38 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE39 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE40 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE41 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE42 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE43 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE44 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE45 VARCHAR2 (240)
Column to store Contact Address Label and Data.
CON_ADD_LABLE46 VARCHAR2 (240)
Column to store Contact Address Label and Data.
ADDRESS_STYLE VARCHAR2 (30)
Address style .
STATUS VARCHAR2 (10)
Status of the 360 Response Message eg Queued,Sent
PER_STATUS_DATE DATE

Date of queued status of the 360 Response Message
RECSEQ VARCHAR2 (150)
Record Sequence
CWK_NUMBER VARCHAR2 (30)
Contingent Worker Number.
Query Text

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;

Dependencies

[top of page]

HR.HR_360_PERSON_VIEW does not reference any database object

HR.HR_360_PERSON_VIEW is referenced by following:

SchemaAPPS
SynonymHR_360_PERSON_VIEW