CURR_STPALL_VW (SQL View)	Index Back
MultiCurrency Steps No Effdt All MultiCurrency Steps without effective-dating. For multiple effective-dated rows, the view will list the one with the latest Effective Date.

CURR_STPALL_VW

(SQL View)

MultiCurrency Steps No Effdt

All MultiCurrency Steps without effective-dating. For multiple effective-dated rows, the view will list the one with the latest Effective Date.

SELECT A.SETID , A.CURR_STEP , A.VERSION_NUM FROM PS_CURR_STEP_TBL A WHERE A.STEP_TYPE = 'R'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 CURR_STEP Character(10) VARCHAR2(10) NOT NULL Process Step

3 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number