EQTN_OPERAND_SQLEFFDTEQTN_SQL_CHUNK_SEQC=Customer Data
D=Demonstration Data
S=System Data
Default Value: C
EQTN_SQL_CHUNKS(SQL Table) |
Index Back |
|---|---|
Equation SQL Broken to ChunksEquation SQL Broken to Chunks |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EQTN_OPERAND_SQL |
Character(30) | VARCHAR2(30) NOT NULL | Equation Processor SQL that can be called. This sqlid will dovetail into potential merging with the sqlid field of tools 8. |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | EQTN_SQL_CHUNK_SEQ |
Number(5,0) | INTEGER NOT NULL | Equation Processor Callable SQL broken from SQL_TEXT in long varchar 8192 format into chunks of 254 bytes each, sequenced by this field: equation chunk sequence. |
| 4 | EQTN_SQL_CHUNK | Character(254) | VARCHAR2(254) NOT NULL | Equation SQL Chunk. Sql Text of long varchar 8192 format must be broken down into pieces less than or equal to 255. However, you cannot create an online field of length greater than 254 without getting errors regarding helpcontext numbers. |
| 5 | SCC_DATA_TYPE_CD | Character(1) | VARCHAR2(1) NOT NULL |
Data Type code indicates whether a row of data is system data, demo data, or customer data.
C=Customer Data D=Demonstration Data S=System Data Default Value: C |