INT_BANK_NROD_HR_PARTNER_COMP_V
Description
Target Objects (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | EMPLOYEE_ID | CHARACTER VARYING(32) | 32 |
| 2 | EMPLOYEE_NAME | CHARACTER VARYING(1000) | 1000 |
| 3 | PAYROLL_NUMBER | CHARACTER VARYING(20) | 20 |
| 4 | TAX_NUMBER | CHARACTER VARYING(20) | 20 |
| 5 | CUSTOMER_SOURCE_UNIQUE_ID | CHARACTER VARYING(32) | 32 |
| 6 | ORGUNIT_CODE | CHARACTER VARYING(10) | 10 |
| 7 | BRANCH_ID | CHARACTER VARYING(32) | 32 |
| 8 | ACTIVE_FLAG | CHARACTER VARYING(1) | 1 |
| 9 | DECEASED_FLAG | CHARACTER VARYING(1) | 1 |
| 10 | REL_MANAGER_FLAG | CHARACTER VARYING(1) | 1 |
| 11 | GENDER_CODE | CHARACTER VARYING(10) | 10 |
| 12 | MARITAL_STATUS | CHARACTER VARYING(10) | 10 |
| 13 | COUNTRY_OF_RESIDENCE | CHARACTER VARYING(3) | 3 |
| 14 | COUNTRY_OF_ORIGIN | CHARACTER VARYING(3) | 3 |
| 15 | NATIONALITY_CODE | CHARACTER VARYING(3) | 3 |
| 16 | DATE_OF_BIRTH | CHARACTER VARYING(1) | 1 |
| 17 | DATE_OF_ENTRY | CHARACTER VARYING(1) | 1 |
| 18 | DATE_PROBATION_END | CHARACTER VARYING(1) | 1 |
| 19 | DATE_OF_EXIT | CHARACTER VARYING(1) | 1 |
| 20 | REASON_OF_EXIT | CHARACTER VARYING(20) | 20 |
| 21 | HOME_ADDRESS | CHARACTER VARYING(400) | 400 |
| 22 | HOME_ZONE | CHARACTER VARYING(100) | 100 |
| 23 | HOME_POSTAL_CODE | CHARACTER VARYING(20) | 20 |
| 24 | HOME_CITY | CHARACTER VARYING(100) | 100 |
| 25 | HOME_PHONE_NUMBER | CHARACTER VARYING(30) | 30 |
| 26 | WORK_ADDRESS | CHARACTER VARYING(400) | 400 |
| 27 | WORK_ZONE | CHARACTER VARYING(100) | 100 |
| 28 | WORK_POSTAL_CODE | CHARACTER VARYING(20) | 20 |
| 29 | WORK_CITY | CHARACTER VARYING(100) | 100 |
| 30 | WORK_PHONE_NUMBER | CHARACTER VARYING(30) | 30 |
| 31 | MOBILE_PHONE_NUMBER | CHARACTER VARYING(30) | 30 |
| 32 | EMAIL_ADDRESS | CHARACTER VARYING(256) | 256 |
| 33 | DEPARTMENT_NAME | CHARACTER VARYING(100) | 100 |
| 34 | MANAGER_ID | CHARACTER VARYING(32) | 32 |
| 35 | TELLER_ID | CHARACTER VARYING(32) | 32 |
| 36 | ROLE_DESCRIPTION | CHARACTER VARYING(70) | 70 |
| 37 | COST_CENTRE_ID | CHARACTER VARYING(32) | 32 |
| 38 | PREVIOUS_EMPLOYER_NAME | CHARACTER VARYING(100) | 100 |
| 39 | EMPLOYEE_SEGMENT | CHARACTER VARYING(50) | 50 |
| 40 | FIRST_NAME | CHARACTER VARYING(150) | 150 |
| 41 | LAST_NAME | CHARACTER VARYING(100) | 100 |
| 42 | MIDDLE_INITIALS | CHARACTER VARYING(10) | 10 |