SOURCE_INSTANCEEQTZ_PROCLOG_VW(SQL View) |
Index Back |
|---|---|
Equitization Process Log View |
| SELECT PROCESS_INSTANCE + %DecMult(REQUEST_NBR, 0.0001) ,PROCESS_INSTANCE ,REQUEST_NBR ,SETID ,EQUITIZATION_GROUP ,TREE_NAME ,TREE_LEVEL ,TREE_NODE ,AS_OF_DATE ,CURRENCY_CD FROM PS_EQTZ_PROC_LOG WHERE CREATE_LOG_SW = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SOURCE_INSTANCE |
Number(15,4) | DECIMAL(14,4) NOT NULL | Identifies a Process Instance (PROCESS_INSTANCE), and is used by the PeopleSoft Process Scheduler to save this identifier. |
| 2 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 3 | REQUEST_NBR | Number(4,0) | SMALLINT NOT NULL | Request Number |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | EQUITIZATION_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Equitization Group |
| 6 | TREE_NAME | Character(18) | VARCHAR2(18) NOT NULL | Tree Name |
| 7 | TREE_LEVEL | Character(10) | VARCHAR2(10) NOT NULL | Tree Level Number |
| 8 | TREE_NODE | Character(20) | VARCHAR2(20) NOT NULL | Node name |
| 9 | AS_OF_DATE | Date(10) | DATE | As of Date |
| 10 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |