PSOPA_ENTFLDMAP

index back

OPA Entity Field Mapping

OPA Entity Field Mapping

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

    FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).

    Prompt Table: OPA_RECFLD_VW

    OPA_FIELD_TYPECharacter(1)VARCHAR2(1) NOT NULLAttribute Type
    B=Input/Output
    I=Input
    O=Output
    OPA_SEQ_NBRNumber(3,0)SMALLINT NOT NULLSequence Number
    OPA_FIELDNAMECharacter(36)VARCHAR2(36) NOT NULLOPA Attribute
    DESCR254Character(254)VARCHAR2(254) NOT NULLDescription of length 254
    OPA_ATRREQ_TYPECharacter(2)VARCHAR2(2) NOT NULLAttribute Data Type
    01=Number
    02=Date
    03=Text
    04=Boolean
    05=Date Time
    06=Time
    07=Currency
    OPA_ATRRESP_TYPECharacter(2)VARCHAR2(2) NOT NULLResponse Data Type
    01=value-only
    02=decision-report
    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