RC_REL_SOL_RUN

(SQL Table)
Index Back

Solution Usage Run Control

This run control record is used for the Update Solution Usage counts.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 SOLUTION_USAGE_RNG Character(1) VARCHAR2(1) NOT NULL Solution Usage Range
A=All
R=Date Range Specified

Default Value: A

4 FROM_DATE Date(10) DATE From Date
5 TO_DATE Date(10) DATE To Date
6 RB_SCORE Signed Number(8,3) DECIMAL(6,3) NOT NULL Search Results Score
7 ROWS_TO_RETURN Number(4,0) SMALLINT NOT NULL Rows to return

Default Value: 10