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
Set Control Field: BUSINESS_UNIT_PC

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
Set Control Field: BUSINESS_UNIT_GL

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
Set Control Field: BUSINESS_UNIT

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