AE_REQUEST_OPT

(SQL Table)
Index Back

AE Request Options

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: PSOPRDEFN

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number
4 AE_BIND_VAR Character(18) VARCHAR2(18) NOT NULL Bind Variable Name

Prompt Table: AE_CACHE_FLD_VW

5 OPTION_VALUE_TYPE Character(1) VARCHAR2(1) NOT NULL Option Value Type
S=Some
V=Value

Default Value: V

6 OPTION_VALUE_1 Character(30) VARCHAR2(30) NOT NULL Option Value Field #1
7 OPTION_VALUE_2 Character(30) VARCHAR2(30) NOT NULL Option Value Field #2