EODU_DATE_AET(SQL Table) |
Index Back |
---|---|
Date Update Manager State RecState 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 |