RTBL_CLOSEST_VW

(SQL View)

SELECT SCE.SCE_ID , STP.SETID , STP.CLOSE_GRP_ID , stp.version_grp , STP.CLOSING_TYPE , STP.CLOSING_SET , STP.version_NUM , STP.CLOSE_STEP FROM PS_CLOSE_GRP_STEP STP , PS_RTBL_SCENARIO SCE , PS_CLOSE_DEFN_TBL A WHERE STP.SETID = A.SETID AND STP.CLOSING_SET = A.CLOSING_SET AND STP.CLOSING_TYPE = A.CLOSING_TYPE AND STP.VERSION_NUM = A.VERSION_NUM AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_CLOSE_DEFN_TBL A_ED WHERE A_ED.SETID = A.SETID AND A_ED.CLOSING_SET = A.CLOSING_SET AND A_ED.VERSION_NUM = A.VERSION_NUM AND A_ED.CLOSING_TYPE = A.CLOSING_TYPE AND A_ED.EFF_STATUS = 'A' AND A_ED.EFFDT <= SCE.ASOFDATE2 ) ORDER BY STP.CLOSE_STEP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCE_ID Character(10) VARCHAR2(10) NOT NULL ID

2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

3 CLOSE_GRP_ID Character(20) VARCHAR2(20) NOT NULL Closing Process Group

4 VERSION_GRP Number(3,0) SMALLINT NOT NULL Group Version

5 CLOSING_TYPE Character(1) VARCHAR2(1) NOT NULL Closing Type
I=Interim
Y=Year End

6 CLOSING_SET Character(20) VARCHAR2(20) NOT NULL Closing Rule

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

8 CLOSE_STEP Number(3,0) SMALLINT NOT NULL Closing Step

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCE_ID	Character(10)	VARCHAR2(10) NOT NULL	ID
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	CLOSE_GRP_ID	Character(20)	VARCHAR2(20) NOT NULL	Closing Process Group
4	VERSION_GRP	Number(3,0)	SMALLINT NOT NULL	Group Version
5	CLOSING_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Closing Type I=Interim Y=Year End
6	CLOSING_SET	Character(20)	VARCHAR2(20) NOT NULL	Closing Rule
7	VERSION_NUM	Number(3,0)	SMALLINT NOT NULL	Version Number
8	CLOSE_STEP	Number(3,0)	SMALLINT NOT NULL	Closing Step