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 NameField TypeColumn TypeDescription
OPA_DATAMODEL_IDCharacter(40)VARCHAR2(40) NOT NULLData Model ID

Prompt Table: OPA_DATAMOD_VW

OPA_ENTITY_NAMECharacter(50)VARCHAR2(50) NOT NULLEntity Name
OPA_ENTITY_TYPECharacter(3)VARCHAR2(3) NOT NULLEntity Type
GI=Global Input
GO=Global Output
IN=Input
IO=Input/Output
OUT=Output
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).

Prompt Table: OPA_RECDEF_VW

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19