ASSGN_VLD_DTS (SQL View)	Index Back
Host Valid Assign Dates

ASSGN_VLD_DTS

(SQL View)

Host Valid Assign Dates

SELECT DISTINCT A.EMPLID , %Sql(HR_CHARTOINT,B.HOME_HOST_EMPL_RCD) , A.END_DT , 'B' , A.BEGIN_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 END_DT Date(10) DATE NOT NULL end date

4 HR_BEGIN_DT_TXT Character(20) VARCHAR2(20) NOT NULL Choose an Existing Assignment

5 BEGIN_DT Date(10) DATE NOT NULL Begin Date

6 ASSGN_TYPE Character(3) VARCHAR2(3) NOT NULL Assignment Type
Prompt Table: ASSGN_TYPE_TBL

#	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	END_DT	Date(10)	DATE NOT NULL	end date
4	HR_BEGIN_DT_TXT	Character(20)	VARCHAR2(20) NOT NULL	Choose an Existing Assignment
5	BEGIN_DT	Date(10)	DATE NOT NULL	Begin Date
6	ASSGN_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Assignment Type Prompt Table: ASSGN_TYPE_TBL