FTLAGD_AET

(SQL Table)
Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 FIELDLIST Character(254) VARCHAR2(254) NOT NULL Used to store a list of FieldNames
3 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive
4 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
5 WHERE_CLAUSE1 Character(254) VARCHAR2(254) NOT NULL Where Clause
6 WHERE_CLAUSE2 Character(254) VARCHAR2(254) NOT NULL Where Clause
7 WHERE_CLAUSE3 Character(254) VARCHAR2(254) NOT NULL Where Clause
8 FROM_CLAUSE Character(254) VARCHAR2(254) NOT NULL From Clause
9 EXPAND_RECNAME Character(20) VARCHAR2(20) NOT NULL Recname expanded with the proper prefix, normally ps_
10 EXPAND_RECNAME1 Character(20) VARCHAR2(20) NOT NULL Recname expanded with the proper prefix, normally ps_
11 EXPAND_RECNAME2 Character(20) VARCHAR2(20) NOT NULL Recname expanded with the proper prefix, normally ps_
12 PROD_EXISTS Character(1) VARCHAR2(1) NOT NULL Field psft_product exists in the temp table record