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.