PSOPA_ENT_REL

index back

Entity Relationship


  • Related language record: PSOPA_REL_LANG
  • 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_SEQ_NBR Number(3,0) SMALLINT NOT NULL Sequence Number
    OPA_ENTREL_NAME Character(50) VARCHAR2(50) NOT NULL Relationship Name
    OPA_ENT_REL_TYPE Character(3) VARCHAR2(3) NOT NULL Entity Relationship Type
    11=One To One
    1M=One To Many
    M1=Many To One
    MM=Many To Many
    DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    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 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20