PROCESS_INSTANCEOPRIDRUN_CNTL_IDPrompt Table: STOCK_TBL
Default Value: 2
Default Value: 1
D=Round Down
S=Standard Rounding
U=Round Up
D=Round Down
S=Standard Rounding
U=Round Up
ST_SPLIT_AET(SQL Table) |
Index Back |
|---|---|
Stock Split AE State RecordStock Split AE State Record holds all bind variables used during the processing of stock splits. |
| # | 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 | STOCK_ID | Character(10) | VARCHAR2(10) NOT NULL |
Company's Stock Identification Symbol
Prompt Table: STOCK_TBL |
| 5 | ST_SPLIT_ID | Character(10) | VARCHAR2(10) NOT NULL | Split ID |
| 6 | RECORD_DT | Date(10) | DATE | Record Date |
| 7 | ST_SPLIT_SHARE_NEW | Number(3,0) | SMALLINT NOT NULL |
Stock Split New Shares
Default Value: 2 |
| 8 | ST_SPLIT_SHARE_OLD | Number(3,0) | SMALLINT NOT NULL |
Stock Split Old Shares
Default Value: 1 |
| 9 | ST_ROUNDING_RULE | Character(1) | VARCHAR2(1) NOT NULL |
Used to determine how the shares will be rounded to the maximum decimal point.
D=Round Down S=Standard Rounding U=Round Up |
| 10 | DEC_PLACES | Number(3,0) | SMALLINT NOT NULL | Number of Decimal Places |
| 11 | ST_ROUNDING_RULE2 | Character(1) | VARCHAR2(1) NOT NULL |
Used to determine how thestock prices will be rounded to the maximum decimal point.
D=Round Down S=Standard Rounding U=Round Up |
| 12 | DEC_PLACES2 | Number(3,0) | SMALLINT NOT NULL | Number of Decimal Places |
| 13 | DECIMAL_VALUE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Value Decimal |
| 14 | DECIMAL_VALUE2 | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Value Decimal |