PSOPA_ENT_REL

index back

Entity Relationship


  • Related language record: PSOPA_REL_LANG
  • 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_SEQ_NBRNumber(3,0)SMALLINT NOT NULLSequence Number
    OPA_ENTREL_NAMECharacter(50)VARCHAR2(50) NOT NULLRelationship Name
    OPA_ENT_REL_TYPECharacter(3)VARCHAR2(3) NOT NULLEntity Relationship Type
    11=One To One
    1M=One To Many
    M1=Many To One
    MM=Many To Many
    DESCR254Character(254)VARCHAR2(254) NOT NULLDescription of length 254
    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