pears.CollectionGetItemTypeName [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== pears.CollectionGetItemTypeName ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
create function "pears"."CollectionGetItemTypeName"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  in "ItemType" char(2) ) 
returns varchar(20)
begin
  declare "rv" varchar(20);
  /* Item Types P -person, C -company, E -employment, L -placement, R -progress, T -timesheet, I -Invoice, V -vacancy, Q -timesheet query, 0 -contact event, */
  case "ItemType"
  when 'O' then set "rv" = "wpkgetswitchvalue"('cename','Global')
  when 'H' then set "rv" = 'Header'
  when 'E' then set "rv" = "wpkgetswitchvalue"('copersonname','Global')
  when 'P' then set "rv" = "wpkgetswitchvalue"('appname','Global')
  when 'Q' then set "rv" = 'Timesheet Query'
  when 'T' then set "rv" = 'Timesheet'
  when 'Z' then set "rv" = 'Prov. Timesheet'
  when 'S' then set "rv" = 'Shift'
  when 'R' then set "rv" = 'Progress'
  when 'C' then set "rv" = "wpkgetswitchvalue"('coname','Global')
  when 'I' then set "rv" = 'Invoice'
  when 'V' then set "rv" = "wpkgetswitchvalue"('vacname','Global')
  when 'L' then set "rv" = "wpkgetswitchvalue"('placname','Global')
  end case;
  return "rv"
end
</code>