Untitled

 avatar
unknown
plain_text
5 months ago
1.8 kB
2
Indexable
create or replace TABLE ALXN_ADP_DEV_DB.TRUSTED_PATIENT_IDENTIFIED.EMP_WRKFL_FACT (
	ROW_ID NUMBER(18,0),
	EMP_WRKFL_ID VARCHAR(32),
	WRKFL_ID VARCHAR(16777216),
	WRKFL_STEP_ID VARCHAR(16777216),
	WRKFL_STEP_ASSIGNEE_ID VARCHAR(16777216),
	WRKFL_STEP_XID VARCHAR(16777216),
	WRKFL_XID VARCHAR(16777216),
	ASSC_SRVY_ID VARCHAR(16777216),
	WRKFL_STEP_CTGY_SEQ NUMBER(38,0),
	WRKFL_STEP_SEQ NUMBER(38,0),
	WRKFL_RCD_TYP VARCHAR(16777216),
	WRKFL_TYP VARCHAR(16777216),
	WRKFL_ACTV_FLAG BOOLEAN,
	WRKFL_STEP_ACTR VARCHAR(16777216),
	CTGY_ICON VARCHAR(16777216),
	WRKFL_STEP_CTGY VARCHAR(16777216),
	INDC VARCHAR(16777216),
	WRKFL_NM VARCHAR(16777216),
	WRKFL_DSC VARCHAR(16777216),
	RLS_STRT_DT DATE,
	RLS_END_DT DATE,
	WRKFL_STEP_RCD_NM VARCHAR(16777216),
	WRKFL_STEP_NM VARCHAR(16777216),
	WRKFL_STEP_TYP VARCHAR(16777216),
	WRKFL_STEP_ASSIGNEE_TYP VARCHAR(16777216),
	WRKFL_STEP_DSC VARCHAR(16777216),
	WRKFL_STEP_REQD_FLAG BOOLEAN,
	WRKFL_STEP_REL_TO VARCHAR(16777216),
	DUE_DT_ADJ_BASE_DT VARCHAR(16777216),
	CR_EVNT_FLAG BOOLEAN,
	CR_TASK_FLAG BOOLEAN,
	CR_STAT_FLAG VARCHAR(16777216),
	ASSC_SRVY VARCHAR(16777216),
	ASSC_SRVY_VER VARCHAR(16777216),
	IMG_CTGY VARCHAR(16777216),
	CASE_TEAM_MBR_ROLE VARCHAR(16777216),
	RCPT_ROLE VARCHAR(16777216),
	TASK_HYPERLINK_FLAG BOOLEAN,
	TASK_IMG VARCHAR(16777216),
	OBJ_RCD_TYP_CR VARCHAR(16777216),
	RISK_SEG VARCHAR(16777216),
	FOLLOWUP_WRKFL_STEPS_FLAG BOOLEAN,
	GNR_EML_NTF_FLAG BOOLEAN,
	REDRCT_VISUALFORCE_PG_FLAG BOOLEAN,
	VISUALFORCE_PG_NM VARCHAR(16777216),
	DUE_DT_ADJ NUMBER(38,0),
	SRC_OWNR_ID VARCHAR(16777216),
	SRC_CR_DT TIMESTAMP_NTZ(9),
	SRC_CR_BY_ID VARCHAR(16777216),
	SRC_LASTMODIFIED_DT TIMESTAMP_NTZ(9),
	SRC_LASTMODIFIED_BY_ID VARCHAR(16777216),
	SRC_SYS_MOD_STMP TIMESTAMP_NTZ(9),
	RUN_ID NUMBER(38,0),
	LOAD_DT TIMESTAMP_LTZ(9),
	CRITICAL_FAILURE_FLAG VARCHAR(5)
);


Editor is loading...
Leave a Comment