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 NameField TypeColumn TypeDescription
OPA_DATAMODEL_IDCharacter(40)VARCHAR2(40) NOT NULLData Model ID
OPA_ENTITY_NAMECharacter(50)VARCHAR2(50) NOT NULLEntity Name

Prompt Table: OPA_DMENT_VW

RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).

Prompt Table: OPA_ENTREC_VW

FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).

Prompt Table: OPA_RECFLD_VW

OPA_SEQ_NBRNumber(3,0)SMALLINT NOT NULLSequence Number
OPA_QRYFLTR_OPCharacter(2)VARCHAR2(2) NOT NULLFilter 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_DEFINEDCharacter(1)VARCHAR2(1) NOT NULLUser Defined
N=No
Y=Yes

Default: Y

LAST_UPDATE_DTTMDateTime(26)TIMESTAMPSpecifies 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.ukPeopleTools 8.54
PTRef generated on 09-JUN-19