GM_PM_BU_PC(SQL Table) |
Index Back |
---|---|
PM PC BU Setup |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
2 | INTEGRATION_TMPL | Character(15) | VARCHAR2(15) NOT NULL |
Integration
Prompt Table:
PC_INT_TMPLGLVW
|
3 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL |
Ledger Group
Prompt Table: SP_LEDGPC_NONVW |
4 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL |
Ledger
Prompt Table:
SP_LEDPC_NONVW
|
5 | LEDGER_GROUP_2 | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
6 | LEDGER_2 | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
7 | PC_SUM_CAL_ID | Character(2) | VARCHAR2(2) NOT NULL |
Default Summary Calendar ID
Prompt Table:
CAL_BP_VW
|
8 | UOM_HOURS | Character(3) | VARCHAR2(3) NOT NULL |
The Unit of Measure that represents Hours.
Default Value: BUS_UNIT_TBL_PC.UOM_HOURS Prompt Table: UNITS_TBL |
9 | DAYS_UOM | Character(3) | VARCHAR2(3) NOT NULL |
the unit of measure for days
Default Value: BUS_UNIT_TBL_PC.DAYS_UOM Prompt Table: UNITS_TBL |
10 | UOM_WEEKS | Character(3) | VARCHAR2(3) NOT NULL |
The Unit of Measure that represents Weeks
Default Value: MWK Prompt Table: UNITS_TBL |
11 | RATE_PLAN_BIL_CST | Character(15) | VARCHAR2(15) NOT NULL |
*Bill & Cost Rate Plan
Prompt Table: GM_RATE_PLN_B_C |
12 | RATE_PLAN_BIL | Character(15) | VARCHAR2(15) NOT NULL |
Bill Rate Plan
Prompt Table: GM_RATE_PLN_BIL |
13 | RATE_PLAN_CST | Character(15) | VARCHAR2(15) NOT NULL |
Cost Rate Plan
Prompt Table: GM_RATE_PLN_CST |
14 | UOM_RSRC_OTHR | Character(3) | VARCHAR2(3) NOT NULL |
The Unit of Measure that represents team member (resource) class of Other.
Default Value: EA Prompt Table: UNITS_TBL |
15 | PROJECT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Project Status
B=Budgeted C=Closed H=Hold O=Open P=Proposed Prompt Table: PROJ_STATUS_TBL |