ER CTMS 037-011: Difference between revisions
From Calidus HUB
(Created page with "<!-- MEDIA LANDSCAPE YES --> {{#vardefine:System|CTMS}} {{ERHeader |SystemVersion=CTMS 11.0 |ERNumber=ER037-011 }} {| class="wikitable" border="1" width="100%" |- bgcolor="sil...") |
m (Text replacement - "[[Category:{{#var:System}} ER]]↵</noinclude>" to "[[Category:{{#var:System}} ER]]Category:ER CTMS 037 </noinclude>") |
||
| (One intermediate revision by one other user not shown) | |||
| Line 42: | Line 42: | ||
|" | |" | ||
|" | |" | ||
|} | |||
{| class="wikitable" border="1" width="100%" | |||
|- bgcolor="silver" | |||
!colspan="4" | New Parameters | |||
|- | |||
!Parameter Name !! Config Level !! Setting Value !! Result | |||
|- | |||
|MIS_TAB_DELIMITER | |||
|SYSTEM | |||
|Y | |||
|A tab will be used as the delimiter for the MIS extract files. | |||
|- | |||
|MIS_TAB_DELIMITER | |||
|SYSTEM | |||
|N | |||
|The specified delimiter will be used for the MIS extract files. | |||
|} | |} | ||
<noinclude> | <noinclude> | ||
[[Category:{{#var:System}} ER]] | [[Category:{{#var:System}} ER]][[Category:ER CTMS 037]] | ||
</noinclude> | </noinclude> | ||
Latest revision as of 14:47, 14 July 2025
EMERGENCY RELEASE - CTMS 11.0
RELNOTE ER037-011
| Module | Program Name | Ver | Call/Iss | Client Ref | Pr'ty | Remarks |
|---|---|---|---|---|---|---|
| AT_MIS_EXTRACT_HEADER_373655.sql | AT Script | 1.1 | 373655 | - | 3 | New system parameter MIS_TAB_DELIMITER exists to use a tab as a delimiter for the MIS extracts. When this parameter is Y, a tab will be used as a delimiter for the MIS extract files.
Assesses a new value for the MIS query to use: Transactional will use created date and updated date within the date ranges for the MIS report values of 'P_from_date' and 'p_to_date' to select records. The standard delimiter should be setup as '||'@'||' for conversion to a tab delimiter. Reference (which is the default value) will use the existing queries. |
| DATA_I_ADM_SYSTEM_PARAM_373655.sql | Data Script | 1.1 | " | " | " | " |
| DP_MIS.sql | MIS Interface Package | 5.6 | " | " | " | " |
| New Parameters | |||
|---|---|---|---|
| Parameter Name | Config Level | Setting Value | Result |
| MIS_TAB_DELIMITER | SYSTEM | Y | A tab will be used as the delimiter for the MIS extract files. |
| MIS_TAB_DELIMITER | SYSTEM | N | The specified delimiter will be used for the MIS extract files. |
