PSOPA_ENTRELATR

index back

Entity Relationship Attributes


PeopleSoft Field Name Field Type Column Type Description
OPA_DATAMODEL_ID Character(40) VARCHAR2(40) NOT NULL Data Model ID
OPA_ENTITY_NAME Character(50) VARCHAR2(50) NOT NULL Entity Name
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: OPA_ENTREC_VW

OPA_DSTENTITY_NAME Character(50) VARCHAR2(50) NOT NULL Target Entity

Prompt Table: OPA_DMENT_VW

OPA_TGT_ATTRNAME Character(36) VARCHAR2(36) NOT NULL Target Attribute

Prompt Table: OPA_ENTATTR_VW

OPA_SEQ_NBR Number(3,0) SMALLINT NOT NULL Sequence Number
OPA_USER_DEFINED Character(1) VARCHAR2(1) NOT NULL User Defined
N=No
Y=Yes

Default: Y

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.
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19