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_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 | ADDRESS1 | |
ADDRESS2 | VARCHAR2 | 240 | ADDRESS2 | |
ADDRESS3 | VARCHAR2 | 240 | ADDRESS3 | |
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 |