OPA_DATAMODEL_IDPrompt Table: OPA_DATAMOD_VW
OPA_RULEBASE_IDN=No
Y=Yes
Default Value: Y
PSOPA_ARTIFACTS(SQL Table) |
Index Back |
|---|---|
OPA AttachmentsOPA Attachments |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPA_DATAMODEL_ID |
Character(40) | VARCHAR2(40) NOT NULL |
Data Model ID
Prompt Table: OPA_DATAMOD_VW |
| 2 | OPA_RULEBASE_ID |
Character(50) | VARCHAR2(50) NOT NULL | Rule Base ID |
| 3 | OPA_RBASE_SYSFILE | Character(128) | VARCHAR2(128) NOT NULL | Rulebase Sys Filename |
| 4 | OPA_RBASE_FILENAME | Character(64) | VARCHAR2(64) NOT NULL | Rulebase File Name |
| 5 | OPA_RPRJ_SYSFILE | Character(128) | VARCHAR2(128) NOT NULL | Rule Project Sys Filename |
| 6 | OPA_RPRJ_FILENAME | Character(64) | VARCHAR2(64) NOT NULL | Rules Project File Nam |
| 7 | LAST_UPDATE_DTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 8 | OPA_USER_DEFINED | Character(1) | VARCHAR2(1) NOT NULL |
User Defined
N=No Y=Yes Default Value: Y |