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
Prompt Table: COUNTRY_TBL |
| 2 | EXCHNG_TO_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
To Currency
Default Value: USD Prompt Table: CURRENCY_CD_TBL |
| 3 | EXCHNG_TO_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Currency Rate Type
Prompt Table: CUR_RT_TYPE_TBL |
| 4 | LELM | Character(1) | VARCHAR2(1) NOT NULL |
Enterprise Learning Management
Y/N Table Edit Default Value: N |
| 5 | 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: N |
| 6 | EONC_INSTALLED | Character(1) | VARCHAR2(1) NOT NULL |
Notification Composer Installation Flag
Y/N Table Edit Default Value: N |