PER_ORG_INST_VW (SQL View)	Index Back
ORG ASGNS by INST View of all Assignments by Organizational Instance

PER_ORG_INST_VW

(SQL View)

ORG ASGNS by INST

View of all Assignments by Organizational Instance

SELECT A.EMPLID ,A.ORG_INSTANCE_ERN ,B.EMPL_RCD FROM PS_PER_ORG_INST A , PS_PER_ORG_ASGN B WHERE A.EMPLID = B.EMPLID AND A.ORG_INSTANCE_ERN = B.ORG_INSTANCE_ERN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 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.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	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.
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record