BUGRP_AET(SQL Table) |
Index Back |
|---|---|
BU Process Group AETBU Process Group AE state 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 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | ACTION_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Action Flag
A=Action |
| 5 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 6 | PROCESS_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Process Status
A=Active C=Successfully Completed E=Completed With Errors N=Not Yet Processed P=Processing Now X=No Success |
| 7 | AS_OF_DATE | Date(10) | DATE | As of Date |
| 8 | BU_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Business Unit Option
A=All Business Units R=Range of Business Units V=Specific Business Unit |
| 9 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 10 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 11 | FIELDNAME_TARGET | Character(18) | VARCHAR2(18) NOT NULL | Allocations Target amount field |
| 12 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |
| 13 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 14 | FLAG1 | Character(1) | VARCHAR2(1) NOT NULL | Flag1 |
| 15 | FLAG2 | Character(1) | VARCHAR2(1) NOT NULL | Flag2 |
| 16 | FLAG3 | Character(1) | VARCHAR2(1) NOT NULL | Flag3 |
| 17 | FLAG4 | Character(1) | VARCHAR2(1) NOT NULL | Flag4 |
| 18 | FLAG5 | Character(1) | VARCHAR2(1) NOT NULL | Flag5 |
| 19 | FLAG6 | Character(1) | VARCHAR2(1) NOT NULL | Flag 6 |
| 20 | FLAG7 | Character(1) | VARCHAR2(1) NOT NULL | Flag 7 |
| 21 | FLAG8 | Character(1) | VARCHAR2(1) NOT NULL | Flag 8 |
| 22 | KEY1 | Character(65) | VARCHAR2(65) NOT NULL | First Key |
| 23 | KEY2 | Character(65) | VARCHAR2(65) NOT NULL | Second Key |
| 24 | KEY3 | Character(65) | VARCHAR2(65) NOT NULL | Third Key |
| 25 | KEY4 | Character(65) | VARCHAR2(65) NOT NULL | Fourth Key |
| 26 | KEY5 | Character(65) | VARCHAR2(65) NOT NULL | Fifth Key |
| 27 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 28 | NUMBER1 | Number(10,0) | DECIMAL(10) NOT NULL | Number |
| 29 | NUMBER2 | Number(10,0) | DECIMAL(10) NOT NULL | Number |
| 30 | NUMBER3 | Number(10,0) | DECIMAL(10) NOT NULL | Number |
| 31 | NUMBER4 | Number(10,0) | DECIMAL(10) NOT NULL | Number |
| 32 | NUMBER5 | Number(10,0) | DECIMAL(10) NOT NULL | Number |
| 33 | PRCSNAME | Character(12) | VARCHAR2(12) NOT NULL | Process Name |
| 34 | RECNAME_BU | Character(15) | VARCHAR2(15) NOT NULL | Business Unit Recname |
| 35 | RECNAME_BU_TMP | Character(15) | VARCHAR2(15) NOT NULL | Temp table holding Business Unit values |
| 36 | RECNAME_BUGRP_TMP | Character(15) | VARCHAR2(15) NOT NULL | BU Process Group Temp Table |
| 37 | RECNAME_CFV_TMP | Character(15) | VARCHAR2(15) NOT NULL | CFV Temp |
| 38 | RECNAME_SETID | Character(15) | VARCHAR2(15) NOT NULL | Set Id Record Name |
| 39 | RECNAME_TARGET | Character(15) | VARCHAR2(15) NOT NULL | Target Recname |
| 40 | REQ_DATE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Request Date Option
A=As of Date P=Business Unit Process Date |
| 41 | ROWCOUNT1 | Number(12,0) | DECIMAL(12) NOT NULL | Row Count |
| 42 | SCE_ID | Character(10) | VARCHAR2(10) NOT NULL | ID |
| 43 | SELECT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Selection Flag
N=No Y=Yes |
| 44 | SEQ_NBR_3 | Number(3,0) | SMALLINT NOT NULL | Sequence |
| 45 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 46 | SQL_TEXT30 | Character(30) | VARCHAR2(30) NOT NULL | SQL Text |
| 47 | SQL_TEXT | Character(254) | VARCHAR2(254) NOT NULL | SQL Text |
| 48 | SQL_TEXT1 | Character(254) | VARCHAR2(254) NOT NULL | SQL Text 1 |
| 49 | WHERE_BU | Character(254) | VARCHAR2(254) NOT NULL | WHERE CLAUSE |
| 50 | WHERE_CLAUSE | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 51 | WHERE_CLAUSE2 | Character(254) | VARCHAR2(254) NOT NULL | Where Clause |
| 52 | FIELD_LIST | Long Character(4000) | CLOB | Field List |