AE_REQUEST |
index back |
---|---|
AE Request |
PeopleSoft Field Name | Field Type | Column Type | Description |
---|---|---|---|
OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN |
RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
REQUEST_NBR | Number(4,0) | SMALLINT NOT NULL | Request Number |
PROCESS_FREQUENCY | Character(1) | VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process N=Don't Run O=Process Once Default: O |
AE_PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Process Status
A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now Default: N |
PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
PROCESS_ORIG | Character(1) | VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source P=Process Scheduler Default: N |
GOTO_PROCESS_STAT | Character(1) | VARCHAR2(1) NOT NULL | Go To Process Status |
LAST_RUN_DTM | DateTime(26) | TIMESTAMP | Last Run On |
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 |
AE_APPL_ID | Character(8) | VARCHAR2(8) NOT NULL |
Application
Prompt Table: AE_APPL_TBL |
index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |