PFT_REPORT



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT REPORT
Definition: This is the parent table for the ProFit reporting structures.
Table Type: REFERENCE





Column Detail - PFT_REPORT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
COMPRESS_IND DOUBLE N Indicates compression of report: 0 = No Compression, 1 = Compression
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
FORMAT_TYPE_FLAG DOUBLE N Defines the report format type: 0 = ASCII, 1=Postscript, 2=Other DIO, 3 = PDF, 4 = Excel
ORIENTATION_IND DOUBLE N Indicates orientation of report: 0 = Portrait, 1=Landscape
PFT_ENTITY_TYPE_CD DOUBLE N Type of query defined as defined for custom batch in workflow.
PFT_REPORT_ID DOUBLE N This is the primary key to the table.
QUERY_BLOB_ID DOUBLE N References LONG_BLOB_REFERENCE to store queries used for custom batch processing.
REPORT_DESC VARCHAR(255) Y This is a description of the purpose of the report.
REPORT_NAME VARCHAR(50) Y This is the user defined name of the report.
REPORT_OBJECT_NAME VARCHAR(32) Y This is the CCL object name of the report.
REPORT_TYPE_FLAG DOUBLE Y This is the report type flag
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - PFT_REPORT


Child Column in PFT_REPORT(FK) Parent Table Name Parent Column Name
Parents: QUERY_BLOB_ID LONG_BLOB_REFERENCE LONG_BLOB_ID




Parent Column in PFT_REPORT (PK) Child Table Name Child Column Name
Children: PFT_REPORT_ID KPI_DAILY_TOTAL PFT_REPORT_ID
PFT_REPORT_INSTANCE PFT_REPORT_ID
PFT_REPORT_PROMPT_RELTN PFT_REPORT_ID


PFT_REPORT_INSTANCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT REPORT INSTANCE
Definition: This activity table stores information about a specific instance of a report
Table Type: ACTIVITY





Column Detail - PFT_REPORT_INSTANCE


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CREATE_DT_TM DATETIME Y Date/Time that report instance was created
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
ERROR_IND DOUBLE N Indicates error running reports
ERROR_MSG VARCHAR(2000) Y Error message from executing report
INSTANCE_NAME VARCHAR(250) Y Name of report from event param
ITEM_STATUS_CD DOUBLE N Current state of the custom batch entity
PARAMS_VALUE VARCHAR(2000) Y Value of param string passed into pft_run_report
PERSISTENT_IND DOUBLE N Indicates whether or not the report file associated with this instance is persistent
PFT_EVENT_ID DOUBLE N Foreign key to Pft_Event table
PFT_REPORT_ID DOUBLE N Foreign key to Pft_Report table
PFT_REPORT_INSTANCE_ID DOUBLE N Unique identifier of this table
PRSNL_ID DOUBLE N Foreign key to the Person table
RETENTION_DAYS DOUBLE N Number of days the persistent report file is kept on system
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.



Relationship Detail - PFT_REPORT_INSTANCE


Child Column in PFT_REPORT_INSTANCE(FK) Parent Table Name Parent Column Name
Parents: PFT_EVENT_ID PFT_EVENT PFT_EVENT_ID
PFT_REPORT_ID PFT_REPORT PFT_REPORT_ID
PRSNL_ID PRSNL PERSON_ID




Parent Column in PFT_REPORT_INSTANCE (PK) Child Table Name Child Column Name
Children: PFT_REPORT_INSTANCE_ID PFT_QUEUE_ITEM PFT_REPORT_INSTANCE_ID
PFT_QUEUE_ITEM_HIST PFT_REPORT_INSTANCE_ID
PFT_RPT_BLOB_RELTN PFT_REPORT_INSTANCE_ID


PFT_REPORT_OPTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT REPORT OPTION
Definition: This is the ProFit report option table.
Table Type: REFERENCE





Column Detail - PFT_REPORT_OPTION


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
ENUM_PROMPT_TEXT VARCHAR(50) Y enum prompt text
PFT_REPORT_OPTION_ID DOUBLE N This is the primary key to the table.
PFT_REPORT_PROMPT_ID DOUBLE N Foreign Key to the PFT_Report_Prompt table
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.



Relationship Detail - PFT_REPORT_OPTION


Child Column in PFT_REPORT_OPTION(FK) Parent Table Name Parent Column Name
Parents: PFT_REPORT_PROMPT_ID PFT_REPORT_PROMPT PFT_REPORT_PROMPT_ID


PFT_REPORT_PROMPT



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT REPORT PROMPT
Definition: This is the ProFit table that stores the prompt information for reports.
Table Type: REFERENCE





Column Detail - PFT_REPORT_PROMPT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CUSTOM_PROMPT_OBJECT VARCHAR(32) Y custom prompt object
DEFAULT_PROMPT_TEXT VARCHAR(50) Y default prompt text
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
PFT_REPORT_PROMPT_ID DOUBLE N This is the primary key to the table.
PROMPT_DATA_SET_NBR DOUBLE Y prompt data set number
PROMPT_DATA_TYPE_CD DOUBLE N Prompt data type
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.



Relationship Detail - PFT_REPORT_PROMPT




Parent Column in PFT_REPORT_PROMPT (PK) Child Table Name Child Column Name
Children: PFT_REPORT_PROMPT_ID PFT_REPORT_OPTION PFT_REPORT_PROMPT_ID
PFT_REPORT_PROMPT_RELTN PFT_REPORT_PROMPT_ID


PFT_REPORT_PROMPT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: PFT REPORT PROMPT RELTN
Definition: This is the ProFit report/prompt reltn table.
Table Type: REFERENCE





Column Detail - PFT_REPORT_PROMPT_RELTN


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME Y The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CUSTOM_PROMPT_TEXT VARCHAR(50) Y custom prompt text
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
PFT_REPORT_ID DOUBLE N This is a foreign key to the pft_report table and this is the unique identifier for the report.
PFT_REPORT_PROMPT_ID DOUBLE N This is a foreign key to the report prompt table and is the unique identifier to the prompt
PFT_REPORT_PROMPT_RELTN_ID DOUBLE N Primary key.
PRIORITY_SEQ DOUBLE Y The sequence of the priority for this row
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.



Relationship Detail - PFT_REPORT_PROMPT_RELTN


Child Column in PFT_REPORT_PROMPT_RELTN(FK) Parent Table Name Parent Column Name
Parents: PFT_REPORT_ID PFT_REPORT PFT_REPORT_ID
PFT_REPORT_PROMPT_ID PFT_REPORT_PROMPT PFT_REPORT_PROMPT_ID