Table_Info
--
CREATE TABLE x1
(
   form_number			number(4),
   elabel_number		number(2),
   resource_type		varchar2(40),
   resource_entity		varchar2(4000),	
   resource_entitlement		varchar2(40),
   resource_type_number		number,
   userid_type_format		varchar2(20),
   system_id			varchar2(20)
);

Data
--

 Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'NAME', '*$FULLNAME$*', 2, 'IDSX***_A', 'MFTSBC');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'PAS', '*$PASSWORD$*,30,EXP', 3, 'IDSX***_A', 'MFTSBC');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'DEPT', 'BNKDKUT', 4, 'IDSX***_A', 'MFTSBC');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'TSS_ATTRIBUTE', 'DUFXTR', 5, 'IDSX***_A', 'MFTSBC');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'FAC', 'CICSPROD', 6, 'IDSX***_A', 'MFTSBC');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'ELAB', '4008042.RPL-----.COMMERCL.COLL----', 7, 'IDSX***_A', 'MFTSBC');

Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'PROF', 'BKC2LC02', 9, 'IDSX***_A', 'MFTSBC');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'GEID', '*$GEID$*', 10, 'IDSX***_A', 'MFTSBC');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'SSN', '*$SSN$*', 11, 'IDSX***_A', 'MFTSBC');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'NAME', '*$FULLNAME$*', 12, 'IDSX***', 'MFTSBC');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'PAS', '*$PASSWORD$*,30,EXP', 13, 'IDSX***', 'MFTSBC');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'DEPT', 'BNKDKUT', 14, 'IDSX***', 'MFTSBC');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'FAC', 'CICSPROD', 15, 'IDSX***', 'MFTSBC');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'TSS_ATTRIBUTE', 'DUFXTR', 16, 'IDSX***', 'MFTSBC');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'ELAB', '4008042.RPL-----.COMMERCL.COLL----', 17, 'IDSX***', 'MFTSBC');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'PROF', 'BKC2CO01', 19, 'IDSX***', 'MFTSBC');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'PROF', 'BCL2KCL5', 20, 'IDSX***', 'MFTSBC');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'PROF', 'ZCO2CLCC', 21, 'IDSX***', 'MFTSBC');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'PROF', 'BNK2CBI4', 22, 'IDSX***', 'MFTSBC');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'GEID', '*$GEID$*', 23, 'IDSX***', 'MFTSBC');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'SSN', '*$SSN$*', 24, 'IDSX***', 'MFTSBC');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'NAME', '*$FULLNAME$*', 25, 'IDSX***', 'MFTSSK');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'PAS', '*$PASSWORD$*,30,EXP', 26, 'IDSX***', 'MFTSSK');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'DEPT', 'BNKDKUT', 27, 'IDSX***', 'MFTSSK');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'PID', '*$PID$*', 28, 'IDSX***', 'MFTSSK');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'FAC', 'CICSPROD', 29, 'IDSX***', 'MFTSSK');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'PROF', 'NCI2PROD', 30, 'IDSX***', 'MFTSSK');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'ELAB', '4008042.RPL-----.COMMERCL.COLL----', 31, 'IDSX***', 'MFTSSK');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'GEID', '*$GEID$*', 32, 'IDSX***', 'MFTSSK');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'SSN', '*$SSN$*', 33, 'IDSX***', 'MFTSSK');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'NAME', '*$FULLNAME$*', 34, 'IDSX***', 'MFRFRA');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'PASS', '*$PASSWORD$*', 35, 'IDSX***', 'MFRFRA');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'DFLTG', 'BNKDKUT', 36, 'IDSX***', 'MFRFRA');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'OWNER', 'BNK0KCC', 37, 'IDSX***', 'MFRFRA');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'WORKATTR_WANAME', '4008042.RPL-----.COMMERCL.COLL----', 38, 'IDSX***', 'MFRFRA');
Insert into x1
   (FORM_NUMBER, ELABEL_NUMBER, RESOURCE_TYPE, RESOURCE_ENTITY, RESOURCE_TYPE_NUMBER, USERID_TYPE_FORMAT, SYSTEM_ID)
 Values
   (4008, 42, 'WORKATTR_WABLDG', '*$GEID$*', 39, 'IDSX***', 'MFRFRA');
--