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 |