PROJECT_FS

(SQL View)
 Index Back

Chartfield Projects View

This view is a special view on the PROJECT table that maps the PROJECT.SET_OVERRIDE column to the PROJECT_FS.SETID column in the view. This view is primarily the basis for customers not using the Projects application. In Projects, General Ledger integration is controlled by "Integration Templates" and prompting uses different views rather than using setid mapping associated with record group FS_08. Customers using the Projects application should have little or no use for this view. Effective Status on PROJECT_FS EFF_STATUS was added as a part of the functionality for Status Control. There are 2 ways to prevent charges to projects and activities: 1. Project and Activity Status - is used to prevent charges in the feeder applications based on the analysis type and the control option. 2. Active/Inactive status - Here EFF_STATUS is used in a view so that projects or activities that are inactive will not even be viewed by users trying to input data - used mainly on PC_FIELDS_WRK. It does not have anything to do with EFF_DATE. EFF_STATUS was used because it was a convenient existing switch. EFF_DATE was never added to PS_PROJECT_FS because it would be too much overhead when trying to join for project reporting or do any processing. The status records are really a way of incorporating effective dating in Projects.

SELECT BUSINESS_UNIT , PROJECT_ID , LAST_ACTIVITY_ID , EFF_STATUS , IN_USE_SW , INTEGRATION_TMPL , DESCR , PROJECT_TYPE , BUSINESS_UNIT_AM , ASSET_ID , PROFILE_ID , SYSTEM_SOURCE , TEMPLATE_ID , TEMPLATE_SW , AFUDC_PROJ_SW , TARGET_PROJ_SW , SALES_TAX_PROJ_SW , DOCKET_NUMBER , PROJECT_FUNCTION , LAST_CRITERIA_ID , CURRENCY_CD , RT_TYPE , CUR_EFFDT_TYPE , PERCENT_COMPLETE , PC_ACT_OPTION , PROJECT_USER1 , PROJECT_USER2 , PROJECT_USER3 , PROJECT_USER4 , PROJECT_USER5 , PROJECT_USER_DT1 , PROJECT_USER_DT2 , PC_USER_CURRENCY , PROJECT_USERAMT1 , PROJECT_USERAMT2 , PROJECT_USERAMT3 , AN_GRP_ACTV_BUD , AN_GRP_TOT_COSTS , SET_OVERRIDE , DTTM_STAMP , PC_MSP_USR1 , PC_MSP_USR2 , PC_MSP_PROJ_ID , PC_REV_ACTIVITY , ENFORCE , enforce_type , TOLERANCE , PC_SCH_PRODUCT , PC_SCH_FIELD1 , PC_SCH_FIELD2 , PC_SCH_FIELD3 , PC_SCH_FIELD4 , PC_SCH_FIELD5 , PC_SCH_FIELD6 , PC_SCH_FIELD7 , PC_SCH_FIELD8 , PC_INDENT_LEVEL , proj_grant_status , grant_flg , gm_primary_flag , pc_template_id , pc_fnd_dist_sw , START_DT , END_DT , BASELINE_START_DT , BASELINE_FINISH_DT , EARLY_START_DT , EARLY_FINISH_DT , ACTUAL_START_DT , ACTUAL_FINISH_DT , LATE_START_DT , LATE_FINISH_DT , PC_DURATION , SUMMARY_PRJ , PC_CHC_SW , PC_CHC_TEMPLATE , PC_CALCULATE_SW , PC_PRJ_DEF_CALC_MT , PC_ACT_DEF_CALC_MT , PC_HOURS_PER_DAY , PC_CALC_METHOD , PC_SUM_METHOD , PM_AUTO_REVIEW , PM_AUTO_POP , FORECAST_AUT_APP , FORECAST_LEVEL , FORECAST_RATE , FORECAST_SRC , PROJ_REQUEST_ID , PPK_PROJ_VERSION , PGM_SCHED_METHOD , PC_PERCENT_DTTM , HOLIDAY_LIST_ID , FMS_DTTM_STAMP , FMS_OPRID , FMS_LASTUPDDTTM , FMS_LASTUPDOPRID , CONSTRAINT_DT_FLG , CHARGING_LEVEL , CHARGING_LEVEL_TR , RATE_PLAN , BUDGET_APPROVER , SCEN_ADJUST_PCT_TM , SCEN_ADJUST_PCT_EX , TEMPLATE_TYPES , PC_TEMPLATE_STATUS , PROJ_TMPL_FILTER , LAST_CBUD_TYPE , LAST_RBUD_TYPE , FNA_REQUESTED , MANAGED_BY_WO , RELEASE , CATEGORY_IND , APPLICATION_AREA , APPLICATION , RATE_SELECT , PC_REV_BUD_AN_GRP , AN_GRP_TOT_REV , AN_GRP_EAC , RETAIN_HISTORY , AN_GRP_FREV , ANLTC_ACT_COST , ANLTC_ACT_REV , ANLTC_FC_COST , ANLTC_FC_REV , ONE_TARGET_SW , P6_INCL_INTGRTN , P6_TEMPLATE_ID , P6_WBS_LVL , PC_REQUEST_ID FROM PS_PROJECT WHERE EFF_STATUS IN ('A', 'I')

  • Related Language Record: PROJECT_LFS

  • Parent Record Of PROJECT_STAT_FS PROJ_STAT_FS

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

    Default Value: PROJECT_FS.SETID

    Prompt Table: SP_BU_FS_NONVW

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

    Prompt Table: PROJECT_ID_VW

    3 LAST_ACTIVITY_ID Number(8,0) INTEGER NOT NULL Last Actvity ID
    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    5 IN_USE_SW Character(1) VARCHAR2(1) NOT NULL Table in use switch
    6 INTEGRATION_TMPL Character(15) VARCHAR2(15) NOT NULL Integration

    Prompt Table: %EDITTABLE

    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
    A=Activity
    G=Grant
    H=Phase
    P=Project
    S=Segment

    Default Value: 00000

    9 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
    10 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
    11 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID
    12 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.

    Default Value: PPC

    13 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template
    14 TEMPLATE_SW Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate whether a given bank transfer transaction should be designated as a

    Y/N Table Edit

    Default Value: N

    15 AFUDC_PROJ_SW Character(1) VARCHAR2(1) NOT NULL Allow Interest Calculation

    Y/N Table Edit

    Default Value: N

    16 TARGET_PROJ_SW Character(1) VARCHAR2(1) NOT NULL Allocation Target

    Y/N Table Edit

    Default Value: N

    17 SALES_TAX_PROJ_SW Character(1) VARCHAR2(1) NOT NULL Allow Sales Tax Calculation

    Y/N Table Edit

    Default Value: N

    18 DOCKET_NUMBER Character(15) VARCHAR2(15) NOT NULL Docket Number
    19 PROJECT_FUNCTION Character(10) VARCHAR2(10) NOT NULL Project Function
    20 LAST_CRITERIA_ID Number(8,0) INTEGER NOT NULL Last Criteria ID
    21 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    22 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.

    Default Value: BUS_UNIT_TBL_PC.RT_TYPE

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

    Default Value: BUS_UNIT_TBL_PC.CUR_EFFDT_TYPE

    24 PERCENT_COMPLETE Number(6,2) DECIMAL(5,2) NOT NULL % Complete
    25 PC_ACT_OPTION Character(1) VARCHAR2(1) NOT NULL Standard Activities
    F=FreeForm Activity ID's
    P=Activity ID's by Project Type

    Default Value: F

    26 PROJECT_USER1 Character(10) VARCHAR2(10) NOT NULL Project User 1
    27 PROJECT_USER2 Character(10) VARCHAR2(10) NOT NULL Project User 2
    28 PROJECT_USER3 Character(10) VARCHAR2(10) NOT NULL Project User 3
    29 PROJECT_USER4 Character(10) VARCHAR2(10) NOT NULL Project User 4
    30 PROJECT_USER5 Character(10) VARCHAR2(10) NOT NULL Project User 5
    31 PROJECT_USER_DT1 Date(10) DATE Date 1
    32 PROJECT_USER_DT2 Date(10) DATE Date 2
    33 PC_USER_CURRENCY Character(3) VARCHAR2(3) NOT NULL User Currency
    34 PROJECT_USERAMT1 Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount 1
    35 PROJECT_USERAMT2 Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount 2
    36 PROJECT_USERAMT3 Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount 3
    37 AN_GRP_ACTV_BUD Character(5) VARCHAR2(5) NOT NULL Budget Analysis Group
    38 AN_GRP_TOT_COSTS Character(5) VARCHAR2(5) NOT NULL Cost Analysis Group
    39 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    40 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    41 PC_MSP_USR1 Character(10) VARCHAR2(10) NOT NULL Microsoft User Define1
    42 PC_MSP_USR2 Character(10) VARCHAR2(10) NOT NULL Microsoft User Define2
    43 PC_MSP_PROJ_ID Character(22) VARCHAR2(22) NOT NULL Unique MSP Project ID
    44 PC_REV_ACTIVITY Character(15) VARCHAR2(15) NOT NULL Revenue Activity

    Prompt Table: PROJ_ACT_STATUS

    45 ENFORCE Character(1) VARCHAR2(1) NOT NULL Enforce project team based prompt. Besides the defined translate values, this field is updated with a value of 'N' when team is not enforced in any of the products.
    E=Expenses
    N=No
    T=Time&Labor
    Y=Exp and TL

    Y/N Table Edit

    Default Value: N

    46 ENFORCE_TYPE Character(1) VARCHAR2(1) NOT NULL Enforce project and activity team based prompt.
    B=Project and Activity Team
    N=Do Not Enforce
    P=Project Team Only
    R=Project Resource Pools Only
    S=Project Activity Resource Pool
    X=Decide at the Project Level

    Default Value: B

    47 TOLERANCE Signed Number(13,8) DECIMAL(11,8) NOT NULL Tolerance Percent
    48 PC_SCH_PRODUCT Character(3) VARCHAR2(3) NOT NULL Product code used by Projects to determine the third party scheduling product being integrated with.
    49 PC_SCH_FIELD1 Character(40) VARCHAR2(40) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    50 PC_SCH_FIELD2 Character(40) VARCHAR2(40) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    51 PC_SCH_FIELD3 Character(40) VARCHAR2(40) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    52 PC_SCH_FIELD4 Character(40) VARCHAR2(40) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    53 PC_SCH_FIELD5 Character(40) VARCHAR2(40) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    54 PC_SCH_FIELD6 Character(40) VARCHAR2(40) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    55 PC_SCH_FIELD7 Character(40) VARCHAR2(40) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    56 PC_SCH_FIELD8 Character(100) VARCHAR2(100) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    57 PC_INDENT_LEVEL Number(3,0) SMALLINT NOT NULL Tree Indent Level
    58 PROJ_GRANT_STATUS Character(1) VARCHAR2(1) NOT NULL Status
    A=Approved
    C=Completed
    I=In Progress
    P=Proposed
    59 GRANT_FLG Character(1) VARCHAR2(1) NOT NULL Grants Management Used for designating whether or not an object is for Grants or for Projects.
    N=Projects Object
    Y=Grants Object
    60 GM_PRIMARY_FLAG Character(1) VARCHAR2(1) NOT NULL This field is used to indicate a Project as a Primary Project

    Y/N Table Edit

    61 PC_TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Rate Template ID
    62 PC_FND_DIST_SW Character(1) VARCHAR2(1) NOT NULL This field is used to indicate the use of Funds Distribution functionality.
    63 START_DT Date(10) DATE NOT NULL Start Date

    Default Value: %Date

    64 END_DT Date(10) DATE NOT NULL End Date

    Default Value: %Date

    65 BASELINE_START_DT Date(10) DATE Baseline Start Date
    66 BASELINE_FINISH_DT Date(10) DATE Baseline Finish Date
    67 EARLY_START_DT Date(10) DATE Early Start Date
    68 EARLY_FINISH_DT Date(10) DATE Early Finish Date
    69 ACTUAL_START_DT Date(10) DATE Actual Start Date
    70 ACTUAL_FINISH_DT Date(10) DATE Actual Finish Date
    71 LATE_START_DT Date(10) DATE Late Start Date
    72 LATE_FINISH_DT Date(10) DATE Late Finish Date
    73 PC_DURATION Number(11,2) DECIMAL(10,2) NOT NULL Duration
    74 SUMMARY_PRJ Character(1) VARCHAR2(1) NOT NULL An indicator to determine whether project is summary or detail.
    N=Detail Project
    Y=Program

    Default Value: N

    75 PC_CHC_SW Character(1) VARCHAR2(1) NOT NULL Enable Change Control

    Y/N Table Edit

    76 PC_CHC_TEMPLATE Character(30) VARCHAR2(30) NOT NULL Change Control Template

    Prompt Table: PC_CHC_CFG

    77 PC_CALCULATE_SW Character(1) VARCHAR2(1) NOT NULL Project-level switch to allow auto-calculation to be turned off if enabled at the BU level.
    D=Delay Calculations Until Save
    M=Manual
    R=Realtime Calculations

    Default Value: M

    78 PC_PRJ_DEF_CALC_MT Character(1) VARCHAR2(1) NOT NULL Calculate The
    D=Duration
    E=End Date
    S=Start Date

    Default Value: D

    79 PC_ACT_DEF_CALC_MT Character(1) VARCHAR2(1) NOT NULL Activity Calculation Method
    D=Duration
    E=End Date
    S=Start Date
    80 PC_HOURS_PER_DAY Number(2,0) SMALLINT NOT NULL Hours per Day
    81 PC_CALC_METHOD Character(1) VARCHAR2(1) NOT NULL Calculation Method
    A=Budget Amount
    D=Duration
    F=Forecast Amount
    H=Forecast Hours
    M=Manual
    U=Budget Hours
    82 PC_SUM_METHOD Character(1) VARCHAR2(1) NOT NULL Summary Method
    N=None
    S=Straight-Line
    W=Weighted
    83 PM_AUTO_REVIEW Character(1) VARCHAR2(1) NOT NULL Auto Review for Billing
    N=Not Reviewed
    Y=Reviewed
    84 PM_AUTO_POP Character(1) VARCHAR2(1) NOT NULL Auto review for POP
    N=No
    Y=Yes
    85 FORECAST_AUT_APP Character(1) VARCHAR2(1) NOT NULL Automatic Forecast Approval
    N=No
    Y=Yes

    Default Value: N

    86 FORECAST_LEVEL Character(1) VARCHAR2(1) NOT NULL Forecast Level
    A=Project/Activity
    P=Project

    Default Value: A

    87 FORECAST_RATE Character(1) VARCHAR2(1) NOT NULL Standard Rate
    E=Resource
    J=Job Code
    R=Role

    Default Value: R

    88 FORECAST_SRC Character(1) VARCHAR2(1) NOT NULL Forecast Source
    F=PeopleSoft Forecast Collection
    M=3rd Party Microsoft Project
    P=3rd Party Primavera

    Default Value: F

    89 PROJ_REQUEST_ID Character(15) VARCHAR2(15) NOT NULL A unique identifier that represents a Project Request.
    90 PPK_PROJ_VERSION Character(15) VARCHAR2(15) NOT NULL An identifier that represents a version of the Project Request.
    91 PGM_SCHED_METHOD Character(1) VARCHAR2(1) NOT NULL The method to be used for Project Scheduling. Valid methods are: Fixed Units, Fixed Duration, and Fixed Work
    D=Fixed Duration
    U=Fixed Units
    W=Fixed Work
    92 PC_PERCENT_DTTM DateTime(26) TIMESTAMP The datetime stamp of when the Project Percent Complete was either last calculated or manually entered.
    93 HOLIDAY_LIST_ID Character(10) VARCHAR2(10) NOT NULL This is used to identify what holiday calendar to use. This is the access field for all financials groups.
    94 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    95 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    96 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    97 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.
    98 CONSTRAINT_DT_FLG Character(1) VARCHAR2(1) NOT NULL Always Honor Constraint Dates
    99 CHARGING_LEVEL Character(1) VARCHAR2(1) NOT NULL Project Charging Level - identifies which level of the WBS activities are available for charging. 'D' indicates the detail level, which means all detail activities are available for charging. '1' indicates level 1 of the WBS is available for charging. '2' indicates level 2 of the WBS is available for charging. '3' indicates level 3 of the WBS is available for charging.
    1=Costing Level 1
    2=Costing Level 2
    3=Costing Level 3
    D=Detail
    100 CHARGING_LEVEL_TR Character(1) VARCHAR2(1) NOT NULL Time Report Charging Level - identifies which level of the WBS activities are available for charging on time reports enter in Expenses. 'D' indicates the detail level, which means all detail activities are available for charging. '1' indicates level 1 of the WBS is available for charging. '2' indicates level 2 of the WBS is available for charging. '3' indicates level 3 of the WBS is available for charging.
    1=Costing Level 1
    2=Costing Level 2
    3=Costing Level 3
    D=Detail
    101 RATE_PLAN Character(15) VARCHAR2(15) NOT NULL Rate Plan - A Rate Plan will allow rate sets to be stacked on top of each other so that the output from one rate set can be used to create additional output from the next rate set. Rate Plans will replace existing Burden Plans in release 8.9. A Rate Plan could be tied to Project Type, Project, Activity or Contract line.
    102 BUDGET_APPROVER Character(11) VARCHAR2(11) NOT NULL Budget Approver - the employee id of the individual who will be responsible for approving budget changes for a given project.
    103 SCEN_ADJUST_PCT_TM Signed Number(7,2) DECIMAL(5,2) NOT NULL Scenario Adjustment % for Time 06/09/2004 PR_FS_B005 Added Label - LABOR_ADJUST
    104 SCEN_ADJUST_PCT_EX Signed Number(7,2) DECIMAL(5,2) NOT NULL Scenario Adjustment % for Expense 06/09/2004 PR_FS_B005 Added Label NON_LABOR_ADJUST
    105 TEMPLATE_TYPES Character(1) VARCHAR2(1) NOT NULL Template Types - used to identify whether a project template is public or private.
    R=Private
    U=Public

    Default Value: U

    106 PC_TEMPLATE_STATUS Character(1) VARCHAR2(1) NOT NULL Template Status
    A=Active
    I=Inactive
    107 PROJ_TMPL_FILTER Character(30) VARCHAR2(30) NOT NULL Template Filter - identifies who is able to view/update a project template. If this field is set to '1', the template is public. If the template is private, this field will contain the operator id of the person who created the template.

    Default Value: 1

    108 LAST_CBUD_TYPE Character(3) VARCHAR2(3) NOT NULL This field stores the last cost budget analysis type used in Projects Budgeting when versioning is turned on.
    109 LAST_RBUD_TYPE Character(3) VARCHAR2(3) NOT NULL This field stores the last revenue budget analysis type used in Projects Budgeting when versioning is turned on.
    110 FNA_REQUESTED Character(1) VARCHAR2(1) NOT NULL Used for Grants type projects only. A flag to indicate whether FNA is requested.
    111 MANAGED_BY_WO Character(1) VARCHAR2(1) NOT NULL Indicates whether a project is Work Order Managed.
    N=No
    Y=Yes

    Default Value: N

    112 RELEASE Character(15) VARCHAR2(15) NOT NULL Release - Carries Release Information driven by the BUSINESS_UNIT
    113 CATEGORY_IND Character(10) VARCHAR2(10) NOT NULL An additional attribute of the project, program, or project request for further classification. This field is user-defined. Examples of usage include "Strategic", "Operational", "Tactical", etc.
    114 APPLICATION_AREA Character(10) VARCHAR2(10) NOT NULL The general area in which an application belongs. Examples: "Financials", "Human Resources", etc.
    115 APPLICATION Character(10) VARCHAR2(10) NOT NULL Usually refers to a software application, such as "Payables", "Projects", "Purchasing", etc. An application needs to be defined under an application area.
    116 RATE_SELECT Character(1) VARCHAR2(1) NOT NULL This will determine selection of 1) Rate Set and 2) Rate Plan in Project Type, Project and Activity.
    1=Rate Set
    2=Rate Plan
    117 PC_REV_BUD_AN_GRP Character(5) VARCHAR2(5) NOT NULL Revenue budget analysis group
    118 AN_GRP_TOT_REV Character(5) VARCHAR2(5) NOT NULL Cost Analysis Group
    119 AN_GRP_EAC Character(5) VARCHAR2(5) NOT NULL Analysis group representing the Estimate at Completion (a.k.a. Forecast).
    120 RETAIN_HISTORY Character(1) VARCHAR2(1) NOT NULL Indicator to determine how often history is retained.
    D=Daily
    M=Monthly
    Q=Quarterly
    W=Weekly
    121 AN_GRP_FREV Character(5) VARCHAR2(5) NOT NULL Forecast Revenue analysis group - contains all the analysis types that make up Forecast Revenue.
    122 ANLTC_ACT_COST Character(5) VARCHAR2(5) NOT NULL Actual Cost analysis group for profitability reporting - contains all the analysis types that make up Actual Cost.
    123 ANLTC_ACT_REV Character(5) VARCHAR2(5) NOT NULL Actual Revenue analysis group for profitability reporting - contains all the analysis types that make up Actual Revenue.
    124 ANLTC_FC_COST Character(5) VARCHAR2(5) NOT NULL Forecast Cost analysis group for profitability reporting - contains all the analysis types that make up Forecast Cost.
    125 ANLTC_FC_REV Character(5) VARCHAR2(5) NOT NULL Forecast Revenue analysis group for profitability reporting - contains all the analysis types that make up Forecast Revenue.
    126 ONE_TARGET_SW Character(1) VARCHAR2(1) NOT NULL Group target definitions
    N=No
    Y=Yes
    127 P6_INCL_INTGRTN Character(1) VARCHAR2(1) NOT NULL Include In Integration

    Default Value: N

    128 P6_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL P6 Synchronization Template Id

    Default Value: BUS_UNIT_OPT_PC.P6_TEMPLATE_ID

    129 P6_WBS_LVL Number(2,0) SMALLINT NOT NULL Work Breakdown Structure Level
    130 PC_REQUEST_ID Character(15) VARCHAR2(15) NOT NULL Request Id