INSTALLATION

(SQL Table)
Index Back

Site-Specific Install Options

Use 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 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

2 MIN_STD_HRS Number(7,2) DECIMAL(6,2) NOT NULL Minimum Standard Hours
3 MAX_STD_HRS Number(7,2) DECIMAL(6,2) NOT NULL Maximum Standard Hours
4 EMPLID_LENGTH Number(2,0) SMALLINT NOT NULL Empl ID Field Length

Default Value: 4

5 STD_HRS_DEFAULT Number(7,2) DECIMAL(6,2) NOT NULL Default Standard Hours

Default Value: 40

6 STD_HRS_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Standard Work Period

Default Value: W

Prompt Table: STDHRS_FREQ_VW

7 TEMP_SSN_MASK Character(3) VARCHAR2(3) NOT NULL 'Temporary SSN' Mask

Default Value: 999

8 COMMIT_AFTER Number(4,0) SMALLINT NOT NULL Commit After Empl Processed

Default Value: 300

9 POSITION_MGMT Character(1) VARCHAR2(1) NOT NULL Position Management Option
F=Full Position Management
N=No Position Management
P=Partial Position Management

Default Value: N

10 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: COUNTRY_TBL

11 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
A=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly

Default Value: M

Prompt Table: COMP_FREQ_VW

12 CAN_CMA Character(2) VARCHAR2(2) NOT NULL Canadian Census Metropol Area

Default Value: 06

13 CAN_IND_SECTOR Character(3) VARCHAR2(3) NOT NULL Canadian Industrial Sector

Default Value: 451

14 MULTI_STEP_GRADE Character(1) VARCHAR2(1) NOT NULL Multi-Step Grade

Y/N Table Edit

Default Value: N

15 FSA_CLAIMS Character(1) VARCHAR2(1) NOT NULL FSA Claims Administration

Y/N Table Edit

Default Value: N

16 BENEFIT_ADMINISTRN Character(1) VARCHAR2(1) NOT NULL Benefits Administration

Y/N Table Edit

Default Value: N

17 START_EVENT_DT Date(10) DATE Start Date for BenAdmin
18 EXCHNG_TO_CURRENCY Character(3) VARCHAR2(3) NOT NULL Exchange to Currency

Default Value: USD

Prompt Table: CURRENCY_CD_TBL

19 EXCHNG_TO_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

Default Value: OFFIC

Prompt Table: RT_TYPE_TBL

20 HR Character(1) VARCHAR2(1) NOT NULL Human Resources

Y/N Table Edit

Default Value: Y

21 AM Character(1) VARCHAR2(1) NOT NULL Asset Management

Y/N Table Edit

Default Value: N

22 AP Character(1) VARCHAR2(1) NOT NULL Payables

Y/N Table Edit

Default Value: N

23 AR Character(1) VARCHAR2(1) NOT NULL Receivables

Y/N Table Edit

Default Value: N

24 GL Character(1) VARCHAR2(1) NOT NULL General Ledger

Y/N Table Edit

Default Value: N

25 BD Character(1) VARCHAR2(1) NOT NULL Budgets

Y/N Table Edit

Default Value: N

26 PC Character(1) VARCHAR2(1) NOT NULL Project Costing

Y/N Table Edit

Default Value: N

27 PO Character(1) VARCHAR2(1) NOT NULL Purchase Order

Y/N Table Edit

Default Value: N

28 INV Character(1) VARCHAR2(1) NOT NULL Inventory

Y/N Table Edit

Default Value: N

29 BI Character(1) VARCHAR2(1) NOT NULL Billing

Y/N Table Edit

Default Value: N

30 OM Character(1) VARCHAR2(1) NOT NULL Order Management

Y/N Table Edit

Default Value: N

31 PUBLIC_SECTOR Character(1) VARCHAR2(1) NOT NULL Education and Government

Y/N Table Edit

Default Value: N

32 RETRO_DEDUCTIONS Character(1) VARCHAR2(1) NOT NULL Retroactive Deductions

Y/N Table Edit

Default Value: Y

33 TL Character(1) VARCHAR2(1) NOT NULL PS/Time and Labor Product

Y/N Table Edit

Default Value: N

34 AUTO_EE_TAX Character(1) VARCHAR2(1) NOT NULL Automatic Employee Tax Data

Y/N Table Edit

Default Value: Y

35 SAME_ST_LCL_RSDNCE Character(1) VARCHAR2(1) NOT NULL Use State Residence for Local

