JOB_TER_ITA_VW (SQL View)	Index Back
End Employment Terms View End Employment Terms View - Contains People who has a Termination (TER) Action and is D - Dead T - Terminated U - Terminated with Pay V - Terminiate with Pension Payout R - Retired Q- Retired with Pay X - Pension Retiree as Status

JOB_TER_ITA_VW

(SQL View)

End Employment Terms View

End Employment Terms View - Contains People who has a Termination (TER) Action and is D - Dead T - Terminated U - Terminated with Pay V - Terminiate with Pension Payout R - Retired Q- Retired with Pay X - Pension Retiree as Status

SELECT EMPLID ,EMPL_RCD ,EFFDT ,EFFSEQ ,ACTION ,ACTION_REASON FROM PS_JOB WHERE EMPL_STATUS IN ('D' ,'T' ,'U' ,'V' ,'R' ,'Q' ,'X') AND ACTION IN ('TER' ,'TWB' ,'TWP' ,'RWP' ,'RET')

# 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
Default Value: %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 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

#	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 Default Value: %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	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code