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 | 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 |