ASSGN_VLD_VW (SQL View)	Index Back
Host Valid Dates Host Valid Dates

ASSGN_VLD_VW

(SQL View)

Host Valid Dates

SELECT DISTINCT A.EMPLID , %Sql(HR_CHARTOINT,B.HOME_HOST_EMPL_RCD) , A.BEGIN_DT , A.END_DT , A.ASSGN_TYPE FROM PS_ASSIGNMENT A , PS_ASGN_HOME_HOST B WHERE A.EMPLID = B.EMPLID AND A.BEGIN_DT = B.BEGIN_DT AND B.HOME_HOST = '0'

# 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 BEGIN_DT Date(10) DATE Begin Date

4 END_DT Date(10) DATE end date

5 ASSGN_TYPE Character(3) VARCHAR2(3) NOT NULL Assignment Type

#	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	BEGIN_DT	Date(10)	DATE	Begin Date
4	END_DT	Date(10)	DATE	end date
5	ASSGN_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Assignment Type