EODU_DATE_AET

(SQL Table)
Index Back

Date Update Manager State Rec

State record for AE DUM_DATE_AE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
4 EODU_PROCESS_GRP Character(10) VARCHAR2(10) NOT NULL Process Group
5 EODU_TYPE Character(1) VARCHAR2(1) NOT NULL DUM Processing Type
1=Refresh
2=Reset
6 EODU_APPL_GRP Character(15) VARCHAR2(15) NOT NULL A group of records that make up an Application Group for processing sample data dates.
7 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
8 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
9 EODU_DATA_DATE_NEW Date(10) DATE The new processing date of the Application Group.
10 EODU_DATA_DATE_INT Date(10) DATE The initial date of the Application Group.
11 EODU_DATA_DATE_PRV Date(10) DATE The previous processing date of the Application Group.
12 DAYS_DIFF Signed Number(7,0) DECIMAL(6) NOT NULL Payment Days Difference
13 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
14 EODU_UPD_ALL_DATES Character(1) VARCHAR2(1) NOT NULL Switch to indicate that all dates will be updated.
15 EODU_UPD_PERIODS Character(1) VARCHAR2(1) NOT NULL Switch to indicate that periods are to be updated.
16 SETID Character(5) VARCHAR2(5) NOT NULL SetID
17 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
18 EODU_AND_OR_OPER Character(1) VARCHAR2(1) NOT NULL Operator
1=AND
2=OR
19 EODU_AND_OR_TEXT Character(3) VARCHAR2(3) NOT NULL Represents 'AND' or 'OR' SQL operator syntax when the user is creating node specific data selection criteria wi
AND=AND
OR=OR
20 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
21 EODU_DATE_FNAME Character(18) VARCHAR2(18) NOT NULL "(Generic field that crosses multiple products; in Treasury
22 EODU_LOGIC_OPR Character(1) VARCHAR2(1) NOT NULL Logic Operator
1=LIKE
2=NOT LIKE
3==
4=>
5=<
6=<>
7=>=
8=<=
9=IN
23 EODU_LOGIC_OPR_TXT Character(10) VARCHAR2(10) NOT NULL Logic Operator for building WHERE clause
24 EODU_MATCH_VALUE Character(100) VARCHAR2(100) NOT NULL Value to Match
25 EODU_FNAME_PERIOD Character(18) VARCHAR2(18) NOT NULL Fieldname of the Period Field
26 EODU_FNAME_YEAR Character(18) VARCHAR2(18) NOT NULL Fieldname of the Year field
27 EODU_FNAME_DATE Character(18) VARCHAR2(18) NOT NULL Fieldname of the Date
28 EODU_PRE_AE_APPL Character(12) VARCHAR2(12) NOT NULL Program Name
29 EODU_PRE_AE_SECT Character(8) VARCHAR2(8) NOT NULL Section
30 EODU_POST_AE_APPL Character(12) VARCHAR2(12) NOT NULL Program Name
31 EODU_POST_AE_SECT Character(8) VARCHAR2(8) NOT NULL Section
32 EODU_WHERE_CLAUSE Long Character(4000) CLOB Where Clause