SETIDDefault Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SET_VLD_HR_03
LOCATIONFT_EFF_START_DATEN=No
Y=Yes
Y/N Table Edit
Default Value: N
N=No
Y=Yes
Default Value: N
Default Value: N
FT_LOCATIONVO(SQL Table) |
Index Back |
|---|---|
Locations VO staging tableFTM - Locations VO staging table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SET_VLD_HR_03 |
| 2 | LOCATION |
Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 3 | FT_LOCATION_GUID | Character(36) | VARCHAR2(36) NOT NULL | Location GUID |
| 4 | FT_EFF_START_DATE |
Date(10) | DATE | Effective Start Date |
| 5 | FT_EFF_END_DATE | Date(10) | DATE | Effective End Date |
| 6 | FT_SET_ID_GUID | Character(36) | VARCHAR2(36) NOT NULL | Set ID GUID |
| 7 | FT_BUS_GROUP_GUID | Character(36) | VARCHAR2(36) NOT NULL | Business Group ID |
| 8 | FT_LOCAT_IMAGE_URL | Character(1) | VARCHAR2(1) NOT NULL | Location Image URL |
| 9 | FT_ADDR_USAGE_TYPE | Character(50) | VARCHAR2(50) NOT NULL | Address usage type |
| 10 | FT_ACTIVE_STATUS | Character(30) | VARCHAR2(30) NOT NULL | Active Status |
| 11 | FT_PHONE_NUMBER_1 | Character(60) | VARCHAR2(60) NOT NULL | Telephone Number 1 |
| 12 | FT_PHONE_NUMBER_2 | Character(60) | VARCHAR2(60) NOT NULL | Telephone Number 2 |
| 13 | FT_PHONE_NUMBER_3 | Character(60) | VARCHAR2(60) NOT NULL | Telephone Number 3 |
| 14 | FT_PHONE_AREA_1 | Character(60) | VARCHAR2(60) NOT NULL | Main Phone Area Code |
| 15 | FT_PHONE_COUNTRY_1 | Character(30) | VARCHAR2(30) NOT NULL | Main Phone Country Code |
| 16 | FT_PHONE_EXT_1 | Character(60) | VARCHAR2(60) NOT NULL | Main Phone Extension |
| 17 | FT_PHONE_SUBSCR_1 | Character(60) | VARCHAR2(60) NOT NULL | Main Phone Subscriber 1 |
| 18 | FT_PHONE_AREA_2 | Character(60) | VARCHAR2(60) NOT NULL | Phone Area Code 2 |
| 19 | FT_PHONE_COUNTRY_2 | Character(30) | VARCHAR2(30) NOT NULL | Phone Country Code 2 |
| 20 | FT_PHONE_EXT_2 | Character(60) | VARCHAR2(60) NOT NULL | Phone Extension 2 |
| 21 | FT_PHONE_SUBSCR_2 | Character(60) | VARCHAR2(60) NOT NULL | Phone Subscriber 2 |
| 22 | FT_PHONE_AREA_3 | Character(60) | VARCHAR2(60) NOT NULL | Phone Area Code 3 |
| 23 | FT_PHONE_COUNTRY_3 | Character(30) | VARCHAR2(30) NOT NULL | Phone Country Code 3 |
| 24 | FT_PHONE_EXT_3 | Character(60) | VARCHAR2(60) NOT NULL | Phone Extension 3 |
| 25 | FT_PHONE_SUBSCR_3 | Character(60) | VARCHAR2(60) NOT NULL | Phone Subscriber 3 |
| 26 | FT_OFFICIAL_LNG_CD | Character(30) | VARCHAR2(30) NOT NULL | Official Language Code |
| 27 | FT_EMAIL_ADDRESS | Character(100) | VARCHAR2(100) NOT NULL | Email Address |
| 28 | FT_SHIPTO_SITE_FLG | Character(30) | VARCHAR2(30) NOT NULL | Ship to Site Flag |
| 29 | FT_SHIPTO_LOC_GUID | Character(36) | VARCHAR2(36) NOT NULL | Ship to Location Id |
| 30 | FT_RECEIV_SITE_FLG | Character(30) | VARCHAR2(30) NOT NULL | Receiving Site Flag |
| 31 | FT_BILLTO_SITE_FLG | Character(30) | VARCHAR2(30) NOT NULL | Bill to Site Flag |
| 32 | FT_OFFICE_SITE_FLG | Character(30) | VARCHAR2(30) NOT NULL | Office Site Flag |
| 33 | FT_RECEIVER_GUID | Character(36) | VARCHAR2(36) NOT NULL | Designated Receiver Id |
| 34 | FT_INVENTORY_GUID | Character(36) | VARCHAR2(36) NOT NULL | Inventory Organization Id |
| 35 | FT_GEO_NODE_GUID | Character(32) | VARCHAR2(32) NOT NULL | Geo Hierarchy Node Id |
| 36 | FT_GEO_NODE_VALUE | Character(100) | VARCHAR2(100) NOT NULL | Geo Hierarchy Node Value |
| 37 | FT_INT_LOCAT_CODE | Character(60) | VARCHAR2(60) NOT NULL | Internal Location Code |
| 38 | FT_LOCATION_CODE1 | Character(50) | VARCHAR2(50) NOT NULL | Location Code |
| 39 | FT_LOCATION_NAME | Character(100) | VARCHAR2(100) NOT NULL | Location Name |
| 40 | FT_DESCRIPTION | Character(240) | VARCHAR2(240) NOT NULL | Description |
| 41 | FT_AC_LOCAT_CODE | Character(60) | VARCHAR2(60) NOT NULL | AC Location Code |
| 42 | FT_ADDRESS_LINE_1 | Character(100) | VARCHAR2(100) NOT NULL | Address Line 1 |
| 43 | FT_ADDRESS_LINE_2 | Character(100) | VARCHAR2(100) NOT NULL | Address Line 2 |
| 44 | FT_ADDRESS_LINE_3 | Character(100) | VARCHAR2(100) NOT NULL | Address Line 3 |
| 45 | FT_ADDRESS_LINE_4 | Character(100) | VARCHAR2(100) NOT NULL | Address Line 4 |
| 46 | FT_BUILDING | Character(60) | VARCHAR2(60) NOT NULL | Building |
| 47 | FT_COUNTRY | Character(60) | VARCHAR2(60) NOT NULL | Country |
| 48 | FT_FLOOR_NUMBER | Character(40) | VARCHAR2(40) NOT NULL | Floor Number |
| 49 | FT_LONG_ZIP_CODE | Character(30) | VARCHAR2(30) NOT NULL | Long Postal Code |
| 50 | FT_ZIP_CODE | Character(30) | VARCHAR2(30) NOT NULL | Postal Code |
| 51 | FT_REGION_1 | Character(120) | VARCHAR2(120) NOT NULL | Region 1 |
| 52 | FT_REGION_2 | Character(120) | VARCHAR2(120) NOT NULL | Region 2 |
| 53 | FT_REGION_3 | Character(120) | VARCHAR2(120) NOT NULL | Region 3 |
| 54 | FT_TIMEZONE_CODE | Character(50) | VARCHAR2(50) NOT NULL | Time Zone Code |
| 55 | FT_TOWN_OR_CITY | Character(30) | VARCHAR2(30) NOT NULL | Town or City |
| 56 | FT_BUS_GROUP1_GUID | Character(36) | VARCHAR2(36) NOT NULL | Business Group 1 GUID |
| 57 | EOTF_IMPORT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Import Value Map
N=No Y=Yes Y/N Table Edit Default Value: N |
| 58 | FT_PROC_MARKER | Character(36) | VARCHAR2(36) NOT NULL | Process marker field |
| 59 | FT_ERROR_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Error Flag
N=No Y=Yes Default Value: N |
| 60 | FT_BYPASS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Bypass Flag
Default Value: N |
| 61 | FT_ALTERNATE_REC | Character(50) | VARCHAR2(50) NOT NULL | Source Record |
| 62 | FT_ALTERNATE_KEY | Character(254) | VARCHAR2(254) NOT NULL | Alternate Key |