PCR-360 is capable of creating a fully configurable Legacy table, by defining a set of parameters in a configuration file before creating the legacy table.

The legacy form can support two tabs. On the first tab up to 4 groups are supported, and a single large text field is supported on the second tab. The second tab is typically used to display long form data, such as emails or remarks.

The Legacy table can be customized with these options: (Where X is the group number and COLUMN_NAME is the name of the column in the database table)

legacy.groupX.name (The name of the group )
legacy.groupX.width(The width, in pixels, of the group on the legacy screen)
legacy.groupX.fields.COLUMN_NAME.name (The field label on the legacy form correlating to the column in the database)
legacy.groupX.filds.COLUMN_NAME.type (This is the data type for the database column, VARCHAR(100) for example)

legacy.comments.field (The column name in the Legacy table for the long form text) legacy.comments.name (The name of the label on the Legacy form) legacy.comments.type (The data type of the data stored in the Legacy table, i.e. "CLOB") legacy.remarks (Designates if the format on the second tab is for remarks, this value is Boolean true or false)

// Example Legacy Format for group1
legacy.group1.name = "Ticket"
legacy.group1.width = 200
legacy.group1.fields.TICKET_NUMBER.name = "Ticket Number"
legacy.group1.fields.TICKET_NUMBER.type = "VARCHAR(100)"
legacy.group1.fields.SOURCE.name = "Source"
legacy.group1.fields.SOURCE.type = "VARCHAR(100)"
legacy.group1.fields.STATUS.name = "Status"
legacy.group1.fields.STATUS.type = "VARCHAR(100)"
legacy.group1.fields.REF_NUM.name = "Ref Num"
legacy.group1.fields.REF_NUM.type = "VARCHAR(100)"
legacy.group1.fields.PRIORITY.name = "Priority"
legacy.group1.fields.PRIORITY.type = "VARCHAR(100)"

//Example Format for second tab on Legacy form
legacy.comments.field = "EMAIL"
legacy.comments.name = "Email"
legacy.comments.type = "CLOB"
legacy.remarks = false

Browser not supported