Table Detail Report
PM_RPT_HEADER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Determines the headers per Person Management Report |
Definition: | Deterines the headers per Person Management Report |
Table Type: | REFERENCE |
Column Detail - PM_RPT_HEADER
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 attribute identifying which field on the pm_rpt_field table is a header |
HEADER_DISPLAY | CHAR(100) | Y | The text displayed as the header to each column |
HEADER_ID | DOUBLE | N | Primary Key attribute |
HEADER_LENGTH | DOUBLE | Y | Defines the length of the header_display attribute shown at the top of each column |
HEADER_SEQUENCE | DOUBLE | Y | Defines the sequence the headers will show up in on the report. |
REPORT_ID | DOUBLE | N | Foreign Key Attribute tying the header to a specific report on the pm_rpt_report table |
SECONDS_IND | DOUBLE | Y | Defines whether this header will include seconds when displayed. In order to be valid the TIME_IND must be TRUE. Used only when the header is a date/time attribute. Display is HH:MM:SS. |
TIME_IND | DOUBLE | Y | Defines whether we will show time for this header. Used only when the header is a date/time attribute. Display is HH:MM. |
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_HEADER
Child Column in PM_RPT_HEADER(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_HEADER (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | HEADER_ID | PM_RPT_GROUP | HEADER_ID |
PM_RPT_ORDER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PM RPT ORDER |
Definition: | Determines the order of the display per Person Management Report |
Table Type: | REFERENCE |
Column Detail - PM_RPT_ORDER
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. |
DESCENDING_IND | DOUBLE | Y | Determines whether this order by will be descending |
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 order by to a specific field on the pm_rpt_field table |
ORDER_ID | DOUBLE | N | Primary Key attribute |
ORDER_SEQUENCE | DOUBLE | N | Determines the sequence of the fields in the order by for a particular report |
REPORT_ID | DOUBLE | N | Foreign Key tying the order by 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_ORDER
Child Column in PM_RPT_ORDER(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | FIELD_ID | PM_RPT_FIELD | FIELD_ID |
REPORT_ID | PM_RPT_REPORT | REPORT_ID |
PM_RPT_REPORT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PM_RPT_REPORT |
Definition: | Person Management reports |
Table Type: | REFERENCE |
Column Detail - PM_RPT_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. |
DATA_STATUS_CD | DOUBLE | N | 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 | N | The person who caused the data_status_cd to be set or change. |
DESCRIPTION | CHAR(100) | Y | Free-text Description of the Person Management Report |
DETAIL_IND | DOUBLE | Y | Determines whether this report will contain detailed data or be a totals only report. If the value is "1", the report will contain details. |
DOUBLESPACE_IND | DOUBLE | Y | Flag to determine if report should print doublespaced. If the value is "1", the report is set up to print doublespaced. |
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. |
INVERSE_IND | DOUBLE | N | Indicates whether or not the inverse of the report's main transaction type has been applied (i.e. 0 means no inverse is being applied, 1 means the inverse of the transaction is being applied). |
LANDSCAPE_IND | DOUBLE | Y | Flag to determine if report should print landscape. If the value is "1", the report will print landscape otherwise it will print portrait. |
PROGRAM_NAME | CHAR(20) | N | The name of the CCL object that is used when this report is ran |
REPORT_ID | DOUBLE | N | Primary Key Attribute |
REPORT_NAME | CHAR(20) | N | Name of this Person Management Report |
REPORT_TYPE | CHAR(1) | N | Determines the type of report. Valid values are T = Transaction, C = Census, M = Miscellaenous, K = Current Cases, A = AFC, O = OPF Matches, P = OPF Population, X = OPF Combine |
RETENTION_DAYS | DOUBLE | Y | Text field displayed at top of report telling end user how many days to retain this report |
TASK_NUMBER | DOUBLE | Y | Ties a report to the security data model through a task number |
TITLE | CHAR(40) | Y | Title of the report. Displays at the top of every page. |
TOTAL_IND | DOUBLE | Y | Determines if a report total will print at the bottom of this report |
TRANSACTION_TYPE | CHAR(4) | Y | Determines what type of transaction this report will be used for (e.g. AMDT, DSCH, etc.). This attribute is valued only when REPORT_TYPE = 'T' |
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_REPORT
Parent Column in PM_RPT_REPORT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | REPORT_ID | PM_RPT_BATCH_PARAMS | REPORT_ID |
PM_RPT_DISPLAY | REPORT_ID | ||
PM_RPT_FILTER | REPORT_ID | ||
PM_RPT_GROUP | REPORT_ID | ||
PM_RPT_HEADER | REPORT_ID | ||
PM_RPT_ORDER | REPORT_ID | ||
PM_RPT_TRANS_OPTIONS | REPORT_ID | ||
PM_TRANSACTION | REPORT_ID |
PM_RPT_TRANS_OPTIONS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Determines what additional transaction types are in use for each PM report. |
Definition: | Person Management Transaction Options |
Table Type: | ACTIVITY |
Column Detail - PM_RPT_TRANS_OPTIONS
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. |
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 | N | 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. |
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. |
INVERSE_IND | DOUBLE | N | Indicates whether or not the inverse of the transaction type is being applied. 0 - means the inverse is NOT being applied, 1 - means the inverse is being applied. |
REPORT_ID | DOUBLE | N | Foreign Key attribute tying the filter to a specific report on the pm_rpt_report table |
TRANSACTION_TYPE | VARCHAR(4) | N | Determines what type of transaction this report will be used for (e.g. AMDT, DSCH, etc.). This attribute is valued only when REPORT_TYPE = 'T' |
TRANS_OPTIONS_ID | DOUBLE | N | Primary Key |
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_TRANS_OPTIONS
Child Column in PM_RPT_TRANS_OPTIONS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REPORT_ID | PM_RPT_REPORT | REPORT_ID |
PM_SCH_COMMON_NAMES
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Person Management Schedule Common Names |
Definition: | This table is needed for a search quality project, it will store all name_keys with a count > 500 up to 32k. We will use this to let the user know if they are going to execute a search that will fail, before they click search. |
Table Type: | ACTIVITY |
Column Detail - PM_SCH_COMMON_NAMES
Column Name | Type | Null? | Definition |
---|---|---|---|
LOGICAL_DOMAIN_ID | DOUBLE | N | Used for multi-tenet sites to stamp the logical domain id. |
NAME_CNT | DOUBLE | N | Number of names for that NAME_KEY & TYPE. |
NAME_KEY | VARCHAR(255) | N | This corresponds to the FIRST_NAME_KEY, LAST_NAME KEYS on the PERSON table, but they can also be combo of both. |
NAME_TYPE_CD | DOUBLE | N | Type code that designates between FIRST, LAST and COMBO types. |
PM_SCH_COMMON_NAMES_ID | DOUBLE | N | Uniquely identifies a row on the pm_sch_common_names |
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_SCH_COMMON_NAMES
Child Column in PM_SCH_COMMON_NAMES(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |