PROCESS_INSTANCEI=Ignore
N=Next Sequence ID
O=Overwrite
X=No Action
1=Project ID
2=Activity ID
3=Resource ID
4=Budget ID
5=Inactive Resource
6=Invalid Budget Calendar
N=Detail Activity
Y=Summary Activity
N=No
Y=Yes
PC_DUP_AET(SQL Table) |
Index Back |
|---|---|
Duplication LibraryState record used in PC_DUP_AELIB for Duplication Process |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | PC_CPY_UNIQUEID | Character(15) | VARCHAR2(15) NOT NULL | Copy Unique ID |
| 5 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 6 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 7 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 8 | TEAM_MEMBER | Character(30) | VARCHAR2(30) NOT NULL | Team Member |
| 9 | PC_BUDGET_ID | Number(3,0) | SMALLINT NOT NULL | Budget Plan ID |
| 10 | PC_TEMP_REC_NAME | Character(20) | VARCHAR2(20) NOT NULL | Temporary Record (Table) |
| 11 | DUPLICATE_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Duplication actions
I=Ignore N=Next Sequence ID O=Overwrite X=No Action |
| 12 | PROJECT_ID_TARGET | Character(15) | VARCHAR2(15) NOT NULL | Project ID |
| 13 | DUPLICATE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Duplicate Type
1=Project ID 2=Activity ID 3=Resource ID 4=Budget ID 5=Inactive Resource 6=Invalid Budget Calendar |
| 14 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 15 | PROBLEM_ID | Character(15) | VARCHAR2(15) NOT NULL | Problem ID |
| 16 | IN_USE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Row in use flag |
| 17 | LAST_ACTIVITY_ID | Number(8,0) | INTEGER NOT NULL | Last Actvity ID |
| 18 | ACTV_FLD_LENGTH | Number(3,0) | SMALLINT NOT NULL | Activity ID Field Length |
| 19 | WORK_CNT8 | Number(8,0) | INTEGER NOT NULL | Count of Anything |
| 20 | ACT_TEMPLATE_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity Template |
| 21 | LAST_BUDGET_ID | Number(8,0) | INTEGER NOT NULL | Last Budget ID |
| 22 | ROW_NUMBER_5 | Number(5,0) | INTEGER NOT NULL | Row Number |
| 23 | LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL | Level |
| 24 | WBS_ID | Character(100) | VARCHAR2(100) NOT NULL | WBS ID |
| 25 | LEVEL1 | Number(5,0) | INTEGER NOT NULL | Level 1 |
| 26 | LEVEL2 | Number(5,0) | INTEGER NOT NULL | Level 2 |
| 27 | LEVEL3 | Number(5,0) | INTEGER NOT NULL | Level 3 |
| 28 | LEVEL4 | Number(5,0) | INTEGER NOT NULL | Level 4 |
| 29 | LEVEL5 | Number(5,0) | INTEGER NOT NULL | Level 5 |
| 30 | LEVEL6 | Number(5,0) | INTEGER NOT NULL | Level 6 |
| 31 | LEVEL7 | Number(5,0) | INTEGER NOT NULL | Level 7 |
| 32 | LEVEL8 | Number(5,0) | INTEGER NOT NULL | Level 8 |
| 33 | LEVEL9 | Number(5,0) | INTEGER NOT NULL | Level 9 |
| 34 | LEVEL10 | Number(5,0) | INTEGER NOT NULL | Level 10 |
| 35 | LEVEL11 | Number(5,0) | INTEGER NOT NULL | Level 11 |
| 36 | LEVEL12 | Number(5,0) | INTEGER NOT NULL | Level 12 |
| 37 | LEVEL13 | Number(5,0) | INTEGER NOT NULL | Level 13 |
| 38 | LEVEL14 | Number(5,0) | INTEGER NOT NULL | Level 14 |
| 39 | LEVEL15 | Number(5,0) | INTEGER NOT NULL | Level 15 |
| 40 | LEVEL16 | Number(5,0) | INTEGER NOT NULL | Level 16 |
| 41 | LEVEL17 | Number(5,0) | INTEGER NOT NULL | Level 17 |
| 42 | LEVEL18 | Number(5,0) | INTEGER NOT NULL | Level 18 |
| 43 | LEVEL19 | Number(5,0) | INTEGER NOT NULL | Level 19 |
| 44 | LEVEL20 | Number(5,0) | INTEGER NOT NULL | Level 20 |
| 45 | LEVEL21 | Number(5,0) | INTEGER NOT NULL | Level 21 |
| 46 | LEVEL22 | Number(5,0) | INTEGER NOT NULL | Level 22 |
| 47 | LEVEL23 | Number(5,0) | INTEGER NOT NULL | Level 23 |
| 48 | LEVEL24 | Number(5,0) | INTEGER NOT NULL | Level 24 |
| 49 | LEVEL25 | Number(5,0) | INTEGER NOT NULL | Level 25 |
| 50 | LEVEL26 | Number(5,0) | INTEGER NOT NULL | Level 26 |
| 51 | SUMMARY_ACT | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether an activity is summary or detail.
N=Detail Activity Y=Summary Activity |
| 52 | WS_CHILD_NODE | Character(20) | VARCHAR2(20) NOT NULL | Used in views requiring child tree node. |
| 53 | FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag
N=No Y=Yes |