FOMB_BULKFL_AET

(SQL Table)
Index Back

Create GTAS Bulk File

Used as a state record for Creating GTAS Bulk File

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
3 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
4 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
5 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
7 REPORT_ID Character(8) VARCHAR2(8) NOT NULL Report Identifier
8 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
9 GTAS_INCLUDE_BAL Character(1) VARCHAR2(1) NOT NULL Include $0 Balances
10 GTAS_FILENAME Character(80) VARCHAR2(80) NOT NULL GTAS File Name
11 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
12 TAS_GWA Character(26) VARCHAR2(26) NOT NULL TAS GWA
13 FED_CLASS_FLD Character(4) VARCHAR2(4) NOT NULL Fed Class Field code
14 FED_DEFC Character(3) VARCHAR2(3) NOT NULL Disaster Emergency Fund Code
15 FED_PROGRAM Character(4) VARCHAR2(4) NOT NULL Fed Program Code
16 GTAS_REIMBURSE_IND Character(1) VARCHAR2(1) NOT NULL Reimbursable Ind
17 ERROR_FLAG Character(1) VARCHAR2(1) NOT NULL Error Flag
18 FLAG Character(1) VARCHAR2(1) NOT NULL Flag
N=No
Y=Yes
19 SQL_TEXT_LONG Long Character(4000) CLOB Dynamic SQL string
20 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
21 SQL_WHERE_001 Character(254) VARCHAR2(254) NOT NULL
22 SQL_WHERE_002 Character(254) VARCHAR2(254) NOT NULL
23 REC_NAME Character(18) VARCHAR2(18) NOT NULL Record Name
24 RECNAME_18 Character(18) VARCHAR2(18) NOT NULL used in table CFOBJECT_TMP for App Engine FS_CFUPDATE.ViewSrch to look for view/table dependencies.