index back

OPA Datamodel Entity mapping

OPA Datamodel Entity mapping

  • Related language record: PSOPA_ENT_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_RECDEF_VW

    OPA_SEQ_NBR Number(3,0) SMALLINT NOT NULL Sequence Number
    OPA_ENTITY_TYPE Character(3) VARCHAR2(3) NOT NULL Entity Type
    GI=Global Input
    GO=Global Output
    DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    OPA_USER_DEFINED Character(1) VARCHAR2(1) NOT NULL User Defined

    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, PeopleTools 8.58
    PTRef generated on 21-DEC-20