PeopleSoft 9
Account Payables

Table Name PROJECT

Table Description
PROJECT
Columns
Name Datatype Is PK Is FK
BUSINESS_UNIT VARCHAR(5) Yes No
PROJECT_ID VARCHAR(15) Yes No
LAST_ACTIVITY_ID int No No
EFF_STATUS VARCHAR(1) No No
IN_USE_SW VARCHAR(1) No No
INTEGRATION_TMPL VARCHAR(15) No No
DESCR VARCHAR(30) No No
PROJECT_TYPE VARCHAR(5) No No
BUSINESS_UNIT_AM VARCHAR(5) No No
ASSET_ID VARCHAR(12) No No
PROFILE_ID VARCHAR(10) No No
SYSTEM_SOURCE VARCHAR(3) No No
TEMPLATE_ID VARCHAR(30) No No
TEMPLATE_SW VARCHAR(1) No No
AFUDC_PROJ_SW VARCHAR(1) No No
TARGET_PROJ_SW VARCHAR(1) No No
SALES_TAX_PROJ_SW VARCHAR(1) No No
DOCKET_NUMBER VARCHAR(15) No No
PROJECT_FUNCTION VARCHAR(10) No No
LAST_CRITERIA_ID int No No
CURRENCY_CD VARCHAR(3) No No
RT_TYPE VARCHAR(5) No No
CUR_EFFDT_TYPE VARCHAR(1) No No
PERCENT_COMPLETE decimal(5,2) No No
PC_ACT_OPTION VARCHAR(1) No No
PROJECT_USER1 VARCHAR(10) No No
PROJECT_USER2 VARCHAR(10) No No
PROJECT_USER3 VARCHAR(10) No No
PROJECT_USER4 VARCHAR(10) No No
PROJECT_USER5 VARCHAR(10) No No
PROJECT_USER_DT1 PSDATE No No
PROJECT_USER_DT2 PSDATE No No
PC_USER_CURRENCY VARCHAR(3) No No
PROJECT_USERAMT1 decimal(15,2) No No
PROJECT_USERAMT2 decimal(15,2) No No
PROJECT_USERAMT3 decimal(15,2) No No
AN_GRP_ACTV_BUD VARCHAR(5) No No
AN_GRP_TOT_COSTS VARCHAR(5) No No
SET_OVERRIDE VARCHAR(5) No No
DTTM_STAMP PSDATETIME No No
PC_MSP_USR1 VARCHAR(10) No No
PC_MSP_USR2 VARCHAR(10) No No
PC_MSP_PROJ_ID VARCHAR(22) No No
PC_REV_ACTIVITY VARCHAR(15) No No
ENFORCE VARCHAR(1) No No
ENFORCE_TYPE VARCHAR(1) No No
TOLERANCE decimal(11,8) No No
PC_SCH_PRODUCT VARCHAR(3) 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
PC_SCH_FIELD8 VARCHAR(100) No No
PC_INDENT_LEVEL SMALLINT No No
PROJ_GRANT_STATUS VARCHAR(1) No No
GRANT_FLG VARCHAR(1) No No
GM_PRIMARY_FLAG VARCHAR(1) No No
PC_TEMPLATE_ID VARCHAR(15) No No
PC_FND_DIST_SW VARCHAR(1) No No
START_DT PSDATE No No
END_DT PSDATE No No
BASELINE_START_DT PSDATE No No
BASELINE_FINISH_DT PSDATE No No
EARLY_START_DT PSDATE No No
EARLY_FINISH_DT PSDATE No No
ACTUAL_START_DT PSDATE No No
ACTUAL_FINISH_DT PSDATE No No
LATE_START_DT PSDATE No No
LATE_FINISH_DT PSDATE No No
PC_DURATION DECIMAL(10,2) No No
SUMMARY_PRJ VARCHAR(1) No No
PC_CHC_SW VARCHAR(1) No No
PC_CHC_TEMPLATE VARCHAR(30) No No
PC_CALCULATE_SW VARCHAR(1) No No
PC_PRJ_DEF_CALC_MT VARCHAR(1) No No
PC_ACT_DEF_CALC_MT VARCHAR(1) No No
PC_HOURS_PER_DAY SMALLINT No No
PC_CALC_METHOD VARCHAR(1) No No
PC_SUM_METHOD VARCHAR(1) No No
PM_AUTO_REVIEW VARCHAR(1) No No
FORECAST_AUT_APP VARCHAR(1) No No
FORECAST_LEVEL VARCHAR(1) No No
FORECAST_RATE VARCHAR(1) No No
FORECAST_SRC VARCHAR(1) No No
PROJ_REQUEST_ID VARCHAR(15) No No
PPK_PROJ_VERSION VARCHAR(15) No No
PGM_SCHED_METHOD VARCHAR(1) No No
PC_PERCENT_DTTM PSDATETIME No No
HOLIDAY_LIST_ID VARCHAR(10) 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
CONSTRAINT_DT_FLG VARCHAR(1) No No
CHARGING_LEVEL VARCHAR(1) No No
CHARGING_LEVEL_TR VARCHAR(1) No No
RATE_PLAN VARCHAR(15) No No
BUDGET_APPROVER VARCHAR(11) No No
SCEN_ADJUST_PCT_TM DECIMAL(5,2) No No
SCEN_ADJUST_PCT_EX DECIMAL(5,2) No No
TEMPLATE_TYPES VARCHAR(1) No No
PROJ_TMPL_FILTER VARCHAR(30) No No
LAST_CBUD_TYPE VARCHAR(3) No No
LAST_RBUD_TYPE VARCHAR(3) No No
FNA_REQUESTED VARCHAR(1) No No
MANAGED_BY_WO VARCHAR(1) No No
RELEASE VARCHAR(15) No No
CATEGORY_IND VARCHAR(10) No No
APPLICATION_AREA VARCHAR(10) No No
APPLICATION VARCHAR(10) No No
RATE_SELECT VARCHAR(1) No No
PC_REV_BUD_AN_GRP VARCHAR(5) No No
AN_GRP_TOT_REV VARCHAR(5) No No
AN_GRP_EAC VARCHAR(5) No No
RETAIN_HISTORY VARCHAR(1) No No
Index
Name Type Unique Member
PS_PROJECT PK Yes
PSAPROJECT IE1 No
Member(s) of "PS_PROJECT" Index
BUSINESS_UNIT
PROJECT_ID
Member(s) of "PSAPROJECT" Index
SYNCID

Published June 06, 2007