GP_POI_VW (SQL View)	Index Back
GP Persons of Interests Payees View of Persons of Interest with the 00005 Type Relationship - GP Payees

GP_POI_VW

(SQL View)

GP Persons of Interests Payees

View of Persons of Interest with the 00005 Type Relationship - GP Payees

SELECT DISTINCT '00005' ,A.EMPLID ,%Sql(FUNCLIB_HR_CHAR,(A.EMPL_RCD)) ,J.HR_STATUS ,J.LST_ASGN_START_DT ,J.TERMINATION_DT FROM PS_JOB A , PS_PER_ORG_ASGN_VW J WHERE A.EMPLID = J.EMPLID AND A.EMPL_RCD = J.EMPL_RCD AND J.PER_ORG = 'POI' AND A.PAY_SYSTEM_FLG = 'GP' AND A.EFFDT = J.EFFDT_NOKEY AND A.EFFSEQ = J.EFFSEQ_NOKEY AND J.POI_TYPE = '00005'

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