EX_DUR_RG_VW

(SQL View)
 Index Back

Expense Per Diem Range


SELECT A.SETID ,B.RANGE_ID ,B.COUNTRY ,A.RANGE_TYPE , A.RANGE_CATEGORY ,B.FROM_VALUE_1 ,B.TO_VALUE_1 ,B.FROM_VALUE_2 ,B.TO_VALUE_2 ,B.FROM_VALUE_3 ,B.TO_VALUE_3 ,B.FROM_VALUE_4 ,B.TO_VALUE_4 FROM PS_EX_RANGE_TBL A , PS_EX_RANGE_DTL B WHERE A.RANGE_TYPE = 'D' AND A.SETID = B.SETID AND A.RANGE_ID = B.RANGE_ID AND A.RANGE_CATEGORY = B.RANGE_CATEGORY AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_EX_RANGE_DTL C WHERE B.SETID = C.SETID AND B.RANGE_ID = C.RANGE_ID AND B.RANGE_CATEGORY = C.RANGE_CATEGORY AND C.EFF_STATUS = 'A' AND C.EFFDT <= %CurrentDateIn) AND A.EFFDT = ( SELECT MAX(D.EFFDT) FROM PS_EX_RANGE_TBL D WHERE D.SETID = A.SETID AND D.RANGE_ID = A.RANGE_ID AND D.RANGE_CATEGORY = A.RANGE_CATEGORY AND D.EFF_STATUS = 'A' AND D.EFFDT <= %CurrentDateIn)

# 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 RANGE_ID Character(5) VARCHAR2(5) NOT NULL Range ID
3 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

4 RANGE_TYPE Character(1) VARCHAR2(1) NOT NULL Range Type
D=Daily
H=Hourly
5 RANGE_CATEGORY Character(5) VARCHAR2(5) NOT NULL Range Category
6 FROM_VALUE_1 Number(3,0) SMALLINT NOT NULL From Value
7 TO_VALUE_1 Number(3,0) SMALLINT NOT NULL To Value
8 FROM_VALUE_2 Number(3,0) SMALLINT NOT NULL From Value
9 TO_VALUE_2 Number(3,0) SMALLINT NOT NULL To Value
10 FROM_VALUE_3 Number(3,0) SMALLINT NOT NULL From Value
11 TO_VALUE_3 Number(3,0) SMALLINT NOT NULL To Value
12 FROM_VALUE_4 Number(3,0) SMALLINT NOT NULL From Value
13 TO_VALUE_4 Number(3,0) SMALLINT NOT NULL To Value