HR_ASSIGNMNT_VW (SQL View)	Index Back
Assignment View This is a view used to fetch Assignment information for Expiration Inquiry Page.

HR_ASSIGNMNT_VW

(SQL View)

Assignment View

This is a view used to fetch Assignment information for Expiration Inquiry Page.

SELECT DISTINCT A.EMPLID , A.EMPL_RCD , D.BEGIN_DT , F.PER_ORG ,E.NAME ,E.LAST_NAME ,E.SECOND_LAST_SRCH ,E.NAME_AC , D.ASSGN_TYPE , D.END_DT FROM PS_PER_ORG_INST_VW A , PS_JOB_CURR_ALL_VW B , PS_PER_ORG_ASGN_VW C , PS_ASSIGNMENT D , PS_PERSONAL_DATA E , PS_JOB F WHERE A.EMPLID = B.EMPLID AND B.EMPLID = C.EMPLID AND C.EMPLID = D.EMPLID AND D.EMPLID = E.EMPLID AND E.EMPLID = F.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND B.EMPL_RCD = C.EMPL_RCD AND C.EMPL_RCD = F.EMPL_RCD AND C.HOME_HOST_CLASS ='S'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr

3 BEGIN_DT Date(10) DATE NOT NULL Begin Date

4 PER_ORG Character(3) VARCHAR2(3) NOT NULL Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest
Default Value: PER_ORG_ASGN.PER_ORG

5 NAME Character(50) VARCHAR2(50) NOT NULL Name

6 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name

7 SECOND_LAST_SRCH Character(30) VARCHAR2(30) NOT NULL Second Name

8 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name

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

10 END_DT Date(10) DATE NOT NULL end date

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Rcd Nbr
3	BEGIN_DT	Date(10)	DATE NOT NULL	Begin Date
4	PER_ORG	Character(3)	VARCHAR2(3) NOT NULL	Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest. CWR=Contingent Worker EMP=Employee POI=Person of Interest Default Value: PER_ORG_ASGN.PER_ORG
5	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
6	LAST_NAME	Character(30)	VARCHAR2(30) NOT NULL	Last Name
7	SECOND_LAST_SRCH	Character(30)	VARCHAR2(30) NOT NULL	Second Name
8	NAME_AC	Character(50)	VARCHAR2(50) NOT NULL	Alternate Character Name
9	ASSGN_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Assignment Type Prompt Table: ASSGN_TYPE_TBL
10	END_DT	Date(10)	DATE NOT NULL	end date