P6_SYNC_TMPLT

(SQL Table)
 Index Back

Synchronization Template

Synchronization Template Definition - Used to synchronize projects and project attributes between PeopleSoft and Primavera(P6)

  • Related Language Record: P6_SYNC_TMP_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 P6_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL P6 Synchronization Template Id
    2 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    3 PROJ_HDR_EXP_FLG Character(1) VARCHAR2(1) NOT NULL Project Header Export Flag

    Y/N Table Edit

    4 PROJ_HDR_IMP_FLG Character(1) VARCHAR2(1) NOT NULL Project Header Import Flag

    Y/N Table Edit

    5 WBS_ACT_EXP_FLG Character(1) VARCHAR2(1) NOT NULL Work Breakdown / Activity Export Flag

    Y/N Table Edit

    6 WBS_ACT_IMP_FLG Character(1) VARCHAR2(1) NOT NULL Work Breakdown / Activity Import Flag

    Y/N Table Edit

    7 PROJ_TEAM_EXP_FLG Character(1) VARCHAR2(1) NOT NULL Project Team Export Flag

    Y/N Table Edit

    8 PROJ_TEAM_IMP_FLG Character(1) VARCHAR2(1) NOT NULL Project Team Import Flag

    Y/N Table Edit

    9 TEAM_EQUIP_EXP_FLG Character(1) VARCHAR2(1) NOT NULL Project Team Export - Include Equipment (Asset) Assignments

    Y/N Table Edit

    Default Value: N

    10 TEAM_LABOR_EXP_FLG Character(1) VARCHAR2(1) NOT NULL Project Team Export - Include Labor Resource Assignments

    Y/N Table Edit

    Default Value: N

    11 RSRC_ASGN_EXP_FLG Character(1) VARCHAR2(1) NOT NULL Resource Assignment Export Flag

    Y/N Table Edit

    12 RSRC_ASGN_IMP_FLG Character(1) VARCHAR2(1) NOT NULL Resource Assignment Import Flag

    Y/N Table Edit

    13 BUDGT_EXP_FLG Character(1) VARCHAR2(1) NOT NULL Budget Export Flag

    Y/N Table Edit

    14 BUDGT_IMP_FLG Character(1) VARCHAR2(1) NOT NULL Budget Import Flag

    Y/N Table Edit

    15 HRS_WRKD_EXP_FLG Character(1) VARCHAR2(1) NOT NULL Hours Worked Export Flag

    Y/N Table Edit

    16 HRS_WRKD_IMP_FLG Character(1) VARCHAR2(1) NOT NULL Hours Worked Import Flag

    Y/N Table Edit

    17 ACT_COST_EXP_FLG Character(1) VARCHAR2(1) NOT NULL Actual Cost Export Flag

    Y/N Table Edit

    18 ACT_COST_IMP_FLG Character(1) VARCHAR2(1) NOT NULL Actual Cost Import Flag

    Y/N Table Edit

    19 P6_WBS_LVL Number(2,0) SMALLINT NOT NULL Work Breakdown Structure Level
    20 ALL_WBS Character(1) VARCHAR2(1) NOT NULL Entire WBS
    N=Work Breakdown Level
    Y=Entire Work Breakdown

    Default Value: N

    21 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
    22 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
    23 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
    24 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.
    25 WBS_PC_EXP_FLG Character(1) VARCHAR2(1) NOT NULL Percent Complete Export Flag

    Y/N Table Edit

    Default Value: N

    26 WBS_PC_IMP_FLG Character(1) VARCHAR2(1) NOT NULL Percent Complete Import Flag

    Y/N Table Edit

    Default Value: N

    27 WBS_PC_SOURCE Character(1) VARCHAR2(1) NOT NULL Percent Complete Source
    D=Duration Percent Complete
    P=Performance Percent Complete
    U=Unit Percent Complete
    28 CMTMNT_EXP_FLG Character(1) VARCHAR2(1) NOT NULL Commitment Export Flag

    Y/N Table Edit

    29 CMTMNT_IMP_FLG Character(1) VARCHAR2(1) NOT NULL Commitment Import Flag

    Y/N Table Edit