OBP24_CZ_MW_LND_LODG_REPORT_SUB_O_W

Database

SDSNZS01_OBP

Schema

CDCPADM_OBP

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 SUBMISSION_ID CHARACTER VARYING(50) 50
2 EXTRACT_ID CHARACTER VARYING(255) 255
3 RECORD_ID NUMERIC(10,0) 19
4 SUBMISSION_CREATION_DATE TIMESTAMP 8
5 SALES_OFFICER_USER_ID CHARACTER VARYING(254) 254
6 REGION CHARACTER VARYING(10) 10
7 ORIGINATION_CHANNEL CHARACTER VARYING(50) 50
8 SUBMISSION_CRATED_BY CHARACTER VARYING(254) 254
9 STATUS CHARACTER VARYING(50) 50
10 STAGE CHARACTER VARYING(50) 50
11 COMMENTS CHARACTER VARYING(4000) 4000
12 RECORD_STATUS CHARACTER VARYING(10) 10
13 LAST_MODIFIED_DATE TIMESTAMP 8
14 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
15 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
16 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
17 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8