RO_TYPE_ADEV_VW(SQL View) |
Index Back |
|---|---|
Data Element Events ViewThis recod keeps the deatils on Data Element Events |
| SELECT A.SETID , A.CAPTURE_TYPE_CD , A.AUDITEVENT , A.ENABLED , A.RO_CONDITION_ID , A.MESSAGE_NBR , A.MESSAGE_SET_NBR , A.MSG_TXT_OR_EXPLAIN , A.SEQ_NUM , %subrec(rb_appclass_sb2,B) FROM %Table(RO_TYPE_ADEVENT) A , %Table(RO_DEFN_DATAELM) B WHERE A.SETID=B.SETID AND A.UID20F=B.UID20 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Prompt Table: SP_SETID_NONVW |
| 2 | CAPTURE_TYPE_CD |
Character(4) | VARCHAR2(4) NOT NULL |
Capture Type
QUO=Quote SO=Order |
| 3 | AUDITEVENT | Character(30) | VARCHAR2(30) NOT NULL | Defines a routing event for PS Workflow |
| 4 | ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
A flag indicates whether this row is enabled or not.
Y/N Table Edit Default Value: Y |
| 5 | RO_CONDITION_ID | Number(31,0) | DECIMAL(31) NOT NULL | the unique identifier for a phrase definition (ignoring versioning) |
| 6 | MESSAGE_NBR | Number(5,0) | INTEGER NOT NULL |
Message Number. This field refers to the Message Number in the Message Catalog.
Prompt Table: PSMSGCATDEFN |
| 7 | MESSAGE_SET_NBR | Number(5,0) | INTEGER NOT NULL |
Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Prompt Table: PSMSGSETDEFN |
| 8 | MSG_TXT_OR_EXPLAIN | Character(1) | VARCHAR2(1) NOT NULL |
Message Text
E=Explanation T=Text Default Value: E |
| 9 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL |
Sequence
Default Value: 10 |
| 10 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table: RBC_APPCLASS_VW |
| 11 | APPCLASS_PATH | Character(254) | VARCHAR2(254) NOT NULL |
Application Class Full Path
Prompt Table: RBC_APPRTPATH_V |