Y/N Table Edit

Default Value: Y

36 FMLA_ADMINISTRN Character(1) VARCHAR2(1) NOT NULL FMLA Administration

Y/N Table Edit

Default Value: N

37 BAL_ID_FOR_CAL_YR Character(2) VARCHAR2(2) NOT NULL Balance ID for Calendar Year

Default Value: CY

38 MAX_ROWS_SCROLL Number(5,0) INTEGER NOT NULL Max Number of Rows in Scrolls

Default Value: 25

39 PA Character(1) VARCHAR2(1) NOT NULL PS/Pension Administration

Y/N Table Edit

Default Value: N

40 BEN_BILLING Character(1) VARCHAR2(1) NOT NULL Benefits Billing

Y/N Table Edit

Default Value: N

41 COBRA_ADMINISTRN Character(1) VARCHAR2(1) NOT NULL COBRA Administration

Y/N Table Edit

Default Value: N

42 ORGCHART Character(1) VARCHAR2(1) NOT NULL Organization Chart
N=None
O=Other
V=Visio

Default Value: N

43 US Character(1) VARCHAR2(1) NOT NULL USA - United States

Y/N Table Edit

Default Value: N

44 CAN Character(1) VARCHAR2(1) NOT NULL CAN - Canada

Y/N Table Edit

Default Value: N

45 GER Character(1) VARCHAR2(1) NOT NULL DEU - Germany

Y/N Table Edit

Default Value: N

46 FRA Character(1) VARCHAR2(1) NOT NULL FRA - France

Y/N Table Edit

Default Value: N

47 UK Character(1) VARCHAR2(1) NOT NULL GBR - United Kingdom

Y/N Table Edit

Default Value: N

48 JPN Character(1) VARCHAR2(1) NOT NULL JPN - Japan

Y/N Table Edit

Default Value: N

49 BEL Character(1) VARCHAR2(1) NOT NULL BEL - Belgium

Y/N Table Edit

Default Value: N

50 NLD Character(1) VARCHAR2(1) NOT NULL NLD - Netherlands

Y/N Table Edit

Default Value: N

51 ESP Character(1) VARCHAR2(1) NOT NULL ESP - Spain

Y/N Table Edit

Default Value: N

52 MEX Character(1) VARCHAR2(1) NOT NULL Field for Country Mexico

Y/N Table Edit

Default Value: N

53 AUS Character(1) VARCHAR2(1) NOT NULL This field is used to identify the Australian Functionality in HRMS

Y/N Table Edit

Default Value: N

54 MYS Character(1) VARCHAR2(1) NOT NULL This field is used to identify the Malaysian Functionality in HRMS

Y/N Table Edit

Default Value: N

55 NZL Character(1) VARCHAR2(1) NOT NULL This field is used to identify the New Zealand Functionality in HRMS

Y/N Table Edit

Default Value: N

56 SGP Character(1) VARCHAR2(1) NOT NULL This field is used to identify the Singapore Functionality in HRMS

Y/N Table Edit

Default Value: N

57 HKG Character(1) VARCHAR2(1) NOT NULL HKG - Hong Kong

Y/N Table Edit

Default Value: N

58 INSTALLED_PAY_GBL Character(1) VARCHAR2(1) NOT NULL Global Payroll Core

Y/N Table Edit

Default Value: N

59 IND Character(1) VARCHAR2(1) NOT NULL This field is used to identify the Indian Functionality in HRMS

Y/N Table Edit

Default Value: N

60 BRA Character(1) VARCHAR2(1) NOT NULL This field is used to identify the Brazilian Functionality in HRMS

Y/N Table Edit

Default Value: N

61 CHN Character(1) VARCHAR2(1) NOT NULL This field is used to identify the Chinese Functionality in HRMS

Y/N Table Edit

Default Value: N

62 THA Character(1) VARCHAR2(1) NOT NULL This field is used to identify the Thailand CE Functionality in HRMS

Y/N Table Edit

Default Value: N

63 INSTALLED_PAY_NA Character(1) VARCHAR2(1) NOT NULL Payroll for North America

Y/N Table Edit

Default Value: N

64 INSTALLED_PAY_INT Character(1) VARCHAR2(1) NOT NULL Payroll Interface

Y/N Table Edit

Default Value: N

65 USE_POINTS_SW Character(1) VARCHAR2(1) NOT NULL Salary Points

Y/N Table Edit

Default Value: N

66 USE_RTCD_GROUP_SW Character(1) VARCHAR2(1) NOT NULL Use Rate Code Groups

