SCE_IDRTBL_GROUPRTBL_STEPRTBL_STP_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT a.SCE_ID , a.RTBL_ELEMENT AS RTBL_GROUP , b.RTBL_ELEMENT AS RTBL_STEP FROM %Table(RTBL_DEPLOYMENT) a , %Table(RTBL_DEPLOYMENT) b WHERE a.SCE_ID=b.SCE_ID AND a.SEQNBR=b.SEQNBR AND a.LEVEL_NUM=1 AND a.LEVEL1=b.LEVEL1 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_GROUP |
Character(30) | VARCHAR2(30) NOT NULL | Element name to identify (in peoplesoft) an element along with its label. |
| 3 | RTBL_STEP |
Character(30) | VARCHAR2(30) NOT NULL | Element name to identify (in peoplesoft) an element along with its label. |