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 |
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 | Field Type | Column Type | Description |
|---|---|---|---|
| OPA_DATAMODEL_ID |
Character(40) | VARCHAR2(40) NOT NULL |
Data Model ID
Prompt Table: OPA_DATAMOD_VW |
| OPA_ENTITY_NAME |
Character(50) | VARCHAR2(50) NOT NULL | Entity Name |
| OPA_ENTITY_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Entity Type
GI=Global Input GO=Global Output IN=Input IO=Input/Output OUT=Output |
| RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: OPA_RECDEF_VW |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |