POS_DESCR2_VW (SQL View)	Index Back
Position View Position Action View created for Approvals

POS_DESCR2_VW

(SQL View)

Position View

Position Action View created for Approvals

SELECT A.POSITION_NBR , A.EFFDT , A.EFFSEQ ,A.DESCR , A.ACTION , A.ACTION_REASON , B.DESCR FROM PS_POSITION_DATA_E A , PS_ACTN_REASON_TBL B WHERE A.ACTION=B.ACTION AND A.ACTION_REASON=B.ACTION_REASON AND B.effdt=( SELECT MAX(EFFDT) FROM PS_ACTN_REASON_TBL C WHERE C.ACTION=B.ACTION AND C.ACTION_REASON=B.ACTION_REASON AND C.ACTION='POS' AND C.EFFDT <= B.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
Default Value: 00000000

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

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

4 TITLE_DESCR1 Character(100) VARCHAR2(100) NOT NULL Title Description

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

6 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code
Prompt Table: ACTN_REASON_TBL

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	POSITION_NBR	Character(8)	VARCHAR2(8) NOT NULL	Position Number Default Value: 00000000
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence
4	TITLE_DESCR1	Character(100)	VARCHAR2(100) NOT NULL	Title Description
5	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Default Value: POS Prompt Table: ACTION_TBL
6	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: ACTN_REASON_TBL
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description