RTBL_ERR_SCE_ST

(SQL View)
 Index Back

SELECT A.SCE_ID ,C.PROCESS_STEP AS RTBL_ELEMENT ,C.VERSION_NUM ,'' ,B.SETID FROM %Table(RTBL_SCENARIO) A , %Table(RTBL_ELEMENT) B , %Table(ALLOC_GRSTP_TBL) C WHERE A.SCE_ID=B.SCE_ID AND B.RTBL_ELEMENT=C.PROCESS_GROUP AND B.VERSION_NUM=C.VERSION_GRP AND A.STATUS_SCENARIO NOT IN ('RP','RA','RD','RC','RY') UNION SELECT A.SCE_ID ,B.RTBL_ELEMENT ,B.VERSION_NUM ,'' ,B.SETID FROM %Table(RTBL_SCENARIO) A , %Table(RTBL_DEPLOY_HIS) B WHERE A.SCE_ID=B.SCE_ID AND A.STATUS_SCENARIO IN ('RP','RA','RD','RC','RY')

# 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