HZ_IMP_RESOURCES_GT
Global Temporary Table to store temporary values during employee resource import.
Details
-
Schema: FUSION
-
Object owner: FUSION
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| PERSON_ID | NUMBER | 18 | PERSON_ID | |
| EMPLOYEE_NUMBER | VARCHAR2 | 30 | EMPLOYEE_NUMBER | |
| HIRE_DATE | DATE | HIRE_DATE | ||
| DATE_OF_BIRTH | DATE | DATE_OF_BIRTH | ||
| WORKER_TYPE | VARCHAR2 | 30 | WORKER_TYPE | |
| LEGAL_ENTITY_ID | NUMBER | 18 | LEGAL_ENTITY_ID | |
| TERMINATION_DATE | DATE | TERMINATION_DATE | ||
| FIRST_NAME | VARCHAR2 | 150 | FIRST_NAME | |
| LAST_NAME | VARCHAR2 | 150 | LAST_NAME | |
| MIDDLE_NAME | VARCHAR2 | 80 | MIDDLE_NAME | |
| SUFFIX | VARCHAR2 | 80 | SUFFIX | |
| KNOWN_AS | VARCHAR2 | 80 | KNOWN_AS | |
| HONORS | VARCHAR2 | 80 | HONORS | |
| PERSON_LAST_NAME_PREFIX | VARCHAR2 | 150 | PERSON_LAST_NAME_PREFIX | |
| PERSON_TITLE | VARCHAR2 | 30 | PERSON_TITLE | |
| PERSON_NAME_ID | NUMBER | 18 | PERSON_NAME_ID | |
| WORK_PH_NUMBER | VARCHAR2 | 60 | WORK_PH_NUMBER | |
| WORK_PH_DATE_FROM | DATE | WORK_PH_DATE_FROM | ||
| WORK_PH_DATE_TO | DATE | WORK_PH_DATE_TO | ||
| WORK_PH_EXTN_NUMBER | VARCHAR2 | 60 | WORK_PH_EXTN_NUMBER | |
| WORK_PH_AREA_CODE | VARCHAR2 | 30 | WORK_PH_AREA_CODE | |
| WORK_PH_CNTRY_CODE | VARCHAR2 | 30 | WORK_PH_CNTRY_CODE | |
| WORK_PH_ID | NUMBER | 18 | WORK_PH_ID | |
| MOBILE_NUMBER | VARCHAR2 | 60 | MOBILE_NUMBER | |
| MOBILE_DATE_FROM | DATE | MOBILE_DATE_FROM | ||
| MOBILE_DATE_TO | DATE | MOBILE_DATE_TO | ||
| MOBILE_PH_AREA_CODE | VARCHAR2 | 30 | MOBILE_PH_AREA_CODE | |
| MOBILE_PH_CNTRY_CODE | VARCHAR2 | 30 | MOBILE_PH_CNTRY_CODE | |
| MOBILE_PH_ID | NUMBER | 18 | MOBILE_PH_ID | |
| FAX_NUMBER | VARCHAR2 | 60 | FAX_NUMBER | |
| FAX_DATE_FROM | DATE | FAX_DATE_FROM | ||
| FAX_DATE_TO | DATE | FAX_DATE_TO | ||
| FAX_AREA_CODE | VARCHAR2 | 30 | FAX_AREA_CODE | |
| FAX_CNTRY_CODE | VARCHAR2 | 30 | FAX_CNTRY_CODE | |
| FAX_ID | NUMBER | 18 | FAX_ID | |
| EMAIL_ADDRESS | VARCHAR2 | 240 | EMAIL_ADDRESS | |
| EMAIL_DATE_FROM | DATE | EMAIL_DATE_FROM | ||
| EMAIL_DATE_TO | DATE | EMAIL_DATE_TO | ||
| EMAIL_ADDRESS_ID | NUMBER | 18 | EMAIL_ADDRESS_ID | |
| DEPARTMENT_NAME | VARCHAR2 | 240 | DEPARTMENT_NAME | |
| JOB_CODE | VARCHAR2 | 30 | JOB_CODE | |
| FLOOR_NUMBER | VARCHAR2 | 45 | FLOOR_NUMBER | |
| MAIL_STOP | VARCHAR2 | 45 | MAIL_STOP | |
| DEPARTMENT_ID | NUMBER | 18 | DEPARTMENT_ID | |
| JOB_ID | NUMBER | 18 | JOB_ID | |
| BUSINESS_UNIT_ID | NUMBER | 18 | BUSINESS_UNIT_ID | |
| LOCATION_ID | NUMBER | 18 | LOCATION_ID | |
| MANAGER_ID | NUMBER | 18 | MANAGER_ID | |
| MANAGER_EMAIL_ADDRESS | VARCHAR2 | 240 | MANAGER_EMAIL_ADDRESS | |
| MANAGER_EMP_NUMBER | VARCHAR2 | 30 | MANAGER_EMP_NUMBER | |
| USER_GUID | VARCHAR2 | 64 | USER_GUID | |
| USERNAME | VARCHAR2 | 100 | USERNAME | |
| IMP_RES_INT_ROWID | NUMBER | 18 | IMP_RES_INT_ROWID | |
| IMP_RES_EMAIL_ADDRESS | VARCHAR2 | 320 | IMP_RES_EMAIL_ADDRESS | |
| IMP_RESMGR_EMAIL_ADDR | VARCHAR2 | 240 | IMP_RESMGR_EMAIL_ADDR | |
| IMP_RES_START_DATE_ACTIVE | DATE | IMP_RES_START_DATE_ACTIVE | ||
| IMP_RES_USER_GUID | VARCHAR2 | 64 | IMP_RES_USER_GUID | |
| IMP_RES_JOB_CODE | VARCHAR2 | 30 | IMP_RES_JOB_CODE | |
| IMP_RES_ROLE_CODE | VARCHAR2 | 30 | IMP_RES_ROLE_CODE | |
| IMP_RES_ROLE_TYPE_CODE | VARCHAR2 | 240 | IMP_RES_ROLE_TYPE_CODE | |
| IMP_RES_ROLE_ID | NUMBER | 18 | IMP_RES_ROLE_ID | |
| RES_TEAM_MEM_EMAIL_ADDR | VARCHAR2 | 320 | RES_TEAM_MEM_EMAIL_ADDR | |
| RES_TEAM_INT_ROW_ID | NUMBER | 18 | RES_TEAM_INT_ROW_ID | |
| RES_ORG_MEM_EMAIL_ADDR | VARCHAR2 | 320 | RES_ORG_MEM_EMAIL_ADDR | |
| RES_ORG_MEM_START_DT_ACTIVE | DATE | RES_ORG_MEM_START_DT_ACTIVE | ||
| RES_ORG_ROLE_ID | NUMBER | 18 | RES_ORG_ROLE_ID | |
| RES_ORG_IS_MGR_ROLE | VARCHAR2 | 1 | RES_ORG_IS_MGR_ROLE | |
| RES_ORG_ROLE_CODE | VARCHAR2 | 30 | RES_ORG_ROLE_CODE | |
| RES_ORG_ROLE_TYPE_CODE | VARCHAR2 | 240 | RES_ORG_ROLE_TYPE_CODE | |
| RES_ORG_ORG_ID | NUMBER | 18 | RES_ORG_ORG_ID | |
| RES_ORG_ORG_NAME | VARCHAR2 | 240 | RES_ORG_ORG_NAME | |
| RES_ORG_PARENT_ORG_NAME | VARCHAR2 | 240 | RES_ORG_PARENT_ORG_NAME | |
| RES_GRP_MGR_EMAIL_ADDRESS | VARCHAR2 | 320 | RESGRPMGREMAILADDRES | |
| RES_ORG_MGR_ORIG_SYS_REF | VARCHAR2 | 240 | RES_ORG_MGR_ORIG_SYS_REF | |
| RES_ORG_ORG_USAGE | VARCHAR2 | 40 | RES_ORG_ORG_USAGE | |
| RES_ORG_ADD_TO_MGR_ORG_FLAG | VARCHAR2 | 1 | RES_ORG_ADD_TO_MGR_ORG_FLAG | |
| RES_ORG_INT_ROWID | NUMBER | 18 | RES_ORG_INT_ROWID | |
| RES_ROLE_ID | NUMBER | 18 | RES_ROLE_ID | |
| RES_ROLE_CODE | VARCHAR2 | 30 | RES_ROLE_CODE | |
| RES_ROLE_TYPE_CODE | VARCHAR2 | 240 | RES_ROLE_TYPE_CODE | |
| MANAGER_FLAG | VARCHAR2 | 1 | MANAGER_FLAG | |
| ADDTNL_PARTY_NAME_T_ID | NUMBER | 18 | ADDTNL_PARTY_NAME_T_ID | |
| MOBILE_CONTACT_ID | NUMBER | 18 | MOBILE_CONTACT_ID | |
| EMAIL_CONTACT_ID | NUMBER | 18 | EMAIL_CONTACT_ID | |
| FAX_CONTACT_ID | NUMBER | 18 | FAX_CONTACT_ID | |
| PARTY_INT_UNIQUE_ID | NUMBER | 18 | PARTY_INT_UNIQUE_ID | |
| BATCH_ID | NUMBER | BATCH_ID | ||
| FILE_RECORD_NUM | NUMBER | 18 | FILE_RECORD_NUM | |
| START_DATE | DATE | START_DATE | ||
| ASSIGNMENT_ID | NUMBER | 20 | ASSIGNMENT_ID | |
| ASS_EFF_START_DATE | DATE | ASS_EFF_START_DATE | ||
| ASS_EFF_END_DATE | DATE | ASS_EFF_END_DATE | ||
| USER_FLAG | VARCHAR2 | 1 | USER_FLAG | |
| SEND_CREDENTIALS_EMAIL | VARCHAR2 | 240 | SEND_CREDENTIALS_EMAIL | |
| ROLE_CODE_01 | VARCHAR2 | 30 | ROLE_CODE_01 | |
| ROLE_CODE_02 | VARCHAR2 | 30 | ROLE_CODE_02 | |
| PROVISION_IN_SYNC_FLAG | VARCHAR2 | 1 | PROVISION_IN_SYNC_FLAG | |
| PARTY_ID | NUMBER | 18 | PARTY_ID | |
| PARTY_ORIG_SYS_01 | VARCHAR2 | 30 | PARTY_ORIG_SYS_01 | |
| PARTY_ORIG_SYS_REF_01 | VARCHAR2 | 240 | PARTY_ORIG_SYS_REF_01 | |
| PARTY_ORIG_SYS_02 | VARCHAR2 | 30 | PARTY_ORIG_SYS_02 | |
| PARTY_ORIG_SYS_REF_02 | VARCHAR2 | 240 | PARTY_ORIG_SYS_REF_02 | |
| ADDRESS1 | VARCHAR2 | 240 | First line for address | |
| ADDRESS2 | VARCHAR2 | 240 | Second line for address | |
| ADDRESS3 | VARCHAR2 | 240 | Third line for address | |
| ADDRESS4 | VARCHAR2 | 240 | Fourth line for address | |
| COUNTY | VARCHAR2 | 120 | Assignment location county/region value from HCM | |
| PROVINCE | VARCHAR2 | 120 | Assignment location province value from HCM | |
| ADDR_ELEMENT_ATTRIBUTE1 | VARCHAR2 | 150 | Additional address element to support flexible address format | |
| ADDR_ELEMENT_ATTRIBUTE2 | VARCHAR2 | 150 | Additional address element to support flexible address format | |
| ADDR_ELEMENT_ATTRIBUTE3 | VARCHAR2 | 150 | Additional address element to support flexible address format | |
| ADDR_ELEMENT_ATTRIBUTE4 | VARCHAR2 | 150 | Additional address element to support flexible address format | |
| ADDR_ELEMENT_ATTRIBUTE5 | VARCHAR2 | 150 | Additional address element to support flexible address format | |
| POSTAL_CODE | VARCHAR2 | 60 | POSTAL_CODE | |
| CITY | VARCHAR2 | 60 | CITY | |
| STATE | VARCHAR2 | 60 | STATE | |
| COUNTRY | VARCHAR2 | 2 | COUNTRY | |
| LOCATION_NAME | VARCHAR2 | 240 | LOCATION_NAME | |
| BUILDING | VARCHAR2 | 240 | BUILDING |