PSOPA_ENTKYFLDS

index back

OPA Entity Key Fields

The Fields specified here for each entity will be used in the request XML generation sqls to narrow down the data set.

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

Prompt Table: OPA_DMENT_VW

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_SEQ_NBR Number(3,0) SMALLINT NOT NULL Sequence Number
OPA_QRYFLTR_OP Character(2) VARCHAR2(2) NOT NULL Filter Operator
BW=Between
EQ=Equal To
GE=Greater than or equals
GT=Greater Than
IN=In
LE=Less than or equals
LT=Less Than
NE=Not Equal To
NI=Not In
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