BI_DESCR_AET

(SQL Table)
Index Back

Field Descrip. AETcache record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 NAME_PREFIX Character(4) VARCHAR2(4) NOT NULL Name Prefix
1=Mr.
2=Mrs.
3=Ms.
3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
4 FIELDNAME1 Character(18) VARCHAR2(18) NOT NULL Field Name 1
5 FIELD_DESCR_NAME Character(18) VARCHAR2(18) NOT NULL Decription Field name
6 FIELDNAME_OUT Character(18) VARCHAR2(18) NOT NULL Output Fieldname
7 FIELDDESCR Character(20) VARCHAR2(20) NOT NULL Description
8 BASE_RECORD Character(15) VARCHAR2(15) NOT NULL Base Record
9 RELLANGRECNAME Character(15) VARCHAR2(15) NOT NULL Related Language Record Name
10 DESCR_TBL_TYPE Character(4) VARCHAR2(4) NOT NULL Description table type
EFF=Effective Dated Table
NEFF=No Effective Date Table
SEFF=SetId & Effdt Table
SET=SetId without Effdt Table
XLAT=TranslateTable
11 SETCNTRLFLD Character(18) VARCHAR2(18) NOT NULL Tree Structure Node User Key Field Name
12 KEYPOSN Number(3,0) SMALLINT NOT NULL Key Position
13 KEYNAME Character(18) VARCHAR2(18) NOT NULL Key Name
14 KEY1_FLDNAME Character(18) VARCHAR2(18) NOT NULL Key 1 Field Name
15 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
16 FIELD_VALUE Character(30) VARCHAR2(30) NOT NULL Field Value
17 FIELDVAL1 Character(30) VARCHAR2(30) NOT NULL Field Value 1
18 FIELDVAL2 Character(30) VARCHAR2(30) NOT NULL Field Value 2
19 FIELDVAL3 Character(30) VARCHAR2(30) NOT NULL Field Value 3
20 FIELDVAL4 Character(30) VARCHAR2(30) NOT NULL Field Value 3
21 FIELDVAL5 Character(250) VARCHAR2(250) NOT NULL Field Value 5
22 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value
23 DESCR_VALUE_1 Character(30) VARCHAR2(30) NOT NULL Description
24 COUNT_1 Number(3,0) SMALLINT NOT NULL Count Work Field
25 COUNT_5 Number(3,0) SMALLINT NOT NULL Count
26 PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL Processing Flag
27 BI_ACTION_FLG Character(1) VARCHAR2(1) NOT NULL Determine if a Bill Action was selected.
28 INVOICE_DT Date(10) DATE Invoice Date
29 REPORT_LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code
30 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
31 BASE_LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
32 LANGUAGE_OPTION Character(1) VARCHAR2(1) NOT NULL Language Option
O=Specified Language
R=Recipient's Language
33 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
34 META_SQL_STRING Character(30) VARCHAR2(30) NOT NULL META SQL string
35 SELECT_PARM Character(254) VARCHAR2(254) NOT NULL Dynamic Where Clause Sel Parms
36 SELECT_PARM1 Character(254) VARCHAR2(254) NOT NULL Dynamic Where Select Parms 1
37 SELECT_PARM2 Character(254) VARCHAR2(254) NOT NULL Dynamic Where Select Parms 2
38 SELECT_CLAUSE Character(254) VARCHAR2(254) NOT NULL Select Clause
39 SELECT_CLAUSE2 Character(254) VARCHAR2(254) NOT NULL Select Clause 2
40 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
41 WHERE_CLAUSE1 Character(254) VARCHAR2(254) NOT NULL Where Clause
42 AE_WHERE_LONG1 Long Character(1300) VARCHAR2(1300) AE Where Clause Long String.