PROCESS_INSTANCECON=Consolidated
DON=Loaded
ERR=Errored
EXC=Excluded
HLD=On Hold
INP=In Process
NEW=Pending
PGI=PO Grp Incomplete
REP=Replaced
UNI=Unitized
N=No
Y=Yes
Default Value: N
PC_DEL_PREP_AET(SQL Table) |
Index Back |
|---|---|
State Rec for Del Prep App EngState record used for the app engine that preps for the delete utility app engine. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | INTFC_ID | Number(8,0) | INTEGER NOT NULL | Interface ID |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 5 | LOAD_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
/* -> JMZ. PSOFT. 11-OCT-2002 */
New Status were added : HLD and INP for Asset Management.
/* <- JMZ. PSOFT. 11-OCT-2002 */
CON=Consolidated DON=Loaded ERR=Errored EXC=Excluded HLD=On Hold INP=In Process NEW=Pending PGI=PO Grp Incomplete REP=Replaced UNI=Unitized |
| 6 | PC_SEL_ALL_ACT | Character(1) | VARCHAR2(1) NOT NULL |
Select All Activity Templates
N=No Y=Yes Default Value: N |
| 7 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 8 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |