RO_TYPE_DEEV_VW(SQL View) |
Index Back |
|---|---|
Data Element Events ViewThis record is a view used for Data Element Events View |
| SELECT A.SETID , A.CAPTURE_TYPE_CD , A.ENABLED , A.MAINTEVENT , A.RO_ELEMENT_TYPE , A.RO_CONDITION_ID , A.SEQ_NUM , %subrec(rb_appclass_sb2,B) FROM %Table(RO_TYPE_DEEVENT) 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 | ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
A flag indicates whether this row is enabled or not.
Y/N Table Edit Default Value: Y |
| 4 | MAINTEVENT | Character(30) | VARCHAR2(30) NOT NULL | Defines a routing event for PS Workflow |
| 5 | RO_ELEMENT_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Used to determine the type of data element for use in maintenance and auditing.
HDEX=Header Level Exclusive HEAD=Header Level LINE=Line Level LNST=Line Status Level MTEN=Maintenance Enabler Default Value: HEAD |
| 6 | RO_CONDITION_ID | Number(31,0) | DECIMAL(31) NOT NULL | the unique identifier for a phrase definition (ignoring versioning) |
| 7 | SEQ_NUM | Number(3,0) | SMALLINT NOT NULL |
Sequence
Default Value: 10 |
| 8 | APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL |
Application Class ID
Prompt Table: RBC_APPCLASS_VW |
| 9 | APPCLASS_PATH | Character(254) | VARCHAR2(254) NOT NULL |
Application Class Full Path
Prompt Table: RBC_APPRTPATH_V |