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 |