POI_ENE_VW (SQL View)	Index Back
Entitled- Non Employee View of Persons of Interest with the 00011 Type Relationship.

POI_ENE_VW

(SQL View)

Entitled- Non Employee

View of Persons of Interest with the 00011 Type Relationship.

SELECT DISTINCT '00011' , J.EMPLID , %NumToChar(J.EMPL_RCD ) ,J.HR_STATUS ,J.LST_ASGN_START_DT ,J.TERMINATION_DT FROM PS_PER_ORG_ASGN_VW J WHERE J.PER_ORG = 'POI' AND J.POI_TYPE = '00011'

Parent record: PERSON

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 EMPL_RCD_CHAR Character(3) VARCHAR2(3) NOT NULL Empl_rcd# character field

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

5 START_DATE Date(10) DATE Start Date for Gen Standing PO

6 END_DATE Date(10) DATE End Date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	POI_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines the Transactional usage of POIs in HRMS. Prompt Table: POI_TYPE_TBL
2	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
3	EMPL_RCD_CHAR	Character(3)	VARCHAR2(3) NOT NULL	Empl_rcd# character field
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
5	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
6	END_DATE	Date(10)	DATE	End Date