EX_STGTMPLNG_VW (SQL View)	Index Back
Temp Stage Language View This view is to temporarily select from the EOAW Stage table and language table because SEQ_NBR is not a key in the default language table.

EX_STGTMPLNG_VW

(SQL View)

Temp Stage Language View

This view is to temporarily select from the EOAW Stage table and language table because SEQ_NBR is not a key in the default language table.

SELECT A.EOAWPRCS_ID , A.EOAWDEFN_ID , A.EFFDT , A.EOAWSTAGE_NBR , B.SEQ_NBR , A.LANGUAGE_CD , A.DESCR FROM PS_EOAW_STG_LNG A , PS_EOAW_STAGE B WHERE A.EOAWPRCS_ID = B.EOAWPRCS_ID AND A.EOAWDEFN_ID = B.EOAWDEFN_ID AND A.EOAWSTAGE_NBR = B.EOAWSTAGE_NBR AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_EOAW_STG_LNG A1 WHERE A.EOAWPRCS_ID = A1.EOAWPRCS_ID AND A.EOAWDEFN_ID = A1.EOAWDEFN_ID AND A.EOAWSTAGE_NBR = A1.EOAWSTAGE_NBR AND A1.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOAWPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID

2 EOAWDEFN_ID Character(30) VARCHAR2(30) NOT NULL Approval Framework Definition ID

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

4 EOAWSTAGE_NBR Number(3,0) SMALLINT NOT NULL Approval Framework Stage Number

5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOAWPRCS_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Process ID
2	EOAWDEFN_ID	Character(30)	VARCHAR2(30) NOT NULL	Approval Framework Definition ID
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EOAWSTAGE_NBR	Number(3,0)	SMALLINT NOT NULL	Approval Framework Stage Number
5	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
6	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description