PSPTDEFSECINRL

index back

Definition Group Inclusion Rul

Definition Group Inclusion Rules

PeopleSoft Field Name Field Type Column Type Description
OBJGROUPID Character(18) VARCHAR2(18) NOT NULL Object Group ID
OBJNAME Character(30) VARCHAR2(30) NOT NULL Object Name

Default: PSPTDEFSEC_WRK.OBJNAME

SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
SEQNO2 Number(3,0) SMALLINT NOT NULL Sequence Number
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Default: APP_DES_OBJECTS.RECNAME

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

Prompt Table: PSPTDBFLDLABL_V

PTBINDTYPE Character(3) VARCHAR2(3) NOT NULL Operation
!==!=
<=<
<==<=
===
>=>
>==>=
AL=All
BT=Between
IN=In
LK=Like

Default: AL

SQLTEXT Long Character(14000) CLOB SQL Statement Text
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19