AE_RUN_CONTROL(SQL Table) |
Index Back |
|---|---|
AE Run Control |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Number(3,0) | SMALLINT NOT NULL | Thread | |
| 2 | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance | |
| 3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 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 | AE_PRODUCT | Character(2) | VARCHAR2(2) NOT NULL |
Product
AE=PS/AE AM=PS/AM AP=PS/AP AR=PS/AR BI=PS/BI EO=PS/EO EX=PS/EX FS=PS/FS GL=PS/GL HR=PS/HR IN=PS/IN OM=PS/OM PC=PS/PC PO=PS/PO TR=PS/TR |
| 7 | AE_APPL_ID | Character(8) | VARCHAR2(8) NOT NULL | Application |
| 8 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 9 | AE_STEP | Character(8) | VARCHAR2(8) NOT NULL | Name |
| 10 | RUN_DTTM | DateTime(26) | TIMESTAMP | Run Date and Time |
| 11 | AE_RTNCD | Number(5,0) | INTEGER NOT NULL | Return Code |
| 12 | AE_CRITICAL_PHASE | Character(1) | VARCHAR2(1) NOT NULL |
Critical
Y/N Table Edit Default Value: N |
| 13 | AE_RUN_DATA_1 | Character(250) | VARCHAR2(250) NOT NULL | Run Data 1 |
| 14 | AE_RUN_DATA_2 | Character(250) | VARCHAR2(250) NOT NULL | Run Data 2 |
| 15 | AE_RUN_DATA_3 | Character(250) | VARCHAR2(250) NOT NULL | Run Data 3 |