BUS_UNIT_TBL_PC

(SQL Table)
 Index Back

PC Business Unit Table

PC Business Unit Table

  • Parent Record Of CA_PRJ_MS_VW_LG CA_PRJ_NONVW_LG GM_PROJECT_LANG GM_PROJ_VW PC_HLTH_CRITERA PC_PROJECT_SBR PC_PROJT_LG PC_WC_PROJ_LGVW PROJECT PROJECT_CPLANG PROJECT_DEL_VW PROJECT_DEL_VWL PROJECT_FS_LANG PROJECT_LANG PROJECT_NON_SUM PROJECT_NS_LANG PROJID_SRCH_VW PROJ_FIN_SM_DVW PSA_PROJSRCH_VW RS_PROJ_BU_LANG RS_PROJ_PCBU_VW SP_CAPRJ4_CLSVW SP_CAPRJ4_NONVW SP_CAPRJ4_OPRVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT

    2 LAST_INTFC_ID Number(8,0) INTEGER NOT NULL Last Interface ID

    Default Value: 10000000

    3 LAST_CONT_NUM_PC Number(8,0) INTEGER NOT NULL Last Contract Number PC
    4 IN_USE_SW Character(1) VARCHAR2(1) NOT NULL Table in use switch
    5 CAT_EDIT_OPTION Character(3) VARCHAR2(3) NOT NULL Category Edit Option
    IND=Independent
    OVR=Override
    REL=Related

    Default Value: IND

    6 SUB_EDIT_OPTION Character(3) VARCHAR2(3) NOT NULL SubCategory Edit Option
    IND=Independent
    OVR=Override
    REL=Related

    Default Value: IND

    7 CATEGORY_EDIT Character(15) VARCHAR2(15) NOT NULL Category Edit Table

    Default Value: PROJ_CATG_TBL

    Prompt Table: RECDEFN_VW

    8 SUBCATEGORY_EDIT Character(15) VARCHAR2(15) NOT NULL SubCategory Edit Table

    Default Value: PROJ_SUBCAT_TBL

    Prompt Table: RECDEFN_VW

    9 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    10 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

    Prompt Table: RT_TYPE_TBL

    11 CUR_EFFDT_TYPE Character(1) VARCHAR2(1) NOT NULL Currency Eff. Date Default
    A=Accounting Date
    C=Current Date
    T=Transaction Date

    Default Value: A

    12 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID

    Prompt Table: CAL_DETL_VW

    13 FLEX_TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Flexible Analysis Template

    Default Value: 1

    14 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

    Prompt Table: PC_GL_CAL_VW

    15 UOM_HOURS Character(3) VARCHAR2(3) NOT NULL The Unit of Measure that represents Hours.

    Default Value: MHR

    Prompt Table: UNITS_TBL

    16 DAYS_UOM Character(3) VARCHAR2(3) NOT NULL the unit of measure for days

    Default Value: MDY

    Prompt Table: UNITS_TBL

    17 PC_RT_TYPE_TRN_SRC Character(1) VARCHAR2(1) NOT NULL Indicator to determine which rate type to use in Multi-currency for transactions coming into Projects. Default will be the PCBU rate type.
    P=Projects BU
    S=Source

    Default Value: P

    18 CRIT_SEQ Number(8,0) INTEGER NOT NULL Criteria Sequence