ERROR_IDSEQ_NUMRB_ER_ACTLST_VW(SQL View) |
Index Back |
|---|---|
RB_ER_ACTLST_VWRB_ER_ACTLST_VW.................. |
| SELECT A.ERROR_ID ,B.SEQ_NUM , B.ORDER_BY_SEQ ,A.DESCR100 , C.APPCLASSID , C.APPCLASS_PATH , A.IBEM_REASON_CD ,A.NOFITY00_ADDR ,C.NOFITY01_ADDR FROM PS_RB_STAT_ACT_GRP A ,PS_RB_ACT_LIST_DFN B ,PS_RB_ACT_DEFN C WHERE A.ACTION_GROUP=B.ACTION_GROUP AND B.ACTIVE_FLAG='A' AND B.ACTION_ID=C.ACTION_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ERROR_ID |
Number(9,0) | DECIMAL(9) NOT NULL | Error ID |
| 2 | SEQ_NUM |
Number(3,0) | SMALLINT NOT NULL | Sequence |
| 3 | ORDER_BY_SEQ | Number(2,0) | SMALLINT NOT NULL | Order by Sequence |
| 4 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
| 5 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL | Application Class ID |
| 6 | APPCLASS_PATH | Character(254) | VARCHAR2(254) NOT NULL | Application Class Full Path |
| 7 | REASON_CODE | Character(3) | VARCHAR2(3) NOT NULL | Reason Code |
| 8 | NOFITY00_ADDR | Long Character | CLOB | Notify Address |
| 9 | NOFITY01_ADDR | Long Character | CLOB | Notify Address |