P6_SYNLGMST_AET

(SQL Table)
Index Back

Master Data Subscription AET

Master Data Subscription (Async) AET table.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
4 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
5 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number
6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
7 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
8 ONLINE_SOURCE Character(1) VARCHAR2(1) NOT NULL On-line Sourcing Routine
9 OPRID2 Character(30) VARCHAR2(30) NOT NULL A user's ID
10 RUN_CNTL_ID2 Character(30) VARCHAR2(30) NOT NULL Run Control ID
11 PROC_INSTANCE_SYNC Number(10,0) DECIMAL(10) NOT NULL Process Instance Sync
12 LABOR_RESOURCE_FLG Character(1) VARCHAR2(1) NOT NULL Labor Resources
13 RESOURCE_RATE_FLG Character(1) VARCHAR2(1) NOT NULL Resource Rates by Employee
14 PSFT_RSRC_TYPE Character(10) VARCHAR2(10) NOT NULL Resource Type
15 RSRC_OBJECTID Number(10,0) DECIMAL(10) NOT NULL Resource Object ID
16 RSRCRT_OBJECTID Number(10,0) DECIMAL(10) NOT NULL Resource Rate Object ID
17 RECNAME_TMP Character(15) VARCHAR2(15) NOT NULL Record (Table) Name
18 COUNT_XREF Number(10,0) DECIMAL(10) NOT NULL Xref Count