PC_MSP2_AET

(SQL Table)
Index Back

MSP Integration

Maintain the state information for the integration app engine.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PC_MSP2_SERVER Character(64) VARCHAR2(64) NOT NULL Microsoft Project Server

Prompt Table: PC_MSP2_SERV_VW

2 SESSION_NAME Character(50) VARCHAR2(50) NOT NULL MSP Integrator Session Name - name given by the Windows Terminal Service session.
3 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
5 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
6 PC_SYNC_DIR Character(3) VARCHAR2(3) NOT NULL Sync direction for MSP Integration. CMS = Copy to Microsoft CPS = Copy to PeopleSoft UMS = Update Microsoft UPS = Upgrade PeopleSoft UPR = Get Update from Project Resource List (PRL)
CMS=Copy Project to Microsoft
CPS=Copy Project to PeopleSoft
UMS=Update Project in Microsoft
UPR=Project Resource List Update
UPS=Update Project in PeopleSoft
7 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
8 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
9 PC_MSP2_INLINE Character(1) VARCHAR2(1) NOT NULL Inline
10 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
11 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
12 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.