RTBL_ERR_ST_M

(SQL View)
 Index Back

SELECT A.SCE_ID ,B.RTBL_ELEMENT ,B.VERSION_NUM ,'' ,B.SETID ,2 ,B.RTBL_ELEMENT_TYPE FROM %Table(RTBL_SCENARIO) A , %Table(RTBL_ELEM_VW) B WHERE A.SCE_ID=B.SCE_ID AND A.ACTIVE_SCENARIO='Y' AND A.STATUS_SCENARIO NOT IN ('RP','RA','RD','RC','RY') AND B.RTBL_ELEMENT_TYPE='M' AND B.LEVEL_NUM=2 UNION SELECT A.SCE_ID ,B.RTBL_ELEMENT ,B.VERSION_NUM ,'' ,B.SETID ,2 ,B.RTBL_ELEMENT_TYPE FROM %Table(RTBL_SCENARIO) A , %Table(RTBL_DEPLOY_HIS) B WHERE A.SCE_ID=B.SCE_ID AND A.ACTIVE_SCENARIO='Y' AND A.STATUS_SCENARIO IN ('RP','RA','RD','RC','RY') AND B.RTBL_ELEMENT_TYPE='M' AND B.LEVEL_NUM=2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SCE_ID Character(10) VARCHAR2(10) NOT NULL ID
2 RTBL_ELEMENT Character(30) VARCHAR2(30) NOT NULL Element name to identify (in peoplesoft) an element along with its label.
3 VERSION_NUM Number(3,0) SMALLINT NOT NULL Version Number
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 SETID Character(5) VARCHAR2(5) NOT NULL SetID
6 LEVEL_NUM Number(3,0) SMALLINT NOT NULL Level
7 RTBL_ELEMENT_TYPE Character(1) VARCHAR2(1) NOT NULL Element name to identify (in peoplesoft) an element along with its label.
A=Allocation
C=Close Ledgers
J=Journal
M=Multi-currency
U=User Defined