INSTALLATION_SP

(SQL Table)
Index Back

sPro Installation Options

Services Procurement Installation Options Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SP_ADMIN_ENABLED Character(1) VARCHAR2(1) NOT NULL SP Administration Enabled

Y/N Table Edit

Default Value: Y

2 SP_EXPENSE_ENABLED Character(1) VARCHAR2(1) NOT NULL SP Expense Enabled

Y/N Table Edit

Default Value: Y

3 SP_FULFILL_ENABLED Character(1) VARCHAR2(1) NOT NULL SP Fulfillment Enabled

Y/N Table Edit

Default Value: Y

4 SP_SETTLE_ENABLED Character(1) VARCHAR2(1) NOT NULL SP Settlement Enabled

Y/N Table Edit

Default Value: Y

5 SPA_PERSONID_PREFX Character(2) VARCHAR2(2) NOT NULL Prefix for Person ID

Y/N Table Edit

Default Value: Y

6 REGION_CATALOG Character(1) VARCHAR2(1) NOT NULL Use Region Catalog

Y/N Table Edit

Default Value: Y

7 BUFFER_COUNT Number(5,0) INTEGER NOT NULL Max Search Result to Retrieve
8 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage

Prompt Table: SPF_UOM_VW

9 BASE_UNIT_WK Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Units Per Week
10 SPB_WOPO Character(1) VARCHAR2(1) NOT NULL PO Work Order Integration option

Y/N Table Edit

Default Value: N

11 SHEET_ID_LAST_USED Number(10,0) DECIMAL(10) NOT NULL Last Report ID Used
12 RES_ID_LAST_USED Number(10,0) DECIMAL(10) NOT NULL Resource ID last used for sPro Projects Integration
13 CNTRCT_ENABLED Character(1) VARCHAR2(1) NOT NULL PO Service Contracts Enabled sPro Installation Option
N=No
Y=Yes
14 DAYS_UOM Character(3) VARCHAR2(3) NOT NULL the unit of measure for days

Prompt Table: SPF_UOM_VW

15 USE_PAY_TYPES Character(1) VARCHAR2(1) NOT NULL Use Pay Types (Installation & BU)

Y/N Table Edit

Default Value: N

16 SP_MSP_FLAG Character(1) VARCHAR2(1) NOT NULL MSP installation flag is used on the INSTALLATION_SP table to determine if this is an MSP installation of sPro

Y/N Table Edit

Default Value: N

17 SP_AUC_ENABLED Character(1) VARCHAR2(1) NOT NULL Use Strategic Sourcing
18 SP_HCM_TERM Character(1) VARCHAR2(1) NOT NULL Use HCM terminology?

Y/N Table Edit

Default Value: N

19 SP_HCM_ENABLED Character(1) VARCHAR2(1) NOT NULL Use HCM terminology?
N=No
Y=Yes

Default Value: N

20 SP_HCM_NODE Character(30) VARCHAR2(30) NOT NULL Node Name

Prompt Table: PSACTIVENODEVW

21 SCH_EM Character(1) VARCHAR2(1) NOT NULL Schedule Sourcing Emails

Y/N Table Edit

Default Value: N

22 SP_HCMCORE_ENABLED Character(1) VARCHAR2(1) NOT NULL spro installation option flag

Y/N Table Edit

Default Value: N

23 SP_REASCD_REQUIRED Character(1) VARCHAR2(1) NOT NULL Field to specify if Reason Code is required
M=Mandatory
N=Not Used
O=Optional

Default Value: N

24 SPF_COMMENTS Character(1) VARCHAR2(1) NOT NULL Comments required
N=No
Y=Yes
25 SP_TASK_INTG_ENBLD Character(1) VARCHAR2(1) NOT NULL task integration flag
N=No
Y=Yes

Default Value: N

26 SP_MAX_RESULTS Number(5,0) INTEGER NOT NULL Maximum Search Results

Default Value: 50

27 SP_DISP_APPR_CHUNK Character(1) VARCHAR2(1) NOT NULL Display Approval Chunking

Y/N Table Edit

28 SP_IN_APPR_MAX_ROW Number(5,0) INTEGER NOT NULL Invoice Approval Monitor

Default Value: 5