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

POS_ACTION_VW

(SQL View)

Position View

Position Action View created for Approvals

SELECT A.POSITION_NBR , A.EFFDT , A.EFFSEQ , 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 ACTION Character(3) VARCHAR2(3) NOT NULL Action
Default Value: POS
Prompt Table: ACTION_TBL

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

6 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	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Default Value: POS Prompt Table: ACTION_TBL
5	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: ACTN_REASON_TBL
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description