PTAFCRTA_VAL

index back

User List Definition

Maps User List to sources or user list data e.g. roles, queries, application classes & SQL Definitions.

PeopleSoft Field Name Field Type Column Type Description
PTAFCRTA_ID Character(100) VARCHAR2(100) NOT NULL Criteria ID
SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: RECDEFN_VW

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

Prompt Table: PSRECFIELDALL

PTAFCRTA_VAL1 Character(100) VARCHAR2(100) NOT NULL Criteria Value 1
PTAFCRTA_OPERATOR Character(3) VARCHAR2(3) NOT NULL Criteria Operator
<=Less Than
<>=Not Equal To
==Equals
>=Greater Than
B=Between
NN=Is Not Blank
NU=Is Blank
PTAFCRTA_VAL2 Character(100) VARCHAR2(100) NOT NULL Criteria Value 2
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19