Rem    NAME 
Rem      ckmigtab.sql
Rem    DESCRIPTION
Rem      Creates tables used for Migration of Designer/2000 IDs to Oracle Repository
Rem    RETURNS
Rem 	 None
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem    CREATED
Rem	  30/03/1999

PROMPT * Creating Migration Table(s)

create table jr_id_maps ( trans_ref         number,
                          old_id            number(38),
                          irid              number,
                          ivid              number,
                          element_type      varchar2(20),
                          occur_type        varchar2(20),
                          is_a_pac_element  varchar2(1),
                          owning_app        varchar2(100),
                          owning_app_id     number,
                          type_id           number,
                          part_of_id        number,
                          use_of_id         number,
                          pop_tab           varchar2(100),
				  is_sys_lan	  varchar2(1) DEFAULT 'N',
				  lan_name          varchar2(40),
				  is_odd            varchar2(1) DEFAULT 'N'	
)
/

