EMPLIDADDRESS_TYPEFT_BYPASS_FLAGFT_EFF_START_DATEN=No
Y=Yes
FT_PER_ADDRESS(SQL Table) |
Index Back |
|---|---|
Person Address InformationPerson Address Information |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | ADDRESS_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | Address Type |
| 3 | FT_BYPASS_FLAG |
Character(1) | VARCHAR2(1) NOT NULL | Bypass Flag |
| 4 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 5 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 6 | FT_ADDR_USAGE_GUID | Character(36) | VARCHAR2(36) NOT NULL | Person Address Usuage ID |
| 7 | FT_EFF_START_DATE |
Date(10) | DATE | Effective Start Date |
| 8 | FT_EFF_END_DATE | Date(10) | DATE | Effective End Date |
| 9 | FT_PERSON_ID_GUID | Character(36) | VARCHAR2(36) NOT NULL | Person GUID |
| 10 | FT_BUS_GROUP_ID | Number(18,0) | DECIMAL(18) NOT NULL | Business Group ID |
| 11 | FT_BUS_GROUP_ID1 | Number(18,0) | DECIMAL(18) NOT NULL | Business Group ID |
| 12 | FT_ADDRESS_TYPE | Character(30) | VARCHAR2(30) NOT NULL | Person Addres Type |
| 13 | FT_ADDRESS_LINE_1 | Character(100) | VARCHAR2(100) NOT NULL | Address Line 1 |
| 14 | FT_ADDRESS_LINE_2 | Character(100) | VARCHAR2(100) NOT NULL | Address Line 2 |
| 15 | FT_ADDRESS_LINE_3 | Character(100) | VARCHAR2(100) NOT NULL | Address Line 3 |
| 16 | FT_ADDRESS_LINE_4 | Character(100) | VARCHAR2(100) NOT NULL | Address Line 4 |
| 17 | FT_BUILDING | Character(60) | VARCHAR2(60) NOT NULL | Building |
| 18 | FT_FLOOR_NUMBER | Character(40) | VARCHAR2(40) NOT NULL | Floor Number |
| 19 | FT_TOWN_OR_CITY | Character(30) | VARCHAR2(30) NOT NULL | Town or City |
| 20 | FT_REGION_1 | Character(120) | VARCHAR2(120) NOT NULL | Region 1 |
| 21 | FT_REGION_2 | Character(120) | VARCHAR2(120) NOT NULL | Region 2 |
| 22 | FT_REGION_3 | Character(120) | VARCHAR2(120) NOT NULL | Region 3 |
| 23 | FT_POSTAL_CODE | Character(30) | VARCHAR2(30) NOT NULL | Personal Address Postal Code |
| 24 | FT_LONG_POSTALCODE | Character(30) | VARCHAR2(30) NOT NULL | Persson Address Long Postal Code Information |
| 25 | FT_COUNTRY | Character(60) | VARCHAR2(60) NOT NULL | Country |
| 26 | FT_TIMEZONE_CODE | Character(50) | VARCHAR2(50) NOT NULL | Time Zone Code |
| 27 | FT_DERIVED_LOCALE | Character(240) | VARCHAR2(240) NOT NULL | Person Address Derived Locale |
| 28 | FT_DQ_VALIDATE_LVL | Number(1,0) | SMALLINT NOT NULL | Person Address DQ Validation Level Information |
| 29 | FT_SINGLE_LINE_ADR | Long Character(2000) | VARCHAR2(2000) | Formatted Single Line Address |
| 30 | FT_MULTI_LINE_ADDR | Long Character(2000) | VARCHAR2(2000) | Formatted Multi-line Address |
| 31 | FT_MAILING_ADD_FLG | Character(30) | VARCHAR2(30) NOT NULL | Mailing Address Flag |
| 32 | FT_ATTR_CATEGORY | Character(30) | VARCHAR2(30) NOT NULL | Attribute Category |
| 33 | FT_ATTRIBUTE1 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 34 | FT_ATTRIBUTE2 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 35 | FT_ATTRIBUTE3 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 36 | FT_ATTRIBUTE4 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 37 | FT_ATTRIBUTE5 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 38 | FT_ATTRIBUTE6 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 39 | FT_ATTRIBUTE7 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 40 | FT_ATTRIBUTE8 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 41 | FT_ATTRIBUTE9 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 42 | FT_ATTRIBUTE10 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 43 | FT_ATTRIBUTE11 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 44 | FT_ATTRIBUTE12 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 45 | FT_ATTRIBUTE13 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 46 | FT_ATTRIBUTE14 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 47 | FT_ATTRIBUTE15 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 48 | FT_ATTRIBUTE16 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 49 | FT_ATTRIBUTE17 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 50 | FT_ATTRIBUTE18 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 51 | FT_ATTRIBUTE19 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 52 | FT_ATTRIBUTE20 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 53 | FT_ATTRIBUTE21 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 54 | FT_ATTRIBUTE22 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 55 | FT_ATTRIBUTE23 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 56 | FT_ATTRIBUTE24 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 57 | FT_ATTRIBUTE25 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 58 | FT_ATTRIBUTE26 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 59 | FT_ATTRIBUTE27 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 60 | FT_ATTRIBUTE28 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 61 | FT_ATTRIBUTE29 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 62 | FT_ATTRIBUTE30 | Character(1) | VARCHAR2(1) NOT NULL | Attribute |
| 63 | FT_ADDR_ATTR_CAT | Character(30) | VARCHAR2(30) NOT NULL | Person Address Attribute Category |
| 64 | FT_ADDR_ATTRIB_1 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 65 | FT_ADDR_ATTRIB_2 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 66 | FT_ADDR_ATTRIB_3 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 67 | FT_ADDR_ATTRIB_4 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 68 | FT_ADDR_ATTRIB_5 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 69 | FT_ADDR_ATTRIB_6 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 70 | FT_ADDR_ATTRIB_7 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 71 | FT_ADDR_ATTRIB_8 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 72 | FT_ADDR_ATTRIB_9 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 73 | FT_ADDR_ATTRIB_10 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 74 | FT_ADDR_ATTRIB_11 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 75 | FT_ADDR_ATTRIB_12 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 76 | FT_ADDR_ATTRIB_13 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 77 | FT_ADDR_ATTRIB_14 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 78 | FT_ADDR_ATTRIB_15 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 79 | FT_ADDR_ATTRIB_16 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 80 | FT_ADDR_ATTRIB_17 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 81 | FT_ADDR_ATTRIB_18 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 82 | FT_ADDR_ATTRIB_19 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 83 | FT_ADDR_ATTRIB_20 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 84 | FT_ADDR_ATTRIB_21 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 85 | FT_ADDR_ATTRIB_22 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 86 | FT_ADDR_ATTRIB_23 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 87 | FT_ADDR_ATTRIB_24 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 88 | FT_ADDR_ATTRIB_25 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 89 | FT_ADDR_ATTRIB_26 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 90 | FT_ADDR_ATTRIB_27 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 91 | FT_ADDR_ATTRIB_28 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 92 | FT_ADDR_ATTRIB_29 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 93 | FT_ADDR_ATTRIB_30 | Character(1) | VARCHAR2(1) NOT NULL | Address Attribute |
| 94 | FT_ADDL_ADDR_ATTB1 | Character(150) | VARCHAR2(150) NOT NULL | Additional Address Attribute |
| 95 | FT_ADDL_ADDR_ATTB2 | Character(150) | VARCHAR2(150) NOT NULL | Additional Address Attribute |
| 96 | FT_ADDL_ADDR_ATTB3 | Character(150) | VARCHAR2(150) NOT NULL | Additional Address Attribute |
| 97 | FT_ADDL_ADDR_ATTB4 | Character(150) | VARCHAR2(150) NOT NULL | Additional Address Attribute |
| 98 | FT_ADDL_ADDR_ATTB5 | Character(150) | VARCHAR2(150) NOT NULL | Additional Address Attribute |
| 99 | FT_PROC_MARKER | Character(36) | VARCHAR2(36) NOT NULL | Process marker field |
| 100 | FT_ERROR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Error Flag
N=No Y=Yes |
| 101 | FT_ALTERNATE_REC | Character(50) | VARCHAR2(50) NOT NULL | Source Record |
| 102 | FT_ALTERNATE_KEY | Character(254) | VARCHAR2(254) NOT NULL | Alternate Key |