HR_ADD_REL_VW (SQL View)	Index Back
Work Record Work record used to hold fields that are in common between the PERSONAL_DATA component and the JOB_DATA * and PERS_POI_ADD components.

HR_ADD_REL_VW

(SQL View)

Work Record

Work record used to hold fields that are in common between the PERSONAL_DATA component and the JOB_DATA * and PERS_POI_ADD components.

SELECT A.EMPLID ,A.EMPL_RCD ,B.NAME ,B.LAST_NAME_SRCH ,' ' ,' ' ,' ' FROM PS_PER_ORG_ASGN A , PS_PERSON_NAME B WHERE A.EMPLID = B.EMPLID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON_NAME

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

3 NAME Character(50) VARCHAR2(50) NOT NULL Name

4 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name

5 ORG_INSTANCE_ERN Number(3,0) SMALLINT NOT NULL Indicates which EMPL_RCD (ERN) is considered the Organizational Instance for this particular ERN. An Organizational Instance defines an Instance of Employment or an Instance of Contingent Workforce. Hire, Termination, and Service dates are captured at the Organiational Instance level.

6 POI_TYPE Character(5) VARCHAR2(5) NOT NULL Defines the Transactional usage of POIs in HRMS.
Prompt Table: %EDITTABLE

7 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON_NAME
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
4	LAST_NAME_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Last Name
5	ORG_INSTANCE_ERN	Number(3,0)	SMALLINT NOT NULL	Indicates which EMPL_RCD (ERN) is considered the Organizational Instance for this particular ERN. An Organizational Instance defines an Instance of Employment or an Instance of Contingent Workforce. Hire, Termination, and Service dates are captured at the Organiational Instance level.
6	POI_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines the Transactional usage of POIs in HRMS. Prompt Table: %EDITTABLE
7	PER_ORG	Character(3)	VARCHAR2(3) NOT NULL	Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest. CWR=Contingent Worker EMP=Employee POI=Person of Interest