UPG_SP_ACTIVITY (SQL Table)	Index Back
Upgrade sPro Standard Activity This table is used during the upgrade process to store old sPro Activity IDs from the PROJ_ACTIVITY Table and the corresponding new Activity ID that is inserted into the standard FS_ACTIVITY_TBL. A query of this table (UPG_SPP715) provides an output of this table and is used for reference purposes only.

UPG_SP_ACTIVITY

(SQL Table)

Upgrade sPro Standard Activity

This table is used during the upgrade process to store old sPro Activity IDs from the PROJ_ACTIVITY Table and the corresponding new Activity ID that is inserted into the standard FS_ACTIVITY_TBL. A query of this table (UPG_SPP715) provides an output of this table and is used for reference purposes only.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT
Prompt Table: SP_BU_PC_NONVW

2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Default Value: OPR_DEF_TBL_PC.PROJECT_ID
Prompt Table: SP_PROJ_NONVW

3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
Prompt Table: PC_TYPE_ACT_VW

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

5 UPG_ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL This field is used during the upgrade process to convert old Activity IDs to new Activity IDs. The old Activity ID comes from PROJ_ACTIVITY and is being renamed to a unique ACTIVITY_ID so that it can be inserted into FS_ACTIVITY_TBL to avoid any data collisions.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Default Value: OPR_DEF_TBL_PC.PROJECT_ID Prompt Table: SP_PROJ_NONVW
3	ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	Activity ID Prompt Table: PC_TYPE_ACT_VW
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	UPG_ACTIVITY_ID	Character(15)	VARCHAR2(15) NOT NULL	This field is used during the upgrade process to convert old Activity IDs to new Activity IDs. The old Activity ID comes from PROJ_ACTIVITY and is being renamed to a unique ACTIVITY_ID so that it can be inserted into FS_ACTIVITY_TBL to avoid any data collisions.