PSOPA_ENTFLDMAP

(SQL Table)
Index Back

OPA Entity Field Mapping

OPA Entity Field Mapping

  • Related Language Record: PSOPA_FDMP_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPA_DATAMODEL_ID Character(40) VARCHAR2(40) NOT NULL Data Model ID
    2 OPA_ENTITY_NAME Character(50) VARCHAR2(50) NOT NULL Entity Name
    3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: OPA_ENTREC_VW

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

    Prompt Table: OPA_RECFLD_VW

    5 OPA_FIELD_TYPE Character(1) VARCHAR2(1) NOT NULL Attribute Type
    B=Input/Output
    I=Input
    O=Output
    6 OPA_SEQ_NBR Number(3,0) SMALLINT NOT NULL Sequence Number
    7 OPA_FIELDNAME Character(36) VARCHAR2(36) NOT NULL OPA Attribute
    8 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    9 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
    10 OPA_ATRRESP_TYPE Character(2) VARCHAR2(2) NOT NULL Response Data Type
    01=value-only
    02=decision-report
    11 OPA_USER_DEFINED Character(1) VARCHAR2(1) NOT NULL User Defined
    N=No
    Y=Yes

    Default Value: Y

    12 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.