PSOPA_ENTFLDMAP | index back |
|---|---|
OPA Entity Field Mapping |
| 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 |