RSAGL_CV01_MAP_HEADERS

Database

INSNZP01

Schema

X01PADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 HEADER_ID INTEGER 4
2 LOOKUP_TYPE CHARACTER VARYING(50) 50
3 MODULE CHARACTER VARYING(50) 50
4 ORGANISATION CHARACTER VARYING(50) 50
5 DESCRIPTION CHARACTER VARYING(250) 250
6 CREATION_DATE TIMESTAMP 8
7 CREATED_BY INTEGER 4
8 LAST_UPDATED_BY INTEGER 4
9 LAST_UPDATE_DATE TIMESTAMP 8
10 LAST_UPDATE_LOGIN INTEGER 4
11 COLUMN_DESCRIPTION CHARACTER VARYING(2000) 2000
12 DST_SEGMENT_NAME1 CHARACTER VARYING(30) 30
13 DST_SEGMENT_NAME2 CHARACTER VARYING(30) 30
14 DST_SEGMENT_NAME3 CHARACTER VARYING(30) 30
15 DST_SEGMENT_NAME4 CHARACTER VARYING(30) 30
16 DST_SEGMENT_NAME5 CHARACTER VARYING(30) 30
17 DST_SEGMENT_NAME6 CHARACTER VARYING(30) 30
18 DST_SEGMENT_NAME7 CHARACTER VARYING(30) 30
19 DST_SEGMENT_NAME8 CHARACTER VARYING(30) 30
20 DST_SEGMENT_NAME9 CHARACTER VARYING(30) 30
21 DST_SEGMENT_NAME10 CHARACTER VARYING(30) 30
22 DST_SEGMENT_NAME11 CHARACTER VARYING(30) 30
23 SRC_SEGMENT_NAME1 CHARACTER VARYING(30) 30
24 SRC_SEGMENT_NAME2 CHARACTER VARYING(30) 30
25 SRC_SEGMENT_NAME3 CHARACTER VARYING(30) 30
26 SRC_SEGMENT_NAME4 CHARACTER VARYING(30) 30
27 SRC_SEGMENT_NAME5 CHARACTER VARYING(30) 30
28 SRC_SEGMENT_NAME6 CHARACTER VARYING(30) 30
29 SRC_SEGMENT_NAME7 CHARACTER VARYING(30) 30
30 SRC_SEGMENT_NAME8 CHARACTER VARYING(30) 30
31 EFFECTIVE_DATE TIMESTAMP 8
32 END_DATE TIMESTAMP 8
33 CURRENT_FLAG CHARACTER VARYING(1) 1