HCR_PER_SUM_VW (SQL View)	Index Back
Person Org Summary View Person Org Summary View for Fluid Job Org relation

HCR_PER_SUM_VW

(SQL View)

Person Org Summary View

Person Org Summary View for Fluid Job Org relation

SELECT A.EMPLID ,A.EMPL_RCD , A.PER_ORG , A.ORG_INSTANCE_ERN ,A.HOME_HOST_CLASS ,A.HR_STATUS ,A.EMPL_STATUS ,A.LAST_HIRE_DT ,A.TERMINATION_DT FROM PS_PER_ASGN_EMP_VW A UNION SELECT B.EMPLID ,B.EMPL_RCD , B.PER_ORG , B.ORG_INSTANCE_ERN ,B.HOME_HOST_CLASS ,B.HR_STATUS ,B.EMPL_STATUS ,B.LAST_HIRE_DT ,B.TERMINATION_DT FROM PS_PER_ASGN_CWR_VW B UNION SELECT A.EMPLID ,A.EMPL_RCD , A.PER_ORG , A.ORG_INSTANCE_ERN ,A.HOME_HOST_CLASS ,B.HR_STATUS ,B.EMPL_STATUS ,B.HIRE_DT ,( SELECT MAX(K.TERMINATION_DT) FROM PS_JOB K WHERE K.EMPLID=B.EMPLID AND K.EMPL_RCD=B.EMPL_RCD AND TERMINATION_DT IS NOT NULL ) FROM PS_PER_ORG_ASGN A ,PS_JOB B WHERE A.EMPLID=B.EMPLID AND A.EMPL_RCD=B.EMPL_RCD AND B.ACTION ='POI'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

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

3 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
Default Value: PER_ORG_INST.PER_ORG
Prompt Table: PER_ORG_VW

4 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.
Default Value: PER_ORG_INST.ORG_INSTANCE_ERN
Prompt Table: PER_ORG_INST

5 HOME_HOST_CLASS Character(1) VARCHAR2(1) NOT NULL Home/Host Classification
M=Home
S=Host

6 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
A=Active
I=Inactive

7 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration

8 HIRE_DT Date(10) DATE First Start Date

9 TERMINATION_DT Date(10) DATE Termination Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record Default Value: 0
3	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 Default Value: PER_ORG_INST.PER_ORG Prompt Table: PER_ORG_VW
4	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. Default Value: PER_ORG_INST.ORG_INSTANCE_ERN Prompt Table: PER_ORG_INST
5	HOME_HOST_CLASS	Character(1)	VARCHAR2(1) NOT NULL	Home/Host Classification M=Home S=Host
6	HR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	HR Status A=Active I=Inactive
7	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
8	HIRE_DT	Date(10)	DATE	First Start Date
9	TERMINATION_DT	Date(10)	DATE	Termination Date