Table Detail Report
PM_RPT_DISPLAY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PM RPT DISPLAY |
Definition: | Holds the menu options for Person Management reporting |
Table Type: | REFERENCE |
Column Detail - PM_RPT_DISPLAY
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 | Y | 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 | Y | 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. |
DATA_STATUS_CD | DOUBLE | Y | Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED. |
DATA_STATUS_DT_TM | DATETIME | Y | The date and time that the data_status_cd was set. |
DATA_STATUS_PRSNL_ID | DOUBLE | Y | The person who caused the data_status_cd to be set or change. |
DISPLAY | CHAR(40) | Y | The text that will be displayed in Person Management Report menuing |
DISPLAY_ID | DOUBLE | N | Primary Key attribute |
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. |
PARENT_DISPLAY_ID | DOUBLE | Y | Points this particular row to its parent PM_RPT_DISPLAY row for Person Management Reporting menuing (i.e. what folder in the tree view does the report display under) |
REPORT_ID | DOUBLE | Y | Foreign Key attribute that points this text row to a particular report on the pm_rpt_report 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 - PM_RPT_DISPLAY
Child Column in PM_RPT_DISPLAY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REPORT_ID | PM_RPT_REPORT | REPORT_ID |
PM_RPT_FIELD
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Reference table containing all the attributes usable in PM reporting |
Definition: | Reference table containing all the attributes usable in PM reporting. These rows are your pick lists for headers, filters, and orders. |
Table Type: | REFERENCE |
Column Detail - PM_RPT_FIELD
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 | Y | 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 | Y | 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. |
DATA_STATUS_CD | DOUBLE | Y | Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED. |
DATA_STATUS_DT_TM | DATETIME | Y | The date and time that the data_status_cd was set. |
DATA_STATUS_PRSNL_ID | DOUBLE | Y | The person who caused the data_status_cd to be set or change. |
DISPLAY_LENGTH | DOUBLE | N | This is the recommended default length for this field |
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. |
FIELD_DISPLAY | CHAR(32) | Y | Text display for the field name |
FIELD_HELP | CHAR(6) | Y | Determines what Code Set will be used as help behind this field |
FIELD_ID | DOUBLE | N | Primary Key attribute |
FIELD_NAME | CHAR(32) | N | Name of this field as defined in the data dictionary |
FIELD_REPORT_TYPE | CHAR(1) | N | Defines the type of report these fields are valid for. Valid values are T = Transaction, C = Census, M = Miscellaenous, and K = Current Case, O = OPF Matches, P = OPF Population, X = OPF Combine, A = AFC |
FIELD_TYPE | CHAR(4) | N | Definition of the field. Valid values are DQ8, F8, I2, I4, and C***. |
KEY_IND | DOUBLE | Y | Tells whether this field is a key or not |
TABLE_NAME | CHAR(32) | N | The table that this field came from as specificied in the data dictionary |
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 - PM_RPT_FIELD
Parent Column in PM_RPT_FIELD (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | FIELD_ID | PM_RPT_FILTER | FIELD_ID |
PM_RPT_GROUP | FIELD_ID | ||
PM_RPT_HEADER | FIELD_ID | ||
PM_RPT_ORDER | FIELD_ID |
PM_RPT_FILTER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PM RPT FILTER |
Definition: | Determines which filters are in use for each Person Management report |
Table Type: | REFERENCE |
Column Detail - PM_RPT_FILTER
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 | Y | 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 | Y | The person who caused the active_status_cd to be set or change. |
AD_HOC_IND | DOUBLE | Y | Determines whether this filter will be used as an ad hoc filter where the value can be changed when the report is run. |
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. |
BETWEEN_IND | DOUBLE | Y | Determines whether this filter will use between logic. If this is TRUE, this filter must have 2 and only 2 filter values tied to it. One filter value is marked as the start and one filter value is marked as the end. |
DATA_STATUS_CD | DOUBLE | Y | Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED. |
DATA_STATUS_DT_TM | DATETIME | Y | The date and time that the data_status_cd was set. |
DATA_STATUS_PRSNL_ID | DOUBLE | Y | The person who caused the data_status_cd to be set or change. |
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. |
FIELD_ID | DOUBLE | Y | Foreign Key attribute tying the filter to a field on the pm_rpt_field table |
FILTER_ID | DOUBLE | N | Primary Key attribute |
REPORT_ID | DOUBLE | Y | Foreign Key attribute tying the filter to a specific report on the pm_rpt_report 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 - PM_RPT_FILTER
Child Column in PM_RPT_FILTER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | FIELD_ID | PM_RPT_FIELD | FIELD_ID |
REPORT_ID | PM_RPT_REPORT | REPORT_ID |
Parent Column in PM_RPT_FILTER (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | FILTER_ID | PM_RPT_FILTER_VALUES | FILTER_ID |
PM_RPT_FILTER_VALUES
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PM RPT FILTER VALUES |
Definition: | Determines the valid values per filter in Person Management Reporting |
Table Type: | REFERENCE |
Column Detail - PM_RPT_FILTER_VALUES
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 | Y | 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 | Y | 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. |
DATA_STATUS_CD | DOUBLE | Y | Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED. |
DATA_STATUS_DT_TM | DATETIME | Y | The date and time that the data_status_cd was set. |
DATA_STATUS_PRSNL_ID | DOUBLE | Y | The person who caused the data_status_cd to be set or change. |
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. |
END_IND | DOUBLE | Y | Used only when the filter has been defined as using 'between' logic. This is the filter value used at the end of the 'between' statement. |
FILTER_ID | DOUBLE | N | Foreign Key tying the filter values to a specific filter on the pm_rpt_filter table |
FILTER_VALUES_ID | DOUBLE | N | Primary Key attribute |
START_IND | DOUBLE | Y | Used only when the filter has been defined as using 'between' logic. This is the filter value used at the start of the 'between' statement. |
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. |
VALUE | CHAR(100) | Y | The value used for this filter |
Relationship Detail - PM_RPT_FILTER_VALUES
Child Column in PM_RPT_FILTER_VALUES(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | FILTER_ID | PM_RPT_FILTER | FILTER_ID |
PM_RPT_GROUP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PM RPT GROUP |
Definition: | Determines which attributes are used to group by per Person Management Report |
Table Type: | REFERENCE |
Column Detail - PM_RPT_GROUP
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 | Y | 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 | Y | 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. |
DATA_STATUS_CD | DOUBLE | Y | Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED. |
DATA_STATUS_DT_TM | DATETIME | Y | The date and time that the data_status_cd was set. |
DATA_STATUS_PRSNL_ID | DOUBLE | Y | The person who caused the data_status_cd to be set or change. |
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. |
FIELD_ID | DOUBLE | N | Foreign Key tying the group to a certain field on the pm_rpt_field table |
GROUP_ID | DOUBLE | N | Primary Key attribute |
GROUP_SEQUENCE | DOUBLE | Y | Detemines the sequence in which the grouping functionality will exist |
GROUP_TOTAL_IND | DOUBLE | Y | Determines if totals will exist for the group |
HEADER_ID | DOUBLE | N | Foreign Key tying the group to a specific header on the pm_rpt_header table |
REPORT_ID | DOUBLE | N | Foreign Key attribute used to tie the group to a report on the pm_rpt_report 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 - PM_RPT_GROUP
Child Column in PM_RPT_GROUP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | FIELD_ID | PM_RPT_FIELD | FIELD_ID |
HEADER_ID | PM_RPT_HEADER | HEADER_ID | |
REPORT_ID | PM_RPT_REPORT | REPORT_ID |