JOB_ACTION_VW (SQL View)	Index Back
Job - Action view This view joins Job and Action table for the Action Type attribute (delivered as Voluntary/Involuntary)..

JOB_ACTION_VW

(SQL View)

Job - Action view

This view joins Job and Action table for the Action Type attribute (delivered as Voluntary/Involuntary)..

SELECT JOB.EMPLID ,JOB.EMPL_RCD ,JOB.EFFDT ,JOB.EFFSEQ ,JOB.ACTION ,ACT.HR_ACTION_TYPE FROM PS_JOB JOB ,PS_ACTION_TBL ACT WHERE JOB.ACTION = ACT.ACTION AND ACT.EFF_STATUS = 'A' AND ACT.EFFDT = ( SELECT MAX(ACT1.EFFDT) FROM PS_ACTION_TBL ACT1 WHERE ACT1.ACTION = ACT.ACTION AND ACT1.EFFDT <= JOB.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

3 EFFDT Date(10) DATE Effective Date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

5 ACTION Character(3) VARCHAR2(3) NOT NULL Action
Prompt Table: ACTION_TBL

6 HR_ACTION_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Action or Action Reason
I=Involuntary
V=Voluntary

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	EFFDT	Date(10)	DATE	Effective Date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
5	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
6	HR_ACTION_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Type of Action or Action Reason I=Involuntary V=Voluntary