PSOPA_ENTITY

index back

OPA Datamodel Entity mapping

OPA Datamodel Entity mapping

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

    OPA_SEQ_NBRNumber(3,0)SMALLINT NOT NULLSequence Number
    OPA_ENTITY_TYPECharacter(3)VARCHAR2(3) NOT NULLEntity Type
    GI=Global Input
    GO=Global Output
    IN=Input
    IO=Input/Output
    OUT=Output
    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