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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19