P6_SYNC_TMPLTVW

(SQL View)
 Index Back

Synchronization Template View

Synchronization template view created to give a grid feel for a single template row.

SELECT P6_TEMPLATE_ID , PROJ_HDR_IMP_FLG , PROJ_HDR_EXP_FLG , '01' FROM %Table(P6_SYNC_TMPLT) UNION SELECT P6_TEMPLATE_ID , WBS_ACT_IMP_FLG , WBS_ACT_EXP_FLG , '02' FROM %Table(P6_SYNC_TMPLT) UNION SELECT P6_TEMPLATE_ID , RSRC_ASGN_IMP_FLG , RSRC_ASGN_EXP_FLG , '03' FROM %Table(P6_SYNC_TMPLT) UNION SELECT P6_TEMPLATE_ID , BUDGT_IMP_FLG , BUDGT_EXP_FLG , '04' FROM %Table(P6_SYNC_TMPLT) UNION SELECT P6_TEMPLATE_ID , HRS_WRKD_IMP_FLG , HRS_WRKD_EXP_FLG , '05' FROM %Table(P6_SYNC_TMPLT) UNION SELECT P6_TEMPLATE_ID , ACT_COST_IMP_FLG , ACT_COST_EXP_FLG , '06' FROM %Table(P6_SYNC_TMPLT) UNION SELECT P6_TEMPLATE_ID , CMTMNT_IMP_FLG , CMTMNT_EXP_FLG , '07' FROM %Table(P6_SYNC_TMPLT) UNION SELECT P6_TEMPLATE_ID , PROJ_TEAM_IMP_FLG , PROJ_TEAM_EXP_FLG , '015' FROM %Table(P6_SYNC_TMPLT)

# 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 IMPORT Character(1) VARCHAR2(1) NOT NULL Import Option

Y/N Table Edit

Default Value: N

3 EXPORT Character(1) VARCHAR2(1) NOT NULL Export Analytic Instance
N=No
Y=Yes

Y/N Table Edit

Default Value: N

4 SYNC_OBJ_TYPE Character(3) VARCHAR2(3) NOT NULL Synchronization Object Type
00=Net New Request
00A=Net New Request-Business Unit
01=Project Header
015=Project Team
02=Work Breakdown / Activities
03=Resource Assignment
04=Budget
05=Hours Worked
06=Actual Costs
07=Commitments
08=Create Acknowledgement
09=Labor Resources
10=Resource Rates
11=Materials
12=Equipment
13=Timesheets