PSOPA_ENTFLDMAP

index back

OPA Entity Field Mapping

OPA Entity Field Mapping

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

    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: OPA_RECFLD_VW

    OPA_FIELD_TYPE Character(1) VARCHAR2(1) NOT NULL Attribute Type
    B=Input/Output
    I=Input
    O=Output
    OPA_SEQ_NBR Number(3,0) SMALLINT NOT NULL Sequence Number
    OPA_FIELDNAME Character(36) VARCHAR2(36) NOT NULL OPA Attribute
    DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    OPA_ATRREQ_TYPE Character(2) VARCHAR2(2) NOT NULL Attribute Data Type
    01=Number
    02=Date
    03=Text
    04=Boolean
    05=Date Time
    06=Time
    07=Currency
    OPA_ATRRESP_TYPE Character(2) VARCHAR2(2) NOT NULL Response Data Type
    01=value-only
    02=decision-report
    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 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19