Untitled
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