Y/N Table Edit

Default Value: N

67 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security

Prompt Table: OPRDEFN_SCRTY

68 FED Character(1) VARCHAR2(1) NOT NULL Federal Functionality

Y/N Table Edit

Default Value: N

69 FP_FLAG Character(1) VARCHAR2(1) NOT NULL French Public Sector

Y/N Table Edit

Default Value: N

70 GVT_PAY_BASIS Character(2) VARCHAR2(2) NOT NULL Pay Basis
BW=Bi-weekly
FB=Fee Basis
PA=Per Annum
PD=Per Diem
PH=Per Hour
PM=Per Month
PW=Piece Work
SM=Semi-monthly
SY=School Year
WC=Without Compensation

Default Value: PA

71 CHE Character(1) VARCHAR2(1) NOT NULL Switzerland Country field.

Y/N Table Edit

Default Value: N

72 ITA Character(1) VARCHAR2(1) NOT NULL Italian HR Functionality/ Person name/ Name

Y/N Table Edit

Default Value: N

73 ALLW_CONC_CALCCONF Character(1) VARCHAR2(1) NOT NULL Concurrent Calc/Confirm

Y/N Table Edit

Default Value: N

74 GP_CST_INSTALL_IND Character(1) VARCHAR2(1) NOT NULL Global Payroll Customer Installation Indicator

Y/N Table Edit

Default Value: Y

75 ST Character(1) VARCHAR2(1) NOT NULL PS/Stock Administration

Y/N Table Edit

Default Value: N

76 ADJ_TL_FINAL_CHK Character(1) VARCHAR2(1) NOT NULL Change Final Check

Y/N Table Edit

Default Value: N

77 ADJ_TL_ONL_CHK Character(1) VARCHAR2(1) NOT NULL Change Online Check

Y/N Table Edit

Default Value: N

78 ADJ_TL_REV_ADJ Character(1) VARCHAR2(1) NOT NULL Change Reversal Adjustments

Y/N Table Edit

Default Value: N

79 REFRSH_TL_JOB_CHG Character(1) VARCHAR2(1) NOT NULL Refresh on Job Change

Y/N Table Edit

Default Value: N

80 REFRSH_TL_PRECALC Character(1) VARCHAR2(1) NOT NULL Load in Preliminary Calc

Y/N Table Edit

Default Value: N

81 PSEBENEFITS Character(1) VARCHAR2(1) NOT NULL PeopleSoft eBenefits

Y/N Table Edit

Default Value: N

82 PSECOMP Character(1) VARCHAR2(1) NOT NULL PeopleSoft eCompensation

Y/N Table Edit

Default Value: N

83 PSEPAY Character(1) VARCHAR2(1) NOT NULL PeopleSoft ePay

Y/N Table Edit

Default Value: N

84 PSEPROFILE Character(1) VARCHAR2(1) NOT NULL PeopleSoft eProfile

Y/N Table Edit

Default Value: N

85 PSERECRUIT Character(1) VARCHAR2(1) NOT NULL Candidate Gateway

Y/N Table Edit

Default Value: N

86 CCU Character(1) VARCHAR2(1) NOT NULL Currency Conversion Utility

Y/N Table Edit

Default Value: N

87 PSEA Character(1) VARCHAR2(1) NOT NULL PeopleSoft eDevelopment

Y/N Table Edit

Default Value: N

88 INSTALLED_GP_AUS Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll Australia

Y/N Table Edit

Default Value: N

89 INSTALLED_GP_BRA Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll Brazil

Y/N Table Edit

Default Value: N

90 INSTALLED_GP_CAN Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll Canada. (Reserved field for possible future country extension development).

Y/N Table Edit

Default Value: N

91 INSTALLED_GP_CHE Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll Switzerland

Y/N Table Edit

Default Value: N

92 INSTALLED_GP_CHN Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll China

Y/N Table Edit

Default Value: N

93 INSTALLED_GP_DEU Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll Germany

Y/N Table Edit

Default Value: N

94 INSTALLED_GP_ESP Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll Spain

Y/N Table Edit

Default Value: N

95 INSTALLED_GP_FRA Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll France

Y/N Table Edit

Default Value: N

96 INSTALLED_GP_HKG Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll Hong Kong

Y/N Table Edit

Default Value: N

97 INSTALLED_GP_IND Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll India

Y/N Table Edit

Default Value: N

98 INSTALLED_GP_ITA Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll Italy

