IT_EXCPT2_AET

(SQL Table)
Index Back

Manage Exceptions State Record

Manage Exceptions State Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1
3 FIELDNAME2 Character(18) VARCHAR2(18) NOT NULL Fieldname 2
4 FIELDNAME3 Character(18) VARCHAR2(18) NOT NULL Field Name
5 FIELDNAME4 Character(18) VARCHAR2(18) NOT NULL Field Name
6 FIELDNAME5 Character(18) VARCHAR2(18) NOT NULL Field Name
7 UPDATE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Meta SQL
8 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
9 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
10 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
11 LEFT_PAREN Character(1) VARCHAR2(1) NOT NULL Left Parenthesis
12 RIGHT_PAREN Character(1) VARCHAR2(1) NOT NULL Right Parenthesis
13 COUNTER Number(10,0) DECIMAL(10) NOT NULL Counter

Default Value: 0

14 FROM_CLAUSE Character(254) VARCHAR2(254) NOT NULL From Clause
15 COUNTER1 Number(16,2) DECIMAL(15,2) NOT NULL Counter 1

Default Value: 0

16 FIRST_PASS_SW Character(1) VARCHAR2(1) NOT NULL First Pass Switch
17 ERROR_SW Character(1) VARCHAR2(1) NOT NULL Error if no Source Data
18 AE_PUBLIC_SW Character(1) VARCHAR2(1) NOT NULL App Engine public switch
19 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
20 COUNTER8 Number(8,0) INTEGER NOT NULL Counter - Unsigned 8
21 COUNTER9 Number(16,2) DECIMAL(15,2) NOT NULL Counter 1
22 WHERE_CLAUSE1 Character(254) VARCHAR2(254) NOT NULL Where Clause