CF_EXP_AET

(SQL Table)
Index Back

OITBI - Tree Flattener AET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
4 REQUEST_NBR Number(4,0) SMALLINT NOT NULL Request Number
5 PROCESS_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Process Frequency
A=Always Process
N=Don't Run
O=Process Once

Default Value: N

6 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
X=No Success

Default Value: N

7 PROCESS_ORIG Character(1) VARCHAR2(1) NOT NULL Process Origin
N=Other Source
P=Process Scheduler
8 DATE_REQ_OPTION2 Character(1) VARCHAR2(1) NOT NULL Request Date Option
A=As-Of Date
S=System Date

Default Value: S

9 AS_OF_DATE Date(10) DATE As of Date
10 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
11 LANG_INCLUDE Character(1) VARCHAR2(1) NOT NULL Include related languages flag

Y/N Table Edit

Default Value: N

12 EXPORT_FLAG Character(1) VARCHAR2(1) NOT NULL Export Flag
13 EXPORT_FILE Character(1) VARCHAR2(1) NOT NULL Export File Flag

Default Value: Y

14 SETID Character(5) VARCHAR2(5) NOT NULL SetID
15 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
16 DAYS_LOOKBACK Number(4,0) SMALLINT NOT NULL Look Back Days
17 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
18 RUN_CNTL_FLAG Character(1) VARCHAR2(1) NOT NULL Run Control Flag
19 PC Character(1) VARCHAR2(1) NOT NULL Projects
20 DELETE_LIMIT Number(12,0) DECIMAL(12) NOT NULL Used in GL AE batch processes to perform deletes rather than truncate.
21 FIRST_PASS_SW Character(1) VARCHAR2(1) NOT NULL First Pass Switch
22 AE_APPSTATUS Number(1,0) SMALLINT NOT NULL AE Application Warning Status
23 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.