PeopleSoft 9
Account Payables

Table Name PROJ_ACTIVITY

Table Description
PROJ_ACTIVITY
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes Yes
PROJECT_ID VARCHAR(15) Yes Yes
ACTIVITY_ID VARCHAR(15) Yes No
EFF_STATUS VARCHAR(1) No No
DESCR VARCHAR(30) No No
ACTIVITY_TYPE VARCHAR(5) No No
WBS_ID VARCHAR(100) No No
SYSTEM_SOURCE VARCHAR(3) No No
ACT_TEMPLATE_ID VARCHAR(15) No No
ACT_TEMPLATE_SW VARCHAR(1) No No
WORK_ORDER_ID VARCHAR(15) No No
WORK_ORDER_DTL_ID VARCHAR(15) No No
AFUDC_ACT_SW VARCHAR(1) No No
TARGET_ACT_SW VARCHAR(1) No No
SALES_TAX_ACT_SW VARCHAR(1) No No
PERCENT_COMPLETE decimal(5,2) No No
START_DT PSDATE No No
END_DT PSDATE No No
EARLY_START_DT PSDATE No No
LATE_START_DT PSDATE No No
ACTUAL_START_DT PSDATE No No
EARLY_FINISH_DT PSDATE No No
LATE_FINISH_DT PSDATE No No
ACTUAL_FINISH_DT PSDATE No No
BASELINE_FINISH_DT PSDATE No No
BASELINE_START_DT PSDATE No No
BCWP SMALLINT No No
BCWS SMALLINT No No
ACT_TYPE_SCH VARCHAR(5) No No
INTEGRATION_ID VARCHAR(40) No No
INTEGRATION_TRG VARCHAR(3) No No
INTEGRATION_ANTYPE VARCHAR(5) No No
DTTM_STAMP PSDATETIME No No
DRAWING_NAME VARCHAR(8) No No
ACTIVITY_USER1 VARCHAR(10) No No
ACTIVITY_USER2 VARCHAR(10) No No
ACTIVITY_USER3 VARCHAR(10) No No
ACTIVITY_USER4 VARCHAR(10) No No
ACTIVITY_USER5 VARCHAR(10) No No
PC_ACT_USER_DT1 PSDATE No No
PC_ACT_USER_DT2 PSDATE No No
PC_USER_CURRENCY VARCHAR(3) No No
PC_ACT_USERAMT1 decimal(15,2) No No
PC_ACT_USERAMT2 decimal(15,2) No No
PC_ACT_USERAMT3 decimal(15,2) No No
PC_MSP_UNIQUE_ID VARCHAR(22) No No
PC_MILESTONE_FLG VARCHAR(1) No No
IN_USE_FLAG VARCHAR(1) No No
PC_SCH_FIELD1 VARCHAR(40) No No
PC_SCH_FIELD2 VARCHAR(40) No No
PC_SCH_FIELD3 VARCHAR(40) No No
PC_SCH_FIELD4 VARCHAR(40) No No
PC_SCH_FIELD5 VARCHAR(40) No No
PC_SCH_FIELD6 VARCHAR(40) No No
PC_SCH_FIELD7 VARCHAR(40) No No
WAIVED_FA_CLC_MTHD VARCHAR(1) No No
ENFORCE VARCHAR(1) No No
SUMMARY_ACT VARCHAR(1) No No
PC_DURATION DECIMAL(10,2) No No
PC_CHC_ACT_SW VARCHAR(1) No No
PGM_SCHED_METHOD VARCHAR(1) No No
ASSGND_WORK decimal(14,2) No No
ACTUAL_WORK decimal(14,2) No No
REMAINING_WORK decimal(14,2) No No
BASELINE_WORK decimal(14,2) No No
COST decimal(26,3) No No
DEFAULT_CURR_SW VARCHAR(1) No No
FMS_DTTM_STAMP PSDATETIME No No
FMS_OPRID VARCHAR(30) No No
FMS_LASTUPDDTTM PSDATETIME No No
FMS_LASTUPDOPRID VARCHAR(30) No No
SYNCID int No No
SYNCDTTM PSDATETIME No No
LEVEL1 SMALLINT No No
LEVEL2 SMALLINT No No
LEVEL3 SMALLINT No No
LEVEL4 SMALLINT No No
LEVEL5 SMALLINT No No
LEVEL6 SMALLINT No No
LEVEL7 SMALLINT No No
LEVEL8 SMALLINT No No
LEVEL9 SMALLINT No No
LEVEL_NUM SMALLINT No No
ROW_NUMBER_5 INT No No
DEADLINE_DT datetime No No
CONSTRAINT_DT datetime No No
CONSTRAINT_TYPE VARCHAR(4) No No
COSTING_ACT_SW VARCHAR(1) No No
PC_ACT_OWNER VARCHAR(11) No No
BILL_AMT DECIMAL(26,3) No No
CURRENCY_CD VARCHAR(3) No No
PC_ACT_DEF_CALC_MT VARCHAR(1) No No
Index
Name Type Unique Member
PS_PROJ_ACTIVITY PK Yes
PSAPROJ_ACTIVITY IE1 No
Member(s) of "PS_PROJ_ACTIVITY" Index
BUSINESS_UNIT
PROJECT_ID
ACTIVITY_ID
Member(s) of "PSAPROJ_ACTIVITY" Index
SYNCID

Published June 06, 2007