INSTALLATION(SQL Table) |
Index Back |
|---|---|
Site-Specific Install OptionsUse the INSTALLATION record to set parameters for running your PeopleSoft system at your specific site. For example, if you are running PeopleSoft on a DB2 machine, you enter certain parameters here. If you use auto-numbering in PeopleSoft, such as auto-assignment of employee IDs, you enter the beginning sequence number here. If you run PeopleSoft Payroll, you specify the number of payroll records to be run before a 'Commit' is executed. If you are running Position Management, you specify whether you are running partial or full Position Management. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Default Value: USA Prompt Table: COUNTRY_TBL |
| 2 | MSWAP | Character(1) | VARCHAR2(1) NOT NULL |
Mobile Sales for WAP Phones installation flag.
Y/N Table Edit Default Value: Y |
| 3 | EXCHNG_TO_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
To Currency
Default Value: USD Prompt Table: CURRENCY_CD_TBL |
| 4 | EXCHNG_TO_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table: CUR_RT_TYPE_TBL |
| 5 | INSTALLATION_CD | Character(5) | VARCHAR2(5) NOT NULL |
Installation Code
Default Value: CRM |
| 6 | RF | Character(1) | VARCHAR2(1) NOT NULL |
Installation Switch
Y/N Table Edit Default Value: Y |
| 7 | RC | Character(1) | VARCHAR2(1) NOT NULL |
RC
Y/N Table Edit Default Value: Y |
| 8 | RCSS | Character(1) | VARCHAR2(1) NOT NULL |
Self Service Field
Y/N Table Edit Default Value: Y |
| 9 | RH | Character(1) | VARCHAR2(1) NOT NULL |
HelpDesk
Y/N Table Edit Default Value: Y |
| 10 | RHSS | Character(1) | VARCHAR2(1) NOT NULL |
HelpDesk-Employee Self Service
Y/N Table Edit Default Value: Y |
| 11 | RHHR | Character(1) | VARCHAR2(1) NOT NULL |
HelpDesk for Human Resources
Y/N Table Edit Default Value: Y |
| 12 | RSF | Character(1) | VARCHAR2(1) NOT NULL |
Sales
Y/N Table Edit Default Value: Y |
| 13 | RSPC | Character(1) | VARCHAR2(1) NOT NULL |
Sales Product Configurator
Y/N Table Edit Default Value: Y |
| 14 | CFG | Character(1) | VARCHAR2(1) NOT NULL |
This field is used for Option to install Configurator product.
Y/N Table Edit Default Value: Y |
| 15 | CZ | Character(1) | VARCHAR2(1) NOT NULL |
This field is used for Option to install Oracle Configurator product.
Y/N Table Edit Default Value: N |
| 16 | MCFG | Character(1) | VARCHAR2(1) NOT NULL |
This field is used for Option to install Mobile Configurator product.
Y/N Table Edit Default Value: Y |
| 17 | RA | Character(1) | VARCHAR2(1) NOT NULL |
Marketing
Y/N Table Edit Default Value: Y |
| 18 | RI | Character(1) | VARCHAR2(1) NOT NULL |
Interaction Management
Y/N Table Edit Default Value: Y |
| 19 | RFM | Character(1) | VARCHAR2(1) NOT NULL |
Mobile Field Service
Y/N Table Edit Default Value: Y |
| 20 | NLP | Character(1) | VARCHAR2(1) NOT NULL |
NLP Framework Installation Field
Default Value: N |
| 21 | RSP | Character(1) | VARCHAR2(1) NOT NULL | Field used by Installation record. |
| 22 | RO | Character(1) | VARCHAR2(1) NOT NULL |
Order Capture
Y/N Table Edit Default Value: Y |
| 23 | ROSS | Character(1) | VARCHAR2(1) NOT NULL |
Order Capture - Self Service
Y/N Table Edit Default Value: Y |
| 24 | ADV | Character(1) | VARCHAR2(1) NOT NULL |
Real-Time Advisor
Y/N Table Edit Default Value: Y |
| 25 | EIM | Character(1) | VARCHAR2(1) NOT NULL |
Incentive Management
Y/N Table Edit Default Value: Y |
| 26 | TM | Character(1) | VARCHAR2(1) NOT NULL |
TeleSales
Default Value: Y |
| 27 | CTI | Character(1) | VARCHAR2(1) NOT NULL |
CTI Integration
Y/N Table Edit Default Value: Y |
| 28 | RMI | Character(1) | VARCHAR2(1) NOT NULL |
Field is a flag for Multichannel Communication.
Y/N Table Edit Default Value: Y |
| 29 | OMK | Character(1) | VARCHAR2(1) NOT NULL |
Online Marketing
Y/N Table Edit Default Value: Y |
| 30 | CCM | Character(1) | VARCHAR2(1) NOT NULL |
Used to identify Catalog Management on each product line's installation record.
Y/N Table Edit Default Value: Y |
| 31 | CRM_PRTAL_PACK | Character(1) | VARCHAR2(1) NOT NULL |
CRM Portal Pack installation flag.
Y/N Table Edit Default Value: Y |
| 32 | RIMORA | Character(1) | VARCHAR2(1) NOT NULL |
Used to identify that theInstall to Maintain Oracle connector is installed.
Y/N Table Edit |
| 33 | RIMSAP | Character(1) | VARCHAR2(1) NOT NULL |
Used to identify that theInstall to Maintain SAP connector is installed.
Y/N Table Edit |
| 34 | ROCORA | Character(1) | VARCHAR2(1) NOT NULL |
Used to identify that the Order to Cash Oracle connector is installed.
Y/N Table Edit |
| 35 | ROCSAP | Character(1) | VARCHAR2(1) NOT NULL |
Used to identify that the Order to Cash SAP connector is installed.
Y/N Table Edit |
| 36 | RRRORA | Character(1) | VARCHAR2(1) NOT NULL |
Used to identify that the Request to Resolve Oracle connector is installed.
Y/N Table Edit |
| 37 | RRRSAP | Character(1) | VARCHAR2(1) NOT NULL |
Used to identify that the Request to Resolve SAP connector is installed.
Y/N Table Edit |
| 38 | ISC | Character(1) | VARCHAR2(1) NOT NULL |
Used to identify that the Infosync Client is installed.
Y/N Table Edit |
| 39 | ISS | Character(1) | VARCHAR2(1) NOT NULL |
Used to identify that the Infosync Server is installed.
Y/N Table Edit |
| 40 | RBP | Character(1) | VARCHAR2(1) NOT NULL |
Bill Presentment installation flag
Y/N Table Edit Default Value: Y |
| 41 | RBT | Character(1) | VARCHAR2(1) NOT NULL |
Banking Transactions installation flag
Y/N Table Edit Default Value: Y |
| 42 | RCM | Character(1) | VARCHAR2(1) NOT NULL |
Installation flag to indicate whether Client Manager is installed
Y/N Table Edit Default Value: Y |
| 43 | RMAP | Character(1) | VARCHAR2(1) NOT NULL |
Mobile Account Planning
Y/N Table Edit Default Value: Y |
| 44 | RPC | Character(1) | VARCHAR2(1) NOT NULL |
Partner Commerce
Y/N Table Edit Default Value: Y |
| 45 | RIM | Character(1) | VARCHAR2(1) NOT NULL | Sales Installation record flag for Blackberry sales application. |
| 46 | RPCP | Character(1) | VARCHAR2(1) NOT NULL |
Policy and Claims Presentment
Y/N Table Edit Default Value: Y |
| 47 | RPM | Character(1) | VARCHAR2(1) NOT NULL |
Partner Marketing
Y/N Table Edit Default Value: Y |
| 48 | RPMA | Character(1) | VARCHAR2(1) NOT NULL |
SmartView
Y/N Table Edit Default Value: Y |
| 49 | RPNA | Character(1) | VARCHAR2(1) NOT NULL |
Phone Number Administration
Y/N Table Edit Default Value: Y |
| 50 | RPP | Character(1) | VARCHAR2(1) NOT NULL |
Partner Planning
Y/N Table Edit Default Value: Y |
| 51 | RPPL | Character(1) | VARCHAR2(1) NOT NULL |
Partner Platform
Y/N Table Edit Default Value: Y |
| 52 | RPSA | Character(1) | VARCHAR2(1) NOT NULL |
Partner Sales
Y/N Table Edit Default Value: Y |
| 53 | RPSE | Character(1) | VARCHAR2(1) NOT NULL |
Partner Service
Y/N Table Edit Default Value: Y |
| 54 | RSMA | Character(1) | VARCHAR2(1) NOT NULL |
Services Management
Y/N Table Edit Default Value: Y |
| 55 | HE | Character(1) | VARCHAR2(1) NOT NULL |
Installation flag for Higher Education
Y/N Table Edit Default Value: Y |
| 56 | HESC | Character(1) | VARCHAR2(1) NOT NULL |
Installation flag for Service Center for Higher Education
Y/N Table Edit Default Value: Y |
| 57 | SUN | Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Sunday
Y/N Table Edit Default Value: Y |
| 58 | MON | Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Monday
Y/N Table Edit Default Value: Y |
| 59 | TUES | Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Tuesday.
Y/N Table Edit Default Value: Y |
| 60 | WED | Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Wednesday.
Y/N Table Edit Default Value: Y |
| 61 | THURS | Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Thursday.
Y/N Table Edit Default Value: Y |
| 62 | FRI | Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Friday.
Y/N Table Edit Default Value: Y |
| 63 | SAT | Character(1) | VARCHAR2(1) NOT NULL |
Y/N flag for providing the Start and End Time for Saturday.
Y/N Table Edit Default Value: N |
| 64 | TIME_FROM | Time(15) | TIMESTAMP | From Time |
| 65 | TIME_TO | Time(15) | TIMESTAMP | To Time |
| 66 | EVALUATION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
This is the evaluation type field.
A=Approved/Official B=Subordinate C=Customer E=Executive Committee M=Mentor P=Peer R=Supervisor/Manager S=Self Default Value: A |
| 67 | SECURITY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Type of Security
C=Permission List Level Security N=No Security O=User ID Level Security Default Value: N |
| 68 | BU_SECURITY | Character(1) | VARCHAR2(1) NOT NULL |
Business Unit Security
Y/N Table Edit Default Value: N |
| 69 | SETID_SECURITY | Character(1) | VARCHAR2(1) NOT NULL |
TableSet ID Security
Y/N Table Edit Default Value: N |
| 70 | BILL_OPT_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Collector/Credit Analyst Req.
N=No Y=Yes Y/N Table Edit Default Value: N |
| 71 | DEF_CUR_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table: RT_TYPE_TBL |
| 72 | MARKET | Character(3) | VARCHAR2(3) NOT NULL |
Market
Default Value: GBL |
| 73 | UPDATE_BO_DIR | Character(1) | VARCHAR2(1) NOT NULL |
Update BO Directory Online
Y/N Table Edit Default Value: Y |
| 74 | MOC | Character(1) | VARCHAR2(1) NOT NULL |
Mobile Order Capture
Y/N Table Edit Default Value: Y |
| 75 | GEO_CODE_AVAIL | Character(1) | VARCHAR2(1) NOT NULL |
Geo Code Availabel
Default Value: N |
| 76 | PS_FLG | Character(1) | VARCHAR2(1) NOT NULL |
PeopleSoft Development
Y/N Table Edit Default Value: Y |
| 77 | LEAD_TIME | Number(3,0) | SMALLINT NOT NULL |
Lead Time Days
Default Value: 90 |
| 78 | CASCADE_COUNT | Number(3,0) | SMALLINT NOT NULL |
This field specifies the threshold number of child cases to switch to batch cascade.
If there are more than this number of child cases, then the AE program will be used to cascade the status. With this number or fewer child cases, the real-time cascade will occur.
Default Value: 5 |
| 79 | KEY_ENCRYPTION | Character(30) | VARCHAR2(30) NOT NULL | Used in the Attribute related application as encryption key string. |
| 80 | RB_TD_360SRCH | Character(1) | VARCHAR2(1) NOT NULL |
Set Context from 360-Degree View Search
0=Off 1=On |
| 81 | RB_DUP_INSTALL | Character(1) | VARCHAR2(1) NOT NULL |
This is the enable duplicate checking field.
Y/N Table Edit Default Value: N |
| 82 | DB2FFR | Character(1) | VARCHAR2(1) NOT NULL |
Fetch First Rows on DB2 OS390
Y/N Table Edit Default Value: N |
| 83 | ESB | Character(1) | VARCHAR2(1) NOT NULL |
Enterprise Sale for Blackberry Installation indicator
Default Value: Y |
| 84 | OCD | Character(1) | VARCHAR2(1) NOT NULL |
Order Capture Dashboard Installation indicator
Default Value: Y |
| 85 | OFM | Character(1) | VARCHAR2(1) NOT NULL |
Offer Management Installation indicator
Default Value: Y |
| 86 | SDB | Character(1) | VARCHAR2(1) NOT NULL |
Service Dashboard Installation indicator
Default Value: Y |
| 87 | SLD | Character(1) | VARCHAR2(1) NOT NULL |
Sales Dashboard Installation indicator
Default Value: Y |
| 88 | RA_THIRD_PARTY | Character(1) | VARCHAR2(1) NOT NULL |
Offer management field to indicate third party optimization
N=No Y=Yes Y/N Table Edit Default Value: N |
| 89 | HDD | Character(1) | VARCHAR2(1) NOT NULL | Service Dashboard Installation indicator |
| 90 | HRD | Character(1) | VARCHAR2(1) NOT NULL | Service Dashboard Installation indicator |
| 91 | ALLOW_BUSINESS_CRD | Character(1) | VARCHAR2(1) NOT NULL |
Allow Prospects
N=No Y=Yes Y/N Table Edit Default Value: N |
| 92 | CDH | Character(1) | VARCHAR2(1) NOT NULL |
This is the field for the Customer Data Hub installed indicator.
N=No Y=Yes |
| 93 | CDHDL | Character(1) | VARCHAR2(1) NOT NULL |
This is the field for the Customer Data Hub installed indicator.
N=No Y=Yes |
| 94 | APPLICATION_EXT_ID | Character(18) | VARCHAR2(18) NOT NULL | Order Capture External |
| 95 | APPLICATION_INT_ID | Character(18) | VARCHAR2(18) NOT NULL | Order Capture Internal |
| 96 | RB_CCV_REQD | Character(1) | VARCHAR2(1) NOT NULL |
Set Context from 360-Degree View Search
N=No Y=Yes |
| 97 | WFC | Character(1) | VARCHAR2(1) NOT NULL |
This is the field for the Customer Data Hub installed indicator.
N=No Y=Yes Default Value: N |
| 98 | EVM | Character(1) | VARCHAR2(1) NOT NULL |
This is the field for the Events Management installed indicator.
N=No Y=Yes Default Value: N |
| 99 | RBPSS | Character(1) | VARCHAR2(1) NOT NULL |
PIM Server Sync
Y/N Table Edit Default Value: N |
| 100 | RB_CCI_HOSTED | Character(1) | VARCHAR2(1) NOT NULL |
Installation Option for selecting to use Hosted Credit Card Payments or standard SOAP processing where card data is encrypted and stored in PeopleSoft tables.
H=Hosted Payment Integration S=SOAP Payment Integration Default Value: S |
| 101 | RB_CYBSRCE_USERID | Character(30) | VARCHAR2(30) NOT NULL | Cybersource User IDs can be generated at the Cybersource website. |
| 102 | RB_CYBSRCE_MERCHID | Character(30) | VARCHAR2(30) NOT NULL | The cybersource merchant ID is included in credit card authorization transactions via SOAP xml interface. Cybersource merchant IDs and keys can be generated at the Cybersource website. |
| 103 | RB_CYBSRCE_KEY | Long Character | CLOB | The cybersource merchant key is the password to the cybersource merchant ID and is included in credit card authorization transactions via SOAP xml interface. Cybersource merchant IDs and keys can be generated at the Cybersource website. |
| 104 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
| 105 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
| 106 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
| 107 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
| 108 | 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. |
| 109 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |