PSOPA_ENTFLDMAP |
index back |
---|---|
OPA Entity Field Mapping |
PeopleSoft Field Name | Field Type | Column Type | Description |
---|---|---|---|
![]() |
Character(40) | VARCHAR2(40) NOT NULL | Data Model ID |
![]() |
Character(50) | VARCHAR2(50) NOT NULL | Entity Name |
![]() |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: OPA_ENTREC_VW |
![]() |
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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |