OEB_HR_ORGANIZATION_INFORMATION

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ORG_INFORMATION_ID BIGINT 8
2 ORG_INFORMATION_CONTEXT CHARACTER VARYING(40) 40
3 ORGANIZATION_ID BIGINT 8
4 ORG_INFORMATION1 CHARACTER VARYING(150) 150
5 ORG_INFORMATION10 CHARACTER VARYING(150) 150
6 ORG_INFORMATION11 CHARACTER VARYING(150) 150
7 ORG_INFORMATION12 CHARACTER VARYING(150) 150
8 ORG_INFORMATION13 CHARACTER VARYING(150) 150
9 ORG_INFORMATION14 CHARACTER VARYING(150) 150
10 ORG_INFORMATION15 CHARACTER VARYING(150) 150
11 ORG_INFORMATION16 CHARACTER VARYING(150) 150
12 ORG_INFORMATION17 CHARACTER VARYING(150) 150
13 ORG_INFORMATION18 CHARACTER VARYING(150) 150
14 ORG_INFORMATION19 CHARACTER VARYING(150) 150
15 ORG_INFORMATION2 CHARACTER VARYING(150) 150
16 ORG_INFORMATION20 CHARACTER VARYING(150) 150
17 ORG_INFORMATION3 CHARACTER VARYING(150) 150
18 ORG_INFORMATION4 CHARACTER VARYING(150) 150
19 ORG_INFORMATION5 CHARACTER VARYING(150) 150
20 ORG_INFORMATION6 CHARACTER VARYING(150) 150
21 ORG_INFORMATION7 CHARACTER VARYING(150) 150
22 ORG_INFORMATION8 CHARACTER VARYING(150) 150
23 ORG_INFORMATION9 CHARACTER VARYING(150) 150
24 REQUEST_ID BIGINT 8
25 PROGRAM_APPLICATION_ID BIGINT 8
26 PROGRAM_ID BIGINT 8
27 PROGRAM_UPDATE_DATE TIMESTAMP 8
28 ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
29 ATTRIBUTE1 CHARACTER VARYING(150) 150
30 ATTRIBUTE2 CHARACTER VARYING(150) 150
31 ATTRIBUTE3 CHARACTER VARYING(150) 150
32 ATTRIBUTE4 CHARACTER VARYING(150) 150
33 ATTRIBUTE5 CHARACTER VARYING(150) 150
34 ATTRIBUTE6 CHARACTER VARYING(150) 150
35 ATTRIBUTE7 CHARACTER VARYING(150) 150
36 ATTRIBUTE8 CHARACTER VARYING(150) 150
37 ATTRIBUTE9 CHARACTER VARYING(150) 150
38 ATTRIBUTE10 CHARACTER VARYING(150) 150
39 ATTRIBUTE11 CHARACTER VARYING(150) 150
40 ATTRIBUTE12 CHARACTER VARYING(150) 150
41 ATTRIBUTE13 CHARACTER VARYING(150) 150
42 ATTRIBUTE14 CHARACTER VARYING(150) 150
43 ATTRIBUTE15 CHARACTER VARYING(150) 150
44 ATTRIBUTE16 CHARACTER VARYING(150) 150
45 ATTRIBUTE17 CHARACTER VARYING(150) 150
46 ATTRIBUTE18 CHARACTER VARYING(150) 150
47 ATTRIBUTE19 CHARACTER VARYING(150) 150
48 ATTRIBUTE20 CHARACTER VARYING(150) 150
49 LAST_UPDATE_DATE TIMESTAMP 8
50 LAST_UPDATED_BY BIGINT 8
51 LAST_UPDATE_LOGIN BIGINT 8
52 CREATED_BY BIGINT 8
53 CREATION_DATE TIMESTAMP 8
54 OBJECT_VERSION_NUMBER BIGINT 8
55 PARTY_ID BIGINT 8
56 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
57 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
58 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
59 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8