RUN_CNTL_EM_DTL

(SQL Table)
Index Back

CC Budget Processor Request

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

Default Value: RUN_CNTL_EM.OPRID

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

Default Value: RUN_CNTL_EM.RUN_CNTL_ID

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

Prompt Table: EM_OPTION_VW

4 EM_FIELD_TYPE Character(1) VARCHAR2(1) NOT NULL Field Type
B=Buyer
S=Seller
5 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SP_SETID_NONVW

6 EM_OPTION_TYPE Character(1) VARCHAR2(1) NOT NULL Value Type
A=All
R=Range
V=Value
7 OPTION_VALUE_1 Character(30) VARCHAR2(30) NOT NULL Option Value Field #1

Prompt Table: %EDITTABLE

8 OPTION_VALUE_2 Character(30) VARCHAR2(30) NOT NULL Option Value Field #2

Prompt Table: %EDITTABLE