RUN_CNTL_PGM_P6

(SQL Table)
 Index Back

Project/Master/Global Data

Run Control Record for Project and Master/Global Data synchronization.

  • Parent Record Of P6_RSRC_ASSBTYP P6_RSRC_ASSTLOC P6_RSRC_ASTYP P6_RSRC_CAT P6_RSRC_DEPT P6_RSRC_EMPLID P6_RSRC_INVID P6_RSRC_ITMGRP P6_RSRC_ITMTYP P6_RSRC_JOBCODE P6_RSRC_LOC P6_RSRC_MANUF P6_RSRC_MODEL P6_RSRC_SHOPID P6_RSRC_TAGNBR RUN_PGM_P6_CNTR RUN_PGM_P6_LOC RUN_PGM_P6_MNGR RUN_PGM_P6_RNGE RUN_PGM_P6_TYPE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: OPR_DEF_TBL_PC.OPRID

    2 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
    3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    4 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number

    Default Value: 1

    5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT

    Prompt Table: SP_BU_PC_NONVW

    6 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    7 RESOURCE_RATE_FLG Character(1) VARCHAR2(1) NOT NULL Resource Rates by Employee

    Y/N Table Edit

    Default Value: N

    8 LABOR_RESOURCE_FLG Character(1) VARCHAR2(1) NOT NULL Labor Resources

    Y/N Table Edit

    Default Value: N

    9 BUSINESS_UNIT_HR Character(5) VARCHAR2(5) NOT NULL Business Unit HR

    Prompt Table: SP_BURSHR_NONVW

    10 MATERIALS_FLG Character(1) VARCHAR2(1) NOT NULL Materials

    Y/N Table Edit

    Default Value: N

    11 BUSINESS_UNIT_IN Character(5) VARCHAR2(5) NOT NULL Inventory Unit

    Prompt Table: SP_BUIN_NONVW

    12 ASSET_FLG Character(1) VARCHAR2(1) NOT NULL Assets Applicable

    Y/N Table Edit

    Default Value: N

    13 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

    Prompt Table: SP_BU_AM_NONVW

    14 ITM_STATUS_CURRENT Character(1) VARCHAR2(1) NOT NULL Item Status Current
    1=Active
    2=Hold
    3=Discontinue
    4=Inactive
    5=Pending Approval
    6=Denied Approval
    7=Under Initialization
    15 SCHEDULABLE_SW Character(1) VARCHAR2(1) NOT NULL Schedulable Switch

    Y/N Table Edit

    Default Value: N

    16 PROJ_HDR_SYNC_FLG Character(1) VARCHAR2(1) NOT NULL Project Header Synchronization Flag

    Y/N Table Edit

    Default Value: N

    17 BUDGT_SYNC_FLG Character(1) VARCHAR2(1) NOT NULL Budget Synchronization Flag

    Y/N Table Edit

    Default Value: N

    18 WBS_ACT_SYNC_FLG Character(1) VARCHAR2(1) NOT NULL Work Breakdown / Activity Synchronization Flag

    Y/N Table Edit

    Default Value: N

    19 HRS_WRKD_SYNC_FLG Character(1) VARCHAR2(1) NOT NULL Hours Worked Sync Flag

    Y/N Table Edit

    Default Value: N

    20 PROJ_TEAM_SYNC_FLG Character(1) VARCHAR2(1) NOT NULL Project Team Synchronization Flag

    Y/N Table Edit

    Default Value: N

    21 ACT_COST_SYNC_FLG Character(1) VARCHAR2(1) NOT NULL Actual Cost Sync Flag

    Y/N Table Edit

    Default Value: N

    22 RSRC_ASGN_SYNC_FLG Character(1) VARCHAR2(1) NOT NULL Resource Assignment Sync Flag

    Y/N Table Edit

    Default Value: N

    23 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    24 PROJECT_STATUS Character(1) VARCHAR2(1) NOT NULL Project Status
    B=Budgeted
    C=Closed
    H=Hold
    O=Open
    P=Proposed

    Prompt Table: PROJ_STAT_VW

    25 PROJ_INIT_IMP_FLG Character(1) VARCHAR2(1) NOT NULL Initiate New Project Import Flag

    Y/N Table Edit

    Default Value: N

    26 PROJ_INIT_EXP_FLG Character(1) VARCHAR2(1) NOT NULL Initiate New Project Export Flag

    Y/N Table Edit

    Default Value: N

    27 NET_NEW Character(1) VARCHAR2(1) NOT NULL An indicator to specify that a third-party Project and all of its children have never been synchronized into PeopleSoft, and thus is net new to PeopleSoft.
    N=No
    Y=Yes
    28 ERR_CHK_OPTN Character(1) VARCHAR2(1) NOT NULL Error Check Option
    B=All
    P=All Projects
    R=All Master Data
    S=Specified Project
    T=All Time Data

    Default Value: P

    29 ONLINE_SOURCE Character(1) VARCHAR2(1) NOT NULL On-line Sourcing Routine

    Y/N Table Edit

    Default Value: Y

    30 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

    Prompt Table: SP_PROJ_NONVW

    31 OPRID2 Character(30) VARCHAR2(30) NOT NULL A user's ID
    32 RUN_CNTL_ID2 Character(30) VARCHAR2(30) NOT NULL Run Control ID
    33 PROC_INSTANCE_SYNC Number(10,0) DECIMAL(10) NOT NULL Process Instance Sync
    34 CMTMNT_SYNC_FLG Character(1) VARCHAR2(1) NOT NULL Commitment Sync Flag

    Y/N Table Edit

    Default Value: N

    35 P6_AND_OR_1 Character(3) VARCHAR2(3) NOT NULL P6 AND / OR Option
    AND=AND
    OR=OR

    Default Value: AND

    36 P6_AND_OR_2 Character(3) VARCHAR2(3) NOT NULL P6 And / Or Option
    AND=AND
    OR=OR

    Default Value: AND

    37 P6_AND_OR_3 Character(3) VARCHAR2(3) NOT NULL P6 And / Or option
    AND=AND
    OR=OR

    Default Value: AND

    38 P6_AND_OR_1_MST Character(3) VARCHAR2(3) NOT NULL P6 And / Or option
    AND=AND
    OR=OR

    Default Value: AND

    39 P6_AND_OR_2_MST Character(3) VARCHAR2(3) NOT NULL P6 And / Or option
    AND=AND
    OR=OR

    Default Value: AND

    40 P6_AND_OR_3_MST Character(3) VARCHAR2(3) NOT NULL P6 And / Or option
    AND=AND
    OR=OR

    Default Value: AND

    41 P6_AND_OR_4_MST Character(3) VARCHAR2(3) NOT NULL P6 And / Or option
    AND=AND
    OR=OR

    Default Value: AND

    42 P6_AND_OR_5_MST Character(3) VARCHAR2(3) NOT NULL P6 And / Or option
    AND=AND
    OR=OR

    Default Value: AND

    43 P6_AND_OR_6_MST Character(3) VARCHAR2(3) NOT NULL P6 And / Or option
    AND=AND
    OR=OR

    Default Value: AND

    44 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

    Prompt Table: PC_TREESTRCT_VW

    45 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

    Prompt Table: PC_TREE_NODE_VW

    46 TREE_EFFDT Date(10) DATE Effective date of the Tree

    Prompt Table: PC_TREE_EFDT_VW