Y/N Table Edit

Default Value: N

99 INSTALLED_GP_JPN Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll Japan

Y/N Table Edit

Default Value: N

100 INSTALLED_GP_MEX Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll Mexico

Y/N Table Edit

Default Value: N

101 INSTALLED_GP_MYS Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll Malaysia

Y/N Table Edit

Default Value: N

102 INSTALLED_GP_NLD Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll Netherlands

Y/N Table Edit

Default Value: N

103 INSTALLED_GP_NZL Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll New Zealand

Y/N Table Edit

Default Value: N

104 INSTALLED_GP_SGP Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll Singapore

Y/N Table Edit

Default Value: N

105 INSTALLED_GP_THA Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll Thailand

Y/N Table Edit

Default Value: N

106 INSTALLED_GP_UK Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll United Kingdom

Y/N Table Edit

Default Value: N

107 INSTALLED_GP_USA Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll United States

Y/N Table Edit

Default Value: N

108 PSECOMP_MGR Character(1) VARCHAR2(1) NOT NULL eCompensation Manager

Y/N Table Edit

Default Value: N

109 PSEPROFILE_MGR Character(1) VARCHAR2(1) NOT NULL eProfile Manager

Y/N Table Edit

Default Value: N

110 PSERECRUIT_MGR Character(1) VARCHAR2(1) NOT NULL Talent Acquisition Management

Y/N Table Edit

Default Value: N

111 FO_PBM Character(1) VARCHAR2(1) NOT NULL Used to identify whether the product Pay/Bill has been installed in the database.

Y/N Table Edit

Default Value: N

112 AUTO_JOB_END Character(1) VARCHAR2(1) NOT NULL This is a flag on the Installation Table page which will indicate whether the system should or should not automatically end jobs on the Expected Job End Date.

Y/N Table Edit

Default Value: N

113 AUTO_JOB_SUSPEND Character(1) VARCHAR2(1) NOT NULL This is a flag on the Installation Table page which will indicate whether the system should automatically suspend Substantive jobs when employees are assigned to Temporary Assignments. Turning this flag on implies that Temporary Assignment is allowed.

Y/N Table Edit

Default Value: N

114 EHC Character(1) VARCHAR2(1) NOT NULL HRMS Portal Pack

Y/N Table Edit

Default Value: N

115 EPU Character(1) VARCHAR2(1) NOT NULL Campus Portal

Y/N Table Edit

Default Value: N

116 APS_AUS Character(1) VARCHAR2(1) NOT NULL This unique ID is on the INSTALLATION table. When checked, it identifies the customer/industry as Australian Public Service.

Y/N Table Edit

Default Value: N

117 DI Character(1) VARCHAR2(1) NOT NULL Identifies the PeopleSoft Directory Interface Product

Y/N Table Edit

Default Value: N

118 INSTALLED_GP_ARG Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll Argentina. (Reserved field for possible future country extension development).

Y/N Table Edit

Default Value: N

119 INSTALLED_GP_IRL Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll Ireland (Reserved field for possible future country extension development).

Y/N Table Edit

Default Value: N

120 INSTALLED_GP_TWN Character(1) VARCHAR2(1) NOT NULL Installation Flag for Global Payroll Taiwan (Reserved field for possible future country extension development).

Y/N Table Edit

Default Value: N

121 TL_MOBILE Character(1) VARCHAR2(1) NOT NULL no longer used

Y/N Table Edit

Default Value: N

122 PSEPERF_MANAGEMENT Character(1) VARCHAR2(1) NOT NULL PeopleSoft ePerformance

Y/N Table Edit

Default Value: N

123 AA_ENABLED_JPN Character(1) VARCHAR2(1) NOT NULL Indicates whether the Japanese Additional Appointment functionality is being used in the system. A value of Y indicates that the functionality is being used. This field determines whether additional processing is performed on the Job component.

Y/N Table Edit

Default Value: N

124 INSTALLED_PAY_PPS Character(1) VARCHAR2(1) NOT NULL Installation Flag for Payroll PIP - SAP

Y/N Table Edit

Default Value: N

125 AV Character(1) VARCHAR2(1) NOT NULL Contributor Relations

Y/N Table Edit

Default Value: N

126 SA Character(1) VARCHAR2(1) NOT NULL Student Administration

Y/N Table Edit

Default Value: N

127 SG Character(1) VARCHAR2(1) NOT NULL Gradebook

Y/N Table Edit

Default Value: N

