Table Detail Report
OMF_SAE_CSV_DEF
Column Section | Top of Page |
Table-level Detail
Description: | OMF SAE CSV DEF |
Definition: | Holds the CSV file definitions used by the PowerVision Subject Area Editor. |
Table Type: | REFERENCE |
Column Detail - OMF_SAE_CSV_DEF
Column Name | Type | Null? | Definition |
---|---|---|---|
COLUMN_NAME | VARCHAR(255) | N | Name of column to be generated in CSV file. |
COLUMN_SEQ | DOUBLE | Y | Order of column in the CSV file definition. |
COLUMN_TYPE | VARCHAR(2) | N | Data type of the column. (I, VC) |
CSV_NAME | VARCHAR(255) | N | Name of csv file definition that "column_name" belongs to. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
OMF_ST_ENGINE_SCRIPTS
Column Section | Top of Page |
Table-level Detail
Description: | Defines scripts called from the summary table engine. |
Definition: | Defines scripts called from the summary table engine. These scripts will fill the request structure(s) and perform any qualifications/calculations needed for the summary table fill scripts. |
Table Type: | REFERENCE |
Column Detail - OMF_ST_ENGINE_SCRIPTS
Column Name | Type | Null? | Definition |
---|---|---|---|
ARRAY_STR | VARCHAR(255) | Y | Array string. |
CALC_SCRIPT | VARCHAR(255) | Y | Script called by the summary table engine to perform calculations on the current transaction. |
CALC_ST_SCRIPT | VARCHAR(255) | Y | Summary table fill script called after calculation(s) have been performed. |
CALC_WHEN_QUAL_IND | DOUBLE | Y | Defines whether or not a qualification has to occur in order to run the calculation script. Values: 1 - only perform the calculation if the transaction qualifies 0 - perform the calculation on every transaction |
COLUMN_STR | VARCHAR(255) | Y | Column string. |
PRODUCT_CD | DOUBLE | N | Defines the product for which the summary table scripts will be run. |
QUALIFY_MULTIPLE_IND | DOUBLE | Y | Defines whether or not the product allows qualifying for multiple qualification records. |
QUALIFY_SCRIPT | VARCHAR(255) | Y | The script called by the summary table engine for rule qualification. |
REQUEST_SCRIPT | VARCHAR(255) | Y | The script called by the summary table engine in order to fill out the request structure. |
SCRIPT_ORDER | DOUBLE | N | The order in which the scripts will be processed for the given product. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
OMF_ST_FILL_SCRIPTS
Column Section | Top of Page |
Table-level Detail
Description: | Defines the scripts called by the summary table engine to fill smry tbls. |
Definition: | Defines the scripts called by the summary table engine to fill the summary tables for a given product. |
Table Type: | REFERENCE |
Column Detail - OMF_ST_FILL_SCRIPTS
Column Name | Type | Null? | Definition |
---|---|---|---|
PRODUCT_CD | DOUBLE | N | The product for which the summary table fill scripts will be run. |
SCRIPT_ORDER | DOUBLE | N | The order in which the summary table fill scripts will be run for a given product. |
ST_FILL_SCRIPT | VARCHAR(255) | N | The script called by the summary table engine to fill the summary tables for a given product. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
OMF_ST_REQUEST
Column Section | Top of Page |
Table-level Detail
Description: | OMF ST REQUEST |
Definition: | Defines the request structures for the summary table engine. |
Table Type: | REFERENCE |
Column Detail - OMF_ST_REQUEST
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
REQUEST_STRUCTURE_NAME | VARCHAR(255) | N | The name of the request structure that will be defined for use in the summary table engine. |
RS_SEQ | DOUBLE | N | The order in which items are defined in the request structure. |
RS_STRING | VARCHAR(132) | Y | The variable(s) defined within the request structure. They will be used by different scripts called within the summary table engine. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |