🏠 Menú principal

← Volver a tablas

---

SIMACMOBILE.MAESTRO_EMPLEADO_SUCURSAL_CSV

Base de datos origen: ORCLSMM

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	W_PERSONA_ID	VARCHAR2(100)	SI
2	W_ORGANIZATION_ID	VARCHAR2(100)	SI
3	W_LEGAL_ENTITY_ID	VARCHAR2(100)	SI
4	W_LEGAL_EMPLOYEER	VARCHAR2(100)	SI
5	W_PERSON_NUMBER	VARCHAR2(100)	SI
6	PN_F_LAST_NAME	VARCHAR2(100)	SI
7	PN_M_LAST_NAME	VARCHAR2(100)	SI
8	PN_FIRST_NAME	VARCHAR2(100)	SI
9	PN_MIDDLE_NAMES	VARCHAR2(100)	SI
10	PEM_EMAIL_TYPE	VARCHAR2(100)	SI
11	PEM_EMAIL_ADDRESS	VARCHAR2(100)	SI
12	WT_PERSON_TYPE	VARCHAR2(100)	SI
13	WT_EMPLOYEER	VARCHAR2(100)	SI
14	AS_STATUS_TYPE	VARCHAR2(100)	SI
15	AS_BUSINESS_UNIT	VARCHAR2(100)	SI
16	AS_DEFAULT_EXP_SEGMENT1	VARCHAR2(100)	SI
17	AS_DEFAULT_EXP_SEGMENT2	VARCHAR2(100)	SI
18	AS_DEFAULT_EXP_SEGMENT3	VARCHAR2(100)	SI
19	AS_DEFAULT_EXP_SEGMENT4	VARCHAR2(100)	SI
20	AS_DEFAULT_EXP_SEGMENT5	VARCHAR2(100)	SI
21	AS_DEFAULT_EXP_SEGMENT6	VARCHAR2(100)	SI
22	AS_DEFAULT_EXP_SEGMENT7	VARCHAR2(100)	SI
23	AS_DEFAULT_EXP_SEGMENT8	VARCHAR2(100)	SI
24	AS_DEFAULT_EXP_SEGMENT9	VARCHAR2(100)	SI
25	AS_LEGISLATION_CODE	VARCHAR2(100)	SI
26	AS_ASSIGNMENT_ID	VARCHAR2(100)	SI
27	HZP_PARTY_ID	VARCHAR2(100)	SI
28	HZP_PARTY_NAME	VARCHAR2(100)	SI
29	PU_USER_ID	VARCHAR2(100)	SI
30	PU_USERNAME	VARCHAR2(100)	SI
31	PU_ACTIVE_FLAG	VARCHAR2(100)	SI
32	MANAGER_FULL_NAME	VARCHAR2(100)	SI
33	AS_DEFAULT_EXP_SEGMENT10	VARCHAR2(10)	SI
34	AS_DEFAULT_EXP_SEGMENT11	VARCHAR2(10)	SI
35	AS_DEFAULT_EXP_SEGMENT12	VARCHAR2(10)	SI

Restricciones

Sin restricciones visibles (P/R/U/C).

DDL

CREATE TABLE "SIMACMOBILE"."MAESTRO_EMPLEADO_SUCURSAL_CSV" 
   (	"W_PERSONA_ID" VARCHAR2(100), 
	"W_ORGANIZATION_ID" VARCHAR2(100), 
	"W_LEGAL_ENTITY_ID" VARCHAR2(100), 
	"W_LEGAL_EMPLOYEER" VARCHAR2(100), 
	"W_PERSON_NUMBER" VARCHAR2(100), 
	"PN_F_LAST_NAME" VARCHAR2(100), 
	"PN_M_LAST_NAME" VARCHAR2(100), 
	"PN_FIRST_NAME" VARCHAR2(100), 
	"PN_MIDDLE_NAMES" VARCHAR2(100), 
	"PEM_EMAIL_TYPE" VARCHAR2(100), 
	"PEM_EMAIL_ADDRESS" VARCHAR2(100), 
	"WT_PERSON_TYPE" VARCHAR2(100), 
	"WT_EMPLOYEER" VARCHAR2(100), 
	"AS_STATUS_TYPE" VARCHAR2(100), 
	"AS_BUSINESS_UNIT" VARCHAR2(100), 
	"AS_DEFAULT_EXP_SEGMENT1" VARCHAR2(100), 
	"AS_DEFAULT_EXP_SEGMENT2" VARCHAR2(100), 
	"AS_DEFAULT_EXP_SEGMENT3" VARCHAR2(100), 
	"AS_DEFAULT_EXP_SEGMENT4" VARCHAR2(100), 
	"AS_DEFAULT_EXP_SEGMENT5" VARCHAR2(100), 
	"AS_DEFAULT_EXP_SEGMENT6" VARCHAR2(100), 
	"AS_DEFAULT_EXP_SEGMENT7" VARCHAR2(100), 
	"AS_DEFAULT_EXP_SEGMENT8" VARCHAR2(100), 
	"AS_DEFAULT_EXP_SEGMENT9" VARCHAR2(100), 
	"AS_LEGISLATION_CODE" VARCHAR2(100), 
	"AS_ASSIGNMENT_ID" VARCHAR2(100), 
	"HZP_PARTY_ID" VARCHAR2(100), 
	"HZP_PARTY_NAME" VARCHAR2(100), 
	"PU_USER_ID" VARCHAR2(100), 
	"PU_USERNAME" VARCHAR2(100), 
	"PU_ACTIVE_FLAG" VARCHAR2(100), 
	"MANAGER_FULL_NAME" VARCHAR2(100), 
	"AS_DEFAULT_EXP_SEGMENT10" VARCHAR2(10), 
	"AS_DEFAULT_EXP_SEGMENT11" VARCHAR2(10), 
	"AS_DEFAULT_EXP_SEGMENT12" VARCHAR2(10)
   ) 
   ORGANIZATION EXTERNAL 
    ( TYPE ORACLE_LOADER
      DEFAULT DIRECTORY "DIR_ARCHIVOS_TMP_EMPLEADO_SUCURSAL"
      ACCESS PARAMETERS
      ( records delimited BY newline
CHARACTERSET 'UTF8'
FIELDS TERMINATED BY '|')
      LOCATION
       ( 'MaestroEmpleadoSucursal.csv'
       )
    )
   REJECT LIMIT UNLIMITED ;

GRANT SELECT ON "SIMACMOBILE"."MAESTRO_EMPLEADO_SUCURSAL_CSV" TO "ROL_SELECT";
  GRANT SELECT ON "SIMACMOBILE"."MAESTRO_EMPLEADO_SUCURSAL_CSV" TO "CONSULTA";

---

← Volver a tablas de SIMACMOBILE

🏠 Volver al menú principal