128 HGA Character(1) VARCHAR2(1) NOT NULL Global Absence Flag

Y/N Table Edit

129 ELM Character(1) VARCHAR2(1) NOT NULL Enterprise Learning Management

Y/N Table Edit

Default Value: N

130 PS_GL_VERSION Character(10) VARCHAR2(10) NOT NULL PeopleSoft General Ledger version.

Default Value: N/A

131 ADP Character(1) VARCHAR2(1) NOT NULL Field for the Installation Table to indicated whether the product Payroll Interface for ADP is installed.

Y/N Table Edit

Default Value: N

132 CSS Character(1) VARCHAR2(1) NOT NULL Product Identifier field for Campus Self Service

Y/N Table Edit

133 HMCF_VALID_CACHE Character(1) VARCHAR2(1) NOT NULL Cache Validations
N=No
Y=Yes

Default Value: N

134 HMCF_CACHE_RETAIN Number(3,0) SMALLINT NOT NULL Number of Days to Retain Cache

Default Value: 0

135 HMCF_EIP_LIMIT Number(4,0) SMALLINT NOT NULL EIP Message Limit

Default Value: 1000

136 GVT_NFC_INDICATOR Character(1) VARCHAR2(1) NOT NULL Federal NFC field

Y/N Table Edit

Default Value: N

137 MILITARY Character(1) VARCHAR2(1) NOT NULL Military Installation

Y/N Table Edit

Default Value: N

138 BEN_DED_CLS_ORDER Character(1) VARCHAR2(1) NOT NULL Benefits Deduction Class Order
1=EE After Tax Then PTax Benefit
2=PTax Benefit Then EE After Tax

Default Value: 1

139 ENC_TRIGGER Character(1) VARCHAR2(1) NOT NULL Encumbrance Trigger

Y/N Table Edit

Default Value: Y

140 UPD_INCUMB_LMT Number(4,0) SMALLINT NOT NULL Update Incumbents Limit
141 INSTALLED_OWS Character(1) VARCHAR2(1) NOT NULL Oracle Workforce Scheduling

Y/N Table Edit

Default Value: N

142 SAIP Character(1) VARCHAR2(1) NOT NULL SA Integration Pack

Y/N Table Edit

Default Value: N

143 HP_ENFORCE_RTBC Character(1) VARCHAR2(1) NOT NULL Enforce Real Time Budget Checking indicator

Y/N Table Edit

Default Value: N

144 HP_KK_BUDGET_PROC Character(1) VARCHAR2(1) NOT NULL Commitment Control Budget Processor Indicator

Y/N Table Edit

Default Value: N

145 ARG Character(1) VARCHAR2(1) NOT NULL ARG - Argentina

Y/N Table Edit

Default Value: N

146 TMOD Character(1) VARCHAR2(1) NOT NULL Talent Management on Demand

Y/N Table Edit

Default Value: N

147 SPN Character(1) VARCHAR2(1) NOT NULL Succession Planning

Y/N Table Edit

Default Value: N

148 USA_TWO_QUESTION Character(1) VARCHAR2(1) NOT NULL Two-Question Format(Ethnicity)

Y/N Table Edit

Default Value: N

149 GPS Character(1) VARCHAR2(1) NOT NULL This field is used as the German Public Sector Flag across the system.

Y/N Table Edit

Default Value: N

150 HCSC_MAP_INDICATOR Character(1) VARCHAR2(1) NOT NULL Checkbox to activate Address Map.

Y/N Table Edit

Default Value: Y

151 TALENT_LINKS Character(1) VARCHAR2(1) NOT NULL Talent Links
N=No
Y=Yes

Default Value: N

152 LRM Character(1) VARCHAR2(1) NOT NULL This field is used as the Labor Rule and Monitoring flag across the system.

Y/N Table Edit

Default Value: N

153 ORCL_ELOC_OPT Character(1) VARCHAR2(1) NOT NULL Use Oracle Maps Service

Y/N Table Edit

Default Value: N

154 TAX_DATA_RESET Character(1) VARCHAR2(1) NOT NULL Tax data reset for PNA
N=No
Y=Yes

Default Value: N

155 EONC_INSTALLED Character(1) VARCHAR2(1) NOT NULL Notification Composer Installation Flag

Y/N Table Edit

Default Value: N

156 NOTIF_DFLT_FLG Character(1) VARCHAR2(1) NOT NULL Specify if email address from User Profile or Employee Personal Information should be used.
H=Employee Personal Information
P=User Profile

Default Value: P