INTFC_PC_GEN_VW

(SQL View)
 Index Back

Interface Project General View

ADD MODE

SELECT INTFC_ID , INTFC_LINE_NUM , BUSINESS_UNIT , PROJECT_ID , INTFC_TYPE , SYSTEM_SOURCE , APPROVAL_SW , INTFC_STATUS , LOAD_STATUS , ORIG_INTFC_ID , ORIG_LINE_NUM , INTEGRATION_TMPL , DESCR , PROJECT_TYPE , BUSINESS_UNIT_AM , ASSET_ID , PROFILE_ID , GROUP_ASSET_ID , PARENT_ID , AM_DISTRIB_STATUS , QUANTITY , TAG_NUMBER , TRANS_CODE , TEMPLATE_ID , TEMPLATE_SW , AFUDC_PROJ_SW , TARGET_PROJ_SW , SALES_TAX_PROJ_SW , DOCKET_NUMBER , PROJECT_FUNCTION , DTTM_STAMP , OPRID , PROCESS_INSTANCE , DESCR254 , ADDRESS_ID , LOCATION_EFFDT , EFFSEQ , LOCATION , LOCATION_FRACTION , CUST_ID , PS_OWNER , FLEX_FORMULA , TEAM_MEMBER , PROJ_ROLE , EMAILID , MANAGER_EFFDT , PROJECT_MANAGER , ROLE_TYPE , MANAGER_START_DT , MANAGER_END_DT , STATUS_EFFDT , PROJECT_STATUS , START_DT_2 , END_DT_2 , PROJECT_PRIORITY , PERCENT_COMPLETE , INTEREST_FACTOR , MILESTONE_EFFDT , MILESTONE_TYPE , MILESTONE_CODE , MILESTONE_ORIGIN , TRANS_DT , ACCOUNTING_DT , SCHEDULE_TYPE , SCHEDULE_STATUS , SCHEDULE_DESCR , FROM_DT , TO_DT , DOCUMENT_TYPE , DOCUMENT_NAME , DOCUMENT_PATH , 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 , PROJ_TOLERANCE_TYP , PROJ_TOLERANCE_AMT , PROJ_TOLERANCE_PCT , %subrec(ADDRESS_SBR, PS_INTFC_PROJ_GEN) , START_DT , END_DT , EARLY_START_DT , EARLY_FINISH_DT , ACTUAL_START_DT , ACTUAL_FINISH_DT , BASELINE_START_DT , BASELINE_FINISH_DT , LATE_START_DT , LATE_FINISH_DT , 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 , DESCRSHORT , PC_INDENT_LEVEL , SUMMARY_PRJ , PC_PROCESS_STATUS , PROJ_REQUEST_ID , PPK_PROJ_VERSION , PGM_SCHED_METHOD , PC_PERCENT_DTTM , HOLIDAY_LIST_ID , CONSTRAINT_DT_FLG , CHARGING_LEVEL , CHARGING_LEVEL_TR , RATE_PLAN , BUDGET_APPROVER , SCEN_ADJUST_PCT_TM , SCEN_ADJUST_PCT_EX , MANAGED_BY_WO , 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 FROM PS_INTFC_PROJ_GEN

  • Parent record: PROJ_ACTIVITY

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID
    2 INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Interface Line Number
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_PC_NONVW

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

    Default Value: NEXT

    5 INTFC_TYPE Character(3) VARCHAR2(3) NOT NULL Trans Load Type
    6 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.
    7 APPROVAL_SW Character(1) VARCHAR2(1) NOT NULL Auto Approval Status
    8 INTFC_STATUS Character(3) VARCHAR2(3) NOT NULL Interface Status
    CON=Consolidated
    DON=Mass Changes Generated
    ERR=Error
    NEW=Mass Changes Not Generated
    REP=Replaced by Other Records (AP)
    UNI=Unitized
    9 LOAD_STATUS Character(3) VARCHAR2(3) NOT NULL /* -> JMZ. PSOFT. 11-OCT-2002 */ New Status were added : HLD and INP for Asset Management. /* <- JMZ. PSOFT. 11-OCT-2002 */
    CON=Consolidated
    DON=Loaded
    ERR=Errored
    EXC=Excluded
    HLD=On Hold
    INP=In Process
    NEW=Pending
    PGI=PO Grp Incomplete
    REP=Replaced
    UNI=Unitized
    10 ORIG_INTFC_ID Number(8,0) INTEGER NOT NULL Original Interface ID
    11 ORIG_LINE_NUM Number(8,0) INTEGER NOT NULL Original Interface Line Number
    12 INTEGRATION_TMPL Character(15) VARCHAR2(15) NOT NULL Integration

    Prompt Table: PC_INT_TMPL

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

    Prompt Table: PROJ_TYPE_TBL

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

    Prompt Table: SP_BU_AM_NONVW

    16 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

    Prompt Table: PROJ_ASSET_VW

    17 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

    Prompt Table: PROFILE_PCAM_VW

    18 GROUP_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Group Asset ID
    19 PARENT_ID Character(12) VARCHAR2(12) NOT NULL Parent ID
    20 AM_DISTRIB_STATUS Character(1) VARCHAR2(1) NOT NULL AM Distribution Status
    D=Distributed
    I=Ignore
    M=Modified
    N=Not Distributed
    P=Pending
    V=Reversed
    21 QUANTITY Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Interface
    22 TAG_NUMBER Character(12) VARCHAR2(12) NOT NULL Tag Number
    23 TRANS_CODE Character(5) VARCHAR2(5) NOT NULL Transaction Code
    24 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template

    Prompt Table: PROJECT_TMPL_VW

    25 TEMPLATE_SW Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate whether a given bank transfer transaction should be designated as a
    26 AFUDC_PROJ_SW Character(1) VARCHAR2(1) NOT NULL Allow Interest Calculation
    27 TARGET_PROJ_SW Character(1) VARCHAR2(1) NOT NULL Allocation Target
    28 SALES_TAX_PROJ_SW Character(1) VARCHAR2(1) NOT NULL Allow Sales Tax Calculation
    29 DOCKET_NUMBER Character(15) VARCHAR2(15) NOT NULL Docket Number
    30 PROJECT_FUNCTION Character(10) VARCHAR2(10) NOT NULL Project Function
    31 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.
    32 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    33 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    34 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    35 ADDRESS_ID Character(3) VARCHAR2(3) NOT NULL Address ID
    36 LOCATION_EFFDT Date(10) DATE Location Effective Date
    37 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    38 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    39 LOCATION_FRACTION Number(4,2) DECIMAL(3,2) NOT NULL Fraction of Cost at Location
    40 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
    41 PS_OWNER Character(2) VARCHAR2(2) NOT NULL PeopleSoft Owner
    AM=Asset Management
    AP=Accounts Payable
    AR=Accounts Receivable
    BD=Budgets
    BI=Billing
    CA=Contracts
    CM=Cost Management
    CS=Customer Service
    EN=Engineering
    EX=Expenses
    GL=General Ledger
    HR=Human Resources
    IN=Inventory
    MG=Manufacturing
    OM=Order Management
    PC=Project Costing
    PL=Planning
    PO=Purchasing
    PR=Production Control
    PT=PeopleTools
    TL=Time and Labor
    TR=Treasury
    42 FLEX_FORMULA Character(15) VARCHAR2(15) NOT NULL Formula Name
    43 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member
    44 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
    45 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
    46 MANAGER_EFFDT Date(10) DATE Project Manager Effective Date
    47 PROJECT_MANAGER Character(11) VARCHAR2(11) NOT NULL Project Manager
    48 ROLE_TYPE Character(6) VARCHAR2(6) NOT NULL Service Type
    APR=Approver
    MGR=Manager
    OPR=Operator
    49 MANAGER_START_DT Date(10) DATE Project Manager Start Date
    50 MANAGER_END_DT Date(10) DATE Project Manager End Date
    51 STATUS_EFFDT Date(10) DATE Project Status Effective Date
    52 PROJECT_STATUS Character(1) VARCHAR2(1) NOT NULL Project Status
    B=Budgeted
    C=Closed
    H=Hold
    O=Open
    P=Proposed
    53 START_DT_2 Date(10) DATE Start Date
    54 END_DT_2 Date(10) DATE End Date
    55 PROJECT_PRIORITY Number(3,0) SMALLINT NOT NULL Project Priority
    56 PERCENT_COMPLETE Number(6,2) DECIMAL(5,2) NOT NULL % Complete
    57 INTEREST_FACTOR Signed Number(5,2) DECIMAL(3,2) NOT NULL Interest Calculation Factor
    58 MILESTONE_EFFDT Date(10) DATE Milestone Effective Date
    59 MILESTONE_TYPE Character(5) VARCHAR2(5) NOT NULL Milestone Type
    60 MILESTONE_CODE Character(15) VARCHAR2(15) NOT NULL Milestone Code
    61 MILESTONE_ORIGIN Character(1) VARCHAR2(1) NOT NULL Milestone Origin
    A=Project
    C=Contract
    62 TRANS_DT Date(10) DATE Transaction Date
    63 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple
    64 SCHEDULE_TYPE Character(15) VARCHAR2(15) NOT NULL Phase Type
    65 SCHEDULE_STATUS Character(1) VARCHAR2(1) NOT NULL Schedule Status
    A=Actual Schedule
    E=Estimated Schedule
    66 SCHEDULE_DESCR Character(30) VARCHAR2(30) NOT NULL Project Schedule Description
    67 FROM_DT Date(10) DATE From Date
    68 TO_DT Date(10) DATE To Date
    69 DOCUMENT_TYPE Character(3) VARCHAR2(3) NOT NULL Document Type
    123=Lotus 1-2-3
    AVI=Video for Windows
    CAD=AutoCad Document
    DOC=Microsoft Winword
    MPP=MicroSoft Project
    NON=No Document Type
    PST=PeopleSoft PeopleTools
    SCR=Lotus ScreenCam
    TLP=TimeLine for Windows
    TXT=Notepad for ASCII Text
    XLS=Microsoft Excel
    70 DOCUMENT_NAME Character(30) VARCHAR2(30) NOT NULL Document Path and Name
    71 DOCUMENT_PATH Character(80) VARCHAR2(80) NOT NULL Application Path
    72 PROJECT_USER1 Character(10) VARCHAR2(10) NOT NULL Project User 1
    73 PROJECT_USER2 Character(10) VARCHAR2(10) NOT NULL Project User 2
    74 PROJECT_USER3 Character(10) VARCHAR2(10) NOT NULL Project User 3
    75 PROJECT_USER4 Character(10) VARCHAR2(10) NOT NULL Project User 4
    76 PROJECT_USER5 Character(10) VARCHAR2(10) NOT NULL Project User 5
    77 PROJECT_USER_DT1 Date(10) DATE Date 1
    78 PROJECT_USER_DT2 Date(10) DATE Date 2
    79 PC_USER_CURRENCY Character(3) VARCHAR2(3) NOT NULL User Currency
    80 PROJECT_USERAMT1 Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount 1
    81 PROJECT_USERAMT2 Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount 2
    82 PROJECT_USERAMT3 Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount 3
    83 AN_GRP_ACTV_BUD Character(5) VARCHAR2(5) NOT NULL Budget Analysis Group
    84 AN_GRP_TOT_COSTS Character(5) VARCHAR2(5) NOT NULL Cost Analysis Group
    85 SET_OVERRIDE Character(5) VARCHAR2(5) NOT NULL FS_08 SetID
    86 PROJ_TOLERANCE_TYP Character(1) VARCHAR2(1) NOT NULL Proj Activity Tolerance Type
    A=Fixed Amount
    P=Percent
    87 PROJ_TOLERANCE_AMT Number(18,2) DECIMAL(17,2) NOT NULL Project Tolerance Amount
    88 PROJ_TOLERANCE_PCT Number(3,0) SMALLINT NOT NULL Project Tolerance Percent
    89 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    90 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    91 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    92 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    93 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    94 CITY Character(30) VARCHAR2(30) NOT NULL City
    95 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    96 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    97 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat
    WW=Trailer
    98 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    99 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    100 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    101 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    102 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: %EDIT_STATE

    103 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    104 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    105 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    106 START_DT Date(10) DATE NOT NULL Start Date
    107 END_DT Date(10) DATE NOT NULL End Date
    108 EARLY_START_DT Date(10) DATE Early Start Date
    109 EARLY_FINISH_DT Date(10) DATE Early Finish Date
    110 ACTUAL_START_DT Date(10) DATE Actual Start Date
    111 ACTUAL_FINISH_DT Date(10) DATE Actual Finish Date
    112 BASELINE_START_DT Date(10) DATE Baseline Start Date
    113 BASELINE_FINISH_DT Date(10) DATE Baseline Finish Date
    114 LATE_START_DT Date(10) DATE Late Start Date
    115 LATE_FINISH_DT Date(10) DATE Late Finish Date
    116 PC_SCH_PRODUCT Character(3) VARCHAR2(3) NOT NULL Product code used by Projects to determine the third party scheduling product being integrated with.
    117 PC_SCH_FIELD1 Character(40) VARCHAR2(40) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    118 PC_SCH_FIELD2 Character(40) VARCHAR2(40) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    119 PC_SCH_FIELD3 Character(40) VARCHAR2(40) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    120 PC_SCH_FIELD4 Character(40) VARCHAR2(40) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    121 PC_SCH_FIELD5 Character(40) VARCHAR2(40) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    122 PC_SCH_FIELD6 Character(40) VARCHAR2(40) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    123 PC_SCH_FIELD7 Character(40) VARCHAR2(40) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    124 PC_SCH_FIELD8 Character(100) VARCHAR2(100) NOT NULL Generic field used for Projects Third Party Schedule Integration.
    125 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    126 PC_INDENT_LEVEL Number(3,0) SMALLINT NOT NULL Tree Indent Level
    127 SUMMARY_PRJ Character(1) VARCHAR2(1) NOT NULL An indicator to determine whether project is summary or detail.
    N=Detail Project
    Y=Program
    128 PC_PROCESS_STATUS Character(1) VARCHAR2(1) NOT NULL The processing state of a project.
    A=Active
    I=Inactive
    P=Pending
    T=Template
    129 PROJ_REQUEST_ID Character(15) VARCHAR2(15) NOT NULL A unique identifier that represents a Project Request.
    130 PPK_PROJ_VERSION Character(15) VARCHAR2(15) NOT NULL An identifier that represents a version of the Project Request.
    131 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
    132 PC_PERCENT_DTTM DateTime(26) TIMESTAMP The datetime stamp of when the Project Percent Complete was either last calculated or manually entered.
    133 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.
    134 CONSTRAINT_DT_FLG Character(1) VARCHAR2(1) NOT NULL Always Honor Constraint Dates

    Y/N Table Edit

    135 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
    136 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
    137 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.
    138 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.

    Prompt Table: PC_CHC_BUD_APR

    139 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
    140 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
    141 MANAGED_BY_WO Character(1) VARCHAR2(1) NOT NULL Indicates whether a project is Work Order Managed.
    N=No
    Y=Yes
    142 PC_REV_BUD_AN_GRP Character(5) VARCHAR2(5) NOT NULL Revenue budget analysis group
    143 AN_GRP_TOT_REV Character(5) VARCHAR2(5) NOT NULL Cost Analysis Group
    144 AN_GRP_EAC Character(5) VARCHAR2(5) NOT NULL Analysis group representing the Estimate at Completion (a.k.a. Forecast).
    145 RETAIN_HISTORY Character(1) VARCHAR2(1) NOT NULL Indicator to determine how often history is retained.
    D=Daily
    M=Monthly
    Q=Quarterly
    W=Weekly
    146 AN_GRP_FREV Character(5) VARCHAR2(5) NOT NULL Forecast Revenue analysis group - contains all the analysis types that make up Forecast Revenue.
    147 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.
    148 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.
    149 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.
    150 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.
    151 ONE_TARGET_SW Character(1) VARCHAR2(1) NOT NULL Group target definitions
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: BUS_UNIT_OPT_PC.ONE_TARGET_SW

    152 P6_INCL_INTGRTN Character(1) VARCHAR2(1) NOT NULL Include In Integration

    Y/N Table Edit

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