PSOPA_ENTRELATR

index back

Entity Relationship Attributes


PeopleSoft Field NameField TypeColumn TypeDescription
OPA_DATAMODEL_IDCharacter(40)VARCHAR2(40) NOT NULLData Model ID
OPA_ENTITY_NAMECharacter(50)VARCHAR2(50) NOT NULLEntity Name
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).

Prompt Table: OPA_ENTREC_VW

OPA_DSTENTITY_NAMECharacter(50)VARCHAR2(50) NOT NULLTarget Entity

Prompt Table: OPA_DMENT_VW

OPA_TGT_ATTRNAMECharacter(36)VARCHAR2(36) NOT NULLTarget Attribute

Prompt Table: OPA_ENTATTR_VW

OPA_SEQ_NBRNumber(3,0)SMALLINT NOT NULLSequence Number
OPA_USER_DEFINEDCharacter(1)VARCHAR2(1) NOT NULLUser Defined
N=No
Y=Yes

Default: Y

LAST_UPDATE_DTTMDateTime(26)TIMESTAMPSpecifies 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.ukPeopleTools 8.54
PTRef generated on 09-JUN-19