ST_GRP_PARM_TBL

(SQL Table)
 Index Back

Stock Group Parameters Table

Used for stock grant group creation.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 STOCK_ID Character(10) VARCHAR2(10) NOT NULL Company's Stock Identification Symbol
2 ST_GROUP_ID Character(5) VARCHAR2(5) NOT NULL Option Group ID - group of stock options
3 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
4 GROUP_BOOLEAN Character(3) VARCHAR2(3) NOT NULL Boolean for groups
AND=AND
OR=OR

Default Value: AND

5 GROUP_LEFT_PAREN Character(1) VARCHAR2(1) NOT NULL Left Parentheses for groups.
0=
1=(
2=((
3=(((
4=((((
5=(((((

Default Value: 0

6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: ST_GRP_REC_EDIT

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

Prompt Table: ST_GRP_FLD_EDIT

8 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SETID_TBL

9 GROUP_OPERATOR Character(4) VARCHAR2(4) NOT NULL SQL operator for Groups
<=<
<==<=
<>=<>
===
>=>
>==>=
LIKE=LIKE

Default Value: =

10 GROUP_VALUE Character(30) VARCHAR2(30) NOT NULL Value for group selection criteria.

Prompt Table: %GRP_VALUE_EDIT

11 GROUP_RIGHT_PAREN Character(1) VARCHAR2(1) NOT NULL Right parentheses for group selection criteria.
0=
1=)
2=))
3=)))
4=))))
5=)))))

Default Value: 0