RTBL_CAF_LED_SC

(SQL Table)
Index Back

Inquiry Criteria - Scenarios

# 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: LED_INQ_CRIT.OPRID

2 SAVED_SEARCH Character(30) VARCHAR2(30) NOT NULL Saved Search Name

Default Value: LED_INQ_CRIT.SAVED_SEARCH

3 INQUIRY_TYPE Character(1) VARCHAR2(1) NOT NULL Inquiry Type specifies Saved Search or Personalization to distinguish the type of search crieria.
P=Personalization
S=Saved Search

Default Value: P

4 CAF_SESSION_ID Character(36) VARCHAR2(36) NOT NULL Session ID
5 CAF_CONFIG_TYPE Character(4) VARCHAR2(4) NOT NULL Analysis Type
RTBL=Real Time Bottom Line
SYS=System
USER=User Defined
6 CAF_CONFIG_ID Character(30) VARCHAR2(30) NOT NULL Analysis ID
7 CAF_FACTOR_ID Character(30) VARCHAR2(30) NOT NULL Factor ID
8 SCE_COMPARE_OPT Character(1) VARCHAR2(1) NOT NULL Scenario Compare Option specifies Actuals or Scenario to compare to the anchor scenario for the purpose of variance measurement (amount or percent).
A=Actuals
S=Scenario

Default Value: S

9 SCE_ID Character(10) VARCHAR2(10) NOT NULL ID
10 RTBL_SCENARIO Character(18) VARCHAR2(18) NOT NULL Scenario Name
11 SCE_ANCHOR Character(1) VARCHAR2(1) NOT NULL Y/N flag to to specify which scenario is the anchor for variance measurement (amount or percent) to other scenarios.

Y/N Table Edit

Default Value: N

12 SHOW_SCENARIO Character(1) VARCHAR2(1) NOT NULL Y/N flag to indicate whether or not to display the scenario.

Y/N Table Edit

Default Value: N

13 SHOW_VAR_AMT Character(1) VARCHAR2(1) NOT NULL Y/N flag to indicate whether or not to display the variance amount.

Y/N Table Edit

Default Value: N

14 SHOW_VAR_PCT Character(1) VARCHAR2(1) NOT NULL Y/N flag to indicate whether or not to display the variance percent.

Y/N Table Edit

Default Value: N

15 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number