P6_ERR_CHK_AET(SQL Table) |
Index Back |
|---|---|
State Record for Error CheckState Record for Error Check Program for PSFT-Primavera P6 Integration. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW |
| 3 | 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 Default Value: P |
| 4 | ONLINE_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
On-line Sourcing Routine
Y/N Table Edit Default Value: Y |
| 5 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: SP_PROJ_NONVW |
| 6 | RUN_PROCESS_FLG | Character(1) | VARCHAR2(1) NOT NULL | Run Process Flag |
| 7 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 8 | OPRID2 | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 9 | RUN_CNTL_ID2 | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 10 | PROC_INSTANCE_SYNC | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance Sync |
| 11 | PROJ_INIT_IMP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Initiate New Project Import Flag |
| 12 | PROJ_INIT_EXP_FLG | Character(1) | VARCHAR2(1) NOT NULL | Initiate New Project Export Flag |