GM_PM_BU_PC(SQL Table) |
Index Back |
|---|---|
PM PC BU Setup |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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 |