This table maintains a catalog of report IDs.
Table 1. Report ID table (ARSDFCRT)
Column Name |
Data Type |
Description |
CRT_REPORTID |
VARCHAR(60) |
Report ID name |
CRT_STATUS |
CHAR(1) |
Status |
CRT_APPLGRP_NAME |
VARCHAR(60) |
Application group name |
CRT_APPL_NAME |
VARCHAR(60) |
Application name |
CRT_REFERENCE |
VARCHAR(254) |
Reference |
CRT_UPD_USERID |
VARCHAR(128) |
Last user to update the report ID |
CRT_UPD_DATE |
BIGINT |
Date and time report ID definition was last updated |
CRT_UPD_DT |
TIMESTAMP |
Date and time report ID definition was last updated (timestamp format) |
Table 2. Indexes for report ID table (ARSDFCRT)
Index name |
Columns in index |
Type of index |
ARSDFCRT_IDX1 |
CRT_REPORTID |
Unique index |
ARSDFCRT_IDX2 |
CRT_APPLGRP_NAME, CRT_APPL_NAME |
Unique cluster index for Db2; Unique index for Oracle and SQL Server |