OPA_DATAMODEL_IDPrompt Table: OPA_DATAMOD_VW
OPA_ENTITY_NAMEGI=Global Input
GO=Global Output
IN=Input
IO=Input/Output
OUT=Output
Prompt Table: OPA_RECDEF_VW
OPA_DMENT_VW(SQL View) |
Index Back |
|---|
| SELECT a.opa_datamodel_id , a.opa_entity_name , a.opa_entity_type , a.recname FROM PSOPA_ENTITY A ,PSOPA_DATAMODEL B WHERE A.opa_datamodel_id=B.opa_datamodel_id AND b.opa_user_defined='N' |
| # | 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_ENTITY_NAME |
Character(50) | VARCHAR2(50) NOT NULL | Entity Name |
| 3 | OPA_ENTITY_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Entity Type
GI=Global Input GO=Global Output IN=Input IO=Input/Output OUT=Output |
| 4 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: OPA_RECDEF_VW |