OEB_PER_ALL_PEOPLE_F

Database

SDSNZS01_R12

Schema

CDCPADM_R12

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PERSON_ID BIGINT 8
2 EFFECTIVE_START_DATE TIMESTAMP 8
3 EFFECTIVE_END_DATE TIMESTAMP 8
4 BUSINESS_GROUP_ID BIGINT 8
5 PERSON_TYPE_ID BIGINT 8
6 LAST_NAME CHARACTER VARYING(150) 150
7 START_DATE TIMESTAMP 8
8 APPLICANT_NUMBER CHARACTER VARYING(30) 30
9 BACKGROUND_CHECK_STATUS CHARACTER VARYING(30) 30
10 BACKGROUND_DATE_CHECK TIMESTAMP 8
11 BLOOD_TYPE CHARACTER VARYING(30) 30
12 COMMENT_ID BIGINT 8
13 CORRESPONDENCE_LANGUAGE CHARACTER VARYING(30) 30
14 CURRENT_APPLICANT_FLAG CHARACTER VARYING(30) 30
15 CURRENT_EMP_OR_APL_FLAG CHARACTER VARYING(30) 30
16 CURRENT_EMPLOYEE_FLAG CHARACTER VARYING(30) 30
17 DATE_EMPLOYEE_DATA_VERIFIED TIMESTAMP 8
18 DATE_OF_BIRTH TIMESTAMP 8
19 EMAIL_ADDRESS CHARACTER VARYING(240) 240
20 EMPLOYEE_NUMBER CHARACTER VARYING(30) 30
21 EXPENSE_CHECK_SEND_TO_ADDRESS CHARACTER VARYING(30) 30
22 FAST_PATH_EMPLOYEE CHARACTER VARYING(30) 30
23 FIRST_NAME CHARACTER VARYING(150) 150
24 FTE_CAPACITY NUMERIC(5,2) 19
25 FULL_NAME CHARACTER VARYING(240) 240
26 HOLD_APPLICANT_DATE_UNTIL TIMESTAMP 8
27 HONORS CHARACTER VARYING(45) 45
28 INTERNAL_LOCATION CHARACTER VARYING(45) 45
29 KNOWN_AS CHARACTER VARYING(80) 80
30 LAST_MEDICAL_TEST_BY CHARACTER VARYING(60) 60
31 LAST_MEDICAL_TEST_DATE TIMESTAMP 8
32 MAILSTOP CHARACTER VARYING(45) 45
33 MARITAL_STATUS CHARACTER VARYING(30) 30
34 MIDDLE_NAMES CHARACTER VARYING(60) 60
35 NATIONALITY CHARACTER VARYING(30) 30
36 NATIONAL_IDENTIFIER CHARACTER VARYING(30) 30
37 OFFICE_NUMBER CHARACTER VARYING(45) 45
38 ON_MILITARY_SERVICE CHARACTER VARYING(30) 30
39 ORDER_NAME CHARACTER VARYING(240) 240
40 PRE_NAME_ADJUNCT CHARACTER VARYING(30) 30
41 PREVIOUS_LAST_NAME CHARACTER VARYING(150) 150
42 PROJECTED_START_DATE TIMESTAMP 8
43 REHIRE_AUTHORIZOR CHARACTER VARYING(60) 60
44 REHIRE_REASON CHARACTER VARYING(60) 60
45 REHIRE_RECOMMENDATION CHARACTER VARYING(30) 30
46 RESUME_EXISTS CHARACTER VARYING(30) 30
47 RESUME_LAST_UPDATED TIMESTAMP 8
48 REGISTERED_DISABLED_FLAG CHARACTER VARYING(30) 30
49 SECOND_PASSPORT_EXISTS CHARACTER VARYING(30) 30
50 SEX CHARACTER VARYING(30) 30
51 STUDENT_STATUS CHARACTER VARYING(30) 30
52 SUFFIX CHARACTER VARYING(30) 30
53 TITLE CHARACTER VARYING(30) 30
54 VENDOR_ID BIGINT 8
55 WORK_SCHEDULE CHARACTER VARYING(30) 30
56 WORK_TELEPHONE CHARACTER VARYING(60) 60
57 COORD_BEN_MED_PLN_NO CHARACTER VARYING(30) 30
58 COORD_BEN_NO_CVG_FLAG CHARACTER VARYING(30) 30
59 DPDNT_ADOPTION_DATE TIMESTAMP 8
60 DPDNT_VLNTRY_SVCE_FLAG CHARACTER VARYING(30) 30
61 RECEIPT_OF_DEATH_CERT_DATE TIMESTAMP 8
62 USES_TOBACCO_FLAG CHARACTER VARYING(30) 30
63 BENEFIT_GROUP_ID BIGINT 8
64 REQUEST_ID BIGINT 8
65 PROGRAM_APPLICATION_ID BIGINT 8
66 PROGRAM_ID BIGINT 8
67 PROGRAM_UPDATE_DATE TIMESTAMP 8
68 ATTRIBUTE_CATEGORY CHARACTER VARYING(30) 30
69 ATTRIBUTE1 CHARACTER VARYING(150) 150
70 ATTRIBUTE2 CHARACTER VARYING(150) 150
71 ATTRIBUTE3 CHARACTER VARYING(150) 150
72 ATTRIBUTE4 CHARACTER VARYING(150) 150
73 ATTRIBUTE5 CHARACTER VARYING(150) 150
74 ATTRIBUTE6 CHARACTER VARYING(150) 150
75 ATTRIBUTE7 CHARACTER VARYING(150) 150
76 ATTRIBUTE8 CHARACTER VARYING(150) 150
77 ATTRIBUTE9 CHARACTER VARYING(150) 150
78 ATTRIBUTE10 CHARACTER VARYING(150) 150
79 ATTRIBUTE11 CHARACTER VARYING(150) 150
80 ATTRIBUTE12 CHARACTER VARYING(150) 150
81 ATTRIBUTE13 CHARACTER VARYING(150) 150
82 ATTRIBUTE14 CHARACTER VARYING(150) 150
83 ATTRIBUTE15 CHARACTER VARYING(150) 150
84 ATTRIBUTE16 CHARACTER VARYING(150) 150
85 ATTRIBUTE17 CHARACTER VARYING(150) 150
86 ATTRIBUTE18 CHARACTER VARYING(150) 150
87 ATTRIBUTE19 CHARACTER VARYING(150) 150
88 ATTRIBUTE20 CHARACTER VARYING(150) 150
89 ATTRIBUTE21 CHARACTER VARYING(150) 150
90 ATTRIBUTE22 CHARACTER VARYING(150) 150
91 ATTRIBUTE23 CHARACTER VARYING(150) 150
92 ATTRIBUTE24 CHARACTER VARYING(150) 150
93 ATTRIBUTE25 CHARACTER VARYING(150) 150
94 ATTRIBUTE26 CHARACTER VARYING(150) 150
95 ATTRIBUTE27 CHARACTER VARYING(150) 150
96 ATTRIBUTE28 CHARACTER VARYING(150) 150
97 ATTRIBUTE29 CHARACTER VARYING(150) 150
98 ATTRIBUTE30 CHARACTER VARYING(150) 150
99 LAST_UPDATE_DATE TIMESTAMP 8
100 LAST_UPDATED_BY BIGINT 8
101 LAST_UPDATE_LOGIN BIGINT 8
102 CREATED_BY BIGINT 8
103 CREATION_DATE TIMESTAMP 8
104 PER_INFORMATION_CATEGORY CHARACTER VARYING(30) 30
105 PER_INFORMATION1 CHARACTER VARYING(150) 150
106 PER_INFORMATION2 CHARACTER VARYING(150) 150
107 PER_INFORMATION3 CHARACTER VARYING(150) 150
108 PER_INFORMATION4 CHARACTER VARYING(150) 150
109 PER_INFORMATION5 CHARACTER VARYING(150) 150
110 PER_INFORMATION6 CHARACTER VARYING(150) 150
111 PER_INFORMATION7 CHARACTER VARYING(150) 150
112 PER_INFORMATION8 CHARACTER VARYING(150) 150
113 PER_INFORMATION9 CHARACTER VARYING(150) 150
114 PER_INFORMATION10 CHARACTER VARYING(150) 150
115 PER_INFORMATION11 CHARACTER VARYING(150) 150
116 PER_INFORMATION12 CHARACTER VARYING(150) 150
117 PER_INFORMATION13 CHARACTER VARYING(150) 150
118 PER_INFORMATION14 CHARACTER VARYING(150) 150
119 PER_INFORMATION15 CHARACTER VARYING(150) 150
120 PER_INFORMATION16 CHARACTER VARYING(150) 150
121 PER_INFORMATION17 CHARACTER VARYING(150) 150
122 PER_INFORMATION18 CHARACTER VARYING(150) 150
123 PER_INFORMATION19 CHARACTER VARYING(150) 150
124 PER_INFORMATION20 CHARACTER VARYING(150) 150
125 PER_INFORMATION21 CHARACTER VARYING(150) 150
126 PER_INFORMATION22 CHARACTER VARYING(150) 150
127 PER_INFORMATION23 CHARACTER VARYING(150) 150
128 PER_INFORMATION24 CHARACTER VARYING(150) 150
129 PER_INFORMATION25 CHARACTER VARYING(150) 150
130 PER_INFORMATION26 CHARACTER VARYING(150) 150
131 PER_INFORMATION27 CHARACTER VARYING(150) 150
132 PER_INFORMATION28 CHARACTER VARYING(150) 150
133 PER_INFORMATION29 CHARACTER VARYING(150) 150
134 PER_INFORMATION30 CHARACTER VARYING(150) 150
135 OBJECT_VERSION_NUMBER BIGINT 8
136 DATE_OF_DEATH TIMESTAMP 8
137 ORIGINAL_DATE_OF_HIRE TIMESTAMP 8
138 TOWN_OF_BIRTH CHARACTER VARYING(90) 90
139 REGION_OF_BIRTH CHARACTER VARYING(90) 90
140 COUNTRY_OF_BIRTH CHARACTER VARYING(90) 90
141 GLOBAL_PERSON_ID CHARACTER VARYING(30) 30
142 COORD_BEN_MED_PL_NAME CHARACTER VARYING(80) 80
143 COORD_BEN_MED_INSR_CRR_NAME CHARACTER VARYING(80) 80
144 COORD_BEN_MED_INSR_CRR_IDENT CHARACTER VARYING(80) 80
145 COORD_BEN_MED_EXT_ER CHARACTER VARYING(80) 80
146 COORD_BEN_MED_CVG_STRT_DT TIMESTAMP 8
147 COORD_BEN_MED_CVG_END_DT TIMESTAMP 8
148 PARTY_ID BIGINT 8
149 NPW_NUMBER CHARACTER VARYING(30) 30
150 CURRENT_NPW_FLAG CHARACTER VARYING(30) 30
151 GLOBAL_NAME CHARACTER VARYING(240) 240
152 LOCAL_NAME CHARACTER VARYING(240) 240
153 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
154 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
155 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
156 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8