PGM_ACT_DEP

(SQL Table)
Index Back

Activity Dependencies

Stores information of depedency type if set across the activities.

# 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: PROJ_ACTIVITY

4 PRDCSR_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Predecessor Business Unit

Prompt Table: SP_BU_PC_NONVW

5 PRDCSR_PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Predecessor Project ID

Prompt Table: SP_PROJP_NONVW

6 PRDCSR_ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Predecessor Activity

Prompt Table: PGM_PRDACT_PRMT

7 DEPENDENCY_TYPE Character(2) VARCHAR2(2) NOT NULL Dependency Type
EE=End-to-End
ES=End-to-Start
SE=Start-to-End
SS=Start-to-Start
8 LAG_DAYS Signed Number(4,0) DECIMAL(3) NOT NULL Lag (Days)
9 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
10 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
11 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
12 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.