RBF_OPTIONS

(SQL Table)
Index Back

FSI Options

This is the main record for holding FSI specific options values

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PKG_CMP_AGENT_FLG Character(1) VARCHAR2(1) NOT NULL In Agent-facing Sales Process

Y/N Table Edit

Default Value: N

2 PKG_CMP_SS_FLG Character(1) VARCHAR2(1) NOT NULL In Self-Service Sales Process

Y/N Table Edit

Default Value: N

3 BILLING_ACCT_FLG Character(1) VARCHAR2(1) NOT NULL Billing account Flag

Y/N Table Edit

4 FSI_CAT_PRD_DETAIL Character(1) VARCHAR2(1) NOT NULL Used to indicate whether product catalog will have options to hide product detail

Y/N Table Edit

5 INTR_DURTN Number(3,0) SMALLINT NOT NULL The Field is used to store the Day duration for Interactions list in FSI Summary Page
6 INTR_DURTN_FREQ Character(1) VARCHAR2(1) NOT NULL Duration Frequency Units, usually paired with the DURATION, to form a 2 part entry field - ie 12 Months.
D=Days
M=Months
W=Weeks
Y=Years
7 PRCS_DURTN Number(3,0) SMALLINT NOT NULL The Field is used to store the Day duration for Process list in FSI Summary Page
8 PRCS_DURTN_FREQ Character(1) VARCHAR2(1) NOT NULL Duration Frequency Units, usually paired with the DURATION, to form a 2 part entry field - ie 12 Months.
D=Days
M=Months
W=Weeks
Y=Years
9 FINACT_DUP_CHECK Character(1) VARCHAR2(1) NOT NULL Dup checking enablement flag in financial account

Y/N Table Edit

Default Value: N

10 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
11 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
12 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
13 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
14 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
15 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time