EX_PAGELET_AET

(SQL Table)
Index Back

Expenses Pagelet Cache Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 OPRID2 Character(30) VARCHAR2(30) NOT NULL A user's ID
4 VALUE1 Character(1) VARCHAR2(1) NOT NULL VALUE1
5 VALUE2 Character(1) VARCHAR2(1) NOT NULL VALUE2
6 BEGIN_DT_CAL_START Date(10) DATE Calendar Begin Date for Start
7 END_DT_CAL_END Date(10) DATE Calendar End Date for End
8 DATEVAL1 Date(10) DATE DateVal1
9 DATEVAL2 Date(10) DATE DateVal1
10 DATEVAL3 Date(10) DATE DateVal1
11 DATEVAL4 Date(10) DATE DateVal1
12 DATEVAL5 Date(10) DATE DateVal1
13 END_DATE_01 Date(10) DATE End Date
14 END_DATE_02 Date(10) DATE End Date
15 END_DATE_03 Date(10) DATE End Date
16 END_DATE_04 Date(10) DATE End Date
17 END_DATE_05 Date(10) DATE End Date
18 BEGIN_DT Date(10) DATE Begin Date
19 BEGIN_DT_2 Date(10) DATE Begin Date
20 END_DT Date(10) DATE End Date
21 END_DT_2 Date(10) DATE End Date
22 NUMBER_PERIODS_EX Character(2) VARCHAR2(2) NOT NULL Number of Past Periods
01=01
02=02
03=03
04=04
05=05
06=06
07=07
08=08
09=09
10=10
11=11
12=12
23 NUMBER_PERIODS_EX2 Character(2) VARCHAR2(2) NOT NULL Number of Past Periods
01=01
02=02
03=03
04=04
05=05
06=06
07=07
08=08
09=09
10=10
11=11
12=12
24 NUM_PER Number(3,0) SMALLINT NOT NULL Number of Periods
25 NUM_PER2 Number(3,0) SMALLINT NOT NULL Number of Periods